diff options
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, |