Mercurial > hg > syntilista

comparison src/main.cpp @ 253:eadffc38ab43

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add support for initial INSERT statements for database creation in schema array.
author Matti Hamalainen <ccr@tnsp.org>
date Tue, 08 May 2018 15:00:41 +0300
parents 4d2b37a0acf2
children 55581d90c55d
comparison
equal deleted inserted replaced
252:4d2b37a0acf2 253:eadffc38ab43
37 "last_name VARCHAR(" SL_STR(SQL_LEN_LAST_NAME) ") NOT NULL," 37 "last_name VARCHAR(" SL_STR(SQL_LEN_LAST_NAME) ") NOT NULL,"
38 "extra_info VARCHAR(" SL_STR(SQL_LEN_EXTRA_INFO) ")," 38 "extra_info VARCHAR(" SL_STR(SQL_LEN_EXTRA_INFO) "),"
39 39
40 "added DATETIME NOT NULL," 40 "added DATETIME NOT NULL,"
41 "updated DATETIME NOT NULL" 41 "updated DATETIME NOT NULL"
42 ) 42 ),
43 { }
43 }, 44 },
44 { 45 {
45 QStringLiteral("transactions"), 46 QStringLiteral("transactions"),
46 QStringLiteral( 47 QStringLiteral(
47 "id INTEGER PRIMARY KEY, " 48 "id INTEGER PRIMARY KEY, "
48 "person INT NOT NULL, " 49 "person INT NOT NULL, "
49 "value REAL, " 50 "value REAL, "
50 "added DATETIME NOT NULL" 51 "added DATETIME NOT NULL"
51 ) 52 ),
53 { }
52 }, 54 },
53 }; 55 };
54 56
55 static const int nslSQLSchemaData = sizeof(slSQLSchemaData) / sizeof(slSQLSchemaData[0]); 57 static const int nslSQLSchemaData = sizeof(slSQLSchemaData) / sizeof(slSQLSchemaData[0]);
56 58