ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `pat_name` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名' after `ip`; ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `pat_age` int(8) NOT NULL DEFAULT '0' COMMENT '年龄' after `pat_name`; ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `pat_sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别' after `pat_age`; ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `id_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '证件类型(1:身份证,2:护照)' after `pat_sex`; ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `id_num` varchar(100) NOT NULL DEFAULT '' COMMENT '证件号' after `id_type`; ALTER TABLE `zzcx_inquiry_info` ADD COLUMN `degree` tinyint(4) NOT NULL DEFAULT '0' COMMENT '诊断程度(1:高,2:中,3:低)' after `id_num`;