Code Coverage
 
Classes and Traits
Functions and Methods
Lines
Total
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 2
CRAP
0.00% covered (danger)
0.00%
0 / 293
Version20150722170707
0.00% covered (danger)
0.00%
0 / 1
0.00% covered (danger)
0.00%
0 / 2
56
0.00% covered (danger)
0.00%
0 / 293
 up
0.00% covered (danger)
0.00%
0 / 1
42
0.00% covered (danger)
0.00%
0 / 291
 down
0.00% covered (danger)
0.00%
0 / 1
2
0.00% covered (danger)
0.00%
0 / 2
<?php
namespace DoctrineMigrations;
use Doctrine\DBAL\Migrations\AbstractMigration;
use Doctrine\DBAL\Schema\Schema;
/**
 * Auto-generated Migration: Please modify to your needs!
 */
class Version20150722170707 extends AbstractMigration
{
    /**
     * @param Schema $schema
     */
    public function up(Schema $schema)
    {
        if($this->connection->getDatabasePlatform()->getName() == "mysql"){
            // this up() migration is auto-generated, please modify it to your needs
            $this->addSql("alter table  dtb_base_info                 collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_block                     collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_block_position            collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_category                  collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_category_count            collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_category_total_count      collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_class_category            collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_class_name                collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_csv                       collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_customer                  collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_customer_address          collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_customer_favorite_product collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_delivery                  collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_delivery_date             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_delivery_fee              collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_delivery_time             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_help                      collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_mail_history              collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_mail_template             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_member                    collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_news                      collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_order                     collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_order_detail              collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_page_layout               collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_payment                   collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_payment_option            collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_plugin                    collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_plugin_event_handler      collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product                   collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product_category          collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product_class             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product_image             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product_stock             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_product_tag               collate utf8_general_ci ;");
            if ($schema->hasTable('dtb_send_customer')) {
                $this->addSql("alter table  dtb_send_customer             collate utf8_general_ci ;");
            }
            if ($schema->hasTable('dtb_send_history')) {
                $this->addSql("alter table  dtb_send_history              collate utf8_general_ci ;");
            }
            $this->addSql("alter table  dtb_shipment_item             collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_shipping                  collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_tax_rule                  collate utf8_general_ci ;");
            $this->addSql("alter table  dtb_template                  collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_authority                 collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_country                   collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_csv_type                  collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_customer_order_status     collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_customer_status           collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_db                        collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_device_type               collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_disp                      collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_job                       collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_order_status              collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_order_status_color        collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_page_max                  collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_pref                      collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_product_list_max          collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_product_list_order_by     collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_product_type              collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_sex                       collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_tag                       collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_taxrule                   collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_work                      collate utf8_general_ci ;");
            $this->addSql("alter table  mtb_zip                       collate utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify company_name            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify company_kana            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify zip01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify zip02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify zipcode                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify addr01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify addr02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify tel01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify tel02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify tel03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify fax01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify fax02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify fax03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify business_hour           longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify email01                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify email02                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify email03                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify email04                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify shop_name               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify shop_kana               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify shop_name_eng           longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify good_traded             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify message                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify latitude                longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_base_info             modify longitude               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_block                 modify block_name              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_block                 modify file_name               varchar(200)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_category              modify category_name           longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_class_category        modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_class_name            modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_csv                   modify entity_name             longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_csv                   modify field_name              longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_csv                   modify reference_field_name    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_csv                   modify disp_name               varchar(255)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify name01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify name02                  longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify kana01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify kana02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify company_name            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify zip01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify zip02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify zipcode                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify addr01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify addr02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify email                   longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify tel01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify tel02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify tel03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify fax01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify fax02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify fax03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify password                longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify salt                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify secret_key              varchar(200)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify note                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer              modify reset_key               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify name01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify name02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify kana01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify kana02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify company_name            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify zip01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify zip02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify zipcode                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify addr01                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify addr02                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify tel01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify tel02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify tel03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify fax01                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify fax02                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_customer_address      modify fax03                   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery              modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery              modify service_name            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery              modify description             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery              modify confirm_url             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery_date         modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_delivery_time         modify delivery_time           longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify customer_agreement      longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_company             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_manager             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_zip01               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_zip02               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_zipcode             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_addr01              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_addr02              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_tel01               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_tel02               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_tel03               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_fax01               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_fax02               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_fax03               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_email               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_url                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term01              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term02              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term03              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term04              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term05              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term06              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term07              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term08              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term09              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_help                  modify law_term10              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_history          modify subject                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_history          modify mail_body               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_template         modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_template         modify file_name               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_template         modify subject                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_template         modify header                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_mail_template         modify footer                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_member                modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_member                modify department              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_member                modify login_id                longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_member                modify password                longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_member                modify salt                    longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_news                  modify news_title              longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_news                  modify news_comment            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_news                  modify news_url                longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify pre_order_id            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify message                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_name01            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_name02            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_kana01            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_kana02            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_company_name      longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_email             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_tel01             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_tel02             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_tel03             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_fax01             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_fax02             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_fax03             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_zip01             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_zip02             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_zipcode           longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_addr01            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify order_addr02            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify payment_method          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order                 modify note                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify product_name            longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify product_code            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify class_name1             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify class_name2             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify class_category_name1    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_order_detail          modify class_category_name2    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify page_name               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify url                     longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify file_name               longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify author                  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify description             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify keyword                 longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify update_url              longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_page_layout           modify meta_robots             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_payment               modify payment_method          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_payment               modify payment_image           longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin                modify name                    longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin                modify code                    longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin                modify class_name              longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin                modify version                 varchar(255)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin                modify source                  longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin_event_handler  modify event                   varchar(255)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin_event_handler  modify handler                 varchar(255)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_plugin_event_handler  modify handler_type            varchar(255)  not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify name                    text          not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify note                    text                    COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify description_list        text                    COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify description_detail      text                    COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify search_word             text                    COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product               modify free_area               text                    COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product_class         modify product_code            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_product_image         modify file_name               longtext      not null           COLLATE utf8_general_ci ;");
            if ($schema->hasTable('dtb_send_customer')) {
                $this->addSql("alter table dtb_send_customer         modify email                   longtext                COLLATE utf8_general_ci ;");
                $this->addSql("alter table dtb_send_customer         modify name                    longtext                COLLATE utf8_general_ci ;");
            }
            if ($schema->hasTable('dtb_send_history')) {
                $this->addSql("alter table dtb_send_history          modify subject                 longtext                COLLATE utf8_general_ci ;");
                $this->addSql("alter table dtb_send_history          modify body                    longtext                COLLATE utf8_general_ci ;");
                $this->addSql("alter table dtb_send_history          modify search_data             longtext                COLLATE utf8_general_ci ;");
            }
            $this->addSql("alter table dtb_shipment_item         modify product_name            longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipment_item         modify product_code            longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipment_item         modify class_name1             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipment_item         modify class_name2             longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipment_item         modify class_category_name1    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipment_item         modify class_category_name2    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_name01         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_name02         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_kana01         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_kana02         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_company_name   longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_tel01          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_tel02          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_tel03          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_fax01          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_fax02          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_fax03          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_zip01          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_zip02          longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_zipcode        longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_addr01         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_addr02         longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_delivery_name  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_shipping              modify shipping_delivery_time  longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_template              modify template_code           longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table dtb_template              modify template_name           longtext      not null           COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_authority             modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_country               modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_csv_type              modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_customer_order_status modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_customer_status       modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_db                    modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_device_type           modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_disp                  modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_job                   modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_order_status          modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_order_status_color    modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_page_max              modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_pref                  modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_product_list_max      modify name                    longtext                COLLATE utf8_general_ci ;");
            $this->addSql("alter table mtb_product_list_order_by modify name                    longtext                COLLATE utf8_general_ci ;");
        }
    }
    /**
     * @param Schema $schema
     */
    public function down(Schema $schema)
    {
        // this down() migration is auto-generated, please modify it to your needs
    }
}