DROP TABLE IF EXISTS `nuvue`;

 CREATE TABLE `nuvue`(

     `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,

     `status` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态',

     `uid` INT(10) UNSIGNED NOT NULL COMMENT '创建用户',

     `province_id` TINYINT(3)  UNSIGNED NOT NULL COMMENT '一级城市',

     `city_id` TINYINT(3)  UNSIGNED NOT NULL COMMENT '二级地区',

     `name` VARCHAR(100) NOT NULL COMMENT '场地名称',

     `logo_url` VARCHAR(100) NOT NULL COMMENT '场地Logo',

     `location_address` VARCHAR(200) NOT NULL COMMENT '场地地址',

     `location_point` VARCHAR(30) NOT NULL COMMENT '场地坐标',

     `caoncat_phone` VARCHAR(20) NOT NULL COMMENT '联系人电话',

     `type` ENUM('livehouse','theare','bar','bookshop','other') NOT NULL COMMENT '场地类型',

     `phone` VARCHAR(20) NOT NULL COMMENT '场地电话',

     `area` VARCHAR(10) NOT NULL COMMENT '场地面积',

     `people` VARCHAR(10) NOT NULL COMMENT '容纳人数',

     `device` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '场地设备',

     `introduction` VARCHAR(100) NOT NULL DEFAULT '' COMMENT '场地简介',

     `create_at` DATETIME NOT NULL COMMENT '创建时间',

     PRIMARY KEY `id`(`id`),

     UNIQUE KEY `name`(`name`),

     KEY `idx_type`(`type`),

     KEY `idx_uid`(`uid`),

     KEY `idx_status`(`status`),

     KEY `idx_location`(`province_id`,`city_id`)

 )ENGINE= Myisam DEFAULT CHARSET = utf8;