diff options
| -rw-r--r-- | setup/otakuhub_2011-07-10.sql | 36 |
1 files changed, 27 insertions, 9 deletions
diff --git a/setup/otakuhub_2011-07-10.sql b/setup/otakuhub_2011-07-10.sql index 3e2a23a..8f407f4 100644 --- a/setup/otakuhub_2011-07-10.sql +++ b/setup/otakuhub_2011-07-10.sql @@ -7,7 +7,7 @@ # # Host: localhost (MySQL 5.5.14) # Database: otakuhub -# Generation Time: 2011-07-10 00:34:13 -0400 +# Generation Time: 2011-07-10 16:37:45 -0400 # ************************************************************ @@ -30,6 +30,21 @@ CREATE TABLE `anime_list` ( +# Dump of table comments +# ------------------------------------------------------------ + +CREATE TABLE `comments` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `user_id` int(11) NOT NULL, + `post_id` int(11) NOT NULL, + `comment` text NOT NULL, + `updated` datetime NOT NULL, + `status` int(11) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; + + + # Dump of table confirm_keys # ------------------------------------------------------------ @@ -42,17 +57,19 @@ CREATE TABLE `confirm_keys` ( -# Dump of table feed +# Dump of table posts # ------------------------------------------------------------ -CREATE TABLE `feed` ( +CREATE TABLE `posts` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, - `userid` int(11) DEFAULT NULL, - `action_type` int(11) DEFAULT NULL, - `media_type` int(11) DEFAULT NULL, - `data` int(11) DEFAULT NULL, - PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=latin1; + `user_id` int(11) unsigned NOT NULL, + `body` text, + `timestamp` int(11) DEFAULT NULL, + `level` varchar(20) NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + KEY `user_id` (`user_id`), + CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; @@ -69,6 +86,7 @@ CREATE TABLE `users` ( `level` varchar(255) DEFAULT NULL, `joined` date DEFAULT NULL, `last_login` date DEFAULT NULL, + `confirmed` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; |