1# 2012 May 21 2# 3# The author disclaims copyright to this source code. In place of 4# a legal notice, here is a blessing: 5# 6# May you do good and not evil. 7# May you find forgiveness for yourself and forgive others. 8# May you share freely, never taking more than you give. 9# 10# NB: Portions of this file are extracted from open-source projects 11# covered by permissive licenses. Use of this file for testing is clearly 12# allowed. However, do not incorporate the text of this one file into 13# end-products without checking the licenses on the open-source projects 14# from which this code was extracted. This warning applies to this one 15# file only - not the bulk of the SQLite source code and tests. 16# 17#*********************************************************************** 18# 19# This file contains large and complex schemas obtained from open-source 20# software projects. The schemas are parsed just to make sure that nothing 21# breaks in the parser logic. 22# 23# These tests merely verify that the parse occurs without error. 24# No attempt is made to verify correct operation of the resulting schema 25# and statements. 26# 27 28set testdir [file dirname $argv0] 29source $testdir/tester.tcl 30 31# Schema and query extracted from Skrooge.org. 32# 33do_test fuzz-oss1-skrooge { 34 db eval { 35CREATE TABLE parameters (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_uuid_parent TEXT NOT NULL DEFAULT '',t_name TEXT NOT NULL,t_value TEXT NOT NULL DEFAULT '',b_blob BLOB,d_lastmodifdate DATE NOT NULL DEFAULT CURRENT_TIMESTAMP,i_tmp INTEGER NOT NULL DEFAULT 0); 36CREATE TABLE doctransaction (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL,t_mode VARCHAR(1) DEFAULT 'U' CHECK (t_mode IN ('U', 'R')),d_date DATE NOT NULL,t_savestep VARCHAR(1) DEFAULT 'N' CHECK (t_savestep IN ('Y', 'N')),i_parent INTEGER, t_refreshviews VARCHAR(1) DEFAULT 'Y' CHECK (t_refreshviews IN ('Y', 'N'))); 37CREATE TABLE doctransactionitem (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, rd_doctransaction_id INTEGER NOT NULL,i_object_id INTEGER NOT NULL,t_object_table TEXT NOT NULL,t_action VARCHAR(1) DEFAULT 'I' CHECK (t_action IN ('I', 'U', 'D')),t_sqlorder TEXT NOT NULL DEFAULT ''); 38CREATE TABLE doctransactionmsg (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, rd_doctransaction_id INTEGER NOT NULL,t_message TEXT NOT NULL DEFAULT '',t_popup VARCHAR(1) DEFAULT 'Y' CHECK (t_popup IN ('Y', 'N'))); 39CREATE TABLE unit(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL,t_symbol TEXT NOT NULL DEFAULT '',t_country TEXT NOT NULL DEFAULT '',t_type VARCHAR(1) NOT NULL DEFAULT 'C' CHECK (t_type IN ('1', '2', 'C', 'S', 'I', 'O')),t_internet_code TEXT NOT NULL DEFAULT '',i_nbdecimal INT NOT NULL DEFAULT 2,rd_unit_id INTEGER NOT NULL DEFAULT 0, t_source TEXT NOT NULL DEFAULT ''); 40CREATE TABLE unitvalue(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,rd_unit_id INTEGER NOT NULL,d_date DATE NOT NULL,f_quantity FLOAT NOT NULL CHECK (f_quantity>=0)); 41CREATE TABLE bank (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL DEFAULT '',t_bank_number TEXT NOT NULL DEFAULT '',t_icon TEXT NOT NULL DEFAULT ''); 42CREATE TABLE interest(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,rd_account_id INTEGER NOT NULL,d_date DATE NOT NULL,f_rate FLOAT NOT NULL CHECK (f_rate>=0),t_income_value_date_mode VARCHAR(1) NOT NULL DEFAULT 'F' CHECK (t_income_value_date_mode IN ('F', '0', '1', '2', '3', '4', '5')),t_expenditure_value_date_mode VARCHAR(1) NOT NULL DEFAULT 'F' CHECK (t_expenditure_value_date_mode IN ('F', '0', '1', '2', '3', '4', '5')),t_base VARCHAR(3) NOT NULL DEFAULT '24' CHECK (t_base IN ('24', '360', '365'))); 43CREATE TABLE operation(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,i_group_id INTEGER NOT NULL DEFAULT 0,i_number INTEGER DEFAULT 0 CHECK (i_number>=0),d_date DATE NOT NULL DEFAULT '0000-00-00',rd_account_id INTEGER NOT NULL,t_mode TEXT NOT NULL DEFAULT '',r_payee_id INTEGER NOT NULL DEFAULT 0,t_comment TEXT NOT NULL DEFAULT '',rc_unit_id INTEGER NOT NULL,t_status VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_status IN ('N', 'P', 'Y')),t_bookmarked VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_bookmarked IN ('Y', 'N')),t_imported VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_imported IN ('Y', 'N', 'P', 'T')),t_template VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_template IN ('Y', 'N')),t_import_id TEXT NOT NULL DEFAULT '',i_tmp INTEGER NOT NULL DEFAULT 0,r_recurrentoperation_id INTEGER NOT NULL DEFAULT 0); 44CREATE TABLE operationbalance(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,f_balance FLOAT NOT NULL DEFAULT 0,r_operation_id INTEGER NOT NULL); 45CREATE TABLE refund (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL DEFAULT '',t_comment TEXT NOT NULL DEFAULT '',t_close VARCHAR(1) DEFAULT 'N' CHECK (t_close IN ('Y', 'N'))); 46CREATE TABLE payee (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL DEFAULT '',t_address TEXT NOT NULL DEFAULT '', t_bookmarked VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_bookmarked IN ('Y', 'N'))); 47CREATE TABLE suboperation(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_comment TEXT NOT NULL DEFAULT '',rd_operation_id INTEGER NOT NULL,r_category_id INTEGER NOT NULL DEFAULT 0,f_value FLOAT NOT NULL DEFAULT 0.0,i_tmp INTEGER NOT NULL DEFAULT 0,r_refund_id INTEGER NOT NULL DEFAULT 0, t_formula TEXT NOT NULL DEFAULT ''); 48CREATE TABLE rule (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_description TEXT NOT NULL DEFAULT '',t_definition TEXT NOT NULL DEFAULT '',t_action_description TEXT NOT NULL DEFAULT '',t_action_definition TEXT NOT NULL DEFAULT '',t_action_type VARCHAR(1) DEFAULT 'S' CHECK (t_action_type IN ('S', 'U', 'A')),t_bookmarked VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_bookmarked IN ('Y', 'N')),f_sortorder FLOAT); 49CREATE TABLE budget (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,rc_category_id INTEGER NOT NULL DEFAULT 0,t_including_subcategories TEXT NOT NULL DEFAULT 'N' CHECK (t_including_subcategories IN ('Y', 'N')),f_budgeted FLOAT NOT NULL DEFAULT 0.0,f_budgeted_modified FLOAT NOT NULL DEFAULT 0.0,f_transferred FLOAT NOT NULL DEFAULT 0.0,i_year INTEGER NOT NULL DEFAULT 2010,i_month INTEGER NOT NULL DEFAULT 0 CHECK (i_month>=0 AND i_month<=12)); 50CREATE TABLE budgetcategory(id INTEGER NOT NULL DEFAULT 0,id_category INTEGER NOT NULL DEFAULT 0); 51CREATE TABLE budgetrule (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,rc_category_id INTEGER NOT NULL DEFAULT 0,t_category_condition TEXT NOT NULL DEFAULT 'Y' CHECK (t_category_condition IN ('Y', 'N')),t_year_condition TEXT NOT NULL DEFAULT 'Y' CHECK (t_year_condition IN ('Y', 'N')),i_year INTEGER NOT NULL DEFAULT 2010,i_month INTEGER NOT NULL DEFAULT 0 CHECK (i_month>=0 AND i_month<=12),t_month_condition TEXT NOT NULL DEFAULT 'Y' CHECK (t_month_condition IN ('Y', 'N')),i_condition INTEGER NOT NULL DEFAULT 0 CHECK (i_condition IN (-1,0,1)),f_quantity FLOAT NOT NULL DEFAULT 0.0,t_absolute TEXT NOT NULL DEFAULT 'Y' CHECK (t_absolute IN ('Y', 'N')),rc_category_id_target INTEGER NOT NULL DEFAULT 0,t_category_target TEXT NOT NULL DEFAULT 'Y' CHECK (t_category_target IN ('Y', 'N')),t_rule TEXT NOT NULL DEFAULT 'N' CHECK (t_rule IN ('N', 'C', 'Y'))); 52CREATE TABLE "recurrentoperation" (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,d_date DATE NOT NULL DEFAULT '0000-00-00',rd_operation_id INTEGER NOT NULL,i_period_increment INTEGER NOT NULL DEFAULT 1 CHECK (i_period_increment>=0),t_period_unit TEXT NOT NULL DEFAULT 'M' CHECK (t_period_unit IN ('D', 'W', 'M', 'Y')),t_auto_write VARCHAR(1) DEFAULT 'Y' CHECK (t_auto_write IN ('Y', 'N')),i_auto_write_days INTEGER NOT NULL DEFAULT 5 CHECK (i_auto_write_days>=0),t_warn VARCHAR(1) DEFAULT 'Y' CHECK (t_warn IN ('Y', 'N')),i_warn_days INTEGER NOT NULL DEFAULT 5 CHECK (i_warn_days>=0),t_times VARCHAR(1) DEFAULT 'N' CHECK (t_times IN ('Y', 'N')),i_nb_times INTEGER NOT NULL DEFAULT 1 CHECK (i_nb_times>=0)); 53CREATE TABLE "category" (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL DEFAULT '' CHECK (t_name NOT LIKE '% > %'),t_fullname TEXT,rd_category_id INT,t_bookmarked VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_bookmarked IN ('Y', 'N'))); 54CREATE TABLE "account"(id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL,t_number TEXT NOT NULL DEFAULT '',t_agency_number TEXT NOT NULL DEFAULT '',t_agency_address TEXT NOT NULL DEFAULT '',t_comment TEXT NOT NULL DEFAULT '',t_close VARCHAR(1) DEFAULT 'N' CHECK (t_close IN ('Y', 'N')),t_type VARCHAR(1) NOT NULL DEFAULT 'C' CHECK (t_type IN ('C', 'D', 'A', 'I', 'L', 'W', 'O')),t_bookmarked VARCHAR(1) NOT NULL DEFAULT 'N' CHECK (t_bookmarked IN ('Y', 'N')),rd_bank_id INTEGER NOT NULL); 55CREATE TABLE "node" (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,t_name TEXT NOT NULL DEFAULT '' CHECK (t_name NOT LIKE '% > %'),t_fullname TEXT,t_icon TEXT DEFAULT '',f_sortorder FLOAT,t_autostart VARCHAR(1) DEFAULT 'N' CHECK (t_autostart IN ('Y', 'N')),t_data TEXT,rd_node_id INT CONSTRAINT fk_id REFERENCES node(id) ON DELETE CASCADE); 56CREATE TABLE vm_category_display_tmp( 57 id INT, 58 t_name TEXT, 59 t_fullname TEXT, 60 rd_category_id INT, 61 t_bookmarked TEXT, 62 i_NBOPERATIONS, 63 f_REALCURRENTAMOUNT 64); 65CREATE TABLE vm_budget_tmp( 66 id INT, 67 rc_category_id INT, 68 t_including_subcategories TEXT, 69 f_budgeted REAL, 70 f_budgeted_modified REAL, 71 f_transferred REAL, 72 i_year INT, 73 i_month INT, 74 t_CATEGORY, 75 t_PERIOD, 76 f_CURRENTAMOUNT, 77 t_RULES 78); 79CREATE INDEX idx_doctransaction_parent ON doctransaction (i_parent); 80CREATE INDEX idx_doctransactionitem_i_object_id ON doctransactionitem (i_object_id); 81CREATE INDEX idx_doctransactionitem_t_object_table ON doctransactionitem (t_object_table); 82CREATE INDEX idx_doctransactionitem_t_action ON doctransactionitem (t_action); 83CREATE INDEX idx_doctransactionitem_rd_doctransaction_id ON doctransactionitem (rd_doctransaction_id); 84CREATE INDEX idx_doctransactionitem_optimization ON doctransactionitem (rd_doctransaction_id, i_object_id, t_object_table, t_action, id); 85CREATE INDEX idx_unit_unit_id ON unitvalue(rd_unit_id); 86CREATE INDEX idx_account_bank_id ON account(rd_bank_id); 87CREATE INDEX idx_account_type ON account(t_type); 88CREATE INDEX idx_category_category_id ON category(rd_category_id); 89CREATE INDEX idx_category_t_fullname ON category(t_fullname); 90CREATE INDEX idx_operation_account_id ON operation (rd_account_id); 91CREATE INDEX idx_operation_tmp1_found_transfert ON operation (rc_unit_id, d_date); 92CREATE INDEX idx_operation_grouped_operation_id ON operation (i_group_id); 93CREATE INDEX idx_operation_i_number ON operation (i_number); 94CREATE INDEX idx_operation_i_tmp ON operation (i_tmp); 95CREATE INDEX idx_operation_rd_account_id ON operation (rd_account_id); 96CREATE INDEX idx_operation_rc_unit_id ON operation (rc_unit_id); 97CREATE INDEX idx_operation_t_status ON operation (t_status); 98CREATE INDEX idx_operation_t_import_id ON operation (t_import_id); 99CREATE INDEX idx_operation_t_template ON operation (t_template); 100CREATE INDEX idx_operation_d_date ON operation (d_date); 101CREATE INDEX idx_operationbalance_operation_id ON operationbalance (r_operation_id); 102CREATE INDEX idx_suboperation_operation_id ON suboperation (rd_operation_id); 103CREATE INDEX idx_suboperation_i_tmp ON suboperation (i_tmp); 104CREATE INDEX idx_suboperation_category_id ON suboperation (r_category_id); 105CREATE INDEX idx_suboperation_refund_id_id ON suboperation (r_refund_id); 106CREATE INDEX idx_recurrentoperation_rd_operation_id ON recurrentoperation (rd_operation_id); 107CREATE INDEX idx_refund_close ON refund(t_close); 108CREATE INDEX idx_interest_account_id ON interest (rd_account_id); 109CREATE INDEX idx_rule_action_type ON rule(t_action_type); 110CREATE INDEX idx_budget_category_id ON budget(rc_category_id); 111CREATE INDEX idx_budgetcategory_id ON budgetcategory (id); 112CREATE INDEX idx_budgetcategory_id_category ON budgetcategory (id_category); 113CREATE UNIQUE INDEX uidx_parameters_uuid_parent_name ON parameters (t_uuid_parent, t_name); 114CREATE UNIQUE INDEX uidx_node_parent_id_name ON node(t_name,rd_node_id); 115CREATE UNIQUE INDEX uidx_node_fullname ON node(t_fullname); 116CREATE UNIQUE INDEX uidx_unit_name ON unit(t_name); 117CREATE UNIQUE INDEX uidx_unit_symbol ON unit(t_symbol); 118CREATE UNIQUE INDEX uidx_unitvalue ON unitvalue(d_date,rd_unit_id); 119CREATE UNIQUE INDEX uidx_bank_name ON bank(t_name); 120CREATE UNIQUE INDEX uidx_account_name ON account(t_name); 121CREATE UNIQUE INDEX uidx_category_parent_id_name ON category(t_name,rd_category_id); 122CREATE UNIQUE INDEX uidx_category_fullname ON category(t_fullname); 123CREATE UNIQUE INDEX uidx_refund_name ON refund(t_name); 124CREATE UNIQUE INDEX uidx_payee_name ON payee(t_name); 125CREATE UNIQUE INDEX uidx_interest ON interest(d_date,rd_account_id); 126CREATE UNIQUE INDEX uidx_budget ON budget(i_year,i_month, rc_category_id); 127CREATE VIEW v_node AS SELECT * from node; 128CREATE VIEW v_node_displayname AS SELECT *, t_fullname AS t_displayname from node; 129CREATE VIEW v_parameters_displayname AS SELECT *, t_name AS t_displayname from parameters; 130CREATE TRIGGER fkdc_parameters_parameters_uuid BEFORE DELETE ON parameters FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'parameters'; END; 131CREATE TRIGGER fkdc_node_parameters_uuid BEFORE DELETE ON node FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'node'; END; 132CREATE TRIGGER cpt_node_fullname1 AFTER INSERT ON node BEGIN UPDATE node SET t_fullname=CASE WHEN new.rd_node_id IS NULL OR new.rd_node_id='' OR new.rd_node_id=0 THEN new.t_name ELSE (SELECT c.t_fullname from node c where c.id=new.rd_node_id)||' > '||new.t_name END WHERE id=new.id;END; 133CREATE TRIGGER cpt_node_fullname2 AFTER UPDATE OF t_name, rd_node_id ON node BEGIN UPDATE node SET t_fullname=CASE WHEN new.rd_node_id IS NULL OR new.rd_node_id='' OR new.rd_node_id=0 THEN new.t_name ELSE (SELECT c.t_fullname from node c where c.id=new.rd_node_id)||' > '||new.t_name END WHERE id=new.id;UPDATE node SET t_name=t_name WHERE rd_node_id=new.id;END; 134CREATE TRIGGER fki_account_bank_rd_bank_id_id BEFORE INSERT ON account FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (bank est utilisé par account) 135Nom de la contrainte : fki_account_bank_rd_bank_id_id') WHERE NEW.rd_bank_id!=0 AND NEW.rd_bank_id!='' AND (SELECT id FROM bank WHERE id = NEW.rd_bank_id) IS NULL; END; 136CREATE TRIGGER fku_account_bank_rd_bank_id_id BEFORE UPDATE ON account FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (bank est utilisé par account) 137Nom de la contrainte : fku_account_bank_rd_bank_id_id') WHERE NEW.rd_bank_id!=0 AND NEW.rd_bank_id!='' AND (SELECT id FROM bank WHERE id = NEW.rd_bank_id) IS NULL; END; 138CREATE TRIGGER fkdc_bank_account_id_rd_bank_id BEFORE DELETE ON bank FOR EACH ROW BEGIN DELETE FROM account WHERE account.rd_bank_id = OLD.id; END; 139CREATE TRIGGER fki_budget_category_rc_category_id_id BEFORE INSERT ON budget FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (category est utilisé par budget) 140Nom de la contrainte : fki_budget_category_rc_category_id_id') WHERE NEW.rc_category_id!=0 AND NEW.rc_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id) IS NULL; END; 141CREATE TRIGGER fku_budget_category_rc_category_id_id BEFORE UPDATE ON budget FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (category est utilisé par budget) 142Nom de la contrainte : fku_budget_category_rc_category_id_id') WHERE NEW.rc_category_id!=0 AND NEW.rc_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id) IS NULL; END; 143CREATE TRIGGER fkd_budget_category_rc_category_id_id BEFORE DELETE ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de détruire un objet (category est utilisé par budget) 144Nom de la contrainte : fkd_budget_category_rc_category_id_id') WHERE (SELECT rc_category_id FROM budget WHERE rc_category_id = OLD.id) IS NOT NULL; END; 145CREATE TRIGGER fki_budgetrule_category_rc_category_id_id BEFORE INSERT ON budgetrule FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (category est utilisé par budgetrule) 146Nom de la contrainte : fki_budgetrule_category_rc_category_id_id') WHERE NEW.rc_category_id!=0 AND NEW.rc_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id) IS NULL; END; 147CREATE TRIGGER fku_budgetrule_category_rc_category_id_id BEFORE UPDATE ON budgetrule FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (category est utilisé par budgetrule) 148Nom de la contrainte : fku_budgetrule_category_rc_category_id_id') WHERE NEW.rc_category_id!=0 AND NEW.rc_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id) IS NULL; END; 149CREATE TRIGGER fkd_budgetrule_category_rc_category_id_id BEFORE DELETE ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de détruire un objet (category est utilisé par budgetrule) 150Nom de la contrainte : fkd_budgetrule_category_rc_category_id_id') WHERE (SELECT rc_category_id FROM budgetrule WHERE rc_category_id = OLD.id) IS NOT NULL; END; 151CREATE TRIGGER fki_budgetrule_category_rc_category_id_target_id BEFORE INSERT ON budgetrule FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (category est utilisé par budgetrule) 152Nom de la contrainte : fki_budgetrule_category_rc_category_id_target_id') WHERE NEW.rc_category_id_target!=0 AND NEW.rc_category_id_target!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id_target) IS NULL; END; 153CREATE TRIGGER fku_budgetrule_category_rc_category_id_target_id BEFORE UPDATE ON budgetrule FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (category est utilisé par budgetrule) 154Nom de la contrainte : fku_budgetrule_category_rc_category_id_target_id') WHERE NEW.rc_category_id_target!=0 AND NEW.rc_category_id_target!='' AND (SELECT id FROM category WHERE id = NEW.rc_category_id_target) IS NULL; END; 155CREATE TRIGGER fkd_budgetrule_category_rc_category_id_target_id BEFORE DELETE ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de détruire un objet (category est utilisé par budgetrule) 156Nom de la contrainte : fkd_budgetrule_category_rc_category_id_target_id') WHERE (SELECT rc_category_id_target FROM budgetrule WHERE rc_category_id_target = OLD.id) IS NOT NULL; END; 157CREATE TRIGGER fki_category_category_rd_category_id_id BEFORE INSERT ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (category est utilisé par category) 158Nom de la contrainte : fki_category_category_rd_category_id_id') WHERE NEW.rd_category_id!=0 AND NEW.rd_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rd_category_id) IS NULL; END; 159CREATE TRIGGER fku_category_category_rd_category_id_id BEFORE UPDATE ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (category est utilisé par category) 160Nom de la contrainte : fku_category_category_rd_category_id_id') WHERE NEW.rd_category_id!=0 AND NEW.rd_category_id!='' AND (SELECT id FROM category WHERE id = NEW.rd_category_id) IS NULL; END; 161CREATE TRIGGER fkdc_category_category_id_rd_category_id BEFORE DELETE ON category FOR EACH ROW BEGIN DELETE FROM category WHERE category.rd_category_id = OLD.id; END; 162CREATE TRIGGER fki_doctransactionitem_doctransaction_rd_doctransaction_id_id BEFORE INSERT ON doctransactionitem FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (doctransaction est utilisé par doctransactionitem) 163Nom de la contrainte : fki_doctransactionitem_doctransaction_rd_doctransaction_id_id') WHERE NEW.rd_doctransaction_id!=0 AND NEW.rd_doctransaction_id!='' AND (SELECT id FROM doctransaction WHERE id = NEW.rd_doctransaction_id) IS NULL; END; 164CREATE TRIGGER fku_doctransactionitem_doctransaction_rd_doctransaction_id_id BEFORE UPDATE ON doctransactionitem FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (doctransaction est utilisé par doctransactionitem) 165Nom de la contrainte : fku_doctransactionitem_doctransaction_rd_doctransaction_id_id') WHERE NEW.rd_doctransaction_id!=0 AND NEW.rd_doctransaction_id!='' AND (SELECT id FROM doctransaction WHERE id = NEW.rd_doctransaction_id) IS NULL; END; 166CREATE TRIGGER fkdc_doctransaction_doctransactionitem_id_rd_doctransaction_id BEFORE DELETE ON doctransaction FOR EACH ROW BEGIN DELETE FROM doctransactionitem WHERE doctransactionitem.rd_doctransaction_id = OLD.id; END; 167CREATE TRIGGER fki_doctransactionmsg_doctransaction_rd_doctransaction_id_id BEFORE INSERT ON doctransactionmsg FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (doctransaction est utilisé par doctransactionmsg) 168Nom de la contrainte : fki_doctransactionmsg_doctransaction_rd_doctransaction_id_id') WHERE NEW.rd_doctransaction_id!=0 AND NEW.rd_doctransaction_id!='' AND (SELECT id FROM doctransaction WHERE id = NEW.rd_doctransaction_id) IS NULL; END; 169CREATE TRIGGER fku_doctransactionmsg_doctransaction_rd_doctransaction_id_id BEFORE UPDATE ON doctransactionmsg FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (doctransaction est utilisé par doctransactionmsg) 170Nom de la contrainte : fku_doctransactionmsg_doctransaction_rd_doctransaction_id_id') WHERE NEW.rd_doctransaction_id!=0 AND NEW.rd_doctransaction_id!='' AND (SELECT id FROM doctransaction WHERE id = NEW.rd_doctransaction_id) IS NULL; END; 171CREATE TRIGGER fkdc_doctransaction_doctransactionmsg_id_rd_doctransaction_id BEFORE DELETE ON doctransaction FOR EACH ROW BEGIN DELETE FROM doctransactionmsg WHERE doctransactionmsg.rd_doctransaction_id = OLD.id; END; 172CREATE TRIGGER fki_interest_account_rd_account_id_id BEFORE INSERT ON interest FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (account est utilisé par interest) 173Nom de la contrainte : fki_interest_account_rd_account_id_id') WHERE NEW.rd_account_id!=0 AND NEW.rd_account_id!='' AND (SELECT id FROM account WHERE id = NEW.rd_account_id) IS NULL; END; 174CREATE TRIGGER fku_interest_account_rd_account_id_id BEFORE UPDATE ON interest FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (account est utilisé par interest) 175Nom de la contrainte : fku_interest_account_rd_account_id_id') WHERE NEW.rd_account_id!=0 AND NEW.rd_account_id!='' AND (SELECT id FROM account WHERE id = NEW.rd_account_id) IS NULL; END; 176CREATE TRIGGER fkdc_account_interest_id_rd_account_id BEFORE DELETE ON account FOR EACH ROW BEGIN DELETE FROM interest WHERE interest.rd_account_id = OLD.id; END; 177CREATE TRIGGER fki_node_node_rd_node_id_id BEFORE INSERT ON node FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (node est utilisé par node) 178Nom de la contrainte : fki_node_node_rd_node_id_id') WHERE NEW.rd_node_id!=0 AND NEW.rd_node_id!='' AND (SELECT id FROM node WHERE id = NEW.rd_node_id) IS NULL; END; 179CREATE TRIGGER fku_node_node_rd_node_id_id BEFORE UPDATE ON node FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (node est utilisé par node) 180Nom de la contrainte : fku_node_node_rd_node_id_id') WHERE NEW.rd_node_id!=0 AND NEW.rd_node_id!='' AND (SELECT id FROM node WHERE id = NEW.rd_node_id) IS NULL; END; 181CREATE TRIGGER fkdc_node_node_id_rd_node_id BEFORE DELETE ON node FOR EACH ROW BEGIN DELETE FROM node WHERE node.rd_node_id = OLD.id; END; 182CREATE TRIGGER fki_operation_account_rd_account_id_id BEFORE INSERT ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (account est utilisé par operation) 183Nom de la contrainte : fki_operation_account_rd_account_id_id') WHERE NEW.rd_account_id!=0 AND NEW.rd_account_id!='' AND (SELECT id FROM account WHERE id = NEW.rd_account_id) IS NULL; END; 184CREATE TRIGGER fku_operation_account_rd_account_id_id BEFORE UPDATE ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (account est utilisé par operation) 185Nom de la contrainte : fku_operation_account_rd_account_id_id') WHERE NEW.rd_account_id!=0 AND NEW.rd_account_id!='' AND (SELECT id FROM account WHERE id = NEW.rd_account_id) IS NULL; END; 186CREATE TRIGGER fkdc_account_operation_id_rd_account_id BEFORE DELETE ON account FOR EACH ROW BEGIN DELETE FROM operation WHERE operation.rd_account_id = OLD.id; END; 187CREATE TRIGGER fki_operation_payee_r_payee_id_id BEFORE INSERT ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (payee est utilisé par operation) 188Nom de la contrainte : fki_operation_payee_r_payee_id_id') WHERE NEW.r_payee_id!=0 AND NEW.r_payee_id!='' AND (SELECT id FROM payee WHERE id = NEW.r_payee_id) IS NULL; END; 189CREATE TRIGGER fku_operation_payee_r_payee_id_id BEFORE UPDATE ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (payee est utilisé par operation) 190Nom de la contrainte : fku_operation_payee_r_payee_id_id') WHERE NEW.r_payee_id!=0 AND NEW.r_payee_id!='' AND (SELECT id FROM payee WHERE id = NEW.r_payee_id) IS NULL; END; 191CREATE TRIGGER fkd_operation_payee_r_payee_id_id BEFORE DELETE ON payee FOR EACH ROW BEGIN UPDATE operation SET r_payee_id=0 WHERE r_payee_id=OLD.id; END; 192CREATE TRIGGER fki_operation_unit_rc_unit_id_id BEFORE INSERT ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (unit est utilisé par operation) 193Nom de la contrainte : fki_operation_unit_rc_unit_id_id') WHERE NEW.rc_unit_id!=0 AND NEW.rc_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rc_unit_id) IS NULL; END; 194CREATE TRIGGER fku_operation_unit_rc_unit_id_id BEFORE UPDATE ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (unit est utilisé par operation) 195Nom de la contrainte : fku_operation_unit_rc_unit_id_id') WHERE NEW.rc_unit_id!=0 AND NEW.rc_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rc_unit_id) IS NULL; END; 196CREATE TRIGGER fkd_operation_unit_rc_unit_id_id BEFORE DELETE ON unit FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de détruire un objet (unit est utilisé par operation) 197Nom de la contrainte : fkd_operation_unit_rc_unit_id_id') WHERE (SELECT rc_unit_id FROM operation WHERE rc_unit_id = OLD.id) IS NOT NULL; END; 198CREATE TRIGGER fki_operation_recurrentoperation_r_recurrentoperation_id_id BEFORE INSERT ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (recurrentoperation est utilisé par operation) 199Nom de la contrainte : fki_operation_recurrentoperation_r_recurrentoperation_id_id') WHERE NEW.r_recurrentoperation_id!=0 AND NEW.r_recurrentoperation_id!='' AND (SELECT id FROM recurrentoperation WHERE id = NEW.r_recurrentoperation_id) IS NULL; END; 200CREATE TRIGGER fku_operation_recurrentoperation_r_recurrentoperation_id_id BEFORE UPDATE ON operation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (recurrentoperation est utilisé par operation) 201Nom de la contrainte : fku_operation_recurrentoperation_r_recurrentoperation_id_id') WHERE NEW.r_recurrentoperation_id!=0 AND NEW.r_recurrentoperation_id!='' AND (SELECT id FROM recurrentoperation WHERE id = NEW.r_recurrentoperation_id) IS NULL; END; 202CREATE TRIGGER fkd_operation_recurrentoperation_r_recurrentoperation_id_id BEFORE DELETE ON recurrentoperation FOR EACH ROW BEGIN UPDATE operation SET r_recurrentoperation_id=0 WHERE r_recurrentoperation_id=OLD.id; END; 203CREATE TRIGGER fki_operationbalance_operation_r_operation_id_id BEFORE INSERT ON operationbalance FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (operation est utilisé par operationbalance) 204Nom de la contrainte : fki_operationbalance_operation_r_operation_id_id') WHERE NEW.r_operation_id!=0 AND NEW.r_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.r_operation_id) IS NULL; END; 205CREATE TRIGGER fku_operationbalance_operation_r_operation_id_id BEFORE UPDATE ON operationbalance FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (operation est utilisé par operationbalance) 206Nom de la contrainte : fku_operationbalance_operation_r_operation_id_id') WHERE NEW.r_operation_id!=0 AND NEW.r_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.r_operation_id) IS NULL; END; 207CREATE TRIGGER fkd_operationbalance_operation_r_operation_id_id BEFORE DELETE ON operation FOR EACH ROW BEGIN UPDATE operationbalance SET r_operation_id=0 WHERE r_operation_id=OLD.id; END; 208CREATE TRIGGER fki_recurrentoperation_operation_rd_operation_id_id BEFORE INSERT ON recurrentoperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (operation est utilisé par recurrentoperation) 209Nom de la contrainte : fki_recurrentoperation_operation_rd_operation_id_id') WHERE NEW.rd_operation_id!=0 AND NEW.rd_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.rd_operation_id) IS NULL; END; 210CREATE TRIGGER fku_recurrentoperation_operation_rd_operation_id_id BEFORE UPDATE ON recurrentoperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (operation est utilisé par recurrentoperation) 211Nom de la contrainte : fku_recurrentoperation_operation_rd_operation_id_id') WHERE NEW.rd_operation_id!=0 AND NEW.rd_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.rd_operation_id) IS NULL; END; 212CREATE TRIGGER fkdc_operation_recurrentoperation_id_rd_operation_id BEFORE DELETE ON operation FOR EACH ROW BEGIN DELETE FROM recurrentoperation WHERE recurrentoperation.rd_operation_id = OLD.id; END; 213CREATE TRIGGER fki_suboperation_operation_rd_operation_id_id BEFORE INSERT ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (operation est utilisé par suboperation) 214Nom de la contrainte : fki_suboperation_operation_rd_operation_id_id') WHERE NEW.rd_operation_id!=0 AND NEW.rd_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.rd_operation_id) IS NULL; END; 215CREATE TRIGGER fku_suboperation_operation_rd_operation_id_id BEFORE UPDATE ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (operation est utilisé par suboperation) 216Nom de la contrainte : fku_suboperation_operation_rd_operation_id_id') WHERE NEW.rd_operation_id!=0 AND NEW.rd_operation_id!='' AND (SELECT id FROM operation WHERE id = NEW.rd_operation_id) IS NULL; END; 217CREATE TRIGGER fkdc_operation_suboperation_id_rd_operation_id BEFORE DELETE ON operation FOR EACH ROW BEGIN DELETE FROM suboperation WHERE suboperation.rd_operation_id = OLD.id; END; 218CREATE TRIGGER fki_suboperation_category_r_category_id_id BEFORE INSERT ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (category est utilisé par suboperation) 219Nom de la contrainte : fki_suboperation_category_r_category_id_id') WHERE NEW.r_category_id!=0 AND NEW.r_category_id!='' AND (SELECT id FROM category WHERE id = NEW.r_category_id) IS NULL; END; 220CREATE TRIGGER fku_suboperation_category_r_category_id_id BEFORE UPDATE ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (category est utilisé par suboperation) 221Nom de la contrainte : fku_suboperation_category_r_category_id_id') WHERE NEW.r_category_id!=0 AND NEW.r_category_id!='' AND (SELECT id FROM category WHERE id = NEW.r_category_id) IS NULL; END; 222CREATE TRIGGER fkd_suboperation_category_r_category_id_id BEFORE DELETE ON category FOR EACH ROW BEGIN UPDATE suboperation SET r_category_id=0 WHERE r_category_id=OLD.id; END; 223CREATE TRIGGER fki_suboperation_refund_r_refund_id_id BEFORE INSERT ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (refund est utilisé par suboperation) 224Nom de la contrainte : fki_suboperation_refund_r_refund_id_id') WHERE NEW.r_refund_id!=0 AND NEW.r_refund_id!='' AND (SELECT id FROM refund WHERE id = NEW.r_refund_id) IS NULL; END; 225CREATE TRIGGER fku_suboperation_refund_r_refund_id_id BEFORE UPDATE ON suboperation FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (refund est utilisé par suboperation) 226Nom de la contrainte : fku_suboperation_refund_r_refund_id_id') WHERE NEW.r_refund_id!=0 AND NEW.r_refund_id!='' AND (SELECT id FROM refund WHERE id = NEW.r_refund_id) IS NULL; END; 227CREATE TRIGGER fkd_suboperation_refund_r_refund_id_id BEFORE DELETE ON refund FOR EACH ROW BEGIN UPDATE suboperation SET r_refund_id=0 WHERE r_refund_id=OLD.id; END; 228CREATE TRIGGER fki_unit_unit_rd_unit_id_id BEFORE INSERT ON unit FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (unit est utilisé par unit) 229Nom de la contrainte : fki_unit_unit_rd_unit_id_id') WHERE NEW.rd_unit_id!=0 AND NEW.rd_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rd_unit_id) IS NULL; END; 230CREATE TRIGGER fku_unit_unit_rd_unit_id_id BEFORE UPDATE ON unit FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (unit est utilisé par unit) 231Nom de la contrainte : fku_unit_unit_rd_unit_id_id') WHERE NEW.rd_unit_id!=0 AND NEW.rd_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rd_unit_id) IS NULL; END; 232CREATE TRIGGER fkdc_unit_unit_id_rd_unit_id BEFORE DELETE ON unit FOR EACH ROW BEGIN DELETE FROM unit WHERE unit.rd_unit_id = OLD.id; END; 233CREATE TRIGGER fki_unitvalue_unit_rd_unit_id_id BEFORE INSERT ON unitvalue FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible d''ajouter un objet (unit est utilisé par unitvalue) 234Nom de la contrainte : fki_unitvalue_unit_rd_unit_id_id') WHERE NEW.rd_unit_id!=0 AND NEW.rd_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rd_unit_id) IS NULL; END; 235CREATE TRIGGER fku_unitvalue_unit_rd_unit_id_id BEFORE UPDATE ON unitvalue FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de modifier un objet (unit est utilisé par unitvalue) 236Nom de la contrainte : fku_unitvalue_unit_rd_unit_id_id') WHERE NEW.rd_unit_id!=0 AND NEW.rd_unit_id!='' AND (SELECT id FROM unit WHERE id = NEW.rd_unit_id) IS NULL; END; 237CREATE TRIGGER fkdc_unit_unitvalue_id_rd_unit_id BEFORE DELETE ON unit FOR EACH ROW BEGIN DELETE FROM unitvalue WHERE unitvalue.rd_unit_id = OLD.id; END; 238CREATE TRIGGER fkd_vm_budget_tmp_category_rc_category_id_id BEFORE DELETE ON category FOR EACH ROW BEGIN SELECT RAISE(ABORT, 'Impossible de détruire un objet (category est utilisé par vm_budget_tmp) 239Nom de la contrainte : fkd_vm_budget_tmp_category_rc_category_id_id') WHERE (SELECT rc_category_id FROM vm_budget_tmp WHERE rc_category_id = OLD.id) IS NOT NULL; END; 240CREATE TRIGGER fkdc_category_vm_category_display_tmp_id_rd_category_id BEFORE DELETE ON category FOR EACH ROW BEGIN DELETE FROM vm_category_display_tmp WHERE vm_category_display_tmp.rd_category_id = OLD.id; END; 241CREATE VIEW v_unit_displayname AS SELECT *, t_name||' ('||t_symbol||')' AS t_displayname FROM unit; 242CREATE VIEW v_unit_tmp1 AS SELECT *,(SELECT count(*) FROM unitvalue s WHERE s.rd_unit_id=unit.id) AS i_NBVALUES, (CASE WHEN unit.rd_unit_id=0 THEN '' ELSE (SELECT (CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.t_name END) FROM unit s WHERE s.id=unit.rd_unit_id) END) AS t_UNIT,(CASE unit.t_type WHEN '1' THEN 'Monnaie principale' WHEN '2' THEN 'Monnaie secondaire' WHEN 'C' THEN 'Monnaie' WHEN 'S' THEN 'Action' WHEN 'I' THEN 'Indice' ELSE 'Objet' END) AS t_TYPENLS, (SELECT MIN(s.d_date) FROM unitvalue s WHERE s.rd_unit_id=unit.id) AS d_MINDATE, (SELECT MAX(s.d_date) FROM unitvalue s WHERE s.rd_unit_id=unit.id) AS d_MAXDATE from unit; 243CREATE VIEW v_unit_tmp2 AS SELECT *,CASE WHEN v_unit_tmp1.t_type='1' THEN 1 ELSE IFNULL((SELECT s.f_quantity FROM unitvalue s WHERE s.rd_unit_id=v_unit_tmp1.id AND s.d_date=v_unit_tmp1.d_MAXDATE),1) END AS f_LASTVALUE from v_unit_tmp1; 244CREATE VIEW v_unit AS SELECT *,v_unit_tmp2.f_LASTVALUE*IFNULL((SELECT s2.f_LASTVALUE FROM v_unit_tmp2 s2 WHERE s2.id=v_unit_tmp2.rd_unit_id) , 1) AS f_CURRENTAMOUNT from v_unit_tmp2; 245CREATE VIEW v_unitvalue_displayname AS SELECT *, (SELECT t_displayname FROM v_unit_displayname WHERE unitvalue.rd_unit_id=v_unit_displayname.id)||' '||STRFTIME('%d/%m/%Y',d_date) AS t_displayname FROM unitvalue; 246CREATE VIEW v_unitvalue AS SELECT * FROM unitvalue; 247CREATE VIEW v_suboperation AS SELECT * FROM suboperation; 248CREATE VIEW v_operation_numbers AS SELECT DISTINCT i_number, rd_account_id FROM operation; 249CREATE VIEW v_operation_next_numbers AS SELECT T1.i_number+1 AS i_number FROM v_operation_numbers AS T1 LEFT OUTER JOIN v_operation_numbers T2 ON T2.rd_account_id=T1.rd_account_id AND T2.i_number=T1.i_number+1 WHERE T1.i_number!=0 AND (T2.i_number IS NULL) ORDER BY T1.i_number; 250CREATE VIEW v_operation_tmp1 AS SELECT *,(SELECT t_name FROM payee s WHERE s.id=operation.r_payee_id) AS t_PAYEE,(SELECT TOTAL(s.f_value) FROM suboperation s WHERE s.rd_operation_id=operation.ID) AS f_QUANTITY,(SELECT count(*) FROM suboperation s WHERE s.rd_operation_id=operation.ID) AS i_NBSUBCATEGORY FROM operation; 251CREATE VIEW v_operation AS SELECT *,(SELECT s.id FROM suboperation s WHERE s.rd_operation_id=v_operation_tmp1.id AND ABS(s.f_value)=(SELECT MAX(ABS(s2.f_value)) FROM suboperation s2 WHERE s2.rd_operation_id=v_operation_tmp1.id)) AS i_MOSTIMPSUBOP,((SELECT s.f_CURRENTAMOUNT FROM v_unit s WHERE s.id=v_operation_tmp1.rc_unit_id)*v_operation_tmp1.f_QUANTITY) AS f_CURRENTAMOUNT, (CASE WHEN v_operation_tmp1.i_group_id<>0 AND EXISTS (SELECT 1 FROM account a WHERE v_operation_tmp1.rd_account_id=a.id AND a.t_type<>'L') AND EXISTS (SELECT 1 FROM v_operation_tmp1 op2, account a WHERE op2.i_group_id=v_operation_tmp1.i_group_id AND op2.rd_account_id=a.id AND a.t_type<>'L' AND op2.rc_unit_id=v_operation_tmp1.rc_unit_id AND op2.f_QUANTITY=-v_operation_tmp1.f_QUANTITY) THEN 'Y' ELSE 'N' END) AS t_TRANSFER FROM v_operation_tmp1; 252CREATE VIEW v_operation_displayname AS SELECT *, STRFTIME('%d/%m/%Y',d_date)||' '||IFNULL(t_PAYEE,'')||' '||v_operation.f_CURRENTAMOUNT||' '||(SELECT (CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.t_name END) FROM unit s WHERE s.id=v_operation.rc_unit_id) AS t_displayname FROM v_operation; 253CREATE VIEW v_operation_delete AS SELECT *, (CASE WHEN t_status='Y' THEN 'Vous n''êtes pas autorisé à détruire cette opération car en état « rapproché »' END) t_delete_message FROM operation; 254CREATE VIEW v_account AS SELECT *,(SELECT MAX(s.d_date) FROM interest s WHERE s.rd_account_id=account.id) AS d_MAXDATE, (SELECT TOTAL(s.f_CURRENTAMOUNT) FROM v_operation s WHERE s.rd_account_id=account.id AND s.t_template='N') AS f_CURRENTAMOUNT FROM account; 255CREATE VIEW v_account_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM operation WHERE rd_account_id=account.id AND d_date<>'0000-00-00' AND t_template='N' AND t_status='Y') THEN 'Vous n''êtes pas autorisé à détruire ce compte car il contient des opérations rapprochées' END) t_delete_message FROM account; 256CREATE VIEW v_bank_displayname AS SELECT *, t_name AS t_displayname FROM bank; 257CREATE VIEW v_account_displayname AS SELECT *, (SELECT t_displayname FROM v_bank_displayname WHERE account.rd_bank_id=v_bank_displayname.id)||'-'||t_name AS t_displayname FROM account; 258CREATE VIEW v_bank AS SELECT *,(SELECT TOTAL(s.f_CURRENTAMOUNT) FROM v_account s WHERE s.rd_bank_id=bank.id) AS f_CURRENTAMOUNT FROM bank; 259CREATE VIEW v_category_displayname AS SELECT *, t_fullname AS t_displayname FROM category; 260CREATE VIEW v_category AS SELECT * FROM category; 261CREATE VIEW v_recurrentoperation AS SELECT *,i_period_increment||' '||(CASE t_period_unit WHEN 'Y' THEN 'année(s)' WHEN 'M' THEN 'mois' WHEN 'W' THEN 'semaine(s)' ELSE 'jour(s)' END) AS t_PERIODNLS FROM recurrentoperation; 262CREATE VIEW v_recurrentoperation_displayname AS SELECT *, STRFTIME('%d/%m/%Y',d_date)||' '||SUBSTR((SELECT t_displayname FROM v_operation_displayname WHERE v_operation_displayname.id=v_recurrentoperation.rd_operation_id), 11) AS t_displayname FROM v_recurrentoperation; 263CREATE VIEW v_unitvalue_display AS SELECT *,IFNULL((SELECT (CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.t_name END) FROM unit s WHERE s.id=(SELECT s2.rd_unit_id FROM unit s2 WHERE s2.id=unitvalue.rd_unit_id)),'') AS t_UNIT,STRFTIME('%Y-%m',unitvalue.d_date) AS d_DATEMONTH,STRFTIME('%Y',unitvalue.d_date) AS d_DATEYEAR FROM unitvalue; 264CREATE VIEW v_suboperation_display AS SELECT *,IFNULL((SELECT s.t_fullname FROM category s WHERE s.id=v_suboperation.r_category_id),'') AS t_CATEGORY, IFNULL((SELECT s.t_name FROM refund s WHERE s.id=v_suboperation.r_refund_id),'') AS t_REFUND, (CASE WHEN v_suboperation.f_value>=0 THEN v_suboperation.f_value ELSE 0 END) AS f_VALUE_INCOME, (CASE WHEN v_suboperation.f_value<=0 THEN v_suboperation.f_value ELSE 0 END) AS f_VALUE_EXPENSE FROM v_suboperation; 265CREATE VIEW v_suboperation_displayname AS SELECT *, t_CATEGORY||' : '||f_value AS t_displayname FROM v_suboperation_display; 266CREATE VIEW v_operation_display_all AS SELECT *,(SELECT s.t_name FROM account s WHERE s.id=v_operation.rd_account_id) AS t_ACCOUNT,(SELECT (CASE WHEN s.t_symbol!='' THEN s.t_symbol ELSE s.t_name END) FROM unit s WHERE s.id=v_operation.rc_unit_id) AS t_UNIT,(SELECT s.t_CATEGORY FROM v_suboperation_display s WHERE s.id=v_operation.i_MOSTIMPSUBOP) AS t_CATEGORY,(SELECT s.t_REFUND FROM v_suboperation_display s WHERE s.id=v_operation.i_MOSTIMPSUBOP) AS t_REFUND,(CASE WHEN v_operation.f_QUANTITY<0 THEN '-' WHEN v_operation.f_QUANTITY=0 THEN '' ELSE '+' END) AS t_TYPEEXPENSE, (CASE WHEN v_operation.f_QUANTITY<=0 THEN 'Dépense' ELSE 'Revenu' END) AS t_TYPEEXPENSENLS, STRFTIME('%Y-W%W',v_operation.d_date) AS d_DATEWEEK,STRFTIME('%Y-%m',v_operation.d_date) AS d_DATEMONTH,STRFTIME('%Y',v_operation.d_date)||'-Q'||(CASE WHEN STRFTIME('%m',v_operation.d_date)<='03' THEN '1' WHEN STRFTIME('%m',v_operation.d_date)<='06' THEN '2' WHEN STRFTIME('%m',v_operation.d_date)<='09' THEN '3' ELSE '4' END) AS d_DATEQUARTER, STRFTIME('%Y',v_operation.d_date)||'-S'||(CASE WHEN STRFTIME('%m',v_operation.d_date)<='06' THEN '1' ELSE '2' END) AS d_DATESEMESTER, STRFTIME('%Y',v_operation.d_date) AS d_DATEYEAR, (SELECT count(*) FROM v_recurrentoperation s WHERE s.rd_operation_id=v_operation.id) AS i_NBRECURRENT, (CASE WHEN v_operation.f_QUANTITY>=0 THEN v_operation.f_QUANTITY ELSE 0 END) AS f_QUANTITY_INCOME, (CASE WHEN v_operation.f_QUANTITY<=0 THEN v_operation.f_QUANTITY ELSE 0 END) AS f_QUANTITY_EXPENSE, (SELECT o2.f_balance FROM operationbalance o2 WHERE o2.r_operation_id=v_operation.id ) AS f_BALANCE, (CASE WHEN v_operation.f_QUANTITY>=0 THEN v_operation.f_CURRENTAMOUNT ELSE 0 END) AS f_CURRENTAMOUNT_INCOME, (CASE WHEN v_operation.f_QUANTITY<=0 THEN v_operation.f_CURRENTAMOUNT ELSE 0 END) AS f_CURRENTAMOUNT_EXPENSE FROM v_operation; 267CREATE VIEW v_operation_template_display AS SELECT * FROM v_operation_display_all WHERE t_template='Y'; 268CREATE VIEW v_operation_display AS SELECT * FROM v_operation_display_all WHERE d_date!='0000-00-00' AND t_template='N'; 269CREATE VIEW v_unit_display AS SELECT *,(SELECT TOTAL(o.f_QUANTITY) FROM v_operation_display o WHERE o.rc_unit_id=v_unit.id) AS f_QUANTITYOWNED FROM v_unit; 270CREATE VIEW v_account_display AS SELECT (CASE t_type WHEN 'C' THEN 'Courant' WHEN 'D' THEN 'Carte de crédit' WHEN 'A' THEN 'Actif' WHEN 'I' THEN 'Investissement' WHEN 'W' THEN 'Portefeuille' WHEN 'L' THEN 'Prêt' WHEN 'O' THEN 'Autre' END) AS t_TYPENLS,bank.t_name AS t_BANK,bank.t_bank_number AS t_BANK_NUMBER,bank.t_icon AS t_ICON,v_account.*,(v_account.f_CURRENTAMOUNT/(SELECT u.f_CURRENTAMOUNT FROM v_unit u, operation s WHERE u.id=s.rc_unit_id AND s.rd_account_id=v_account.id AND s.d_date='0000-00-00')) AS f_QUANTITY, (SELECT (CASE WHEN u.t_symbol!='' THEN u.t_symbol ELSE u.t_name END) FROM unit u, operation s WHERE u.id=s.rc_unit_id AND s.rd_account_id=v_account.id AND s.d_date='0000-00-00') AS t_UNIT, (SELECT TOTAL(s.f_CURRENTAMOUNT) FROM v_operation s WHERE s.rd_account_id=v_account.id AND s.t_status!='N' AND s.t_template='N') AS f_CHECKED, (SELECT TOTAL(s.f_CURRENTAMOUNT) FROM v_operation s WHERE s.rd_account_id=v_account.id AND s.t_status='N' AND s.t_template='N') AS f_COMING_SOON, (SELECT TOTAL(s.f_CURRENTAMOUNT) FROM v_operation s WHERE s.rd_account_id=v_account.id AND s.d_date<=date('now') AND s.t_template='N') AS f_TODAYAMOUNT, (SELECT count(*) FROM v_operation_display s WHERE s.rd_account_id=v_account.id) AS i_NBOPERATIONS, IFNULL((SELECT s.f_rate FROM interest s WHERE s.rd_account_id=v_account.id AND s.d_date=v_account.d_MAXDATE),0) AS f_RATE FROM v_account, bank WHERE bank.id=v_account.rd_bank_id; 271CREATE VIEW v_operation_consolidated AS SELECT (SELECT s.t_TYPENLS FROM v_account_display s WHERE s.id=op.rd_account_id) AS t_ACCOUNTTYPE,(SELECT u.t_TYPENLS FROM v_unit u WHERE u.id=op.rc_unit_id) AS t_UNITTYPE,sop.id AS i_SUBOPID, sop.r_refund_id AS r_refund_id, (CASE WHEN sop.t_comment='' THEN op.t_comment ELSE sop.t_comment END) AS t_REALCOMMENT, sop.t_CATEGORY AS t_REALCATEGORY, sop.t_REFUND AS t_REALREFUND, sop.r_category_id AS i_IDCATEGORY, (CASE WHEN sop.f_value<0 THEN '-' WHEN sop.f_value=0 THEN '' ELSE '+' END) AS t_TYPEEXPENSE, (CASE WHEN sop.f_value<0 THEN 'Dépense' WHEN sop.f_value=0 THEN '' ELSE 'Revenu' END) AS t_TYPEEXPENSENLS, sop.f_value AS f_REALQUANTITY, sop.f_VALUE_INCOME AS f_REALQUANTITY_INCOME, sop.f_VALUE_EXPENSE AS f_REALQUANTITY_EXPENSE, ((SELECT u.f_CURRENTAMOUNT FROM v_unit u WHERE u.id=op.rc_unit_id)*sop.f_value) AS f_REALCURRENTAMOUNT, ((SELECT u.f_CURRENTAMOUNT FROM v_unit u WHERE u.id=op.rc_unit_id)*sop.f_VALUE_INCOME) AS f_REALCURRENTAMOUNT_INCOME, ((SELECT u.f_CURRENTAMOUNT FROM v_unit u WHERE u.id=op.rc_unit_id)*sop.f_VALUE_EXPENSE) AS f_REALCURRENTAMOUNT_EXPENSE, op.* FROM v_operation_display_all AS op, v_suboperation_display AS sop WHERE op.t_template='N' AND sop.rd_operation_id=op.ID; 272CREATE VIEW v_operation_prop AS SELECT p.id AS i_PROPPID, p.t_name AS i_PROPPNAME, p.t_value AS i_PROPVALUE, op.* FROM v_operation_consolidated AS op LEFT OUTER JOIN parameters AS p ON p.t_uuid_parent=op.id||'-operation'; 273CREATE VIEW v_refund_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM v_operation_consolidated WHERE r_refund_id=refund.id AND t_status='Y') THEN 'Vous n''êtes pas autorisé à détruire ce suiveur car utilisé par des opérations rapprochées' END) t_delete_message FROM refund; 274CREATE VIEW v_refund AS SELECT *, (SELECT TOTAL(o.f_REALCURRENTAMOUNT) FROM v_operation_consolidated o WHERE o.r_refund_id=refund.id) AS f_CURRENTAMOUNT FROM refund; 275CREATE VIEW v_refund_display AS SELECT *,(SELECT MIN(o.d_date) FROM v_operation_consolidated o WHERE o.r_refund_id=v_refund.id) AS d_FIRSTDATE, (SELECT MAX(o.d_date) FROM v_operation_consolidated o WHERE o.r_refund_id=v_refund.id) AS d_LASTDATE FROM v_refund; 276CREATE VIEW v_refund_displayname AS SELECT *, t_name AS t_displayname FROM refund; 277CREATE VIEW v_payee_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM operation WHERE r_payee_id=payee.id AND t_status='Y') THEN 'Vous n''êtes pas autorisé à détruire ce tiers car utilisé par des opérations rapprochées' END) t_delete_message FROM payee; 278CREATE VIEW v_payee AS SELECT *, (SELECT TOTAL(o.f_CURRENTAMOUNT) FROM v_operation o WHERE o.r_payee_id=payee.id AND o.t_template='N') AS f_CURRENTAMOUNT FROM payee; 279CREATE VIEW v_payee_display AS SELECT * FROM v_payee; 280CREATE VIEW v_payee_displayname AS SELECT *, t_name AS t_displayname FROM payee; 281CREATE VIEW v_category_delete AS SELECT *, (CASE WHEN EXISTS(SELECT 1 FROM v_operation_consolidated WHERE (t_REALCATEGORY=category.t_fullname OR t_REALCATEGORY like category.t_fullname||'%') AND t_status='Y') THEN 'Vous n''êtes pas autorisé à détruire cette catégorie car utilisée par des opérations rapprochées' END) t_delete_message FROM category; 282CREATE VIEW v_category_display_tmp AS SELECT *,(SELECT count(distinct(so.rd_operation_id)) FROM operation o, suboperation so WHERE so.rd_operation_id=o.id AND so.r_category_id=v_category.ID AND o.t_template='N') AS i_NBOPERATIONS, (SELECT TOTAL(o.f_REALCURRENTAMOUNT) FROM v_operation_consolidated o WHERE o.i_IDCATEGORY=v_category.ID) AS f_REALCURRENTAMOUNT FROM v_category; 283CREATE VIEW v_category_display AS SELECT *,f_REALCURRENTAMOUNT+(SELECT TOTAL(c.f_REALCURRENTAMOUNT) FROM vm_category_display_tmp c WHERE c.t_fullname LIKE vm_category_display_tmp.t_fullname||' > %') AS f_SUMCURRENTAMOUNT, i_NBOPERATIONS+(SELECT CAST(TOTAL(c.i_NBOPERATIONS) AS INTEGER) FROM vm_category_display_tmp c WHERE c.t_fullname like vm_category_display_tmp.t_fullname||' > %') AS i_SUMNBOPERATIONS, (CASE WHEN t_bookmarked='Y' THEN 'Y' WHEN EXISTS(SELECT 1 FROM category c WHERE c.t_bookmarked='Y' AND c.t_fullname like vm_category_display_tmp.t_fullname||' > %') THEN 'C' ELSE 'N' END) AS t_HASBOOKMARKEDCHILD, (CASE WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT<0 THEN '-' WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT=0 THEN '' ELSE '+' END) AS t_TYPEEXPENSE,(CASE WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT<0 THEN 'Dépense' WHEN vm_category_display_tmp.f_REALCURRENTAMOUNT=0 THEN '' ELSE 'Revenu' END) AS t_TYPEEXPENSENLS FROM vm_category_display_tmp; 284CREATE VIEW v_recurrentoperation_display AS SELECT rop.*, op.t_ACCOUNT, op.i_number, op.t_mode, op.i_group_id, op.t_TRANSFER, op.t_PAYEE, op.t_comment, op.t_CATEGORY, op.t_status, op.f_CURRENTAMOUNT FROM v_recurrentoperation rop, v_operation_display_all AS op WHERE rop.rd_operation_id=op.ID; 285CREATE VIEW v_rule AS SELECT *,(SELECT COUNT(1) FROM rule r WHERE r.f_sortorder<=rule.f_sortorder) AS i_ORDER FROM rule; 286CREATE VIEW v_rule_displayname AS SELECT *, t_definition AS t_displayname FROM rule; 287CREATE VIEW v_interest AS SELECT *,(SELECT s.t_name FROM account s WHERE s.id=interest.rd_account_id) AS t_ACCOUNT FROM interest; 288CREATE VIEW v_interest_displayname AS SELECT *, STRFTIME('%d/%m/%Y',d_date)||' '||f_rate||'%' AS t_displayname FROM interest; 289CREATE VIEW v_budgetrule AS SELECT *, IFNULL((SELECT s.t_fullname FROM category s WHERE s.id=budgetrule.rc_category_id),'') AS t_CATEGORYCONDITION, IFNULL((SELECT s.t_fullname FROM category s WHERE s.id=budgetrule.rc_category_id_target),'') AS t_CATEGORY, (CASE WHEN budgetrule.i_condition=-1 THEN 'Négatif' WHEN budgetrule.i_condition=1 THEN 'Positif' WHEN budgetrule.i_condition=0 THEN 'Tous' END) AS t_WHENNLS, f_quantity||(CASE WHEN budgetrule.t_absolute='N' THEN '%' ELSE (SELECT t_symbol FROM unit WHERE t_type='1') END) AS t_WHATNLS,(CASE WHEN budgetrule.t_rule='N' THEN 'Suivant' WHEN budgetrule.t_rule='C' THEN 'Courant' WHEN budgetrule.t_rule='Y' THEN 'Année' END) AS t_RULENLS FROM budgetrule; 290CREATE VIEW v_budgetrule_display AS SELECT * FROM v_budgetrule; 291CREATE VIEW v_budgetrule_displayname AS SELECT *, t_WHENNLS||' '||t_WHATNLS||' '||t_RULENLS||' '||t_CATEGORY AS t_displayname FROM v_budgetrule; 292CREATE VIEW v_budget_tmp AS SELECT *, IFNULL((SELECT s.t_fullname FROM category s WHERE s.id=budget.rc_category_id),'') AS t_CATEGORY, (i_year||(CASE WHEN i_month=0 THEN '' WHEN i_month<10 THEN '-0'||i_month ELSE '-'||i_month END)) AS t_PERIOD, (SELECT TOTAL(o.f_REALCURRENTAMOUNT) FROM v_operation_consolidated o WHERE STRFTIME('%Y', o.d_date)=i_year AND (i_month=0 OR STRFTIME('%m', o.d_date)=i_month) AND o.i_IDCATEGORY IN (SELECT b2.id_category FROM budgetcategory b2 WHERE b2.id=budget.id)) AS f_CURRENTAMOUNT, (SELECT GROUP_CONCAT(v_budgetrule_displayname.t_displayname,',') FROM v_budgetrule_displayname WHERE (v_budgetrule_displayname.t_year_condition='N' OR budget.i_year=v_budgetrule_displayname.i_year) AND (v_budgetrule_displayname.t_month_condition='N' OR budget.i_month=v_budgetrule_displayname.i_month) AND (v_budgetrule_displayname.t_category_condition='N' OR budget.rc_category_id=v_budgetrule_displayname.rc_category_id) ORDER BY v_budgetrule_displayname.t_absolute DESC, v_budgetrule_displayname.id) AS t_RULES FROM budget; 293CREATE VIEW v_budget AS SELECT *, (f_CURRENTAMOUNT-f_budgeted_modified) AS f_DELTABEFORETRANSFER, (f_CURRENTAMOUNT-f_budgeted_modified-f_transferred) AS f_DELTA FROM v_budget_tmp; 294CREATE VIEW v_budget_display AS SELECT *, (f_CURRENTAMOUNT-f_budgeted_modified) AS f_DELTABEFORETRANSFER, (f_CURRENTAMOUNT-f_budgeted_modified-f_transferred) AS f_DELTA FROM vm_budget_tmp; 295CREATE VIEW v_budget_displayname AS SELECT *, t_CATEGORY||' '||t_PERIOD||' '||f_budgeted_modified AS t_displayname FROM v_budget; 296CREATE TRIGGER fkdc_bank_parameters_uuid BEFORE DELETE ON bank FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'bank'; END; 297CREATE TRIGGER fkdc_account_parameters_uuid BEFORE DELETE ON account FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'account'; END; 298CREATE TRIGGER fkdc_unit_parameters_uuid BEFORE DELETE ON unit FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'unit'; END; 299CREATE TRIGGER fkdc_unitvalue_parameters_uuid BEFORE DELETE ON unitvalue FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'unitvalue'; END; 300CREATE TRIGGER fkdc_category_parameters_uuid BEFORE DELETE ON category FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'category'; END; 301CREATE TRIGGER fkdc_operation_parameters_uuid BEFORE DELETE ON operation FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'operation'; END; 302CREATE TRIGGER fkdc_interest_parameters_uuid BEFORE DELETE ON interest FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'interest'; END; 303CREATE TRIGGER fkdc_suboperation_parameters_uuid BEFORE DELETE ON suboperation FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'suboperation'; END; 304CREATE TRIGGER fkdc_refund_parameters_uuid BEFORE DELETE ON refund FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'refund'; END; 305CREATE TRIGGER fkdc_payee_parameters_uuid BEFORE DELETE ON payee FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'payee'; END; 306CREATE TRIGGER fkdc_recurrentoperation_parameters_uuid BEFORE DELETE ON recurrentoperation FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'recurrentoperation'; END; 307CREATE TRIGGER fkdc_rule_parameters_uuid BEFORE DELETE ON rule FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'rule'; END; 308CREATE TRIGGER fkdc_budget_parameters_uuid BEFORE DELETE ON budget FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'budget'; END; 309CREATE TRIGGER fkdc_budgetrule_parameters_uuid BEFORE DELETE ON budgetrule FOR EACH ROW BEGIN DELETE FROM parameters WHERE parameters.t_uuid_parent=OLD.id||'-'||'budgetrule'; END; 310CREATE TRIGGER cpt_category_fullname1 AFTER INSERT ON category BEGIN UPDATE category SET t_fullname=CASE WHEN rd_category_id IS NULL OR rd_category_id='' OR rd_category_id=0 THEN new.t_name ELSE (SELECT c.t_fullname FROM category c WHERE c.id=new.rd_category_id)||' > '||new.t_name END WHERE id=new.id;END; 311CREATE TRIGGER cpt_category_fullname2 AFTER UPDATE OF t_name, rd_category_id ON category BEGIN UPDATE category SET t_fullname=CASE WHEN rd_category_id IS NULL OR rd_category_id='' OR rd_category_id=0 THEN new.t_name ELSE (SELECT c.t_fullname FROM category c WHERE c.id=new.rd_category_id)||' > '||new.t_name END WHERE id=new.id;UPDATE category SET t_name=t_name WHERE rd_category_id=new.id;END; 312CREATE TRIGGER fkdc_category_delete BEFORE DELETE ON category FOR EACH ROW BEGIN UPDATE suboperation SET r_category_id=OLD.rd_category_id WHERE r_category_id=OLD.id; END; 313explain 314 SELECT TOTAL(f_CURRENTAMOUNT), d_DATEMONTH 315 from v_operation_display 316 WHERE d_DATEMONTH IN ('2012-05', '2012-04') 317 group by d_DATEMONTH, t_TYPEEXPENSE; 318 } 319} {/.* Goto .*/} 320 321# The next test requires FTS4 322ifcapable !fts3 { 323 finish_test 324 return 325} 326 327# Taken from the gnome-shell project 328# 329db close 330forcedelete test.db 331sqlite3 db test.db 332sqlite3_db_config db SQLITE_DBCONFIG_DQS_DDL 1 333sqlite3_db_config db SQLITE_DBCONFIG_DQS_DML 1 334do_test fuzz-oss1-gnomeshell { 335 db eval { 336CREATE TABLE Resource (ID INTEGER NOT NULL PRIMARY KEY, Uri TEXT NOT 337NULL, UNIQUE (Uri)); 338CREATE VIRTUAL TABLE fts USING fts4; 339CREATE TABLE "mfo:Action" (ID INTEGER NOT NULL PRIMARY KEY); 340CREATE TABLE "mfo:Enclosure" (ID INTEGER NOT NULL PRIMARY KEY, 341"mfo:remoteLink" INTEGER, "mfo:remoteLink:graph" INTEGER, 342"mfo:groupDefault" INTEGER, "mfo:groupDefault:graph" INTEGER, 343"mfo:localLink" INTEGER, "mfo:localLink:graph" INTEGER, "mfo:optional" 344INTEGER, "mfo:optional:graph" INTEGER); 345CREATE TABLE "mfo:FeedChannel" (ID INTEGER NOT NULL PRIMARY KEY, 346"mfo:updatedTime" INTEGER, "mfo:updatedTime:graph" INTEGER, 347"mfo:updatedTime:localDate" INTEGER, "mfo:updatedTime:localTime" 348INTEGER, "mfo:unreadCount" INTEGER, "mfo:unreadCount:graph" INTEGER, 349"mfo:totalCount" INTEGER, "mfo:totalCount:graph" INTEGER, "mfo:action" 350INTEGER, "mfo:action:graph" INTEGER, "mfo:type" INTEGER, 351"mfo:type:graph" INTEGER); 352CREATE TABLE "mfo:FeedElement" (ID INTEGER NOT NULL PRIMARY KEY, 353"mfo:image" TEXT COLLATE NOCASE, "mfo:image:graph" INTEGER, 354"mfo:feedSettings" INTEGER, "mfo:feedSettings:graph" INTEGER); 355CREATE TABLE "mfo:FeedMessage" (ID INTEGER NOT NULL PRIMARY KEY, 356"mfo:downloadedTime" INTEGER, "mfo:downloadedTime:graph" INTEGER, 357"mfo:downloadedTime:localDate" INTEGER, "mfo:downloadedTime:localTime" 358INTEGER); 359CREATE TABLE "mfo:FeedMessage_mfo:enclosureList" (ID INTEGER NOT NULL, 360"mfo:enclosureList" INTEGER NOT NULL, "mfo:enclosureList:graph" 361INTEGER); 362CREATE TABLE "mfo:FeedSettings" (ID INTEGER NOT NULL PRIMARY KEY, 363"mfo:updateInterval" INTEGER, "mfo:updateInterval:graph" INTEGER, 364"mfo:expiryInterval" INTEGER, "mfo:expiryInterval:graph" INTEGER, 365"mfo:downloadPath" TEXT COLLATE NOCASE, "mfo:downloadPath:graph" 366INTEGER, "mfo:downloadFlag" INTEGER, "mfo:downloadFlag:graph" INTEGER, 367"mfo:maxSize" INTEGER, "mfo:maxSize:graph" INTEGER); 368CREATE TABLE "mfo:FeedType" (ID INTEGER NOT NULL PRIMARY KEY, 369"mfo:name" TEXT COLLATE NOCASE, "mfo:name:graph" INTEGER); 370CREATE TABLE "mlo:GeoBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); 371CREATE TABLE "mlo:GeoBoundingBox_mlo:bbNorthWest" (ID INTEGER NOT 372NULL, "mlo:bbNorthWest" INTEGER NOT NULL, "mlo:bbNorthWest:graph" 373INTEGER); 374CREATE TABLE "mlo:GeoBoundingBox_mlo:bbSouthEast" (ID INTEGER NOT 375NULL, "mlo:bbSouthEast" INTEGER NOT NULL, "mlo:bbSouthEast:graph" 376INTEGER); 377CREATE TABLE "mlo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY); 378CREATE TABLE "mlo:GeoLocation_mlo:asBoundingBox" (ID INTEGER NOT NULL, 379"mlo:asBoundingBox" INTEGER NOT NULL, "mlo:asBoundingBox:graph" 380INTEGER); 381CREATE TABLE "mlo:GeoLocation_mlo:asGeoPoint" (ID INTEGER NOT NULL, 382"mlo:asGeoPoint" INTEGER NOT NULL, "mlo:asGeoPoint:graph" INTEGER); 383CREATE TABLE "mlo:GeoLocation_mlo:asPostalAddress" (ID INTEGER NOT 384NULL, "mlo:asPostalAddress" INTEGER NOT NULL, 385"mlo:asPostalAddress:graph" INTEGER); 386CREATE TABLE "mlo:GeoPoint" (ID INTEGER NOT NULL PRIMARY KEY); 387CREATE TABLE "mlo:GeoPoint_mlo:address" (ID INTEGER NOT NULL, 388"mlo:address" TEXT NOT NULL, "mlo:address:graph" INTEGER); 389CREATE TABLE "mlo:GeoPoint_mlo:altitude" (ID INTEGER NOT NULL, 390"mlo:altitude" REAL NOT NULL, "mlo:altitude:graph" INTEGER); 391CREATE TABLE "mlo:GeoPoint_mlo:city" (ID INTEGER NOT NULL, "mlo:city" 392TEXT NOT NULL, "mlo:city:graph" INTEGER); 393CREATE TABLE "mlo:GeoPoint_mlo:country" (ID INTEGER NOT NULL, 394"mlo:country" TEXT NOT NULL, "mlo:country:graph" INTEGER); 395CREATE TABLE "mlo:GeoPoint_mlo:latitude" (ID INTEGER NOT NULL, 396"mlo:latitude" REAL NOT NULL, "mlo:latitude:graph" INTEGER); 397CREATE TABLE "mlo:GeoPoint_mlo:longitude" (ID INTEGER NOT NULL, 398"mlo:longitude" REAL NOT NULL, "mlo:longitude:graph" INTEGER); 399CREATE TABLE "mlo:GeoPoint_mlo:state" (ID INTEGER NOT NULL, 400"mlo:state" TEXT NOT NULL, "mlo:state:graph" INTEGER); 401CREATE TABLE "mlo:GeoPoint_mlo:timestamp" (ID INTEGER NOT NULL, 402"mlo:timestamp" INTEGER NOT NULL, "mlo:timestamp:graph" INTEGER, 403"mlo:timestamp:localDate" INTEGER NOT NULL, "mlo:timestamp:localTime" 404INTEGER NOT NULL); 405CREATE TABLE "mlo:GeoSphere" (ID INTEGER NOT NULL PRIMARY KEY); 406CREATE TABLE "mlo:GeoSphere_mlo:radius" (ID INTEGER NOT NULL, 407"mlo:radius" REAL NOT NULL, "mlo:radius:graph" INTEGER); 408CREATE TABLE "mlo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY); 409CREATE TABLE "mlo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY); 410CREATE TABLE "mlo:LandmarkCategory_mlo:isRemovable" (ID INTEGER NOT 411NULL, "mlo:isRemovable" INTEGER NOT NULL, "mlo:isRemovable:graph" 412INTEGER); 413CREATE TABLE "mlo:Landmark_mlo:belongsToCategory" (ID INTEGER NOT 414NULL, "mlo:belongsToCategory" INTEGER NOT NULL, 415"mlo:belongsToCategory:graph" INTEGER); 416CREATE TABLE "mlo:Landmark_mlo:poiLocation" (ID INTEGER NOT NULL, 417"mlo:poiLocation" INTEGER NOT NULL, "mlo:poiLocation:graph" INTEGER); 418CREATE TABLE "mlo:LocationBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); 419CREATE TABLE "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID INTEGER 420NOT NULL, "mlo:boxEastLimit" INTEGER NOT NULL, 421"mlo:boxEastLimit:graph" INTEGER); 422CREATE TABLE "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID INTEGER 423NOT NULL, "mlo:boxNorthLimit" INTEGER NOT NULL, 424"mlo:boxNorthLimit:graph" INTEGER); 425CREATE TABLE "mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID 426INTEGER NOT NULL, "mlo:boxSouthWestCorner" INTEGER NOT NULL, 427"mlo:boxSouthWestCorner:graph" INTEGER); 428CREATE TABLE "mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID 429INTEGER NOT NULL, "mlo:boxVerticalLimit" INTEGER NOT NULL, 430"mlo:boxVerticalLimit:graph" INTEGER); 431CREATE TABLE "mlo:PointOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); 432CREATE TABLE "mlo:Route" (ID INTEGER NOT NULL PRIMARY KEY); 433CREATE TABLE "mlo:Route_mlo:endTime" (ID INTEGER NOT NULL, 434"mlo:endTime" INTEGER NOT NULL, "mlo:endTime:graph" INTEGER, 435"mlo:endTime:localDate" INTEGER NOT NULL, "mlo:endTime:localTime" 436INTEGER NOT NULL); 437CREATE TABLE "mlo:Route_mlo:routeDetails" (ID INTEGER NOT NULL, 438"mlo:routeDetails" TEXT NOT NULL, "mlo:routeDetails:graph" INTEGER); 439CREATE TABLE "mlo:Route_mlo:startTime" (ID INTEGER NOT NULL, 440"mlo:startTime" INTEGER NOT NULL, "mlo:startTime:graph" INTEGER, 441"mlo:startTime:localDate" INTEGER NOT NULL, "mlo:startTime:localTime" 442INTEGER NOT NULL); 443CREATE TABLE "mto:DownloadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 444CREATE TABLE "mto:State" (ID INTEGER NOT NULL PRIMARY KEY); 445CREATE TABLE "mto:SyncTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 446CREATE TABLE "mto:Transfer" (ID INTEGER NOT NULL PRIMARY KEY, 447"mto:transferState" INTEGER, "mto:transferState:graph" INTEGER, 448"mto:method" INTEGER, "mto:method:graph" INTEGER, "mto:created" 449INTEGER, "mto:created:graph" INTEGER, "mto:created:localDate" INTEGER, 450"mto:created:localTime" INTEGER, "mto:account" TEXT COLLATE NOCASE, 451"mto:account:graph" INTEGER, "mto:starter" INTEGER, 452"mto:starter:graph" INTEGER, "mto:agent" INTEGER, "mto:agent:graph" 453INTEGER); 454CREATE TABLE "mto:TransferElement" (ID INTEGER NOT NULL PRIMARY KEY, 455"mto:source" INTEGER, "mto:source:graph" INTEGER, "mto:destination" 456INTEGER, "mto:destination:graph" INTEGER, "mto:startedTime" INTEGER, 457"mto:startedTime:graph" INTEGER, "mto:startedTime:localDate" INTEGER, 458"mto:startedTime:localTime" INTEGER, "mto:completedTime" INTEGER, 459"mto:completedTime:graph" INTEGER, "mto:completedTime:localDate" 460INTEGER, "mto:completedTime:localTime" INTEGER, "mto:state" INTEGER, 461"mto:state:graph" INTEGER); 462CREATE TABLE "mto:TransferMethod" (ID INTEGER NOT NULL PRIMARY KEY); 463CREATE TABLE "mto:Transfer_mto:transferList" (ID INTEGER NOT NULL, 464"mto:transferList" INTEGER NOT NULL, "mto:transferList:graph" 465INTEGER); 466CREATE TABLE "mto:Transfer_mto:transferPrivacyLevel" (ID INTEGER NOT 467NULL, "mto:transferPrivacyLevel" TEXT NOT NULL, 468"mto:transferPrivacyLevel:graph" INTEGER); 469CREATE TABLE "mto:UploadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 470CREATE TABLE "mto:UploadTransfer_mto:transferCategory" (ID INTEGER NOT 471NULL, "mto:transferCategory" TEXT NOT NULL, 472"mto:transferCategory:graph" INTEGER); 473CREATE TABLE "mtp:ScanType" (ID INTEGER NOT NULL PRIMARY KEY); 474CREATE TABLE "nao:Property" (ID INTEGER NOT NULL PRIMARY KEY, 475"nao:propertyName" TEXT COLLATE NOCASE, "nao:propertyName:graph" 476INTEGER, "nao:propertyValue" TEXT COLLATE NOCASE, 477"nao:propertyValue:graph" INTEGER); 478CREATE TABLE "nao:Tag" (ID INTEGER NOT NULL PRIMARY KEY, 479"nao:prefLabel" TEXT COLLATE NOCASE, "nao:prefLabel:graph" INTEGER, 480"nao:description" TEXT COLLATE NOCASE, "nao:description:graph" 481INTEGER); 482CREATE TABLE "nao:Tag_tracker:isDefaultTag" (ID INTEGER NOT NULL, 483"tracker:isDefaultTag" INTEGER NOT NULL, "tracker:isDefaultTag:graph" 484INTEGER); 485CREATE TABLE "nao:Tag_tracker:tagRelatedTo" (ID INTEGER NOT NULL, 486"tracker:tagRelatedTo" INTEGER NOT NULL, "tracker:tagRelatedTo:graph" 487INTEGER); 488CREATE TABLE "ncal:AccessClassification" (ID INTEGER NOT NULL PRIMARY KEY); 489CREATE TABLE "ncal:Alarm" (ID INTEGER NOT NULL PRIMARY KEY, 490"ncal:repeat" INTEGER, "ncal:repeat:graph" INTEGER); 491CREATE TABLE "ncal:AlarmAction" (ID INTEGER NOT NULL PRIMARY KEY); 492CREATE TABLE "ncal:Alarm_ncal:action" (ID INTEGER NOT NULL, 493"ncal:action" INTEGER NOT NULL, "ncal:action:graph" INTEGER); 494CREATE TABLE "ncal:Attachment" (ID INTEGER NOT NULL PRIMARY KEY, 495"ncal:attachmentUri" INTEGER, "ncal:attachmentUri:graph" INTEGER, 496"ncal:fmttype" TEXT COLLATE NOCASE, "ncal:fmttype:graph" INTEGER, 497"ncal:encoding" INTEGER, "ncal:encoding:graph" INTEGER, 498"ncal:attachmentContent" TEXT COLLATE NOCASE, 499"ncal:attachmentContent:graph" INTEGER); 500CREATE TABLE "ncal:AttachmentEncoding" (ID INTEGER NOT NULL PRIMARY KEY); 501CREATE TABLE "ncal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, 502"ncal:delegatedTo" INTEGER, "ncal:delegatedTo:graph" INTEGER, 503"ncal:delegatedFrom" INTEGER, "ncal:delegatedFrom:graph" INTEGER, 504"ncal:cutype" INTEGER, "ncal:cutype:graph" INTEGER, "ncal:member" 505INTEGER, "ncal:member:graph" INTEGER, "ncal:role" INTEGER, 506"ncal:role:graph" INTEGER, "ncal:rsvp" INTEGER, "ncal:rsvp:graph" 507INTEGER, "ncal:partstat" INTEGER, "ncal:partstat:graph" INTEGER); 508CREATE TABLE "ncal:AttendeeOrOrganizer" (ID INTEGER NOT NULL PRIMARY 509KEY, "ncal:dir" INTEGER, "ncal:dir:graph" INTEGER, 510"ncal:involvedContact" INTEGER, "ncal:involvedContact:graph" INTEGER, 511"ncal:sentBy" INTEGER, "ncal:sentBy:graph" INTEGER); 512CREATE TABLE "ncal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); 513CREATE TABLE "ncal:BydayRulePart" (ID INTEGER NOT NULL PRIMARY KEY); 514CREATE TABLE "ncal:BydayRulePart_ncal:bydayModifier" (ID INTEGER NOT 515NULL, "ncal:bydayModifier" INTEGER NOT NULL, 516"ncal:bydayModifier:graph" INTEGER); 517CREATE TABLE "ncal:BydayRulePart_ncal:bydayWeekday" (ID INTEGER NOT 518NULL, "ncal:bydayWeekday" INTEGER NOT NULL, "ncal:bydayWeekday:graph" 519INTEGER); 520CREATE TABLE "ncal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY, 521"ncal:method" TEXT COLLATE NOCASE, "ncal:method:graph" INTEGER, 522"ncal:calscale" INTEGER, "ncal:calscale:graph" INTEGER, "ncal:prodid" 523TEXT COLLATE NOCASE, "ncal:prodid:graph" INTEGER, "ncal:version" TEXT 524COLLATE NOCASE, "ncal:version:graph" INTEGER); 525CREATE TABLE "ncal:CalendarDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 526CREATE TABLE "ncal:CalendarScale" (ID INTEGER NOT NULL PRIMARY KEY); 527CREATE TABLE "ncal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); 528CREATE TABLE "ncal:Calendar_ncal:component" (ID INTEGER NOT NULL, 529"ncal:component" INTEGER NOT NULL, "ncal:component:graph" INTEGER); 530CREATE TABLE "ncal:Event" (ID INTEGER NOT NULL PRIMARY KEY, 531"ncal:eventStatus" INTEGER, "ncal:eventStatus:graph" INTEGER, 532"ncal:transp" INTEGER, "ncal:transp:graph" INTEGER); 533CREATE TABLE "ncal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); 534CREATE TABLE "ncal:Freebusy" (ID INTEGER NOT NULL PRIMARY KEY); 535CREATE TABLE "ncal:FreebusyPeriod" (ID INTEGER NOT NULL PRIMARY KEY, 536"ncal:fbtype" INTEGER, "ncal:fbtype:graph" INTEGER); 537CREATE TABLE "ncal:FreebusyType" (ID INTEGER NOT NULL PRIMARY KEY); 538CREATE TABLE "ncal:Freebusy_ncal:freebusy" (ID INTEGER NOT NULL, 539"ncal:freebusy" INTEGER NOT NULL, "ncal:freebusy:graph" INTEGER); 540CREATE TABLE "ncal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, 541"ncal:journalStatus" INTEGER, "ncal:journalStatus:graph" INTEGER); 542CREATE TABLE "ncal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); 543CREATE TABLE "ncal:NcalDateTime" (ID INTEGER NOT NULL PRIMARY KEY, 544"ncal:ncalTimezone" INTEGER, "ncal:ncalTimezone:graph" INTEGER, 545"ncal:date" INTEGER, "ncal:date:graph" INTEGER, "ncal:date:localDate" 546INTEGER, "ncal:date:localTime" INTEGER, "ncal:dateTime" INTEGER, 547"ncal:dateTime:graph" INTEGER, "ncal:dateTime:localDate" INTEGER, 548"ncal:dateTime:localTime" INTEGER); 549CREATE TABLE "ncal:NcalPeriod" (ID INTEGER NOT NULL PRIMARY KEY, 550"ncal:periodBegin" INTEGER, "ncal:periodBegin:graph" INTEGER, 551"ncal:periodBegin:localDate" INTEGER, "ncal:periodBegin:localTime" 552INTEGER, "ncal:periodDuration" INTEGER, "ncal:periodDuration:graph" 553INTEGER, "ncal:periodEnd" INTEGER, "ncal:periodEnd:graph" INTEGER, 554"ncal:periodEnd:localDate" INTEGER, "ncal:periodEnd:localTime" 555INTEGER); 556CREATE TABLE "ncal:NcalTimeEntity" (ID INTEGER NOT NULL PRIMARY KEY); 557CREATE TABLE "ncal:Organizer" (ID INTEGER NOT NULL PRIMARY KEY); 558CREATE TABLE "ncal:ParticipationStatus" (ID INTEGER NOT NULL PRIMARY KEY); 559CREATE TABLE "ncal:RecurrenceFrequency" (ID INTEGER NOT NULL PRIMARY KEY); 560CREATE TABLE "ncal:RecurrenceIdentifier" (ID INTEGER NOT NULL PRIMARY 561KEY, "ncal:range" INTEGER, "ncal:range:graph" INTEGER, 562"ncal:recurrenceIdDateTime" INTEGER, "ncal:recurrenceIdDateTime:graph" 563INTEGER); 564CREATE TABLE "ncal:RecurrenceIdentifierRange" (ID INTEGER NOT NULL PRIMARY KEY); 565CREATE TABLE "ncal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, 566"ncal:until" INTEGER, "ncal:until:graph" INTEGER, 567"ncal:until:localDate" INTEGER, "ncal:until:localTime" INTEGER, 568"ncal:wkst" INTEGER, "ncal:wkst:graph" INTEGER, "ncal:interval" 569INTEGER, "ncal:interval:graph" INTEGER, "ncal:count" INTEGER, 570"ncal:count:graph" INTEGER, "ncal:freq" INTEGER, "ncal:freq:graph" 571INTEGER); 572CREATE TABLE "ncal:RecurrenceRule_ncal:byday" (ID INTEGER NOT NULL, 573"ncal:byday" INTEGER NOT NULL, "ncal:byday:graph" INTEGER); 574CREATE TABLE "ncal:RecurrenceRule_ncal:byhour" (ID INTEGER NOT NULL, 575"ncal:byhour" INTEGER NOT NULL, "ncal:byhour:graph" INTEGER); 576CREATE TABLE "ncal:RecurrenceRule_ncal:byminute" (ID INTEGER NOT NULL, 577"ncal:byminute" INTEGER NOT NULL, "ncal:byminute:graph" INTEGER); 578CREATE TABLE "ncal:RecurrenceRule_ncal:bymonth" (ID INTEGER NOT NULL, 579"ncal:bymonth" INTEGER NOT NULL, "ncal:bymonth:graph" INTEGER); 580CREATE TABLE "ncal:RecurrenceRule_ncal:bymonthday" (ID INTEGER NOT 581NULL, "ncal:bymonthday" INTEGER NOT NULL, "ncal:bymonthday:graph" 582INTEGER); 583CREATE TABLE "ncal:RecurrenceRule_ncal:bysecond" (ID INTEGER NOT NULL, 584"ncal:bysecond" INTEGER NOT NULL, "ncal:bysecond:graph" INTEGER); 585CREATE TABLE "ncal:RecurrenceRule_ncal:bysetpos" (ID INTEGER NOT NULL, 586"ncal:bysetpos" INTEGER NOT NULL, "ncal:bysetpos:graph" INTEGER); 587CREATE TABLE "ncal:RecurrenceRule_ncal:byweekno" (ID INTEGER NOT NULL, 588"ncal:byweekno" INTEGER NOT NULL, "ncal:byweekno:graph" INTEGER); 589CREATE TABLE "ncal:RecurrenceRule_ncal:byyearday" (ID INTEGER NOT 590NULL, "ncal:byyearday" INTEGER NOT NULL, "ncal:byyearday:graph" 591INTEGER); 592CREATE TABLE "ncal:RequestStatus" (ID INTEGER NOT NULL PRIMARY KEY, 593"ncal:statusDescription" TEXT COLLATE NOCASE, 594"ncal:statusDescription:graph" INTEGER, "ncal:returnStatus" TEXT 595COLLATE NOCASE, "ncal:returnStatus:graph" INTEGER, 596"ncal:requestStatusData" TEXT COLLATE NOCASE, 597"ncal:requestStatusData:graph" INTEGER); 598CREATE TABLE "ncal:TimeTransparency" (ID INTEGER NOT NULL PRIMARY KEY); 599CREATE TABLE "ncal:Timezone" (ID INTEGER NOT NULL PRIMARY KEY, 600"ncal:tzurl" INTEGER, "ncal:tzurl:graph" INTEGER, "ncal:standard" 601INTEGER, "ncal:standard:graph" INTEGER, "ncal:daylight" INTEGER, 602"ncal:daylight:graph" INTEGER, "ncal:tzid" TEXT COLLATE NOCASE, 603"ncal:tzid:graph" INTEGER); 604CREATE TABLE "ncal:TimezoneObservance" (ID INTEGER NOT NULL PRIMARY 605KEY, "ncal:tzoffsetfrom" TEXT COLLATE NOCASE, 606"ncal:tzoffsetfrom:graph" INTEGER, "ncal:tzoffsetto" TEXT COLLATE 607NOCASE, "ncal:tzoffsetto:graph" INTEGER, "ncal:tzname" TEXT COLLATE 608NOCASE, "ncal:tzname:graph" INTEGER); 609CREATE TABLE "ncal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, 610"ncal:percentComplete" INTEGER, "ncal:percentComplete:graph" INTEGER, 611"ncal:completed" INTEGER, "ncal:completed:graph" INTEGER, 612"ncal:completed:localDate" INTEGER, "ncal:completed:localTime" 613INTEGER, "ncal:todoStatus" INTEGER, "ncal:todoStatus:graph" INTEGER, 614"ncal:due" INTEGER, "ncal:due:graph" INTEGER); 615CREATE TABLE "ncal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); 616CREATE TABLE "ncal:Trigger" (ID INTEGER NOT NULL PRIMARY KEY, 617"ncal:related" INTEGER, "ncal:related:graph" INTEGER, 618"ncal:triggerDateTime" INTEGER, "ncal:triggerDateTime:graph" INTEGER, 619"ncal:triggerDateTime:localDate" INTEGER, 620"ncal:triggerDateTime:localTime" INTEGER, "ncal:triggerDuration" 621INTEGER, "ncal:triggerDuration:graph" INTEGER); 622CREATE TABLE "ncal:TriggerRelation" (ID INTEGER NOT NULL PRIMARY KEY); 623CREATE TABLE "ncal:UnionParentClass" (ID INTEGER NOT NULL PRIMARY KEY, 624"ncal:lastModified" INTEGER, "ncal:lastModified:graph" INTEGER, 625"ncal:lastModified:localDate" INTEGER, "ncal:lastModified:localTime" 626INTEGER, "ncal:trigger" INTEGER, "ncal:trigger:graph" INTEGER, 627"ncal:created" INTEGER, "ncal:created:graph" INTEGER, 628"ncal:created:localDate" INTEGER, "ncal:created:localTime" INTEGER, 629"ncal:url" INTEGER, "ncal:url:graph" INTEGER, "ncal:comment" TEXT 630COLLATE NOCASE, "ncal:comment:graph" INTEGER, "ncal:summaryAltRep" 631INTEGER, "ncal:summaryAltRep:graph" INTEGER, "ncal:priority" INTEGER, 632"ncal:priority:graph" INTEGER, "ncal:location" TEXT COLLATE NOCASE, 633"ncal:location:graph" INTEGER, "ncal:uid" TEXT COLLATE NOCASE, 634"ncal:uid:graph" INTEGER, "ncal:requestStatus" INTEGER, 635"ncal:requestStatus:graph" INTEGER, "ncal:recurrenceId" INTEGER, 636"ncal:recurrenceId:graph" INTEGER, "ncal:dtstamp" INTEGER, 637"ncal:dtstamp:graph" INTEGER, "ncal:dtstamp:localDate" INTEGER, 638"ncal:dtstamp:localTime" INTEGER, "ncal:class" INTEGER, 639"ncal:class:graph" INTEGER, "ncal:organizer" INTEGER, 640"ncal:organizer:graph" INTEGER, "ncal:dtend" INTEGER, 641"ncal:dtend:graph" INTEGER, "ncal:summary" TEXT COLLATE NOCASE, 642"ncal:summary:graph" INTEGER, "ncal:descriptionAltRep" INTEGER, 643"ncal:descriptionAltRep:graph" INTEGER, "ncal:commentAltRep" INTEGER, 644"ncal:commentAltRep:graph" INTEGER, "ncal:sequence" INTEGER, 645"ncal:sequence:graph" INTEGER, "ncal:contact" TEXT COLLATE NOCASE, 646"ncal:contact:graph" INTEGER, "ncal:contactAltRep" INTEGER, 647"ncal:contactAltRep:graph" INTEGER, "ncal:locationAltRep" INTEGER, 648"ncal:locationAltRep:graph" INTEGER, "ncal:geo" INTEGER, 649"ncal:geo:graph" INTEGER, "ncal:resourcesAltRep" INTEGER, 650"ncal:resourcesAltRep:graph" INTEGER, "ncal:dtstart" INTEGER, 651"ncal:dtstart:graph" INTEGER, "ncal:description" TEXT COLLATE NOCASE, 652"ncal:description:graph" INTEGER, "ncal:relatedToSibling" TEXT COLLATE 653NOCASE, "ncal:relatedToSibling:graph" INTEGER, "ncal:duration" 654INTEGER, "ncal:duration:graph" INTEGER); 655CREATE TABLE "ncal:UnionParentClass_ncal:attach" (ID INTEGER NOT NULL, 656"ncal:attach" INTEGER NOT NULL, "ncal:attach:graph" INTEGER); 657CREATE TABLE "ncal:UnionParentClass_ncal:attendee" (ID INTEGER NOT 658NULL, "ncal:attendee" INTEGER NOT NULL, "ncal:attendee:graph" 659INTEGER); 660CREATE TABLE "ncal:UnionParentClass_ncal:categories" (ID INTEGER NOT 661NULL, "ncal:categories" TEXT NOT NULL, "ncal:categories:graph" 662INTEGER); 663CREATE TABLE "ncal:UnionParentClass_ncal:exdate" (ID INTEGER NOT NULL, 664"ncal:exdate" INTEGER NOT NULL, "ncal:exdate:graph" INTEGER); 665CREATE TABLE "ncal:UnionParentClass_ncal:exrule" (ID INTEGER NOT NULL, 666"ncal:exrule" INTEGER NOT NULL, "ncal:exrule:graph" INTEGER); 667CREATE TABLE "ncal:UnionParentClass_ncal:hasAlarm" (ID INTEGER NOT 668NULL, "ncal:hasAlarm" INTEGER NOT NULL, "ncal:hasAlarm:graph" 669INTEGER); 670CREATE TABLE "ncal:UnionParentClass_ncal:ncalRelation" (ID INTEGER NOT 671NULL, "ncal:ncalRelation" TEXT NOT NULL, "ncal:ncalRelation:graph" 672INTEGER); 673CREATE TABLE "ncal:UnionParentClass_ncal:rdate" (ID INTEGER NOT NULL, 674"ncal:rdate" INTEGER NOT NULL, "ncal:rdate:graph" INTEGER); 675CREATE TABLE "ncal:UnionParentClass_ncal:relatedToChild" (ID INTEGER 676NOT NULL, "ncal:relatedToChild" TEXT NOT NULL, 677"ncal:relatedToChild:graph" INTEGER); 678CREATE TABLE "ncal:UnionParentClass_ncal:relatedToParent" (ID INTEGER 679NOT NULL, "ncal:relatedToParent" TEXT NOT NULL, 680"ncal:relatedToParent:graph" INTEGER); 681CREATE TABLE "ncal:UnionParentClass_ncal:resources" (ID INTEGER NOT 682NULL, "ncal:resources" TEXT NOT NULL, "ncal:resources:graph" INTEGER); 683CREATE TABLE "ncal:UnionParentClass_ncal:rrule" (ID INTEGER NOT NULL, 684"ncal:rrule" INTEGER NOT NULL, "ncal:rrule:graph" INTEGER); 685CREATE TABLE "ncal:Weekday" (ID INTEGER NOT NULL PRIMARY KEY); 686CREATE TABLE "nco:Affiliation" (ID INTEGER NOT NULL PRIMARY KEY, 687"nco:department" TEXT COLLATE NOCASE, "nco:department:graph" INTEGER, 688"nco:org" INTEGER, "nco:org:graph" INTEGER, "nco:role" TEXT COLLATE 689NOCASE, "nco:role:graph" INTEGER); 690CREATE TABLE "nco:Affiliation_nco:title" (ID INTEGER NOT NULL, 691"nco:title" TEXT NOT NULL, "nco:title:graph" INTEGER); 692CREATE TABLE "nco:AuthorizationStatus" (ID INTEGER NOT NULL PRIMARY KEY); 693CREATE TABLE "nco:BbsNumber" (ID INTEGER NOT NULL PRIMARY KEY); 694CREATE TABLE "nco:CarPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 695CREATE TABLE "nco:CellPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 696CREATE TABLE "nco:Contact" (ID INTEGER NOT NULL PRIMARY KEY, 697"nco:fullname" TEXT COLLATE NOCASE, "nco:fullname:graph" INTEGER, 698"nco:key" INTEGER, "nco:key:graph" INTEGER, "nco:contactUID" TEXT 699COLLATE NOCASE, "nco:contactUID:graph" INTEGER, "nco:contactLocalUID" 700TEXT COLLATE NOCASE, "nco:contactLocalUID:graph" INTEGER, 701"nco:hasLocation" INTEGER, "nco:hasLocation:graph" INTEGER, 702"nco:nickname" TEXT COLLATE NOCASE, "nco:nickname:graph" INTEGER, 703"nco:representative" INTEGER, "nco:representative:graph" INTEGER, 704"nco:photo" INTEGER, "nco:photo:graph" INTEGER, "nco:birthDate" 705INTEGER, "nco:birthDate:graph" INTEGER, "nco:birthDate:localDate" 706INTEGER, "nco:birthDate:localTime" INTEGER, "nco:sound" INTEGER, 707"nco:sound:graph" INTEGER); 708CREATE TABLE "nco:ContactGroup" (ID INTEGER NOT NULL PRIMARY KEY, 709"nco:contactGroupName" TEXT COLLATE NOCASE, 710"nco:contactGroupName:graph" INTEGER); 711CREATE TABLE "nco:ContactList" (ID INTEGER NOT NULL PRIMARY KEY); 712CREATE TABLE "nco:ContactListDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 713CREATE TABLE "nco:ContactList_nco:containsContact" (ID INTEGER NOT 714NULL, "nco:containsContact" INTEGER NOT NULL, 715"nco:containsContact:graph" INTEGER); 716CREATE TABLE "nco:ContactMedium" (ID INTEGER NOT NULL PRIMARY KEY, 717"nco:contactMediumComment" TEXT COLLATE NOCASE, 718"nco:contactMediumComment:graph" INTEGER); 719CREATE TABLE "nco:Contact_ncal:anniversary" (ID INTEGER NOT NULL, 720"ncal:anniversary" INTEGER NOT NULL, "ncal:anniversary:graph" 721INTEGER); 722CREATE TABLE "nco:Contact_ncal:birthday" (ID INTEGER NOT NULL, 723"ncal:birthday" INTEGER NOT NULL, "ncal:birthday:graph" INTEGER); 724CREATE TABLE "nco:Contact_nco:belongsToGroup" (ID INTEGER NOT NULL, 725"nco:belongsToGroup" INTEGER NOT NULL, "nco:belongsToGroup:graph" 726INTEGER); 727CREATE TABLE "nco:Contact_nco:note" (ID INTEGER NOT NULL, "nco:note" 728TEXT NOT NULL, "nco:note:graph" INTEGER); 729CREATE TABLE "nco:Contact_scal:anniversary" (ID INTEGER NOT NULL, 730"scal:anniversary" INTEGER NOT NULL, "scal:anniversary:graph" 731INTEGER); 732CREATE TABLE "nco:Contact_scal:birthday" (ID INTEGER NOT NULL, 733"scal:birthday" INTEGER NOT NULL, "scal:birthday:graph" INTEGER); 734CREATE TABLE "nco:DomesticDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); 735CREATE TABLE "nco:EmailAddress" (ID INTEGER NOT NULL PRIMARY KEY, 736"nco:emailAddress" TEXT COLLATE NOCASE UNIQUE, 737"nco:emailAddress:graph" INTEGER); 738CREATE TABLE "nco:FaxNumber" (ID INTEGER NOT NULL PRIMARY KEY); 739CREATE TABLE "nco:Gender" (ID INTEGER NOT NULL PRIMARY KEY); 740CREATE TABLE "nco:IMAccount" (ID INTEGER NOT NULL PRIMARY KEY, 741"nco:imAccountAddress" INTEGER UNIQUE, "nco:imAccountAddress:graph" 742INTEGER, "nco:imAccountType" TEXT COLLATE NOCASE, 743"nco:imAccountType:graph" INTEGER, "nco:imDisplayName" TEXT COLLATE 744NOCASE, "nco:imDisplayName:graph" INTEGER, "nco:imEnabled" INTEGER, 745"nco:imEnabled:graph" INTEGER); 746CREATE TABLE "nco:IMAccount_nco:hasIMContact" (ID INTEGER NOT NULL, 747"nco:hasIMContact" INTEGER NOT NULL, "nco:hasIMContact:graph" 748INTEGER); 749CREATE TABLE "nco:IMAddress" (ID INTEGER NOT NULL PRIMARY KEY, 750"nco:imID" TEXT COLLATE NOCASE, "nco:imID:graph" INTEGER, 751"nco:imNickname" TEXT COLLATE NOCASE, "nco:imNickname:graph" INTEGER, 752"nco:imAvatar" INTEGER, "nco:imAvatar:graph" INTEGER, "nco:imProtocol" 753TEXT COLLATE NOCASE, "nco:imProtocol:graph" INTEGER, 754"nco:imStatusMessage" TEXT COLLATE NOCASE, 755"nco:imStatusMessage:graph" INTEGER, "nco:imPresence" INTEGER, 756"nco:imPresence:graph" INTEGER, "nco:presenceLastModified" INTEGER, 757"nco:presenceLastModified:graph" INTEGER, 758"nco:presenceLastModified:localDate" INTEGER, 759"nco:presenceLastModified:localTime" INTEGER, 760"nco:imAddressAuthStatusFrom" INTEGER, 761"nco:imAddressAuthStatusFrom:graph" INTEGER, 762"nco:imAddressAuthStatusTo" INTEGER, "nco:imAddressAuthStatusTo:graph" 763INTEGER); 764CREATE TABLE "nco:IMAddress_nco:imCapability" (ID INTEGER NOT NULL, 765"nco:imCapability" INTEGER NOT NULL, "nco:imCapability:graph" 766INTEGER); 767CREATE TABLE "nco:IMCapability" (ID INTEGER NOT NULL PRIMARY KEY); 768CREATE TABLE "nco:InternationalDeliveryAddress" (ID INTEGER NOT NULL 769PRIMARY KEY); 770CREATE TABLE "nco:IsdnNumber" (ID INTEGER NOT NULL PRIMARY KEY); 771CREATE TABLE "nco:MessagingNumber" (ID INTEGER NOT NULL PRIMARY KEY); 772CREATE TABLE "nco:ModemNumber" (ID INTEGER NOT NULL PRIMARY KEY); 773CREATE TABLE "nco:OrganizationContact" (ID INTEGER NOT NULL PRIMARY 774KEY, "nco:logo" INTEGER, "nco:logo:graph" INTEGER); 775CREATE TABLE "nco:PagerNumber" (ID INTEGER NOT NULL PRIMARY KEY); 776CREATE TABLE "nco:ParcelDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); 777CREATE TABLE "nco:PcsNumber" (ID INTEGER NOT NULL PRIMARY KEY); 778CREATE TABLE "nco:PersonContact" (ID INTEGER NOT NULL PRIMARY KEY, 779"nco:nameFamily" TEXT COLLATE NOCASE, "nco:nameFamily:graph" INTEGER, 780"nco:nameGiven" TEXT COLLATE NOCASE, "nco:nameGiven:graph" INTEGER, 781"nco:nameAdditional" TEXT COLLATE NOCASE, "nco:nameAdditional:graph" 782INTEGER, "nco:nameHonorificSuffix" TEXT COLLATE NOCASE, 783"nco:nameHonorificSuffix:graph" INTEGER, "nco:nameHonorificPrefix" 784TEXT COLLATE NOCASE, "nco:nameHonorificPrefix:graph" INTEGER, 785"nco:hobby" TEXT COLLATE NOCASE, "nco:hobby:graph" INTEGER, 786"nco:gender" INTEGER, "nco:gender:graph" INTEGER); 787CREATE TABLE "nco:PersonContact_nco:hasAffiliation" (ID INTEGER NOT 788NULL, "nco:hasAffiliation" INTEGER NOT NULL, 789"nco:hasAffiliation:graph" INTEGER); 790CREATE TABLE "nco:PhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, 791"nco:phoneNumber" TEXT COLLATE NOCASE, "nco:phoneNumber:graph" 792INTEGER); 793CREATE TABLE "nco:PostalAddress" (ID INTEGER NOT NULL PRIMARY KEY, 794"nco:region" TEXT COLLATE NOCASE, "nco:region:graph" INTEGER, 795"nco:country" TEXT COLLATE NOCASE, "nco:country:graph" INTEGER, 796"nco:extendedAddress" TEXT COLLATE NOCASE, 797"nco:extendedAddress:graph" INTEGER, "nco:addressLocation" INTEGER, 798"nco:addressLocation:graph" INTEGER, "nco:streetAddress" TEXT COLLATE 799NOCASE, "nco:streetAddress:graph" INTEGER, "nco:postalcode" TEXT 800COLLATE NOCASE, "nco:postalcode:graph" INTEGER, "nco:locality" TEXT 801COLLATE NOCASE, "nco:locality:graph" INTEGER, "nco:county" TEXT 802COLLATE NOCASE, "nco:county:graph" INTEGER, "nco:district" TEXT 803COLLATE NOCASE, "nco:district:graph" INTEGER, "nco:pobox" TEXT 804COLLATE NOCASE, "nco:pobox:graph" INTEGER); 805CREATE TABLE "nco:PresenceStatus" (ID INTEGER NOT NULL PRIMARY KEY); 806CREATE TABLE "nco:Role" (ID INTEGER NOT NULL PRIMARY KEY, "nco:video" 807INTEGER, "nco:video:graph" INTEGER); 808CREATE TABLE "nco:Role_nco:blogUrl" (ID INTEGER NOT NULL, 809"nco:blogUrl" INTEGER NOT NULL, "nco:blogUrl:graph" INTEGER); 810CREATE TABLE "nco:Role_nco:foafUrl" (ID INTEGER NOT NULL, 811"nco:foafUrl" INTEGER NOT NULL, "nco:foafUrl:graph" INTEGER); 812CREATE TABLE "nco:Role_nco:hasContactMedium" (ID INTEGER NOT NULL, 813"nco:hasContactMedium" INTEGER NOT NULL, "nco:hasContactMedium:graph" 814INTEGER); 815CREATE TABLE "nco:Role_nco:hasEmailAddress" (ID INTEGER NOT NULL, 816"nco:hasEmailAddress" INTEGER NOT NULL, "nco:hasEmailAddress:graph" 817INTEGER); 818CREATE TABLE "nco:Role_nco:hasIMAddress" (ID INTEGER NOT NULL, 819"nco:hasIMAddress" INTEGER NOT NULL, "nco:hasIMAddress:graph" 820INTEGER); 821CREATE TABLE "nco:Role_nco:hasPhoneNumber" (ID INTEGER NOT NULL, 822"nco:hasPhoneNumber" INTEGER NOT NULL, "nco:hasPhoneNumber:graph" 823INTEGER); 824CREATE TABLE "nco:Role_nco:hasPostalAddress" (ID INTEGER NOT NULL, 825"nco:hasPostalAddress" INTEGER NOT NULL, "nco:hasPostalAddress:graph" 826INTEGER); 827CREATE TABLE "nco:Role_nco:url" (ID INTEGER NOT NULL, "nco:url" 828INTEGER NOT NULL, "nco:url:graph" INTEGER); 829CREATE TABLE "nco:Role_nco:websiteUrl" (ID INTEGER NOT NULL, 830"nco:websiteUrl" INTEGER NOT NULL, "nco:websiteUrl:graph" INTEGER); 831CREATE TABLE "nco:VideoTelephoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 832CREATE TABLE "nco:VoicePhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, 833"nco:voiceMail" INTEGER, "nco:voiceMail:graph" INTEGER); 834CREATE TABLE "nfo:Application" (ID INTEGER NOT NULL PRIMARY KEY); 835CREATE TABLE "nfo:Archive" (ID INTEGER NOT NULL PRIMARY KEY, 836"nfo:uncompressedSize" INTEGER, "nfo:uncompressedSize:graph" INTEGER); 837CREATE TABLE "nfo:ArchiveItem" (ID INTEGER NOT NULL PRIMARY KEY, 838"nfo:isPasswordProtected" INTEGER, "nfo:isPasswordProtected:graph" 839INTEGER); 840CREATE TABLE "nfo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); 841CREATE TABLE "nfo:Audio" (ID INTEGER NOT NULL PRIMARY KEY, 842"nfo:channels" INTEGER, "nfo:channels:graph" INTEGER, 843"nfo:sideChannels" INTEGER, "nfo:sideChannels:graph" INTEGER, 844"nfo:lfeChannels" INTEGER, "nfo:lfeChannels:graph" INTEGER, 845"nfo:sampleCount" INTEGER, "nfo:sampleCount:graph" INTEGER, 846"nfo:bitsPerSample" INTEGER, "nfo:bitsPerSample:graph" INTEGER, 847"nfo:frontChannels" INTEGER, "nfo:frontChannels:graph" INTEGER, 848"nfo:sampleRate" REAL, "nfo:sampleRate:graph" INTEGER, 849"nfo:averageAudioBitrate" REAL, "nfo:averageAudioBitrate:graph" 850INTEGER, "nfo:rearChannels" INTEGER, "nfo:rearChannels:graph" INTEGER, 851"nfo:gain" INTEGER, "nfo:gain:graph" INTEGER, "nfo:peakGain" INTEGER, 852"nfo:peakGain:graph" INTEGER, "nfo:audioOffset" REAL, 853"nfo:audioOffset:graph" INTEGER); 854CREATE TABLE "nfo:Bookmark" (ID INTEGER NOT NULL PRIMARY KEY, 855"nfo:bookmarks" INTEGER, "nfo:bookmarks:graph" INTEGER, 856"nfo:characterPosition" INTEGER, "nfo:characterPosition:graph" 857INTEGER, "nfo:pageNumber" INTEGER, "nfo:pageNumber:graph" INTEGER, 858"nfo:streamPosition" INTEGER, "nfo:streamPosition:graph" INTEGER, 859"nfo:streamDuration" INTEGER, "nfo:streamDuration:graph" INTEGER); 860CREATE TABLE "nfo:BookmarkFolder" (ID INTEGER NOT NULL PRIMARY KEY); 861CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmark" (ID INTEGER NOT 862NULL, "nfo:containsBookmark" INTEGER NOT NULL, 863"nfo:containsBookmark:graph" INTEGER); 864CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID 865INTEGER NOT NULL, "nfo:containsBookmarkFolder" INTEGER NOT NULL, 866"nfo:containsBookmarkFolder:graph" INTEGER); 867CREATE TABLE "nfo:CompressionType" (ID INTEGER NOT NULL PRIMARY KEY); 868CREATE TABLE "nfo:Cursor" (ID INTEGER NOT NULL PRIMARY KEY); 869CREATE TABLE "nfo:DataContainer" (ID INTEGER NOT NULL PRIMARY KEY); 870CREATE TABLE "nfo:DeletedResource" (ID INTEGER NOT NULL PRIMARY KEY, 871"nfo:originalLocation" TEXT COLLATE NOCASE, 872"nfo:originalLocation:graph" INTEGER, "nfo:deletionDate" INTEGER, 873"nfo:deletionDate:graph" INTEGER, "nfo:deletionDate:localDate" 874INTEGER, "nfo:deletionDate:localTime" INTEGER); 875CREATE TABLE "nfo:Document" (ID INTEGER NOT NULL PRIMARY KEY, 876"nfo:tableOfContents" TEXT COLLATE NOCASE, 877"nfo:tableOfContents:graph" INTEGER); 878CREATE TABLE "nfo:EmbeddedFileDataObject" (ID INTEGER NOT NULL PRIMARY 879KEY, "nfo:encoding" TEXT COLLATE NOCASE, "nfo:encoding:graph" 880INTEGER); 881CREATE TABLE "nfo:Equipment" (ID INTEGER NOT NULL PRIMARY KEY, 882"nfo:manufacturer" TEXT COLLATE NOCASE, "nfo:manufacturer:graph" 883INTEGER, "nfo:model" TEXT COLLATE NOCASE, "nfo:model:graph" INTEGER, 884"nfo:equipmentSoftware" TEXT COLLATE NOCASE, 885"nfo:equipmentSoftware:graph" INTEGER); 886CREATE TABLE "nfo:Executable" (ID INTEGER NOT NULL PRIMARY KEY); 887CREATE TABLE "nfo:FileDataObject" (ID INTEGER NOT NULL PRIMARY KEY, 888"nfo:fileLastAccessed" INTEGER, "nfo:fileLastAccessed:graph" INTEGER, 889"nfo:fileLastAccessed:localDate" INTEGER, 890"nfo:fileLastAccessed:localTime" INTEGER, "nfo:fileCreated" INTEGER, 891"nfo:fileCreated:graph" INTEGER, "nfo:fileCreated:localDate" INTEGER, 892"nfo:fileCreated:localTime" INTEGER, "nfo:fileSize" INTEGER, 893"nfo:fileSize:graph" INTEGER, "nfo:permissions" TEXT COLLATE NOCASE, 894"nfo:permissions:graph" INTEGER, "nfo:fileName" TEXT COLLATE NOCASE, 895"nfo:fileName:graph" INTEGER, "nfo:hasHash" INTEGER, 896"nfo:hasHash:graph" INTEGER, "nfo:fileOwner" INTEGER, 897"nfo:fileOwner:graph" INTEGER, "nfo:fileLastModified" INTEGER, 898"nfo:fileLastModified:graph" INTEGER, "nfo:fileLastModified:localDate" 899INTEGER, "nfo:fileLastModified:localTime" INTEGER); 900CREATE TABLE "nfo:FileHash" (ID INTEGER NOT NULL PRIMARY KEY, 901"nfo:hashValue" TEXT COLLATE NOCASE, "nfo:hashValue:graph" INTEGER, 902"nfo:hashAlgorithm" TEXT COLLATE NOCASE, "nfo:hashAlgorithm:graph" 903INTEGER); 904CREATE TABLE "nfo:Filesystem" (ID INTEGER NOT NULL PRIMARY KEY); 905CREATE TABLE "nfo:FilesystemImage" (ID INTEGER NOT NULL PRIMARY KEY); 906CREATE TABLE "nfo:Folder" (ID INTEGER NOT NULL PRIMARY KEY); 907CREATE TABLE "nfo:Font" (ID INTEGER NOT NULL PRIMARY KEY, 908"nfo:fontFamily" TEXT COLLATE NOCASE, "nfo:fontFamily:graph" INTEGER, 909"nfo:foundry" INTEGER, "nfo:foundry:graph" INTEGER); 910CREATE TABLE "nfo:HardDiskPartition" (ID INTEGER NOT NULL PRIMARY KEY); 911CREATE TABLE "nfo:HelpDocument" (ID INTEGER NOT NULL PRIMARY KEY); 912CREATE TABLE "nfo:HtmlDocument" (ID INTEGER NOT NULL PRIMARY KEY); 913CREATE TABLE "nfo:Icon" (ID INTEGER NOT NULL PRIMARY KEY); 914CREATE TABLE "nfo:Image" (ID INTEGER NOT NULL PRIMARY KEY, 915"nfo:verticalResolution" INTEGER, "nfo:verticalResolution:graph" 916INTEGER, "nfo:horizontalResolution" INTEGER, 917"nfo:horizontalResolution:graph" INTEGER, "nfo:orientation" INTEGER, 918"nfo:orientation:graph" INTEGER); 919CREATE TABLE "nfo:Image_nfo:depicts" (ID INTEGER NOT NULL, 920"nfo:depicts" INTEGER NOT NULL, "nfo:depicts:graph" INTEGER); 921CREATE TABLE "nfo:Image_nfo:hasRegionOfInterest" (ID INTEGER NOT NULL, 922"nfo:hasRegionOfInterest" INTEGER NOT NULL, 923"nfo:hasRegionOfInterest:graph" INTEGER); 924CREATE TABLE "nfo:Media" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:count" 925INTEGER, "nfo:count:graph" INTEGER, "nfo:duration" INTEGER, 926"nfo:duration:graph" INTEGER, "nfo:compressionType" INTEGER, 927"nfo:compressionType:graph" INTEGER, "nfo:hasMediaStream" INTEGER, 928"nfo:hasMediaStream:graph" INTEGER, "nfo:bitDepth" INTEGER, 929"nfo:bitDepth:graph" INTEGER, "nfo:codec" TEXT COLLATE NOCASE, 930"nfo:codec:graph" INTEGER, "nfo:encodedBy" TEXT COLLATE NOCASE, 931"nfo:encodedBy:graph" INTEGER, "nfo:bitrateType" TEXT COLLATE NOCASE, 932"nfo:bitrateType:graph" INTEGER, "nfo:averageBitrate" REAL, 933"nfo:averageBitrate:graph" INTEGER, "nfo:genre" TEXT COLLATE NOCASE, 934"nfo:genre:graph" INTEGER, "nfo:equipment" INTEGER, 935"nfo:equipment:graph" INTEGER, "nfo:lastPlayedPosition" INTEGER, 936"nfo:lastPlayedPosition:graph" INTEGER, "nmm:genre" TEXT COLLATE 937NOCASE, "nmm:genre:graph" INTEGER, "nmm:skipCounter" INTEGER, 938"nmm:skipCounter:graph" INTEGER, "nmm:dlnaProfile" TEXT COLLATE 939NOCASE, "nmm:dlnaProfile:graph" INTEGER, "nmm:dlnaMime" TEXT COLLATE 940NOCASE, "nmm:dlnaMime:graph" INTEGER, "nmm:uPnPShared" INTEGER, 941"nmm:uPnPShared:graph" INTEGER, "mtp:credits" TEXT COLLATE NOCASE, 942"mtp:credits:graph" INTEGER, "mtp:creator" TEXT COLLATE NOCASE, 943"mtp:creator:graph" INTEGER); 944CREATE TABLE "nfo:MediaFileListEntry" (ID INTEGER NOT NULL PRIMARY 945KEY, "nfo:listPosition" REAL, "nfo:listPosition:graph" INTEGER, 946"nfo:entryUrl" TEXT COLLATE NOCASE, "nfo:entryUrl:graph" INTEGER); 947CREATE TABLE "nfo:MediaList" (ID INTEGER NOT NULL PRIMARY KEY, 948"nfo:entryCounter" INTEGER, "nfo:entryCounter:graph" INTEGER, 949"nfo:listDuration" INTEGER, "nfo:listDuration:graph" INTEGER); 950CREATE TABLE "nfo:MediaList_nfo:hasMediaFileListEntry" (ID INTEGER NOT 951NULL, "nfo:hasMediaFileListEntry" INTEGER NOT NULL, 952"nfo:hasMediaFileListEntry:graph" INTEGER); 953CREATE TABLE "nfo:MediaList_nfo:mediaListEntry" (ID INTEGER NOT NULL, 954"nfo:mediaListEntry" INTEGER NOT NULL, "nfo:mediaListEntry:graph" 955INTEGER); 956CREATE TABLE "nfo:MediaStream" (ID INTEGER NOT NULL PRIMARY KEY); 957CREATE TABLE "nfo:Media_mtp:hidden" (ID INTEGER NOT NULL, "mtp:hidden" 958INTEGER NOT NULL, "mtp:hidden:graph" INTEGER); 959CREATE TABLE "nfo:Media_nmm:alternativeMedia" (ID INTEGER NOT NULL, 960"nmm:alternativeMedia" INTEGER NOT NULL, "nmm:alternativeMedia:graph" 961INTEGER); 962CREATE TABLE "nfo:MindMap" (ID INTEGER NOT NULL PRIMARY KEY); 963CREATE TABLE "nfo:Note" (ID INTEGER NOT NULL PRIMARY KEY); 964CREATE TABLE "nfo:OperatingSystem" (ID INTEGER NOT NULL PRIMARY KEY); 965CREATE TABLE "nfo:Orientation" (ID INTEGER NOT NULL PRIMARY KEY); 966CREATE TABLE "nfo:PaginatedTextDocument" (ID INTEGER NOT NULL PRIMARY 967KEY, "nfo:pageCount" INTEGER, "nfo:pageCount:graph" INTEGER); 968CREATE TABLE "nfo:PlainTextDocument" (ID INTEGER NOT NULL PRIMARY KEY); 969CREATE TABLE "nfo:Presentation" (ID INTEGER NOT NULL PRIMARY KEY); 970CREATE TABLE "nfo:RasterImage" (ID INTEGER NOT NULL PRIMARY KEY); 971CREATE TABLE "nfo:RegionOfInterest" (ID INTEGER NOT NULL PRIMARY KEY, 972"nfo:regionOfInterestX" REAL, "nfo:regionOfInterestX:graph" INTEGER, 973"nfo:regionOfInterestY" REAL, "nfo:regionOfInterestY:graph" INTEGER, 974"nfo:regionOfInterestWidth" REAL, "nfo:regionOfInterestWidth:graph" 975INTEGER, "nfo:regionOfInterestHeight" REAL, 976"nfo:regionOfInterestHeight:graph" INTEGER, "nfo:regionOfInterestType" 977INTEGER, "nfo:regionOfInterestType:graph" INTEGER, "nfo:roiRefersTo" 978INTEGER, "nfo:roiRefersTo:graph" INTEGER); 979CREATE TABLE "nfo:RegionOfInterestContent" (ID INTEGER NOT NULL PRIMARY KEY); 980CREATE TABLE "nfo:RemoteDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 981CREATE TABLE "nfo:RemotePortAddress" (ID INTEGER NOT NULL PRIMARY KEY); 982CREATE TABLE "nfo:Software" (ID INTEGER NOT NULL PRIMARY KEY, 983"nfo:conflicts" INTEGER, "nfo:conflicts:graph" INTEGER, 984"nfo:supercedes" INTEGER, "nfo:supercedes:graph" INTEGER, 985"nfo:softwareIcon" INTEGER, "nfo:softwareIcon:graph" INTEGER, 986"nfo:softwareCmdLine" TEXT COLLATE NOCASE, 987"nfo:softwareCmdLine:graph" INTEGER); 988CREATE TABLE "nfo:SoftwareApplication" (ID INTEGER NOT NULL PRIMARY KEY); 989CREATE TABLE "nfo:SoftwareCategory" (ID INTEGER NOT NULL PRIMARY KEY, 990"nfo:softwareCategoryIcon" INTEGER, "nfo:softwareCategoryIcon:graph" 991INTEGER); 992CREATE TABLE "nfo:SoftwareItem" (ID INTEGER NOT NULL PRIMARY KEY); 993CREATE TABLE "nfo:SoftwareService" (ID INTEGER NOT NULL PRIMARY KEY); 994CREATE TABLE "nfo:SourceCode" (ID INTEGER NOT NULL PRIMARY KEY, 995"nfo:commentCharacterCount" INTEGER, "nfo:commentCharacterCount:graph" 996INTEGER, "nfo:programmingLanguage" TEXT COLLATE NOCASE, 997"nfo:programmingLanguage:graph" INTEGER, "nfo:definesClass" TEXT 998COLLATE NOCASE, "nfo:definesClass:graph" INTEGER, 999"nfo:definesFunction" TEXT COLLATE NOCASE, 1000"nfo:definesFunction:graph" INTEGER, "nfo:definesGlobalVariable" TEXT 1001COLLATE NOCASE, "nfo:definesGlobalVariable:graph" INTEGER); 1002CREATE TABLE "nfo:Spreadsheet" (ID INTEGER NOT NULL PRIMARY KEY); 1003CREATE TABLE "nfo:TextDocument" (ID INTEGER NOT NULL PRIMARY KEY, 1004"nfo:wordCount" INTEGER, "nfo:wordCount:graph" INTEGER, 1005"nfo:lineCount" INTEGER, "nfo:lineCount:graph" INTEGER, 1006"nfo:characterCount" INTEGER, "nfo:characterCount:graph" INTEGER); 1007CREATE TABLE "nfo:Trash" (ID INTEGER NOT NULL PRIMARY KEY); 1008CREATE TABLE "nfo:VectorImage" (ID INTEGER NOT NULL PRIMARY KEY); 1009CREATE TABLE "nfo:Video" (ID INTEGER NOT NULL PRIMARY KEY, 1010"nfo:frameRate" REAL, "nfo:frameRate:graph" INTEGER, "nfo:frameCount" 1011INTEGER, "nfo:frameCount:graph" INTEGER, "nfo:averageVideoBitrate" 1012REAL, "nfo:averageVideoBitrate:graph" INTEGER); 1013CREATE TABLE "nfo:Visual" (ID INTEGER NOT NULL PRIMARY KEY, 1014"nie:contentCreated" INTEGER, "nie:contentCreated:graph" INTEGER, 1015"nie:contentCreated:localDate" INTEGER, "nie:contentCreated:localTime" 1016INTEGER, "nfo:aspectRatio" REAL, "nfo:aspectRatio:graph" INTEGER, 1017"nfo:heading" REAL, "nfo:heading:graph" INTEGER, "nfo:tilt" REAL, 1018"nfo:tilt:graph" INTEGER, "nfo:interlaceMode" INTEGER, 1019"nfo:interlaceMode:graph" INTEGER, "nfo:height" INTEGER, 1020"nfo:height:graph" INTEGER, "nfo:width" INTEGER, "nfo:width:graph" 1021INTEGER, "nfo:colorDepth" INTEGER, "nfo:colorDepth:graph" INTEGER); 1022CREATE TABLE "nfo:WebHistory" (ID INTEGER NOT NULL PRIMARY KEY, 1023"nfo:domain" TEXT COLLATE NOCASE, "nfo:domain:graph" INTEGER, 1024"nfo:uri" TEXT COLLATE NOCASE, "nfo:uri:graph" INTEGER); 1025CREATE TABLE "nfo:Website" (ID INTEGER NOT NULL PRIMARY KEY); 1026CREATE TABLE "nid3:ID3Audio" (ID INTEGER NOT NULL PRIMARY KEY, 1027"nid3:title" TEXT COLLATE NOCASE, "nid3:title:graph" INTEGER, 1028"nid3:albumTitle" TEXT COLLATE NOCASE, "nid3:albumTitle:graph" 1029INTEGER, "nid3:contentType" TEXT COLLATE NOCASE, 1030"nid3:contentType:graph" INTEGER, "nid3:length" INTEGER, 1031"nid3:length:graph" INTEGER, "nid3:recordingYear" INTEGER, 1032"nid3:recordingYear:graph" INTEGER, "nid3:trackNumber" TEXT COLLATE 1033NOCASE, "nid3:trackNumber:graph" INTEGER, "nid3:partOfSet" TEXT 1034COLLATE NOCASE, "nid3:partOfSet:graph" INTEGER, "nid3:comments" TEXT 1035COLLATE NOCASE, "nid3:comments:graph" INTEGER); 1036CREATE TABLE "nid3:ID3Audio_nid3:leadArtist" (ID INTEGER NOT NULL, 1037"nid3:leadArtist" INTEGER NOT NULL, "nid3:leadArtist:graph" INTEGER); 1038CREATE TABLE "nie:DataObject" (ID INTEGER NOT NULL PRIMARY KEY, 1039"nie:url" TEXT COLLATE NOCASE UNIQUE, "nie:url:graph" INTEGER, 1040"nie:byteSize" INTEGER, "nie:byteSize:graph" INTEGER, 1041"nie:interpretedAs" INTEGER, "nie:interpretedAs:graph" INTEGER, 1042"nie:lastRefreshed" INTEGER, "nie:lastRefreshed:graph" INTEGER, 1043"nie:lastRefreshed:localDate" INTEGER, "nie:lastRefreshed:localTime" 1044INTEGER, "nie:created" INTEGER, "nie:created:graph" INTEGER, 1045"nie:created:localDate" INTEGER, "nie:created:localTime" INTEGER, 1046"nfo:belongsToContainer" INTEGER, "nfo:belongsToContainer:graph" 1047INTEGER, "tracker:available" INTEGER, "tracker:available:graph" 1048INTEGER); 1049CREATE TABLE "nie:DataObject_nie:dataSource" (ID INTEGER NOT NULL, 1050"nie:dataSource" INTEGER NOT NULL, "nie:dataSource:graph" INTEGER); 1051CREATE TABLE "nie:DataObject_nie:isPartOf" (ID INTEGER NOT NULL, 1052"nie:isPartOf" INTEGER NOT NULL, "nie:isPartOf:graph" INTEGER); 1053CREATE TABLE "nie:DataSource" (ID INTEGER NOT NULL PRIMARY KEY); 1054CREATE TABLE "nie:InformationElement" (ID INTEGER NOT NULL PRIMARY 1055KEY, "nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1056"nie:contentLastModified" INTEGER, "nie:contentLastModified:graph" 1057INTEGER, "nie:contentLastModified:localDate" INTEGER, 1058"nie:contentLastModified:localTime" INTEGER, "nie:subject" TEXT 1059COLLATE NOCASE, "nie:subject:graph" INTEGER, "nie:mimeType" TEXT 1060COLLATE NOCASE, "nie:mimeType:graph" INTEGER, "nie:language" TEXT 1061COLLATE NOCASE, "nie:language:graph" INTEGER, "nie:plainTextContent" 1062TEXT COLLATE NOCASE, "nie:plainTextContent:graph" INTEGER, 1063"nie:legal" TEXT COLLATE NOCASE, "nie:legal:graph" INTEGER, 1064"nie:generator" TEXT COLLATE NOCASE, "nie:generator:graph" INTEGER, 1065"nie:description" TEXT COLLATE NOCASE, "nie:description:graph" 1066INTEGER, "nie:disclaimer" TEXT COLLATE NOCASE, "nie:disclaimer:graph" 1067INTEGER, "nie:depends" INTEGER, "nie:depends:graph" INTEGER, 1068"nie:links" INTEGER, "nie:links:graph" INTEGER, "nie:copyright" TEXT 1069COLLATE NOCASE, "nie:copyright:graph" INTEGER, "nie:comment" TEXT 1070COLLATE NOCASE, "nie:comment:graph" INTEGER, "nie:isStoredAs" 1071INTEGER, "nie:isStoredAs:graph" INTEGER, "nie:version" TEXT COLLATE 1072NOCASE, "nie:version:graph" INTEGER, "nie:contentCreated" INTEGER, 1073"nie:contentCreated:graph" INTEGER, "nie:contentCreated:localDate" 1074INTEGER, "nie:contentCreated:localTime" INTEGER, "nie:contentAccessed" 1075INTEGER, "nie:contentAccessed:graph" INTEGER, 1076"nie:contentAccessed:localDate" INTEGER, 1077"nie:contentAccessed:localTime" INTEGER, "nie:license" TEXT COLLATE 1078NOCASE, "nie:license:graph" INTEGER, "nie:identifier" TEXT COLLATE 1079NOCASE, "nie:identifier:graph" INTEGER, "nie:licenseType" TEXT 1080COLLATE NOCASE, "nie:licenseType:graph" INTEGER, "nie:characterSet" 1081TEXT COLLATE NOCASE, "nie:characterSet:graph" INTEGER, 1082"nie:contentSize" INTEGER, "nie:contentSize:graph" INTEGER, 1083"nie:rootElementOf" INTEGER, "nie:rootElementOf:graph" INTEGER, 1084"nie:usageCounter" INTEGER, "nie:usageCounter:graph" INTEGER, 1085"nco:publisher" INTEGER, "nco:publisher:graph" INTEGER, 1086"nfo:isContentEncrypted" INTEGER, "nfo:isContentEncrypted:graph" 1087INTEGER, "slo:location" INTEGER, "slo:location:graph" INTEGER, 1088"nfo:isBootable" INTEGER, "nfo:isBootable:graph" INTEGER, "osinfo:id" 1089TEXT COLLATE NOCASE, "osinfo:id:graph" INTEGER, "osinfo:mediaId" TEXT 1090COLLATE NOCASE, "osinfo:mediaId:graph" INTEGER); 1091CREATE TABLE "nie:InformationElement_mlo:location" (ID INTEGER NOT 1092NULL, "mlo:location" INTEGER NOT NULL, "mlo:location:graph" INTEGER); 1093CREATE TABLE "nie:InformationElement_nao:hasProperty" (ID INTEGER NOT 1094NULL, "nao:hasProperty" INTEGER NOT NULL, "nao:hasProperty:graph" 1095INTEGER); 1096CREATE TABLE "nie:InformationElement_nco:contributor" (ID INTEGER NOT 1097NULL, "nco:contributor" INTEGER NOT NULL, "nco:contributor:graph" 1098INTEGER); 1099CREATE TABLE "nie:InformationElement_nco:creator" (ID INTEGER NOT 1100NULL, "nco:creator" INTEGER NOT NULL, "nco:creator:graph" INTEGER); 1101CREATE TABLE "nie:InformationElement_nie:hasLogicalPart" (ID INTEGER 1102NOT NULL, "nie:hasLogicalPart" INTEGER NOT NULL, 1103"nie:hasLogicalPart:graph" INTEGER); 1104CREATE TABLE "nie:InformationElement_nie:hasPart" (ID INTEGER NOT 1105NULL, "nie:hasPart" INTEGER NOT NULL, "nie:hasPart:graph" INTEGER); 1106CREATE TABLE "nie:InformationElement_nie:informationElementDate" (ID 1107INTEGER NOT NULL, "nie:informationElementDate" INTEGER NOT NULL, 1108"nie:informationElementDate:graph" INTEGER, 1109"nie:informationElementDate:localDate" INTEGER NOT NULL, 1110"nie:informationElementDate:localTime" INTEGER NOT NULL); 1111CREATE TABLE "nie:InformationElement_nie:isLogicalPartOf" (ID INTEGER 1112NOT NULL, "nie:isLogicalPartOf" INTEGER NOT NULL, 1113"nie:isLogicalPartOf:graph" INTEGER); 1114CREATE TABLE "nie:InformationElement_nie:keyword" (ID INTEGER NOT 1115NULL, "nie:keyword" TEXT NOT NULL, "nie:keyword:graph" INTEGER); 1116CREATE TABLE "nie:InformationElement_nie:relatedTo" (ID INTEGER NOT 1117NULL, "nie:relatedTo" INTEGER NOT NULL, "nie:relatedTo:graph" 1118INTEGER); 1119CREATE TABLE "nmm:AnalogRadio" (ID INTEGER NOT NULL PRIMARY KEY, 1120"nmm:modulation" INTEGER, "nmm:modulation:graph" INTEGER, 1121"nmm:frequency" INTEGER, "nmm:frequency:graph" INTEGER); 1122CREATE TABLE "nmm:Artist" (ID INTEGER NOT NULL PRIMARY KEY, 1123"nmm:artistName" TEXT COLLATE NOCASE, "nmm:artistName:graph" 1124INTEGER); 1125CREATE TABLE "nmm:DigitalRadio" (ID INTEGER NOT NULL PRIMARY KEY, 1126"nmm:streamingBitrate" INTEGER, "nmm:streamingBitrate:graph" INTEGER, 1127"nmm:encoding" TEXT COLLATE NOCASE, "nmm:encoding:graph" INTEGER, 1128"nmm:protocol" TEXT COLLATE NOCASE, "nmm:protocol:graph" INTEGER); 1129CREATE TABLE "nmm:Flash" (ID INTEGER NOT NULL PRIMARY KEY); 1130CREATE TABLE "nmm:ImageList" (ID INTEGER NOT NULL PRIMARY KEY); 1131CREATE TABLE "nmm:MeteringMode" (ID INTEGER NOT NULL PRIMARY KEY); 1132CREATE TABLE "nmm:MusicAlbum" (ID INTEGER NOT NULL PRIMARY KEY, 1133"nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1134"nmm:albumTrackCount" INTEGER, "nmm:albumTrackCount:graph" INTEGER, 1135"nmm:albumTitle" TEXT COLLATE NOCASE, "nmm:albumTitle:graph" INTEGER, 1136"nmm:albumDuration" INTEGER, "nmm:albumDuration:graph" INTEGER, 1137"nmm:albumGain" INTEGER, "nmm:albumGain:graph" INTEGER, 1138"nmm:albumPeakGain" INTEGER, "nmm:albumPeakGain:graph" INTEGER); 1139CREATE TABLE "nmm:MusicAlbumDisc" (ID INTEGER NOT NULL PRIMARY KEY, 1140"nmm:albumDiscAlbum" INTEGER, "nmm:albumDiscAlbum:graph" INTEGER, 1141"nmm:musicCDIdentifier" TEXT COLLATE NOCASE, 1142"nmm:musicCDIdentifier:graph" INTEGER, "nmm:setNumber" INTEGER, 1143"nmm:setNumber:graph" INTEGER); 1144CREATE TABLE "nmm:MusicAlbum_nmm:albumArtist" (ID INTEGER NOT NULL, 1145"nmm:albumArtist" INTEGER NOT NULL, "nmm:albumArtist:graph" INTEGER); 1146CREATE TABLE "nmm:MusicPiece" (ID INTEGER NOT NULL PRIMARY KEY, 1147"nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1148"nmm:musicAlbum" INTEGER, "nmm:musicAlbum:graph" INTEGER, 1149"nmm:musicAlbumDisc" INTEGER, "nmm:musicAlbumDisc:graph" INTEGER, 1150"nmm:beatsPerMinute" INTEGER, "nmm:beatsPerMinute:graph" INTEGER, 1151"nmm:performer" INTEGER, "nmm:performer:graph" INTEGER, "nmm:composer" 1152INTEGER, "nmm:composer:graph" INTEGER, "nmm:lyricist" INTEGER, 1153"nmm:lyricist:graph" INTEGER, "nmm:trackNumber" INTEGER, 1154"nmm:trackNumber:graph" INTEGER, 1155"nmm:internationalStandardRecordingCode" TEXT COLLATE NOCASE, 1156"nmm:internationalStandardRecordingCode:graph" INTEGER); 1157CREATE TABLE "nmm:MusicPiece_nmm:lyrics" (ID INTEGER NOT NULL, 1158"nmm:lyrics" INTEGER NOT NULL, "nmm:lyrics:graph" INTEGER); 1159CREATE TABLE "nmm:Photo" (ID INTEGER NOT NULL PRIMARY KEY, 1160"nmm:exposureTime" REAL, "nmm:exposureTime:graph" INTEGER, "nmm:flash" 1161INTEGER, "nmm:flash:graph" INTEGER, "nmm:fnumber" REAL, 1162"nmm:fnumber:graph" INTEGER, "nmm:focalLength" REAL, 1163"nmm:focalLength:graph" INTEGER, "nmm:isoSpeed" REAL, 1164"nmm:isoSpeed:graph" INTEGER, "nmm:meteringMode" INTEGER, 1165"nmm:meteringMode:graph" INTEGER, "nmm:whiteBalance" INTEGER, 1166"nmm:whiteBalance:graph" INTEGER, "nmm:isCropped" INTEGER, 1167"nmm:isCropped:graph" INTEGER, "nmm:isColorCorrected" INTEGER, 1168"nmm:isColorCorrected:graph" INTEGER); 1169CREATE TABLE "nmm:Playlist" (ID INTEGER NOT NULL PRIMARY KEY); 1170CREATE TABLE "nmm:RadioModulation" (ID INTEGER NOT NULL PRIMARY KEY); 1171CREATE TABLE "nmm:RadioStation" (ID INTEGER NOT NULL PRIMARY KEY, 1172"nmm:radioIcon" INTEGER, "nmm:radioIcon:graph" INTEGER, "nmm:radioPTY" 1173INTEGER, "nmm:radioPTY:graph" INTEGER); 1174CREATE TABLE "nmm:RadioStation_nmm:carrier" (ID INTEGER NOT NULL, 1175"nmm:carrier" INTEGER NOT NULL, "nmm:carrier:graph" INTEGER); 1176CREATE TABLE "nmm:SynchronizedText" (ID INTEGER NOT NULL PRIMARY KEY, 1177"nmm:isForHearingImpaired" INTEGER, "nmm:isForHearingImpaired:graph" 1178INTEGER); 1179CREATE TABLE "nmm:Video" (ID INTEGER NOT NULL PRIMARY KEY, 1180"nmm:videoAlbum" INTEGER, "nmm:videoAlbum:graph" INTEGER, 1181"nmm:isSeries" INTEGER, "nmm:isSeries:graph" INTEGER, "nmm:season" 1182INTEGER, "nmm:season:graph" INTEGER, "nmm:episodeNumber" INTEGER, 1183"nmm:episodeNumber:graph" INTEGER, "nmm:runTime" INTEGER, 1184"nmm:runTime:graph" INTEGER, "nmm:synopsis" TEXT COLLATE NOCASE, 1185"nmm:synopsis:graph" INTEGER, "nmm:MPAARating" TEXT COLLATE NOCASE, 1186"nmm:MPAARating:graph" INTEGER, "nmm:category" TEXT COLLATE NOCASE, 1187"nmm:category:graph" INTEGER, "nmm:producedBy" INTEGER, 1188"nmm:producedBy:graph" INTEGER, "nmm:hasSubtitle" INTEGER, 1189"nmm:hasSubtitle:graph" INTEGER, "nmm:isContentEncrypted" INTEGER, 1190"nmm:isContentEncrypted:graph" INTEGER, "mtp:fourCC" TEXT COLLATE 1191NOCASE, "mtp:fourCC:graph" INTEGER, "mtp:waveformat" TEXT COLLATE 1192NOCASE, "mtp:waveformat:graph" INTEGER); 1193CREATE TABLE "nmm:Video_mtp:scantype" (ID INTEGER NOT NULL, 1194"mtp:scantype" INTEGER NOT NULL, "mtp:scantype:graph" INTEGER); 1195CREATE TABLE "nmm:Video_nmm:director" (ID INTEGER NOT NULL, 1196"nmm:director" INTEGER NOT NULL, "nmm:director:graph" INTEGER); 1197CREATE TABLE "nmm:Video_nmm:leadActor" (ID INTEGER NOT NULL, 1198"nmm:leadActor" INTEGER NOT NULL, "nmm:leadActor:graph" INTEGER); 1199CREATE TABLE "nmm:Video_nmm:subtitle" (ID INTEGER NOT NULL, 1200"nmm:subtitle" INTEGER NOT NULL, "nmm:subtitle:graph" INTEGER); 1201CREATE TABLE "nmm:WhiteBalance" (ID INTEGER NOT NULL PRIMARY KEY); 1202CREATE TABLE "nmo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); 1203CREATE TABLE "nmo:Call" (ID INTEGER NOT NULL PRIMARY KEY, 1204"nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, 1205"nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, 1206"nmo:duration" INTEGER, "nmo:duration:graph" INTEGER); 1207CREATE TABLE "nmo:CommunicationChannel" (ID INTEGER NOT NULL PRIMARY 1208KEY, "nmo:lastMessageDate" INTEGER, "nmo:lastMessageDate:graph" 1209INTEGER, "nmo:lastMessageDate:localDate" INTEGER, 1210"nmo:lastMessageDate:localTime" INTEGER, 1211"nmo:lastSuccessfulMessageDate" INTEGER, 1212"nmo:lastSuccessfulMessageDate:graph" INTEGER, 1213"nmo:lastSuccessfulMessageDate:localDate" INTEGER, 1214"nmo:lastSuccessfulMessageDate:localTime" INTEGER); 1215CREATE TABLE "nmo:CommunicationChannel_nmo:hasParticipant" (ID INTEGER 1216NOT NULL, "nmo:hasParticipant" INTEGER NOT NULL, 1217"nmo:hasParticipant:graph" INTEGER); 1218CREATE TABLE "nmo:Conversation" (ID INTEGER NOT NULL PRIMARY KEY); 1219CREATE TABLE "nmo:DeliveryStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1220CREATE TABLE "nmo:Email" (ID INTEGER NOT NULL PRIMARY KEY, 1221"nmo:hasContent" INTEGER, "nmo:hasContent:graph" INTEGER, 1222"nmo:isFlagged" INTEGER, "nmo:isFlagged:graph" INTEGER, "nmo:isRecent" 1223INTEGER, "nmo:isRecent:graph" INTEGER, "nmo:status" TEXT COLLATE 1224NOCASE, "nmo:status:graph" INTEGER, "nmo:responseType" TEXT COLLATE 1225NOCASE, "nmo:responseType:graph" INTEGER); 1226CREATE TABLE "nmo:Email_nmo:contentMimeType" (ID INTEGER NOT NULL, 1227"nmo:contentMimeType" TEXT NOT NULL, "nmo:contentMimeType:graph" 1228INTEGER); 1229CREATE TABLE "nmo:IMMessage" (ID INTEGER NOT NULL PRIMARY KEY); 1230CREATE TABLE "nmo:MMSMessage" (ID INTEGER NOT NULL PRIMARY KEY, 1231"nmo:mmsHasContent" INTEGER, "nmo:mmsHasContent:graph" INTEGER); 1232CREATE TABLE "nmo:MailAccount" (ID INTEGER NOT NULL PRIMARY KEY, 1233"nmo:accountName" TEXT COLLATE NOCASE, "nmo:accountName:graph" 1234INTEGER, "nmo:accountDisplayName" TEXT COLLATE NOCASE, 1235"nmo:accountDisplayName:graph" INTEGER, "nmo:fromAddress" INTEGER, 1236"nmo:fromAddress:graph" INTEGER, "nmo:signature" TEXT COLLATE NOCASE, 1237"nmo:signature:graph" INTEGER); 1238CREATE TABLE "nmo:MailFolder" (ID INTEGER NOT NULL PRIMARY KEY, 1239"nmo:folderName" TEXT COLLATE NOCASE, "nmo:folderName:graph" INTEGER, 1240"nmo:serverCount" INTEGER, "nmo:serverCount:graph" INTEGER, 1241"nmo:serverUnreadCount" INTEGER, "nmo:serverUnreadCount:graph" 1242INTEGER); 1243CREATE TABLE "nmo:MailboxDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 1244CREATE TABLE "nmo:Message" (ID INTEGER NOT NULL PRIMARY KEY, 1245"nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, 1246"nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, 1247"nmo:from" INTEGER, "nmo:from:graph" INTEGER, "nmo:isAnswered" 1248INTEGER, "nmo:isAnswered:graph" INTEGER, "nmo:isDeleted" INTEGER, 1249"nmo:isDeleted:graph" INTEGER, "nmo:isDraft" INTEGER, 1250"nmo:isDraft:graph" INTEGER, "nmo:isRead" INTEGER, "nmo:isRead:graph" 1251INTEGER, "nmo:isSent" INTEGER, "nmo:isSent:graph" INTEGER, 1252"nmo:isEmergency" INTEGER, "nmo:isEmergency:graph" INTEGER, 1253"nmo:htmlMessageContent" TEXT COLLATE NOCASE, 1254"nmo:htmlMessageContent:graph" INTEGER, "nmo:messageId" TEXT COLLATE 1255NOCASE, "nmo:messageId:graph" INTEGER, "nmo:messageSubject" TEXT 1256COLLATE NOCASE, "nmo:messageSubject:graph" INTEGER, 1257"nmo:receivedDate" INTEGER, "nmo:receivedDate:graph" INTEGER, 1258"nmo:receivedDate:localDate" INTEGER, "nmo:receivedDate:localTime" 1259INTEGER, "nmo:replyTo" INTEGER, "nmo:replyTo:graph" INTEGER, 1260"nmo:sender" INTEGER, "nmo:sender:graph" INTEGER, "nmo:conversation" 1261INTEGER, "nmo:conversation:graph" INTEGER, "nmo:communicationChannel" 1262INTEGER, "nmo:communicationChannel:graph" INTEGER, 1263"nmo:deliveryStatus" INTEGER, "nmo:deliveryStatus:graph" INTEGER, 1264"nmo:reportDelivery" INTEGER, "nmo:reportDelivery:graph" INTEGER, 1265"nmo:sentWithReportRead" INTEGER, "nmo:sentWithReportRead:graph" 1266INTEGER, "nmo:reportReadStatus" INTEGER, "nmo:reportReadStatus:graph" 1267INTEGER, "nmo:mustAnswerReportRead" INTEGER, 1268"nmo:mustAnswerReportRead:graph" INTEGER, "nmo:mmsId" TEXT COLLATE 1269NOCASE, "nmo:mmsId:graph" INTEGER); 1270CREATE TABLE "nmo:MessageHeader" (ID INTEGER NOT NULL PRIMARY KEY, 1271"nmo:headerName" TEXT COLLATE NOCASE, "nmo:headerName:graph" INTEGER, 1272"nmo:headerValue" TEXT COLLATE NOCASE, "nmo:headerValue:graph" 1273INTEGER); 1274CREATE TABLE "nmo:Message_nmo:bcc" (ID INTEGER NOT NULL, "nmo:bcc" 1275INTEGER NOT NULL, "nmo:bcc:graph" INTEGER); 1276CREATE TABLE "nmo:Message_nmo:cc" (ID INTEGER NOT NULL, "nmo:cc" 1277INTEGER NOT NULL, "nmo:cc:graph" INTEGER); 1278CREATE TABLE "nmo:Message_nmo:hasAttachment" (ID INTEGER NOT NULL, 1279"nmo:hasAttachment" INTEGER NOT NULL, "nmo:hasAttachment:graph" 1280INTEGER); 1281CREATE TABLE "nmo:Message_nmo:inReplyTo" (ID INTEGER NOT NULL, 1282"nmo:inReplyTo" INTEGER NOT NULL, "nmo:inReplyTo:graph" INTEGER); 1283CREATE TABLE "nmo:Message_nmo:messageHeader" (ID INTEGER NOT NULL, 1284"nmo:messageHeader" INTEGER NOT NULL, "nmo:messageHeader:graph" 1285INTEGER); 1286CREATE TABLE "nmo:Message_nmo:recipient" (ID INTEGER NOT NULL, 1287"nmo:recipient" INTEGER NOT NULL, "nmo:recipient:graph" INTEGER); 1288CREATE TABLE "nmo:Message_nmo:references" (ID INTEGER NOT NULL, 1289"nmo:references" INTEGER NOT NULL, "nmo:references:graph" INTEGER); 1290CREATE TABLE "nmo:Message_nmo:to" (ID INTEGER NOT NULL, "nmo:to" 1291INTEGER NOT NULL, "nmo:to:graph" INTEGER); 1292CREATE TABLE "nmo:MimePart" (ID INTEGER NOT NULL PRIMARY KEY, 1293"nmo:charSet" TEXT COLLATE NOCASE, "nmo:charSet:graph" INTEGER, 1294"nmo:contentId" TEXT COLLATE NOCASE, "nmo:contentId:graph" INTEGER, 1295"nmo:contentTransferEncoding" TEXT COLLATE NOCASE, 1296"nmo:contentTransferEncoding:graph" INTEGER, "nmo:contentDescription" 1297TEXT COLLATE NOCASE, "nmo:contentDescription:graph" INTEGER, 1298"nmo:contentDisposition" TEXT COLLATE NOCASE, 1299"nmo:contentDisposition:graph" INTEGER); 1300CREATE TABLE "nmo:MimePart_nmo:mimeHeader" (ID INTEGER NOT NULL, 1301"nmo:mimeHeader" INTEGER NOT NULL, "nmo:mimeHeader:graph" INTEGER); 1302CREATE TABLE "nmo:Multipart" (ID INTEGER NOT NULL PRIMARY KEY); 1303CREATE TABLE "nmo:Multipart_nmo:partBoundary" (ID INTEGER NOT NULL, 1304"nmo:partBoundary" TEXT NOT NULL, "nmo:partBoundary:graph" INTEGER); 1305CREATE TABLE "nmo:PermanentChannel" (ID INTEGER NOT NULL PRIMARY KEY); 1306CREATE TABLE "nmo:PhoneMessage" (ID INTEGER NOT NULL PRIMARY KEY, 1307"nmo:fromVCard" INTEGER, "nmo:fromVCard:graph" INTEGER, "nmo:encoding" 1308TEXT COLLATE NOCASE, "nmo:encoding:graph" INTEGER, 1309"nmo:phoneMessageId" INTEGER, "nmo:phoneMessageId:graph" INTEGER, 1310"nmo:validityPeriod" INTEGER, "nmo:validityPeriod:graph" INTEGER); 1311CREATE TABLE "nmo:PhoneMessageFolder" (ID INTEGER NOT NULL PRIMARY 1312KEY, "nmo:phoneMessageFolderId" TEXT COLLATE NOCASE, 1313"nmo:phoneMessageFolderId:graph" INTEGER); 1314CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID 1315INTEGER NOT NULL, "nmo:containsPhoneMessage" INTEGER NOT NULL, 1316"nmo:containsPhoneMessage:graph" INTEGER); 1317CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" 1318(ID INTEGER NOT NULL, "nmo:containsPhoneMessageFolder" INTEGER NOT 1319NULL, "nmo:containsPhoneMessageFolder:graph" INTEGER); 1320CREATE TABLE "nmo:PhoneMessage_nmo:toVCard" (ID INTEGER NOT NULL, 1321"nmo:toVCard" INTEGER NOT NULL, "nmo:toVCard:graph" INTEGER); 1322CREATE TABLE "nmo:ReportReadStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1323CREATE TABLE "nmo:SMSMessage" (ID INTEGER NOT NULL PRIMARY KEY); 1324CREATE TABLE "nmo:TransientChannel" (ID INTEGER NOT NULL PRIMARY KEY); 1325CREATE TABLE "nmo:VOIPCall" (ID INTEGER NOT NULL PRIMARY KEY); 1326CREATE TABLE "nrl:InverseFunctionalProperty" (ID INTEGER NOT NULL PRIMARY KEY); 1327CREATE TABLE "osinfo:Installer" (ID INTEGER NOT NULL PRIMARY KEY); 1328CREATE TABLE "poi:ObjectOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); 1329CREATE TABLE "rdf:Property" (ID INTEGER NOT NULL PRIMARY KEY, 1330"rdfs:domain" INTEGER, "rdfs:domain:graph" INTEGER, "rdfs:range" 1331INTEGER, "rdfs:range:graph" INTEGER, "tracker:indexed" INTEGER, 1332"tracker:indexed:graph" INTEGER, "tracker:secondaryIndex" INTEGER, 1333"tracker:secondaryIndex:graph" INTEGER, "tracker:fulltextIndexed" 1334INTEGER, "tracker:fulltextIndexed:graph" INTEGER, 1335"tracker:fulltextNoLimit" INTEGER, "tracker:fulltextNoLimit:graph" 1336INTEGER, "tracker:transient" INTEGER, "tracker:transient:graph" 1337INTEGER, "tracker:weight" INTEGER, "tracker:weight:graph" INTEGER, 1338"tracker:defaultValue" TEXT COLLATE NOCASE, 1339"tracker:defaultValue:graph" INTEGER, "nrl:maxCardinality" INTEGER, 1340"nrl:maxCardinality:graph" INTEGER, "tracker:writeback" INTEGER, 1341"tracker:writeback:graph" INTEGER, "tracker:forceJournal" INTEGER, 1342"tracker:forceJournal:graph" INTEGER); 1343CREATE TABLE "rdf:Property_rdfs:subPropertyOf" (ID INTEGER NOT NULL, 1344"rdfs:subPropertyOf" INTEGER NOT NULL, "rdfs:subPropertyOf:graph" 1345INTEGER); 1346CREATE TABLE "rdfs:Class" (ID INTEGER NOT NULL PRIMARY KEY, 1347"tracker:notify" INTEGER, "tracker:notify:graph" INTEGER); 1348CREATE TABLE "rdfs:Class_rdfs:subClassOf" (ID INTEGER NOT NULL, 1349"rdfs:subClassOf" INTEGER NOT NULL, "rdfs:subClassOf:graph" INTEGER); 1350CREATE TABLE "rdfs:Class_tracker:domainIndex" (ID INTEGER NOT NULL, 1351"tracker:domainIndex" INTEGER NOT NULL, "tracker:domainIndex:graph" 1352INTEGER); 1353CREATE TABLE "rdfs:Literal" (ID INTEGER NOT NULL PRIMARY KEY); 1354CREATE TABLE "rdfs:Resource" (ID INTEGER NOT NULL PRIMARY KEY, 1355Available INTEGER NOT NULL, "rdfs:comment" TEXT COLLATE NOCASE, 1356"rdfs:comment:graph" INTEGER, "rdfs:label" TEXT COLLATE NOCASE, 1357"rdfs:label:graph" INTEGER, "tracker:added" INTEGER, 1358"tracker:added:graph" INTEGER, "tracker:added:localDate" INTEGER, 1359"tracker:added:localTime" INTEGER, "tracker:modified" INTEGER, 1360"tracker:modified:graph" INTEGER, "tracker:damaged" INTEGER, 1361"tracker:damaged:graph" INTEGER, "dc:title" TEXT COLLATE NOCASE, 1362"dc:title:graph" INTEGER, "dc:creator" TEXT COLLATE NOCASE, 1363"dc:creator:graph" INTEGER, "dc:subject" TEXT COLLATE NOCASE, 1364"dc:subject:graph" INTEGER, "dc:description" TEXT COLLATE NOCASE, 1365"dc:description:graph" INTEGER, "dc:publisher" TEXT COLLATE NOCASE, 1366"dc:publisher:graph" INTEGER, "dc:type" TEXT COLLATE NOCASE, 1367"dc:type:graph" INTEGER, "dc:format" TEXT COLLATE NOCASE, 1368"dc:format:graph" INTEGER, "dc:identifier" TEXT COLLATE NOCASE, 1369"dc:identifier:graph" INTEGER, "dc:language" TEXT COLLATE NOCASE, 1370"dc:language:graph" INTEGER, "dc:coverage" TEXT COLLATE NOCASE, 1371"dc:coverage:graph" INTEGER, "dc:rights" TEXT COLLATE NOCASE, 1372"dc:rights:graph" INTEGER, "nao:identifier" TEXT COLLATE NOCASE, 1373"nao:identifier:graph" INTEGER, "nao:numericRating" REAL, 1374"nao:numericRating:graph" INTEGER, "nao:lastModified" INTEGER, 1375"nao:lastModified:graph" INTEGER, "nao:lastModified:localDate" 1376INTEGER, "nao:lastModified:localTime" INTEGER); 1377CREATE TABLE "rdfs:Resource_dc:contributor" (ID INTEGER NOT NULL, 1378"dc:contributor" TEXT NOT NULL, "dc:contributor:graph" INTEGER); 1379CREATE TABLE "rdfs:Resource_dc:date" (ID INTEGER NOT NULL, "dc:date" 1380INTEGER NOT NULL, "dc:date:graph" INTEGER, "dc:date:localDate" INTEGER 1381NOT NULL, "dc:date:localTime" INTEGER NOT NULL); 1382CREATE TABLE "rdfs:Resource_dc:relation" (ID INTEGER NOT NULL, 1383"dc:relation" TEXT NOT NULL, "dc:relation:graph" INTEGER); 1384CREATE TABLE "rdfs:Resource_dc:source" (ID INTEGER NOT NULL, 1385"dc:source" INTEGER NOT NULL, "dc:source:graph" INTEGER); 1386CREATE TABLE "rdfs:Resource_nao:deprecated" (ID INTEGER NOT NULL, 1387"nao:deprecated" INTEGER NOT NULL, "nao:deprecated:graph" INTEGER); 1388CREATE TABLE "rdfs:Resource_nao:hasTag" (ID INTEGER NOT NULL, 1389"nao:hasTag" INTEGER NOT NULL, "nao:hasTag:graph" INTEGER); 1390CREATE TABLE "rdfs:Resource_nao:isRelated" (ID INTEGER NOT NULL, 1391"nao:isRelated" INTEGER NOT NULL, "nao:isRelated:graph" INTEGER); 1392CREATE TABLE "rdfs:Resource_rdf:type" (ID INTEGER NOT NULL, "rdf:type" 1393INTEGER NOT NULL, "rdf:type:graph" INTEGER); 1394CREATE TABLE "scal:AccessLevel" (ID INTEGER NOT NULL PRIMARY KEY); 1395CREATE TABLE "scal:AttendanceStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1396CREATE TABLE "scal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, 1397"scal:attendanceStatus" INTEGER, "scal:attendanceStatus:graph" 1398INTEGER, "scal:attendeeRole" INTEGER, "scal:attendeeRole:graph" 1399INTEGER, "scal:attendeeContact" INTEGER, "scal:attendeeContact:graph" 1400INTEGER, "scal:rsvp" INTEGER, "scal:rsvp:graph" INTEGER, 1401"scal:calendarUserType" INTEGER, "scal:calendarUserType:graph" 1402INTEGER); 1403CREATE TABLE "scal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); 1404CREATE TABLE "scal:Attendee_scal:delegated-from" (ID INTEGER NOT NULL, 1405"scal:delegated-from" INTEGER NOT NULL, "scal:delegated-from:graph" 1406INTEGER); 1407CREATE TABLE "scal:Attendee_scal:delegated-to" (ID INTEGER NOT NULL, 1408"scal:delegated-to" INTEGER NOT NULL, "scal:delegated-to:graph" 1409INTEGER); 1410CREATE TABLE "scal:Attendee_scal:member" (ID INTEGER NOT NULL, 1411"scal:member" INTEGER NOT NULL, "scal:member:graph" INTEGER); 1412CREATE TABLE "scal:Attendee_scal:sent-by" (ID INTEGER NOT NULL, 1413"scal:sent-by" INTEGER NOT NULL, "scal:sent-by:graph" INTEGER); 1414CREATE TABLE "scal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY); 1415CREATE TABLE "scal:CalendarAlarm" (ID INTEGER NOT NULL PRIMARY KEY, 1416"scal:alarmOffset" INTEGER, "scal:alarmOffset:graph" INTEGER); 1417CREATE TABLE "scal:CalendarAlarm_scal:alarmAttendee" (ID INTEGER NOT 1418NULL, "scal:alarmAttendee" INTEGER NOT NULL, 1419"scal:alarmAttendee:graph" INTEGER); 1420CREATE TABLE "scal:CalendarItem" (ID INTEGER NOT NULL PRIMARY KEY, 1421"scal:textLocation" INTEGER, "scal:textLocation:graph" INTEGER, 1422"scal:resources" TEXT COLLATE NOCASE, "scal:resources:graph" INTEGER, 1423"scal:transparency" INTEGER, "scal:transparency:graph" INTEGER, 1424"scal:calendarItemAlarm" INTEGER, "scal:calendarItemAlarm:graph" 1425INTEGER, "scal:start" INTEGER, "scal:start:graph" INTEGER, "scal:end" 1426INTEGER, "scal:end:graph" INTEGER, "scal:isAllDay" INTEGER, 1427"scal:isAllDay:graph" INTEGER, "scal:priority" INTEGER, 1428"scal:priority:graph" INTEGER, "scal:rdate" INTEGER, 1429"scal:rdate:graph" INTEGER, "scal:exceptionRDate" INTEGER, 1430"scal:exceptionRDate:graph" INTEGER); 1431CREATE TABLE "scal:CalendarItem_scal:access" (ID INTEGER NOT NULL, 1432"scal:access" INTEGER NOT NULL, "scal:access:graph" INTEGER); 1433CREATE TABLE "scal:CalendarItem_scal:attachment" (ID INTEGER NOT NULL, 1434"scal:attachment" INTEGER NOT NULL, "scal:attachment:graph" INTEGER); 1435CREATE TABLE "scal:CalendarItem_scal:attendee" (ID INTEGER NOT NULL, 1436"scal:attendee" INTEGER NOT NULL, "scal:attendee:graph" INTEGER); 1437CREATE TABLE "scal:CalendarItem_scal:belongsToCalendar" (ID INTEGER 1438NOT NULL, "scal:belongsToCalendar" INTEGER NOT NULL, 1439"scal:belongsToCalendar:graph" INTEGER); 1440CREATE TABLE "scal:CalendarItem_scal:contact" (ID INTEGER NOT NULL, 1441"scal:contact" INTEGER NOT NULL, "scal:contact:graph" INTEGER); 1442CREATE TABLE "scal:CalendarItem_scal:rrule" (ID INTEGER NOT NULL, 1443"scal:rrule" INTEGER NOT NULL, "scal:rrule:graph" INTEGER); 1444CREATE TABLE "scal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); 1445CREATE TABLE "scal:Event" (ID INTEGER NOT NULL PRIMARY KEY, 1446"scal:eventStatus" INTEGER, "scal:eventStatus:graph" INTEGER); 1447CREATE TABLE "scal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1448CREATE TABLE "scal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, 1449"scal:journalStatus" INTEGER, "scal:journalStatus:graph" INTEGER); 1450CREATE TABLE "scal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1451CREATE TABLE "scal:RSVPValues" (ID INTEGER NOT NULL PRIMARY KEY); 1452CREATE TABLE "scal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, 1453"scal:recurrencePattern" TEXT COLLATE NOCASE, 1454"scal:recurrencePattern:graph" INTEGER, "scal:recurrenceStartDate" 1455INTEGER, "scal:recurrenceStartDate:graph" INTEGER, "scal:exception" 1456INTEGER, "scal:exception:graph" INTEGER); 1457CREATE TABLE "scal:TimePoint" (ID INTEGER NOT NULL PRIMARY KEY, 1458"scal:dateTime" INTEGER, "scal:dateTime:graph" INTEGER, 1459"scal:dateTime:localDate" INTEGER, "scal:dateTime:localTime" INTEGER, 1460"scal:TimeZone" TEXT COLLATE NOCASE, "scal:TimeZone:graph" INTEGER); 1461CREATE TABLE "scal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, 1462"scal:todoStatus" INTEGER, "scal:todoStatus:graph" INTEGER, "scal:due" 1463INTEGER, "scal:due:graph" INTEGER, "scal:completed" INTEGER, 1464"scal:completed:graph" INTEGER, "scal:percentComplete" INTEGER, 1465"scal:percentComplete:graph" INTEGER); 1466CREATE TABLE "scal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1467CREATE TABLE "scal:TransparencyValues" (ID INTEGER NOT NULL PRIMARY KEY); 1468CREATE TABLE "slo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY, 1469"slo:latitude" REAL, "slo:latitude:graph" INTEGER, "slo:longitude" 1470REAL, "slo:longitude:graph" INTEGER, "slo:verticalAccuracy" REAL, 1471"slo:verticalAccuracy:graph" INTEGER, "slo:horizontalAccuracy" REAL, 1472"slo:horizontalAccuracy:graph" INTEGER, "slo:altitude" REAL, 1473"slo:altitude:graph" INTEGER, "slo:boundingLatitudeMin" REAL, 1474"slo:boundingLatitudeMin:graph" INTEGER, "slo:boundingLatitudeMax" 1475REAL, "slo:boundingLatitudeMax:graph" INTEGER, 1476"slo:boundingLongitudeMin" REAL, "slo:boundingLongitudeMin:graph" 1477INTEGER, "slo:boundingLongitudeMax" REAL, 1478"slo:boundingLongitudeMax:graph" INTEGER, "slo:radius" REAL, 1479"slo:radius:graph" INTEGER, "slo:timestamp" INTEGER, 1480"slo:timestamp:graph" INTEGER, "slo:timestamp:localDate" INTEGER, 1481"slo:timestamp:localTime" INTEGER, "slo:postalAddress" INTEGER, 1482"slo:postalAddress:graph" INTEGER); 1483CREATE TABLE "slo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY, 1484"slo:iconUrl" INTEGER, "slo:iconUrl:graph" INTEGER); 1485CREATE TABLE "slo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY, 1486"slo:isRemovable" INTEGER, "slo:isRemovable:graph" INTEGER, 1487"slo:categoryIconUrl" INTEGER, "slo:categoryIconUrl:graph" INTEGER); 1488CREATE TABLE "slo:Landmark_slo:belongsToCategory" (ID INTEGER NOT 1489NULL, "slo:belongsToCategory" INTEGER NOT NULL, 1490"slo:belongsToCategory:graph" INTEGER); 1491CREATE TABLE "slo:Landmark_slo:hasContact" (ID INTEGER NOT NULL, 1492"slo:hasContact" INTEGER NOT NULL, "slo:hasContact:graph" INTEGER); 1493CREATE TABLE "slo:Route" (ID INTEGER NOT NULL PRIMARY KEY, 1494"slo:startTime" INTEGER, "slo:startTime:graph" INTEGER, 1495"slo:startTime:localDate" INTEGER, "slo:startTime:localTime" INTEGER, 1496"slo:endTime" INTEGER, "slo:endTime:graph" INTEGER, 1497"slo:endTime:localDate" INTEGER, "slo:endTime:localTime" INTEGER); 1498CREATE TABLE "slo:Route_slo:routeDetails" (ID INTEGER NOT NULL, 1499"slo:routeDetails" TEXT NOT NULL, "slo:routeDetails:graph" INTEGER); 1500CREATE TABLE "tracker:Namespace" (ID INTEGER NOT NULL PRIMARY KEY, 1501"tracker:prefix" TEXT COLLATE NOCASE, "tracker:prefix:graph" 1502INTEGER); 1503CREATE TABLE "tracker:Ontology" (ID INTEGER NOT NULL PRIMARY KEY); 1504CREATE TABLE "tracker:Volume" (ID INTEGER NOT NULL PRIMARY KEY, 1505"tracker:isMounted" INTEGER, "tracker:isMounted:graph" INTEGER, 1506"tracker:unmountDate" INTEGER, "tracker:unmountDate:graph" INTEGER, 1507"tracker:unmountDate:localDate" INTEGER, 1508"tracker:unmountDate:localTime" INTEGER, "tracker:mountPoint" INTEGER, 1509"tracker:mountPoint:graph" INTEGER, "tracker:isRemovable" INTEGER, 1510"tracker:isRemovable:graph" INTEGER, "tracker:isOptical" INTEGER, 1511"tracker:isOptical:graph" INTEGER); 1512CREATE UNIQUE INDEX "mfo:FeedMessage_mfo:enclosureList_ID_ID" ON 1513"mfo:FeedMessage_mfo:enclosureList" (ID, "mfo:enclosureList"); 1514CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbNorthWest_ID_ID" ON 1515"mlo:GeoBoundingBox_mlo:bbNorthWest" (ID, "mlo:bbNorthWest"); 1516CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbSouthEast_ID_ID" ON 1517"mlo:GeoBoundingBox_mlo:bbSouthEast" (ID, "mlo:bbSouthEast"); 1518CREATE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID" ON 1519"mlo:GeoLocation_mlo:asBoundingBox" (ID); 1520CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID_ID" ON 1521"mlo:GeoLocation_mlo:asBoundingBox" ("mlo:asBoundingBox", ID); 1522CREATE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID" ON 1523"mlo:GeoLocation_mlo:asGeoPoint" (ID); 1524CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID_ID" ON 1525"mlo:GeoLocation_mlo:asGeoPoint" ("mlo:asGeoPoint", ID); 1526CREATE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID" ON 1527"mlo:GeoLocation_mlo:asPostalAddress" (ID); 1528CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID_ID" ON 1529"mlo:GeoLocation_mlo:asPostalAddress" ("mlo:asPostalAddress", ID); 1530CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:address_ID_ID" ON 1531"mlo:GeoPoint_mlo:address" (ID, "mlo:address"); 1532CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:altitude_ID_ID" ON 1533"mlo:GeoPoint_mlo:altitude" (ID, "mlo:altitude"); 1534CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:city_ID_ID" ON 1535"mlo:GeoPoint_mlo:city" (ID, "mlo:city"); 1536CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:country_ID_ID" ON 1537"mlo:GeoPoint_mlo:country" (ID, "mlo:country"); 1538CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:latitude_ID_ID" ON 1539"mlo:GeoPoint_mlo:latitude" (ID, "mlo:latitude"); 1540CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:longitude_ID_ID" ON 1541"mlo:GeoPoint_mlo:longitude" (ID, "mlo:longitude"); 1542CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:state_ID_ID" ON 1543"mlo:GeoPoint_mlo:state" (ID, "mlo:state"); 1544CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:timestamp_ID_ID" ON 1545"mlo:GeoPoint_mlo:timestamp" (ID, "mlo:timestamp"); 1546CREATE UNIQUE INDEX "mlo:GeoSphere_mlo:radius_ID_ID" ON 1547"mlo:GeoSphere_mlo:radius" (ID, "mlo:radius"); 1548CREATE UNIQUE INDEX "mlo:LandmarkCategory_mlo:isRemovable_ID_ID" ON 1549"mlo:LandmarkCategory_mlo:isRemovable" (ID, "mlo:isRemovable"); 1550CREATE UNIQUE INDEX "mlo:Landmark_mlo:belongsToCategory_ID_ID" ON 1551"mlo:Landmark_mlo:belongsToCategory" (ID, "mlo:belongsToCategory"); 1552CREATE UNIQUE INDEX "mlo:Landmark_mlo:poiLocation_ID_ID" ON 1553"mlo:Landmark_mlo:poiLocation" (ID, "mlo:poiLocation"); 1554CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxEastLimit_ID_ID" 1555ON "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID, 1556"mlo:boxEastLimit"); 1557CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxNorthLimit_ID_ID" 1558ON "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID, 1559"mlo:boxNorthLimit"); 1560CREATE UNIQUE INDEX 1561"mlo:LocationBoundingBox_mlo:boxSouthWestCorner_ID_ID" ON 1562"mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID, 1563"mlo:boxSouthWestCorner"); 1564CREATE UNIQUE INDEX 1565"mlo:LocationBoundingBox_mlo:boxVerticalLimit_ID_ID" ON 1566"mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID, 1567"mlo:boxVerticalLimit"); 1568CREATE UNIQUE INDEX "mlo:Route_mlo:endTime_ID_ID" ON 1569"mlo:Route_mlo:endTime" (ID, "mlo:endTime"); 1570CREATE UNIQUE INDEX "mlo:Route_mlo:routeDetails_ID_ID" ON 1571"mlo:Route_mlo:routeDetails" (ID, "mlo:routeDetails"); 1572CREATE UNIQUE INDEX "mlo:Route_mlo:startTime_ID_ID" ON 1573"mlo:Route_mlo:startTime" (ID, "mlo:startTime"); 1574CREATE UNIQUE INDEX "mto:Transfer_mto:transferList_ID_ID" ON 1575"mto:Transfer_mto:transferList" (ID, "mto:transferList"); 1576CREATE UNIQUE INDEX "mto:Transfer_mto:transferPrivacyLevel_ID_ID" ON 1577"mto:Transfer_mto:transferPrivacyLevel" (ID, 1578"mto:transferPrivacyLevel"); 1579CREATE UNIQUE INDEX "mto:UploadTransfer_mto:transferCategory_ID_ID" ON 1580"mto:UploadTransfer_mto:transferCategory" (ID, 1581"mto:transferCategory"); 1582CREATE UNIQUE INDEX "nao:Tag_tracker:isDefaultTag_ID_ID" ON 1583"nao:Tag_tracker:isDefaultTag" (ID, "tracker:isDefaultTag"); 1584CREATE UNIQUE INDEX "nao:Tag_tracker:tagRelatedTo_ID_ID" ON 1585"nao:Tag_tracker:tagRelatedTo" (ID, "tracker:tagRelatedTo"); 1586CREATE UNIQUE INDEX "ncal:Alarm_ncal:action_ID_ID" ON 1587"ncal:Alarm_ncal:action" (ID, "ncal:action"); 1588CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayModifier_ID_ID" ON 1589"ncal:BydayRulePart_ncal:bydayModifier" (ID, "ncal:bydayModifier"); 1590CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayWeekday_ID_ID" ON 1591"ncal:BydayRulePart_ncal:bydayWeekday" (ID, "ncal:bydayWeekday"); 1592CREATE UNIQUE INDEX "ncal:Calendar_ncal:component_ID_ID" ON 1593"ncal:Calendar_ncal:component" (ID, "ncal:component"); 1594CREATE UNIQUE INDEX "ncal:Freebusy_ncal:freebusy_ID_ID" ON 1595"ncal:Freebusy_ncal:freebusy" (ID, "ncal:freebusy"); 1596CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byday_ID_ID" ON 1597"ncal:RecurrenceRule_ncal:byday" (ID, "ncal:byday"); 1598CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byhour_ID_ID" ON 1599"ncal:RecurrenceRule_ncal:byhour" (ID, "ncal:byhour"); 1600CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byminute_ID_ID" ON 1601"ncal:RecurrenceRule_ncal:byminute" (ID, "ncal:byminute"); 1602CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonth_ID_ID" ON 1603"ncal:RecurrenceRule_ncal:bymonth" (ID, "ncal:bymonth"); 1604CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonthday_ID_ID" ON 1605"ncal:RecurrenceRule_ncal:bymonthday" (ID, "ncal:bymonthday"); 1606CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysecond_ID_ID" ON 1607"ncal:RecurrenceRule_ncal:bysecond" (ID, "ncal:bysecond"); 1608CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysetpos_ID_ID" ON 1609"ncal:RecurrenceRule_ncal:bysetpos" (ID, "ncal:bysetpos"); 1610CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byweekno_ID_ID" ON 1611"ncal:RecurrenceRule_ncal:byweekno" (ID, "ncal:byweekno"); 1612CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byyearday_ID_ID" ON 1613"ncal:RecurrenceRule_ncal:byyearday" (ID, "ncal:byyearday"); 1614CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attach_ID_ID" ON 1615"ncal:UnionParentClass_ncal:attach" (ID, "ncal:attach"); 1616CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attendee_ID_ID" ON 1617"ncal:UnionParentClass_ncal:attendee" (ID, "ncal:attendee"); 1618CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:categories_ID_ID" ON 1619"ncal:UnionParentClass_ncal:categories" (ID, "ncal:categories"); 1620CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exdate_ID_ID" ON 1621"ncal:UnionParentClass_ncal:exdate" (ID, "ncal:exdate"); 1622CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exrule_ID_ID" ON 1623"ncal:UnionParentClass_ncal:exrule" (ID, "ncal:exrule"); 1624CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:hasAlarm_ID_ID" ON 1625"ncal:UnionParentClass_ncal:hasAlarm" (ID, "ncal:hasAlarm"); 1626CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:ncalRelation_ID_ID" ON 1627"ncal:UnionParentClass_ncal:ncalRelation" (ID, "ncal:ncalRelation"); 1628CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rdate_ID_ID" ON 1629"ncal:UnionParentClass_ncal:rdate" (ID, "ncal:rdate"); 1630CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToChild_ID_ID" 1631ON "ncal:UnionParentClass_ncal:relatedToChild" (ID, 1632"ncal:relatedToChild"); 1633CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToParent_ID_ID" 1634ON "ncal:UnionParentClass_ncal:relatedToParent" (ID, 1635"ncal:relatedToParent"); 1636CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:resources_ID_ID" ON 1637"ncal:UnionParentClass_ncal:resources" (ID, "ncal:resources"); 1638CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rrule_ID_ID" ON 1639"ncal:UnionParentClass_ncal:rrule" (ID, "ncal:rrule"); 1640CREATE UNIQUE INDEX "nco:Affiliation_nco:title_ID_ID" ON 1641"nco:Affiliation_nco:title" (ID, "nco:title"); 1642CREATE UNIQUE INDEX "nco:ContactList_nco:containsContact_ID_ID" ON 1643"nco:ContactList_nco:containsContact" (ID, "nco:containsContact"); 1644CREATE UNIQUE INDEX "nco:Contact_ncal:anniversary_ID_ID" ON 1645"nco:Contact_ncal:anniversary" (ID, "ncal:anniversary"); 1646CREATE UNIQUE INDEX "nco:Contact_ncal:birthday_ID_ID" ON 1647"nco:Contact_ncal:birthday" (ID, "ncal:birthday"); 1648CREATE UNIQUE INDEX "nco:Contact_nco:belongsToGroup_ID_ID" ON 1649"nco:Contact_nco:belongsToGroup" (ID, "nco:belongsToGroup"); 1650CREATE UNIQUE INDEX "nco:Contact_nco:note_ID_ID" ON 1651"nco:Contact_nco:note" (ID, "nco:note"); 1652CREATE UNIQUE INDEX "nco:Contact_scal:anniversary_ID_ID" ON 1653"nco:Contact_scal:anniversary" (ID, "scal:anniversary"); 1654CREATE UNIQUE INDEX "nco:Contact_scal:birthday_ID_ID" ON 1655"nco:Contact_scal:birthday" (ID, "scal:birthday"); 1656CREATE UNIQUE INDEX "nco:IMAccount_nco:hasIMContact_ID_ID" ON 1657"nco:IMAccount_nco:hasIMContact" (ID, "nco:hasIMContact"); 1658CREATE UNIQUE INDEX "nco:IMAddress_nco:imCapability_ID_ID" ON 1659"nco:IMAddress_nco:imCapability" (ID, "nco:imCapability"); 1660CREATE UNIQUE INDEX "nco:PersonContact_nco:hasAffiliation_ID_ID" ON 1661"nco:PersonContact_nco:hasAffiliation" (ID, "nco:hasAffiliation"); 1662CREATE INDEX "nco:PersonContact_nco:nameFamily" ON "nco:PersonContact" 1663("nco:nameFamily"); 1664CREATE INDEX "nco:PhoneNumber_nco:phoneNumber" ON "nco:PhoneNumber" 1665("nco:phoneNumber"); 1666CREATE UNIQUE INDEX "nco:Role_nco:blogUrl_ID_ID" ON 1667"nco:Role_nco:blogUrl" (ID, "nco:blogUrl"); 1668CREATE UNIQUE INDEX "nco:Role_nco:foafUrl_ID_ID" ON 1669"nco:Role_nco:foafUrl" (ID, "nco:foafUrl"); 1670CREATE UNIQUE INDEX "nco:Role_nco:hasContactMedium_ID_ID" ON 1671"nco:Role_nco:hasContactMedium" (ID, "nco:hasContactMedium"); 1672CREATE INDEX "nco:Role_nco:hasEmailAddress_ID" ON 1673"nco:Role_nco:hasEmailAddress" (ID); 1674CREATE UNIQUE INDEX "nco:Role_nco:hasEmailAddress_ID_ID" ON 1675"nco:Role_nco:hasEmailAddress" ("nco:hasEmailAddress", ID); 1676CREATE UNIQUE INDEX "nco:Role_nco:hasIMAddress_ID_ID" ON 1677"nco:Role_nco:hasIMAddress" (ID, "nco:hasIMAddress"); 1678CREATE UNIQUE INDEX "nco:Role_nco:hasPhoneNumber_ID_ID" ON 1679"nco:Role_nco:hasPhoneNumber" (ID, "nco:hasPhoneNumber"); 1680CREATE INDEX "nco:Role_nco:hasPostalAddress_ID" ON 1681"nco:Role_nco:hasPostalAddress" (ID); 1682CREATE UNIQUE INDEX "nco:Role_nco:hasPostalAddress_ID_ID" ON 1683"nco:Role_nco:hasPostalAddress" ("nco:hasPostalAddress", ID); 1684CREATE UNIQUE INDEX "nco:Role_nco:url_ID_ID" ON "nco:Role_nco:url" 1685(ID, "nco:url"); 1686CREATE UNIQUE INDEX "nco:Role_nco:websiteUrl_ID_ID" ON 1687"nco:Role_nco:websiteUrl" (ID, "nco:websiteUrl"); 1688CREATE UNIQUE INDEX 1689"nfo:BookmarkFolder_nfo:containsBookmarkFolder_ID_ID" ON 1690"nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID, 1691"nfo:containsBookmarkFolder"); 1692CREATE UNIQUE INDEX "nfo:BookmarkFolder_nfo:containsBookmark_ID_ID" ON 1693"nfo:BookmarkFolder_nfo:containsBookmark" (ID, 1694"nfo:containsBookmark"); 1695CREATE INDEX "nfo:FileDataObject_nfo:fileLastModified" ON 1696"nfo:FileDataObject" ("nfo:fileLastModified"); 1697CREATE UNIQUE INDEX "nfo:Image_nfo:depicts_ID_ID" ON 1698"nfo:Image_nfo:depicts" (ID, "nfo:depicts"); 1699CREATE UNIQUE INDEX "nfo:Image_nfo:hasRegionOfInterest_ID_ID" ON 1700"nfo:Image_nfo:hasRegionOfInterest" (ID, "nfo:hasRegionOfInterest"); 1701CREATE UNIQUE INDEX "nfo:MediaList_nfo:hasMediaFileListEntry_ID_ID" ON 1702"nfo:MediaList_nfo:hasMediaFileListEntry" (ID, 1703"nfo:hasMediaFileListEntry"); 1704CREATE UNIQUE INDEX "nfo:MediaList_nfo:mediaListEntry_ID_ID" ON 1705"nfo:MediaList_nfo:mediaListEntry" (ID, "nfo:mediaListEntry"); 1706CREATE UNIQUE INDEX "nfo:Media_mtp:hidden_ID_ID" ON 1707"nfo:Media_mtp:hidden" (ID, "mtp:hidden"); 1708CREATE UNIQUE INDEX "nfo:Media_nmm:alternativeMedia_ID_ID" ON 1709"nfo:Media_nmm:alternativeMedia" (ID, "nmm:alternativeMedia"); 1710CREATE INDEX "nfo:Visual_nie:contentCreated" ON "nfo:Visual" 1711("nie:contentCreated"); 1712CREATE UNIQUE INDEX "nid3:ID3Audio_nid3:leadArtist_ID_ID" ON 1713"nid3:ID3Audio_nid3:leadArtist" (ID, "nid3:leadArtist"); 1714CREATE UNIQUE INDEX "nie:DataObject_nie:dataSource_ID_ID" ON 1715"nie:DataObject_nie:dataSource" (ID, "nie:dataSource"); 1716CREATE UNIQUE INDEX "nie:DataObject_nie:isPartOf_ID_ID" ON 1717"nie:DataObject_nie:isPartOf" (ID, "nie:isPartOf"); 1718CREATE INDEX "nie:DataObject_nie:url" ON "nie:DataObject" ("nie:url"); 1719CREATE INDEX "nie:InformationElement_mlo:location_ID" ON 1720"nie:InformationElement_mlo:location" (ID); 1721CREATE UNIQUE INDEX "nie:InformationElement_mlo:location_ID_ID" ON 1722"nie:InformationElement_mlo:location" ("mlo:location", ID); 1723CREATE UNIQUE INDEX "nie:InformationElement_nao:hasProperty_ID_ID" ON 1724"nie:InformationElement_nao:hasProperty" (ID, "nao:hasProperty"); 1725CREATE UNIQUE INDEX "nie:InformationElement_nco:contributor_ID_ID" ON 1726"nie:InformationElement_nco:contributor" (ID, "nco:contributor"); 1727CREATE UNIQUE INDEX "nie:InformationElement_nco:creator_ID_ID" ON 1728"nie:InformationElement_nco:creator" (ID, "nco:creator"); 1729CREATE UNIQUE INDEX "nie:InformationElement_nie:hasLogicalPart_ID_ID" 1730ON "nie:InformationElement_nie:hasLogicalPart" (ID, 1731"nie:hasLogicalPart"); 1732CREATE UNIQUE INDEX "nie:InformationElement_nie:hasPart_ID_ID" ON 1733"nie:InformationElement_nie:hasPart" (ID, "nie:hasPart"); 1734CREATE UNIQUE INDEX 1735"nie:InformationElement_nie:informationElementDate_ID_ID" ON 1736"nie:InformationElement_nie:informationElementDate" (ID, 1737"nie:informationElementDate"); 1738CREATE UNIQUE INDEX "nie:InformationElement_nie:isLogicalPartOf_ID_ID" 1739ON "nie:InformationElement_nie:isLogicalPartOf" (ID, 1740"nie:isLogicalPartOf"); 1741CREATE UNIQUE INDEX "nie:InformationElement_nie:keyword_ID_ID" ON 1742"nie:InformationElement_nie:keyword" (ID, "nie:keyword"); 1743CREATE UNIQUE INDEX "nie:InformationElement_nie:relatedTo_ID_ID" ON 1744"nie:InformationElement_nie:relatedTo" (ID, "nie:relatedTo"); 1745CREATE INDEX "nie:InformationElement_slo:location" ON 1746"nie:InformationElement" ("slo:location"); 1747CREATE INDEX "nmm:Artist_nmm:artistName" ON "nmm:Artist" ("nmm:artistName"); 1748CREATE INDEX "nmm:MusicAlbum_nie:title" ON "nmm:MusicAlbum" ("nie:title"); 1749CREATE UNIQUE INDEX "nmm:MusicAlbum_nmm:albumArtist_ID_ID" ON 1750"nmm:MusicAlbum_nmm:albumArtist" (ID, "nmm:albumArtist"); 1751CREATE INDEX "nmm:MusicPiece_nie:title" ON "nmm:MusicPiece" ("nie:title"); 1752CREATE UNIQUE INDEX "nmm:MusicPiece_nmm:lyrics_ID_ID" ON 1753"nmm:MusicPiece_nmm:lyrics" (ID, "nmm:lyrics"); 1754CREATE INDEX "nmm:MusicPiece_nmm:musicAlbum" ON "nmm:MusicPiece" 1755("nmm:musicAlbum"); 1756CREATE INDEX "nmm:MusicPiece_nmm:performer" ON "nmm:MusicPiece" 1757("nmm:performer"); 1758CREATE UNIQUE INDEX "nmm:RadioStation_nmm:carrier_ID_ID" ON 1759"nmm:RadioStation_nmm:carrier" (ID, "nmm:carrier"); 1760CREATE UNIQUE INDEX "nmm:Video_mtp:scantype_ID_ID" ON 1761"nmm:Video_mtp:scantype" (ID, "mtp:scantype"); 1762CREATE UNIQUE INDEX "nmm:Video_nmm:director_ID_ID" ON 1763"nmm:Video_nmm:director" (ID, "nmm:director"); 1764CREATE UNIQUE INDEX "nmm:Video_nmm:leadActor_ID_ID" ON 1765"nmm:Video_nmm:leadActor" (ID, "nmm:leadActor"); 1766CREATE UNIQUE INDEX "nmm:Video_nmm:subtitle_ID_ID" ON 1767"nmm:Video_nmm:subtitle" (ID, "nmm:subtitle"); 1768CREATE INDEX "nmo:Call_nmo:sentDate" ON "nmo:Call" ("nmo:sentDate"); 1769CREATE INDEX "nmo:CommunicationChannel_nmo:hasParticipant_ID" ON 1770"nmo:CommunicationChannel_nmo:hasParticipant" (ID); 1771CREATE UNIQUE INDEX 1772"nmo:CommunicationChannel_nmo:hasParticipant_ID_ID" ON 1773"nmo:CommunicationChannel_nmo:hasParticipant" ("nmo:hasParticipant", 1774ID); 1775CREATE INDEX "nmo:CommunicationChannel_nmo:lastMessageDate" ON 1776"nmo:CommunicationChannel" ("nmo:lastMessageDate"); 1777CREATE UNIQUE INDEX "nmo:Email_nmo:contentMimeType_ID_ID" ON 1778"nmo:Email_nmo:contentMimeType" (ID, "nmo:contentMimeType"); 1779CREATE UNIQUE INDEX "nmo:Message_nmo:bcc_ID_ID" ON 1780"nmo:Message_nmo:bcc" (ID, "nmo:bcc"); 1781CREATE UNIQUE INDEX "nmo:Message_nmo:cc_ID_ID" ON "nmo:Message_nmo:cc" 1782(ID, "nmo:cc"); 1783CREATE INDEX "nmo:Message_nmo:communicationChannel" ON "nmo:Message" 1784("nmo:communicationChannel", "nmo:receivedDate"); 1785CREATE INDEX "nmo:Message_nmo:conversation" ON "nmo:Message" 1786("nmo:conversation"); 1787CREATE INDEX "nmo:Message_nmo:from" ON "nmo:Message" ("nmo:from"); 1788CREATE UNIQUE INDEX "nmo:Message_nmo:hasAttachment_ID_ID" ON 1789"nmo:Message_nmo:hasAttachment" (ID, "nmo:hasAttachment"); 1790CREATE UNIQUE INDEX "nmo:Message_nmo:inReplyTo_ID_ID" ON 1791"nmo:Message_nmo:inReplyTo" (ID, "nmo:inReplyTo"); 1792CREATE UNIQUE INDEX "nmo:Message_nmo:messageHeader_ID_ID" ON 1793"nmo:Message_nmo:messageHeader" (ID, "nmo:messageHeader"); 1794CREATE UNIQUE INDEX "nmo:Message_nmo:recipient_ID_ID" ON 1795"nmo:Message_nmo:recipient" (ID, "nmo:recipient"); 1796CREATE UNIQUE INDEX "nmo:Message_nmo:references_ID_ID" ON 1797"nmo:Message_nmo:references" (ID, "nmo:references"); 1798CREATE INDEX "nmo:Message_nmo:sender" ON "nmo:Message" ("nmo:sender"); 1799CREATE INDEX "nmo:Message_nmo:sentDate" ON "nmo:Message" ("nmo:sentDate"); 1800CREATE INDEX "nmo:Message_nmo:to_ID" ON "nmo:Message_nmo:to" (ID); 1801CREATE UNIQUE INDEX "nmo:Message_nmo:to_ID_ID" ON "nmo:Message_nmo:to" 1802("nmo:to", ID); 1803CREATE UNIQUE INDEX "nmo:MimePart_nmo:mimeHeader_ID_ID" ON 1804"nmo:MimePart_nmo:mimeHeader" (ID, "nmo:mimeHeader"); 1805CREATE UNIQUE INDEX "nmo:Multipart_nmo:partBoundary_ID_ID" ON 1806"nmo:Multipart_nmo:partBoundary" (ID, "nmo:partBoundary"); 1807CREATE UNIQUE INDEX 1808"nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder_ID_ID" ON 1809"nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" (ID, 1810"nmo:containsPhoneMessageFolder"); 1811CREATE UNIQUE INDEX 1812"nmo:PhoneMessageFolder_nmo:containsPhoneMessage_ID_ID" ON 1813"nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID, 1814"nmo:containsPhoneMessage"); 1815CREATE UNIQUE INDEX "nmo:PhoneMessage_nmo:toVCard_ID_ID" ON 1816"nmo:PhoneMessage_nmo:toVCard" (ID, "nmo:toVCard"); 1817CREATE UNIQUE INDEX "rdf:Property_rdfs:subPropertyOf_ID_ID" ON 1818"rdf:Property_rdfs:subPropertyOf" (ID, "rdfs:subPropertyOf"); 1819CREATE UNIQUE INDEX "rdfs:Class_rdfs:subClassOf_ID_ID" ON 1820"rdfs:Class_rdfs:subClassOf" (ID, "rdfs:subClassOf"); 1821CREATE UNIQUE INDEX "rdfs:Class_tracker:domainIndex_ID_ID" ON 1822"rdfs:Class_tracker:domainIndex" (ID, "tracker:domainIndex"); 1823CREATE UNIQUE INDEX "rdfs:Resource_dc:contributor_ID_ID" ON 1824"rdfs:Resource_dc:contributor" (ID, "dc:contributor"); 1825CREATE UNIQUE INDEX "rdfs:Resource_dc:date_ID_ID" ON 1826"rdfs:Resource_dc:date" (ID, "dc:date"); 1827CREATE UNIQUE INDEX "rdfs:Resource_dc:relation_ID_ID" ON 1828"rdfs:Resource_dc:relation" (ID, "dc:relation"); 1829CREATE UNIQUE INDEX "rdfs:Resource_dc:source_ID_ID" ON 1830"rdfs:Resource_dc:source" (ID, "dc:source"); 1831CREATE UNIQUE INDEX "rdfs:Resource_nao:deprecated_ID_ID" ON 1832"rdfs:Resource_nao:deprecated" (ID, "nao:deprecated"); 1833CREATE INDEX "rdfs:Resource_nao:hasTag_ID" ON "rdfs:Resource_nao:hasTag" (ID); 1834CREATE UNIQUE INDEX "rdfs:Resource_nao:hasTag_ID_ID" ON 1835"rdfs:Resource_nao:hasTag" ("nao:hasTag", ID); 1836CREATE UNIQUE INDEX "rdfs:Resource_nao:isRelated_ID_ID" ON 1837"rdfs:Resource_nao:isRelated" (ID, "nao:isRelated"); 1838CREATE UNIQUE INDEX "rdfs:Resource_rdf:type_ID_ID" ON 1839"rdfs:Resource_rdf:type" (ID, "rdf:type"); 1840CREATE INDEX "rdfs:Resource_tracker:added" ON "rdfs:Resource" ("tracker:added"); 1841CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-from_ID_ID" ON 1842"scal:Attendee_scal:delegated-from" (ID, "scal:delegated-from"); 1843CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-to_ID_ID" ON 1844"scal:Attendee_scal:delegated-to" (ID, "scal:delegated-to"); 1845CREATE UNIQUE INDEX "scal:Attendee_scal:member_ID_ID" ON 1846"scal:Attendee_scal:member" (ID, "scal:member"); 1847CREATE UNIQUE INDEX "scal:Attendee_scal:sent-by_ID_ID" ON 1848"scal:Attendee_scal:sent-by" (ID, "scal:sent-by"); 1849CREATE UNIQUE INDEX "scal:CalendarAlarm_scal:alarmAttendee_ID_ID" ON 1850"scal:CalendarAlarm_scal:alarmAttendee" (ID, "scal:alarmAttendee"); 1851CREATE UNIQUE INDEX "scal:CalendarItem_scal:access_ID_ID" ON 1852"scal:CalendarItem_scal:access" (ID, "scal:access"); 1853CREATE UNIQUE INDEX "scal:CalendarItem_scal:attachment_ID_ID" ON 1854"scal:CalendarItem_scal:attachment" (ID, "scal:attachment"); 1855CREATE UNIQUE INDEX "scal:CalendarItem_scal:attendee_ID_ID" ON 1856"scal:CalendarItem_scal:attendee" (ID, "scal:attendee"); 1857CREATE UNIQUE INDEX "scal:CalendarItem_scal:belongsToCalendar_ID_ID" 1858ON "scal:CalendarItem_scal:belongsToCalendar" (ID, 1859"scal:belongsToCalendar"); 1860CREATE UNIQUE INDEX "scal:CalendarItem_scal:contact_ID_ID" ON 1861"scal:CalendarItem_scal:contact" (ID, "scal:contact"); 1862CREATE UNIQUE INDEX "scal:CalendarItem_scal:rrule_ID_ID" ON 1863"scal:CalendarItem_scal:rrule" (ID, "scal:rrule"); 1864CREATE INDEX "slo:GeoLocation_slo:postalAddress" ON "slo:GeoLocation" 1865("slo:postalAddress"); 1866CREATE UNIQUE INDEX "slo:Landmark_slo:belongsToCategory_ID_ID" ON 1867"slo:Landmark_slo:belongsToCategory" (ID, "slo:belongsToCategory"); 1868CREATE UNIQUE INDEX "slo:Landmark_slo:hasContact_ID_ID" ON 1869"slo:Landmark_slo:hasContact" (ID, "slo:hasContact"); 1870CREATE UNIQUE INDEX "slo:Route_slo:routeDetails_ID_ID" ON 1871"slo:Route_slo:routeDetails" (ID, "slo:routeDetails"); 1872 1873EXPLAIN SELECT "1_u", (SELECT "nco:fullname" FROM "nco:Contact" WHERE 1874ID = "1_u") COLLATE NOCASE, (SELECT "nco:nameFamily" FROM 1875"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1876"nco:nameGiven" FROM "nco:PersonContact" WHERE ID = "1_u") 1877COLLATE NOCASE, (SELECT "nco:nameAdditional" FROM 1878"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1879"nco:nameHonorificPrefix" FROM "nco:PersonContact" WHERE ID = 1880"1_u") COLLATE NOCASE, (SELECT "nco:nameHonorificSuffix" FROM 1881"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1882"nco:nickname" FROM "nco:Contact" WHERE ID = "1_u") COLLATE 1883NOCASE, strftime("%s",(SELECT "nco:birthDate" FROM 1884"nco:Contact" WHERE ID = "1_u")), (SELECT "nie:url" FROM 1885"nie:DataObject" WHERE ID = (SELECT "nco:photo" FROM 1886"nco:Contact" WHERE ID = "1_u")) COLLATE NOCASE, (SELECT 1887GROUP_CONCAT("2_u"||? COLLATE NOCASE||COALESCE((SELECT 1888"nco:imProtocol" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1889NOCASE, ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1890"nco:imID" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1891NOCASE, ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1892"nco:imNickname" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1893NOCASE, ? COLLATE NOCASE), '\n') FROM (SELECT 1894"nco:PersonContact_nco:hasAffiliation2"."nco:hasAffiliation" AS 1895"2_u", "nco:Role_nco:hasIMAddress3"."nco:hasIMAddress" AS 1896"3_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1897"nco:PersonContact_nco:hasAffiliation2", 1898"nco:Role_nco:hasIMAddress" AS "nco:Role_nco:hasIMAddress3" WHERE 1899"1_u" = "nco:PersonContact_nco:hasAffiliation2"."ID" AND 1900"nco:PersonContact_nco:hasAffiliation2"."nco:hasAffiliation" = 1901"nco:Role_nco:hasIMAddress3"."ID")), (SELECT 1902GROUP_CONCAT("2_u"||? COLLATE NOCASE||(SELECT "nco:phoneNumber" 1903FROM "nco:PhoneNumber" WHERE ID = "4_u") COLLATE NOCASE, '\n') 1904FROM (SELECT "nco:PersonContact_nco:hasAffiliation4"."nco:hasAffiliation" 1905AS "2_u", "nco:Role_nco:hasPhoneNumber5"."nco:hasPhoneNumber" AS 1906"4_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1907"nco:PersonContact_nco:hasAffiliation4", 1908"nco:Role_nco:hasPhoneNumber" AS "nco:Role_nco:hasPhoneNumber5" 1909WHERE "1_u" = "nco:PersonContact_nco:hasAffiliation4"."ID" AND 1910"nco:PersonContact_nco:hasAffiliation4"."nco:hasAffiliation" = 1911"nco:Role_nco:hasPhoneNumber5"."ID")), (SELECT 1912GROUP_CONCAT("2_u"||? COLLATE NOCASE||(SELECT "nco:emailAddress" 1913FROM "nco:EmailAddress" WHERE ID = "5_u") COLLATE NOCASE, ',') 1914FROM (SELECT "nco:PersonContact_nco:hasAffiliation6"."nco:hasAffiliation" 1915AS "2_u", "nco:Role_nco:hasEmailAddress7"."nco:hasEmailAddress" 1916AS "5_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1917"nco:PersonContact_nco:hasAffiliation6", 1918"nco:Role_nco:hasEmailAddress" AS "nco:Role_nco:hasEmailAddress7" 1919WHERE "1_u" = "nco:PersonContact_nco:hasAffiliation6"."ID" AND 1920"nco:PersonContact_nco:hasAffiliation6"."nco:hasAffiliation" = 1921"nco:Role_nco:hasEmailAddress7"."ID")), (SELECT 1922GROUP_CONCAT("2_u"||? COLLATE NOCASE||COALESCE((SELECT 1923GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = 1924"nco:blogUrl"),',') FROM "nco:Role_nco:blogUrl" WHERE ID = 1925"2_u"), ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1926GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = 1927"nco:websiteUrl"),',') FROM "nco:Role_nco:websiteUrl" WHERE ID = 1928"2_u"), ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1929GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = "nco:url"),',') 1930FROM "nco:Role_nco:url" WHERE ID = "2_u"), ? COLLATE NOCASE), 1931'\n') FROM (SELECT 1932"nco:PersonContact_nco:hasAffiliation8"."nco:hasAffiliation" AS 1933"2_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1934"nco:PersonContact_nco:hasAffiliation8" WHERE "1_u" = 1935"nco:PersonContact_nco:hasAffiliation8"."ID")), (SELECT 1936GROUP_CONCAT("6_u", ',') FROM (SELECT 1937"rdfs:Resource_nao:hasTag9"."nao:hasTag" AS "6_u" FROM 1938"rdfs:Resource_nao:hasTag" AS "rdfs:Resource_nao:hasTag9" WHERE 1939"1_u" = "rdfs:Resource_nao:hasTag9"."ID")), (SELECT Uri FROM 1940Resource WHERE ID = "1_u"), (SELECT GROUP_CONCAT("2_u"||? COLLATE 1941NOCASE||COALESCE((SELECT "nco:role" FROM "nco:Affiliation" WHERE 1942ID = "2_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1943NOCASE||COALESCE((SELECT "nco:department" FROM "nco:Affiliation" 1944WHERE ID = "2_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1945NOCASE||COALESCE((SELECT GROUP_CONCAT("nco:title",',') FROM 1946"nco:Affiliation_nco:title" WHERE ID = "2_u"), ? COLLATE NOCASE), 1947'\n') FROM (SELECT 1948"nco:PersonContact_nco:hasAffiliation10"."nco:hasAffiliation" AS 1949"2_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1950"nco:PersonContact_nco:hasAffiliation10" WHERE "1_u" = 1951"nco:PersonContact_nco:hasAffiliation10"."ID")), (SELECT 1952GROUP_CONCAT("nco:note",',') FROM "nco:Contact_nco:note" WHERE ID 1953= "1_u"), (SELECT "nco:gender" FROM "nco:PersonContact" WHERE ID 1954= "1_u"), (SELECT GROUP_CONCAT("2_u"||? COLLATE 1955NOCASE||COALESCE((SELECT "nco:pobox" FROM "nco:PostalAddress" 1956WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1957NOCASE||COALESCE((SELECT "nco:district" FROM "nco:PostalAddress" 1958WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1959NOCASE||COALESCE((SELECT "nco:county" FROM "nco:PostalAddress" 1960WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1961NOCASE||COALESCE((SELECT "nco:locality" FROM "nco:PostalAddress" 1962WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1963NOCASE||COALESCE((SELECT "nco:postalcode" FROM 1964"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1965NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:streetAddress" 1966FROM "nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? 1967COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT Uri FROM 1968Resource WHERE ID = (SELECT "nco:addressLocation" FROM 1969"nco:PostalAddress" WHERE ID = "7_u")), ? COLLATE NOCASE)||? 1970COLLATE NOCASE||COALESCE((SELECT "nco:extendedAddress" FROM 1971"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1972NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:country" FROM 1973"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1974NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:region" FROM 1975"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1976NOCASE), '\n') FROM (SELECT 1977"nco:PersonContact_nco:hasAffiliation11"."nco:hasAffiliation" AS 1978"2_u", "nco:Role_nco:hasPostalAddress12"."nco:hasPostalAddress" 1979AS "7_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1980"nco:PersonContact_nco:hasAffiliation11", 1981"nco:Role_nco:hasPostalAddress" AS 1982"nco:Role_nco:hasPostalAddress12" WHERE "1_u" = 1983"nco:PersonContact_nco:hasAffiliation11"."ID" AND 1984"nco:PersonContact_nco:hasAffiliation11"."nco:hasAffiliation" = 1985"nco:Role_nco:hasPostalAddress12"."ID")), (SELECT 1986GROUP_CONCAT("10_u" COLLATE NOCASE, ',') FROM (SELECT 1987"nie:InformationElement_nao:hasProperty13"."nao:hasProperty" AS 1988"8_u", "nao:Property14"."nao:propertyName" AS "9_u", 1989"nao:Property14"."nao:propertyValue" AS "10_u" FROM 1990"nie:InformationElement_nao:hasProperty" AS 1991"nie:InformationElement_nao:hasProperty13", "nao:Property" AS 1992"nao:Property14" WHERE "1_u" = 1993"nie:InformationElement_nao:hasProperty13"."ID" AND 1994"nie:InformationElement_nao:hasProperty13"."nao:hasProperty" = 1995"nao:Property14"."ID" AND "9_u" IS NOT NULL AND "10_u" IS NOT 1996NULL AND ("9_u" COLLATE NOCASE = ? COLLATE NOCASE))) FROM (SELECT 1997"nco:PersonContact1"."ID" AS "1_u" FROM "nco:PersonContact" AS 1998"nco:PersonContact1") ORDER BY "1_u"; 1999 } 2000} {/.* Goto .*/} 2001 2002# Crash reported by OSS-FUZZ on 2016-11-10 2003do_catchsql_test fuzz-oss1-detach { 2004 DETACH x IS #1; 2005} {1 {near "#1": syntax error}} 2006 2007finish_test 2008