
CREATE DATABASE `swgk_wl` DEFAULT CHARACTER SET utf8mb4;

USE `swgk_wl`;

CREATE TABLE `swgk_base_ppl` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '人员唯一ID',
  `cardid` varchar(18) NOT NULL DEFAULT '' COMMENT '证件号码主键身份证编码应符合gb 11643',
  `idtype` char(3) NOT NULL DEFAULT '111' COMMENT '证件类型编码，见data_idtype表code',
  `peopletype` char(2) DEFAULT '01' COMMENT '人口类型编码，见data_peopletype表code',
  `name` varchar(81) NOT NULL DEFAULT '' COMMENT '姓名',
  `usedname` varchar(13) NOT NULL DEFAULT '' COMMENT '曾用名',
  `sex` char(1) NOT NULL DEFAULT '9' COMMENT '性别编码，见data_gender表code',
  `birthday` date NOT NULL DEFAULT '1970-01-01' COMMENT '格式为“yyyy-mm-dd”',
  `region_code` char(12) NOT NULL DEFAULT '' COMMENT '所属区域编码, 见region表code',
  `birthplace` varchar(200) NOT NULL DEFAULT '' COMMENT '出生地',
  `nativeplace` varchar(200) NOT NULL DEFAULT '' COMMENT '籍贯',
  `national` char(2) NOT NULL DEFAULT '01' COMMENT '民族编码，见data_national表code',
  `bloodtype` char(1) NOT NULL DEFAULT '0' COMMENT '血型编码，见data_bloodtype表code',
  `marital` char(2) NOT NULL DEFAULT '90' COMMENT '婚姻状态编码，见data_marital表code',
  `political` char(2) NOT NULL DEFAULT '13' COMMENT '政治面貌编码，见data_political表code',
  `religious` char(2) NOT NULL DEFAULT '' COMMENT '宗教信仰编码，见data_religious表code',
  `education` char(2) NOT NULL DEFAULT '90' COMMENT '最高学历编码，见data_education表code',
  `telphone` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `military` varchar(50) NOT NULL DEFAULT '' COMMENT '兵役状况',
  `health` char(2) NOT NULL DEFAULT '90' COMMENT '健康状况编码，见data_health表code',
  `death` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否死亡 0-否 1-是',
  `deathdate` date NOT NULL DEFAULT '1970-01-01' COMMENT '死亡日期',
  `country` char(3) NOT NULL DEFAULT '156' COMMENT '国籍编码，见data_country表code',
  `email` varchar(30) NOT NULL DEFAULT '' COMMENT '邮箱',
  `other_telphone` varchar(100) NOT NULL DEFAULT '' COMMENT '其他联系方式，多个号码以逗号(,)分隔',
  `workunit` varchar(21) NOT NULL DEFAULT '' COMMENT '工作单位',
  `residenceplace` varchar(201) NOT NULL DEFAULT '' COMMENT '户籍详址',
  `inhabitedplace` varchar(201) NOT NULL DEFAULT '' COMMENT '居住详址',
  `is_master` enum('n','y') NOT NULL DEFAULT 'n' COMMENT '是否为户主',
  `remark` varchar(41) NOT NULL DEFAULT '' COMMENT '备注',
  `pics` varchar(302) NOT NULL DEFAULT '' COMMENT '用户头像存储地址',
  `face_code` varchar(800) NOT NULL DEFAULT '' COMMENT '人脸识别码',
  `is_volunteer` enum('y','n') NOT NULL DEFAULT 'n' COMMENT '是否为志愿者',
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_idx1` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=22235 DEFAULT CHARSET=utf8mb4 COMMENT='人口信息表';

/*Data for the table `swgk_base_ppl` */

insert  into `swgk_base_ppl`(`id`,`uuid`,`cardid`,`idtype`,`peopletype`,`name`,`usedname`,`sex`,`birthday`,`birthplace`,`nativeplace`,`national`,`bloodtype`,`marital`,`political`,`religious`,`education`,`telphone`,`military`,`health`,`death`,`deathdate`,`country`,`email`,`other_telphone`,`workunit`,`residenceplace`,`inhabitedplace`,`is_master`,`remark`,`pics`,`face_code`,`is_volunteer`) values (1,'4c8f125cd4334b248dceed93ee330685','140581199003168415','111','01','系统总监','','1','1990-03-16','','天上','01','0','90','13','','90','18999999999','','90',0,'1970-01-01','156','','','','','','n','','','QXUAAAAAAAAMAgAA4CImPIEJIb0JKKE8dda1PIqWrD23JWi9lzOkO8TDE71Z+y++5DSZvONtBb1kCKu90JriPaHXhDyhjRu+ExYovph0CD6aiFs+qz1XOzMbGTzD1iU9UaUHvbpuJL4Hwc68TmLqPHVWqr1Iw8u8oMsFPkwr8b3uewc9/1tYPhc1cr0Ugcc9SfV3vb39Yb2Zi/S9YjWKvR1FAL6UimA83+vavbPDYz1kCLu8Iuc9OwhDAj4cvaI9u98QvmDhpz3Ii0i9OFwjPn/XGL3Rp6g9bYatvVruDDt2gZa9OS0DvsslF7vH9di9vyIkPXDRkb3QL3e9pz+CvRAlRD6N+Km8f2lzPSGrDb1zXpU9sBH0PACIkLtuEPQ9CtOWPRjIfD1LZgi+tyMavvEKzLt9YZ29Lss5vddLv71ovKI750XHPWxZ6D1+Aci9hUTfvTUKGr4oamu8eJehPZKRGD1cSAS9epPcPEZyjjwVV7s9rWnWPVLiWrwIzKq84B1evn552D2W/oW92DqSPMebhL1cSRU9RHVnPTXUZTyGj/s9fUNqvZcQ0r3Iu2Y8dxvVPClLej2pVZ29jjBqvltBzT0b/RW9bsMPvN5ajj20nKW9DTMDvL8ISb3XmEA99NC2PFLDMb6m4lo9OtIaPQnUTL3FWQc9TzcRPM09KT3sZme9AuWQvRw3PD4=','n');

CREATE TABLE `swgk_boss` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `user_code` varchar(31) NOT NULL DEFAULT '' COMMENT '客户编码',
  `user_name` varchar(21) NOT NULL DEFAULT '' COMMENT '客户名称',
  `user_addr` varchar(101) NOT NULL DEFAULT '' COMMENT '地址',
  `user_phone` char(11) NOT NULL DEFAULT '' COMMENT '客户手机号码'
  `caid` varchar(31) NOT NULL DEFAULT '' COMMENT '智能卡号',
  `stbid` varchar(31) NOT NULL DEFAULT '' COMMENT '机顶盒号',
  `uuid` char(32) NOT NULL COMMENT '持卡人uuid，见base_ppl表uuid',
  `use_status` enum('未激活','罚停','暂停','有效') DEFAULT '未激活' COMMENT '状态',
  PRIMARY KEY (`id`),
  UNIQUE KEY `u_idx1` (`caid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='电视端CA卡列表';

CREATE TABLE `swgk_browsing_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键自增ID',
  `c_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '用户uuid',
  `ctime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '浏览时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户浏览记录表';

CREATE TABLE `swgk_camera` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(201) NOT NULL DEFAULT '' COMMENT '监控名称',
  `type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类,见camera_type表id',
  `camera_type` varchar(21) NOT NULL DEFAULT '普通' COMMENT '摄像头类型 (取流接口不同)',
  `camera_url` varchar(201) NOT NULL DEFAULT '' COMMENT '监控URL',
  `stream` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '监控IP',
  `vsea_u` varchar(50) NOT NULL DEFAULT '' COMMENT '监控账户',
  `vsea_p` varchar(50) NOT NULL DEFAULT '' COMMENT '监控密码',
  `vsea_l` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '监控端口',
  `channel` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '通道',
  `subtype` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '码流',
  `latitude` float(10,7) NOT NULL DEFAULT '0.0000000' COMMENT '监控纬度',
  `longitude` float(10,7) NOT NULL DEFAULT '0.0000000' COMMENT '监控经度',
  `camera_addr` varchar(201) NOT NULL DEFAULT '' COMMENT '监控所在地址',
  `pics` varchar(60) NOT NULL DEFAULT '' COMMENT '监控的图片',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '监控状态 0-正常 1-停用 2-异常',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '99' COMMENT '排序',
  `auto_time` varchar(35) NOT NULL DEFAULT '' COMMENT '自动开启时间段',
  `ison` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否开启会议 0-未开启 1-已开启',
  `isopen` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '是否向公众开放 0-否 1-是',
  `port` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '电视端推流端口',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='监控表';


CREATE TABLE `swgk_camera_type` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `name` varchar(21) NOT NULL DEFAULT '' COMMENT '监控类型 如厨房、操场',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '99' COMMENT '排序',
  `desc` varchar(201) NOT NULL DEFAULT '' COMMENT '监控类型描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='监控类型表';

CREATE TABLE `swgk_comment` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `c_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论内容id，见content表id',
  `content` mediumtext COMMENT '评论内容',
  `status` enum('待审核','已审核','驳回','上线','下线') NOT NULL DEFAULT '待审核' COMMENT '评论的状态',
  `reject_reason` varchar(30) NOT NULL DEFAULT '' COMMENT '驳回意见',
  `creator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '评论人创建uuid，见base_ppl表uuid',
  `auditor_uuid` char(32) NOT NULL DEFAULT '' COMMENT '审核人uuid，见base_ppl表uuid',
  `publisher_uuid` char(32) NOT NULL DEFAULT '' COMMENT '发布人uuid，见base_ppl表uuid',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '评论创建时间',
  `atime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '评论审核时间',
  `ptime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '评论上线的时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='评论表';

CREATE TABLE `swgk_con_collection` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键自增ID',
  `c_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID，对应content表ID',
  `ctime` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '收藏时间',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '收藏用户uuid,对应base_ppl表uuid字段',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内容收藏表';

CREATE TABLE `swgk_conf` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `conf_key` varchar(30) NOT NULL DEFAULT '' COMMENT '配置键值',
  `conf_value` text NOT NULL COMMENT '配置值',
  `conf_desc` varchar(50) NOT NULL DEFAULT '' COMMENT '配置描述',
  `conf_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '配置生效时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='系统设置表';

insert  into `swgk_conf`(`id`,`conf_key`,`conf_value`,`conf_desc`,`conf_time`) values (1,'book_borrow_date','60','图书可借阅时长','2019-09-10 06:15:00'),(2,'login_ip_lock_err_times','5','登录错误次数达标时IP锁定','2019-09-10 06:15:00'),(3,'login_ip_lock_err_time','30','登录错误次数达标时IP锁定时长/分钟','2019-09-10 06:15:00'),(4,'login_user_lock_err_times','10','登录错误次数达标时用户名锁定','2019-09-10 06:15:00'),(5,'login_user_lock_err_time','60','登录错误次数达标时用户名锁定时长/分钟','2019-09-10 06:15:00'),(6,'sms_expire','300','短信有效期时长/分钟','2019-09-10 06:15:00'),(7,'pwd_weak_list','123456,000000,111111,123123,112233,123321,654321,666666,888888,1234567,5201314,11111111,88888888,66666666,12345678,123456789,987654321,1234567890,9876543210,abc123,a1b2c3,aaa111,123qwe,adobe123,passw0rd,qwerty,monkey,shadow,azerty,abcdef,abcabc,qweasd,passwd,dragon,master,ashley,bailey,qazwsx,woaini,letmein,michael,wohenni,password,iloveyou,photoshop,sunshine,password1,princess,trustno1,football,p@ssword,asdfghjkl,baseball,superman,zhangwei,wangwei,147258369','弱密码列表','2019-09-24 14:39:51'),(8,'pwd_strong_switch','y','弱密码校验是否开启','2019-09-24 14:39:51'),(9,'notes_point','3','读书笔记积分','2019-09-24 14:39:51'),(10,'third_token_expire','2592000','第三方授权码有效时长','2020-02-21 15:20:00'),(11,'third_token_refresh_expire','31104000','第三方授权码有效时长','2020-02-21 15:20:00');

CREATE TABLE `swgk_consult` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content_id` varchar(10) NOT NULL COMMENT '内容ID',
  `c_title` varchar(51) NOT NULL COMMENT '标题',
  `contents` varchar(1001) NOT NULL COMMENT '评选内容',
  `type` enum('人物评选','征询') NOT NULL COMMENT '类型',
  `pics` varchar(360) NOT NULL DEFAULT '' COMMENT '照片，最多9张，以逗号隔开',
  `name` varchar(31) NOT NULL DEFAULT '' COMMENT '姓名',
  `position` varchar(51) NOT NULL DEFAULT '' COMMENT '职务',
  `phone` varchar(51) NOT NULL DEFAULT '' COMMENT '电话',
  `mark` varchar(101) NOT NULL DEFAULT '' COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='征询评选表';

CREATE TABLE `swgk_consult_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `content_id` varchar(10) NOT NULL COMMENT '内容ID',
  `consult_id` varchar(10) NOT NULL DEFAULT '' COMMENT '征询id',
  `operator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '征询者UUID，见base_ppl表uuid',
  `dates` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '征询时间',
  `feedback` mediumint(9) unsigned NOT NULL DEFAULT '0' COMMENT '人物评选票数/征询选项id',
  `ca_no` varchar(31) NOT NULL DEFAULT '' COMMENT 'CA卡号，TV端投票专用',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='征询评选反馈管理表 ';

CREATE TABLE `swgk_consult_option` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `content_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章ID，对应content表ID',
  `consult_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '征询ID，对应consult表ID',
  `option_desc` varchar(301) NOT NULL DEFAULT '' COMMENT '选项描述',
  `vote_number` mediumint(9) NOT NULL DEFAULT '0' COMMENT '投票数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='征询选项表';

CREATE TABLE `swgk_content` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(201) NOT NULL DEFAULT '' COMMENT '标题',
  `contents` mediumtext COMMENT '内容',
  `video_path` varchar(51) NOT NULL DEFAULT '' COMMENT '视频，仅支持一个视频',
  `pics` text COMMENT '图片存储路径，多个以逗号隔开',
  `type` enum('图文','财务','征询','评选','纯表格','全屏视频','党员形象照') NOT NULL DEFAULT '图文' COMMENT '内容样式',
  `node_id` varchar(51) NOT NULL DEFAULT '' COMMENT '所属栏目ID，见node表id，最多支持10个栏目，多个栏目id以逗号隔开',
  `status` enum('待审核','已审核','驳回','上线','下线') NOT NULL DEFAULT '待审核' COMMENT '文章状态',
  `reject_reason` varchar(201) NOT NULL DEFAULT '' COMMENT '驳回意见',
  `region_code` char(12) NOT NULL DEFAULT '' COMMENT '所属区域编码, 见region表code',
  `creator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '录入人uuid，见base_ppl表uuid',
  `auditor_uuid` char(32) NOT NULL DEFAULT '' COMMENT '审核人uuid，见base_ppl表uuid',
  `publisher_uuid` char(32) NOT NULL DEFAULT '' COMMENT '发布人uuid，见base_ppl表uuid',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '录入时间',
  `atime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '审核时间',
  `ptime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '发布时间',
  `sort` int(10) unsigned NOT NULL DEFAULT '99' COMMENT '文章排序',
  `iscomment` enum('y','n') NOT NULL DEFAULT 'y' COMMENT '内容是否允许评论',
  `media_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '媒资ID，对应media表ID',
  `icon` varchar(60) NOT NULL DEFAULT '' COMMENT '封面图片',
  `start_time` timestamp NULL DEFAULT NULL COMMENT '征询开始时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '征询结束时间',
  `to_homepage` enum('y','n') NOT NULL DEFAULT 'n' COMMENT '是否推荐到首页 y-是 n-否',
  `vid` varchar(21) NOT NULL DEFAULT '' COMMENT '网易云vid',
  `isperson` enum('y','n') NOT NULL DEFAULT 'n' COMMENT '是否人物类内容',
  `tv_play_url` varchar(1002) NOT NULL DEFAULT '' COMMENT '电视端播放地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='内容表';

CREATE TABLE `swgk_data_bloodtype` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(1) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(3) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='血型表应符合GA/T 2000.37-2014';

insert  into `swgk_data_bloodtype`(`id`,`code`,`name`) values (1,'0','不明'),(2,'1','A型'),(3,'2','B型'),(4,'3','O型'),(5,'4','AB型'),(6,'9','其他');

CREATE TABLE `swgk_data_country` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(3) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(14) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8mb4 COMMENT='国籍表';

insert  into `swgk_data_country`(`id`,`code`,`name`) values (1,'156','中国'),(2,'158','中国台湾'),(3,'344','中国香港'),(4,'446','中国澳门'),(5,'4','阿富汗'),(6,'8','阿尔巴尼亚'),(7,'10','南极洲'),(8,'12','阿尔及利亚'),(9,'16','萨摩亚'),(10,'20','安道尔'),(11,'24','安哥拉'),(12,'28','安提瓜和巴布达'),(13,'31','阿塞拜疆'),(14,'32','阿根廷'),(15,'36','澳大利亚'),(16,'40','奥地利'),(17,'44','巴哈马'),(18,'48','巴林'),(19,'50','孟加拉国'),(20,'51','亚美尼亚'),(21,'52','巴巴多斯'),(22,'56','比利时'),(23,'60','百慕大群岛'),(24,'64','不丹'),(25,'68','玻利维亚'),(26,'70','波斯尼亚和黑塞哥维那'),(27,'72','博茨瓦纳'),(28,'74','布韦岛'),(29,'76','巴西'),(30,'84','伯利兹'),(31,'86','印度洋领地'),(32,'90','所罗门群岛'),(33,'92','维尔京群岛'),(34,'96','文莱'),(35,'100','保加利亚'),(36,'104','缅甸'),(37,'108','布隆迪'),(38,'112','白俄罗斯'),(39,'116','柬埔寨'),(40,'120','喀麦隆'),(41,'124','加拿大'),(42,'132','佛得角'),(43,'136','开曼群岛'),(44,'140','中非共和国'),(45,'144','斯里兰卡'),(46,'148','乍得'),(47,'152','智利'),(48,'162','圣诞岛'),(49,'166','科科斯群岛（基灵群岛）'),(50,'170','哥伦比亚'),(51,'174','科摩罗'),(52,'175','马约特岛'),(53,'178','刚果'),(54,'180','刚果民主共和国'),(55,'184','库克群岛'),(56,'188','哥斯达黎加'),(57,'191','克罗地亚'),(58,'192','古巴'),(59,'196','塞浦路斯'),(60,'203','捷克共和国'),(61,'204','贝宁'),(62,'208','丹麦'),(63,'212','多米尼加'),(64,'214','多米尼加共和国'),(65,'218','厄瓜多尔'),(66,'222','萨尔瓦多'),(67,'226','赤道几内亚'),(68,'231','埃塞俄比亚'),(69,'232','厄立特里亚'),(70,'233','爱沙尼亚'),(71,'234','法罗群岛'),(72,'238','福克兰群岛(马尔维纳斯群岛)'),(73,'239','南乔治亚和南桑德威奇群岛'),(74,'242','斐济群岛'),(75,'246','芬兰'),(76,'248','奥兰群岛(芬兰属)'),(77,'250','法国'),(78,'254','法属圭亚那'),(79,'258','法属波利尼西亚'),(80,'260','法属南极地区'),(81,'262','吉布提'),(82,'266','加蓬'),(83,'268','乔治亚'),(84,'270','冈比亚'),(85,'275','巴勒斯坦当局'),(86,'276','德国'),(87,'288','加纳'),(88,'292','直布罗陀'),(89,'296','基里巴斯'),(90,'300','希腊'),(91,'304','格陵兰'),(92,'308','格林纳达'),(93,'312','瓜德罗普岛'),(94,'316','关岛'),(95,'320','危地马拉'),(96,'324','几内亚'),(97,'328','圭亚那'),(98,'332','海地'),(99,'334','赫德和麦克唐纳群岛'),(100,'336','梵蒂冈城'),(101,'340','洪都拉斯'),(102,'348','匈牙利'),(103,'352','冰岛'),(104,'356','印度'),(105,'360','印度尼西亚'),(106,'364','伊朗'),(107,'368','伊拉克'),(108,'372','爱尔兰'),(109,'376','以色列'),(110,'380','意大利'),(111,'384','科特迪瓦'),(112,'388','牙买加'),(113,'392','日本'),(114,'398','哈萨克斯坦'),(115,'400','约旦'),(116,'404','肯尼亚'),(117,'408','朝鲜'),(118,'410','韩国'),(119,'414','科威特'),(120,'417','吉尔吉斯斯坦'),(121,'418','老挝'),(122,'422','黎巴嫩'),(123,'426','莱索托'),(124,'428','拉脱维亚'),(125,'430','利比里亚'),(126,'434','利比亚'),(127,'438','列支敦士登'),(128,'440','立陶宛'),(129,'442','卢森堡'),(130,'450','马达加斯加'),(131,'454','马拉维'),(132,'458','马来西亚'),(133,'462','马尔代夫'),(134,'466','马里'),(135,'470','马耳他'),(136,'474','马提尼克岛'),(137,'478','毛里塔尼亚'),(138,'480','毛里求斯'),(139,'484','墨西哥'),(140,'492','摩纳哥'),(141,'496','蒙古'),(142,'498','摩尔多瓦'),(143,'499','门的内哥罗(黑山)'),(144,'500','蒙特塞拉特'),(145,'504','摩洛哥'),(146,'508','莫桑比克'),(147,'512','阿曼'),(148,'516','纳米比亚'),(149,'520','瑙鲁'),(150,'524','尼泊尔'),(151,'528','荷兰'),(152,'530','荷属安的列斯群岛'),(153,'533','阿鲁巴'),(154,'540','新喀里多尼亚'),(155,'548','瓦努阿图'),(156,'554','新西兰'),(157,'558','尼加拉瓜'),(158,'562','尼日尔'),(159,'566','尼日利亚'),(160,'570','纽埃'),(161,'574','诺福克岛'),(162,'578','挪威'),(163,'580','北马里亚纳群岛'),(164,'581','小奥特兰群岛'),(165,'583','密克罗尼西亚'),(166,'584','马绍尔群岛'),(167,'585','帕劳群岛'),(168,'586','巴基斯坦'),(169,'591','巴拿马'),(170,'598','巴布亚新几内亚'),(171,'600','巴拉圭'),(172,'604','秘鲁'),(173,'608','菲律宾'),(174,'612','皮特克恩群岛'),(175,'616','波兰'),(176,'620','葡萄牙'),(177,'624','几内亚比绍'),(178,'626','东帝汶'),(179,'630','波多黎各'),(180,'634','卡塔尔'),(181,'638','留尼汪岛'),(182,'642','罗马尼亚'),(183,'643','俄罗斯'),(184,'646','卢旺达'),(185,'652','圣巴泰勒米'),(186,'654','圣赫勒拿岛'),(187,'659','圣基茨和尼维斯'),(188,'660','安圭拉岛'),(189,'662','圣卢西亚'),(190,'663','圣马丁'),(191,'666','圣皮埃尔岛和密克隆岛'),(192,'670','圣文森特和格林纳丁斯'),(193,'674','圣马力诺'),(194,'678','圣多美和普林西比'),(195,'682','沙特阿拉伯'),(196,'686','塞内加尔'),(197,'688','塞尔维亚'),(198,'690','塞舌尔'),(199,'694','塞拉利昂'),(200,'702','新加坡'),(201,'703','斯洛伐克'),(202,'704','越南'),(203,'705','斯洛文尼亚'),(204,'706','索马里'),(205,'710','南非'),(206,'716','津巴布韦'),(207,'724','西班牙'),(208,'732','西撒哈拉'),(209,'736','苏丹'),(210,'740','苏里南'),(211,'744','斯瓦尔巴群岛和扬马延'),(212,'748','斯威士兰'),(213,'752','瑞典'),(214,'756','瑞士'),(215,'760','叙利亚'),(216,'762','塔吉克斯坦'),(217,'764','泰国'),(218,'768','多哥'),(219,'772','托克劳'),(220,'776','汤加'),(221,'780','特立尼达和多巴哥'),(222,'784','阿拉伯联合酋长国'),(223,'788','突尼斯'),(224,'792','土耳其'),(225,'795','土库曼斯坦'),(226,'796','特克斯群岛和凯科斯群岛'),(227,'798','图瓦卢'),(228,'800','乌干达'),(229,'804','乌克兰'),(230,'807','马其顿(南斯拉夫共和国)'),(231,'818','埃及'),(232,'826','英国'),(233,'831','格恩西'),(234,'832','泽西'),(235,'833','马恩岛'),(236,'834','坦桑尼亚'),(237,'840','美国'),(238,'850','维尔京群岛'),(239,'854','布基纳法索'),(240,'858','乌拉圭'),(241,'860','乌兹别克斯坦'),(242,'862','委内瑞拉'),(243,'876','瓦利斯群岛和富图纳群岛'),(244,'882','萨摩亚'),(245,'887','也门'),(246,'894','赞比亚');

CREATE TABLE `swgk_data_education` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` char(2) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COMMENT='学历表应符合gb/t 4658 2006';

insert  into `swgk_data_education`(`id`,`code`,`name`) values (1,'11','博士'),(2,'14','硕士'),(3,'21','学士'),(4,'31','专科'),(5,'41','中专'),(6,'44','职高'),(7,'47','技校'),(8,'61','高中'),(9,'71','初中'),(10,'81','小学'),(11,'90','其他');

CREATE TABLE `swgk_data_gender` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(1) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(3) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='性别表应符合gb/t 2261.1';

insert  into `swgk_data_gender`(`id`,`code`,`name`) values (1,'0','未填写'),(2,'1','男'),(3,'2','女'),(4,'9','保密');

CREATE TABLE `swgk_data_health` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(1) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(5) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='健康状态表应符合GB/T 2261.3';

insert  into `swgk_data_health`(`id`,`code`,`name`) values (1,'1','健康或良好'),(2,'2','一般或较弱'),(3,'3','有慢性病'),(4,'6','残疾');

CREATE TABLE `swgk_data_idtype` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(3) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(31) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COMMENT='证件类型表应符合ga/t 517';

insert  into `swgk_data_idtype`(`id`,`code`,`name`) values (1,'111','居民身份证'),(2,'114','军官证'),(3,'115','警官证'),(4,'414','普通护照'),(5,'5','户口本'),(6,'6','外交护照'),(7,'7','公务护照'),(8,'8','因公普通护照'),(9,'9','台湾居民来往大陆通行证'),(10,'3','港澳居民来往内地通行证'),(11,'11','华侨回国定居证'),(12,'12','台湾居民定居证'),(13,'13','普通签证'),(14,'14','外国人旅行证'),(15,'15','外国人居留许可'),(16,'17','外国人永久居留证'),(17,'112','临时居民身份证'),(18,'116','暂住证'),(19,'219','结婚证'),(20,'335','机动车驾驶证'),(21,'415','旅行证'),(22,'416','入出境通行证'),(23,'417','外国人出入境证'),(24,'419','海员证'),(25,'420','香港热别行政区护照'),(26,'421','澳门特别行政区护照'),(27,'423','澳门特别行政区旅行证'),(28,'512','台湾居民来往大陆通行证'),(29,'513','往来港澳通行证'),(30,'515','前往港澳通行证'),(31,'516','港澳同胞回乡证'),(32,'517','大陆居民往来台湾通行证'),(33,'518','因公往来香港澳门特别行政区通行证'),(34,'551','华侨回国定居证'),(35,'552','台湾居民定居证'),(36,'554','外国人居留证'),(37,'555','外国人临时居留证');

CREATE TABLE `swgk_data_marital` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` char(2) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COMMENT='婚姻状态表应符合gb/t 2261.2 2003';

insert  into `swgk_data_marital`(`id`,`code`,`name`) values (1,'10','未婚'),(2,'20','已婚'),(3,'21','初婚'),(4,'22','再婚'),(5,'23','复婚'),(6,'30','丧偶'),(7,'40','离婚'),(8,'90','未知');

CREATE TABLE `swgk_data_military` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(1) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(10) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT='兵役状态表，应符合GA/T 2000.36-2014';

insert  into `swgk_data_military`(`id`,`code`,`name`) values (1,'0','未服兵役'),(2,'1','退出现役'),(3,'2','士兵预备役'),(4,'3','军官预备役'),(5,'4','服现役'),(6,'9','其他');

CREATE TABLE `swgk_data_national` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(9) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COMMENT='民族表应符合gb/t 3304';

insert  into `swgk_data_national`(`id`,`code`,`name`) values (1,'01','汉族'),(2,'02','蒙古族'),(3,'03','回族'),(4,'04','藏族'),(5,'05','维吾尔族'),(6,'06','苗族'),(7,'07','彝族'),(8,'08','壮族'),(9,'09','布依族'),(10,'10','朝鲜族'),(11,'11','满族'),(12,'12','侗族'),(13,'13','瑶族'),(14,'14','白族'),(15,'15','土家族'),(16,'16','哈尼族'),(17,'17','哈萨克族'),(18,'18','傣族'),(19,'19','黎族'),(20,'20','傈僳族'),(21,'21','佤族'),(22,'22','畲族'),(23,'23','高山族'),(24,'24','拉祜族'),(25,'25','水族'),(26,'26','东乡族'),(27,'27','纳西族'),(28,'28','景颇族'),(29,'29','柯尔克孜族'),(30,'30','土族'),(31,'31','达斡尔族'),(32,'32','仫佬族'),(33,'33','羌族'),(34,'34','布朗族'),(35,'35','撒拉族'),(36,'36','毛难族'),(37,'37','仡佬族'),(38,'38','锡伯族'),(39,'39','阿昌族'),(40,'40','普米族'),(41,'41','塔吉克族'),(42,'42','怒族'),(43,'43','乌孜别克族'),(44,'44','俄罗斯族'),(45,'45','鄂温克族'),(46,'46','崩龙族'),(47,'47','保安族'),(48,'48','裕固族'),(49,'49','京族'),(50,'50','塔塔尔族'),(51,'51','独龙族'),(52,'52','鄂伦春族'),(53,'53','赫哲族'),(54,'54','门巴族'),(55,'55','珞巴族'),(56,'56','基诺族'),(57,'97','其他'),(58,'98','外国血统中国籍人士');

CREATE TABLE `swgk_data_peopletype` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` char(10) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='人口类型表';

insert  into `swgk_data_peopletype`(`id`,`code`,`name`) values (1,'01','户籍人口'),(2,'02','常住居民'),(3,'03','外来人口租房户');

CREATE TABLE `swgk_data_political` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(12) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COMMENT='政治面貌表应符合gb/t 4762-1984';

insert  into `swgk_data_political`(`id`,`code`,`name`) values (1,'13','群众'),(2,'01','中国共产党党员'),(3,'02','中国共产党预备党员'),(4,'03','中国共产主义青年团团员'),(5,'04','中国国民党革命委员会会员'),(6,'05','中国民主同盟盟员'),(7,'06','中国民主建国会会员'),(8,'07','中国民主促进会会员'),(9,'08','中国农工民主党党员'),(10,'09','中国致公党党员'),(11,'10','九三学社社员'),(12,'11','台湾民主自治同盟盟员'),(13,'12','无党派民主人土');

CREATE TABLE `swgk_data_relationship` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(15) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COMMENT='户主关系表编码应符合GB/T 4761';

insert  into `swgk_data_relationship`(`id`,`code`,`name`) values (1,'01','本人'),(2,'02','户主'),(3,'10','配偶'),(4,'11','夫'),(5,'12','妻'),(6,'20','子'),(7,'21','独生子'),(8,'22','长子'),(9,'23','次子'),(10,'24','三子'),(11,'25','四子'),(12,'26','五子'),(13,'27','养子或继子'),(14,'28','女婿'),(15,'29','其他儿子'),(16,'30','女'),(17,'31','独生女'),(18,'32','长女'),(19,'33','次女'),(20,'34','三女'),(21,'35','四女'),(22,'36','五女'),(23,'37','养女或继女'),(24,'38','儿媳'),(25,'39','其他女儿'),(26,'40','孙子、孙女或外孙子、外孙女'),(27,'41','孙子'),(28,'42','孙女'),(29,'43','外孙子'),(30,'44','外孙女'),(31,'45','孙媳妇或外孙媳妇'),(32,'46','孙女婿或外孙女婿'),(33,'47','曾孙子或外曾孙子'),(34,'48','曾孙女或外曾孙女'),(35,'49','其他孙子、孙女或外孙子、外孙女'),(36,'50','父母'),(37,'51','父亲'),(38,'52','母亲'),(39,'53','公公'),(40,'54','婆婆'),(41,'55','岳父'),(42,'56','岳母'),(43,'57','继父或养父'),(44,'58','继母或养母'),(45,'59','其他父母关系'),(46,'60','祖父母或外祖父母'),(47,'61','祖父'),(48,'62','祖母'),(49,'63','外祖父'),(50,'64','外祖母'),(51,'65','配偶的祖父母或外祖父母'),(52,'66','曾祖父'),(53,'67','曾祖母'),(54,'68','配偶的曾祖父母或外曾祖父母'),(55,'69','其他祖父母或外祖父母关系'),(56,'70','兄弟姐妹'),(57,'71','兄'),(58,'72','嫂'),(59,'73','弟'),(60,'74','弟媳'),(61,'75','姐姐'),(62,'76','姐夫'),(63,'77','妹妹'),(64,'78','妹夫'),(65,'79','其他兄弟姐妹'),(66,'80','其他'),(67,'81','伯父'),(68,'82','伯母'),(69,'83','叔父'),(70,'84','婶母'),(71,'85','舅父'),(72,'86','舅母'),(73,'87','姨父'),(74,'88','姨母'),(75,'89','姑父,'),(76,'90','姑母'),(77,'91','堂兄弟、堂姐妹'),(78,'92','表兄弟、表姐妹'),(79,'93','侄子'),(80,'94','侄女'),(81,'95','外甥'),(82,'96','外甥女'),(83,'97','其他亲属'),(84,'99','非亲属');

CREATE TABLE `swgk_data_religious` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(5) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='宗教信仰表应符合GA 214.12';

insert  into `swgk_data_religious`(`id`,`code`,`name`) values (1,'00','无宗教信仰'),(2,'10','佛教'),(3,'20','喇嘛教'),(4,'30','道教'),(5,'40','天主教'),(6,'50','基督教'),(7,'60','东正教'),(8,'70','伊斯兰教'),(9,'99','其他');

CREATE TABLE `swgk_media` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(101) NOT NULL DEFAULT '' COMMENT '资源名称',
  `path` varchar(301) NOT NULL DEFAULT '' COMMENT '资源路径',
  `desc` varchar(5010) NOT NULL DEFAULT '' COMMENT '资源描述',
  `size` double(10,1) NOT NULL DEFAULT '0.0' COMMENT '资源大小（单位：MB）',
  `cid` smallint(6) NOT NULL DEFAULT '0' COMMENT '所属分类，对应media_categories的id',
  `mark` varchar(301) NOT NULL DEFAULT '' COMMENT '资源标签',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '资源上传用户ID',
  `user_src` enum('pc','android','ios','h5') NOT NULL DEFAULT 'pc' COMMENT '资源上传用户的客户端类型',
  `ctime` datetime NOT NULL DEFAULT '1970-01-01 00:00:01' COMMENT '上传时间',
  `status` enum('正常','停用') NOT NULL DEFAULT '正常' COMMENT '媒体资源状态',
  `vid` varchar(21) NOT NULL DEFAULT '' COMMENT '网易云vid',
  `play_url` varchar(1002) NOT NULL DEFAULT '' COMMENT '电视端视频播放地址',
  `trans_status` enum('待转码','转码中','待注入','注入中','已注入') NOT NULL DEFAULT '待转码' COMMENT '媒资转码注入状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='媒体资源表';

CREATE TABLE `swgk_media_categories` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `category` varchar(101) NOT NULL DEFAULT '' COMMENT '分类',
  `c_desc` text COMMENT '分类描述',
  `c_status` enum('停用','使用') NOT NULL DEFAULT '使用' COMMENT '分类状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='媒体资源分类表';

CREATE TABLE `swgk_node` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `pid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '节点父ID',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '节点层级',
  `name` varchar(50) NOT NULL DEFAULT '' COMMENT '节点对应的方法名或者控制器名',
  `routing` varchar(50) NOT NULL DEFAULT '' COMMENT '管理端接口url',
  `sort` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '节点排序',
  `need_content` enum('否','是') NOT NULL DEFAULT '否' COMMENT '否-不可添加内容， 是-可添加内容',
  `typeid` varchar(10) NOT NULL DEFAULT '' COMMENT '网易云分类id',
  `icon` varchar(60) NOT NULL DEFAULT '' COMMENT '栏目图标',
  `title` varchar(22) NOT NULL DEFAULT '' COMMENT '栏目名称',
  `display` tinyint(3) NOT NULL DEFAULT '1' COMMENT '管理端是否展示 1-是 0-否',
  `urls` varchar(50) NOT NULL DEFAULT '' COMMENT '对外接口url',
  `node_type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '节点类型 1-栏目节点 0-功能节点',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=253 DEFAULT CHARSET=utf8mb4 COMMENT='节点表';

insert  into `swgk_node`(`id`,`pid`,`level`,`name`,`routing`,`sort`,`need_content`,`typeid`,`icon`,`title`,`display`,`urls`,`node_type`) values (1,0,0,'SystemConfig','',2,'否','','','栏目节点管理',1,'',1),(2,1,1,'','SystemConfig/systemNodeManage',0,'否','','','节点配置',1,'',1),(3,1,1,'','SystemConfig/powerSetting',2,'否','','','节点权限配置',1,'',1),(5,2,2,'','SystemConfig/addSystemNode',0,'否','','','栏目添加',0,'',0),(6,2,2,'','SystemConfig/updateSystemNode',2,'否','','','栏目修改',0,'',0),(7,3,2,'','SystemConfig/grantRole',0,'否','','','权限配置',0,'',0),(8,0,0,'SystemConfig','',4,'否','','','系统配置',1,'',1),(9,8,1,'','SystemConfig/safe',0,'否','','','密码安全',1,'',1),(10,8,1,'','SystemConfig/configSet',2,'否','','','通用配置',1,'',1),(11,8,1,'','SystemConfig/holidays',4,'否','','','节假日配置',1,'',1),(12,0,0,'SystemConfig','',6,'否','','','积分配置',0,'',1),(13,12,1,'','SystemConfig/CIVPointManage',0,'否','','','文明积分配置',1,'',1),(16,0,0,'SystemConfig','',10,'否','','','区域管理',1,'',1),(17,16,1,'','SystemConfig/regionManage',10,'否','','','区域管理',1,'',1),(18,0,0,'Library','',12,'否','','','图书管理',1,'',1),(19,18,1,'','BooksManage/BooksLibrary/BooksLibrary',0,'否','','','图书馆',1,'',1),(20,18,1,'','BooksManage/BooksLibrary/BookEntry',2,'否','','','图书录入',1,'',1),(21,18,1,'','BooksManage/BooksLibrary/bookCode',4,'否','','','图书编码生成',1,'',1),(23,0,0,'Library','',14,'否','','','图书借阅',1,'',1),(24,23,1,'','BooksManage/BooksLook/BooksLend',0,'否','','','图书借阅',1,'',1),(25,23,1,'','BooksManage/BooksLook/BookBack',2,'否','','','图书归还',1,'',1),(26,0,0,'Library','',16,'否','','','读书笔记',1,'',1),(27,26,1,'','BooksManage/BooksNotes/NotesReview',0,'否','','','笔记审核',1,'',1),(28,26,1,'','BooksManage/BooksNotes/NotesHistory',2,'否','','','笔记历史',1,'',1),(29,0,0,'Library','',18,'否','','','读书积分',1,'',1),(30,29,1,'','BooksManage/BooksPoint/bookPointExc',0,'否','','','积分兑换',1,'',1),(31,29,1,'','BooksManage/BooksPoint/bookPointExcHistory',2,'否','','','兑换历史',1,'',1),(33,29,1,'','BooksManage/BooksPoint/BooksYearPoint',6,'否','','','读书年度积分',1,'',1),(34,0,0,'UserManage','',20,'否','','','用户管理',1,'',1),(36,35,2,'','SystemConfig/getUserList',0,'否','','','条件查找',0,'',0),(37,35,2,'','SystemConfig/userStatusChange',2,'否','','','封禁',0,'',0),(38,35,2,'','SystemConfig/userStatusChange',4,'否','','','解禁',0,'',0),(39,35,2,'','SystemConfig/resetPassword',6,'否','','','密码重置',0,'',0),(40,34,1,'/UserManage/getRoleList','UserManage/manRoleManage',2,'否','','','角色管理',1,'',1),(41,40,2,'/UserManage/addRole','',0,'否','','','新增角色',0,'',0),(42,40,2,'/UserManage/editRole','',0,'否','','','编辑角色',0,'',0),(43,0,0,'BaseData','',22,'否','','','基础信息管理',1,'',1),(44,43,1,'/BasePeople/getList','/Basicinfo/people',0,'否','','','人口信息管理',1,'',1),(45,43,1,'/Building/getBuildingInfo','Basicinfo/buliding',2,'否','','','建筑信息管理',1,'',1),(46,43,1,'/House/getHouseInfo','Basicinfo/house',3,'否','','','房屋信息管理',1,'',1),(47,43,1,'/Unit/getUnitList','Basicinfo/unit',5,'否','','','社区部件管理',1,'',1),(48,12,1,'','SystemConfig/readPointManage',4,'否','','','读书积分配置',1,'',1),(49,0,0,'Party/index','',2,'否','','','党建',1,'',1),(50,49,1,'/Party/organization','Party/organization',0,'否','','','党组织管理',1,'',1),(51,0,0,'/Party/course','/contentManage/contentEdit',2,'是','','','智慧党建',1,'',1),(53,49,1,'/Party/member','/Party/member',0,'否','','','党员管理',1,'',1),(56,44,2,'/BasePeople/addPeopleBaseInfo','',0,'否','','','新增人口信息',0,'',0),(57,44,2,'/BasePeople/editPeopleBaseInfo','',0,'否','','','修改人口信息',0,'',0),(58,43,1,'/BasePeople/getFamilyList','Basicinfo/familyTies',1,'否','','','家庭关系管理',1,'',1),(59,58,2,'/BasePeople/getMemberList','',0,'否','','','获取家庭成员列表',0,'',0),(60,58,2,'/BasePeople/editFamily','',0,'否','','','修改家庭关系',0,'',0),(61,58,2,'/BasePeople/addMember','',0,'否','','','新增家庭成员',0,'',0),(62,58,2,'/BasePeople/editMember','',0,'否','','','修改家庭成员',0,'',0),(63,58,2,'/BasePeople/deleteMember','',0,'否','','','删除家庭成员',0,'',0),(64,58,2,'/BasePeople/searchPeopleInfo','',0,'否','','','搜索人员信息',0,'',0),(65,0,0,'/SmartProperty/index','',0,'否','','','智慧物业',1,'',1),(66,65,1,'/GridManage/getGridList','SmartProperty/GridManage',1,'否','','','网格管理',1,'',1),(67,66,2,'/GridManage/addGrid','',0,'否','','','新增网格',0,'',0),(68,66,2,'/GridManage/editGrid','',0,'否','','','修改网格',0,'',0),(69,66,2,'/GridManage/deleteGrid','',0,'否','','','删除网格',0,'',0),(70,23,1,'/CardManage/getCardList','Basicinfo/card',6,'否','','','IC卡管理',1,'',1),(71,70,2,'/CardManage/addCard','',0,'否','','','录入IC卡',0,'',0),(72,70,2,'/CardManage/editCard','',0,'否','','','修改IC卡',0,'',0),(73,70,2,'/CardManage/deleteCard','',0,'否','','','删除IC卡',0,'',0),(74,70,2,'/CardManage/changeCardStatus','',0,'否','','','改变IC卡状态',0,'',0),(76,43,1,'/Unit/getUnitDepartmentList','Basicinfo/unitDepartment',4,'否','','','部件部门管理',1,'',1),(78,76,2,'/Unit/addUnitDepartment','',0,'否','','','新增',0,'',0),(79,76,2,'/Unit/editUnitDepartment','',0,'否','','','修改',0,'',0),(84,47,2,'/Unit/addUnit','',0,'否','','','新增',0,'',0),(85,47,2,'/Unit/editUnit','',0,'否','','','修改',0,'',0),(86,47,2,'/Unit/deleteUnit','',0,'否','','','删除',0,'',0),(87,12,1,'','SystemConfig/partyPointManage',2,'否','','','党员积分配置',1,'',1),(88,0,0,'','',2,'否','','','党员积分',1,'',1),(89,88,1,'','memberIntegral/annualIntegral',0,'否','','','党员年度积分',1,'',1),(92,47,2,'/Unit/getUnitDepartmentJson','',0,'否','','','获取部件所属部门JSON数据',0,'',0),(93,49,1,'','Party/jobManage',0,'否','','','职务管理',1,'',1),(94,45,2,'/Building/addBuilding','',0,'否','','','新增建筑信息',0,'',0),(95,45,2,'/Building/editBuilding','',0,'否','','','修改建筑信息',0,'',0),(96,45,2,'/Building/deleteBuilding','',0,'否','','','删除建筑信息',0,'',0),(97,46,2,'/House/addHouse','',0,'否','','','新增房屋信息',0,'',0),(98,46,2,'/House/editHouse','',0,'否','','','修改房屋信息',0,'',0),(99,46,2,'/House/deleteHouse','',0,'否','','','删除房屋信息',0,'',0),(100,0,0,'','CIVP/',2,'否','','','文明积分',1,'',1),(101,100,1,'','CIVP/pointDeduction',6,'否','','','文明扣分项管理',1,'',1),(102,100,1,'','CIVP/personalPoint',4,'否','','','文明基础积分管理',1,'',1),(103,100,1,'','CIVP/personalViolations',2,'否','','','文明积分管理',1,'',1),(104,100,1,'','CIVP/civiYear',0,'否','','','家庭年度积分',1,'',1),(105,0,0,'','',2,'否','','','媒资管理',1,'',1),(106,105,1,'','/media/type',0,'否','','','资产分类管理',1,'',1),(107,105,1,'','/media/docManage',0,'否','','','资产文件管理',1,'',1),(109,0,0,'','',2,'否','','','内容管理',1,'',1),(110,109,1,'','contentManage/collectContent',0,'否','','','内容采集',1,'',1),(112,109,1,'','contentManage/releaseContent',0,'否','','','内容审核',1,'',1),(113,109,1,'','LevalMessage/collectMessage',0,'否','','','评论查看',1,'',1),(114,109,1,'','LevalMessage/auditMessage',0,'否','','','评论审核（取消）',0,'',1),(115,109,1,'','LevalMessage/releaseMessage',0,'否','','','评论审核',1,'',1),(116,40,2,'/UserManage/getPermissions','',0,'否','','','获取栏目节点树',0,'',0),(117,40,2,'/UserManage/changeRoleStatus','',0,'否','','','启用/禁用',0,'',0),(118,58,2,'/BasePeople/searchHouseInfo','',0,'否','','','通过房主姓名搜索房屋列表',0,'',0),(119,34,1,'/UserManage/getGridUserList','UserManage/grider',0,'否','','','网格员管理',0,'',1),(120,65,1,'/GridManage/getTrackList','/SmartProperty/track',2,'否','','','电子巡查',1,'',1),(121,65,1,'/GridManage/getVisitList','/SmartProperty/visit',3,'否','','','电子走访',1,'',1),(122,65,1,'/AttenceSystem/getAttendanceData','/SmartProperty/attence',4,'否','','','电子考勤记录',1,'',1),(124,0,0,'GridManage/checkout','SmartProperty/checkout',0,'否','','','考核评比',1,'',1),(125,65,1,'GridManage/gridMap','SmartProperty/map',0,'否','','','网格地图',1,'',1),(126,0,0,'/Event/index','',0,'否','','','事件联动',1,'',1),(127,43,1,'/Department/getDepartmentList','Basicinfo/department',1,'否','','','办事部门管理',1,'',1),(128,34,1,'/UserManage/getDepartmentUserList','UserManage/departmentUser',0,'否','','','部门人员管理',0,'',1),(129,0,1,'MeetingRoom','',22,'否','','','会议室管理',1,'',1),(130,129,2,'','meetingRoom/meetingManage',0,'否','','','会议室管理',1,'',1),(131,129,2,'','meetingRoom/attenceManage',6,'否','','','会议室考勤管理',1,'',1),(132,34,1,'/UserManage/getLeadUserList','UserManage/leadUser',0,'否','','','角色人员管理',1,'',1),(133,127,2,'/Department/addDepartment','',0,'否','','','新增部门信息',0,'',0),(134,127,2,'/Department/editDepartment','',0,'否','','','编辑部门信息',0,'',0),(135,65,1,'/AttenceSystem/getAttenceConfig','/SmartProperty/attenceConfig',5,'否','','','电子考勤配置',1,'',1),(136,135,2,'/AttenceSystem/editAttenceConfig','',0,'否','','','编辑考勤配置',0,'',0),(137,129,2,'','meeting/meetingManage',2,'否','','','会议管理',1,'',1),(138,51,1,'','contentManage/contentEdit',0,'是','','','党建动态',1,'',1),(139,51,1,'','contentManage/contentEdit',0,'是','','','学习园地',1,'',1),(148,51,1,'','contentManage/contentEdit',0,'是','','','傅村党总支',1,'',1),(152,0,0,'','',2,'是','','','三务公开',1,'',1),(153,152,1,'','contentManage/contentEdit',0,'是','','','党务',1,'',1),(154,152,1,'','contentManage/contentEdit',0,'是','','','村务',1,'',1),(155,152,1,'','contentManage/contentEdit',0,'是','','','财务',1,'',1),(158,51,1,'','contentManage/contentEdit',6,'是','','','党群管理',1,'',1),(159,172,1,'/Event/getEventTypes','eventManage/eventType',0,'否','','','事件类型管理',1,'',1),(160,172,1,'/Event/getItemList','eventManage/eventSet',0,'否','','','事件流程配置',1,'',1),(161,126,1,'/Event/addEvent','eventManage/addEvent',8,'否','','','事件登记',1,'',1),(162,126,1,'/Event/enter','eventManage/console',4,'否','','','事件历史',0,'',1),(163,126,1,'/Event/getWaitDealList','eventManage/waitDeal',2,'否','','newDefined-icon-orderEnd','待办理',0,'',1),(164,126,1,'/Event/getWaitAssignList','eventManage/waitAssign',4,'否','','newDefined-icon-accept','待派单',0,'',1),(165,126,1,'/Event/getWaitAuditList','eventManage/waitAudit',6,'否','','newDefined-icon-orderVerify','待审核',0,'',1),(166,126,1,'/Event/getWaitReceiveList','eventManage/waitReceive',8,'否','','newDefined-icon-orderFill','待接单',0,'',1),(167,126,1,'/Event/getAlreadyFileList','eventManage/alreadyFile',10,'否','','newDefined-icon-orderFills','已归档',0,'',1),(168,126,1,'/Event/getAlreadyRejectList','eventManage/alreadyReject',12,'否','','newDefined-icon-orderReject','已驳回',0,'',1),(169,126,1,'/Event/getBeRejectedList','eventManage/beRejected',14,'否','','newDefined-icon-orderBack','被驳回',0,'',1),(170,126,1,'/Event/getMyDealList','eventManage/myDeal',6,'否','','newDefined-icon-orderHistory','办理历史',1,'',1),(171,126,1,'/Event/getMySubmitList','eventManage/myDeal',20,'否','','newDefined-icon-orderMe','我登记的',1,'',1),(172,0,0,'/Event/config','',1,'否','','','事件配置',1,'',1),(173,0,0,'','',2,'是','','','首页内容',1,'',1),(174,173,1,'','contentManage/contentEdit',0,'是','','','小程序轮播广告',1,'',1),(176,0,0,'','rules/rules',2,'否','','','规章制度',1,'',1),(177,176,1,'','rules/rules',0,'否','','','规章制度',1,'',1),(178,159,2,'/Event/addEventType','',0,'否','','','新增事件类型',0,'',0),(179,159,2,'/Event/editEventType','',0,'否','','','修改事件类型',0,'',0),(180,124,1,'AssessManage/eventCount','AssessManage/eventCount',1,'否','','','事件上报统计',1,'',1),(181,124,1,'AssessManage/attenceGrider','AssessManage/attence',0,'否','','','日常考勤统计',1,'',1),(182,124,1,'AssessManage/eventScore','AssessManage/eventScore',3,'否','','','事件评分统计',1,'',1),(183,124,1,'AssessManage/eventCountOrder','AssessManage/eventCountOrder',2,'否','','','事件上报排名',1,'',1),(184,124,1,'AssessManage/eventScoreOrder','AssessManage/eventScoreOrder',4,'否','','','事件评分排名',1,'',1),(186,43,1,'/BasePeople/getLocalPeopleList','Basicinfo/rentHousePeople',0,'否','','','本地户籍人口',1,'',1),(187,43,1,'/BasePeople/getBuyHousePeopleList','Basicinfo/rentHousePeople',0,'否','','','外来买房人口',1,'',1),(188,43,1,'/BasePeople/getRentHousePeopleList','Basicinfo/rentHousePeople',0,'否','','','外来租房人口',1,'',1),(189,126,1,'/eventManage/showEventMap','/eventManage/eventMap',2,'否','','','事件地图',1,'',1),(191,23,1,'','BooksManage/BooksLibrary/bookBorrowing',4,'否','','','在借图书',1,'',1),(192,23,1,'','BooksManage/BooksLibrary/bookBorrowed',5,'否','','','借阅历史',1,'',1),(194,126,1,'','alarm/emergenceAlarm',1,'否','','','告警处理',0,'',1),(199,173,1,'','contentManage/contentEdit',0,'是','','','民主评议',1,'',1),(205,0,0,'/Party/practice','/contentManage/contentEdit',2,'是','','','文明实践',1,'',1),(206,205,1,'','/contentManage/contentEdit',0,'是','','','文明动态',1,'',1),(208,205,1,'','/contentManage/contentEdit',0,'是','','','社区课堂',1,'',1),(209,205,1,'','/contentManage/contentEdit',0,'是','','','文娱队伍',1,'',1),(214,0,0,'/Party/classification','/contentManage/contentEdit',2,'是','','','历史沿革',1,'',1),(215,214,1,'','/contentManage/contentEdit',0,'是','','','傅村故事',1,'',1),(217,214,1,'','contentManage/contentEdit',0,'是','','','作品展示',1,'',1),(220,0,0,'BossManage/boss','',0,'否','','','电视端管理',1,'',1),(221,220,1,'/BossManage/getCardList','Boss/card',0,'否','','','CA卡号管理',1,'',1),(222,221,2,'/BossManage/addCard','',0,'否','','','录入CA卡',0,'',0),(223,221,2,'/BossManage/editCard','',0,'否','','','修改CA卡',0,'',0),(224,221,2,'/BossManage/deleteCard','',0,'否','','','删除CA卡',0,'',0),(225,221,2,'/BossManage/changeCardStatus','',0,'否','','','改变CA卡状态',0,'',0),(226,221,2,'/BossManage/importCard','',0,'否','','','批量导入CA卡',0,'',0),(227,0,0,'','',0,'否','','','志愿者',1,'',1),(228,227,1,'','Volunteer/VolunteerApplication',0,'否','','','志愿者审核',1,'',1),(229,227,1,'','Volunteer/VolunteerPoint',4,'否','','','志愿者积分',1,'',1),(230,8,1,'/SystemConfig/getAppList','/SystemConfig/appList',0,'否','','','版本管理',1,'',1),(231,35,2,'','',0,'否','','','TV端首页滚动条',1,'',1),(232,220,2,'/BossManage/getTVidxMarquee','Boss/TVidxMarquee',0,'否','','','TV滚动条管理',1,'',1),(233,0,0,'','',0,'是','','','平安傅村',1,'',1),(234,233,1,'','contentManage/contentEdit',0,'是','','','社区民警',1,'',1),(235,233,1,'','contentManage/contentEdit',0,'是','','','法治宣传',1,'',1),(236,233,1,'','contentManage/contentEdit',0,'是','','','社区安全栏',1,'',1),(237,233,1,'','contentManage/contentEdit',0,'是','','','网格管理',1,'',1),(238,205,1,'','contentManage/contentEdit',0,'是','','','便民信息',1,'',1),(239,126,1,'/Event/getWaitDealEventList','/eventManage/synthesize',0,'否','','','事件办理',1,'',1),(240,49,1,'/Party/org_auth','Party/org_auth',0,'否','','','党组织权限管理',1,'',1),(241,220,1,'/BossManage/getTVidxVideoFrame','Boss/TVidxVideoFrame',0,'否','','','TV首页视频管理',1,'',1),(242,129,2,'','Camera/liveManage',4,'否','','','会议直播管理',1,'',1),(243,88,1,'','memberIntegral/partyPointOption',0,'否','','','党员加(扣)分项管理',1,'',1),(244,205,1,'','/contentManage/contentEdit',0,'是','','','乡风文明',1,'',1),(245,227,1,'','Volunteer/VolunteerApplication',2,'否','','','志愿者列表',1,'',1),(246,65,1,'','SmartProperty/garbageStatistics',0,'否','','','垃圾分类统计',1,'',1),(247,126,1,'/Event/searchEventList','eventManage/searchDeal',22,'否','','','所有事件',1,'',1),(248,65,1,'','SmartProperty/deductionPointReason',0,'否','','','垃圾分类扣分原因',1,'',1),(249,233,1,'','contentManage/contentEdit',0,'是','','','调解委员会',1,'',1),(250,0,0,'','discuss/discussBan',0,'否','','','居民议事板',1,'',1),(251,250,1,'','discuss/discussBan',0,'否','','','居民议事板',1,'',1),(252,227,1,'','Volunteer/VolunteerPointLogs',6,'否','','','志愿者积分详细',1,'',1);

CREATE TABLE `swgk_operate_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `auth_type` char(2) NOT NULL DEFAULT '01' COMMENT '授权方式 (01 账号登录 02 授权登录)',
  `operator_uuid` char(32) NOT NULL DEFAULT '' COMMENT '操作人uuid',
  `operate_platform` enum('android','ios','pc') NOT NULL DEFAULT 'pc' COMMENT '操作平台类型',
  `operate_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  `operate_ip` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作人IP',
  `operate_status` enum('y','n') NOT NULL DEFAULT 'y' COMMENT '操作状态 n-失败 y-成功',
  `operate_info` varchar(100) NOT NULL DEFAULT '' COMMENT '操作描述',
  `urls` varchar(100) NOT NULL DEFAULT '' COMMENT '操作的地址',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户操作日志表';

CREATE TABLE `swgk_praise_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `c_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID, 对应content表ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '点赞用户,对应base_ppl表uuid',
  `ctime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '投票时间',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '是否点赞，0-否 1-赞',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='内容点赞表';

CREATE TABLE `swgk_region` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT  COMMENT '表ID',
  `name` varchar(101) NOT NULL COMMENT '区域名称',
  `pid` varchar(20) NOT NULL COMMENT '父区域ID',
  `code` varchar(20) NOT NULL COMMENT '区域码',
  `begin_ip` varchar(21) NOT NULL DEFAULT '0' COMMENT '区域起始IP的整数值',
  `end_ip` varchar(21) NOT NULL DEFAULT '0' COMMENT '区域末尾IP的整数值',
  `levels` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '区域级别 0-省 1-市 2-区/县 3-乡镇街道 4-社区/行政村',
  `status` enum('上线','下线') NOT NULL DEFAULT '下线' COMMENT '项目状态',
  `temp_id` varchar(30) NOT NULL DEFAULT '0' COMMENT '模板ID',
  `logo_path` varchar(101) NOT NULL DEFAULT '' COMMENT 'logo路径',
  `pic` varchar(301) NOT NULL DEFAULT '' COMMENT '区域图片',
  `region_desc` text COMMENT '区域描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='区域表';

insert  into `swgk_region`(`id`,`name`,`pid`,`code`,`begin_ip`,`end_ip`,`levels`,`status`,`temp_id`,`logo_path`,`pic`,`region_desc`) values (9,'温岭市','0','331081000000','0','0',2,'下线','1','','',NULL),(104,'太平街道','331081000000','331081001000','0','0',3,'下线','1','','',NULL),(105,'城东街道','331081000000','331081002000','0','0',3,'下线','1','','',NULL),(106,'城西街道','331081000000','331081003000','0','0',3,'下线','1','','',NULL),(107,'城北街道','331081000000','331081004000','0','0',3,'下线','1','','',NULL),(108,'横峰街道','331081000000','331081005000','0','0',3,'下线','1','','',NULL),(109,'泽国镇','331081000000','331081100000','0','0',3,'下线','1','','',NULL),(110,'大溪镇','331081000000','331081101000','0','0',3,'下线','1','','',NULL),(111,'松门镇','331081000000','331081102000','0','0',3,'下线','1','','',NULL),(112,'箬横镇','331081000000','331081103000','0','0',3,'下线','1','','',NULL),(113,'新河镇','331081000000','331081104000','0','0',3,'下线','1','','',NULL),(114,'石塘镇','331081000000','331081105000','0','0',3,'下线','1','','',NULL),(115,'滨海镇','331081000000','331081106000','0','0',3,'下线','1','','',NULL),(116,'温峤镇','331081000000','331081107000','0','0',3,'下线','1','','',NULL),(117,'城南镇','331081000000','331081108000','0','0',3,'下线','1','','',NULL),(118,'石桥头镇','331081000000','331081109000','0','0',3,'下线','1','','',NULL),(119,'坞根镇','331081000000','331081110000','0','0',3,'下线','1','','',NULL),(3190,'迎辉社区','331081001000','331081001003','0','0',4,'下线','1','','',NULL),(3191,'月河社区','331081001000','331081001008','0','0',4,'下线','1','','',NULL),(3192,'西园社区','331081001000','331081001014','0','0',4,'下线','1','','',NULL),(3193,'东辉社区','331081001000','331081001018','0','0',4,'下线','1','','',NULL),(3194,'繁昌社区','331081001000','331081001019','0','0',4,'下线','1','','',NULL),(3195,'三星社区','331081001000','331081001021','0','0',4,'下线','1','','',NULL),(3196,'太平社区','331081001000','331081001022','0','0',4,'下线','1','','',NULL),(3197,'方城社区','331081001000','331081001023','0','0',4,'下线','1','','',NULL),(3198,'锦园社区','331081001000','331081001024','0','0',4,'下线','1','','',NULL),(3199,'锦屏社区','331081001000','331081001025','0','0',4,'下线','1','','',NULL),(3200,'南屏社区','331081001000','331081001026','0','0',4,'下线','1','','',NULL),(3201,'南泉社区','331081001000','331081001027','0','0',4,'下线','1','','',NULL),(3202,'卖鱼桥社区','331081001000','331081001028','0','0',4,'下线','1','','',NULL),(3203,'尚书坊社区','331081001000','331081001029','0','0',4,'下线','1','','',NULL),(3204,'东门村','331081001000','331081001200','0','0',4,'下线','1','','',NULL),(3205,'南门村','331081001000','331081001201','0','0',4,'下线','1','','',NULL),(3206,'西门村','331081001000','331081001202','0','0',4,'下线','1','','',NULL),(3207,'北门村','331081001000','331081001203','0','0',4,'下线','1','','',NULL),(3208,'塔下村','331081001000','331081001204','0','0',4,'下线','1','','',NULL),(3209,'三星桥村','331081001000','331081001205','0','0',4,'下线','1','','',NULL),(3210,'北山村','331081001000','331081001206','0','0',4,'下线','1','','',NULL),(3211,'田洋村','331081001000','331081001207','0','0',4,'下线','1','','',NULL),(3212,'小南门村','331081001000','331081001208','0','0',4,'下线','1','','',NULL),(3213,'岙底杨村','331081001000','331081001209','0','0',4,'下线','1','','',NULL),(3214,'西郊村','331081001000','331081001210','0','0',4,'下线','1','','',NULL),(3215,'岙底胡村','331081001000','331081001211','0','0',4,'下线','1','','',NULL),(3216,'下河村','331081001000','331081001214','0','0',4,'下线','1','','',NULL),(3217,'后应村','331081001000','331081001215','0','0',4,'下线','1','','',NULL),(3218,'屏下村','331081001000','331081001216','0','0',4,'下线','1','','',NULL),(3219,'小河头村','331081001000','331081001217','0','0',4,'下线','1','','',NULL),(3220,'山下金村','331081001000','331081001218','0','0',4,'下线','1','','',NULL),(3221,'肖泉村','331081001000','331081001219','0','0',4,'下线','1','','',NULL),(3222,'梅岭村','331081001000','331081001220','0','0',4,'下线','1','','',NULL),(3223,'东湖社区','331081002000','331081002001','0','0',4,'下线','1','','',NULL),(3224,'锦屏社区','331081002000','331081002002','0','0',4,'下线','1','','',NULL),(3225,'翠屏社区','331081002000','331081002003','0','0',4,'下线','1','','',NULL),(3226,'九龙汇','331081002000','331081002004','0','0',4,'下线','1','','',NULL),(3227,'后塘岸村','331081002000','331081002200','0','0',4,'下线','1','','',NULL),(3228,'金家村','331081002000','331081002201','0','0',4,'下线','1','','',NULL),(3229,'袁家村','331081002000','331081002202','0','0',4,'下线','1','','',NULL),(3230,'蔡家村','331081002000','331081002203','0','0',4,'下线','1','','',NULL),(3231,'前岙村','331081002000','331081002204','0','0',4,'下线','1','','',NULL),(3232,'许家村','331081002000','331081002205','0','0',4,'下线','1','','',NULL),(3233,'乌龙岙村','331081002000','331081002206','0','0',4,'下线','1','','',NULL),(3234,'汪家村','331081002000','331081002207','0','0',4,'下线','1','','',NULL),(3235,'山河村','331081002000','331081002208','0','0',4,'下线','1','','',NULL),(3236,'庆恩王村','331081002000','331081002209','0','0',4,'下线','1','','',NULL),(3237,'横山头村','331081002000','331081002210','0','0',4,'下线','1','','',NULL),(3238,'高园村','331081002000','331081002211','0','0',4,'下线','1','','',NULL),(3239,'林家村','331081002000','331081002212','0','0',4,'下线','1','','',NULL),(3240,'山凰村','331081002000','331081002213','0','0',4,'下线','1','','',NULL),(3241,'洋河村','331081002000','331081002214','0','0',4,'下线','1','','',NULL),(3242,'虎头山村','331081002000','331081002215','0','0',4,'下线','1','','',NULL),(3243,'楼山村','331081002000','331081002216','0','0',4,'下线','1','','',NULL),(3244,'紫皋村','331081002000','331081002217','0','0',4,'下线','1','','',NULL),(3245,'石仓下村','331081002000','331081002218','0','0',4,'下线','1','','',NULL),(3246,'紫皋陆村','331081002000','331081002219','0','0',4,'下线','1','','',NULL),(3247,'鸡鸣村','331081002000','331081002220','0','0',4,'下线','1','','',NULL),(3248,'河边村','331081002000','331081002221','0','0',4,'下线','1','','',NULL),(3249,'汇头王村','331081002000','331081002222','0','0',4,'下线','1','','',NULL),(3250,'下蒋村','331081002000','331081002223','0','0',4,'下线','1','','',NULL),(3251,'莘塘村','331081002000','331081002224','0','0',4,'下线','1','','',NULL),(3252,'后洋吴村','331081002000','331081002225','0','0',4,'下线','1','','',NULL),(3253,'山南前村','331081002000','331081002226','0','0',4,'下线','1','','',NULL),(3254,'西岙咀村','331081002000','331081002227','0','0',4,'下线','1','','',NULL),(3255,'岩下村','331081002000','331081002228','0','0',4,'下线','1','','',NULL),(3256,'横湖桥村','331081002000','331081002229','0','0',4,'下线','1','','',NULL),(3257,'下岸渚村','331081002000','331081002230','0','0',4,'下线','1','','',NULL),(3258,'渭渚村','331081002000','331081002231','0','0',4,'下线','1','','',NULL),(3259,'殿前村','331081002000','331081002232','0','0',4,'下线','1','','',NULL),(3260,'瓦窑头村','331081002000','331081002233','0','0',4,'下线','1','','',NULL),(3261,'瓦林村','331081002000','331081002234','0','0',4,'下线','1','','',NULL),(3262,'下罗村','331081002000','331081002235','0','0',4,'下线','1','','',NULL),(3263,'晋岙村','331081002000','331081002236','0','0',4,'下线','1','','',NULL),(3264,'坦头村','331081002000','331081002237','0','0',4,'下线','1','','',NULL),(3265,'外球村','331081002000','331081002238','0','0',4,'下线','1','','',NULL),(3266,'肖溪村','331081002000','331081002239','0','0',4,'下线','1','','',NULL),(3267,'东焦湾村','331081002000','331081002240','0','0',4,'下线','1','','',NULL),(3268,'湖南村','331081002000','331081002241','0','0',4,'下线','1','','',NULL),(3269,'下岙严村','331081002000','331081002242','0','0',4,'下线','1','','',NULL),(3270,'前黄村','331081002000','331081002243','0','0',4,'下线','1','','',NULL),(3271,'川城社区','331081003000','331081003001','0','0',4,'下线','1','','','川城社区下蔡村'),(3272,'开元社区','331081003000','331081003002','0','0',4,'下线','1','','',''),(3273,'湖畔社区','331081003000','331081003003','0','0',4,'下线','1','','',NULL),(3274,'渭川村','331081003000','331081003200','0','0',4,'下线','1','','',NULL),(3275,'高洋村','331081003000','331081003201','0','0',4,'下线','1','','',NULL),(3276,'神童门村','331081003000','331081003202','0','0',4,'下线','1','','',NULL),(3277,'下洋应村','331081003000','331081003203','0','0',4,'下线','1','','',NULL),(3278,'下保宅前村','331081003000','331081003204','0','0',4,'下线','1','','',NULL),(3279,'九龙湖社区','331081003000','331081003205','0','0',4,'下线','1','','',NULL),(3280,'上林村','331081003000','331081003206','0','0',4,'下线','1','','',NULL),(3281,'芝岙村','331081003000','331081003207','0','0',4,'下线','1','','',NULL),(3282,'鉴洋村','331081003000','331081003208','0','0',4,'下线','1','','',NULL),(3283,'合岙村','331081003000','331081003209','0','0',4,'下线','1','','',NULL),(3285,'王府基村','331081003000','331081003211','0','0',4,'下线','1','','',NULL),(3286,'西岙村','331081003000','331081003212','0','0',4,'下线','1','','',NULL),(3287,'康庭社区','331081003000','331081003213','0','0',4,'下线','1','','','康庭社区莞田下岙'),(3288,'吴岙村','331081003000','331081003214','0','0',4,'下线','1','','',NULL),(3290,'螺屿村','331081003000','331081003216','0','0',4,'下线','1','','',NULL),(3291,'下岙村','331081003000','331081003217','0','0',4,'下线','1','','',NULL),(3292,'芷胜庄村','331081003000','331081003218','0','0',4,'下线','1','','',NULL),(3293,'吴山村','331081003000','331081003219','0','0',4,'下线','1','','',NULL),(3294,'王小田村','331081003000','331081003220','0','0',4,'下线','1','','',NULL),(3295,'沿江社区','331081004000','331081004001','0','0',4,'下线','1','','',NULL),(3296,'石粘村','331081004000','331081004200','0','0',4,'下线','1','','',NULL),(3297,'山马村','331081004000','331081004201','0','0',4,'下线','1','','',NULL),(3298,'山头赵村','331081004000','331081004202','0','0',4,'下线','1','','',NULL),(3299,'南山村','331081004000','331081004203','0','0',4,'下线','1','','',NULL),(3300,'南山闸村','331081004000','331081004204','0','0',4,'下线','1','','',NULL),(3301,'六份村','331081004000','331081004205','0','0',4,'下线','1','','',NULL),(3302,'琅岙村','331081004000','331081004206','0','0',4,'下线','1','','',NULL),(3303,'麻车村','331081004000','331081004207','0','0',4,'下线','1','','',NULL),(3304,'花桥村','331081004000','331081004208','0','0',4,'下线','1','','',NULL),(3305,'横塘村','331081004000','331081004209','0','0',4,'下线','1','','',NULL),(3306,'沧浦村','331081004000','331081004210','0','0',4,'下线','1','','',NULL),(3307,'芳田村','331081004000','331081004211','0','0',4,'下线','1','','',NULL),(3308,'九份村','331081004000','331081004212','0','0',4,'下线','1','','',NULL),(3309,'后陈村','331081004000','331081004213','0','0',4,'下线','1','','',NULL),(3310,'东普村','331081004000','331081004214','0','0',4,'下线','1','','',NULL),(3311,'杨家渭村','331081004000','331081004215','0','0',4,'下线','1','','',NULL),(3312,'宗文社区','331081005000','331081005001','0','0',4,'下线','1','','',NULL),(3313,'横峰村','331081005000','331081005200','0','0',4,'下线','1','','',NULL),(3314,'马鞍桥村','331081005000','331081005201','0','0',4,'下线','1','','',NULL),(3315,'汇川王村','331081005000','331081005202','0','0',4,'下线','1','','',NULL),(3316,'长洋村','331081005000','331081005203','0','0',4,'下线','1','','',NULL),(3317,'石刺头村','331081005000','331081005204','0','0',4,'下线','1','','',NULL),(3318,'上洋林村','331081005000','331081005205','0','0',4,'下线','1','','',NULL),(3319,'下洋林村','331081005000','331081005206','0','0',4,'下线','1','','',NULL),(3320,'石埭村','331081005000','331081005207','0','0',4,'下线','1','','',NULL),(3321,'东洋村','331081005000','331081005208','0','0',4,'下线','1','','',NULL),(3322,'东塘村','331081005000','331081005209','0','0',4,'下线','1','','',NULL),(3323,'七份岸村','331081005000','331081005210','0','0',4,'下线','1','','',NULL),(3324,'后洋郑村','331081005000','331081005211','0','0',4,'下线','1','','',NULL),(3325,'前陈村','331081005000','331081005212','0','0',4,'下线','1','','',NULL),(3326,'西庄村','331081005000','331081005213','0','0',4,'下线','1','','',NULL),(3327,'祝洋村','331081005000','331081005214','0','0',4,'下线','1','','',NULL),(3328,'祝家洋村','331081005000','331081005215','0','0',4,'下线','1','','',NULL),(3329,'西洋村','331081005000','331081005216','0','0',4,'下线','1','','',NULL),(3330,'洋江村','331081005000','331081005217','0','0',4,'下线','1','','',NULL),(3331,'莞渭陈村','331081005000','331081005218','0','0',4,'下线','1','','',NULL),(3332,'方家洋村','331081005000','331081005219','0','0',4,'下线','1','','',NULL),(3333,'西塘村','331081005000','331081005220','0','0',4,'下线','1','','',NULL),(3334,'后洋村','331081005000','331081005221','0','0',4,'下线','1','','',NULL),(3335,'前洋村','331081005000','331081005222','0','0',4,'下线','1','','',NULL),(3336,'邱家岸村','331081005000','331081005223','0','0',4,'下线','1','','',NULL),(3337,'高洋王村','331081005000','331081005224','0','0',4,'下线','1','','',NULL),(3338,'下叶村','331081005000','331081005225','0','0',4,'下线','1','','',NULL),(3339,'屯田村','331081005000','331081005226','0','0',4,'下线','1','','',NULL),(3340,'上街社区','331081100000','331081100001','0','0',4,'下线','1','','',NULL),(3341,'下街社区','331081100000','331081100002','0','0',4,'下线','1','','',NULL),(3342,'丁字街社区','331081100000','331081100003','0','0',4,'下线','1','','',NULL),(3343,'前街社区','331081100000','331081100004','0','0',4,'下线','1','','',NULL),(3344,'幸福社区','331081100000','331081100005','0','0',4,'下线','1','','',NULL),(3345,'虎山社区','331081100000','331081100006','0','0',4,'下线','1','','',NULL),(3346,'东河社区','331081100000','331081100007','0','0',4,'下线','1','','',NULL),(3347,'商城社区','331081100000','331081100008','0','0',4,'下线','1','','',NULL),(3348,'小前陈社区','331081100000','331081100009','0','0',4,'下线','1','','',NULL),(3349,'楼下社区','331081100000','331081100010','0','0',4,'下线','1','','',NULL),(3350,'下汇头社区','331081100000','331081100011','0','0',4,'下线','1','','',NULL),(3351,'泽南社区','331081100000','331081100012','0','0',4,'下线','1','','',NULL),(3352,'前炉社区','331081100000','331081100013','0','0',4,'下线','1','','',NULL),(3353,'布巷社区','331081100000','331081100014','0','0',4,'下线','1','','',NULL),(3354,'下樟桥社区','331081100000','331081100015','0','0',4,'下线','1','','',NULL),(3355,'后炉社区','331081100000','331081100016','0','0',4,'下线','1','','',NULL),(3356,'长泾社区','331081100000','331081100017','0','0',4,'下线','1','','',NULL),(3357,'山下陈社区','331081100000','331081100018','0','0',4,'下线','1','','',NULL),(3358,'腾蛟','331081100000','331081100020','0','0',4,'下线','1','','',NULL),(3359,'泥桥','331081100000','331081100021','0','0',4,'下线','1','','',NULL),(3360,'扁屿','331081100000','331081100022','0','0',4,'下线','1','','',NULL),(3361,'丹山','331081100000','331081100023','0','0',4,'下线','1','','',NULL),(3362,'牧屿街','331081100000','331081100024','0','0',4,'下线','1','','',NULL),(3363,'山北','331081100000','331081100025','0','0',4,'下线','1','','',NULL),(3364,'桥林村','331081100000','331081100200','0','0',4,'下线','1','','',NULL),(3365,'洪家村','331081100000','331081100201','0','0',4,'下线','1','','',NULL),(3366,'戴家村','331081100000','331081100202','0','0',4,'下线','1','','',NULL),(3367,'樟皇村','331081100000','331081100203','0','0',4,'下线','1','','',NULL),(3368,'横径村','331081100000','331081100204','0','0',4,'下线','1','','',NULL),(3369,'打角村','331081100000','331081100205','0','0',4,'下线','1','','',NULL),(3370,'万堂村','331081100000','331081100206','0','0',4,'下线','1','','',NULL),(3371,'汇头林村','331081100000','331081100207','0','0',4,'下线','1','','',NULL),(3372,'前岸村','331081100000','331081100208','0','0',4,'下线','1','','',NULL),(3373,'下郑村','331081100000','331081100209','0','0',4,'下线','1','','',NULL),(3374,'三衙桥村','331081100000','331081100210','0','0',4,'下线','1','','',NULL),(3375,'水次洋村','331081100000','331081100211','0','0',4,'下线','1','','',NULL),(3376,'上孚李村','331081100000','331081100212','0','0',4,'下线','1','','',NULL),(3377,'蔡林村','331081100000','331081100213','0','0',4,'下线','1','','',NULL),(3378,'四份村','331081100000','331081100214','0','0',4,'下线','1','','',NULL),(3379,'西岸村','331081100000','331081100215','0','0',4,'下线','1','','',NULL),(3380,'新秋村','331081100000','331081100216','0','0',4,'下线','1','','',NULL),(3381,'湖亭村','331081100000','331081100217','0','0',4,'下线','1','','',NULL),(3382,'官路村','331081100000','331081100218','0','0',4,'下线','1','','',NULL),(3383,'下庄村','331081100000','331081100219','0','0',4,'下线','1','','',NULL),(3384,'茶屿村','331081100000','331081100220','0','0',4,'下线','1','','',NULL),(3385,'东村','331081100000','331081100221','0','0',4,'下线','1','','',NULL),(3386,'徐家村','331081100000','331081100222','0','0',4,'下线','1','','',NULL),(3387,'陈家里村','331081100000','331081100223','0','0',4,'下线','1','','',NULL),(3388,'珠山村','331081100000','331081100224','0','0',4,'下线','1','','',NULL),(3389,'桥伍村','331081100000','331081100225','0','0',4,'下线','1','','',NULL),(3390,'水澄村','331081100000','331081100226','0','0',4,'下线','1','','',NULL),(3391,'株松村','331081100000','331081100227','0','0',4,'下线','1','','',NULL),(3392,'西湾村','331081100000','331081100228','0','0',4,'下线','1','','',NULL),(3393,'天皇村','331081100000','331081100229','0','0',4,'下线','1','','',NULL),(3394,'筻头村','331081100000','331081100230','0','0',4,'下线','1','','',NULL),(3395,'竖石村','331081100000','331081100231','0','0',4,'下线','1','','',NULL),(3396,'田洋里村','331081100000','331081100232','0','0',4,'下线','1','','',NULL),(3397,'西桐村','331081100000','331081100233','0','0',4,'下线','1','','',NULL),(3398,'湖头村','331081100000','331081100234','0','0',4,'下线','1','','',NULL),(3399,'山坑村','331081100000','331081100235','0','0',4,'下线','1','','',NULL),(3400,'百亩坦村','331081100000','331081100236','0','0',4,'下线','1','','',NULL),(3401,'牧屿村','331081100000','331081100238','0','0',4,'下线','1','','',NULL),(3402,'牧南村','331081100000','331081100239','0','0',4,'下线','1','','',NULL),(3403,'牧东村','331081100000','331081100240','0','0',4,'下线','1','','',NULL),(3404,'沈桥村','331081100000','331081100241','0','0',4,'下线','1','','',NULL),(3405,'牧西村','331081100000','331081100242','0','0',4,'下线','1','','',NULL),(3406,'池里村','331081100000','331081100243','0','0',4,'下线','1','','',NULL),(3407,'五里泾村','331081100000','331081100244','0','0',4,'下线','1','','',NULL),(3408,'八份村','331081100000','331081100245','0','0',4,'下线','1','','',NULL),(3409,'大池陈村','331081100000','331081100246','0','0',4,'下线','1','','',NULL),(3410,'上汇头村','331081100000','331081100247','0','0',4,'下线','1','','',NULL),(3411,'洋肚村','331081100000','331081100248','0','0',4,'下线','1','','',NULL),(3412,'金水村','331081100000','331081100249','0','0',4,'下线','1','','',NULL),(3413,'牛桥头村','331081100000','331081100250','0','0',4,'下线','1','','',NULL),(3414,'金樟村','331081100000','331081100251','0','0',4,'下线','1','','',NULL),(3415,'渚里村','331081100000','331081100252','0','0',4,'下线','1','','',NULL),(3416,'山南村','331081100000','331081100253','0','0',4,'下线','1','','',NULL),(3417,'颜家村','331081100000','331081100254','0','0',4,'下线','1','','',NULL),(3418,'章袁村','331081100000','331081100255','0','0',4,'下线','1','','',NULL),(3419,'南洋王村','331081100000','331081100256','0','0',4,'下线','1','','',NULL),(3420,'下周村','331081100000','331081100257','0','0',4,'下线','1','','',NULL),(3421,'郑家村','331081100000','331081100258','0','0',4,'下线','1','','',NULL),(3422,'姜家村','331081100000','331081100259','0','0',4,'下线','1','','',NULL),(3423,'马家村','331081100000','331081100260','0','0',4,'下线','1','','',NULL),(3424,'夹屿村','331081100000','331081100261','0','0',4,'下线','1','','',NULL),(3425,'埭头蔡村','331081100000','331081100262','0','0',4,'下线','1','','',NULL),(3426,'金施村','331081100000','331081100263','0','0',4,'下线','1','','',NULL),(3427,'楼下张村','331081100000','331081100264','0','0',4,'下线','1','','',NULL),(3428,'长大村','331081100000','331081100265','0','0',4,'下线','1','','',NULL),(3429,'双峰村','331081100000','331081100266','0','0',4,'下线','1','','',NULL),(3430,'高坦村','331081100000','331081100267','0','0',4,'下线','1','','',NULL),(3431,'联树村','331081100000','331081100268','0','0',4,'下线','1','','',NULL),(3432,'三王村','331081100000','331081100269','0','0',4,'下线','1','','',NULL),(3433,'下店村','331081100000','331081100270','0','0',4,'下线','1','','',NULL),(3434,'塔龙村','331081100000','331081100271','0','0',4,'下线','1','','',NULL),(3435,'长桥村','331081100000','331081100272','0','0',4,'下线','1','','',NULL),(3436,'上庄村','331081100000','331081100273','0','0',4,'下线','1','','',NULL),(3437,'光明村','331081100000','331081100274','0','0',4,'下线','1','','',NULL),(3438,'安平居','331081101000','331081101001','0','0',4,'下线','1','','',NULL),(3439,'中兴居','331081101000','331081101002','0','0',4,'下线','1','','',NULL),(3440,'德明居','331081101000','331081101003','0','0',4,'下线','1','','',NULL),(3441,'大溪居','331081101000','331081101004','0','0',4,'下线','1','','',NULL),(3442,'宜桥居','331081101000','331081101005','0','0',4,'下线','1','','',NULL),(3443,'水仓居','331081101000','331081101006','0','0',4,'下线','1','','',NULL),(3444,'后岸居','331081101000','331081101007','0','0',4,'下线','1','','',NULL),(3445,'上洋岙居','331081101000','331081101008','0','0',4,'下线','1','','',NULL),(3446,'上河头居','331081101000','331081101009','0','0',4,'下线','1','','',NULL),(3447,'河北居','331081101000','331081101010','0','0',4,'下线','1','','',NULL),(3448,'河南居','331081101000','331081101011','0','0',4,'下线','1','','',NULL),(3449,'下洋岙村','331081101000','331081101200','0','0',4,'下线','1','','',NULL),(3450,'双凌村','331081101000','331081101201','0','0',4,'下线','1','','',NULL),(3451,'下村村','331081101000','331081101202','0','0',4,'下线','1','','',NULL),(3452,'闸头村','331081101000','331081101203','0','0',4,'下线','1','','',NULL),(3453,'良山村','331081101000','331081101204','0','0',4,'下线','1','','',NULL),(3454,'花金村','331081101000','331081101205','0','0',4,'下线','1','','',NULL),(3455,'大溪岙村','331081101000','331081101206','0','0',4,'下线','1','','',NULL),(3456,'银河村','331081101000','331081101207','0','0',4,'下线','1','','',NULL),(3457,'小溪村','331081101000','331081101208','0','0',4,'下线','1','','',NULL),(3458,'岩头山村','331081101000','331081101209','0','0',4,'下线','1','','',NULL),(3459,'小溪岭头村','331081101000','331081101210','0','0',4,'下线','1','','',NULL),(3460,'滥田湖村','331081101000','331081101211','0','0',4,'下线','1','','',NULL),(3461,'麻车屿村','331081101000','331081101212','0','0',4,'下线','1','','',NULL),(3462,'上新建村','331081101000','331081101213','0','0',4,'下线','1','','',NULL),(3463,'下新建村','331081101000','331081101214','0','0',4,'下线','1','','',NULL),(3464,'三池窟村','331081101000','331081101215','0','0',4,'下线','1','','',NULL),(3465,'高田村','331081101000','331081101216','0','0',4,'下线','1','','',NULL),(3466,'阳山村','331081101000','331081101217','0','0',4,'下线','1','','',NULL),(3467,'兆岙村','331081101000','331081101218','0','0',4,'下线','1','','',NULL),(3468,'毛竹下村','331081101000','331081101219','0','0',4,'下线','1','','',NULL),(3469,'上洋村','331081101000','331081101220','0','0',4,'下线','1','','',NULL),(3470,'坎头村','331081101000','331081101221','0','0',4,'下线','1','','',NULL),(3471,'下郎桥村','331081101000','331081101222','0','0',4,'下线','1','','',NULL),(3472,'桃夏河头村','331081101000','331081101223','0','0',4,'下线','1','','',NULL),(3473,'殿下村','331081101000','331081101224','0','0',4,'下线','1','','',NULL),(3474,'念母洋村','331081101000','331081101225','0','0',4,'下线','1','','',NULL),(3475,'双桥村','331081101000','331081101226','0','0',4,'下线','1','','',NULL),(3476,'吕岙村','331081101000','331081101227','0','0',4,'下线','1','','',NULL),(3477,'桥外村','331081101000','331081101228','0','0',4,'下线','1','','',NULL),(3478,'桥里村','331081101000','331081101229','0','0',4,'下线','1','','',NULL),(3479,'沈岙村','331081101000','331081101230','0','0',4,'下线','1','','',NULL),(3480,'中岙张村','331081101000','331081101231','0','0',4,'下线','1','','',NULL),(3481,'照洋村','331081101000','331081101232','0','0',4,'下线','1','','',NULL),(3482,'下山后村','331081101000','331081101233','0','0',4,'下线','1','','',NULL),(3483,'新南岙村','331081101000','331081101234','0','0',4,'下线','1','','',NULL),(3484,'塘山村','331081101000','331081101235','0','0',4,'下线','1','','',NULL),(3485,'里宅村','331081101000','331081101236','0','0',4,'下线','1','','',NULL),(3486,'大岙村','331081101000','331081101237','0','0',4,'下线','1','','',NULL),(3487,'屿孙村','331081101000','331081101238','0','0',4,'下线','1','','',NULL),(3488,'沙岸村','331081101000','331081101239','0','0',4,'下线','1','','',NULL),(3489,'东桥村','331081101000','331081101240','0','0',4,'下线','1','','',NULL),(3490,'横后村','331081101000','331081101241','0','0',4,'下线','1','','',NULL),(3491,'塘岭村','331081101000','331081101242','0','0',4,'下线','1','','',NULL),(3492,'潘郎村','331081101000','331081101243','0','0',4,'下线','1','','',NULL),(3493,'前瓦屿村','331081101000','331081101244','0','0',4,'下线','1','','',NULL),(3494,'后瓦屿村','331081101000','331081101245','0','0',4,'下线','1','','',NULL),(3495,'岙增张村','331081101000','331081101246','0','0',4,'下线','1','','',NULL),(3496,'许家渭村','331081101000','331081101247','0','0',4,'下线','1','','',NULL),(3497,'现范桥村','331081101000','331081101248','0','0',4,'下线','1','','',NULL),(3498,'相公渭村','331081101000','331081101249','0','0',4,'下线','1','','',NULL),(3499,'田洋季村','331081101000','331081101250','0','0',4,'下线','1','','',NULL),(3500,'水门后村','331081101000','331081101251','0','0',4,'下线','1','','',NULL),(3501,'毛头村','331081101000','331081101252','0','0',4,'下线','1','','',NULL),(3502,'流庆村','331081101000','331081101253','0','0',4,'下线','1','','',NULL),(3503,'西山金村','331081101000','331081101254','0','0',4,'下线','1','','',NULL),(3504,'下洋陶村','331081101000','331081101255','0','0',4,'下线','1','','',NULL),(3505,'陶家埠村','331081101000','331081101256','0','0',4,'下线','1','','',NULL),(3506,'油屿村','331081101000','331081101257','0','0',4,'下线','1','','',NULL),(3507,'新岙里村','331081101000','331081101258','0','0',4,'下线','1','','',NULL),(3508,'部渎村','331081101000','331081101259','0','0',4,'下线','1','','',NULL),(3509,'水坦村','331081101000','331081101260','0','0',4,'下线','1','','',NULL),(3510,'前溪村','331081101000','331081101261','0','0',4,'下线','1','','',NULL),(3511,'岗上村','331081101000','331081101262','0','0',4,'下线','1','','',NULL),(3512,'佛陇村','331081101000','331081101263','0','0',4,'下线','1','','',NULL),(3513,'下陈村','331081101000','331081101264','0','0',4,'下线','1','','',NULL),(3514,'担屿村','331081101000','331081101265','0','0',4,'下线','1','','',NULL),(3515,'水渚村','331081101000','331081101266','0','0',4,'下线','1','','',NULL),(3516,'上山村','331081101000','331081101267','0','0',4,'下线','1','','',NULL),(3517,'山市村','331081101000','331081101268','0','0',4,'下线','1','','',NULL),(3518,'潘岙村','331081101000','331081101269','0','0',4,'下线','1','','',NULL),(3519,'金岙村','331081101000','331081101270','0','0',4,'下线','1','','',NULL),(3520,'翁岙村','331081101000','331081101271','0','0',4,'下线','1','','',NULL),(3521,'塘头村','331081101000','331081101272','0','0',4,'下线','1','','',NULL),(3522,'小塘村','331081101000','331081101273','0','0',4,'下线','1','','',NULL),(3523,'塔岙村','331081101000','331081101274','0','0',4,'下线','1','','',NULL),(3524,'白塔村','331081101000','331081101275','0','0',4,'下线','1','','',NULL),(3525,'上坦头村','331081101000','331081101276','0','0',4,'下线','1','','',NULL),(3526,'下员山村','331081101000','331081101277','0','0',4,'下线','1','','',NULL),(3527,'水桶坤村','331081101000','331081101278','0','0',4,'下线','1','','',NULL),(3528,'白山街村','331081101000','331081101279','0','0',4,'下线','1','','',NULL),(3529,'应钱村','331081101000','331081101280','0','0',4,'下线','1','','',NULL),(3530,'纶丝洋村','331081101000','331081101281','0','0',4,'下线','1','','',NULL),(3531,'孙家村','331081101000','331081101282','0','0',4,'下线','1','','',NULL),(3532,'五峰村','331081101000','331081101283','0','0',4,'下线','1','','',NULL),(3533,'白山里村','331081101000','331081101284','0','0',4,'下线','1','','',NULL),(3534,'曹岙村','331081101000','331081101285','0','0',4,'下线','1','','',NULL),(3535,'利岙村','331081101000','331081101286','0','0',4,'下线','1','','',NULL),(3536,'下洋张村','331081101000','331081101287','0','0',4,'下线','1','','',NULL),(3537,'井朱村','331081101000','331081101288','0','0',4,'下线','1','','',NULL),(3538,'平山村','331081101000','331081101289','0','0',4,'下线','1','','',NULL),(3539,'盘山村','331081101000','331081101290','0','0',4,'下线','1','','',NULL),(3540,'陈洋村','331081101000','331081101291','0','0',4,'下线','1','','',NULL),(3541,'马面村','331081101000','331081101292','0','0',4,'下线','1','','',NULL),(3542,'白泥村','331081101000','331081101293','0','0',4,'下线','1','','',NULL),(3543,'秀岭村','331081101000','331081101294','0','0',4,'下线','1','','',NULL),(3544,'梅安村','331081101000','331081101295','0','0',4,'下线','1','','',NULL),(3545,'上毛坦村','331081101000','331081101296','0','0',4,'下线','1','','',NULL),(3546,'下毛坦村','331081101000','331081101297','0','0',4,'下线','1','','',NULL),(3547,'田茶村','331081101000','331081101298','0','0',4,'下线','1','','',NULL),(3548,'中城社区','331081102000','331081102001','0','0',4,'下线','1','','',NULL),(3549,'南城社区','331081102000','331081102002','0','0',4,'下线','1','','',NULL),(3550,'西城社区','331081102000','331081102003','0','0',4,'下线','1','','',NULL),(3551,'北城社区','331081102000','331081102004','0','0',4,'下线','1','','',NULL),(3552,'新街社区','331081102000','331081102005','0','0',4,'下线','1','','',NULL),(3553,'茶山社区','331081102000','331081102006','0','0',4,'下线','1','','',NULL),(3554,'远景社区','331081102000','331081102007','0','0',4,'下线','1','','',NULL),(3555,'淋铃社区','331081102000','331081102008','0','0',4,'下线','1','','',NULL),(3556,'松建村','331081102000','331081102200','0','0',4,'下线','1','','',NULL),(3557,'朝阳村','331081102000','331081102201','0','0',4,'下线','1','','',NULL),(3558,'松椒村','331081102000','331081102202','0','0',4,'下线','1','','',NULL),(3559,'南塘一村','331081102000','331081102203','0','0',4,'下线','1','','',NULL),(3560,'南塘二村','331081102000','331081102204','0','0',4,'下线','1','','',NULL),(3561,'南塘三村','331081102000','331081102205','0','0',4,'下线','1','','',NULL),(3562,'南塘四村','331081102000','331081102206','0','0',4,'下线','1','','',NULL),(3563,'南塘五村','331081102000','331081102207','0','0',4,'下线','1','','',NULL),(3564,'南坑村','331081102000','331081102208','0','0',4,'下线','1','','',NULL),(3565,'乌坑村','331081102000','331081102209','0','0',4,'下线','1','','',NULL),(3566,'大交陈村','331081102000','331081102210','0','0',4,'下线','1','','',NULL),(3567,'小交陈村','331081102000','331081102211','0','0',4,'下线','1','','',NULL),(3568,'山里皇村','331081102000','331081102212','0','0',4,'下线','1','','',NULL),(3569,'大坑沙村','331081102000','331081102213','0','0',4,'下线','1','','',NULL),(3570,'洞下村','331081102000','331081102214','0','0',4,'下线','1','','',NULL),(3571,'松西村','331081102000','331081102215','0','0',4,'下线','1','','',NULL),(3572,'松南村','331081102000','331081102216','0','0',4,'下线','1','','',NULL),(3573,'河头村','331081102000','331081102217','0','0',4,'下线','1','','',NULL),(3574,'东升村','331081102000','331081102218','0','0',4,'下线','1','','',NULL),(3575,'幸福村','331081102000','331081102219','0','0',4,'下线','1','','',NULL),(3576,'松东村','331081102000','331081102220','0','0',4,'下线','1','','',NULL),(3577,'东城村','331081102000','331081102221','0','0',4,'下线','1','','',NULL),(3578,'松北村','331081102000','331081102222','0','0',4,'下线','1','','',NULL),(3579,'松寨村','331081102000','331081102223','0','0',4,'下线','1','','',NULL),(3580,'沙镬村','331081102000','331081102224','0','0',4,'下线','1','','',NULL),(3581,'淋头村','331081102000','331081102225','0','0',4,'下线','1','','',NULL),(3582,'星光村','331081102000','331081102226','0','0',4,'下线','1','','',NULL),(3583,'北咸田村','331081102000','331081102227','0','0',4,'下线','1','','',NULL),(3584,'北沙村','331081102000','331081102228','0','0',4,'下线','1','','',NULL),(3585,'度爿村','331081102000','331081102229','0','0',4,'下线','1','','',NULL),(3586,'南咸田村','331081102000','331081102230','0','0',4,'下线','1','','',NULL),(3587,'新华村','331081102000','331081102231','0','0',4,'下线','1','','',NULL),(3588,'红光村','331081102000','331081102232','0','0',4,'下线','1','','',NULL),(3589,'苍山村','331081102000','331081102233','0','0',4,'下线','1','','',NULL),(3590,'南洋村','331081102000','331081102234','0','0',4,'下线','1','','',NULL),(3591,'木耳村','331081102000','331081102235','0','0',4,'下线','1','','',NULL),(3592,'新建村','331081102000','331081102236','0','0',4,'下线','1','','',NULL),(3593,'长川村','331081102000','331081102237','0','0',4,'下线','1','','',NULL),(3594,'五甲村','331081102000','331081102238','0','0',4,'下线','1','','',NULL),(3595,'竿蓬村','331081102000','331081102239','0','0',4,'下线','1','','',NULL),(3596,'竿北村','331081102000','331081102240','0','0',4,'下线','1','','',NULL),(3597,'胜南村','331081102000','331081102241','0','0',4,'下线','1','','',NULL),(3598,'胜北村','331081102000','331081102242','0','0',4,'下线','1','','',NULL),(3599,'乃崦村','331081102000','331081102243','0','0',4,'下线','1','','',NULL),(3600,'胜盐村','331081102000','331081102244','0','0',4,'下线','1','','',NULL),(3601,'四甲村','331081102000','331081102245','0','0',4,'下线','1','','',NULL),(3602,'水浦村','331081102000','331081102246','0','0',4,'下线','1','','',NULL),(3603,'新田村','331081102000','331081102247','0','0',4,'下线','1','','',NULL),(3604,'六甲村','331081102000','331081102248','0','0',4,'下线','1','','',NULL),(3605,'八甲村','331081102000','331081102249','0','0',4,'下线','1','','',NULL),(3606,'新坦村','331081102000','331081102250','0','0',4,'下线','1','','',NULL),(3607,'新丰村','331081102000','331081102251','0','0',4,'下线','1','','',NULL),(3608,'荣华村','331081102000','331081102252','0','0',4,'下线','1','','',NULL),(3609,'石板殿村','331081102000','331081102253','0','0',4,'下线','1','','',NULL),(3610,'塘礁村','331081102000','331081102254','0','0',4,'下线','1','','',NULL),(3611,'白岩村','331081102000','331081102255','0','0',4,'下线','1','','',NULL),(3612,'乌岩村','331081102000','331081102256','0','0',4,'下线','1','','',NULL),(3613,'横门村','331081102000','331081102257','0','0',4,'下线','1','','',NULL),(3614,'铜门村','331081102000','331081102258','0','0',4,'下线','1','','',NULL),(3615,'南港村','331081102000','331081102259','0','0',4,'下线','1','','',NULL),(3616,'北港村','331081102000','331081102260','0','0',4,'下线','1','','',NULL),(3617,'繁荣','331081103000','331081103001','0','0',4,'下线','1','','',NULL),(3618,'建设','331081103000','331081103002','0','0',4,'下线','1','','',NULL),(3619,'民主','331081103000','331081103003','0','0',4,'下线','1','','',NULL),(3620,'团结','331081103000','331081103004','0','0',4,'下线','1','','',NULL),(3621,'北新','331081103000','331081103005','0','0',4,'下线','1','','',NULL),(3622,'箬横','331081103000','331081103006','0','0',4,'下线','1','','',NULL),(3623,'解放','331081103000','331081103007','0','0',4,'下线','1','','',NULL),(3624,'埭头','331081103000','331081103008','0','0',4,'下线','1','','',NULL),(3625,'司城社区','331081103000','331081103009','0','0',4,'下线','1','','',NULL),(3626,'义民','331081103000','331081103010','0','0',4,'下线','1','','',NULL),(3627,'马桥','331081103000','331081103011','0','0',4,'下线','1','','',NULL),(3628,'朝西','331081103000','331081103012','0','0',4,'下线','1','','',NULL),(3629,'浦头','331081103000','331081103013','0','0',4,'下线','1','','',NULL),(3630,'水岸','331081103000','331081103014','0','0',4,'下线','1','','',NULL),(3631,'东浦苑','331081103000','331081103015','0','0',4,'下线','1','','',NULL),(3632,'常乐村','331081103000','331081103200','0','0',4,'下线','1','','',NULL),(3633,'繁荣村','331081103000','331081103201','0','0',4,'下线','1','','',NULL),(3634,'翻身村','331081103000','331081103202','0','0',4,'下线','1','','',NULL),(3635,'团结村','331081103000','331081103203','0','0',4,'下线','1','','',NULL),(3636,'咸田村','331081103000','331081103204','0','0',4,'下线','1','','',NULL),(3637,'下金村','331081103000','331081103205','0','0',4,'下线','1','','',NULL),(3638,'王家村','331081103000','331081103206','0','0',4,'下线','1','','',NULL),(3639,'高园村','331081103000','331081103207','0','0',4,'下线','1','','',NULL),(3640,'李婆桥村','331081103000','331081103208','0','0',4,'下线','1','','',NULL),(3641,'中库村','331081103000','331081103209','0','0',4,'下线','1','','',NULL),(3642,'大路毛村','331081103000','331081103210','0','0',4,'下线','1','','',NULL),(3643,'湾张村','331081103000','331081103211','0','0',4,'下线','1','','',NULL),(3644,'田东村','331081103000','331081103212','0','0',4,'下线','1','','',NULL),(3645,'彭林村','331081103000','331081103213','0','0',4,'下线','1','','',NULL),(3646,'长塘村','331081103000','331081103214','0','0',4,'下线','1','','',NULL),(3647,'汇头林村','331081103000','331081103215','0','0',4,'下线','1','','',NULL),(3648,'亚湖村','331081103000','331081103216','0','0',4,'下线','1','','',NULL),(3649,'花芯村','331081103000','331081103223','0','0',4,'下线','1','','',NULL),(3650,'下墩村','331081103000','331081103224','0','0',4,'下线','1','','',NULL),(3651,'西墩村','331081103000','331081103225','0','0',4,'下线','1','','',NULL),(3652,'白水田村','331081103000','331081103226','0','0',4,'下线','1','','',NULL),(3653,'三顶桥村','331081103000','331081103227','0','0',4,'下线','1','','',NULL),(3654,'红升村','331081103000','331081103228','0','0',4,'下线','1','','',NULL),(3655,'黄岩塘村','331081103000','331081103229','0','0',4,'下线','1','','',NULL),(3656,'下山头村','331081103000','331081103230','0','0',4,'下线','1','','',NULL),(3657,'新屋村','331081103000','331081103231','0','0',4,'下线','1','','',NULL),(3658,'下朱村','331081103000','331081103232','0','0',4,'下线','1','','',NULL),(3659,'陈家村','331081103000','331081103233','0','0',4,'下线','1','','',NULL),(3660,'红丰村','331081103000','331081103234','0','0',4,'下线','1','','',NULL),(3661,'谢家村','331081103000','331081103235','0','0',4,'下线','1','','',NULL),(3662,'庄联村','331081103000','331081103236','0','0',4,'下线','1','','',NULL),(3663,'下谢村','331081103000','331081103237','0','0',4,'下线','1','','',NULL),(3664,'东红村','331081103000','331081103238','0','0',4,'下线','1','','',NULL),(3665,'盘马村','331081103000','331081103239','0','0',4,'下线','1','','',NULL),(3666,'娄江村','331081103000','331081103240','0','0',4,'下线','1','','',NULL),(3667,'龙皇宫村','331081103000','331081103241','0','0',4,'下线','1','','',NULL),(3668,'乐邦寺村','331081103000','331081103242','0','0',4,'下线','1','','',NULL),(3669,'山东村','331081103000','331081103243','0','0',4,'下线','1','','',NULL),(3670,'西江村','331081103000','331081103244','0','0',4,'下线','1','','',NULL),(3671,'山西村','331081103000','331081103245','0','0',4,'下线','1','','',NULL),(3672,'长山村','331081103000','331081103246','0','0',4,'下线','1','','',NULL),(3673,'车路村','331081103000','331081103247','0','0',4,'下线','1','','',NULL),(3674,'五份头村','331081103000','331081103248','0','0',4,'下线','1','','',NULL),(3675,'高楼村','331081103000','331081103249','0','0',4,'下线','1','','',NULL),(3676,'东洋里村','331081103000','331081103250','0','0',4,'下线','1','','',NULL),(3677,'百亩坦村','331081103000','331081103251','0','0',4,'下线','1','','',NULL),(3678,'坭城村','331081103000','331081103252','0','0',4,'下线','1','','',NULL),(3679,'东浦村','331081103000','331081103253','0','0',4,'下线','1','','',NULL),(3680,'三透里村','331081103000','331081103254','0','0',4,'下线','1','','',NULL),(3681,'下闸村','331081103000','331081103255','0','0',4,'下线','1','','',NULL),(3682,'坭屋村','331081103000','331081103256','0','0',4,'下线','1','','',NULL),(3683,'庙南河村','331081103000','331081103257','0','0',4,'下线','1','','',NULL),(3684,'西浦村','331081103000','331081103258','0','0',4,'下线','1','','',NULL),(3685,'岁坊村','331081103000','331081103259','0','0',4,'下线','1','','',NULL),(3686,'新建村','331081103000','331081103260','0','0',4,'下线','1','','',NULL),(3687,'前九份村','331081103000','331081103261','0','0',4,'下线','1','','',NULL),(3688,'毛山下村','331081103000','331081103262','0','0',4,'下线','1','','',NULL),(3689,'下李村','331081103000','331081103263','0','0',4,'下线','1','','',NULL),(3690,'桥下村','331081103000','331081103264','0','0',4,'下线','1','','',NULL),(3691,'街龙头村','331081103000','331081103268','0','0',4,'下线','1','','',NULL),(3692,'新基村','331081103000','331081103269','0','0',4,'下线','1','','',NULL),(3693,'西汇头村','331081103000','331081103270','0','0',4,'下线','1','','',NULL),(3694,'上叶村','331081103000','331081103271','0','0',4,'下线','1','','',NULL),(3695,'东桥头村','331081103000','331081103272','0','0',4,'下线','1','','',NULL),(3696,'琅洋村','331081103000','331081103273','0','0',4,'下线','1','','',NULL),(3697,'夏程村','331081103000','331081103274','0','0',4,'下线','1','','',NULL),(3698,'西楼村','331081103000','331081103275','0','0',4,'下线','1','','',NULL),(3699,'石牌桥村','331081103000','331081103276','0','0',4,'下线','1','','',NULL),(3700,'东方村','331081103000','331081103283','0','0',4,'下线','1','','',NULL),(3701,'严家村','331081103000','331081103284','0','0',4,'下线','1','','',NULL),(3702,'旗杆村','331081103000','331081103285','0','0',4,'下线','1','','',NULL),(3703,'海城村','331081103000','331081103286','0','0',4,'下线','1','','',NULL),(3704,'上轩村','331081103000','331081103287','0','0',4,'下线','1','','',NULL),(3705,'下轩村','331081103000','331081103288','0','0',4,'下线','1','','',NULL),(3706,'海防村','331081103000','331081103289','0','0',4,'下线','1','','',NULL),(3707,'滨海村','331081103000','331081103290','0','0',4,'下线','1','','',NULL),(3708,'滨胜村','331081103000','331081103291','0','0',4,'下线','1','','',NULL),(3709,'浦北村','331081103000','331081103292','0','0',4,'下线','1','','',NULL),(3710,'张家村','331081103000','331081103293','0','0',4,'下线','1','','',NULL),(3711,'三房村','331081103000','331081103294','0','0',4,'下线','1','','',NULL),(3712,'五房村','331081103000','331081103295','0','0',4,'下线','1','','',NULL),(3713,'三星村','331081103000','331081103296','0','0',4,'下线','1','','',NULL),(3714,'和平村','331081103000','331081103297','0','0',4,'下线','1','','',NULL),(3715,'胜利村','331081103000','331081103298','0','0',4,'下线','1','','',NULL),(3716,'田后村','331081103000','331081103299','0','0',4,'下线','1','','',NULL),(3717,'希洋村','331081103000','331081103300','0','0',4,'下线','1','','',NULL),(3718,'双透村','331081103000','331081103301','0','0',4,'下线','1','','',NULL),(3719,'三甲村','331081103000','331081103302','0','0',4,'下线','1','','',NULL),(3720,'南塘村','331081103000','331081103303','0','0',4,'下线','1','','',NULL),(3721,'汇头村','331081103000','331081103304','0','0',4,'下线','1','','',NULL),(3722,'东马村','331081103000','331081103305','0','0',4,'下线','1','','',NULL),(3723,'前江村','331081103000','331081103306','0','0',4,'下线','1','','',NULL),(3724,'横陈村','331081103000','331081103307','0','0',4,'下线','1','','',NULL),(3725,'西陈村','331081103000','331081103308','0','0',4,'下线','1','','',NULL),(3726,'岸蔡村','331081103000','331081103309','0','0',4,'下线','1','','',NULL),(3727,'贯庄村','331081103000','331081103310','0','0',4,'下线','1','','',NULL),(3728,'浦岙村','331081103000','331081103311','0','0',4,'下线','1','','',NULL),(3729,'晋岙里村','331081103000','331081103312','0','0',4,'下线','1','','',NULL),(3730,'龙岗村','331081103000','331081103313','0','0',4,'下线','1','','',NULL),(3731,'东城','331081104000','331081104001','0','0',4,'下线','1','','',NULL),(3732,'西城','331081104000','331081104002','0','0',4,'下线','1','','',NULL),(3733,'南城','331081104000','331081104003','0','0',4,'下线','1','','',NULL),(3734,'北城','331081104000','331081104004','0','0',4,'下线','1','','',NULL),(3735,'虹桥头','331081104000','331081104005','0','0',4,'下线','1','','',NULL),(3736,'寺前桥','331081104000','331081104006','0','0',4,'下线','1','','',NULL),(3737,'城东村','331081104000','331081104200','0','0',4,'下线','1','','',NULL),(3738,'城西村','331081104000','331081104201','0','0',4,'下线','1','','',NULL),(3739,'城南村','331081104000','331081104202','0','0',4,'下线','1','','',NULL),(3740,'城北村','331081104000','331081104203','0','0',4,'下线','1','','',NULL),(3741,'横板桥村','331081104000','331081104204','0','0',4,'下线','1','','',NULL),(3742,'山后鲍村','331081104000','331081104205','0','0',4,'下线','1','','',NULL),(3743,'南鉴村','331081104000','331081104206','0','0',4,'下线','1','','',NULL),(3744,'横陶村','331081104000','331081104207','0','0',4,'下线','1','','',NULL),(3745,'中闸村','331081104000','331081104208','0','0',4,'下线','1','','',NULL),(3746,'后街村','331081104000','331081104209','0','0',4,'下线','1','','',NULL),(3747,'北闸村','331081104000','331081104210','0','0',4,'下线','1','','',NULL),(3748,'东合村','331081104000','331081104211','0','0',4,'下线','1','','',NULL),(3749,'渡首东村','331081104000','331081104212','0','0',4,'下线','1','','',NULL),(3750,'渡首西村','331081104000','331081104213','0','0',4,'下线','1','','',NULL),(3751,'渡首南村','331081104000','331081104214','0','0',4,'下线','1','','',NULL),(3752,'路边村','331081104000','331081104215','0','0',4,'下线','1','','',NULL),(3753,'夹里村','331081104000','331081104216','0','0',4,'下线','1','','',NULL),(3754,'甸支村','331081104000','331081104217','0','0',4,'下线','1','','',NULL),(3755,'上桥村','331081104000','331081104218','0','0',4,'下线','1','','',NULL),(3756,'西岸郑村','331081104000','331081104219','0','0',4,'下线','1','','',NULL),(3757,'新联村','331081104000','331081104220','0','0',4,'下线','1','','',NULL),(3758,'牛桥村','331081104000','331081104221','0','0',4,'下线','1','','',NULL),(3759,'雅雀村','331081104000','331081104222','0','0',4,'下线','1','','',NULL),(3760,'渡南头村','331081104000','331081104223','0','0',4,'下线','1','','',NULL),(3761,'坦头村','331081104000','331081104224','0','0',4,'下线','1','','',NULL),(3762,'蔡施桥村','331081104000','331081104225','0','0',4,'下线','1','','',NULL),(3763,'蔡洋村','331081104000','331081104226','0','0',4,'下线','1','','',NULL),(3764,'戴池村','331081104000','331081104227','0','0',4,'下线','1','','',NULL),(3765,'岸头村','331081104000','331081104228','0','0',4,'下线','1','','',NULL),(3766,'大墩村','331081104000','331081104229','0','0',4,'下线','1','','',NULL),(3767,'六闸村','331081104000','331081104230','0','0',4,'下线','1','','',NULL),(3768,'潮观村','331081104000','331081104231','0','0',4,'下线','1','','',NULL),(3769,'咸田湖村','331081104000','331081104232','0','0',4,'下线','1','','',NULL),(3770,'小江下村','331081104000','331081104233','0','0',4,'下线','1','','',NULL),(3771,'永革村','331081104000','331081104234','0','0',4,'下线','1','','',NULL),(3772,'后行村','331081104000','331081104235','0','0',4,'下线','1','','',NULL),(3773,'赵家村','331081104000','331081104236','0','0',4,'下线','1','','',NULL),(3774,'长屿村','331081104000','331081104237','0','0',4,'下线','1','','',NULL),(3775,'姚施村','331081104000','331081104238','0','0',4,'下线','1','','',NULL),(3776,'河头梁村','331081104000','331081104239','0','0',4,'下线','1','','',NULL),(3777,'山园村','331081104000','331081104243','0','0',4,'下线','1','','',NULL),(3778,'东湾村','331081104000','331081104244','0','0',4,'下线','1','','',NULL),(3779,'岙里村','331081104000','331081104245','0','0',4,'下线','1','','',NULL),(3780,'屿头村','331081104000','331081104246','0','0',4,'下线','1','','',NULL),(3781,'塘家洋村','331081104000','331081104247','0','0',4,'下线','1','','',NULL),(3782,'前蔡村','331081104000','331081104248','0','0',4,'下线','1','','',NULL),(3783,'屿詹村','331081104000','331081104249','0','0',4,'下线','1','','',NULL),(3784,'下章村','331081104000','331081104250','0','0',4,'下线','1','','',NULL),(3785,'屿罗村','331081104000','331081104251','0','0',4,'下线','1','','',NULL),(3786,'屿后村','331081104000','331081104252','0','0',4,'下线','1','','',NULL),(3787,'官路村','331081104000','331081104253','0','0',4,'下线','1','','',NULL),(3788,'金桥村','331081104000','331081104255','0','0',4,'下线','1','','',NULL),(3789,'水仓头村','331081104000','331081104256','0','0',4,'下线','1','','',NULL),(3790,'楼岙村','331081104000','331081104258','0','0',4,'下线','1','','',NULL),(3791,'铁场村','331081104000','331081104259','0','0',4,'下线','1','','',NULL),(3792,'丁岙村','331081104000','331081104260','0','0',4,'下线','1','','',NULL),(3793,'塘下村','331081104000','331081104261','0','0',4,'下线','1','','',NULL),(3794,'屏上村','331081104000','331081104262','0','0',4,'下线','1','','',NULL),(3795,'南洋岙村','331081104000','331081104263','0','0',4,'下线','1','','',NULL),(3796,'上桥头村','331081104000','331081104264','0','0',4,'下线','1','','',NULL),(3797,'下王村','331081104000','331081104265','0','0',4,'下线','1','','',NULL),(3798,'桥下郑村','331081104000','331081104266','0','0',4,'下线','1','','',NULL),(3799,'花篮村','331081104000','331081104267','0','0',4,'下线','1','','',NULL),(3800,'南栅村','331081104000','331081104268','0','0',4,'下线','1','','',NULL),(3801,'咸田王村','331081104000','331081104269','0','0',4,'下线','1','','',NULL),(3802,'向西莫村','331081104000','331081104270','0','0',4,'下线','1','','',NULL),(3803,'下莫村','331081104000','331081104271','0','0',4,'下线','1','','',NULL),(3804,'团塘村','331081104000','331081104272','0','0',4,'下线','1','','',NULL),(3805,'上方村','331081104000','331081104273','0','0',4,'下线','1','','',NULL),(3806,'上莫村','331081104000','331081104274','0','0',4,'下线','1','','',NULL),(3807,'下张村','331081104000','331081104275','0','0',4,'下线','1','','',NULL),(3808,'前洋村','331081104000','331081104276','0','0',4,'下线','1','','',NULL),(3809,'中厢村','331081104000','331081104277','0','0',4,'下线','1','','',NULL),(3810,'下林村','331081104000','331081104278','0','0',4,'下线','1','','',NULL),(3811,'肖家桥村','331081104000','331081104279','0','0',4,'下线','1','','',NULL),(3812,'上应村','331081104000','331081104280','0','0',4,'下线','1','','',NULL),(3813,'秧田村','331081104000','331081104281','0','0',4,'下线','1','','',NULL),(3814,'东长大村','331081104000','331081104282','0','0',4,'下线','1','','',NULL),(3815,'腰塘村','331081104000','331081104283','0','0',4,'下线','1','','',NULL),(3816,'横塘头村','331081104000','331081104284','0','0',4,'下线','1','','',NULL),(3817,'良种村','331081104000','331081104285','0','0',4,'下线','1','','',NULL),(3818,'三邵村','331081104000','331081104286','0','0',4,'下线','1','','',NULL),(3819,'潮未至村','331081104000','331081104287','0','0',4,'下线','1','','',NULL),(3820,'梁家村','331081104000','331081104288','0','0',4,'下线','1','','',NULL),(3821,'硐天南村','331081104000','331081104289','0','0',4,'下线','1','','',NULL),(3822,'金盛村','331081104000','331081104290','0','0',4,'下线','1','','',NULL),(3823,'南街社区','331081105000','331081105001','0','0',4,'下线','1','','',NULL),(3824,'北街社区','331081105000','331081105002','0','0',4,'下线','1','','',NULL),(3825,'西街社区','331081105000','331081105003','0','0',4,'下线','1','','',NULL),(3826,'中街社区','331081105000','331081105004','0','0',4,'下线','1','','',NULL),(3827,'东街社区','331081105000','331081105005','0','0',4,'下线','1','','',NULL),(3828,'前街社区','331081105000','331081105006','0','0',4,'下线','1','','',NULL),(3829,'流水坑村','331081105000','331081105200','0','0',4,'下线','1','','',NULL),(3830,'环海村','331081105000','331081105201','0','0',4,'下线','1','','',NULL),(3831,'海洋村','331081105000','331081105202','0','0',4,'下线','1','','',NULL),(3832,'粗沙头村','331081105000','331081105203','0','0',4,'下线','1','','',NULL),(3833,'小沙头村','331081105000','331081105204','0','0',4,'下线','1','','',NULL),(3834,'长征村','331081105000','331081105205','0','0',4,'下线','1','','',NULL),(3835,'长海村','331081105000','331081105206','0','0',4,'下线','1','','',NULL),(3836,'庆丰村','331081105000','331081105207','0','0',4,'下线','1','','',NULL),(3837,'桂岙村','331081105000','331081105208','0','0',4,'下线','1','','',NULL),(3838,'三蒜村','331081105000','331081105209','0','0',4,'下线','1','','',NULL),(3839,'前进村','331081105000','331081105210','0','0',4,'下线','1','','',NULL),(3840,'中山村','331081105000','331081105211','0','0',4,'下线','1','','',NULL),(3841,'新村村','331081105000','331081105212','0','0',4,'下线','1','','',NULL),(3842,'中心村','331081105000','331081105213','0','0',4,'下线','1','','',NULL),(3843,'海滨村','331081105000','331081105214','0','0',4,'下线','1','','',NULL),(3844,'东角头村','331081105000','331081105215','0','0',4,'下线','1','','',NULL),(3845,'新东村','331081105000','331081105216','0','0',4,'下线','1','','',NULL),(3846,'前红村','331081105000','331081105217','0','0',4,'下线','1','','',NULL),(3847,'捕屿村','331081105000','331081105218','0','0',4,'下线','1','','',NULL),(3848,'新远景村','331081105000','331081105219','0','0',4,'下线','1','','',NULL),(3849,'车关村','331081105000','331081105220','0','0',4,'下线','1','','',NULL),(3850,'三岙村','331081105000','331081105221','0','0',4,'下线','1','','',NULL),(3851,'四岙村','331081105000','331081105222','0','0',4,'下线','1','','',NULL),(3852,'五岙村','331081105000','331081105223','0','0',4,'下线','1','','',NULL),(3853,'金星村','331081105000','331081105224','0','0',4,'下线','1','','',NULL),(3854,'盐南村','331081105000','331081105225','0','0',4,'下线','1','','',NULL),(3855,'盐北村','331081105000','331081105226','0','0',4,'下线','1','','',NULL),(3856,'后沙村','331081105000','331081105227','0','0',4,'下线','1','','',NULL),(3857,'兴建村','331081105000','331081105228','0','0',4,'下线','1','','',NULL),(3858,'里箬村','331081105000','331081105229','0','0',4,'下线','1','','',NULL),(3859,'东兴村','331081105000','331081105230','0','0',4,'下线','1','','',NULL),(3860,'东山村','331081105000','331081105231','0','0',4,'下线','1','','',NULL),(3861,'东湖村','331081105000','331081105232','0','0',4,'下线','1','','',NULL),(3862,'东海村','331081105000','331081105233','0','0',4,'下线','1','','',NULL),(3863,'胜海村','331081105000','331081105234','0','0',4,'下线','1','','',NULL),(3864,'小箬村','331081105000','331081105235','0','0',4,'下线','1','','',NULL),(3865,'花岙村','331081105000','331081105236','0','0',4,'下线','1','','',NULL),(3866,'水仙岙村','331081105000','331081105237','0','0',4,'下线','1','','',NULL),(3867,'大黄泥村','331081105000','331081105238','0','0',4,'下线','1','','',NULL),(3868,'新峰村','331081105000','331081105239','0','0',4,'下线','1','','',NULL),(3869,'新红村','331081105000','331081105240','0','0',4,'下线','1','','',NULL),(3870,'新滨村','331081105000','331081105241','0','0',4,'下线','1','','',NULL),(3871,'新进村','331081105000','331081105242','0','0',4,'下线','1','','',NULL),(3872,'小黄泥村','331081105000','331081105243','0','0',4,'下线','1','','',NULL),(3873,'西沙村','331081105000','331081105244','0','0',4,'下线','1','','',NULL),(3874,'东滨村','331081105000','331081105245','0','0',4,'下线','1','','',NULL),(3875,'红岩村','331081105000','331081105249','0','0',4,'下线','1','','',NULL),(3876,'隔海村','331081105000','331081105250','0','0',4,'下线','1','','',NULL),(3877,'沙头村','331081105000','331081105251','0','0',4,'下线','1','','',NULL),(3878,'永红村','331081105000','331081105252','0','0',4,'下线','1','','',NULL),(3879,'红卫村','331081105000','331081105253','0','0',4,'下线','1','','',NULL),(3880,'红旗村','331081105000','331081105254','0','0',4,'下线','1','','',NULL),(3881,'红星村','331081105000','331081105255','0','0',4,'下线','1','','',NULL),(3882,'高升村','331081105000','331081105256','0','0',4,'下线','1','','',NULL),(3883,'高岩村','331081105000','331081105257','0','0',4,'下线','1','','',NULL),(3884,'沙港村','331081105000','331081105258','0','0',4,'下线','1','','',NULL),(3885,'里西村','331081105000','331081105259','0','0',4,'下线','1','','',NULL),(3886,'杨柳新村','331081105000','331081105260','0','0',4,'下线','1','','',NULL),(3887,'东片社区','331081106000','331081106001','0','0',4,'下线','1','','',NULL),(3888,'湾下村','331081106000','331081106200','0','0',4,'下线','1','','',NULL),(3889,'桩头村','331081106000','331081106201','0','0',4,'下线','1','','',NULL),(3890,'决心村','331081106000','331081106202','0','0',4,'下线','1','','',NULL),(3891,'平安村','331081106000','331081106203','0','0',4,'下线','1','','',NULL),(3892,'民益村','331081106000','331081106204','0','0',4,'下线','1','','',NULL),(3893,'永胜村','331081106000','331081106205','0','0',4,'下线','1','','',NULL),(3894,'镇靖村','331081106000','331081106206','0','0',4,'下线','1','','',NULL),(3895,'永丰村','331081106000','331081106207','0','0',4,'下线','1','','',NULL),(3896,'永安村','331081106000','331081106208','0','0',4,'下线','1','','',NULL),(3897,'永进村','331081106000','331081106209','0','0',4,'下线','1','','',NULL),(3898,'新民村','331081106000','331081106210','0','0',4,'下线','1','','',NULL),(3899,'泥涂村','331081106000','331081106211','0','0',4,'下线','1','','',NULL),(3900,'金闸村','331081106000','331081106212','0','0',4,'下线','1','','',NULL),(3901,'闸南村','331081106000','331081106213','0','0',4,'下线','1','','',NULL),(3902,'汇合村','331081106000','331081106214','0','0',4,'下线','1','','',NULL),(3903,'鲤鱼村','331081106000','331081106215','0','0',4,'下线','1','','',NULL),(3904,'必胜村','331081106000','331081106216','0','0',4,'下线','1','','',NULL),(3905,'丰收村','331081106000','331081106217','0','0',4,'下线','1','','',NULL),(3906,'临江村','331081106000','331081106218','0','0',4,'下线','1','','',NULL),(3907,'江滨村','331081106000','331081106219','0','0',4,'下线','1','','',NULL),(3908,'长安村','331081106000','331081106220','0','0',4,'下线','1','','',NULL),(3909,'前街村','331081106000','331081106221','0','0',4,'下线','1','','',NULL),(3910,'新南村','331081106000','331081106222','0','0',4,'下线','1','','',NULL),(3911,'中南村','331081106000','331081106223','0','0',4,'下线','1','','',NULL),(3912,'新中村','331081106000','331081106224','0','0',4,'下线','1','','',NULL),(3913,'后新街村','331081106000','331081106225','0','0',4,'下线','1','','',NULL),(3914,'新北村','331081106000','331081106226','0','0',4,'下线','1','','',NULL),(3915,'民生村','331081106000','331081106227','0','0',4,'下线','1','','',NULL),(3916,'岱石村','331081106000','331081106228','0','0',4,'下线','1','','',NULL),(3917,'百花村','331081106000','331081106229','0','0',4,'下线','1','','',NULL),(3918,'复宁村','331081106000','331081106230','0','0',4,'下线','1','','',NULL),(3919,'中海村','331081106000','331081106231','0','0',4,'下线','1','','',NULL),(3920,'前王村','331081106000','331081106232','0','0',4,'下线','1','','',NULL),(3921,'二塘村','331081106000','331081106233','0','0',4,'下线','1','','',NULL),(3922,'新横径村','331081106000','331081106234','0','0',4,'下线','1','','',NULL),(3923,'新西村','331081106000','331081106235','0','0',4,'下线','1','','',NULL),(3924,'马路村','331081106000','331081106236','0','0',4,'下线','1','','',NULL),(3925,'泰星村','331081106000','331081106237','0','0',4,'下线','1','','',NULL),(3926,'五百屿村','331081106000','331081106238','0','0',4,'下线','1','','',NULL),(3927,'东楼村','331081106000','331081106239','0','0',4,'下线','1','','',NULL),(3928,'镇海村','331081106000','331081106240','0','0',4,'下线','1','','',NULL),(3929,'新湾村','331081106000','331081106241','0','0',4,'下线','1','','',NULL),(3930,'镇中村','331081106000','331081106242','0','0',4,'下线','1','','',NULL),(3931,'新胜村','331081106000','331081106243','0','0',4,'下线','1','','',NULL),(3932,'新农村','331081106000','331081106244','0','0',4,'下线','1','','',NULL),(3933,'二塘庙村','331081106000','331081106245','0','0',4,'下线','1','','',NULL),(3934,'宁海村','331081106000','331081106246','0','0',4,'下线','1','','',NULL),(3935,'联海村','331081106000','331081106247','0','0',4,'下线','1','','',NULL),(3936,'东林村','331081106000','331081106248','0','0',4,'下线','1','','',NULL),(3937,'靖海村','331081106000','331081106249','0','0',4,'下线','1','','',NULL),(3938,'四塘村','331081106000','331081106250','0','0',4,'下线','1','','',NULL),(3939,'雨伞村','331081106000','331081106251','0','0',4,'下线','1','','',NULL),(3940,'四湾村','331081106000','331081106252','0','0',4,'下线','1','','',NULL),(3941,'联友村','331081106000','331081106253','0','0',4,'下线','1','','',NULL),(3942,'下盛村','331081106000','331081106254','0','0',4,'下线','1','','',NULL),(3943,'海新村','331081106000','331081106255','0','0',4,'下线','1','','',NULL),(3944,'永定村','331081106000','331081106256','0','0',4,'下线','1','','',NULL),(3945,'定海村','331081106000','331081106257','0','0',4,'下线','1','','',NULL),(3946,'雨荣村','331081106000','331081106258','0','0',4,'下线','1','','',NULL),(3947,'洞济村','331081106000','331081106259','0','0',4,'下线','1','','',NULL),(3948,'青石桥','331081107000','331081107001','0','0',4,'下线','1','','',NULL),(3949,'打铁桥','331081107000','331081107002','0','0',4,'下线','1','','',NULL),(3950,'新桥头','331081107000','331081107003','0','0',4,'下线','1','','',NULL),(3951,'河头堂','331081107000','331081107004','0','0',4,'下线','1','','',NULL),(3952,'上街村','331081107000','331081107200','0','0',4,'下线','1','','',NULL),(3953,'中街村','331081107000','331081107201','0','0',4,'下线','1','','',NULL),(3954,'张老桥村','331081107000','331081107202','0','0',4,'下线','1','','',NULL),(3955,'许宅村','331081107000','331081107203','0','0',4,'下线','1','','',NULL),(3956,'前洋下村','331081107000','331081107204','0','0',4,'下线','1','','',NULL),(3957,'山下村','331081107000','331081107205','0','0',4,'下线','1','','',NULL),(3958,'赵桥村','331081107000','331081107206','0','0',4,'下线','1','','',NULL),(3959,'上珙村','331081107000','331081107207','0','0',4,'下线','1','','',NULL),(3960,'琛山村','331081107000','331081107208','0','0',4,'下线','1','','',NULL),(3961,'西焦湾村','331081107000','331081107209','0','0',4,'下线','1','','',NULL),(3962,'北珠村','331081107000','331081107210','0','0',4,'下线','1','','',NULL),(3963,'上墩村','331081107000','331081107211','0','0',4,'下线','1','','',NULL),(3964,'楼旗村','331081107000','331081107212','0','0',4,'下线','1','','',NULL),(3965,'莞渭童村','331081107000','331081107213','0','0',4,'下线','1','','',NULL),(3966,'西洋潘村','331081107000','331081107214','0','0',4,'下线','1','','',NULL),(3967,'茅洋村','331081107000','331081107215','0','0',4,'下线','1','','',NULL),(3968,'桐山村','331081107000','331081107216','0','0',4,'下线','1','','',NULL),(3969,'陈家宅村','331081107000','331081107217','0','0',4,'下线','1','','',NULL),(3970,'横路头村','331081107000','331081107218','0','0',4,'下线','1','','',NULL),(3971,'岭下周村','331081107000','331081107219','0','0',4,'下线','1','','',NULL),(3972,'岙口村','331081107000','331081107220','0','0',4,'下线','1','','',NULL),(3973,'帽岭村','331081107000','331081107221','0','0',4,'下线','1','','',NULL),(3974,'峨嵋山村','331081107000','331081107222','0','0',4,'下线','1','','',NULL),(3975,'横泾堂村','331081107000','331081107223','0','0',4,'下线','1','','',NULL),(3976,'江厦村','331081107000','331081107224','0','0',4,'下线','1','','',NULL),(3977,'界坑村','331081107000','331081107225','0','0',4,'下线','1','','',NULL),(3978,'梅溪村','331081107000','331081107226','0','0',4,'下线','1','','',NULL),(3979,'岭脚村','331081107000','331081107227','0','0',4,'下线','1','','',NULL),(3980,'白岩下村','331081107000','331081107228','0','0',4,'下线','1','','',NULL),(3981,'东坑村','331081107000','331081107229','0','0',4,'下线','1','','',NULL),(3982,'上河岙村','331081107000','331081107230','0','0',4,'下线','1','','',NULL),(3983,'下河岙村','331081107000','331081107231','0','0',4,'下线','1','','',NULL),(3984,'姆坑村','331081107000','331081107232','0','0',4,'下线','1','','',NULL),(3985,'姆坑山头村','331081107000','331081107233','0','0',4,'下线','1','','',NULL),(3986,'青屿村','331081107000','331081107234','0','0',4,'下线','1','','',NULL),(3987,'半山村','331081107000','331081107235','0','0',4,'下线','1','','',NULL),(3988,'下金前村','331081107000','331081107236','0','0',4,'下线','1','','',NULL),(3989,'大猛坑村','331081107000','331081107237','0','0',4,'下线','1','','',NULL),(3990,'下保村','331081107000','331081107238','0','0',4,'下线','1','','',NULL),(3991,'中保村','331081107000','331081107239','0','0',4,'下线','1','','',NULL),(3992,'上保村','331081107000','331081107240','0','0',4,'下线','1','','',NULL),(3993,'金岩村','331081107000','331081107241','0','0',4,'下线','1','','',NULL),(3994,'杨公岙村','331081107000','331081107242','0','0',4,'下线','1','','',NULL),(3995,'南湾村','331081107000','331081107243','0','0',4,'下线','1','','',NULL),(3996,'坞沙门村','331081107000','331081107244','0','0',4,'下线','1','','',NULL),(3997,'大闾街村','331081108000','331081108200','0','0',4,'下线','1','','',NULL),(3998,'田塘村','331081108000','331081108201','0','0',4,'下线','1','','',NULL),(3999,'后里村','331081108000','331081108202','0','0',4,'下线','1','','',NULL),(4000,'下许村','331081108000','331081108203','0','0',4,'下线','1','','',NULL),(4001,'小东岙村','331081108000','331081108204','0','0',4,'下线','1','','',NULL),(4002,'沌头村','331081108000','331081108205','0','0',4,'下线','1','','',NULL),(4003,'长沙村','331081108000','331081108206','0','0',4,'下线','1','','',NULL),(4004,'冷水塘村','331081108000','331081108207','0','0',4,'下线','1','','',NULL),(4005,'山岙村','331081108000','331081108208','0','0',4,'下线','1','','',NULL),(4006,'坑洋村','331081108000','331081108209','0','0',4,'下线','1','','',NULL),(4007,'叶家村','331081108000','331081108210','0','0',4,'下线','1','','',NULL),(4008,'堂前村','331081108000','331081108211','0','0',4,'下线','1','','',NULL),(4009,'林岙村','331081108000','331081108212','0','0',4,'下线','1','','',NULL),(4010,'横溪村','331081108000','331081108213','0','0',4,'下线','1','','',NULL),(4011,'彭家村','331081108000','331081108214','0','0',4,'下线','1','','',NULL),(4012,'二宅村','331081108000','331081108215','0','0',4,'下线','1','','',NULL),(4013,'峻岭村','331081108000','331081108216','0','0',4,'下线','1','','',NULL),(4014,'莞岙村','331081108000','331081108217','0','0',4,'下线','1','','',NULL),(4015,'三宅村','331081108000','331081108218','0','0',4,'下线','1','','',NULL),(4016,'毛洋村','331081108000','331081108219','0','0',4,'下线','1','','',NULL),(4017,'磊石村','331081108000','331081108220','0','0',4,'下线','1','','',NULL),(4018,'礁门村','331081108000','331081108221','0','0',4,'下线','1','','',NULL),(4019,'东峰山村','331081108000','331081108222','0','0',4,'下线','1','','',NULL),(4020,'高山头村','331081108000','331081108223','0','0',4,'下线','1','','',NULL),(4021,'吉捕岙村','331081108000','331081108224','0','0',4,'下线','1','','',NULL),(4022,'沙岙村','331081108000','331081108225','0','0',4,'下线','1','','',NULL),(4023,'横屿村','331081108000','331081108226','0','0',4,'下线','1','','',NULL),(4024,'台头村','331081108000','331081108227','0','0',4,'下线','1','','',NULL),(4025,'南边村','331081108000','331081108228','0','0',4,'下线','1','','',NULL),(4026,'摘梅坑村','331081108000','331081108229','0','0',4,'下线','1','','',NULL),(4027,'中柱村','331081108000','331081108230','0','0',4,'下线','1','','',NULL),(4028,'下街村','331081108000','331081108231','0','0',4,'下线','1','','',NULL),(4029,'岙环街村','331081108000','331081108232','0','0',4,'下线','1','','',NULL),(4030,'沙头门村','331081108000','331081108233','0','0',4,'下线','1','','',NULL),(4031,'后塘村','331081108000','331081108234','0','0',4,'下线','1','','',NULL),(4032,'后亭坑村','331081108000','331081108235','0','0',4,'下线','1','','',NULL),(4033,'罗殊村','331081108000','331081108236','0','0',4,'下线','1','','',NULL),(4034,'铁下村','331081108000','331081108237','0','0',4,'下线','1','','',NULL),(4035,'古岭下村','331081108000','331081108238','0','0',4,'下线','1','','',NULL),(4036,'池头村','331081108000','331081108239','0','0',4,'下线','1','','',NULL),(4037,'兰公岙村','331081108000','331081108240','0','0',4,'下线','1','','',NULL),(4038,'上岙村','331081108000','331081108241','0','0',4,'下线','1','','',NULL),(4039,'后岭村','331081108000','331081108242','0','0',4,'下线','1','','',NULL),(4040,'营田村','331081108000','331081108243','0','0',4,'下线','1','','',NULL),(4041,'叠岭村','331081108000','331081108244','0','0',4,'下线','1','','',NULL),(4042,'彭下村','331081108000','331081108245','0','0',4,'下线','1','','',NULL),(4043,'照谷村','331081108000','331081108246','0','0',4,'下线','1','','',NULL),(4044,'蒲洞村','331081108000','331081108247','0','0',4,'下线','1','','',NULL),(4045,'寨门村','331081108000','331081108248','0','0',4,'下线','1','','',NULL),(4046,'何家村','331081108000','331081108249','0','0',4,'下线','1','','',NULL),(4047,'上塘村','331081108000','331081108250','0','0',4,'下线','1','','',NULL),(4048,'南岙村','331081108000','331081108251','0','0',4,'下线','1','','',NULL),(4049,'小江绾村','331081108000','331081108252','0','0',4,'下线','1','','',NULL),(4050,'上绾山村','331081108000','331081108253','0','0',4,'下线','1','','',NULL),(4051,'下绾山村','331081108000','331081108254','0','0',4,'下线','1','','',NULL),(4052,'竹坑村','331081108000','331081108255','0','0',4,'下线','1','','',NULL),(4053,'珠村村','331081108000','331081108256','0','0',4,'下线','1','','',NULL),(4054,'南下陈村','331081108000','331081108257','0','0',4,'下线','1','','',NULL),(4055,'白溪村','331081108000','331081108258','0','0',4,'下线','1','','',NULL),(4056,'西坑村','331081108000','331081108259','0','0',4,'下线','1','','',NULL),(4057,'西沙头村','331081108000','331081108260','0','0',4,'下线','1','','',NULL),(4058,'西合村','331081108000','331081108261','0','0',4,'下线','1','','',NULL),(4059,'广联村','331081108000','331081108262','0','0',4,'下线','1','','',NULL),(4060,'毛家村','331081108000','331081108263','0','0',4,'下线','1','','',NULL),(4061,'湾塘村','331081108000','331081108264','0','0',4,'下线','1','','',NULL),(4062,'黄湾村','331081108000','331081108265','0','0',4,'下线','1','','',NULL),(4063,'小石桥村','331081108000','331081108266','0','0',4,'下线','1','','',NULL),(4064,'山前村','331081108000','331081108267','0','0',4,'下线','1','','',NULL),(4065,'山后村','331081108000','331081108268','0','0',4,'下线','1','','',NULL),(4066,'东辽村','331081108000','331081108269','0','0',4,'下线','1','','',NULL),(4067,'沿坑村','331081108000','331081108270','0','0',4,'下线','1','','',NULL),(4068,'大田村','331081108000','331081108271','0','0',4,'下线','1','','',NULL),(4069,'田基村','331081108000','331081108272','0','0',4,'下线','1','','',NULL),(4070,'湖溪村','331081108000','331081108273','0','0',4,'下线','1','','',NULL),(4071,'茶园村','331081108000','331081108274','0','0',4,'下线','1','','',NULL),(4072,'西山村','331081108000','331081108275','0','0',4,'下线','1','','',NULL),(4073,'石桥街村','331081109000','331081109200','0','0',4,'下线','1','','',NULL),(4074,'沙角村','331081109000','331081109201','0','0',4,'下线','1','','',NULL),(4075,'下宅金村','331081109000','331081109202','0','0',4,'下线','1','','',NULL),(4076,'下宅吴村','331081109000','331081109203','0','0',4,'下线','1','','',NULL),(4077,'小岭下村','331081109000','331081109204','0','0',4,'下线','1','','',NULL),(4078,'横古塘村','331081109000','331081109205','0','0',4,'下线','1','','',NULL),(4079,'黄西岙村','331081109000','331081109206','0','0',4,'下线','1','','',NULL),(4080,'上洞桥村','331081109000','331081109207','0','0',4,'下线','1','','',NULL),(4081,'下洞桥村','331081109000','331081109208','0','0',4,'下线','1','','',NULL),(4082,'陈岙村','331081109000','331081109209','0','0',4,'下线','1','','',NULL),(4083,'阮岙村','331081109000','331081109210','0','0',4,'下线','1','','',NULL),(4084,'何岙村','331081109000','331081109211','0','0',4,'下线','1','','',NULL),(4085,'后林村','331081109000','331081109212','0','0',4,'下线','1','','',NULL),(4086,'大甲头村','331081109000','331081109213','0','0',4,'下线','1','','',NULL),(4087,'后台门村','331081109000','331081109214','0','0',4,'下线','1','','',NULL),(4088,'前林村','331081109000','331081109215','0','0',4,'下线','1','','',NULL),(4089,'土坦头村','331081109000','331081109216','0','0',4,'下线','1','','',NULL),(4090,'横湖村','331081109000','331081109217','0','0',4,'下线','1','','',NULL),(4091,'中央段村','331081109000','331081109218','0','0',4,'下线','1','','',NULL),(4092,'斜路村','331081109000','331081109219','0','0',4,'下线','1','','',NULL),(4093,'杨家浦村','331081109000','331081109220','0','0',4,'下线','1','','',NULL),(4094,'桥浦村','331081109000','331081109221','0','0',4,'下线','1','','',NULL),(4095,'中扇村','331081109000','331081109222','0','0',4,'下线','1','','',NULL),(4096,'东花桥村','331081109000','331081109223','0','0',4,'下线','1','','',NULL),(4097,'上王村','331081109000','331081109224','0','0',4,'下线','1','','',NULL),(4098,'杨家村','331081109000','331081109225','0','0',4,'下线','1','','',NULL),(4099,'下黄村','331081109000','331081109226','0','0',4,'下线','1','','',NULL),(4100,'秀溪居','331081110000','331081110001','0','0',4,'下线','1','','',NULL),(4101,'街头村','331081110000','331081110200','0','0',4,'下线','1','','',NULL),(4102,'白牛皮村','331081110000','331081110201','0','0',4,'下线','1','','',NULL),(4103,'新方村','331081110000','331081110202','0','0',4,'下线','1','','',NULL),(4104,'茅陶村','331081110000','331081110203','0','0',4,'下线','1','','',NULL),(4105,'蒋山村','331081110000','331081110204','0','0',4,'下线','1','','',NULL),(4106,'小坞根村','331081110000','331081110205','0','0',4,'下线','1','','',NULL),(4107,'大地山村','331081110000','331081110206','0','0',4,'下线','1','','',NULL),(4108,'西山下村','331081110000','331081110207','0','0',4,'下线','1','','',NULL),(4109,'寺基村','331081110000','331081110208','0','0',4,'下线','1','','',NULL),(4110,'西里村','331081110000','331081110209','0','0',4,'下线','1','','',NULL),(4111,'坑潘村','331081110000','331081110210','0','0',4,'下线','1','','',NULL),(4112,'东里村','331081110000','331081110211','0','0',4,'下线','1','','',NULL),(4113,'洋呈村','331081110000','331081110212','0','0',4,'下线','1','','',NULL),(4114,'下呈村','331081110000','331081110213','0','0',4,'下线','1','','',NULL),(4115,'沙山村','331081110000','331081110214','0','0',4,'下线','1','','',NULL),(4116,'下楼村','331081110000','331081110215','0','0',4,'下线','1','','',NULL),(4117,'东门头村','331081110000','331081110216','0','0',4,'下线','1','','',NULL),(4118,'白璧村','331081110000','331081110217','0','0',4,'下线','1','','',NULL),(4119,'荣茂电器','331081107000','331081107245','0','0',4,'下线','0','','',NULL),(4120,'西子社区','331081003000','331081003221','0','0',4,'下线','0','','',NULL);

CREATE TABLE `swgk_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '启用状态 1-启用 0-禁用',
  `name` varchar(11) NOT NULL DEFAULT '' COMMENT '角色名称',
  `desc` varchar(200) NOT NULL DEFAULT '' COMMENT '角色描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='管理者角色类型表';

insert  into `swgk_role`(`id`,`status`,`name`,`desc`) values (1,1,'超级管理员','');

CREATE TABLE `swgk_role_access` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `role_id` smallint(6) unsigned NOT NULL COMMENT '角色ID，见role表ID',
  `node_id` smallint(6) unsigned NOT NULL COMMENT '栏目ID，见node表ID',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '访问状态 1-是 0-否',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16084 DEFAULT CHARSET=utf8mb4 COMMENT='用户访问控制权限表';

insert  into `swgk_role_access`(`id`,`role_id`,`node_id`,`status`) values (1766,1,1,1),(1767,1,2,1),(1768,1,3,1),(1769,1,5,1),(1770,1,6,1),(1771,1,7,1),(1772,1,8,1),(1773,1,9,1),(1774,1,10,1),(1775,1,11,1),(1776,1,12,1),(1777,1,13,1),(1780,1,16,1),(1781,1,17,1),(1782,1,18,1),(1783,1,19,1),(1784,1,20,1),(1785,1,21,1),(1786,1,23,1),(1787,1,24,1),(1788,1,25,1),(1789,1,26,1),(1790,1,27,1),(1791,1,28,1),(1792,1,29,1),(1793,1,30,1),(1794,1,31,1),(1796,1,33,1),(1797,1,34,1),(1799,1,36,1),(1800,1,37,1),(1801,1,38,1),(1802,1,39,1),(1803,1,40,1),(1804,1,41,1),(1805,1,42,1),(1806,1,43,1),(1807,1,44,1),(1808,1,45,1),(1809,1,46,1),(1810,1,47,1),(1811,1,48,1),(1812,1,49,1),(1813,1,50,1),(1814,1,51,1),(1816,1,53,1),(1817,1,54,1),(1818,1,55,1),(1819,1,56,1),(1820,1,57,1),(1821,1,58,1),(1822,1,59,1),(1823,1,60,1),(1824,1,61,1),(1825,1,62,1),(1826,1,63,1),(1827,1,64,1),(1828,1,65,1),(1829,1,66,1),(1830,1,67,1),(1831,1,68,1),(1832,1,69,1),(1833,1,70,1),(1834,1,71,1),(1835,1,72,1),(1836,1,73,1),(1837,1,74,1),(1838,1,76,1),(1839,1,78,1),(1840,1,79,1),(1841,1,84,1),(1842,1,85,1),(1843,1,86,1),(1844,1,87,1),(1845,1,88,1),(1846,1,89,1),(1849,1,92,1),(1850,1,93,1),(1851,1,94,1),(1852,1,95,1),(1853,1,96,1),(1854,1,97,1),(1855,1,98,1),(1856,1,99,1),(1857,1,100,1),(1858,1,101,1),(1859,1,102,1),(1860,1,103,1),(1861,1,104,1),(1862,1,105,1),(1863,1,106,1),(1864,1,107,1),(1865,1,108,1),(1866,1,109,1),(1867,1,110,1),(1868,1,111,1),(1869,1,112,1),(1870,1,113,1),(1871,1,114,1),(1872,1,115,1),(1873,1,116,1),(1874,1,117,1),(1875,1,118,1),(1876,1,119,1),(1881,1,120,1),(1886,1,121,1),(1891,1,122,1),(1901,1,124,1),(1906,1,125,1),(1911,1,126,1),(1916,1,127,1),(1921,1,128,1),(1926,1,129,1),(1931,1,130,1),(1936,1,131,1),(1941,1,132,1),(1946,1,133,1),(1951,1,134,1),(1956,1,135,1),(1961,1,136,1),(1966,1,137,1),(1971,1,138,1),(1976,1,139,1),(1981,1,140,1),(1986,1,141,1),(1991,1,142,1),(1996,1,143,1),(2001,1,144,1),(2006,1,145,1),(2011,1,146,1),(2016,1,147,1),(2021,1,148,1),(2026,1,149,1),(2031,1,150,1),(2036,1,151,1),(2041,1,152,1),(2046,1,153,1),(2051,1,154,1),(2056,1,155,1),(2061,1,156,1),(2066,1,157,1),(2071,1,158,1),(2076,1,159,1),(2081,1,160,1),(2086,1,161,1),(2091,1,162,1),(2096,1,163,1),(2101,1,164,1),(2106,1,165,1),(2111,1,166,1),(2116,1,167,1),(2121,1,168,1),(2126,1,169,1),(2131,1,170,1),(2136,1,171,1),(2141,1,172,1),(2778,1,173,1),(2784,1,174,1),(2790,1,175,1),(2796,1,176,1),(2802,1,177,1),(2808,1,178,1),(2814,1,179,1),(2820,1,180,1),(2826,1,181,1),(2832,1,182,1),(2838,1,183,1),(2844,1,184,1),(2856,1,186,1),(2862,1,187,1),(2868,1,188,1),(2880,1,189,1),(3065,1,191,1),(3072,1,192,1),(3601,1,193,1),(3609,1,194,1),(3617,1,195,1),(3625,1,196,1),(3633,1,197,1),(4894,1,198,1),(4906,1,199,1),(4918,1,200,1),(4930,1,201,1),(4942,1,202,1),(4954,1,203,1),(4966,1,204,1),(4978,1,205,1),(4990,1,206,1),(5002,1,207,1),(5014,1,208,1),(5026,1,209,1),(5038,1,210,1),(5277,1,214,1),(5290,1,215,1),(5303,1,216,1),(5316,1,217,1),(5329,1,218,1),(5342,1,219,1),(6143,1,220,1),(6157,1,221,1),(6171,1,222,1),(6185,1,223,1),(6199,1,224,1),(6213,1,225,1),(6227,1,226,1),(6241,1,227,1),(6255,1,228,1),(6269,1,229,1),(7107,1,230,1),(7121,1,231,1),(7135,1,232,1),(7149,1,233,1),(7163,1,234,1),(7177,1,235,1),(7191,1,236,1),(7205,1,237,1),(7219,1,238,1),(7806,1,239,1),(8960,1,240,1),(8974,1,241,1),(8988,1,242,1),(9002,1,243,1),(9592,1,244,1),(9994,1,245,1),(13287,1,246,1),(14065,1,247,1),(14461,1,248,1),(14665,1,249,1),(14870,1,250,1),(14880,1,251,1),(16072,1,252,1);

CREATE TABLE `swgk_tv_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `tname` varchar(21) NOT NULL DEFAULT '' COMMENT '表名',
  `flag` varchar(19) NOT NULL DEFAULT '' COMMENT '操作',
  `data` text COMMENT '数据',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '录入时间',
  `status` enum('yes','no') NOT NULL DEFAULT 'no' COMMENT '该语句是否被执行，默认为no：yes-是 no-否',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='tv数据更新队列表';

CREATE TABLE `swgk_ua` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ua` text,
  `signs` char(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `signs` (`signs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

CREATE TABLE `swgk_user_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '见base_ppl表uuid',
  `role_id` smallint(6) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID，见role表ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22699 DEFAULT CHARSET=utf8mb4 COMMENT='用户角色表';

insert  into `swgk_user_role`(`id`,`uuid`,`role_id`) values (1,'4c8f125cd4334b248dceed93ee330685',1);

CREATE TABLE `swgk_vod` (
  `id` int(10) unsigned NOT NULL COMMENT '表ID',
  `type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '网易视频分类id',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '发布人uuid，见base_ppl表uuid',
  `vid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '网易云 点播id',
  `vod_name` varchar(101) NOT NULL DEFAULT '' COMMENT '点播名称',
  `snapshoturl` varchar(201) NOT NULL DEFAULT '' COMMENT '视频封面',
  `downloadorigurl` varchar(1001) NOT NULL DEFAULT '' COMMENT '原始视频url',
  `initialsize` varchar(20) NOT NULL DEFAULT '' COMMENT '视频大小',
  `status` char(2) NOT NULL DEFAULT '10' COMMENT '视频的状态，10表示初始，20表示失败，30表示处理中，40表示成功，50表示屏蔽',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='点播列表';

CREATE TABLE `swgk_vod_node` (
  `id` tinyint(3) unsigned NOT NULL COMMENT '表ID',
  `name` varchar(10) NOT NULL COMMENT '名称',
  `type_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '网易视频分类id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='网易视频分类表';

CREATE TABLE `swgk_data_intoreason` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(2) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(4) NOT NULL DEFAULT '' COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='流动人口流入原因表';

INSERT INTO `swgk_data_intoreason` VALUES (1,'01','务工'),(2,'02','务农'),(3,'03','经商'),(4,'04','学习培训'),(5,'05','婚嫁'),(6,'06','随迁'),(7,'07','治病疗养'),(8,'08','投亲靠友'),(9,'09','工作调动'),(10,'99','其他');

CREATE TABLE `swgk_user_favorite_nodes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '用户uuid，见base_ppl表uuid',
  `node_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '收藏的栏目ID，见node表ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户收藏的栏目节点';

CREATE TABLE `swgk_grab_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `title` varchar(201) NOT NULL DEFAULT '' COMMENT '标题',
  `contents` mediumtext COMMENT '内容',
  `release_time` date NOT NULL DEFAULT '1970-01-01' COMMENT '发布时间',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '抓取时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻抓取表';

CREATE TABLE `swgk_bind_region` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `uuid` char(32) NOT NULL DEFAULT '' COMMENT '绑定用户uuid，见base_ppl表uuid',
  `region_code` char(12) NOT NULL DEFAULT '' COMMENT '区域编码, 见region表code',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='区域绑定记录表';

CREATE TABLE `swgk_duty_person` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `name` varchar(81) NOT NULL DEFAULT '' COMMENT '姓名',
  `contact` char(32) NOT NULL DEFAULT '' COMMENT '联系方式',
  `pic_path` varchar(302) NOT NULL DEFAULT '' COMMENT '工作照',
  `position` varchar(51) NOT NULL DEFAULT '' COMMENT '职务',
  `region_code` char(12) NOT NULL DEFAULT '' COMMENT '所属区域',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '录入时间',
  `etime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '编辑时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='值班人员表';

CREATE TABLE `swgk_duty_schedule` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `person_id` varchar(81) NOT NULL COMMENT '值班人id，关联值班人员表id',
  `week_day` varchar(302) NOT NULL DEFAULT '' COMMENT '每周值班安排，多个用逗号隔开',
  `date_set` varchar(302) NOT NULL DEFAULT '' COMMENT '指定值班日期，多个用逗号隔开',
  `ctime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '录入时间',
  `etime` datetime NOT NULL DEFAULT '1970-01-01 00:00:00' COMMENT '编辑时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='值班日程安排表';

CREATE TABLE `swgk_photo_category` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT COMMENT '表ID',
  `code` char(6) NOT NULL DEFAULT '' COMMENT '编码',
  `name` varchar(31) NOT NULL DEFAULT '' COMMENT '名称',
  `status` enum('上线', '下线') NOT NULL DEFAULT '上线' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='随手拍分类表';
INSERT INTO `swgk_photo_category` VALUES (1,'ssp001','履职记录','上线'),(2,'ssp002','举报投诉','上线'),(3,'ssp003','其他','上线');