diff options
author | tomsmeding <tom.smeding@gmail.com> | 2017-03-15 08:53:25 +0100 |
---|---|---|
committer | tomsmeding <tom.smeding@gmail.com> | 2017-03-15 08:53:25 +0100 |
commit | f1634688d62f2a6115739b65a311ab2b1cf79764 (patch) | |
tree | e185cbc4f53a27f0588d5660b9bec567d6f6fa66 /schema.sql | |
parent | a7a5b95990e0d6c1617c796dba2c45dab816161d (diff) |
Remove useless UserNames table
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 2 insertions, 7 deletions
@@ -16,15 +16,10 @@ create table Members ( create table Users ( id integer primary key, - username text, + name text, pass text ); - -create table UserNames ( - name text primary key, - user integer, - foreign key(user) references Users(id) on delete cascade -); +create unique index users_name_index on Users(name); create table Messages ( id integer primary key, |