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