| 1 | |
|---|
| 2 | CREATE INDEX dtb_products_category_id_key ON dtb_products(category_id); |
|---|
| 3 | CREATE INDEX dtb_products_class_product_id_key ON dtb_products_class(product_id); |
|---|
| 4 | CREATE INDEX dtb_order_detail_product_id_key ON dtb_order_detail(product_id); |
|---|
| 5 | CREATE INDEX dtb_category_category_id_key ON dtb_category(category_id); |
|---|
| 6 | |
|---|
| 7 | INSERT INTO dtb_classcategory (classcategory_id, class_id, rank, creator_id, create_date) |
|---|
| 8 | VALUES (0, 0, 0, 0, now()); |
|---|
| 9 | |
|---|
| 10 | INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, delete) |
|---|
| 11 | VALUES ('dummy','dummy','',0,0,1,1); |
|---|
| 12 | |
|---|
| 13 | INSERT INTO dtb_member (name, login_id, password, creator_id, authority, work, delete) |
|---|
| 14 | VALUES ('admin','admin','$1$JPUS3lIX$B0FJNs4Q0lv9i.UYBP7do0',0,0,1,0); |
|---|
| 15 | |
|---|
| 16 | insert into dtb_pagelayout ( page_name, url, php_dir, tpl_dir, filename, edit_flg) |
|---|
| 17 | values( 'TOP¥Ú¡¼¥¸', 'index.php', '', '/html/user_data/include/', 'top', 2); |
|---|
| 18 | |
|---|
| 19 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'product_id', '¾¦ÉÊID', 1 ); |
|---|
| 20 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'product_class_id', 'µ¬³ÊID', 2 ); |
|---|
| 21 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'classcategory_id1', 'µ¬³Ê̾1', 3 ); |
|---|
| 22 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'classcategory_id2', 'µ¬³Ê̾2', 4 ); |
|---|
| 23 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'name', '¾¦ÉÊ̾', 5 ); |
|---|
| 24 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'status', '¸ø³«¥Õ¥é¥°', 6 ); |
|---|
| 25 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'product_flag', '¾¦ÉÊ¥¹¥Æ¡¼¥¿¥¹', 7 ); |
|---|
| 26 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'product_code', '¾¦ÉÊ¥³¡¼¥É', 8 ); |
|---|
| 27 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'price01', '»²¹Í»Ô¾ì²Á³Ê', 9 ); |
|---|
| 28 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'price02', '²Á³Ê', 10 ); |
|---|
| 29 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'stock', 'ºß¸Ë¿ô', 11 ); |
|---|
| 30 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'deliv_fee', 'Á÷ÎÁ', 12 ); |
|---|
| 31 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'point_rate', '¥Ý¥¤¥ó¥ÈÉÕͿΨ', 13 ); |
|---|
| 32 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sale_limit', '¹ØÆþÀ©¸Â', 14 ); |
|---|
| 33 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'comment1', '¥á¡¼¥«¡¼URL', 15 ); |
|---|
| 34 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'comment3', '¸¡º÷¥ï¡¼¥É', 16 ); |
|---|
| 35 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'main_list_comment', '°ìÍ÷-¥á¥¤¥ó¥³¥á¥ó¥È', 17 ); |
|---|
| 36 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'main_list_image', '°ìÍ÷-¥á¥¤¥ó²èÁü', 18 ); |
|---|
| 37 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'main_comment', '¾ÜºÙ-¥á¥¤¥ó¥³¥á¥ó¥È', 19 ); |
|---|
| 38 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'main_image', '¾ÜºÙ-¥á¥¤¥ó²èÁü', 20 ); |
|---|
| 39 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'main_large_image', '¾ÜºÙ-¥á¥¤¥ó³ÈÂç²èÁü ', 21 ); |
|---|
| 40 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'file1', '¥«¥é¡¼Èæ³Ó²èÁü', 22 ); |
|---|
| 41 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'file2', '¾¦Éʾܺ٥ե¡¥¤¥ë ', 23 ); |
|---|
| 42 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_title1', '¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê1¡Ë', 24 ); |
|---|
| 43 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_comment1', '¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê1¡Ë', 25 ); |
|---|
| 44 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_image1', '¾ÜºÙ-¥µ¥Ö²èÁü¡Ê1¡Ë', 26 ); |
|---|
| 45 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_large_image1', '¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê1¡Ë', 27 ); |
|---|
| 46 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_title2', '¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê2¡Ë', 28 ); |
|---|
| 47 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_comment2', '¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê2¡Ë', 29 ); |
|---|
| 48 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_image2', '¾ÜºÙ-¥µ¥Ö²èÁü¡Ê2¡Ë', 30 ); |
|---|
| 49 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_large_image2', '¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê2¡Ë', 31 ); |
|---|
| 50 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_title3', '¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê3¡Ë', 32 ); |
|---|
| 51 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_comment3', '¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê3¡Ë', 33 ); |
|---|
| 52 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_image3', '¾ÜºÙ-¥µ¥Ö²èÁü¡Ê3¡Ë', 34 ); |
|---|
| 53 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_large_image3', '¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê3¡Ë', 35 ); |
|---|
| 54 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_title4', '¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê4¡Ë', 36 ); |
|---|
| 55 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_comment4', '¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê4¡Ë', 37 ); |
|---|
| 56 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_image4', '¾ÜºÙ-¥µ¥Ö²èÁü¡Ê4¡Ë', 38 ); |
|---|
| 57 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_large_image4', '¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê4¡Ë', 39 ); |
|---|
| 58 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_title5', '¾ÜºÙ-¥µ¥Ö¥¿¥¤¥È¥ë¡Ê5¡Ë', 40 ); |
|---|
| 59 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_comment5', '¾ÜºÙ-¥µ¥Ö¥³¥á¥ó¥È¡Ê5¡Ë', 41 ); |
|---|
| 60 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_image5', '¾ÜºÙ-¥µ¥Ö²èÁü¡Ê5¡Ë', 42 ); |
|---|
| 61 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'sub_large_image5', '¾ÜºÙ-¥µ¥Ö³ÈÂç²èÁü¡Ê5¡Ë', 43 ); |
|---|
| 62 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 1 , 'deliv_date_id', 'ȯÁ÷ÆüÌܰÂ', 44 ); |
|---|
| 63 | 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 ); |
|---|
| 64 | 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 ); |
|---|
| 65 | 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 ); |
|---|
| 66 | 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 ); |
|---|
| 67 | 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 ); |
|---|
| 68 | 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 ); |
|---|
| 69 | 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 ); |
|---|
| 70 | 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 ); |
|---|
| 71 | |
|---|
| 72 | |
|---|
| 73 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'customer_id', '¸ÜµÒID', 1 ); |
|---|
| 74 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'name01', '̾Á°1', 2 ); |
|---|
| 75 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'name02', '̾Á°2', 3 ); |
|---|
| 76 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'kana01', '¥Õ¥ê¥¬¥Ê1', 4 ); |
|---|
| 77 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'kana02', '¥Õ¥ê¥¬¥Ê2', 5 ); |
|---|
| 78 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'zip01', 'Í¹ÊØÈÖ¹æ1', 6 ); |
|---|
| 79 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'zip02', 'Í¹ÊØÈÖ¹æ2', 7 ); |
|---|
| 80 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'pref', 'ÅÔÆ»Éܸ©', 8 ); |
|---|
| 81 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'addr01', '½»½ê1', 9 ); |
|---|
| 82 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'addr02', '½»½ê2', 10 ); |
|---|
| 83 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'email', 'E-MAIL', 11 ); |
|---|
| 84 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'tel01', 'TEL1', 12 ); |
|---|
| 85 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'tel02', 'TEL2', 13 ); |
|---|
| 86 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'tel03', 'TEL3', 14 ); |
|---|
| 87 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'fax01', 'FAX1', 15 ); |
|---|
| 88 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'fax02', 'FAX2', 16 ); |
|---|
| 89 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'fax03', 'FAX3', 17 ); |
|---|
| 90 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'CASE WHEN sex = 1 THEN ''ÃËÀ'' ELSE ''½÷À'' END AS sex', 'ÀÊÌ', 18 ); |
|---|
| 91 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'job', '¿¦¶È', 19 ); |
|---|
| 92 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'to_char(birth, ''YYYYǯMM·îDDÆü'') AS birth', 'ÃÂÀ¸Æü', 20 ); |
|---|
| 93 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'to_char(first_buy_date, ''YYYYǯMM·îDDÆüHH24:MI'') AS first_buy_date', '½é²ó¹ØÆþÆü', 21 ); |
|---|
| 94 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'to_char(last_buy_date, ''YYYYǯMM·îDDÆüHH24:MI'') AS last_buy_date', 'ºÇ½ª¹ØÆþÆü', 22 ); |
|---|
| 95 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'buy_times', '¹ØÆþ²ó¿ô', 23 ); |
|---|
| 96 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'point', '¥Ý¥¤¥ó¥È»Ä¹â', 24 ); |
|---|
| 97 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'note', 'È÷¹Í', 25 ); |
|---|
| 98 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'to_char(create_date, ''YYYYǯMM·îDDÆüHH24:MI'') AS create_date', 'ÅÐÏ¿Æü', 26 ); |
|---|
| 99 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 2 , 'to_char(update_date, ''YYYYǯMM·îDDÆüHH24:MI'') AS update_date', '¹¹¿·Æü', 27 ); |
|---|
| 100 | |
|---|
| 101 | |
|---|
| 102 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_id', 'ÃíʸID', 1 ); |
|---|
| 103 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'customer_id', '¸ÜµÒID', 2 ); |
|---|
| 104 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'message', 'Í×˾Åù', 3 ); |
|---|
| 105 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_name01', '¸ÜµÒ̾1', 4 ); |
|---|
| 106 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_name02', '¸ÜµÒ̾2', 5 ); |
|---|
| 107 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_kana01', '¸ÜµÒ̾¥«¥Ê1', 6 ); |
|---|
| 108 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_kana02', '¸ÜµÒ̾¥«¥Ê2', 7 ); |
|---|
| 109 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_email', '¥á¡¼¥ë¥¢¥É¥ì¥¹', 8 ); |
|---|
| 110 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_tel01', 'ÅÅÏÃÈÖ¹æ1', 9 ); |
|---|
| 111 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_tel02', 'ÅÅÏÃÈÖ¹æ2', 10 ); |
|---|
| 112 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_tel03', 'ÅÅÏÃÈÖ¹æ3', 11 ); |
|---|
| 113 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_fax01', 'FAX1', 12 ); |
|---|
| 114 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_fax02', 'FAX2', 13 ); |
|---|
| 115 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_fax03', 'FAX3', 14 ); |
|---|
| 116 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_zip01', 'Í¹ÊØÈÖ¹æ1', 15 ); |
|---|
| 117 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_zip02', 'Í¹ÊØÈÖ¹æ2', 16 ); |
|---|
| 118 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_pref', 'ÅÔÆ»Éܸ©', 17 ); |
|---|
| 119 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_addr01', '½»½ê1', 18 ); |
|---|
| 120 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_addr02', '½»½ê2', 19 ); |
|---|
| 121 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_sex', 'ÀÊÌ', 20 ); |
|---|
| 122 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_birth', 'À¸Ç¯·îÆü', 21 ); |
|---|
| 123 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'order_job', '¿¦¼ï', 22 ); |
|---|
| 124 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_name01', 'ÇÛÁ÷Àè̾Á°', 23 ); |
|---|
| 125 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_name02', 'ÇÛÁ÷Àè̾Á°', 24 ); |
|---|
| 126 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_kana01', 'ÇÛÁ÷À襫¥Ê', 25 ); |
|---|
| 127 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_kana02', 'ÇÛÁ÷À襫¥Ê', 26 ); |
|---|
| 128 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_tel01', 'ÅÅÏÃÈÖ¹æ1', 27 ); |
|---|
| 129 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_tel02', 'ÅÅÏÃÈÖ¹æ2', 28 ); |
|---|
| 130 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_tel03', 'ÅÅÏÃÈÖ¹æ3', 29 ); |
|---|
| 131 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_fax01', 'FAX1', 30 ); |
|---|
| 132 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_fax02', 'FAX2', 31 ); |
|---|
| 133 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_fax03', 'FAX3', 32 ); |
|---|
| 134 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_zip01', 'Í¹ÊØÈÖ¹æ1', 33 ); |
|---|
| 135 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_zip02', 'Í¹ÊØÈÖ¹æ2', 34 ); |
|---|
| 136 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_pref', 'ÅÔÆ»Éܸ©', 35 ); |
|---|
| 137 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_addr01', '½»½ê1', 36 ); |
|---|
| 138 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_addr02', '½»½ê2', 37 ); |
|---|
| 139 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'subtotal', '¾®·×', 38 ); |
|---|
| 140 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'discount', 'ÃͰú¤', 39 ); |
|---|
| 141 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_fee', 'Á÷ÎÁ', 40 ); |
|---|
| 142 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'charge', '¼ê¿ôÎÁ', 41 ); |
|---|
| 143 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'use_point', '»ÈÍѥݥ¤¥ó¥È', 42 ); |
|---|
| 144 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'add_point', '²Ã»»¥Ý¥¤¥ó¥È', 43 ); |
|---|
| 145 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'tax', 'ÀǶâ', 44 ); |
|---|
| 146 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'total', '¹ç·×', 45 ); |
|---|
| 147 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'payment_total', '¤ª»Ùʧ¤¤¹ç·×', 46 ); |
|---|
| 148 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'payment_method', '»Ùʧ¤¤ÊýË¡', 47 ); |
|---|
| 149 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_time', 'ÇÛÁ÷»þ´Ö', 48 ); |
|---|
| 150 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'deliv_no', 'ÇÛÁ÷ÅÁɼÈÖ¹æ', 49 ); |
|---|
| 151 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'note', 'SHOP¥á¥â', 50 ); |
|---|
| 152 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'status', 'Âбþ¾õ¶·', 51 ); |
|---|
| 153 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'create_date', 'ÃíʸÆü»þ', 52 ); |
|---|
| 154 | insert into dtb_csv(csv_id,col,disp_name,rank)values( 3 , 'update_date', '¹¹¿·Æü»þ', 53 ); |
|---|
| 155 | |
|---|
| 156 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 157 | VALUES ('Â裱¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£ |
|---|
| 158 | 2. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£ |
|---|
| 159 | 3. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£', |
|---|
| 160 | 12,0,Now(),0); |
|---|
| 161 | |
|---|
| 162 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 163 | VALUES ('Â裲¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê |
|---|
| 164 | Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òͤ·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£ |
|---|
| 165 | |
|---|
| 166 | 2. ²ñ°÷¾ðÊó¤ÎÆþÎÏ |
|---|
| 167 | ²ñ°÷ÅÐÏ¿¼ê³¤ÎºÝ¤Ë¤Ï¡¢ÆþÎϾå¤ÎÃí°Õ¤ò¤è¤¯ÆÉ¤ß¡¢½êÄê¤ÎÆþÎÏ¥Õ¥©¡¼¥à¤ËɬÍ×»ö¹à¤òÀµ³Î¤ËÆþÎϤ·¤Æ¤¯¤À¤µ¤¤¡£²ñ°÷¾ðÊó¤ÎÅÐÏ¿¤Ë¤ª¤¤¤Æ¡¢ÆÃ¼ìµ¹æ¡¦µì´Á»ú¡¦¥í¡¼¥Þ¿ô»ú¤Ê¤É¤Ï¤´»ÈÍѤˤʤì¤Þ¤»¤ó¡£¤³¤ì¤é¤Îʸ»ú¤¬ÅÐÏ¿¤µ¤ì¤¿¾ì¹ç¤ÏÅö¼Ò¤Ë¤ÆÊѹ¹Ãפ·¤Þ¤¹¡£ |
|---|
| 168 | |
|---|
| 169 | 3. ¥Ñ¥¹¥ï¡¼¥É¤Î´ÉÍý |
|---|
| 170 | (1)¥Ñ¥¹¥ï¡¼¥É¤Ï²ñ°÷ËܿͤΤߤ¬ÍøÍѤǤ¤ë¤â¤Î¤È¤·¡¢Âè»°¼Ô¤Ë¾ùÅÏ¡¦ÂßÍ¿¤Ç¤¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£ |
|---|
| 171 | (2)¥Ñ¥¹¥ï¡¼¥É¤Ï¡¢Â¾¿Í¤ËÃΤé¤ì¤ë¤³¤È¤¬¤Ê¤¤¤è¤¦Äê´üŪ¤ËÊѹ¹¤¹¤ëÅù¡¢²ñ°÷Ëܿͤ¬ÀÕǤ¤ò¤â¤Ã¤Æ´ÉÍý¤·¤Æ¤¯¤À¤µ¤¤¡£ |
|---|
| 172 | (3)¥Ñ¥¹¥ï¡¼¥É¤òÍѤ¤¤ÆÅö¼Ò¤ËÂФ·¤Æ¹Ô¤ï¤ì¤¿°Õ»×ɽ¼¨¤Ï¡¢²ñ°÷Ëܿͤΰջ×ɽ¼¨¤È¤ß¤Ê¤·¡¢¤½¤Î¤¿¤á¤ËÀ¸¤¸¤ë»ÙʧÅù¤Ï¤¹¤Ù¤Æ²ñ°÷¤ÎÀÕǤ¤È¤Ê¤ê¤Þ¤¹¡£', |
|---|
| 173 | 11,0,Now(),0); |
|---|
| 174 | |
|---|
| 175 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 176 | VALUES ('Â裳¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆÏ¤±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ |
|---|
| 177 | 2. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£', |
|---|
| 178 | 10,0,Now(),0); |
|---|
| 179 | |
|---|
| 180 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 181 | VALUES ('Â裴¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£', |
|---|
| 182 | 9,0,Now(),0); |
|---|
| 183 | |
|---|
| 184 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 185 | VALUES ('Â裵¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤¤ë¤³¤È¤È¤·¤Þ¤¹¡£ |
|---|
| 186 | 2. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£ |
|---|
| 187 | (1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È |
|---|
| 188 | (2)Åö¥Û¡¼¥à¥Ú¡¼¥¸¤Ë¥¢¥¯¥»¥¹¤·¤Æ¾ðÊó¤ò²þ¤¶¤ó¤·¤¿¤ê¡¢Åö¥Û¡¼¥à¥Ú¡¼¥¸¤Ëͳ²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¤òÁ÷¿®¤¹¤ë¤Ê¤É¤·¤Æ¡¢Åö¼Ò¤Î±Ä¶È¤ò˸³²¤¹¤ë¤³¤È |
|---|
| 189 | (3)Åö¼Ò¤¬°·¤¦¾¦ÉʤÎÃÎŪ½ê͸¢¤ò¿¯³²¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È |
|---|
| 190 | (4)¤½¤Î¾¡¢¤³¤ÎÍøÍѵ¬Ìó¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¤¹¤ë¤³¤È', |
|---|
| 191 | 8,0,Now(),0); |
|---|
| 192 | |
|---|
| 193 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 194 | VALUES ('Â裶¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ |
|---|
| 195 | (1)Ë¡Îá¤Ë´ð¤Å¤³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç |
|---|
| 196 | (2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç |
|---|
| 197 | 2. ²ñ°÷¾ðÊó¤Ë¤Ä¤¤Þ¤·¤Æ¤Ï¡¢Åö¼Ò¤Î¡Ö¸Ä¿Í¾ðÊóÊÝ¸î¤Ø¤Î¼èÁȤߡפ˽¾¤¤¡¢Åö¼Ò¤¬´ÉÍý¤·¤Þ¤¹¡£Åö¼Ò¤Ï¡¢²ñ°÷¾ðÊó¤ò¡¢²ñ°÷¤Ø¤Î¥µ¡¼¥Ó¥¹Äó¶¡¡¢¥µ¡¼¥Ó¥¹ÆâÍÆ¤Î¸þ¾å¡¢¥µ¡¼¥Ó¥¹¤ÎÍøÍÑÂ¥¿Ê¡¢¤ª¤è¤Ó¥µ¡¼¥Ó¥¹¤Î·òÁ´¤«¤Ä±ß³ê¤Ê±¿±Ä¤Î³ÎÊݤò¿Þ¤ëÌÜŪ¤Î¤¿¤á¤Ë¡¢Åö¼Ò¤ª¤¤¤ÆÍøÍѤ¹¤ë¤³¤È¤¬¤Ç¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ |
|---|
| 198 | 3. Åö¼Ò¤Ï¡¢²ñ°÷¤ËÂФ·¤Æ¡¢¥á¡¼¥ë¥Þ¥¬¥¸¥ó¤½¤Î¾¤ÎÊýË¡¤Ë¤è¤ë¾ðÊóÄ󶡡ʹ¹ð¤ò´Þ¤ß¤Þ¤¹¡Ë¤ò¹Ô¤¦¤³¤È¤¬¤Ç¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡£²ñ°÷¤¬¾ðÊóÄ󶡤ò´õ˾¤·¤Ê¤¤¾ì¹ç¤Ï¡¢Åö¼Ò½êÄê¤ÎÊýË¡¤Ë½¾¤¤¡¢¤½¤Î»Ý¤òÄÌÃΤ·¤ÆÄº¤±¤ì¤Ð¡¢¾ðÊóÄ󶡤òÄä»ß¤·¤Þ¤¹¡£¤¿¤À¤·¡¢ËÜ¥µ¡¼¥Ó¥¹±¿±Ä¤ËɬÍפʾðÊóÄ󶡤ˤĤ¤Þ¤·¤Æ¤Ï¡¢²ñ°÷¤Î´õ˾¤Ë¤è¤êÄä»ß¤ò¤¹¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£', |
|---|
| 199 | 7,0,Now(),0); |
|---|
| 200 | |
|---|
| 201 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 202 | VALUES ('Â裷¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£ |
|---|
| 203 | |
|---|
| 204 | 1. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È |
|---|
| 205 | 2. Åö¼Ò¡¢¤ª¤è¤Ó¤½¤Î¾¤ÎÂè»°¼Ô¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤ò»¤Í¤ë¤³¤È |
|---|
| 206 | 3. Àľ¯Ç¯¤Î¿´¿È¤Ë°±Æ¶Á¤òµÚ¤Ü¤¹¶²¤ì¤¬¤¢¤ë¹Ô°Ù¡¢¤½¤Î¾¸ø½øÎɯ¤ËÈ¿¤¹¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È |
|---|
| 207 | 4. ¾¤ÎÍøÍѼԤ½¤Î¾¤ÎÂè»°¼Ô¤ËÌÂÏǤȤʤë¹Ô°Ù¤äÉÔ²÷´¶¤òÊú¤«¤»¤ë¹Ô°Ù¤ò¹Ô¤¦¤³¤È |
|---|
| 208 | 5. µõµ¶¤Î¾ðÊó¤òÆþÎϤ¹¤ë¤³¤È |
|---|
| 209 | 6. ͳ²¤Ê¥³¥ó¥Ô¥å¡¼¥¿¥×¥í¥°¥é¥à¡¢¥á¡¼¥ëÅù¤òÁ÷¿®¤Þ¤¿¤Ï½ñ¤¹þ¤à¤³¤È |
|---|
| 210 | 7. Åö¼Ò¤Î¥µ¡¼¥Ð¤½¤Î¾¤Î¥³¥ó¥Ô¥å¡¼¥¿¤ËÉÔÀµ¤Ë¥¢¥¯¥»¥¹¤¹¤ë¤³¤È |
|---|
| 211 | 8. ¥Ñ¥¹¥ï¡¼¥É¤òÂè»°¼Ô¤ËÂßÍ¿¡¦¾ùÅϤ¹¤ë¤³¤È¡¢¤Þ¤¿¤ÏÂè»°¼Ô¤È¶¦ÍѤ¹¤ë¤³¤È |
|---|
| 212 | 9. ¤½¤Î¾Åö¼Ò¤¬ÉÔŬÀÚ¤ÈȽÃǤ¹¤ë¤³¤È', |
|---|
| 213 | 6,0,Now(),0); |
|---|
| 214 | |
|---|
| 215 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 216 | VALUES ('Â裸¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²Ôư¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£ |
|---|
| 217 | (1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç |
|---|
| 218 | (2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç |
|---|
| 219 | (3)²ÐºÒ¡¢ÄäÅÅ¡¢Âè»°¼Ô¤Ë¤è¤ë˸³²¹Ô°Ù¤Ê¤É¤Ë¤è¤ê¥·¥¹¥Æ¥à¤Î±¿ÍѤ¬º¤Æñ¤Ë¤Ê¤Ã¤¿¾ì¹ç |
|---|
| 220 | (4)¤½¤Î¾¡¢»ß¤à¤òÆÀ¤º¥·¥¹¥Æ¥à¤ÎÄä»ß¤¬É¬ÍפÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç', |
|---|
| 221 | 5,0,Now(),0); |
|---|
| 222 | |
|---|
| 223 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 224 | VALUES ('Â裹¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ¤ë¤â¤Î¤È¤·¤Þ¤¹¡£', |
|---|
| 225 | 4,0,Now(),0); |
|---|
| 226 | |
|---|
| 227 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 228 | VALUES ('Âè10¾ò¡ÊÌÈÀÕ¡Ë','1. ÄÌ¿®²óÀþ¤ä¥³¥ó¥Ô¥å¡¼¥¿¤Ê¤É¤Î¾ã³²¤Ë¤è¤ë¥·¥¹¥Æ¥à¤ÎÃæÃÇ¡¦ÃÙÂÚ¡¦Ãæ»ß¡¦¥Ç¡¼¥¿¤Î¾Ã¼º¡¢¥Ç¡¼¥¿¤Ø¤ÎÉÔÀµ¥¢¥¯¥»¥¹¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¡¢¤½¤Î¾Åö¼Ò¤Î¥µ¡¼¥Ó¥¹¤Ë´Ø¤·¤Æ²ñ°÷¤ËÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉé¤ï¤Ê¤¤¤â¤Î¤È¤·¤Þ¤¹¡£ |
|---|
| 229 | 2. Åö¼Ò¤Ï¡¢Åö¼Ò¤Î¥¦¥§¥Ö¥Ú¡¼¥¸¡¦¥µ¡¼¥Ð¡¦¥É¥á¥¤¥ó¤Ê¤É¤«¤éÁ÷¤é¤ì¤ë¥á¡¼¥ë¡¦¥³¥ó¥Æ¥ó¥Ä¤Ë¡¢¥³¥ó¥Ô¥å¡¼¥¿¡¦¥¦¥£¥ë¥¹¤Ê¤É¤Îͳ²¤Ê¤â¤Î¤¬´Þ¤Þ¤ì¤Æ¤¤¤Ê¤¤¤³¤È¤òÊݾڤ¤¤¿¤·¤Þ¤»¤ó¡£ |
|---|
| 230 | 3. ²ñ°÷¤¬Ëܵ¬ÌóÅù¤Ë°ãÈ¿¤·¤¿¤³¤È¤Ë¤è¤Ã¤ÆÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¤Ï¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£', |
|---|
| 231 | 3,0,Now(),0); |
|---|
| 232 | |
|---|
| 233 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 234 | VALUES ('Âè11¾ò¡ÊËܵ¬Ìó¤Î²þÄê¡Ë','Åö¼Ò¤Ï¡¢Ëܵ¬Ìó¤òǤ°Õ¤Ë²þÄê¤Ç¤¤ë¤â¤Î¤È¤·¡¢¤Þ¤¿¡¢Åö¼Ò¤Ë¤ª¤¤¤ÆËܵ¬Ìó¤òÊä½¼¤¹¤ëµ¬Ìó¡Ê°Ê²¼¡ÖÊä½¼µ¬Ìó¡×¤È¤¤¤¤¤Þ¤¹¡Ë¤òÄê¤á¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£Ëܵ¬Ìó¤Î²þÄê¤Þ¤¿¤ÏÊä½¼¤Ï¡¢²þÄê¸å¤ÎËܵ¬Ìó¤Þ¤¿¤ÏÊä½¼µ¬Ìó¤òÅö¼Ò½êÄê¤Î¥µ¥¤¥È¤Ë·Ç¼¨¤·¤¿¤È¤¤Ë¤½¤Î¸úÎϤòÀ¸¤¸¤ë¤â¤Î¤È¤·¤Þ¤¹¡£¤³¤Î¾ì¹ç¡¢²ñ°÷¤Ï¡¢²þÄê¸å¤Îµ¬Ì󤪤è¤ÓÊä½¼µ¬Ìó¤Ë½¾¤¦¤â¤Î¤ÈÃפ·¤Þ¤¹¡£', |
|---|
| 235 | 2,0,Now(),0); |
|---|
| 236 | |
|---|
| 237 | INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, delete) |
|---|
| 238 | VALUES ('Âè12¾ò¡Ê½àµòË¡¡¢´É³íºÛȽ½ê¡Ë','Ëܵ¬Ìó¤Ë´Ø¤·¤ÆÊ¶Á褬À¸¤¸¤¿¾ì¹ç¡¢Åö¼ÒËÜŹ½êºßÃϤò´É³í¤¹¤ëÃÏÊýºÛȽ½ê¤òÂè°ì¿³¤ÎÀì°Ū¹ç°Õ´É³íºÛȽ½ê¤È¤·¤Þ¤¹¡£ ', |
|---|
| 239 | 1,0,Now(),0); |
|---|
| 240 | |
|---|