diff options
Diffstat (limited to 'sql/schema.sql')
-rw-r--r-- | sql/schema.sql | 10 |
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 ); |