# HG changeset patch
# User bsw
# Date 1328632027 -3600
# Node ID 4c0bff8141ee12e904aad04b3e757dcafd33d5bf
# Parent  878526479494db5a23a0cd98b3c5d21aef68f5a2
Add session table creation script

diff -r 878526479494 -r 4c0bff8141ee db/session.lua
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/db/session.lua	Tue Feb 07 17:27:07 2012 +0100
@@ -0,0 +1,15 @@
+CREATE TABLE "session" (
+        "ident"                 TEXT            PRIMARY KEY,
+        "additional_secret"     TEXT,
+        "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
+        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
+        "lang"                  TEXT );
+CREATE INDEX "session_expiry_idx" ON "session" ("expiry");
+
+COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend';
+
+COMMENT ON COLUMN "session"."ident"             IS 'Secret session identifier (i.e. random string)';
+COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';
+COMMENT ON COLUMN "session"."member_id"         IS 'Reference to member, who is logged in';
+COMMENT ON COLUMN "session"."lang"              IS 'Language code of the selected language';
+