PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE commands(ft_id INTEGER NOT NULL, type INTEGER NOT NULL, enabled INTEGER NOT NULL, command TEXT, FOREIGN KEY(ft_id) REFERENCES filetypes(id) ON UPDATE CASCADE ON DELETE CASCADE, PRIMARY KEY (ft_id, type)); INSERT INTO commands VALUES(1,0,1,'"!=\!.!"'); INSERT INTO commands VALUES(1,1,1,'observe:"!=\!.!"'); INSERT INTO commands VALUES(1,2,1,'view:"!=\!.!"'); INSERT INTO commands VALUES(2,0,1,'hlf:"!=\!+!" !?Go to topic ((Contents if empty))!'); INSERT INTO commands VALUES(2,3,1,'hlf:"!=\!+!"'); INSERT INTO commands VALUES(2,4,1,'edit:"!=\!+!"'); INSERT INTO commands VALUES(3,0,1,'lua:@"!=\!.!"'); INSERT INTO commands VALUES(4,0,1,'moon:@"!=\!.!"'); INSERT INTO commands VALUES(5,0,1,'view:"!=\!+!"'); INSERT INTO commands VALUES(5,2,1,'View:"!=\!+!"'); INSERT INTO commands VALUES(5,3,1,'"!=\!+!"'); INSERT INTO commands VALUES(5,4,1,'edit:"!=\!+!"'); INSERT INTO commands VALUES(5,5,1,'"!=\!+!"'); INSERT INTO commands VALUES(6,0,1,'view:"!=\!.!"'); INSERT INTO commands VALUES(6,1,1,'view:"!=\!.!"'); INSERT INTO commands VALUES(7,0,1,'lua:Keys("ShiftEnter")'); INSERT INTO commands VALUES(7,1,1,'@pic:!=\!.!'); INSERT INTO commands VALUES(7,2,0,'@pic:!=\!.!'); INSERT INTO commands VALUES(8,3,1,'peanalyzer:"!=\!+!"'); INSERT INTO commands VALUES(9,0,1,'"!=\!+!"'); INSERT INTO commands VALUES(9,2,1,'view:"!=\!+!"'); INSERT INTO commands VALUES(9,4,1,'edit:"!=\!+!"'); INSERT INTO commands VALUES(9,5,1,'reg2:"!=\!+!"'); COMMIT; PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE filetypes(id INTEGER PRIMARY KEY, weight INTEGER NOT NULL, mask TEXT, description TEXT); INSERT INTO filetypes VALUES(1,1,'*.pdf','Adobe PDF'); INSERT INTO filetypes VALUES(2,2,'*.hlf','Far Help'); INSERT INTO filetypes VALUES(3,3,'*.lua','Lua script'); INSERT INTO filetypes VALUES(4,4,'*.moon','Moonscrip'); INSERT INTO filetypes VALUES(5,5,'Readme.[tw]xt,Descript.ion,File_Id.diz,[r]notes.[tw]xt,readme.md','Readme and descriptions'); INSERT INTO filetypes VALUES(6,6,'*.','Text UNIX'); INSERT INTO filetypes VALUES(7,7,'<video>','Video'); INSERT INTO filetypes VALUES(8,8,'*.exe,*.?ll,*.ocx,*.bin,*.sys,*.prg,*.ax','Windows executable'); INSERT INTO filetypes VALUES(9,9,'*.reg,*.key','Windows Registry'); COMMIT; |