123456789 |
- 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;
|