DROP TABLE IF EXISTS Scene;
CREATE TABLE Scene (
id INTEGER PRIMARY KEY);
DROP TABLE IF EXISTS Pages;
CREATE TABLE Pages (
id INTEGER PRIMARY KEY,
indexPosition INTEGER);
DROP TABLE IF EXISTS Widgets;
CREATE TABLE Widgets (
id INTEGER PRIMARY KEY,
uri TEXT,
pageId INTEGER);
DROP TABLE IF EXISTS WidgetPresentations;
CREATE TABLE WidgetPresentations (
key TEXT,
x REAL,
y REAL,
zValue REAL,
widgetId INTEGER,
UNIQUE(widgetId, key) ON CONFLICT REPLACE,
FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);
DROP TABLE IF EXISTS WidgetPreferences;
CREATE TABLE WidgetPreferences (
key TEXT,
value TEXT,
widgetId INTEGER,
UNIQUE(widgetId, key) ON CONFLICT REPLACE,
FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);
DROP TABLE IF EXISTS Configuration;
CREATE TABLE Configuration (
key TEXT,
value TEXT,
UNIQUE(key) ON CONFLICT REPLACE);