EC-CUBE2.11.5から2.13.5にマイグレーションするんでDDLの差分とった

EC-CUBE2.11.5から2.13.5にマイグレーションするんでDDLの差分とったこんなかんじ

--- db_eccube_2_11_5.ddl.txt
+++ db_eccube_2_13_5.ddl.txt
@@ -1,9 +1,43 @@
+CREATE TABLE dtb_api_account
+(
+    api_account_id INT PRIMARY KEY NOT NULL,
+    api_access_key LONGTEXT NOT NULL,
+    api_secret_key LONGTEXT NOT NULL,
+    enable SMALLINT DEFAULT 0 NOT NULL,
+    del_flg SMALLINT DEFAULT 0 NOT NULL,
+    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
+);
+CREATE TABLE dtb_api_account_api_account_id_seq
+(
+    sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
+);
+CREATE TABLE dtb_api_config
+(
+    api_config_id INT PRIMARY KEY NOT NULL,
+    operation_name LONGTEXT NOT NULL,
+    operation_description LONGTEXT,
+    auth_types LONGTEXT NOT NULL,
+    enable SMALLINT DEFAULT 0 NOT NULL,
+    is_log SMALLINT DEFAULT 0 NOT NULL,
+    sub_data LONGTEXT,
+    del_flg SMALLINT DEFAULT 0 NOT NULL,
+    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
+);
+CREATE TABLE dtb_api_config_api_config_id_seq
+(
+    sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
+);
 CREATE TABLE dtb_baseinfo
 (
+    id INT PRIMARY KEY NOT NULL,
     company_name LONGTEXT,
     company_kana LONGTEXT,
     zip01 LONGTEXT,
     zip02 LONGTEXT,
+    zipcode LONGTEXT,
+    country_id INT,
     pref SMALLINT,
     addr01 LONGTEXT,
     addr02 LONGTEXT,
@@ -18,6 +52,8 @@
     law_manager LONGTEXT,
     law_zip01 LONGTEXT,
     law_zip02 LONGTEXT,
+    law_zipcode LONGTEXT,
+    law_country_id INT,
     law_pref SMALLINT,
     law_addr01 LONGTEXT,
     law_addr02 LONGTEXT,
@@ -39,13 +75,10 @@
     law_term08 LONGTEXT,
     law_term09 LONGTEXT,
     law_term10 LONGTEXT,
-    tax DECIMAL(10,0) DEFAULT 5 NOT NULL,
-    tax_rule SMALLINT DEFAULT 1 NOT NULL,
     email01 LONGTEXT,
     email02 LONGTEXT,
     email03 LONGTEXT,
     email04 LONGTEXT,
-    email05 LONGTEXT,
     free_rule DECIMAL(10,0),
     shop_name LONGTEXT,
     shop_kana LONGTEXT,
@@ -84,7 +117,7 @@
 );
 CREATE TABLE dtb_bkup
 (
-    bkup_name VARCHAR(50) PRIMARY KEY NOT NULL,
+    bkup_name LONGTEXT PRIMARY KEY NOT NULL,
     bkup_memo LONGTEXT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
@@ -94,11 +127,12 @@
     bloc_id INT NOT NULL,
     bloc_name LONGTEXT,
     tpl_path LONGTEXT,
-    filename VARCHAR(50) NOT NULL,
+    filename LONGTEXT NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
     php_path LONGTEXT,
     deletable_flg SMALLINT DEFAULT 1 NOT NULL,
+    plugin_id INT,
     PRIMARY KEY ( device_type_id, bloc_id )
 );
 CREATE TABLE dtb_bloc_bloc_id_seq
@@ -133,13 +167,13 @@
 );
 CREATE TABLE dtb_category_count
 (
-    category_id INT NOT NULL,
+    category_id INT PRIMARY KEY NOT NULL,
     product_count INT NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
 CREATE TABLE dtb_category_total_count
 (
-    category_id INT NOT NULL,
+    category_id INT PRIMARY KEY NOT NULL,
     product_count INT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
@@ -157,17 +191,6 @@
 (
     sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
 );
-CREATE TABLE dtb_class_combination
-(
-    class_combination_id INT PRIMARY KEY NOT NULL,
-    parent_class_combination_id INT,
-    classcategory_id INT NOT NULL,
-    level INT
-);
-CREATE TABLE dtb_class_combination_class_combination_id_seq
-(
-    sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
-);
 CREATE TABLE dtb_classcategory
 (
     classcategory_id INT PRIMARY KEY NOT NULL,
@@ -219,10 +242,13 @@
     customer_id INT PRIMARY KEY NOT NULL,
     name01 LONGTEXT NOT NULL,
     name02 LONGTEXT NOT NULL,
-    kana01 LONGTEXT NOT NULL,
-    kana02 LONGTEXT NOT NULL,
+    kana01 LONGTEXT,
+    kana02 LONGTEXT,
+    company_name LONGTEXT,
     zip01 LONGTEXT,
     zip02 LONGTEXT,
+    zipcode LONGTEXT,
+    country_id INT,
     pref SMALLINT,
     addr01 LONGTEXT,
     addr02 LONGTEXT,
@@ -241,28 +267,19 @@
     reminder SMALLINT,
     reminder_answer LONGTEXT,
     salt LONGTEXT,
-    secret_key VARCHAR(50) NOT NULL,
+    secret_key LONGTEXT NOT NULL,
     first_buy_date DATETIME,
     last_buy_date DATETIME,
     buy_times DECIMAL(10,0) DEFAULT 0,
     buy_total DECIMAL(10,0) DEFAULT 0,
-    point DECIMAL(10,0) DEFAULT 0,
+    point DECIMAL(10,0) DEFAULT 0 NOT NULL,
     note LONGTEXT,
     status SMALLINT DEFAULT 1 NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
     del_flg SMALLINT DEFAULT 0 NOT NULL,
     mobile_phone_id LONGTEXT,
-    mailmaga_flg SMALLINT,
-    old_payquick_id LONGTEXT,
-    old_card LONGTEXT,
-    old_expire LONGTEXT,
-    old_payquick_date LONGTEXT,
-    payquick_id LONGTEXT,
-    card LONGTEXT,
-    expire LONGTEXT,
-    payquick_date LONGTEXT,
-    payquick_flg LONGTEXT
+    mailmaga_flg SMALLINT
 );
 CREATE TABLE dtb_customer_customer_id_seq
 (
@@ -328,8 +345,8 @@
 );
 CREATE TABLE dtb_index_list
 (
-    table_name VARCHAR(30) NOT NULL,
-    column_name VARCHAR(30) NOT NULL,
+    table_name LONGTEXT NOT NULL,
+    column_name LONGTEXT NOT NULL,
     recommend_flg SMALLINT DEFAULT 0 NOT NULL,
     recommend_comment LONGTEXT,
     PRIMARY KEY ( table_name, column_name )
@@ -380,7 +397,7 @@
 );
 CREATE TABLE dtb_mailtemplate
 (
-    template_id INT NOT NULL,
+    template_id INT PRIMARY KEY NOT NULL,
     subject LONGTEXT,
     header LONGTEXT,
     footer LONGTEXT,
@@ -401,7 +418,7 @@
 );
 CREATE TABLE dtb_maker_count
 (
-    maker_id INT NOT NULL,
+    maker_id INT PRIMARY KEY NOT NULL,
     product_count INT NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL
 );
@@ -432,7 +449,7 @@
 );
 CREATE TABLE dtb_mobile_ext_session_id
 (
-    session_id LONGTEXT NOT NULL,
+    session_id LONGTEXT PRIMARY KEY NOT NULL,
     param_key LONGTEXT,
     param_value LONGTEXT,
     url LONGTEXT,
@@ -440,7 +457,7 @@
 );
 CREATE TABLE dtb_module
 (
-    module_id INT NOT NULL,
+    module_id INT PRIMARY KEY NOT NULL,
     module_code LONGTEXT NOT NULL,
     module_name LONGTEXT NOT NULL,
     sub_data LONGTEXT,
@@ -493,6 +510,7 @@
     order_name02 LONGTEXT,
     order_kana01 LONGTEXT,
     order_kana02 LONGTEXT,
+    order_company_name LONGTEXT,
     order_email LONGTEXT,
     order_tel01 LONGTEXT,
     order_tel02 LONGTEXT,
@@ -502,6 +520,8 @@
     order_fax03 LONGTEXT,
     order_zip01 LONGTEXT,
     order_zip02 LONGTEXT,
+    order_zipcode LONGTEXT,
+    order_country_id INT,
     order_pref SMALLINT,
     order_addr01 LONGTEXT,
     order_addr02 LONGTEXT,
@@ -509,13 +529,13 @@
     order_birth DATETIME,
     order_job INT,
     subtotal DECIMAL(10,0),
-    discount DECIMAL(10,0),
+    discount DECIMAL(10,0) DEFAULT 0 NOT NULL,
     deliv_id INT,
     deliv_fee DECIMAL(10,0),
     charge DECIMAL(10,0),
-    use_point DECIMAL(10,0),
-    add_point DECIMAL(10,0),
-    birth_point DECIMAL(10,0) DEFAULT 0,
+    use_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    add_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    birth_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
     tax DECIMAL(10,0),
     total DECIMAL(10,0),
     payment_total DECIMAL(10,0),
@@ -552,7 +572,9 @@
     classcategory_name2 LONGTEXT,
     price DECIMAL(10,0),
     quantity DECIMAL(10,0),
-    point_rate DECIMAL(10,0)
+    point_rate DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    tax_rate DECIMAL(10,0),
+    tax_rule SMALLINT
 );
 CREATE TABLE dtb_order_detail_order_detail_id_seq
 (
@@ -564,13 +586,14 @@
 );
 CREATE TABLE dtb_order_temp
 (
-    order_temp_id LONGTEXT NOT NULL,
+    order_temp_id LONGTEXT PRIMARY KEY NOT NULL,
     customer_id INT NOT NULL,
     message LONGTEXT,
     order_name01 LONGTEXT,
     order_name02 LONGTEXT,
     order_kana01 LONGTEXT,
     order_kana02 LONGTEXT,
+    order_company_name LONGTEXT,
     order_email LONGTEXT,
     order_tel01 LONGTEXT,
     order_tel02 LONGTEXT,
@@ -580,6 +603,8 @@
     order_fax03 LONGTEXT,
     order_zip01 LONGTEXT,
     order_zip02 LONGTEXT,
+    order_zipcode LONGTEXT,
+    order_country_id INT,
     order_pref SMALLINT,
     order_addr01 LONGTEXT,
     order_addr02 LONGTEXT,
@@ -587,13 +612,13 @@
     order_birth DATETIME,
     order_job INT,
     subtotal DECIMAL(10,0),
-    discount DECIMAL(10,0),
+    discount DECIMAL(10,0) DEFAULT 0 NOT NULL,
     deliv_id INT,
     deliv_fee DECIMAL(10,0),
     charge DECIMAL(10,0),
-    use_point DECIMAL(10,0),
-    add_point DECIMAL(10,0),
-    birth_point DECIMAL(10,0) DEFAULT 0,
+    use_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    add_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    birth_point DECIMAL(10,0) DEFAULT 0 NOT NULL,
     tax DECIMAL(10,0),
     total DECIMAL(10,0),
     payment_total DECIMAL(10,0),
@@ -629,14 +654,20 @@
     name02 LONGTEXT,
     kana01 LONGTEXT,
     kana02 LONGTEXT,
+    company_name LONGTEXT,
     zip01 LONGTEXT,
     zip02 LONGTEXT,
+    zipcode LONGTEXT,
+    country_id INT,
     pref SMALLINT,
     addr01 LONGTEXT,
     addr02 LONGTEXT,
     tel01 LONGTEXT,
     tel02 LONGTEXT,
-    tel03 LONGTEXT
+    tel03 LONGTEXT,
+    fax01 LONGTEXT,
+    fax02 LONGTEXT,
+    fax03 LONGTEXT
 );
 CREATE TABLE dtb_other_deliv_other_deliv_id_seq
 (
@@ -644,7 +675,7 @@
 );
 CREATE TABLE dtb_ownersstore_settings
 (
-    public_key LONGTEXT
+    public_key LONGTEXT PRIMARY KEY NOT NULL
 );
 CREATE TABLE dtb_pagelayout
 (
@@ -662,6 +693,7 @@
     update_url LONGTEXT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
+    meta_robots LONGTEXT,
     PRIMARY KEY ( device_type_id, page_id )
 );
 CREATE TABLE dtb_pagelayout_page_id_seq
@@ -673,7 +705,7 @@
     payment_id INT PRIMARY KEY NOT NULL,
     payment_method LONGTEXT,
     charge DECIMAL(10,0),
-    rule DECIMAL(10,0),
+    rule_max DECIMAL(10,0),
     rank INT,
     note LONGTEXT,
     fix SMALLINT,
@@ -698,22 +730,7 @@
     memo07 LONGTEXT,
     memo08 LONGTEXT,
     memo09 LONGTEXT,
-    memo10 LONGTEXT,
-    module_code LONGTEXT,
-    connect_type LONGTEXT,
-    gateway_credit_url LONGTEXT,
-    payquick LONGTEXT,
-    extset_url LONGTEXT,
-    securitycode LONGTEXT,
-    three_d_secure LONGTEXT,
-    gateway_convenience_url LONGTEXT,
-    job LONGTEXT,
-    pay_date LONGTEXT,
-    cvs LONGTEXT,
-    use_cardbrand LONGTEXT,
-    receiptmail_flg LONGTEXT,
-    receiptmail_id LONGTEXT,
-    extset_host_id LONGTEXT
+    memo10 LONGTEXT
 );
 CREATE TABLE dtb_payment_options
 (
@@ -729,21 +746,38 @@
 CREATE TABLE dtb_plugin
 (
     plugin_id INT PRIMARY KEY NOT NULL,
-    plugin_name VARCHAR(255) NOT NULL,
-    plugin_code VARCHAR(255) NOT NULL,
-    author VARCHAR(255),
-    plugin_site_url VARCHAR(255),
-    plugin_version VARCHAR(255),
-    plugin_description VARCHAR(255),
-    plugin_setting_path VARCHAR(255),
-    class_name VARCHAR(255) NOT NULL,
-    rank INT DEFAULT 0 NOT NULL,
-    status SMALLINT DEFAULT 0 NOT NULL,
+    plugin_name LONGTEXT NOT NULL,
+    plugin_code LONGTEXT NOT NULL,
+    class_name LONGTEXT NOT NULL,
+    author LONGTEXT,
+    author_site_url LONGTEXT,
+    plugin_site_url LONGTEXT,
+    plugin_version LONGTEXT,
+    compliant_version LONGTEXT,
+    plugin_description LONGTEXT,
+    priority INT DEFAULT 0 NOT NULL,
     enable SMALLINT DEFAULT 0 NOT NULL,
-    del_flg SMALLINT DEFAULT 0 NOT NULL,
+    free_field1 LONGTEXT,
+    free_field2 LONGTEXT,
+    free_field3 LONGTEXT,
+    free_field4 LONGTEXT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
 );
+CREATE TABLE dtb_plugin_hookpoint
+(
+    plugin_hookpoint_id INT PRIMARY KEY NOT NULL,
+    plugin_id INT NOT NULL,
+    hook_point LONGTEXT NOT NULL,
+    callback LONGTEXT,
+    use_flg SMALLINT DEFAULT 1 NOT NULL,
+    create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
+);
+CREATE TABLE dtb_plugin_hookpoint_plugin_hookpoint_id_seq
+(
+    sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
+);
 CREATE TABLE dtb_plugin_plugin_id_seq
 (
     sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
@@ -817,7 +851,8 @@
 (
     product_class_id INT PRIMARY KEY NOT NULL,
     product_id INT NOT NULL,
-    class_combination_id INT,
+    classcategory_id1 INT DEFAULT 0 NOT NULL,
+    classcategory_id2 INT DEFAULT 0 NOT NULL,
     product_type_id INT DEFAULT 0 NOT NULL,
     product_code LONGTEXT,
     stock DECIMAL(10,0),
@@ -826,7 +861,7 @@
     price01 DECIMAL(10,0),
     price02 DECIMAL(10,0) NOT NULL,
     deliv_fee DECIMAL(10,0),
-    point_rate DECIMAL(10,0),
+    point_rate DECIMAL(10,0) DEFAULT 0 NOT NULL,
     creator_id INT NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
@@ -851,7 +886,8 @@
     status SMALLINT DEFAULT 0 NOT NULL,
     creator_id INT NOT NULL,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
-    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
+    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
+    PRIMARY KEY ( product_id, recommend_product_id )
 );
 CREATE TABLE dtb_review
 (
@@ -876,7 +912,7 @@
 );
 CREATE TABLE dtb_send_customer
 (
-    customer_id INT DEFAULT 0 NOT NULL,
+    customer_id INT NOT NULL,
     send_id INT NOT NULL,
     email LONGTEXT,
     name LONGTEXT,
@@ -905,7 +941,7 @@
 );
 CREATE TABLE dtb_session
 (
-    sess_id VARCHAR(50) PRIMARY KEY NOT NULL,
+    sess_id LONGTEXT PRIMARY KEY NOT NULL,
     sess_data LONGTEXT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
     update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
@@ -931,21 +967,22 @@
     shipping_name02 LONGTEXT,
     shipping_kana01 LONGTEXT,
     shipping_kana02 LONGTEXT,
+    shipping_company_name LONGTEXT,
     shipping_tel01 LONGTEXT,
     shipping_tel02 LONGTEXT,
     shipping_tel03 LONGTEXT,
     shipping_fax01 LONGTEXT,
     shipping_fax02 LONGTEXT,
     shipping_fax03 LONGTEXT,
+    shipping_country_id INT,
     shipping_pref SMALLINT,
     shipping_zip01 LONGTEXT,
     shipping_zip02 LONGTEXT,
+    shipping_zipcode LONGTEXT,
     shipping_addr01 LONGTEXT,
     shipping_addr02 LONGTEXT,
-    deliv_id INT NOT NULL,
     time_id INT,
     shipping_time LONGTEXT,
-    shipping_num LONGTEXT,
     shipping_date DATETIME,
     shipping_commit_date DATETIME,
     rank INT,
@@ -954,9 +991,29 @@
     del_flg SMALLINT DEFAULT 0 NOT NULL,
     PRIMARY KEY ( shipping_id, order_id )
 );
+CREATE TABLE dtb_tax_rule
+(
+    tax_rule_id INT PRIMARY KEY NOT NULL,
+    country_id INT DEFAULT 0 NOT NULL,
+    pref_id INT DEFAULT 0 NOT NULL,
+    product_id INT DEFAULT 0 NOT NULL,
+    product_class_id INT DEFAULT 0 NOT NULL,
+    calc_rule SMALLINT DEFAULT 1 NOT NULL,
+    tax_rate DECIMAL(10,0) DEFAULT 8 NOT NULL,
+    tax_adjust DECIMAL(10,0) DEFAULT 0 NOT NULL,
+    apply_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
+    member_id INT NOT NULL,
+    del_flg SMALLINT DEFAULT 0 NOT NULL,
+    create_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
+    update_date TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL
+);
+CREATE TABLE dtb_tax_rule_tax_rule_id_seq
+(
+    sequence INT PRIMARY KEY NOT NULL AUTO_INCREMENT
+);
 CREATE TABLE dtb_templates
 (
-    template_code VARCHAR(50) PRIMARY KEY NOT NULL,
+    template_code LONGTEXT PRIMARY KEY NOT NULL,
     device_type_id INT NOT NULL,
     template_name LONGTEXT,
     create_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
@@ -997,12 +1054,6 @@
     name LONGTEXT,
     rank SMALLINT DEFAULT 0 NOT NULL
 );
-CREATE TABLE mtb_class
-(
-    id SMALLINT PRIMARY KEY NOT NULL,
-    name LONGTEXT,
-    rank SMALLINT DEFAULT 0 NOT NULL
-);
 CREATE TABLE mtb_constants
 (
     id LONGTEXT PRIMARY KEY NOT NULL,
@@ -1010,6 +1061,18 @@
     rank SMALLINT DEFAULT 0 NOT NULL,
     remarks LONGTEXT
 );
+CREATE TABLE mtb_country
+(
+    id INT PRIMARY KEY NOT NULL,
+    name LONGTEXT,
+    rank INT NOT NULL
+);
+CREATE TABLE mtb_customer_order_status
+(
+    id SMALLINT PRIMARY KEY NOT NULL,
+    name LONGTEXT,
+    rank SMALLINT DEFAULT 0 NOT NULL
+);
 CREATE TABLE mtb_customer_status
 (
     id SMALLINT PRIMARY KEY NOT NULL,
@@ -1106,12 +1169,6 @@
     name LONGTEXT,
     rank SMALLINT DEFAULT 0 NOT NULL
 );
-CREATE TABLE mtb_ownersstore_ips
-(
-    id SMALLINT PRIMARY KEY NOT NULL,
-    name LONGTEXT,
-    rank SMALLINT DEFAULT 0 NOT NULL
-);
 CREATE TABLE mtb_page_max
 (
     id SMALLINT PRIMARY KEY NOT NULL,
@@ -1210,21 +1267,11 @@
 );
 CREATE TABLE mtb_zip
 (
-    code LONGTEXT,
-    old_zipcode LONGTEXT,
+    zip_id INT PRIMARY KEY NOT NULL,
     zipcode LONGTEXT,
-    state_kana LONGTEXT,
-    city_kana LONGTEXT,
-    town_kana LONGTEXT,
     state LONGTEXT,
     city LONGTEXT,
-    town LONGTEXT,
-    flg1 LONGTEXT,
-    flg2 LONGTEXT,
-    flg3 LONGTEXT,
-    flg4 LONGTEXT,
-    flg5 LONGTEXT,
-    flg6 LONGTEXT
+    town LONGTEXT
 );
 CREATE UNIQUE INDEX device_type_id ON dtb_bloc ( device_type_id, filename );
 CREATE UNIQUE INDEX secret_key ON dtb_customer ( secret_key );
@@ -1233,9 +1280,7 @@
 CREATE INDEX dtb_mobile_ext_session_id_param_key_key ON dtb_mobile_ext_session_id ( param_key );
 CREATE INDEX dtb_mobile_ext_session_id_param_value_key ON dtb_mobile_ext_session_id ( param_value );
 CREATE INDEX dtb_mobile_ext_session_id_url_key ON dtb_mobile_ext_session_id ( url );
-CREATE UNIQUE INDEX module_id ON dtb_module ( module_id );
 CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail ( product_id );
-CREATE INDEX dtb_product_categories_category_id_key_idx ON dtb_product_categories ( category_id );
-CREATE INDEX dtb_products_name_key_idx ON dtb_products ( name );
+CREATE UNIQUE INDEX dtb_products_class_unique_key ON dtb_products_class ( product_id, classcategory_id1, classcategory_id2 );
 CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class ( product_id );
 CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer ( customer_id );

About the author
  • コメントを残す