From f1634688d62f2a6115739b65a311ab2b1cf79764 Mon Sep 17 00:00:00 2001
From: tomsmeding <tom.smeding@gmail.com>
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

