Changeset 18216 for branches/comu-ver2/html/install/sql/insert_data.sql

Timestamp:

2009/07/20 07:32:15 (14 years ago)

Author:

Seasoft

Message:

#518(ブロックを置ける場所を増やしてみた)

• 未使用(Unused)の値が頻繁に変更される煩雑さから開放(アップグレードの手間を軽減する意図)

File:

• branches/comu-ver2/html/install/sql/insert_data.sql (modified) (2 diffs)

branches/comu-ver2/html/install/sql/insert_data.sql

@@ -34 +34 @@
 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,1,2,3,'guide');
 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,1,3,1,'cart');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,4,0,'search_products');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,5,0,'news');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,6,0,'login');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (2,10,7,0,'best5');
 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,1,2,'category');
 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,2,3,'guide');
 INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,1,3,1,'cart');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,4,0,'search_products');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,5,0,'news');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,6,0,'login');
-INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename) VALUES (3,10,7,0,'best5');
 
 INSERT INTO dtb_csv(csv_id,col,disp_name,rank,create_date,update_date) VALUES (1,'product_id','商品ID',1,now(),now());
@@ -741 +733 @@
 INSERT INTO mtb_db VALUES ('1', 'PostgreSQL',0);
 INSERT INTO mtb_db VALUES ('2', 'MySQL',1);
-INSERT INTO mtb_target VALUES ('1', 'LeftNavi',0);
-INSERT INTO mtb_target VALUES ('2', 'MainHead',1);
-INSERT INTO mtb_target VALUES ('3', 'RightNavi',2);
-INSERT INTO mtb_target VALUES ('4', 'MainFoot',3);
-INSERT INTO mtb_target VALUES ('5', 'TopNavi',4);
-INSERT INTO mtb_target VALUES ('6', 'BottomNavi',5);
-INSERT INTO mtb_target VALUES ('7', 'HeadNavi',6);
-INSERT INTO mtb_target VALUES ('8', 'HeaderTopNavi',7);
-INSERT INTO mtb_target VALUES ('9', 'FooterBottomNavi',8);
-INSERT INTO mtb_target VALUES ('10', 'Unused',9);
+INSERT INTO mtb_target VALUES ('0', 'Unused',0);
+INSERT INTO mtb_target VALUES ('1', 'LeftNavi',1);
+INSERT INTO mtb_target VALUES ('2', 'MainHead',2);
+INSERT INTO mtb_target VALUES ('3', 'RightNavi',3);
+INSERT INTO mtb_target VALUES ('4', 'MainFoot',4);
+INSERT INTO mtb_target VALUES ('5', 'TopNavi',5);
+INSERT INTO mtb_target VALUES ('6', 'BottomNavi',6);
+INSERT INTO mtb_target VALUES ('7', 'HeadNavi',7);
+INSERT INTO mtb_target VALUES ('8', 'HeaderTopNavi',8);
+INSERT INTO mtb_target VALUES ('9', 'FooterBottomNavi',9);
 INSERT INTO mtb_review_deny_url VALUES ('0', 'http://',0);
 INSERT INTO mtb_review_deny_url VALUES ('1', 'https://',1);