<?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 Version20220317080656 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 calendar (id INT AUTO_INCREMENT NOT NULL, calendar_setting_id INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_6EA9A146787F7977 (calendar_setting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE calendar_setting (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, day_border_color VARCHAR(10) DEFAULT NULL, day_number_color VARCHAR(10) DEFAULT NULL, day_hover_color VARCHAR(10) DEFAULT NULL, day_number_hover_color VARCHAR(10) DEFAULT NULL, day_background_color VARCHAR(10) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_FD03C35F979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE campaign (id INT AUTO_INCREMENT NOT NULL, dynamic_rule_id INT DEFAULT NULL, voucher_id INT DEFAULT NULL, campaign_type_id INT DEFAULT NULL, valid_from DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', valid_to DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', name VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_1F1512DDAA32ED4A (dynamic_rule_id), INDEX IDX_1F1512DD28AA1B6F (voucher_id), INDEX IDX_1F1512DD6DF610BF (campaign_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE campaign_type (id INT AUTO_INCREMENT NOT NULL, term VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, image_id INT DEFAULT NULL, meta_id INT DEFAULT NULL, footer_content_id INT DEFAULT NULL, schema_org_rating_id INT DEFAULT NULL, header_content_id INT DEFAULT NULL, language_id INT DEFAULT NULL, type_id INT DEFAULT NULL, network_id INT DEFAULT NULL, setting_id INT DEFAULT NULL, name VARCHAR(255) NOT NULL, token VARCHAR(32) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_A2F98E47979B1AD6 (company_id), INDEX IDX_A2F98E473DA5256D (image_id), INDEX IDX_A2F98E4739FCA6F9 (meta_id), INDEX IDX_A2F98E471821D579 (footer_content_id), INDEX IDX_A2F98E4756DDD79C (schema_org_rating_id), INDEX IDX_A2F98E472677B3DA (header_content_id), INDEX IDX_A2F98E4782F1BAF4 (language_id), INDEX IDX_A2F98E47C54C8C93 (type_id), INDEX IDX_A2F98E4734128B91 (network_id), INDEX IDX_A2F98E47EE35BD72 (setting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_schema_org_question (channel_id INT NOT NULL, schema_org_question_id INT NOT NULL, INDEX IDX_931AF5B772F5A1AA (channel_id), INDEX IDX_931AF5B77671A710 (schema_org_question_id), PRIMARY KEY(channel_id, schema_org_question_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_campaign (id INT AUTO_INCREMENT NOT NULL, campaign_id INT NOT NULL, channel_id INT NOT NULL, position INT DEFAULT NULL, INDEX IDX_68A56174F639F774 (campaign_id), INDEX IDX_68A5617472F5A1AA (channel_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_footer_content (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, language_id INT DEFAULT NULL, main_headline VARCHAR(255) DEFAULT NULL, collapse TINYINT(1) DEFAULT NULL, utm VARCHAR(255) DEFAULT NULL, collapse_label VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_5283A097979B1AD6 (company_id), INDEX IDX_5283A09782F1BAF4 (language_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_footer_entry (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, language_id INT DEFAULT NULL, content LONGTEXT NOT NULL, name VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_4D62D56E979B1AD6 (company_id), INDEX IDX_4D62D56E82F1BAF4 (language_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_footer_entry_position (id INT AUTO_INCREMENT NOT NULL, footer_content_id INT DEFAULT NULL, footer_entry_id INT DEFAULT NULL, position INT DEFAULT NULL, INDEX IDX_1D5FC7A51821D579 (footer_content_id), INDEX IDX_1D5FC7A5C2516B9A (footer_entry_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_header_content (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, language_id INT DEFAULT NULL, headline VARCHAR(255) DEFAULT NULL, entry_text LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_E48084E4979B1AD6 (company_id), INDEX IDX_E48084E482F1BAF4 (language_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_layout (id INT AUTO_INCREMENT NOT NULL, type_id INT DEFAULT NULL, company_id INT DEFAULT NULL, button_css_class VARCHAR(255) DEFAULT NULL, overview_css LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_C459519CC54C8C93 (type_id), INDEX IDX_C459519C979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_layout_channel (channel_layout_id INT NOT NULL, channel_id INT NOT NULL, INDEX IDX_1C283BA3235F0125 (channel_layout_id), INDEX IDX_1C283BA372F5A1AA (channel_id), PRIMARY KEY(channel_layout_id, channel_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_layout_type (id INT AUTO_INCREMENT NOT NULL, term VARCHAR(255) DEFAULT NULL, category VARCHAR(255) NOT NULL, css_class VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_meta (id INT AUTO_INCREMENT NOT NULL, title VARCHAR(255) DEFAULT NULL, keywords VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_network (id INT AUTO_INCREMENT NOT NULL, network_id INT DEFAULT NULL, INDEX IDX_D7C7B8BD34128B91 (network_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_setting (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, condition_label VARCHAR(255) DEFAULT NULL, copy_label VARCHAR(255) DEFAULT NULL, utm VARCHAR(255) DEFAULT NULL, shop_url VARCHAR(255) DEFAULT NULL, shop_voucher_url VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_28378799979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE channel_type (id INT AUTO_INCREMENT NOT NULL, term VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE company (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, street VARCHAR(255) DEFAULT NULL, postcode VARCHAR(10) DEFAULT NULL, country VARCHAR(255) DEFAULT NULL, city VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE deeplink_button (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, url VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_103C73C4979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE dynamic_rule (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, rule LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_57A7B628979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE ext_log_entries (id INT AUTO_INCREMENT NOT NULL, action VARCHAR(8) NOT NULL, logged_at DATETIME NOT NULL, object_id VARCHAR(64) DEFAULT NULL, object_class VARCHAR(191) NOT NULL, version INT NOT NULL, data LONGTEXT DEFAULT NULL COMMENT \'(DC2Type:array)\', username VARCHAR(191) DEFAULT NULL, INDEX log_class_lookup_idx (object_class), INDEX log_date_lookup_idx (logged_at), INDEX log_user_lookup_idx (username), INDEX log_version_lookup_idx (object_id, object_class, version), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC');
$this->addSql('CREATE TABLE image (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, alt_value VARCHAR(255) DEFAULT NULL, name VARCHAR(255) NOT NULL, size INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_C53D045F979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE language (id INT AUTO_INCREMENT NOT NULL, locale VARCHAR(7) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE lucky_wheel (id INT AUTO_INCREMENT NOT NULL, lucky_wheel_setting_id INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_EA9C8DF029F72054 (lucky_wheel_setting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE lucky_wheel_setting (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, button_background_color VARCHAR(255) DEFAULT NULL, button_title VARCHAR(255) DEFAULT NULL, button_color VARCHAR(255) DEFAULT NULL, action_rotate_text VARCHAR(255) DEFAULT NULL, copy_button_title VARCHAR(255) DEFAULT NULL, btn_text_after_click VARCHAR(255) DEFAULT NULL, body_background_color VARCHAR(10) DEFAULT NULL, toast_front_color VARCHAR(10) DEFAULT NULL, toast_background_color VARCHAR(10) DEFAULT NULL, wheel_stroke_color VARCHAR(10) DEFAULT NULL, wheel_stroke_width INT DEFAULT NULL, wheel_text_color VARCHAR(10) DEFAULT NULL, center_circle_stroke_color VARCHAR(10) DEFAULT NULL, center_circle_fill_color VARCHAR(10) DEFAULT NULL, center_circle_stroke_width INT DEFAULT NULL, segment_stroke_width INT DEFAULT NULL, segment_stroke_color VARCHAR(10) DEFAULT NULL, peg_color VARCHAR(10) DEFAULT NULL, restriction_front_color VARCHAR(10) DEFAULT NULL, restriction_background_color VARCHAR(10) DEFAULT NULL, restriction_text VARCHAR(255) DEFAULT NULL, max_restrictions INT DEFAULT 2, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_F556CFDB979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE lucky_wheel_voucher (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE network (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, publisher_id VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE schema_org_question (id INT AUTO_INCREMENT NOT NULL, language_id INT DEFAULT NULL, company_id INT DEFAULT NULL, question VARCHAR(255) DEFAULT NULL, answer LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_EAA517F582F1BAF4 (language_id), INDEX IDX_EAA517F5979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE schema_org_rating (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, ratin_value INT DEFAULT NULL, worst_rating INT DEFAULT NULL, best_rating INT DEFAULT NULL, rating_count INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_E2AE8569979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE scratch_card (id INT AUTO_INCREMENT NOT NULL, scratch_card_setting_id INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_A363FEE0E5E20F89 (scratch_card_setting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE scratch_card_setting (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, button_text VARCHAR(255) DEFAULT NULL, code_preview VARCHAR(255) DEFAULT NULL, top_color VARCHAR(10) DEFAULT NULL, middle_color VARCHAR(10) DEFAULT NULL, bottom_color VARCHAR(10) DEFAULT NULL, title_color VARCHAR(10) DEFAULT NULL, bottom_text_color VARCHAR(10) DEFAULT NULL, first_color_card VARCHAR(10) DEFAULT NULL, second_color_card VARCHAR(10) DEFAULT NULL, button_text_color VARCHAR(10) DEFAULT NULL, button_background_color VARCHAR(10) DEFAULT NULL, max_restrictions INT DEFAULT NULL, restriction_text VARCHAR(255) DEFAULT NULL, presentation_type INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_E54AA5B2979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user (id INT AUTO_INCREMENT NOT NULL, user_setting_id INT DEFAULT NULL, company_id INT DEFAULT NULL, email VARCHAR(180) NOT NULL, roles JSON NOT NULL, password VARCHAR(255) NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, last_login DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_8D93D649E7927C74 (email), UNIQUE INDEX UNIQ_8D93D64949527B9E (user_setting_id), INDEX IDX_8D93D649979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE user_setting (id INT AUTO_INCREMENT NOT NULL, language_id INT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_C779A69282F1BAF4 (language_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, content_id INT DEFAULT NULL, generic_id INT DEFAULT NULL, scratch_card_id INT DEFAULT NULL, type_id INT DEFAULT NULL, lucky_wheel_id INT DEFAULT NULL, calendar_id INT DEFAULT NULL, code_list_id INT DEFAULT NULL, image_id INT DEFAULT NULL, modal TINYINT(1) DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_1392A5D8979B1AD6 (company_id), INDEX IDX_1392A5D884A0A3ED (content_id), INDEX IDX_1392A5D8B8F19F66 (generic_id), INDEX IDX_1392A5D89127E9E2 (scratch_card_id), INDEX IDX_1392A5D8C54C8C93 (type_id), INDEX IDX_1392A5D8A4118F63 (lucky_wheel_id), INDEX IDX_1392A5D8A40A2C8 (calendar_id), INDEX IDX_1392A5D85095217 (code_list_id), INDEX IDX_1392A5D83DA5256D (image_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_deeplink_button (voucher_id INT NOT NULL, deeplink_button_id INT NOT NULL, INDEX IDX_72F7836E28AA1B6F (voucher_id), INDEX IDX_72F7836EDB9AAD0E (deeplink_button_id), PRIMARY KEY(voucher_id, deeplink_button_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_code_list (id INT AUTO_INCREMENT NOT NULL, company VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, used TINYINT(1) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_E6D90E054FBF094F (company), UNIQUE INDEX UNIQ_E6D90E055E237E06 (name), UNIQUE INDEX UNIQ_E6D90E0577153098 (code), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_condition (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, language_id INT DEFAULT NULL, content VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_292C149F979B1AD6 (company_id), INDEX IDX_292C149F82F1BAF4 (language_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_condition_position (id INT AUTO_INCREMENT NOT NULL, voucher_id INT NOT NULL, condition_id INT NOT NULL, position INT NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_AD8F14BD28AA1B6F (voucher_id), INDEX IDX_AD8F14BD887793B6 (condition_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_content (id INT AUTO_INCREMENT NOT NULL, language_id INT DEFAULT NULL, company_id INT DEFAULT NULL, title VARCHAR(255) DEFAULT NULL, description LONGTEXT DEFAULT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_3D081AAE82F1BAF4 (language_id), INDEX IDX_3D081AAE979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_generic (id INT AUTO_INCREMENT NOT NULL, company_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_55828BD4979B1AD6 (company_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE voucher_type (id INT AUTO_INCREMENT NOT NULL, term VARCHAR(255) DEFAULT \'parent\' NOT NULL, created_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', updated_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', UNIQUE INDEX UNIQ_8DB3D791A50FE78D (term), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE calendar ADD CONSTRAINT FK_6EA9A146787F7977 FOREIGN KEY (calendar_setting_id) REFERENCES calendar_setting (id)');
$this->addSql('ALTER TABLE calendar_setting ADD CONSTRAINT FK_FD03C35F979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DDAA32ED4A FOREIGN KEY (dynamic_rule_id) REFERENCES dynamic_rule (id)');
$this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD28AA1B6F FOREIGN KEY (voucher_id) REFERENCES voucher (id)');
$this->addSql('ALTER TABLE campaign ADD CONSTRAINT FK_1F1512DD6DF610BF FOREIGN KEY (campaign_type_id) REFERENCES campaign_type (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E47979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E473DA5256D FOREIGN KEY (image_id) REFERENCES image (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E4739FCA6F9 FOREIGN KEY (meta_id) REFERENCES channel_meta (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E471821D579 FOREIGN KEY (footer_content_id) REFERENCES channel_footer_content (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E4756DDD79C FOREIGN KEY (schema_org_rating_id) REFERENCES schema_org_rating (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E472677B3DA FOREIGN KEY (header_content_id) REFERENCES channel_header_content (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E4782F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E47C54C8C93 FOREIGN KEY (type_id) REFERENCES channel_type (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E4734128B91 FOREIGN KEY (network_id) REFERENCES channel_network (id)');
$this->addSql('ALTER TABLE channel ADD CONSTRAINT FK_A2F98E47EE35BD72 FOREIGN KEY (setting_id) REFERENCES channel_setting (id)');
$this->addSql('ALTER TABLE channel_schema_org_question ADD CONSTRAINT FK_931AF5B772F5A1AA FOREIGN KEY (channel_id) REFERENCES channel (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE channel_schema_org_question ADD CONSTRAINT FK_931AF5B77671A710 FOREIGN KEY (schema_org_question_id) REFERENCES schema_org_question (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE channel_campaign ADD CONSTRAINT FK_68A56174F639F774 FOREIGN KEY (campaign_id) REFERENCES campaign (id)');
$this->addSql('ALTER TABLE channel_campaign ADD CONSTRAINT FK_68A5617472F5A1AA FOREIGN KEY (channel_id) REFERENCES channel (id)');
$this->addSql('ALTER TABLE channel_footer_content ADD CONSTRAINT FK_5283A097979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE channel_footer_content ADD CONSTRAINT FK_5283A09782F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE channel_footer_entry ADD CONSTRAINT FK_4D62D56E979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE channel_footer_entry ADD CONSTRAINT FK_4D62D56E82F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE channel_footer_entry_position ADD CONSTRAINT FK_1D5FC7A51821D579 FOREIGN KEY (footer_content_id) REFERENCES channel_footer_content (id)');
$this->addSql('ALTER TABLE channel_footer_entry_position ADD CONSTRAINT FK_1D5FC7A5C2516B9A FOREIGN KEY (footer_entry_id) REFERENCES channel_footer_entry (id)');
$this->addSql('ALTER TABLE channel_header_content ADD CONSTRAINT FK_E48084E4979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE channel_header_content ADD CONSTRAINT FK_E48084E482F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE channel_layout ADD CONSTRAINT FK_C459519CC54C8C93 FOREIGN KEY (type_id) REFERENCES channel_layout_type (id)');
$this->addSql('ALTER TABLE channel_layout ADD CONSTRAINT FK_C459519C979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE channel_layout_channel ADD CONSTRAINT FK_1C283BA3235F0125 FOREIGN KEY (channel_layout_id) REFERENCES channel_layout (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE channel_layout_channel ADD CONSTRAINT FK_1C283BA372F5A1AA FOREIGN KEY (channel_id) REFERENCES channel (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE channel_network ADD CONSTRAINT FK_D7C7B8BD34128B91 FOREIGN KEY (network_id) REFERENCES network (id)');
$this->addSql('ALTER TABLE channel_setting ADD CONSTRAINT FK_28378799979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE deeplink_button ADD CONSTRAINT FK_103C73C4979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE dynamic_rule ADD CONSTRAINT FK_57A7B628979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE image ADD CONSTRAINT FK_C53D045F979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE lucky_wheel ADD CONSTRAINT FK_EA9C8DF029F72054 FOREIGN KEY (lucky_wheel_setting_id) REFERENCES lucky_wheel_setting (id)');
$this->addSql('ALTER TABLE lucky_wheel_setting ADD CONSTRAINT FK_F556CFDB979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE schema_org_question ADD CONSTRAINT FK_EAA517F582F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE schema_org_question ADD CONSTRAINT FK_EAA517F5979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE schema_org_rating ADD CONSTRAINT FK_E2AE8569979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE scratch_card ADD CONSTRAINT FK_A363FEE0E5E20F89 FOREIGN KEY (scratch_card_setting_id) REFERENCES scratch_card_setting (id)');
$this->addSql('ALTER TABLE scratch_card_setting ADD CONSTRAINT FK_E54AA5B2979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D64949527B9E FOREIGN KEY (user_setting_id) REFERENCES user_setting (id)');
$this->addSql('ALTER TABLE user ADD CONSTRAINT FK_8D93D649979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE user_setting ADD CONSTRAINT FK_C779A69282F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D8979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D884A0A3ED FOREIGN KEY (content_id) REFERENCES voucher_content (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D8B8F19F66 FOREIGN KEY (generic_id) REFERENCES voucher_generic (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D89127E9E2 FOREIGN KEY (scratch_card_id) REFERENCES scratch_card (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D8C54C8C93 FOREIGN KEY (type_id) REFERENCES voucher_type (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D8A4118F63 FOREIGN KEY (lucky_wheel_id) REFERENCES lucky_wheel (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D8A40A2C8 FOREIGN KEY (calendar_id) REFERENCES calendar (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D85095217 FOREIGN KEY (code_list_id) REFERENCES voucher_code_list (id)');
$this->addSql('ALTER TABLE voucher ADD CONSTRAINT FK_1392A5D83DA5256D FOREIGN KEY (image_id) REFERENCES image (id)');
$this->addSql('ALTER TABLE voucher_deeplink_button ADD CONSTRAINT FK_72F7836E28AA1B6F FOREIGN KEY (voucher_id) REFERENCES voucher (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE voucher_deeplink_button ADD CONSTRAINT FK_72F7836EDB9AAD0E FOREIGN KEY (deeplink_button_id) REFERENCES deeplink_button (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE voucher_condition ADD CONSTRAINT FK_292C149F979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE voucher_condition ADD CONSTRAINT FK_292C149F82F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE voucher_condition_position ADD CONSTRAINT FK_AD8F14BD28AA1B6F FOREIGN KEY (voucher_id) REFERENCES voucher (id)');
$this->addSql('ALTER TABLE voucher_condition_position ADD CONSTRAINT FK_AD8F14BD887793B6 FOREIGN KEY (condition_id) REFERENCES voucher_condition (id)');
$this->addSql('ALTER TABLE voucher_content ADD CONSTRAINT FK_3D081AAE82F1BAF4 FOREIGN KEY (language_id) REFERENCES language (id)');
$this->addSql('ALTER TABLE voucher_content ADD CONSTRAINT FK_3D081AAE979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
$this->addSql('ALTER TABLE voucher_generic ADD CONSTRAINT FK_55828BD4979B1AD6 FOREIGN KEY (company_id) REFERENCES company (id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D8A40A2C8');
$this->addSql('ALTER TABLE calendar DROP FOREIGN KEY FK_6EA9A146787F7977');
$this->addSql('ALTER TABLE channel_campaign DROP FOREIGN KEY FK_68A56174F639F774');
$this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD6DF610BF');
$this->addSql('ALTER TABLE channel_schema_org_question DROP FOREIGN KEY FK_931AF5B772F5A1AA');
$this->addSql('ALTER TABLE channel_campaign DROP FOREIGN KEY FK_68A5617472F5A1AA');
$this->addSql('ALTER TABLE channel_layout_channel DROP FOREIGN KEY FK_1C283BA372F5A1AA');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E471821D579');
$this->addSql('ALTER TABLE channel_footer_entry_position DROP FOREIGN KEY FK_1D5FC7A51821D579');
$this->addSql('ALTER TABLE channel_footer_entry_position DROP FOREIGN KEY FK_1D5FC7A5C2516B9A');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E472677B3DA');
$this->addSql('ALTER TABLE channel_layout_channel DROP FOREIGN KEY FK_1C283BA3235F0125');
$this->addSql('ALTER TABLE channel_layout DROP FOREIGN KEY FK_C459519CC54C8C93');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E4739FCA6F9');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E4734128B91');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E47EE35BD72');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E47C54C8C93');
$this->addSql('ALTER TABLE calendar_setting DROP FOREIGN KEY FK_FD03C35F979B1AD6');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E47979B1AD6');
$this->addSql('ALTER TABLE channel_footer_content DROP FOREIGN KEY FK_5283A097979B1AD6');
$this->addSql('ALTER TABLE channel_footer_entry DROP FOREIGN KEY FK_4D62D56E979B1AD6');
$this->addSql('ALTER TABLE channel_header_content DROP FOREIGN KEY FK_E48084E4979B1AD6');
$this->addSql('ALTER TABLE channel_layout DROP FOREIGN KEY FK_C459519C979B1AD6');
$this->addSql('ALTER TABLE channel_setting DROP FOREIGN KEY FK_28378799979B1AD6');
$this->addSql('ALTER TABLE deeplink_button DROP FOREIGN KEY FK_103C73C4979B1AD6');
$this->addSql('ALTER TABLE dynamic_rule DROP FOREIGN KEY FK_57A7B628979B1AD6');
$this->addSql('ALTER TABLE image DROP FOREIGN KEY FK_C53D045F979B1AD6');
$this->addSql('ALTER TABLE lucky_wheel_setting DROP FOREIGN KEY FK_F556CFDB979B1AD6');
$this->addSql('ALTER TABLE schema_org_question DROP FOREIGN KEY FK_EAA517F5979B1AD6');
$this->addSql('ALTER TABLE schema_org_rating DROP FOREIGN KEY FK_E2AE8569979B1AD6');
$this->addSql('ALTER TABLE scratch_card_setting DROP FOREIGN KEY FK_E54AA5B2979B1AD6');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D649979B1AD6');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D8979B1AD6');
$this->addSql('ALTER TABLE voucher_condition DROP FOREIGN KEY FK_292C149F979B1AD6');
$this->addSql('ALTER TABLE voucher_content DROP FOREIGN KEY FK_3D081AAE979B1AD6');
$this->addSql('ALTER TABLE voucher_generic DROP FOREIGN KEY FK_55828BD4979B1AD6');
$this->addSql('ALTER TABLE voucher_deeplink_button DROP FOREIGN KEY FK_72F7836EDB9AAD0E');
$this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DDAA32ED4A');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E473DA5256D');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D83DA5256D');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E4782F1BAF4');
$this->addSql('ALTER TABLE channel_footer_content DROP FOREIGN KEY FK_5283A09782F1BAF4');
$this->addSql('ALTER TABLE channel_footer_entry DROP FOREIGN KEY FK_4D62D56E82F1BAF4');
$this->addSql('ALTER TABLE channel_header_content DROP FOREIGN KEY FK_E48084E482F1BAF4');
$this->addSql('ALTER TABLE schema_org_question DROP FOREIGN KEY FK_EAA517F582F1BAF4');
$this->addSql('ALTER TABLE user_setting DROP FOREIGN KEY FK_C779A69282F1BAF4');
$this->addSql('ALTER TABLE voucher_condition DROP FOREIGN KEY FK_292C149F82F1BAF4');
$this->addSql('ALTER TABLE voucher_content DROP FOREIGN KEY FK_3D081AAE82F1BAF4');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D8A4118F63');
$this->addSql('ALTER TABLE lucky_wheel DROP FOREIGN KEY FK_EA9C8DF029F72054');
$this->addSql('ALTER TABLE channel_network DROP FOREIGN KEY FK_D7C7B8BD34128B91');
$this->addSql('ALTER TABLE channel_schema_org_question DROP FOREIGN KEY FK_931AF5B77671A710');
$this->addSql('ALTER TABLE channel DROP FOREIGN KEY FK_A2F98E4756DDD79C');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D89127E9E2');
$this->addSql('ALTER TABLE scratch_card DROP FOREIGN KEY FK_A363FEE0E5E20F89');
$this->addSql('ALTER TABLE user DROP FOREIGN KEY FK_8D93D64949527B9E');
$this->addSql('ALTER TABLE campaign DROP FOREIGN KEY FK_1F1512DD28AA1B6F');
$this->addSql('ALTER TABLE voucher_deeplink_button DROP FOREIGN KEY FK_72F7836E28AA1B6F');
$this->addSql('ALTER TABLE voucher_condition_position DROP FOREIGN KEY FK_AD8F14BD28AA1B6F');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D85095217');
$this->addSql('ALTER TABLE voucher_condition_position DROP FOREIGN KEY FK_AD8F14BD887793B6');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D884A0A3ED');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D8B8F19F66');
$this->addSql('ALTER TABLE voucher DROP FOREIGN KEY FK_1392A5D8C54C8C93');
$this->addSql('DROP TABLE calendar');
$this->addSql('DROP TABLE calendar_setting');
$this->addSql('DROP TABLE campaign');
$this->addSql('DROP TABLE campaign_type');
$this->addSql('DROP TABLE channel');
$this->addSql('DROP TABLE channel_schema_org_question');
$this->addSql('DROP TABLE channel_campaign');
$this->addSql('DROP TABLE channel_footer_content');
$this->addSql('DROP TABLE channel_footer_entry');
$this->addSql('DROP TABLE channel_footer_entry_position');
$this->addSql('DROP TABLE channel_header_content');
$this->addSql('DROP TABLE channel_layout');
$this->addSql('DROP TABLE channel_layout_channel');
$this->addSql('DROP TABLE channel_layout_type');
$this->addSql('DROP TABLE channel_meta');
$this->addSql('DROP TABLE channel_network');
$this->addSql('DROP TABLE channel_setting');
$this->addSql('DROP TABLE channel_type');
$this->addSql('DROP TABLE company');
$this->addSql('DROP TABLE deeplink_button');
$this->addSql('DROP TABLE dynamic_rule');
$this->addSql('DROP TABLE ext_log_entries');
$this->addSql('DROP TABLE image');
$this->addSql('DROP TABLE language');
$this->addSql('DROP TABLE lucky_wheel');
$this->addSql('DROP TABLE lucky_wheel_setting');
$this->addSql('DROP TABLE lucky_wheel_voucher');
$this->addSql('DROP TABLE network');
$this->addSql('DROP TABLE schema_org_question');
$this->addSql('DROP TABLE schema_org_rating');
$this->addSql('DROP TABLE scratch_card');
$this->addSql('DROP TABLE scratch_card_setting');
$this->addSql('DROP TABLE user');
$this->addSql('DROP TABLE user_setting');
$this->addSql('DROP TABLE voucher');
$this->addSql('DROP TABLE voucher_deeplink_button');
$this->addSql('DROP TABLE voucher_code_list');
$this->addSql('DROP TABLE voucher_condition');
$this->addSql('DROP TABLE voucher_condition_position');
$this->addSql('DROP TABLE voucher_content');
$this->addSql('DROP TABLE voucher_generic');
$this->addSql('DROP TABLE voucher_type');
}
}