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 PRIMARY KEY (`comment_id`)
12 ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
15 CREATE TABLE `users` (
16 `user_id` int(11) NOT NULL AUTO_INCREMENT,
17 `user_name` varchar(128) NOT NULL,
18 `user_email` varchar(256) NOT NULL,
19 `user_imageurl` varchar(1024) NOT NULL,
20 PRIMARY KEY (`user_id`)
21 ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;