<?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 Version20240326073258 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('DROP SEQUENCE plussum1_skdev4.dtb_order_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_customer_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_product_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_cart_item_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_login_history_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_tradelaw_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_mail_history_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_class_category_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_payment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_order_item_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_delivery_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_product_stock_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_authority_role_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_customer_favorite_product_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_product_image_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_delivery_fee_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_plugin_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_cart_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_calendar_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_member_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_tax_rule_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_delivery_time_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_news_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_base_info_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_product_tag_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_template_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_csv_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_mail_template_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_block_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_delivery_duration_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_tag_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_customer_address_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_class_name_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_shipping_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_page_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_layout_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_product_class_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_category_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_entry_contact_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.dtb_deposit_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_entry_contact_mail_history_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_entry_contact_reply_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_apg_simple_calendar_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_apg_simple_calendar_holidays_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_api_webhook_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_contact_management4_mail_history_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_contact_management4_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_contact_management4_contact_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_contact_management4_contact_reply_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_coupon_detail_coupon_detail_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_coupon_order_coupon_order_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_coupon_coupon_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_customerrank_dtb_customer_rank_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_customerrank_dtb_customer_price_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_customerrank_dtb_config_status_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_ec_apg_simple_calendar_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_ec_apg_simple_calendar_holidays_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_line_integration_history_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_ec_mypage_receipt42_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_product_classes_regular_cycles_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_count_discount_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_cycle_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_credit_access_block_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_order_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_credit_access_log_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_ip_black_list_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_order_item_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_shipping_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_hsd_related_product_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_hsd_related_product_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_mailmaga_template_template_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_mailmaga_send_history_send_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_pinpoint_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_product_pinpoint_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_pinpoint_sale_config_option_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_pinpoint_repeat_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_pinpoint_sale_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_product_review_config_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_product_review_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_recommend_product_recommend_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_related_product_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_salesrestrictions_dtb_product_customer_rank_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_site_kit_id_token_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plussum1_skdev4.plg_sort_product_id_seq CASCADE');
$this->addSql('DROP TABLE migration_contactmanagement42');
$this->addSql('DROP TABLE migration_ecapgsimplecalendar');
$this->addSql('DROP TABLE migration_pinpointsaledx');
$this->addSql('ALTER TABLE dtb_base_info DROP site_kit_site_id');
$this->addSql('ALTER TABLE dtb_base_info DROP site_kit_site_secret');
$this->addSql('ALTER TABLE dtb_customer DROP CONSTRAINT fk_8298bbe36acbc331');
$this->addSql('DROP INDEX idx_8298bbe36acbc331');
$this->addSql('ALTER TABLE dtb_customer DROP customer_rank_id');
$this->addSql('ALTER TABLE dtb_customer DROP plg_mailmagazine_flg');
$this->addSql('ALTER TABLE dtb_customer DROP check_date');
$this->addSql('ALTER TABLE dtb_customer DROP gmo_epsilon_credit_card_expiration_date');
$this->addSql('ALTER TABLE dtb_customer DROP card_change_request_mail_send_date');
$this->addSql('ALTER TABLE dtb_delivery DROP CONSTRAINT fk_3420d9fa89de8df2');
$this->addSql('DROP INDEX idx_3420d9fa89de8df2');
$this->addSql('ALTER TABLE dtb_delivery DROP delivery_company_id');
$this->addSql('ALTER TABLE dtb_order DROP CONSTRAINT fk_1d66d80728de2f95');
$this->addSql('ALTER TABLE dtb_order DROP CONSTRAINT fk_1d66d80780e7cd1b');
$this->addSql('DROP INDEX idx_1d66d80780e7cd1b');
$this->addSql('DROP INDEX idx_1d66d80728de2f95');
$this->addSql('ALTER TABLE dtb_order DROP payment_status_id');
$this->addSql('ALTER TABLE dtb_order DROP regular_order_id');
$this->addSql('ALTER TABLE dtb_order DROP customer_rank_id');
$this->addSql('ALTER TABLE dtb_order DROP customer_rank_name');
$this->addSql('ALTER TABLE dtb_order DROP trans_code');
$this->addSql('ALTER TABLE dtb_order DROP gmo_epsilon_order_no');
$this->addSql('ALTER TABLE dtb_product DROP free_description_about_quantity');
$this->addSql('ALTER TABLE dtb_product DROP free_description_about_selling_price');
$this->addSql('ALTER TABLE dtb_product DROP free_description_of_payment_delivery');
$this->addSql('ALTER TABLE dtb_product_class DROP CONSTRAINT fk_1a11d1ba86aedc4c');
$this->addSql('DROP INDEX idx_1a11d1ba86aedc4c');
$this->addSql('ALTER TABLE dtb_product_class DROP regular_discount_id');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE SCHEMA public');
$this->addSql('CREATE SCHEMA plussum1_skdev4');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_order_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_customer_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_product_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_cart_item_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_login_history_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_tradelaw_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_mail_history_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_class_category_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_payment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_order_item_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_delivery_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_product_stock_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_authority_role_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_customer_favorite_product_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_product_image_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_delivery_fee_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_plugin_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_cart_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_calendar_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_member_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_tax_rule_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_delivery_time_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_news_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_base_info_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_product_tag_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_template_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_csv_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_mail_template_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_block_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_delivery_duration_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_tag_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_customer_address_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_class_name_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_shipping_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_page_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_layout_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_product_class_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_category_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_entry_contact_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.dtb_deposit_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_entry_contact_mail_history_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_entry_contact_reply_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_apg_simple_calendar_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_apg_simple_calendar_holidays_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_api_webhook_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_contact_management4_mail_history_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_contact_management4_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_contact_management4_contact_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_contact_management4_contact_reply_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_coupon_detail_coupon_detail_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_coupon_order_coupon_order_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_coupon_coupon_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_customerrank_dtb_customer_rank_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_customerrank_dtb_customer_price_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_customerrank_dtb_config_status_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_ec_apg_simple_calendar_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_ec_apg_simple_calendar_holidays_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_line_integration_history_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_ec_mypage_receipt42_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_product_classes_regular_cycles_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_count_discount_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_cycle_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_credit_access_block_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_order_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_credit_access_log_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_ip_black_list_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_order_item_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_eccube_payment_lite42_regular_shipping_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_hsd_related_product_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_hsd_related_product_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_mailmaga_template_template_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_mailmaga_send_history_send_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_pinpoint_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_product_pinpoint_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_pinpoint_sale_config_option_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_pinpoint_repeat_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_pinpoint_sale_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_product_review_config_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_product_review_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_recommend_product_recommend_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_related_product_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_salesrestrictions_dtb_product_customer_rank_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_site_kit_id_token_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE plussum1_skdev4.plg_sort_product_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE TABLE migration_contactmanagement42 (version VARCHAR(191) NOT NULL, executed_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY(version))');
$this->addSql('COMMENT ON COLUMN migration_contactmanagement42.executed_at IS \'(DC2Type:datetime)\'');
$this->addSql('CREATE TABLE migration_ecapgsimplecalendar (version VARCHAR(191) NOT NULL, executed_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY(version))');
$this->addSql('COMMENT ON COLUMN migration_ecapgsimplecalendar.executed_at IS \'(DC2Type:datetime)\'');
$this->addSql('CREATE TABLE migration_pinpointsaledx (version VARCHAR(191) NOT NULL, executed_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, execution_time INT DEFAULT NULL, PRIMARY KEY(version))');
$this->addSql('COMMENT ON COLUMN migration_pinpointsaledx.executed_at IS \'(DC2Type:datetime)\'');
$this->addSql('ALTER TABLE dtb_product_class ADD regular_discount_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_product_class ADD CONSTRAINT fk_1a11d1ba86aedc4c FOREIGN KEY (regular_discount_id) REFERENCES plg_eccube_payment_lite42_regular_count_discount (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE INDEX idx_1a11d1ba86aedc4c ON dtb_product_class (regular_discount_id)');
$this->addSql('ALTER TABLE dtb_order ADD payment_status_id SMALLINT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD regular_order_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD customer_rank_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD customer_rank_name VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD trans_code VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD gmo_epsilon_order_no VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_order ADD CONSTRAINT fk_1d66d80728de2f95 FOREIGN KEY (payment_status_id) REFERENCES plg_eccube_payment_lite42_payment_status (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE dtb_order ADD CONSTRAINT fk_1d66d80780e7cd1b FOREIGN KEY (regular_order_id) REFERENCES plg_eccube_payment_lite42_regular_order (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE INDEX idx_1d66d80780e7cd1b ON dtb_order (regular_order_id)');
$this->addSql('CREATE INDEX idx_1d66d80728de2f95 ON dtb_order (payment_status_id)');
$this->addSql('ALTER TABLE dtb_product ADD free_description_about_quantity TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_product ADD free_description_about_selling_price TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_product ADD free_description_of_payment_delivery TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_base_info ADD site_kit_site_id VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_base_info ADD site_kit_site_secret VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_customer ADD customer_rank_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_customer ADD plg_mailmagazine_flg SMALLINT DEFAULT 0');
$this->addSql('ALTER TABLE dtb_customer ADD check_date TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_customer ADD gmo_epsilon_credit_card_expiration_date TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_customer ADD card_change_request_mail_send_date TIMESTAMP(0) WITH TIME ZONE DEFAULT NULL');
$this->addSql('COMMENT ON COLUMN dtb_customer.check_date IS \'(DC2Type:datetimetz)\'');
$this->addSql('COMMENT ON COLUMN dtb_customer.gmo_epsilon_credit_card_expiration_date IS \'(DC2Type:datetimetz)\'');
$this->addSql('COMMENT ON COLUMN dtb_customer.card_change_request_mail_send_date IS \'(DC2Type:datetimetz)\'');
$this->addSql('ALTER TABLE dtb_customer ADD CONSTRAINT fk_8298bbe36acbc331 FOREIGN KEY (customer_rank_id) REFERENCES plg_customerrank_dtb_customer_rank (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE INDEX idx_8298bbe36acbc331 ON dtb_customer (customer_rank_id)');
$this->addSql('ALTER TABLE dtb_delivery ADD delivery_company_id SMALLINT DEFAULT NULL');
$this->addSql('ALTER TABLE dtb_delivery ADD CONSTRAINT fk_3420d9fa89de8df2 FOREIGN KEY (delivery_company_id) REFERENCES plg_eccube_payment_lite42_delivery_company (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE INDEX idx_3420d9fa89de8df2 ON dtb_delivery (delivery_company_id)');
}
}