HEX
Server: Apache
System: Linux s198.coreserver.jp 5.15.0-151-generic #161-Ubuntu SMP Tue Jul 22 14:25:40 UTC 2025 x86_64
User: nagasaki (10062)
PHP: 7.1.33
Disabled: NONE
$ pwd: /virtual/nagasaki/public_html/ec/app/log/
Upload Files
File: /virtual/nagasaki/public_html/ec/app/log/install.log
[2017-07-21 21:56:53] myapp.INFO: Matched route "install". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::index","_route":"install"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/"} []
[2017-07-21 21:56:53] myapp.INFO: > GET /ec/html/install.php [] []
[2017-07-21 21:56:53] myapp.INFO: < 302 /ec/html/install.php/step1 [] []
[2017-07-21 21:56:53] myapp.INFO: Matched route "install_step1". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step1","_route":"install_step1"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step1"} []
[2017-07-21 21:56:53] myapp.INFO: > GET /ec/html/install.php/step1 [] []
[2017-07-21 21:56:53] myapp.INFO: < 200 [] []
[2017-07-21 21:57:05] myapp.INFO: Matched route "install_step1". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step1","_route":"install_step1"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step1"} []
[2017-07-21 21:57:05] myapp.INFO: > POST /ec/html/install.php/step1 [] []
[2017-07-21 21:57:05] myapp.INFO: < 302 /ec/html/install.php/step2 [] []
[2017-07-21 21:57:05] myapp.INFO: Matched route "install_step2". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step2","_route":"install_step2"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step2"} []
[2017-07-21 21:57:05] myapp.INFO: > GET /ec/html/install.php/step2 [] []
[2017-07-21 21:57:05] myapp.INFO: < 200 [] []
[2017-07-21 21:57:08] myapp.INFO: Matched route "install_step3". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step3","_route":"install_step3"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step3"} []
[2017-07-21 21:57:08] myapp.INFO: > GET /ec/html/install.php/step3 [] []
[2017-07-21 21:57:09] myapp.INFO: < 200 [] []
[2017-07-21 21:58:13] myapp.INFO: Matched route "install_step3". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step3","_route":"install_step3"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step3"} []
[2017-07-21 21:58:13] myapp.INFO: > POST /ec/html/install.php/step3 [] []
[2017-07-21 21:58:13] myapp.INFO: < 302 /ec/html/install.php/step4 [] []
[2017-07-21 21:58:14] myapp.INFO: Matched route "install_step4". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step4","_route":"install_step4"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step4"} []
[2017-07-21 21:58:14] myapp.INFO: > GET /ec/html/install.php/step4 [] []
[2017-07-21 21:58:14] myapp.INFO: < 200 [] []
[2017-07-21 21:59:04] myapp.INFO: Matched route "install_step4". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step4","_route":"install_step4"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step4"} []
[2017-07-21 21:59:04] myapp.INFO: > POST /ec/html/install.php/step4 [] []
[2017-07-21 21:59:04] myapp.INFO: < 302 /ec/html/install.php/step5 [] []
[2017-07-21 21:59:04] myapp.INFO: Matched route "install_step5". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step5","_route":"install_step5"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step5"} []
[2017-07-21 21:59:04] myapp.INFO: > GET /ec/html/install.php/step5 [] []
[2017-07-21 21:59:05] myapp.INFO: < 200 [] []
[2017-07-21 21:59:09] myapp.INFO: Matched route "install_step5". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::step5","_route":"install_step5"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/step5"} []
[2017-07-21 21:59:09] myapp.INFO: > POST /ec/html/install.php/step5 [] []
[2017-07-21 21:59:10] myapp.DEBUG: SHOW FULL TABLES WHERE Table_type = 'BASE TABLE' [] []
[2017-07-21 21:59:10] myapp.DEBUG: DROP TABLE IF EXISTS doctrine_migration_versions [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_customer_address (customer_address_id INT AUTO_INCREMENT NOT NULL, customer_id INT NOT NULL, country_id SMALLINT DEFAULT NULL, pref SMALLINT DEFAULT NULL, name01 LONGTEXT DEFAULT NULL, name02 LONGTEXT DEFAULT NULL, kana01 LONGTEXT DEFAULT NULL, kana02 LONGTEXT DEFAULT NULL, company_name LONGTEXT DEFAULT NULL, zip01 LONGTEXT DEFAULT NULL, zip02 LONGTEXT DEFAULT NULL, zipcode LONGTEXT DEFAULT NULL, addr01 LONGTEXT DEFAULT NULL, addr02 LONGTEXT DEFAULT NULL, tel01 LONGTEXT DEFAULT NULL, tel02 LONGTEXT DEFAULT NULL, tel03 LONGTEXT DEFAULT NULL, fax01 LONGTEXT DEFAULT NULL, fax02 LONGTEXT DEFAULT NULL, fax03 LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_6C38C0F89395C3F3 (customer_id), INDEX IDX_6C38C0F8F92F3E70 (country_id), INDEX IDX_6C38C0F8A1559831 (pref), PRIMARY KEY(customer_address_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_template (template_id INT AUTO_INCREMENT NOT NULL, device_type_id SMALLINT DEFAULT NULL, template_code LONGTEXT NOT NULL, template_name LONGTEXT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_94C12A694FFA550E (device_type_id), PRIMARY KEY(template_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_page_layout (page_id INT AUTO_INCREMENT NOT NULL, device_type_id SMALLINT DEFAULT NULL, page_name LONGTEXT DEFAULT NULL, url LONGTEXT NOT NULL, file_name LONGTEXT DEFAULT NULL, edit_flg SMALLINT DEFAULT 1, author LONGTEXT DEFAULT NULL, description LONGTEXT DEFAULT NULL, keyword LONGTEXT DEFAULT NULL, update_url LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, meta_robots LONGTEXT DEFAULT NULL, INDEX IDX_F27999414FFA550E (device_type_id), PRIMARY KEY(page_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_shipping (shipping_id INT AUTO_INCREMENT NOT NULL, shipping_country_id SMALLINT DEFAULT NULL, shipping_pref SMALLINT DEFAULT NULL, order_id INT DEFAULT NULL, delivery_id INT DEFAULT NULL, time_id INT DEFAULT NULL, fee_id INT DEFAULT NULL, shipping_name01 LONGTEXT DEFAULT NULL, shipping_name02 LONGTEXT DEFAULT NULL, shipping_kana01 LONGTEXT DEFAULT NULL, shipping_kana02 LONGTEXT DEFAULT NULL, shipping_company_name LONGTEXT DEFAULT NULL, shipping_tel01 LONGTEXT DEFAULT NULL, shipping_tel02 LONGTEXT DEFAULT NULL, shipping_tel03 LONGTEXT DEFAULT NULL, shipping_fax01 LONGTEXT DEFAULT NULL, shipping_fax02 LONGTEXT DEFAULT NULL, shipping_fax03 LONGTEXT DEFAULT NULL, shipping_zip01 LONGTEXT DEFAULT NULL, shipping_zip02 LONGTEXT DEFAULT NULL, shipping_zipcode LONGTEXT DEFAULT NULL, shipping_addr01 LONGTEXT DEFAULT NULL, shipping_addr02 LONGTEXT DEFAULT NULL, shipping_delivery_name LONGTEXT DEFAULT NULL, shipping_delivery_time LONGTEXT DEFAULT NULL, shipping_delivery_date DATETIME DEFAULT NULL, shipping_delivery_fee NUMERIC(10, 0) DEFAULT NULL, shipping_commit_date DATETIME DEFAULT NULL, rank INT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_2EBD22CE41D46E2E (shipping_country_id), INDEX IDX_2EBD22CE30E90E33 (shipping_pref), INDEX IDX_2EBD22CE8D9F6D38 (order_id), INDEX IDX_2EBD22CE12136921 (delivery_id), INDEX IDX_2EBD22CE5EEADD3B (time_id), INDEX IDX_2EBD22CEAB45AECA (fee_id), PRIMARY KEY(shipping_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_product_image (product_image_id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, creator_id INT NOT NULL, file_name LONGTEXT NOT NULL, rank INT NOT NULL, create_date DATETIME NOT NULL, INDEX IDX_3267CC7A4584665A (product_id), INDEX IDX_3267CC7A61220EA6 (creator_id), PRIMARY KEY(product_image_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_category_count (category_id INT AUTO_INCREMENT NOT NULL, product_count INT NOT NULL, create_date DATETIME NOT NULL, PRIMARY KEY(category_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_customer (customer_id INT AUTO_INCREMENT NOT NULL, status SMALLINT DEFAULT NULL, sex SMALLINT DEFAULT NULL, job SMALLINT DEFAULT NULL, country_id SMALLINT DEFAULT NULL, pref SMALLINT DEFAULT NULL, name01 LONGTEXT NOT NULL, name02 LONGTEXT NOT NULL, kana01 LONGTEXT DEFAULT NULL, kana02 LONGTEXT DEFAULT NULL, company_name LONGTEXT DEFAULT NULL, zip01 LONGTEXT DEFAULT NULL, zip02 LONGTEXT DEFAULT NULL, zipcode LONGTEXT DEFAULT NULL, addr01 LONGTEXT DEFAULT NULL, addr02 LONGTEXT DEFAULT NULL, email LONGTEXT NOT NULL, tel01 LONGTEXT DEFAULT NULL, tel02 LONGTEXT DEFAULT NULL, tel03 LONGTEXT DEFAULT NULL, fax01 LONGTEXT DEFAULT NULL, fax02 LONGTEXT DEFAULT NULL, fax03 LONGTEXT DEFAULT NULL, birth DATETIME DEFAULT NULL, password LONGTEXT DEFAULT NULL, salt LONGTEXT DEFAULT NULL, secret_key VARCHAR(200) NOT NULL, first_buy_date DATETIME DEFAULT NULL, last_buy_date DATETIME DEFAULT NULL, buy_times NUMERIC(10, 0) DEFAULT '0', buy_total NUMERIC(10, 0) DEFAULT '0', note LONGTEXT DEFAULT NULL, reset_key LONGTEXT DEFAULT NULL, reset_expire DATETIME DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_8298BBE37B00651C (status), INDEX IDX_8298BBE3EFA269F7 (sex), INDEX IDX_8298BBE3FBD8E0F8 (job), INDEX IDX_8298BBE3F92F3E70 (country_id), INDEX IDX_8298BBE3A1559831 (pref), INDEX dtb_customer_create_date_idx (create_date), INDEX dtb_customer_update_date_idx (update_date), INDEX dtb_customer_last_buy_date_idx (last_buy_date), INDEX dtb_customer_buy_times_idx (buy_times), INDEX dtb_customer_buy_total_idx (buy_total), UNIQUE INDEX secret_key (secret_key), PRIMARY KEY(customer_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_category (category_id INT AUTO_INCREMENT NOT NULL, parent_category_id INT DEFAULT NULL, creator_id INT DEFAULT NULL, category_name LONGTEXT NOT NULL, level INT NOT NULL, rank INT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_5ED2C2B796A8F92 (parent_category_id), INDEX IDX_5ED2C2B61220EA6 (creator_id), PRIMARY KEY(category_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_csv (csv_id INT AUTO_INCREMENT NOT NULL, csv_type SMALLINT NOT NULL, creator_id INT NOT NULL, entity_name LONGTEXT NOT NULL, field_name LONGTEXT NOT NULL, reference_field_name LONGTEXT DEFAULT NULL, disp_name LONGTEXT NOT NULL, rank SMALLINT NOT NULL, enable_flg SMALLINT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_F55F48C32C648C74 (csv_type), INDEX IDX_F55F48C361220EA6 (creator_id), PRIMARY KEY(csv_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_customer_favorite_product (favorite_id INT AUTO_INCREMENT NOT NULL, customer_id INT DEFAULT NULL, product_id INT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_ED6313839395C3F3 (customer_id), INDEX IDX_ED6313834584665A (product_id), PRIMARY KEY(favorite_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_shipment_item (item_id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, product_id INT NOT NULL, product_class_id INT NOT NULL, shipping_id INT NOT NULL, product_name LONGTEXT NOT NULL, product_code LONGTEXT DEFAULT NULL, class_name1 LONGTEXT DEFAULT NULL, class_name2 LONGTEXT DEFAULT NULL, class_category_name1 LONGTEXT DEFAULT NULL, class_category_name2 LONGTEXT DEFAULT NULL, price NUMERIC(10, 0) DEFAULT NULL, quantity NUMERIC(10, 0) DEFAULT NULL, INDEX IDX_57C3C0398D9F6D38 (order_id), INDEX IDX_57C3C0394584665A (product_id), INDEX IDX_57C3C03921B06187 (product_class_id), INDEX IDX_57C3C0394887F3F8 (shipping_id), PRIMARY KEY(item_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_member (member_id INT AUTO_INCREMENT NOT NULL, work SMALLINT DEFAULT NULL, authority SMALLINT DEFAULT NULL, creator_id INT DEFAULT NULL, name LONGTEXT DEFAULT NULL, department LONGTEXT DEFAULT NULL, login_id LONGTEXT NOT NULL, password LONGTEXT NOT NULL, salt LONGTEXT NOT NULL, rank INT NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, login_date DATETIME DEFAULT NULL, INDEX IDX_10BC3BE6534E6880 (work), INDEX IDX_10BC3BE64AF96AFC (authority), INDEX IDX_10BC3BE661220EA6 (creator_id), PRIMARY KEY(member_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_block_position (page_id INT NOT NULL, target_id INT NOT NULL, block_id INT NOT NULL, block_row INT DEFAULT NULL, anywhere SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_35DCD731E9ED820C (block_id), INDEX IDX_35DCD731C4663E4 (page_id), PRIMARY KEY(page_id, target_id, block_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_order_detail (order_detail_id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, product_id INT NOT NULL, product_class_id INT NOT NULL, product_name LONGTEXT NOT NULL, product_code LONGTEXT DEFAULT NULL, class_name1 LONGTEXT DEFAULT NULL, class_name2 LONGTEXT DEFAULT NULL, class_category_name1 LONGTEXT DEFAULT NULL, class_category_name2 LONGTEXT DEFAULT NULL, price NUMERIC(10, 0) DEFAULT NULL, quantity NUMERIC(10, 0) DEFAULT NULL, tax_rate NUMERIC(10, 0) DEFAULT NULL, tax_rule SMALLINT DEFAULT NULL, INDEX IDX_58FE35738D9F6D38 (order_id), INDEX IDX_58FE357321B06187 (product_class_id), INDEX dtb_order_detail_product_id_key (product_id), PRIMARY KEY(order_detail_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_mail_history (send_id INT AUTO_INCREMENT NOT NULL, order_id INT NOT NULL, template_id INT DEFAULT NULL, creator_id INT DEFAULT NULL, send_date DATETIME DEFAULT NULL, subject LONGTEXT DEFAULT NULL, mail_body LONGTEXT DEFAULT NULL, INDEX IDX_4870AB118D9F6D38 (order_id), INDEX IDX_4870AB115DA0FB8 (template_id), INDEX IDX_4870AB1161220EA6 (creator_id), PRIMARY KEY(send_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_product (product_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, status SMALLINT DEFAULT NULL, name TEXT NOT NULL, note TEXT DEFAULT NULL, description_list TEXT DEFAULT NULL, description_detail TEXT DEFAULT NULL, search_word TEXT DEFAULT NULL, free_area TEXT DEFAULT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_C49DE22F61220EA6 (creator_id), INDEX IDX_C49DE22F7B00651C (status), PRIMARY KEY(product_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_delivery_date (date_id INT AUTO_INCREMENT NOT NULL, name LONGTEXT DEFAULT NULL, value SMALLINT DEFAULT 0 NOT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(date_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:10] myapp.DEBUG: CREATE TABLE dtb_payment (payment_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, payment_method LONGTEXT DEFAULT NULL, charge NUMERIC(10, 0) DEFAULT NULL, rule_max NUMERIC(10, 0) DEFAULT NULL, rank INT DEFAULT NULL, fix_flg SMALLINT DEFAULT 1, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, payment_image LONGTEXT DEFAULT NULL, charge_flg SMALLINT DEFAULT 1, rule_min NUMERIC(10, 0) DEFAULT NULL, INDEX IDX_7AFF628F61220EA6 (creator_id), PRIMARY KEY(payment_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_product_type (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_authority (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_customer_order_status (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_country (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank INT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_tag (id SMALLINT NOT NULL, name LONGTEXT NOT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_sex (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_customer_status (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_order_status_color (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_csv_type (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_product_list_max (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_order_status (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_job (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_taxrule (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_work (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_zip (zip_id INT NOT NULL, zipcode LONGTEXT DEFAULT NULL, state LONGTEXT DEFAULT NULL, city LONGTEXT DEFAULT NULL, town LONGTEXT DEFAULT NULL, PRIMARY KEY(zip_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_pref (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_product_list_order_by (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_disp (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_device_type (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_db (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE mtb_page_max (id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, rank SMALLINT NOT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_product_stock (product_stock_id INT AUTO_INCREMENT NOT NULL, product_class_id INT DEFAULT NULL, creator_id INT NOT NULL, stock NUMERIC(10, 0) DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, UNIQUE INDEX UNIQ_BC6C9E4521B06187 (product_class_id), INDEX IDX_BC6C9E4561220EA6 (creator_id), PRIMARY KEY(product_stock_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_product_tag (product_tag_id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, tag SMALLINT NOT NULL, creator_id INT NOT NULL, create_date DATETIME NOT NULL, INDEX IDX_4433E7214584665A (product_id), INDEX IDX_4433E721389B783 (tag), INDEX IDX_4433E72161220EA6 (creator_id), PRIMARY KEY(product_tag_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_plugin_event_handler (id INT AUTO_INCREMENT NOT NULL, plugin_id INT NOT NULL, event VARCHAR(255) NOT NULL, priority INT NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, handler VARCHAR(255) NOT NULL, handler_type VARCHAR(255) NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_92639EBDEC942BCF (plugin_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_category_total_count (category_id INT AUTO_INCREMENT NOT NULL, product_count INT DEFAULT NULL, create_date DATETIME NOT NULL, PRIMARY KEY(category_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_product_class (product_class_id INT AUTO_INCREMENT NOT NULL, product_id INT NOT NULL, product_type_id SMALLINT NOT NULL, class_category_id1 INT DEFAULT NULL, class_category_id2 INT DEFAULT NULL, delivery_date_id INT DEFAULT NULL, creator_id INT NOT NULL, product_code LONGTEXT DEFAULT NULL, stock NUMERIC(10, 0) DEFAULT NULL, stock_unlimited SMALLINT NOT NULL, sale_limit NUMERIC(10, 0) DEFAULT NULL, price01 NUMERIC(10, 0) DEFAULT NULL, price02 NUMERIC(10, 0) NOT NULL, delivery_fee NUMERIC(10, 0) DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_1A11D1BA4584665A (product_id), INDEX IDX_1A11D1BA14959723 (product_type_id), INDEX IDX_1A11D1BA248D128 (class_category_id1), INDEX IDX_1A11D1BA9B418092 (class_category_id2), INDEX IDX_1A11D1BAB28989B5 (delivery_date_id), INDEX IDX_1A11D1BA61220EA6 (creator_id), INDEX dtb_product_class_price02_idx (price02), INDEX dtb_product_class_stock_stock_unlimited_idx (stock, stock_unlimited), PRIMARY KEY(product_class_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_delivery (delivery_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, product_type_id SMALLINT NOT NULL, name LONGTEXT DEFAULT NULL, service_name LONGTEXT DEFAULT NULL, description LONGTEXT DEFAULT NULL, confirm_url LONGTEXT DEFAULT NULL, rank INT DEFAULT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_3420D9FA61220EA6 (creator_id), INDEX IDX_3420D9FA14959723 (product_type_id), PRIMARY KEY(delivery_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_help (id INT AUTO_INCREMENT NOT NULL, law_country_id SMALLINT DEFAULT NULL, law_pref SMALLINT DEFAULT NULL, customer_agreement LONGTEXT DEFAULT NULL, law_company LONGTEXT DEFAULT NULL, law_manager LONGTEXT DEFAULT NULL, law_zip01 LONGTEXT DEFAULT NULL, law_zip02 LONGTEXT DEFAULT NULL, law_zipcode LONGTEXT DEFAULT NULL, law_addr01 LONGTEXT DEFAULT NULL, law_addr02 LONGTEXT DEFAULT NULL, law_tel01 LONGTEXT DEFAULT NULL, law_tel02 LONGTEXT DEFAULT NULL, law_tel03 LONGTEXT DEFAULT NULL, law_fax01 LONGTEXT DEFAULT NULL, law_fax02 LONGTEXT DEFAULT NULL, law_fax03 LONGTEXT DEFAULT NULL, law_email LONGTEXT DEFAULT NULL, law_url LONGTEXT DEFAULT NULL, law_term01 LONGTEXT DEFAULT NULL, law_term02 LONGTEXT DEFAULT NULL, law_term03 LONGTEXT DEFAULT NULL, law_term04 LONGTEXT DEFAULT NULL, law_term05 LONGTEXT DEFAULT NULL, law_term06 LONGTEXT DEFAULT NULL, law_term07 LONGTEXT DEFAULT NULL, law_term08 LONGTEXT DEFAULT NULL, law_term09 LONGTEXT DEFAULT NULL, law_term10 LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_FF18F0EB5C77387 (law_country_id), INDEX IDX_FF18F0EBE3D20F82 (law_pref), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_delivery_fee (fee_id INT AUTO_INCREMENT NOT NULL, delivery_id INT DEFAULT NULL, pref SMALLINT NOT NULL, fee NUMERIC(10, 0) NOT NULL, INDEX IDX_491552412136921 (delivery_id), INDEX IDX_4915524A1559831 (pref), PRIMARY KEY(fee_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_order (order_id INT AUTO_INCREMENT NOT NULL, customer_id INT DEFAULT NULL, order_country_id SMALLINT DEFAULT NULL, order_pref SMALLINT DEFAULT NULL, order_sex SMALLINT DEFAULT NULL, order_job SMALLINT DEFAULT NULL, payment_id INT DEFAULT NULL, device_type_id SMALLINT DEFAULT NULL, pre_order_id LONGTEXT DEFAULT NULL, message LONGTEXT DEFAULT NULL, order_name01 LONGTEXT DEFAULT NULL, order_name02 LONGTEXT DEFAULT NULL, order_kana01 LONGTEXT DEFAULT NULL, order_kana02 LONGTEXT DEFAULT NULL, order_company_name LONGTEXT DEFAULT NULL, order_email LONGTEXT DEFAULT NULL, order_tel01 LONGTEXT DEFAULT NULL, order_tel02 LONGTEXT DEFAULT NULL, order_tel03 LONGTEXT DEFAULT NULL, order_fax01 LONGTEXT DEFAULT NULL, order_fax02 LONGTEXT DEFAULT NULL, order_fax03 LONGTEXT DEFAULT NULL, order_zip01 LONGTEXT DEFAULT NULL, order_zip02 LONGTEXT DEFAULT NULL, order_zipcode LONGTEXT DEFAULT NULL, order_addr01 LONGTEXT DEFAULT NULL, order_addr02 LONGTEXT DEFAULT NULL, order_birth DATETIME DEFAULT NULL, subtotal NUMERIC(10, 0) DEFAULT NULL, discount NUMERIC(10, 0) DEFAULT '0' NOT NULL, delivery_fee_total NUMERIC(10, 0) DEFAULT NULL, charge NUMERIC(10, 0) DEFAULT NULL, tax NUMERIC(10, 0) DEFAULT NULL, total NUMERIC(10, 0) DEFAULT NULL, payment_total NUMERIC(10, 0) DEFAULT NULL, payment_method LONGTEXT DEFAULT NULL, note LONGTEXT DEFAULT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, order_date DATETIME DEFAULT NULL, commit_date DATETIME DEFAULT NULL, payment_date DATETIME DEFAULT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, status SMALLINT DEFAULT NULL, INDEX IDX_1D66D8079395C3F3 (customer_id), INDEX IDX_1D66D8074AF5C325 (order_country_id), INDEX IDX_1D66D807ECA4A226 (order_pref), INDEX IDX_1D66D807ACF92697 (order_sex), INDEX IDX_1D66D807B883AF98 (order_job), INDEX IDX_1D66D8074C3A3BB (payment_id), INDEX IDX_1D66D8074FFA550E (device_type_id), INDEX IDX_1D66D8077B00651C (status), INDEX dtb_order_order_date_idx (order_date), INDEX dtb_order_payment_date_idx (payment_date), INDEX dtb_order_commit_date_idx (commit_date), INDEX dtb_order_update_date_idx (update_date), PRIMARY KEY(order_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_payment_option (delivery_id INT NOT NULL, payment_id INT NOT NULL, INDEX IDX_5631540D12136921 (delivery_id), INDEX IDX_5631540D4C3A3BB (payment_id), PRIMARY KEY(delivery_id, payment_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_mail_template (template_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, name LONGTEXT DEFAULT NULL, file_name LONGTEXT DEFAULT NULL, subject LONGTEXT DEFAULT NULL, header LONGTEXT DEFAULT NULL, footer LONGTEXT DEFAULT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_1CB16DB261220EA6 (creator_id), PRIMARY KEY(template_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_delivery_time (time_id INT AUTO_INCREMENT NOT NULL, delivery_id INT DEFAULT NULL, delivery_time LONGTEXT NOT NULL, INDEX IDX_E80EE3A612136921 (delivery_id), PRIMARY KEY(time_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_class_category (class_category_id INT AUTO_INCREMENT NOT NULL, class_name_id INT NOT NULL, creator_id INT NOT NULL, name LONGTEXT NOT NULL, rank INT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_9B0D1DBAB462FB2A (class_name_id), INDEX IDX_9B0D1DBA61220EA6 (creator_id), PRIMARY KEY(class_category_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_plugin (plugin_id INT AUTO_INCREMENT NOT NULL, name LONGTEXT NOT NULL, code LONGTEXT NOT NULL, class_name LONGTEXT NOT NULL, plugin_enable SMALLINT DEFAULT 0 NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, version VARCHAR(255) NOT NULL, source LONGTEXT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, PRIMARY KEY(plugin_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_class_name (class_name_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, name LONGTEXT NOT NULL, rank INT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_187C95AD61220EA6 (creator_id), PRIMARY KEY(class_name_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_base_info (id INT AUTO_INCREMENT NOT NULL, country_id SMALLINT DEFAULT NULL, pref SMALLINT DEFAULT NULL, company_name LONGTEXT DEFAULT NULL, company_kana LONGTEXT DEFAULT NULL, zip01 LONGTEXT DEFAULT NULL, zip02 LONGTEXT DEFAULT NULL, zipcode LONGTEXT DEFAULT NULL, addr01 LONGTEXT DEFAULT NULL, addr02 LONGTEXT DEFAULT NULL, tel01 LONGTEXT DEFAULT NULL, tel02 LONGTEXT DEFAULT NULL, tel03 LONGTEXT DEFAULT NULL, fax01 LONGTEXT DEFAULT NULL, fax02 LONGTEXT DEFAULT NULL, fax03 LONGTEXT DEFAULT NULL, business_hour LONGTEXT DEFAULT NULL, email01 LONGTEXT DEFAULT NULL, email02 LONGTEXT DEFAULT NULL, email03 LONGTEXT DEFAULT NULL, email04 LONGTEXT DEFAULT NULL, shop_name LONGTEXT DEFAULT NULL, shop_kana LONGTEXT DEFAULT NULL, shop_name_eng LONGTEXT DEFAULT NULL, update_date DATETIME NOT NULL, good_traded LONGTEXT DEFAULT NULL, message LONGTEXT DEFAULT NULL, latitude LONGTEXT DEFAULT NULL, longitude LONGTEXT DEFAULT NULL, delivery_free_amount NUMERIC(10, 0) DEFAULT NULL, delivery_free_quantity INT DEFAULT NULL, option_multiple_shipping SMALLINT DEFAULT 0, option_mypage_order_status_display SMALLINT DEFAULT 1, nostock_hidden SMALLINT DEFAULT 0, option_favorite_product SMALLINT DEFAULT 1, option_product_delivery_fee SMALLINT DEFAULT 0, option_product_tax_rule SMALLINT DEFAULT 0, option_customer_activate SMALLINT DEFAULT 1, option_remember_me SMALLINT DEFAULT 0, authentication_key LONGTEXT DEFAULT NULL, INDEX IDX_1D3655F4F92F3E70 (country_id), INDEX IDX_1D3655F4A1559831 (pref), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_product_category (product_id INT NOT NULL, category_id INT NOT NULL, rank INT NOT NULL, INDEX IDX_B05778914584665A (product_id), INDEX IDX_B057789112469DE2 (category_id), PRIMARY KEY(product_id, category_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_news (news_id INT AUTO_INCREMENT NOT NULL, creator_id INT NOT NULL, news_date DATETIME DEFAULT NULL, rank INT DEFAULT NULL, news_title LONGTEXT NOT NULL, news_comment LONGTEXT DEFAULT NULL, news_url LONGTEXT DEFAULT NULL, news_select SMALLINT DEFAULT 0 NOT NULL, link_method SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, INDEX IDX_EA4C351761220EA6 (creator_id), PRIMARY KEY(news_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_tax_rule (tax_rule_id INT AUTO_INCREMENT NOT NULL, product_class_id INT DEFAULT NULL, creator_id INT NOT NULL, country_id SMALLINT DEFAULT NULL, pref_id SMALLINT DEFAULT NULL, product_id INT DEFAULT NULL, calc_rule SMALLINT DEFAULT NULL, tax_rate NUMERIC(10, 0) DEFAULT '8' NOT NULL, tax_adjust NUMERIC(10, 0) DEFAULT '0' NOT NULL, apply_date DATETIME NOT NULL, del_flg SMALLINT DEFAULT 0 NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, UNIQUE INDEX UNIQ_59F696DE21B06187 (product_class_id), INDEX IDX_59F696DE61220EA6 (creator_id), INDEX IDX_59F696DEF92F3E70 (country_id), INDEX IDX_59F696DEE171EF5F (pref_id), INDEX IDX_59F696DE4584665A (product_id), INDEX IDX_59F696DE800F7945 (calc_rule), PRIMARY KEY(tax_rule_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_authority_role (authority_role_id INT AUTO_INCREMENT NOT NULL, authority_id SMALLINT NOT NULL, creator_id INT NOT NULL, deny_url LONGTEXT NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, INDEX IDX_4A1F70B181EC865B (authority_id), INDEX IDX_4A1F70B161220EA6 (creator_id), PRIMARY KEY(authority_role_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: CREATE TABLE dtb_block (block_id INT AUTO_INCREMENT NOT NULL, device_type_id SMALLINT DEFAULT NULL, block_name LONGTEXT DEFAULT NULL, file_name VARCHAR(200) NOT NULL, create_date DATETIME NOT NULL, update_date DATETIME NOT NULL, logic_flg SMALLINT DEFAULT 1 NOT NULL, deletable_flg SMALLINT DEFAULT 1 NOT NULL, INDEX IDX_6B54DCBD4FFA550E (device_type_id), UNIQUE INDEX device_type_id (device_type_id, file_name), PRIMARY KEY(block_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE = InnoDB [] []
[2017-07-21 21:59:11] myapp.DEBUG: ALTER TABLE dtb_customer_address ADD CONSTRAINT FK_6C38C0F89395C3F3 FOREIGN KEY (customer_id) REFERENCES dtb_customer (customer_id) [] []
[2017-07-21 21:59:11] myapp.DEBUG: ALTER TABLE dtb_customer_address ADD CONSTRAINT FK_6C38C0F8F92F3E70 FOREIGN KEY (country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:11] myapp.DEBUG: ALTER TABLE dtb_customer_address ADD CONSTRAINT FK_6C38C0F8A1559831 FOREIGN KEY (pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_template ADD CONSTRAINT FK_94C12A694FFA550E FOREIGN KEY (device_type_id) REFERENCES mtb_device_type (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_page_layout ADD CONSTRAINT FK_F27999414FFA550E FOREIGN KEY (device_type_id) REFERENCES mtb_device_type (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CE41D46E2E FOREIGN KEY (shipping_country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CE30E90E33 FOREIGN KEY (shipping_pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CE8D9F6D38 FOREIGN KEY (order_id) REFERENCES dtb_order (order_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CE12136921 FOREIGN KEY (delivery_id) REFERENCES dtb_delivery (delivery_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CE5EEADD3B FOREIGN KEY (time_id) REFERENCES dtb_delivery_time (time_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipping ADD CONSTRAINT FK_2EBD22CEAB45AECA FOREIGN KEY (fee_id) REFERENCES dtb_delivery_fee (fee_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_image ADD CONSTRAINT FK_3267CC7A4584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_image ADD CONSTRAINT FK_3267CC7A61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer ADD CONSTRAINT FK_8298BBE37B00651C FOREIGN KEY (status) REFERENCES mtb_customer_status (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer ADD CONSTRAINT FK_8298BBE3EFA269F7 FOREIGN KEY (sex) REFERENCES mtb_sex (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer ADD CONSTRAINT FK_8298BBE3FBD8E0F8 FOREIGN KEY (job) REFERENCES mtb_job (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer ADD CONSTRAINT FK_8298BBE3F92F3E70 FOREIGN KEY (country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer ADD CONSTRAINT FK_8298BBE3A1559831 FOREIGN KEY (pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_category ADD CONSTRAINT FK_5ED2C2B796A8F92 FOREIGN KEY (parent_category_id) REFERENCES dtb_category (category_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_category ADD CONSTRAINT FK_5ED2C2B61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_csv ADD CONSTRAINT FK_F55F48C32C648C74 FOREIGN KEY (csv_type) REFERENCES mtb_csv_type (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_csv ADD CONSTRAINT FK_F55F48C361220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer_favorite_product ADD CONSTRAINT FK_ED6313839395C3F3 FOREIGN KEY (customer_id) REFERENCES dtb_customer (customer_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_customer_favorite_product ADD CONSTRAINT FK_ED6313834584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipment_item ADD CONSTRAINT FK_57C3C0398D9F6D38 FOREIGN KEY (order_id) REFERENCES dtb_order (order_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipment_item ADD CONSTRAINT FK_57C3C0394584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipment_item ADD CONSTRAINT FK_57C3C03921B06187 FOREIGN KEY (product_class_id) REFERENCES dtb_product_class (product_class_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_shipment_item ADD CONSTRAINT FK_57C3C0394887F3F8 FOREIGN KEY (shipping_id) REFERENCES dtb_shipping (shipping_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_member ADD CONSTRAINT FK_10BC3BE6534E6880 FOREIGN KEY (work) REFERENCES mtb_work (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_member ADD CONSTRAINT FK_10BC3BE64AF96AFC FOREIGN KEY (authority) REFERENCES mtb_authority (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_member ADD CONSTRAINT FK_10BC3BE661220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_block_position ADD CONSTRAINT FK_35DCD731E9ED820C FOREIGN KEY (block_id) REFERENCES dtb_block (block_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_block_position ADD CONSTRAINT FK_35DCD731C4663E4 FOREIGN KEY (page_id) REFERENCES dtb_page_layout (page_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_order_detail ADD CONSTRAINT FK_58FE35738D9F6D38 FOREIGN KEY (order_id) REFERENCES dtb_order (order_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_order_detail ADD CONSTRAINT FK_58FE35734584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_order_detail ADD CONSTRAINT FK_58FE357321B06187 FOREIGN KEY (product_class_id) REFERENCES dtb_product_class (product_class_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_mail_history ADD CONSTRAINT FK_4870AB118D9F6D38 FOREIGN KEY (order_id) REFERENCES dtb_order (order_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_mail_history ADD CONSTRAINT FK_4870AB115DA0FB8 FOREIGN KEY (template_id) REFERENCES dtb_mail_template (template_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_mail_history ADD CONSTRAINT FK_4870AB1161220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product ADD CONSTRAINT FK_C49DE22F61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product ADD CONSTRAINT FK_C49DE22F7B00651C FOREIGN KEY (status) REFERENCES mtb_disp (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_payment ADD CONSTRAINT FK_7AFF628F61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_stock ADD CONSTRAINT FK_BC6C9E4521B06187 FOREIGN KEY (product_class_id) REFERENCES dtb_product_class (product_class_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_stock ADD CONSTRAINT FK_BC6C9E4561220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_tag ADD CONSTRAINT FK_4433E7214584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_tag ADD CONSTRAINT FK_4433E721389B783 FOREIGN KEY (tag) REFERENCES mtb_tag (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_tag ADD CONSTRAINT FK_4433E72161220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_plugin_event_handler ADD CONSTRAINT FK_92639EBDEC942BCF FOREIGN KEY (plugin_id) REFERENCES dtb_plugin (plugin_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BA4584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BA14959723 FOREIGN KEY (product_type_id) REFERENCES mtb_product_type (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BA248D128 FOREIGN KEY (class_category_id1) REFERENCES dtb_class_category (class_category_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BA9B418092 FOREIGN KEY (class_category_id2) REFERENCES dtb_class_category (class_category_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BAB28989B5 FOREIGN KEY (delivery_date_id) REFERENCES dtb_delivery_date (date_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_product_class ADD CONSTRAINT FK_1A11D1BA61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_delivery ADD CONSTRAINT FK_3420D9FA61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_delivery ADD CONSTRAINT FK_3420D9FA14959723 FOREIGN KEY (product_type_id) REFERENCES mtb_product_type (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_help ADD CONSTRAINT FK_FF18F0EB5C77387 FOREIGN KEY (law_country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_help ADD CONSTRAINT FK_FF18F0EBE3D20F82 FOREIGN KEY (law_pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_delivery_fee ADD CONSTRAINT FK_491552412136921 FOREIGN KEY (delivery_id) REFERENCES dtb_delivery (delivery_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_delivery_fee ADD CONSTRAINT FK_4915524A1559831 FOREIGN KEY (pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D8079395C3F3 FOREIGN KEY (customer_id) REFERENCES dtb_customer (customer_id) [] []
[2017-07-21 21:59:12] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D8074AF5C325 FOREIGN KEY (order_country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D807ECA4A226 FOREIGN KEY (order_pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D807ACF92697 FOREIGN KEY (order_sex) REFERENCES mtb_sex (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D807B883AF98 FOREIGN KEY (order_job) REFERENCES mtb_job (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D8074C3A3BB FOREIGN KEY (payment_id) REFERENCES dtb_payment (payment_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_order ADD CONSTRAINT FK_1D66D8074FFA550E FOREIGN KEY (device_type_id) REFERENCES mtb_device_type (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_payment_option ADD CONSTRAINT FK_5631540D12136921 FOREIGN KEY (delivery_id) REFERENCES dtb_delivery (delivery_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_payment_option ADD CONSTRAINT FK_5631540D4C3A3BB FOREIGN KEY (payment_id) REFERENCES dtb_payment (payment_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_mail_template ADD CONSTRAINT FK_1CB16DB261220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_delivery_time ADD CONSTRAINT FK_E80EE3A612136921 FOREIGN KEY (delivery_id) REFERENCES dtb_delivery (delivery_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_class_category ADD CONSTRAINT FK_9B0D1DBAB462FB2A FOREIGN KEY (class_name_id) REFERENCES dtb_class_name (class_name_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_class_category ADD CONSTRAINT FK_9B0D1DBA61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_class_name ADD CONSTRAINT FK_187C95AD61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_base_info ADD CONSTRAINT FK_1D3655F4F92F3E70 FOREIGN KEY (country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_base_info ADD CONSTRAINT FK_1D3655F4A1559831 FOREIGN KEY (pref) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_product_category ADD CONSTRAINT FK_B05778914584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_product_category ADD CONSTRAINT FK_B057789112469DE2 FOREIGN KEY (category_id) REFERENCES dtb_category (category_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_news ADD CONSTRAINT FK_EA4C351761220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DE21B06187 FOREIGN KEY (product_class_id) REFERENCES dtb_product_class (product_class_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DE61220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DEF92F3E70 FOREIGN KEY (country_id) REFERENCES mtb_country (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DEE171EF5F FOREIGN KEY (pref_id) REFERENCES mtb_pref (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DE4584665A FOREIGN KEY (product_id) REFERENCES dtb_product (product_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_tax_rule ADD CONSTRAINT FK_59F696DE800F7945 FOREIGN KEY (calc_rule) REFERENCES mtb_taxrule (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_authority_role ADD CONSTRAINT FK_4A1F70B181EC865B FOREIGN KEY (authority_id) REFERENCES mtb_authority (id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_authority_role ADD CONSTRAINT FK_4A1F70B161220EA6 FOREIGN KEY (creator_id) REFERENCES dtb_member (member_id) [] []
[2017-07-21 21:59:13] myapp.DEBUG: ALTER TABLE dtb_block ADD CONSTRAINT FK_6B54DCBD4FFA550E FOREIGN KEY (device_type_id) REFERENCES mtb_device_type (id) [] []
[2017-07-21 21:59:31] myapp.INFO: < 302 /ec/html/install.php/complete [] []
[2017-07-21 21:59:33] myapp.INFO: Matched route "install_complete". {"route_parameters":{"_controller":"\\Eccube\\Controller\\Install\\InstallController::complete","_route":"install_complete"},"request_uri":"http://www.nagasaki-shinju.com/ec/html/install.php/complete"} []
[2017-07-21 21:59:33] myapp.INFO: > GET /ec/html/install.php/complete [] []
[2017-07-21 21:59:33] myapp.INFO: < 200 [] []
@ Telegram