liquid_feedback_core

changeset 220:4e3d8f1ca3a9

Re-added "session" table to the core
author jbe
date Sat Feb 25 15:09:27 2012 +0100 (2012-02-25)
parents cd0a8fd2059d
children 4a7ae2507515
files core.sql
line diff
     1.1 --- a/core.sql	Wed Feb 22 21:41:48 2012 +0100
     1.2 +++ b/core.sql	Sat Feb 25 15:09:27 2012 +0100
     1.3 @@ -302,6 +302,22 @@
     1.4  COMMENT ON COLUMN "ignored_member"."other_member_id" IS 'Member being ignored';
     1.5  
     1.6  
     1.7 +CREATE TABLE "session" (
     1.8 +        "ident"                 TEXT            PRIMARY KEY,
     1.9 +        "additional_secret"     TEXT,
    1.10 +        "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
    1.11 +        "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
    1.12 +        "lang"                  TEXT );
    1.13 +CREATE INDEX "session_expiry_idx" ON "session" ("expiry");
    1.14 +
    1.15 +COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend or API layer';
    1.16 +
    1.17 +COMMENT ON COLUMN "session"."ident"             IS 'Secret session identifier (i.e. random string)';
    1.18 +COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';
    1.19 +COMMENT ON COLUMN "session"."member_id"         IS 'Reference to member, who is logged in';
    1.20 +COMMENT ON COLUMN "session"."lang"              IS 'Language code of the selected language';
    1.21 +
    1.22 +
    1.23  CREATE TABLE "policy" (
    1.24          "id"                    SERIAL4         PRIMARY KEY,
    1.25          "index"                 INT4            NOT NULL,

Impressum / About Us