Closed timlentse closed 9 years ago
建表sql,暂定这些基本信息,以后可能会加
CREATE TABLE IF NOT EXISTS `hospitals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(128) NOT NULL, `city` varchar(50) NOT NULL, `province` varchar(50) NOT NULL, `level` varchar(50) DEFAULT NULL, `mode` varchar(50) DEFAULT NULL, `dep` varchar(256) DEFAULT NULL, `address` varchar(256) DEFAULT NULL, `phone` varchar(256) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
建表sql,暂定这些基本信息,以后可能会加