CREATE TABLE `blog` (
`id` bigint( 20 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 200 ) COLLATE utf8_unicode_ci NOT NULL ,
`kind` int( 11 ) NOT NULL ,
`content` longtext COLLATE utf8_unicode_ci,
`postTime` datetime NOT NULL ,
`updateTime` varchar( 1000 ) COLLATE utf8_unicode_ci default NULL ,
`userId` int( 11 ) NOT NULL ,
`quanxian` int( 4 ) NOT NULL ,
`view` int( 6 ) NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci ;