Room listing and creation

1 files changed, 1 insertions, 6 deletions

diff --git a/schema.sql b/schema.sql
index 5a888d6..9f6da9e 100644
--- a/schema.sql
+++ b/schema.sql
@@ -4,12 +4,7 @@ create table Rooms (
 	id integer primary key,
 	name text
 );
-
-create table RoomNames (
-	name text primary key,
-	room integer not null,
-	foreign key(room) references Rooms(id) on delete cascade
-);
+create unique index rooms_name_index on Rooms(name);
 
 create table Members (
 	room integer,