From cfba0ecd08b5af5a56cfdfe3e5225ae98f5107da Mon Sep 17 00:00:00 2001 From: Michael Francis Date: Sun, 10 Jul 2011 00:36:02 -0400 Subject: initial schema for MySQL --- setup/otakuhub_2011-07-10.sql | 83 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 83 insertions(+) create mode 100644 setup/otakuhub_2011-07-10.sql (limited to 'setup') diff --git a/setup/otakuhub_2011-07-10.sql b/setup/otakuhub_2011-07-10.sql new file mode 100644 index 0000000..3e2a23a --- /dev/null +++ b/setup/otakuhub_2011-07-10.sql @@ -0,0 +1,83 @@ +# ************************************************************ +# Sequel Pro SQL dump +# Version 3348 +# +# http://www.sequelpro.com/ +# http://code.google.com/p/sequel-pro/ +# +# Host: localhost (MySQL 5.5.14) +# Database: otakuhub +# Generation Time: 2011-07-10 00:34:13 -0400 +# ************************************************************ + + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + + +# Dump of table anime_list +# ------------------------------------------------------------ + +CREATE TABLE `anime_list` ( + `id` int(11) unsigned NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + + + +# Dump of table confirm_keys +# ------------------------------------------------------------ + +CREATE TABLE `confirm_keys` ( + `id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `key` varchar(12) NOT NULL DEFAULT '', + `username` varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; + + + +# Dump of table feed +# ------------------------------------------------------------ + +CREATE TABLE `feed` ( + `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; + + + +# Dump of table users +# ------------------------------------------------------------ + +CREATE TABLE `users` ( + `id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `username` varchar(255) NOT NULL DEFAULT '', + `password` varchar(255) NOT NULL DEFAULT '', + `pepper` varchar(255) DEFAULT NULL, + `active` tinyint(1) NOT NULL, + `email` varchar(255) DEFAULT NULL, + `level` varchar(255) DEFAULT NULL, + `joined` date DEFAULT NULL, + `last_login` date DEFAULT NULL, + PRIMARY KEY (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; + + + + +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; -- cgit v1.2.3