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

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

-- ¥Ú¡¼¥¸¥Ç¡¼¥¿
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_mailtemplate (template_id, subject, header, footer, creator_id, update_date) values (
1,
'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
'¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£

',
'

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

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

',0,Now());

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

-- ÇÛÁ÷¥Ç¡¼¥¿
INSERT INTO dtb_deliv VALUES (1, '¥À¥ß¡¼ÇÛÁ÷¶È¼Ô', '¥À¥ß¡¼ÇÛÁ÷¶È¼Ô', '', 1, 1, 0, 2, now(), now());

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

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

-- »ÙʧÊýË¡¥Ç¡¼¥¿
INSERT INTO dtb_payment VALUES (4, '͹ÊØ¿¶ÂØ', 0, NULL, 1, 4, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment VALUES (3, '¸½¶â½ñα', 0, NULL, 1, 3, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment VALUES (2, '¶ä¹Ô¿¶¹þ', 0, NULL, 1, 2, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);
INSERT INTO dtb_payment VALUES (1, 'Âå¶â°ú´¹', 0, NULL, 1, 1, NULL, 2, 1, 0, 1, now(), now(), NULL, NULL);

-- ¾¦Éʥǡ¼¥¿
INSERT INTO dtb_products VALUES (1, '¥¢¥¤¥¹¥¯¥ê¡¼¥à', 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 VALUES (2, '¤ª¤Ê¤Ù', 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 VALUES (3, 1, 3, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (4, 1, 3, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (5, 1, 2, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (6, 1, 2, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (7, 1, 2, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (8, 1, 1, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (9, 1, 1, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (10, 1, 1, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (2, 1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
INSERT INTO dtb_products_class VALUES (11, 2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), NULL);

INSERT INTO dtb_recommend_products VALUES (2, 1, 4, '¤ª¸ýľ¤·¤Ë¡£', 0, 2, now(), now());

--µ¬³Ê
INSERT INTO dtb_class VALUES (2, 'Â礭¤µ', NULL, 2, 2, now(), NULL, 0, NULL);
INSERT INTO dtb_class VALUES (1, 'Ì£', NULL, 1, 2, now(), now(), 0, NULL);

INSERT INTO dtb_classcategory VALUES (0, NULL, 0, NULL, 0, 0, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (1, '¥Ð¥Ë¥é', 1, NULL, 1, 2, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (2, '¥Á¥ç¥³', 1, NULL, 2, 2, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (3, 'ËõÃã?', 1, NULL, 3, 2, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (4, 'L', 2, NULL, 1, 2, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (5, 'M', 2, NULL, 2, 2, now(), NULL, 0);
INSERT INTO dtb_classcategory VALUES (6, 'S', 2, NULL, 3, 2, now(), NULL, 0);

-- ¥«¥Æ¥´¥ê¡¼
INSERT INTO dtb_category VALUES (3, '¤ª²Û»Ò', 1, 2, 2, 2, now(), now(), 0);
INSERT INTO dtb_category VALUES (1, '(¥À¥ß¡¼)¿©ÉÊ', 0, 1, 4, 2, now(), now(), 0);
INSERT INTO dtb_category VALUES (2, '(¥À¥ß¡¼)»¨²ß', 0, 1, 5, 2, now(), now(), 0);
INSERT INTO dtb_category VALUES (5, '¥¢¥¤¥¹', 3, 3, 1, 2, now(), now(), 0);
INSERT INTO dtb_category VALUES (4, '¤Ê¤Ù', 1, 2, 3, 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_best_products VALUES (1, 0, 1, 1, '', 'ÅöŹ1Èֿ͵¤¤Ç¤¹¡£', 2, now(), now(), 0);
INSERT INTO dtb_best_products VALUES (2, 0, 2, 2, '', '¤³¤Á¤é¤â¤ª¤¹¤¹¤á', 2, now(), now(), 0);

-- ¥Æ¥ó¥×¥ì¡¼¥È
INSERT INTO dtb_templates VALUES('default1','¥Ç¥Õ¥©¥ë¥È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);