From f1634688d62f2a6115739b65a311ab2b1cf79764 Mon Sep 17 00:00:00 2001 From: tomsmeding Date: Wed, 15 Mar 2017 08:53:25 +0100 Subject: Remove useless UserNames table --- schema.sql | 9 ++------- 1 file changed, 2 insertions(+), 7 deletions(-) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 9f6da9e..321cb38 100644 --- a/schema.sql +++ b/schema.sql @@ -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, -- cgit v1.2.3-54-g00ecf