主表(内容表)
CREATE TABLE IF NOT EXISTS `diary`
(
`diary_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
`user_name` VARCHAR(255) NOT NULL COMMENT 'MD5加密用户名',
`classify_id` INT(10) NOT NULL DEFAULT -1 COMMENT '分类表中主键id值,-1为默认分类',
`title` VARCHAR(255) NOT NULL DEFAULT '无标题内容' COMMENT '标题',
`contents` TEXT NOT NULL DEFAULT '' COMMENT '内容',
`create_time` INT(20) UNSIGNED DEFAULT 0 COMMENT '创建时间',
`update_time` INT(20) UNSIGNED DEFAULT 0 COMMENT '更新时间',
PRIMARY KEY ( `diary_id` ),
KEY `index_user_name` (<