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);
21
22INSERT INTO users (github_login, admin)
23VALUES
24    ('nathansobo', true),
25    ('maxbrunsfeld', true),
26    ('as-cii', true);