· 8 years ago · Feb 26, 2018, 11:56 PM
1 ANTIRULES
2 <https://www.bellinity.com>
3 #LulzSe @UnitedSecAnon
4
5
6
7
8
9
10-- MySQL dump 10.13 Distrib 5.5.16, for Win32 (x86)
11--
12-- Host: localhost Database: bellinity
13-- ------------------------------------------------------
14-- Server version 5.5.24-log
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8 */;
20/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
21/*!40103 SET TIME_ZONE='+00:00' */;
22/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
23/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
24/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
25/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
26
27--
28-- Table structure for table `talent`
29--
30
31DROP TABLE IF EXISTS `talent`;
32/*!40101 SET @saved_cs_client = @@character_set_client */;
33/*!40101 SET character_set_client = utf8 */;
34CREATE TABLE `talent` (
35 `talent_id` int(11) NOT NULL AUTO_INCREMENT,
36 `lastname` varchar(100) NOT NULL,
37 `firstname` varchar(100) NOT NULL,
38 `job profile` varchar(100) NOT NULL,
39 `website` varchar(200) DEFAULT NULL,
40 `email_address` varchar(100) NOT NULL,
41 `description` text NOT NULL,
42 `profile_pic_url` varchar(200) NOT NULL,
43 `experience` text,
44 `skills` text,
45 `interests` text,
46 PRIMARY KEY (`talent_id`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48/*!40101 SET character_set_client = @saved_cs_client */;
49
50--
51-- Dumping data for table `talent`
52--
53
54LOCK TABLES `talent` WRITE;
55/*!40000 ALTER TABLE `talent` DISABLE KEYS */;
56/*!40000 ALTER TABLE `talent` ENABLE KEYS */;
57UNLOCK TABLES;
58
59--
60-- Table structure for table `user_saved_profiles`
61--
62
63DROP TABLE IF EXISTS `user_saved_profiles`;
64/*!40101 SET @saved_cs_client = @@character_set_client */;
65/*!40101 SET character_set_client = utf8 */;
66CREATE TABLE `user_saved_profiles` (
67 `id` int(11) NOT NULL AUTO_INCREMENT,
68 `user_id` int(11) NOT NULL,
69 `talent_id` int(11) NOT NULL,
70 `created_at` datetime NOT NULL,
71 PRIMARY KEY (`id`),
72 KEY `fk_talent_id_save_idx` (`talent_id`),
73 KEY `fk_user_id_save_idx` (`user_id`),
74 CONSTRAINT `fk_talent_id_save` FOREIGN KEY (`talent_id`) REFERENCES `talent` (`talent_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
75 CONSTRAINT `fk_user_id_save` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
76) ENGINE=InnoDB DEFAULT CHARSET=latin1;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Dumping data for table `user_saved_profiles`
81--
82
83LOCK TABLES `user_saved_profiles` WRITE;
84/*!40000 ALTER TABLE `user_saved_profiles` DISABLE KEYS */;
85/*!40000 ALTER TABLE `user_saved_profiles` ENABLE KEYS */;
86UNLOCK TABLES;
87
88--
89-- Table structure for table `criteria_values`
90--
91
92DROP TABLE IF EXISTS `criteria_values`;
93/*!40101 SET @saved_cs_client = @@character_set_client */;
94/*!40101 SET character_set_client = utf8 */;
95CREATE TABLE `criteria_values` (
96 `id` int(11) NOT NULL AUTO_INCREMENT,
97 `criteria_id` int(11) NOT NULL,
98 `criteria_value` varchar(100) NOT NULL,
99 PRIMARY KEY (`id`),
100 KEY `fk_criteria_id_idx` (`criteria_id`),
101 CONSTRAINT `fk_criteria_id` FOREIGN KEY (`criteria_id`) REFERENCES `criteria` (`criteria_id`) ON DELETE CASCADE ON UPDATE CASCADE
102) ENGINE=InnoDB DEFAULT CHARSET=latin1;
103/*!40101 SET character_set_client = @saved_cs_client */;
104
105--
106-- Dumping data for table `criteria_values`
107--
108
109LOCK TABLES `criteria_values` WRITE;
110/*!40000 ALTER TABLE `criteria_values` DISABLE KEYS */;
111/*!40000 ALTER TABLE `criteria_values` ENABLE KEYS */;
112UNLOCK TABLES;
113
114--
115-- Table structure for table `talent_attribute_relationship`
116--
117
118DROP TABLE IF EXISTS `talent_attribute_relationship`;
119/*!40101 SET @saved_cs_client = @@character_set_client */;
120/*!40101 SET character_set_client = utf8 */;
121CREATE TABLE `talent_attribute_relationship` (
122 `id` int(11) NOT NULL AUTO_INCREMENT,
123 `talent_id` int(11) NOT NULL,
124 `criteria_id` int(11) NOT NULL,
125 `criteria_value` varchar(100) NOT NULL,
126 PRIMARY KEY (`id`),
127 KEY `fk_criteria_id_idx` (`criteria_id`),
128 KEY `fk_talent_id_idx` (`talent_id`),
129 CONSTRAINT `fk_criteria_id_rel` FOREIGN KEY (`criteria_id`) REFERENCES `criteria` (`criteria_id`) ON DELETE CASCADE ON UPDATE CASCADE,
130 CONSTRAINT `fk_talent_id_rel` FOREIGN KEY (`talent_id`) REFERENCES `talent` (`talent_id`) ON DELETE CASCADE ON UPDATE CASCADE
131) ENGINE=InnoDB DEFAULT CHARSET=latin1;
132/*!40101 SET character_set_client = @saved_cs_client */;
133
134--
135-- Dumping data for table `talent_attribute_relationship`
136--
137
138LOCK TABLES `talent_attribute_relationship` WRITE;
139/*!40000 ALTER TABLE `talent_attribute_relationship` DISABLE KEYS */;
140/*!40000 ALTER TABLE `talent_attribute_relationship` ENABLE KEYS */;
141UNLOCK TABLES;
142
143--
144-- Table structure for table `user_settings_account_members`
145--
146
147DROP TABLE IF EXISTS `user_settings_account_members`;
148/*!40101 SET @saved_cs_client = @@character_set_client */;
149/*!40101 SET character_set_client = utf8 */;
150CREATE TABLE `user_settings_account_members` (
151 `id` int(11) NOT NULL AUTO_INCREMENT,
152 `user_id` int(11) NOT NULL,
153 `member_user_id` int(11) NOT NULL,
154 `member_is_admin` binary(1) NOT NULL,
155 `username` varchar(50) NOT NULL,
156 `password` varchar(50) NOT NULL,
157 `lastname` varchar(50) NOT NULL,
158 `firstname` varchar(50) NOT NULL,
159 `email_address` varchar(100) NOT NULL,
160 PRIMARY KEY (`id`),
161 KEY `fk_user_id_member_idx` (`user_id`),
162 KEY `fk_member_id_member_idx` (`member_user_id`),
163 CONSTRAINT `fk_member_id_member` FOREIGN KEY (`member_user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
164 CONSTRAINT `fk_user_id_member` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
165) ENGINE=InnoDB DEFAULT CHARSET=latin1;
166/*!40101 SET character_set_client = @saved_cs_client */;
167
168--
169-- Dumping data for table `user_settings_account_members`
170--
171
172LOCK TABLES `user_settings_account_members` WRITE;
173/*!40000 ALTER TABLE `user_settings_account_members` DISABLE KEYS */;
174/*!40000 ALTER TABLE `user_settings_account_members` ENABLE KEYS */;
175UNLOCK TABLES;
176
177--
178-- Table structure for table `talent_contact`
179--
180
181DROP TABLE IF EXISTS `talent_contact`;
182/*!40101 SET @saved_cs_client = @@character_set_client */;
183/*!40101 SET character_set_client = utf8 */;
184CREATE TABLE `talent_contact` (
185 `id` int(11) NOT NULL AUTO_INCREMENT,
186 `talent_id` int(11) DEFAULT NULL,
187 `name` varchar(100) NOT NULL,
188 `email_address` varchar(150) NOT NULL,
189 `phone_number` varchar(15) NOT NULL,
190 PRIMARY KEY (`id`),
191 KEY `fk_talent_contact_idx` (`talent_id`),
192 CONSTRAINT `fk_talent_contact` FOREIGN KEY (`talent_id`) REFERENCES `talent` (`talent_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Dumping data for table `talent_contact`
198--
199
200LOCK TABLES `talent_contact` WRITE;
201/*!40000 ALTER TABLE `talent_contact` DISABLE KEYS */;
202/*!40000 ALTER TABLE `talent_contact` ENABLE KEYS */;
203UNLOCK TABLES;
204
205--
206-- Table structure for table `talent_gallery`
207--
208
209DROP TABLE IF EXISTS `talent_gallery`;
210/*!40101 SET @saved_cs_client = @@character_set_client */;
211/*!40101 SET character_set_client = utf8 */;
212CREATE TABLE `talent_gallery` (
213 `id` int(11) NOT NULL AUTO_INCREMENT,
214 `talent_id` int(11) NOT NULL,
215 `group_id` int(11) NOT NULL,
216 `url` varchar(200) NOT NULL,
217 PRIMARY KEY (`id`),
218 KEY `fk_talent_id_idx` (`talent_id`),
219 KEY `fk_group_id_idx` (`group_id`),
220 CONSTRAINT `fk_group_id` FOREIGN KEY (`group_id`) REFERENCES `talent_gallery_group` (`group_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
221 CONSTRAINT `fk_talent_id` FOREIGN KEY (`talent_id`) REFERENCES `talent` (`talent_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
222) ENGINE=InnoDB DEFAULT CHARSET=latin1;
223/*!40101 SET character_set_client = @saved_cs_client */;
224
225--
226-- Dumping data for table `talent_gallery`
227--
228
229LOCK TABLES `talent_gallery` WRITE;
230/*!40000 ALTER TABLE `talent_gallery` DISABLE KEYS */;
231/*!40000 ALTER TABLE `talent_gallery` ENABLE KEYS */;
232UNLOCK TABLES;
233
234--
235-- Table structure for table `user_settings`
236--
237
238DROP TABLE IF EXISTS `user_settings`;
239/*!40101 SET @saved_cs_client = @@character_set_client */;
240/*!40101 SET character_set_client = utf8 */;
241CREATE TABLE `user_settings` (
242 `id` int(11) NOT NULL AUTO_INCREMENT,
243 `user_id` int(11) NOT NULL,
244 `settings_id` int(11) NOT NULL,
245 `flag` tinyint(1) NOT NULL,
246 PRIMARY KEY (`id`),
247 KEY `fk_user_id_settings_idx` (`user_id`),
248 CONSTRAINT `fk_user_id_settings` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
249) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
250/*!40101 SET character_set_client = @saved_cs_client */;
251
252--
253-- Dumping data for table `user_settings`
254--
255
256LOCK TABLES `user_settings` WRITE;
257/*!40000 ALTER TABLE `user_settings` DISABLE KEYS */;
258INSERT INTO `user_settings` VALUES (16,16,1,0),(17,16,2,0),(18,16,3,0),(19,16,4,0),(20,16,5,0),(21,16,6,0),(22,16,7,0),(23,16,8,0);
259/*!40000 ALTER TABLE `user_settings` ENABLE KEYS */;
260UNLOCK TABLES;
261
262--
263-- Table structure for table `criteria`
264--
265
266DROP TABLE IF EXISTS `criteria`;
267/*!40101 SET @saved_cs_client = @@character_set_client */;
268/*!40101 SET character_set_client = utf8 */;
269CREATE TABLE `criteria` (
270 `criteria_id` int(11) NOT NULL AUTO_INCREMENT,
271 `criteria_name` varchar(100) NOT NULL,
272 `group_name` varchar(100) DEFAULT NULL,
273 PRIMARY KEY (`criteria_id`)
274) ENGINE=InnoDB DEFAULT CHARSET=latin1;
275/*!40101 SET character_set_client = @saved_cs_client */;
276
277--
278-- Dumping data for table `criteria`
279--
280
281LOCK TABLES `criteria` WRITE;
282/*!40000 ALTER TABLE `criteria` DISABLE KEYS */;
283/*!40000 ALTER TABLE `criteria` ENABLE KEYS */;
284UNLOCK TABLES;
285
286--
287-- Table structure for table `user_info_payment`
288--
289
290DROP TABLE IF EXISTS `user_info_payment`;
291/*!40101 SET @saved_cs_client = @@character_set_client */;
292/*!40101 SET character_set_client = utf8 */;
293CREATE TABLE `user_info_payment` (
294 `id` int(11) NOT NULL AUTO_INCREMENT,
295 `user_id` int(11) NOT NULL,
296 `payment_token` text NOT NULL,
297 `billing_address` text NOT NULL,
298 `shipping_address` text NOT NULL,
299 PRIMARY KEY (`id`),
300 KEY `fk_user_id_payment_idx` (`user_id`),
301 CONSTRAINT `fk_user_id_payment` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
302) ENGINE=InnoDB DEFAULT CHARSET=latin1;
303/*!40101 SET character_set_client = @saved_cs_client */;
304
305--
306-- Dumping data for table `user_info_payment`
307--
308
309LOCK TABLES `user_info_payment` WRITE;
310/*!40000 ALTER TABLE `user_info_payment` DISABLE KEYS */;
311/*!40000 ALTER TABLE `user_info_payment` ENABLE KEYS */;
312UNLOCK TABLES;
313
314--
315-- Table structure for table `user_recent_activity`
316--
317
318DROP TABLE IF EXISTS `user_recent_activity`;
319/*!40101 SET @saved_cs_client = @@character_set_client */;
320/*!40101 SET character_set_client = utf8 */;
321CREATE TABLE `user_recent_activity` (
322 `id` int(11) NOT NULL,
323 `user_id` int(11) NOT NULL,
324 `activity_date` datetime NOT NULL,
325 `activity` text NOT NULL,
326 PRIMARY KEY (`id`),
327 KEY `fk_user_id_log_idx` (`user_id`),
328 CONSTRAINT `fk_user_id_log` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
329) ENGINE=InnoDB DEFAULT CHARSET=latin1;
330/*!40101 SET character_set_client = @saved_cs_client */;
331
332--
333-- Dumping data for table `user_recent_activity`
334--
335
336LOCK TABLES `user_recent_activity` WRITE;
337/*!40000 ALTER TABLE `user_recent_activity` DISABLE KEYS */;
338/*!40000 ALTER TABLE `user_recent_activity` ENABLE KEYS */;
339UNLOCK TABLES;
340
341--
342-- Table structure for table `user_saved_criteria`
343--
344
345DROP TABLE IF EXISTS `user_saved_criteria`;
346/*!40101 SET @saved_cs_client = @@character_set_client */;
347/*!40101 SET character_set_client = utf8 */;
348CREATE TABLE `user_saved_criteria` (
349 `id` int(11) NOT NULL AUTO_INCREMENT,
350 `user_id` int(11) NOT NULL,
351 `search_criteria` text NOT NULL,
352 `created_at` datetime NOT NULL,
353 `name` varchar(100) NOT NULL,
354 PRIMARY KEY (`id`),
355 KEY `fk_user_id_saved_criteria_idx` (`user_id`),
356 CONSTRAINT `fk_user_id_saved_criteria` FOREIGN KEY (`user_id`) REFERENCES `user` (`user_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
357) ENGINE=InnoDB DEFAULT CHARSET=latin1;
358/*!40101 SET character_set_client = @saved_cs_client */;
359
360--
361-- Dumping data for table `user_saved_criteria`
362--
363
364LOCK TABLES `user_saved_criteria` WRITE;
365/*!40000 ALTER TABLE `user_saved_criteria` DISABLE KEYS */;
366/*!40000 ALTER TABLE `user_saved_criteria` ENABLE KEYS */;
367UNLOCK TABLES;
368
369--
370-- Table structure for table `talent_gallery_group`
371--
372
373DROP TABLE IF EXISTS `talent_gallery_group`;
374/*!40101 SET @saved_cs_client = @@character_set_client */;
375/*!40101 SET character_set_client = utf8 */;
376CREATE TABLE `talent_gallery_group` (
377 `group_id` int(11) NOT NULL AUTO_INCREMENT,
378 `group_name` varchar(100) NOT NULL,
379 `talent_id` int(11) DEFAULT NULL,
380 PRIMARY KEY (`group_id`),
381 KEY `fk_talent_group_idx` (`talent_id`),
382 CONSTRAINT `fk_talent_group` FOREIGN KEY (`talent_id`) REFERENCES `talent` (`talent_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
383) ENGINE=InnoDB DEFAULT CHARSET=latin1;
384/*!40101 SET character_set_client = @saved_cs_client */;
385
386--
387-- Dumping data for table `talent_gallery_group`
388--
389
390LOCK TABLES `talent_gallery_group` WRITE;
391/*!40000 ALTER TABLE `talent_gallery_group` DISABLE KEYS */;
392/*!40000 ALTER TABLE `talent_gallery_group` ENABLE KEYS */;
393UNLOCK TABLES;
394
395--
396-- Table structure for table `user`
397--
398
399DROP TABLE IF EXISTS `user`;
400/*!40101 SET @saved_cs_client = @@character_set_client */;
401/*!40101 SET character_set_client = utf8 */;
402CREATE TABLE `user` (
403 `user_id` int(11) NOT NULL AUTO_INCREMENT,
404 `username` varchar(50) NOT NULL,
405 `password` varchar(50) NOT NULL,
406 `email_address` varchar(100) NOT NULL,
407 `account_type` varchar(45) NOT NULL DEFAULT 'free',
408 `active` tinyint(1) NOT NULL,
409 `firstname` varchar(50) NOT NULL,
410 `lastname` varchar(50) NOT NULL,
411 `company_name` varchar(100) NOT NULL,
412 `primary_business_focus` varchar(200) NOT NULL,
413 `business_size` varchar(45) DEFAULT NULL,
414 `phone_number` varchar(45) NOT NULL,
415 PRIMARY KEY (`user_id`),
416 UNIQUE KEY `username_UNIQUE` (`username`)
417) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
418/*!40101 SET character_set_client = @saved_cs_client */;
419
420--
421-- Dumping data for table `user`
422--
423
424LOCK TABLES `user` WRITE;
425/*!40000 ALTER TABLE `user` DISABLE KEYS */;
426INSERT INTO `user` VALUES (16,'varun','5ae296c995ea0e818c726b0ff38d6285','vrbrahme@gmail.com','Free',1,'Varun','Brahme','Arroyo Labs','Software solutions','Small Group','2136103259');
427/*!40000 ALTER TABLE `user` ENABLE KEYS */;
428UNLOCK TABLES;
429
430--
431-- Dumping events for database 'bellinity'
432--
433
434--
435-- Dumping routines for database 'bellinity'
436--
437/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
438
439/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
440/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
441/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
442/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
443/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
444/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
445/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;