diff options
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 7 |
1 files changed, 1 insertions, 6 deletions
@@ -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, |