2019-10-08 23:24:25 +02:00
|
|
|
CREATE TABLE "sessions" (
|
|
|
|
|
"sid" text NOT NULL COLLATE "default",
|
2019-10-22 19:06:21 +02:00
|
|
|
"session" jsonb NOT NULL,
|
2019-10-08 23:24:25 +02:00
|
|
|
"expires_at" timestamptz NOT NULL,
|
|
|
|
|
"created_at" timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
|
|
|
"updated_at" timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP
|
|
|
|
|
);
|
|
|
|
|
|
|
|
|
|
ALTER TABLE "sessions" ADD CONSTRAINT "session_pkey" PRIMARY KEY ("sid") NOT DEFERRABLE INITIALLY IMMEDIATE;
|
|
|
|
|
CREATE TRIGGER "set_sessions_updated" BEFORE UPDATE ON "sessions" FOR EACH ROW EXECUTE PROCEDURE set_updated_timestamp();
|
