Multiple bugfixes to authorization system & sql tweaks

This commit is tested to work.

1 files changed, 2 insertions, 2 deletions

diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index 444d81c9..e631039e 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -2,7 +2,7 @@
 -- Create table for session data storage
 
 CREATE TABLE sessions (
-    uid integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
+    uid integer NOT NULL REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED;
     token character(40) NOT NULL,
     expiration bigint DEFAULT 0 NOT NULL,
     PRIMARY KEY (uid, token)
@@ -10,5 +10,5 @@ CREATE TABLE sessions (
 
 -- Add column to users for salt storage
 
-ALTER TABLE users ADD COLUMN salt character(9) NOT NULL DEFAULT 0;
+ALTER TABLE users ADD COLUMN salt character(9) NOT NULL DEFAULT '';