migrations/Version20220602091827.php line 1

Open in your IDE?
  1. <?php
  3. declare(strict_types=1);
  5. namespace DoctrineMigrations;
  7. use Doctrine\DBAL\Schema\Schema;
  8. use Doctrine\Migrations\AbstractMigration;
  10. /**
  11. * Auto-generated Migration: Please modify to your needs!
  12. */
  13. final class Version20220602091827 extends AbstractMigration
  14. {
  15. public function getDescription(): string
  16. {
  17. return '';
  18. }
  20. public function up(Schema $schema): void
  21. {
  22. // this up() migration is auto-generated, please modify it to your needs
  23. $this->addSql('CREATE TABLE account_notifications (id INT AUTO_INCREMENT NOT NULL, user_id VARCHAR(36) DEFAULT NULL, label VARCHAR(255) NOT NULL, link VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, status TINYINT(1) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_FF268C60A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  24. $this->addSql('CREATE TABLE account_users (id VARCHAR(36) NOT NULL, created_by_id VARCHAR(36) DEFAULT NULL, updated_by_id VARCHAR(36) DEFAULT NULL, email VARCHAR(180) NOT NULL, roles LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', password VARCHAR(255) NOT NULL, enabled TINYINT(1) NOT NULL, token VARCHAR(63) DEFAULT NULL, token_at DATETIME DEFAULT NULL, first_name VARCHAR(255) DEFAULT NULL, last_name VARCHAR(255) DEFAULT NULL, phone_number VARCHAR(20) DEFAULT NULL, description LONGTEXT DEFAULT NULL, role_description VARCHAR(255) DEFAULT NULL, avatar TINYINT(1) DEFAULT NULL, gender VARCHAR(2) DEFAULT NULL, birth_at DATE DEFAULT NULL, is_verified TINYINT(1) NOT NULL, address_street VARCHAR(255) DEFAULT NULL, address_post_code VARCHAR(15) DEFAULT NULL, address_city VARCHAR(255) DEFAULT NULL, address_country VARCHAR(2) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_220C7C98E7927C74 (email), INDEX IDX_220C7C98B03A8386 (created_by_id), INDEX IDX_220C7C98896DBBDE (updated_by_id), FULLTEXT INDEX IDX_220C7C98E7927C74 (email), FULLTEXT INDEX IDX_220C7C98A9D1C132 (first_name), FULLTEXT INDEX IDX_220C7C98C808BA5A (last_name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  25. $this->addSql('CREATE TABLE app (id INT AUTO_INCREMENT NOT NULL, label VARCHAR(31) NOT NULL, queue_name VARCHAR(31) NOT NULL, secret VARCHAR(36) NOT NULL, UNIQUE INDEX UNIQ_C96E70CFFB7336F0 (queue_name), UNIQUE INDEX UNIQ_C96E70CF5CA2E8E5 (secret), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  26. $this->addSql('CREATE TABLE channel_agreements (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, dtype VARCHAR(255) NOT NULL, agreement_number VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  27. $this->addSql('CREATE TABLE channel_channel_permissions (id VARCHAR(36) NOT NULL, user_id VARCHAR(36) NOT NULL, target_id VARCHAR(36) NOT NULL, created_by_id VARCHAR(36) DEFAULT NULL, updated_by_id VARCHAR(36) DEFAULT NULL, perms LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', expire_at DATETIME DEFAULT NULL, status VARCHAR(15) NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_4D88D10CA76ED395 (user_id), INDEX IDX_4D88D10C158E0B66 (target_id), INDEX IDX_4D88D10CB03A8386 (created_by_id), INDEX IDX_4D88D10C896DBBDE (updated_by_id), UNIQUE INDEX UNIQ_4D88D10CA76ED395158E0B66 (user_id, target_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  28. $this->addSql('CREATE TABLE channel_channels (id VARCHAR(36) NOT NULL, agreement_id INT DEFAULT NULL, professional_id_id INT DEFAULT NULL, owner_id VARCHAR(36) NOT NULL, image_id INT DEFAULT NULL, created_by_id VARCHAR(36) DEFAULT NULL, updated_by_id VARCHAR(36) DEFAULT NULL, name VARCHAR(63) NOT NULL, approved TINYINT(1) NOT NULL, address_street VARCHAR(255) DEFAULT NULL, address_post_code VARCHAR(15) DEFAULT NULL, address_city VARCHAR(255) DEFAULT NULL, address_country VARCHAR(2) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_84A4911F24890B2B (agreement_id), UNIQUE INDEX UNIQ_84A4911F1E3D24BD (professional_id_id), INDEX IDX_84A4911F7E3C61F9 (owner_id), INDEX IDX_84A4911F3DA5256D (image_id), INDEX IDX_84A4911FB03A8386 (created_by_id), INDEX IDX_84A4911F896DBBDE (updated_by_id), FULLTEXT INDEX IDX_84A4911F5E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  29. $this->addSql('CREATE TABLE channel_groups (id VARCHAR(36) NOT NULL, channel_id VARCHAR(36) NOT NULL, label VARCHAR(255) NOT NULL, INDEX IDX_E0E030E72F5A1AA (channel_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  30. $this->addSql('CREATE TABLE channel_group_users (group_id VARCHAR(36) NOT NULL, user_id VARCHAR(36) NOT NULL, INDEX IDX_5D7571AFFE54D947 (group_id), INDEX IDX_5D7571AFA76ED395 (user_id), PRIMARY KEY(group_id, user_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  31. $this->addSql('CREATE TABLE channel_images (id INT AUTO_INCREMENT NOT NULL, owner_channel_id VARCHAR(36) NOT NULL, name VARCHAR(36) NOT NULL, extension VARCHAR(6) NOT NULL, title VARCHAR(63) NOT NULL, description VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_1E7C8414209F38EF (owner_channel_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  32. $this->addSql('CREATE TABLE channel_links (id INT AUTO_INCREMENT NOT NULL, channel_id VARCHAR(36) NOT NULL, label VARCHAR(255) NOT NULL, url VARCHAR(511) NOT NULL, INDEX IDX_66A3A98072F5A1AA (channel_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  33. $this->addSql('CREATE TABLE channel_orders (id VARCHAR(36) NOT NULL, user_id VARCHAR(36) DEFAULT NULL, channel_id VARCHAR(36) NOT NULL, created_by_id VARCHAR(36) DEFAULT NULL, updated_by_id VARCHAR(36) DEFAULT NULL, status INT NOT NULL, amount NUMERIC(10, 2) NOT NULL, json_data LONGTEXT NOT NULL COMMENT \'(DC2Type:json)\', transaction_pay_plug_id VARCHAR(255) DEFAULT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, INDEX IDX_1B4CC790A76ED395 (user_id), INDEX IDX_1B4CC79072F5A1AA (channel_id), INDEX IDX_1B4CC790B03A8386 (created_by_id), INDEX IDX_1B4CC790896DBBDE (updated_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  34. $this->addSql('CREATE TABLE order_product (order_id VARCHAR(36) NOT NULL, product_id INT NOT NULL, INDEX IDX_2530ADE68D9F6D38 (order_id), INDEX IDX_2530ADE64584665A (product_id), PRIMARY KEY(order_id, product_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  35. $this->addSql('CREATE TABLE channel_products (id INT AUTO_INCREMENT NOT NULL, source_id INT DEFAULT NULL, channel_id VARCHAR(36) NOT NULL, label VARCHAR(255) NOT NULL, price NUMERIC(10, 2) DEFAULT NULL, INDEX IDX_C40A29F3953C1C61 (source_id), INDEX IDX_C40A29F372F5A1AA (channel_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  36. $this->addSql('CREATE TABLE channel_professional_ids (id INT AUTO_INCREMENT NOT NULL, created_at DATETIME NOT NULL, updated_at DATETIME DEFAULT NULL, dtype VARCHAR(255) NOT NULL, vatin VARCHAR(100) DEFAULT NULL, siret VARCHAR(14) DEFAULT NULL, naf VARCHAR(20) DEFAULT NULL, rcs VARCHAR(255) DEFAULT NULL, rm VARCHAR(255) DEFAULT NULL, capital_type VARCHAR(100) DEFAULT NULL, capital_amount NUMERIC(12, 2) DEFAULT NULL, legal_form VARCHAR(20) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  37. $this->addSql('CREATE TABLE channel_user_from_channels (id INT AUTO_INCREMENT NOT NULL, user_id VARCHAR(36) DEFAULT NULL, channel_id VARCHAR(36) NOT NULL, created_by_id VARCHAR(36) DEFAULT NULL, created_at DATETIME NOT NULL, UNIQUE INDEX UNIQ_382F4975A76ED395 (user_id), INDEX IDX_382F497572F5A1AA (channel_id), INDEX IDX_382F4975B03A8386 (created_by_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  38. $this->addSql('CREATE TABLE oauth_access_token (id INT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id VARCHAR(36) DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_F7FA86A45F37A13B (token), INDEX IDX_F7FA86A419EB6921 (client_id), INDEX IDX_F7FA86A4A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  39. $this->addSql('CREATE TABLE oauth_auth_code (id INT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id VARCHAR(36) DEFAULT NULL, token VARCHAR(255) NOT NULL, redirect_uri LONGTEXT NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_4D12F0E05F37A13B (token), INDEX IDX_4D12F0E019EB6921 (client_id), INDEX IDX_4D12F0E0A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  40. $this->addSql('CREATE TABLE oauth_client (id INT AUTO_INCREMENT NOT NULL, random_id VARCHAR(255) NOT NULL, redirect_uris LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', secret VARCHAR(255) NOT NULL, allowed_grant_types LONGTEXT NOT NULL COMMENT \'(DC2Type:array)\', auto_accept TINYINT(1) NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  41. $this->addSql('CREATE TABLE oauth_refresh_token (id INT AUTO_INCREMENT NOT NULL, client_id INT NOT NULL, user_id VARCHAR(36) DEFAULT NULL, token VARCHAR(255) NOT NULL, expires_at INT DEFAULT NULL, scope VARCHAR(255) DEFAULT NULL, UNIQUE INDEX UNIQ_55DCF7555F37A13B (token), INDEX IDX_55DCF75519EB6921 (client_id), INDEX IDX_55DCF755A76ED395 (user_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
  42. $this->addSql('ALTER TABLE account_notifications ADD CONSTRAINT FK_FF268C60A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id)');
  43. $this->addSql('ALTER TABLE account_users ADD CONSTRAINT FK_220C7C98B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  44. $this->addSql('ALTER TABLE account_users ADD CONSTRAINT FK_220C7C98896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  45. $this->addSql('ALTER TABLE channel_channel_permissions ADD CONSTRAINT FK_4D88D10CA76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id)');
  46. $this->addSql('ALTER TABLE channel_channel_permissions ADD CONSTRAINT FK_4D88D10C158E0B66 FOREIGN KEY (target_id) REFERENCES channel_channels (id)');
  47. $this->addSql('ALTER TABLE channel_channel_permissions ADD CONSTRAINT FK_4D88D10CB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  48. $this->addSql('ALTER TABLE channel_channel_permissions ADD CONSTRAINT FK_4D88D10C896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  49. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911F24890B2B FOREIGN KEY (agreement_id) REFERENCES channel_agreements (id)');
  50. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911F1E3D24BD FOREIGN KEY (professional_id_id) REFERENCES channel_professional_ids (id)');
  51. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911F7E3C61F9 FOREIGN KEY (owner_id) REFERENCES account_users (id)');
  52. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911F3DA5256D FOREIGN KEY (image_id) REFERENCES channel_images (id) ON DELETE SET NULL');
  53. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911FB03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  54. $this->addSql('ALTER TABLE channel_channels ADD CONSTRAINT FK_84A4911F896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  55. $this->addSql('ALTER TABLE channel_groups ADD CONSTRAINT FK_E0E030E72F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id)');
  56. $this->addSql('ALTER TABLE channel_group_users ADD CONSTRAINT FK_5D7571AFFE54D947 FOREIGN KEY (group_id) REFERENCES channel_groups (id) ON DELETE CASCADE');
  57. $this->addSql('ALTER TABLE channel_group_users ADD CONSTRAINT FK_5D7571AFA76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id) ON DELETE CASCADE');
  58. $this->addSql('ALTER TABLE channel_images ADD CONSTRAINT FK_1E7C8414209F38EF FOREIGN KEY (owner_channel_id) REFERENCES channel_channels (id)');
  59. $this->addSql('ALTER TABLE channel_links ADD CONSTRAINT FK_66A3A98072F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id)');
  60. $this->addSql('ALTER TABLE channel_orders ADD CONSTRAINT FK_1B4CC790A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id)');
  61. $this->addSql('ALTER TABLE channel_orders ADD CONSTRAINT FK_1B4CC79072F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id)');
  62. $this->addSql('ALTER TABLE channel_orders ADD CONSTRAINT FK_1B4CC790B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  63. $this->addSql('ALTER TABLE channel_orders ADD CONSTRAINT FK_1B4CC790896DBBDE FOREIGN KEY (updated_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  64. $this->addSql('ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE68D9F6D38 FOREIGN KEY (order_id) REFERENCES channel_orders (id) ON DELETE CASCADE');
  65. $this->addSql('ALTER TABLE order_product ADD CONSTRAINT FK_2530ADE64584665A FOREIGN KEY (product_id) REFERENCES channel_products (id) ON DELETE CASCADE');
  66. $this->addSql('ALTER TABLE channel_products ADD CONSTRAINT FK_C40A29F3953C1C61 FOREIGN KEY (source_id) REFERENCES app (id)');
  67. $this->addSql('ALTER TABLE channel_products ADD CONSTRAINT FK_C40A29F372F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id)');
  68. $this->addSql('ALTER TABLE channel_user_from_channels ADD CONSTRAINT FK_382F4975A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id)');
  69. $this->addSql('ALTER TABLE channel_user_from_channels ADD CONSTRAINT FK_382F497572F5A1AA FOREIGN KEY (channel_id) REFERENCES channel_channels (id)');
  70. $this->addSql('ALTER TABLE channel_user_from_channels ADD CONSTRAINT FK_382F4975B03A8386 FOREIGN KEY (created_by_id) REFERENCES account_users (id) ON DELETE SET NULL');
  71. $this->addSql('ALTER TABLE oauth_access_token ADD CONSTRAINT FK_F7FA86A419EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)');
  72. $this->addSql('ALTER TABLE oauth_access_token ADD CONSTRAINT FK_F7FA86A4A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id) ON DELETE CASCADE');
  73. $this->addSql('ALTER TABLE oauth_auth_code ADD CONSTRAINT FK_4D12F0E019EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)');
  74. $this->addSql('ALTER TABLE oauth_auth_code ADD CONSTRAINT FK_4D12F0E0A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id) ON DELETE CASCADE');
  75. $this->addSql('ALTER TABLE oauth_refresh_token ADD CONSTRAINT FK_55DCF75519EB6921 FOREIGN KEY (client_id) REFERENCES oauth_client (id)');
  76. $this->addSql('ALTER TABLE oauth_refresh_token ADD CONSTRAINT FK_55DCF755A76ED395 FOREIGN KEY (user_id) REFERENCES account_users (id) ON DELETE CASCADE');
  77. }
  79. public function down(Schema $schema): void
  80. {
  81. // this down() migration is auto-generated, please modify it to your needs
  82. $this->addSql('ALTER TABLE account_notifications DROP FOREIGN KEY FK_FF268C60A76ED395');
  83. $this->addSql('ALTER TABLE account_users DROP FOREIGN KEY FK_220C7C98B03A8386');
  84. $this->addSql('ALTER TABLE account_users DROP FOREIGN KEY FK_220C7C98896DBBDE');
  85. $this->addSql('ALTER TABLE channel_channel_permissions DROP FOREIGN KEY FK_4D88D10CA76ED395');
  86. $this->addSql('ALTER TABLE channel_channel_permissions DROP FOREIGN KEY FK_4D88D10CB03A8386');
  87. $this->addSql('ALTER TABLE channel_channel_permissions DROP FOREIGN KEY FK_4D88D10C896DBBDE');
  88. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911F7E3C61F9');
  89. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911FB03A8386');
  90. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911F896DBBDE');
  91. $this->addSql('ALTER TABLE channel_group_users DROP FOREIGN KEY FK_5D7571AFA76ED395');
  92. $this->addSql('ALTER TABLE channel_orders DROP FOREIGN KEY FK_1B4CC790A76ED395');
  93. $this->addSql('ALTER TABLE channel_orders DROP FOREIGN KEY FK_1B4CC790B03A8386');
  94. $this->addSql('ALTER TABLE channel_orders DROP FOREIGN KEY FK_1B4CC790896DBBDE');
  95. $this->addSql('ALTER TABLE channel_user_from_channels DROP FOREIGN KEY FK_382F4975A76ED395');
  96. $this->addSql('ALTER TABLE channel_user_from_channels DROP FOREIGN KEY FK_382F4975B03A8386');
  97. $this->addSql('ALTER TABLE oauth_access_token DROP FOREIGN KEY FK_F7FA86A4A76ED395');
  98. $this->addSql('ALTER TABLE oauth_auth_code DROP FOREIGN KEY FK_4D12F0E0A76ED395');
  99. $this->addSql('ALTER TABLE oauth_refresh_token DROP FOREIGN KEY FK_55DCF755A76ED395');
  100. $this->addSql('ALTER TABLE channel_products DROP FOREIGN KEY FK_C40A29F3953C1C61');
  101. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911F24890B2B');
  102. $this->addSql('ALTER TABLE channel_channel_permissions DROP FOREIGN KEY FK_4D88D10C158E0B66');
  103. $this->addSql('ALTER TABLE channel_groups DROP FOREIGN KEY FK_E0E030E72F5A1AA');
  104. $this->addSql('ALTER TABLE channel_images DROP FOREIGN KEY FK_1E7C8414209F38EF');
  105. $this->addSql('ALTER TABLE channel_links DROP FOREIGN KEY FK_66A3A98072F5A1AA');
  106. $this->addSql('ALTER TABLE channel_orders DROP FOREIGN KEY FK_1B4CC79072F5A1AA');
  107. $this->addSql('ALTER TABLE channel_products DROP FOREIGN KEY FK_C40A29F372F5A1AA');
  108. $this->addSql('ALTER TABLE channel_user_from_channels DROP FOREIGN KEY FK_382F497572F5A1AA');
  109. $this->addSql('ALTER TABLE channel_group_users DROP FOREIGN KEY FK_5D7571AFFE54D947');
  110. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911F3DA5256D');
  111. $this->addSql('ALTER TABLE order_product DROP FOREIGN KEY FK_2530ADE68D9F6D38');
  112. $this->addSql('ALTER TABLE order_product DROP FOREIGN KEY FK_2530ADE64584665A');
  113. $this->addSql('ALTER TABLE channel_channels DROP FOREIGN KEY FK_84A4911F1E3D24BD');
  114. $this->addSql('ALTER TABLE oauth_access_token DROP FOREIGN KEY FK_F7FA86A419EB6921');
  115. $this->addSql('ALTER TABLE oauth_auth_code DROP FOREIGN KEY FK_4D12F0E019EB6921');
  116. $this->addSql('ALTER TABLE oauth_refresh_token DROP FOREIGN KEY FK_55DCF75519EB6921');
  117. $this->addSql('DROP TABLE account_notifications');
  118. $this->addSql('DROP TABLE account_users');
  119. $this->addSql('DROP TABLE app');
  120. $this->addSql('DROP TABLE channel_agreements');
  121. $this->addSql('DROP TABLE channel_channel_permissions');
  122. $this->addSql('DROP TABLE channel_channels');
  123. $this->addSql('DROP TABLE channel_groups');
  124. $this->addSql('DROP TABLE channel_group_users');
  125. $this->addSql('DROP TABLE channel_images');
  126. $this->addSql('DROP TABLE channel_links');
  127. $this->addSql('DROP TABLE channel_orders');
  128. $this->addSql('DROP TABLE order_product');
  129. $this->addSql('DROP TABLE channel_products');
  130. $this->addSql('DROP TABLE channel_professional_ids');
  131. $this->addSql('DROP TABLE channel_user_from_channels');
  132. $this->addSql('DROP TABLE oauth_access_token');
  133. $this->addSql('DROP TABLE oauth_auth_code');
  134. $this->addSql('DROP TABLE oauth_client');
  135. $this->addSql('DROP TABLE oauth_refresh_token');
  136. }
  137. }