annotate db/session.lua @ 481:ec2ff3e0b0e6
Add missing group by clauses for search selectors
| author |
bsw |
| date |
Thu Mar 15 13:20:18 2012 +0100 (2012-03-15) |
| 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'; |