³«»Ï ¡¡2003/08/19 ô ¡§ÃÓÅÄ // ½ª¹¹¿· 2004/04/30¡¡ ¹¹¥á¡§»³ ½ª¹¹¿· 2004/05/02¡¡ ¹¹¥á¡§ÃÓÅÄ ¥Þ¥Ë¥Õ¥§¥¹¥È ¥·¥¹¥Æ ¥Ç¡¼¥¿¥Ù¡¼¥¹:manifest DB ¥¹¡¼¥Ñ¡¼ ¡¼¥¶ ¹Ô ¡Ê postgres¡Ë¡§ createdb -E EUC_JP manifest cd /var/lib/pgsql/data/ pg_passwd passwd postgres koumeidb pg_passwd passwd nobody koumeidb pg_passwd passwd manifest koumeidb createuser manifest n, n koumeidb drop table advertisement, m_category1, m_category2, m_category3, paper1, bbs, message , m_user , bbs_category, m_paragraph_text,m_paragraph_img,m_paragraph_val,m_alert CREATE TABLE m_org( org_id text, org_name text, url text, prefecture text, address1 text, address2 text, tel text, fax text, mobile text, email text ); /* ¥æ¡¼¥¶¥Þ¥¹¥¿¡¼ */ CREATE TABLE m_user( user_number text PRIMARY KEY, user_id text NOT NULL UNIQUE, user_name text NOT NULL, pen_name text, user_password text NOT NULL, name_kana text, familyname text, firstname text, pen_name_e text, group_name text, station text, post text, hp_url text, sex bool DEFAULT TRUE, birth1 int, birth2 int, birth3 int, age int, email_pc text, email_keitai text, yubin1 text, yubin2 text, address1 text, address2 text, address3 text, tel1 text, tel2 text, tel3 text, fax1 text, fax2 text, fax3 text, keitai1 text, keitai2 text, keitai3 text, introduction text, constituency1 text, constituency2 text, mail_chk bool DEFAULT FALSE, author_chk bool NOT NULL DEFAULT TRUE, contributor_chk bool NOT NULL DEFAULT FALSE, admin_chk bool NOT NULL DEFAULT FALSE, author_user_id text, domain text, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, maketime text , group_id int, permission int, role int, rank int, introduceup1 text, introduceup2 text, introduceup3 text, introduceup4 text, introduceup5 text, introducedown1 text, introducedown2 text, introducedown3 text, introducedown4 text, introducedown5 text, result bool, remarks text, datafrom text, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, keisyo text, url text, addressforcompany text, telforcompany text, faxforcompany text, mobileforcompany text, mailforcompany text, org_id1 int, org_id2 int, agent1 int, agent2 int, agent3 int, agent4 int, agent5 int ); /* ¥¢¥Ê¥¦¥ó¥¹¥á¡¼¥ëÇÛ¿® */ CREATE TABLE mailmag ( paper_id text PRIMARY KEY, paper_title text NOT NULL, author_id text NOT NULL, year varchar(4) NOT NULL DEFAULT to_char((('now'::text)::date)::timestamp with time zone, 'yyyy'::text), summary text, keyword text, sql_list text, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, status int4, FOREIGN KEY (author_id) REFERENCES m_user_kihon (user_number) ) ; CREATE TABLE meibo_kanri ( kanri_id text, user_id text ); CREATE TABLE usertype ( type_id int4, type_name text ); CREATE TABLE userkengen ( type_id int4, category1_id text, kengen_id int4 ); /* Áªµó¾ðÊó */ CREATE TABLE election ( election_id text NOT NULL, divisions text, eleobject text, kinds text, elestart text, eleend text, termof text, reason text, members int4, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, lasttime text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* Áªµó¾ðÊó¾ÜºÙ */ CREATE TABLE election_data ( user_id text NOT NULL, election_id text NOT NULL, constituency1 text, constituency2 text, proportion text, ranking text, party text, recommend1 text, recommend2 text, recommend3 text, elected text, votes text, total int4, votesrank int4, kind text, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, lasttime text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¥«¥Æ¥´¥ê¥Þ¥¹¥¿¡¼Âç */ CREATE TABLE m_category1 ( category1_id text PRIMARY KEY, category1_title text NOT NULL UNIQUE, permission text, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¥«¥Æ¥´¥ê¥Þ¥¹¥¿¡¼Ãæ */ CREATE TABLE m_category2 ( category1_id text, category2_id text, category2_title text NOT NULL UNIQUE, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, CONSTRAINT m_category2_pkey PRIMARY KEY (category1_id, category2_id), CONSTRAINT m_category2_fkey FOREIGN KEY (category1_id) REFERENCES m_category1 (category1_id) ) ; /* ¥«¥Æ¥´¥ê¥Þ¥¹¥¿¡¼¾® */ CREATE TABLE m_category3 ( category1_id text, category2_id text, category3_id text, category3_title text NOT NULL UNIQUE, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, CONSTRAINT m_category3_pkey PRIMARY KEY (category1_id, category2_id, category3_id), CONSTRAINT m_category3_fkey FOREIGN KEY (category1_id, category2_id) REFERENCES m_category2 (category1_id, category2_id) ) ; /* ¿Æµ­»öÊݸ¥Æ¡¼¥Ö¥ë */ CREATE TABLE paper1 ( paper_id text PRIMARY KEY, paper_title text NOT NULL, contributor_id text NOT NULL, author_id text NOT NULL, year varchar(4) NOT NULL DEFAULT to_char((('now'::text)::date)::timestamp with time zone, 'yyyy'::text), summary text, keyword text, paper_order int NOT NULL, paper_mark bool NOT NULL DEFAULT FALSE, category1_id text, category2_id text, category3_id text, paper_code text UNIQUE, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, last_time text NOT NULL, history_flg int, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, CONSTRAINT paper1_f1key FOREIGN KEY (category1_id) REFERENCES m_category1 (category1_id), CONSTRAINT paper1_f2key FOREIGN KEY (category1_id, category2_id) REFERENCES m_category2 (category1_id, category2_id), CONSTRAINT paper1_f3key FOREIGN KEY (category1_id, category2_id, category3_id) REFERENCES m_category3 (category1_id, category2_id, category3_id), CONSTRAINT paper1_f4key FOREIGN KEY (author_id) REFERENCES m_user_kihon (user_number), CONSTRAINT paper1_f5key FOREIGN KEY (contributor_id) REFERENCES m_user_kihon (user_number) ) ; /* ¥³¥á¥ó¥ÈÊÖ¿®¥«¥Æ¥´¥ê¥Þ¥¹¥¿¡¼ */ CREATE TABLE bbs_category ( category1_id text PRIMARY KEY, category1_title text NOT NULL UNIQUE, del bool NOT NULL DEFAULT FALSE, time text NOT NULL, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¾ÜºÙ¥Æ¥­¥¹¥ÈÊݸ¥Æ¡¼¥Ö¥ë */ CREATE TABLE m_paragraph_text( paragraph_id int NOT NULL, paper_id int NOT NULL, paragraph_title varchar(200) NOT NULL, order_no int NOT NULL, paragraph_text text, del bool NOT NULL, createdate timestamp NOT NULL, updatedate timestamp NOT NULL, PRIMARY KEY (paper_id,paragraph_id), other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ²èÁü¾ðÊóÊݸ¥Æ¡¼¥Ö¥ë */ CREATE TABLE m_paragraph_img( paragraph_id int NOT NULL, paper_id int NOT NULL, paragraph_title varchar(200) NOT NULL, order_no int2 NOT NULL, img1 varchar(100), img2 varchar(100), img3 varchar(100), img4 varchar(100), img5 varchar(100), comment1 varchar(50), comment2 varchar(50), comment3 varchar(50), comment4 varchar(50), comment5 varchar(50), url1 varchar(50), url2 varchar(50), url3 varchar(50), url4 varchar(50), url5 varchar(50), width1 int, width2 int, width3 int, width4 int, width5 int, height1 int, height2 int, height3 int, height4 int, height5 int, dsp_flg varchar(1), del bool NOT NULL, createdate timestamp NOT NULL, updatedate timestamp NOT NULL, PRIMARY KEY (paper_id,paragraph_id), other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¿ôÃÍÊݸ¥Æ¡¼¥Ö¥ë */ CREATE TABLE m_paragraph_val( paragraph_id int NOT NULL, paper_id int NOT NULL, paragraph_title varchar(200) NOT NULL, order_no int2 NOT NULL, minVal int, maxVal int, unit varchar(10), del bool NOT NULL, createdate timestamp NOT NULL, updatedate timestamp NOT NULL, PRIMARY KEY (paper_id,paragraph_id), other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¹­¹ð¥Æ¡¼¥Ö¥ë */ CREATE TABLE advertisement ( class VARCHAR(3) NOT NULL, id int PRIMARY KEY, level VARCHAR(2) NOT NULL, valid BOOLEAN NOT NULL DEFAULT TRUE, ad_start DATE NOT NULL, ad_end DATE NOT NULL, ad_text TEXT, link TEXT NOT NULL, memo TEXT NOT NULL , other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /*¡¡£Â£Â£Ó¾ðÊ󥤥ó¥Ç¥Ã¥¯¥¹¥Æ¡¼¥Ö¥ë¡¡*/ CREATE TABLE bbs ( bbs_id TEXT PRIMARY KEY, title TEXT NOT NULL, user_id TEXT NOT NULL ) ; /* £Â£Â£Ó¾ðÊó¾ÜºÙ¥Æ¡¼¥Ö¥ë */ CREATE TABLE message ( server_id TEXT NOT NULL, bbs_id TEXT NOT NULL, message_id TEXT PRIMARY KEY, parent_id TEXT NOT NULL, child_id TEXT NOT NULL, timestamp TIMESTAMP NOT NULL, user_id TEXT NOT NULL, title TEXT NOT NULL, text TEXT NOT NULL, user_name TEXT, bbs_category text, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text ) ; /* ¥¢¥é¡¼¥È¥Æ¡¼¥Ö¥ë */ CREATE TABLE m_alert( user_id text NOT NULL, alert_no int4 NOT NULL, alert_type int4, alert_type2 int4, category1_id int4, user_name varchar(100), key_word varchar(20), yoteibi_flag varchar(1), word_num int4, last_time timestamp default CURRENT_TIMESTAMP, createtime timestamp default CURRENT_TIMESTAMP, other1 text, other2 text, other3 text, other4 text, other5 text, other6 text, other7 text, other8 text, other9 text, PRIMARY KEY (user_id,alert_no) ); CREATE VIEW mu_p1_view AS SELECT * FROM m_user WHERE user_id NOT IN (SELECT author_id FROM paper1) AND del = 'f' AND admin_chk = 'f' AND author_chk = 'f' AND contributor_chk = 't' ; /* ÅÔÆ»Éܸ©¥Æ¡¼¥Ö¥ë¡Ê»ÈÍѤ·¤Æ¤¤¤Ê¤¤¡Ë */ CREATE TABLE test_for_bunseki ( address1_id text PRIMARY KEY, address1_name text NOT NULL ) ; /* ¸¢¸ÂÊѹ¹£± */ REVOKE ALL PRIVILEGES ON advertisement, m_category1, m_category2, m_category3, m_user, paper1, paper2, mu_p1_view, bbs, message FROM manifest ; /* ¸¢¸ÂÊѹ¹£² */ GRANT all ON m_user, paper1, advertisement, m_category1, m_category2, m_category3, bbs, message, m_alert, m_paragraph_img, m_paragraph_text, m_paragraph_val, bbs_category TO manifest; GRANT all ON m_user, paper1, advertisement, m_category1, m_category2, m_category3, bbs, message, m_alert, m_paragraph_img, m_paragraph_text, m_paragraph_val TO manifest; ³Îǧ psql -d manifest postgres-password \z ¡¼¥¶manifest psql -d manifest -U manifest manifest-password \d [ ¡¼¥¶¥Þ¥¹¥¿ ɬÍ× ] INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('t-mizuno',' ů ','koumei','','t','0','0','0','0','','','','1','','','','','','','','','090','3064','4702','1','','','','f','f','t','f','','','f','1064244486','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('other',' ','di4kyd9q',' ','t','0','0','0','0','','','','','','','','','','','','','','','','','','','','f','f','t','f','','','f','1063239630','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('adminroot',' ¡¼¥È ¥á','koumei',' ','t','0','0','0','0','','','','','','','','','','','','','','','','','','','','f','f','t','t','','','f','1063406806','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('test','¥Æ¥¹¥È','test',' ','t','2003','9','29','0','info@manife.com','','','14','','','123','456','789','','','','','','','1','1','','www.manife.com','f','f','t','f','','','f','1064847189','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('hide','ÃÓÅıѭ­','aiueo',' ','t','2000','1','23','25','hidekiikeda@pop01.odn.ne.jp','123','4567','14','XX YY ','1-2-3','03','1234','5678','03','9876','5432','090','2345','6789','13','14','¥Æ¥¹¥È ','http://www1.odn.ne.jp/','t','f','t','f','','','f','1064334482','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('hidedairi1','ÃÓÅÄ ¿Í£±','aiueo','','f','0','0','0','0','','','','1','','','111','222','333','','','','','','','1','','','','f','t','t','f','hide','','f','1064337605','','','','','','','','',''); INSERT INTO "m_user" ("user_id","user_name","user_password","name_kana","sex","birth1","birth2","birth3","age","email_pc","yubin1","yubin2","address1","address2","address3","tel1","tel2","tel3","fax1","fax2","fax3","keitai1","keitai2","keitai3","constituency1","constituency2","political_party","hp_url","mail_manife","author_chk","contributor_chk","admin_chk","author_user_id","domain","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('hidedairi2','ÃÓÅÄ ¿Í£²','aiueo','','f','0','0','0','0','','','','1','','','444','555','666','','','','','','','1','','','','f','t','t','f','hide','','f','1064337693','','','','','','','','',''); [ ¥«¥Æ¥´ ¥Þ¥¹¥¿ ɬÍ× ] INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('9999',' ','f','1063229200','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1000',' ','f','1063229201','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1001',' ','f','1063229202','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1002',' ¡¦ ','f','1063229203','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1003',' ','f','1063229204','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1004','·Ð ','f','1063549060','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1005','³° ','f','1063549061','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1006','ÇÀ ','f','1063549062','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1007','¡£ ','f','1063549063','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1008',' ËÉ ','f','1063549064','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1009',' ','f','1063549065','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1010',' ¡¦ ','f','1063549066','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1011','ǯ ','f','1063549067','','','','','','','','',''); INSERT INTO "m_category1" ("category1_id","category1_title","del","time","other1","other2","other3","other4","other5","other6","other7","other8","other9") VALUES('1012','ÃÏ ','f','1063549068','','','','','','','','',''); [ ÍÑÅÔ ÉÜ ¥Þ¥¹¥¿ ɬÍ× ¡ÊËÜ¥·¥¹¥Æ »ÈÍÑ ¡Ë] INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('1',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('2','Ë̳¤ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('3',' ¿¹ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('4',' ¤ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('5','µÜ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('6','½©ÅÄ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('7','»³·Á '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('8',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('9',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('10',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('11','·²ÇÏ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('12',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('13',' ÍÕ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('14',' ÅÔ'); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('15','¿À '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('16','¿· '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('17','ÉÙ»³ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('18',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('19',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('20','»³ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('21',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('22',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('23',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('24',' ÃÎ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('25','»°½Å '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('26','¡¡ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('27',' ÅÔÉÜ'); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('28',' ÉÜ'); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('29',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('30',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('31','Ï »³ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('32',' ɨ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('33',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('34',' »³ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('35','¹­ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('36','»³ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('37',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('38',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('39',' ɲ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('40',' ÃÎ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('41',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('42',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('43',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('44','·§ËÜ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('45',' '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('46','µÜ '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('47','¥åðô '); INSERT INTO "test_for_bunseki" ("address1_id","address1_name") VALUES('48',' ');