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
MySQL
15 lines
322 B
MySQL
6 years ago
|
-- schemas
|
||
|
|
|
||
|
|
CREATE SCHEMA IF NOT EXISTS bingo;
|
||
|
|
|
||
|
|
-- public tables
|
||
|
|
|
||
|
|
-- creates the Session table
|
||
|
6 years ago
|
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);
|