tizen beta release
[framework/web/wrt-plugins-common.git] / src / modules / tizen / WidgetInterfaceDAO / widget_interface_db
1 SQL(
2     PRAGMA foreign_keys = ON;
3     BEGIN TRANSACTION;
4 )
5
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)
11
12     TABLE_CONSTRAINTS(unique(key))
13 CREATE_TABLE_END()
14
15 SQL(
16     COMMIT;
17 )