2 CREATE_TABLE(TestTableInsert)
3 COLUMN(ColumnOptInt, INT,)
4 COLUMN(ColumnOptText, TEXT,)
5 COLUMN_NOT_NULL(ColumnInt, INT, DEFAULT 99)
6 COLUMN_NOT_NULL(ColumnInt2, INT,)
7 COLUMN_NOT_NULL(ColumnText, TEXT,)
10 CREATE_TABLE(TestTableDelete)
11 COLUMN(ColumnOptInt, INT,)
12 COLUMN(ColumnOptText, TEXT,)
13 COLUMN_NOT_NULL(ColumnInt, INT, DEFAULT 99)
14 COLUMN_NOT_NULL(ColumnInt2, INT,)
15 COLUMN_NOT_NULL(ColumnText, TEXT,)
19 INSERT INTO TestTableDelete VALUES(1, "two", 3, 4, "five");
20 INSERT INTO TestTableDelete VALUES(6, "seven", 8, 9, "ten");
21 INSERT INTO TestTableDelete (ColumnInt2, ColumnText) VALUES(11, "twelve");
22 INSERT INTO TestTableDelete (ColumnInt2, ColumnText) VALUES(13, "fourteen");
25 CREATE_TABLE(TestTable)
26 COLUMN(ColumnOptInt, INT,)
27 COLUMN(ColumnOptText, TEXT,)
28 COLUMN_NOT_NULL(ColumnInt, INT, DEFAULT 99)
29 COLUMN_NOT_NULL(ColumnInt2, INT,)
30 COLUMN_NOT_NULL(ColumnText, TEXT,)
34 INSERT INTO TestTable VALUES(1, "two", 3, 4, "five");
35 INSERT INTO TestTable VALUES(6, "seven", 8, 9, "ten");
36 INSERT INTO TestTable (ColumnInt2, ColumnText) VALUES(11, "twelve");
37 INSERT INTO TestTable (ColumnInt2, ColumnText) VALUES(13, "fourteen");
40 CREATE_TABLE(TestTableJoin1)
41 COLUMN_NOT_NULL(TestID, INT,)
42 COLUMN_NOT_NULL(TestText, TEXT,)
43 COLUMN(TestNumber, INT,)
49 CREATE_TABLE(TestTableJoin2)
50 COLUMN_NOT_NULL(TestID, INT,)
51 COLUMN_NOT_NULL(TestText1, TEXT,)
52 COLUMN_NOT_NULL(TestText2, TEXT,)
58 CREATE_TABLE(TestTableJoin3)
59 COLUMN_NOT_NULL(TestID, INT,)
61 COLUMN(TestText33, TEXT,)
68 INSERT INTO TestTableJoin1 VALUES(1, "text val 1", 111);
69 INSERT INTO TestTableJoin1 VALUES(2, "text val 2", 222);
70 INSERT INTO TestTableJoin1 VALUES(3, "text val 3", 333);
71 INSERT INTO TestTableJoin1 VALUES(4, "text val 4", 444);
72 INSERT INTO TestTableJoin1 VALUES(5, "text val 5", 555);
73 INSERT INTO TestTableJoin1 VALUES(6, "text val 6", 666);
75 INSERT INTO TestTableJoin2 VALUES(1, "01", "text2 1");
76 INSERT INTO TestTableJoin2 VALUES(2, "02", "text2 2");
77 INSERT INTO TestTableJoin2 VALUES(3, "03", "text2 3");
78 INSERT INTO TestTableJoin2 VALUES(4, " 4 ", "text2 4");
79 INSERT INTO TestTableJoin2 VALUES(5, "*5*", "text2 5");
80 INSERT INTO TestTableJoin2 VALUES(10, "6", "text2 6");
82 INSERT INTO TestTableJoin3 VALUES(1, 111, "test 1");
83 INSERT INTO TestTableJoin3 VALUES(2, 111, "test 2");
84 INSERT INTO TestTableJoin3 VALUES(3, 222, "test 3");
85 INSERT INTO TestTableJoin3 VALUES(6, 222, "test 4");
86 INSERT INTO TestTableJoin3 (TestID, TestText33) VALUES(7, "test 5");
87 INSERT INTO TestTableJoin3 (TestID, TestText33) VALUES(10, "test 6");