· 10 years ago · Sep 10, 2016, 11:16 AM
1-- MySQL dump 10.13 Distrib 5.5.50, for debian-linux-gnu (x86_64)
2--
3-- Host: localhost Database: ctv_dev
4-- ------------------------------------------------------
5-- Server version 5.5.50-0ubuntu0.14.04.1
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 `addresses`
20--
21
22DROP TABLE IF EXISTS `addresses`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `addresses` (
26 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
27 `street` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
28 `place_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
29 `place_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
30 `created_at` datetime NOT NULL,
31 `updated_at` datetime NOT NULL,
32 UNIQUE KEY `index_addresses_on_id` (`id`),
33 KEY `index_addresses_on_place_type_and_place_id` (`place_type`,`place_id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Table structure for table `admins`
39--
40
41DROP TABLE IF EXISTS `admins`;
42/*!40101 SET @saved_cs_client = @@character_set_client */;
43/*!40101 SET character_set_client = utf8 */;
44CREATE TABLE `admins` (
45 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
46 `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
47 `password_digest` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
48 `created_at` datetime NOT NULL,
49 `updated_at` datetime NOT NULL,
50 UNIQUE KEY `index_admins_on_id` (`id`),
51 UNIQUE KEY `index_admins_on_username` (`username`)
52) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
53/*!40101 SET character_set_client = @saved_cs_client */;
54
55--
56-- Table structure for table `applicant_educations`
57--
58
59DROP TABLE IF EXISTS `applicant_educations`;
60/*!40101 SET @saved_cs_client = @@character_set_client */;
61/*!40101 SET character_set_client = utf8 */;
62CREATE TABLE `applicant_educations` (
63 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
64 `applicant_resume_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
65 `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
66 `school` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
67 `qualification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
68 `start_date` datetime DEFAULT NULL,
69 `end_date` datetime DEFAULT NULL,
70 `description` text COLLATE utf8_unicode_ci,
71 `created_at` datetime NOT NULL,
72 `updated_at` datetime NOT NULL,
73 UNIQUE KEY `index_applicant_educations_on_id` (`id`),
74 KEY `fk_rails_d2aa76bf9e` (`applicant_resume_id`),
75 CONSTRAINT `fk_rails_d2aa76bf9e` FOREIGN KEY (`applicant_resume_id`) REFERENCES `applicant_resumes` (`id`)
76) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Table structure for table `applicant_experiences`
81--
82
83DROP TABLE IF EXISTS `applicant_experiences`;
84/*!40101 SET @saved_cs_client = @@character_set_client */;
85/*!40101 SET character_set_client = utf8 */;
86CREATE TABLE `applicant_experiences` (
87 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
88 `applicant_resume_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
89 `position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
90 `com_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
91 `start_date` datetime DEFAULT NULL,
92 `end_date` datetime DEFAULT NULL,
93 `is_current_job` tinyint(1) DEFAULT NULL,
94 `description` text COLLATE utf8_unicode_ci,
95 `created_at` datetime NOT NULL,
96 `updated_at` datetime NOT NULL,
97 UNIQUE KEY `index_applicant_experiences_on_id` (`id`),
98 KEY `fk_rails_26bdf448fa` (`applicant_resume_id`),
99 CONSTRAINT `fk_rails_26bdf448fa` FOREIGN KEY (`applicant_resume_id`) REFERENCES `applicant_resumes` (`id`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
101/*!40101 SET character_set_client = @saved_cs_client */;
102
103--
104-- Table structure for table `applicant_languages`
105--
106
107DROP TABLE IF EXISTS `applicant_languages`;
108/*!40101 SET @saved_cs_client = @@character_set_client */;
109/*!40101 SET character_set_client = utf8 */;
110CREATE TABLE `applicant_languages` (
111 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
112 `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
113 `qualification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
114 `applicant_resume_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
115 `created_at` datetime NOT NULL,
116 `updated_at` datetime NOT NULL
117) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
118/*!40101 SET character_set_client = @saved_cs_client */;
119
120--
121-- Table structure for table `applicant_resumes`
122--
123
124DROP TABLE IF EXISTS `applicant_resumes`;
125/*!40101 SET @saved_cs_client = @@character_set_client */;
126/*!40101 SET character_set_client = utf8 */;
127CREATE TABLE `applicant_resumes` (
128 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
129 `user_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
130 `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
131 `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
132 `dob` datetime DEFAULT NULL,
133 `gender` int(11) DEFAULT NULL,
134 `marital` int(11) DEFAULT NULL,
135 `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
136 `qualification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
137 `year_of_experience` int(11) DEFAULT NULL,
138 `address_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
139 `expected_position` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
140 `expected_salary` float DEFAULT NULL,
141 `expected_work_location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
142 `description` text COLLATE utf8_unicode_ci,
143 `created_at` datetime NOT NULL,
144 `updated_at` datetime NOT NULL,
145 `photo_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
146 `photo_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
147 `photo_file_size` int(11) DEFAULT NULL,
148 `photo_updated_at` datetime DEFAULT NULL,
149 `cv_attachment_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
150 `cv_attachment_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
151 `cv_attachment_file_size` int(11) DEFAULT NULL,
152 `cv_attachment_updated_at` datetime DEFAULT NULL,
153 UNIQUE KEY `index_applicant_resumes_on_id` (`id`),
154 KEY `index_applicant_resumes_on_address_id` (`address_id`),
155 KEY `fk_rails_180e3972e7` (`user_id`),
156 CONSTRAINT `fk_rails_180e3972e7` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
157 CONSTRAINT `fk_rails_427efa639a` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`)
158) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
159/*!40101 SET character_set_client = @saved_cs_client */;
160
161--
162-- Table structure for table `applications`
163--
164
165DROP TABLE IF EXISTS `applications`;
166/*!40101 SET @saved_cs_client = @@character_set_client */;
167/*!40101 SET character_set_client = utf8 */;
168CREATE TABLE `applications` (
169 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
170 `user_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
171 `job_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
172 `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
173 `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
174 `dob` datetime DEFAULT NULL,
175 `gender` int(11) DEFAULT NULL,
176 `marital` int(11) DEFAULT NULL,
177 `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
178 `qualification` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
179 `year_of_experience` int(11) DEFAULT NULL,
180 `address_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
181 `description` text COLLATE utf8_unicode_ci,
182 `created_at` datetime NOT NULL,
183 `updated_at` datetime NOT NULL,
184 `cv_attachment_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
185 `cv_attachment_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
186 `cv_attachment_file_size` int(11) DEFAULT NULL,
187 `cv_attachment_updated_at` datetime DEFAULT NULL,
188 `photo_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
189 `photo_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
190 `photo_file_size` int(11) DEFAULT NULL,
191 `photo_updated_at` datetime DEFAULT NULL,
192 `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
193) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Table structure for table `average_caches`
198--
199
200DROP TABLE IF EXISTS `average_caches`;
201/*!40101 SET @saved_cs_client = @@character_set_client */;
202/*!40101 SET character_set_client = utf8 */;
203CREATE TABLE `average_caches` (
204 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
205 `rater_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
206 `rateable_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
207 `rateable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
208 `avg` float NOT NULL,
209 `created_at` datetime DEFAULT NULL,
210 `updated_at` datetime DEFAULT NULL
211) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
212/*!40101 SET character_set_client = @saved_cs_client */;
213
214--
215-- Table structure for table `banks`
216--
217
218DROP TABLE IF EXISTS `banks`;
219/*!40101 SET @saved_cs_client = @@character_set_client */;
220/*!40101 SET character_set_client = utf8 */;
221CREATE TABLE `banks` (
222 `id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
223 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
224 `acc_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
225 `acc_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
226 `acc_branch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
227 `is_main` tinyint(1) DEFAULT '0',
228 `created_at` datetime NOT NULL,
229 `updated_at` datetime NOT NULL
230) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
231/*!40101 SET character_set_client = @saved_cs_client */;
232
233--
234-- Table structure for table `charges`
235--
236
237DROP TABLE IF EXISTS `charges`;
238/*!40101 SET @saved_cs_client = @@character_set_client */;
239/*!40101 SET character_set_client = utf8 */;
240CREATE TABLE `charges` (
241 `id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
242 `user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
243 `price` float DEFAULT NULL,
244 `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'unconfirm',
245 `created_at` datetime NOT NULL,
246 `updated_at` datetime NOT NULL
247) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
248/*!40101 SET character_set_client = @saved_cs_client */;
249
250--
251-- Table structure for table `cities`
252--
253
254DROP TABLE IF EXISTS `cities`;
255/*!40101 SET @saved_cs_client = @@character_set_client */;
256/*!40101 SET character_set_client = utf8 */;
257CREATE TABLE `cities` (
258 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
259 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
260 `created_at` datetime NOT NULL,
261 `updated_at` datetime NOT NULL,
262 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
263 UNIQUE KEY `index_cities_on_id` (`id`),
264 UNIQUE KEY `index_cities_on_slug` (`slug`)
265) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
266/*!40101 SET character_set_client = @saved_cs_client */;
267
268--
269-- Table structure for table `commontator_comments`
270--
271
272DROP TABLE IF EXISTS `commontator_comments`;
273/*!40101 SET @saved_cs_client = @@character_set_client */;
274/*!40101 SET character_set_client = utf8 */;
275CREATE TABLE `commontator_comments` (
276 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
277 `creator_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
278 `creator_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
279 `editor_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
280 `editor_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
281 `thread_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
282 `body` text COLLATE utf8_unicode_ci NOT NULL,
283 `deleted_at` datetime DEFAULT NULL,
284 `cached_votes_up` int(11) DEFAULT '0',
285 `cached_votes_down` int(11) DEFAULT '0',
286 `created_at` datetime DEFAULT NULL,
287 `updated_at` datetime DEFAULT NULL,
288 KEY `index_commontator_comments_on_c_id_and_c_type_and_t_id` (`creator_id`,`creator_type`,`thread_id`),
289 KEY `index_commontator_comments_on_thread_id_and_created_at` (`thread_id`,`created_at`),
290 KEY `index_commontator_comments_on_cached_votes_up` (`cached_votes_up`),
291 KEY `index_commontator_comments_on_cached_votes_down` (`cached_votes_down`)
292) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
293/*!40101 SET character_set_client = @saved_cs_client */;
294
295--
296-- Table structure for table `commontator_subscriptions`
297--
298
299DROP TABLE IF EXISTS `commontator_subscriptions`;
300/*!40101 SET @saved_cs_client = @@character_set_client */;
301/*!40101 SET character_set_client = utf8 */;
302CREATE TABLE `commontator_subscriptions` (
303 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
304 `subscriber_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
305 `subscriber_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
306 `thread_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
307 `created_at` datetime DEFAULT NULL,
308 `updated_at` datetime DEFAULT NULL,
309 UNIQUE KEY `index_commontator_subscriptions_on_s_id_and_s_type_and_t_id` (`subscriber_id`,`subscriber_type`,`thread_id`),
310 KEY `index_commontator_subscriptions_on_thread_id` (`thread_id`)
311) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
312/*!40101 SET character_set_client = @saved_cs_client */;
313
314--
315-- Table structure for table `commontator_threads`
316--
317
318DROP TABLE IF EXISTS `commontator_threads`;
319/*!40101 SET @saved_cs_client = @@character_set_client */;
320/*!40101 SET character_set_client = utf8 */;
321CREATE TABLE `commontator_threads` (
322 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
323 `commontable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
324 `commontable_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
325 `closed_at` datetime DEFAULT NULL,
326 `closer_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
327 `closer_id` int(11) DEFAULT NULL,
328 `created_at` datetime DEFAULT NULL,
329 `updated_at` datetime DEFAULT NULL,
330 UNIQUE KEY `index_commontator_threads_on_c_id_and_c_type` (`commontable_id`,`commontable_type`)
331) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
332/*!40101 SET character_set_client = @saved_cs_client */;
333
334--
335-- Table structure for table `districts`
336--
337
338DROP TABLE IF EXISTS `districts`;
339/*!40101 SET @saved_cs_client = @@character_set_client */;
340/*!40101 SET character_set_client = utf8 */;
341CREATE TABLE `districts` (
342 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
343 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
344 `city_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
345 `created_at` datetime NOT NULL,
346 `updated_at` datetime NOT NULL,
347 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
348 UNIQUE KEY `index_districts_on_id` (`id`),
349 UNIQUE KEY `index_districts_on_slug` (`slug`),
350 KEY `index_districts_on_city_id` (`city_id`),
351 CONSTRAINT `fk_rails_92c48f7cf2` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
353/*!40101 SET character_set_client = @saved_cs_client */;
354
355--
356-- Table structure for table `employer_categories`
357--
358
359DROP TABLE IF EXISTS `employer_categories`;
360/*!40101 SET @saved_cs_client = @@character_set_client */;
361/*!40101 SET character_set_client = utf8 */;
362CREATE TABLE `employer_categories` (
363 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
364 `employer_profile_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
365 `job_category_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
366 `created_at` datetime NOT NULL,
367 `updated_at` datetime NOT NULL
368) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
369/*!40101 SET character_set_client = @saved_cs_client */;
370
371--
372-- Table structure for table `employer_images`
373--
374
375DROP TABLE IF EXISTS `employer_images`;
376/*!40101 SET @saved_cs_client = @@character_set_client */;
377/*!40101 SET character_set_client = utf8 */;
378CREATE TABLE `employer_images` (
379 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
380 `user_id` varchar(35) COLLATE utf8_unicode_ci NOT NULL,
381 `created_at` datetime NOT NULL,
382 `updated_at` datetime NOT NULL,
383 `photo_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
384 `photo_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
385 `photo_file_size` int(11) DEFAULT NULL,
386 `photo_updated_at` datetime DEFAULT NULL
387) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Table structure for table `employer_profiles`
392--
393
394DROP TABLE IF EXISTS `employer_profiles`;
395/*!40101 SET @saved_cs_client = @@character_set_client */;
396/*!40101 SET character_set_client = utf8 */;
397CREATE TABLE `employer_profiles` (
398 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
399 `user_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
400 `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
401 `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
402 `com_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
403 `com_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
404 `address_id` varchar(36) COLLATE utf8_unicode_ci DEFAULT NULL,
405 `com_num_of_staff` int(11) DEFAULT '0',
406 `com_introduction` text COLLATE utf8_unicode_ci,
407 `created_at` datetime NOT NULL,
408 `updated_at` datetime NOT NULL,
409 `logo_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
410 `logo_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
411 `logo_file_size` int(11) DEFAULT NULL,
412 `logo_updated_at` datetime DEFAULT NULL,
413 `contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
414 `contact_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
415 `contact_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
416 `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
417 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
418 UNIQUE KEY `index_employer_profiles_on_id` (`id`),
419 UNIQUE KEY `index_employer_profiles_on_slug` (`slug`),
420 KEY `fk_rails_cab8544d84` (`user_id`),
421 KEY `fk_rails_8e83b7a149` (`address_id`),
422 CONSTRAINT `fk_rails_8e83b7a149` FOREIGN KEY (`address_id`) REFERENCES `addresses` (`id`),
423 CONSTRAINT `fk_rails_cab8544d84` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
424) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
425/*!40101 SET character_set_client = @saved_cs_client */;
426
427--
428-- Table structure for table `friendly_id_slugs`
429--
430
431DROP TABLE IF EXISTS `friendly_id_slugs`;
432/*!40101 SET @saved_cs_client = @@character_set_client */;
433/*!40101 SET character_set_client = utf8 */;
434CREATE TABLE `friendly_id_slugs` (
435 `id` int(11) NOT NULL AUTO_INCREMENT,
436 `slug` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
437 `sluggable_id` int(11) NOT NULL,
438 `sluggable_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
439 `scope` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
440 `created_at` datetime DEFAULT NULL,
441 PRIMARY KEY (`id`),
442 UNIQUE KEY `index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope` (`slug`,`sluggable_type`,`scope`),
443 KEY `index_friendly_id_slugs_on_sluggable_id` (`sluggable_id`),
444 KEY `index_friendly_id_slugs_on_slug_and_sluggable_type` (`slug`,`sluggable_type`),
445 KEY `index_friendly_id_slugs_on_sluggable_type` (`sluggable_type`)
446) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
447/*!40101 SET character_set_client = @saved_cs_client */;
448
449--
450-- Table structure for table `impressions`
451--
452
453DROP TABLE IF EXISTS `impressions`;
454/*!40101 SET @saved_cs_client = @@character_set_client */;
455/*!40101 SET character_set_client = utf8 */;
456CREATE TABLE `impressions` (
457 `id` int(11) NOT NULL AUTO_INCREMENT,
458 `impressionable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
459 `impressionable_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
460 `user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
461 `controller_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
462 `action_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
463 `view_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
464 `request_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
465 `ip_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
466 `session_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
467 `message` text COLLATE utf8_unicode_ci,
468 `referrer` text COLLATE utf8_unicode_ci,
469 `created_at` datetime DEFAULT NULL,
470 `updated_at` datetime DEFAULT NULL,
471 PRIMARY KEY (`id`),
472 KEY `impressionable_type_message_index` (`impressionable_type`,`message`(255),`impressionable_id`),
473 KEY `poly_request_index` (`impressionable_type`,`impressionable_id`,`request_hash`),
474 KEY `poly_ip_index` (`impressionable_type`,`impressionable_id`,`ip_address`),
475 KEY `poly_session_index` (`impressionable_type`,`impressionable_id`,`session_hash`),
476 KEY `controlleraction_request_index` (`controller_name`,`action_name`,`request_hash`),
477 KEY `controlleraction_ip_index` (`controller_name`,`action_name`,`ip_address`),
478 KEY `controlleraction_session_index` (`controller_name`,`action_name`,`session_hash`),
479 KEY `index_impressions_on_user_id` (`user_id`)
480) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
481/*!40101 SET character_set_client = @saved_cs_client */;
482
483--
484-- Table structure for table `job_categories`
485--
486
487DROP TABLE IF EXISTS `job_categories`;
488/*!40101 SET @saved_cs_client = @@character_set_client */;
489/*!40101 SET character_set_client = utf8 */;
490CREATE TABLE `job_categories` (
491 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
492 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
493 `created_at` datetime NOT NULL,
494 `updated_at` datetime NOT NULL,
495 `jobs_count` int(11) DEFAULT '0',
496 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
497 UNIQUE KEY `index_job_categories_on_id` (`id`),
498 UNIQUE KEY `index_job_categories_on_slug` (`slug`)
499) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
500/*!40101 SET character_set_client = @saved_cs_client */;
501
502--
503-- Table structure for table `jobs`
504--
505
506DROP TABLE IF EXISTS `jobs`;
507/*!40101 SET @saved_cs_client = @@character_set_client */;
508/*!40101 SET character_set_client = utf8 */;
509CREATE TABLE `jobs` (
510 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
511 `status` int(11) NOT NULL DEFAULT '0',
512 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
513 `quantity` int(11) DEFAULT '0',
514 `city_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
515 `expired_at` datetime DEFAULT NULL,
516 `salary` float DEFAULT '0',
517 `salary_unit` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
518 `description` text COLLATE utf8_unicode_ci,
519 `created_at` datetime NOT NULL,
520 `updated_at` datetime NOT NULL,
521 `category_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
522 `user_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
523 `salary_min` float DEFAULT '0',
524 `requirements` text COLLATE utf8_unicode_ci,
525 `benefits` text COLLATE utf8_unicode_ci,
526 `is_negotiate` tinyint(1) DEFAULT '0',
527 `impressions_count` int(11) DEFAULT NULL,
528 `seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
529 `seo_keywords` text COLLATE utf8_unicode_ci,
530 `seo_description` text COLLATE utf8_unicode_ci,
531 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
532 UNIQUE KEY `index_jobs_on_id` (`id`),
533 UNIQUE KEY `index_jobs_on_slug` (`slug`),
534 KEY `index_jobs_on_city_id` (`city_id`),
535 KEY `index_jobs_on_category_id` (`category_id`),
536 KEY `index_jobs_on_user_id` (`user_id`),
537 CONSTRAINT `fk_rails_1cf0b3b406` FOREIGN KEY (`category_id`) REFERENCES `job_categories` (`id`),
538 CONSTRAINT `fk_rails_54d543406a` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
539 CONSTRAINT `fk_rails_df6238c8a6` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
540) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
541/*!40101 SET character_set_client = @saved_cs_client */;
542
543--
544-- Table structure for table `object_skills`
545--
546
547DROP TABLE IF EXISTS `object_skills`;
548/*!40101 SET @saved_cs_client = @@character_set_client */;
549/*!40101 SET character_set_client = utf8 */;
550CREATE TABLE `object_skills` (
551 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
552 `owner_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
553 `owner_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
554 `skill_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
555 `created_at` datetime NOT NULL,
556 `updated_at` datetime NOT NULL,
557 UNIQUE KEY `index_object_skills_on_id` (`id`),
558 UNIQUE KEY `index_object_skills_on_owner_type_and_owner_id_and_skill_id` (`owner_type`,`owner_id`,`skill_id`)
559) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
560/*!40101 SET character_set_client = @saved_cs_client */;
561
562--
563-- Table structure for table `overall_averages`
564--
565
566DROP TABLE IF EXISTS `overall_averages`;
567/*!40101 SET @saved_cs_client = @@character_set_client */;
568/*!40101 SET character_set_client = utf8 */;
569CREATE TABLE `overall_averages` (
570 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
571 `rateable_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
572 `rateable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
573 `overall_avg` float NOT NULL,
574 `created_at` datetime DEFAULT NULL,
575 `updated_at` datetime DEFAULT NULL
576) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
577/*!40101 SET character_set_client = @saved_cs_client */;
578
579--
580-- Table structure for table `page_infos`
581--
582
583DROP TABLE IF EXISTS `page_infos`;
584/*!40101 SET @saved_cs_client = @@character_set_client */;
585/*!40101 SET character_set_client = utf8 */;
586CREATE TABLE `page_infos` (
587 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
588 `seo_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
589 `seo_keywords` text COLLATE utf8_unicode_ci,
590 `seo_description` text COLLATE utf8_unicode_ci,
591 `created_at` datetime NOT NULL,
592 `updated_at` datetime NOT NULL,
593 `facebook_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
594 `google_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
595 `twitter_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
596 `linkedin_link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
597) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
598/*!40101 SET character_set_client = @saved_cs_client */;
599
600--
601-- Table structure for table `rates`
602--
603
604DROP TABLE IF EXISTS `rates`;
605/*!40101 SET @saved_cs_client = @@character_set_client */;
606/*!40101 SET character_set_client = utf8 */;
607CREATE TABLE `rates` (
608 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
609 `rater_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
610 `rateable_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
611 `rateable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
612 `stars` float NOT NULL,
613 `dimension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
614 `created_at` datetime DEFAULT NULL,
615 `updated_at` datetime DEFAULT NULL,
616 KEY `index_rates_on_rater_id` (`rater_id`),
617 KEY `index_rates_on_rateable_id_and_rateable_type` (`rateable_id`,`rateable_type`)
618) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
619/*!40101 SET character_set_client = @saved_cs_client */;
620
621--
622-- Table structure for table `rating_caches`
623--
624
625DROP TABLE IF EXISTS `rating_caches`;
626/*!40101 SET @saved_cs_client = @@character_set_client */;
627/*!40101 SET character_set_client = utf8 */;
628CREATE TABLE `rating_caches` (
629 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
630 `cacheable_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
631 `cacheable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
632 `avg` float NOT NULL,
633 `qty` int(11) NOT NULL,
634 `dimension` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
635 `created_at` datetime DEFAULT NULL,
636 `updated_at` datetime DEFAULT NULL,
637 KEY `index_rating_caches_on_cacheable_id_and_cacheable_type` (`cacheable_id`,`cacheable_type`)
638) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
639/*!40101 SET character_set_client = @saved_cs_client */;
640
641--
642-- Table structure for table `schema_migrations`
643--
644
645DROP TABLE IF EXISTS `schema_migrations`;
646/*!40101 SET @saved_cs_client = @@character_set_client */;
647/*!40101 SET character_set_client = utf8 */;
648CREATE TABLE `schema_migrations` (
649 `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
650 UNIQUE KEY `unique_schema_migrations` (`version`)
651) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
652/*!40101 SET character_set_client = @saved_cs_client */;
653
654--
655-- Table structure for table `skills`
656--
657
658DROP TABLE IF EXISTS `skills`;
659/*!40101 SET @saved_cs_client = @@character_set_client */;
660/*!40101 SET character_set_client = utf8 */;
661CREATE TABLE `skills` (
662 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
663 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
664 `created_at` datetime NOT NULL,
665 `updated_at` datetime NOT NULL,
666 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
667 UNIQUE KEY `index_skills_on_id` (`id`),
668 UNIQUE KEY `index_skills_on_slug` (`slug`)
669) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
670/*!40101 SET character_set_client = @saved_cs_client */;
671
672--
673-- Table structure for table `subscription_logs`
674--
675
676DROP TABLE IF EXISTS `subscription_logs`;
677/*!40101 SET @saved_cs_client = @@character_set_client */;
678/*!40101 SET character_set_client = utf8 */;
679CREATE TABLE `subscription_logs` (
680 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
681 `status` int(11) DEFAULT NULL,
682 `user_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
683 `job_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
684 `created_at` datetime NOT NULL,
685 `updated_at` datetime NOT NULL,
686 KEY `fk_rails_d28c7cb930` (`user_id`),
687 KEY `fk_rails_64200f434a` (`job_id`),
688 CONSTRAINT `fk_rails_64200f434a` FOREIGN KEY (`job_id`) REFERENCES `jobs` (`id`),
689 CONSTRAINT `fk_rails_d28c7cb930` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
690) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
691/*!40101 SET character_set_client = @saved_cs_client */;
692
693--
694-- Table structure for table `user_skill_subscriptions`
695--
696
697DROP TABLE IF EXISTS `user_skill_subscriptions`;
698/*!40101 SET @saved_cs_client = @@character_set_client */;
699/*!40101 SET character_set_client = utf8 */;
700CREATE TABLE `user_skill_subscriptions` (
701 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
702 `user_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
703 `skill_id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
704 `created_at` datetime NOT NULL,
705 `updated_at` datetime NOT NULL,
706 `city_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
707 `category_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
708 KEY `fk_rails_97e69da875` (`user_id`),
709 KEY `fk_rails_f05f625aa3` (`skill_id`),
710 KEY `index_user_skill_subscriptions_on_category_id` (`category_id`),
711 KEY `index_user_skill_subscriptions_on_city_id` (`city_id`),
712 CONSTRAINT `fk_rails_d41a302ba0` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`),
713 CONSTRAINT `fk_rails_529c24dee9` FOREIGN KEY (`category_id`) REFERENCES `job_categories` (`id`),
714 CONSTRAINT `fk_rails_97e69da875` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
715 CONSTRAINT `fk_rails_f05f625aa3` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`)
716) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
717/*!40101 SET character_set_client = @saved_cs_client */;
718
719--
720-- Table structure for table `users`
721--
722
723DROP TABLE IF EXISTS `users`;
724/*!40101 SET @saved_cs_client = @@character_set_client */;
725/*!40101 SET character_set_client = utf8 */;
726CREATE TABLE `users` (
727 `id` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
728 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
729 `encrypted_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
730 `reset_password_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
731 `reset_password_sent_at` datetime DEFAULT NULL,
732 `remember_created_at` datetime DEFAULT NULL,
733 `sign_in_count` int(11) NOT NULL DEFAULT '0',
734 `current_sign_in_at` datetime DEFAULT NULL,
735 `last_sign_in_at` datetime DEFAULT NULL,
736 `current_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
737 `last_sign_in_ip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
738 `created_at` datetime NOT NULL,
739 `updated_at` datetime NOT NULL,
740 `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT 'vi',
741 `avatar_file_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
742 `avatar_content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
743 `avatar_file_size` int(11) DEFAULT NULL,
744 `avatar_updated_at` datetime DEFAULT NULL,
745 `account_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
746 `balance` float DEFAULT '0',
747 `upgrade_type` int(11) DEFAULT '0',
748 `upgrade_expired_at` datetime DEFAULT NULL,
749 UNIQUE KEY `index_users_on_id` (`id`),
750 UNIQUE KEY `index_users_on_email` (`email`),
751 UNIQUE KEY `index_users_on_reset_password_token` (`reset_password_token`)
752) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
753/*!40101 SET character_set_client = @saved_cs_client */;
754/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
755
756/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
757/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
758/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
759/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
760/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
761/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
762/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
763
764-- Dump completed on 2016-09-10 18:15:34