MySQL build table statement, MySQL build table statement _php Tutorial

MySQL build table statement, MySQL build table statement

1 DROP TABLE IF EXISTS' NuVue ';2 3 CREATE TABLE' NuVue ' (4' ID 'INT(Ten) UNSIGNED not NULLAuto_increment,5' Status 'TINYINT(2) UNSIGNED not NULL DEFAULT 0COMMENT'Status',6' UID 'INT(Ten) UNSIGNED not NULLCOMMENT'Create user',7' province_id 'TINYINT(3) UNSIGNED not NULLCOMMENT'first-class city',8' city_id 'TINYINT(3) UNSIGNED not NULLCOMMENT'Level Two area',9' Name 'VARCHAR( -) not NULLCOMMENT'Site name',Ten' Logo_url 'VARCHAR( -) not NULLCOMMENT'Site Logo', One' Location_address 'VARCHAR( $) not NULLCOMMENT'Venue Address', A' Location_point 'VARCHAR( -) not NULLCOMMENT'site coordinates', -' Caoncat_phone 'VARCHAR( -) not NULLCOMMENT'Contact Phone', -' Type ' ENUM ('Livehouse','Theare','Bar','Bookshop',' Other') not NULLCOMMENT'Venue Type', the' Phone 'VARCHAR( -) not NULLCOMMENT'Venue Phone', -' Area 'VARCHAR(Ten) not NULLCOMMENT'Site Area', -' People 'VARCHAR(Ten) not NULLCOMMENT'Number of seats', -' Device 'VARCHAR( -) not NULL DEFAULT ''COMMENT'Site Equipment', +' Introduction 'VARCHAR( -) not NULL DEFAULT ''COMMENT'Venue Introduction', -' Create_at 'DATETIME  not NULLCOMMENT'creation Time', +     PRIMARY KEY' id ' (' id '), A     UNIQUE KEY' name ' (' name '), at     KEY' Idx_type ' (' type '), -     KEY' idx_uid ' (' uid '), -     KEY' Idx_status ' (' status '), -     KEY' idx_location ' (' province_id ', ' city_id ') -) ENGINE=MyisamDEFAULTCHARSET=UTF8;

http://www.bkjia.com/PHPjc/922303.html www.bkjia.com true http://www.bkjia.com/PHPjc/922303.html techarticle a MySQL Build table statement, MySQL build table statement 1 DROP table IF EXISTS ' NuVue '; 2 3 CREATE table ' NuVue ' (4 ' id ' INT ') UNSIGNED not NULL Auto_increment, 5 ' status ' TINYINT (2) ...

