diff options
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 +); |