summaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/schema.sql10
1 files changed, 3 insertions, 7 deletions
diff --git a/sql/schema.sql b/sql/schema.sql
index 7bfb9d0..06f4091 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -10,11 +10,7 @@ CREATE TABLE users (
id TEXT PRIMARY KEY NOT NULL,
name TEXT,
email TEXT,
- department TEXT
-);
-CREATE TABLE sessions (
- cookie TEXT PRIMARY KEY NOT NULL,
- userid TEXT NOT NULL,
- expr INTEGER NOT NULL,
- FOREIGN KEY(userid) REFERENCES users(id)
+ department TEXT,
+ session TEXT,
+ expr INTEGER
);