source: temp/branches/mobile/html/install/sql/insert_data.sql @ 11398

CREATE INDEX dtb_products_category_id_key ON dtb_products(category_id);
CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id);
CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id);
CREATE INDEX dtb_customer_mobile_phone_id_key ON dtb_customer (mobile_phone_id);

INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date) 
VALUES ('dummy','dummy',' ',0,0,1,1, now(), now());

insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¥«¥Æ¥´¥ê', 'include/bloc/category.tpl', 'category','frontparts/bloc/category.php', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('ÍøÍÑ¥¬¥¤¥É','include/bloc/guide.tpl', 'guide','', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¤«¤´¤ÎÃæ', 'include/bloc/cart.tpl', 'cart','frontparts/bloc/cart.php', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¾¦Éʸ¡º÷', 'include/bloc/search_products.tpl', 'search_products','frontparts/bloc/search_products.php', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¿·Ãå¾ðÊó', 'include/bloc/news.tpl', 'news','frontparts/bloc/news.php', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¥í¥°¥¤¥ó', 'include/bloc/login.tpl', 'login','frontparts/bloc/login.php', 1, now(), now());
insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg, create_date, update_date ) values ('¥ª¥¹¥¹¥á¾¦ÉÊ','include/bloc/best5.tpl', 'best5','frontparts/bloc/best5.php', 1, now(), now());

insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg, create_date, update_date)values('TOP¥Ú¡¼¥¸','index.php',' ','user_data/templates/','top',2,now(),now());
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg, create_date, update_date)values('¾¦ÉÊ°ìÍ÷¥Ú¡¼¥¸','products/list.php',' ','user_data/templates/','list',2,now(),now());
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg, create_date, update_date)values('¾¦Éʾܺ٥ڡ¼¥¸','products/detail.php',' ','user_data/templates/','detail',2,now(),now());
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg, create_date, update_date)values('MY¥Ú¡¼¥¸','mypage/index.php',' ','','',2,now(),now());

insert into dtb_pagelayout (page_id,page_name,url, create_date, update_date)values(0, '¥×¥ì¥Ó¥å¡¼¥Ç¡¼¥¿',' ',now(),now());
update dtb_pagelayout set page_id = 0 where page_id = 5;

INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),2,'search_products');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),1,'news');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),1,'login');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),2,'best5');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'category'),2,'category');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'guide'),3,'guide');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'cart'),1,'cart');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'search_products'),0,'search_products');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'news'),0,'news');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'login'),0,'login');
INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,(SELECT bloc_id FROM dtb_bloc WHERE filename = 'best5'),0,'best5');

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,'main_list_comment','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È',17,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_list_image','°ìÍ÷-¥á¥¤¥ó²èÁü',18,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_comment','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È',19,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_image','¾ÜºÙ-¥á¥¤¥ó²èÁü',20,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_large_image','¾ÜºÙ-¥á¥¤¥ó³ÈÂç²èÁü ',21,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'file1','¥«¥é¡¼Èæ³Ó²èÁü',22,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'file2','¾¦Éʾܺ٥ե¡¥¤¥ë    ',23,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title1','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê1¡Ë',24,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment1','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê1¡Ë',25,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image1','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê1¡Ë',26,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image1','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê1¡Ë',27,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title2','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê2¡Ë',28,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment2','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê2¡Ë',29,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image2','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê2¡Ë',30,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image2','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê2¡Ë',31,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title3','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê3¡Ë',32,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment3','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê3¡Ë',33,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image3','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê3¡Ë',34,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image3','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê3¡Ë',35,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title4','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê4¡Ë',36,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment4','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê4¡Ë',37,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image4','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê4¡Ë',38,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image4','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê4¡Ë',39,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title5','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê5¡Ë',40,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment5','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê5¡Ë',41,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image5','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê5¡Ë',42,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image5','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê5¡Ë',43,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'deliv_date_id','ȯÁ÷ÆüÌÜ°Â',44,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)',45,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)',46,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)',47,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)',48,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)',49,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)',50,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)',51,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)',52,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'customer_id','¸ÜµÒID',1,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'name01','̾Á°1',2,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'name02','̾Á°2',3,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'kana01','¥Õ¥ê¥¬¥Ê1',4,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'kana02','¥Õ¥ê¥¬¥Ê2',5,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'zip01', '͹ÊØÈÖ¹æ1',6,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'zip02', '͹ÊØÈÖ¹æ2',7,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'pref', 'ÅÔÆ»Éܸ©',8,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'addr01', '½»½ê1',9,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'addr02', '½»½ê2',10,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'email', 'E-MAIL',11,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel01', 'TEL1',12,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel02', 'TEL2',13,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel03', 'TEL3',14,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax01', 'FAX1',15,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax02', 'FAX2',16,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax03', 'FAX3',17,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'sex', 'À­ÊÌ',18,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'job', '¿¦¶È',19,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'birth', 'ÃÂÀ¸Æü',20,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'first_buy_date', '½é²ó¹ØÆþÆü',21,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'last_buy_date', 'ºÇ½ª¹ØÆþÆü',22,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'buy_times', '¹ØÆþ²ó¿ô',23,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'point', '¥Ý¥¤¥ó¥È»Ä¹â',24,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'note', 'È÷¹Í',25,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'create_date','ÅÐÏ¿Æü',26,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'update_date','¹¹¿·Æü',   27,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_id','ÃíʸID',1,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'customer_id','¸ÜµÒID',2,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'message','Í×˾Åù',3,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_name01','¸ÜµÒ̾1',4,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_name02','¸ÜµÒ̾2',5,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_kana01','¸ÜµÒ̾¥«¥Ê1',6,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_kana02','¸ÜµÒ̾¥«¥Ê2',7,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',8,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel01','ÅÅÏÃÈÖ¹æ1',9,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel02','ÅÅÏÃÈÖ¹æ2',10,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel03','ÅÅÏÃÈÖ¹æ3',11,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax01','FAX1',12,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax02','FAX2',13,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax03','FAX3',14,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_zip01','͹ÊØÈÖ¹æ1',15,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_zip02','͹ÊØÈÖ¹æ2',16,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_pref','ÅÔÆ»Éܸ©',17,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_addr01','½»½ê1',18,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_addr02','½»½ê2',19,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_sex','À­ÊÌ',20,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_birth','À¸Ç¯·îÆü',21,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_job','¿¦¼ï',22,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name01','ÇÛÁ÷Àè̾Á°',23,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name02','ÇÛÁ÷Àè̾Á°',24,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana01','ÇÛÁ÷À襫¥Ê',25,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana02','ÇÛÁ÷À襫¥Ê',26,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',27,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',28,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',29,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax01','FAX1',30,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax02','FAX2',31,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax03','FAX3',32,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_zip01','͹ÊØÈÖ¹æ1',33,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_zip02','͹ÊØÈÖ¹æ2',34,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_pref','ÅÔÆ»Éܸ©',35,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_addr01','½»½ê1',36,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_addr02','½»½ê2',37,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'subtotal','¾®·×',38,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'discount','ÃÍ°ú¤­',39,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fee','Á÷ÎÁ',40,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'charge','¼ê¿ôÎÁ',41,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'use_point','»ÈÍѥݥ¤¥ó¥È',42,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'add_point','²Ã»»¥Ý¥¤¥ó¥È',43,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'tax','ÀǶâ',44,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'total','¹ç·×',45,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_total','¤ª»Ùʧ¤¤¹ç·×',46,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_method','»Ùʧ¤¤ÊýË¡',47,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_time','ÇÛÁ÷»þ´Ö',48,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_no','ÇÛÁ÷ÅÁɼÈÖ¹æ',49,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'note','SHOP¥á¥â',50,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'status','Âбþ¾õ¶·',51,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'create_date','ÃíʸÆü»þ',52,now(),now());
insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'update_date','¹¹¿·Æü»þ',53,now(),now());


INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES('default1','¥Ç¥Õ¥©¥ë¥È1', now(), now());

insert into dtb_mailtemplate (template_id, subject, header, footer, creator_id, update_date, create_date) values (
1,
'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
'¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£

',
'

==============================================================¡ù


¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ø¤ÎÊÖ¿®¤È¤·¤Æ¤´¼ÁÌä¤ò¤ªÁ÷¤ê¤¤¤¿¤À¤¤¤Æ¤â²óÅú¤Ç¤­¤Þ¤»¤ó¡£
¤´Î»¾µ¤¯¤À¤µ¤¤¡£

¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
http://------.co.jp

',0,Now(), now());

insert into dtb_news (news_date,rank, news_title, news_comment, creator_id, create_date, update_date) 
values(now(),1,'¥µ¥¤¥È¥ª¡¼¥×¥ó¤¤¤¿¤·¤Þ¤·¤¿!','°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª',1, now(), now());

INSERT INTO dtb_deliv (name,service_name,confirm_url,rank,status,del_flg,creator_id,create_date,update_date)
VALUES ('¥µ¥ó¥×¥ë¶È¼Ô', '¥µ¥ó¥×¥ë¶È¼Ô', '', 1, 1, 0, 2, now(), now());

INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 1);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 2);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 3);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 4);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 5);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 6);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 7);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 8);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 9);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 10);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 11);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 12);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 13);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 14);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 15);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 16);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 17);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 18);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 19);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 20);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 21);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 22);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 23);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 24);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 25);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 26);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 27);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 28);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 29);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 30);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 31);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 32);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 33);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 34);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 35);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 36);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 37);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 38);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 39);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 40);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 41);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 42);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 43);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 44);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 45);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 46);
INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 47);

INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸áÁ°');
INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸á¸å');

INSERT INTO dtb_payment (payment_method,charge,rule,deliv_id,rank,note,fix,status,del_flg,creator_id,create_date,update_date,payment_image,upper_rule) VALUES ('͹ÊØ¿¶ÂØ', 0, NULL, 1, 4, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment (payment_method,charge,rule,deliv_id,rank,note,fix,status,del_flg,creator_id,create_date,update_date,payment_image,upper_rule) VALUES ('¸½¶â½ñα', 0, NULL, 1, 3, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment (payment_method,charge,rule,deliv_id,rank,note,fix,status,del_flg,creator_id,create_date,update_date,payment_image,upper_rule) VALUES ('¶ä¹Ô¿¶¹þ', 0, NULL, 1, 2, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment (payment_method,charge,rule,deliv_id,rank,note,fix,status,del_flg,creator_id,create_date,update_date,payment_image,upper_rule) VALUES ('Âå¶â°ú´¹', 0, NULL, 1, 1, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);

INSERT INTO dtb_products (name,deliv_fee,sale_limit,sale_unlimited,category_id,rank,status,product_flag,point_rate,comment1,comment2,comment3,comment4,comment5,comment6,file1,file2,file3,file4,file5,file6,main_list_comment,main_list_image,main_comment,main_image,main_large_image,sub_title1,sub_comment1,sub_image1,sub_large_image1,sub_title2,sub_comment2,sub_image2,sub_large_image2,sub_title3,sub_comment3,sub_image3,sub_large_image3,sub_title4,sub_comment4,sub_image4,sub_large_image4,sub_title5,sub_comment5,sub_image5,sub_large_image5,sub_title6,sub_comment6,sub_image6,sub_large_image6,del_flg,creator_id,create_date,update_date,deliv_date_id) 
VALUES ('¥¢¥¤¥¹¥¯¥ê¡¼¥à', NULL, NULL, 1, 5, 1, 1, '10010', 10, NULL, NULL, '¥¢¥¤¥¹,¥Ð¥Ë¥é,¥Á¥ç¥³,ËõÃã', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '½ë¤¤²Æ¤Ë¤É¤¦¤¾¡£', '08311201_44f65122ee5fe.jpg', 'Î䤿¤¤¤â¤Î¤Ï¤¤¤«¤¬¤Ç¤¹¤«¡©', '08311202_44f6515906a41.jpg', '08311203_44f651959bcb5.jpg', NULL, '<b>¤ª¤¤¤·¤¤¤è<b>', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, now(), now(), 2);
INSERT INTO dtb_products (name,deliv_fee,sale_limit,sale_unlimited,category_id,rank,status,product_flag,point_rate,comment1,comment2,comment3,comment4,comment5,comment6,file1,file2,file3,file4,file5,file6,main_list_comment,main_list_image,main_comment,main_image,main_large_image,sub_title1,sub_comment1,sub_image1,sub_large_image1,sub_title2,sub_comment2,sub_image2,sub_large_image2,sub_title3,sub_comment3,sub_image3,sub_large_image3,sub_title4,sub_comment4,sub_image4,sub_large_image4,sub_title5,sub_comment5,sub_image5,sub_large_image5,sub_title6,sub_comment6,sub_image6,sub_large_image6,del_flg,creator_id,create_date,update_date,deliv_date_id)
VALUES ('¤ª¤Ê¤Ù', NULL, 5, NULL, 4, 1, 1, '11001', 5, NULL, NULL, 'Æé,¤Ê¤Ù,¥Ê¥Ù', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '°ì¿ÍÍѤ«¤é¤¢¤ê¤Þ¤¹¡£', '08311311_44f661811fec0.jpg', '¤¿¤Þ¤Ë¤ÏÆé¤Ç¤â¤É¤¦¤Ç¤·¤ç¤¦¡£', '08311313_44f661dc649fb.jpg', '08311313_44f661e5698a6.jpg', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, now(), now(), 3);

INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
DELETE FROM dtb_products_class;
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date) 
VALUES (1, 3, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 3, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 2, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 2, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 2, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 1, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 1, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (1, 1, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
INSERT INTO dtb_products_class (product_id,classcategory_id1,classcategory_id2,product_code,stock,stock_unlimited,sale_limit,price01,price02,status,creator_id,create_date,update_date)
VALUES (2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), now());

INSERT INTO dtb_recommend_products (product_id,rank,comment,status,creator_id,create_date,update_date) VALUES (2, 4, '¤ª¸ýľ¤·¤Ë¡£', 0, 2, now(), now());

INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Ì£', NULL, 1, 2, now(), now(), 0, NULL);
INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Â礭¤µ', NULL, 2, 2, now(), now(), 0, NULL);

INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Ð¥Ë¥é', 1, NULL, 1, 2, now(), now(), 0);
INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Á¥ç¥³', 1, NULL, 2, 2, now(), now(), 0);
INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('ËõÃã', 1, NULL, 3, 2, now(), now(), 0);
INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('L', 2, NULL, 1, 2, now(), now(), 0);
INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('M', 2, NULL, 2, 2, now(), now(), 0);
INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('S', 2, NULL, 3, 2, now(), now(), 0);

INSERT INTO dtb_classcategory (classcategory_id, class_id, rank, creator_id, create_date, update_date) 
VALUES (0, 0, 0, 0, now(), now());
UPDATE dtb_classcategory SET classcategory_id = 0 WHERE class_id = 0;

INSERT INTO dtb_category (category_name,parent_category_id,level,rank,creator_id,create_date,update_date,del_flg) VALUES ('¿©ÉÊ', 0, 1, 4, 2, now(), now(), 0);
INSERT INTO dtb_category (category_name,parent_category_id,level,rank,creator_id,create_date,update_date,del_flg) VALUES ('»¨²ß', 0, 1, 5, 2, now(), now(), 0);
INSERT INTO dtb_category (category_name,parent_category_id,level,rank,creator_id,create_date,update_date,del_flg) VALUES ('¤ª²Û»Ò', 1, 2, 2, 2, now(), now(), 0);
INSERT INTO dtb_category (category_name,parent_category_id,level,rank,creator_id,create_date,update_date,del_flg) VALUES ('¤Ê¤Ù', 1, 2, 3, 2, now(), now(), 0);
INSERT INTO dtb_category (category_name,parent_category_id,level,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥¢¥¤¥¹', 3, 3, 1, 2, now(), now(), 0);

INSERT INTO dtb_category_count VALUES (4, 1, now());
INSERT INTO dtb_category_count VALUES (5, 1, now());

INSERT INTO dtb_category_total_count VALUES (3, 1, now());
INSERT INTO dtb_category_total_count VALUES (1, 2, now());
INSERT INTO dtb_category_total_count VALUES (2, NULL, now());
INSERT INTO dtb_category_total_count VALUES (5, 1, now());
INSERT INTO dtb_category_total_count VALUES (4, 1, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裱¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£
2. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À­¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£
3. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£',
12,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裲¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê
Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òÍ­¤·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£

2. ²ñ°÷¾ðÊó¤ÎÆþÎÏ
²ñ°÷ÅÐÏ¿¼ê³¤ÎºÝ¤Ë¤Ï¡¢ÆþÎϾå¤ÎÃí°Õ¤ò¤è¤¯Æɤߡ¢½êÄê¤ÎÆþÎÏ¥Õ¥©¡¼¥à¤ËɬÍ×»ö¹à¤òÀµ³Î¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£²ñ°÷¾ðÊó¤ÎÅÐÏ¿¤Ë¤ª¤¤¤Æ¡¢Æü쵭¹æ¡¦µì´Á»ú¡¦¥í¡¼¥Þ¿ô»ú¤Ê¤É¤Ï¤´»ÈÍѤˤʤì¤Þ¤»¤ó¡£¤³¤ì¤é¤Îʸ»ú¤¬ÅÐÏ¿¤µ¤ì¤¿¾ì¹ç¤ÏÅö¼Ò¤Ë¤ÆÊѹ¹Ãפ·¤Þ¤¹¡£

3. ¥Ñ¥¹¥ï¡¼¥É¤Î´ÉÍý
(1)¥Ñ¥¹¥ï¡¼¥É¤Ï²ñ°÷ËܿͤΤߤ¬ÍøÍѤǤ­¤ë¤â¤Î¤È¤·¡¢Âè»°¼Ô¤Ë¾ùÅÏ¡¦ÂßÍ¿¤Ç¤­¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
(2)¥Ñ¥¹¥ï¡¼¥É¤Ï¡¢Â¾¿Í¤ËÃΤé¤ì¤ë¤³¤È¤¬¤Ê¤¤¤è¤¦Äê´üŪ¤ËÊѹ¹¤¹¤ëÅù¡¢²ñ°÷Ëܿͤ¬ÀÕǤ¤ò¤â¤Ã¤Æ´ÉÍý¤·¤Æ¤¯¤À¤µ¤¤¡£
(3)¥Ñ¥¹¥ï¡¼¥É¤òÍѤ¤¤ÆÅö¼Ò¤ËÂФ·¤Æ¹Ô¤ï¤ì¤¿°Õ»×ɽ¼¨¤Ï¡¢²ñ°÷Ëܿͤΰջ×ɽ¼¨¤È¤ß¤Ê¤·¡¢¤½¤Î¤¿¤á¤ËÀ¸¤¸¤ë»ÙʧÅù¤Ï¤¹¤Ù¤Æ²ñ°÷¤ÎÀÕǤ¤È¤Ê¤ê¤Þ¤¹¡£',
11,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裳¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
2. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£',
10,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裴¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤­¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£',
9,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裵¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤­¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ­¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤­¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤­¤ë¤³¤È¤È¤·¤Þ¤¹¡£
2. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤­¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£
(1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È
(2)Åö¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¥¢¥¯¥»¥¹¤·¤Æ¾ðÊó¤ò²þ¤¶¤ó¤·¤¿¤ê¡¢Åö¥Û¡¼¥à¥Ú¡¼¥¸¤ËÍ­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¤òÁ÷¿®¤¹¤ë¤Ê¤É¤·¤Æ¡¢Åö¼Ò¤Î±Ä¶È¤ò˸³²¤¹¤ë¤³¤È
(3)Åö¼Ò¤¬°·¤¦¾¦ÉʤÎÃÎŪ½êÍ­¸¢¤ò¿¯³²¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È
(4)¤½¤Î¾¡¢¤³¤ÎÍøÍѵ¬Ìó¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È',
8,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裶¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
(1)Ë¡Îá¤Ë´ð¤Å¤­³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç
(2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç
2. ²ñ°÷¾ðÊó¤Ë¤Ä¤­¤Þ¤·¤Æ¤Ï¡¢Åö¼Ò¤Î¡Ö¸Ä¿Í¾ðÊóÊݸî¤Ø¤Î¼èÁȤߡפ˽¾¤¤¡¢Åö¼Ò¤¬´ÉÍý¤·¤Þ¤¹¡£Åö¼Ò¤Ï¡¢²ñ°÷¾ðÊó¤ò¡¢²ñ°÷¤Ø¤Î¥µ¡¼¥Ó¥¹Ä󶡡¢¥µ¡¼¥Ó¥¹ÆâÍƤθþ¾å¡¢¥µ¡¼¥Ó¥¹¤ÎÍøÍÑÂ¥¿Ê¡¢¤ª¤è¤Ó¥µ¡¼¥Ó¥¹¤Î·òÁ´¤«¤Ä±ß³ê¤Ê±¿±Ä¤Î³ÎÊݤò¿Þ¤ëÌÜŪ¤Î¤¿¤á¤Ë¡¢Åö¼Ò¤ª¤¤¤ÆÍøÍѤ¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
3. Åö¼Ò¤Ï¡¢²ñ°÷¤ËÂФ·¤Æ¡¢¥á¡¼¥ë¥Þ¥¬¥¸¥ó¤½¤Î¾¤ÎÊýË¡¤Ë¤è¤ë¾ðÊóÄ󶡡ʹ­¹ð¤ò´Þ¤ß¤Þ¤¹¡Ë¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£²ñ°÷¤¬¾ðÊóÄ󶡤ò´õ˾¤·¤Ê¤¤¾ì¹ç¤Ï¡¢Åö¼Ò½êÄê¤ÎÊýË¡¤Ë½¾¤¤¡¢¤½¤Î»Ý¤òÄÌÃΤ·¤Æ失¤ì¤Ð¡¢¾ðÊóÄ󶡤òÄä»ß¤·¤Þ¤¹¡£¤¿¤À¤·¡¢ËÜ¥µ¡¼¥Ó¥¹±¿±Ä¤ËɬÍפʾðÊóÄ󶡤ˤĤ­¤Þ¤·¤Æ¤Ï¡¢²ñ°÷¤Î´õ˾¤Ë¤è¤êÄä»ß¤ò¤¹¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£',
7,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裷¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£

1. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È
2. Åö¼Ò¡¢¤ª¤è¤Ó¤½¤Î¾¤ÎÂè»°¼Ô¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤ò»¤Í¤ë¤³¤È
3. Àľ¯Ç¯¤Î¿´¿È¤Ë°­±Æ¶Á¤òµÚ¤Ü¤¹¶²¤ì¤¬¤¢¤ë¹Ô°Ù¡¢¤½¤Î¾¸ø½øÎɯ¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
4. ¾¤ÎÍøÍѼԤ½¤Î¾¤ÎÂè»°¼Ô¤ËÌÂÏǤȤʤë¹Ô°Ù¤äÉÔ²÷´¶¤òÊú¤«¤»¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
5. µõµ¶¤Î¾ðÊó¤òÆþÎϤ¹¤ë¤³¤È
6. Í­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¡¢¥á¡¼¥ëÅù¤òÁ÷¿®¤Þ¤¿¤Ï½ñ¤­¹þ¤à¤³¤È
7. Åö¼Ò¤Î¥µ¡¼¥Ð¤½¤Î¾¤Î¥³¥ó¥Ô¥å¡¼¥¿¤ËÉÔÀµ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤³¤È
8. ¥Ñ¥¹¥ï¡¼¥É¤òÂè»°¼Ô¤ËÂßÍ¿¡¦¾ùÅϤ¹¤ë¤³¤È¡¢¤Þ¤¿¤ÏÂè»°¼Ô¤È¶¦ÍѤ¹¤ë¤³¤È
9. ¤½¤Î¾Åö¼Ò¤¬ÉÔŬÀÚ¤ÈȽÃǤ¹¤ë¤³¤È',
6,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裸¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£
(1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç
(2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç
(3)²ÐºÒ¡¢ÄäÅÅ¡¢Âè»°¼Ô¤Ë¤è¤ë˸³²¹Ô°Ù¤Ê¤É¤Ë¤è¤ê¥·¥¹¥Æ¥à¤Î±¿ÍѤ¬º¤Æñ¤Ë¤Ê¤Ã¤¿¾ì¹ç
(4)¤½¤Î¾¡¢»ß¤à¤òÆÀ¤º¥·¥¹¥Æ¥à¤ÎÄä»ß¤¬É¬ÍפÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç',
5,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Â裹¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£',
4,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Âè10¾ò¡ÊÌÈÀÕ¡Ë','1. ÄÌ¿®²óÀþ¤ä¥³¥ó¥Ô¥å¡¼¥¿¤Ê¤É¤Î¾ã³²¤Ë¤è¤ë¥·¥¹¥Æ¥à¤ÎÃæÃÇ¡¦ÃÙÂÚ¡¦Ãæ»ß¡¦¥Ç¡¼¥¿¤Î¾Ã¼º¡¢¥Ç¡¼¥¿¤Ø¤ÎÉÔÀµ¥¢¥¯¥»¥¹¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¡¢¤½¤Î¾Åö¼Ò¤Î¥µ¡¼¥Ó¥¹¤Ë´Ø¤·¤Æ²ñ°÷¤ËÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉé¤ï¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
2. Åö¼Ò¤Ï¡¢Åö¼Ò¤Î¥¦¥§¥Ö¥Ú¡¼¥¸¡¦¥µ¡¼¥Ð¡¦¥É¥á¥¤¥ó¤Ê¤É¤«¤éÁ÷¤é¤ì¤ë¥á¡¼¥ë¡¦¥³¥ó¥Æ¥ó¥Ä¤Ë¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¦¥¦¥£¥ë¥¹¤Ê¤É¤ÎÍ­³²¤Ê¤â¤Î¤¬´Þ¤Þ¤ì¤Æ¤¤¤Ê¤¤¤³¤È¤òÊݾڤ¤¤¿¤·¤Þ¤»¤ó¡£
3. ²ñ°÷¤¬Ëܵ¬ÌóÅù¤Ë°ãÈ¿¤·¤¿¤³¤È¤Ë¤è¤Ã¤ÆÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¤Ï¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£',
3,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Âè11¾ò¡ÊËܵ¬Ìó¤Î²þÄê¡Ë','Åö¼Ò¤Ï¡¢Ëܵ¬Ìó¤òǤ°Õ¤Ë²þÄê¤Ç¤­¤ë¤â¤Î¤È¤·¡¢¤Þ¤¿¡¢Åö¼Ò¤Ë¤ª¤¤¤ÆËܵ¬Ìó¤òÊä½¼¤¹¤ëµ¬Ìó¡Ê°Ê²¼¡ÖÊä½¼µ¬Ìó¡×¤È¤¤¤¤¤Þ¤¹¡Ë¤òÄê¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£Ëܵ¬Ìó¤Î²þÄê¤Þ¤¿¤ÏÊä½¼¤Ï¡¢²þÄê¸å¤ÎËܵ¬Ìó¤Þ¤¿¤ÏÊä½¼µ¬Ìó¤òÅö¼Ò½êÄê¤Î¥µ¥¤¥È¤Ë·Ç¼¨¤·¤¿¤È¤­¤Ë¤½¤Î¸úÎϤòÀ¸¤¸¤ë¤â¤Î¤È¤·¤Þ¤¹¡£¤³¤Î¾ì¹ç¡¢²ñ°÷¤Ï¡¢²þÄê¸å¤Îµ¬Ì󤪤è¤ÓÊä½¼µ¬Ìó¤Ë½¾¤¦¤â¤Î¤ÈÃפ·¤Þ¤¹¡£',
2,0,Now(),0, now());

INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 
VALUES ('Âè12¾ò¡Ê½àµòË¡¡¢´É³íºÛȽ½ê¡Ë','Ëܵ¬Ìó¤Ë´Ø¤·¤ÆʶÁ褬À¸¤¸¤¿¾ì¹ç¡¢Åö¼ÒËÜŹ½êºßÃϤò´É³í¤¹¤ëÃÏÊýºÛȽ½ê¤òÂè°ì¿³¤ÎÀì°Ū¹ç°Õ´É³íºÛȽ½ê¤È¤·¤Þ¤¹¡£ ',
1,0,Now(),0, now());