modules/custom_handler_dao/orm/custom_handler_db

   1 SQL(
   2     BEGIN TRANSACTION;
   3 )
   4
   5 CREATE_TABLE(ProtocolHandlers)
   6     COLUMN_NOT_NULL(app_id,             TEXT,)
   7     COLUMN_NOT_NULL(target,             TEXT,)
   8     COLUMN_NOT_NULL(base_url,       TEXT,)
   9     COLUMN_NOT_NULL(url,                TEXT,)
  10     COLUMN_NOT_NULL(title,          TEXT,)
  11     COLUMN_NOT_NULL(user_allowed,   INT,)
  12
  13     TABLE_CONSTRAINTS(
  14         PRIMARY KEY (app_id, target, base_url, url)
  15     )
  16 CREATE_TABLE_END()
  17
  18 CREATE_TABLE(ContentHandlers)
  19     COLUMN_NOT_NULL(app_id,             TEXT,)
  20     COLUMN_NOT_NULL(target,             TEXT,)
  21     COLUMN_NOT_NULL(base_url,       TEXT,)
  22     COLUMN_NOT_NULL(url,                TEXT,)
  23     COLUMN_NOT_NULL(title,          TEXT,)
  24     COLUMN_NOT_NULL(user_allowed,   INT,)
  25
  26     TABLE_CONSTRAINTS(
  27         PRIMARY KEY (app_id, target, base_url, url)
  28     )
  29 CREATE_TABLE_END()
  30
  31 SQL(
  32     COMMIT;
  33 )
  34