--- /dev/null
+----------------------------------------------------------------
+-- ¥Æ¥¹¥È¥Ç¡¼¥¿
+-- $Id: test_data.sql,v 1.7 2006/12/18 07:41:46 w-ota Exp $
+----------------------------------------------------------------
+
+
+-- ¥È¥é¥ó¥¶¥¯¥·¥ç¥ó³«»Ï
+BEGIN;
+
+
+-- ¥Þ¥¤¥Ú¡¼¥¸
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£(¥Þ¥¤¥Ú¡¼¥¸:10)
+COPY community FROM stdin;
+1000 ¥¿¥í¥¦ 10 \N f now f
+1001 ¥¤¥Á¥í¥¦ 10 \N f now f
+1002 ¥¸¥í¥¦ 10 \N f now f
+1003 ¥µ¥Ö¥í¥¦ 10 \N f now f
+1004 ¥·¥í¥¦ 10 \N f now f
+1005 ¥´¥í¥¦ 10 \N f now f
+1010 \N 10 \N f now f
+\.
+
+
+-- ¥Þ¥¤¥Õ¥ì¥ó¥º
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£(¥Þ¥¤¥Õ¥ì¥ó¥º:20)
+COPY community FROM stdin;
+2000 \N 20 \N f now f
+2001 \N 20 \N f now f
+2002 \N 20 \N f now f
+2003 \N 20 \N f now f
+2004 \N 20 \N f now f
+2005 \N 20 \N f now f
+2010 \N 20 \N f now f
+\.
+
+COPY sub_community FROM stdin;
+1000 2000
+1001 2001
+1002 2002
+1003 2003
+1004 2004
+1005 2005
+1010 2010
+\.
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£(¥Þ¥¤¥Õ¥ì¥ó¥º¥°¥ë¡¼¥×:30)
+COPY community FROM stdin;
+3000 ͧ¿Í 30 \N f now f
+3010 ¥Ü¥¹ 30 \N f now f
+\.
+
+COPY sub_community FROM stdin;
+2000 3000
+2000 3010
+\.
+
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£(¥³¥ß¥å¥Ë¥Æ¥£:40)
+COPY community FROM stdin;
+4001 A¸¦µæ¼¼ 40 0001 f 2005/10/10 f
+4002 P¥×¥í¥¸¥§¥¯¥È 40 0005 f 2005/10/10 f
+4003 PostgreSQL 40 0017 t 2005/10/10 f
+4011 XXÊÙ¶¯²ñ 40 0003 f 2005/10/11 f
+4012 YYÊÙ¶¯²ñ 40 0003 f 2005/10/12 f
+\.
+
+-- ¥µ¥Ö¥³¥ß¥å¥Ë¥Æ¥£ÀßÄê
+COPY sub_community FROM stdin;
+4001 4011
+4001 4012
+4002 4012
+\.
+
+-- ¥³¥ó¥Æ¥ó¥Ä
+COPY contents FROM stdin;
+4001 07 ¤³¤³¤ÏA¸¦µæ¼¼¥³¥ß¥å¥Ë¥Æ¥£¤Ç¤¹¡£ 01
+4002 07 ¤³¤³¤ÏP¥×¥í¥¸¥§¥¯¥È¥³¥ß¥å¥Ë¥Æ¥£¤Ç¤¹¡£ 01
+4003 07 ¤³¤³¤ÏPostgreSQL¥³¥ß¥å¥Ë¥Æ¥£¤Ç¤¹¡£ 01
+4011 07 ¤³¤³¤ÏXXÊÙ¶¯²ñ¥³¥ß¥å¥Ë¥Æ¥£¤Ç¤¹¡£ 01
+4012 07 ¤³¤³¤ÏYYÊÙ¶¯²ñ¥³¥ß¥å¥Ë¥Æ¥£¤Ç¤¹¡£ 01
+4001 00 \N 01
+4002 00 \N 01
+4003 00 \N 01
+4011 00 \N 03
+4012 00 \N 03
+4001 31 \N 01
+4002 31 \N 01
+4003 31 \N 02
+4011 31 \N 04
+4012 31 \N 04
+4001 41 \N 01
+4002 41 \N 01
+4003 41 \N 04
+4011 41 \N 04
+4012 41 \N 04
+1000 00 \N 01
+1000 01 »³ÅÄÂÀϺ 02
+1000 02 acs-yamada@xxx.yyy.zz.jp 03
+1000 03 ¾ðÊóʸ²½³ØÉô 01
+1000 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1000 05 °¦ÃÎ 05
+1000 06 1987/01/01 05
+1000 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤ä¤Þ¤À¤Ç¤¹¡£(°ìÈ̸þ¤±) 01
+1000 08 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤ä¤Þ¤À¤Ç¤¹¡£(¥í¥°¥¤¥ó¥æ¡¼¥¶¸þ¤±) 02
+1000 09 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤ä¤Þ¤À¤Ç¤¹¡£(ͧ¿Í¸þ¤±) 05
+1000 11 \N 01
+1001 00 \N 01
+1001 01 ÎëÌÚ°ìϺ 02
+1001 02 acs-suzuki1@xxx.yyy.zz.jp 03
+1001 03 ¾ðÊóʸ²½³ØÉô 01
+1001 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1001 05 °¦ÃÎ 01
+1001 06 1987/01/01 01
+1001 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤¤¤Á¤í¤¦¤Ç¤¹¡£ 01
+1001 08 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤¤¤Á¤í¤¦¤Ç¤¹¡£(¥í¥°¥¤¥ó¥æ¡¼¥¶¸þ¤±) 02
+1001 11 \N 01
+1002 00 \N 01
+1002 01 ÎëÌÚÆóϺ 02
+1002 02 acs-suzuki2@xxx.yyy.zz.jp 03
+1002 03 ¾ðÊóʸ²½³ØÉô 01
+1002 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1002 05 °¦ÃÎ 01
+1002 06 1987/01/01 01
+1002 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤¸¤í¤¦¤Ç¤¹¡£ 01
+1002 08 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤¸¤í¤¦¤Ç¤¹¡£(¥í¥°¥¤¥ó¥æ¡¼¥¶¸þ¤±) 02
+1002 11 \N 01
+1003 00 \N 01
+1003 01 ÎëÌÚ»°Ïº 02
+1003 02 acs-suzuki3@xxx.yyy.zz.jp 03
+1003 03 ¾ðÊóʸ²½³ØÉô 01
+1003 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1003 05 °¦ÃÎ 01
+1003 06 1987/01/01 01
+1003 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤µ¤Ö¤í¤¦¤Ç¤¹¡£ 01
+1003 11 \N 01
+1004 00 \N 01
+1004 01 ÎëÌÚ»ÍϺ 02
+1004 02 acs-suzuki4@xxx.yyy.zz.jp 04
+1004 03 ¾ðÊóʸ²½³ØÉô 01
+1004 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1004 05 °¦ÃÎ 01
+1004 06 1987/01/01 01
+1004 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤·¤í¤¦¤Ç¤¹¡£ 01
+1004 11 \N 01
+1005 00 \N 01
+1005 01 ÎëÌÚ¸ÞϺ 02
+1005 02 acs-suzuki5@xxx.yyy.zz.jp 03
+1005 03 ¾ðÊóʸ²½³ØÉô 01
+1005 04 ¼«Á³¾ðÊó³Ø²Ê 01
+1005 05 °¦ÃÎ 03
+1005 06 1987/01/01 03
+1005 07 ¤³¤ó¤Ë¤Á¤Ï¡£\n¤´¤í¤¦¤Ç¤¹¡£ 01
+1005 11 \N 01
+1010 00 \N 03
+1010 01 º´Æ£Èó¸ø³«ÂÀϺ 02
+1010 02 acs-satou@xxx.yyy.zz.jp 03
+1010 11 \N 01
+\.
+
+
+-- ¥³¥ó¥Æ¥ó¥Ä ¿®ÍêºÑ¤ß¥³¥ß¥å¥Ë¥Æ¥£
+COPY contents_trusted_community FROM stdin;
+1000 05 05 3000
+1000 05 05 3010
+1000 06 05 2000
+\.
+
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£¥á¥ó¥Ð(¥Þ¥¤¥Õ¥ì¥ó¥º)
+COPY community_member FROM stdin;
+2000 1001 \N
+2000 1002 \N
+2000 1003 \N
+2000 1004 \N
+2001 1000 \N
+2001 1005 \N
+2002 1000 \N
+2003 1000 \N
+2004 1000 \N
+2005 1001 \N
+\.
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£¥á¥ó¥Ð(¥Þ¥¤¥Õ¥ì¥ó¥º¤Î¥°¥ë¡¼¥×)
+COPY community_member FROM stdin;
+3000 1002 \N
+3000 1003 \N
+3010 1004 \N
+\.
+
+-- ¥³¥ß¥å¥Ë¥Æ¥£¥á¥ó¥Ð(°ìÈÌ¥³¥ß¥å¥Ë¥Æ¥£)
+COPY community_member FROM stdin;
+4001 1000 10
+4001 1001 20
+4001 1002 20
+4001 1003 20
+4002 1003 10
+4002 1000 20
+4003 1001 10
+4003 1002 10
+4003 1003 20
+4011 1000 10
+4011 1003 20
+4012 1004 10
+\.
+
+
+-- ¥æ¡¼¥¶¾ðÊó
+COPY user_info FROM stdin;
+yamada 1000 f
+suzuki1 1001 f
+suzuki2 1002 f
+suzuki3 1003 f
+suzuki4 1004 f
+suzuki5 1005 f
+satou 1010 f
+\.
+
+
+-- ¡ú¥À¥¤¥¢¥ê¡¼
+COPY diary FROM stdin;
+10001 1000 ¥Æ¥¹¥ÈÆüµ1 ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµ1¤Ç¤¹¡£\ntest now 01 f
+10002 1000 ¥Æ¥¹¥ÈÆüµ2 ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµ2¤Ç¤¹¡£\ntest now 02 f
+10003 1000 ¥Æ¥¹¥ÈÆüµ3 ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµ3¤Ç¤¹¡£\ntest now 05 f
+10004 1000 ¥Æ¥¹¥ÈÆüµ4 ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµ4¤Ç¤¹¡£\ntest now 03 f
+10011 1001 ¥Æ¥¹¥ÈÆüµA ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµA¤Ç¤¹¡£\ntest now 02 f
+10021 1002 ¥Æ¥¹¥ÈÆüµB ¤³¤ì¤Ï¥Æ¥¹¥ÈÆüµB¤Ç¤¹¡£\ntest now 01 f
+\.
+
+-- ¡ú¥À¥¤¥¢¥ê¡¼¿®ÍêºÑ¤ß
+COPY diary_trusted_community FROM stdin;
+10003 2000
+\.
+
+-- ¡ú¥À¥¤¥¢¥ê¡¼¥³¥á¥ó¥È
+COPY diary_comment FROM stdin;
+10001 10001 1001 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+10002 10001 1003 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+10003 10011 1000 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+10004 10011 1001 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+10005 10011 1002 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+10006 10011 1003 ¤³¤ì¤Ï¥³¥á¥ó¥È¤Ç¤¹¡£ now f
+\.
+
+-- ¡ú·Ç¼¨ÈÄ
+COPY bbs FROM stdin;
+50010 4001 1000 ¥Æ¥¹¥ÈÅê¹Æ ¤³¤ì¤Ï¥Æ¥¹¥È½ñ¤¹þ¤ß¤Ç¤¹¡£\ntest1 now 04 \N f f
+50011 4001 1001 ¥Æ¥¹¥ÈÅê¹Æ2 ¤³¤ì¤Ï¥Æ¥¹¥È½ñ¤¹þ¤ß2¤Ç¤¹¡£\ntest2 now 04 \N f f
+50012 4001 1001 ¥Æ¥¹¥ÈÅê¹Æ3 ¤³¤ì¤Ï¥Æ¥¹¥È½ñ¤¹þ¤ß3¤Ç¤¹¡£\ntest3 2005/01/02 03:04:05 02 \N f f
+50015 4001 1001 ¥Æ¥¹¥È¥Ñ¥Ö¥ê¥Ã¥¯¥ê¥ê¡¼¥¹ ¤³¤ì¤Ï¥Æ¥¹¥È¥Ñ¥Ö¥ê¥Ã¥¯¥ê¥ê¡¼¥¹¤Ç¤¹¡£\ntest now 06 2007-03-31 f f
+50030 4003 1001 ¥Æ¥¹¥ÈÅê¹Æ ¤³¤ì¤Ï¥Æ¥¹¥È½ñ¤¹þ¤ß¤Ç¤¹¡£\ntest now 01 \N f f
+\.
+
+-- ¡ú·Ç¼¨ÈÄÊÖ¿®
+COPY bbs_res FROM stdin;
+50001 50010 1001 Re: ¥Æ¥¹¥ÈÅê¹Æ ¤³¤ì¤ÏÊÖ¿®¤Ç¤¹¡£\nTEST now f
+50002 50010 1002 Re: ¥Æ¥¹¥ÈÅê¹Æ ¤³¤ì¤ÏÊÖ¿®¤Ç¤¹¡£\nTEST now f
+\.
+
+-- ¡ú·Ç¼¨ÈÄ¿®ÍêºÑ¤ß¥³¥ß¥å¥Ë¥Æ¥£
+COPY bbs_trusted_community FROM stdin;
+50011 4011
+50011 4012
+\.
+
+
+-- ¥³¥ß¥Ã¥È
+COMMIT;
OSDN Git Service
