Version7 447 B

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