homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql
changeset 92 6727c5d0afc7
parent 85 35368b604b28
child 96 458d8c8d9580
--- a/homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql	Thu Sep 02 20:17:27 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