# HG changeset patch
# User jbe
# Date 1330178967 -3600
# Node ID 4e3d8f1ca3a9475e85af5f5002222e1d07d2ca18
# Parent  cd0a8fd2059de0f4141568e055f6de6f3916a507
Re-added "session" table to the core

diff -r cd0a8fd2059d -r 4e3d8f1ca3a9 core.sql
--- a/core.sql	Wed Feb 22 21:41:48 2012 +0100
+++ b/core.sql	Sat Feb 25 15:09:27 2012 +0100
@@ -302,6 +302,22 @@
 COMMENT ON COLUMN "ignored_member"."other_member_id" IS 'Member being ignored';
 
 
+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 or API layer';
+
+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';
+
+
 CREATE TABLE "policy" (
         "id"                    SERIAL4         PRIMARY KEY,
         "index"                 INT4            NOT NULL,