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 321db close 322forcedelete test.db 323sqlite3 db test.db 324do_test fuzz-oss1-gnomeshell { 325 db eval { 326CREATE TABLE Resource (ID INTEGER NOT NULL PRIMARY KEY, Uri TEXT NOT 327NULL, UNIQUE (Uri)); 328CREATE VIRTUAL TABLE fts USING fts4; 329CREATE TABLE "mfo:Action" (ID INTEGER NOT NULL PRIMARY KEY); 330CREATE TABLE "mfo:Enclosure" (ID INTEGER NOT NULL PRIMARY KEY, 331"mfo:remoteLink" INTEGER, "mfo:remoteLink:graph" INTEGER, 332"mfo:groupDefault" INTEGER, "mfo:groupDefault:graph" INTEGER, 333"mfo:localLink" INTEGER, "mfo:localLink:graph" INTEGER, "mfo:optional" 334INTEGER, "mfo:optional:graph" INTEGER); 335CREATE TABLE "mfo:FeedChannel" (ID INTEGER NOT NULL PRIMARY KEY, 336"mfo:updatedTime" INTEGER, "mfo:updatedTime:graph" INTEGER, 337"mfo:updatedTime:localDate" INTEGER, "mfo:updatedTime:localTime" 338INTEGER, "mfo:unreadCount" INTEGER, "mfo:unreadCount:graph" INTEGER, 339"mfo:totalCount" INTEGER, "mfo:totalCount:graph" INTEGER, "mfo:action" 340INTEGER, "mfo:action:graph" INTEGER, "mfo:type" INTEGER, 341"mfo:type:graph" INTEGER); 342CREATE TABLE "mfo:FeedElement" (ID INTEGER NOT NULL PRIMARY KEY, 343"mfo:image" TEXT COLLATE NOCASE, "mfo:image:graph" INTEGER, 344"mfo:feedSettings" INTEGER, "mfo:feedSettings:graph" INTEGER); 345CREATE TABLE "mfo:FeedMessage" (ID INTEGER NOT NULL PRIMARY KEY, 346"mfo:downloadedTime" INTEGER, "mfo:downloadedTime:graph" INTEGER, 347"mfo:downloadedTime:localDate" INTEGER, "mfo:downloadedTime:localTime" 348INTEGER); 349CREATE TABLE "mfo:FeedMessage_mfo:enclosureList" (ID INTEGER NOT NULL, 350"mfo:enclosureList" INTEGER NOT NULL, "mfo:enclosureList:graph" 351INTEGER); 352CREATE TABLE "mfo:FeedSettings" (ID INTEGER NOT NULL PRIMARY KEY, 353"mfo:updateInterval" INTEGER, "mfo:updateInterval:graph" INTEGER, 354"mfo:expiryInterval" INTEGER, "mfo:expiryInterval:graph" INTEGER, 355"mfo:downloadPath" TEXT COLLATE NOCASE, "mfo:downloadPath:graph" 356INTEGER, "mfo:downloadFlag" INTEGER, "mfo:downloadFlag:graph" INTEGER, 357"mfo:maxSize" INTEGER, "mfo:maxSize:graph" INTEGER); 358CREATE TABLE "mfo:FeedType" (ID INTEGER NOT NULL PRIMARY KEY, 359"mfo:name" TEXT COLLATE NOCASE, "mfo:name:graph" INTEGER); 360CREATE TABLE "mlo:GeoBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); 361CREATE TABLE "mlo:GeoBoundingBox_mlo:bbNorthWest" (ID INTEGER NOT 362NULL, "mlo:bbNorthWest" INTEGER NOT NULL, "mlo:bbNorthWest:graph" 363INTEGER); 364CREATE TABLE "mlo:GeoBoundingBox_mlo:bbSouthEast" (ID INTEGER NOT 365NULL, "mlo:bbSouthEast" INTEGER NOT NULL, "mlo:bbSouthEast:graph" 366INTEGER); 367CREATE TABLE "mlo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY); 368CREATE TABLE "mlo:GeoLocation_mlo:asBoundingBox" (ID INTEGER NOT NULL, 369"mlo:asBoundingBox" INTEGER NOT NULL, "mlo:asBoundingBox:graph" 370INTEGER); 371CREATE TABLE "mlo:GeoLocation_mlo:asGeoPoint" (ID INTEGER NOT NULL, 372"mlo:asGeoPoint" INTEGER NOT NULL, "mlo:asGeoPoint:graph" INTEGER); 373CREATE TABLE "mlo:GeoLocation_mlo:asPostalAddress" (ID INTEGER NOT 374NULL, "mlo:asPostalAddress" INTEGER NOT NULL, 375"mlo:asPostalAddress:graph" INTEGER); 376CREATE TABLE "mlo:GeoPoint" (ID INTEGER NOT NULL PRIMARY KEY); 377CREATE TABLE "mlo:GeoPoint_mlo:address" (ID INTEGER NOT NULL, 378"mlo:address" TEXT NOT NULL, "mlo:address:graph" INTEGER); 379CREATE TABLE "mlo:GeoPoint_mlo:altitude" (ID INTEGER NOT NULL, 380"mlo:altitude" REAL NOT NULL, "mlo:altitude:graph" INTEGER); 381CREATE TABLE "mlo:GeoPoint_mlo:city" (ID INTEGER NOT NULL, "mlo:city" 382TEXT NOT NULL, "mlo:city:graph" INTEGER); 383CREATE TABLE "mlo:GeoPoint_mlo:country" (ID INTEGER NOT NULL, 384"mlo:country" TEXT NOT NULL, "mlo:country:graph" INTEGER); 385CREATE TABLE "mlo:GeoPoint_mlo:latitude" (ID INTEGER NOT NULL, 386"mlo:latitude" REAL NOT NULL, "mlo:latitude:graph" INTEGER); 387CREATE TABLE "mlo:GeoPoint_mlo:longitude" (ID INTEGER NOT NULL, 388"mlo:longitude" REAL NOT NULL, "mlo:longitude:graph" INTEGER); 389CREATE TABLE "mlo:GeoPoint_mlo:state" (ID INTEGER NOT NULL, 390"mlo:state" TEXT NOT NULL, "mlo:state:graph" INTEGER); 391CREATE TABLE "mlo:GeoPoint_mlo:timestamp" (ID INTEGER NOT NULL, 392"mlo:timestamp" INTEGER NOT NULL, "mlo:timestamp:graph" INTEGER, 393"mlo:timestamp:localDate" INTEGER NOT NULL, "mlo:timestamp:localTime" 394INTEGER NOT NULL); 395CREATE TABLE "mlo:GeoSphere" (ID INTEGER NOT NULL PRIMARY KEY); 396CREATE TABLE "mlo:GeoSphere_mlo:radius" (ID INTEGER NOT NULL, 397"mlo:radius" REAL NOT NULL, "mlo:radius:graph" INTEGER); 398CREATE TABLE "mlo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY); 399CREATE TABLE "mlo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY); 400CREATE TABLE "mlo:LandmarkCategory_mlo:isRemovable" (ID INTEGER NOT 401NULL, "mlo:isRemovable" INTEGER NOT NULL, "mlo:isRemovable:graph" 402INTEGER); 403CREATE TABLE "mlo:Landmark_mlo:belongsToCategory" (ID INTEGER NOT 404NULL, "mlo:belongsToCategory" INTEGER NOT NULL, 405"mlo:belongsToCategory:graph" INTEGER); 406CREATE TABLE "mlo:Landmark_mlo:poiLocation" (ID INTEGER NOT NULL, 407"mlo:poiLocation" INTEGER NOT NULL, "mlo:poiLocation:graph" INTEGER); 408CREATE TABLE "mlo:LocationBoundingBox" (ID INTEGER NOT NULL PRIMARY KEY); 409CREATE TABLE "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID INTEGER 410NOT NULL, "mlo:boxEastLimit" INTEGER NOT NULL, 411"mlo:boxEastLimit:graph" INTEGER); 412CREATE TABLE "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID INTEGER 413NOT NULL, "mlo:boxNorthLimit" INTEGER NOT NULL, 414"mlo:boxNorthLimit:graph" INTEGER); 415CREATE TABLE "mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID 416INTEGER NOT NULL, "mlo:boxSouthWestCorner" INTEGER NOT NULL, 417"mlo:boxSouthWestCorner:graph" INTEGER); 418CREATE TABLE "mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID 419INTEGER NOT NULL, "mlo:boxVerticalLimit" INTEGER NOT NULL, 420"mlo:boxVerticalLimit:graph" INTEGER); 421CREATE TABLE "mlo:PointOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); 422CREATE TABLE "mlo:Route" (ID INTEGER NOT NULL PRIMARY KEY); 423CREATE TABLE "mlo:Route_mlo:endTime" (ID INTEGER NOT NULL, 424"mlo:endTime" INTEGER NOT NULL, "mlo:endTime:graph" INTEGER, 425"mlo:endTime:localDate" INTEGER NOT NULL, "mlo:endTime:localTime" 426INTEGER NOT NULL); 427CREATE TABLE "mlo:Route_mlo:routeDetails" (ID INTEGER NOT NULL, 428"mlo:routeDetails" TEXT NOT NULL, "mlo:routeDetails:graph" INTEGER); 429CREATE TABLE "mlo:Route_mlo:startTime" (ID INTEGER NOT NULL, 430"mlo:startTime" INTEGER NOT NULL, "mlo:startTime:graph" INTEGER, 431"mlo:startTime:localDate" INTEGER NOT NULL, "mlo:startTime:localTime" 432INTEGER NOT NULL); 433CREATE TABLE "mto:DownloadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 434CREATE TABLE "mto:State" (ID INTEGER NOT NULL PRIMARY KEY); 435CREATE TABLE "mto:SyncTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 436CREATE TABLE "mto:Transfer" (ID INTEGER NOT NULL PRIMARY KEY, 437"mto:transferState" INTEGER, "mto:transferState:graph" INTEGER, 438"mto:method" INTEGER, "mto:method:graph" INTEGER, "mto:created" 439INTEGER, "mto:created:graph" INTEGER, "mto:created:localDate" INTEGER, 440"mto:created:localTime" INTEGER, "mto:account" TEXT COLLATE NOCASE, 441"mto:account:graph" INTEGER, "mto:starter" INTEGER, 442"mto:starter:graph" INTEGER, "mto:agent" INTEGER, "mto:agent:graph" 443INTEGER); 444CREATE TABLE "mto:TransferElement" (ID INTEGER NOT NULL PRIMARY KEY, 445"mto:source" INTEGER, "mto:source:graph" INTEGER, "mto:destination" 446INTEGER, "mto:destination:graph" INTEGER, "mto:startedTime" INTEGER, 447"mto:startedTime:graph" INTEGER, "mto:startedTime:localDate" INTEGER, 448"mto:startedTime:localTime" INTEGER, "mto:completedTime" INTEGER, 449"mto:completedTime:graph" INTEGER, "mto:completedTime:localDate" 450INTEGER, "mto:completedTime:localTime" INTEGER, "mto:state" INTEGER, 451"mto:state:graph" INTEGER); 452CREATE TABLE "mto:TransferMethod" (ID INTEGER NOT NULL PRIMARY KEY); 453CREATE TABLE "mto:Transfer_mto:transferList" (ID INTEGER NOT NULL, 454"mto:transferList" INTEGER NOT NULL, "mto:transferList:graph" 455INTEGER); 456CREATE TABLE "mto:Transfer_mto:transferPrivacyLevel" (ID INTEGER NOT 457NULL, "mto:transferPrivacyLevel" TEXT NOT NULL, 458"mto:transferPrivacyLevel:graph" INTEGER); 459CREATE TABLE "mto:UploadTransfer" (ID INTEGER NOT NULL PRIMARY KEY); 460CREATE TABLE "mto:UploadTransfer_mto:transferCategory" (ID INTEGER NOT 461NULL, "mto:transferCategory" TEXT NOT NULL, 462"mto:transferCategory:graph" INTEGER); 463CREATE TABLE "mtp:ScanType" (ID INTEGER NOT NULL PRIMARY KEY); 464CREATE TABLE "nao:Property" (ID INTEGER NOT NULL PRIMARY KEY, 465"nao:propertyName" TEXT COLLATE NOCASE, "nao:propertyName:graph" 466INTEGER, "nao:propertyValue" TEXT COLLATE NOCASE, 467"nao:propertyValue:graph" INTEGER); 468CREATE TABLE "nao:Tag" (ID INTEGER NOT NULL PRIMARY KEY, 469"nao:prefLabel" TEXT COLLATE NOCASE, "nao:prefLabel:graph" INTEGER, 470"nao:description" TEXT COLLATE NOCASE, "nao:description:graph" 471INTEGER); 472CREATE TABLE "nao:Tag_tracker:isDefaultTag" (ID INTEGER NOT NULL, 473"tracker:isDefaultTag" INTEGER NOT NULL, "tracker:isDefaultTag:graph" 474INTEGER); 475CREATE TABLE "nao:Tag_tracker:tagRelatedTo" (ID INTEGER NOT NULL, 476"tracker:tagRelatedTo" INTEGER NOT NULL, "tracker:tagRelatedTo:graph" 477INTEGER); 478CREATE TABLE "ncal:AccessClassification" (ID INTEGER NOT NULL PRIMARY KEY); 479CREATE TABLE "ncal:Alarm" (ID INTEGER NOT NULL PRIMARY KEY, 480"ncal:repeat" INTEGER, "ncal:repeat:graph" INTEGER); 481CREATE TABLE "ncal:AlarmAction" (ID INTEGER NOT NULL PRIMARY KEY); 482CREATE TABLE "ncal:Alarm_ncal:action" (ID INTEGER NOT NULL, 483"ncal:action" INTEGER NOT NULL, "ncal:action:graph" INTEGER); 484CREATE TABLE "ncal:Attachment" (ID INTEGER NOT NULL PRIMARY KEY, 485"ncal:attachmentUri" INTEGER, "ncal:attachmentUri:graph" INTEGER, 486"ncal:fmttype" TEXT COLLATE NOCASE, "ncal:fmttype:graph" INTEGER, 487"ncal:encoding" INTEGER, "ncal:encoding:graph" INTEGER, 488"ncal:attachmentContent" TEXT COLLATE NOCASE, 489"ncal:attachmentContent:graph" INTEGER); 490CREATE TABLE "ncal:AttachmentEncoding" (ID INTEGER NOT NULL PRIMARY KEY); 491CREATE TABLE "ncal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, 492"ncal:delegatedTo" INTEGER, "ncal:delegatedTo:graph" INTEGER, 493"ncal:delegatedFrom" INTEGER, "ncal:delegatedFrom:graph" INTEGER, 494"ncal:cutype" INTEGER, "ncal:cutype:graph" INTEGER, "ncal:member" 495INTEGER, "ncal:member:graph" INTEGER, "ncal:role" INTEGER, 496"ncal:role:graph" INTEGER, "ncal:rsvp" INTEGER, "ncal:rsvp:graph" 497INTEGER, "ncal:partstat" INTEGER, "ncal:partstat:graph" INTEGER); 498CREATE TABLE "ncal:AttendeeOrOrganizer" (ID INTEGER NOT NULL PRIMARY 499KEY, "ncal:dir" INTEGER, "ncal:dir:graph" INTEGER, 500"ncal:involvedContact" INTEGER, "ncal:involvedContact:graph" INTEGER, 501"ncal:sentBy" INTEGER, "ncal:sentBy:graph" INTEGER); 502CREATE TABLE "ncal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); 503CREATE TABLE "ncal:BydayRulePart" (ID INTEGER NOT NULL PRIMARY KEY); 504CREATE TABLE "ncal:BydayRulePart_ncal:bydayModifier" (ID INTEGER NOT 505NULL, "ncal:bydayModifier" INTEGER NOT NULL, 506"ncal:bydayModifier:graph" INTEGER); 507CREATE TABLE "ncal:BydayRulePart_ncal:bydayWeekday" (ID INTEGER NOT 508NULL, "ncal:bydayWeekday" INTEGER NOT NULL, "ncal:bydayWeekday:graph" 509INTEGER); 510CREATE TABLE "ncal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY, 511"ncal:method" TEXT COLLATE NOCASE, "ncal:method:graph" INTEGER, 512"ncal:calscale" INTEGER, "ncal:calscale:graph" INTEGER, "ncal:prodid" 513TEXT COLLATE NOCASE, "ncal:prodid:graph" INTEGER, "ncal:version" TEXT 514COLLATE NOCASE, "ncal:version:graph" INTEGER); 515CREATE TABLE "ncal:CalendarDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 516CREATE TABLE "ncal:CalendarScale" (ID INTEGER NOT NULL PRIMARY KEY); 517CREATE TABLE "ncal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); 518CREATE TABLE "ncal:Calendar_ncal:component" (ID INTEGER NOT NULL, 519"ncal:component" INTEGER NOT NULL, "ncal:component:graph" INTEGER); 520CREATE TABLE "ncal:Event" (ID INTEGER NOT NULL PRIMARY KEY, 521"ncal:eventStatus" INTEGER, "ncal:eventStatus:graph" INTEGER, 522"ncal:transp" INTEGER, "ncal:transp:graph" INTEGER); 523CREATE TABLE "ncal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); 524CREATE TABLE "ncal:Freebusy" (ID INTEGER NOT NULL PRIMARY KEY); 525CREATE TABLE "ncal:FreebusyPeriod" (ID INTEGER NOT NULL PRIMARY KEY, 526"ncal:fbtype" INTEGER, "ncal:fbtype:graph" INTEGER); 527CREATE TABLE "ncal:FreebusyType" (ID INTEGER NOT NULL PRIMARY KEY); 528CREATE TABLE "ncal:Freebusy_ncal:freebusy" (ID INTEGER NOT NULL, 529"ncal:freebusy" INTEGER NOT NULL, "ncal:freebusy:graph" INTEGER); 530CREATE TABLE "ncal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, 531"ncal:journalStatus" INTEGER, "ncal:journalStatus:graph" INTEGER); 532CREATE TABLE "ncal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); 533CREATE TABLE "ncal:NcalDateTime" (ID INTEGER NOT NULL PRIMARY KEY, 534"ncal:ncalTimezone" INTEGER, "ncal:ncalTimezone:graph" INTEGER, 535"ncal:date" INTEGER, "ncal:date:graph" INTEGER, "ncal:date:localDate" 536INTEGER, "ncal:date:localTime" INTEGER, "ncal:dateTime" INTEGER, 537"ncal:dateTime:graph" INTEGER, "ncal:dateTime:localDate" INTEGER, 538"ncal:dateTime:localTime" INTEGER); 539CREATE TABLE "ncal:NcalPeriod" (ID INTEGER NOT NULL PRIMARY KEY, 540"ncal:periodBegin" INTEGER, "ncal:periodBegin:graph" INTEGER, 541"ncal:periodBegin:localDate" INTEGER, "ncal:periodBegin:localTime" 542INTEGER, "ncal:periodDuration" INTEGER, "ncal:periodDuration:graph" 543INTEGER, "ncal:periodEnd" INTEGER, "ncal:periodEnd:graph" INTEGER, 544"ncal:periodEnd:localDate" INTEGER, "ncal:periodEnd:localTime" 545INTEGER); 546CREATE TABLE "ncal:NcalTimeEntity" (ID INTEGER NOT NULL PRIMARY KEY); 547CREATE TABLE "ncal:Organizer" (ID INTEGER NOT NULL PRIMARY KEY); 548CREATE TABLE "ncal:ParticipationStatus" (ID INTEGER NOT NULL PRIMARY KEY); 549CREATE TABLE "ncal:RecurrenceFrequency" (ID INTEGER NOT NULL PRIMARY KEY); 550CREATE TABLE "ncal:RecurrenceIdentifier" (ID INTEGER NOT NULL PRIMARY 551KEY, "ncal:range" INTEGER, "ncal:range:graph" INTEGER, 552"ncal:recurrenceIdDateTime" INTEGER, "ncal:recurrenceIdDateTime:graph" 553INTEGER); 554CREATE TABLE "ncal:RecurrenceIdentifierRange" (ID INTEGER NOT NULL PRIMARY KEY); 555CREATE TABLE "ncal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, 556"ncal:until" INTEGER, "ncal:until:graph" INTEGER, 557"ncal:until:localDate" INTEGER, "ncal:until:localTime" INTEGER, 558"ncal:wkst" INTEGER, "ncal:wkst:graph" INTEGER, "ncal:interval" 559INTEGER, "ncal:interval:graph" INTEGER, "ncal:count" INTEGER, 560"ncal:count:graph" INTEGER, "ncal:freq" INTEGER, "ncal:freq:graph" 561INTEGER); 562CREATE TABLE "ncal:RecurrenceRule_ncal:byday" (ID INTEGER NOT NULL, 563"ncal:byday" INTEGER NOT NULL, "ncal:byday:graph" INTEGER); 564CREATE TABLE "ncal:RecurrenceRule_ncal:byhour" (ID INTEGER NOT NULL, 565"ncal:byhour" INTEGER NOT NULL, "ncal:byhour:graph" INTEGER); 566CREATE TABLE "ncal:RecurrenceRule_ncal:byminute" (ID INTEGER NOT NULL, 567"ncal:byminute" INTEGER NOT NULL, "ncal:byminute:graph" INTEGER); 568CREATE TABLE "ncal:RecurrenceRule_ncal:bymonth" (ID INTEGER NOT NULL, 569"ncal:bymonth" INTEGER NOT NULL, "ncal:bymonth:graph" INTEGER); 570CREATE TABLE "ncal:RecurrenceRule_ncal:bymonthday" (ID INTEGER NOT 571NULL, "ncal:bymonthday" INTEGER NOT NULL, "ncal:bymonthday:graph" 572INTEGER); 573CREATE TABLE "ncal:RecurrenceRule_ncal:bysecond" (ID INTEGER NOT NULL, 574"ncal:bysecond" INTEGER NOT NULL, "ncal:bysecond:graph" INTEGER); 575CREATE TABLE "ncal:RecurrenceRule_ncal:bysetpos" (ID INTEGER NOT NULL, 576"ncal:bysetpos" INTEGER NOT NULL, "ncal:bysetpos:graph" INTEGER); 577CREATE TABLE "ncal:RecurrenceRule_ncal:byweekno" (ID INTEGER NOT NULL, 578"ncal:byweekno" INTEGER NOT NULL, "ncal:byweekno:graph" INTEGER); 579CREATE TABLE "ncal:RecurrenceRule_ncal:byyearday" (ID INTEGER NOT 580NULL, "ncal:byyearday" INTEGER NOT NULL, "ncal:byyearday:graph" 581INTEGER); 582CREATE TABLE "ncal:RequestStatus" (ID INTEGER NOT NULL PRIMARY KEY, 583"ncal:statusDescription" TEXT COLLATE NOCASE, 584"ncal:statusDescription:graph" INTEGER, "ncal:returnStatus" TEXT 585COLLATE NOCASE, "ncal:returnStatus:graph" INTEGER, 586"ncal:requestStatusData" TEXT COLLATE NOCASE, 587"ncal:requestStatusData:graph" INTEGER); 588CREATE TABLE "ncal:TimeTransparency" (ID INTEGER NOT NULL PRIMARY KEY); 589CREATE TABLE "ncal:Timezone" (ID INTEGER NOT NULL PRIMARY KEY, 590"ncal:tzurl" INTEGER, "ncal:tzurl:graph" INTEGER, "ncal:standard" 591INTEGER, "ncal:standard:graph" INTEGER, "ncal:daylight" INTEGER, 592"ncal:daylight:graph" INTEGER, "ncal:tzid" TEXT COLLATE NOCASE, 593"ncal:tzid:graph" INTEGER); 594CREATE TABLE "ncal:TimezoneObservance" (ID INTEGER NOT NULL PRIMARY 595KEY, "ncal:tzoffsetfrom" TEXT COLLATE NOCASE, 596"ncal:tzoffsetfrom:graph" INTEGER, "ncal:tzoffsetto" TEXT COLLATE 597NOCASE, "ncal:tzoffsetto:graph" INTEGER, "ncal:tzname" TEXT COLLATE 598NOCASE, "ncal:tzname:graph" INTEGER); 599CREATE TABLE "ncal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, 600"ncal:percentComplete" INTEGER, "ncal:percentComplete:graph" INTEGER, 601"ncal:completed" INTEGER, "ncal:completed:graph" INTEGER, 602"ncal:completed:localDate" INTEGER, "ncal:completed:localTime" 603INTEGER, "ncal:todoStatus" INTEGER, "ncal:todoStatus:graph" INTEGER, 604"ncal:due" INTEGER, "ncal:due:graph" INTEGER); 605CREATE TABLE "ncal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); 606CREATE TABLE "ncal:Trigger" (ID INTEGER NOT NULL PRIMARY KEY, 607"ncal:related" INTEGER, "ncal:related:graph" INTEGER, 608"ncal:triggerDateTime" INTEGER, "ncal:triggerDateTime:graph" INTEGER, 609"ncal:triggerDateTime:localDate" INTEGER, 610"ncal:triggerDateTime:localTime" INTEGER, "ncal:triggerDuration" 611INTEGER, "ncal:triggerDuration:graph" INTEGER); 612CREATE TABLE "ncal:TriggerRelation" (ID INTEGER NOT NULL PRIMARY KEY); 613CREATE TABLE "ncal:UnionParentClass" (ID INTEGER NOT NULL PRIMARY KEY, 614"ncal:lastModified" INTEGER, "ncal:lastModified:graph" INTEGER, 615"ncal:lastModified:localDate" INTEGER, "ncal:lastModified:localTime" 616INTEGER, "ncal:trigger" INTEGER, "ncal:trigger:graph" INTEGER, 617"ncal:created" INTEGER, "ncal:created:graph" INTEGER, 618"ncal:created:localDate" INTEGER, "ncal:created:localTime" INTEGER, 619"ncal:url" INTEGER, "ncal:url:graph" INTEGER, "ncal:comment" TEXT 620COLLATE NOCASE, "ncal:comment:graph" INTEGER, "ncal:summaryAltRep" 621INTEGER, "ncal:summaryAltRep:graph" INTEGER, "ncal:priority" INTEGER, 622"ncal:priority:graph" INTEGER, "ncal:location" TEXT COLLATE NOCASE, 623"ncal:location:graph" INTEGER, "ncal:uid" TEXT COLLATE NOCASE, 624"ncal:uid:graph" INTEGER, "ncal:requestStatus" INTEGER, 625"ncal:requestStatus:graph" INTEGER, "ncal:recurrenceId" INTEGER, 626"ncal:recurrenceId:graph" INTEGER, "ncal:dtstamp" INTEGER, 627"ncal:dtstamp:graph" INTEGER, "ncal:dtstamp:localDate" INTEGER, 628"ncal:dtstamp:localTime" INTEGER, "ncal:class" INTEGER, 629"ncal:class:graph" INTEGER, "ncal:organizer" INTEGER, 630"ncal:organizer:graph" INTEGER, "ncal:dtend" INTEGER, 631"ncal:dtend:graph" INTEGER, "ncal:summary" TEXT COLLATE NOCASE, 632"ncal:summary:graph" INTEGER, "ncal:descriptionAltRep" INTEGER, 633"ncal:descriptionAltRep:graph" INTEGER, "ncal:commentAltRep" INTEGER, 634"ncal:commentAltRep:graph" INTEGER, "ncal:sequence" INTEGER, 635"ncal:sequence:graph" INTEGER, "ncal:contact" TEXT COLLATE NOCASE, 636"ncal:contact:graph" INTEGER, "ncal:contactAltRep" INTEGER, 637"ncal:contactAltRep:graph" INTEGER, "ncal:locationAltRep" INTEGER, 638"ncal:locationAltRep:graph" INTEGER, "ncal:geo" INTEGER, 639"ncal:geo:graph" INTEGER, "ncal:resourcesAltRep" INTEGER, 640"ncal:resourcesAltRep:graph" INTEGER, "ncal:dtstart" INTEGER, 641"ncal:dtstart:graph" INTEGER, "ncal:description" TEXT COLLATE NOCASE, 642"ncal:description:graph" INTEGER, "ncal:relatedToSibling" TEXT COLLATE 643NOCASE, "ncal:relatedToSibling:graph" INTEGER, "ncal:duration" 644INTEGER, "ncal:duration:graph" INTEGER); 645CREATE TABLE "ncal:UnionParentClass_ncal:attach" (ID INTEGER NOT NULL, 646"ncal:attach" INTEGER NOT NULL, "ncal:attach:graph" INTEGER); 647CREATE TABLE "ncal:UnionParentClass_ncal:attendee" (ID INTEGER NOT 648NULL, "ncal:attendee" INTEGER NOT NULL, "ncal:attendee:graph" 649INTEGER); 650CREATE TABLE "ncal:UnionParentClass_ncal:categories" (ID INTEGER NOT 651NULL, "ncal:categories" TEXT NOT NULL, "ncal:categories:graph" 652INTEGER); 653CREATE TABLE "ncal:UnionParentClass_ncal:exdate" (ID INTEGER NOT NULL, 654"ncal:exdate" INTEGER NOT NULL, "ncal:exdate:graph" INTEGER); 655CREATE TABLE "ncal:UnionParentClass_ncal:exrule" (ID INTEGER NOT NULL, 656"ncal:exrule" INTEGER NOT NULL, "ncal:exrule:graph" INTEGER); 657CREATE TABLE "ncal:UnionParentClass_ncal:hasAlarm" (ID INTEGER NOT 658NULL, "ncal:hasAlarm" INTEGER NOT NULL, "ncal:hasAlarm:graph" 659INTEGER); 660CREATE TABLE "ncal:UnionParentClass_ncal:ncalRelation" (ID INTEGER NOT 661NULL, "ncal:ncalRelation" TEXT NOT NULL, "ncal:ncalRelation:graph" 662INTEGER); 663CREATE TABLE "ncal:UnionParentClass_ncal:rdate" (ID INTEGER NOT NULL, 664"ncal:rdate" INTEGER NOT NULL, "ncal:rdate:graph" INTEGER); 665CREATE TABLE "ncal:UnionParentClass_ncal:relatedToChild" (ID INTEGER 666NOT NULL, "ncal:relatedToChild" TEXT NOT NULL, 667"ncal:relatedToChild:graph" INTEGER); 668CREATE TABLE "ncal:UnionParentClass_ncal:relatedToParent" (ID INTEGER 669NOT NULL, "ncal:relatedToParent" TEXT NOT NULL, 670"ncal:relatedToParent:graph" INTEGER); 671CREATE TABLE "ncal:UnionParentClass_ncal:resources" (ID INTEGER NOT 672NULL, "ncal:resources" TEXT NOT NULL, "ncal:resources:graph" INTEGER); 673CREATE TABLE "ncal:UnionParentClass_ncal:rrule" (ID INTEGER NOT NULL, 674"ncal:rrule" INTEGER NOT NULL, "ncal:rrule:graph" INTEGER); 675CREATE TABLE "ncal:Weekday" (ID INTEGER NOT NULL PRIMARY KEY); 676CREATE TABLE "nco:Affiliation" (ID INTEGER NOT NULL PRIMARY KEY, 677"nco:department" TEXT COLLATE NOCASE, "nco:department:graph" INTEGER, 678"nco:org" INTEGER, "nco:org:graph" INTEGER, "nco:role" TEXT COLLATE 679NOCASE, "nco:role:graph" INTEGER); 680CREATE TABLE "nco:Affiliation_nco:title" (ID INTEGER NOT NULL, 681"nco:title" TEXT NOT NULL, "nco:title:graph" INTEGER); 682CREATE TABLE "nco:AuthorizationStatus" (ID INTEGER NOT NULL PRIMARY KEY); 683CREATE TABLE "nco:BbsNumber" (ID INTEGER NOT NULL PRIMARY KEY); 684CREATE TABLE "nco:CarPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 685CREATE TABLE "nco:CellPhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 686CREATE TABLE "nco:Contact" (ID INTEGER NOT NULL PRIMARY KEY, 687"nco:fullname" TEXT COLLATE NOCASE, "nco:fullname:graph" INTEGER, 688"nco:key" INTEGER, "nco:key:graph" INTEGER, "nco:contactUID" TEXT 689COLLATE NOCASE, "nco:contactUID:graph" INTEGER, "nco:contactLocalUID" 690TEXT COLLATE NOCASE, "nco:contactLocalUID:graph" INTEGER, 691"nco:hasLocation" INTEGER, "nco:hasLocation:graph" INTEGER, 692"nco:nickname" TEXT COLLATE NOCASE, "nco:nickname:graph" INTEGER, 693"nco:representative" INTEGER, "nco:representative:graph" INTEGER, 694"nco:photo" INTEGER, "nco:photo:graph" INTEGER, "nco:birthDate" 695INTEGER, "nco:birthDate:graph" INTEGER, "nco:birthDate:localDate" 696INTEGER, "nco:birthDate:localTime" INTEGER, "nco:sound" INTEGER, 697"nco:sound:graph" INTEGER); 698CREATE TABLE "nco:ContactGroup" (ID INTEGER NOT NULL PRIMARY KEY, 699"nco:contactGroupName" TEXT COLLATE NOCASE, 700"nco:contactGroupName:graph" INTEGER); 701CREATE TABLE "nco:ContactList" (ID INTEGER NOT NULL PRIMARY KEY); 702CREATE TABLE "nco:ContactListDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 703CREATE TABLE "nco:ContactList_nco:containsContact" (ID INTEGER NOT 704NULL, "nco:containsContact" INTEGER NOT NULL, 705"nco:containsContact:graph" INTEGER); 706CREATE TABLE "nco:ContactMedium" (ID INTEGER NOT NULL PRIMARY KEY, 707"nco:contactMediumComment" TEXT COLLATE NOCASE, 708"nco:contactMediumComment:graph" INTEGER); 709CREATE TABLE "nco:Contact_ncal:anniversary" (ID INTEGER NOT NULL, 710"ncal:anniversary" INTEGER NOT NULL, "ncal:anniversary:graph" 711INTEGER); 712CREATE TABLE "nco:Contact_ncal:birthday" (ID INTEGER NOT NULL, 713"ncal:birthday" INTEGER NOT NULL, "ncal:birthday:graph" INTEGER); 714CREATE TABLE "nco:Contact_nco:belongsToGroup" (ID INTEGER NOT NULL, 715"nco:belongsToGroup" INTEGER NOT NULL, "nco:belongsToGroup:graph" 716INTEGER); 717CREATE TABLE "nco:Contact_nco:note" (ID INTEGER NOT NULL, "nco:note" 718TEXT NOT NULL, "nco:note:graph" INTEGER); 719CREATE TABLE "nco:Contact_scal:anniversary" (ID INTEGER NOT NULL, 720"scal:anniversary" INTEGER NOT NULL, "scal:anniversary:graph" 721INTEGER); 722CREATE TABLE "nco:Contact_scal:birthday" (ID INTEGER NOT NULL, 723"scal:birthday" INTEGER NOT NULL, "scal:birthday:graph" INTEGER); 724CREATE TABLE "nco:DomesticDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); 725CREATE TABLE "nco:EmailAddress" (ID INTEGER NOT NULL PRIMARY KEY, 726"nco:emailAddress" TEXT COLLATE NOCASE UNIQUE, 727"nco:emailAddress:graph" INTEGER); 728CREATE TABLE "nco:FaxNumber" (ID INTEGER NOT NULL PRIMARY KEY); 729CREATE TABLE "nco:Gender" (ID INTEGER NOT NULL PRIMARY KEY); 730CREATE TABLE "nco:IMAccount" (ID INTEGER NOT NULL PRIMARY KEY, 731"nco:imAccountAddress" INTEGER UNIQUE, "nco:imAccountAddress:graph" 732INTEGER, "nco:imAccountType" TEXT COLLATE NOCASE, 733"nco:imAccountType:graph" INTEGER, "nco:imDisplayName" TEXT COLLATE 734NOCASE, "nco:imDisplayName:graph" INTEGER, "nco:imEnabled" INTEGER, 735"nco:imEnabled:graph" INTEGER); 736CREATE TABLE "nco:IMAccount_nco:hasIMContact" (ID INTEGER NOT NULL, 737"nco:hasIMContact" INTEGER NOT NULL, "nco:hasIMContact:graph" 738INTEGER); 739CREATE TABLE "nco:IMAddress" (ID INTEGER NOT NULL PRIMARY KEY, 740"nco:imID" TEXT COLLATE NOCASE, "nco:imID:graph" INTEGER, 741"nco:imNickname" TEXT COLLATE NOCASE, "nco:imNickname:graph" INTEGER, 742"nco:imAvatar" INTEGER, "nco:imAvatar:graph" INTEGER, "nco:imProtocol" 743TEXT COLLATE NOCASE, "nco:imProtocol:graph" INTEGER, 744"nco:imStatusMessage" TEXT COLLATE NOCASE, 745"nco:imStatusMessage:graph" INTEGER, "nco:imPresence" INTEGER, 746"nco:imPresence:graph" INTEGER, "nco:presenceLastModified" INTEGER, 747"nco:presenceLastModified:graph" INTEGER, 748"nco:presenceLastModified:localDate" INTEGER, 749"nco:presenceLastModified:localTime" INTEGER, 750"nco:imAddressAuthStatusFrom" INTEGER, 751"nco:imAddressAuthStatusFrom:graph" INTEGER, 752"nco:imAddressAuthStatusTo" INTEGER, "nco:imAddressAuthStatusTo:graph" 753INTEGER); 754CREATE TABLE "nco:IMAddress_nco:imCapability" (ID INTEGER NOT NULL, 755"nco:imCapability" INTEGER NOT NULL, "nco:imCapability:graph" 756INTEGER); 757CREATE TABLE "nco:IMCapability" (ID INTEGER NOT NULL PRIMARY KEY); 758CREATE TABLE "nco:InternationalDeliveryAddress" (ID INTEGER NOT NULL 759PRIMARY KEY); 760CREATE TABLE "nco:IsdnNumber" (ID INTEGER NOT NULL PRIMARY KEY); 761CREATE TABLE "nco:MessagingNumber" (ID INTEGER NOT NULL PRIMARY KEY); 762CREATE TABLE "nco:ModemNumber" (ID INTEGER NOT NULL PRIMARY KEY); 763CREATE TABLE "nco:OrganizationContact" (ID INTEGER NOT NULL PRIMARY 764KEY, "nco:logo" INTEGER, "nco:logo:graph" INTEGER); 765CREATE TABLE "nco:PagerNumber" (ID INTEGER NOT NULL PRIMARY KEY); 766CREATE TABLE "nco:ParcelDeliveryAddress" (ID INTEGER NOT NULL PRIMARY KEY); 767CREATE TABLE "nco:PcsNumber" (ID INTEGER NOT NULL PRIMARY KEY); 768CREATE TABLE "nco:PersonContact" (ID INTEGER NOT NULL PRIMARY KEY, 769"nco:nameFamily" TEXT COLLATE NOCASE, "nco:nameFamily:graph" INTEGER, 770"nco:nameGiven" TEXT COLLATE NOCASE, "nco:nameGiven:graph" INTEGER, 771"nco:nameAdditional" TEXT COLLATE NOCASE, "nco:nameAdditional:graph" 772INTEGER, "nco:nameHonorificSuffix" TEXT COLLATE NOCASE, 773"nco:nameHonorificSuffix:graph" INTEGER, "nco:nameHonorificPrefix" 774TEXT COLLATE NOCASE, "nco:nameHonorificPrefix:graph" INTEGER, 775"nco:hobby" TEXT COLLATE NOCASE, "nco:hobby:graph" INTEGER, 776"nco:gender" INTEGER, "nco:gender:graph" INTEGER); 777CREATE TABLE "nco:PersonContact_nco:hasAffiliation" (ID INTEGER NOT 778NULL, "nco:hasAffiliation" INTEGER NOT NULL, 779"nco:hasAffiliation:graph" INTEGER); 780CREATE TABLE "nco:PhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, 781"nco:phoneNumber" TEXT COLLATE NOCASE, "nco:phoneNumber:graph" 782INTEGER); 783CREATE TABLE "nco:PostalAddress" (ID INTEGER NOT NULL PRIMARY KEY, 784"nco:region" TEXT COLLATE NOCASE, "nco:region:graph" INTEGER, 785"nco:country" TEXT COLLATE NOCASE, "nco:country:graph" INTEGER, 786"nco:extendedAddress" TEXT COLLATE NOCASE, 787"nco:extendedAddress:graph" INTEGER, "nco:addressLocation" INTEGER, 788"nco:addressLocation:graph" INTEGER, "nco:streetAddress" TEXT COLLATE 789NOCASE, "nco:streetAddress:graph" INTEGER, "nco:postalcode" TEXT 790COLLATE NOCASE, "nco:postalcode:graph" INTEGER, "nco:locality" TEXT 791COLLATE NOCASE, "nco:locality:graph" INTEGER, "nco:county" TEXT 792COLLATE NOCASE, "nco:county:graph" INTEGER, "nco:district" TEXT 793COLLATE NOCASE, "nco:district:graph" INTEGER, "nco:pobox" TEXT 794COLLATE NOCASE, "nco:pobox:graph" INTEGER); 795CREATE TABLE "nco:PresenceStatus" (ID INTEGER NOT NULL PRIMARY KEY); 796CREATE TABLE "nco:Role" (ID INTEGER NOT NULL PRIMARY KEY, "nco:video" 797INTEGER, "nco:video:graph" INTEGER); 798CREATE TABLE "nco:Role_nco:blogUrl" (ID INTEGER NOT NULL, 799"nco:blogUrl" INTEGER NOT NULL, "nco:blogUrl:graph" INTEGER); 800CREATE TABLE "nco:Role_nco:foafUrl" (ID INTEGER NOT NULL, 801"nco:foafUrl" INTEGER NOT NULL, "nco:foafUrl:graph" INTEGER); 802CREATE TABLE "nco:Role_nco:hasContactMedium" (ID INTEGER NOT NULL, 803"nco:hasContactMedium" INTEGER NOT NULL, "nco:hasContactMedium:graph" 804INTEGER); 805CREATE TABLE "nco:Role_nco:hasEmailAddress" (ID INTEGER NOT NULL, 806"nco:hasEmailAddress" INTEGER NOT NULL, "nco:hasEmailAddress:graph" 807INTEGER); 808CREATE TABLE "nco:Role_nco:hasIMAddress" (ID INTEGER NOT NULL, 809"nco:hasIMAddress" INTEGER NOT NULL, "nco:hasIMAddress:graph" 810INTEGER); 811CREATE TABLE "nco:Role_nco:hasPhoneNumber" (ID INTEGER NOT NULL, 812"nco:hasPhoneNumber" INTEGER NOT NULL, "nco:hasPhoneNumber:graph" 813INTEGER); 814CREATE TABLE "nco:Role_nco:hasPostalAddress" (ID INTEGER NOT NULL, 815"nco:hasPostalAddress" INTEGER NOT NULL, "nco:hasPostalAddress:graph" 816INTEGER); 817CREATE TABLE "nco:Role_nco:url" (ID INTEGER NOT NULL, "nco:url" 818INTEGER NOT NULL, "nco:url:graph" INTEGER); 819CREATE TABLE "nco:Role_nco:websiteUrl" (ID INTEGER NOT NULL, 820"nco:websiteUrl" INTEGER NOT NULL, "nco:websiteUrl:graph" INTEGER); 821CREATE TABLE "nco:VideoTelephoneNumber" (ID INTEGER NOT NULL PRIMARY KEY); 822CREATE TABLE "nco:VoicePhoneNumber" (ID INTEGER NOT NULL PRIMARY KEY, 823"nco:voiceMail" INTEGER, "nco:voiceMail:graph" INTEGER); 824CREATE TABLE "nfo:Application" (ID INTEGER NOT NULL PRIMARY KEY); 825CREATE TABLE "nfo:Archive" (ID INTEGER NOT NULL PRIMARY KEY, 826"nfo:uncompressedSize" INTEGER, "nfo:uncompressedSize:graph" INTEGER); 827CREATE TABLE "nfo:ArchiveItem" (ID INTEGER NOT NULL PRIMARY KEY, 828"nfo:isPasswordProtected" INTEGER, "nfo:isPasswordProtected:graph" 829INTEGER); 830CREATE TABLE "nfo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); 831CREATE TABLE "nfo:Audio" (ID INTEGER NOT NULL PRIMARY KEY, 832"nfo:channels" INTEGER, "nfo:channels:graph" INTEGER, 833"nfo:sideChannels" INTEGER, "nfo:sideChannels:graph" INTEGER, 834"nfo:lfeChannels" INTEGER, "nfo:lfeChannels:graph" INTEGER, 835"nfo:sampleCount" INTEGER, "nfo:sampleCount:graph" INTEGER, 836"nfo:bitsPerSample" INTEGER, "nfo:bitsPerSample:graph" INTEGER, 837"nfo:frontChannels" INTEGER, "nfo:frontChannels:graph" INTEGER, 838"nfo:sampleRate" REAL, "nfo:sampleRate:graph" INTEGER, 839"nfo:averageAudioBitrate" REAL, "nfo:averageAudioBitrate:graph" 840INTEGER, "nfo:rearChannels" INTEGER, "nfo:rearChannels:graph" INTEGER, 841"nfo:gain" INTEGER, "nfo:gain:graph" INTEGER, "nfo:peakGain" INTEGER, 842"nfo:peakGain:graph" INTEGER, "nfo:audioOffset" REAL, 843"nfo:audioOffset:graph" INTEGER); 844CREATE TABLE "nfo:Bookmark" (ID INTEGER NOT NULL PRIMARY KEY, 845"nfo:bookmarks" INTEGER, "nfo:bookmarks:graph" INTEGER, 846"nfo:characterPosition" INTEGER, "nfo:characterPosition:graph" 847INTEGER, "nfo:pageNumber" INTEGER, "nfo:pageNumber:graph" INTEGER, 848"nfo:streamPosition" INTEGER, "nfo:streamPosition:graph" INTEGER, 849"nfo:streamDuration" INTEGER, "nfo:streamDuration:graph" INTEGER); 850CREATE TABLE "nfo:BookmarkFolder" (ID INTEGER NOT NULL PRIMARY KEY); 851CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmark" (ID INTEGER NOT 852NULL, "nfo:containsBookmark" INTEGER NOT NULL, 853"nfo:containsBookmark:graph" INTEGER); 854CREATE TABLE "nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID 855INTEGER NOT NULL, "nfo:containsBookmarkFolder" INTEGER NOT NULL, 856"nfo:containsBookmarkFolder:graph" INTEGER); 857CREATE TABLE "nfo:CompressionType" (ID INTEGER NOT NULL PRIMARY KEY); 858CREATE TABLE "nfo:Cursor" (ID INTEGER NOT NULL PRIMARY KEY); 859CREATE TABLE "nfo:DataContainer" (ID INTEGER NOT NULL PRIMARY KEY); 860CREATE TABLE "nfo:DeletedResource" (ID INTEGER NOT NULL PRIMARY KEY, 861"nfo:originalLocation" TEXT COLLATE NOCASE, 862"nfo:originalLocation:graph" INTEGER, "nfo:deletionDate" INTEGER, 863"nfo:deletionDate:graph" INTEGER, "nfo:deletionDate:localDate" 864INTEGER, "nfo:deletionDate:localTime" INTEGER); 865CREATE TABLE "nfo:Document" (ID INTEGER NOT NULL PRIMARY KEY, 866"nfo:tableOfContents" TEXT COLLATE NOCASE, 867"nfo:tableOfContents:graph" INTEGER); 868CREATE TABLE "nfo:EmbeddedFileDataObject" (ID INTEGER NOT NULL PRIMARY 869KEY, "nfo:encoding" TEXT COLLATE NOCASE, "nfo:encoding:graph" 870INTEGER); 871CREATE TABLE "nfo:Equipment" (ID INTEGER NOT NULL PRIMARY KEY, 872"nfo:manufacturer" TEXT COLLATE NOCASE, "nfo:manufacturer:graph" 873INTEGER, "nfo:model" TEXT COLLATE NOCASE, "nfo:model:graph" INTEGER, 874"nfo:equipmentSoftware" TEXT COLLATE NOCASE, 875"nfo:equipmentSoftware:graph" INTEGER); 876CREATE TABLE "nfo:Executable" (ID INTEGER NOT NULL PRIMARY KEY); 877CREATE TABLE "nfo:FileDataObject" (ID INTEGER NOT NULL PRIMARY KEY, 878"nfo:fileLastAccessed" INTEGER, "nfo:fileLastAccessed:graph" INTEGER, 879"nfo:fileLastAccessed:localDate" INTEGER, 880"nfo:fileLastAccessed:localTime" INTEGER, "nfo:fileCreated" INTEGER, 881"nfo:fileCreated:graph" INTEGER, "nfo:fileCreated:localDate" INTEGER, 882"nfo:fileCreated:localTime" INTEGER, "nfo:fileSize" INTEGER, 883"nfo:fileSize:graph" INTEGER, "nfo:permissions" TEXT COLLATE NOCASE, 884"nfo:permissions:graph" INTEGER, "nfo:fileName" TEXT COLLATE NOCASE, 885"nfo:fileName:graph" INTEGER, "nfo:hasHash" INTEGER, 886"nfo:hasHash:graph" INTEGER, "nfo:fileOwner" INTEGER, 887"nfo:fileOwner:graph" INTEGER, "nfo:fileLastModified" INTEGER, 888"nfo:fileLastModified:graph" INTEGER, "nfo:fileLastModified:localDate" 889INTEGER, "nfo:fileLastModified:localTime" INTEGER); 890CREATE TABLE "nfo:FileHash" (ID INTEGER NOT NULL PRIMARY KEY, 891"nfo:hashValue" TEXT COLLATE NOCASE, "nfo:hashValue:graph" INTEGER, 892"nfo:hashAlgorithm" TEXT COLLATE NOCASE, "nfo:hashAlgorithm:graph" 893INTEGER); 894CREATE TABLE "nfo:Filesystem" (ID INTEGER NOT NULL PRIMARY KEY); 895CREATE TABLE "nfo:FilesystemImage" (ID INTEGER NOT NULL PRIMARY KEY); 896CREATE TABLE "nfo:Folder" (ID INTEGER NOT NULL PRIMARY KEY); 897CREATE TABLE "nfo:Font" (ID INTEGER NOT NULL PRIMARY KEY, 898"nfo:fontFamily" TEXT COLLATE NOCASE, "nfo:fontFamily:graph" INTEGER, 899"nfo:foundry" INTEGER, "nfo:foundry:graph" INTEGER); 900CREATE TABLE "nfo:HardDiskPartition" (ID INTEGER NOT NULL PRIMARY KEY); 901CREATE TABLE "nfo:HelpDocument" (ID INTEGER NOT NULL PRIMARY KEY); 902CREATE TABLE "nfo:HtmlDocument" (ID INTEGER NOT NULL PRIMARY KEY); 903CREATE TABLE "nfo:Icon" (ID INTEGER NOT NULL PRIMARY KEY); 904CREATE TABLE "nfo:Image" (ID INTEGER NOT NULL PRIMARY KEY, 905"nfo:verticalResolution" INTEGER, "nfo:verticalResolution:graph" 906INTEGER, "nfo:horizontalResolution" INTEGER, 907"nfo:horizontalResolution:graph" INTEGER, "nfo:orientation" INTEGER, 908"nfo:orientation:graph" INTEGER); 909CREATE TABLE "nfo:Image_nfo:depicts" (ID INTEGER NOT NULL, 910"nfo:depicts" INTEGER NOT NULL, "nfo:depicts:graph" INTEGER); 911CREATE TABLE "nfo:Image_nfo:hasRegionOfInterest" (ID INTEGER NOT NULL, 912"nfo:hasRegionOfInterest" INTEGER NOT NULL, 913"nfo:hasRegionOfInterest:graph" INTEGER); 914CREATE TABLE "nfo:Media" (ID INTEGER NOT NULL PRIMARY KEY, "nfo:count" 915INTEGER, "nfo:count:graph" INTEGER, "nfo:duration" INTEGER, 916"nfo:duration:graph" INTEGER, "nfo:compressionType" INTEGER, 917"nfo:compressionType:graph" INTEGER, "nfo:hasMediaStream" INTEGER, 918"nfo:hasMediaStream:graph" INTEGER, "nfo:bitDepth" INTEGER, 919"nfo:bitDepth:graph" INTEGER, "nfo:codec" TEXT COLLATE NOCASE, 920"nfo:codec:graph" INTEGER, "nfo:encodedBy" TEXT COLLATE NOCASE, 921"nfo:encodedBy:graph" INTEGER, "nfo:bitrateType" TEXT COLLATE NOCASE, 922"nfo:bitrateType:graph" INTEGER, "nfo:averageBitrate" REAL, 923"nfo:averageBitrate:graph" INTEGER, "nfo:genre" TEXT COLLATE NOCASE, 924"nfo:genre:graph" INTEGER, "nfo:equipment" INTEGER, 925"nfo:equipment:graph" INTEGER, "nfo:lastPlayedPosition" INTEGER, 926"nfo:lastPlayedPosition:graph" INTEGER, "nmm:genre" TEXT COLLATE 927NOCASE, "nmm:genre:graph" INTEGER, "nmm:skipCounter" INTEGER, 928"nmm:skipCounter:graph" INTEGER, "nmm:dlnaProfile" TEXT COLLATE 929NOCASE, "nmm:dlnaProfile:graph" INTEGER, "nmm:dlnaMime" TEXT COLLATE 930NOCASE, "nmm:dlnaMime:graph" INTEGER, "nmm:uPnPShared" INTEGER, 931"nmm:uPnPShared:graph" INTEGER, "mtp:credits" TEXT COLLATE NOCASE, 932"mtp:credits:graph" INTEGER, "mtp:creator" TEXT COLLATE NOCASE, 933"mtp:creator:graph" INTEGER); 934CREATE TABLE "nfo:MediaFileListEntry" (ID INTEGER NOT NULL PRIMARY 935KEY, "nfo:listPosition" REAL, "nfo:listPosition:graph" INTEGER, 936"nfo:entryUrl" TEXT COLLATE NOCASE, "nfo:entryUrl:graph" INTEGER); 937CREATE TABLE "nfo:MediaList" (ID INTEGER NOT NULL PRIMARY KEY, 938"nfo:entryCounter" INTEGER, "nfo:entryCounter:graph" INTEGER, 939"nfo:listDuration" INTEGER, "nfo:listDuration:graph" INTEGER); 940CREATE TABLE "nfo:MediaList_nfo:hasMediaFileListEntry" (ID INTEGER NOT 941NULL, "nfo:hasMediaFileListEntry" INTEGER NOT NULL, 942"nfo:hasMediaFileListEntry:graph" INTEGER); 943CREATE TABLE "nfo:MediaList_nfo:mediaListEntry" (ID INTEGER NOT NULL, 944"nfo:mediaListEntry" INTEGER NOT NULL, "nfo:mediaListEntry:graph" 945INTEGER); 946CREATE TABLE "nfo:MediaStream" (ID INTEGER NOT NULL PRIMARY KEY); 947CREATE TABLE "nfo:Media_mtp:hidden" (ID INTEGER NOT NULL, "mtp:hidden" 948INTEGER NOT NULL, "mtp:hidden:graph" INTEGER); 949CREATE TABLE "nfo:Media_nmm:alternativeMedia" (ID INTEGER NOT NULL, 950"nmm:alternativeMedia" INTEGER NOT NULL, "nmm:alternativeMedia:graph" 951INTEGER); 952CREATE TABLE "nfo:MindMap" (ID INTEGER NOT NULL PRIMARY KEY); 953CREATE TABLE "nfo:Note" (ID INTEGER NOT NULL PRIMARY KEY); 954CREATE TABLE "nfo:OperatingSystem" (ID INTEGER NOT NULL PRIMARY KEY); 955CREATE TABLE "nfo:Orientation" (ID INTEGER NOT NULL PRIMARY KEY); 956CREATE TABLE "nfo:PaginatedTextDocument" (ID INTEGER NOT NULL PRIMARY 957KEY, "nfo:pageCount" INTEGER, "nfo:pageCount:graph" INTEGER); 958CREATE TABLE "nfo:PlainTextDocument" (ID INTEGER NOT NULL PRIMARY KEY); 959CREATE TABLE "nfo:Presentation" (ID INTEGER NOT NULL PRIMARY KEY); 960CREATE TABLE "nfo:RasterImage" (ID INTEGER NOT NULL PRIMARY KEY); 961CREATE TABLE "nfo:RegionOfInterest" (ID INTEGER NOT NULL PRIMARY KEY, 962"nfo:regionOfInterestX" REAL, "nfo:regionOfInterestX:graph" INTEGER, 963"nfo:regionOfInterestY" REAL, "nfo:regionOfInterestY:graph" INTEGER, 964"nfo:regionOfInterestWidth" REAL, "nfo:regionOfInterestWidth:graph" 965INTEGER, "nfo:regionOfInterestHeight" REAL, 966"nfo:regionOfInterestHeight:graph" INTEGER, "nfo:regionOfInterestType" 967INTEGER, "nfo:regionOfInterestType:graph" INTEGER, "nfo:roiRefersTo" 968INTEGER, "nfo:roiRefersTo:graph" INTEGER); 969CREATE TABLE "nfo:RegionOfInterestContent" (ID INTEGER NOT NULL PRIMARY KEY); 970CREATE TABLE "nfo:RemoteDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 971CREATE TABLE "nfo:RemotePortAddress" (ID INTEGER NOT NULL PRIMARY KEY); 972CREATE TABLE "nfo:Software" (ID INTEGER NOT NULL PRIMARY KEY, 973"nfo:conflicts" INTEGER, "nfo:conflicts:graph" INTEGER, 974"nfo:supercedes" INTEGER, "nfo:supercedes:graph" INTEGER, 975"nfo:softwareIcon" INTEGER, "nfo:softwareIcon:graph" INTEGER, 976"nfo:softwareCmdLine" TEXT COLLATE NOCASE, 977"nfo:softwareCmdLine:graph" INTEGER); 978CREATE TABLE "nfo:SoftwareApplication" (ID INTEGER NOT NULL PRIMARY KEY); 979CREATE TABLE "nfo:SoftwareCategory" (ID INTEGER NOT NULL PRIMARY KEY, 980"nfo:softwareCategoryIcon" INTEGER, "nfo:softwareCategoryIcon:graph" 981INTEGER); 982CREATE TABLE "nfo:SoftwareItem" (ID INTEGER NOT NULL PRIMARY KEY); 983CREATE TABLE "nfo:SoftwareService" (ID INTEGER NOT NULL PRIMARY KEY); 984CREATE TABLE "nfo:SourceCode" (ID INTEGER NOT NULL PRIMARY KEY, 985"nfo:commentCharacterCount" INTEGER, "nfo:commentCharacterCount:graph" 986INTEGER, "nfo:programmingLanguage" TEXT COLLATE NOCASE, 987"nfo:programmingLanguage:graph" INTEGER, "nfo:definesClass" TEXT 988COLLATE NOCASE, "nfo:definesClass:graph" INTEGER, 989"nfo:definesFunction" TEXT COLLATE NOCASE, 990"nfo:definesFunction:graph" INTEGER, "nfo:definesGlobalVariable" TEXT 991COLLATE NOCASE, "nfo:definesGlobalVariable:graph" INTEGER); 992CREATE TABLE "nfo:Spreadsheet" (ID INTEGER NOT NULL PRIMARY KEY); 993CREATE TABLE "nfo:TextDocument" (ID INTEGER NOT NULL PRIMARY KEY, 994"nfo:wordCount" INTEGER, "nfo:wordCount:graph" INTEGER, 995"nfo:lineCount" INTEGER, "nfo:lineCount:graph" INTEGER, 996"nfo:characterCount" INTEGER, "nfo:characterCount:graph" INTEGER); 997CREATE TABLE "nfo:Trash" (ID INTEGER NOT NULL PRIMARY KEY); 998CREATE TABLE "nfo:VectorImage" (ID INTEGER NOT NULL PRIMARY KEY); 999CREATE TABLE "nfo:Video" (ID INTEGER NOT NULL PRIMARY KEY, 1000"nfo:frameRate" REAL, "nfo:frameRate:graph" INTEGER, "nfo:frameCount" 1001INTEGER, "nfo:frameCount:graph" INTEGER, "nfo:averageVideoBitrate" 1002REAL, "nfo:averageVideoBitrate:graph" INTEGER); 1003CREATE TABLE "nfo:Visual" (ID INTEGER NOT NULL PRIMARY KEY, 1004"nie:contentCreated" INTEGER, "nie:contentCreated:graph" INTEGER, 1005"nie:contentCreated:localDate" INTEGER, "nie:contentCreated:localTime" 1006INTEGER, "nfo:aspectRatio" REAL, "nfo:aspectRatio:graph" INTEGER, 1007"nfo:heading" REAL, "nfo:heading:graph" INTEGER, "nfo:tilt" REAL, 1008"nfo:tilt:graph" INTEGER, "nfo:interlaceMode" INTEGER, 1009"nfo:interlaceMode:graph" INTEGER, "nfo:height" INTEGER, 1010"nfo:height:graph" INTEGER, "nfo:width" INTEGER, "nfo:width:graph" 1011INTEGER, "nfo:colorDepth" INTEGER, "nfo:colorDepth:graph" INTEGER); 1012CREATE TABLE "nfo:WebHistory" (ID INTEGER NOT NULL PRIMARY KEY, 1013"nfo:domain" TEXT COLLATE NOCASE, "nfo:domain:graph" INTEGER, 1014"nfo:uri" TEXT COLLATE NOCASE, "nfo:uri:graph" INTEGER); 1015CREATE TABLE "nfo:Website" (ID INTEGER NOT NULL PRIMARY KEY); 1016CREATE TABLE "nid3:ID3Audio" (ID INTEGER NOT NULL PRIMARY KEY, 1017"nid3:title" TEXT COLLATE NOCASE, "nid3:title:graph" INTEGER, 1018"nid3:albumTitle" TEXT COLLATE NOCASE, "nid3:albumTitle:graph" 1019INTEGER, "nid3:contentType" TEXT COLLATE NOCASE, 1020"nid3:contentType:graph" INTEGER, "nid3:length" INTEGER, 1021"nid3:length:graph" INTEGER, "nid3:recordingYear" INTEGER, 1022"nid3:recordingYear:graph" INTEGER, "nid3:trackNumber" TEXT COLLATE 1023NOCASE, "nid3:trackNumber:graph" INTEGER, "nid3:partOfSet" TEXT 1024COLLATE NOCASE, "nid3:partOfSet:graph" INTEGER, "nid3:comments" TEXT 1025COLLATE NOCASE, "nid3:comments:graph" INTEGER); 1026CREATE TABLE "nid3:ID3Audio_nid3:leadArtist" (ID INTEGER NOT NULL, 1027"nid3:leadArtist" INTEGER NOT NULL, "nid3:leadArtist:graph" INTEGER); 1028CREATE TABLE "nie:DataObject" (ID INTEGER NOT NULL PRIMARY KEY, 1029"nie:url" TEXT COLLATE NOCASE UNIQUE, "nie:url:graph" INTEGER, 1030"nie:byteSize" INTEGER, "nie:byteSize:graph" INTEGER, 1031"nie:interpretedAs" INTEGER, "nie:interpretedAs:graph" INTEGER, 1032"nie:lastRefreshed" INTEGER, "nie:lastRefreshed:graph" INTEGER, 1033"nie:lastRefreshed:localDate" INTEGER, "nie:lastRefreshed:localTime" 1034INTEGER, "nie:created" INTEGER, "nie:created:graph" INTEGER, 1035"nie:created:localDate" INTEGER, "nie:created:localTime" INTEGER, 1036"nfo:belongsToContainer" INTEGER, "nfo:belongsToContainer:graph" 1037INTEGER, "tracker:available" INTEGER, "tracker:available:graph" 1038INTEGER); 1039CREATE TABLE "nie:DataObject_nie:dataSource" (ID INTEGER NOT NULL, 1040"nie:dataSource" INTEGER NOT NULL, "nie:dataSource:graph" INTEGER); 1041CREATE TABLE "nie:DataObject_nie:isPartOf" (ID INTEGER NOT NULL, 1042"nie:isPartOf" INTEGER NOT NULL, "nie:isPartOf:graph" INTEGER); 1043CREATE TABLE "nie:DataSource" (ID INTEGER NOT NULL PRIMARY KEY); 1044CREATE TABLE "nie:InformationElement" (ID INTEGER NOT NULL PRIMARY 1045KEY, "nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1046"nie:contentLastModified" INTEGER, "nie:contentLastModified:graph" 1047INTEGER, "nie:contentLastModified:localDate" INTEGER, 1048"nie:contentLastModified:localTime" INTEGER, "nie:subject" TEXT 1049COLLATE NOCASE, "nie:subject:graph" INTEGER, "nie:mimeType" TEXT 1050COLLATE NOCASE, "nie:mimeType:graph" INTEGER, "nie:language" TEXT 1051COLLATE NOCASE, "nie:language:graph" INTEGER, "nie:plainTextContent" 1052TEXT COLLATE NOCASE, "nie:plainTextContent:graph" INTEGER, 1053"nie:legal" TEXT COLLATE NOCASE, "nie:legal:graph" INTEGER, 1054"nie:generator" TEXT COLLATE NOCASE, "nie:generator:graph" INTEGER, 1055"nie:description" TEXT COLLATE NOCASE, "nie:description:graph" 1056INTEGER, "nie:disclaimer" TEXT COLLATE NOCASE, "nie:disclaimer:graph" 1057INTEGER, "nie:depends" INTEGER, "nie:depends:graph" INTEGER, 1058"nie:links" INTEGER, "nie:links:graph" INTEGER, "nie:copyright" TEXT 1059COLLATE NOCASE, "nie:copyright:graph" INTEGER, "nie:comment" TEXT 1060COLLATE NOCASE, "nie:comment:graph" INTEGER, "nie:isStoredAs" 1061INTEGER, "nie:isStoredAs:graph" INTEGER, "nie:version" TEXT COLLATE 1062NOCASE, "nie:version:graph" INTEGER, "nie:contentCreated" INTEGER, 1063"nie:contentCreated:graph" INTEGER, "nie:contentCreated:localDate" 1064INTEGER, "nie:contentCreated:localTime" INTEGER, "nie:contentAccessed" 1065INTEGER, "nie:contentAccessed:graph" INTEGER, 1066"nie:contentAccessed:localDate" INTEGER, 1067"nie:contentAccessed:localTime" INTEGER, "nie:license" TEXT COLLATE 1068NOCASE, "nie:license:graph" INTEGER, "nie:identifier" TEXT COLLATE 1069NOCASE, "nie:identifier:graph" INTEGER, "nie:licenseType" TEXT 1070COLLATE NOCASE, "nie:licenseType:graph" INTEGER, "nie:characterSet" 1071TEXT COLLATE NOCASE, "nie:characterSet:graph" INTEGER, 1072"nie:contentSize" INTEGER, "nie:contentSize:graph" INTEGER, 1073"nie:rootElementOf" INTEGER, "nie:rootElementOf:graph" INTEGER, 1074"nie:usageCounter" INTEGER, "nie:usageCounter:graph" INTEGER, 1075"nco:publisher" INTEGER, "nco:publisher:graph" INTEGER, 1076"nfo:isContentEncrypted" INTEGER, "nfo:isContentEncrypted:graph" 1077INTEGER, "slo:location" INTEGER, "slo:location:graph" INTEGER, 1078"nfo:isBootable" INTEGER, "nfo:isBootable:graph" INTEGER, "osinfo:id" 1079TEXT COLLATE NOCASE, "osinfo:id:graph" INTEGER, "osinfo:mediaId" TEXT 1080COLLATE NOCASE, "osinfo:mediaId:graph" INTEGER); 1081CREATE TABLE "nie:InformationElement_mlo:location" (ID INTEGER NOT 1082NULL, "mlo:location" INTEGER NOT NULL, "mlo:location:graph" INTEGER); 1083CREATE TABLE "nie:InformationElement_nao:hasProperty" (ID INTEGER NOT 1084NULL, "nao:hasProperty" INTEGER NOT NULL, "nao:hasProperty:graph" 1085INTEGER); 1086CREATE TABLE "nie:InformationElement_nco:contributor" (ID INTEGER NOT 1087NULL, "nco:contributor" INTEGER NOT NULL, "nco:contributor:graph" 1088INTEGER); 1089CREATE TABLE "nie:InformationElement_nco:creator" (ID INTEGER NOT 1090NULL, "nco:creator" INTEGER NOT NULL, "nco:creator:graph" INTEGER); 1091CREATE TABLE "nie:InformationElement_nie:hasLogicalPart" (ID INTEGER 1092NOT NULL, "nie:hasLogicalPart" INTEGER NOT NULL, 1093"nie:hasLogicalPart:graph" INTEGER); 1094CREATE TABLE "nie:InformationElement_nie:hasPart" (ID INTEGER NOT 1095NULL, "nie:hasPart" INTEGER NOT NULL, "nie:hasPart:graph" INTEGER); 1096CREATE TABLE "nie:InformationElement_nie:informationElementDate" (ID 1097INTEGER NOT NULL, "nie:informationElementDate" INTEGER NOT NULL, 1098"nie:informationElementDate:graph" INTEGER, 1099"nie:informationElementDate:localDate" INTEGER NOT NULL, 1100"nie:informationElementDate:localTime" INTEGER NOT NULL); 1101CREATE TABLE "nie:InformationElement_nie:isLogicalPartOf" (ID INTEGER 1102NOT NULL, "nie:isLogicalPartOf" INTEGER NOT NULL, 1103"nie:isLogicalPartOf:graph" INTEGER); 1104CREATE TABLE "nie:InformationElement_nie:keyword" (ID INTEGER NOT 1105NULL, "nie:keyword" TEXT NOT NULL, "nie:keyword:graph" INTEGER); 1106CREATE TABLE "nie:InformationElement_nie:relatedTo" (ID INTEGER NOT 1107NULL, "nie:relatedTo" INTEGER NOT NULL, "nie:relatedTo:graph" 1108INTEGER); 1109CREATE TABLE "nmm:AnalogRadio" (ID INTEGER NOT NULL PRIMARY KEY, 1110"nmm:modulation" INTEGER, "nmm:modulation:graph" INTEGER, 1111"nmm:frequency" INTEGER, "nmm:frequency:graph" INTEGER); 1112CREATE TABLE "nmm:Artist" (ID INTEGER NOT NULL PRIMARY KEY, 1113"nmm:artistName" TEXT COLLATE NOCASE, "nmm:artistName:graph" 1114INTEGER); 1115CREATE TABLE "nmm:DigitalRadio" (ID INTEGER NOT NULL PRIMARY KEY, 1116"nmm:streamingBitrate" INTEGER, "nmm:streamingBitrate:graph" INTEGER, 1117"nmm:encoding" TEXT COLLATE NOCASE, "nmm:encoding:graph" INTEGER, 1118"nmm:protocol" TEXT COLLATE NOCASE, "nmm:protocol:graph" INTEGER); 1119CREATE TABLE "nmm:Flash" (ID INTEGER NOT NULL PRIMARY KEY); 1120CREATE TABLE "nmm:ImageList" (ID INTEGER NOT NULL PRIMARY KEY); 1121CREATE TABLE "nmm:MeteringMode" (ID INTEGER NOT NULL PRIMARY KEY); 1122CREATE TABLE "nmm:MusicAlbum" (ID INTEGER NOT NULL PRIMARY KEY, 1123"nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1124"nmm:albumTrackCount" INTEGER, "nmm:albumTrackCount:graph" INTEGER, 1125"nmm:albumTitle" TEXT COLLATE NOCASE, "nmm:albumTitle:graph" INTEGER, 1126"nmm:albumDuration" INTEGER, "nmm:albumDuration:graph" INTEGER, 1127"nmm:albumGain" INTEGER, "nmm:albumGain:graph" INTEGER, 1128"nmm:albumPeakGain" INTEGER, "nmm:albumPeakGain:graph" INTEGER); 1129CREATE TABLE "nmm:MusicAlbumDisc" (ID INTEGER NOT NULL PRIMARY KEY, 1130"nmm:albumDiscAlbum" INTEGER, "nmm:albumDiscAlbum:graph" INTEGER, 1131"nmm:musicCDIdentifier" TEXT COLLATE NOCASE, 1132"nmm:musicCDIdentifier:graph" INTEGER, "nmm:setNumber" INTEGER, 1133"nmm:setNumber:graph" INTEGER); 1134CREATE TABLE "nmm:MusicAlbum_nmm:albumArtist" (ID INTEGER NOT NULL, 1135"nmm:albumArtist" INTEGER NOT NULL, "nmm:albumArtist:graph" INTEGER); 1136CREATE TABLE "nmm:MusicPiece" (ID INTEGER NOT NULL PRIMARY KEY, 1137"nie:title" TEXT COLLATE NOCASE, "nie:title:graph" INTEGER, 1138"nmm:musicAlbum" INTEGER, "nmm:musicAlbum:graph" INTEGER, 1139"nmm:musicAlbumDisc" INTEGER, "nmm:musicAlbumDisc:graph" INTEGER, 1140"nmm:beatsPerMinute" INTEGER, "nmm:beatsPerMinute:graph" INTEGER, 1141"nmm:performer" INTEGER, "nmm:performer:graph" INTEGER, "nmm:composer" 1142INTEGER, "nmm:composer:graph" INTEGER, "nmm:lyricist" INTEGER, 1143"nmm:lyricist:graph" INTEGER, "nmm:trackNumber" INTEGER, 1144"nmm:trackNumber:graph" INTEGER, 1145"nmm:internationalStandardRecordingCode" TEXT COLLATE NOCASE, 1146"nmm:internationalStandardRecordingCode:graph" INTEGER); 1147CREATE TABLE "nmm:MusicPiece_nmm:lyrics" (ID INTEGER NOT NULL, 1148"nmm:lyrics" INTEGER NOT NULL, "nmm:lyrics:graph" INTEGER); 1149CREATE TABLE "nmm:Photo" (ID INTEGER NOT NULL PRIMARY KEY, 1150"nmm:exposureTime" REAL, "nmm:exposureTime:graph" INTEGER, "nmm:flash" 1151INTEGER, "nmm:flash:graph" INTEGER, "nmm:fnumber" REAL, 1152"nmm:fnumber:graph" INTEGER, "nmm:focalLength" REAL, 1153"nmm:focalLength:graph" INTEGER, "nmm:isoSpeed" REAL, 1154"nmm:isoSpeed:graph" INTEGER, "nmm:meteringMode" INTEGER, 1155"nmm:meteringMode:graph" INTEGER, "nmm:whiteBalance" INTEGER, 1156"nmm:whiteBalance:graph" INTEGER, "nmm:isCropped" INTEGER, 1157"nmm:isCropped:graph" INTEGER, "nmm:isColorCorrected" INTEGER, 1158"nmm:isColorCorrected:graph" INTEGER); 1159CREATE TABLE "nmm:Playlist" (ID INTEGER NOT NULL PRIMARY KEY); 1160CREATE TABLE "nmm:RadioModulation" (ID INTEGER NOT NULL PRIMARY KEY); 1161CREATE TABLE "nmm:RadioStation" (ID INTEGER NOT NULL PRIMARY KEY, 1162"nmm:radioIcon" INTEGER, "nmm:radioIcon:graph" INTEGER, "nmm:radioPTY" 1163INTEGER, "nmm:radioPTY:graph" INTEGER); 1164CREATE TABLE "nmm:RadioStation_nmm:carrier" (ID INTEGER NOT NULL, 1165"nmm:carrier" INTEGER NOT NULL, "nmm:carrier:graph" INTEGER); 1166CREATE TABLE "nmm:SynchronizedText" (ID INTEGER NOT NULL PRIMARY KEY, 1167"nmm:isForHearingImpaired" INTEGER, "nmm:isForHearingImpaired:graph" 1168INTEGER); 1169CREATE TABLE "nmm:Video" (ID INTEGER NOT NULL PRIMARY KEY, 1170"nmm:videoAlbum" INTEGER, "nmm:videoAlbum:graph" INTEGER, 1171"nmm:isSeries" INTEGER, "nmm:isSeries:graph" INTEGER, "nmm:season" 1172INTEGER, "nmm:season:graph" INTEGER, "nmm:episodeNumber" INTEGER, 1173"nmm:episodeNumber:graph" INTEGER, "nmm:runTime" INTEGER, 1174"nmm:runTime:graph" INTEGER, "nmm:synopsis" TEXT COLLATE NOCASE, 1175"nmm:synopsis:graph" INTEGER, "nmm:MPAARating" TEXT COLLATE NOCASE, 1176"nmm:MPAARating:graph" INTEGER, "nmm:category" TEXT COLLATE NOCASE, 1177"nmm:category:graph" INTEGER, "nmm:producedBy" INTEGER, 1178"nmm:producedBy:graph" INTEGER, "nmm:hasSubtitle" INTEGER, 1179"nmm:hasSubtitle:graph" INTEGER, "nmm:isContentEncrypted" INTEGER, 1180"nmm:isContentEncrypted:graph" INTEGER, "mtp:fourCC" TEXT COLLATE 1181NOCASE, "mtp:fourCC:graph" INTEGER, "mtp:waveformat" TEXT COLLATE 1182NOCASE, "mtp:waveformat:graph" INTEGER); 1183CREATE TABLE "nmm:Video_mtp:scantype" (ID INTEGER NOT NULL, 1184"mtp:scantype" INTEGER NOT NULL, "mtp:scantype:graph" INTEGER); 1185CREATE TABLE "nmm:Video_nmm:director" (ID INTEGER NOT NULL, 1186"nmm:director" INTEGER NOT NULL, "nmm:director:graph" INTEGER); 1187CREATE TABLE "nmm:Video_nmm:leadActor" (ID INTEGER NOT NULL, 1188"nmm:leadActor" INTEGER NOT NULL, "nmm:leadActor:graph" INTEGER); 1189CREATE TABLE "nmm:Video_nmm:subtitle" (ID INTEGER NOT NULL, 1190"nmm:subtitle" INTEGER NOT NULL, "nmm:subtitle:graph" INTEGER); 1191CREATE TABLE "nmm:WhiteBalance" (ID INTEGER NOT NULL PRIMARY KEY); 1192CREATE TABLE "nmo:Attachment" (ID INTEGER NOT NULL PRIMARY KEY); 1193CREATE TABLE "nmo:Call" (ID INTEGER NOT NULL PRIMARY KEY, 1194"nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, 1195"nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, 1196"nmo:duration" INTEGER, "nmo:duration:graph" INTEGER); 1197CREATE TABLE "nmo:CommunicationChannel" (ID INTEGER NOT NULL PRIMARY 1198KEY, "nmo:lastMessageDate" INTEGER, "nmo:lastMessageDate:graph" 1199INTEGER, "nmo:lastMessageDate:localDate" INTEGER, 1200"nmo:lastMessageDate:localTime" INTEGER, 1201"nmo:lastSuccessfulMessageDate" INTEGER, 1202"nmo:lastSuccessfulMessageDate:graph" INTEGER, 1203"nmo:lastSuccessfulMessageDate:localDate" INTEGER, 1204"nmo:lastSuccessfulMessageDate:localTime" INTEGER); 1205CREATE TABLE "nmo:CommunicationChannel_nmo:hasParticipant" (ID INTEGER 1206NOT NULL, "nmo:hasParticipant" INTEGER NOT NULL, 1207"nmo:hasParticipant:graph" INTEGER); 1208CREATE TABLE "nmo:Conversation" (ID INTEGER NOT NULL PRIMARY KEY); 1209CREATE TABLE "nmo:DeliveryStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1210CREATE TABLE "nmo:Email" (ID INTEGER NOT NULL PRIMARY KEY, 1211"nmo:hasContent" INTEGER, "nmo:hasContent:graph" INTEGER, 1212"nmo:isFlagged" INTEGER, "nmo:isFlagged:graph" INTEGER, "nmo:isRecent" 1213INTEGER, "nmo:isRecent:graph" INTEGER, "nmo:status" TEXT COLLATE 1214NOCASE, "nmo:status:graph" INTEGER, "nmo:responseType" TEXT COLLATE 1215NOCASE, "nmo:responseType:graph" INTEGER); 1216CREATE TABLE "nmo:Email_nmo:contentMimeType" (ID INTEGER NOT NULL, 1217"nmo:contentMimeType" TEXT NOT NULL, "nmo:contentMimeType:graph" 1218INTEGER); 1219CREATE TABLE "nmo:IMMessage" (ID INTEGER NOT NULL PRIMARY KEY); 1220CREATE TABLE "nmo:MMSMessage" (ID INTEGER NOT NULL PRIMARY KEY, 1221"nmo:mmsHasContent" INTEGER, "nmo:mmsHasContent:graph" INTEGER); 1222CREATE TABLE "nmo:MailAccount" (ID INTEGER NOT NULL PRIMARY KEY, 1223"nmo:accountName" TEXT COLLATE NOCASE, "nmo:accountName:graph" 1224INTEGER, "nmo:accountDisplayName" TEXT COLLATE NOCASE, 1225"nmo:accountDisplayName:graph" INTEGER, "nmo:fromAddress" INTEGER, 1226"nmo:fromAddress:graph" INTEGER, "nmo:signature" TEXT COLLATE NOCASE, 1227"nmo:signature:graph" INTEGER); 1228CREATE TABLE "nmo:MailFolder" (ID INTEGER NOT NULL PRIMARY KEY, 1229"nmo:folderName" TEXT COLLATE NOCASE, "nmo:folderName:graph" INTEGER, 1230"nmo:serverCount" INTEGER, "nmo:serverCount:graph" INTEGER, 1231"nmo:serverUnreadCount" INTEGER, "nmo:serverUnreadCount:graph" 1232INTEGER); 1233CREATE TABLE "nmo:MailboxDataObject" (ID INTEGER NOT NULL PRIMARY KEY); 1234CREATE TABLE "nmo:Message" (ID INTEGER NOT NULL PRIMARY KEY, 1235"nmo:sentDate" INTEGER, "nmo:sentDate:graph" INTEGER, 1236"nmo:sentDate:localDate" INTEGER, "nmo:sentDate:localTime" INTEGER, 1237"nmo:from" INTEGER, "nmo:from:graph" INTEGER, "nmo:isAnswered" 1238INTEGER, "nmo:isAnswered:graph" INTEGER, "nmo:isDeleted" INTEGER, 1239"nmo:isDeleted:graph" INTEGER, "nmo:isDraft" INTEGER, 1240"nmo:isDraft:graph" INTEGER, "nmo:isRead" INTEGER, "nmo:isRead:graph" 1241INTEGER, "nmo:isSent" INTEGER, "nmo:isSent:graph" INTEGER, 1242"nmo:isEmergency" INTEGER, "nmo:isEmergency:graph" INTEGER, 1243"nmo:htmlMessageContent" TEXT COLLATE NOCASE, 1244"nmo:htmlMessageContent:graph" INTEGER, "nmo:messageId" TEXT COLLATE 1245NOCASE, "nmo:messageId:graph" INTEGER, "nmo:messageSubject" TEXT 1246COLLATE NOCASE, "nmo:messageSubject:graph" INTEGER, 1247"nmo:receivedDate" INTEGER, "nmo:receivedDate:graph" INTEGER, 1248"nmo:receivedDate:localDate" INTEGER, "nmo:receivedDate:localTime" 1249INTEGER, "nmo:replyTo" INTEGER, "nmo:replyTo:graph" INTEGER, 1250"nmo:sender" INTEGER, "nmo:sender:graph" INTEGER, "nmo:conversation" 1251INTEGER, "nmo:conversation:graph" INTEGER, "nmo:communicationChannel" 1252INTEGER, "nmo:communicationChannel:graph" INTEGER, 1253"nmo:deliveryStatus" INTEGER, "nmo:deliveryStatus:graph" INTEGER, 1254"nmo:reportDelivery" INTEGER, "nmo:reportDelivery:graph" INTEGER, 1255"nmo:sentWithReportRead" INTEGER, "nmo:sentWithReportRead:graph" 1256INTEGER, "nmo:reportReadStatus" INTEGER, "nmo:reportReadStatus:graph" 1257INTEGER, "nmo:mustAnswerReportRead" INTEGER, 1258"nmo:mustAnswerReportRead:graph" INTEGER, "nmo:mmsId" TEXT COLLATE 1259NOCASE, "nmo:mmsId:graph" INTEGER); 1260CREATE TABLE "nmo:MessageHeader" (ID INTEGER NOT NULL PRIMARY KEY, 1261"nmo:headerName" TEXT COLLATE NOCASE, "nmo:headerName:graph" INTEGER, 1262"nmo:headerValue" TEXT COLLATE NOCASE, "nmo:headerValue:graph" 1263INTEGER); 1264CREATE TABLE "nmo:Message_nmo:bcc" (ID INTEGER NOT NULL, "nmo:bcc" 1265INTEGER NOT NULL, "nmo:bcc:graph" INTEGER); 1266CREATE TABLE "nmo:Message_nmo:cc" (ID INTEGER NOT NULL, "nmo:cc" 1267INTEGER NOT NULL, "nmo:cc:graph" INTEGER); 1268CREATE TABLE "nmo:Message_nmo:hasAttachment" (ID INTEGER NOT NULL, 1269"nmo:hasAttachment" INTEGER NOT NULL, "nmo:hasAttachment:graph" 1270INTEGER); 1271CREATE TABLE "nmo:Message_nmo:inReplyTo" (ID INTEGER NOT NULL, 1272"nmo:inReplyTo" INTEGER NOT NULL, "nmo:inReplyTo:graph" INTEGER); 1273CREATE TABLE "nmo:Message_nmo:messageHeader" (ID INTEGER NOT NULL, 1274"nmo:messageHeader" INTEGER NOT NULL, "nmo:messageHeader:graph" 1275INTEGER); 1276CREATE TABLE "nmo:Message_nmo:recipient" (ID INTEGER NOT NULL, 1277"nmo:recipient" INTEGER NOT NULL, "nmo:recipient:graph" INTEGER); 1278CREATE TABLE "nmo:Message_nmo:references" (ID INTEGER NOT NULL, 1279"nmo:references" INTEGER NOT NULL, "nmo:references:graph" INTEGER); 1280CREATE TABLE "nmo:Message_nmo:to" (ID INTEGER NOT NULL, "nmo:to" 1281INTEGER NOT NULL, "nmo:to:graph" INTEGER); 1282CREATE TABLE "nmo:MimePart" (ID INTEGER NOT NULL PRIMARY KEY, 1283"nmo:charSet" TEXT COLLATE NOCASE, "nmo:charSet:graph" INTEGER, 1284"nmo:contentId" TEXT COLLATE NOCASE, "nmo:contentId:graph" INTEGER, 1285"nmo:contentTransferEncoding" TEXT COLLATE NOCASE, 1286"nmo:contentTransferEncoding:graph" INTEGER, "nmo:contentDescription" 1287TEXT COLLATE NOCASE, "nmo:contentDescription:graph" INTEGER, 1288"nmo:contentDisposition" TEXT COLLATE NOCASE, 1289"nmo:contentDisposition:graph" INTEGER); 1290CREATE TABLE "nmo:MimePart_nmo:mimeHeader" (ID INTEGER NOT NULL, 1291"nmo:mimeHeader" INTEGER NOT NULL, "nmo:mimeHeader:graph" INTEGER); 1292CREATE TABLE "nmo:Multipart" (ID INTEGER NOT NULL PRIMARY KEY); 1293CREATE TABLE "nmo:Multipart_nmo:partBoundary" (ID INTEGER NOT NULL, 1294"nmo:partBoundary" TEXT NOT NULL, "nmo:partBoundary:graph" INTEGER); 1295CREATE TABLE "nmo:PermanentChannel" (ID INTEGER NOT NULL PRIMARY KEY); 1296CREATE TABLE "nmo:PhoneMessage" (ID INTEGER NOT NULL PRIMARY KEY, 1297"nmo:fromVCard" INTEGER, "nmo:fromVCard:graph" INTEGER, "nmo:encoding" 1298TEXT COLLATE NOCASE, "nmo:encoding:graph" INTEGER, 1299"nmo:phoneMessageId" INTEGER, "nmo:phoneMessageId:graph" INTEGER, 1300"nmo:validityPeriod" INTEGER, "nmo:validityPeriod:graph" INTEGER); 1301CREATE TABLE "nmo:PhoneMessageFolder" (ID INTEGER NOT NULL PRIMARY 1302KEY, "nmo:phoneMessageFolderId" TEXT COLLATE NOCASE, 1303"nmo:phoneMessageFolderId:graph" INTEGER); 1304CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID 1305INTEGER NOT NULL, "nmo:containsPhoneMessage" INTEGER NOT NULL, 1306"nmo:containsPhoneMessage:graph" INTEGER); 1307CREATE TABLE "nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" 1308(ID INTEGER NOT NULL, "nmo:containsPhoneMessageFolder" INTEGER NOT 1309NULL, "nmo:containsPhoneMessageFolder:graph" INTEGER); 1310CREATE TABLE "nmo:PhoneMessage_nmo:toVCard" (ID INTEGER NOT NULL, 1311"nmo:toVCard" INTEGER NOT NULL, "nmo:toVCard:graph" INTEGER); 1312CREATE TABLE "nmo:ReportReadStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1313CREATE TABLE "nmo:SMSMessage" (ID INTEGER NOT NULL PRIMARY KEY); 1314CREATE TABLE "nmo:TransientChannel" (ID INTEGER NOT NULL PRIMARY KEY); 1315CREATE TABLE "nmo:VOIPCall" (ID INTEGER NOT NULL PRIMARY KEY); 1316CREATE TABLE "nrl:InverseFunctionalProperty" (ID INTEGER NOT NULL PRIMARY KEY); 1317CREATE TABLE "osinfo:Installer" (ID INTEGER NOT NULL PRIMARY KEY); 1318CREATE TABLE "poi:ObjectOfInterest" (ID INTEGER NOT NULL PRIMARY KEY); 1319CREATE TABLE "rdf:Property" (ID INTEGER NOT NULL PRIMARY KEY, 1320"rdfs:domain" INTEGER, "rdfs:domain:graph" INTEGER, "rdfs:range" 1321INTEGER, "rdfs:range:graph" INTEGER, "tracker:indexed" INTEGER, 1322"tracker:indexed:graph" INTEGER, "tracker:secondaryIndex" INTEGER, 1323"tracker:secondaryIndex:graph" INTEGER, "tracker:fulltextIndexed" 1324INTEGER, "tracker:fulltextIndexed:graph" INTEGER, 1325"tracker:fulltextNoLimit" INTEGER, "tracker:fulltextNoLimit:graph" 1326INTEGER, "tracker:transient" INTEGER, "tracker:transient:graph" 1327INTEGER, "tracker:weight" INTEGER, "tracker:weight:graph" INTEGER, 1328"tracker:defaultValue" TEXT COLLATE NOCASE, 1329"tracker:defaultValue:graph" INTEGER, "nrl:maxCardinality" INTEGER, 1330"nrl:maxCardinality:graph" INTEGER, "tracker:writeback" INTEGER, 1331"tracker:writeback:graph" INTEGER, "tracker:forceJournal" INTEGER, 1332"tracker:forceJournal:graph" INTEGER); 1333CREATE TABLE "rdf:Property_rdfs:subPropertyOf" (ID INTEGER NOT NULL, 1334"rdfs:subPropertyOf" INTEGER NOT NULL, "rdfs:subPropertyOf:graph" 1335INTEGER); 1336CREATE TABLE "rdfs:Class" (ID INTEGER NOT NULL PRIMARY KEY, 1337"tracker:notify" INTEGER, "tracker:notify:graph" INTEGER); 1338CREATE TABLE "rdfs:Class_rdfs:subClassOf" (ID INTEGER NOT NULL, 1339"rdfs:subClassOf" INTEGER NOT NULL, "rdfs:subClassOf:graph" INTEGER); 1340CREATE TABLE "rdfs:Class_tracker:domainIndex" (ID INTEGER NOT NULL, 1341"tracker:domainIndex" INTEGER NOT NULL, "tracker:domainIndex:graph" 1342INTEGER); 1343CREATE TABLE "rdfs:Literal" (ID INTEGER NOT NULL PRIMARY KEY); 1344CREATE TABLE "rdfs:Resource" (ID INTEGER NOT NULL PRIMARY KEY, 1345Available INTEGER NOT NULL, "rdfs:comment" TEXT COLLATE NOCASE, 1346"rdfs:comment:graph" INTEGER, "rdfs:label" TEXT COLLATE NOCASE, 1347"rdfs:label:graph" INTEGER, "tracker:added" INTEGER, 1348"tracker:added:graph" INTEGER, "tracker:added:localDate" INTEGER, 1349"tracker:added:localTime" INTEGER, "tracker:modified" INTEGER, 1350"tracker:modified:graph" INTEGER, "tracker:damaged" INTEGER, 1351"tracker:damaged:graph" INTEGER, "dc:title" TEXT COLLATE NOCASE, 1352"dc:title:graph" INTEGER, "dc:creator" TEXT COLLATE NOCASE, 1353"dc:creator:graph" INTEGER, "dc:subject" TEXT COLLATE NOCASE, 1354"dc:subject:graph" INTEGER, "dc:description" TEXT COLLATE NOCASE, 1355"dc:description:graph" INTEGER, "dc:publisher" TEXT COLLATE NOCASE, 1356"dc:publisher:graph" INTEGER, "dc:type" TEXT COLLATE NOCASE, 1357"dc:type:graph" INTEGER, "dc:format" TEXT COLLATE NOCASE, 1358"dc:format:graph" INTEGER, "dc:identifier" TEXT COLLATE NOCASE, 1359"dc:identifier:graph" INTEGER, "dc:language" TEXT COLLATE NOCASE, 1360"dc:language:graph" INTEGER, "dc:coverage" TEXT COLLATE NOCASE, 1361"dc:coverage:graph" INTEGER, "dc:rights" TEXT COLLATE NOCASE, 1362"dc:rights:graph" INTEGER, "nao:identifier" TEXT COLLATE NOCASE, 1363"nao:identifier:graph" INTEGER, "nao:numericRating" REAL, 1364"nao:numericRating:graph" INTEGER, "nao:lastModified" INTEGER, 1365"nao:lastModified:graph" INTEGER, "nao:lastModified:localDate" 1366INTEGER, "nao:lastModified:localTime" INTEGER); 1367CREATE TABLE "rdfs:Resource_dc:contributor" (ID INTEGER NOT NULL, 1368"dc:contributor" TEXT NOT NULL, "dc:contributor:graph" INTEGER); 1369CREATE TABLE "rdfs:Resource_dc:date" (ID INTEGER NOT NULL, "dc:date" 1370INTEGER NOT NULL, "dc:date:graph" INTEGER, "dc:date:localDate" INTEGER 1371NOT NULL, "dc:date:localTime" INTEGER NOT NULL); 1372CREATE TABLE "rdfs:Resource_dc:relation" (ID INTEGER NOT NULL, 1373"dc:relation" TEXT NOT NULL, "dc:relation:graph" INTEGER); 1374CREATE TABLE "rdfs:Resource_dc:source" (ID INTEGER NOT NULL, 1375"dc:source" INTEGER NOT NULL, "dc:source:graph" INTEGER); 1376CREATE TABLE "rdfs:Resource_nao:deprecated" (ID INTEGER NOT NULL, 1377"nao:deprecated" INTEGER NOT NULL, "nao:deprecated:graph" INTEGER); 1378CREATE TABLE "rdfs:Resource_nao:hasTag" (ID INTEGER NOT NULL, 1379"nao:hasTag" INTEGER NOT NULL, "nao:hasTag:graph" INTEGER); 1380CREATE TABLE "rdfs:Resource_nao:isRelated" (ID INTEGER NOT NULL, 1381"nao:isRelated" INTEGER NOT NULL, "nao:isRelated:graph" INTEGER); 1382CREATE TABLE "rdfs:Resource_rdf:type" (ID INTEGER NOT NULL, "rdf:type" 1383INTEGER NOT NULL, "rdf:type:graph" INTEGER); 1384CREATE TABLE "scal:AccessLevel" (ID INTEGER NOT NULL PRIMARY KEY); 1385CREATE TABLE "scal:AttendanceStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1386CREATE TABLE "scal:Attendee" (ID INTEGER NOT NULL PRIMARY KEY, 1387"scal:attendanceStatus" INTEGER, "scal:attendanceStatus:graph" 1388INTEGER, "scal:attendeeRole" INTEGER, "scal:attendeeRole:graph" 1389INTEGER, "scal:attendeeContact" INTEGER, "scal:attendeeContact:graph" 1390INTEGER, "scal:rsvp" INTEGER, "scal:rsvp:graph" INTEGER, 1391"scal:calendarUserType" INTEGER, "scal:calendarUserType:graph" 1392INTEGER); 1393CREATE TABLE "scal:AttendeeRole" (ID INTEGER NOT NULL PRIMARY KEY); 1394CREATE TABLE "scal:Attendee_scal:delegated-from" (ID INTEGER NOT NULL, 1395"scal:delegated-from" INTEGER NOT NULL, "scal:delegated-from:graph" 1396INTEGER); 1397CREATE TABLE "scal:Attendee_scal:delegated-to" (ID INTEGER NOT NULL, 1398"scal:delegated-to" INTEGER NOT NULL, "scal:delegated-to:graph" 1399INTEGER); 1400CREATE TABLE "scal:Attendee_scal:member" (ID INTEGER NOT NULL, 1401"scal:member" INTEGER NOT NULL, "scal:member:graph" INTEGER); 1402CREATE TABLE "scal:Attendee_scal:sent-by" (ID INTEGER NOT NULL, 1403"scal:sent-by" INTEGER NOT NULL, "scal:sent-by:graph" INTEGER); 1404CREATE TABLE "scal:Calendar" (ID INTEGER NOT NULL PRIMARY KEY); 1405CREATE TABLE "scal:CalendarAlarm" (ID INTEGER NOT NULL PRIMARY KEY, 1406"scal:alarmOffset" INTEGER, "scal:alarmOffset:graph" INTEGER); 1407CREATE TABLE "scal:CalendarAlarm_scal:alarmAttendee" (ID INTEGER NOT 1408NULL, "scal:alarmAttendee" INTEGER NOT NULL, 1409"scal:alarmAttendee:graph" INTEGER); 1410CREATE TABLE "scal:CalendarItem" (ID INTEGER NOT NULL PRIMARY KEY, 1411"scal:textLocation" INTEGER, "scal:textLocation:graph" INTEGER, 1412"scal:resources" TEXT COLLATE NOCASE, "scal:resources:graph" INTEGER, 1413"scal:transparency" INTEGER, "scal:transparency:graph" INTEGER, 1414"scal:calendarItemAlarm" INTEGER, "scal:calendarItemAlarm:graph" 1415INTEGER, "scal:start" INTEGER, "scal:start:graph" INTEGER, "scal:end" 1416INTEGER, "scal:end:graph" INTEGER, "scal:isAllDay" INTEGER, 1417"scal:isAllDay:graph" INTEGER, "scal:priority" INTEGER, 1418"scal:priority:graph" INTEGER, "scal:rdate" INTEGER, 1419"scal:rdate:graph" INTEGER, "scal:exceptionRDate" INTEGER, 1420"scal:exceptionRDate:graph" INTEGER); 1421CREATE TABLE "scal:CalendarItem_scal:access" (ID INTEGER NOT NULL, 1422"scal:access" INTEGER NOT NULL, "scal:access:graph" INTEGER); 1423CREATE TABLE "scal:CalendarItem_scal:attachment" (ID INTEGER NOT NULL, 1424"scal:attachment" INTEGER NOT NULL, "scal:attachment:graph" INTEGER); 1425CREATE TABLE "scal:CalendarItem_scal:attendee" (ID INTEGER NOT NULL, 1426"scal:attendee" INTEGER NOT NULL, "scal:attendee:graph" INTEGER); 1427CREATE TABLE "scal:CalendarItem_scal:belongsToCalendar" (ID INTEGER 1428NOT NULL, "scal:belongsToCalendar" INTEGER NOT NULL, 1429"scal:belongsToCalendar:graph" INTEGER); 1430CREATE TABLE "scal:CalendarItem_scal:contact" (ID INTEGER NOT NULL, 1431"scal:contact" INTEGER NOT NULL, "scal:contact:graph" INTEGER); 1432CREATE TABLE "scal:CalendarItem_scal:rrule" (ID INTEGER NOT NULL, 1433"scal:rrule" INTEGER NOT NULL, "scal:rrule:graph" INTEGER); 1434CREATE TABLE "scal:CalendarUserType" (ID INTEGER NOT NULL PRIMARY KEY); 1435CREATE TABLE "scal:Event" (ID INTEGER NOT NULL PRIMARY KEY, 1436"scal:eventStatus" INTEGER, "scal:eventStatus:graph" INTEGER); 1437CREATE TABLE "scal:EventStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1438CREATE TABLE "scal:Journal" (ID INTEGER NOT NULL PRIMARY KEY, 1439"scal:journalStatus" INTEGER, "scal:journalStatus:graph" INTEGER); 1440CREATE TABLE "scal:JournalStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1441CREATE TABLE "scal:RSVPValues" (ID INTEGER NOT NULL PRIMARY KEY); 1442CREATE TABLE "scal:RecurrenceRule" (ID INTEGER NOT NULL PRIMARY KEY, 1443"scal:recurrencePattern" TEXT COLLATE NOCASE, 1444"scal:recurrencePattern:graph" INTEGER, "scal:recurrenceStartDate" 1445INTEGER, "scal:recurrenceStartDate:graph" INTEGER, "scal:exception" 1446INTEGER, "scal:exception:graph" INTEGER); 1447CREATE TABLE "scal:TimePoint" (ID INTEGER NOT NULL PRIMARY KEY, 1448"scal:dateTime" INTEGER, "scal:dateTime:graph" INTEGER, 1449"scal:dateTime:localDate" INTEGER, "scal:dateTime:localTime" INTEGER, 1450"scal:TimeZone" TEXT COLLATE NOCASE, "scal:TimeZone:graph" INTEGER); 1451CREATE TABLE "scal:Todo" (ID INTEGER NOT NULL PRIMARY KEY, 1452"scal:todoStatus" INTEGER, "scal:todoStatus:graph" INTEGER, "scal:due" 1453INTEGER, "scal:due:graph" INTEGER, "scal:completed" INTEGER, 1454"scal:completed:graph" INTEGER, "scal:percentComplete" INTEGER, 1455"scal:percentComplete:graph" INTEGER); 1456CREATE TABLE "scal:TodoStatus" (ID INTEGER NOT NULL PRIMARY KEY); 1457CREATE TABLE "scal:TransparencyValues" (ID INTEGER NOT NULL PRIMARY KEY); 1458CREATE TABLE "slo:GeoLocation" (ID INTEGER NOT NULL PRIMARY KEY, 1459"slo:latitude" REAL, "slo:latitude:graph" INTEGER, "slo:longitude" 1460REAL, "slo:longitude:graph" INTEGER, "slo:verticalAccuracy" REAL, 1461"slo:verticalAccuracy:graph" INTEGER, "slo:horizontalAccuracy" REAL, 1462"slo:horizontalAccuracy:graph" INTEGER, "slo:altitude" REAL, 1463"slo:altitude:graph" INTEGER, "slo:boundingLatitudeMin" REAL, 1464"slo:boundingLatitudeMin:graph" INTEGER, "slo:boundingLatitudeMax" 1465REAL, "slo:boundingLatitudeMax:graph" INTEGER, 1466"slo:boundingLongitudeMin" REAL, "slo:boundingLongitudeMin:graph" 1467INTEGER, "slo:boundingLongitudeMax" REAL, 1468"slo:boundingLongitudeMax:graph" INTEGER, "slo:radius" REAL, 1469"slo:radius:graph" INTEGER, "slo:timestamp" INTEGER, 1470"slo:timestamp:graph" INTEGER, "slo:timestamp:localDate" INTEGER, 1471"slo:timestamp:localTime" INTEGER, "slo:postalAddress" INTEGER, 1472"slo:postalAddress:graph" INTEGER); 1473CREATE TABLE "slo:Landmark" (ID INTEGER NOT NULL PRIMARY KEY, 1474"slo:iconUrl" INTEGER, "slo:iconUrl:graph" INTEGER); 1475CREATE TABLE "slo:LandmarkCategory" (ID INTEGER NOT NULL PRIMARY KEY, 1476"slo:isRemovable" INTEGER, "slo:isRemovable:graph" INTEGER, 1477"slo:categoryIconUrl" INTEGER, "slo:categoryIconUrl:graph" INTEGER); 1478CREATE TABLE "slo:Landmark_slo:belongsToCategory" (ID INTEGER NOT 1479NULL, "slo:belongsToCategory" INTEGER NOT NULL, 1480"slo:belongsToCategory:graph" INTEGER); 1481CREATE TABLE "slo:Landmark_slo:hasContact" (ID INTEGER NOT NULL, 1482"slo:hasContact" INTEGER NOT NULL, "slo:hasContact:graph" INTEGER); 1483CREATE TABLE "slo:Route" (ID INTEGER NOT NULL PRIMARY KEY, 1484"slo:startTime" INTEGER, "slo:startTime:graph" INTEGER, 1485"slo:startTime:localDate" INTEGER, "slo:startTime:localTime" INTEGER, 1486"slo:endTime" INTEGER, "slo:endTime:graph" INTEGER, 1487"slo:endTime:localDate" INTEGER, "slo:endTime:localTime" INTEGER); 1488CREATE TABLE "slo:Route_slo:routeDetails" (ID INTEGER NOT NULL, 1489"slo:routeDetails" TEXT NOT NULL, "slo:routeDetails:graph" INTEGER); 1490CREATE TABLE "tracker:Namespace" (ID INTEGER NOT NULL PRIMARY KEY, 1491"tracker:prefix" TEXT COLLATE NOCASE, "tracker:prefix:graph" 1492INTEGER); 1493CREATE TABLE "tracker:Ontology" (ID INTEGER NOT NULL PRIMARY KEY); 1494CREATE TABLE "tracker:Volume" (ID INTEGER NOT NULL PRIMARY KEY, 1495"tracker:isMounted" INTEGER, "tracker:isMounted:graph" INTEGER, 1496"tracker:unmountDate" INTEGER, "tracker:unmountDate:graph" INTEGER, 1497"tracker:unmountDate:localDate" INTEGER, 1498"tracker:unmountDate:localTime" INTEGER, "tracker:mountPoint" INTEGER, 1499"tracker:mountPoint:graph" INTEGER, "tracker:isRemovable" INTEGER, 1500"tracker:isRemovable:graph" INTEGER, "tracker:isOptical" INTEGER, 1501"tracker:isOptical:graph" INTEGER); 1502CREATE UNIQUE INDEX "mfo:FeedMessage_mfo:enclosureList_ID_ID" ON 1503"mfo:FeedMessage_mfo:enclosureList" (ID, "mfo:enclosureList"); 1504CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbNorthWest_ID_ID" ON 1505"mlo:GeoBoundingBox_mlo:bbNorthWest" (ID, "mlo:bbNorthWest"); 1506CREATE UNIQUE INDEX "mlo:GeoBoundingBox_mlo:bbSouthEast_ID_ID" ON 1507"mlo:GeoBoundingBox_mlo:bbSouthEast" (ID, "mlo:bbSouthEast"); 1508CREATE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID" ON 1509"mlo:GeoLocation_mlo:asBoundingBox" (ID); 1510CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asBoundingBox_ID_ID" ON 1511"mlo:GeoLocation_mlo:asBoundingBox" ("mlo:asBoundingBox", ID); 1512CREATE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID" ON 1513"mlo:GeoLocation_mlo:asGeoPoint" (ID); 1514CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asGeoPoint_ID_ID" ON 1515"mlo:GeoLocation_mlo:asGeoPoint" ("mlo:asGeoPoint", ID); 1516CREATE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID" ON 1517"mlo:GeoLocation_mlo:asPostalAddress" (ID); 1518CREATE UNIQUE INDEX "mlo:GeoLocation_mlo:asPostalAddress_ID_ID" ON 1519"mlo:GeoLocation_mlo:asPostalAddress" ("mlo:asPostalAddress", ID); 1520CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:address_ID_ID" ON 1521"mlo:GeoPoint_mlo:address" (ID, "mlo:address"); 1522CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:altitude_ID_ID" ON 1523"mlo:GeoPoint_mlo:altitude" (ID, "mlo:altitude"); 1524CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:city_ID_ID" ON 1525"mlo:GeoPoint_mlo:city" (ID, "mlo:city"); 1526CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:country_ID_ID" ON 1527"mlo:GeoPoint_mlo:country" (ID, "mlo:country"); 1528CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:latitude_ID_ID" ON 1529"mlo:GeoPoint_mlo:latitude" (ID, "mlo:latitude"); 1530CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:longitude_ID_ID" ON 1531"mlo:GeoPoint_mlo:longitude" (ID, "mlo:longitude"); 1532CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:state_ID_ID" ON 1533"mlo:GeoPoint_mlo:state" (ID, "mlo:state"); 1534CREATE UNIQUE INDEX "mlo:GeoPoint_mlo:timestamp_ID_ID" ON 1535"mlo:GeoPoint_mlo:timestamp" (ID, "mlo:timestamp"); 1536CREATE UNIQUE INDEX "mlo:GeoSphere_mlo:radius_ID_ID" ON 1537"mlo:GeoSphere_mlo:radius" (ID, "mlo:radius"); 1538CREATE UNIQUE INDEX "mlo:LandmarkCategory_mlo:isRemovable_ID_ID" ON 1539"mlo:LandmarkCategory_mlo:isRemovable" (ID, "mlo:isRemovable"); 1540CREATE UNIQUE INDEX "mlo:Landmark_mlo:belongsToCategory_ID_ID" ON 1541"mlo:Landmark_mlo:belongsToCategory" (ID, "mlo:belongsToCategory"); 1542CREATE UNIQUE INDEX "mlo:Landmark_mlo:poiLocation_ID_ID" ON 1543"mlo:Landmark_mlo:poiLocation" (ID, "mlo:poiLocation"); 1544CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxEastLimit_ID_ID" 1545ON "mlo:LocationBoundingBox_mlo:boxEastLimit" (ID, 1546"mlo:boxEastLimit"); 1547CREATE UNIQUE INDEX "mlo:LocationBoundingBox_mlo:boxNorthLimit_ID_ID" 1548ON "mlo:LocationBoundingBox_mlo:boxNorthLimit" (ID, 1549"mlo:boxNorthLimit"); 1550CREATE UNIQUE INDEX 1551"mlo:LocationBoundingBox_mlo:boxSouthWestCorner_ID_ID" ON 1552"mlo:LocationBoundingBox_mlo:boxSouthWestCorner" (ID, 1553"mlo:boxSouthWestCorner"); 1554CREATE UNIQUE INDEX 1555"mlo:LocationBoundingBox_mlo:boxVerticalLimit_ID_ID" ON 1556"mlo:LocationBoundingBox_mlo:boxVerticalLimit" (ID, 1557"mlo:boxVerticalLimit"); 1558CREATE UNIQUE INDEX "mlo:Route_mlo:endTime_ID_ID" ON 1559"mlo:Route_mlo:endTime" (ID, "mlo:endTime"); 1560CREATE UNIQUE INDEX "mlo:Route_mlo:routeDetails_ID_ID" ON 1561"mlo:Route_mlo:routeDetails" (ID, "mlo:routeDetails"); 1562CREATE UNIQUE INDEX "mlo:Route_mlo:startTime_ID_ID" ON 1563"mlo:Route_mlo:startTime" (ID, "mlo:startTime"); 1564CREATE UNIQUE INDEX "mto:Transfer_mto:transferList_ID_ID" ON 1565"mto:Transfer_mto:transferList" (ID, "mto:transferList"); 1566CREATE UNIQUE INDEX "mto:Transfer_mto:transferPrivacyLevel_ID_ID" ON 1567"mto:Transfer_mto:transferPrivacyLevel" (ID, 1568"mto:transferPrivacyLevel"); 1569CREATE UNIQUE INDEX "mto:UploadTransfer_mto:transferCategory_ID_ID" ON 1570"mto:UploadTransfer_mto:transferCategory" (ID, 1571"mto:transferCategory"); 1572CREATE UNIQUE INDEX "nao:Tag_tracker:isDefaultTag_ID_ID" ON 1573"nao:Tag_tracker:isDefaultTag" (ID, "tracker:isDefaultTag"); 1574CREATE UNIQUE INDEX "nao:Tag_tracker:tagRelatedTo_ID_ID" ON 1575"nao:Tag_tracker:tagRelatedTo" (ID, "tracker:tagRelatedTo"); 1576CREATE UNIQUE INDEX "ncal:Alarm_ncal:action_ID_ID" ON 1577"ncal:Alarm_ncal:action" (ID, "ncal:action"); 1578CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayModifier_ID_ID" ON 1579"ncal:BydayRulePart_ncal:bydayModifier" (ID, "ncal:bydayModifier"); 1580CREATE UNIQUE INDEX "ncal:BydayRulePart_ncal:bydayWeekday_ID_ID" ON 1581"ncal:BydayRulePart_ncal:bydayWeekday" (ID, "ncal:bydayWeekday"); 1582CREATE UNIQUE INDEX "ncal:Calendar_ncal:component_ID_ID" ON 1583"ncal:Calendar_ncal:component" (ID, "ncal:component"); 1584CREATE UNIQUE INDEX "ncal:Freebusy_ncal:freebusy_ID_ID" ON 1585"ncal:Freebusy_ncal:freebusy" (ID, "ncal:freebusy"); 1586CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byday_ID_ID" ON 1587"ncal:RecurrenceRule_ncal:byday" (ID, "ncal:byday"); 1588CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byhour_ID_ID" ON 1589"ncal:RecurrenceRule_ncal:byhour" (ID, "ncal:byhour"); 1590CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byminute_ID_ID" ON 1591"ncal:RecurrenceRule_ncal:byminute" (ID, "ncal:byminute"); 1592CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonth_ID_ID" ON 1593"ncal:RecurrenceRule_ncal:bymonth" (ID, "ncal:bymonth"); 1594CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bymonthday_ID_ID" ON 1595"ncal:RecurrenceRule_ncal:bymonthday" (ID, "ncal:bymonthday"); 1596CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysecond_ID_ID" ON 1597"ncal:RecurrenceRule_ncal:bysecond" (ID, "ncal:bysecond"); 1598CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:bysetpos_ID_ID" ON 1599"ncal:RecurrenceRule_ncal:bysetpos" (ID, "ncal:bysetpos"); 1600CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byweekno_ID_ID" ON 1601"ncal:RecurrenceRule_ncal:byweekno" (ID, "ncal:byweekno"); 1602CREATE UNIQUE INDEX "ncal:RecurrenceRule_ncal:byyearday_ID_ID" ON 1603"ncal:RecurrenceRule_ncal:byyearday" (ID, "ncal:byyearday"); 1604CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attach_ID_ID" ON 1605"ncal:UnionParentClass_ncal:attach" (ID, "ncal:attach"); 1606CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:attendee_ID_ID" ON 1607"ncal:UnionParentClass_ncal:attendee" (ID, "ncal:attendee"); 1608CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:categories_ID_ID" ON 1609"ncal:UnionParentClass_ncal:categories" (ID, "ncal:categories"); 1610CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exdate_ID_ID" ON 1611"ncal:UnionParentClass_ncal:exdate" (ID, "ncal:exdate"); 1612CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:exrule_ID_ID" ON 1613"ncal:UnionParentClass_ncal:exrule" (ID, "ncal:exrule"); 1614CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:hasAlarm_ID_ID" ON 1615"ncal:UnionParentClass_ncal:hasAlarm" (ID, "ncal:hasAlarm"); 1616CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:ncalRelation_ID_ID" ON 1617"ncal:UnionParentClass_ncal:ncalRelation" (ID, "ncal:ncalRelation"); 1618CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rdate_ID_ID" ON 1619"ncal:UnionParentClass_ncal:rdate" (ID, "ncal:rdate"); 1620CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToChild_ID_ID" 1621ON "ncal:UnionParentClass_ncal:relatedToChild" (ID, 1622"ncal:relatedToChild"); 1623CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:relatedToParent_ID_ID" 1624ON "ncal:UnionParentClass_ncal:relatedToParent" (ID, 1625"ncal:relatedToParent"); 1626CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:resources_ID_ID" ON 1627"ncal:UnionParentClass_ncal:resources" (ID, "ncal:resources"); 1628CREATE UNIQUE INDEX "ncal:UnionParentClass_ncal:rrule_ID_ID" ON 1629"ncal:UnionParentClass_ncal:rrule" (ID, "ncal:rrule"); 1630CREATE UNIQUE INDEX "nco:Affiliation_nco:title_ID_ID" ON 1631"nco:Affiliation_nco:title" (ID, "nco:title"); 1632CREATE UNIQUE INDEX "nco:ContactList_nco:containsContact_ID_ID" ON 1633"nco:ContactList_nco:containsContact" (ID, "nco:containsContact"); 1634CREATE UNIQUE INDEX "nco:Contact_ncal:anniversary_ID_ID" ON 1635"nco:Contact_ncal:anniversary" (ID, "ncal:anniversary"); 1636CREATE UNIQUE INDEX "nco:Contact_ncal:birthday_ID_ID" ON 1637"nco:Contact_ncal:birthday" (ID, "ncal:birthday"); 1638CREATE UNIQUE INDEX "nco:Contact_nco:belongsToGroup_ID_ID" ON 1639"nco:Contact_nco:belongsToGroup" (ID, "nco:belongsToGroup"); 1640CREATE UNIQUE INDEX "nco:Contact_nco:note_ID_ID" ON 1641"nco:Contact_nco:note" (ID, "nco:note"); 1642CREATE UNIQUE INDEX "nco:Contact_scal:anniversary_ID_ID" ON 1643"nco:Contact_scal:anniversary" (ID, "scal:anniversary"); 1644CREATE UNIQUE INDEX "nco:Contact_scal:birthday_ID_ID" ON 1645"nco:Contact_scal:birthday" (ID, "scal:birthday"); 1646CREATE UNIQUE INDEX "nco:IMAccount_nco:hasIMContact_ID_ID" ON 1647"nco:IMAccount_nco:hasIMContact" (ID, "nco:hasIMContact"); 1648CREATE UNIQUE INDEX "nco:IMAddress_nco:imCapability_ID_ID" ON 1649"nco:IMAddress_nco:imCapability" (ID, "nco:imCapability"); 1650CREATE UNIQUE INDEX "nco:PersonContact_nco:hasAffiliation_ID_ID" ON 1651"nco:PersonContact_nco:hasAffiliation" (ID, "nco:hasAffiliation"); 1652CREATE INDEX "nco:PersonContact_nco:nameFamily" ON "nco:PersonContact" 1653("nco:nameFamily"); 1654CREATE INDEX "nco:PhoneNumber_nco:phoneNumber" ON "nco:PhoneNumber" 1655("nco:phoneNumber"); 1656CREATE UNIQUE INDEX "nco:Role_nco:blogUrl_ID_ID" ON 1657"nco:Role_nco:blogUrl" (ID, "nco:blogUrl"); 1658CREATE UNIQUE INDEX "nco:Role_nco:foafUrl_ID_ID" ON 1659"nco:Role_nco:foafUrl" (ID, "nco:foafUrl"); 1660CREATE UNIQUE INDEX "nco:Role_nco:hasContactMedium_ID_ID" ON 1661"nco:Role_nco:hasContactMedium" (ID, "nco:hasContactMedium"); 1662CREATE INDEX "nco:Role_nco:hasEmailAddress_ID" ON 1663"nco:Role_nco:hasEmailAddress" (ID); 1664CREATE UNIQUE INDEX "nco:Role_nco:hasEmailAddress_ID_ID" ON 1665"nco:Role_nco:hasEmailAddress" ("nco:hasEmailAddress", ID); 1666CREATE UNIQUE INDEX "nco:Role_nco:hasIMAddress_ID_ID" ON 1667"nco:Role_nco:hasIMAddress" (ID, "nco:hasIMAddress"); 1668CREATE UNIQUE INDEX "nco:Role_nco:hasPhoneNumber_ID_ID" ON 1669"nco:Role_nco:hasPhoneNumber" (ID, "nco:hasPhoneNumber"); 1670CREATE INDEX "nco:Role_nco:hasPostalAddress_ID" ON 1671"nco:Role_nco:hasPostalAddress" (ID); 1672CREATE UNIQUE INDEX "nco:Role_nco:hasPostalAddress_ID_ID" ON 1673"nco:Role_nco:hasPostalAddress" ("nco:hasPostalAddress", ID); 1674CREATE UNIQUE INDEX "nco:Role_nco:url_ID_ID" ON "nco:Role_nco:url" 1675(ID, "nco:url"); 1676CREATE UNIQUE INDEX "nco:Role_nco:websiteUrl_ID_ID" ON 1677"nco:Role_nco:websiteUrl" (ID, "nco:websiteUrl"); 1678CREATE UNIQUE INDEX 1679"nfo:BookmarkFolder_nfo:containsBookmarkFolder_ID_ID" ON 1680"nfo:BookmarkFolder_nfo:containsBookmarkFolder" (ID, 1681"nfo:containsBookmarkFolder"); 1682CREATE UNIQUE INDEX "nfo:BookmarkFolder_nfo:containsBookmark_ID_ID" ON 1683"nfo:BookmarkFolder_nfo:containsBookmark" (ID, 1684"nfo:containsBookmark"); 1685CREATE INDEX "nfo:FileDataObject_nfo:fileLastModified" ON 1686"nfo:FileDataObject" ("nfo:fileLastModified"); 1687CREATE UNIQUE INDEX "nfo:Image_nfo:depicts_ID_ID" ON 1688"nfo:Image_nfo:depicts" (ID, "nfo:depicts"); 1689CREATE UNIQUE INDEX "nfo:Image_nfo:hasRegionOfInterest_ID_ID" ON 1690"nfo:Image_nfo:hasRegionOfInterest" (ID, "nfo:hasRegionOfInterest"); 1691CREATE UNIQUE INDEX "nfo:MediaList_nfo:hasMediaFileListEntry_ID_ID" ON 1692"nfo:MediaList_nfo:hasMediaFileListEntry" (ID, 1693"nfo:hasMediaFileListEntry"); 1694CREATE UNIQUE INDEX "nfo:MediaList_nfo:mediaListEntry_ID_ID" ON 1695"nfo:MediaList_nfo:mediaListEntry" (ID, "nfo:mediaListEntry"); 1696CREATE UNIQUE INDEX "nfo:Media_mtp:hidden_ID_ID" ON 1697"nfo:Media_mtp:hidden" (ID, "mtp:hidden"); 1698CREATE UNIQUE INDEX "nfo:Media_nmm:alternativeMedia_ID_ID" ON 1699"nfo:Media_nmm:alternativeMedia" (ID, "nmm:alternativeMedia"); 1700CREATE INDEX "nfo:Visual_nie:contentCreated" ON "nfo:Visual" 1701("nie:contentCreated"); 1702CREATE UNIQUE INDEX "nid3:ID3Audio_nid3:leadArtist_ID_ID" ON 1703"nid3:ID3Audio_nid3:leadArtist" (ID, "nid3:leadArtist"); 1704CREATE UNIQUE INDEX "nie:DataObject_nie:dataSource_ID_ID" ON 1705"nie:DataObject_nie:dataSource" (ID, "nie:dataSource"); 1706CREATE UNIQUE INDEX "nie:DataObject_nie:isPartOf_ID_ID" ON 1707"nie:DataObject_nie:isPartOf" (ID, "nie:isPartOf"); 1708CREATE INDEX "nie:DataObject_nie:url" ON "nie:DataObject" ("nie:url"); 1709CREATE INDEX "nie:InformationElement_mlo:location_ID" ON 1710"nie:InformationElement_mlo:location" (ID); 1711CREATE UNIQUE INDEX "nie:InformationElement_mlo:location_ID_ID" ON 1712"nie:InformationElement_mlo:location" ("mlo:location", ID); 1713CREATE UNIQUE INDEX "nie:InformationElement_nao:hasProperty_ID_ID" ON 1714"nie:InformationElement_nao:hasProperty" (ID, "nao:hasProperty"); 1715CREATE UNIQUE INDEX "nie:InformationElement_nco:contributor_ID_ID" ON 1716"nie:InformationElement_nco:contributor" (ID, "nco:contributor"); 1717CREATE UNIQUE INDEX "nie:InformationElement_nco:creator_ID_ID" ON 1718"nie:InformationElement_nco:creator" (ID, "nco:creator"); 1719CREATE UNIQUE INDEX "nie:InformationElement_nie:hasLogicalPart_ID_ID" 1720ON "nie:InformationElement_nie:hasLogicalPart" (ID, 1721"nie:hasLogicalPart"); 1722CREATE UNIQUE INDEX "nie:InformationElement_nie:hasPart_ID_ID" ON 1723"nie:InformationElement_nie:hasPart" (ID, "nie:hasPart"); 1724CREATE UNIQUE INDEX 1725"nie:InformationElement_nie:informationElementDate_ID_ID" ON 1726"nie:InformationElement_nie:informationElementDate" (ID, 1727"nie:informationElementDate"); 1728CREATE UNIQUE INDEX "nie:InformationElement_nie:isLogicalPartOf_ID_ID" 1729ON "nie:InformationElement_nie:isLogicalPartOf" (ID, 1730"nie:isLogicalPartOf"); 1731CREATE UNIQUE INDEX "nie:InformationElement_nie:keyword_ID_ID" ON 1732"nie:InformationElement_nie:keyword" (ID, "nie:keyword"); 1733CREATE UNIQUE INDEX "nie:InformationElement_nie:relatedTo_ID_ID" ON 1734"nie:InformationElement_nie:relatedTo" (ID, "nie:relatedTo"); 1735CREATE INDEX "nie:InformationElement_slo:location" ON 1736"nie:InformationElement" ("slo:location"); 1737CREATE INDEX "nmm:Artist_nmm:artistName" ON "nmm:Artist" ("nmm:artistName"); 1738CREATE INDEX "nmm:MusicAlbum_nie:title" ON "nmm:MusicAlbum" ("nie:title"); 1739CREATE UNIQUE INDEX "nmm:MusicAlbum_nmm:albumArtist_ID_ID" ON 1740"nmm:MusicAlbum_nmm:albumArtist" (ID, "nmm:albumArtist"); 1741CREATE INDEX "nmm:MusicPiece_nie:title" ON "nmm:MusicPiece" ("nie:title"); 1742CREATE UNIQUE INDEX "nmm:MusicPiece_nmm:lyrics_ID_ID" ON 1743"nmm:MusicPiece_nmm:lyrics" (ID, "nmm:lyrics"); 1744CREATE INDEX "nmm:MusicPiece_nmm:musicAlbum" ON "nmm:MusicPiece" 1745("nmm:musicAlbum"); 1746CREATE INDEX "nmm:MusicPiece_nmm:performer" ON "nmm:MusicPiece" 1747("nmm:performer"); 1748CREATE UNIQUE INDEX "nmm:RadioStation_nmm:carrier_ID_ID" ON 1749"nmm:RadioStation_nmm:carrier" (ID, "nmm:carrier"); 1750CREATE UNIQUE INDEX "nmm:Video_mtp:scantype_ID_ID" ON 1751"nmm:Video_mtp:scantype" (ID, "mtp:scantype"); 1752CREATE UNIQUE INDEX "nmm:Video_nmm:director_ID_ID" ON 1753"nmm:Video_nmm:director" (ID, "nmm:director"); 1754CREATE UNIQUE INDEX "nmm:Video_nmm:leadActor_ID_ID" ON 1755"nmm:Video_nmm:leadActor" (ID, "nmm:leadActor"); 1756CREATE UNIQUE INDEX "nmm:Video_nmm:subtitle_ID_ID" ON 1757"nmm:Video_nmm:subtitle" (ID, "nmm:subtitle"); 1758CREATE INDEX "nmo:Call_nmo:sentDate" ON "nmo:Call" ("nmo:sentDate"); 1759CREATE INDEX "nmo:CommunicationChannel_nmo:hasParticipant_ID" ON 1760"nmo:CommunicationChannel_nmo:hasParticipant" (ID); 1761CREATE UNIQUE INDEX 1762"nmo:CommunicationChannel_nmo:hasParticipant_ID_ID" ON 1763"nmo:CommunicationChannel_nmo:hasParticipant" ("nmo:hasParticipant", 1764ID); 1765CREATE INDEX "nmo:CommunicationChannel_nmo:lastMessageDate" ON 1766"nmo:CommunicationChannel" ("nmo:lastMessageDate"); 1767CREATE UNIQUE INDEX "nmo:Email_nmo:contentMimeType_ID_ID" ON 1768"nmo:Email_nmo:contentMimeType" (ID, "nmo:contentMimeType"); 1769CREATE UNIQUE INDEX "nmo:Message_nmo:bcc_ID_ID" ON 1770"nmo:Message_nmo:bcc" (ID, "nmo:bcc"); 1771CREATE UNIQUE INDEX "nmo:Message_nmo:cc_ID_ID" ON "nmo:Message_nmo:cc" 1772(ID, "nmo:cc"); 1773CREATE INDEX "nmo:Message_nmo:communicationChannel" ON "nmo:Message" 1774("nmo:communicationChannel", "nmo:receivedDate"); 1775CREATE INDEX "nmo:Message_nmo:conversation" ON "nmo:Message" 1776("nmo:conversation"); 1777CREATE INDEX "nmo:Message_nmo:from" ON "nmo:Message" ("nmo:from"); 1778CREATE UNIQUE INDEX "nmo:Message_nmo:hasAttachment_ID_ID" ON 1779"nmo:Message_nmo:hasAttachment" (ID, "nmo:hasAttachment"); 1780CREATE UNIQUE INDEX "nmo:Message_nmo:inReplyTo_ID_ID" ON 1781"nmo:Message_nmo:inReplyTo" (ID, "nmo:inReplyTo"); 1782CREATE UNIQUE INDEX "nmo:Message_nmo:messageHeader_ID_ID" ON 1783"nmo:Message_nmo:messageHeader" (ID, "nmo:messageHeader"); 1784CREATE UNIQUE INDEX "nmo:Message_nmo:recipient_ID_ID" ON 1785"nmo:Message_nmo:recipient" (ID, "nmo:recipient"); 1786CREATE UNIQUE INDEX "nmo:Message_nmo:references_ID_ID" ON 1787"nmo:Message_nmo:references" (ID, "nmo:references"); 1788CREATE INDEX "nmo:Message_nmo:sender" ON "nmo:Message" ("nmo:sender"); 1789CREATE INDEX "nmo:Message_nmo:sentDate" ON "nmo:Message" ("nmo:sentDate"); 1790CREATE INDEX "nmo:Message_nmo:to_ID" ON "nmo:Message_nmo:to" (ID); 1791CREATE UNIQUE INDEX "nmo:Message_nmo:to_ID_ID" ON "nmo:Message_nmo:to" 1792("nmo:to", ID); 1793CREATE UNIQUE INDEX "nmo:MimePart_nmo:mimeHeader_ID_ID" ON 1794"nmo:MimePart_nmo:mimeHeader" (ID, "nmo:mimeHeader"); 1795CREATE UNIQUE INDEX "nmo:Multipart_nmo:partBoundary_ID_ID" ON 1796"nmo:Multipart_nmo:partBoundary" (ID, "nmo:partBoundary"); 1797CREATE UNIQUE INDEX 1798"nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder_ID_ID" ON 1799"nmo:PhoneMessageFolder_nmo:containsPhoneMessageFolder" (ID, 1800"nmo:containsPhoneMessageFolder"); 1801CREATE UNIQUE INDEX 1802"nmo:PhoneMessageFolder_nmo:containsPhoneMessage_ID_ID" ON 1803"nmo:PhoneMessageFolder_nmo:containsPhoneMessage" (ID, 1804"nmo:containsPhoneMessage"); 1805CREATE UNIQUE INDEX "nmo:PhoneMessage_nmo:toVCard_ID_ID" ON 1806"nmo:PhoneMessage_nmo:toVCard" (ID, "nmo:toVCard"); 1807CREATE UNIQUE INDEX "rdf:Property_rdfs:subPropertyOf_ID_ID" ON 1808"rdf:Property_rdfs:subPropertyOf" (ID, "rdfs:subPropertyOf"); 1809CREATE UNIQUE INDEX "rdfs:Class_rdfs:subClassOf_ID_ID" ON 1810"rdfs:Class_rdfs:subClassOf" (ID, "rdfs:subClassOf"); 1811CREATE UNIQUE INDEX "rdfs:Class_tracker:domainIndex_ID_ID" ON 1812"rdfs:Class_tracker:domainIndex" (ID, "tracker:domainIndex"); 1813CREATE UNIQUE INDEX "rdfs:Resource_dc:contributor_ID_ID" ON 1814"rdfs:Resource_dc:contributor" (ID, "dc:contributor"); 1815CREATE UNIQUE INDEX "rdfs:Resource_dc:date_ID_ID" ON 1816"rdfs:Resource_dc:date" (ID, "dc:date"); 1817CREATE UNIQUE INDEX "rdfs:Resource_dc:relation_ID_ID" ON 1818"rdfs:Resource_dc:relation" (ID, "dc:relation"); 1819CREATE UNIQUE INDEX "rdfs:Resource_dc:source_ID_ID" ON 1820"rdfs:Resource_dc:source" (ID, "dc:source"); 1821CREATE UNIQUE INDEX "rdfs:Resource_nao:deprecated_ID_ID" ON 1822"rdfs:Resource_nao:deprecated" (ID, "nao:deprecated"); 1823CREATE INDEX "rdfs:Resource_nao:hasTag_ID" ON "rdfs:Resource_nao:hasTag" (ID); 1824CREATE UNIQUE INDEX "rdfs:Resource_nao:hasTag_ID_ID" ON 1825"rdfs:Resource_nao:hasTag" ("nao:hasTag", ID); 1826CREATE UNIQUE INDEX "rdfs:Resource_nao:isRelated_ID_ID" ON 1827"rdfs:Resource_nao:isRelated" (ID, "nao:isRelated"); 1828CREATE UNIQUE INDEX "rdfs:Resource_rdf:type_ID_ID" ON 1829"rdfs:Resource_rdf:type" (ID, "rdf:type"); 1830CREATE INDEX "rdfs:Resource_tracker:added" ON "rdfs:Resource" ("tracker:added"); 1831CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-from_ID_ID" ON 1832"scal:Attendee_scal:delegated-from" (ID, "scal:delegated-from"); 1833CREATE UNIQUE INDEX "scal:Attendee_scal:delegated-to_ID_ID" ON 1834"scal:Attendee_scal:delegated-to" (ID, "scal:delegated-to"); 1835CREATE UNIQUE INDEX "scal:Attendee_scal:member_ID_ID" ON 1836"scal:Attendee_scal:member" (ID, "scal:member"); 1837CREATE UNIQUE INDEX "scal:Attendee_scal:sent-by_ID_ID" ON 1838"scal:Attendee_scal:sent-by" (ID, "scal:sent-by"); 1839CREATE UNIQUE INDEX "scal:CalendarAlarm_scal:alarmAttendee_ID_ID" ON 1840"scal:CalendarAlarm_scal:alarmAttendee" (ID, "scal:alarmAttendee"); 1841CREATE UNIQUE INDEX "scal:CalendarItem_scal:access_ID_ID" ON 1842"scal:CalendarItem_scal:access" (ID, "scal:access"); 1843CREATE UNIQUE INDEX "scal:CalendarItem_scal:attachment_ID_ID" ON 1844"scal:CalendarItem_scal:attachment" (ID, "scal:attachment"); 1845CREATE UNIQUE INDEX "scal:CalendarItem_scal:attendee_ID_ID" ON 1846"scal:CalendarItem_scal:attendee" (ID, "scal:attendee"); 1847CREATE UNIQUE INDEX "scal:CalendarItem_scal:belongsToCalendar_ID_ID" 1848ON "scal:CalendarItem_scal:belongsToCalendar" (ID, 1849"scal:belongsToCalendar"); 1850CREATE UNIQUE INDEX "scal:CalendarItem_scal:contact_ID_ID" ON 1851"scal:CalendarItem_scal:contact" (ID, "scal:contact"); 1852CREATE UNIQUE INDEX "scal:CalendarItem_scal:rrule_ID_ID" ON 1853"scal:CalendarItem_scal:rrule" (ID, "scal:rrule"); 1854CREATE INDEX "slo:GeoLocation_slo:postalAddress" ON "slo:GeoLocation" 1855("slo:postalAddress"); 1856CREATE UNIQUE INDEX "slo:Landmark_slo:belongsToCategory_ID_ID" ON 1857"slo:Landmark_slo:belongsToCategory" (ID, "slo:belongsToCategory"); 1858CREATE UNIQUE INDEX "slo:Landmark_slo:hasContact_ID_ID" ON 1859"slo:Landmark_slo:hasContact" (ID, "slo:hasContact"); 1860CREATE UNIQUE INDEX "slo:Route_slo:routeDetails_ID_ID" ON 1861"slo:Route_slo:routeDetails" (ID, "slo:routeDetails"); 1862 1863EXPLAIN SELECT "1_u", (SELECT "nco:fullname" FROM "nco:Contact" WHERE 1864ID = "1_u") COLLATE NOCASE, (SELECT "nco:nameFamily" FROM 1865"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1866"nco:nameGiven" FROM "nco:PersonContact" WHERE ID = "1_u") 1867COLLATE NOCASE, (SELECT "nco:nameAdditional" FROM 1868"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1869"nco:nameHonorificPrefix" FROM "nco:PersonContact" WHERE ID = 1870"1_u") COLLATE NOCASE, (SELECT "nco:nameHonorificSuffix" FROM 1871"nco:PersonContact" WHERE ID = "1_u") COLLATE NOCASE, (SELECT 1872"nco:nickname" FROM "nco:Contact" WHERE ID = "1_u") COLLATE 1873NOCASE, strftime("%s",(SELECT "nco:birthDate" FROM 1874"nco:Contact" WHERE ID = "1_u")), (SELECT "nie:url" FROM 1875"nie:DataObject" WHERE ID = (SELECT "nco:photo" FROM 1876"nco:Contact" WHERE ID = "1_u")) COLLATE NOCASE, (SELECT 1877GROUP_CONCAT("2_u"||? COLLATE NOCASE||COALESCE((SELECT 1878"nco:imProtocol" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1879NOCASE, ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1880"nco:imID" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1881NOCASE, ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1882"nco:imNickname" FROM "nco:IMAddress" WHERE ID = "3_u") COLLATE 1883NOCASE, ? COLLATE NOCASE), '\n') FROM (SELECT 1884"nco:PersonContact_nco:hasAffiliation2"."nco:hasAffiliation" AS 1885"2_u", "nco:Role_nco:hasIMAddress3"."nco:hasIMAddress" AS 1886"3_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1887"nco:PersonContact_nco:hasAffiliation2", 1888"nco:Role_nco:hasIMAddress" AS "nco:Role_nco:hasIMAddress3" WHERE 1889"1_u" = "nco:PersonContact_nco:hasAffiliation2"."ID" AND 1890"nco:PersonContact_nco:hasAffiliation2"."nco:hasAffiliation" = 1891"nco:Role_nco:hasIMAddress3"."ID")), (SELECT 1892GROUP_CONCAT("2_u"||? COLLATE NOCASE||(SELECT "nco:phoneNumber" 1893FROM "nco:PhoneNumber" WHERE ID = "4_u") COLLATE NOCASE, '\n') 1894FROM (SELECT "nco:PersonContact_nco:hasAffiliation4"."nco:hasAffiliation" 1895AS "2_u", "nco:Role_nco:hasPhoneNumber5"."nco:hasPhoneNumber" AS 1896"4_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1897"nco:PersonContact_nco:hasAffiliation4", 1898"nco:Role_nco:hasPhoneNumber" AS "nco:Role_nco:hasPhoneNumber5" 1899WHERE "1_u" = "nco:PersonContact_nco:hasAffiliation4"."ID" AND 1900"nco:PersonContact_nco:hasAffiliation4"."nco:hasAffiliation" = 1901"nco:Role_nco:hasPhoneNumber5"."ID")), (SELECT 1902GROUP_CONCAT("2_u"||? COLLATE NOCASE||(SELECT "nco:emailAddress" 1903FROM "nco:EmailAddress" WHERE ID = "5_u") COLLATE NOCASE, ',') 1904FROM (SELECT "nco:PersonContact_nco:hasAffiliation6"."nco:hasAffiliation" 1905AS "2_u", "nco:Role_nco:hasEmailAddress7"."nco:hasEmailAddress" 1906AS "5_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1907"nco:PersonContact_nco:hasAffiliation6", 1908"nco:Role_nco:hasEmailAddress" AS "nco:Role_nco:hasEmailAddress7" 1909WHERE "1_u" = "nco:PersonContact_nco:hasAffiliation6"."ID" AND 1910"nco:PersonContact_nco:hasAffiliation6"."nco:hasAffiliation" = 1911"nco:Role_nco:hasEmailAddress7"."ID")), (SELECT 1912GROUP_CONCAT("2_u"||? COLLATE NOCASE||COALESCE((SELECT 1913GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = 1914"nco:blogUrl"),',') FROM "nco:Role_nco:blogUrl" WHERE ID = 1915"2_u"), ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1916GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = 1917"nco:websiteUrl"),',') FROM "nco:Role_nco:websiteUrl" WHERE ID = 1918"2_u"), ? COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT 1919GROUP_CONCAT((SELECT Uri FROM Resource WHERE ID = "nco:url"),',') 1920FROM "nco:Role_nco:url" WHERE ID = "2_u"), ? COLLATE NOCASE), 1921'\n') FROM (SELECT 1922"nco:PersonContact_nco:hasAffiliation8"."nco:hasAffiliation" AS 1923"2_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1924"nco:PersonContact_nco:hasAffiliation8" WHERE "1_u" = 1925"nco:PersonContact_nco:hasAffiliation8"."ID")), (SELECT 1926GROUP_CONCAT("6_u", ',') FROM (SELECT 1927"rdfs:Resource_nao:hasTag9"."nao:hasTag" AS "6_u" FROM 1928"rdfs:Resource_nao:hasTag" AS "rdfs:Resource_nao:hasTag9" WHERE 1929"1_u" = "rdfs:Resource_nao:hasTag9"."ID")), (SELECT Uri FROM 1930Resource WHERE ID = "1_u"), (SELECT GROUP_CONCAT("2_u"||? COLLATE 1931NOCASE||COALESCE((SELECT "nco:role" FROM "nco:Affiliation" WHERE 1932ID = "2_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1933NOCASE||COALESCE((SELECT "nco:department" FROM "nco:Affiliation" 1934WHERE ID = "2_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1935NOCASE||COALESCE((SELECT GROUP_CONCAT("nco:title",',') FROM 1936"nco:Affiliation_nco:title" WHERE ID = "2_u"), ? COLLATE NOCASE), 1937'\n') FROM (SELECT 1938"nco:PersonContact_nco:hasAffiliation10"."nco:hasAffiliation" AS 1939"2_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1940"nco:PersonContact_nco:hasAffiliation10" WHERE "1_u" = 1941"nco:PersonContact_nco:hasAffiliation10"."ID")), (SELECT 1942GROUP_CONCAT("nco:note",',') FROM "nco:Contact_nco:note" WHERE ID 1943= "1_u"), (SELECT "nco:gender" FROM "nco:PersonContact" WHERE ID 1944= "1_u"), (SELECT GROUP_CONCAT("2_u"||? COLLATE 1945NOCASE||COALESCE((SELECT "nco:pobox" FROM "nco:PostalAddress" 1946WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1947NOCASE||COALESCE((SELECT "nco:district" FROM "nco:PostalAddress" 1948WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1949NOCASE||COALESCE((SELECT "nco:county" FROM "nco:PostalAddress" 1950WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1951NOCASE||COALESCE((SELECT "nco:locality" FROM "nco:PostalAddress" 1952WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE NOCASE)||? COLLATE 1953NOCASE||COALESCE((SELECT "nco:postalcode" FROM 1954"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1955NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:streetAddress" 1956FROM "nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? 1957COLLATE NOCASE)||? COLLATE NOCASE||COALESCE((SELECT Uri FROM 1958Resource WHERE ID = (SELECT "nco:addressLocation" FROM 1959"nco:PostalAddress" WHERE ID = "7_u")), ? COLLATE NOCASE)||? 1960COLLATE NOCASE||COALESCE((SELECT "nco:extendedAddress" FROM 1961"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1962NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:country" FROM 1963"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1964NOCASE)||? COLLATE NOCASE||COALESCE((SELECT "nco:region" FROM 1965"nco:PostalAddress" WHERE ID = "7_u") COLLATE NOCASE, ? COLLATE 1966NOCASE), '\n') FROM (SELECT 1967"nco:PersonContact_nco:hasAffiliation11"."nco:hasAffiliation" AS 1968"2_u", "nco:Role_nco:hasPostalAddress12"."nco:hasPostalAddress" 1969AS "7_u" FROM "nco:PersonContact_nco:hasAffiliation" AS 1970"nco:PersonContact_nco:hasAffiliation11", 1971"nco:Role_nco:hasPostalAddress" AS 1972"nco:Role_nco:hasPostalAddress12" WHERE "1_u" = 1973"nco:PersonContact_nco:hasAffiliation11"."ID" AND 1974"nco:PersonContact_nco:hasAffiliation11"."nco:hasAffiliation" = 1975"nco:Role_nco:hasPostalAddress12"."ID")), (SELECT 1976GROUP_CONCAT("10_u" COLLATE NOCASE, ',') FROM (SELECT 1977"nie:InformationElement_nao:hasProperty13"."nao:hasProperty" AS 1978"8_u", "nao:Property14"."nao:propertyName" AS "9_u", 1979"nao:Property14"."nao:propertyValue" AS "10_u" FROM 1980"nie:InformationElement_nao:hasProperty" AS 1981"nie:InformationElement_nao:hasProperty13", "nao:Property" AS 1982"nao:Property14" WHERE "1_u" = 1983"nie:InformationElement_nao:hasProperty13"."ID" AND 1984"nie:InformationElement_nao:hasProperty13"."nao:hasProperty" = 1985"nao:Property14"."ID" AND "9_u" IS NOT NULL AND "10_u" IS NOT 1986NULL AND ("9_u" COLLATE NOCASE = ? COLLATE NOCASE))) FROM (SELECT 1987"nco:PersonContact1"."ID" AS "1_u" FROM "nco:PersonContact" AS 1988"nco:PersonContact1") ORDER BY "1_u"; 1989 } 1990} {/.* Goto .*/} 1991 1992 1993finish_test 1994