1ALTER TABLE users
2ADD email_address VARCHAR(255) DEFAULT NULL,
3ADD invite_code VARCHAR(64),
4ADD invite_count INTEGER NOT NULL DEFAULT 0,
5ADD inviter_id INTEGER REFERENCES users (id),
6ADD connected_once BOOLEAN NOT NULL DEFAULT false,
7ADD created_at TIMESTAMP NOT NULL DEFAULT NOW();
8
9CREATE UNIQUE INDEX "index_invite_code_users" ON "users" ("invite_code");