一則 Mysql 建表語句

標籤：style   blog   io   ar   color   sp   on   div   log   

 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;

 

一則 Mysql 建表語句