CREATE TABLE if not exists `every_studies` ( `id` varchar(50) NOT NULL, `institution_id` varchar(50) DEFAULT NULL COMMENT '医院id', `institution_name` varchar(255) DEFAULT NULL COMMENT '医院名称', `date` varchar(50) DEFAULT NULL COMMENT '检查时间', `count` int(11) DEFAULT NULL COMMENT '检查数量', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ALTER TABLE `institution` ADD is_test varchar(10) default 0;