目次
2.12.0 から 2.12.1
SQL (mtb_customer_order_status)
CREATE TABLE mtb_customer_order_status ( id SMALLINT, name text, rank SMALLINT NOT NULL DEFAULT 0, PRIMARY KEY (id) ); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (7, '注文未完了', 0); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (1, '注文受付', 1); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (2, '入金待ち', 2); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (6, '注文受付', 3); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (3, 'キャンセル', 4); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (4, '注文受付', 5); INSERT INTO mtb_customer_order_status (id, name, rank) VALUES (5, '発送済み', 6);
SQL (dtb_recommend_products)
-- PostgreSQL 用 ALTER TABLE dtb_recommend_products DROP CONSTRAINT dtb_recommend_products_pkey; -- MySQL 用 ALTER TABLE dtb_recommend_products DROP PRIMARY KEY; -- 以下共通 DELETE FROM dtb_recommend_products WHERE EXISTS( SELECT * FROM dtb_recommend_products sub WHERE sub.product_id = dtb_recommend_products.product_id AND sub.recommend_product_id = dtb_recommend_products.recommend_product_id AND sub.rank > dtb_recommend_products.rank ) ; ALTER TABLE dtb_recommend_products ADD PRIMARY KEY (product_id, recommend_product_id);
SQL (他DDL)
該当なし
SQL (他DML)
UPDATE dtb_csv SET size_const_type = 'LTEXT_LEN' WHERE no = 70 AND size_const_type = 'STEXT_LEN' ; UPDATE mtb_constants SET name = '"LC_Page_preProcess"' WHERE id = 'HOOK_POINT_PREPROCESS' AND name = 'LC_Page_preProcess' ; UPDATE mtb_constants SET name = '"LC_Page_process"' WHERE id = 'HOOK_POINT_PROCESS' AND name = 'LC_Page_process' ; INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MYPAGE_ORDER_STATUS_DISP_FLAG', 'true', 1412, 'MYページ:ご注文状況表示フラグ');
ファイル
変更: data/Smarty/templates/admin/basis/delivery_input.tpl data/Smarty/templates/admin/basis/kiyaku.tpl data/Smarty/templates/admin/customer/edit_confirm.tpl data/Smarty/templates/admin/home.tpl data/Smarty/templates/admin/order/product_select.tpl data/Smarty/templates/admin/ownersstore/plugin.tpl data/Smarty/templates/admin/products/confirm.tpl data/Smarty/templates/admin/products/product_select.tpl data/Smarty/templates/admin/products/review.tpl data/Smarty/templates/admin/products/upload_csv_complete.tpl data/Smarty/templates/default/mypage/index.tpl data/Smarty/templates/default/products/list.tpl data/class/SC_CartSession.php data/class/SC_CheckError.php data/class/SC_ClassAutoloader.php data/class/SC_CustomerList.php data/class/SC_Date.php data/class/SC_Display.php data/class/SC_FormParam.php data/class/SC_Fpdf.php data/class/SC_Image.php data/class/SC_Initial.php data/class/SC_MobileEmoji.php data/class/SC_MobileImage.php data/class/SC_Product.php data/class/SC_Query.php data/class/SC_SelectSql.php data/class/SC_SendMail.php data/class/SC_UploadFile.php data/class/SC_View.php data/class/api/operations/ItemSearch.php data/class/db/SC_DB_MasterData.php data/class/helper/SC_Helper_CSV.php data/class/helper/SC_Helper_DB.php data/class/helper/SC_Helper_FPDI.php data/class/helper/SC_Helper_FileManager.php data/class/helper/SC_Helper_HandleError.php data/class/helper/SC_Helper_Mail.php data/class/helper/SC_Helper_Mobile.php data/class/helper/SC_Helper_PageLayout.php data/class/helper/SC_Helper_Plugin.php data/class/helper/SC_Helper_Purchase.php data/class/helper/SC_Helper_Transform.php data/class/pages/LC_Page_ResizeImage.php data/class/pages/LC_Page_Sitemap.php data/class/pages/admin/basis/LC_Page_Admin_Basis.php data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php data/class/pages/admin/basis/LC_Page_Admin_Basis_PaymentInput.php data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php data/class/pages/admin/contents/LC_Page_Admin_Contents_FileManager.php data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php data/class/pages/admin/ownersstore/LC_Page_Admin_OwnersStore.php data/class/pages/admin/products/LC_Page_Admin_Products_Class.php data/class/pages/admin/products/LC_Page_Admin_Products_Maker.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/admin/products/LC_Page_Admin_Products_Review.php data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSV.php data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php data/class/pages/admin/total/LC_Page_Admin_Total.php data/class/pages/cart/LC_Page_Cart.php data/class/pages/entry/LC_Page_Entry.php data/class/pages/entry/LC_Page_Entry_EmailMobile.php data/class/pages/forgot/LC_Page_Forgot.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_News.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Recommend.php data/class/pages/mypage/LC_Page_Mypage.php data/class/pages/mypage/LC_Page_Mypage_Change.php data/class/pages/products/LC_Page_Products_Detail.php data/class/pages/products/LC_Page_Products_List.php data/class/pages/regist/LC_Page_Regist.php data/class/pages/rss/LC_Page_Rss.php data/class/pages/shopping/LC_Page_Shopping.php data/class/pages/shopping/LC_Page_Shopping_Confirm.php data/class/pages/shopping/LC_Page_Shopping_Deliv.php data/class/pages/shopping/LC_Page_Shopping_Multiple.php data/class/pages/shopping/LC_Page_Shopping_Payment.php data/class/pages/upgrade/LC_Page_Upgrade_Base.php data/class/pages/upgrade/helper/LC_Upgrade_Helper_Json.php data/class/plugin/SC_Plugin_Base.php data/class/plugin/SC_Plugin_Util.php data/class/util/GC_Utils.php data/class/util/SC_Utils.php data/downloads/KEN_ALL.CSV data/mtb_constants_init.php data/require_compat.php html/admin/require.php html/install/index.php html/install/sql/create_table_mysql.sql html/install/sql/create_table_pgsql.sql html/install/sql/drop_table.sql html/install/sql/insert_data.sql html/js/jquery.facebox/facebox.js html/js/products.js html/js/site.js html/require.php test/createEcCubeData-v25.php