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,