CREATE TABLE `tb_diary` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`address` varchar(50) NOT NULL COMMENT '日记保存的地址',
`writeTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
`userid` int(10) unsigned NOT NULL COMMENT '用户ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=gbk;
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(60) NOT NULL,
`address` varchar(50) NOT NULL COMMENT '日记保存的地址',
`writeTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间',
`userid` int(10) unsigned NOT NULL COMMENT '用户ID',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=gbk;