ttt-space / schema.sql
radames's picture
first
feb4f42
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;