equal
deleted
inserted
replaced
|
1 DROP TABLE IF EXISTS Scene; |
|
2 CREATE TABLE Scene ( |
|
3 id INTEGER PRIMARY KEY); |
|
4 |
|
5 DROP TABLE IF EXISTS Pages; |
|
6 CREATE TABLE Pages ( |
|
7 id INTEGER PRIMARY KEY, |
|
8 indexPosition INTEGER); |
|
9 |
|
10 DROP TABLE IF EXISTS Widgets; |
|
11 CREATE TABLE Widgets ( |
|
12 id INTEGER PRIMARY KEY, |
|
13 uri TEXT, |
|
14 pageId INTEGER); |
|
15 |
|
16 DROP TABLE IF EXISTS WidgetPresentations; |
|
17 CREATE TABLE WidgetPresentations ( |
|
18 key TEXT, |
|
19 x REAL, |
|
20 y REAL, |
|
21 zValue REAL, |
|
22 widgetId INTEGER, |
|
23 UNIQUE(widgetId, key) ON CONFLICT REPLACE, |
|
24 FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE); |
|
25 |
|
26 DROP TABLE IF EXISTS WidgetPreferences; |
|
27 CREATE TABLE WidgetPreferences ( |
|
28 key TEXT, |
|
29 value TEXT, |
|
30 widgetId INTEGER, |
|
31 UNIQUE(widgetId, key) ON CONFLICT REPLACE, |
|
32 FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE); |
|
33 |
|
34 DROP TABLE IF EXISTS Configuration; |
|
35 CREATE TABLE Configuration ( |
|
36 key TEXT, |
|
37 value TEXT, |
|
38 UNIQUE(key) ON CONFLICT REPLACE); |
|
39 |