API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 6th, 2015
274
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 102.61 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3. namespace Application\Migrations;
  4.  
  5. use Doctrine\DBAL\Migrations\AbstractMigration;
  6. use Doctrine\DBAL\Schema\Schema;
  7.  
  8. /**
  9.  * Auto-generated Migration: Please modify to your needs!
  10.  */
  11. class Version20150507142118 extends AbstractMigration
  12. {
  13.     /**
  14.      * @param Schema $schema
  15.      */
  16.     public function up(Schema $schema)
  17.     {
  18.         // this up() migration is auto-generated, please modify it to your needs
  19.         $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  20.  
  21.         $this->addSql('ALTER TABLE autoservice_entry_prices DROP FOREIGN KEY autoservice_entry_prices_ibfk_1');
  22.         $this->addSql('ALTER TABLE autoservice_entry_services DROP FOREIGN KEY autoservice_entry_services_ibfk_1');
  23.         $this->addSql('ALTER TABLE calls_status_statistic DROP FOREIGN KEY calls_status_statistic_ibfk_1');
  24.         $this->addSql('ALTER TABLE indicator_values DROP FOREIGN KEY indicator_values_ibfk_1');
  25.         $this->addSql('ALTER TABLE invoices_custom_parts DROP FOREIGN KEY invoices_custom_parts_ibfk_1');
  26.         $this->addSql('ALTER TABLE invoices_parts DROP FOREIGN KEY invoices_parts_ibfk_2');
  27.         $this->addSql('ALTER TABLE japancar_cache_data DROP FOREIGN KEY japancar_cache_data_ibfk_1');
  28.         $this->addSql('ALTER TABLE kpi_values DROP FOREIGN KEY kpi_values_ibfk_1');
  29.         $this->addSql('ALTER TABLE autoservice_entry DROP FOREIGN KEY autoservice_entry_ibfk_1');
  30.         $this->addSql('ALTER TABLE autoservice_entry_prices DROP FOREIGN KEY autoservice_entry_prices_ibfk_2');
  31.         $this->addSql('ALTER TABLE invoices_parts DROP FOREIGN KEY invoices_parts_ibfk_1');
  32.         $this->addSql('ALTER TABLE sxgeo_cities DROP FOREIGN KEY sxgeo_cities_ibfk_2');
  33.         $this->addSql('CREATE TABLE autoservices (id INT AUTO_INCREMENT NOT NULL, agent_id INT DEFAULT NULL, name VARCHAR(150) NOT NULL, address LONGTEXT NOT NULL, phone VARCHAR(30) NOT NULL, notify_phone VARCHAR(30) DEFAULT NULL, email VARCHAR(150) DEFAULT NULL, site VARCHAR(150) DEFAULT NULL, notified TINYINT(1) NOT NULL, discount INT DEFAULT NULL, visible TINYINT(1) NOT NULL, comment LONGTEXT DEFAULT NULL, INDEX IDX_2D3F4D2E3414710B (agent_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  34.         $this->addSql('ALTER TABLE autoservices ADD CONSTRAINT FK_2D3F4D2E3414710B FOREIGN KEY (agent_id) REFERENCES users (id)');
  35.         $this->addSql('DROP TABLE actuality_offer_parts');
  36.         $this->addSql('DROP TABLE add_lookup');
  37.         $this->addSql('DROP TABLE alarm');
  38.         $this->addSql('DROP TABLE autoload_prices_history');
  39.         $this->addSql('DROP TABLE autoservice_entry');
  40.         $this->addSql('DROP TABLE autoservice_entry_prices');
  41.         $this->addSql('DROP TABLE autoservice_entry_services');
  42.         $this->addSql('DROP TABLE autoservice_orders');
  43.         $this->addSql('DROP TABLE autoservices_orders_info');
  44.         $this->addSql('DROP TABLE autoservices_orders_status');
  45.         $this->addSql('DROP TABLE brands_common_name_description');
  46.         $this->addSql('DROP TABLE brands_name');
  47.         $this->addSql('DROP TABLE calls_status');
  48.         $this->addSql('DROP TABLE calls_status_statistic');
  49.         $this->addSql('DROP TABLE car_subsystem_parts');
  50.         $this->addSql('DROP TABLE car_subsystems');
  51.         $this->addSql('DROP TABLE car_systems');
  52.         $this->addSql('DROP TABLE cars_brand');
  53.         $this->addSql('DROP TABLE cars_chassis');
  54.         $this->addSql('DROP TABLE cars_info');
  55.         $this->addSql('DROP TABLE cars_model');
  56.         $this->addSql('DROP TABLE cars_motor');
  57.         $this->addSql('DROP TABLE cars_years');
  58.         $this->addSql('DROP TABLE cash_orders_info');
  59.         $this->addSql('DROP TABLE cash_status');
  60.         $this->addSql('DROP TABLE catalog');
  61.         $this->addSql('DROP TABLE catalog_art_display');
  62.         $this->addSql('DROP TABLE catalog_descriptions');
  63.         $this->addSql('DROP TABLE catalog_farpost_analog');
  64.         $this->addSql('DROP TABLE catalog_farpost_oem');
  65.         $this->addSql('DROP TABLE catalog_farpost_usage');
  66.         $this->addSql('DROP TABLE catalog_info');
  67.         $this->addSql('DROP TABLE catalog_offer_price');
  68.         $this->addSql('DROP TABLE catalog_parts_descriptions');
  69.         $this->addSql('DROP TABLE catalog_parts_info');
  70.         $this->addSql('DROP TABLE catalog_root');
  71.         $this->addSql('DROP TABLE catalog_sv_kind');
  72.         $this->addSql('DROP TABLE catalog_sv_val');
  73.         $this->addSql('DROP TABLE catalog_tmp_sv_val');
  74.         $this->addSql('DROP TABLE changed_price_parts');
  75.         $this->addSql('DROP TABLE check_new_route');
  76.         $this->addSql('DROP TABLE check_self_price_log');
  77.         $this->addSql('DROP TABLE clients_orders_history');
  78.         $this->addSql('DROP TABLE clients_orders_info');
  79.         $this->addSql('DROP TABLE collect_orders_statistic');
  80.         $this->addSql('DROP TABLE count_orders_statistic');
  81.         $this->addSql('DROP TABLE courier_parts_info');
  82.         $this->addSql('DROP TABLE courier_ready');
  83.         $this->addSql('DROP TABLE courier_route');
  84.         $this->addSql('DROP TABLE couriers');
  85.         $this->addSql('DROP TABLE couriers_fuel_rate');
  86.         $this->addSql('DROP TABLE couriers_routes');
  87.         $this->addSql('DROP TABLE couriers_routes_history');
  88.         $this->addSql('DROP TABLE couriers_speedometer_data');
  89.         $this->addSql('DROP TABLE couriers_status');
  90.         $this->addSql('DROP TABLE couriers_time_limits');
  91.         $this->addSql('DROP TABLE cross_base');
  92.         $this->addSql('DROP TABLE cur_back_baza');
  93.         $this->addSql('DROP TABLE cur_delivery_times');
  94.         $this->addSql('DROP TABLE cur_times');
  95.         $this->addSql('DROP TABLE debt_status');
  96.         $this->addSql('DROP TABLE delete_orders');
  97.         $this->addSql('DROP TABLE delivery');
  98.         $this->addSql('DROP TABLE delivery_info');
  99.         $this->addSql('DROP TABLE delivery_plan_info');
  100.         $this->addSql('DROP TABLE delivery_route_info');
  101.         $this->addSql('DROP TABLE detail_brand');
  102.         $this->addSql('DROP TABLE detail_name');
  103.         $this->addSql('DROP TABLE detail_name_alternative');
  104.         $this->addSql('DROP TABLE dict_father_names');
  105.         $this->addSql('DROP TABLE dict_names');
  106.         $this->addSql('DROP TABLE distributors_brands_syn');
  107.         $this->addSql('DROP TABLE distributors_ftp_settings');
  108.         $this->addSql('DROP TABLE distributors_info');
  109.         $this->addSql('DROP TABLE distributors_price_settings');
  110.         $this->addSql('DROP TABLE distributors_send_mail');
  111.         $this->addSql('DROP TABLE distributors_status');
  112.         $this->addSql('DROP TABLE distributors_visit_statistic');
  113.         $this->addSql('DROP TABLE error_log_info');
  114.         $this->addSql('DROP TABLE error_status');
  115.         $this->addSql('DROP TABLE exceed_orders_time');
  116.         $this->addSql('DROP TABLE faq_news');
  117.         $this->addSql('DROP TABLE farpost_price');
  118.         $this->addSql('DROP TABLE farpost_price_history');
  119.         $this->addSql('DROP TABLE fixed_prices');
  120.         $this->addSql('DROP TABLE ftp_accounts');
  121.         $this->addSql('DROP TABLE garanty_error_log_info');
  122.         $this->addSql('DROP TABLE garanty_sto');
  123.         $this->addSql('DROP TABLE getback_status');
  124.         $this->addSql('DROP TABLE indicator_values');
  125.         $this->addSql('DROP TABLE indicators');
  126.         $this->addSql('DROP TABLE install_point_table');
  127.         $this->addSql('DROP TABLE invoices');
  128.         $this->addSql('DROP TABLE invoices_custom_parts');
  129.         $this->addSql('DROP TABLE invoices_parts');
  130.         $this->addSql('DROP TABLE japancar_cache_data');
  131.         $this->addSql('DROP TABLE japancar_cache_info');
  132.         $this->addSql('DROP TABLE japancar_datail_name');
  133.         $this->addSql('DROP TABLE kpi');
  134.         $this->addSql('DROP TABLE kpi_values');
  135.         $this->addSql('DROP TABLE load_lookup_log');
  136.         $this->addSql('DROP TABLE logistic_alarm');
  137.         $this->addSql('DROP TABLE logistic_error_log_info');
  138.         $this->addSql('DROP TABLE logistic_stat');
  139.         $this->addSql('DROP TABLE lookup');
  140.         $this->addSql('DROP TABLE main_page_offer');
  141.         $this->addSql('DROP TABLE manager_actions_log');
  142.         $this->addSql('DROP TABLE new_courier_status');
  143.         $this->addSql('DROP TABLE new_delivery_route_info');
  144.         $this->addSql('DROP TABLE new_route_way_time');
  145.         $this->addSql('DROP TABLE offer_orders_contractors');
  146.         $this->addSql('DROP TABLE offer_parts_info');
  147.         $this->addSql('DROP TABLE offer_status');
  148.         $this->addSql('DROP TABLE offer_view');
  149.         $this->addSql('DROP TABLE oil_scheme_data');
  150.         $this->addSql('DROP TABLE order_client_status');
  151.         $this->addSql('DROP TABLE order_sources');
  152.         $this->addSql('DROP TABLE order_statistic');
  153.         $this->addSql('DROP TABLE order_status');
  154.         $this->addSql('DROP TABLE orders_clients_info');
  155.         $this->addSql('DROP TABLE orders_clients_info_tmp');
  156.         $this->addSql('DROP TABLE orders_comments');
  157.         $this->addSql('DROP TABLE orders_delivery_info');
  158.         $this->addSql('DROP TABLE orders_error_log');
  159.         $this->addSql('DROP TABLE orders_error_log_history');
  160.         $this->addSql('DROP TABLE orders_getback_parts');
  161.         $this->addSql('DROP TABLE orders_link');
  162.         $this->addSql('DROP TABLE orders_list');
  163.         $this->addSql('DROP TABLE orders_logistic_info');
  164.         $this->addSql('DROP TABLE orders_managers');
  165.         $this->addSql('DROP TABLE orders_managers_history');
  166.         $this->addSql('DROP TABLE orders_offer_list');
  167.         $this->addSql('DROP TABLE orders_offer_parts_info');
  168.         $this->addSql('DROP TABLE orders_parts_history');
  169.         $this->addSql('DROP TABLE orders_parts_info');
  170.         $this->addSql('DROP TABLE orders_prices');
  171.         $this->addSql('DROP TABLE orders_root_status');
  172.         $this->addSql('DROP TABLE orders_status_history');
  173.         $this->addSql('DROP TABLE pages');
  174.         $this->addSql('DROP TABLE paid_orders');
  175.         $this->addSql('DROP TABLE parts_base');
  176.         $this->addSql('DROP TABLE parts_history');
  177.         $this->addSql('DROP TABLE parts_name');
  178.         $this->addSql('DROP TABLE poll_info');
  179.         $this->addSql('DROP TABLE poll_statistic');
  180.         $this->addSql('DROP TABLE pre_add_lookup');
  181.         $this->addSql('DROP TABLE price');
  182.         $this->addSql('DROP TABLE price_bad');
  183.         $this->addSql('DROP TABLE price_bad_5');
  184.         $this->addSql('DROP TABLE price_bad_delete_log');
  185.         $this->addSql('DROP TABLE price_farpost');
  186.         $this->addSql('DROP TABLE price_farpost_min_pr');
  187.         $this->addSql('DROP TABLE price_farpost_onsite');
  188.         $this->addSql('DROP TABLE price_farpost_out');
  189.         $this->addSql('DROP TABLE price_farpost_ready');
  190.         $this->addSql('DROP TABLE price_farpost_rf');
  191.         $this->addSql('DROP TABLE price_our');
  192.         $this->addSql('DROP TABLE price_our_ttmp');
  193.         $this->addSql('DROP TABLE price_point');
  194.         $this->addSql('DROP TABLE price_region_1');
  195.         $this->addSql('DROP TABLE price_region_2');
  196.         $this->addSql('DROP TABLE price_region_3');
  197.         $this->addSql('DROP TABLE price_regions');
  198.         $this->addSql('DROP TABLE price_tmp_load');
  199.         $this->addSql('DROP TABLE price_vladivostok');
  200.         $this->addSql('DROP TABLE prouser_manager_data');
  201.         $this->addSql('DROP TABLE required_orders_managers');
  202.         $this->addSql('DROP TABLE route_place_time');
  203.         $this->addSql('DROP TABLE route_way_statistic');
  204.         $this->addSql('DROP TABLE route_way_time');
  205.         $this->addSql('DROP TABLE s_groups');
  206.         $this->addSql('DROP TABLE service_info');
  207.         $this->addSql('DROP TABLE sip');
  208.         $this->addSql('DROP TABLE sip_calls');
  209.         $this->addSql('DROP TABLE sip_calls_mainmanager_tmp');
  210.         $this->addSql('DROP TABLE sip_calls_status');
  211.         $this->addSql('DROP TABLE sip_calls_tmp');
  212.         $this->addSql('DROP TABLE sip_recalls');
  213.         $this->addSql('DROP TABLE sip_request');
  214.         $this->addSql('DROP TABLE sip_request_tmp');
  215.         $this->addSql('DROP TABLE sms_settings');
  216.         $this->addSql('DROP TABLE sms_status');
  217.         $this->addSql('DROP TABLE storage_stat');
  218.         $this->addSql('DROP TABLE store_error_log_info');
  219.         $this->addSql('DROP TABLE store_getback_orders_place');
  220.         $this->addSql('DROP TABLE store_getback_parts_place');
  221.         $this->addSql('DROP TABLE store_orders_info');
  222.         $this->addSql('DROP TABLE store_parts_place');
  223.         $this->addSql('DROP TABLE store_status');
  224.         $this->addSql('DROP TABLE sxgeo_cities');
  225.         $this->addSql('DROP TABLE system_discount');
  226.         $this->addSql('DROP TABLE tests_answers_table');
  227.         $this->addSql('DROP TABLE tests_catalog_resources_table');
  228.         $this->addSql('DROP TABLE tests_end_status_table');
  229.         $this->addSql('DROP TABLE tests_questions_table');
  230.         $this->addSql('DROP TABLE tests_tech_resources_table');
  231.         $this->addSql('DROP TABLE tests_try_table');
  232.         $this->addSql('DROP TABLE tests_users_info_table');
  233.         $this->addSql('DROP TABLE timezones');
  234.         $this->addSql('DROP TABLE tk_info');
  235.         $this->addSql('DROP TABLE tmp');
  236.         $this->addSql('DROP TABLE variables');
  237.         $this->addSql('DROP TABLE view_orders_option');
  238.         $this->addSql('DROP TABLE volume_weight_brands');
  239.         $this->addSql('DROP TABLE volume_weight_data');
  240.         $this->addSql('DROP TABLE wishful_price');
  241.         $this->addSql('ALTER TABLE users DROP secondname, CHANGE login_count login_count INT DEFAULT 0 COMMENT \'The number of times the user has logged in.\', CHANGE old_user old_user TINYINT(1) NOT NULL');
  242.         $this->addSql('DROP INDEX id ON managers');
  243.         $this->addSql('DROP INDEX sip_contact ON managers');
  244.         $this->addSql('DROP INDEX group_status ON managers');
  245.         $this->addSql('DROP INDEX group_id ON managers');
  246.         $this->addSql('DROP INDEX status_id ON managers');
  247.         $this->addSql('DROP INDEX region_id ON managers');
  248.         $this->addSql('DROP INDEX statistic_status ON managers');
  249.         $this->addSql('DROP INDEX error_log_status ON managers');
  250.         $this->addSql('DROP INDEX offline_status ON managers');
  251.         $this->addSql('DROP INDEX group_leader ON managers');
  252.         $this->addSql('DROP INDEX visibility ON managers');
  253.         $this->addSql('ALTER TABLE managers ADD user_id INT NOT NULL, ADD sip_number INT DEFAULT NULL, ADD skype VARCHAR(150) NOT NULL, ADD join_time DATETIME NOT NULL, ADD leave_time DATETIME DEFAULT NULL, DROP name, DROP short_name, DROP color, DROP pass, DROP skype_contact, DROP sip_contact, DROP region_id, DROP status_id, DROP main_manager, DROP group_id, DROP group_leader, DROP group_status, DROP error_log_status, DROP offline_status, DROP visibility, CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE 1c_code 1c_code VARCHAR(45) NOT NULL, CHANGE garanty_view visible TINYINT(1) NOT NULL, ADD PRIMARY KEY (id)');
  254.         $this->addSql('ALTER TABLE managers ADD CONSTRAINT FK_A949E006A76ED395 FOREIGN KEY (user_id) REFERENCES users (id)');
  255.         $this->addSql('ALTER TABLE managers ADD CONSTRAINT FK_A949E00650ABD72B FOREIGN KEY (sip_number) REFERENCES sip_numbers (id)');
  256.         $this->addSql('CREATE INDEX IDX_A949E006A76ED395 ON managers (user_id)');
  257.         $this->addSql('CREATE INDEX IDX_A949E00650ABD72B ON managers (sip_number)');
  258.         $this->addSql('CREATE UNIQUE INDEX UNIQ_57C2B0621F578393 ON categories__categories (singular_name)');
  259.         $this->addSql('CREATE UNIQUE INDEX UNIQ_57C2B0629DEC66E6 ON categories__categories (plural_name)');
  260.         $this->addSql('ALTER TABLE products__products_images DROP art, DROP brand');
  261.         $this->addSql('ALTER TABLE products__products_images ADD CONSTRAINT FK_470C54717294869C FOREIGN KEY (article_id) REFERENCES articles (id) ON DELETE CASCADE');
  262.         $this->addSql('CREATE INDEX IDX_470C54717294869C ON products__products_images (article_id)');
  263.         $this->addSql('DROP INDEX brand_id ON products__products_categories');
  264.         $this->addSql('DROP INDEX ft4 ON products__products_categories');
  265.         $this->addSql('ALTER TABLE products__products_categories DROP brand_id, DROP art');
  266.         $this->addSql('ALTER TABLE brands DROP kind');
  267.         $this->addSql('DROP INDEX md5 ON products__products_weights');
  268.         $this->addSql('DROP INDEX art ON products__products_weights');
  269.         $this->addSql('DROP INDEX brand_id ON products__products_weights');
  270.         $this->addSql('DROP INDEX kind ON products__products_weights');
  271.         $this->addSql('DROP INDEX add_source ON products__products_weights');
  272.         $this->addSql('ALTER TABLE products__products_weights ADD article_id INT NOT NULL, DROP brand, DROP art, DROP md5, DROP brand_id, DROP kind, DROP add_source');
  273.         $this->addSql('ALTER TABLE products__products_weights ADD CONSTRAINT FK_9010A95E7294869C FOREIGN KEY (article_id) REFERENCES articles (id) ON DELETE CASCADE');
  274.         $this->addSql('CREATE INDEX IDX_9010A95E7294869C ON products__products_weights (article_id)');
  275.     }
  276.  
  277.     /**
  278.      * @param Schema $schema
  279.      */
  280.     public function down(Schema $schema)
  281.     {
  282.         // this down() migration is auto-generated, please modify it to your needs
  283.         $this->abortIf($this->connection->getDatabasePlatform()->getName() != 'mysql', 'Migration can only be executed safely on \'mysql\'.');
  284.  
  285.         $this->addSql('CREATE TABLE actuality_offer_parts (id INT AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, part_status INT NOT NULL, status_id INT NOT NULL, distr_id INT NOT NULL, date DATETIME NOT NULL, INDEX part_id (part_id), INDEX status_id (status_id), INDEX distr_id (distr_id), INDEX part_status (part_status), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  286.         $this->addSql('CREATE TABLE add_lookup (brand_name LONGTEXT DEFAULT NULL, art LONGTEXT DEFAULT NULL, art_disp LONGTEXT DEFAULT NULL, art_id INT DEFAULT NULL, art_bra_md5 TINYBLOB NOT NULL, INDEX in_art_id (art_id), INDEX in_s_md5 (art_bra_md5)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  287.         $this->addSql('CREATE TABLE alarm (up INT DEFAULT 1, stat TINYINT(1) DEFAULT NULL, INDEX up (up), INDEX stat (stat)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  288.         $this->addSql('CREATE TABLE autoload_prices_history (id INT AUTO_INCREMENT NOT NULL, distr_id INT NOT NULL, filename VARCHAR(500) NOT NULL, filesize INT NOT NULL, date DATETIME NOT NULL, INDEX distr_id (distr_id), INDEX filename (filename), INDEX filesize (filesize), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  289.         $this->addSql('CREATE TABLE autoservice_entry (id INT UNSIGNED AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, autoservice_id INT NOT NULL, send_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, status INT DEFAULT 0 NOT NULL, UNIQUE INDEX order_id (order_id, autoservice_id), INDEX autoservice_id (autoservice_id), INDEX IDX_43DDB1FA8D9F6D38 (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  290.         $this->addSql('CREATE TABLE autoservice_entry_prices (id INT UNSIGNED AUTO_INCREMENT NOT NULL, entry_id INT UNSIGNED NOT NULL, detail_id INT NOT NULL, price INT DEFAULT 0 NOT NULL, UNIQUE INDEX entry_id (entry_id, detail_id), INDEX detail_id (detail_id), INDEX IDX_F4A463A6BA364942 (entry_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  291.         $this->addSql('CREATE TABLE autoservice_entry_services (id INT UNSIGNED AUTO_INCREMENT NOT NULL, entry_id INT UNSIGNED NOT NULL, name VARCHAR(250) NOT NULL, price INT DEFAULT 0 NOT NULL, INDEX entry_id (entry_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  292.         $this->addSql('CREATE TABLE autoservice_orders (autoservice_id SMALLINT NOT NULL, system_order_id INT NOT NULL, autoservice_order_id INT AUTO_INCREMENT NOT NULL, autoservices_clients_name LONGTEXT NOT NULL, autoservices_clients_tel LONGTEXT NOT NULL, autoservices_clients_address LONGTEXT NOT NULL, autoservices_clients_city VARCHAR(50) NOT NULL, autoservices_clients_street VARCHAR(100) NOT NULL, autoservices_clients_house VARCHAR(10) NOT NULL, autoservices_clients_floor VARCHAR(10) NOT NULL, autoservices_other_delivery_info VARCHAR(500) NOT NULL, autoservices_clients_mail LONGTEXT NOT NULL, autoservices_order_discount SMALLINT NOT NULL, INDEX autoservice_order_id (autoservice_order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  293.         $this->addSql('CREATE TABLE autoservices_orders_info (order_id LONGTEXT NOT NULL, service_id LONGTEXT NOT NULL, car_info LONGTEXT NOT NULL, vin_number LONGTEXT NOT NULL, parts_info LONGTEXT NOT NULL, delivery_info LONGTEXT NOT NULL, offer_parts LONGTEXT NOT NULL, order_status LONGTEXT NOT NULL, change_status_time LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  294.         $this->addSql('CREATE TABLE autoservices_orders_status (order_id LONGTEXT NOT NULL, service_id LONGTEXT NOT NULL, order_status LONGTEXT NOT NULL, change_status_time LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  295.         $this->addSql('CREATE TABLE brands_common_name_description (id INT AUTO_INCREMENT NOT NULL, brand_id INT NOT NULL, common_name_id INT NOT NULL, description LONGTEXT NOT NULL, INDEX brand_id (brand_id), INDEX common_name_id (common_name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  296.         $this->addSql('CREATE TABLE brands_name (name LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  297.         $this->addSql('CREATE TABLE calls_status (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(200) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  298.         $this->addSql('CREATE TABLE calls_status_statistic (id INT AUTO_INCREMENT NOT NULL, status_id INT NOT NULL, phone VARCHAR(20) NOT NULL, sip_id VARCHAR(50) NOT NULL, order_id INT NOT NULL, manager_id INT NOT NULL, date DATETIME NOT NULL, INDEX phone (phone), INDEX sip_id (sip_id), INDEX order_id (order_id), INDEX manager_id (manager_id), INDEX status_id (status_id), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  299.         $this->addSql('CREATE TABLE car_subsystem_parts (id INT AUTO_INCREMENT NOT NULL, subsystem_id INT NOT NULL, name LONGTEXT NOT NULL, UNIQUE INDEX id_2 (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  300.         $this->addSql('CREATE TABLE car_subsystems (id INT AUTO_INCREMENT NOT NULL, main_system_id SMALLINT NOT NULL, name LONGTEXT NOT NULL, UNIQUE INDEX id_2 (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  301.         $this->addSql('CREATE TABLE car_systems (id SMALLINT AUTO_INCREMENT NOT NULL, name LONGTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  302.         $this->addSql('CREATE TABLE cars_brand (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(20) NOT NULL, INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  303.         $this->addSql('CREATE TABLE cars_chassis (id_auto INT AUTO_INCREMENT NOT NULL, id_mark INT NOT NULL, id_year INT NOT NULL, chassis_uin VARCHAR(50) DEFAULT NULL, INDEX UK_cars_chassis_id_year (id_year), PRIMARY KEY(id_auto)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  304.         $this->addSql('CREATE TABLE cars_info (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(20) NOT NULL, model VARCHAR(40) NOT NULL, brand_id INT NOT NULL, INDEX brand (brand), INDEX model (model), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  305.         $this->addSql('CREATE TABLE cars_model (id INT UNSIGNED AUTO_INCREMENT NOT NULL, brand_id INT UNSIGNED DEFAULT NULL, name VARCHAR(100) DEFAULT NULL, INDEX brand_id (brand_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  306.         $this->addSql('CREATE TABLE cars_motor (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(100) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  307.         $this->addSql('CREATE TABLE cars_years (id_years INT AUTO_INCREMENT NOT NULL, id_mark INT NOT NULL, years VARCHAR(17) NOT NULL, UNIQUE INDEX id_years_2 (id_years), INDEX id_mark (id_mark), PRIMARY KEY(id_years)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  308.         $this->addSql('CREATE TABLE cash_orders_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, order_status SMALLINT NOT NULL, price INT NOT NULL, change_status_time LONGTEXT NOT NULL, INDEX id (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  309.         $this->addSql('CREATE TABLE cash_status (status_id SMALLINT NOT NULL, info LONGTEXT NOT NULL, color LONGTEXT NOT NULL, UNIQUE INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  310.         $this->addSql('CREATE TABLE catalog (id INT UNSIGNED AUTO_INCREMENT NOT NULL, md5 TINYBLOB NOT NULL, art VARCHAR(100) NOT NULL, detail_brand_id INT UNSIGNED NOT NULL, detail_name_id INT UNSIGNED DEFAULT 0, car_brand_id INT UNSIGNED DEFAULT 0, car_model_id INT UNSIGNED DEFAULT 0, car_chassis_id INT UNSIGNED DEFAULT 0, car_motor_id INT UNSIGNED DEFAULT 0, INDEX md5 (md5), INDEX detail_brand_id (detail_brand_id), INDEX detail_name_id (detail_name_id), INDEX car_brand_id (car_brand_id), INDEX car_model_id (car_model_id), INDEX car_chassis_id (car_chassis_id), INDEX car_motor_id (car_motor_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  311.         $this->addSql('CREATE TABLE catalog_art_display (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(100) NOT NULL, art_display VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, INDEX md5 (md5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  312.         $this->addSql('CREATE TABLE catalog_descriptions (id INT AUTO_INCREMENT NOT NULL, name_id INT NOT NULL, description VARCHAR(300) NOT NULL, INDEX name_id (name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  313.         $this->addSql('CREATE TABLE catalog_farpost_analog (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, analog VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, uniq_field TINYBLOB NOT NULL, INDEX uniq_field (uniq_field), INDEX md5 (md5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  314.         $this->addSql('CREATE TABLE catalog_farpost_oem (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, oem VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, uniq_field TINYBLOB NOT NULL, INDEX md5 (md5), INDEX uniq_field (uniq_field), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  315.         $this->addSql('CREATE TABLE catalog_farpost_usage (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, `usage` VARCHAR(300) NOT NULL, md5 TINYBLOB NOT NULL, uniq_field TINYBLOB NOT NULL, INDEX uniq_field (uniq_field), INDEX md5 (md5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  316.         $this->addSql('CREATE TABLE catalog_info (id INT UNSIGNED AUTO_INCREMENT NOT NULL, detail_name_id INT UNSIGNED DEFAULT NULL, detail_brand_id INT UNSIGNED DEFAULT NULL, brand_name VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, name LONGTEXT NOT NULL, spy_name LONGTEXT NOT NULL, img_1 LONGTEXT NOT NULL, description LONGTEXT DEFAULT NULL, `usage` LONGTEXT DEFAULT NULL, addinfo LONGTEXT DEFAULT NULL, brand LONGTEXT DEFAULT NULL, model LONGTEXT DEFAULT NULL, chassis LONGTEXT DEFAULT NULL, motor LONGTEXT DEFAULT NULL, undef LONGTEXT DEFAULT NULL, INDEX md5 (md5), INDEX detail_name_id (detail_name_id), INDEX detail_brand_id (detail_brand_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  317.         $this->addSql('CREATE TABLE catalog_offer_price (ID INT AUTO_INCREMENT NOT NULL, md5 TINYBLOB NOT NULL, price INT NOT NULL, old_price INT NOT NULL, start_price INT NOT NULL, INDEX md5 (md5), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  318.         $this->addSql('CREATE TABLE catalog_parts_descriptions (id INT AUTO_INCREMENT NOT NULL, brand_name VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, spy_name VARCHAR(300) NOT NULL, name VARCHAR(300) NOT NULL, stock_status TINYINT(1) DEFAULT \'0\' NOT NULL, sort INT DEFAULT 1 NOT NULL, UNIQUE INDEX md5 (md5), INDEX stok_status (stock_status), INDEX sort (sort), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  319.         $this->addSql('CREATE TABLE catalog_parts_info (id INT AUTO_INCREMENT NOT NULL, catalog_id INT NOT NULL, car_mod_id INT NOT NULL, common_group_id INT NOT NULL, common_name_id INT NOT NULL, brand_id INT NOT NULL, brand_name VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, md5 TINYBLOB NOT NULL, name VARCHAR(300) NOT NULL, spy_name VARCHAR(300) NOT NULL, img_1 VARCHAR(500) NOT NULL, img_2 VARCHAR(500) NOT NULL, info VARCHAR(1000) NOT NULL, description VARCHAR(1000) DEFAULT NULL, `usage` VARCHAR(1000) DEFAULT NULL, addinfo LONGTEXT DEFAULT NULL, INDEX md5 (md5), INDEX brand_id (brand_id), INDEX catalog_id (catalog_id), INDEX img_1 (img_1), INDEX common_name_id (common_name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  320.         $this->addSql('CREATE TABLE catalog_root (id INT AUTO_INCREMENT NOT NULL, catalog_root_id INT NOT NULL, catalog_root_name VARCHAR(1000) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  321.         $this->addSql('CREATE TABLE catalog_sv_kind (sv_kind_id INT AUTO_INCREMENT NOT NULL, common_name_id INT NOT NULL, sv_kind_name VARCHAR(300) NOT NULL, sv_kind_des VARCHAR(500) NOT NULL, control VARCHAR(255) DEFAULT \'textbox\' NOT NULL, PRIMARY KEY(sv_kind_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  322.         $this->addSql('CREATE TABLE catalog_sv_val (id INT AUTO_INCREMENT NOT NULL, sv_kind_id INT NOT NULL, sv_val VARCHAR(300) NOT NULL, md5 TINYBLOB NOT NULL, INDEX sv_kind_id (sv_kind_id), INDEX sv_val (sv_val), INDEX md5 (md5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  323.         $this->addSql('CREATE TABLE catalog_tmp_sv_val (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(50) NOT NULL, value_id INT NOT NULL, value_val VARCHAR(30) NOT NULL, md5 TINYBLOB DEFAULT NULL, INDEX brand (brand), INDEX art (art), INDEX md5 (md5), INDEX value_id (value_id), INDEX value_val (value_val), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  324.         $this->addSql('CREATE TABLE changed_price_parts (id INT AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, distr_id INT NOT NULL, old_price INT NOT NULL, new_price INT NOT NULL, date DATETIME NOT NULL, INDEX part_id (part_id), INDEX distr_id (distr_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  325.         $this->addSql('CREATE TABLE check_new_route (courier_id SMALLINT NOT NULL, status_id SMALLINT NOT NULL, UNIQUE INDEX courier_id_2 (courier_id), INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  326.         $this->addSql('CREATE TABLE check_self_price_log (id INT AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, manager_id SMALLINT NOT NULL, date DATETIME NOT NULL, INDEX part_id (part_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  327.         $this->addSql('CREATE TABLE clients_orders_history (order_id INT DEFAULT 0 NOT NULL, dt DATETIME DEFAULT NULL, root_manager LONGTEXT DEFAULT NULL, parts_info LONGTEXT DEFAULT NULL, offer_parts LONGTEXT DEFAULT NULL, offer_status LONGTEXT DEFAULT NULL, offer_comments LONGTEXT DEFAULT NULL, courier_id LONGTEXT DEFAULT NULL, INDEX order_id (order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  328.         $this->addSql('CREATE TABLE clients_orders_info (order_id INT AUTO_INCREMENT NOT NULL, order_status INT NOT NULL, first_manager LONGTEXT NOT NULL, root_manager LONGTEXT NOT NULL, car_brand LONGTEXT NOT NULL, car_model LONGTEXT NOT NULL, vin_number LONGTEXT NOT NULL, parts_info LONGTEXT NOT NULL, delivery_info SMALLINT NOT NULL, clients_name LONGTEXT NOT NULL, clients_tel LONGTEXT NOT NULL, clients_address LONGTEXT NOT NULL, clients_mail LONGTEXT NOT NULL, offer_parts LONGTEXT NOT NULL, other_services_info LONGTEXT NOT NULL, courier_time LONGTEXT NOT NULL, change_status_time LONGTEXT NOT NULL, order_comment LONGTEXT NOT NULL, offer_status LONGTEXT NOT NULL, offer_comments LONGTEXT NOT NULL, client_orders_discount SMALLINT NOT NULL, courier_id VARCHAR(50) DEFAULT NULL, INDEX ind_clients_tel (clients_tel), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  329.         $this->addSql('CREATE TABLE collect_orders_statistic (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, store_date DATETIME DEFAULT NULL, collect_date DATETIME DEFAULT NULL, UNIQUE INDEX order_id_2 (order_id), INDEX store_date (store_date), INDEX collect_date (collect_date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  330.         $this->addSql('CREATE TABLE count_orders_statistic (order_id LONGTEXT NOT NULL, manager_id LONGTEXT NOT NULL, start_time_order LONGTEXT NOT NULL, end_time_order LONGTEXT NOT NULL, count_parts INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  331.         $this->addSql('CREATE TABLE courier_parts_info (id INT AUTO_INCREMENT NOT NULL, courier_id SMALLINT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, route_id INT NOT NULL, status_id SMALLINT NOT NULL, take_time DATETIME NOT NULL, get_time DATETIME NOT NULL, INDEX courier_id (courier_id), INDEX order_id (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  332.         $this->addSql('CREATE TABLE courier_ready (courier_id SMALLINT NOT NULL, status_id SMALLINT NOT NULL, UNIQUE INDEX courier_id (courier_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  333.         $this->addSql('CREATE TABLE courier_route (distributors_name LONGTEXT NOT NULL, courier_id LONGTEXT NOT NULL, time LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  334.         $this->addSql('CREATE TABLE couriers (id SMALLINT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, name VARCHAR(30) NOT NULL, pass VARCHAR(10) NOT NULL, type VARCHAR(10) NOT NULL, phone VARCHAR(12) NOT NULL, UNIQUE INDEX id_2 (id), INDEX user_id (user_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  335.         $this->addSql('CREATE TABLE couriers_fuel_rate (courier_id SMALLINT NOT NULL, rate INT NOT NULL, price DOUBLE PRECISION NOT NULL, UNIQUE INDEX courier_id (courier_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  336.         $this->addSql('CREATE TABLE couriers_routes (id INT AUTO_INCREMENT NOT NULL, route_info VARCHAR(80) NOT NULL, courier_id SMALLINT NOT NULL, time VARCHAR(10) NOT NULL, new_time DATETIME NOT NULL, status_id SMALLINT NOT NULL, create_time INT DEFAULT NULL, new_create_time DATETIME NOT NULL, INDEX create_time (create_time), INDEX status_id (status_id), INDEX new_create_time (new_create_time), INDEX courier_id (courier_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  337.         $this->addSql('CREATE TABLE couriers_routes_history (id INT AUTO_INCREMENT NOT NULL, route_info LONGTEXT NOT NULL, time LONGTEXT NOT NULL, status_id SMALLINT NOT NULL, create_time INT DEFAULT NULL, last_ofer_time INT DEFAULT NULL, base_time INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  338.         $this->addSql('CREATE TABLE couriers_speedometer_data (id INT AUTO_INCREMENT NOT NULL, courier_id SMALLINT NOT NULL, first_value INT NOT NULL, last_value INT NOT NULL, date LONGTEXT NOT NULL, new_date DATE NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  339.         $this->addSql('CREATE TABLE couriers_status (id INT AUTO_INCREMENT NOT NULL, distributors_id INT NOT NULL, courier_id LONGTEXT NOT NULL, time LONGTEXT NOT NULL, go_away_time LONGTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  340.         $this->addSql('CREATE TABLE couriers_time_limits (courier_id SMALLINT NOT NULL, plan_delivery_limit LONGTEXT NOT NULL, route_way_limit LONGTEXT NOT NULL, UNIQUE INDEX courier_id (courier_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  341.         $this->addSql('CREATE TABLE cross_base (cross_brand LONGTEXT NOT NULL, cross_orig_art LONGTEXT NOT NULL, cross_art_for_search LONGTEXT NOT NULL, cross_oem LONGTEXT NOT NULL, cross_brand_1 LONGTEXT NOT NULL, cross_art_1 LONGTEXT NOT NULL, cross_brand_2 LONGTEXT NOT NULL, cross_art_2 LONGTEXT NOT NULL, cross_brand_3 LONGTEXT NOT NULL, cross_art_3 LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  342.         $this->addSql('CREATE TABLE cur_back_baza (ID INT AUTO_INCREMENT NOT NULL, cur_id INT DEFAULT NULL, order_id INT DEFAULT NULL, stat TINYINT(1) DEFAULT NULL, dt DATETIME DEFAULT NULL, INDEX ind_st (stat), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  343.         $this->addSql('CREATE TABLE cur_delivery_times (ID INT AUTO_INCREMENT NOT NULL, cur_id INT DEFAULT NULL, addr LONGTEXT DEFAULT NULL, addr_md5 TINYBLOB DEFAULT NULL, first_time INT DEFAULT NULL, begin_time INT DEFAULT NULL, ready_time INT DEFAULT NULL, PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  344.         $this->addSql('CREATE TABLE cur_times (id INT AUTO_INCREMENT NOT NULL, cur_id INT DEFAULT NULL, route_id INT DEFAULT NULL, `from` INT DEFAULT NULL, dest INT DEFAULT NULL, first_time INT DEFAULT NULL, begin_time INT DEFAULT NULL, reach_time INT DEFAULT NULL, ready_time INT DEFAULT NULL, INDEX ind_cur (cur_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  345.         $this->addSql('CREATE TABLE debt_status (distributor_id INT NOT NULL, status INT NOT NULL, INDEX status (status), PRIMARY KEY(distributor_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  346.         $this->addSql('CREATE TABLE delete_orders (order_id INT AUTO_INCREMENT NOT NULL, order_status LONGTEXT NOT NULL, first_manager LONGTEXT NOT NULL, root_manager LONGTEXT NOT NULL, car_brand LONGTEXT NOT NULL, car_model LONGTEXT NOT NULL, vin_number LONGTEXT NOT NULL, parts_info LONGTEXT NOT NULL, delivery_info SMALLINT NOT NULL, clients_name LONGTEXT NOT NULL, clients_tel LONGTEXT NOT NULL, clients_address LONGTEXT NOT NULL, clients_mail LONGTEXT NOT NULL, offer_parts LONGTEXT NOT NULL, other_services_info LONGTEXT NOT NULL, courier_time LONGTEXT NOT NULL, change_status_time LONGTEXT NOT NULL, offer_status LONGTEXT NOT NULL, offer_comments LONGTEXT NOT NULL, PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  347.         $this->addSql('CREATE TABLE delivery (id SMALLINT NOT NULL, name LONGTEXT NOT NULL, price INT NOT NULL, UNIQUE INDEX id (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  348.         $this->addSql('CREATE TABLE delivery_info (id INT AUTO_INCREMENT NOT NULL, new_order_id INT NOT NULL, plan_route_id INT NOT NULL, delivery_status SMALLINT NOT NULL, cashier_status SMALLINT NOT NULL, date DATETIME NOT NULL, grid_key INT NOT NULL, grid_date DATE NOT NULL, grid_delivery_time DATETIME NOT NULL, INDEX new_order_id (new_order_id), INDEX plan_route_id (plan_route_id), INDEX cashier_status (cashier_status), INDEX delivery_status (delivery_status), INDEX grid_key (grid_key), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  349.         $this->addSql('CREATE TABLE delivery_plan_info (id INT AUTO_INCREMENT NOT NULL, address LONGTEXT NOT NULL, status_id SMALLINT NOT NULL, order_id INT NOT NULL, new_order_id INT NOT NULL, UNIQUE INDEX id (id), INDEX status_id (status_id), INDEX order_id (order_id), INDEX new_order_id (new_order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  350.         $this->addSql('CREATE TABLE delivery_route_info (courier_id SMALLINT NOT NULL, delivery_address LONGTEXT NOT NULL, install_date LONGTEXT NOT NULL, new_install_date DATETIME NOT NULL, roughly_time LONGTEXT NOT NULL, new_roughly_time DATETIME NOT NULL, UNIQUE INDEX courier_id (courier_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  351.         $this->addSql('CREATE TABLE detail_brand (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(100) DEFAULT NULL, disp VARCHAR(100) NOT NULL, country VARCHAR(100) NOT NULL, info LONGTEXT NOT NULL, advantage LONGTEXT NOT NULL, rus LONGTEXT NOT NULL, logo LONGTEXT NOT NULL, kind INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  352.         $this->addSql('CREATE TABLE detail_name (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, weight DOUBLE PRECISION NOT NULL, max_weight DOUBLE PRECISION NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  353.         $this->addSql('CREATE TABLE detail_name_alternative (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(100) DEFAULT NULL, detail_name_id INT UNSIGNED DEFAULT NULL, INDEX detail_name_id (detail_name_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  354.         $this->addSql('CREATE TABLE dict_father_names (fname_id INT AUTO_INCREMENT NOT NULL, fname VARCHAR(50) DEFAULT NULL, tmp TINYINT(1) DEFAULT \'0\' NOT NULL, INDEX fname (fname), PRIMARY KEY(fname_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  355.         $this->addSql('CREATE TABLE dict_names (name_id INT AUTO_INCREMENT NOT NULL, name VARCHAR(30) DEFAULT NULL, tmp TINYINT(1) DEFAULT \'0\' NOT NULL, INDEX name (name), PRIMARY KEY(name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  356.         $this->addSql('CREATE TABLE distributors_brands_syn (id INT AUTO_INCREMENT NOT NULL, distr_id INT NOT NULL, origin_brand VARCHAR(50) NOT NULL, system_brand VARCHAR(50) NOT NULL, INDEX distr_id (distr_id), INDEX origin_brand (origin_brand), INDEX system_brand (system_brand), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  357.         $this->addSql('CREATE TABLE distributors_ftp_settings (id INT AUTO_INCREMENT NOT NULL, distr_id INT NOT NULL, ftp_type VARCHAR(20) NOT NULL, input_host VARCHAR(50) NOT NULL, input_port VARCHAR(20) NOT NULL, input_login VARCHAR(100) NOT NULL, input_pass VARCHAR(50) NOT NULL, output_host VARCHAR(50) NOT NULL, output_port VARCHAR(20) NOT NULL, output_login VARCHAR(100) NOT NULL, output_pass VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  358.         $this->addSql('CREATE TABLE distributors_info (id SMALLINT NOT NULL, distributors_id INT NOT NULL, 1c_code VARCHAR(20) NOT NULL, distributors_name LONGTEXT NOT NULL, urname VARCHAR(1000) NOT NULL, day_1 LONGTEXT NOT NULL, day_2 LONGTEXT NOT NULL, day_3 LONGTEXT NOT NULL, day_4 LONGTEXT NOT NULL, day_5 LONGTEXT NOT NULL, day_6 LONGTEXT NOT NULL, day_0 LONGTEXT NOT NULL, couriers_info LONGTEXT NOT NULL, storemanager_info LONGTEXT NOT NULL, status_id SMALLINT DEFAULT \'1\' NOT NULL, skype_contact LONGTEXT NOT NULL, tel_contact LONGTEXT NOT NULL, storemanager_tel_contact LONGTEXT NOT NULL, buh_tel_contact VARCHAR(200) NOT NULL, email VARCHAR(150) DEFAULT \'\', get_address VARCHAR(200) NOT NULL, INDEX distributors_id (distributors_id), INDEX status_id (status_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  359.         $this->addSql('CREATE TABLE distributors_price_settings (id INT AUTO_INCREMENT NOT NULL, distr_id INT NOT NULL, file_type VARCHAR(10) NOT NULL, name_mask VARCHAR(50) NOT NULL, name_mask_flag INT NOT NULL, brand_field INT NOT NULL, art_field INT NOT NULL, info_field INT NOT NULL, num_field INT NOT NULL, price_field INT NOT NULL, brand_field_xml_title VARCHAR(50) NOT NULL, art_field_xml_title VARCHAR(50) NOT NULL, info_field_xml_title VARCHAR(50) NOT NULL, num_field_xml_title VARCHAR(50) NOT NULL, price_field_xml_title VARCHAR(50) NOT NULL, ignore_field_xml_title VARCHAR(50) NOT NULL, ignore_field_xml_value VARCHAR(50) NOT NULL, tag_name VARCHAR(50) NOT NULL, enable TINYINT(1) NOT NULL, INDEX distr_id (distr_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  360.         $this->addSql('CREATE TABLE distributors_send_mail (id INT AUTO_INCREMENT NOT NULL, distr_id INT NOT NULL, email VARCHAR(100) NOT NULL, date DATETIME NOT NULL, INDEX distr_id (distr_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  361.         $this->addSql('CREATE TABLE distributors_status (status_id SMALLINT NOT NULL, info LONGTEXT NOT NULL, color LONGTEXT NOT NULL, INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  362.         $this->addSql('CREATE TABLE distributors_visit_statistic (id INT UNSIGNED AUTO_INCREMENT NOT NULL, distributors_id INT NOT NULL, visit_time DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  363.         $this->addSql('CREATE TABLE error_log_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, informs_manager INT NOT NULL, report_id SMALLINT NOT NULL, date DATETIME NOT NULL, INDEX order_id (order_id), INDEX report_id (report_id), INDEX part_id (part_id), INDEX informs_manager (informs_manager), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  364.         $this->addSql('CREATE TABLE error_status (status_id SMALLINT NOT NULL, info VARCHAR(50) NOT NULL, color VARCHAR(10) NOT NULL, UNIQUE INDEX status_id (status_id), INDEX info (info), INDEX color (color)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  365.         $this->addSql('CREATE TABLE exceed_orders_time (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, distributor_id SMALLINT NOT NULL, time LONGTEXT NOT NULL, INDEX id (id, order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  366.         $this->addSql('CREATE TABLE faq_news (id INT AUTO_INCREMENT NOT NULL, date DATETIME NOT NULL, title VARCHAR(200) NOT NULL, content VARCHAR(500) NOT NULL, system_id INT NOT NULL, status_id INT NOT NULL, INDEX title (title), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  367.         $this->addSql('CREATE TABLE farpost_price (id INT UNSIGNED AUTO_INCREMENT NOT NULL, brand VARCHAR(30) DEFAULT NULL, art VARCHAR(60) DEFAULT NULL, price DOUBLE PRECISION DEFAULT NULL, descr LONGTEXT DEFAULT NULL, name LONGTEXT DEFAULT NULL, oem VARCHAR(120) DEFAULT NULL, `usage` LONGTEXT DEFAULT NULL, replacement LONGTEXT DEFAULT NULL, photo VARCHAR(512) DEFAULT NULL, md5brandart TINYBLOB DEFAULT NULL, INDEX brand (brand), INDEX art (art), INDEX oem (oem), INDEX md5brandart (md5brandart), FULLTEXT INDEX replacement (replacement), FULLTEXT INDEX `usage` (`usage`), FULLTEXT INDEX descr (descr), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  368.         $this->addSql('CREATE TABLE farpost_price_history (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(50) NOT NULL, pro_id INT NOT NULL, dist_price INT NOT NULL, sell_price INT NOT NULL, count INT NOT NULL, date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, md5 TINYBLOB NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  369.         $this->addSql('CREATE TABLE fixed_prices (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(100) NOT NULL, art VARCHAR(100) NOT NULL, price INT NOT NULL, distr_id INT NOT NULL, date DATETIME NOT NULL, INDEX brand (brand), INDEX art (art), INDEX distr_id (distr_id), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  370.         $this->addSql('CREATE TABLE ftp_accounts (id INT AUTO_INCREMENT NOT NULL, ip VARCHAR(15) NOT NULL, login VARCHAR(50) NOT NULL, pass VARCHAR(50) NOT NULL, status_id INT DEFAULT 1 NOT NULL, INDEX status_id (status_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  371.         $this->addSql('CREATE TABLE garanty_error_log_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, status_id SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  372.         $this->addSql('CREATE TABLE garanty_sto (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, sort INT NOT NULL, INDEX user_id (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  373.         $this->addSql('CREATE TABLE getback_status (id INT NOT NULL, name VARCHAR(50) NOT NULL, color VARCHAR(50) NOT NULL, UNIQUE INDEX id (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  374.         $this->addSql('CREATE TABLE indicator_values (id INT UNSIGNED AUTO_INCREMENT NOT NULL, indicator_id INT UNSIGNED NOT NULL, type VARCHAR(255) DEFAULT \'not_less\' NOT NULL, value INT NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, INDEX indicator_id (indicator_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  375.         $this->addSql('CREATE TABLE indicators (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  376.         $this->addSql('CREATE TABLE install_point_table (id INT AUTO_INCREMENT NOT NULL, distributor_id SMALLINT NOT NULL, UNIQUE INDEX distributor_id (distributor_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  377.         $this->addSql('CREATE TABLE invoices (id INT UNSIGNED AUTO_INCREMENT NOT NULL, provider_id INT NOT NULL, creation_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, invoice_date DATETIME DEFAULT \'0000-00-00 00:00:00\' NOT NULL, send_date DATETIME DEFAULT NULL, INDEX provider_id (provider_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  378.         $this->addSql('CREATE TABLE invoices_custom_parts (id INT UNSIGNED AUTO_INCREMENT NOT NULL, invoice_id INT UNSIGNED NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(50) NOT NULL, name VARCHAR(300) NOT NULL, price DOUBLE PRECISION DEFAULT \'0\' NOT NULL, amount INT UNSIGNED DEFAULT 0 NOT NULL, INDEX invoice_id (invoice_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  379.         $this->addSql('CREATE TABLE invoices_parts (id INT UNSIGNED AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, invoice_id INT UNSIGNED NOT NULL, order_date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, price DOUBLE PRECISION DEFAULT \'0\' NOT NULL, UNIQUE INDEX part_id (part_id), INDEX invoice_id (invoice_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  380.         $this->addSql('CREATE TABLE japancar_cache_data (id INT UNSIGNED AUTO_INCREMENT NOT NULL, id_info INT UNSIGNED NOT NULL, url VARCHAR(300) NOT NULL, small_img LONGTEXT DEFAULT NULL, car_info_body VARCHAR(100) DEFAULT NULL, car_info_engine VARCHAR(100) DEFAULT NULL, stuff LONGTEXT DEFAULT NULL, firm VARCHAR(100) DEFAULT NULL, detail VARCHAR(100) DEFAULT NULL, price VARCHAR(100) DEFAULT NULL, INDEX id_info (id_info), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  381.         $this->addSql('CREATE TABLE japancar_cache_info (id INT UNSIGNED AUTO_INCREMENT NOT NULL, detail_code VARCHAR(100) NOT NULL, brand VARCHAR(100) DEFAULT NULL, model VARCHAR(100) DEFAULT NULL, page INT UNSIGNED NOT NULL, last_update DATE NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  382.         $this->addSql('CREATE TABLE japancar_datail_name (id VARCHAR(100) NOT NULL, name VARCHAR(100) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  383.         $this->addSql('CREATE TABLE kpi (id INT UNSIGNED AUTO_INCREMENT NOT NULL, system VARCHAR(100) NOT NULL, name VARCHAR(200) NOT NULL, INDEX system (system), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  384.         $this->addSql('CREATE TABLE kpi_values (id INT UNSIGNED AUTO_INCREMENT NOT NULL, indicator_id INT UNSIGNED NOT NULL, type VARCHAR(255) DEFAULT \'not_less\' NOT NULL, value INT NOT NULL, start_date DATE NOT NULL, end_date DATE NOT NULL, INDEX indicator_id (indicator_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  385.         $this->addSql('CREATE TABLE load_lookup_log (id INT AUTO_INCREMENT NOT NULL, dt DATETIME DEFAULT NULL, seq_art_id INT DEFAULT NULL, seq_gr_id INT DEFAULT NULL, fname VARCHAR(50) DEFAULT NULL, stat INT DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  386.         $this->addSql('CREATE TABLE logistic_alarm (id INT AUTO_INCREMENT NOT NULL, parts_num INT NOT NULL, delivery_num INT NOT NULL, INDEX old_parts_num (parts_num), INDEX delivery_num (delivery_num), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  387.         $this->addSql('CREATE TABLE logistic_error_log_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, status_id SMALLINT NOT NULL, route_id INT NOT NULL, INDEX part_id (part_id), INDEX order_id (order_id), INDEX status_id (status_id), INDEX route_id (route_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  388.         $this->addSql('CREATE TABLE logistic_stat (id INT UNSIGNED AUTO_INCREMENT NOT NULL, order_id INT DEFAULT NULL, time1 INT DEFAULT NULL, time2 INT DEFAULT NULL, INDEX order_id (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  389.         $this->addSql('CREATE TABLE lookup (ID INT AUTO_INCREMENT NOT NULL, brand_name LONGTEXT DEFAULT NULL, art LONGTEXT DEFAULT NULL, art_disp LONGTEXT DEFAULT NULL, art_id INT DEFAULT NULL, art_bra_md5 TINYBLOB NOT NULL, INDEX in_art (art), INDEX in_art_id (art_id), INDEX in_s_md5 (art_bra_md5), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  390.         $this->addSql('CREATE TABLE main_page_offer (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, info LONGTEXT NOT NULL, `use` LONGTEXT NOT NULL, price LONGTEXT NOT NULL, img LONGTEXT NOT NULL, pcode LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  391.         $this->addSql('CREATE TABLE manager_actions_log (ID INT AUTO_INCREMENT NOT NULL, ORDER_ID INT DEFAULT NULL, MANAGER_ID INT DEFAULT NULL, DT DATETIME DEFAULT NULL, `DESC` LONGTEXT DEFAULT NULL, INDEX IN_ORDER_ID (ORDER_ID), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  392.         $this->addSql('CREATE TABLE new_courier_status (id INT AUTO_INCREMENT NOT NULL, route_id INT NOT NULL, distributor_id SMALLINT NOT NULL, courier_id SMALLINT NOT NULL, status_id SMALLINT NOT NULL, INDEX id (id, route_id), INDEX route_id (route_id), INDEX distributor_id (distributor_id), INDEX courier_id (courier_id), INDEX status_id (status_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  393.         $this->addSql('CREATE TABLE new_delivery_route_info (id INT AUTO_INCREMENT NOT NULL, courier_id SMALLINT NOT NULL, plan_route_id INT NOT NULL, address LONGTEXT NOT NULL, status_id SMALLINT NOT NULL, install_time DATETIME NOT NULL, roughly_time DATETIME NOT NULL, end_delivery_time DATETIME NOT NULL, INDEX courier_id (courier_id), INDEX status_id (status_id), INDEX plan_route_id (plan_route_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  394.         $this->addSql('CREATE TABLE new_route_way_time (id INT AUTO_INCREMENT NOT NULL, route_point_1 INT NOT NULL, route_point_2 INT NOT NULL, time INT NOT NULL, INDEX route_point_1 (route_point_1), INDEX route_point_2 (route_point_2), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  395.         $this->addSql('CREATE TABLE offer_orders_contractors (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(300) NOT NULL, tel VARCHAR(20) NOT NULL, address VARCHAR(300) NOT NULL, discount VARCHAR(5) NOT NULL, delivery_id INT NOT NULL, delivery_price INT NOT NULL, 1c_code VARCHAR(30) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  396.         $this->addSql('CREATE TABLE offer_parts_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, new_order_id INT NOT NULL, part_num SMALLINT NOT NULL, new_part_id INT NOT NULL, status_id SMALLINT NOT NULL, time VARCHAR(20) NOT NULL, date DATETIME NOT NULL, days_count INT NOT NULL, distr_id INT NOT NULL, emex_distr VARCHAR(10) NOT NULL, view_status INT DEFAULT 1 NOT NULL, INDEX order_id (order_id), INDEX new_order_id (new_order_id), INDEX status_id (status_id), INDEX date (date), INDEX new_part_id (new_part_id), INDEX distr_id (distr_id), INDEX view_status (view_status), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  397.         $this->addSql('CREATE TABLE offer_status (status_id SMALLINT NOT NULL, info LONGTEXT NOT NULL, color LONGTEXT NOT NULL, UNIQUE INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  398.         $this->addSql('CREATE TABLE offer_view (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, count INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  399.         $this->addSql('CREATE TABLE oil_scheme_data (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(200) NOT NULL, model VARCHAR(200) NOT NULL, chassis VARCHAR(200) NOT NULL, year VARCHAR(200) DEFAULT NULL, motor_number VARCHAR(200) DEFAULT NULL, motor_volume VARCHAR(200) DEFAULT NULL, motor_transmission VARCHAR(200) DEFAULT NULL, oil_volume VARCHAR(200) DEFAULT NULL, oil_filters VARCHAR(200) DEFAULT NULL, oil_SAE VARCHAR(200) DEFAULT NULL, oil_API VARCHAR(200) DEFAULT NULL, mkp_volume VARCHAR(200) DEFAULT NULL, mkp_oil VARCHAR(200) DEFAULT NULL, akp_volume VARCHAR(200) DEFAULT NULL, akp_volume_for_change VARCHAR(200) DEFAULT NULL, akp_oil VARCHAR(200) DEFAULT NULL, rkp_volume VARCHAR(200) DEFAULT NULL, rkp_oil VARCHAR(200) DEFAULT NULL, diff_forward_volume VARCHAR(200) DEFAULT NULL, diff_forward_oil VARCHAR(200) DEFAULT NULL, diff_back_volume VARCHAR(200) DEFAULT NULL, diff_back_oil VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  400.         $this->addSql('CREATE TABLE order_client_status (status_id SMALLINT NOT NULL, info LONGTEXT NOT NULL, color LONGTEXT NOT NULL, UNIQUE INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  401.         $this->addSql('CREATE TABLE order_sources (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(50) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  402.         $this->addSql('CREATE TABLE order_statistic (id LONGTEXT NOT NULL, date LONGTEXT NOT NULL, manager LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  403.         $this->addSql('CREATE TABLE order_status (status_id SMALLINT NOT NULL, info VARCHAR(25) NOT NULL, color VARCHAR(10) NOT NULL, UNIQUE INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  404.         $this->addSql('CREATE TABLE orders_clients_info (order_id INT UNSIGNED NOT NULL, id INT AUTO_INCREMENT NOT NULL, clients_name VARCHAR(1000) DEFAULT NULL, clients_first_name VARCHAR(1000) DEFAULT NULL, clients_second_name VARCHAR(1000) DEFAULT NULL, clients_father_name VARCHAR(1000) DEFAULT NULL, clients_tel VARCHAR(15) DEFAULT NULL, clients_tel2 VARCHAR(15) DEFAULT NULL, clients_address VARCHAR(200) DEFAULT NULL, region_id INT DEFAULT 1 NOT NULL, clients_city VARCHAR(100) DEFAULT NULL, clients_street VARCHAR(100) DEFAULT NULL, clients_house VARCHAR(20) DEFAULT NULL, clients_floor VARCHAR(20) DEFAULT NULL, other_delivery_info VARCHAR(500) DEFAULT NULL, clients_mail VARCHAR(100) DEFAULT NULL, car_brand VARCHAR(50) DEFAULT NULL, car_model VARCHAR(50) DEFAULT NULL, car_vin VARCHAR(30) DEFAULT NULL, clients_id INT DEFAULT NULL, INDEX id (id), INDEX indx_tel (clients_tel), INDEX clients_tel2 (clients_tel2), INDEX clients_id (clients_id), INDEX region_id (region_id), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  405.         $this->addSql('CREATE TABLE orders_clients_info_tmp (order_id INT UNSIGNED NOT NULL, id INT AUTO_INCREMENT NOT NULL, clients_name LONGTEXT NOT NULL, clients_first_name VARCHAR(100) NOT NULL, clients_second_name VARCHAR(100) NOT NULL, clients_father_name VARCHAR(100) NOT NULL, clients_tel VARCHAR(15) NOT NULL, clients_tel2 VARCHAR(15) NOT NULL, clients_address LONGTEXT NOT NULL, region_id INT DEFAULT 1 NOT NULL, clients_city LONGTEXT NOT NULL, clients_street LONGTEXT NOT NULL, clients_house LONGTEXT NOT NULL, clients_floor LONGTEXT NOT NULL, other_delivery_info LONGTEXT NOT NULL, clients_mail LONGTEXT NOT NULL, car_brand LONGTEXT NOT NULL, car_model LONGTEXT NOT NULL, car_vin LONGTEXT NOT NULL, clients_id INT DEFAULT NULL, INDEX id (id), INDEX indx_tel (clients_tel), INDEX clients_tel2 (clients_tel2), INDEX region_id (region_id), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  406.         $this->addSql('CREATE TABLE orders_comments (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, manager_id INT NOT NULL, comment VARCHAR(500) NOT NULL, self_comment VARCHAR(500) NOT NULL, date DATETIME NOT NULL, INDEX order_id (order_id, manager_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  407.         $this->addSql('CREATE TABLE orders_delivery_info (id INT AUTO_INCREMENT NOT NULL, order_id INT UNSIGNED NOT NULL, delivery_id SMALLINT NOT NULL, tk_id SMALLINT NOT NULL, delivery_price INT NOT NULL, tk_price INT NOT NULL, other_delivery_info LONGTEXT NOT NULL, delivery_variant INT NOT NULL, tk_variant INT DEFAULT 1 NOT NULL, danger_cargo INT NOT NULL, region_id INT DEFAULT 1 NOT NULL, print_status INT NOT NULL, package_type INT NOT NULL, INDEX order_id (order_id), INDEX tk_id (tk_id), INDEX tk_variant (tk_variant), INDEX delivery_id (delivery_id), INDEX region_id (region_id), INDEX danger_cargo (danger_cargo), INDEX print_status (print_status), INDEX package_type (package_type), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  408.         $this->addSql('CREATE TABLE orders_error_log (id INT AUTO_INCREMENT NOT NULL, manager_id INT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, error_status INT NOT NULL, dat DATETIME NOT NULL, INDEX manager_id (manager_id), INDEX order_id (order_id), INDEX part_id (part_id), INDEX error_status (error_status), INDEX dat (dat), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  409.         $this->addSql('CREATE TABLE orders_error_log_history (manager_id INT NOT NULL, order_id INT NOT NULL, part_id INT NOT NULL, error_status INT NOT NULL, dat DATETIME NOT NULL, INDEX manager_id (manager_id), INDEX order_id (order_id), INDEX part_id (part_id), INDEX error_status (error_status), INDEX dat (dat)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  410.         $this->addSql('CREATE TABLE orders_getback_parts (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, store_order_id INT NOT NULL, part_id INT NOT NULL, parts_num INT DEFAULT 1 NOT NULL, distributor_id INT NOT NULL, manager_id INT NOT NULL, root_manager_id INT NOT NULL, margin_manager_id INT NOT NULL, status_id INT NOT NULL, manager_comment VARCHAR(300) NOT NULL, manager_comment_key INT NOT NULL, cashier_comment VARCHAR(300) NOT NULL, margin INT NOT NULL, tk_price INT NOT NULL, review_status INT NOT NULL, cashier_work_status INT NOT NULL, date DATETIME NOT NULL, INDEX status_id (status_id), INDEX date (date), INDEX part_id (part_id), INDEX order_id (order_id), INDEX manager_comment (manager_comment), INDEX distributor_id (distributor_id), INDEX root_manager_id (root_manager_id), INDEX margin_manager_id (margin_manager_id), INDEX review_status (review_status), INDEX store_order_id (store_order_id), INDEX manager_id (manager_id), INDEX manager_comment_key (manager_comment_key), INDEX cashier_work_status (cashier_work_status), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  411.         $this->addSql('CREATE TABLE orders_link (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, link_order_id INT NOT NULL, INDEX order_id (order_id), INDEX link_order_id (link_order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  412.         $this->addSql('CREATE TABLE orders_list (id INT AUTO_INCREMENT NOT NULL, start_date DATETIME NOT NULL, inner_status SMALLINT NOT NULL, order_discount INT NOT NULL, end_logistic_time DATETIME NOT NULL, confirm_status INT DEFAULT 1 NOT NULL, xml_status INT NOT NULL, xml_send INT NOT NULL, xml_send_date DATETIME NOT NULL, payed_status INT NOT NULL, comment VARCHAR(500) NOT NULL, self_comment VARCHAR(500) NOT NULL, visited_time DATETIME NOT NULL, INDEX end_logistic_time (end_logistic_time), INDEX inner_status (inner_status), INDEX order_discount (order_discount), INDEX confirm_status (confirm_status), INDEX xml_status (xml_status), INDEX visited_time (visited_time), INDEX xml_send (xml_send), INDEX xml_send_date (xml_send_date), INDEX payed_status (payed_status), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  413.         $this->addSql('CREATE TABLE orders_logistic_info (id INT AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, route_id INT DEFAULT NULL, recomended_time DATETIME NOT NULL, INDEX part_id (part_id), INDEX route_id (route_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  414.         $this->addSql('CREATE TABLE orders_managers (order_id INT UNSIGNED NOT NULL, first_manager INT NOT NULL, root_manager INT DEFAULT NULL, work_manager INT DEFAULT NULL, site_manager INT DEFAULT NULL, pass_manager INT DEFAULT NULL, INDEX first_manager (first_manager), INDEX root_manager (root_manager), INDEX work_manager (work_manager), INDEX site_manager (site_manager), INDEX pass_manager (pass_manager), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  415.         $this->addSql('CREATE TABLE orders_managers_history (order_id INT NOT NULL, first_manager SMALLINT DEFAULT NULL, root_manager INT NOT NULL, work_manager INT NOT NULL, change_status_time DATETIME NOT NULL, INDEX order_id (order_id), INDEX first_manager (first_manager), INDEX root_manager (root_manager), INDEX work_manager (work_manager), INDEX change_status_time (change_status_time)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  416.         $this->addSql('CREATE TABLE orders_offer_list (id INT AUTO_INCREMENT NOT NULL, status_id INT NOT NULL, contractor INT NOT NULL, date DATETIME NOT NULL, INDEX status_id (status_id), INDEX contractor (contractor), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  417.         $this->addSql('CREATE TABLE orders_offer_parts_info (id INT AUTO_INCREMENT NOT NULL, order_id INT UNSIGNED NOT NULL, parts_name LONGTEXT NOT NULL, parts_num SMALLINT NOT NULL, parts_status SMALLINT DEFAULT \'11\' NOT NULL, parts_comment VARCHAR(200) NOT NULL, other_info VARCHAR(100) NOT NULL, offer_distributors_id SMALLINT DEFAULT NULL, offer_brand VARCHAR(100) NOT NULL, oem_art VARCHAR(100) NOT NULL, offer_art VARCHAR(100) NOT NULL, start_price INT NOT NULL, offer_price INT NOT NULL, offer_discount INT NOT NULL, date DATETIME NOT NULL, INDEX indx_order_id (order_id), INDEX indx_art (offer_art), INDEX parts_status (parts_status), INDEX offer_distributors_id (offer_distributors_id), INDEX oem_art (oem_art), INDEX offer_brand (offer_brand), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  418.         $this->addSql('CREATE TABLE orders_parts_history (id INT NOT NULL, dt DATETIME DEFAULT NULL, manager_id INT DEFAULT NULL, courier_id INT DEFAULT NULL, order_id INT UNSIGNED NOT NULL, parts_name VARCHAR(300) NOT NULL, parts_num SMALLINT NOT NULL, parts_status SMALLINT NOT NULL, parts_comment LONGTEXT NOT NULL, parts_common_name_id INT NOT NULL, offer_distributors_id SMALLINT DEFAULT NULL, offer_brand VARCHAR(50) NOT NULL, oem_art VARCHAR(50) NOT NULL, offer_art VARCHAR(50) NOT NULL, start_price INT NOT NULL, offer_price INT NOT NULL, offer_discount INT NOT NULL, check_rating INT NOT NULL, garanty_period INT NOT NULL, garanty_mileage INT NOT NULL, date DATETIME NOT NULL, INDEX id (id), INDEX indx_order_id (order_id), INDEX offer_brand (offer_brand), INDEX offer_art (offer_art)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  419.         $this->addSql('CREATE TABLE orders_parts_info (id INT AUTO_INCREMENT NOT NULL, order_id INT UNSIGNED NOT NULL, parts_name VARCHAR(300) NOT NULL, parts_num SMALLINT NOT NULL, parts_status SMALLINT NOT NULL, parts_comment VARCHAR(300) NOT NULL, parts_comment_contract VARCHAR(1000) NOT NULL, parts_comment_sto VARCHAR(1000) NOT NULL, parts_common_name_id INT NOT NULL, offer_distributors_id SMALLINT DEFAULT NULL, offer_brand VARCHAR(50) NOT NULL, oem_art VARCHAR(50) NOT NULL, offer_art VARCHAR(50) NOT NULL, start_price INT NOT NULL, offer_price INT NOT NULL, offer_discount INT NOT NULL, check_rating INT NOT NULL, garanty_period INT NOT NULL, garanty_mileage INT NOT NULL, weight DOUBLE PRECISION NOT NULL, date DATETIME NOT NULL, parts_manager INT DEFAULT NULL, INDEX indx_order_id (order_id), INDEX parts_status (parts_status), INDEX offer_distributors_id (offer_distributors_id), INDEX offer_art (offer_art), INDEX offer_brand (offer_brand), INDEX parts_common_name_id (parts_common_name_id), INDEX check_rating (check_rating), INDEX parts_manager (parts_manager), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  420.         $this->addSql('CREATE TABLE orders_prices (order_id INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, UNIQUE INDEX order_id (order_id), INDEX price (price), INDEX date (date)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  421.         $this->addSql('CREATE TABLE orders_root_status (order_id INT UNSIGNED NOT NULL, status_id SMALLINT NOT NULL, change_status_time DATETIME NOT NULL, INDEX status_id (status_id), INDEX change_status_time (change_status_time), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  422.         $this->addSql('CREATE TABLE orders_status_history (order_id INT NOT NULL, status_id SMALLINT NOT NULL, manager_id INT NOT NULL, change_status_time DATETIME NOT NULL, change_date DATETIME NOT NULL, INDEX order_id (order_id), INDEX status_id (status_id), INDEX manager_id (manager_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  423.         $this->addSql('CREATE TABLE pages (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(50) NOT NULL, text LONGTEXT NOT NULL, date DATETIME NOT NULL, INDEX title (title), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  424.         $this->addSql('CREATE TABLE paid_orders (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, status_id SMALLINT NOT NULL, change_status_time DATETIME NOT NULL, UNIQUE INDEX order_id (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  425.         $this->addSql('CREATE TABLE parts_base (main_brand LONGTEXT NOT NULL, main_art LONGTEXT NOT NULL, `group` LONGTEXT NOT NULL, info LONGTEXT NOT NULL, mark LONGTEXT NOT NULL, model LONGTEXT NOT NULL, engine LONGTEXT NOT NULL, body LONGTEXT NOT NULL, year LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  426.         $this->addSql('CREATE TABLE parts_history (id INT UNSIGNED AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, type VARCHAR(255) NOT NULL, date DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, value VARCHAR(250) NOT NULL, INDEX part_id (part_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  427.         $this->addSql('CREATE TABLE parts_name (name LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  428.         $this->addSql('CREATE TABLE poll_info (id SMALLINT AUTO_INCREMENT NOT NULL, title LONGTEXT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  429.         $this->addSql('CREATE TABLE poll_statistic (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, new_order_id INT NOT NULL, clients_tel LONGTEXT NOT NULL, poll_id SMALLINT NOT NULL, INDEX id (id, order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  430.         $this->addSql('CREATE TABLE pre_add_lookup (n INT DEFAULT NULL, bra LONGTEXT DEFAULT NULL, disp VARCHAR(50) DEFAULT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  431.         $this->addSql('CREATE TABLE price (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, price INT NOT NULL, `use` LONGTEXT NOT NULL, info LONGTEXT NOT NULL, oem LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  432.         $this->addSql('CREATE TABLE price_bad (ID INT AUTO_INCREMENT NOT NULL, brand_name VARCHAR(30) NOT NULL, brand_id INT DEFAULT NULL, art VARCHAR(50) DEFAULT NULL, art_disp VARCHAR(50) DEFAULT NULL, price INT DEFAULT NULL, info VARCHAR(300) DEFAULT NULL, pro_id INT NOT NULL, num INT DEFAULT NULL, ART_BRA_MD5 TINYBLOB NOT NULL, common_name_id INT NOT NULL, weight DOUBLE PRECISION NOT NULL, weight_type INT NOT NULL, INDEX brand_name (brand_name), INDEX brand_id (brand_id), INDEX art (art), INDEX num (num), INDEX ART_BRA_MD5 (ART_BRA_MD5), INDEX common_name_id (common_name_id), INDEX weight_type (weight_type), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  433.         $this->addSql('CREATE TABLE price_bad_5 (ID INT AUTO_INCREMENT NOT NULL, brand_name VARCHAR(30) NOT NULL, brand_id INT DEFAULT NULL, art VARCHAR(50) DEFAULT NULL, art_disp VARCHAR(50) DEFAULT NULL, price INT DEFAULT NULL, info VARCHAR(300) DEFAULT NULL, num INT DEFAULT NULL, ART_BRA_MD5 TINYBLOB NOT NULL, INDEX in_s_md5 (ART_BRA_MD5), INDEX brand_name (brand_name), INDEX brand_id (brand_id), INDEX art (art), INDEX num (num), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  434.         $this->addSql('CREATE TABLE price_bad_delete_log (ID INT AUTO_INCREMENT NOT NULL, brand_name VARCHAR(30) NOT NULL, brand_id INT DEFAULT NULL, art VARCHAR(50) DEFAULT NULL, art_disp VARCHAR(50) DEFAULT NULL, price INT DEFAULT NULL, info VARCHAR(300) DEFAULT NULL, num INT DEFAULT NULL, ART_BRA_MD5 TINYBLOB NOT NULL, delete_time DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL, INDEX in_s_md5 (ART_BRA_MD5), INDEX brand_name (brand_name), INDEX brand_id (brand_id), INDEX art (art), INDEX num (num), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  435.         $this->addSql('CREATE TABLE price_farpost (ID INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(50) NOT NULL, art_disp VARCHAR(50) NOT NULL, price INT NOT NULL, old_price INT NOT NULL, info LONGTEXT NOT NULL, provider VARCHAR(50) NOT NULL, num INT NOT NULL, ART_BRA_MD5 TINYBLOB NOT NULL, INDEX in_s_md5 (ART_BRA_MD5), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  436.         $this->addSql('CREATE TABLE price_farpost_min_pr (brand LONGTEXT DEFAULT NULL, art LONGTEXT DEFAULT NULL, info LONGTEXT DEFAULT NULL, min_price INT DEFAULT NULL, num INT DEFAULT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  437.         $this->addSql('CREATE TABLE price_farpost_onsite (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, info LONGTEXT NOT NULL, price INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  438.         $this->addSql('CREATE TABLE price_farpost_out (ID INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, brand_id INT NOT NULL, art VARCHAR(50) NOT NULL, art_disp VARCHAR(50) NOT NULL, price INT NOT NULL, old_price INT NOT NULL, start_price INT NOT NULL, info LONGTEXT NOT NULL, oem VARCHAR(1000) NOT NULL, analog VARCHAR(1000) NOT NULL, `usage` VARCHAR(1000) NOT NULL, provider VARCHAR(50) NOT NULL, num INT NOT NULL, md5 TINYBLOB NOT NULL, weight DOUBLE PRECISION DEFAULT \'0\' NOT NULL, common_name_id INT NOT NULL, img VARCHAR(500) NOT NULL, price_source INT NOT NULL, INDEX md5 (md5), INDEX brand (brand), INDEX art (art), INDEX art_disp (art_disp), INDEX provider (provider), INDEX common_name_id (common_name_id), INDEX price_source (price_source), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  439.         $this->addSql('CREATE TABLE price_farpost_ready (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, price INT NOT NULL, `use` LONGTEXT NOT NULL, info LONGTEXT NOT NULL, oem LONGTEXT NOT NULL, oem_brand_1 LONGTEXT NOT NULL, oem_num_1 LONGTEXT NOT NULL, oem_brand_2 LONGTEXT NOT NULL, oem_num_2 LONGTEXT NOT NULL, oem_brand_3 LONGTEXT NOT NULL, oem_num_3 LONGTEXT NOT NULL, action LONGTEXT NOT NULL, img_src LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  440.         $this->addSql('CREATE TABLE price_farpost_rf (ID INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, brand_id INT NOT NULL, art VARCHAR(50) NOT NULL, art_disp VARCHAR(50) NOT NULL, price INT NOT NULL, old_price INT NOT NULL, start_price INT NOT NULL, info VARCHAR(500) NOT NULL, name VARCHAR(500) NOT NULL, oem VARCHAR(1000) NOT NULL, analog VARCHAR(1000) NOT NULL, `usage` VARCHAR(1000) NOT NULL, provider INT NOT NULL, num INT NOT NULL, md5 TINYBLOB NOT NULL, weight DOUBLE PRECISION DEFAULT \'0\' NOT NULL, common_name_id INT NOT NULL, img VARCHAR(500) NOT NULL, price_source INT NOT NULL, INDEX md5 (md5), INDEX brand (brand), INDEX art (art), INDEX provider (provider), INDEX common_name_id (common_name_id), INDEX price_source (price_source), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  441.         $this->addSql('CREATE TABLE price_our (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(30) NOT NULL, art VARCHAR(100) NOT NULL, info VARCHAR(300) NOT NULL, price INT NOT NULL, num INT NOT NULL, INDEX brand (brand), INDEX art (art), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  442.         $this->addSql('CREATE TABLE price_our_ttmp (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(30) NOT NULL, art VARCHAR(50) NOT NULL, art_clean VARCHAR(50) NOT NULL, info VARCHAR(500) NOT NULL, price INT NOT NULL, offer_price INT NOT NULL, num INT NOT NULL, distr_id INT NOT NULL, md5 TINYBLOB DEFAULT NULL, common_name_id INT DEFAULT NULL, brand_id INT DEFAULT NULL, weight DOUBLE PRECISION DEFAULT \'0\' NOT NULL, weight_type INT NOT NULL, INDEX brand (brand), INDEX offer_price (offer_price), INDEX brand_id (brand_id), INDEX distr_id (distr_id), INDEX weight_type (weight_type), INDEX common_name_id (common_name_id), INDEX md5 (md5), INDEX art (art), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  443.         $this->addSql('CREATE TABLE price_point (brand LONGTEXT NOT NULL, art LONGTEXT NOT NULL, info LONGTEXT NOT NULL, price INT NOT NULL, num LONGTEXT NOT NULL, old_price INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  444.         $this->addSql('CREATE TABLE price_region_1 (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(100) NOT NULL, info VARCHAR(500) NOT NULL, num INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  445.         $this->addSql('CREATE TABLE price_region_2 (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(100) NOT NULL, info VARCHAR(500) NOT NULL, num INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  446.         $this->addSql('CREATE TABLE price_region_3 (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(100) NOT NULL, info VARCHAR(500) NOT NULL, num INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  447.         $this->addSql('CREATE TABLE price_regions (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, brand VARCHAR(50) NOT NULL, art VARCHAR(100) NOT NULL, info VARCHAR(500) NOT NULL, num INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  448.         $this->addSql('CREATE TABLE price_tmp_load (ID INT AUTO_INCREMENT NOT NULL, brand_name VARCHAR(30) NOT NULL, brand_id INT DEFAULT NULL, art VARCHAR(30) DEFAULT NULL, art_disp LONGTEXT DEFAULT NULL, price INT DEFAULT NULL, offer_price INT NOT NULL, info LONGTEXT DEFAULT NULL, pro_id INT DEFAULT NULL, num INT DEFAULT NULL, ART_BRA_MD5 TINYBLOB NOT NULL, common_name_id INT NOT NULL, img VARCHAR(500) NOT NULL, weight DOUBLE PRECISION DEFAULT \'0\' NOT NULL, weight_type INT NOT NULL, INDEX in_s_md5 (ART_BRA_MD5), INDEX brand_name (brand_name), INDEX brand_id (brand_id), INDEX art (art), INDEX pro_id (pro_id), INDEX offer_price (offer_price), INDEX weight_type (weight_type), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  449.         $this->addSql('CREATE TABLE price_vladivostok (ID INT AUTO_INCREMENT NOT NULL, brand VARCHAR(50) NOT NULL, brand_id INT NOT NULL, art VARCHAR(50) NOT NULL, art_disp VARCHAR(50) NOT NULL, price INT NOT NULL, old_price INT NOT NULL, start_price INT NOT NULL, info VARCHAR(500) NOT NULL, name VARCHAR(500) NOT NULL, oem VARCHAR(1000) NOT NULL, analog VARCHAR(1000) NOT NULL, `usage` VARCHAR(1000) NOT NULL, provider VARCHAR(50) NOT NULL, num INT NOT NULL, md5 TINYBLOB NOT NULL, weight DOUBLE PRECISION DEFAULT \'0\' NOT NULL, common_name_id INT NOT NULL, img VARCHAR(500) NOT NULL, price_source INT NOT NULL, INDEX md5 (md5), INDEX brand (brand), INDEX art (art), INDEX art_disp (art_disp), INDEX provider (provider), INDEX common_name_id (common_name_id), INDEX price_source (price_source), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  450.         $this->addSql('CREATE TABLE prouser_manager_data (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(300) NOT NULL, phone VARCHAR(20) NOT NULL, img VARCHAR(200) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  451.         $this->addSql('CREATE TABLE required_orders_managers (id INT AUTO_INCREMENT NOT NULL, manager_id INT NOT NULL, site_count INT NOT NULL, pass_count INT NOT NULL, INDEX manager_id (manager_id), INDEX site_count (site_count), INDEX pass_count (pass_count), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  452.         $this->addSql('CREATE TABLE route_place_time (distributors_id INT NOT NULL, place_time INT NOT NULL, UNIQUE INDEX distributors_id (distributors_id), INDEX place_time (place_time)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  453.         $this->addSql('CREATE TABLE route_way_statistic (way_statistic_id INT AUTO_INCREMENT NOT NULL, courier_1 LONGTEXT NOT NULL, courier_2 LONGTEXT NOT NULL, courier_3 LONGTEXT NOT NULL, courier_4 LONGTEXT NOT NULL, courier_5 LONGTEXT NOT NULL, PRIMARY KEY(way_statistic_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  454.         $this->addSql('CREATE TABLE route_way_time (route_id LONGTEXT NOT NULL, way_time LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  455.         $this->addSql('CREATE TABLE s_groups (id INT AUTO_INCREMENT NOT NULL, gr_id INT DEFAULT NULL, art_id INT DEFAULT NULL, fd DATETIME DEFAULT NULL, td DATETIME DEFAULT NULL, INDEX in_gr_id (gr_id), INDEX in_art_id (art_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  456.         $this->addSql('CREATE TABLE service_info (service_id INT AUTO_INCREMENT NOT NULL, service_mail LONGTEXT NOT NULL, service_name LONGTEXT NOT NULL, service_pass LONGTEXT NOT NULL, stok LONGTEXT NOT NULL, PRIMARY KEY(service_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  457.         $this->addSql('CREATE TABLE sip (id INT AUTO_INCREMENT NOT NULL, client_tel VARCHAR(20) NOT NULL, manager_tel VARCHAR(20) NOT NULL, status_id INT NOT NULL, date DATETIME NOT NULL, UNIQUE INDEX id (id), INDEX client_tel (client_tel), INDEX manager_tel (manager_tel), INDEX status_id (status_id), INDEX date (date)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  458.         $this->addSql('CREATE TABLE sip_calls (ID INT AUTO_INCREMENT NOT NULL, NUM VARCHAR(20) DEFAULT NULL, CALL_TIME DATETIME DEFAULT NULL, RESP_TIME DATETIME DEFAULT NULL, END_TIME DATETIME DEFAULT NULL, STATUS INT DEFAULT NULL, manager INT DEFAULT NULL, media_file VARCHAR(300) NOT NULL, INDEX sip_calls_dir (media_file), INDEX NUM (NUM), INDEX STATUS (STATUS), INDEX manager (manager), INDEX CALL_TIME (CALL_TIME), INDEX END_TIME (END_TIME), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  459.         $this->addSql('CREATE TABLE sip_calls_mainmanager_tmp (ID INT AUTO_INCREMENT NOT NULL, NUM VARCHAR(20) DEFAULT NULL, CALL_TIME DATETIME DEFAULT NULL, RESP_TIME DATETIME DEFAULT NULL, END_TIME DATETIME DEFAULT NULL, STATUS INT DEFAULT NULL, manager INT DEFAULT NULL, media_file VARCHAR(200) NOT NULL, INDEX sip_calls_dir (media_file), INDEX NUM (NUM), INDEX manager (manager), INDEX STATUS (STATUS), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  460.         $this->addSql('CREATE TABLE sip_calls_status (id INT AUTO_INCREMENT NOT NULL, txt VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  461.         $this->addSql('CREATE TABLE sip_calls_tmp (ID INT NOT NULL, NUM VARCHAR(20) DEFAULT NULL, CALL_TIME DATETIME DEFAULT NULL, RESP_TIME DATETIME DEFAULT NULL, END_TIME DATETIME DEFAULT NULL, STATUS INT DEFAULT NULL, manager INT DEFAULT NULL, media_file VARCHAR(200) NOT NULL, INDEX sip_calls_dir (media_file), INDEX NUM (NUM), INDEX manager (manager), INDEX STATUS (STATUS), PRIMARY KEY(ID)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  462.         $this->addSql('CREATE TABLE sip_recalls (id INT AUTO_INCREMENT NOT NULL, manager_id INT NOT NULL, num VARCHAR(12) NOT NULL, date DATETIME NOT NULL, INDEX manager_id (manager_id), INDEX num (num), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  463.         $this->addSql('CREATE TABLE sip_request (id INT AUTO_INCREMENT NOT NULL, v1 VARCHAR(100) NOT NULL, v2 VARCHAR(100) NOT NULL, v3 INT NOT NULL, v4 VARCHAR(500) NOT NULL, v5 VARCHAR(100) NOT NULL, v6 VARCHAR(100) NOT NULL, v7 VARCHAR(100) NOT NULL, v8 VARCHAR(100) NOT NULL, v9 VARCHAR(100) NOT NULL, v10 VARCHAR(100) NOT NULL, date DATETIME NOT NULL, INDEX v3 (v3), INDEX v5 (v5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  464.         $this->addSql('CREATE TABLE sip_request_tmp (id INT AUTO_INCREMENT NOT NULL, v1 VARCHAR(100) NOT NULL, v2 VARCHAR(100) NOT NULL, v3 INT NOT NULL, v4 VARCHAR(500) NOT NULL, v5 VARCHAR(100) NOT NULL, v6 VARCHAR(100) NOT NULL, v7 VARCHAR(100) NOT NULL, v8 VARCHAR(100) NOT NULL, v9 VARCHAR(100) NOT NULL, v10 VARCHAR(100) NOT NULL, date DATETIME NOT NULL, INDEX v3 (v3), INDEX v5 (v5), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  465.         $this->addSql('CREATE TABLE sms_settings (id INT AUTO_INCREMENT NOT NULL, site VARCHAR(100) NOT NULL, login VARCHAR(100) NOT NULL, password VARCHAR(200) NOT NULL, sender VARCHAR(100) NOT NULL, UNIQUE INDEX site (site), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  466.         $this->addSql('CREATE TABLE sms_status (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, info_sms_status_id SMALLINT NOT NULL, collect_sms_status_id SMALLINT NOT NULL, bk_sms_status_id SMALLINT NOT NULL, confirm_sms_status_id INT NOT NULL, INDEX order_id (order_id), INDEX info_sms_status_id (info_sms_status_id), INDEX collect_sms_status_id (collect_sms_status_id), INDEX bk_sms_status_id (bk_sms_status_id), INDEX confirm_sms_status_id (confirm_sms_status_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  467.         $this->addSql('CREATE TABLE storage_stat (id INT AUTO_INCREMENT NOT NULL, order_id INT DEFAULT NULL, time1 INT UNSIGNED DEFAULT NULL, time2 INT UNSIGNED DEFAULT NULL, INDEX order_id (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  468.         $this->addSql('CREATE TABLE store_error_log_info (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, part_id INT DEFAULT NULL, status_id SMALLINT NOT NULL, INDEX part_id (part_id), INDEX status_id (status_id), INDEX order_id (order_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  469.         $this->addSql('CREATE TABLE store_getback_orders_place (id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, place_info VARCHAR(100) NOT NULL, INDEX order_id (order_id), INDEX place_info (place_info), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  470.         $this->addSql('CREATE TABLE store_getback_parts_place (id INT AUTO_INCREMENT NOT NULL, part_id INT NOT NULL, place_info VARCHAR(100) NOT NULL, INDEX part_id (part_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  471.         $this->addSql('CREATE TABLE store_orders_info (order_id INT AUTO_INCREMENT NOT NULL, order_status INT NOT NULL, change_status_time DATETIME NOT NULL, INDEX order_status (order_status), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  472.         $this->addSql('CREATE TABLE store_parts_place (order_id INT NOT NULL, new_order_id INT NOT NULL, place_id VARCHAR(10) NOT NULL, INDEX new_order_id (new_order_id), INDEX place_id (place_id), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  473.         $this->addSql('CREATE TABLE store_status (status_id SMALLINT NOT NULL, info LONGTEXT NOT NULL, color LONGTEXT NOT NULL, UNIQUE INDEX status_id (status_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  474.         $this->addSql('CREATE TABLE sxgeo_cities (id INT UNSIGNED AUTO_INCREMENT NOT NULL, region_id INT NOT NULL, timezone_id INT UNSIGNED NOT NULL, sxgeo_id INT NOT NULL, UNIQUE INDEX region_id (region_id, sxgeo_id), INDEX timezone_id (timezone_id), INDEX IDX_FDE6C6BE98260155 (region_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  475.         $this->addSql('CREATE TABLE system_discount (value INT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  476.         $this->addSql('CREATE TABLE tests_answers_table (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, try_num INT NOT NULL, question_num INT NOT NULL, answer VARCHAR(100) NOT NULL, answer_status INT NOT NULL, date DATETIME NOT NULL, INDEX user_id (user_id), INDEX try_num (try_num), INDEX question_num (question_num), INDEX answer_status (answer_status), INDEX date (date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  477.         $this->addSql('CREATE TABLE tests_catalog_resources_table (id INT AUTO_INCREMENT NOT NULL, block_id INT NOT NULL, model INT NOT NULL, res_link VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  478.         $this->addSql('CREATE TABLE tests_end_status_table (id INT AUTO_INCREMENT NOT NULL, status_id INT NOT NULL, status_name VARCHAR(100) NOT NULL, INDEX id (id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  479.         $this->addSql('CREATE TABLE tests_questions_table (id INT AUTO_INCREMENT NOT NULL, block_id INT NOT NULL, brand VARCHAR(100) NOT NULL, model VARCHAR(100) NOT NULL, vin VARCHAR(100) NOT NULL, question VARCHAR(300) NOT NULL, answer VARCHAR(100) NOT NULL, INDEX block_id (block_id), INDEX vin (vin), INDEX answer (answer), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  480.         $this->addSql('CREATE TABLE tests_tech_resources_table (id INT AUTO_INCREMENT NOT NULL, block_id INT NOT NULL, info VARCHAR(100) NOT NULL, res_link VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  481.         $this->addSql('CREATE TABLE tests_try_table (id INT AUTO_INCREMENT NOT NULL, block_id INT NOT NULL, user_id INT NOT NULL, try_num INT NOT NULL, try_end INT NOT NULL, start_date DATETIME NOT NULL, end_date DATETIME NOT NULL, INDEX block_id (block_id), INDEX user_id (user_id), INDEX try_num (try_num), INDEX try_end (try_end), INDEX start_date (start_date), INDEX end_date (end_date), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  482.         $this->addSql('CREATE TABLE tests_users_info_table (id INT AUTO_INCREMENT NOT NULL, user_id INT NOT NULL, first_input DATETIME NOT NULL, root_block INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  483.         $this->addSql('CREATE TABLE timezones (id INT UNSIGNED NOT NULL, name VARCHAR(100) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  484.         $this->addSql('CREATE TABLE tk_info (name LONGTEXT NOT NULL, point LONGTEXT NOT NULL, time_in_way LONGTEXT NOT NULL, weight_0.1 LONGTEXT NOT NULL, weight_0.5 LONGTEXT NOT NULL, weight_1 LONGTEXT NOT NULL, weight_1.5 LONGTEXT NOT NULL, weight_2 LONGTEXT NOT NULL, weight_3 LONGTEXT NOT NULL, weight_4 LONGTEXT NOT NULL, weight_5 LONGTEXT NOT NULL, weight_6 LONGTEXT NOT NULL, weight_7 LONGTEXT NOT NULL, weight_8 LONGTEXT NOT NULL, weight_9 LONGTEXT NOT NULL, weight_10 LONGTEXT NOT NULL, weight_11 LONGTEXT NOT NULL, weight_12 LONGTEXT NOT NULL, weight_13 LONGTEXT NOT NULL, weight_14 LONGTEXT NOT NULL, weight_15 LONGTEXT NOT NULL, weight_16 LONGTEXT NOT NULL, weight_17 LONGTEXT NOT NULL, weight_18 LONGTEXT NOT NULL, weight_19 LONGTEXT NOT NULL, weight_20 LONGTEXT NOT NULL, weight_21 LONGTEXT NOT NULL, weight_22 LONGTEXT NOT NULL, weight_23 LONGTEXT NOT NULL, weight_24 LONGTEXT NOT NULL, weight_25 LONGTEXT NOT NULL, weight_26 LONGTEXT NOT NULL, weight_27 LONGTEXT NOT NULL, weight_28 LONGTEXT NOT NULL, weight_29 LONGTEXT NOT NULL, weight_30 LONGTEXT NOT NULL, weight_31 LONGTEXT NOT NULL, weight_31.5 LONGTEXT NOT NULL, weight_100 LONGTEXT NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  485.         $this->addSql('CREATE TABLE tmp (art VARCHAR(50) NOT NULL, price INT DEFAULT NULL, date DATETIME NOT NULL) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  486.         $this->addSql('CREATE TABLE variables (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(500) NOT NULL, value INT NOT NULL, INDEX name (name), INDEX value (value), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  487.         $this->addSql('CREATE TABLE view_orders_option (id INT AUTO_INCREMENT NOT NULL, manager_id INT NOT NULL, user_id INT NOT NULL, INDEX manager_id (manager_id), INDEX user_id (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  488.         $this->addSql('CREATE TABLE volume_weight_brands (id INT AUTO_INCREMENT NOT NULL, brand VARCHAR(30) NOT NULL, brand_id INT NOT NULL, kind INT NOT NULL, INDEX brand (brand), INDEX brand_id (brand_id), INDEX kind (kind), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  489.         $this->addSql('CREATE TABLE volume_weight_data (id INT AUTO_INCREMENT NOT NULL, volume VARCHAR(20) NOT NULL, weight DOUBLE PRECISION NOT NULL, INDEX volume (volume), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  490.         $this->addSql('CREATE TABLE wishful_price (id INT AUTO_INCREMENT NOT NULL, art VARCHAR(50) NOT NULL, md5 VARCHAR(100) NOT NULL, distributor_id INT NOT NULL, start_price INT NOT NULL, root_price INT NOT NULL, price INT NOT NULL, date DATETIME NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB');
  491.         $this->addSql('ALTER TABLE autoservice_entry ADD CONSTRAINT autoservice_entry_ibfk_1 FOREIGN KEY (order_id) REFERENCES orders_list (id) ON DELETE CASCADE');
  492.         $this->addSql('ALTER TABLE autoservice_entry ADD CONSTRAINT autoservice_entry_ibfk_2 FOREIGN KEY (autoservice_id) REFERENCES sys_autoservices_info (id) ON DELETE CASCADE');
  493.         $this->addSql('ALTER TABLE autoservice_entry_prices ADD CONSTRAINT autoservice_entry_prices_ibfk_1 FOREIGN KEY (entry_id) REFERENCES autoservice_entry (id) ON DELETE CASCADE');
  494.         $this->addSql('ALTER TABLE autoservice_entry_prices ADD CONSTRAINT autoservice_entry_prices_ibfk_2 FOREIGN KEY (detail_id) REFERENCES orders_parts_info (id) ON DELETE CASCADE');
  495.         $this->addSql('ALTER TABLE autoservice_entry_services ADD CONSTRAINT autoservice_entry_services_ibfk_1 FOREIGN KEY (entry_id) REFERENCES autoservice_entry (id) ON DELETE CASCADE');
  496.         $this->addSql('ALTER TABLE calls_status_statistic ADD CONSTRAINT calls_status_statistic_ibfk_1 FOREIGN KEY (status_id) REFERENCES calls_status (id)');
  497.         $this->addSql('ALTER TABLE indicator_values ADD CONSTRAINT indicator_values_ibfk_1 FOREIGN KEY (indicator_id) REFERENCES indicators (id) ON DELETE CASCADE');
  498.         $this->addSql('ALTER TABLE invoices ADD CONSTRAINT invoices_ibfk_1 FOREIGN KEY (provider_id) REFERENCES d3_providers (id) ON DELETE CASCADE');
  499.         $this->addSql('ALTER TABLE invoices_custom_parts ADD CONSTRAINT invoices_custom_parts_ibfk_1 FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE CASCADE');
  500.         $this->addSql('ALTER TABLE invoices_parts ADD CONSTRAINT invoices_parts_ibfk_1 FOREIGN KEY (part_id) REFERENCES orders_parts_info (id) ON DELETE CASCADE');
  501.         $this->addSql('ALTER TABLE invoices_parts ADD CONSTRAINT invoices_parts_ibfk_2 FOREIGN KEY (invoice_id) REFERENCES invoices (id) ON DELETE CASCADE');
  502.         $this->addSql('ALTER TABLE japancar_cache_data ADD CONSTRAINT japancar_cache_data_ibfk_1 FOREIGN KEY (id_info) REFERENCES japancar_cache_info (id) ON DELETE CASCADE');
  503.         $this->addSql('ALTER TABLE kpi_values ADD CONSTRAINT kpi_values_ibfk_1 FOREIGN KEY (indicator_id) REFERENCES kpi (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
  504.         $this->addSql('ALTER TABLE sxgeo_cities ADD CONSTRAINT sxgeo_cities_ibfk_1 FOREIGN KEY (region_id) REFERENCES d3_region_info (id) ON DELETE CASCADE');
  505.         $this->addSql('ALTER TABLE sxgeo_cities ADD CONSTRAINT sxgeo_cities_ibfk_2 FOREIGN KEY (timezone_id) REFERENCES timezones (id) ON DELETE CASCADE');
  506.         $this->addSql('DROP TABLE autoservices');
  507.         $this->addSql('ALTER TABLE brands ADD kind INT DEFAULT NULL');
  508.         $this->addSql('DROP INDEX UNIQ_57C2B0621F578393 ON categories__categories');
  509.         $this->addSql('DROP INDEX UNIQ_57C2B0629DEC66E6 ON categories__categories');
  510.         $this->addSql('ALTER TABLE managers MODIFY id INT NOT NULL');
  511.         $this->addSql('ALTER TABLE managers DROP INDEX primary, ADD UNIQUE INDEX id (id)');
  512.         $this->addSql('ALTER TABLE managers DROP FOREIGN KEY FK_A949E006A76ED395');
  513.         $this->addSql('ALTER TABLE managers DROP FOREIGN KEY FK_A949E00650ABD72B');
  514.         $this->addSql('DROP INDEX IDX_A949E006A76ED395 ON managers');
  515.         $this->addSql('DROP INDEX IDX_A949E00650ABD72B ON managers');
  516.         $this->addSql('ALTER TABLE managers ADD name VARCHAR(100) NOT NULL, ADD short_name VARCHAR(50) NOT NULL, ADD color VARCHAR(10) DEFAULT \'#FFFFFF\' NOT NULL, ADD pass VARCHAR(50) NOT NULL, ADD skype_contact VARCHAR(100) NOT NULL, ADD region_id INT DEFAULT 1 NOT NULL, ADD status_id INT DEFAULT 1 NOT NULL, ADD main_manager INT DEFAULT 0 NOT NULL, ADD group_id INT DEFAULT 0 NOT NULL, ADD group_leader INT NOT NULL, ADD group_status INT NOT NULL, ADD error_log_status INT NOT NULL, ADD offline_status INT NOT NULL, ADD visibility TINYINT(1) DEFAULT \'1\' NOT NULL, DROP sip_number, DROP skype, DROP join_time, DROP leave_time, CHANGE id id SMALLINT NOT NULL, CHANGE 1c_code 1c_code VARCHAR(11) NOT NULL, CHANGE user_id sip_contact INT NOT NULL, CHANGE visible garanty_view TINYINT(1) NOT NULL');
  517.         $this->addSql('CREATE UNIQUE INDEX sip_contact ON managers (sip_contact)');
  518.         $this->addSql('CREATE INDEX group_status ON managers (group_status)');
  519.         $this->addSql('CREATE INDEX group_id ON managers (group_id)');
  520.         $this->addSql('CREATE INDEX status_id ON managers (status_id)');
  521.         $this->addSql('CREATE INDEX region_id ON managers (region_id)');
  522.         $this->addSql('CREATE INDEX statistic_status ON managers (main_manager)');
  523.         $this->addSql('CREATE INDEX error_log_status ON managers (error_log_status)');
  524.         $this->addSql('CREATE INDEX offline_status ON managers (offline_status)');
  525.         $this->addSql('CREATE INDEX group_leader ON managers (group_leader)');
  526.         $this->addSql('CREATE INDEX visibility ON managers (visibility)');
  527.         $this->addSql('ALTER TABLE products__products_categories ADD brand_id INT NOT NULL, ADD art VARCHAR(100) NOT NULL');
  528.         $this->addSql('CREATE INDEX brand_id ON products__products_categories (brand_id)');
  529.         $this->addSql('CREATE INDEX ft4 ON products__products_categories (art)');
  530.         $this->addSql('ALTER TABLE products__products_images DROP FOREIGN KEY FK_470C54717294869C');
  531.         $this->addSql('DROP INDEX IDX_470C54717294869C ON products__products_images');
  532.         $this->addSql('ALTER TABLE products__products_images ADD art VARCHAR(100) NOT NULL, ADD brand VARCHAR(50) NOT NULL');
  533.         $this->addSql('ALTER TABLE products__products_weights DROP FOREIGN KEY FK_9010A95E7294869C');
  534.         $this->addSql('DROP INDEX IDX_9010A95E7294869C ON products__products_weights');
  535.         $this->addSql('ALTER TABLE products__products_weights ADD brand VARCHAR(50) NOT NULL, ADD art VARCHAR(100) NOT NULL, ADD md5 TINYBLOB NOT NULL, ADD kind INT NOT NULL, ADD add_source INT NOT NULL, CHANGE article_id brand_id INT NOT NULL');
  536.         $this->addSql('CREATE INDEX md5 ON products__products_weights (md5)');
  537.         $this->addSql('CREATE INDEX art ON products__products_weights (art)');
  538.         $this->addSql('CREATE INDEX brand_id ON products__products_weights (brand_id)');
  539.         $this->addSql('CREATE INDEX kind ON products__products_weights (kind)');
  540.         $this->addSql('CREATE INDEX add_source ON products__products_weights (add_source)');
  541.         $this->addSql('ALTER TABLE users ADD secondname VARCHAR(50) DEFAULT NULL, CHANGE login_count login_count INT DEFAULT 0, CHANGE old_user old_user TINYINT(1) DEFAULT \'0\' NOT NULL');
  542.     }
  543. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!