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