================= Fri, 17 Jun 2016 13:35:27 +0000 ================= SET time_zone = 'UTC' SET sql_mode = 'NO_BACKSLASH_ESCAPES,STRICT_ALL_TABLES,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' SET max_sp_recursion_depth = 255 CALL session_start(empty2null('')) START TRANSACTION SELECT TABLE_NAME ,INFORMATION_SCHEMA.TABLES.`ENGINE` ,INFORMATION_SCHEMA.TABLES.`ROW_FORMAT` ,INFORMATION_SCHEMA.TABLES.`TABLE_COMMENT` FROM INFORMATION_SCHEMA.`TABLES` WHERE INFORMATION_SCHEMA.TABLES.`TABLE_SCHEMA` = DATABASE() AND TABLE_TYPE!='VIEW' ORDER BY TABLE_NAME SELECT TABLE_NAME ,COLUMN_NAME , DATA_TYPE , IS_NULLABLE , COLUMN_DEFAULT ,INFORMATION_SCHEMA.COLUMNS.`CHARACTER_MAXIMUM_LENGTH` ,INFORMATION_SCHEMA.COLUMNS.`COLUMN_COMMENT` ,INFORMATION_SCHEMA.COLUMNS.`EXTRA` ,INFORMATION_SCHEMA.COLUMNS.`CHARACTER_MAXIMUM_LENGTH` ,INFORMATION_SCHEMA.COLUMNS.`NUMERIC_PRECISION` ,INFORMATION_SCHEMA.COLUMNS.`COLUMN_TYPE` ,INFORMATION_SCHEMA.COLUMNS.`COLUMN_DEFAULT` /* ,INFORMATION_SCHEMA.COLUMNS.`ORDINAL_POSITION` */ FROM INFORMATION_SCHEMA.COLUMNS JOIN INFORMATION_SCHEMA.`TABLES` USING(`TABLE_SCHEMA`, TABLE_NAME) WHERE INFORMATION_SCHEMA.COLUMNS.`TABLE_SCHEMA` = DATABASE() AND INFORMATION_SCHEMA.`TABLES`.TABLE_TYPE!='VIEW' ORDER BY TABLE_NAME,INFORMATION_SCHEMA.COLUMNS.`ORDINAL_POSITION` SELECT INFORMATION_SCHEMA.`STATISTICS`.`INDEX_NAME` ,INFORMATION_SCHEMA.`STATISTICS`.`TABLE_NAME` ,INFORMATION_SCHEMA.`STATISTICS`.`COLUMN_NAME` ,INFORMATION_SCHEMA.`STATISTICS`.`INDEX_TYPE` ,INFORMATION_SCHEMA.`STATISTICS`.`NON_UNIQUE` ,INFORMATION_SCHEMA.`STATISTICS`.`NULLABLE` FROM INFORMATION_SCHEMA.`STATISTICS` WHERE INFORMATION_SCHEMA.STATISTICS.`TABLE_SCHEMA` = DATABASE() SELECT INFORMATION_SCHEMA.KEY_COLUMN_USAGE.`CONSTRAINT_NAME` ,INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS`.`DELETE_RULE` ,INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS`.`UPDATE_RULE` ,INFORMATION_SCHEMA.`TABLE_CONSTRAINTS`.`CONSTRAINT_TYPE` ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE.`TABLE_NAME` ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE.`COLUMN_NAME` ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE.`REFERENCED_TABLE_NAME` ,INFORMATION_SCHEMA.KEY_COLUMN_USAGE.`REFERENCED_COLUMN_NAME` FROM INFORMATION_SCHEMA.`TABLE_CONSTRAINTS` JOIN INFORMATION_SCHEMA.`REFERENTIAL_CONSTRAINTS` USING(CONSTRAINT_NAME,CONSTRAINT_SCHEMA) JOIN INFORMATION_SCHEMA.`KEY_COLUMN_USAGE` USING(CONSTRAINT_NAME,CONSTRAINT_SCHEMA) WHERE INFORMATION_SCHEMA.`TABLE_CONSTRAINTS`.`CONSTRAINT_SCHEMA` = DATABASE() SELECT INFORMATION_SCHEMA.`TRIGGERS`.`TRIGGER_NAME` ,INFORMATION_SCHEMA.`TRIGGERS`.`EVENT_OBJECT_TABLE` ,CONCAT('DROP TRIGGER IF EXISTS `',INFORMATION_SCHEMA.`TRIGGERS`.`TRIGGER_NAME`,'`; CREATE TRIGGER `',INFORMATION_SCHEMA.`TRIGGERS`.`TRIGGER_NAME`,'` ',INFORMATION_SCHEMA.`TRIGGERS`.ACTION_TIMING,' ',INFORMATION_SCHEMA.`TRIGGERS`.EVENT_MANIPULATION,' ON `',INFORMATION_SCHEMA.`TRIGGERS`.`EVENT_OBJECT_TABLE`,'` FOR EACH ',INFORMATION_SCHEMA.`TRIGGERS`.ACTION_ORIENTATION,' ',INFORMATION_SCHEMA.`TRIGGERS`.ACTION_STATEMENT,' ;') sql_body FROM INFORMATION_SCHEMA.`TRIGGERS` WHERE INFORMATION_SCHEMA.`TRIGGERS`.`TRIGGER_SCHEMA`= DATABASE() SELECT `name` SPECIFIC_NAME ,`definer` , CONCAT('DROP PROCEDURE IF EXISTS `',`name`,'`;') drop_body , CONCAT('DROP PROCEDURE IF EXISTS `',`name`,'`; CREATE PROCEDURE `',`name`,'` (',`param_list`,') ',`body`,';') sql_body FROM `mysql`.`proc` WHERE db = DATABASE() AND `type`='PROCEDURE' SELECT `name` SPECIFIC_NAME ,`definer` , CONCAT('DROP FUNCTION IF EXISTS `',`name`,'`;') drop_body , CONCAT('DROP FUNCTION IF EXISTS `',`name`,'`; CREATE FUNCTION `',`name`,'` (',`param_list`,') RETURNS ',`returns` ,IF(is_deterministic='YES',' DETERMINISTIC ',' ') ,REPLACE(sql_data_access, '_', ' '),' ',`body`,';') sql_body FROM `mysql`.`proc` WHERE db = DATABASE() AND `type`='FUNCTION' SELECT `information_schema`.`VIEWS`.`TABLE_NAME` , CONCAT('DROP VIEW ',`information_schema`.`VIEWS`.`TABLE_NAME`,';') drop_body , CONCAT('CREATE OR REPLACE VIEW ' ,`information_schema`.`VIEWS`.`TABLE_NAME` ,' AS ' ,REPLACE(`information_schema`.`VIEWS`.`VIEW_DEFINITION`,CONCAT('`',DATABASE(),'`.'),'') ,';') sql_body FROM `information_schema`.`VIEWS` WHERE `information_schema`.`VIEWS`.`TABLE_SCHEMA`= DATABASE() DROP TRIGGER IF EXISTS `#departments_insert` DROP TRIGGER IF EXISTS `#departments_update` DROP TRIGGER IF EXISTS `#departments_delete` DROP TRIGGER IF EXISTS `appl_profile_account_ins` DROP TRIGGER IF EXISTS `appl_profile_contact_ins` DROP TRIGGER IF EXISTS `appl_profiles_delete` DROP TRIGGER IF EXISTS `bpl_acc_turn_update` DROP TRIGGER IF EXISTS `client_priv_update` DROP TRIGGER IF EXISTS `ui_menu_insert` DROP TRIGGER IF EXISTS `ui_menu_delete` DROP TRIGGER IF EXISTS `ui_menu_update` ALTER TABLE `#department_addr` DROP FOREIGN KEY `#department_addr_ibfk_1`, DROP FOREIGN KEY `#department_addr_ibfk_2` ALTER TABLE `#department_contact` DROP FOREIGN KEY `#department_contact_ibfk_1`, DROP FOREIGN KEY `#department_contact_ibfk_5` ALTER TABLE `#department_tree_p` DROP FOREIGN KEY `#department_tree_p_ibfk_1`, DROP FOREIGN KEY `#department_tree_p_ibfk_2` ALTER TABLE `#departments` DROP FOREIGN KEY `#departments_ibfk_1`, DROP FOREIGN KEY `#departments_ibfk_2`, DROP FOREIGN KEY `#departments_ibfk_3` ALTER TABLE `#departments_pos` DROP FOREIGN KEY `#departments_pos_ibfk_1`, DROP FOREIGN KEY `#departments_pos_ibfk_2` ALTER TABLE `#ext_sys_departs` DROP FOREIGN KEY `#ext_sys_departs_ibfk_2`, DROP FOREIGN KEY `@0023ext_sys_departs_ibfk_1` ALTER TABLE `#group_items` DROP FOREIGN KEY `#group_items_ibfk_1` ALTER TABLE `#module_role` DROP FOREIGN KEY `FK_#module_role_modules`, DROP FOREIGN KEY `FK_#module_role_roles` ALTER TABLE `#tasks` DROP FOREIGN KEY `#tasks_ibfk_1` ALTER TABLE `#user_acls` DROP FOREIGN KEY `#user_acls_ibfk_1`, DROP FOREIGN KEY `FK_acl_role` ALTER TABLE `#user_profiles` DROP FOREIGN KEY `#user_profiles_ibfk_1`, DROP FOREIGN KEY `id_job`, DROP FOREIGN KEY `user` ALTER TABLE `#users` DROP FOREIGN KEY `#users_ibfk_1` ALTER TABLE `appl_appraiser` DROP FOREIGN KEY `appl_appraiser_ibfk_4`, DROP FOREIGN KEY `appl_appraiser_ibfk_5` ALTER TABLE `appl_cond_opt` DROP FOREIGN KEY `appl_cond_opt_ibfk_1` ALTER TABLE `appl_contract_account` DROP FOREIGN KEY `appl_contract_account_ibfk_2`, DROP FOREIGN KEY `appl_contract_account_ibfk_3`, DROP FOREIGN KEY `appl_contract_account_ibfk_4`, DROP FOREIGN KEY `appl_contract_account_ibfk_5`, DROP FOREIGN KEY `appl_contract_account_ibfk_6` ALTER TABLE `appl_loan_limit_data` DROP FOREIGN KEY `appl_loan_limit_data_ibfk_2`, DROP FOREIGN KEY `appl_loan_limit_data_ibfk_3` ALTER TABLE `appl_loan_tariff` DROP FOREIGN KEY `appl_loan_tariff_ibfk_1`, DROP FOREIGN KEY `appl_loan_tariff_ibfk_2` ALTER TABLE `appl_loan_tariff_opt` DROP FOREIGN KEY `appl_loan_tariff_opt_ibfk_1`, DROP FOREIGN KEY `appl_loan_tariff_opt_ibfk_2` ALTER TABLE `appl_product_departs` DROP FOREIGN KEY `appl_product_departs_ibfk_2`, DROP FOREIGN KEY `appl_product_departs_ibfk_3` ALTER TABLE `appl_products` DROP FOREIGN KEY `appl_products_ibfk_2`, DROP FOREIGN KEY `appl_products_ibfk_3`, DROP FOREIGN KEY `appl_products_ibfk_4`, DROP FOREIGN KEY `appl_products_ibfk_5`, DROP FOREIGN KEY `appl_products_ibfk_6` ALTER TABLE `appl_products_opers` DROP FOREIGN KEY `appl_products_opers_ibfk_1`, DROP FOREIGN KEY `appl_products_opers_ibfk_2` ALTER TABLE `appl_profile_account` DROP FOREIGN KEY `appl_profile_account_ibfk_1`, DROP FOREIGN KEY `appl_profile_account_ibfk_2` ALTER TABLE `appl_profile_addr` DROP FOREIGN KEY `appl_profile_addr_ibfk_2`, DROP FOREIGN KEY `appl_profile_addr_ibfk_3` ALTER TABLE `appl_profile_contact` DROP FOREIGN KEY `appl_profile_contact_ibfk_3`, DROP FOREIGN KEY `appl_profile_contact_ibfk_4` ALTER TABLE `appl_profile_doc` DROP FOREIGN KEY `appl_profile_doc_ibfk_1`, DROP FOREIGN KEY `appl_profile_doc_ibfk_2` ALTER TABLE `appl_profile_types` DROP FOREIGN KEY `appl_profile_types_ibfk_1` ALTER TABLE `appl_profile_types_groups` DROP FOREIGN KEY `appl_profile_types_groups_ibfk_1`, DROP FOREIGN KEY `appl_profile_types_groups_ibfk_2` ALTER TABLE `appl_profiles` DROP FOREIGN KEY `appl_profiles_ibfk_1`, DROP FOREIGN KEY `appl_profiles_ibfk_10`, DROP FOREIGN KEY `appl_profiles_ibfk_11`, DROP FOREIGN KEY `appl_profiles_ibfk_12`, DROP FOREIGN KEY `appl_profiles_ibfk_14`, DROP FOREIGN KEY `appl_profiles_ibfk_15`, DROP FOREIGN KEY `appl_profiles_ibfk_2`, DROP FOREIGN KEY `appl_profiles_ibfk_3`, DROP FOREIGN KEY `appl_profiles_ibfk_7`, DROP FOREIGN KEY `depart` ALTER TABLE `appl_profiles_groups` DROP FOREIGN KEY `appl_profiles_groups_ibfk_1`, DROP FOREIGN KEY `appl_profiles_groups_ibfk_2` ALTER TABLE `appl_profiles_notations` DROP FOREIGN KEY `appl_profiles_notations_ibfk_2`, DROP FOREIGN KEY `appl_profiles_notations_ibfk_3`, DROP FOREIGN KEY `appl_profiles_notations_ibfk_4`, DROP FOREIGN KEY `appl_profiles_notations_ibfk_5` ALTER TABLE `appl_template_group_doc` DROP FOREIGN KEY `appl_template_group_doc_ibfk_2`, DROP FOREIGN KEY `appl_template_group_doc_ibfk_6`, DROP FOREIGN KEY `appl_template_group_doc_ibfk_7`, DROP FOREIGN KEY `appl_template_group_doc_ibfk_8` ALTER TABLE `appl_template_groups` DROP FOREIGN KEY `appl_template_groups_ibfk_1`, DROP FOREIGN KEY `appl_template_groups_ibfk_2` ALTER TABLE `appl_template_ndfl` DROP FOREIGN KEY `appl_template_ndfl_ibfk_1`, DROP FOREIGN KEY `appl_template_ndfl_ibfk_2` ALTER TABLE `appl_templates` DROP FOREIGN KEY `appl_templates_ibfk_1` ALTER TABLE `bki_loans` DROP FOREIGN KEY `bki_loans_ibfk_1` ALTER TABLE `bonus_conditions` DROP FOREIGN KEY `bonus_conditions_ibfk_1`, DROP FOREIGN KEY `bonus_conditions_ibfk_2` ALTER TABLE `bpl_accounts` DROP FOREIGN KEY `bpl_accounts_ibfk_1`, DROP FOREIGN KEY `bpl_accounts_ibfk_2` ALTER TABLE `bpl_accounts_turns` DROP FOREIGN KEY `bpl_accounts_turns_ibfk_2` ALTER TABLE `bpl_car_model` DROP FOREIGN KEY `bpl_car_model_ibfk_1` ALTER TABLE `bpl_car_modify` DROP FOREIGN KEY `bpl_car_modify_ibfk_1` ALTER TABLE `bpl_car_year` DROP FOREIGN KEY `bpl_car_year_ibfk_1` ALTER TABLE `bpl_cards` DROP FOREIGN KEY `bpl_cards_ibfk_2`, DROP FOREIGN KEY `bpl_cards_ibfk_3` ALTER TABLE `bpl_cards_accounts` DROP FOREIGN KEY `bpl_cards_accounts_ibfk_1`, DROP FOREIGN KEY `bpl_cards_accounts_ibfk_2`, DROP FOREIGN KEY `bpl_cards_accounts_ibfk_3` ALTER TABLE `bpl_contract_accounts` DROP FOREIGN KEY `bpl_contract_accounts_ibfk_1` ALTER TABLE `bpl_contracts` DROP FOREIGN KEY `bpl_contracts_ibfk_2`, DROP FOREIGN KEY `bpl_contracts_ibfk_3` ALTER TABLE `bpl_departments_stores` DROP FOREIGN KEY `bpl_departments_stores_ibfk_1`, DROP FOREIGN KEY `bpl_departments_stores_ibfk_2`, DROP FOREIGN KEY `bpl_departments_stores_ibfk_3` ALTER TABLE `bpl_product_cnts` DROP FOREIGN KEY `bpl_product_cnts_ibfk_5`, DROP FOREIGN KEY `bpl_product_cnts_ibfk_6` ALTER TABLE `bpl_product_loyality` DROP FOREIGN KEY `bpl_product_loyality_ibfk_1`, DROP FOREIGN KEY `bpl_product_loyality_ibfk_2`, DROP FOREIGN KEY `bpl_product_loyality_ibfk_3` ALTER TABLE `bpl_product_prices` DROP FOREIGN KEY `bpl_product_prices_ibfk_3`, DROP FOREIGN KEY `bpl_product_prices_ibfk_4` ALTER TABLE `bpl_product_types` DROP FOREIGN KEY `bpl_product_types_ibfk_1`, DROP FOREIGN KEY `bpl_product_types_ibfk_2` ALTER TABLE `bpl_products_groups` DROP FOREIGN KEY `bpl_products_groups_ibfk_1`, DROP FOREIGN KEY `bpl_products_groups_ibfk_2` ALTER TABLE `bpl_store_addr` DROP FOREIGN KEY `bpl_store_addr_ibfk_1` ALTER TABLE `bpl_store_contact` DROP FOREIGN KEY `bpl_store_contact_ibfk_1` ALTER TABLE `bpl_stores_turns` DROP FOREIGN KEY `bpl_stores_turns_ibfk_4`, DROP FOREIGN KEY `bpl_stores_turns_ibfk_6` ALTER TABLE `contract_turns` DROP FOREIGN KEY `contract_turns_ibfk_2`, DROP FOREIGN KEY `contract_turns_ibfk_4`, DROP FOREIGN KEY `contract_turns_ibfk_5`, DROP FOREIGN KEY `contract_turns_ibfk_6` ALTER TABLE `crm_client` DROP FOREIGN KEY `crm_client_ibfk_2`, DROP FOREIGN KEY `crm_client_ibfk_3`, DROP FOREIGN KEY `crm_client_ibfk_4`, DROP FOREIGN KEY `crm_client_ibfk_5` ALTER TABLE `crm_client_account` DROP FOREIGN KEY `crm_client_account_ibfk_1`, DROP FOREIGN KEY `crm_client_account_ibfk_2` ALTER TABLE `crm_client_addr` DROP FOREIGN KEY `crm_client_addr_ibfk_1`, DROP FOREIGN KEY `crm_client_addr_ibfk_2` ALTER TABLE `crm_client_contact` DROP FOREIGN KEY `crm_client_contact_ibfk_4`, DROP FOREIGN KEY `crm_client_contact_ibfk_5` ALTER TABLE `crm_client_directory` DROP FOREIGN KEY `crm_client_directory_ibfk_2`, DROP FOREIGN KEY `crm_client_directory_ibfk_3`, DROP FOREIGN KEY `crm_client_directory_ibfk_4`, DROP FOREIGN KEY `crm_client_directory_ibfk_5` ALTER TABLE `crm_client_doc` DROP FOREIGN KEY `crm_client_doc_ibfk_1`, DROP FOREIGN KEY `crm_client_doc_ibfk_2` ALTER TABLE `crm_client_insur` DROP FOREIGN KEY `crm_client_insur_ibfk_1` ALTER TABLE `crm_client_legal` DROP FOREIGN KEY `crm_client_legal_ibfk_1`, DROP FOREIGN KEY `crm_client_legal_ibfk_3`, DROP FOREIGN KEY `crm_client_legal_ibfk_5`, DROP FOREIGN KEY `crm_client_legal_ibfk_6`, DROP FOREIGN KEY `crm_client_legal_ibfk_7` ALTER TABLE `crm_client_license` DROP FOREIGN KEY `crm_client_license_ibfk_1`, DROP FOREIGN KEY `crm_client_license_ibfk_3`, DROP FOREIGN KEY `crm_client_license_ibfk_4` ALTER TABLE `crm_client_merchant` DROP FOREIGN KEY `crm_client_merchant_ibfk_1`, DROP FOREIGN KEY `crm_client_merchant_ibfk_2` ALTER TABLE `crm_client_notes` DROP FOREIGN KEY `crm_client_notes_ibfk_1`, DROP FOREIGN KEY `crm_client_notes_ibfk_2`, DROP FOREIGN KEY `crm_client_notes_ibfk_3` ALTER TABLE `crm_client_private` DROP FOREIGN KEY `crm_client_private_ibfk_1`, DROP FOREIGN KEY `crm_client_private_ibfk_2`, DROP FOREIGN KEY `crm_client_private_ibfk_3`, DROP FOREIGN KEY `crm_client_private_ibfk_5`, DROP FOREIGN KEY `crm_client_private_ibfk_6` ALTER TABLE `crm_client_segment` DROP FOREIGN KEY `crm_client_segment_ibfk_1`, DROP FOREIGN KEY `crm_client_segment_ibfk_2` ALTER TABLE `crm_client_type_docs` DROP FOREIGN KEY `crm_client_type_docs_ibfk_2`, DROP FOREIGN KEY `crm_client_type_docs_ibfk_3` ALTER TABLE `crm_client_work` DROP FOREIGN KEY `crm_client_work_ibfk_1` ALTER TABLE `crm_conclusion_storage` DROP FOREIGN KEY `crm_conclusion_storage_ibfk_1`, DROP FOREIGN KEY `crm_conclusion_storage_ibfk_2`, DROP FOREIGN KEY `crm_conclusion_storage_ibfk_3`, DROP FOREIGN KEY `crm_conclusion_storage_ibfk_4` ALTER TABLE `crm_enterprise_type` DROP FOREIGN KEY `crm_enterprise_type_ibfk_1` ALTER TABLE `crm_ndfl_code` DROP FOREIGN KEY `crm_ndfl_code_ibfk_1` ALTER TABLE `crm_okved` DROP FOREIGN KEY `crm_okved_ibfk_1` ALTER TABLE `crm_tax_type` DROP FOREIGN KEY `crm_tax_type_ibfk_1` ALTER TABLE `files` DROP FOREIGN KEY `files_ibfk_2` ALTER TABLE `files_appl_profiles` DROP FOREIGN KEY `files_appl_profiles_ibfk_1`, DROP FOREIGN KEY `files_appl_profiles_ibfk_2` ALTER TABLE `files_client_doc` DROP FOREIGN KEY `files_client_doc_ibfk_1`, DROP FOREIGN KEY `files_client_doc_ibfk_2` ALTER TABLE `files_documents` DROP FOREIGN KEY `files_documents_ibfk_1` ALTER TABLE `files_profile_doc` DROP FOREIGN KEY `files_profile_doc_ibfk_1`, DROP FOREIGN KEY `files_profile_doc_ibfk_2` ALTER TABLE `mailer_blanks` DROP FOREIGN KEY `mailer_blanks_ibfk_1`, DROP FOREIGN KEY `mailer_blanks_ibfk_2` ALTER TABLE `old_appl_product_opt` DROP FOREIGN KEY `old_appl_product_opt_ibfk_4` ALTER TABLE `old_dictionary_block_types` DROP FOREIGN KEY `old_dictionary_block_types_ibfk_1`, DROP FOREIGN KEY `old_dictionary_block_types_ibfk_2` ALTER TABLE `portal_articles` DROP FOREIGN KEY `portal_articles_ibfk_1` ALTER TABLE `portal_sections` DROP FOREIGN KEY `portal_sections_ibfk_1` ALTER TABLE `spr_answer` DROP FOREIGN KEY `FK_spr_answer` ALTER TABLE `spr_question` DROP FOREIGN KEY `FK_spr_question` ALTER TABLE `spr_testing` DROP FOREIGN KEY `FK_spr_testing`, DROP FOREIGN KEY `FK_spr_testing_group` ALTER TABLE `tabel_employees` DROP FOREIGN KEY `tabel_employees_ibfk_2` ALTER TABLE `transactions` DROP FOREIGN KEY `transactions_ibfk_1`, DROP FOREIGN KEY `transactions_ibfk_2`, DROP FOREIGN KEY `transactions_ibfk_3` ALTER TABLE `ui_menu` DROP FOREIGN KEY `menu_component`, DROP FOREIGN KEY `ui_menu_ibfk_1` ALTER TABLE `ui_menu_tree_p` DROP FOREIGN KEY `ui_menu_tree_p_ibfk_1`, DROP FOREIGN KEY `ui_menu_tree_p_ibfk_2` ALTER TABLE `workflow_jumps` DROP FOREIGN KEY `FK_workflow_jumps_workflow_schemes`, DROP FOREIGN KEY `FK_workflow_jumps_workflow_tasks` ALTER TABLE `workflow_mailing` DROP FOREIGN KEY `FK_workflow_mailing_workflow_stages`, DROP FOREIGN KEY `workflow_mailing_ibfk_1` ALTER TABLE `workflow_processes_questions` DROP FOREIGN KEY `workflow_processes_questions_ibfk_1`, DROP FOREIGN KEY `workflow_processes_questions_ibfk_2` ALTER TABLE `workflow_results` DROP FOREIGN KEY `FK_workflow_results_documents`, DROP FOREIGN KEY `FK_workflow_results_scheme`, DROP FOREIGN KEY `FK_workflow_results_workflow_tasks`, DROP FOREIGN KEY `workflow_results_ibfk_1`, DROP FOREIGN KEY `workflow_results_ibfk_2`, DROP FOREIGN KEY `workflow_results_ibfk_3` ALTER TABLE `workflow_results_last` DROP FOREIGN KEY `workflow_results_last_ibfk_1`, DROP FOREIGN KEY `workflow_results_last_ibfk_2`, DROP FOREIGN KEY `workflow_results_last_ibfk_3` ALTER TABLE `workflow_roles` DROP FOREIGN KEY `FK_workflow_roles_stages`, DROP FOREIGN KEY `workflow_roles_ibfk_1` ALTER TABLE `workflow_schemes` DROP FOREIGN KEY `FK_workflow_schemes_processes`, DROP FOREIGN KEY `FK_workflow_schemes_roles`, DROP FOREIGN KEY `FK_workflow_schemes_stages`, DROP FOREIGN KEY `workflow_schemes_ibfk_1` ALTER TABLE `workflow_stages_sms` DROP FOREIGN KEY `workflow_stages_sms_ibfk_1` ALTER TABLE `workflow_stages_tmpl_arm` DROP FOREIGN KEY `workflow_stages_tmpl_arm_ibfk_1`, DROP FOREIGN KEY `workflow_stages_tmpl_arm_ibfk_2` ALTER TABLE `workflow_tasks` DROP FOREIGN KEY `FK_workflow_tasks_workflow_schemes` DELETE FROM `#translit`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/#translit.csv' INTO TABLE `#translit` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_products`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_products.csv' INTO TABLE `appl_products` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_types.csv' INTO TABLE `appl_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `#components`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/#components.csv' INTO TABLE `#components` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bonus_condition_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bonus_condition_types.csv' INTO TABLE `bonus_condition_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `reports`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/reports.csv' INTO TABLE `reports` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_profile_groups`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_profile_groups.csv' INTO TABLE `appl_profile_groups` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_profile_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_profile_types.csv' INTO TABLE `appl_profile_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_profile_types_groups`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_profile_types_groups.csv' INTO TABLE `appl_profile_types_groups` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_template_group_doc`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_template_group_doc.csv' INTO TABLE `appl_template_group_doc` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_template_groups`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_template_groups.csv' INTO TABLE `appl_template_groups` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_templates`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_templates.csv' INTO TABLE `appl_templates` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_car_brand`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_car_brand.csv' INTO TABLE `bpl_car_brand` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_car_modify`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_car_modify.csv' INTO TABLE `bpl_car_modify` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_car_year`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_car_year.csv' INTO TABLE `bpl_car_year` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_card_status`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_card_status.csv' INTO TABLE `bpl_card_status` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_card_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_card_types.csv' INTO TABLE `bpl_card_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_delivery`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_delivery.csv' INTO TABLE `bpl_delivery` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_doc_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_doc_type.csv' INTO TABLE `bpl_doc_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_payment_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_payment_type.csv' INTO TABLE `bpl_payment_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_tire_brand`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_tire_brand.csv' INTO TABLE `bpl_tire_brand` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_tire_dictionary`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_tire_dictionary.csv' INTO TABLE `bpl_tire_dictionary` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_tire_repair`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_tire_repair.csv' INTO TABLE `bpl_tire_repair` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_web_dictionary`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_web_dictionary.csv' INTO TABLE `bpl_web_dictionary` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_web_repair`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_web_repair.csv' INTO TABLE `bpl_web_repair` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_address_property`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_address_property.csv' INTO TABLE `crm_address_property` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_address_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_address_type.csv' INTO TABLE `crm_address_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_army_status`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_army_status.csv' INTO TABLE `crm_army_status` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_banks`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_banks.csv' INTO TABLE `crm_banks` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_branch_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_branch_type.csv' INTO TABLE `crm_branch_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_client_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_client_type.csv' INTO TABLE `crm_client_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_client_type_docs`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_client_type_docs.csv' INTO TABLE `crm_client_type_docs` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_contact_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_contact_type.csv' INTO TABLE `crm_contact_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_country`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_country.csv' INTO TABLE `crm_country` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_currency`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_currency.csv' INTO TABLE `crm_currency` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_directory_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_directory_type.csv' INTO TABLE `crm_directory_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_doc_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_doc_type.csv' INTO TABLE `crm_doc_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_education`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_education.csv' INTO TABLE `crm_education` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_employee_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_employee_type.csv' INTO TABLE `crm_employee_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_enterprise_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_enterprise_type.csv' INTO TABLE `crm_enterprise_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_family_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_family_type.csv' INTO TABLE `crm_family_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_house`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_house.csv' INTO TABLE `crm_house` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_kfs`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_kfs.csv' INTO TABLE `crm_kfs` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_kladr`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_kladr.csv' INTO TABLE `crm_kladr` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_license_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_license_type.csv' INTO TABLE `crm_license_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_materials`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_materials.csv' INTO TABLE `crm_materials` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_mpb`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_mpb.csv' INTO TABLE `crm_mpb` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_obligation_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_obligation_type.csv' INTO TABLE `crm_obligation_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_okopf`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_okopf.csv' INTO TABLE `crm_okopf` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_okved`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_okved.csv' INTO TABLE `crm_okved` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_org_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_org_type.csv' INTO TABLE `crm_org_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_property_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_property_type.csv' INTO TABLE `crm_property_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_realty_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_realty_type.csv' INTO TABLE `crm_realty_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_social_states`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_social_states.csv' INTO TABLE `crm_social_states` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_soun`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_soun.csv' INTO TABLE `crm_soun` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_status_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_status_type.csv' INTO TABLE `crm_status_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_street`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_street.csv' INTO TABLE `crm_street` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_tire_diameter`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_tire_diameter.csv' INTO TABLE `crm_tire_diameter` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_tire_name`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_tire_name.csv' INTO TABLE `crm_tire_name` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_tire_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_tire_type.csv' INTO TABLE `crm_tire_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_trans_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_trans_type.csv' INTO TABLE `crm_trans_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_web_name`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_web_name.csv' INTO TABLE `crm_web_name` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_web_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_web_type.csv' INTO TABLE `crm_web_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `files_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/files_type.csv' INTO TABLE `files_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `sed_post_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/sed_post_types.csv' INTO TABLE `sed_post_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `spr_answer`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/spr_answer.csv' INTO TABLE `spr_answer` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `spr_question`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/spr_question.csv' INTO TABLE `spr_question` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `spr_tests`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/spr_tests.csv' INTO TABLE `spr_tests` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `ui_blocks`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/ui_blocks.csv' INTO TABLE `ui_blocks` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_jumps`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_jumps.csv' INTO TABLE `workflow_jumps` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_mailing`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_mailing.csv' INTO TABLE `workflow_mailing` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_mailing_set`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_mailing_set.csv' INTO TABLE `workflow_mailing_set` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_processes`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_processes.csv' INTO TABLE `workflow_processes` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_schemes`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_schemes.csv' INTO TABLE `workflow_schemes` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_stages`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_stages.csv' INTO TABLE `workflow_stages` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_stages_sms`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_stages_sms.csv' INTO TABLE `workflow_stages_sms` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_stages_tmpl_arm`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_stages_tmpl_arm.csv' INTO TABLE `workflow_stages_tmpl_arm` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `workflow_tasks`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/workflow_tasks.csv' INTO TABLE `workflow_tasks` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `#roles`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/#roles.csv' INTO TABLE `#roles` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `#reference_tables`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/#reference_tables.csv' INTO TABLE `#reference_tables` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_car_model`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_car_model.csv' INTO TABLE `bpl_car_model` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_account_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_account_types.csv' INTO TABLE `bpl_account_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `contract_turns`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/contract_turns.csv' INTO TABLE `contract_turns` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `contract_operations`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/contract_operations.csv' INTO TABLE `contract_operations` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `contract_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/contract_types.csv' INTO TABLE `contract_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_oper_types`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_oper_types.csv' INTO TABLE `bpl_oper_types` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `dictionaries`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/dictionaries.csv' INTO TABLE `dictionaries` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_tax_type`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_tax_type.csv' INTO TABLE `crm_tax_type` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `crm_ndfl_code`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/crm_ndfl_code.csv' INTO TABLE `crm_ndfl_code` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_cond`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_cond.csv' INTO TABLE `appl_cond` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_cond_opt`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_cond_opt.csv' INTO TABLE `appl_cond_opt` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_loan_tariff_opt`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_loan_tariff_opt.csv' INTO TABLE `appl_loan_tariff_opt` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_loan_tariff`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_loan_tariff.csv' INTO TABLE `appl_loan_tariff` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `contract_acc_find_fn`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/contract_acc_find_fn.csv' INTO TABLE `contract_acc_find_fn` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `bpl_eckk`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/bpl_eckk.csv' INTO TABLE `bpl_eckk` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_loan_limit`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_loan_limit.csv' INTO TABLE `appl_loan_limit` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_template_ndfl`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_template_ndfl.csv' INTO TABLE `appl_template_ndfl` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_products_opers`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_products_opers.csv' INTO TABLE `appl_products_opers` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `ui_menu`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/ui_menu.csv' INTO TABLE `ui_menu` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `ui_menu_tree_p`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/ui_menu_tree_p.csv' INTO TABLE `ui_menu_tree_p` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; DELETE FROM `appl_loan_limit_data`; LOAD DATA LOCAL INFILE '/home/synergy/www/update/db/tables/appl_loan_limit_data.csv' INTO TABLE `appl_loan_limit_data` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\' LINES TERMINATED BY ' '; ALTER TABLE `#department_addr` ADD CONSTRAINT `#department_addr_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `#department_addr_ibfk_2` FOREIGN KEY( `addr_type` ) REFERENCES `crm_address_type` ( `addr_type` ) ON DELETE RESTRICT ON UPDATE NO ACTION ALTER TABLE `#department_contact` ADD CONSTRAINT `#department_contact_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `#department_contact_ibfk_5` FOREIGN KEY( `id_contact_type` ) REFERENCES `crm_contact_type` ( `id_contact_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#department_tree_p` ADD CONSTRAINT `#department_tree_p_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `#department_tree_p_ibfk_2` FOREIGN KEY( `id_depart_in` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#departments` ADD CONSTRAINT `#departments_ibfk_1` FOREIGN KEY( `id_parent` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `#departments_ibfk_2` FOREIGN KEY( `emp_id` ) REFERENCES `#users` ( `id_user` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `#departments_ibfk_3` FOREIGN KEY( `emp_id_first` ) REFERENCES `#users` ( `id_user` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#departments_pos` ADD CONSTRAINT `#departments_pos_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `#departments_pos_ibfk_2` FOREIGN KEY( `id_client_bank` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#ext_sys_departs` ADD CONSTRAINT `#ext_sys_departs_ibfk_2` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `@0023ext_sys_departs_ibfk_1` FOREIGN KEY( `id_ext_sys` ) REFERENCES `#ext_sys` ( `id_ext_sys` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#group_items` ADD CONSTRAINT `#group_items_ibfk_1` FOREIGN KEY( `id_group` ) REFERENCES `#groups` ( `id_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#module_role` ADD CONSTRAINT `FK_#module_role_modules` FOREIGN KEY( `id_module` ) REFERENCES `#modules` ( `id_module` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `FK_#module_role_roles` FOREIGN KEY( `id_role` ) REFERENCES `#roles` ( `id_role` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `#tasks` ADD CONSTRAINT `#tasks_ibfk_1` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `#user_acls` ADD CONSTRAINT `#user_acls_ibfk_1` FOREIGN KEY( `id_profile` ) REFERENCES `#user_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `FK_acl_role` FOREIGN KEY( `id_role` ) REFERENCES `#roles` ( `id_role` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `#user_profiles` ADD CONSTRAINT `#user_profiles_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `id_job` FOREIGN KEY( `id_job` ) REFERENCES `#jobs` ( `id_job` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `user` FOREIGN KEY( `id_user` ) REFERENCES `#users` ( `id_user` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `#users` ADD CONSTRAINT `#users_ibfk_1` FOREIGN KEY( `id_user` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `appl_appraiser` ADD CONSTRAINT `appl_appraiser_ibfk_4` FOREIGN KEY( `id_client` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_appraiser_ibfk_5` FOREIGN KEY( `kladr_code` ) REFERENCES `crm_kladr` ( `code` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_cond_opt` ADD CONSTRAINT `appl_cond_opt_ibfk_1` FOREIGN KEY( `id_cond` ) REFERENCES `appl_cond` ( `id_cond` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_contract_account` ADD CONSTRAINT `appl_contract_account_ibfk_2` FOREIGN KEY( `id_account` ) REFERENCES `bpl_accounts` ( `id_account` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_contract_account_ibfk_3` FOREIGN KEY( `id_acc_type` ) REFERENCES `bpl_account_types` ( `id_acc_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_contract_account_ibfk_4` FOREIGN KEY( `id_profile_group` ) REFERENCES `appl_profile_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_contract_account_ibfk_5` FOREIGN KEY( `id_document` ) REFERENCES `workflow_documents` ( `id_document` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_contract_account_ibfk_6` FOREIGN KEY( `id_client` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_loan_limit_data` ADD CONSTRAINT `appl_loan_limit_data_ibfk_2` FOREIGN KEY( `kladr_code` ) REFERENCES `crm_kladr` ( `code` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_loan_limit_data_ibfk_3` FOREIGN KEY( `id_limit` ) REFERENCES `appl_loan_limit` ( `id_limit` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_loan_tariff` ADD CONSTRAINT `appl_loan_tariff_ibfk_1` FOREIGN KEY( `id_product` ) REFERENCES `appl_products` ( `id_product` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_loan_tariff_ibfk_2` FOREIGN KEY( `id_limit` ) REFERENCES `appl_loan_limit` ( `id_limit` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_loan_tariff_opt` ADD CONSTRAINT `appl_loan_tariff_opt_ibfk_1` FOREIGN KEY( `id_tariff` ) REFERENCES `appl_loan_tariff` ( `id_tariff` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_loan_tariff_opt_ibfk_2` FOREIGN KEY( `id_opt` ) REFERENCES `appl_cond_opt` ( `id_opt` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_product_departs` ADD CONSTRAINT `appl_product_departs_ibfk_2` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_product_departs_ibfk_3` FOREIGN KEY( `id_product` ) REFERENCES `appl_products` ( `id_product` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_products` ADD CONSTRAINT `appl_products_ibfk_2` FOREIGN KEY( `id_process` ) REFERENCES `workflow_processes` ( `id_process` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_products_ibfk_3` FOREIGN KEY( `id_template` ) REFERENCES `appl_templates` ( `id_template` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_products_ibfk_4` FOREIGN KEY( `appl_type` ) REFERENCES `appl_types` ( `appl_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_products_ibfk_5` FOREIGN KEY( `id_contract_type` ) REFERENCES `contract_types` ( `id_contract_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_products_ibfk_6` FOREIGN KEY( `id_role` ) REFERENCES `#roles` ( `id_role` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_products_opers` ADD CONSTRAINT `appl_products_opers_ibfk_1` FOREIGN KEY( `id_product` ) REFERENCES `appl_products` ( `id_product` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_products_opers_ibfk_2` FOREIGN KEY( `id_product_oper` ) REFERENCES `appl_products` ( `id_product` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_profile_account` ADD CONSTRAINT `appl_profile_account_ibfk_1` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profile_account_ibfk_2` FOREIGN KEY( `bic` ) REFERENCES `crm_banks` ( `bic` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_profile_addr` ADD CONSTRAINT `appl_profile_addr_ibfk_2` FOREIGN KEY( `addr_type` ) REFERENCES `crm_address_type` ( `addr_type` ) ON DELETE RESTRICT ON UPDATE NO ACTION, ADD CONSTRAINT `appl_profile_addr_ibfk_3` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `appl_profile_contact` ADD CONSTRAINT `appl_profile_contact_ibfk_3` FOREIGN KEY( `id_contact_type` ) REFERENCES `crm_contact_type` ( `id_contact_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profile_contact_ibfk_4` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `appl_profile_doc` ADD CONSTRAINT `appl_profile_doc_ibfk_1` FOREIGN KEY( `id_doc_type` ) REFERENCES `crm_doc_type` ( `id_doc_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profile_doc_ibfk_2` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `appl_profile_types` ADD CONSTRAINT `appl_profile_types_ibfk_1` FOREIGN KEY( `client_type` ) REFERENCES `crm_client_type` ( `client_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_profile_types_groups` ADD CONSTRAINT `appl_profile_types_groups_ibfk_1` FOREIGN KEY( `id_profile_type` ) REFERENCES `appl_profile_types` ( `id_profile_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profile_types_groups_ibfk_2` FOREIGN KEY( `id_profile_group` ) REFERENCES `appl_profile_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_profiles` ADD CONSTRAINT `appl_profiles_ibfk_1` FOREIGN KEY( `id_post_type` ) REFERENCES `sed_post_types` ( `id_post_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_10` FOREIGN KEY( `id_profile_parent` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_11` FOREIGN KEY( `id_profile_type` ) REFERENCES `appl_profile_types` ( `id_profile_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_12` FOREIGN KEY( `id_client` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_14` FOREIGN KEY( `id_file` ) REFERENCES `files` ( `id_file` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_15` FOREIGN KEY( `id_product` ) REFERENCES `appl_products` ( `id_product` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_2` FOREIGN KEY( `emp_id` ) REFERENCES `#users` ( `id_user` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_3` FOREIGN KEY( `emp_id_first` ) REFERENCES `#users` ( `id_user` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_ibfk_7` FOREIGN KEY( `id_document` ) REFERENCES `workflow_documents` ( `id_document` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `depart` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_profiles_groups` ADD CONSTRAINT `appl_profiles_groups_ibfk_1` FOREIGN KEY( `id_profile_group` ) REFERENCES `appl_profile_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_groups_ibfk_2` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `appl_profiles_notations` ADD CONSTRAINT `appl_profiles_notations_ibfk_2` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_notations_ibfk_3` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_notations_ibfk_4` FOREIGN KEY( `id_job` ) REFERENCES `#jobs` ( `id_job` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_profiles_notations_ibfk_5` FOREIGN KEY( `emp_id` ) REFERENCES `#users` ( `id_user` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_template_group_doc` ADD CONSTRAINT `appl_template_group_doc_ibfk_2` FOREIGN KEY( `id_profile_group` ) REFERENCES `appl_profile_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_template_group_doc_ibfk_6` FOREIGN KEY( `id_template` ) REFERENCES `appl_templates` ( `id_template` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_template_group_doc_ibfk_7` FOREIGN KEY( `id_doc_type` ) REFERENCES `crm_doc_type` ( `id_doc_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_template_group_doc_ibfk_8` FOREIGN KEY( `id_profile_type` ) REFERENCES `appl_profile_types` ( `id_profile_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_template_groups` ADD CONSTRAINT `appl_template_groups_ibfk_1` FOREIGN KEY( `id_template` ) REFERENCES `appl_templates` ( `id_template` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_template_groups_ibfk_2` FOREIGN KEY( `id_profile_group` ) REFERENCES `appl_profile_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_template_ndfl` ADD CONSTRAINT `appl_template_ndfl_ibfk_1` FOREIGN KEY( `id_template` ) REFERENCES `appl_templates` ( `id_template` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `appl_template_ndfl_ibfk_2` FOREIGN KEY( `ndfl_code` ) REFERENCES `crm_ndfl_code` ( `code` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `appl_templates` ADD CONSTRAINT `appl_templates_ibfk_1` FOREIGN KEY( `id_profile_group_main` ) REFERENCES `appl_template_groups` ( `id_profile_group` ) ON DELETE RESTRICT ON UPDATE SET NULL ALTER TABLE `bki_loans` ADD CONSTRAINT `bki_loans_ibfk_1` FOREIGN KEY( `id_profile` ) REFERENCES `appl_profiles` ( `id_profile` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bonus_conditions` ADD CONSTRAINT `bonus_conditions_ibfk_1` FOREIGN KEY( `id_rule` ) REFERENCES `bonus_rules` ( `id_rule` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bonus_conditions_ibfk_2` FOREIGN KEY( `id_condition_type` ) REFERENCES `bonus_condition_types` ( `id_condition_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_accounts` ADD CONSTRAINT `bpl_accounts_ibfk_1` FOREIGN KEY( `id_acc_type` ) REFERENCES `bpl_account_types` ( `id_acc_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_accounts_ibfk_2` FOREIGN KEY( `id_client` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_accounts_turns` ADD CONSTRAINT `bpl_accounts_turns_ibfk_2` FOREIGN KEY( `id_account` ) REFERENCES `bpl_accounts` ( `id_account` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_car_model` ADD CONSTRAINT `bpl_car_model_ibfk_1` FOREIGN KEY( `id_brand` ) REFERENCES `bpl_car_brand` ( `id_brand` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_car_modify` ADD CONSTRAINT `bpl_car_modify_ibfk_1` FOREIGN KEY( `id_model` ) REFERENCES `bpl_car_model` ( `id_model` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_car_year` ADD CONSTRAINT `bpl_car_year_ibfk_1` FOREIGN KEY( `id_modify` ) REFERENCES `bpl_car_modify` ( `id_modify` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_cards` ADD CONSTRAINT `bpl_cards_ibfk_2` FOREIGN KEY( `id_status` ) REFERENCES `bpl_card_status` ( `id_status` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_cards_ibfk_3` FOREIGN KEY( `id_card_type` ) REFERENCES `bpl_card_types` ( `id_card_type` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_cards_accounts` ADD CONSTRAINT `bpl_cards_accounts_ibfk_1` FOREIGN KEY( `id_card` ) REFERENCES `bpl_cards` ( `id_card` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_cards_accounts_ibfk_2` FOREIGN KEY( `id_account` ) REFERENCES `bpl_accounts` ( `id_account` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_cards_accounts_ibfk_3` FOREIGN KEY( `id_document` ) REFERENCES `workflow_documents` ( `id_document` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_contract_accounts` ADD CONSTRAINT `bpl_contract_accounts_ibfk_1` FOREIGN KEY( `id_contract` ) REFERENCES `bpl_contracts` ( `id_contract` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_contracts` ADD CONSTRAINT `bpl_contracts_ibfk_2` FOREIGN KEY( `id_client` ) REFERENCES `crm_client` ( `id_client` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_contracts_ibfk_3` FOREIGN KEY( `id_prog` ) REFERENCES `bpl_programs` ( `id_prog` ) ON DELETE RESTRICT ON UPDATE RESTRICT ALTER TABLE `bpl_departments_stores` ADD CONSTRAINT `bpl_departments_stores_ibfk_1` FOREIGN KEY( `id_store` ) REFERENCES `bpl_stores` ( `id_store` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_departments_stores_ibfk_2` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_departments_stores_ibfk_3` FOREIGN KEY( `id_store` ) REFERENCES `bpl_stores` ( `id_store` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `bpl_product_cnts` ADD CONSTRAINT `bpl_product_cnts_ibfk_5` FOREIGN KEY( `id_store` ) REFERENCES `bpl_stores` ( `id_store` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_product_cnts_ibfk_6` FOREIGN KEY( `id_product` ) REFERENCES `bpl_product_types` ( `id_product` ) ON DELETE CASCADE ON UPDATE RESTRICT ALTER TABLE `bpl_product_loyality` ADD CONSTRAINT `bpl_product_loyality_ibfk_1` FOREIGN KEY( `id_depart` ) REFERENCES `#departments` ( `id_depart` ) ON DELETE RESTRICT ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_product_loyality_ibfk_2` FOREIGN KEY( `id_product` ) REFERENCES `bpl_product_types` ( `id_product` ) ON DELETE CASCADE ON UPDATE RESTRICT, ADD CONSTRAINT `bpl_product_loyality_ibfk_3` FOREIGN KEY( `id_prog` ) REFERENCES `bpl_programs` ( `id_prog` ) ON DELETE RESTRICT ON UPDATE RESTRICT /* PDO::query(): MySQL server has gone away */