-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 建立日期: 2022 年 04 月 11 日 12:23
-- 伺服器版本: 5.5.62-0ubuntu0.14.04.1
-- PHP 版本: 5.5.9-1ubuntu4.29




-- --------------------------------------------------------

--
-- 資料表結構 `application`
--

CREATE TABLE IF NOT EXISTS `application` (
  `apid` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `dbid` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `authcode` int(11) NOT NULL,
  `status_auth` int(11) NOT NULL,
  `date` bigint(20) NOT NULL,
  `memo` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`apid`),
  UNIQUE KEY `apid` (`apid`),
  KEY `apid_2` (`apid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1147 ;

--
-- 資料表的匯出資料 `application`
--

INSERT INTO `application` (`apid`, `uid`, `dbid`, `pid`, `authcode`, `status_auth`, `date`, `memo`) VALUES
(1001, 1001, 5, 5, 0, 1, 1543282064, ''),
(1002, 1005, 1, 1, 0, 1, 1544096503, ''),
(1003, 1007, 4, 4, 0, 0, 1544096904, ''),
(1004, 1011, 4, 4, 2, 0, 1544097042, ''),
(1005, 1012, 4, 4, 5, 0, 1544097096, ''),
(1007, 1003, 2, 2, 0, 1, 1545107917, ''),
(1008, 1013, 5, 5, 0, 1, 1545627647, ''),
(1011, 1016, 4, 4, 0, 1, 1546918210, ''),
(1013, 1024, 1, 1, 0, 1, 1548415021, ''),
(1014, 1033, 1, 1, 0, 1, 1550797993, ''),
(1015, 1041, 9, 9, 0, 1, 1551924774, ''),
(1016, 1042, 5, 5, 0, 1, 1552316347, ''),
(1017, 1036, 9, 9, 0, 1, 1552316439, ''),
(1018, 1035, 10, 10, 0, 1, 1552316496, ''),
(1019, 1027, 2, 2, 5, 0, 1552316532, ''),
(1020, 1034, 1, 1, 8, 0, 1552441364, ''),
(1021, 1052, 2, 2, 0, 0, 1554088790, ''),
(1023, 1067, 2, 2, 0, 0, 1555037675, ''),
(1024, 1060, 1, 1, 0, 1, 1555565277, ''),
(1025, 1038, 2, 2, 0, 1, 1557112023, ''),
(1026, 1079, 11, 11, 0, 1, 1558057935, ''),
(1027, 1073, 2, 2, 0, 1, 1558058002, ''),
(1028, 1064, 10, 10, 0, 1, 1558661755, ''),
(1029, 1088, 5, 5, 0, 1, 1560219793, ''),
(1030, 1085, 1, 1, 977, 1, 1560219871, ''),
(1031, 1080, 4, 4, 0, 1, 1560219907, ''),
(1032, 1090, 2, 2, 0, 0, 1560744276, ''),
(1033, 1078, 5, 5, 0, 1, 1560744307, ''),
(1034, 1096, 7, 7, 0, 1, 1561431993, ''),
(1035, 1095, 5, 5, 46, 0, 1561432001, ''),
(1036, 1094, 1, 1, 0, 1, 1561432007, ''),
(1037, 1089, 6, 6, 0, 0, 1561432043, ''),
(1038, 1110, 4, 4, 0, 1, 1563418609, ''),
(1039, 1109, 9, 9, 0, 1, 1564036904, ''),
(1040, 1121, 5, 5, 31, 1, 1565665285, ''),
(1041, 1122, 5, 5, 0, 0, 1565665298, ''),
(1042, 1125, 9, 9, 0, 1, 1567560914, ''),
(1043, 1126, 2, 2, 27, 1, 1567560928, ''),
(1044, 1099, 5, 5, 0, 1, 1569295550, ''),
(1045, 1129, 3, 3, 0, 1, 1569485598, ''),
(1046, 1133, 1, 1, 0, 1, 1570454849, ''),
(1047, 1132, 1, 1, 0, 0, 1570454866, ''),
(1048, 1136, 4, 4, 0, 2, 1571121839, '本圖庫只有圖片沒有語音，?可能不符合貴研究之需求。'),
(1050, 1143, 9, 9, 1, 1, 1573440315, ''),
(1051, 1161, 1, 1, 0, 1, 1576045023, ''),
(1052, 1162, 2, 2, 0, 1, 1576045034, ''),
(1053, 1164, 3, 3, 0, 1, 1576045049, ''),
(1054, 1165, 1, 1, 0, 0, 1576045086, ''),
(1055, 1150, 1, 1, 0, 1, 1576045137, ''),
(1056, 1146, 10, 10, 0, 1, 1576133677, ''),
(1057, 1170, 2, 2, 0, 0, 1577241959, ''),
(1058, 1149, 4, 4, 0, 1, 1577934335, ''),
(1059, 1176, 1, 1, 0, 1, 1580958090, ''),
(1060, 1138, 9, 9, 0, 0, 1581562006, ''),
(1061, 1175, 10, 10, 0, 1, 1581993724, ''),
(1062, 1183, 4, 4, 0, 1, 1583286583, ''),
(1063, 1181, 1, 1, 0, 1, 1583463883, ''),
(1064, 1186, 10, 10, 1, 1, 1583816954, ''),
(1066, 1000, 1, 1, 0, 1, 1584084165, ''),
(1067, 1196, 1, 1, 0, 1, 1586401743, ''),
(1068, 1163, 2, 2, 0, 0, 1586401776, ''),
(1069, 1061, 9, 9, 0, 0, 1587522235, ''),
(1070, 1180, 9, 9, 0, 1, 1587955779, ''),
(1071, 1207, 4, 4, 0, 1, 1588659496, ''),
(1072, 1226, 2, 2, 1, 1, 1591236220, ''),
(1073, 1229, 1, 1, 6, 1, 1591333643, ''),
(1074, 1222, 1, 1, 5, 1, 1591838451, ''),
(1075, 1237, 6, 6, 0, 1, 1591927662, ''),
(1076, 1249, 11, 11, 0, 1, 1594259142, ''),
(1077, 1254, 5, 5, 0, 1, 1595815887, ''),
(1078, 1258, 2, 2, 0, 1, 1596161913, ''),
(1079, 1261, 5, 5, 0, 1, 1596700629, ''),
(1080, 1263, 1, 1, 0, 1, 1597296198, ''),
(1081, 1260, 4, 4, 0, 1, 1597801791, ''),
(1082, 1217, 11, 11, 7, 1, 1597801846, ''),
(1083, 1264, 1, 1, 0, 1, 1598253303, ''),
(1084, 1265, 4, 4, 0, 1, 1598498363, ''),
(1085, 1269, 4, 4, 28, 1, 1599100657, ''),
(1086, 1243, 4, 4, 0, 1, 1601344277, ''),
(1087, 1246, 4, 4, 2, 1, 1601951061, ''),
(1088, 1182, 1, 1, 0, 1, 1601951101, ''),
(1089, 1291, 1, 1, 0, 1, 1602594701, ''),
(1090, 1293, 5, 5, 48, 1, 1603349172, ''),
(1091, 1284, 1, 1, 0, 1, 1603766993, ''),
(1092, 1300, 4, 4, 1, 1, 1603857616, ''),
(1093, 1305, 1, 1, 0, 1, 1605074252, ''),
(1094, 1304, 5, 5, 3, 1, 1606271703, ''),
(1095, 1325, 4, 4, 0, 1, 1607657967, ''),
(1098, 1324, 5, 5, 240, 1, 1608093831, ''),
(1099, 1329, 1, 1, 4, 1, 1608261932, ''),
(1100, 1338, 2, 2, 0, 2, 1609816763, '申請人未說明需要使用本資料庫之必要性'),
(1102, 1292, 9, 9, 0, 1, 1610508396, ''),
(1103, 1332, 5, 5, 61, 0, 1610682290, ''),
(1104, 1326, 3, 3, 0, 1, 1610940781, ''),
(1106, 1362, 4, 4, 1, 1, 1612759567, ''),
(1108, 1363, 1, 1, 1, 1, 1612863056, ''),
(1109, 1380, 2, 2, 7, 1, 1617287095, ''),
(1110, 1382, 5, 5, 0, 1, 1617863785, ''),
(1111, 1319, 1, 1, 0, 1, 1617945772, ''),
(1112, 1379, 2, 2, 0, 1, 1617984094, ''),
(1113, 1384, 9, 9, 0, 0, 1618212490, ''),
(1114, 1393, 10, 10, 0, 1, 1619082533, ''),
(1115, 1369, 2, 2, 0, 1, 1619427711, ''),
(1116, 1358, 1, 1, 0, 1, 1619427821, ''),
(1117, 1372, 10, 10, 223, 1, 1619455126, ''),
(1118, 1399, 11, 11, 0, 1, 1620358413, ''),
(1119, 1396, 1, 1, 0, 1, 1620800523, ''),
(1120, 1397, 4, 4, 92, 1, 1622180024, ''),
(1121, 1412, 1, 1, 0, 1, 1623308412, ''),
(1122, 1413, 1, 1, 0, 1, 1623754266, ''),
(1123, 1415, 9, 9, 0, 1, 1624246903, ''),
(1124, 1417, 5, 5, 0, 1, 1624503734, ''),
(1125, 1421, 1, 1, 0, 1, 1624944587, ''),
(1126, 1431, 1, 1, 0, 0, 1628141310, ''),
(1127, 1439, 1, 1, 0, 0, 1630126304, ''),
(1128, 1450, 2, 2, 0, 1, 1632966806, ''),
(1129, 1449, 10, 10, 0, 1, 1632977439, ''),
(1130, 1447, 1, 1, 0, 1, 1633018669, ''),
(1131, 1452, 4, 4, 0, 1, 1633498617, ''),
(1132, 1451, 10, 10, 0, 1, 1633498625, ''),
(1133, 1457, 3, 3, 9, 1, 1633965602, ''),
(1134, 1459, 4, 4, 7, 1, 1633965609, ''),
(1135, 1448, 5, 5, 6, 1, 1635228241, ''),
(1136, 1440, 11, 11, 0, 1, 1635228248, ''),
(1137, 1465, 5, 5, 0, 1, 1635575878, ''),
(1138, 1436, 2, 2, 0, 1, 1636050198, ''),
(1139, 1434, 4, 4, 0, 1, 1636353605, ''),
(1143, 1490, 10, 10, 2, 1, 1642037467, ''),
(1144, 1504, 11, 11, 2, 1, 1642557910, ''),
(1145, 1501, 2, 2, 1, 1, 1642558064, ''),
(1146, 1414, 1, 1, 0, 1, 1647241545, '');

-- --------------------------------------------------------

--
-- 資料表結構 `city`
--

CREATE TABLE IF NOT EXISTS `city` (
  `Name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Order` bigint(20) NOT NULL,
  `State` smallint(6) NOT NULL,
  `AutoNo` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`AutoNo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=24 ;

--
-- 資料表的匯出資料 `city`
--

INSERT INTO `city` (`Name`, `Order`, `State`, `AutoNo`) VALUES
('台北市', 0, 0, 1),
('基隆市', 0, 0, 2),
('新北市', 0, 0, 3),
('宜蘭縣', 0, 0, 4),
('新竹市', 0, 0, 5),
('新竹縣', 0, 0, 6),
('桃園縣', 0, 0, 7),
('苗栗縣', 0, 0, 8),
('台中市', 0, 0, 9),
('彰化縣', 0, 0, 10),
('南投縣', 0, 0, 11),
('雲林縣', 0, 0, 12),
('嘉義市', 0, 0, 13),
('嘉義縣', 0, 0, 14),
('台南市', 0, 0, 15),
('高雄市', 0, 0, 16),
('南海諸島', 0, 0, 17),
('澎湖縣', 0, 0, 18),
('屏東縣', 0, 0, 19),
('台東縣', 0, 0, 20),
('花蓮縣', 0, 0, 21),
('金門縣', 0, 0, 22),
('連江縣', 0, 0, 23);

-- --------------------------------------------------------

--
-- 資料表結構 `dbase`
--

CREATE TABLE IF NOT EXISTS `dbase` (
  `dbid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NOT NULL,
  `dbname` varchar(100) CHARACTER SET utf8 NOT NULL,
  `memo` varchar(100) CHARACTER SET utf8 NOT NULL,
  `open` int(11) NOT NULL,
  PRIMARY KEY (`dbid`),
  UNIQUE KEY `dbid` (`dbid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- 資料表的匯出資料 `dbase`
--

INSERT INTO `dbase` (`dbid`, `pid`, `dbname`, `memo`, `open`) VALUES
(1, 1, '臉孔表情-專業演員', '', 1),
(2, 2, '以大學生建立台灣華人基本情緒臉孔表情資料庫', '', 1),
(3, 3, '自發性情緒表情', '', 1),
(4, 4, '情緒圖片', '', 1),
(5, 5, '情緒詞', '', 1),
(6, 6, '情緒詞的加性樹狀結構', '', 1),
(7, 7, '情緒相關隱喻或比方', '', 1),
(8, 8, '引發情緒之敘述-笑話', '', 1),
(9, 9, '情緒聲調', '', 1),
(10, 10, '情緒影片', '', 1),
(11, 11, '音樂的情緒特性', '', 1);

-- --------------------------------------------------------

--
-- 資料表結構 `preview`
--

CREATE TABLE IF NOT EXISTS `preview` (
  `dbid` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`dbid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- 資料表的匯出資料 `preview`
--

INSERT INTO `preview` (`dbid`, `filename`) VALUES
(1, 'preview_01.jpg'),
(2, 'preview_02.jpg');

-- --------------------------------------------------------

--
-- 資料表結構 `professor`
--

CREATE TABLE IF NOT EXISTS `professor` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8 NOT NULL,
  `mail` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mail2` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `mail3` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12 ;

--
-- 資料表的匯出資料 `professor`
--

INSERT INTO `professor` (`pid`, `name`, `mail`, `mail2`, `mail3`) VALUES
(1, '陳建中', 'c3chen@ntu.edu.tw', '', ''),
(2, '襲充文', 'cwshyi@gmail.com', '', ''),
(3, '黃世琤', 'psysth@ccu.edu.tw', '', ''),
(4, '顏乃欣、廖瑞銘、楊建銘、黃淑麗、蔡介立', 'nsy@nccu.edu.tw', 'rmliao@nccu.edu.tw', 'yangcm@nccu.edu.tw'),
(5, '鄭昭明、陳學志、卓淑玲', 'chcjyh@gmail.com', 'lincho056384@gmail.com', ''),
(6, '卓淑玲、陳學志', 'lincho056384@gmail.com', 'chcjyh@gmail.com', ''),
(7, '陳學志、卓淑玲、蘇雅靜、林湘怡', 'chcjyh@gmail.com', 'lincho056384@gmail.com', ''),
(8, '陳學志、詹雨臻、蘇雅靜', 'chcjyh@gmail.com', 'ycchan@mx.nthu.edu.tw ', ''),
(9, '黃世琤', 'psysth@ccu.edu.tw', '', ''),
(10, '謝淑蘭、翁嘉英、孫蒨如', 'psyhsl@mail.ncku.edu.tw ', 'psycyw@ccu.edu.tw', 'chienru@nccu.edu.tw'),
(11, '陳一平、蔡振家', 'iping@faculty.nctu.edu.tw', 'tsaichengia@ntu.edu.tw', '');

-- --------------------------------------------------------

--
-- 資料表結構 `town`
--

CREATE TABLE IF NOT EXISTS `town` (
  `CNo` bigint(20) NOT NULL,
  `Name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `Post` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `State` smallint(6) NOT NULL,
  `AutoNo` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`AutoNo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=371 ;

--
-- 資料表的匯出資料 `town`
--

INSERT INTO `town` (`CNo`, `Name`, `Post`, `State`, `AutoNo`) VALUES
(1, '中正區', '100', 0, 1),
(1, '大同區', '103', 0, 2),
(1, '中山區', '104', 0, 3),
(1, '松山區', '105', 0, 4),
(1, '大安區', '106', 0, 5),
(1, '萬華區', '108', 0, 6),
(1, '信義區', '110', 0, 7),
(1, '士林區', '111', 0, 8),
(1, '北投區', '112', 0, 9),
(1, '內湖區', '114', 0, 10),
(1, '南港區', '115', 0, 11),
(1, '文山區', '116', 0, 12),
(2, '仁愛區', '200', 0, 13),
(2, '信義區', '201', 0, 14),
(2, '中正區', '202', 0, 15),
(2, '中山區', '203', 0, 16),
(2, '安樂區', '204', 0, 17),
(2, '暖暖區', '205', 0, 18),
(2, '七堵區', '206', 0, 19),
(3, '萬里區', '207', 0, 20),
(3, '金山區', '208', 0, 21),
(3, '板橋區', '220', 0, 22),
(3, '汐止區', '221', 0, 23),
(3, '深坑區', '222', 0, 24),
(3, '石碇區', '223', 0, 25),
(3, '瑞芳區', '224', 0, 26),
(3, '平溪區', '226', 0, 27),
(3, '雙溪區', '227', 0, 28),
(3, '貢寮區', '228', 0, 29),
(3, '新店區', '231', 0, 30),
(3, '坪林區', '232', 0, 31),
(3, '烏來區', '233', 0, 32),
(3, '永和區', '234', 0, 33),
(3, '中和區', '235', 0, 34),
(3, '土城區', '236', 0, 35),
(3, '三峽區', '237', 0, 36),
(3, '樹林區', '238', 0, 37),
(3, '鶯歌區', '239', 0, 38),
(3, '三重區', '241', 0, 39),
(3, '新莊區', '242', 0, 40),
(3, '泰山區', '243', 0, 41),
(3, '林口區', '244', 0, 42),
(3, '蘆洲區', '247', 0, 43),
(3, '五股區', '248', 0, 44),
(3, '八里區', '249', 0, 45),
(3, '淡水區', '251', 0, 46),
(3, '三芝區', '252', 0, 47),
(3, '石門區', '253', 0, 48),
(4, '宜蘭市', '260', 0, 49),
(4, '頭城鎮', '261', 0, 50),
(4, '礁溪鄉', '262', 0, 51),
(4, '壯圍鄉', '263', 0, 52),
(4, '員山鄉', '264', 0, 53),
(4, '羅東鎮', '265', 0, 54),
(4, '三星鄉', '266', 0, 55),
(4, '大同鄉', '267', 0, 56),
(4, '五結鄉', '268', 0, 57),
(4, '冬山鄉', '269', 0, 58),
(4, '蘇澳鎮', '270', 0, 59),
(4, '南澳鄉', '272', 0, 60),
(4, '釣魚台列嶼', '290', 0, 61),
(5, '新竹市', '300', 0, 62),
(6, '竹北市', '302', 0, 63),
(6, '湖口鄉', '303', 0, 64),
(6, '新豐鄉', '304', 0, 65),
(6, '新埔鎮', '305', 0, 66),
(6, '關西鎮', '306', 0, 67),
(6, '芎林鄉', '307', 0, 68),
(6, '寶山鄉', '308', 0, 69),
(6, '竹東鎮', '310', 0, 70),
(6, '五峰鄉', '311', 0, 71),
(6, '橫山鄉', '312', 0, 72),
(6, '尖石鄉', '313', 0, 73),
(6, '北埔鄉', '314', 0, 74),
(6, '峨眉鄉', '315', 0, 75),
(7, '中壢市', '320', 0, 76),
(7, '平鎮市', '324', 0, 77),
(7, '龍潭鄉', '325', 0, 78),
(7, '楊梅市', '326', 0, 79),
(7, '新屋鄉', '327', 0, 80),
(7, '觀音鄉', '328', 0, 81),
(7, '桃園市', '330', 0, 82),
(7, '龜山鄉', '333', 0, 83),
(7, '八德市', '334', 0, 84),
(7, '大溪鎮', '335', 0, 85),
(7, '復興鄉', '336', 0, 86),
(7, '大園鄉', '337', 0, 87),
(7, '蘆竹鄉', '338', 0, 88),
(8, '竹南鎮', '350', 0, 89),
(8, '頭份鎮', '351', 0, 90),
(8, '三灣鄉', '352', 0, 91),
(8, '南庄鄉', '353', 0, 92),
(8, '獅潭鄉', '354', 0, 93),
(8, '後龍鎮', '356', 0, 94),
(8, '通霄鎮', '357', 0, 95),
(8, '苑裡鎮', '358', 0, 96),
(8, '苗栗市', '360', 0, 97),
(8, '造橋鄉', '361', 0, 98),
(8, '頭屋鄉', '362', 0, 99),
(8, '公館鄉', '363', 0, 100),
(8, '大湖鄉', '364', 0, 101),
(8, '泰安鄉', '365', 0, 102),
(8, '銅鑼鄉', '366', 0, 103),
(8, '三義鄉', '367', 0, 104),
(8, '西湖鄉', '368', 0, 105),
(8, '卓蘭鎮', '369', 0, 106),
(9, '中區', '400', 0, 107),
(9, '東區', '401', 0, 108),
(9, '南區', '402', 0, 109),
(9, '西區', '403', 0, 110),
(9, '北區', '404', 0, 111),
(9, '北屯區', '406', 0, 112),
(9, '西屯區', '407', 0, 113),
(9, '南屯區', '408', 0, 114),
(9, '太平區', '411', 0, 115),
(9, '大里區', '412', 0, 116),
(9, '霧峰區', '413', 0, 117),
(9, '烏日區', '414', 0, 118),
(9, '豐原區', '420', 0, 119),
(9, '后里區', '421', 0, 120),
(9, '石岡區', '422', 0, 121),
(9, '東勢區', '423', 0, 122),
(9, '和平區', '424', 0, 123),
(9, '新社區', '426', 0, 124),
(9, '潭子區', '427', 0, 125),
(9, '大雅區', '428', 0, 126),
(9, '神岡區', '429', 0, 127),
(9, '大肚區', '432', 0, 128),
(9, '沙鹿區', '433', 0, 129),
(9, '龍井區', '434', 0, 130),
(9, '梧棲區', '435', 0, 131),
(9, '清水區', '436', 0, 132),
(9, '大甲區', '437', 0, 133),
(9, '外埔區', '438', 0, 134),
(9, '大安區', '439', 0, 135),
(10, '彰化市', '500', 0, 136),
(10, '芬園鄉', '502', 0, 137),
(10, '花壇鄉', '503', 0, 138),
(10, '秀水鄉', '504', 0, 139),
(10, '鹿港鎮', '505', 0, 140),
(10, '福興鄉', '506', 0, 141),
(10, '線西鄉', '507', 0, 142),
(10, '和美鎮', '508', 0, 143),
(10, '伸港鄉', '509', 0, 144),
(10, '員林鎮', '510', 0, 145),
(10, '社頭鄉', '511', 0, 146),
(10, '永靖鄉', '512', 0, 147),
(10, '埔心鄉', '513', 0, 148),
(10, '溪湖鎮', '514', 0, 149),
(10, '大村鄉', '515', 0, 150),
(10, '埔鹽鄉', '516', 0, 151),
(10, '田中鎮', '520', 0, 152),
(10, '北斗鎮', '521', 0, 153),
(10, '田尾鄉', '522', 0, 154),
(10, '埤頭鄉', '523', 0, 155),
(10, '溪州鄉', '524', 0, 156),
(10, '竹塘鄉', '525', 0, 157),
(10, '二林鎮', '526', 0, 158),
(10, '大城鄉', '527', 0, 159),
(10, '芳苑鄉', '528', 0, 160),
(10, '二水鄉', '530', 0, 161),
(11, '南投市', '540', 0, 162),
(11, '中寮鄉', '541', 0, 163),
(11, '草屯鎮', '542', 0, 164),
(11, '國姓鄉', '544', 0, 165),
(11, '埔里鎮', '545', 0, 166),
(11, '仁愛鄉', '546', 0, 167),
(11, '名間鄉', '551', 0, 168),
(11, '集集鎮', '552', 0, 169),
(11, '水里鄉', '553', 0, 170),
(11, '魚池鄉', '555', 0, 171),
(11, '信義鄉', '556', 0, 172),
(11, '竹山鎮', '557', 0, 173),
(11, '鹿谷鄉', '558', 0, 174),
(12, '斗南鎮', '630', 0, 175),
(12, '大埤鄉', '631', 0, 176),
(12, '虎尾鎮', '632', 0, 177),
(12, '土庫鎮', '633', 0, 178),
(12, '褒忠鄉', '634', 0, 179),
(12, '東勢鄉', '635', 0, 180),
(12, '臺西鄉', '636', 0, 181),
(12, '崙背鄉', '637', 0, 182),
(12, '麥寮鄉', '638', 0, 183),
(12, '斗六市', '640', 0, 184),
(12, '林內鄉', '643', 0, 185),
(12, '古坑鄉', '646', 0, 186),
(12, '莿桐鄉', '647', 0, 187),
(12, '西螺鎮', '648', 0, 188),
(12, '二崙鄉', '649', 0, 189),
(12, '北港鎮', '651', 0, 190),
(12, '水林鄉', '652', 0, 191),
(12, '口湖鄉', '653', 0, 192),
(12, '四湖鄉', '654', 0, 193),
(12, '元長鄉', '655', 0, 194),
(13, '嘉義市', '600', 0, 195),
(14, '番路鄉', '602', 0, 196),
(14, '梅山鄉', '603', 0, 197),
(14, '竹崎鄉', '604', 0, 198),
(14, '阿里山鄉', '605', 0, 199),
(14, '中埔鄉', '606', 0, 200),
(14, '大埔鄉', '607', 0, 201),
(14, '水上鄉', '608', 0, 202),
(14, '鹿草鄉', '611', 0, 203),
(14, '太保市', '612', 0, 204),
(14, '朴子市', '613', 0, 205),
(14, '東石鄉', '614', 0, 206),
(14, '六腳鄉', '615', 0, 207),
(14, '新港鄉', '616', 0, 208),
(14, '民雄鄉', '621', 0, 209),
(14, '大林鎮', '622', 0, 210),
(14, '溪口鄉', '623', 0, 211),
(14, '義竹鄉', '624', 0, 212),
(14, '布袋鎮', '625', 0, 213),
(15, '中西區', '700', 0, 214),
(15, '東區', '701', 0, 215),
(15, '南區', '702', 0, 216),
(15, '北區', '704', 0, 217),
(15, '安平區', '708', 0, 218),
(15, '安南區', '709', 0, 219),
(15, '永康區', '710', 0, 220),
(15, '歸仁區', '711', 0, 221),
(15, '新化區', '712', 0, 222),
(15, '左鎮區', '713', 0, 223),
(15, '玉井區', '714', 0, 224),
(15, '楠西區', '715', 0, 225),
(15, '南化區', '716', 0, 226),
(15, '仁德區', '717', 0, 227),
(15, '關廟區', '718', 0, 228),
(15, '龍崎區', '719', 0, 229),
(15, '官田區', '720', 0, 230),
(15, '麻豆區', '721', 0, 231),
(15, '佳里區', '722', 0, 232),
(15, '西港區', '723', 0, 233),
(15, '七股區', '724', 0, 234),
(15, '將軍區', '725', 0, 235),
(15, '學甲區', '726', 0, 236),
(15, '北門區', '727', 0, 237),
(15, '新營區', '730', 0, 238),
(15, '後壁區', '731', 0, 239),
(15, '白河區', '732', 0, 240),
(15, '東山區', '733', 0, 241),
(15, '六甲區', '734', 0, 242),
(15, '下營區', '735', 0, 243),
(15, '柳營區', '736', 0, 244),
(15, '鹽水區', '737', 0, 245),
(15, '善化區', '741', 0, 246),
(15, '大內區', '742', 0, 247),
(15, '山上區', '743', 0, 248),
(15, '新市區', '744', 0, 249),
(15, '安定區', '745', 0, 250),
(16, '新興區', '800', 0, 251),
(16, '前金區', '801', 0, 252),
(16, '苓雅區', '802', 0, 253),
(16, '鹽埕區', '803', 0, 254),
(16, '鼓山區', '804', 0, 255),
(16, '旗津區', '805', 0, 256),
(16, '前鎮區', '806', 0, 257),
(16, '三民區', '807', 0, 258),
(16, '楠梓區', '811', 0, 259),
(16, '小港區', '812', 0, 260),
(16, '左營區', '813', 0, 261),
(16, '仁武區', '814', 0, 262),
(16, '大社區', '815', 0, 263),
(16, '岡山區', '820', 0, 264),
(16, '路竹區', '821', 0, 265),
(16, '阿蓮區', '822', 0, 266),
(16, '田寮區', '823', 0, 267),
(16, '燕巢區', '824', 0, 268),
(16, '橋頭區', '825', 0, 269),
(16, '梓官區', '826', 0, 270),
(16, '彌陀區', '827', 0, 271),
(16, '永安區', '828', 0, 272),
(16, '湖內區', '829', 0, 273),
(16, '鳳山區', '830', 0, 274),
(16, '大寮區', '831', 0, 275),
(16, '林園區', '832', 0, 276),
(16, '鳥松區', '833', 0, 277),
(16, '大樹區', '840', 0, 278),
(16, '旗山區', '842', 0, 279),
(16, '美濃區', '843', 0, 280),
(16, '六龜區', '844', 0, 281),
(16, '內門區', '845', 0, 282),
(16, '杉林區', '846', 0, 283),
(16, '甲仙區', '847', 0, 284),
(16, '桃源區', '848', 0, 285),
(16, '那瑪夏區', '849', 0, 286),
(16, '茂林區', '851', 0, 287),
(16, '茄萣區', '852', 0, 288),
(17, '東沙', '817', 0, 289),
(17, '南沙', '819', 0, 290),
(18, '馬公市', '880', 0, 291),
(18, '西嶼鄉', '881', 0, 292),
(18, '望安鄉', '882', 0, 293),
(18, '七美鄉', '883', 0, 294),
(18, '白沙鄉', '884', 0, 295),
(18, '湖西鄉', '885', 0, 296),
(19, '屏東市', '900', 0, 297),
(19, '三地門鄉', '901', 0, 298),
(19, '霧臺鄉', '902', 0, 299),
(19, '瑪家鄉', '903', 0, 300),
(19, '九如鄉', '904', 0, 301),
(19, '里港鄉', '905', 0, 302),
(19, '高樹鄉', '906', 0, 303),
(19, '鹽埔鄉', '907', 0, 304),
(19, '長治鄉', '908', 0, 305),
(19, '麟洛鄉', '909', 0, 306),
(19, '竹田鄉', '911', 0, 307),
(19, '內埔鄉', '912', 0, 308),
(19, '萬丹鄉', '913', 0, 309),
(19, '潮州鎮', '920', 0, 310),
(19, '泰武鄉', '921', 0, 311),
(19, '來義鄉', '922', 0, 312),
(19, '萬巒鄉', '923', 0, 313),
(19, '崁頂鄉', '924', 0, 314),
(19, '新埤鄉', '925', 0, 315),
(19, '南州鄉', '926', 0, 316),
(19, '林邊鄉', '927', 0, 317),
(19, '東港鄉', '928', 0, 318),
(19, '琉球鄉', '929', 0, 319),
(19, '佳冬鄉', '931', 0, 320),
(19, '新園鄉', '932', 0, 321),
(19, '枋寮鄉', '940', 0, 322),
(19, '枋山鄉', '941', 0, 323),
(19, '春日鄉', '942', 0, 324),
(19, '獅子鄉', '943', 0, 325),
(19, '車城鄉', '944', 0, 326),
(19, '牡丹鄉', '945', 0, 327),
(19, '恆春鄉', '946', 0, 328),
(19, '滿州鄉', '947', 0, 329),
(20, '臺東市', '950', 0, 330),
(20, '綠島鄉', '951', 0, 331),
(20, '蘭嶼鄉', '952', 0, 332),
(20, '延平鄉', '953', 0, 333),
(20, '卑南鄉', '954', 0, 334),
(20, '鹿野鄉', '955', 0, 335),
(20, '關山鎮', '956', 0, 336),
(20, '海端鄉', '957', 0, 337),
(20, '池上鄉', '958', 0, 338),
(20, '東河鄉', '959', 0, 339),
(20, '成功鎮', '961', 0, 340),
(20, '長濱鄉', '962', 0, 341),
(20, '太麻里鄉', '963', 0, 342),
(20, '金峰鄉', '964', 0, 343),
(20, '大武鄉', '965', 0, 344),
(20, '達仁鄉', '966', 0, 345),
(21, '花蓮市', '970', 0, 346),
(21, '新城鄉', '971', 0, 347),
(21, '秀林鄉', '972', 0, 348),
(21, '吉安鄉', '973', 0, 349),
(21, '壽豐鄉', '974', 0, 350),
(21, '鳳林鎮', '975', 0, 351),
(21, '光復鄉', '976', 0, 352),
(21, '豐濱鄉', '977', 0, 353),
(21, '瑞穗鄉', '978', 0, 354),
(21, '萬榮鄉', '979', 0, 355),
(21, '玉里鎮', '981', 0, 356),
(21, '卓溪鄉', '982', 0, 357),
(21, '富里鄉', '983', 0, 358),
(22, '金沙鎮', '890', 0, 359),
(22, '金湖鎮', '891', 0, 360),
(22, '金寧鄉', '892', 0, 361),
(22, '金城鎮', '893', 0, 362),
(22, '烈嶼鄉', '894', 0, 363),
(22, '烏坵鄉', '896', 0, 364),
(23, '南竿鄉', '209', 0, 365),
(23, '北竿鄉', '210', 0, 366),
(23, '莒光鄉', '211', 0, 367),
(23, '東引鄉', '212', 0, 368);

