annotate db/session.lua @ 1083:6639b4188d7d
Fixed initiative link in testing config
| author |
bsw |
| date |
Wed Jul 23 23:08:53 2014 +0200 (2014-07-23) |
| parents |
bde068b37608 |
| children |
|
| rev |
line source |
|
bsw@259
|
1 CREATE TABLE "session" (
|
|
bsw@259
|
2 "ident" TEXT PRIMARY KEY,
|
|
bsw@259
|
3 "additional_secret" TEXT,
|
|
bsw@259
|
4 "expiry" TIMESTAMPTZ NOT NULL DEFAULT now() + '24 hours',
|
|
bsw@259
|
5 "member_id" INT8 REFERENCES "member" ("id") ON DELETE SET NULL,
|
|
bsw@259
|
6 "lang" TEXT );
|
|
bsw@259
|
7 CREATE INDEX "session_expiry_idx" ON "session" ("expiry");
|
|
bsw@259
|
8
|
|
bsw@259
|
9 COMMENT ON TABLE "session" IS 'Sessions, i.e. for a web-frontend';
|
|
bsw@259
|
10
|
|
bsw@259
|
11 COMMENT ON COLUMN "session"."ident" IS 'Secret session identifier (i.e. random string)';
|
|
bsw@259
|
12 COMMENT ON COLUMN "session"."additional_secret" IS 'Additional field to store a secret, which can be used against CSRF attacks';
|
|
bsw@259
|
13 COMMENT ON COLUMN "session"."member_id" IS 'Reference to member, who is logged in';
|
|
bsw@259
|
14 COMMENT ON COLUMN "session"."lang" IS 'Language code of the selected language';
|
|
bsw@259
|
15
|
|
bsw@277
|
16
|
|
bsw@277
|
17
|
|
bsw@277
|
18 DELETE FROM "setting" WHERE key = 'tab_mode'; |