annotate db/session.lua @ 1676:8fde003bdeb0
Added support for alternative DN string
| author |
bsw |
| date |
Mon Jun 07 20:58:31 2021 +0200 (2021-06-07) |
| 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'; |