bsw@259: CREATE TABLE "session" (
bsw@259:         "ident"                 TEXT            PRIMARY KEY,
bsw@259:         "additional_secret"     TEXT,
bsw@259:         "expiry"                TIMESTAMPTZ     NOT NULL DEFAULT now() + '24 hours',
bsw@259:         "member_id"             INT8            REFERENCES "member" ("id") ON DELETE SET NULL,
bsw@259:         "lang"                  TEXT );
bsw@259: CREATE INDEX "session_expiry_idx" ON "session" ("expiry");
bsw@259: 
bsw@259: COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend';
bsw@259: 
bsw@259: COMMENT ON COLUMN "session"."ident"             IS 'Secret session identifier (i.e. random string)';
bsw@259: COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';
bsw@259: COMMENT ON COLUMN "session"."member_id"         IS 'Reference to member, who is logged in';
bsw@259: COMMENT ON COLUMN "session"."lang"              IS 'Language code of the selected language';
bsw@259: 
bsw@277: 
bsw@277: 
bsw@277: DELETE FROM "setting" WHERE key = 'tab_mode';