Changeset 11769
- Timestamp:
- 2007/03/12 11:34:38 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/install/sql/insert_data.sql
r11716 r11769 364 364 365 365 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 366 VALUES ('Âè £±¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£366 VALUES ('Âè1¾ò¡Ê²ñ°÷¡Ë','1. ¡Ö²ñ°÷¡×¤È¤Ï¡¢Åö¼Ò¤¬Äê¤á¤ë¼ê³¤Ë½¾¤¤Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢Æþ²ñ¤Î¿½¤·¹þ¤ß¤ò¹Ô¤¦¸Ä¿Í¤ò¤¤¤¤¤Þ¤¹¡£ 367 367 2. ¡Ö²ñ°÷¾ðÊó¡×¤È¤Ï¡¢²ñ°÷¤¬Åö¼Ò¤Ë³«¼¨¤·¤¿²ñ°÷¤Î°À¤Ë´Ø¤¹¤ë¾ðÊ󤪤è¤Ó²ñ°÷¤Î¼è°ú¤Ë´Ø¤¹¤ëÍúÎòÅù¤Î¾ðÊó¤ò¤¤¤¤¤Þ¤¹¡£ 368 368 3. Ëܵ¬Ìó¤Ï¡¢¤¹¤Ù¤Æ¤Î²ñ°÷¤ËŬÍѤµ¤ì¡¢ÅÐÏ¿¼ê³»þ¤ª¤è¤ÓÅÐÏ¿¸å¤Ë¤ª¼é¤ê¤¤¤¿¤À¤¯µ¬Ìó¤Ç¤¹¡£', … … 370 370 371 371 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 372 VALUES ('Âè £²¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê372 VALUES ('Âè2¾ò¡ÊÅÐÏ¿¡Ë','1. ²ñ°÷»ñ³Ê 373 373 Ëܵ¬Ìó¤ËƱ°Õ¤Î¾å¡¢½êÄê¤ÎÆþ²ñ¿½¹þ¤ß¤ò¤µ¤ì¤¿¤ªµÒÍͤϡ¢½êÄê¤ÎÅÐÏ¿¼ê³´°Î»¸å¤Ë²ñ°÷¤È¤·¤Æ¤Î»ñ³Ê¤òͤ·¤Þ¤¹¡£²ñ°÷ÅÐÏ¿¼ê³¤Ï¡¢²ñ°÷¤È¤Ê¤ë¤´Ëܿͤ¬¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£ÂåÍý¤Ë¤è¤ëÅÐÏ¿¤Ï°ìÀÚǧ¤á¤é¤ì¤Þ¤»¤ó¡£¤Ê¤ª¡¢²áµî¤Ë²ñ°÷»ñ³Ê¤¬¼è¤ê¾Ã¤µ¤ì¤¿Êý¤ä¤½¤Î¾Åö¼Ò¤¬Áê±þ¤·¤¯¤Ê¤¤¤ÈȽÃǤ·¤¿Êý¤«¤é¤Î²ñ°÷¿½¹þ¤Ï¤ªÃǤꤹ¤ë¾ì¹ç¤¬¤¢¤ê¤Þ¤¹¡£ 374 374 … … 383 383 384 384 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 385 VALUES ('Âè £³¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£385 VALUES ('Âè3¾ò¡ÊÊѹ¹¡Ë','1. ²ñ°÷¤Ï¡¢»á̾¡¢½»½ê¤Ê¤ÉÅö¼Ò¤ËÆϤ±½Ð¤¿»ö¹à¤ËÊѹ¹¤¬¤¢¤Ã¤¿¾ì¹ç¤Ë¤Ï¡¢Â®¤ä¤«¤ËÅö¼Ò¤ËÏ¢Íí¤¹¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ 386 386 2. Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤Ê¤«¤Ã¤¿¤³¤È¤Ë¤è¤êÀ¸¤¸¤¿Â»³²¤Ë¤Ä¤¤¤Æ¡¢Åö¼Ò¤Ï°ìÀÚÀÕǤ¤òÉ餤¤Þ¤»¤ó¡£¤Þ¤¿¡¢Êѹ¹ÅÐÏ¿¤¬¤Ê¤µ¤ì¤¿¾ì¹ç¤Ç¤â¡¢Êѹ¹ÅÐÏ¿Á°¤Ë¤¹¤Ç¤Ë¼ê³¤¬¤Ê¤µ¤ì¤¿¼è°ú¤Ï¡¢Êѹ¹ÅÐÏ¿Á°¤Î¾ðÊó¤Ë´ð¤Å¤¤¤Æ¹Ô¤ï¤ì¤Þ¤¹¤Î¤Ç¤´Ãí°Õ¤¯¤À¤µ¤¤¡£', 387 387 10,0,Now(),0, now()); 388 388 389 389 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 390 VALUES ('Âè £´¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£',390 VALUES ('Âè4¾ò¡ÊÂà²ñ¡Ë','²ñ°÷¤¬Âà²ñ¤ò´õ˾¤¹¤ë¾ì¹ç¤Ë¤Ï¡¢²ñ°÷Ëܿͤ¬Âà²ñ¼ê³¤¤ò¹Ô¤Ã¤Æ¤¯¤À¤µ¤¤¡£½êÄê¤ÎÂà²ñ¼ê³¤Î½ªÎ»¸å¤Ë¡¢Âà²ñ¤È¤Ê¤ê¤Þ¤¹¡£', 391 391 9,0,Now(),0, now()); 392 392 393 393 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 394 VALUES ('Âè £µ¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤¤ë¤³¤È¤È¤·¤Þ¤¹¡£394 VALUES ('Âè5¾ò¡Ê²ñ°÷»ñ³Ê¤ÎÁÓ¼ºµÚ¤ÓÇå½þµÁ̳¡Ë','1. ²ñ°÷¤¬¡¢²ñ°÷»ñ³Ê¼èÆÀ¿½¹þ¤ÎºÝ¤Ëµõµ¶¤Î¿½¹ð¤ò¤·¤¿¤È¤¡¢ÄÌ¿®ÈÎÇä¤Ë¤è¤ëÂå¶â»ÙʧºÄ̳¤òÂդ俤Ȥ¡¢¤½¤Î¾Åö¼Ò¤¬²ñ°÷¤È¤·¤ÆÉÔŬÅö¤Èǧ¤á¤ë»öͳ¤¬¤¢¤ë¤È¤¤Ï¡¢Åö¼Ò¤Ï¡¢²ñ°÷»ñ³Ê¤ò¼è¤ê¾Ã¤¹¤³¤È¤¬¤Ç¤¤ë¤³¤È¤È¤·¤Þ¤¹¡£ 395 395 2. ²ñ°÷¤¬¡¢°Ê²¼¤Î³Æ¹æ¤ËÄê¤á¤ë¹Ô°Ù¤ò¤·¤¿¤È¤¤Ï¡¢¤³¤ì¤Ë¤è¤êÅö¼Ò¤¬Èï¤Ã¤¿Â»³²¤òÇå½þ¤¹¤ëÀÕǤ¤òÉ餤¤Þ¤¹¡£ 396 396 (1)²ñ°÷Èֹ桢¥Ñ¥¹¥ï¡¼¥É¤òÉÔÀµ¤ËÍøÍѤ¹¤ë¤³¤È … … 401 401 402 402 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 403 VALUES ('Âè £¶¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡£403 VALUES ('Âè6¾ò¡Ê²ñ°÷¾ðÊó¤Î¼è°·¤¤¡Ë','1. Åö¼Ò¤Ï¡¢¸¶Â§¤È¤·¤Æ²ñ°÷¾ðÊó¤ò²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯Âè»°¼Ô¤ËÂФ·¤Æ³«¼¨¤¹¤ë¤³¤È¤Ï¤¢¤ê¤Þ¤»¤ó¡£¤¿¤À¤·¡¢¼¡¤Î³Æ¹æ¤Î¾ì¹ç¤Ë¤Ï¡¢²ñ°÷¤Î»öÁ°¤ÎƱ°Õ¤Ê¤¯¡¢Åö¼Ò¤Ï²ñ°÷¾ðÊ󤽤ξ¤Î¤ªµÒÍ;ðÊó¤ò³«¼¨¤Ç¤¤ë¤â¤Î¤È¤·¤Þ¤¹¡£ 404 404 (1)Ë¡Îá¤Ë´ð¤Å¤³«¼¨¤òµá¤á¤é¤ì¤¿¾ì¹ç 405 405 (2)Åö¼Ò¤Î¸¢Íø¡¢Íø±×¡¢Ì¾ÍÀÅù¤òÊݸ¤ë¤¿¤á¤ËɬÍפǤ¢¤ë¤ÈÅö¼Ò¤¬È½ÃǤ·¤¿¾ì¹ç … … 409 409 410 410 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 411 VALUES ('Âè £·¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£411 VALUES ('Âè7¾ò¡Ê¶Ø»ß»ö¹à¡Ë','ËÜ¥µ¡¼¥Ó¥¹¤ÎÍøÍѤ˺ݤ·¤Æ¡¢²ñ°÷¤ËÂФ·¼¡¤Î³Æ¹æ¤Î¹Ô°Ù¤ò¹Ô¤¦¤³¤È¤ò¶Ø»ß¤·¤Þ¤¹¡£ 412 412 413 413 1. Ë¡Îá¤Þ¤¿¤ÏËܵ¬Ìó¡¢ËÜ¥µ¡¼¥Ó¥¹¤´ÍøÍѾå¤Î¤´Ãí°Õ¡¢ËÜ¥µ¡¼¥Ó¥¹¤Ç¤Î¤ªÇ㤤ʪ¾å¤Î¤´Ãí°Õ¤½¤Î¾¤ÎËܵ¬ÌóÅù¤Ë°ãÈ¿¤¹¤ë¤³¤È … … 423 423 424 424 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 425 VALUES ('Âè £¸¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£425 VALUES ('Âè8¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÃæÃÇ¡¦Ää»ßÅù¡Ë','1. Åö¼Ò¤Ï¡¢ËÜ¥µ¡¼¥Ó¥¹¤Î²ÔÆ°¾õÂÖ¤òÎɹ¥¤ËÊݤĤ¿¤á¤Ë¡¢¼¡¤Î³Æ¹æ¤Î°ì¤Ë³ºÅö¤¹¤ë¾ì¹ç¡¢Í½¹ð¤Ê¤·¤Ë¡¢ËÜ¥µ¡¼¥Ó¥¹¤ÎÄó¶¡Á´¤Æ¤¢¤ë¤¤¤Ï°ìÉô¤òÄä»ß¤¹¤ë¤³¤È¤¬¤¢¤ê¤Þ¤¹¡£ 426 426 (1)¥·¥¹¥Æ¥à¤ÎÄê´üÊݼ餪¤è¤Ó¶ÛµÞÊݼé¤Î¤¿¤á¤ËɬÍפʾì¹ç 427 427 (2)¥·¥¹¥Æ¥à¤ËÉé²Ù¤¬½¸Ã椷¤¿¾ì¹ç … … 431 431 432 432 INSERT INTO dtb_kiyaku (kiyaku_title, kiyaku_text, rank, creator_id, update_date, del_flg, create_date) 433 VALUES ('Âè £¹¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ¤ë¤â¤Î¤È¤·¤Þ¤¹¡£',433 VALUES ('Âè9¾ò¡Ê¥µ¡¼¥Ó¥¹¤ÎÊѹ¹¡¦ÇѻߡË','Åö¼Ò¤Ï¡¢¤½¤ÎȽÃǤˤè¤ê¥µ¡¼¥Ó¥¹¤ÎÁ´Éô¤Þ¤¿¤Ï°ìÉô¤ò»öÁ°¤ÎÄÌÃΤʤ¯¡¢Å¬µ¹Êѹ¹¡¦ÇѻߤǤ¤ë¤â¤Î¤È¤·¤Þ¤¹¡£', 434 434 4,0,Now(),0, now()); 435 435
Note: See TracChangeset
for help on using the changeset viewer.