2 PRAGMA foreign_keys = ON;
6 CREATE_TABLE(Properties)
7 COLUMN_NOT_NULL(key, TEXT,)
8 COLUMN_NOT_NULL(value, TEXT,)
9 COLUMN_NOT_NULL(readonly, INTEGER, check(readonly between 0 and 1))
10 COLUMN_NOT_NULL(configxml, INTEGER, check(readonly between 0 and 1) DEFAULT 0)
12 TABLE_CONSTRAINTS(unique(key))