CREATE TABLE `blog` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`title` varchar(45) NOT NULL,

`label` varchar(45) NOT NULL,

`time` date NOT NULL,

`path` longtext,

`visit` int(10) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

UNIQUE KEY `id_UNIQUE` (`id`),

UNIQUE KEY `title_UNIQUE` (`title`)

) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8;