================= 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 */