1 DROP TABLE IF EXISTS Scene;

     2 CREATE TABLE Scene (

     3   id INTEGER PRIMARY KEY,

     4   portraitWallpaper TEXT,

     5   landscapeWallpaper TEXT,

     6   defaultPageId INTEGER,

     7   maximumPageCount INTEGER);

     8 

     9 DROP TABLE IF EXISTS Pages;

    10 CREATE TABLE Pages (

    11   id INTEGER PRIMARY KEY,  

    12   indexPosition INTEGER);

    13 

    14 DROP TABLE IF EXISTS Widgets;

    15 CREATE TABLE Widgets (

    16   id INTEGER PRIMARY KEY,

    17   uri TEXT,  

    18   pageId INTEGER);

    19 

    20 DROP TABLE IF EXISTS WidgetPresentations;

    21 CREATE TABLE WidgetPresentations (

    22   key TEXT,

    23   x REAL,

    24   y REAL,

    25   width REAL,

    26   height REAL,

    27   zValue REAL,	

    28   widgetId INTEGER,

    29   UNIQUE(widgetId, key) ON CONFLICT REPLACE,

    30   FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);

    31 

    32 DROP TABLE IF EXISTS WidgetPreferences;

    33 CREATE TABLE WidgetPreferences (

    34   key TEXT,

    35   value TEXT,

    36   widgetId INTEGER,

    37   UNIQUE(widgetId, key) ON CONFLICT REPLACE,

    38   FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);