--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/homescreenapp/hsapplication/conf/implml/homescreendb_templates/create.sql Fri Sep 17 08:27:54 2010 +0300
@@ -0,0 +1,39 @@
+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);
+
\ No newline at end of file