mirror of https://github.com/Trivernis/whooshy.git
You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
15 lines
322 B
SQL
15 lines
322 B
SQL
-- schemas
|
|
|
|
CREATE SCHEMA IF NOT EXISTS bingo;
|
|
|
|
-- public tables
|
|
|
|
-- creates the Session table
|
|
CREATE TABLE IF NOT EXISTS "user_sessions" (
|
|
"sid" varchar NOT NULL COLLATE "default",
|
|
"sess" json NOT NULL,
|
|
"expire" timestamp(6) NOT NULL,
|
|
PRIMARY KEY ("sid") NOT DEFERRABLE INITIALLY IMMEDIATE
|
|
)
|
|
WITH (OIDS=FALSE);
|