· 8 years ago · May 08, 2018, 04:10 PM
1-- MySQL dump 10.11
2--
3-- Host: localhost Database: carstar_big_game
4-- ------------------------------------------------------
5-- Server version 5.0.51a-3ubuntu5.1-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `albums`
20--
21
22DROP TABLE IF EXISTS `albums`;
23SET @saved_cs_client = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `albums` (
26 `id` int(11) NOT NULL auto_increment,
27 `user_id` int(11) NOT NULL,
28 `position` int(11) NOT NULL default '1',
29 `title` varchar(128) NOT NULL,
30 `description` varchar(500) default NULL,
31 `photos_count` int(11) NOT NULL default '0',
32 `created_at` datetime default NULL,
33 `updated_at` datetime default NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
36SET character_set_client = @saved_cs_client;
37
38--
39-- Dumping data for table `albums`
40--
41
42LOCK TABLES `albums` WRITE;
43/*!40000 ALTER TABLE `albums` DISABLE KEYS */;
44INSERT 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');
45/*!40000 ALTER TABLE `albums` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `contestants`
50--
51
52DROP TABLE IF EXISTS `contestants`;
53SET @saved_cs_client = @@character_set_client;
54SET character_set_client = utf8;
55CREATE TABLE `contestants` (
56 `id` int(11) NOT NULL auto_increment,
57 `first_name` varchar(255) default NULL,
58 `last_name` varchar(255) default NULL,
59 `email` varchar(255) default NULL,
60 `phone_number` varchar(255) default NULL,
61 `photo_id` int(11) default NULL,
62 `created_at` datetime default NULL,
63 `updated_at` datetime default NULL,
64 PRIMARY KEY (`id`)
65) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
66SET character_set_client = @saved_cs_client;
67
68--
69-- Dumping data for table `contestants`
70--
71
72LOCK TABLES `contestants` WRITE;
73/*!40000 ALTER TABLE `contestants` DISABLE KEYS */;
74INSERT 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');
75/*!40000 ALTER TABLE `contestants` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Table structure for table `favourites`
80--
81
82DROP TABLE IF EXISTS `favourites`;
83SET @saved_cs_client = @@character_set_client;
84SET character_set_client = utf8;
85CREATE TABLE `favourites` (
86 `id` int(11) NOT NULL auto_increment,
87 `ip_address` varchar(255) default NULL,
88 `photo_id` int(11) default NULL,
89 `created_at` datetime default NULL,
90 `updated_at` datetime default NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
93SET character_set_client = @saved_cs_client;
94
95--
96-- Dumping data for table `favourites`
97--
98
99LOCK TABLES `favourites` WRITE;
100/*!40000 ALTER TABLE `favourites` DISABLE KEYS */;
101INSERT 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');
102/*!40000 ALTER TABLE `favourites` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `photos`
107--
108
109DROP TABLE IF EXISTS `photos`;
110SET @saved_cs_client = @@character_set_client;
111SET character_set_client = utf8;
112CREATE TABLE `photos` (
113 `id` int(11) NOT NULL auto_increment,
114 `album_id` int(11) NOT NULL,
115 `position` int(11) NOT NULL default '1',
116 `image_file_name` varchar(255) default NULL,
117 `image_content_type` varchar(255) default NULL,
118 `image_file_size` int(11) default NULL,
119 `image_updated_at` datetime default NULL,
120 `created_at` datetime default NULL,
121 `updated_at` datetime default NULL,
122 `source_id` int(11) default NULL,
123 `favourited_by` int(11) default NULL,
124 `contestant_id` int(11) default NULL,
125 PRIMARY KEY (`id`)
126) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
127SET character_set_client = @saved_cs_client;
128
129--
130-- Dumping data for table `photos`
131--
132
133LOCK TABLES `photos` WRITE;
134/*!40000 ALTER TABLE `photos` DISABLE KEYS */;
135INSERT 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);
136/*!40000 ALTER TABLE `photos` ENABLE KEYS */;
137UNLOCK TABLES;
138
139--
140-- Table structure for table `schema_migrations`
141--
142
143DROP TABLE IF EXISTS `schema_migrations`;
144SET @saved_cs_client = @@character_set_client;
145SET character_set_client = utf8;
146CREATE TABLE `schema_migrations` (
147 `version` varchar(255) NOT NULL,
148 UNIQUE KEY `unique_schema_migrations` (`version`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8;
150SET character_set_client = @saved_cs_client;
151
152--
153-- Dumping data for table `schema_migrations`
154--
155
156LOCK TABLES `schema_migrations` WRITE;
157/*!40000 ALTER TABLE `schema_migrations` DISABLE KEYS */;
158INSERT INTO `schema_migrations` VALUES ('1'),('2'),('20081124192945'),('20081124204359'),('20081125154636'),('20081125154726'),('20081125165401'),('20081125202915'),('20081125214832'),('20081126161412'),('3'),('4');
159/*!40000 ALTER TABLE `schema_migrations` ENABLE KEYS */;
160UNLOCK TABLES;
161
162--
163-- Table structure for table `slugs`
164--
165
166DROP TABLE IF EXISTS `slugs`;
167SET @saved_cs_client = @@character_set_client;
168SET character_set_client = utf8;
169CREATE TABLE `slugs` (
170 `id` int(11) NOT NULL auto_increment,
171 `name` varchar(255) NOT NULL,
172 `sluggable_type` varchar(128) NOT NULL,
173 `sluggable_id` int(11) NOT NULL,
174 `created_at` datetime default NULL,
175 `updated_at` datetime default NULL,
176 PRIMARY KEY (`id`),
177 KEY `index_slugs_on_name` (`name`),
178 KEY `index_slugs_on_sluggable_type` (`sluggable_type`),
179 KEY `index_slugs_on_sluggable_id` (`sluggable_id`)
180) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
181SET character_set_client = @saved_cs_client;
182
183--
184-- Dumping data for table `slugs`
185--
186
187LOCK TABLES `slugs` WRITE;
188/*!40000 ALTER TABLE `slugs` DISABLE KEYS */;
189INSERT 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');
190/*!40000 ALTER TABLE `slugs` ENABLE KEYS */;
191UNLOCK TABLES;
192
193--
194-- Table structure for table `unapproved_photos`
195--
196
197DROP TABLE IF EXISTS `unapproved_photos`;
198SET @saved_cs_client = @@character_set_client;
199SET character_set_client = utf8;
200CREATE TABLE `unapproved_photos` (
201 `id` int(11) NOT NULL auto_increment,
202 `image_file_name` varchar(255) default NULL,
203 `image_content_type` varchar(255) default NULL,
204 `image_file_size` int(11) default NULL,
205 `image_updated_at` datetime default NULL,
206 `created_at` datetime default NULL,
207 `updated_at` datetime default NULL,
208 `contestant_id` int(11) default NULL,
209 `approved` tinyint(1) default '0',
210 PRIMARY KEY (`id`)
211) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
212SET character_set_client = @saved_cs_client;
213
214--
215-- Dumping data for table `unapproved_photos`
216--
217
218LOCK TABLES `unapproved_photos` WRITE;
219/*!40000 ALTER TABLE `unapproved_photos` DISABLE KEYS */;
220INSERT 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);
221/*!40000 ALTER TABLE `unapproved_photos` ENABLE KEYS */;
222UNLOCK TABLES;
223
224--
225-- Table structure for table `users`
226--
227
228DROP TABLE IF EXISTS `users`;
229SET @saved_cs_client = @@character_set_client;
230SET character_set_client = utf8;
231CREATE TABLE `users` (
232 `id` int(11) NOT NULL auto_increment,
233 `login` varchar(40) NOT NULL,
234 `email` varchar(100) NOT NULL,
235 `remember_token` varchar(40) default NULL,
236 `crypted_password` varchar(40) default NULL,
237 `password_reset_code` varchar(40) default NULL,
238 `salt` varchar(40) default NULL,
239 `activation_code` varchar(40) default NULL,
240 `remember_token_expires_at` datetime default NULL,
241 `activated_at` datetime default NULL,
242 `deleted_at` datetime default NULL,
243 `state` varchar(10) NOT NULL default 'passive',
244 `albums_count` int(11) NOT NULL default '0',
245 `created_at` datetime default NULL,
246 `updated_at` datetime default NULL,
247 PRIMARY KEY (`id`)
248) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
249SET character_set_client = @saved_cs_client;
250
251--
252-- Dumping data for table `users`
253--
254
255LOCK TABLES `users` WRITE;
256/*!40000 ALTER TABLE `users` DISABLE KEYS */;
257INSERT 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');
258/*!40000 ALTER TABLE `users` ENABLE KEYS */;
259UNLOCK TABLES;
260/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
261
262/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
263/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
264/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
265/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
266/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
267/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
268/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
269
270-- Dump completed on 2008-11-27 19:52:38