| 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; |
|---|