2.11.0 から 2.11.1
- 構文エラーなき事のみ確認。データ整合は未確認。
- (2012/1/18) MySQL 環境に適用。不具合箇所を修正。
SQL (DDL)
dtb_plugin
for PostgreSQL
-- dtb_plugin が空の場合 DROP TABLE dtb_plugin; CREATE TABLE dtb_plugin ( plugin_id INT NOT NULL, plugin_name text NOT NULL, plugin_code text NOT NULL, author text, plugin_site_url text, plugin_version text, plugin_description text, plugin_setting_path text, class_name text NOT NULL, rank INT NOT NULL DEFAULT 0, STATUS SMALLINT NOT NULL DEFAULT 0, enable SMALLINT NOT NULL DEFAULT 0, del_flg SMALLINT NOT NULL DEFAULT 0, create_date TIMESTAMP NOT NULL DEFAULT now(), update_date TIMESTAMP NOT NULL, PRIMARY KEY (plugin_id) ); -- dtb_plugin にデータがある場合 ALTER TABLE dtb_plugin ALTER COLUMN plugin_name DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN author DROP NOT NULL; ALTER TABLE dtb_plugin ALTER COLUMN author DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN plugin_site_url DROP NOT NULL; ALTER TABLE dtb_plugin ALTER COLUMN plugin_site_url DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN plugin_version DROP NOT NULL; ALTER TABLE dtb_plugin ALTER COLUMN plugin_version DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN plugin_description DROP NOT NULL; ALTER TABLE dtb_plugin ALTER COLUMN plugin_description DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN plugin_setting_path DROP NOT NULL; ALTER TABLE dtb_plugin ALTER COLUMN plugin_setting_path DROP DEFAULT; ALTER TABLE dtb_plugin ALTER COLUMN class_name DROP DEFAULT; -- rank 追加が欠落
for MySQL
-- dtb_plugin が空の場合 DROP TABLE dtb_plugin; CREATE TABLE dtb_plugin ( plugin_id INT 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 NOT NULL DEFAULT 0, STATUS SMALLINT NOT NULL DEFAULT 0, enable SMALLINT NOT NULL DEFAULT 0, del_flg SMALLINT NOT NULL DEFAULT 0, create_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, update_date TIMESTAMP NOT NULL, PRIMARY KEY (plugin_id) ) ENGINE=InnoDB; -- dtb_plugin にデータがある場合 ALTER TABLE dtb_plugin MODIFY plugin_name VARCHAR(255) NOT NULL; ALTER TABLE dtb_plugin MODIFY author VARCHAR(255); ALTER TABLE dtb_plugin MODIFY plugin_site_url VARCHAR(255); ALTER TABLE dtb_plugin MODIFY plugin_version VARCHAR(255); ALTER TABLE dtb_plugin MODIFY plugin_description VARCHAR(255); ALTER TABLE dtb_plugin MODIFY plugin_setting_path VARCHAR(255); ALTER TABLE dtb_plugin MODIFY class_name VARCHAR(255) NOT NULL; -- rank 追加が欠落
他
ALTER TABLE dtb_index_list ALTER COLUMN TABLE_NAME DROP DEFAULT; ALTER TABLE dtb_index_list ALTER COLUMN column_name DROP DEFAULT;
SQL (DML)
INSERT INTO dtb_bloc (device_type_id, bloc_id, bloc_name, tpl_path, filename, create_date, update_date, php_path, deletable_flg) VALUES (1, 4, 'カテゴリ', 'category.tpl', 'category', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP, 'frontparts/bloc/category.php', 0); INSERT INTO dtb_blocposition (device_type_id, page_id, target_id, bloc_id, bloc_row, anywhere) VALUES (1, 1, 2, 4, 3, 0); -- 1行更新 UPDATE dtb_csv SET size_const_type = 'null' ,error_check_types = 'NO_SPTAB,EMAIL_CHECK,EMAIL_CHAR_CHECK' WHERE 0=0 AND size_const_type = 'STEXT_LEN' AND error_check_types = 'NO_SPTAB,MAX_LENGTH_CHECK,EMAIL_CHECK,EMAIL_CHAR_CHECK' ; -- 1行削除 DELETE FROM mtb_constants WHERE id = 'SMARTPHONE_DEFAULT_TEMPLATE_NAME' AND name = '"mobile"'; -- 1行削除 DELETE FROM mtb_constants WHERE id = 'MOBILE_DEFAULT_TEMPLATE_NAME' AND name = '"sphone"'; -- 1行挿入 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('MOBILE_DEFAULT_TEMPLATE_NAME', '"mobile"', 301, 'デフォルトテンプレート名(モバイル)'); -- 1行挿入 INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SMARTPHONE_DEFAULT_TEMPLATE_NAME', '"sphone"', 302, 'デフォルトテンプレート名(スマートフォン)');
他に \html\user_data\packages\default\sql\update_bloc.sql も改訂があるが、アップデート時の適用は不要と思われる。(2.11.0 では実行されていなかった。)
ファイル
削除: data/Smarty/templates/admin/design/upload.tpl data/class_extends/page_extends/mypage/LC_Page_Mypage_LoginCheck_Ex.php data/module/fpdf/filters/ data/module/fpdf/filters/FilterASCII85.php data/module/fpdf/filters/FilterASCII85_FPDI.php data/module/fpdf/filters/FilterLZW.php data/module/fpdf/filters/FilterLZW_FPDI.php data/module/fpdf/font/makefont/ data/module/fpdf/font/makefont/cp1250.map data/module/fpdf/font/makefont/cp1251.map data/module/fpdf/font/makefont/cp1252.map data/module/fpdf/font/makefont/cp1253.map data/module/fpdf/font/makefont/cp1254.map data/module/fpdf/font/makefont/cp1255.map data/module/fpdf/font/makefont/cp1257.map data/module/fpdf/font/makefont/cp1258.map data/module/fpdf/font/makefont/cp874.map data/module/fpdf/font/makefont/iso-8859-1.map data/module/fpdf/font/makefont/iso-8859-11.map data/module/fpdf/font/makefont/iso-8859-15.map data/module/fpdf/font/makefont/iso-8859-16.map data/module/fpdf/font/makefont/iso-8859-2.map data/module/fpdf/font/makefont/iso-8859-4.map data/module/fpdf/font/makefont/iso-8859-5.map data/module/fpdf/font/makefont/iso-8859-7.map data/module/fpdf/font/makefont/iso-8859-9.map data/module/fpdf/font/makefont/koi8-r.map data/module/fpdf/font/makefont/koi8-u.map data/module/fpdf/font/makefont/makefont.php data/module/fpdf/fpdf_tpl.php data/module/fpdf/fpdi.php data/module/fpdf/fpdi2tcpdf_bridge.php data/module/fpdf/fpdi_pdf_parser.php data/module/fpdf/japanese.php data/module/fpdf/pdf_context.php data/module/fpdf/pdf_parser.php html/mypage/login_check.php html/user_data/packages/sphone/css/detail.css html/user_data/packages/sphone/css/iphone.css html/user_data/packages/sphone/css/table.css html/user_data/packages/sphone/css/top.css html/user_data/packages/sphone/css/width.css html/user_data/packages/sphone/css/wreckage.css 追加: data/class_extends/page_extends/mypage/LC_Page_Mypage_LoginCheck_Ex.php data/module/fpdf/filters/ data/module/fpdf/filters/FilterASCII85.php data/module/fpdf/filters/FilterASCII85_FPDI.php data/module/fpdf/filters/FilterLZW.php data/module/fpdf/filters/FilterLZW_FPDI.php data/module/fpdf/font/makefont/ data/module/fpdf/font/makefont/cp1250.map data/module/fpdf/font/makefont/cp1251.map data/module/fpdf/font/makefont/cp1252.map data/module/fpdf/font/makefont/cp1253.map data/module/fpdf/font/makefont/cp1254.map data/module/fpdf/font/makefont/cp1255.map data/module/fpdf/font/makefont/cp1257.map data/module/fpdf/font/makefont/cp1258.map data/module/fpdf/font/makefont/cp874.map data/module/fpdf/font/makefont/iso-8859-1.map data/module/fpdf/font/makefont/iso-8859-11.map data/module/fpdf/font/makefont/iso-8859-15.map data/module/fpdf/font/makefont/iso-8859-16.map data/module/fpdf/font/makefont/iso-8859-2.map data/module/fpdf/font/makefont/iso-8859-4.map data/module/fpdf/font/makefont/iso-8859-5.map data/module/fpdf/font/makefont/iso-8859-7.map data/module/fpdf/font/makefont/iso-8859-9.map data/module/fpdf/font/makefont/koi8-r.map data/module/fpdf/font/makefont/koi8-u.map data/module/fpdf/font/makefont/makefont.php data/module/fpdf/fpdf_tpl.php data/module/fpdf/fpdi.php data/module/fpdf/fpdi2tcpdf_bridge.php data/module/fpdf/fpdi_pdf_parser.php data/module/fpdf/japanese.php data/module/fpdf/pdf_context.php data/module/fpdf/pdf_parser.php html/mypage/login_check.php html/user_data/packages/sphone/css/detail.css html/user_data/packages/sphone/css/iphone.css html/user_data/packages/sphone/css/table.css html/user_data/packages/sphone/css/top.css html/user_data/packages/sphone/css/width.css html/user_data/packages/sphone/css/wreckage.css 変更: data/Smarty/templates/admin/adminparts/form_customer_search.tpl data/Smarty/templates/admin/basis/delivery.tpl data/Smarty/templates/admin/basis/index.tpl data/Smarty/templates/admin/basis/payment.tpl data/Smarty/templates/admin/basis/point.tpl data/Smarty/templates/admin/contents/file_manager.tpl data/Smarty/templates/admin/contents/recommend.tpl data/Smarty/templates/admin/customer/index.tpl data/Smarty/templates/admin/design/bloc.tpl data/Smarty/templates/admin/design/css.tpl data/Smarty/templates/admin/design/header.tpl data/Smarty/templates/admin/design/index.tpl data/Smarty/templates/admin/design/main_edit.tpl data/Smarty/templates/admin/design/template.tpl data/Smarty/templates/admin/design/up_down.tpl data/Smarty/templates/admin/mail/input_confirm.tpl data/Smarty/templates/admin/main_frame.tpl data/Smarty/templates/admin/order/subnavi.tpl data/Smarty/templates/admin/products/category.tpl data/Smarty/templates/admin/products/class.tpl data/Smarty/templates/admin/products/confirm.tpl data/Smarty/templates/admin/products/maker.tpl data/Smarty/templates/admin/products/product_rank.tpl data/Smarty/templates/admin/system/plugin.tpl data/Smarty/templates/admin/system/system.tpl data/Smarty/templates/admin/total/page_products.tpl data/Smarty/templates/default/abouts/index.tpl data/Smarty/templates/default/cart/index.tpl data/Smarty/templates/default/contact/index.tpl data/Smarty/templates/default/entry/kiyaku.tpl data/Smarty/templates/default/frontparts/bloc/cart.tpl data/Smarty/templates/default/frontparts/form_personal_input.tpl data/Smarty/templates/default/header.tpl data/Smarty/templates/default/mypage/history.tpl data/Smarty/templates/default/products/detail.tpl data/Smarty/templates/default/shopping/payment.tpl data/Smarty/templates/default/site_frame.tpl data/Smarty/templates/default/site_main.tpl data/Smarty/templates/mobile/cart/index.tpl data/Smarty/templates/mobile/entry/confirm.tpl data/Smarty/templates/mobile/entry/email_mobile.tpl data/Smarty/templates/mobile/entry/index.tpl data/Smarty/templates/mobile/frontparts/bloc/category.tpl data/Smarty/templates/mobile/header.tpl data/Smarty/templates/mobile/index.tpl data/Smarty/templates/mobile/mypage/change.tpl data/Smarty/templates/mobile/mypage/change_confirm.tpl data/Smarty/templates/mobile/mypage/history.tpl data/Smarty/templates/mobile/shopping/confirm.tpl data/Smarty/templates/mobile/shopping/deliv.tpl data/Smarty/templates/mobile/shopping/payment.tpl data/Smarty/templates/mobile/shopping/select_deliv.tpl data/Smarty/templates/mobile/site_frame.tpl data/Smarty/templates/mobile/site_main.tpl data/Smarty/templates/sphone/abouts/index.tpl data/Smarty/templates/sphone/cart/index.tpl data/Smarty/templates/sphone/frontparts/form_personal_input.tpl data/Smarty/templates/sphone/mypage/history.tpl data/Smarty/templates/sphone/site_frame.tpl data/Smarty/templates/sphone/site_main.tpl data/class/SC_CartSession.php data/class/SC_CheckError.php data/class/SC_FormParam.php data/class/SC_Initial.php data/class/SC_Product.php data/class/SC_Query.php data/class/SC_UploadFile.php data/class/db/SC_DB_DBFactory.php data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php data/class/helper/SC_Helper_Customer.php data/class/helper/SC_Helper_DB.php data/class/helper/SC_Helper_FileManager.php data/class/helper/SC_Helper_PageLayout.php data/class/helper/SC_Helper_Plugin.php data/class/helper/SC_Helper_Purchase.php data/class/pages/admin/LC_Page_Admin.php data/class/pages/admin/basis/LC_Page_Admin_Basis.php data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php data/class/pages/admin/contents/LC_Page_Admin_Contents.php data/class/pages/admin/customer/LC_Page_Admin_Customer.php data/class/pages/admin/customer/LC_Page_Admin_Customer_Edit.php data/class/pages/admin/design/LC_Page_Admin_Design.php data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php data/class/pages/admin/design/LC_Page_Admin_Design_CSS.php data/class/pages/admin/design/LC_Page_Admin_Design_Header.php data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php data/class/pages/admin/design/LC_Page_Admin_Design_Template.php data/class/pages/admin/design/LC_Page_Admin_Design_UpDown.php data/class/pages/admin/order/LC_Page_Admin_Order.php data/class/pages/admin/order/LC_Page_Admin_Order_Edit.php data/class/pages/admin/products/LC_Page_Admin_Products_ClassCategory.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_UploadCSV.php data/class/pages/admin/products/LC_Page_Admin_Products_UploadCSVCategory.php data/class/pages/admin/system/LC_Page_Admin_System_Bkup.php data/class/pages/admin/system/LC_Page_Admin_System_Plugin.php data/class/pages/admin/system/LC_Page_Admin_System_System.php data/class/pages/admin/total/LC_Page_Admin_Total.php data/class/pages/cart/LC_Page_Cart.php data/class/pages/contact/LC_Page_Contact.php data/class/pages/entry/LC_Page_Entry_Complete.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.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Calendar.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Cart.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Login.php data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_LoginHeader.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/frontparts/bloc/LC_Page_FrontParts_Bloc_SearchProducts.php data/class/pages/mypage/LC_Page_Mypage_DownLoad.php data/class/pages/mypage/LC_Page_Mypage_History.php data/class/pages/products/LC_Page_Products_Detail.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_Payment.php data/class/util/SC_Utils.php data/download/save/recipe_onabe.pdf data/downloads/KEN_ALL.CSV html/admin/css/install.css html/frontparts/bloc/calendar.php html/frontparts/bloc/cart.php html/frontparts/bloc/category.php html/frontparts/bloc/login.php html/frontparts/bloc/login_header.php html/frontparts/bloc/news.php html/frontparts/bloc/recommend.php html/frontparts/bloc/search_products.php html/install/index.php html/install/sql/create_table_mysql.sql html/install/sql/create_table_pgsql.sql html/install/sql/insert_data.sql html/user_data/__default.php html/user_data/packages/admin/css/admin_file_manager.css html/user_data/packages/default/css/contents.css html/user_data/packages/default/css/popup_import.css html/user_data/packages/default/sql/update_bloc.sql test/class/util/SC_Utils_Test.php test/require.php