homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql
changeset 86 e4f038c420f7
parent 81 7dd137878ff8
child 90 3ac3aaebaee5
--- a/homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql	Wed Aug 18 10:33:57 2010 +0300
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,39 +0,0 @@
-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