ace/orm/ace_db

   1 SQL(
   2     PRAGMA foreign_keys = ON;
   3     BEGIN TRANSACTION;
   4 )
   5
   6 CREATE_TABLE(AcePolicyResult)
   7     COLUMN_NOT_NULL(decision,       INTEGER,    check(decision between 0 and 6))
   8     COLUMN_NOT_NULL(hash,           TEXT,)
   9     COLUMN_NOT_NULL(rule_id,        INTEGER)
  10     TABLE_CONSTRAINTS(
  11         PRIMARY KEY(hash)
  12     )
  13 CREATE_TABLE_END()
  14
  15 CREATE_TABLE(AcePromptDecision)
  16     COLUMN_NOT_NULL(app_id,         INTEGER,)
  17     COLUMN_NOT_NULL(decision,       INTEGER,   check(decision between 0 and 5))
  18     COLUMN(session,                 TEXT,)
  19     COLUMN_NOT_NULL(rule_id,        INTEGER,)
  20     TABLE_CONSTRAINTS(
  21         PRIMARY KEY(app_id,rule_id)
  22     )
  23 CREATE_TABLE_END()
  24
  25 CREATE_TABLE(AceAttribute)
  26     COLUMN_NOT_NULL(attr_id,        INTEGER,    primary key autoincrement)
  27     COLUMN_NOT_NULL(name,           TEXT,)
  28     COLUMN_NOT_NULL(type,           INTEGER,    check(type between 0 and 4))
  29
  30     TABLE_CONSTRAINTS(unique(name,type))
  31 CREATE_TABLE_END()
  32
  33 CREATE_TABLE(AceSubject)
  34     COLUMN_NOT_NULL(subject_id,     INTEGER,    primary key autoincrement)
  35     COLUMN_NOT_NULL(id_uri,         TEXT,       unique)
  36 CREATE_TABLE_END()
  37
  38 CREATE_TABLE(AceDevCap)
  39     COLUMN_NOT_NULL(resource_id,    INTEGER,    primary key autoincrement)
  40     COLUMN_NOT_NULL(id_uri,         TEXT,       unique)
  41     COLUMN_NOT_NULL(general_setting,INTEGER,    check(general_setting between -1 and 4))
  42 CREATE_TABLE_END()
  43
  44 CREATE_TABLE(AceWidgetDevCapSetting)
  45     COLUMN_NOT_NULL(app_id,         INTEGER,    not null)
  46     COLUMN_NOT_NULL(resource_id,    INTEGER,    references AceDevCap(resource_id))
  47     COLUMN_NOT_NULL(access_value,   INTEGER,    check(access_value between -1 and 4))
  48
  49     TABLE_CONSTRAINTS(unique(app_id,resource_id))
  50 CREATE_TABLE_END()
  51
  52 CREATE_TABLE(AceRequestedDevCaps)
  53     COLUMN_NOT_NULL(app_id,        INTEGER,  not null)
  54     COLUMN_NOT_NULL(grant_smack,   INTEGER,  not null)
  55     COLUMN_NOT_NULL(dev_cap,       TEXT,)
  56
  57     TABLE_CONSTRAINTS(unique(app_id,dev_cap))
  58 CREATE_TABLE_END()
  59
  60 CREATE_TABLE(AceAcceptedFeature)
  61     COLUMN_NOT_NULL(app_id,        INTEGER,  not null)
  62     COLUMN_NOT_NULL(feature,       TEXT,     not null)
  63
  64     TABLE_CONSTRAINTS(unique(app_id,feature))
  65 CREATE_TABLE_END()
  66
  67 CREATE_TABLE(WidgetInfo)
  68     COLUMN_NOT_NULL(app_id,         INTEGER,      PRIMARY KEY)
  69     COLUMN(widget_type,             INT,          DEFAULT 1)
  70     COLUMN(widget_id,               VARCHAR(256), DEFAULT '')
  71     COLUMN(widget_version,          VARCHAR(256), DEFAULT '')
  72     COLUMN(author_name,             VARCHAR(256), DEFAULT '')
  73     COLUMN(share_href,              VARCHAR(256), DEFAULT '')
  74 CREATE_TABLE_END()
  75
  76 CREATE_TABLE(WidgetCertificateFingerprint)
  77     COLUMN_NOT_NULL(app_id,     INT,)
  78     COLUMN_NOT_NULL(owner,      INT,)
  79     COLUMN_NOT_NULL(chainid,    INT,)
  80     COLUMN_NOT_NULL(type,       INT,)
  81     COLUMN(md5_fingerprint,     VARCHAR(64),)
  82     COLUMN(sha1_fingerprint,    VARCHAR(64),)
  83     COLUMN(common_name,         VARCHAR(64),)
  84     TABLE_CONSTRAINTS(
  85         PRIMARY KEY (app_id, chainid, owner, type)
  86         FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
  87     )
  88 CREATE_TABLE_END()
  89
  90 SQL(
  91     COMMIT;
  92 )