source: branches/beta/html/install/sql/insert_data.sql @ 15482

Revision 15482, 48.4 KB checked in by naka, 17 years ago (diff)

受注メールのバグ修正

Line 
1CREATE INDEX dtb_products_category_id_key ON dtb_products(category_id);
2CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id);
3CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id);
4CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id);
5
6INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, create_date, update_date)
7VALUES ('dummy','dummy',' ',0,0,1,1, now(), now());
8
9insert 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());
10insert 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());
11insert 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());
12insert 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());
13insert 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());
14insert 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());
15insert 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());
16
17insert 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());
18insert 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());
19insert 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());
20insert 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());
21
22insert into dtb_pagelayout (page_id,page_name,url, create_date, update_date)values(0, '¥×¥ì¥Ó¥å¡¼¥Ç¡¼¥¿',' ',now(),now());
23update dtb_pagelayout set page_id = 0 where page_id = 5;
24
25INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,1,2,'category');
26INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,2,3,'guide');
27INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,1,3,1,'cart');
28INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,4,2,'search_products');
29INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,5,1,'news');
30INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,3,6,1,'login');
31INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(1,4,7,2,'best5');
32INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,1,2,'category');
33INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,2,3,'guide');
34INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,1,3,1,'cart');
35INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,4,0,'search_products');
36INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,5,0,'news');
37INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,6,0,'login');
38INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(2,5,7,0,'best5');
39INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,1,2,'category');
40INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,2,3,'guide');
41INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,1,3,1,'cart');
42INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,4,0,'search_products');
43INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,5,0,'news');
44INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,6,0,'login');
45INSERT INTO dtb_blocposition (page_id,target_id,bloc_id,bloc_row,filename)values(3,5,7,0,'best5');
46
47insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_id','¾¦ÉÊID',1,now(),now());
48insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_class_id','µ¬³ÊID',2,now(),now());
49insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'classcategory_id1','µ¬³Ê̾1',3,now(),now());
50insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'classcategory_id2','µ¬³Ê̾2',4,now(),now());
51insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'name','¾¦ÉÊ̾',5,now(),now());
52insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'status','¸ø³«¥Õ¥é¥°',6,now(),now());
53insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_flag','¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹',7,now(),now());
54insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'product_code','¾¦ÉÊ¥³¡¼¥É',8,now(),now());
55insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price01','Ä̾ï²Á³Ê',9,now(),now());
56insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'price02','ÈÎÇä²Á³Ê',10,now(),now());
57insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'stock','ºß¸Ë¿ô',11,now(),now());
58insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'deliv_fee','Á÷ÎÁ',12,now(),now());
59insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'point_rate','¥Ý¥¤¥ó¥ÈÉÕͿΨ',13,now(),now());
60insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sale_limit','¹ØÆþÀ©¸Â',14,now(),now());
61insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'comment1','¥á¡¼¥«¡¼URL',15,now(),now());
62insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'comment3','¸¡º÷¥ï¡¼¥É',16,now(),now());
63insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_list_comment','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È',17,now(),now());
64insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_list_image','°ìÍ÷-¥á¥¤¥ó²èÁü',18,now(),now());
65insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_comment','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È',19,now(),now());
66insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_image','¾ÜºÙ-¥á¥¤¥ó²èÁü',20,now(),now());
67insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'main_large_image','¾ÜºÙ-¥á¥¤¥ó³ÈÂç²èÁü ',21,now(),now());
68insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'file1','¥«¥é¡¼Èæ³Ó²èÁü',22,now(),now());
69insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'file2','¾¦Éʾܺ٥ե¡¥¤¥ë    ',23,now(),now());
70insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title1','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê1¡Ë',24,now(),now());
71insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment1','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê1¡Ë',25,now(),now());
72insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image1','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê1¡Ë',26,now(),now());
73insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image1','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê1¡Ë',27,now(),now());
74insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title2','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê2¡Ë',28,now(),now());
75insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment2','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê2¡Ë',29,now(),now());
76insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image2','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê2¡Ë',30,now(),now());
77insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image2','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê2¡Ë',31,now(),now());
78insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title3','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê3¡Ë',32,now(),now());
79insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment3','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê3¡Ë',33,now(),now());
80insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image3','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê3¡Ë',34,now(),now());
81insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image3','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê3¡Ë',35,now(),now());
82insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title4','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê4¡Ë',36,now(),now());
83insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment4','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê4¡Ë',37,now(),now());
84insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image4','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê4¡Ë',38,now(),now());
85insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image4','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê4¡Ë',39,now(),now());
86insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_title5','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê5¡Ë',40,now(),now());
87insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_comment5','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê5¡Ë',41,now(),now());
88insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_image5','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê5¡Ë',42,now(),now());
89insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'sub_large_image5','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê5¡Ë',43,now(),now());
90insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'deliv_date_id','ȯÁ÷ÆüÌÜ°Â',44,now(),now());
91insert 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());
92insert 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());
93insert 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());
94insert 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());
95insert 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());
96insert 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());
97insert 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());
98insert 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());
99insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_product_id5','¤ª¤¹¤¹¤á¾¦ÉÊ(5)',53,now(),now());
100insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 4) AS recommend_comment5','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(5)',54,now(),now());
101insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT recommend_product_id FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_product_id6','¤ª¤¹¤¹¤á¾¦ÉÊ(6)',55,now(),now());
102insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'(SELECT comment FROM dtb_recommend_products WHERE prdcls.product_id = dtb_recommend_products.product_id ORDER BY update_date DESC limit 1 offset 5) AS recommend_comment6','¤ª¤¹¤¹¤á¥³¥á¥ó¥È(6)',56,now(),now());
103insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(1,'category_id','¥«¥Æ¥´¥êID',57,now(),now());
104insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'customer_id','¸ÜµÒID',1,now(),now());
105insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'name01','̾Á°1',2,now(),now());
106insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'name02','̾Á°2',3,now(),now());
107insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'kana01','¥Õ¥ê¥¬¥Ê1',4,now(),now());
108insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'kana02','¥Õ¥ê¥¬¥Ê2',5,now(),now());
109insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'zip01', '͹ÊØÈÖ¹æ1',6,now(),now());
110insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'zip02', '͹ÊØÈÖ¹æ2',7,now(),now());
111insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'pref', 'ÅÔÆ»Éܸ©',8,now(),now());
112insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'addr01', '½»½ê1',9,now(),now());
113insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'addr02', '½»½ê2',10,now(),now());
114insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'email', 'E-MAIL',11,now(),now());
115insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel01', 'TEL1',12,now(),now());
116insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel02', 'TEL2',13,now(),now());
117insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'tel03', 'TEL3',14,now(),now());
118insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax01', 'FAX1',15,now(),now());
119insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax02', 'FAX2',16,now(),now());
120insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'fax03', 'FAX3',17,now(),now());
121insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'sex', 'À­ÊÌ',18,now(),now());
122insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'job', '¿¦¶È',19,now(),now());
123insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'birth', 'ÃÂÀ¸Æü',20,now(),now());
124insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'first_buy_date', '½é²ó¹ØÆþÆü',21,now(),now());
125insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'last_buy_date', 'ºÇ½ª¹ØÆþÆü',22,now(),now());
126insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'buy_times', '¹ØÆþ²ó¿ô',23,now(),now());
127insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'point', '¥Ý¥¤¥ó¥È»Ä¹â',24,now(),now());
128insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'note', 'È÷¹Í',25,now(),now());
129insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'create_date','ÅÐÏ¿Æü',26,now(),now());
130insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(2,'update_date','¹¹¿·Æü',   27,now(),now());
131insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_id','ÃíʸID',1,now(),now());
132insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'customer_id','¸ÜµÒID',2,now(),now());
133insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'message','Í×˾Åù',3,now(),now());
134insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_name01','¸ÜµÒ̾1',4,now(),now());
135insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_name02','¸ÜµÒ̾2',5,now(),now());
136insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_kana01','¸ÜµÒ̾¥«¥Ê1',6,now(),now());
137insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_kana02','¸ÜµÒ̾¥«¥Ê2',7,now(),now());
138insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',8,now(),now());
139insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel01','ÅÅÏÃÈÖ¹æ1',9,now(),now());
140insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel02','ÅÅÏÃÈÖ¹æ2',10,now(),now());
141insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_tel03','ÅÅÏÃÈÖ¹æ3',11,now(),now());
142insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax01','FAX1',12,now(),now());
143insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax02','FAX2',13,now(),now());
144insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_fax03','FAX3',14,now(),now());
145insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_zip01','͹ÊØÈÖ¹æ1',15,now(),now());
146insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_zip02','͹ÊØÈÖ¹æ2',16,now(),now());
147insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_pref','ÅÔÆ»Éܸ©',17,now(),now());
148insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_addr01','½»½ê1',18,now(),now());
149insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_addr02','½»½ê2',19,now(),now());
150insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_sex','À­ÊÌ',20,now(),now());
151insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_birth','À¸Ç¯·îÆü',21,now(),now());
152insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'order_job','¿¦¼ï',22,now(),now());
153insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name01','ÇÛÁ÷Àè̾Á°',23,now(),now());
154insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_name02','ÇÛÁ÷Àè̾Á°',24,now(),now());
155insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana01','ÇÛÁ÷À襫¥Ê',25,now(),now());
156insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_kana02','ÇÛÁ÷À襫¥Ê',26,now(),now());
157insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',27,now(),now());
158insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',28,now(),now());
159insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',29,now(),now());
160insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax01','FAX1',30,now(),now());
161insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax02','FAX2',31,now(),now());
162insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fax03','FAX3',32,now(),now());
163insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_zip01','͹ÊØÈÖ¹æ1',33,now(),now());
164insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_zip02','͹ÊØÈÖ¹æ2',34,now(),now());
165insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_pref','ÅÔÆ»Éܸ©',35,now(),now());
166insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_addr01','½»½ê1',36,now(),now());
167insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_addr02','½»½ê2',37,now(),now());
168insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'subtotal','¾®·×',38,now(),now());
169insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'discount','ÃÍ°ú¤­',39,now(),now());
170insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_fee','Á÷ÎÁ',40,now(),now());
171insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'charge','¼ê¿ôÎÁ',41,now(),now());
172insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'use_point','»ÈÍѥݥ¤¥ó¥È',42,now(),now());
173insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'add_point','²Ã»»¥Ý¥¤¥ó¥È',43,now(),now());
174insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'tax','ÀǶâ',44,now(),now());
175insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'total','¹ç·×',45,now(),now());
176insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_total','¤ª»Ùʧ¤¤¹ç·×',46,now(),now());
177insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'payment_method','»Ùʧ¤¤ÊýË¡',47,now(),now());
178insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_time','ÇÛÁ÷»þ´Ö',48,now(),now());
179insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'deliv_no','ÇÛÁ÷ÅÁɼÈÖ¹æ',49,now(),now());
180insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'note','SHOP¥á¥â',50,now(),now());
181insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'status','Âбþ¾õ¶·',51,now(),now());
182insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'create_date','ÃíʸÆü»þ',52,now(),now());
183insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(3,'update_date','¹¹¿·Æü»þ',53,now(),now());
184insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_id','ÃíʸID',1,now(),now());
185insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'campaign_id','¥­¥ã¥ó¥Ú¡¼¥óID',2,now(),now());
186insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'customer_id','¸ÜµÒID',3,now(),now());
187insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'message','Í×˾Åù',4,now(),now());
188insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_name01','¸ÜµÒ̾1',5,now(),now());
189insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_name02','¸ÜµÒ̾2',6,now(),now());
190insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_kana01','¸ÜµÒ̾¥«¥Ê1',7,now(),now());
191insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_kana02','¸ÜµÒ̾¥«¥Ê2',8,now(),now());
192insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',9,now(),now());
193insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_tel01','ÅÅÏÃÈÖ¹æ1',10,now(),now());
194insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_tel02','ÅÅÏÃÈÖ¹æ2',11,now(),now());
195insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_tel03','ÅÅÏÃÈÖ¹æ3',12,now(),now());
196insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_fax01','FAX1',13,now(),now());
197insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_fax02','FAX2',14,now(),now());
198insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_fax03','FAX3',15,now(),now());
199insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_zip01','͹ÊØÈÖ¹æ1',16,now(),now());
200insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_zip02','͹ÊØÈÖ¹æ2',17,now(),now());
201insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_pref','ÅÔÆ»Éܸ©',18,now(),now());
202insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_addr01','½»½ê1',19,now(),now());
203insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_addr02','½»½ê2',20,now(),now());
204insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_sex','À­ÊÌ',21,now(),now());
205insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_birth','À¸Ç¯·îÆü',22,now(),now());
206insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'order_job','¿¦¼ï',23,now(),now());
207insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name01','ÇÛÁ÷Àè̾Á°',24,now(),now());
208insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_name02','ÇÛÁ÷Àè̾Á°',25,now(),now());
209insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana01','ÇÛÁ÷À襫¥Ê',26,now(),now());
210insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_kana02','ÇÛÁ÷À襫¥Ê',27,now(),now());
211insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',28,now(),now());
212insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',29,now(),now());
213insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',30,now(),now());
214insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_fax01','FAX1',31,now(),now());
215insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_fax02','FAX2',32,now(),now());
216insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_fax03','FAX3',33,now(),now());
217insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_zip01','͹ÊØÈÖ¹æ1',34,now(),now());
218insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_zip02','͹ÊØÈÖ¹æ2',35,now(),now());
219insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_pref','ÅÔÆ»Éܸ©',36,now(),now());
220insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_addr01','½»½ê1',37,now(),now());
221insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'deliv_addr02','½»½ê2',38,now(),now());
222insert into dtb_csv(csv_id,col,disp_name,rank,create_date,update_date)values(4,'payment_total','¤ª»Ùʧ¤¤¹ç·×',39,now(),now());
223
224INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES('default1','¥Ç¥Õ¥©¥ë¥È1', now(), now());
225
226insert into dtb_mailtemplate (template_id, subject, body, creator_id, update_date, create_date, send_type, template_name) values (
227'1',
228'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
229'{name}ÍÍ
230
231¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
232²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£
233
234{order}
235
236¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
237¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ø¤ÎÊÖ¿®¤È¤·¤Æ¤´¼ÁÌä¤ò¤ªÁ÷¤ê¤¤¤¿¤À¤¤¤Æ¤â²óÅú¤Ç¤­¤Þ¤»¤ó¡£
238¤´Î»¾µ¤¯¤À¤µ¤¤¡£
239
240¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£',
2410,
242Now(),
243Now(),
2440,
245'¼õÃí´°Î»¥Æ¥ó¥×¥ì¡¼¥È(PCÍÑ)');
246
247insert into dtb_mailtemplate (template_id, subject, body, creator_id, update_date, create_date, send_type, template_name) values (
248'2',
249'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
250'{name}ÍÍ
251
252¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
253²¼µ­¤´ÃíʸÆâÍƤˤª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£
254
255{order}
256
257¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
258¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ø¤ÎÊÖ¿®¤È¤·¤Æ¤´¼ÁÌä¤ò¤ªÁ÷¤ê¤¤¤¿¤À¤¤¤Æ¤â²óÅú¤Ç¤­¤Þ¤»¤ó¡£
259¤´Î»¾µ¤¯¤À¤µ¤¤¡£
260
261¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£',
2620,
263Now(),
264Now(),
2651,
266'¼õÃí´°Î»¥Æ¥ó¥×¥ì¡¼¥È(·ÈÂÓÍÑ)');
267
268insert into dtb_news (news_date,rank, news_title, news_comment, creator_id, create_date, update_date)
269values(now(),1,'¥µ¥¤¥È¥ª¡¼¥×¥ó¤¤¤¿¤·¤Þ¤·¤¿!','°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆϤ±¤·¤Þ¤¹¡ª',1, now(), now());
270
271INSERT INTO dtb_deliv (name,service_name,confirm_url,rank,status,del_flg,creator_id,create_date,update_date)
272VALUES ('¥µ¥ó¥×¥ë¶È¼Ô', '¥µ¥ó¥×¥ë¶È¼Ô', '', 1, 1, 0, 2, now(), now());
273
274INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 1);
275INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 2);
276INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 3);
277INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 4);
278INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 5);
279INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 6);
280INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 7);
281INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 8);
282INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 9);
283INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 10);
284INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 11);
285INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 12);
286INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 13);
287INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 14);
288INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 15);
289INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 16);
290INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 17);
291INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 18);
292INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 19);
293INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 20);
294INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 21);
295INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 22);
296INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 23);
297INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 24);
298INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 25);
299INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 26);
300INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 27);
301INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 28);
302INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 29);
303INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 30);
304INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 31);
305INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 32);
306INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 33);
307INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 34);
308INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 35);
309INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 36);
310INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 37);
311INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 38);
312INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 39);
313INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 40);
314INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 41);
315INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 42);
316INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 43);
317INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 44);
318INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 45);
319INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 46);
320INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 47);
321
322INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸áÁ°');
323INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸á¸å');
324
325INSERT 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);
326INSERT 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);
327INSERT 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);
328INSERT 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);
329
330INSERT 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)
331VALUES ('¥¢¥¤¥¹¥¯¥ê¡¼¥à', 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);
332INSERT 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)
333VALUES ('¤ª¤Ê¤Ù', 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);
334
335INSERT 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)
336VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
337DELETE FROM dtb_products_class;
338INSERT 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)
339VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
340INSERT 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)
341VALUES (1, 3, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
342INSERT 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)
343VALUES (1, 3, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
344INSERT 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)
345VALUES (1, 2, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
346INSERT 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)
347VALUES (1, 2, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
348INSERT 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)
349VALUES (1, 2, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
350INSERT 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)
351VALUES (1, 1, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
352INSERT 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)
353VALUES (1, 1, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
354INSERT 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)
355VALUES (1, 1, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), now());
356INSERT 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)
357VALUES (2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), now());
358
359INSERT INTO dtb_recommend_products (product_id,rank,comment,status,creator_id,create_date,update_date) VALUES (2, 4, '¤ª¸ýľ¤·¤Ë¡£', 0, 2, now(), now());
360
361INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Ì£', NULL, 1, 2, now(), now(), 0, NULL);
362INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Â礭¤µ', NULL, 2, 2, now(), now(), 0, NULL);
363
364INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Ð¥Ë¥é', 1, NULL, 1, 2, now(), now(), 0);
365INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Á¥ç¥³', 1, NULL, 2, 2, now(), now(), 0);
366INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('ËõÃã', 1, NULL, 3, 2, now(), now(), 0);
367INSERT 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);
368INSERT 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);
369INSERT 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);
370
371INSERT INTO dtb_classcategory (classcategory_id, class_id, rank, creator_id, create_date, update_date)
372VALUES (0, 0, 0, 0, now(), now());
373UPDATE dtb_classcategory SET classcategory_id = 0 WHERE class_id = 0;
374
375INSERT 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);
376INSERT 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);
377INSERT 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);
378INSERT 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);
379INSERT 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);
380
381INSERT INTO dtb_category_count VALUES (4, 1, now());
382INSERT INTO dtb_category_count VALUES (5, 1, now());
383
384INSERT INTO dtb_category_total_count VALUES (3, 1, now());
385INSERT INTO dtb_category_total_count VALUES (1, 2, now());
386INSERT INTO dtb_category_total_count VALUES (2, NULL, now());
387INSERT INTO dtb_category_total_count VALUES (5, 1, now());
388INSERT INTO dtb_category_total_count VALUES (4, 1, now());
389
390INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
391VALUES ('Âè1¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£
3922. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À­¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£
3933. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£',
39412,0,Now(),0, now());
395
396INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
397VALUES ('Âè2¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê
398Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òÍ­¤·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£
399
4002. ²ñ°÷¾ðÊó¤ÎÆþÎÏ
401²ñ°÷ÅÐÏ¿¼ê³¤ÎºÝ¤Ë¤Ï¡¢ÆþÎϾå¤ÎÃí°Õ¤ò¤è¤¯Æɤߡ¢½êÄê¤ÎÆþÎÏ¥Õ¥©¡¼¥à¤ËɬÍ×»ö¹à¤òÀµ³Î¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£²ñ°÷¾ðÊó¤ÎÅÐÏ¿¤Ë¤ª¤¤¤Æ¡¢Æü쵭¹æ¡¦µì´Á»ú¡¦¥í¡¼¥Þ¿ô»ú¤Ê¤É¤Ï¤´»ÈÍѤˤʤì¤Þ¤»¤ó¡£¤³¤ì¤é¤Îʸ»ú¤¬ÅÐÏ¿¤µ¤ì¤¿¾ì¹ç¤ÏÅö¼Ò¤Ë¤ÆÊѹ¹Ãפ·¤Þ¤¹¡£
402
4033. ¥Ñ¥¹¥ï¡¼¥É¤Î´ÉÍý
404(1)¥Ñ¥¹¥ï¡¼¥É¤Ï²ñ°÷ËܿͤΤߤ¬ÍøÍѤǤ­¤ë¤â¤Î¤È¤·¡¢Âè»°¼Ô¤Ë¾ùÅÏ¡¦ÂßÍ¿¤Ç¤­¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
405(2)¥Ñ¥¹¥ï¡¼¥É¤Ï¡¢Â¾¿Í¤ËÃΤé¤ì¤ë¤³¤È¤¬¤Ê¤¤¤è¤¦Äê´üŪ¤ËÊѹ¹¤¹¤ëÅù¡¢²ñ°÷Ëܿͤ¬ÀÕǤ¤ò¤â¤Ã¤Æ´ÉÍý¤·¤Æ¤¯¤À¤µ¤¤¡£
406(3)¥Ñ¥¹¥ï¡¼¥É¤òÍѤ¤¤ÆÅö¼Ò¤ËÂФ·¤Æ¹Ô¤ï¤ì¤¿°Õ»×ɽ¼¨¤Ï¡¢²ñ°÷Ëܿͤΰջ×ɽ¼¨¤È¤ß¤Ê¤·¡¢¤½¤Î¤¿¤á¤ËÀ¸¤¸¤ë»ÙʧÅù¤Ï¤¹¤Ù¤Æ²ñ°÷¤ÎÀÕǤ¤È¤Ê¤ê¤Þ¤¹¡£',
40711,0,Now(),0, now());
408
409INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
410VALUES ('Âè3¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
4112. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£',
41210,0,Now(),0, now());
413
414INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
415VALUES ('Âè4¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤­¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£',
4169,0,Now(),0, now());
417
418INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
419VALUES ('Âè5¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤­¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ­¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤­¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤­¤ë¤³¤È¤È¤·¤Þ¤¹¡£
4202. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤­¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£
421(1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È
422(2)Åö¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¥¢¥¯¥»¥¹¤·¤Æ¾ðÊó¤ò²þ¤¶¤ó¤·¤¿¤ê¡¢Åö¥Û¡¼¥à¥Ú¡¼¥¸¤ËÍ­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¤òÁ÷¿®¤¹¤ë¤Ê¤É¤·¤Æ¡¢Åö¼Ò¤Î±Ä¶È¤ò˸³²¤¹¤ë¤³¤È
423(3)Åö¼Ò¤¬°·¤¦¾¦ÉʤÎÃÎŪ½êÍ­¸¢¤ò¿¯³²¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È
424(4)¤½¤Î¾¡¢¤³¤ÎÍøÍѵ¬Ìó¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È',
4258,0,Now(),0, now());
426
427INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
428VALUES ('Âè6¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
429(1)Ë¡Îá¤Ë´ð¤Å¤­³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç
430(2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç
4312. ²ñ°÷¾ðÊó¤Ë¤Ä¤­¤Þ¤·¤Æ¤Ï¡¢Åö¼Ò¤Î¡Ö¸Ä¿Í¾ðÊóÊݸî¤Ø¤Î¼èÁȤߡפ˽¾¤¤¡¢Åö¼Ò¤¬´ÉÍý¤·¤Þ¤¹¡£Åö¼Ò¤Ï¡¢²ñ°÷¾ðÊó¤ò¡¢²ñ°÷¤Ø¤Î¥µ¡¼¥Ó¥¹Ä󶡡¢¥µ¡¼¥Ó¥¹ÆâÍƤθþ¾å¡¢¥µ¡¼¥Ó¥¹¤ÎÍøÍÑÂ¥¿Ê¡¢¤ª¤è¤Ó¥µ¡¼¥Ó¥¹¤Î·òÁ´¤«¤Ä±ß³ê¤Ê±¿±Ä¤Î³ÎÊݤò¿Þ¤ëÌÜŪ¤Î¤¿¤á¤Ë¡¢Åö¼Ò¤ª¤¤¤ÆÍøÍѤ¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
4323. Åö¼Ò¤Ï¡¢²ñ°÷¤ËÂФ·¤Æ¡¢¥á¡¼¥ë¥Þ¥¬¥¸¥ó¤½¤Î¾¤ÎÊýË¡¤Ë¤è¤ë¾ðÊóÄ󶡡ʹ­¹ð¤ò´Þ¤ß¤Þ¤¹¡Ë¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£²ñ°÷¤¬¾ðÊóÄ󶡤ò´õ˾¤·¤Ê¤¤¾ì¹ç¤Ï¡¢Åö¼Ò½êÄê¤ÎÊýË¡¤Ë½¾¤¤¡¢¤½¤Î»Ý¤òÄÌÃΤ·¤Æ失¤ì¤Ð¡¢¾ðÊóÄ󶡤òÄä»ß¤·¤Þ¤¹¡£¤¿¤À¤·¡¢ËÜ¥µ¡¼¥Ó¥¹±¿±Ä¤ËɬÍפʾðÊóÄ󶡤ˤĤ­¤Þ¤·¤Æ¤Ï¡¢²ñ°÷¤Î´õ˾¤Ë¤è¤êÄä»ß¤ò¤¹¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£',
4337,0,Now(),0, now());
434
435INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
436VALUES ('Âè7¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£
437
4381. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È
4392. Åö¼Ò¡¢¤ª¤è¤Ó¤½¤Î¾¤ÎÂè»°¼Ô¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤ò»¤Í¤ë¤³¤È
4403. Àľ¯Ç¯¤Î¿´¿È¤Ë°­±Æ¶Á¤òµÚ¤Ü¤¹¶²¤ì¤¬¤¢¤ë¹Ô°Ù¡¢¤½¤Î¾¸ø½øÎɯ¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
4414. ¾¤ÎÍøÍѼԤ½¤Î¾¤ÎÂè»°¼Ô¤ËÌÂÏǤȤʤë¹Ô°Ù¤äÉÔ²÷´¶¤òÊú¤«¤»¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
4425. µõµ¶¤Î¾ðÊó¤òÆþÎϤ¹¤ë¤³¤È
4436. Í­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¡¢¥á¡¼¥ëÅù¤òÁ÷¿®¤Þ¤¿¤Ï½ñ¤­¹þ¤à¤³¤È
4447. Åö¼Ò¤Î¥µ¡¼¥Ð¤½¤Î¾¤Î¥³¥ó¥Ô¥å¡¼¥¿¤ËÉÔÀµ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤³¤È
4458. ¥Ñ¥¹¥ï¡¼¥É¤òÂè»°¼Ô¤ËÂßÍ¿¡¦¾ùÅϤ¹¤ë¤³¤È¡¢¤Þ¤¿¤ÏÂè»°¼Ô¤È¶¦ÍѤ¹¤ë¤³¤È
4469. ¤½¤Î¾Åö¼Ò¤¬ÉÔŬÀÚ¤ÈȽÃǤ¹¤ë¤³¤È',
4476,0,Now(),0, now());
448
449INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
450VALUES ('Âè8¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£
451(1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç
452(2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç
453(3)²ÐºÒ¡¢ÄäÅÅ¡¢Âè»°¼Ô¤Ë¤è¤ë˸³²¹Ô°Ù¤Ê¤É¤Ë¤è¤ê¥·¥¹¥Æ¥à¤Î±¿ÍѤ¬º¤Æñ¤Ë¤Ê¤Ã¤¿¾ì¹ç
454(4)¤½¤Î¾¡¢»ß¤à¤òÆÀ¤º¥·¥¹¥Æ¥à¤ÎÄä»ß¤¬É¬ÍפÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç',
4555,0,Now(),0, now());
456
457INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
458VALUES ('Âè9¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£',
4594,0,Now(),0, now());
460
461INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
462VALUES ('Âè10¾ò¡ÊÌÈÀÕ¡Ë','1. ÄÌ¿®²óÀþ¤ä¥³¥ó¥Ô¥å¡¼¥¿¤Ê¤É¤Î¾ã³²¤Ë¤è¤ë¥·¥¹¥Æ¥à¤ÎÃæÃÇ¡¦ÃÙÂÚ¡¦Ãæ»ß¡¦¥Ç¡¼¥¿¤Î¾Ã¼º¡¢¥Ç¡¼¥¿¤Ø¤ÎÉÔÀµ¥¢¥¯¥»¥¹¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¡¢¤½¤Î¾Åö¼Ò¤Î¥µ¡¼¥Ó¥¹¤Ë´Ø¤·¤Æ²ñ°÷¤ËÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉé¤ï¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
4632. Åö¼Ò¤Ï¡¢Åö¼Ò¤Î¥¦¥§¥Ö¥Ú¡¼¥¸¡¦¥µ¡¼¥Ð¡¦¥É¥á¥¤¥ó¤Ê¤É¤«¤éÁ÷¤é¤ì¤ë¥á¡¼¥ë¡¦¥³¥ó¥Æ¥ó¥Ä¤Ë¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¦¥¦¥£¥ë¥¹¤Ê¤É¤ÎÍ­³²¤Ê¤â¤Î¤¬´Þ¤Þ¤ì¤Æ¤¤¤Ê¤¤¤³¤È¤òÊݾڤ¤¤¿¤·¤Þ¤»¤ó¡£
4643. ²ñ°÷¤¬Ëܵ¬ÌóÅù¤Ë°ãÈ¿¤·¤¿¤³¤È¤Ë¤è¤Ã¤ÆÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¤Ï¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£',
4653,0,Now(),0, now());
466
467INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
468VALUES ('Âè11¾ò¡ÊËܵ¬Ìó¤Î²þÄê¡Ë','Åö¼Ò¤Ï¡¢Ëܵ¬Ìó¤òǤ°Õ¤Ë²þÄê¤Ç¤­¤ë¤â¤Î¤È¤·¡¢¤Þ¤¿¡¢Åö¼Ò¤Ë¤ª¤¤¤ÆËܵ¬Ìó¤òÊä½¼¤¹¤ëµ¬Ìó¡Ê°Ê²¼¡ÖÊä½¼µ¬Ìó¡×¤È¤¤¤¤¤Þ¤¹¡Ë¤òÄê¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£Ëܵ¬Ìó¤Î²þÄê¤Þ¤¿¤ÏÊä½¼¤Ï¡¢²þÄê¸å¤ÎËܵ¬Ìó¤Þ¤¿¤ÏÊä½¼µ¬Ìó¤òÅö¼Ò½êÄê¤Î¥µ¥¤¥È¤Ë·Ç¼¨¤·¤¿¤È¤­¤Ë¤½¤Î¸úÎϤòÀ¸¤¸¤ë¤â¤Î¤È¤·¤Þ¤¹¡£¤³¤Î¾ì¹ç¡¢²ñ°÷¤Ï¡¢²þÄê¸å¤Îµ¬Ì󤪤è¤ÓÊä½¼µ¬Ìó¤Ë½¾¤¦¤â¤Î¤ÈÃפ·¤Þ¤¹¡£',
4692,0,Now(),0, now());
470
471INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date)
472VALUES ('Âè12¾ò¡Ê½àµòË¡¡¢´É³íºÛȽ½ê¡Ë','Ëܵ¬Ìó¤Ë´Ø¤·¤ÆʶÁ褬À¸¤¸¤¿¾ì¹ç¡¢Åö¼ÒËÜŹ½êºßÃϤò´É³í¤¹¤ëÃÏÊýºÛȽ½ê¤òÂè°ì¿³¤ÎÀì°Ū¹ç°Õ´É³íºÛȽ½ê¤È¤·¤Þ¤¹¡£ ',
4731,0,Now(),0, now());
Note: See TracBrowser for help on using the repository browser.