<?php

declare(strict_types=1);

namespace DoctrineMigrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20211020151756 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE TABLE allergen (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) DEFAULT NULL, ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE assortment (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE assortment_group (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', main_group_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', assortment_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', parent_id INT DEFAULT NULL, position INT DEFAULT NULL, url_name VARCHAR(255) DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, media_name VARCHAR(255) DEFAULT NULL, hide_subgroups TINYINT(1) DEFAULT NULL, extra_set_id INT DEFAULT NULL, ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_EC2544192776C832 (main_group_id), INDEX IDX_EC254419D7A15862 (assortment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE assortment_product (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', vat_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', nutrition_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', assortment_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) DEFAULT NULL, price NUMERIC(10, 2) NOT NULL, product_links LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', in_stock TINYINT(1) NOT NULL, description LONGTEXT DEFAULT NULL, code VARCHAR(255) DEFAULT NULL, media_name VARCHAR(255) DEFAULT NULL, feature_ids LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', qualitymark_ids LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', exclude_for_discount TINYINT(1) NOT NULL, button_text VARCHAR(255) DEFAULT NULL, url_name VARCHAR(255) DEFAULT NULL, ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_FEC70F5BB5B63A6B (vat_id), UNIQUE INDEX UNIQ_FEC70F5BB5D724CD (nutrition_id), INDEX IDX_FEC70F5BD7A15862 (assortment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE product_allergen (product_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', allergen_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_EE0F62594584665A (product_id), INDEX IDX_EE0F62596E775A4A (allergen_id), PRIMARY KEY(product_id, allergen_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE assortment_product_position (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', assortment_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', product_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', group_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', position INT NOT NULL, is_active TINYINT(1) NOT NULL, question_set_id INT DEFAULT NULL, extra_set_id INT DEFAULT NULL, ask_extra_article TINYINT(1) NOT NULL, name VARCHAR(255) DEFAULT NULL, media_name VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, button_text VARCHAR(255) DEFAULT NULL, ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_67E9B5FED7A15862 (assortment_id), INDEX IDX_67E9B5FE4584665A (product_id), INDEX IDX_67E9B5FEFE54D947 (group_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE product_nutrition (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', carbs NUMERIC(10, 2) DEFAULT NULL, energy_kcal NUMERIC(10, 2) DEFAULT NULL, energy_kj NUMERIC(10, 2) DEFAULT NULL, fats_saturated NUMERIC(10, 2) DEFAULT NULL, fats_total NUMERIC(10, 2) DEFAULT NULL, fibers NUMERIC(10, 2) DEFAULT NULL, nutrition_for_amount NUMERIC(10, 2) DEFAULT NULL, portion_content NUMERIC(10, 2) DEFAULT NULL, portion_unit VARCHAR(255) DEFAULT NULL, proteins NUMERIC(10, 2) DEFAULT NULL, salts NUMERIC(10, 2) DEFAULT NULL, sugars NUMERIC(10, 2) DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', ntf_id VARCHAR(255) DEFAULT NULL, drupal_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', name VARCHAR(255) DEFAULT NULL, street VARCHAR(255) DEFAULT NULL, number VARCHAR(255) DEFAULT NULL, postal VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, lat DOUBLE PRECISION DEFAULT NULL, `long` DOUBLE PRECISION DEFAULT NULL, telephone VARCHAR(255) DEFAULT NULL, fax VARCHAR(255) DEFAULT NULL, email VARCHAR(255) DEFAULT NULL, contact VARCHAR(255) DEFAULT NULL, panic_mode_active TINYINT(1) NOT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_FF5758778233D7B (ntf_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store_content_blocks (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', store_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', drupal_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', identifier VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, content LONGTEXT DEFAULT NULL, active TINYINT(1) NOT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_B14DF80AF023AAC2 (drupal_id), INDEX IDX_B14DF80AB092A811 (store_id), UNIQUE INDEX store_identifier (store_id, identifier), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store_delivery_method (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', store_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', assortment_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', description VARCHAR(255) DEFAULT NULL, min_amount NUMERIC(10, 0) NOT NULL, fee_amount NUMERIC(10, 0) NOT NULL, no_fee_amount NUMERIC(10, 0) NOT NULL, time_selection_type VARCHAR(255) DEFAULT NULL, display_name VARCHAR(255) DEFAULT NULL, delivery_method INT NOT NULL, sort INT NOT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_2134AA20B092A811 (store_id), UNIQUE INDEX UNIQ_2134AA20D7A15862 (assortment_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store_open_time (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', store_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', day_of_week INT NOT NULL, open_from VARCHAR(255) DEFAULT NULL, open_to VARCHAR(255) DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_8B36B51DB092A811 (store_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store_page (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', store_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', drupal_id CHAR(36) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', title VARCHAR(255) DEFAULT NULL, identifier VARCHAR(255) DEFAULT NULL, content LONGTEXT DEFAULT NULL, content_heading VARCHAR(255) DEFAULT NULL, meta_description LONGTEXT DEFAULT NULL, meta_keywords VARCHAR(255) DEFAULT NULL, active TINYINT(1) NOT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_F6B318EEF023AAC2 (drupal_id), INDEX IDX_F6B318EEB092A811 (store_id), UNIQUE INDEX store_identifier (store_id, identifier), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE store_settings (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', store_id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', allow_product_notes TINYINT(1) NOT NULL, allow_order_notes TINYINT(1) NOT NULL, default_block_size INT NOT NULL, send_to_url_after_order_url VARCHAR(255) DEFAULT NULL, custom_message_modal_text LONGTEXT DEFAULT NULL, allow_order_reference TINYINT(1) NOT NULL, max_order_price INT NOT NULL, customers_can_log_in TINYINT(1) NOT NULL, has_plastic_bag_costs TINYINT(1) DEFAULT NULL, plastic_bag_delivery_cost INT DEFAULT NULL, plastic_bag_pickup_cost INT DEFAULT NULL, only_allow_orders_for_today TINYINT(1) NOT NULL, show_newsletter_option TINYINT(1) NOT NULL, pushbird_id INT DEFAULT NULL, customer_can_give_tips TINYINT(1) NOT NULL, about_us_txt LONGTEXT DEFAULT NULL, allow_extra_filter TINYINT(1) NOT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, INDEX IDX_DB32DF3FB092A811 (store_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE vat (id CHAR(36) NOT NULL COMMENT \'(DC2Type:uuid)\', percentage INT NOT NULL, country_id VARCHAR(255) NOT NULL, ntf_id INT DEFAULT NULL, updated_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE assortment_group ADD CONSTRAINT FK_EC2544192776C832 FOREIGN KEY (main_group_id) REFERENCES assortment_group (id)');
        $this->addSql('ALTER TABLE assortment_group ADD CONSTRAINT FK_EC254419D7A15862 FOREIGN KEY (assortment_id) REFERENCES assortment (id)');
        $this->addSql('ALTER TABLE assortment_product ADD CONSTRAINT FK_FEC70F5BB5B63A6B FOREIGN KEY (vat_id) REFERENCES vat (id)');
        $this->addSql('ALTER TABLE assortment_product ADD CONSTRAINT FK_FEC70F5BB5D724CD FOREIGN KEY (nutrition_id) REFERENCES product_nutrition (id)');
        $this->addSql('ALTER TABLE assortment_product ADD CONSTRAINT FK_FEC70F5BD7A15862 FOREIGN KEY (assortment_id) REFERENCES assortment (id)');
        $this->addSql('ALTER TABLE product_allergen ADD CONSTRAINT FK_EE0F62594584665A FOREIGN KEY (product_id) REFERENCES assortment_product (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE product_allergen ADD CONSTRAINT FK_EE0F62596E775A4A FOREIGN KEY (allergen_id) REFERENCES allergen (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE assortment_product_position ADD CONSTRAINT FK_67E9B5FED7A15862 FOREIGN KEY (assortment_id) REFERENCES assortment (id)');
        $this->addSql('ALTER TABLE assortment_product_position ADD CONSTRAINT FK_67E9B5FE4584665A FOREIGN KEY (product_id) REFERENCES assortment_product (id)');
        $this->addSql('ALTER TABLE assortment_product_position ADD CONSTRAINT FK_67E9B5FEFE54D947 FOREIGN KEY (group_id) REFERENCES assortment_group (id)');
        $this->addSql('ALTER TABLE store_content_blocks ADD CONSTRAINT FK_B14DF80AB092A811 FOREIGN KEY (store_id) REFERENCES store (id)');
        $this->addSql('ALTER TABLE store_delivery_method ADD CONSTRAINT FK_2134AA20B092A811 FOREIGN KEY (store_id) REFERENCES store (id)');
        $this->addSql('ALTER TABLE store_delivery_method ADD CONSTRAINT FK_2134AA20D7A15862 FOREIGN KEY (assortment_id) REFERENCES assortment (id)');
        $this->addSql('ALTER TABLE store_open_time ADD CONSTRAINT FK_8B36B51DB092A811 FOREIGN KEY (store_id) REFERENCES store (id)');
        $this->addSql('ALTER TABLE store_page ADD CONSTRAINT FK_F6B318EEB092A811 FOREIGN KEY (store_id) REFERENCES store (id)');
        $this->addSql('ALTER TABLE store_settings ADD CONSTRAINT FK_DB32DF3FB092A811 FOREIGN KEY (store_id) REFERENCES store (id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE product_allergen DROP FOREIGN KEY FK_EE0F62596E775A4A');
        $this->addSql('ALTER TABLE assortment_group DROP FOREIGN KEY FK_EC254419D7A15862');
        $this->addSql('ALTER TABLE assortment_product DROP FOREIGN KEY FK_FEC70F5BD7A15862');
        $this->addSql('ALTER TABLE assortment_product_position DROP FOREIGN KEY FK_67E9B5FED7A15862');
        $this->addSql('ALTER TABLE store_delivery_method DROP FOREIGN KEY FK_2134AA20D7A15862');
        $this->addSql('ALTER TABLE assortment_group DROP FOREIGN KEY FK_EC2544192776C832');
        $this->addSql('ALTER TABLE assortment_product_position DROP FOREIGN KEY FK_67E9B5FEFE54D947');
        $this->addSql('ALTER TABLE product_allergen DROP FOREIGN KEY FK_EE0F62594584665A');
        $this->addSql('ALTER TABLE assortment_product_position DROP FOREIGN KEY FK_67E9B5FE4584665A');
        $this->addSql('ALTER TABLE assortment_product DROP FOREIGN KEY FK_FEC70F5BB5D724CD');
        $this->addSql('ALTER TABLE store_content_blocks DROP FOREIGN KEY FK_B14DF80AB092A811');
        $this->addSql('ALTER TABLE store_delivery_method DROP FOREIGN KEY FK_2134AA20B092A811');
        $this->addSql('ALTER TABLE store_open_time DROP FOREIGN KEY FK_8B36B51DB092A811');
        $this->addSql('ALTER TABLE store_page DROP FOREIGN KEY FK_F6B318EEB092A811');
        $this->addSql('ALTER TABLE store_settings DROP FOREIGN KEY FK_DB32DF3FB092A811');
        $this->addSql('ALTER TABLE assortment_product DROP FOREIGN KEY FK_FEC70F5BB5B63A6B');
        $this->addSql('DROP TABLE allergen');
        $this->addSql('DROP TABLE assortment');
        $this->addSql('DROP TABLE assortment_group');
        $this->addSql('DROP TABLE assortment_product');
        $this->addSql('DROP TABLE product_allergen');
        $this->addSql('DROP TABLE assortment_product_position');
        $this->addSql('DROP TABLE product_nutrition');
        $this->addSql('DROP TABLE store');
        $this->addSql('DROP TABLE store_content_blocks');
        $this->addSql('DROP TABLE store_delivery_method');
        $this->addSql('DROP TABLE store_open_time');
        $this->addSql('DROP TABLE store_page');
        $this->addSql('DROP TABLE store_settings');
        $this->addSql('DROP TABLE vat');
    }

    public function isTransactional(): bool
    {
        return false;
    }
}