source: temp/trunk/html/install/insert_data.sql @ 2840

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);

INSERT INTO dtb_classcategory (classcategory_id, class_id, rank, creator_id, create_date) 
VALUES (0, 0, 0, 0, now());

INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, delete) 
VALUES ('dummy','dummy','',0,0,1,1);

INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, delete) 
VALUES ('admin','admin','$1$JPUS3lIX$B0FJNs4Q0lv9i.UYBP7do0',0,0,1,0);

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

-- ¥Ú¡¼¥¸¥Ç¡¼¥¿
insert into dtb_pagelayout (page_id,page_name,url)values(0, '¥×¥ì¥Ó¥å¡¼¥Ç¡¼¥¿','');
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg)values('TOP¥Ú¡¼¥¸','index.php',' ','/html/user_data/templates/','top',2);
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg)values('¾¦ÉÊ°ìÍ÷¥Ú¡¼¥¸','products/list.php',' ','/html/user_data/templates/','list',2);
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg)values('¾¦ÉʾܺÙ','products/detail.php',' ','/html/user_data/templates/','detail',2);
insert into dtb_pagelayout (page_name,url,php_dir,tpl_dir,filename,edit_flg)values('MY¥Ú¡¼¥¸','mypage/index.php',' ','','',2);

-- ¥Ö¥í¥Ã¥¯ÇÛÃ֥ǡ¼¥¿
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');

-- CSV¥Ç¡¼¥¿
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_id','¾¦ÉÊID',1);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_class_id','µ¬³ÊID',2);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'classcategory_id1','µ¬³Ê̾1',3);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'classcategory_id2','µ¬³Ê̾2',4);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'name','¾¦ÉÊ̾',5);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'status','¸ø³«¥Õ¥é¥°',6);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_flag','¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹',7);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_code','¾¦ÉÊ¥³¡¼¥É',8);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'price01','»²¹Í»Ô¾ì²Á³Ê',9);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'price02','²Á³Ê',10);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'stock','ºß¸Ë¿ô',11);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'deliv_fee','Á÷ÎÁ',12);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'point_rate','¥Ý¥¤¥ó¥ÈÉÕͿΨ',13);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sale_limit','¹ØÆþÀ©¸Â',14);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'comment1','¥á¡¼¥«¡¼URL',15);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'comment3','¸¡º÷¥ï¡¼¥É',16);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_list_comment','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È',17);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_list_image','°ìÍ÷-¥á¥¤¥ó²èÁü',18);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_comment','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È',19);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_image','¾ÜºÙ-¥á¥¤¥ó²èÁü',20);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_large_image','¾ÜºÙ-¥á¥¤¥ó³ÈÂç²èÁü ',21);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'file1','¥«¥é¡¼Èæ³Ó²èÁü',22);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'file2','¾¦Éʾܺ٥ե¡¥¤¥ë    ',23);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title1','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê1¡Ë',24);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment1','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê1¡Ë',25);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image1','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê1¡Ë',26);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image1','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê1¡Ë',27);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title2','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê2¡Ë',28);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment2','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê2¡Ë',29);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image2','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê2¡Ë',30);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image2','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê2¡Ë',31);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title3','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê3¡Ë',32);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment3','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê3¡Ë',33);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image3','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê3¡Ë',34);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image3','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê3¡Ë',35);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title4','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê4¡Ë',36);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment4','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê4¡Ë',37);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image4','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê4¡Ë',38);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image4','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê4¡Ë',39);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title5','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê5¡Ë',40);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment5','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê5¡Ë',41);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image5','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê5¡Ë',42);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image5','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê5¡Ë',43);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'deliv_date_id','ȯÁ÷ÆüÌÜ°Â',44);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_product_id1','¤ª¤¹¤¹¤á¾¦ÉÊ(1)',45);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT comment FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1) AS recommend_comment1','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(1)',46);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_product_id2','¤ª¤¹¤¹¤á¾¦ÉÊ(2)',47);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT comment FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 1) AS recommend_comment2','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(2)',48);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_product_id3','¤ª¤¹¤¹¤á¾¦ÉÊ(3)',49);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT comment FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 2) AS recommend_comment3','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(3)',50);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_product_id4','¤ª¤¹¤¹¤á¾¦ÉÊ(4)',51);
insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'(SELECT comment FROM dtb_recommend_products WHERE vw_product_class.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 3) AS recommend_comment4','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(4)',52);

insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'customer_id','¸ÜµÒID',1);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'name01','̾Á°1',2);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'name02','̾Á°2',3);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'kana01','¥Õ¥ê¥¬¥Ê1',4);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'kana02','¥Õ¥ê¥¬¥Ê2',5);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'zip01', '͹ÊØÈÖ¹æ1',6);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'zip02', '͹ÊØÈÖ¹æ2',7);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'pref', 'ÅÔÆ»Éܸ©',8);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'addr01', '½»½ê1',9);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'addr02', '½»½ê2',10);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'email', 'E-MAIL',11);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel01', 'TEL1',12);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel02', 'TEL2',13);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel03', 'TEL3',14);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax01', 'FAX1',15);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax02', 'FAX2',16);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax03', 'FAX3',17);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'sex', 'À­ÊÌ',18);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'job', '¿¦¶È',19);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'birth', 'ÃÂÀ¸Æü',20);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'first_buy_date', '½é²ó¹ØÆþÆü',21);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'last_buy_date', 'ºÇ½ª¹ØÆþÆü',22);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'buy_times', '¹ØÆþ²ó¿ô',23);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'point', '¥Ý¥¤¥ó¥È»Ä¹â',24);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'note', 'È÷¹Í',25);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'create_date','ÅÐÏ¿Æü',26);
insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'update_date','¹¹¿·Æü',   27);

insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_id','ÃíʸID',1);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'customer_id','¸ÜµÒID',2);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'message','Í×˾Åù',3);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_name01','¸ÜµÒ̾1',4);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_name02','¸ÜµÒ̾2',5);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_kana01','¸ÜµÒ̾¥«¥Ê1',6);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_kana02','¸ÜµÒ̾¥«¥Ê2',7);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',8);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel01','ÅÅÏÃÈÖ¹æ1',9);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel02','ÅÅÏÃÈÖ¹æ2',10);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel03','ÅÅÏÃÈÖ¹æ3',11);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax01','FAX1',12);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax02','FAX2',13);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax03','FAX3',14);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_zip01','͹ÊØÈÖ¹æ1',15);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_zip02','͹ÊØÈÖ¹æ2',16);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_pref','ÅÔÆ»Éܸ©',17);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_addr01','½»½ê1',18);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_addr02','½»½ê2',19);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_sex','À­ÊÌ',20);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_birth','À¸Ç¯·îÆü',21);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_job','¿¦¼ï',22);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_name01','ÇÛÁ÷Àè̾Á°',23);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_name02','ÇÛÁ÷Àè̾Á°',24);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_kana01','ÇÛÁ÷À襫¥Ê',25);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_kana02','ÇÛÁ÷À襫¥Ê',26);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',27);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',28);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',29);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax01','FAX1',30);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax02','FAX2',31);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax03','FAX3',32);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_zip01','͹ÊØÈÖ¹æ1',33);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_zip02','͹ÊØÈÖ¹æ2',34);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_pref','ÅÔÆ»Éܸ©',35);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_addr01','½»½ê1',36);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_addr02','½»½ê2',37);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'subtotal','¾®·×',38);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'discount','ÃÍ°ú¤­',39);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fee','Á÷ÎÁ',40);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'charge','¼ê¿ôÎÁ',41);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'use_point','»ÈÍѥݥ¤¥ó¥È',42);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'add_point','²Ã»»¥Ý¥¤¥ó¥È',43);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'tax','ÀǶâ',44);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'total','¹ç·×',45);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'payment_total','¤ª»Ùʧ¤¤¹ç·×',46);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'payment_method','»Ùʧ¤¤ÊýË¡',47);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_time','ÇÛÁ÷»þ´Ö',48);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_no','ÇÛÁ÷ÅÁɼÈÖ¹æ',49);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'note','SHOP¥á¥â',50);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'status','Âбþ¾õ¶·',51);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'create_date','ÃíʸÆü»þ',52);
insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'update_date','¹¹¿·Æü»þ',53);

-- »ÙʧÊýË¡¥Ç¡¼¥¿
insert into dtb_payment(payment_method,rank,fix,creator_id)values('Âå¶â°ú´¹',1,2,1);
insert into dtb_payment(payment_method,rank,fix,creator_id)values('¶ä¹Ô¿¶¹þ',2,2,1);
insert into dtb_payment(payment_method,rank,fix,creator_id)values('¸½¶â½ñα',3,2,1);
insert into dtb_payment(payment_method,rank,fix,creator_id)values('͹ÊØ¿¶ÂØ',4,2,1);

-- Ãíʸ´°Î»¥á¡¼¥ë
update dtb_mailtemplate set 
subject = '¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
header = 
'¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£

',
footer = 
'

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

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

'
where template_id = 1;

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

-- ¾¦Éʥǡ¼¥¿
insert into dtb_products (name,sale_unlimited,category_id,rank,status,product_flag,point_rate,main_list_comment,main_list_image,main_comment,main_image,main_large_image, creator_id)
values('ϲۻÒ3ÅÀ¥»¥Ã¥È(¾®½Õ)','1','1','1','1','0','100','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£','08281319_44f26ebbf2435.jpg','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£','08281319_44f26ec47f8c7.jpg','08281319_44f26eca33e2f.jpg', 1);
insert into dtb_products (name,sale_unlimited,category_id,rank,status,product_flag,point_rate,main_list_comment,main_list_image,main_comment,main_image,main_large_image, creator_id)
values('ϲۻÒ3ÅÀ¥»¥Ã¥È(²ÖÎñ)','1','1','1','1','10','100','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£','08281159_44f25c1bb46e4.jpg','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È¥À¥ß¡¼¥Æ¥­¥¹¥È¤Ç¤¹¡£','08281200_44f25c4be7e1a.jpg','08281201_44f25c6daaf90.jpg', 1);

-- ¾¦ÉÊ¥¯¥é¥¹¥Ç¡¼¥¿
insert into dtb_products_class(product_id,classcategory_id1,classcategory_id2,product_code,stock_unlimited,price02,creator_id)
values('1','0','0','a-001','1','1500','1');
insert into dtb_products_class(product_id,classcategory_id1,classcategory_id2,product_code,stock_unlimited,price02,creator_id)
values('2','0','0','a-002','1','1500','1');

-- ¥ª¥¹¥¹¥á¾¦ÉÊ
insert into dtb_best_products (rank,product_id, comment, category_id, creator_id)
values(1,1,'¥À¥ß¡¼¥ª¥¹¥¹¥á¥³¥á¥ó¥È¡ª',1,1);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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