Latest Database Schema

10/21/14

CREATE DATABASE IF NOT EXISTS `contested` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `contested`;
- MySQL dump 10.13 Distrib 5.6.19, for osx10.7 (i386)
-
- Host: 192.168.0.111 Database: contested
- -—————————————————————————-
— Server version 5.5.40-MariaDB-log

/!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 */; /*!40103 SET @OLD_TIME_ZONE=TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!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 */;

-
- Table structure for table `contest`
—

DROP TABLE IF EXISTS `contest`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `contest` (
`contest_id` int(11) NOT NULL AUTO_INCREMENT,
`user1` int(11) NOT NULL,
`user2` int(11) NOT NULL,
`name` varchar(140) DEFAULT NULL,
`user1_score` int(32) DEFAULT ‘0’,
`user2_score` int(32) DEFAULT ‘0’,
`image1` int(11) DEFAULT ‘-1’,
`image2` int(11) DEFAULT ‘-1’,
`thumb1` int(11) DEFAULT ‘-1’,
`thumb2` int(11) DEFAULT ‘-1’,
`permissions` int(11) DEFAULT ‘0’,
`starttime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`endtime` datetime DEFAULT NULL,
PRIMARY KEY (`contest_id`),
UNIQUE KEY `contest_id_UNIQUE` (`contest_id`)
) ENGINE=InnoDB AUTO_INCREMENT=529 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

-
- Table structure for table `contest_tags`
—

DROP TABLE IF EXISTS `contest_tags`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `contest_tags` (
`contest_id` int(11) NOT NULL,
`tag` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

-
- Table structure for table `friends`
—

DROP TABLE IF EXISTS `friends`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `friends` (
`userid` int(11) NOT NULL,
`friendid` int(11) NOT NULL,
PRIMARY KEY (`userid`,`friendid`),
UNIQUE KEY `unique_index` (`userid`,`friendid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

-
- Table structure for table `images`
—

DROP TABLE IF EXISTS `images`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `images` (
`image_id` int(11) NOT NULL AUTO_INCREMENT,
`owner_id` int(11) DEFAULT NULL,
`image` mediumtext,
PRIMARY KEY (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=533 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

-
- Table structure for table `users`
—

DROP TABLE IF EXISTS `users`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `users` (
`user_id` int(32) NOT NULL AUTO_INCREMENT,
`user_name` varchar(32) DEFAULT NULL,
`user_score` int(32) DEFAULT NULL,
`password` varchar(32) DEFAULT NULL,
`email_address` varchar(64) DEFAULT NULL,
PRIMARY KEY (`user_id`),
UNIQUE KEY `email_address_UNIQUE` (`email_address`),
UNIQUE KEY `user_name_UNIQUE` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = @saved_cs_client */;

-
- Table structure for table `voted`
—

DROP TABLE IF EXISTS `voted`;
/!40101 SET saved_cs_client = @character_set_client */;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE `voted` (
`userid` int(11) NOT NULL,
`contestid` int(11) NOT NULL,
PRIMARY KEY (`userid`,`contestid`),
UNIQUE KEY `unique_index` (`userid`,`contestid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/!40101 SET character_set_client = saved_cs_client */; /*!40103 SET TIME_ZONE=OLD_TIME_ZONE */;

/!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/!40014 SET FOREIGN_KEY_CHECKS=OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=OLD_UNIQUE_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 */; /*!40111 SET SQL_NOTES=OLD_SQL_NOTES */;

— Dump completed on 2014-10-21 15:49:34