From e5a2850b6bb9887b241316be24b3f7047cef6ea3 Mon Sep 17 00:00:00 2001 From: Jeffrey Armstrong Date: Wed, 27 Apr 2022 09:52:34 -0400 Subject: Added command line args to create an admin user. Fixed a few db bugs. --- captain/sql/create.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'captain/sql') diff --git a/captain/sql/create.sql b/captain/sql/create.sql index 9e4d204..7517e07 100644 --- a/captain/sql/create.sql +++ b/captain/sql/create.sql @@ -17,7 +17,7 @@ CREATE TABLE checkin(player INTEGER PRIMARY KEY, year INTEGER, month INTEGER, da CREATE TABLE schedule(instruction INTEGER NOT NULL, player INTEGER NOT NULL, day INTEGER DEFAULT 0, hour INTEGER DEFAULT 0, FOREIGN KEY(instruction) REFERENCES instructions(id) ON DELETE CASCADE, FOREIGN KEY(player) REFERENCES players(id) ON DELETE CASCADE ); -CREATE TABLE users(id INTEGER PRIMARY KEY, username TEXT UNIQUE NOT NULL, email TEXT NOT NULL, password TEXT NOT NULL, level INTEGER DEFAULT 1); +CREATE TABLE users(id INTEGER PRIMARY KEY AUTOINCREMENT, username TEXT UNIQUE NOT NULL, email TEXT NOT NULL, password TEXT NOT NULL, level INTEGER DEFAULT 1); CREATE TABLE sessions(user INTEGER, session TEXT NOT NULL, expiration TEXT NOT NULL, FOREIGN KEY(user) REFERENCES users(id) ON DELETE CASCADE); -- cgit v1.2.3