<commit_before><commit_msg>refs #26684 Настройка функционала синхронизации складов убрал не используемый код<commit_after><?php

namespace Application\Migrations;

use Doctrine\DBAL\Migrations\AbstractMigration,
    Doctrine\DBAL\Schema\Schema;

/**
 * Auto-generated Migration: Please modify to your need!
 */
class Version20131213183417 extends AbstractMigration
{
    public function up(Schema $schema)
    {
        // this up() migration is autogenerated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        
        $this->addSql("CREATE TABLE delivery_cities (id INT AUTO_INCREMENT NOT NULL, geo_city_id INT DEFAULT NULL, delivery_id INT DEFAULT NULL, city_code VARCHAR(100) DEFAULT NULL COMMENT 'ID города в ТК', name VARCHAR(255) NOT NULL COMMENT 'Название города', created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_C74C48E53CBAEFAD (geo_city_id), INDEX IDX_C74C48E512136921 (delivery_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB");
        $this->addSql("CREATE TABLE delivery_warehouses (id INT AUTO_INCREMENT NOT NULL, delivery_id INT DEFAULT NULL, city_id INT DEFAULT NULL, warehouse_code VARCHAR(100) DEFAULT NULL COMMENT 'ID склада в ТК', number VARCHAR(25) DEFAULT NULL COMMENT 'Номер склада в городе', name VARCHAR(255) NOT NULL COMMENT 'Название отделения', address VARCHAR(255) NOT NULL COMMENT 'Адрес отделения', phone VARCHAR(255) NOT NULL COMMENT 'Телефон отделения', latitude NUMERIC(13, 8) NOT NULL COMMENT 'Широта', longitude NUMERIC(13, 8) NOT NULL COMMENT 'Долгота', created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_B1AC559312136921 (delivery_id), INDEX IDX_B1AC55938BAC62AF (city_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB");
        $this->addSql("ALTER TABLE delivery_cities ADD CONSTRAINT FK_C74C48E53CBAEFAD FOREIGN KEY (geo_city_id) REFERENCES geo_city (id)");
        $this->addSql("ALTER TABLE delivery_cities ADD CONSTRAINT FK_C74C48E512136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id)");
        $this->addSql("ALTER TABLE delivery_warehouses ADD CONSTRAINT FK_B1AC559312136921 FOREIGN KEY (delivery_id) REFERENCES delivery (id)");
        $this->addSql("ALTER TABLE delivery_warehouses ADD CONSTRAINT FK_B1AC55938BAC62AF FOREIGN KEY (city_id) REFERENCES delivery_cities (id)");
    }

    public function down(Schema $schema)
    {
        // this down() migration is autogenerated, please modify it to your needs
        $this->abortIf($this->connection->getDatabasePlatform()->getName() != "mysql");
        
        $this->addSql("ALTER TABLE delivery_warehouses DROP FOREIGN KEY FK_B1AC55938BAC62AF");
        $this->addSql("DROP TABLE delivery_cities");
        $this->addSql("DROP TABLE delivery_warehouses");
    }
}
{'fraction_non_alphanumeric': 0.08817567567567568, 'fraction_numerical': 0.04628378378378378, 'mean_word_length': 5.16875, 'pattern_counts': {'":': 0, '<': 4, '<?xml version=': 0, '>': 20, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5004651', 'n_tokens_mistral': 1053, 'n_tokens_neox': 969, 'n_words': 278}