annotate db/session.lua @ 259:4c0bff8141ee
Add session table creation script
| author |
bsw |
| date |
Tue Feb 07 17:27:07 2012 +0100 (2012-02-07) |
| parents |
|
| children |
bde068b37608 |
| 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
|