Remove useless UserNames table

1 files changed, 2 insertions, 7 deletions

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,