From fda3b17b032b67e0ccfbaa3aa6ec6e4ee5a17f70 Mon Sep 17 00:00:00 2001 From: Michael Francis Date: Sat, 16 Jul 2011 00:50:36 -0400 Subject: Implemented mySQL based friending --- setup/otakuhub_friends_2011-07-16.sql | 48 +++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) create mode 100644 setup/otakuhub_friends_2011-07-16.sql (limited to 'setup') diff --git a/setup/otakuhub_friends_2011-07-16.sql b/setup/otakuhub_friends_2011-07-16.sql new file mode 100644 index 0000000..9409825 --- /dev/null +++ b/setup/otakuhub_friends_2011-07-16.sql @@ -0,0 +1,48 @@ +# ************************************************************ +# 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-16 00:52:59 -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 friends +# ------------------------------------------------------------ + +CREATE TABLE `friends` ( + `id` int(11) unsigned NOT NULL AUTO_INCREMENT, + `FromUserId` int(11) unsigned NOT NULL, + `ToUserId` int(11) unsigned NOT NULL, + `StatusId` tinyint(4) DEFAULT NULL, + `SentTime` datetime DEFAULT NULL, + `ResponseTime` datetime DEFAULT NULL, + PRIMARY KEY (`id`), + KEY `FromUserId` (`FromUserId`), + KEY `ToUserId` (`ToUserId`), + CONSTRAINT `friends_ibfk_1` FOREIGN KEY (`FromUserId`) REFERENCES `users` (`id`), + CONSTRAINT `friends_ibfk_2` FOREIGN KEY (`ToUserId`) REFERENCES `users` (`id`) +) ENGINE=InnoDB AUTO_INCREMENT=4 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