一则 mysql 建表语句，mysql建表语句 1 drop table if exists `nuvue`; 2 3 create table `nuvue`( 4 `id` int(10) unsigned not null auto_increment, 5 `status` tinyint(2) unsigned not null default 0 comment '状态', 6 `uid` int(10) unsigned not null comment '创建用户', 7 `province_id` tinyint(3) unsigned not null comment '一级城市', 8 `city_id` tinyint(3) unsigned not null comment '二级地区', 9 `name` varchar(100) not null comment '场地名称',10 `logo_url` varchar(100) not null comment '场地logo',11 `location_address` varchar(200) not null comment '场地地址',12 `location_point` varchar(30) not null comment '场地坐标',13 `caoncat_phone` varchar(20) not null comment '联系人电话',14 `type` enum('livehouse','theare','bar','bookshop','other') not null comment '场地类型',15 `phone` varchar(20) not null comment '场地电话',16 `area` varchar(10) not null comment '场地面积',17 `people` varchar(10) not null comment '容纳人数',18 `device` varchar(100) not null default '' comment '场地设备',19 `introduction` varchar(100) not null default '' comment '场地简介',20 `create_at` datetime not null comment '创建时间',21 primary key `id`(`id`),22 unique key `name`(`name`),23 key `idx_type`(`type`),24 key `idx_uid`(`uid`),25 key `idx_status`(`status`),26 key `idx_location`(`province_id`,`city_id`)27 )engine= myisam default charset = utf8;
http://www.bkjia.com/phpjc/922303.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/922303.htmltecharticle一则 mysql 建表语句，mysql建表语句 1 drop table if exists `nuvue`; 2 3 create table `nuvue`( 4 `id` int ( 10 ) unsigned not null auto_increment, 5 `status` tinyint ( 2 )...