homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql
changeset 36 cdae8c6c3876
child 39 4e8ebe173323
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql	Fri Apr 16 14:54:01 2010 +0300
@@ -0,0 +1,38 @@
+DROP TABLE IF EXISTS Scene;
+CREATE TABLE Scene (
+  id INTEGER PRIMARY KEY,
+  portraitWallpaper TEXT,
+  landscapeWallpaper TEXT,
+  defaultPageId INTEGER,
+  maximumPageCount INTEGER);
+
+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,
+  width REAL,
+  height 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);