Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- MySQL dump 10.11
- --
- -- Host: localhost Database: carstar_big_game
- -- ------------------------------------------------------
- -- Server version 5.0.51a-3ubuntu5.1-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 `albums`
- --
- DROP TABLE IF EXISTS `albums`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `albums` (
- `id` int(11) NOT NULL auto_increment,
- `user_id` int(11) NOT NULL,
- `position` int(11) NOT NULL default '1',
- `title` varchar(128) NOT NULL,
- `description` varchar(500) default NULL,
- `photos_count` int(11) NOT NULL default '0',
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `albums`
- --
- LOCK TABLES `albums` WRITE;
- /*!40000 ALTER TABLE `albums` DISABLE KEYS */;
- INSERT INTO `albums` VALUES (1,0,1,'11/24/08-11/30/08 Entries','Entries for the week of 11/24/08 to 11/30/08',8,'2008-11-26 20:44:04','2008-11-26 20:44:04');
- /*!40000 ALTER TABLE `albums` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `contestants`
- --
- DROP TABLE IF EXISTS `contestants`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `contestants` (
- `id` int(11) NOT NULL auto_increment,
- `first_name` varchar(255) default NULL,
- `last_name` varchar(255) default NULL,
- `email` varchar(255) default NULL,
- `phone_number` varchar(255) default NULL,
- `photo_id` int(11) default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `contestants`
- --
- LOCK TABLES `contestants` WRITE;
- /*!40000 ALTER TABLE `contestants` DISABLE KEYS */;
- INSERT INTO `contestants` VALUES (1,'John','Smith','matt.grande.ebay@gmail.com','905-234-3842',NULL,'2008-11-26 20:31:07','2008-11-26 20:31:07'),(2,'Justin','Hogeterp','justin@fluidmedia.com','905 523 5898',NULL,'2008-11-26 20:38:24','2008-11-26 20:38:24'),(3,'Justin','hogeterp','justin@brainmade.com','905 523 5898',NULL,'2008-11-26 20:45:02','2008-11-26 20:45:02'),(4,'justin','hogeterp','justin@gmail.com','905 523 5898',NULL,'2008-11-26 20:47:03','2008-11-26 20:47:03'),(5,'justin','hogeterp','justin@mac.com','905 523 5898',NULL,'2008-11-26 20:48:08','2008-11-26 20:48:08'),(6,'justin','hogeterp','justin@gov.com','905 523 5898',NULL,'2008-11-26 20:49:16','2008-11-26 20:49:16'),(7,'justin','hogeterp','justin@canada.com','905 523 5898',NULL,'2008-11-26 20:49:59','2008-11-26 20:49:59'),(8,'Matt','Grande','matt.grande@gmail.com','345-231-3456',NULL,'2008-11-26 20:55:48','2008-11-26 20:55:48'),(9,'Dr.','Horrible','john@smith.com','123-456-7895',NULL,'2008-11-26 21:51:51','2008-11-26 21:51:51');
- /*!40000 ALTER TABLE `contestants` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `favourites`
- --
- DROP TABLE IF EXISTS `favourites`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `favourites` (
- `id` int(11) NOT NULL auto_increment,
- `ip_address` varchar(255) default NULL,
- `photo_id` int(11) default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `favourites`
- --
- LOCK TABLES `favourites` WRITE;
- /*!40000 ALTER TABLE `favourites` DISABLE KEYS */;
- INSERT INTO `favourites` VALUES (16,'216.185.67.23',9,'2008-11-26 21:59:28','2008-11-26 21:59:28'),(17,'24.141.211.222',9,'2008-11-26 23:55:11','2008-11-26 23:55:11'),(20,'24.36.82.153',9,'2008-11-27 00:19:34','2008-11-27 00:19:34');
- /*!40000 ALTER TABLE `favourites` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `photos`
- --
- DROP TABLE IF EXISTS `photos`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `photos` (
- `id` int(11) NOT NULL auto_increment,
- `album_id` int(11) NOT NULL,
- `position` int(11) NOT NULL default '1',
- `image_file_name` varchar(255) default NULL,
- `image_content_type` varchar(255) default NULL,
- `image_file_size` int(11) default NULL,
- `image_updated_at` datetime default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- `source_id` int(11) default NULL,
- `favourited_by` int(11) default NULL,
- `contestant_id` int(11) default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `photos`
- --
- LOCK TABLES `photos` WRITE;
- /*!40000 ALTER TABLE `photos` DISABLE KEYS */;
- INSERT INTO `photos` VALUES (2,1,1,'rugby_dealz.JPG','image/jpeg',45835,'2008-11-26 20:31:06','2008-11-26 20:44:07','2008-11-26 20:44:07',1,0,1),(3,1,2,'Apr_04_2008_-_VID00010_1.jpg','image/jpeg',76170,'2008-11-26 20:45:01','2008-11-26 20:45:27','2008-11-26 20:45:27',3,NULL,3),(4,1,3,'DONE_orlando.jpg','image/jpeg',395787,'2008-11-26 20:48:07','2008-11-26 20:48:20','2008-11-26 20:48:20',5,0,5),(5,1,4,'c.jpeg','image/jpeg',35519,'2008-11-26 20:47:03','2008-11-26 20:48:21','2008-11-26 20:48:21',4,0,4),(7,1,5,'18lehman.600.jpg','image/jpeg',48151,'2008-11-26 20:49:15','2008-11-26 20:50:14','2008-11-26 20:50:14',6,0,6),(8,1,6,'awesome.jpg','image/jpeg',575620,'2008-11-26 20:55:47','2008-11-26 20:56:05','2008-11-26 20:56:05',8,0,8),(9,1,7,'drhorrible.jpg','image/jpeg',327292,'2008-11-26 21:51:50','2008-11-26 21:52:01','2008-11-26 21:52:01',9,3,9),(10,1,8,'3009095236_84989ffc18.jpg','image/jpeg',115630,'2008-11-26 20:49:58','2008-11-27 00:25:55','2008-11-27 00:25:55',7,NULL,7);
- /*!40000 ALTER TABLE `photos` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `schema_migrations`
- --
- DROP TABLE IF EXISTS `schema_migrations`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `schema_migrations` (
- `version` varchar(255) NOT NULL,
- UNIQUE KEY `unique_schema_migrations` (`version`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `schema_migrations`
- --
- LOCK TABLES `schema_migrations` WRITE;
- /*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
- INSERT INTO `schema_migrations` VALUES ('1'),('2'),('20081124192945'),('20081124204359'),('20081125154636'),('20081125154726'),('20081125165401'),('20081125202915'),('20081125214832'),('20081126161412'),('3'),('4');
- /*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `slugs`
- --
- DROP TABLE IF EXISTS `slugs`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `slugs` (
- `id` int(11) NOT NULL auto_increment,
- `name` varchar(255) NOT NULL,
- `sluggable_type` varchar(128) NOT NULL,
- `sluggable_id` int(11) NOT NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`),
- KEY `index_slugs_on_name` (`name`),
- KEY `index_slugs_on_sluggable_type` (`sluggable_type`),
- KEY `index_slugs_on_sluggable_id` (`sluggable_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `slugs`
- --
- LOCK TABLES `slugs` WRITE;
- /*!40000 ALTER TABLE `slugs` DISABLE KEYS */;
- INSERT INTO `slugs` VALUES (1,'demo','User',1,'2008-11-26 19:52:26','2008-11-26 19:52:26'),(2,'11-24-08-11-30-08-entries','Album',1,'2008-11-26 20:44:04','2008-11-26 20:44:04');
- /*!40000 ALTER TABLE `slugs` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `unapproved_photos`
- --
- DROP TABLE IF EXISTS `unapproved_photos`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `unapproved_photos` (
- `id` int(11) NOT NULL auto_increment,
- `image_file_name` varchar(255) default NULL,
- `image_content_type` varchar(255) default NULL,
- `image_file_size` int(11) default NULL,
- `image_updated_at` datetime default NULL,
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- `contestant_id` int(11) default NULL,
- `approved` tinyint(1) default '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `unapproved_photos`
- --
- LOCK TABLES `unapproved_photos` WRITE;
- /*!40000 ALTER TABLE `unapproved_photos` DISABLE KEYS */;
- INSERT INTO `unapproved_photos` VALUES (1,'rugby_dealz.JPG','image/jpeg',45835,'2008-11-26 20:31:06','2008-11-26 20:31:07','2008-11-26 20:44:07',1,1),(2,'macro_photo_4_t.jpg','image/jpeg',2799,'2008-11-26 20:38:23','2008-11-26 20:38:24','2008-11-27 00:20:25',2,0),(3,'Apr_04_2008_-_VID00010_1.jpg','image/jpeg',76170,'2008-11-26 20:45:01','2008-11-26 20:45:02','2008-11-26 20:45:27',3,1),(4,'c.jpeg','image/jpeg',35519,'2008-11-26 20:47:03','2008-11-26 20:47:03','2008-11-26 20:48:21',4,1),(5,'DONE_orlando.jpg','image/jpeg',395787,'2008-11-26 20:48:07','2008-11-26 20:48:08','2008-11-26 20:48:20',5,1),(6,'18lehman.600.jpg','image/jpeg',48151,'2008-11-26 20:49:15','2008-11-26 20:49:16','2008-11-26 20:50:14',6,1),(7,'3009095236_84989ffc18.jpg','image/jpeg',115630,'2008-11-26 20:49:58','2008-11-26 20:49:59','2008-11-27 00:25:55',7,1),(8,'awesome.jpg','image/jpeg',575620,'2008-11-26 20:55:47','2008-11-26 20:55:48','2008-11-26 20:56:05',8,1),(9,'drhorrible.jpg','image/jpeg',327292,'2008-11-26 21:51:50','2008-11-26 21:51:51','2008-11-26 21:52:01',9,1);
- /*!40000 ALTER TABLE `unapproved_photos` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `users`
- --
- DROP TABLE IF EXISTS `users`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `users` (
- `id` int(11) NOT NULL auto_increment,
- `login` varchar(40) NOT NULL,
- `email` varchar(100) NOT NULL,
- `remember_token` varchar(40) default NULL,
- `crypted_password` varchar(40) default NULL,
- `password_reset_code` varchar(40) default NULL,
- `salt` varchar(40) default NULL,
- `activation_code` varchar(40) default NULL,
- `remember_token_expires_at` datetime default NULL,
- `activated_at` datetime default NULL,
- `deleted_at` datetime default NULL,
- `state` varchar(10) NOT NULL default 'passive',
- `albums_count` int(11) NOT NULL default '0',
- `created_at` datetime default NULL,
- `updated_at` datetime default NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `users`
- --
- LOCK TABLES `users` WRITE;
- /*!40000 ALTER TABLE `users` DISABLE KEYS */;
- INSERT INTO `users` VALUES (1,'demo','matt@fluidmedia.com','ff53a940c643b0f4af96a1bf45dee7096bd64b8e','0b9185187e3c7d6f8045d86cbadbbc2a4f07d9de',NULL,'558484d17a9e9a4cff8038d1c97418209569f833',NULL,'2008-12-11 00:20:11','2008-08-12 19:58:44',NULL,'active',0,'2008-11-26 19:52:26','2008-11-27 00:20:11');
- /*!40000 ALTER TABLE `users` ENABLE KEYS */;
- UNLOCK TABLES;
- /*!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 2008-11-27 19:52:38
Add Comment
Please, Sign In to add comment