| PRAGMA foreign_keys=OFF; | |
| BEGIN TRANSACTION; | |
| CREATE TABLE rooms ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
| room_id TEXT NOT NULL | |
| );INSERT INTO rooms VALUES(1,'room-0'); | |
| INSERT INTO rooms VALUES(2,'room-1'); | |
| INSERT INTO rooms VALUES(3,'room-2'); | |
| INSERT INTO rooms VALUES(4,'room-3'); | |
| INSERT INTO rooms VALUES(5,'room-4'); | |
| INSERT INTO rooms VALUES(6,'room-5'); | |
| INSERT INTO rooms VALUES(7,'room-6'); | |
| INSERT INTO rooms VALUES(8,'room-7'); | |
| INSERT INTO rooms VALUES(9,'room-8'); | |
| INSERT INTO rooms VALUES(10,'room-9'); | |
| INSERT INTO rooms VALUES(11,'room-10'); | |
| INSERT INTO rooms VALUES(12,'room-11'); | |
| INSERT INTO rooms VALUES(13,'room-12'); | |
| INSERT INTO rooms VALUES(14,'room-13'); | |
| INSERT INTO rooms VALUES(15,'room-14'); | |
| INSERT INTO rooms VALUES(16,'room-15'); | |
| INSERT INTO rooms VALUES(17,'room-16'); | |
| INSERT INTO rooms VALUES(18,'room-17'); | |
| INSERT INTO rooms VALUES(19,'room-18'); | |
| INSERT INTO rooms VALUES(20,'room-19'); | |
| INSERT INTO rooms VALUES(21,'room-20'); | |
| INSERT INTO rooms VALUES(22,'room-21'); | |
| INSERT INTO rooms VALUES(23,'room-22'); | |
| INSERT INTO rooms VALUES(24,'room-23'); | |
| INSERT INTO rooms VALUES(25,'room-24'); | |
| INSERT INTO rooms VALUES(26,'room-25'); | |
| INSERT INTO rooms VALUES(27,'room-26'); | |
| INSERT INTO rooms VALUES(28,'room-27'); | |
| INSERT INTO rooms VALUES(29,'room-28'); | |
| INSERT INTO rooms VALUES(30,'room-29'); | |
| INSERT INTO rooms VALUES(31,'room-30'); | |
| INSERT INTO rooms VALUES(32,'room-31'); | |
| INSERT INTO rooms VALUES(33,'room-32'); | |
| INSERT INTO rooms VALUES(34,'room-33'); | |
| INSERT INTO rooms VALUES(35,'room-34'); | |
| INSERT INTO rooms VALUES(36,'room-35'); | |
| INSERT INTO rooms VALUES(37,'room-36'); | |
| INSERT INTO rooms VALUES(38,'room-37'); | |
| INSERT INTO rooms VALUES(39,'room-38'); | |
| INSERT INTO rooms VALUES(40,'room-39'); | |
| INSERT INTO rooms VALUES(41,'room-40'); | |
| DELETE FROM sqlite_sequence; | |
| INSERT INTO sqlite_sequence VALUES('rooms',41); | |
| CREATE TABLE rooms_data ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, | |
| room_id TEXT NOT NULL, | |
| uuid TEXT NOT NULL, | |
| x INTEGER NOT NULL, | |
| y INTEGER NOT NULL, | |
| prompt TEXT NOT NULL, | |
| time DATETIME NOT NULL, | |
| key TEXT NOT NULL, | |
| UNIQUE (key) ON CONFLICT IGNORE | |
| );COMMIT; | |