2.13.3 から 2.13.4

UPDATE dtb_csv
SET error_check_types = 'EXIST_CHECK,SPTAB_CHECK,MAX_LENGTH_CHECK'
WHERE (csv_id, col, error_check_types) = (1, 'product_code', 'SPTAB_CHECK,MAX_LENGTH_CHECK');
-- 1行
 
-- PostgreSQL で確認
ALTER TABLE dtb_products_class DROP CONSTRAINT dtb_products_class_product_id_classcategory_id1_classcatego_key;
ALTER TABLE dtb_products_class ADD CONSTRAINT dtb_products_class_unique_key UNIQUE (product_id, classcategory_id1, classcategory_id2);

DROP INDEX dtb_products_class_product_id;
CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class (product_id) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_product_code_key ON dtb_products_class (product_id,product_code) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_price01_key ON dtb_products_class (product_id,price01) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_price02_key ON dtb_products_class (product_id,price02) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_stock_key ON dtb_products_class (product_id,stock) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_stock_unlimited_key ON dtb_products_class (product_id,stock_unlimited) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_point_rate_key ON dtb_products_class (product_id,point_rate) WHERE del_flg = 0;
CREATE INDEX dtb_products_class_deliv_fee_key ON dtb_products_class (product_id,deliv_fee) WHERE del_flg = 0;

変更

data/class/SC_FormParam.php
data/class/SC_Fpdf.php
data/class/SC_Initial.php
data/class/SC_Session.php
data/class/db/SC_DB_DBFactory.php
data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php
data/class/helper/SC_Helper_Address.php
data/class/helper/SC_Helper_DB.php
data/class/helper/SC_Helper_FPDI.php
data/class/helper/SC_Helper_Purchase.php
data/class/pages/LC_Page.php
data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_CSV.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php
data/class/pages/admin/order/LC_Page_Admin_Order_Pdf.php
data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php
data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore.php
data/class/pages/admin/products/LC_Page_Admin_Products.php
data/class/pages/admin/products/LC_Page_Admin_Products_Product.php
data/class/pages/admin/products/LC_Page_Admin_Products_ProductClass.php
data/class/pages/products/LC_Page_Products_Review.php
data/class/pages/products/LC_Page_Products_ReviewComplete.php
data/class/pages/shopping/LC_Page_Shopping_Confirm.php
data/class/util/SC_Utils.php
data/module/SearchReplace.php
data/module/Net/URL.php
data/module/Services/JSON/Test-JSON.php
data/Smarty/templates/admin/basis/index.tpl
data/Smarty/templates/admin/basis/zip_install.tpl
data/Smarty/templates/admin/mail/history.tpl
data/Smarty/templates/admin/mail/template.tpl
data/Smarty/templates/admin/order/subnavi.tpl
data/Smarty/templates/admin/ownersstore/log.tpl
data/Smarty/templates/admin/products/product_class.tpl
data/Smarty/templates/admin/system/system.tpl
data/Smarty/templates/admin/total/index.tpl
data/Smarty/templates/default/frontparts/form_personal_input.tpl
data/Smarty/templates/default/mypage/delivery_addr.tpl
data/Smarty/templates/sphone/frontparts/form_personal_input.tpl
data/Smarty/templates/sphone/frontparts/bloc/navi_header.tpl
html/install/sql/create_table_mysql.sql
html/install/sql/create_table_pgsql.sql
html/install/sql/insert_data.sql