summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
author3dB <3db@3decibels.net>2009-07-27 20:17:58 -0400
committer3dB <3db@3decibels.net>2009-07-27 20:17:58 -0400
commitb0eb9d6fa3d3d11e4218f98cb78d13acc8cf962d (patch)
treef2b02d2a857c4e7c4751758528ae5008bbd358af /util
parenta1fc2a9a103e0f426ac4e496200408a2deccaaf0 (diff)
Applied small adjustments and reorganized DB library code.
-- Removed "ON UPDATE" from sessions.uid column FK -- Fixed dbSessionCheck to work as described -- Merged DB/Sessions.pm into DB/Users.pm
Diffstat (limited to 'util')
-rw-r--r--util/updates/update_2.6.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index 6d38c8b8..444d81c9 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 UPDATE CASCADE ON DELETE CASCADE,
+ uid integer NOT NULL REFERENCES users(id) ON DELETE CASCADE,
token character(40) NOT NULL,
expiration bigint DEFAULT 0 NOT NULL,
PRIMARY KEY (uid, token)