mysql建表语句

// 建表名为 blog_blog
create table blog_blog(
    bid mediumint(8) primary key auto_increment,
    btitle varchar(60) ,
    content text,
    status tinyint(2),
    cid tinyint(4)
)

//更改主键bid 为id
alter table blog_blog change bid id mediumint(8) auto_increment

// 建表名为 blog_channel
create table blog_channel(
    cid tinyint(4) default null,
    ctitle varchar(60) default null,
    isshow tinyint(2) default '1'
)ENGINE = MyISAM DEFAULT CHARSET = gbk

// 建表名为 blog_note
create table blog_note( 
    nid int(11) not null auto_increment, 
    uid mediumint(6) default null,
    wtime int(10) default null,
    wpic varchar(200) default null,
    status tinyint(2) default '0',
    reply tinyint(2) default '0',
    primary key(nid)
  )ENGINE = MyISAM DEFAULT CHARSET = gbk