2.13.5 から 2.17.2

• 2.13.5 は、2.13.4 も同様。
• 2.17.2 は、2.17.2-p1 も同様。

BEGIN;
 
-- DDL
DROP SEQUENCE dtb_bloc_bloc_id_seq;
DROP SEQUENCE dtb_csv_no_seq;
DROP SEQUENCE dtb_pagelayout_page_id_seq;
ALTER TABLE dtb_shipment_item DROP CONSTRAINT dtb_shipment_item_pkey;
ALTER TABLE dtb_shipment_item ADD CONSTRAINT dtb_shipment_item_pkey PRIMARY KEY (order_id, shipping_id, product_class_id);
ALTER TABLE dtb_shipping DROP CONSTRAINT dtb_shipping_pkey;
ALTER TABLE dtb_shipping ADD CONSTRAINT dtb_shipping_pkey PRIMARY KEY (order_id, shipping_id);
CREATE INDEX dtb_order_customer_id_key ON public.dtb_order USING btree (customer_id);
CREATE INDEX dtb_order_detail_order_id_key ON public.dtb_order_detail USING btree (order_id);
CREATE INDEX dtb_session_update_date_key ON public.dtb_session USING btree (update_date);
 
-- DML
-- UPDATE 文は結果が1行であることを確認する。(変更後の値と同じ場合も更新するように考慮してある。)
INSERT INTO dtb_index_list (TABLE_NAME, column_name, recommend_flg, recommend_comment) VALUES ('dtb_session', 'update_date', 0, NULL);
UPDATE mtb_allowed_tag SET name = 'span' WHERE id = 9 AND name IN ('h', 'span');
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (19, 'h1', 19);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (20, 'h2', 20);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (21, 'h3', 21);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (22, 'h4', 22);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (23, 'h5', 23);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (24, 'h6', 24);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (25, 'tbody', 25);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (26, 'thead', 26);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (27, 'tfoot', 27);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (28, 'th', 28);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (29, 'ul', 29);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (30, 'ol', 30);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (31, 'dl', 31);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (32, 'dt', 32);
INSERT INTO mtb_allowed_tag (id, name, rank) VALUES (33, 'dd', 33);
UPDATE mtb_constants SET name = '8' WHERE id = 'PASSWORD_MIN_LEN' AND name IN ('1', '2', '3', '4', '5', '6', '7', '8');
UPDATE mtb_constants SET name = 'SMTEXT_LEN' WHERE id = 'PASSWORD_MAX_LEN' AND name IN ('STEXT_LEN', 'SMTEXT_LEN');
UPDATE mtb_constants SET name = '"https://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip"' WHERE id = 'ZIP_DOWNLOAD_URL' AND name IN ('"http://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip"', '"https://www.post.japanpost.jp/zipcode/dl/kogaki/zip/ken_all.zip"');
INSERT INTO mtb_constants (id, name, rank, remarks) VALUES ('SUBSTITUTE_CHAR', '63', 1421, 'UTF-8依存文字が入力された際に表示する文字(Unicode値の整数 デフォルト: ?)');
INSERT INTO mtb_mobile_domain (id, name, rank) VALUES (11, 'au.com', 10);
UPDATE mtb_permission SET id = '/system/index.php'          WHERE id IN ('/admin/system/index.php',         '/system/index.php'         );
UPDATE mtb_permission SET id = '/system/delete.php'         WHERE id IN ('/admin/system/delete.php',        '/system/delete.php'        );
UPDATE mtb_permission SET id = '/system/input.php'          WHERE id IN ('/admin/system/input.php',         '/system/input.php'         );
UPDATE mtb_permission SET id = '/system/master.php'         WHERE id IN ('/admin/system/master.php',        '/system/master.php'        );
UPDATE mtb_permission SET id = '/system/master_delete.php'  WHERE id IN ('/admin/system/master_delete.php', '/system/master_delete.php' );
UPDATE mtb_permission SET id = '/system/master_rank.php'    WHERE id IN ('/admin/system/master_rank.php',   '/system/master_rank.php'   );
UPDATE mtb_permission SET id = '/system/mastercsv.php'      WHERE id IN ('/admin/system/mastercsv.php',     '/system/mastercsv.php'     );
UPDATE mtb_permission SET id = '/system/rank.php'           WHERE id IN ('/admin/system/rank.php',          '/system/rank.php'          );
UPDATE mtb_permission SET id = '/entry/index.php'           WHERE id IN ('/admin/entry/index.php',          '/entry/index.php'          );
UPDATE mtb_permission SET id = '/entry/delete.php'          WHERE id IN ('/admin/entry/delete.php',         '/entry/delete.php'         );
UPDATE mtb_permission SET id = '/entry/inputzip.php'        WHERE id IN ('/admin/entry/inputzip.php',       '/entry/inputzip.php'       );
UPDATE mtb_permission SET id = '/search/delete_note.php'    WHERE id IN ('/admin/search/delete_note.php',   '/search/delete_note.php'   );
 
COMMIT;

未確認