RicardoSQLiteOddity: dumpMenu.sql

File dumpMenu.sql, 1.8 kB (added by raraoz, 3 years ago)
Line 
1 BEGIN TRANSACTION;
2 CREATE TABLE "Menu" (
3     "MenuId" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
4     "Name" INTEGER NOT NULL,
5     "Hidden" INTEGER NOT NULL,
6     "Disabled" INTEGER NOT NULL
7 );
8 INSERT INTO "Menu" VALUES(1,'root',1,1);
9 INSERT INTO "Menu" VALUES(2,'Hijo',0,0);
10 INSERT INTO "Menu" VALUES(3,'OtroHijo',0,0);
11 INSERT INTO "Menu" VALUES(4,'Hijo-1',0,0);
12 INSERT INTO "Menu" VALUES(5,'Hijo-1-1',0,0);
13 INSERT INTO "Menu" VALUES(6,'Hijo-1-2',0,0);
14 INSERT INTO "Menu" VALUES(7,'OtroHijo-1',0,0);
15 INSERT INTO "Menu" VALUES(8,'Hijo-2',0,0);
16 DELETE FROM sqlite_sequence;
17 INSERT INTO "sqlite_sequence" VALUES('Menu',8);
18 INSERT INTO "sqlite_sequence" VALUES('MenuOpt',2);
19 CREATE TABLE "Path" (
20     "Id" INTEGER NOT NULL,
21     "AncestorId" INTEGER NOT NULL
22 );
23 INSERT INTO "Path" VALUES(2,1);
24 INSERT INTO "Path" VALUES(3,1);
25 INSERT INTO "Path" VALUES(4,2);
26 INSERT INTO "Path" VALUES(4,1);
27 INSERT INTO "Path" VALUES(5,4);
28 INSERT INTO "Path" VALUES(5,2);
29 INSERT INTO "Path" VALUES(5,1);
30 INSERT INTO "Path" VALUES(6,4);
31 INSERT INTO "Path" VALUES(6,2);
32 INSERT INTO "Path" VALUES(6,1);
33 INSERT INTO "Path" VALUES(7,3);
34 INSERT INTO "Path" VALUES(7,1);
35 INSERT INTO "Path" VALUES(8,2);
36 INSERT INTO "Path" VALUES(8,1);
37 CREATE TABLE "MenuOpt" (
38     "MenuOptId" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
39     "MenuId" INTEGER NOT NULL,
40     "Name" TEXT NOT NULL,
41     "Hidden" INTEGER NOT NULL DEFAULT (0),
42     "Disabled" INTEGER NOT NULL DEFAULT (0),
43     "OutDir" TEXT NOT NULL DEFAULT ('.\'),
44     "Execute" TEXT,
45     "Help" TEXT,
46     "Obs" TEXT,
47     "Order" INTEGER NOT NULL DEFAULT (999999)
48 );
49 INSERT INTO "MenuOpt" VALUES(1,4,'Alguna Opcion',0,0,'.\',NULL,'Help para alguna opcion',NULL,999999);
50 INSERT INTO "MenuOpt" VALUES(2,4,'Otra Opción',0,0,'.\',NULL,'help para Otra Opcion',NULL,999999);
51 COMMIT;