homescreenapp/hsapplication/conf/base/implml/homescreendb_templates/create.sql
changeset 62 341166945d65
parent 55 03646e8da489
equal deleted inserted replaced
57:2e2dc3d30ca8 62:341166945d65
     1 DROP TABLE IF EXISTS Scene;
     1 DROP TABLE IF EXISTS Scene;
     2 CREATE TABLE Scene (
     2 CREATE TABLE Scene (
     3   id INTEGER PRIMARY KEY,
     3   id INTEGER PRIMARY KEY);
     4   portraitWallpaper TEXT,
       
     5   landscapeWallpaper TEXT);
       
     6 
     4 
     7 DROP TABLE IF EXISTS Pages;
     5 DROP TABLE IF EXISTS Pages;
     8 CREATE TABLE Pages (
     6 CREATE TABLE Pages (
     9   id INTEGER PRIMARY KEY,  
     7   id INTEGER PRIMARY KEY,  
    10   indexPosition INTEGER);
     8   indexPosition INTEGER);
    31   value TEXT,
    29   value TEXT,
    32   widgetId INTEGER,
    30   widgetId INTEGER,
    33   UNIQUE(widgetId, key) ON CONFLICT REPLACE,
    31   UNIQUE(widgetId, key) ON CONFLICT REPLACE,
    34   FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);
    32   FOREIGN KEY(widgetId) REFERENCES Widgets(id) ON DELETE CASCADE);
    35 
    33 
    36 DROP TABLE IF EXISTS SnapConfiguration;
    34 DROP TABLE IF EXISTS Configuration;
    37 CREATE TABLE SnapConfiguration (
    35 CREATE TABLE Configuration (
    38 	snappingEnabled INTEGER,
    36 	key TEXT,
    39 	showEffects INTEGER,
    37 	value TEXT,
    40 	snapForce REAL,
    38 	UNIQUE(key) ON CONFLICT REPLACE);
    41 	snapGap REAL,
       
    42 	borderGap REAL,
       
    43 	timeout INTEGER);
       
    44 	
    39 	
    45 DROP TABLE IF EXISTS FeedbackConfiguration;
       
    46 CREATE TABLE FeedbackConfiguration (
       
    47   pageChangeFeedbackType TEXT,
       
    48   widgetPickFeedbackType TEXT, 
       
    49   widgetDropFeedbackType TEXT,
       
    50   widgetRepositionFeedbackType TEXT,
       
    51   widgetOverTrashbinFeedbackType TEXT,
       
    52   widgetDropToTrashbinFeedbackType TEXT,
       
    53   shortcutWidgetTapFeedbackType TEXT,
       
    54   widgetMoveBlockedFeedbackType TEXT,
       
    55   clockWidgetTapFeedbackType TEXT,
       
    56   widgetSnappingFeedbackType TEXT);
       
    57 
       
    58 DROP TABLE IF EXISTS GeneralConfiguration;
       
    59 CREATE TABLE GeneralConfiguration (
       
    60   bounceEffect INTEGER, 
       
    61   tapAndHoldDistance REAL, 
       
    62   widgetTapAndHoldTimeout INTEGER,
       
    63   sceneTapAndHoldTimeout INTEGER,  
       
    64   pageChangeZoneWidth REAL,
       
    65   pageIndicatorSpacing REAL,
       
    66   pageChangeAnimationDuration INTEGER,
       
    67   pageChangeZoneAnimationDuration INTEGER,
       
    68   pageChangeZoneReverseAnimationDuration INTEGER,
       
    69   pageRemovedAnimationDuration INTEGER, 
       
    70   newPageAddedAnimationDuration INTEGER, 
       
    71   widgetDragEffectDuration INTEGER, 
       
    72   widgetDropEffectDuration INTEGER,
       
    73   boundaryFeedbackEffectDistance INTEGER,
       
    74   defaultPageId INTEGER,
       
    75   maximumPageCount INTEGER,
       
    76   maximumWidgetHeight REAL,
       
    77   maximumWidgetWidth REAL,
       
    78   minimumWidgetHeight REAL,
       
    79   minimumWidgetWidth REAL,
       
    80   shortcutLabelsVisible INTEGER,
       
    81   pageChangePanDistance REAL);
       
    82