homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql
author Dremov Kirill (Nokia-D-MSW/Tampere) <kirill.dremov@nokia.com>
Fri, 16 Apr 2010 14:54:01 +0300
changeset 36 cdae8c6c3876
child 39 4e8ebe173323
permissions -rw-r--r--
Revision: 201011 Kit: 201015

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