1CREATE TABLE IF NOT EXISTS "sessions" (
 2    "id" VARCHAR NOT NULL PRIMARY KEY,
 3    "expires" TIMESTAMP WITH TIME ZONE NULL,
 4    "session" TEXT NOT NULL
 5);
 6
 7CREATE TABLE IF NOT EXISTS "users" (
 8    "id" SERIAL PRIMARY KEY,
 9    "github_login" VARCHAR,
10    "admin" BOOLEAN
11);
12
13CREATE UNIQUE INDEX "index_users_github_login" ON "users" ("github_login");
14
15CREATE TABLE IF NOT EXISTS "signups" (
16    "id" SERIAL PRIMARY KEY,
17    "github_login" VARCHAR,
18    "email_address" VARCHAR,
19    "about" TEXT
20);