--- 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