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(
  58         unique(app_id,dev_cap)
  59         FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
  60     )
  61 CREATE_TABLE_END()
  62
  63 CREATE_TABLE(AceAcceptedFeature)
  64     COLUMN_NOT_NULL(app_id,        INTEGER,  not null)
  65     COLUMN_NOT_NULL(feature,       TEXT,     not null)
  66
  67     TABLE_CONSTRAINTS(
  68         unique(app_id,feature)
  69         FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
  70     )
  71 CREATE_TABLE_END()
  72
  73 CREATE_TABLE(WidgetInfo)
  74     COLUMN_NOT_NULL(app_id,         INTEGER,      PRIMARY KEY)
  75     COLUMN(widget_type,             INT,          DEFAULT 1)
  76     COLUMN(widget_id,               VARCHAR(256), DEFAULT '')
  77     COLUMN(widget_version,          VARCHAR(256), DEFAULT '')
  78     COLUMN(author_name,             VARCHAR(256), DEFAULT '')
  79     COLUMN(share_href,              VARCHAR(256), DEFAULT '')
  80 CREATE_TABLE_END()
  81
  82 CREATE_TABLE(WidgetCertificateFingerprint)
  83     COLUMN_NOT_NULL(app_id,     INT,)
  84     COLUMN_NOT_NULL(owner,      INT,)
  85     COLUMN_NOT_NULL(chainid,    INT,)
  86     COLUMN_NOT_NULL(type,       INT,)
  87     COLUMN(md5_fingerprint,     VARCHAR(64),)
  88     COLUMN(sha1_fingerprint,    VARCHAR(64),)
  89     COLUMN(common_name,         VARCHAR(64),)
  90     TABLE_CONSTRAINTS(
  91         PRIMARY KEY (app_id, chainid, owner, type)
  92         FOREIGN KEY (app_id) REFERENCES WidgetInfo (app_id) ON DELETE CASCADE
  93     )
  94 CREATE_TABLE_END()
  95
  96 SQL(
  97     COMMIT;
  98 )