diff options
author | rsiddharth <s@ricketyspace.net> | 2019-09-12 21:22:01 -0400 |
---|---|---|
committer | rsiddharth <s@ricketyspace.net> | 2019-09-12 21:22:01 -0400 |
commit | 3d6ea3afec8d2f6db68f66dd60fa78efa9035e87 (patch) | |
tree | 709b3ed1d30a629ab27a31dca3814335e06fabac /nfsw/schema.sql | |
parent | 39c85710f5ab1f7c63caf30beaaaede7286fc53a (diff) |
Add some auth flask snafu.
Diffstat (limited to 'nfsw/schema.sql')
-rw-r--r-- | nfsw/schema.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/nfsw/schema.sql b/nfsw/schema.sql new file mode 100644 index 0000000..ff36a06 --- /dev/null +++ b/nfsw/schema.sql @@ -0,0 +1,9 @@ +DROP TABLE IF EXISTS user; + +CREATE TABLE user ( + id INTEGER PRIMARY KEY AUTOINCREMENT, + username TEXT UNIQUE NOT NULL, + password TEXT NOT NULL, + terms_agreed INTEGER DEFAULT 0, + last_login TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP +); |