BEGIN TRANSACTION;
CREATE TABLE Test1 (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO "Test1" VALUES(1,'Ivan');
INSERT INTO "Test1" VALUES(2,'Petr');
INSERT INTO "Test1" VALUES(3,'Sidor');
CREATE TABLE Test2 (id INTEGER PRIMARY KEY, name_id INTEGER,nick TEXT);
INSERT INTO "Test2" VALUES(1,1,'Vanja');
INSERT INTO "Test2" VALUES(2,2,'Petja');
CREATE TABLE Test3 (id INTEGER PRIMARY KEY, name_id INTEGER,data_type INTEGER, data TEXT);
INSERT INTO "Test3" VALUES(1,1,1,'1_Phone1');
INSERT INTO "Test3" VALUES(2,1,1,'1_Phone2');
INSERT INTO "Test3" VALUES(3,1,1,'1_Phone3');
INSERT INTO "Test3" VALUES(4,1,2,'1_Email1');
INSERT INTO "Test3" VALUES(5,2,1,'2_Phone1');
INSERT INTO "Test3" VALUES(6,2,2,'2_Email1');
INSERT INTO "Test3" VALUES(7,3,1,'3_Phone1');
COMMIT;
|
