-- [PG]
CREATE INDEX dtb_session_sess_id_key ON dtb_session (sess_id)
;
-- [MY]
CREATE INDEX dtb_session_sess_id_key ON dtb_session (sess_id(32))
;
INSERT INTO dtb_table_comment(TABLE_NAME,column_name,description) VALUES ('dtb_products','note','備考欄(SHOP専用)')
;
ALTER TABLE dtb_baseinfo
ADD COLUMN regular_holiday_ids text
;
-- [PG]
-- 暫定(位置に差異あり)
ALTER TABLE dtb_products
ADD COLUMN note text
;
-- [MY]
ALTER TABLE dtb_products
ADD note TEXT
AFTER comment6
;
-- [PG]
CREATE TABLE dtb_customer_favorite_products (
customer_id int4 NOT NULL,
product_id int4 NOT NULL,
create_date TIMESTAMP NOT NULL DEFAULT now(),
update_date TIMESTAMP NOT NULL DEFAULT now(),
PRIMARY KEY (customer_id, product_id)
)
;
-- [MY]
CREATE TABLE dtb_customer_favorite_products (
customer_id INT NOT NULL,
product_id INT NOT NULL,
create_date datetime NOT NULL,
update_date datetime NOT NULL
) TYPE=InnoDB
;
CREATE INDEX dtb_send_customer_customer_id_key ON dtb_send_customer(customer_id)
;
DELETE FROM dtb_csv WHERE csv_id = 1;
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'product_id','商品ID',1,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'product_class_id','規格ID',2,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'classcategory_id1','規格名1',3,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'classcategory_id2','規格名2',4,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'name','商品名',5,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'status','公開フラグ',6,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'product_flag','商品ステータス',7,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'product_code','商品コード',8,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'price01','通常価格',9,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'price02','販売価格',10,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'stock','在庫数',11,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'deliv_fee','送料',12,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'point_rate','ポイント付与率',13,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sale_limit','購入制限',14,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'comment1','メーカーURL',15,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'comment3','検索ワード',16,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'note','備考欄(SHOP専用)',17,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'main_list_comment','一覧-メインコメント',18,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'main_list_image','一覧-メイン画像',19,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'main_comment','詳細-メインコメント',20,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'main_image','詳細-メイン画像',21,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'main_large_image','詳細-メイン拡大画像 ',22,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'file1','カラー比較画像',23,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'file2','商品詳細ファイル ',24,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_title1','詳細-サブタイトル（1）',25,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_comment1','詳細-サブコメント（1）',26,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_image1','詳細-サブ画像（1）',27,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_large_image1','詳細-サブ拡大画像（1）',28,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_title2','詳細-サブタイトル（2）',29,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_comment2','詳細-サブコメント（2）',30,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_image2','詳細-サブ画像（2）',31,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_large_image2','詳細-サブ拡大画像（2）',32,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_title3','詳細-サブタイトル（3）',33,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_comment3','詳細-サブコメント（3）',34,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_image3','詳細-サブ画像（3）',35,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_large_image3','詳細-サブ拡大画像（3）',36,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_title4','詳細-サブタイトル（4）',37,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_comment4','詳細-サブコメント（4）',38,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_image4','詳細-サブ画像（4）',39,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_large_image4','詳細-サブ拡大画像（4）',40,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_title5','詳細-サブタイトル（5）',41,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_comment5','詳細-サブコメント（5）',42,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_image5','詳細-サブ画像（5）',43,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'sub_large_image5','詳細-サブ拡大画像（5）',44,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'deliv_date_id','発送日目安',45,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1','おすすめ商品(1)',46,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1','おすすめコメント(1)',47,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2','おすすめ商品(2)',48,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2','おすすめコメント(2)',49,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3','おすすめ商品(3)',50,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3','おすすめコメント(3)',51,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','おすすめ商品(4)',52,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','おすすめコメント(4)',53,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5','おすすめ商品(5)',54,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5','おすすめコメント(5)',55,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6','おすすめ商品(6)',56,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6','おすすめコメント(6)',57,now(),now());
INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)VALUES(1,'category_id','カテゴリID',58,now(),now());
UPDATE mtb_constants
SET remarks = '管理画面用：ID・パスワードの文字数制限'
WHERE id = 'ID_MAX_LEN'
;
UPDATE mtb_constants
SET remarks = '管理画面用：ID・パスワードの文字数制限'
WHERE id = 'ID_MIN_LEN'
;
UPDATE mtb_constants
SET remarks = 'フロント画面用：パスワードの最小文字数'
WHERE id = 'PASSWORD_LEN1'
;
UPDATE mtb_constants
SET remarks = 'フロント画面用：パスワードの最大文字数'
WHERE id = 'PASSWORD_LEN2'
;
INSERT INTO mtb_constants
VALUES ('USE_POINT','true',290,'ポイントを利用するか(true:利用する、false:利用しない) (false は一部対応)')
;
INSERT INTO mtb_constants
VALUES ('OPTION_FAVOFITE_PRODUCT','1',523,'お気に入り商品登録(有効:1 無効:0)')
;
INSERT INTO mtb_constants
VALUES ('NOSTOCK_HIDDEN','false',524,'お気に入り商品を表示する際の、在庫なし商品表示・非表示(非表示:true 表示:false)')
;
INSERT INTO mtb_constants
VALUES ('IMAGE_RENAME','true',525,'画像リネーム設定（商品画像のみ）(true:リネームする、false:リネームしない)')
;