4 CREATE TABLE `comments` (
5 `comment_id` int(11) NOT NULL AUTO_INCREMENT,
6 `comment_user_id` int(11) NOT NULL,
7 `comment_published` datetime NOT NULL,
8 `comment_of_url` varchar(2048) NOT NULL,
9 `comment_type` varchar(32) NOT NULL,
10 `comment_json` mediumtext NOT NULL,
11 `comment_pingstate` varchar(6) NOT NULL,
12 PRIMARY KEY (`comment_id`)
13 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
16 CREATE TABLE `users` (
17 `user_id` int(11) NOT NULL AUTO_INCREMENT,
18 `user_name` varchar(128) NOT NULL,
19 `user_imageurl` varchar(1024) NOT NULL,
20 PRIMARY KEY (`user_id`)
21 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;