DESCRIPTION VALUE INTVALUE 身份证 IDCARD 100001军人证 ARMYMANCARD 100002护照 PASSPORT 100003户口本 PERMANENTRESIDENT 100004外国人永久居留证 FOREIGN 100005武警证 POLICECARD 100006公章 CACHET 100007工商营业执照 BusinessLicense 100008法人代码证 CorporationID 100009学生证 STUDENTCARD 100010士兵证 SOLDIERCARD 100011港澳居民来往内地通行证 GAJMLW 100016台湾居民来往大陆通行证 TWJMLW 100017其他证件类型 QTZJLX 100018

CREATE TABLE `certificate_type` (

`id` int(11) NOT NULL auto_increment COMMENT '编号',

`value` varchar(50) collate utf8_unicode_ci default NULL,

`description` varchar(50) collate utf8_unicode_ci default NULL,

`intvalue` int(10) default NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (1, 'IDCARD', '身份证', 100001);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (2, 'ARMYMANCARD', '军人证 ', 100002);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (3, 'PASSPORT', '护照', 100003);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (4, 'PERMANENTRESIDENT', '户口本', 100004);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (5, 'FOREIGN', '外国人永久居留证', 100005);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (6, 'POLICECARD', '武警证', 100006);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (7, 'CACHET', '公章', 100007);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (8, 'BusinessLicense', '工商营业执照', 100008);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (9, ' CorporationID', '法人代码证', 100009);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (10, 'STUDENTCARD', '学生证 ', 100010);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (11, 'SOLDIERCARD', '士兵证', 100011);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (12, 'GAJMLW', '港澳居民来往内地通行证', 100016);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (13, 'TWJMLW', '台湾居民来往大陆通行证', 100017);

INSERT INTO `certificate_type` (`id`, `value`, `description`, `intvalue`) VALUES (14, 'QTZJLX', '其他证件类型', 100018);