1 CREATE TABLE "session" (

2 "ident" TEXT PRIMARY KEY,

3 "additional_secret" TEXT,

4 "expiry" TIMESTAMPTZ NOT NULL DEFAULT now() + '24 hours',

5 "member_id" INT8 REFERENCES "member" ("id") ON DELETE SET NULL,

6 "lang" TEXT );

7 CREATE INDEX "session_expiry_idx" ON "session" ("expiry");

8

9 COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend';

10

11 COMMENT ON COLUMN "session"."ident" IS 'Secret session identifier (i.e. random string)';

12 COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';

13 COMMENT ON COLUMN "session"."member_id" IS 'Reference to member, who is logged in';

14 COMMENT ON COLUMN "session"."lang" IS 'Language code of the selected language';

15