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

Revision 5122, 38.1 KB checked in by kakinaka, 20 years ago (diff)

blank

  • Property svn:mime-type set to application/octet-stream
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)
7VALUES ('dummy','dummy','',0,0,1,1);
8
9INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, del_flg, rank)
10VALUES ('admin','admin','2c19f4a742398150cecc80b3e76b673a35b8c19c',0,0,1,0,1);
11
12insert 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);
13insert into dtb_bloc ( bloc_name, tpl_path, filename, php_path, del_flg ) values ('ÍøÍÑ¥¬¥¤¥É', 'html/user_data/include/bloc/guide.tpl',            'guide','', 1);
14insert 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);
15insert 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);
16insert 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);
17insert 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);
18insert 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);
19
20insert into dtb_pagelayout (page_id,page_name,url)values(0, '¥×¥ì¥Ó¥å¡¼¥Ç¡¼¥¿','');
21update dtb_pagelayout set page_id = 0;
22insert into dtb_pagelayout (page_id,page_name,url,php_dir,tpl_dir,filename,edit_flg)values(1,'TOP¥Ú¡¼¥¸','index.php',' ','/html/user_data/templates/','top',2);
23insert into dtb_pagelayout (page_id,page_name,url,php_dir,tpl_dir,filename,edit_flg)values(2,'¾¦ÉʰìÍ÷¥Ú¡¼¥¸','products/list.php',' ','/html/user_data/templates/','list',2);
24insert into dtb_pagelayout (page_id,page_name,url,php_dir,tpl_dir,filename,edit_flg)values(3,'¾¦ÉʾܺÙ','products/detail.php',' ','/html/user_data/templates/','detail',2);
25insert into dtb_pagelayout (page_id,page_name,url,php_dir,tpl_dir,filename,edit_flg)values(4,'MY¥Ú¡¼¥¸','mypage/index.php',' ','','',2);
26
27INSERT 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');
28INSERT 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');
29INSERT 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');
30INSERT 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');
31INSERT 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');
32INSERT 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');
33INSERT 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');
34INSERT 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');
35INSERT 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');
36INSERT 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');
37INSERT 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');
38INSERT 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');
39INSERT 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');
40INSERT 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');
41INSERT 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');
42INSERT 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');
43INSERT 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');
44INSERT 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');
45INSERT 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');
46INSERT 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');
47INSERT 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');
48
49insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_id','¾¦ÉÊID',1);
50insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_class_id','µ¬³ÊID',2);
51insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'classcategory_id1','µ¬³Ê̾1',3);
52insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'classcategory_id2','µ¬³Ê̾2',4);
53insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'name','¾¦ÉÊ̾',5);
54insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'status','¸ø³«¥Õ¥é¥°',6);
55insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_flag','¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹',7);
56insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'product_code','¾¦ÉÊ¥³¡¼¥É',8);
57insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'price01','»²¹Í»Ô¾ì²Á³Ê',9);
58insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'price02','²Á³Ê',10);
59insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'stock','ºß¸Ë¿ô',11);
60insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'deliv_fee','Á÷ÎÁ',12);
61insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'point_rate','¥Ý¥¤¥ó¥ÈÉÕͿΨ',13);
62insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sale_limit','¹ØÆþÀ©¸Â',14);
63insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'comment1','¥á¡¼¥«¡¼URL',15);
64insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'comment3','¸¡º÷¥ï¡¼¥É',16);
65insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_list_comment','°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È',17);
66insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_list_image','°ìÍ÷-¥á¥¤¥ó²èÁü',18);
67insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_comment','¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È',19);
68insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_image','¾ÜºÙ-¥á¥¤¥ó²èÁü',20);
69insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'main_large_image','¾ÜºÙ-¥á¥¤¥ó³ÈÂç²èÁü ',21);
70insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'file1','¥«¥é¡¼Èæ³Ó²èÁü',22);
71insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'file2','¾¦Éʾܺ٥ե¡¥¤¥ë    ',23);
72insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title1','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê1¡Ë',24);
73insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment1','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê1¡Ë',25);
74insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image1','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê1¡Ë',26);
75insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image1','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê1¡Ë',27);
76insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title2','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê2¡Ë',28);
77insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment2','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê2¡Ë',29);
78insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image2','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê2¡Ë',30);
79insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image2','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê2¡Ë',31);
80insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title3','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê3¡Ë',32);
81insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment3','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê3¡Ë',33);
82insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image3','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê3¡Ë',34);
83insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image3','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê3¡Ë',35);
84insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title4','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê4¡Ë',36);
85insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment4','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê4¡Ë',37);
86insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image4','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê4¡Ë',38);
87insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image4','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê4¡Ë',39);
88insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_title5','¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê5¡Ë',40);
89insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_comment5','¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê5¡Ë',41);
90insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_image5','¾ÜºÙ-¥µ¥Ö²èÁü¡Ê5¡Ë',42);
91insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'sub_large_image5','¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê5¡Ë',43);
92insert into dtb_csv(csv_id,col,disp_name,rank)values(1,'deliv_date_id','ȯÁ÷ÆüÌܰÂ',44);
93insert 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);
94insert 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);
95insert 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);
96insert 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);
97insert 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);
98insert 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);
99insert 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);
100insert 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);
101
102insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'customer_id','¸ÜµÒID',1);
103insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'name01','̾Á°1',2);
104insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'name02','̾Á°2',3);
105insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'kana01','¥Õ¥ê¥¬¥Ê1',4);
106insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'kana02','¥Õ¥ê¥¬¥Ê2',5);
107insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'zip01', 'Í¹ÊØÈÖ¹æ1',6);
108insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'zip02', 'Í¹ÊØÈÖ¹æ2',7);
109insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'pref', 'ÅÔÆ»Éܸ©',8);
110insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'addr01', '½»½ê1',9);
111insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'addr02', '½»½ê2',10);
112insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'email', 'E-MAIL',11);
113insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel01', 'TEL1',12);
114insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel02', 'TEL2',13);
115insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'tel03', 'TEL3',14);
116insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax01', 'FAX1',15);
117insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax02', 'FAX2',16);
118insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'fax03', 'FAX3',17);
119insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'sex', 'À­ÊÌ',18);
120insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'job', '¿¦¶È',19);
121insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'birth', 'ÃÂÀ¸Æü',20);
122insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'first_buy_date', '½é²ó¹ØÆþÆü',21);
123insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'last_buy_date', 'ºÇ½ª¹ØÆþÆü',22);
124insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'buy_times', '¹ØÆþ²ó¿ô',23);
125insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'point', '¥Ý¥¤¥ó¥È»Ä¹â',24);
126insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'note', 'È÷¹Í',25);
127insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'create_date','ÅÐÏ¿Æü',26);
128insert into dtb_csv(csv_id,col,disp_name,rank)values(2,'update_date','¹¹¿·Æü',   27);
129
130insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_id','ÃíʸID',1);
131insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'customer_id','¸ÜµÒID',2);
132insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'message','Í×˾Åù',3);
133insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_name01','¸ÜµÒ̾1',4);
134insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_name02','¸ÜµÒ̾2',5);
135insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_kana01','¸ÜµÒ̾¥«¥Ê1',6);
136insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_kana02','¸ÜµÒ̾¥«¥Ê2',7);
137insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_email','¥á¡¼¥ë¥¢¥É¥ì¥¹',8);
138insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel01','ÅÅÏÃÈÖ¹æ1',9);
139insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel02','ÅÅÏÃÈÖ¹æ2',10);
140insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_tel03','ÅÅÏÃÈÖ¹æ3',11);
141insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax01','FAX1',12);
142insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax02','FAX2',13);
143insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_fax03','FAX3',14);
144insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_zip01','Í¹ÊØÈÖ¹æ1',15);
145insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_zip02','Í¹ÊØÈÖ¹æ2',16);
146insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_pref','ÅÔÆ»Éܸ©',17);
147insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_addr01','½»½ê1',18);
148insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_addr02','½»½ê2',19);
149insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_sex','À­ÊÌ',20);
150insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_birth','À¸Ç¯·îÆü',21);
151insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'order_job','¿¦¼ï',22);
152insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_name01','ÇÛÁ÷Àè̾Á°',23);
153insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_name02','ÇÛÁ÷Àè̾Á°',24);
154insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_kana01','ÇÛÁ÷À襫¥Ê',25);
155insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_kana02','ÇÛÁ÷À襫¥Ê',26);
156insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel01','ÅÅÏÃÈÖ¹æ1',27);
157insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel02','ÅÅÏÃÈÖ¹æ2',28);
158insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_tel03','ÅÅÏÃÈÖ¹æ3',29);
159insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax01','FAX1',30);
160insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax02','FAX2',31);
161insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fax03','FAX3',32);
162insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_zip01','Í¹ÊØÈÖ¹æ1',33);
163insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_zip02','Í¹ÊØÈÖ¹æ2',34);
164insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_pref','ÅÔÆ»Éܸ©',35);
165insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_addr01','½»½ê1',36);
166insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_addr02','½»½ê2',37);
167insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'subtotal','¾®·×',38);
168insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'discount','ÃͰú¤­',39);
169insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_fee','Á÷ÎÁ',40);
170insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'charge','¼ê¿ôÎÁ',41);
171insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'use_point','»ÈÍѥݥ¤¥ó¥È',42);
172insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'add_point','²Ã»»¥Ý¥¤¥ó¥È',43);
173insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'tax','ÀǶâ',44);
174insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'total','¹ç·×',45);
175insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'payment_total','¤ª»Ùʧ¤¤¹ç·×',46);
176insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'payment_method','»Ùʧ¤¤ÊýË¡',47);
177insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_time','ÇÛÁ÷»þ´Ö',48);
178insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'deliv_no','ÇÛÁ÷ÅÁɼÈÖ¹æ',49);
179insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'note','SHOP¥á¥â',50);
180insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'status','Âбþ¾õ¶·',51);
181insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'create_date','ÃíʸÆü»þ',52);
182insert into dtb_csv(csv_id,col,disp_name,rank)values(3,'update_date','¹¹¿·Æü»þ',53);
183
184INSERT INTO dtb_templates (template_code, template_name, create_date, update_date) VALUES('default1','¥Ç¥Õ¥©¥ë¥È1', now(), now());
185
186insert into dtb_mailtemplate (template_id, subject, header, footer, creator_id, update_date) values (
1871,
188'¤´Ãíʸ¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£',
189'¤³¤ÎÅ٤Ϥ´Ãíʸ¤¤¤¿¤À¤­À¿¤ËÍ­Æñ¤¦¤´¤¶¤¤¤Þ¤¹¡£
190²¼µ­¤´ÃíʸÆâÍÆ¤Ë¤ª´Ö°ã¤¨¤¬¤Ê¤¤¤«¤´³Îǧ²¼¤µ¤¤¡£
191
192',
193'
194
195==============================================================¡ù
196¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ï¤ªµÒÍͤؤΤªÃΤ餻ÀìÍѤǤ¹¤Î¤Ç¡¢
197¤³¤Î¥á¥Ã¥»¡¼¥¸¤Ø¤ÎÊÖ¿®¤È¤·¤Æ¤´¼ÁÌä¤ò¤ªÁ÷¤ê¤¤¤¿¤À¤¤¤Æ¤â²óÅú¤Ç¤­¤Þ¤»¤ó¡£
198¤´Î»¾µ¤¯¤À¤µ¤¤¡£
199
200¤´¼ÁÌä¤ä¤´ÉÔÌÀ¤ÊÅÀ¤¬¤´¤¶¤¤¤Þ¤·¤¿¤é¡¢¤³¤Á¤é¤«¤é¤ª´ê¤¤¤¤¤¿¤·¤Þ¤¹¡£
201http://------.co.jp
202
203',0,Now());
204
205insert into dtb_news (news_title, news_comment, creator_id)
206values('¥µ¥¤¥È¥ª¡¼¥×¥ó¤¤¤¿¤·¤Þ¤·¤¿!','°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆÏ¤±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆÏ¤±¤·¤Þ¤¹¡ª°ì¿ÍÊë¤é¤·¤«¤é¥ª¥Õ¥£¥¹¤Ê¤É¤µ¤Þ¤¶¤Þ¤Ê¥·¡¼¥ó¤Ç ¤¢¤Ê¤¿¤ÎÀ¸³è¤ò¥µ¥Ý¡¼¥È¤¹¤ë¥°¥Ã¥º¤ò¤´²ÈÄí¤Ø¤ªÆÏ¤±¤·¤Þ¤¹¡ª',1);
207
208INSERT INTO dtb_deliv (name,service_name,confirm_url,rank,status,del_flg,creator_id,create_date,update_date)
209VALUES ('¥À¥ß¡¼ÇÛÁ÷¶È¼Ô', '¥À¥ß¡¼ÇÛÁ÷¶È¼Ô', '', 1, 1, 0, 2, now(), now());
210
211INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 1);
212INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 2);
213INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 3);
214INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 4);
215INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 5);
216INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 6);
217INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 7);
218INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 8);
219INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 9);
220INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 10);
221INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 11);
222INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 12);
223INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 13);
224INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 14);
225INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 15);
226INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 16);
227INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 17);
228INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 18);
229INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 19);
230INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 20);
231INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 21);
232INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 22);
233INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 23);
234INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 24);
235INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 25);
236INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 26);
237INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 27);
238INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 28);
239INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 29);
240INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 30);
241INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 31);
242INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 32);
243INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 33);
244INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 34);
245INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 35);
246INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 36);
247INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 37);
248INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 38);
249INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 39);
250INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 40);
251INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 41);
252INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 42);
253INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 43);
254INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 44);
255INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 45);
256INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 46);
257INSERT INTO dtb_delivfee (deliv_id,fee,pref) VALUES (1, '1000', 47);
258
259INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸áÁ°');
260INSERT INTO dtb_delivtime (deliv_id, deliv_time) VALUES (1, '¸á¸å');
261
262INSERT 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);
263INSERT 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);
264INSERT 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);
265INSERT 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);
266
267INSERT 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)
268VALUES ('¥¢¥¤¥¹¥¯¥ê¡¼¥à', 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);
269INSERT 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)
270VALUES ('¤ª¤Ê¤Ù', 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);
271
272INSERT 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)
273VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
274DELETE FROM dtb_products_class;
275INSERT 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)
276VALUES (1, 3, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
277INSERT 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)
278VALUES (1, 3, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
279INSERT 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)
280VALUES (1, 3, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
281INSERT 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)
282VALUES (1, 2, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
283INSERT 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)
284VALUES (1, 2, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
285INSERT 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)
286VALUES (1, 2, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
287INSERT 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)
288VALUES (1, 1, 6, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
289INSERT 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)
290VALUES (1, 1, 5, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
291INSERT 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)
292VALUES (1, 1, 4, 'ice-01', NULL, 1, NULL, 150, 120, NULL, 2, now(), NULL);
293INSERT 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)
294VALUES (2, 0, 0, 'nabe-01', 100, NULL, NULL, 1700, 1650, NULL, 2, now(), NULL);
295
296INSERT INTO dtb_recommend_products (product_id,rank,comment,status,creator_id,create_date,update_date) VALUES (2, 4, '¤ª¸ýľ¤·¤Ë¡£', 0, 2, now(), now());
297
298INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Ì£', NULL, 1, 2, now(), now(), 0, NULL);
299INSERT INTO dtb_class (name,status,rank,creator_id,create_date,update_date,del_flg,product_id) VALUES ('Â礭¤µ', NULL, 2, 2, now(), NULL, 0, NULL);
300
301INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Ð¥Ë¥é', 1, NULL, 1, 2, now(), NULL, 0);
302INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('¥Á¥ç¥³', 1, NULL, 2, 2, now(), NULL, 0);
303INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('ËõÃã', 1, NULL, 3, 2, now(), NULL, 0);
304INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('L', 2, NULL, 1, 2, now(), NULL, 0);
305INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('M', 2, NULL, 2, 2, now(), NULL, 0);
306INSERT INTO dtb_classcategory (name,class_id,status,rank,creator_id,create_date,update_date,del_flg) VALUES ('S', 2, NULL, 3, 2, now(), NULL, 0);
307
308INSERT INTO dtb_classcategory (classcategory_id, class_id, rank, creator_id, create_date, update_date)
309VALUES (0, 0, 0, 0, now(), now());
310UPDATE dtb_classcategory SET classcategory_id = 0 WHERE class_id = 0;
311
312INSERT 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);
313INSERT 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);
314INSERT 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);
315INSERT 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);
316INSERT 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);
317
318INSERT INTO dtb_category_count VALUES (4, 1, now());
319INSERT INTO dtb_category_count VALUES (5, 1, now());
320
321INSERT INTO dtb_category_total_count VALUES (3, 1, now());
322INSERT INTO dtb_category_total_count VALUES (1, 2, now());
323INSERT INTO dtb_category_total_count VALUES (2, NULL, now());
324INSERT INTO dtb_category_total_count VALUES (5, 1, now());
325INSERT INTO dtb_category_total_count VALUES (4, 1, now());
326
327INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
328VALUES ('Â裱¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£
3292. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À­¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£
3303. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£',
33112,0,Now(),0);
332
333INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
334VALUES ('Â裲¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê
335Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òÍ­¤·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£
336
3372. ²ñ°÷¾ðÊó¤ÎÆþÎÏ
338²ñ°÷ÅÐÏ¿¼ê³¤ÎºÝ¤Ë¤Ï¡¢ÆþÎϾå¤ÎÃí°Õ¤ò¤è¤¯ÆÉ¤ß¡¢½êÄê¤ÎÆþÎÏ¥Õ¥©¡¼¥à¤ËɬÍ×»ö¹à¤òÀµ³Î¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£²ñ°÷¾ðÊó¤ÎÅÐÏ¿¤Ë¤ª¤¤¤Æ¡¢ÆÃ¼ìµ­¹æ¡¦µì´Á»ú¡¦¥í¡¼¥Þ¿ô»ú¤Ê¤É¤Ï¤´»ÈÍѤˤʤì¤Þ¤»¤ó¡£¤³¤ì¤é¤Îʸ»ú¤¬ÅÐÏ¿¤µ¤ì¤¿¾ì¹ç¤ÏÅö¼Ò¤Ë¤ÆÊѹ¹Ãפ·¤Þ¤¹¡£
339
3403. ¥Ñ¥¹¥ï¡¼¥É¤Î´ÉÍý
341(1)¥Ñ¥¹¥ï¡¼¥É¤Ï²ñ°÷ËܿͤΤߤ¬ÍøÍѤǤ­¤ë¤â¤Î¤È¤·¡¢Âè»°¼Ô¤Ë¾ùÅÏ¡¦ÂßÍ¿¤Ç¤­¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
342(2)¥Ñ¥¹¥ï¡¼¥É¤Ï¡¢Â¾¿Í¤ËÃΤé¤ì¤ë¤³¤È¤¬¤Ê¤¤¤è¤¦Äê´üŪ¤ËÊѹ¹¤¹¤ëÅù¡¢²ñ°÷Ëܿͤ¬ÀÕǤ¤ò¤â¤Ã¤Æ´ÉÍý¤·¤Æ¤¯¤À¤µ¤¤¡£
343(3)¥Ñ¥¹¥ï¡¼¥É¤òÍѤ¤¤ÆÅö¼Ò¤ËÂФ·¤Æ¹Ô¤ï¤ì¤¿°Õ»×ɽ¼¨¤Ï¡¢²ñ°÷Ëܿͤΰջ×ɽ¼¨¤È¤ß¤Ê¤·¡¢¤½¤Î¤¿¤á¤ËÀ¸¤¸¤ë»ÙʧÅù¤Ï¤¹¤Ù¤Æ²ñ°÷¤ÎÀÕǤ¤È¤Ê¤ê¤Þ¤¹¡£',
34411,0,Now(),0);
345
346INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
347VALUES ('Â裳¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆÏ¤±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
3482. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£',
34910,0,Now(),0);
350
351INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
352VALUES ('Â裴¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤­¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£',
3539,0,Now(),0);
354
355INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
356VALUES ('Â裵¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤­¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ­¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤­¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤­¤ë¤³¤È¤È¤·¤Þ¤¹¡£
3572. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤­¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£
358(1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È
359(2)Åö¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¥¢¥¯¥»¥¹¤·¤Æ¾ðÊó¤ò²þ¤¶¤ó¤·¤¿¤ê¡¢Åö¥Û¡¼¥à¥Ú¡¼¥¸¤ËÍ­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¤òÁ÷¿®¤¹¤ë¤Ê¤É¤·¤Æ¡¢Åö¼Ò¤Î±Ä¶È¤ò˸³²¤¹¤ë¤³¤È
360(3)Åö¼Ò¤¬°·¤¦¾¦ÉʤÎÃÎŪ½êÍ­¸¢¤ò¿¯³²¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È
361(4)¤½¤Î¾¡¢¤³¤ÎÍøÍѵ¬Ìó¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È',
3628,0,Now(),0);
363
364INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
365VALUES ('Â裶¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
366(1)Ë¡Îá¤Ë´ð¤Å¤­³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç
367(2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç
3682. ²ñ°÷¾ðÊó¤Ë¤Ä¤­¤Þ¤·¤Æ¤Ï¡¢Åö¼Ò¤Î¡Ö¸Ä¿Í¾ðÊóÊÝ¸î¤Ø¤Î¼èÁȤߡפ˽¾¤¤¡¢Åö¼Ò¤¬´ÉÍý¤·¤Þ¤¹¡£Åö¼Ò¤Ï¡¢²ñ°÷¾ðÊó¤ò¡¢²ñ°÷¤Ø¤Î¥µ¡¼¥Ó¥¹Äó¶¡¡¢¥µ¡¼¥Ó¥¹ÆâÍÆ¤Î¸þ¾å¡¢¥µ¡¼¥Ó¥¹¤ÎÍøÍÑÂ¥¿Ê¡¢¤ª¤è¤Ó¥µ¡¼¥Ó¥¹¤Î·òÁ´¤«¤Ä±ß³ê¤Ê±¿±Ä¤Î³ÎÊݤò¿Þ¤ëÌÜŪ¤Î¤¿¤á¤Ë¡¢Åö¼Ò¤ª¤¤¤ÆÍøÍѤ¹¤ë¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£
3693. Åö¼Ò¤Ï¡¢²ñ°÷¤ËÂФ·¤Æ¡¢¥á¡¼¥ë¥Þ¥¬¥¸¥ó¤½¤Î¾¤ÎÊýË¡¤Ë¤è¤ë¾ðÊóÄ󶡡ʹ­¹ð¤ò´Þ¤ß¤Þ¤¹¡Ë¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£²ñ°÷¤¬¾ðÊóÄ󶡤ò´õ˾¤·¤Ê¤¤¾ì¹ç¤Ï¡¢Åö¼Ò½êÄê¤ÎÊýË¡¤Ë½¾¤¤¡¢¤½¤Î»Ý¤òÄÌÃΤ·¤ÆÄº¤±¤ì¤Ð¡¢¾ðÊóÄ󶡤òÄä»ß¤·¤Þ¤¹¡£¤¿¤À¤·¡¢ËÜ¥µ¡¼¥Ó¥¹±¿±Ä¤ËɬÍפʾðÊóÄ󶡤ˤĤ­¤Þ¤·¤Æ¤Ï¡¢²ñ°÷¤Î´õ˾¤Ë¤è¤êÄä»ß¤ò¤¹¤ë¤³¤È¤Ï¤Ç¤­¤Þ¤»¤ó¡£',
3707,0,Now(),0);
371
372INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
373VALUES ('Â裷¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£
374
3751. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È
3762. Åö¼Ò¡¢¤ª¤è¤Ó¤½¤Î¾¤ÎÂè»°¼Ô¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤ò»¤Í¤ë¤³¤È
3773. Àľ¯Ç¯¤Î¿´¿È¤Ë°­±Æ¶Á¤òµÚ¤Ü¤¹¶²¤ì¤¬¤¢¤ë¹Ô°Ù¡¢¤½¤Î¾¸ø½øÎɯ¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
3784. ¾¤ÎÍøÍѼԤ½¤Î¾¤ÎÂè»°¼Ô¤ËÌÂÏǤȤʤë¹Ô°Ù¤äÉÔ²÷´¶¤òÊú¤«¤»¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È
3795. µõµ¶¤Î¾ðÊó¤òÆþÎϤ¹¤ë¤³¤È
3806. Í­³²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¡¢¥á¡¼¥ëÅù¤òÁ÷¿®¤Þ¤¿¤Ï½ñ¤­¹þ¤à¤³¤È
3817. Åö¼Ò¤Î¥µ¡¼¥Ð¤½¤Î¾¤Î¥³¥ó¥Ô¥å¡¼¥¿¤ËÉÔÀµ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤³¤È
3828. ¥Ñ¥¹¥ï¡¼¥É¤òÂè»°¼Ô¤ËÂßÍ¿¡¦¾ùÅϤ¹¤ë¤³¤È¡¢¤Þ¤¿¤ÏÂè»°¼Ô¤È¶¦ÍѤ¹¤ë¤³¤È
3839. ¤½¤Î¾Åö¼Ò¤¬ÉÔŬÀÚ¤ÈȽÃǤ¹¤ë¤³¤È',
3846,0,Now(),0);
385
386INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
387VALUES ('Â裸¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²Ôư¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£
388(1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç
389(2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç
390(3)²ÐºÒ¡¢ÄäÅÅ¡¢Âè»°¼Ô¤Ë¤è¤ë˸³²¹Ô°Ù¤Ê¤É¤Ë¤è¤ê¥·¥¹¥Æ¥à¤Î±¿ÍѤ¬º¤Æñ¤Ë¤Ê¤Ã¤¿¾ì¹ç
391(4)¤½¤Î¾¡¢»ß¤à¤òÆÀ¤º¥·¥¹¥Æ¥à¤ÎÄä»ß¤¬É¬ÍפÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç',
3925,0,Now(),0);
393
394INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
395VALUES ('Â裹¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ­¤ë¤â¤Î¤È¤·¤Þ¤¹¡£',
3964,0,Now(),0);
397
398INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
399VALUES ('Âè10¾ò¡ÊÌÈÀÕ¡Ë','1. ÄÌ¿®²óÀþ¤ä¥³¥ó¥Ô¥å¡¼¥¿¤Ê¤É¤Î¾ã³²¤Ë¤è¤ë¥·¥¹¥Æ¥à¤ÎÃæÃÇ¡¦ÃÙÂÚ¡¦Ãæ»ß¡¦¥Ç¡¼¥¿¤Î¾Ã¼º¡¢¥Ç¡¼¥¿¤Ø¤ÎÉÔÀµ¥¢¥¯¥»¥¹¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¡¢¤½¤Î¾Åö¼Ò¤Î¥µ¡¼¥Ó¥¹¤Ë´Ø¤·¤Æ²ñ°÷¤ËÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉé¤ï¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£
4002. Åö¼Ò¤Ï¡¢Åö¼Ò¤Î¥¦¥§¥Ö¥Ú¡¼¥¸¡¦¥µ¡¼¥Ð¡¦¥É¥á¥¤¥ó¤Ê¤É¤«¤éÁ÷¤é¤ì¤ë¥á¡¼¥ë¡¦¥³¥ó¥Æ¥ó¥Ä¤Ë¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¦¥¦¥£¥ë¥¹¤Ê¤É¤ÎÍ­³²¤Ê¤â¤Î¤¬´Þ¤Þ¤ì¤Æ¤¤¤Ê¤¤¤³¤È¤òÊݾڤ¤¤¿¤·¤Þ¤»¤ó¡£
4013. ²ñ°÷¤¬Ëܵ¬ÌóÅù¤Ë°ãÈ¿¤·¤¿¤³¤È¤Ë¤è¤Ã¤ÆÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¤Ï¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£',
4023,0,Now(),0);
403
404INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
405VALUES ('Âè11¾ò¡ÊËܵ¬Ìó¤Î²þÄê¡Ë','Åö¼Ò¤Ï¡¢Ëܵ¬Ìó¤òǤ°Õ¤Ë²þÄê¤Ç¤­¤ë¤â¤Î¤È¤·¡¢¤Þ¤¿¡¢Åö¼Ò¤Ë¤ª¤¤¤ÆËܵ¬Ìó¤òÊä½¼¤¹¤ëµ¬Ìó¡Ê°Ê²¼¡ÖÊä½¼µ¬Ìó¡×¤È¤¤¤¤¤Þ¤¹¡Ë¤òÄê¤á¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡£Ëܵ¬Ìó¤Î²þÄê¤Þ¤¿¤ÏÊä½¼¤Ï¡¢²þÄê¸å¤ÎËܵ¬Ìó¤Þ¤¿¤ÏÊä½¼µ¬Ìó¤òÅö¼Ò½êÄê¤Î¥µ¥¤¥È¤Ë·Ç¼¨¤·¤¿¤È¤­¤Ë¤½¤Î¸úÎϤòÀ¸¤¸¤ë¤â¤Î¤È¤·¤Þ¤¹¡£¤³¤Î¾ì¹ç¡¢²ñ°÷¤Ï¡¢²þÄê¸å¤Îµ¬Ì󤪤è¤ÓÊä½¼µ¬Ìó¤Ë½¾¤¦¤â¤Î¤ÈÃפ·¤Þ¤¹¡£',
4062,0,Now(),0);
407
408INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg)
409VALUES ('Âè12¾ò¡Ê½àµòË¡¡¢´É³íºÛȽ½ê¡Ë','Ëܵ¬Ìó¤Ë´Ø¤·¤ÆÊ¶Á褬À¸¤¸¤¿¾ì¹ç¡¢Åö¼ÒËÜŹ½êºßÃϤò´É³í¤¹¤ëÃÏÊýºÛȽ½ê¤òÂè°ì¿³¤ÎÀì°Ū¹ç°Õ´É³íºÛȽ½ê¤È¤·¤Þ¤¹¡£ ',
4101,0,Now(),0);
Note: See TracBrowser for help on using the repository browser.