TRUNCATE t_pref;

INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (1, '北海道',1);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (2, '青森県',2);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (3, '岩手県',3);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (4, '宮城県',4);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (5, '秋田県',5);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (6, '山形県',6);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (7, '福島県',7);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (8, '茨城県',8);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (9, '栃木県',9);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (10, '群馬県',10);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (11, '埼玉県',11);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (12, '千葉県',12);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (13, '東京都',13);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (14, '神奈川県',14);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (15, '新潟県',15);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (16, '富山県',16);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (17, '石川県',17);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (18, '福井県',18);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (19, '山梨県',19);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (20, '長野県',20);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (21, '岐阜県',21);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (22, '静岡県',22);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (23, '愛知県',23);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (24, '三重県',24);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (25, '滋賀県',25);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (26, '京都府',26);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (27, '大阪府',27);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (28, '兵庫県',28);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (29, '奈良県',29);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (30, '和歌山県',30);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (31, '鳥取県',31);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (32, '島根県',32);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (33, '岡山県',33);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (34, '広島県',34);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (35, '山口県',35);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (36, '徳島県',36);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (37, '香川県',37);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (38, '愛媛県',38);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (39, '高知県',39);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (40, '福岡県',40);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (41, '佐賀県',41);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (42, '長崎県',42);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (43, '熊本県',43);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (44, '大分県',44);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (45, '宮崎県',45);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (46, '鹿児島県',46);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (47, '沖縄県',47);
INSERT INTO t_pref (prefcd, prefnm, disppriority) VALUES (48, 'その他',48);