· 6 years ago · Jun 13, 2019, 02:20 AM
1$$\ $$\ $$$$$$\
2$$$\ $$ | $$ __$$\
3$$$$\ $$ | $$$$$$\ $$\ $$\ $$\ $$ / \__| $$$$$$\ $$$$$$$\
4$$ $$\$$ |$$ __$$\ $$ | $$ | $$ |\$$$$$$\ $$ __$$\ $$ _____|
5$$ \$$$$ |$$$$$$$$ |$$ | $$ | $$ | \____$$\ $$$$$$$$ |$$ /
6$$ |\$$$ |$$ ____|$$ | $$ | $$ |$$\ $$ |$$ ____|$$ |
7$$ | \$$ |\$$$$$$$\ \$$$$$\$$$$ |\$$$$$$ |\$$$$$$$\ \$$$$$$$\
8\__| \__| \_______| \_____\____/ \______/ \_______| \_______|
9
10
11
12$$$$$$$\ $$$$$$\ $$\
13$$ __$$\ $$ __$$\ $$ |
14$$ | $$ | $$$$$$\ $$$$$$\$$$$\ $$$$$$\ $$$$$$$\ $$ / \__| $$$$$$\ $$$$$$$ |
15$$ | $$ |$$ __$$\ $$ _$$ _$$\ $$ __$$\ $$ __$$\ \$$$$$$\ \____$$\ $$ __$$ |
16$$ | $$ |$$$$$$$$ |$$ / $$ / $$ |$$ / $$ |$$ | $$ | \____$$\ $$$$$$$ |$$ / $$ |
17$$ | $$ |$$ ____|$$ | $$ | $$ |$$ | $$ |$$ | $$ |$$\ $$ |$$ __$$ |$$ | $$ |
18$$$$$$$ |\$$$$$$$\ $$ | $$ | $$ |\$$$$$$ |$$ | $$ |\$$$$$$ |\$$$$$$$ |\$$$$$$$ |
19\_______/ \_______|\__| \__| \__| \______/ \__| \__| \______/ \_______| \_______|
20
21
22
23
24----------------------------------------------------------------------------------------------------------------------------
25
26Target : https://www.ssu.edu ( Universidade dos Estados dos USA )
27
28Database, Tables, Columns Dumpeds
29
30By : DemonSad | NewSec Group | We Are : DemonSad, Kami, NedLock, Silv3r
31
32"We are NewSec"
33
34-------------------------------------------------------------------------------------------------------------------------
35
36Server version 5.6.28-0ubuntu0.15.04.1
37Database: ssu_db
38
39/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
40/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
41/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
42/*!40101 SET NAMES utf8 */;
43/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
44/*!40103 SET TIME_ZONE='+00:00' */;
45/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
46/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
47/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
48/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
49
50--
51-- Table structure for table `admins`
52--
53
54DROP TABLE IF EXISTS `admins`;
55/*!40101 SET @saved_cs_client = @@character_set_client */;
56/*!40101 SET character_set_client = utf8 */;
57CREATE TABLE `admins` (
58 `sid` int(11) NOT NULL AUTO_INCREMENT,
59 `name` varchar(255) DEFAULT NULL,
60 `email` varchar(255) DEFAULT NULL,
61 `password` varchar(255) DEFAULT NULL,
62 `owner` int(11) DEFAULT '0',
63 `permissions_type` varchar(255) DEFAULT NULL,
64 `permissions` varchar(255) DEFAULT NULL,
65 `status` varchar(255) DEFAULT 'Pending',
66 `recover_key` varchar(255) DEFAULT NULL,
67 PRIMARY KEY (`sid`),
68 UNIQUE KEY `email_unique` (`email`) USING BTREE,
69 KEY `status` (`status`),
70 KEY `email` (`email`)
71) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
72/*!40101 SET character_set_client = @saved_cs_client */;
73
74--
75-- Dumping data for table `admins`
76--
77
78LOCK TABLES `admins` WRITE;
79/*!40000 ALTER TABLE `admins` DISABLE KEYS */;
80INSERT INTO `admins` VALUES (1,'admin','admin','21232f297a57a5a743894a0e4a801fc3',1,NULL,NULL,'Active',NULL);
81/*!40000 ALTER TABLE `admins` ENABLE KEYS */;
82UNLOCK TABLES;
83
84--
85-- Table structure for table `applications`
86--
87
88DROP TABLE IF EXISTS `applications`;
89/*!40101 SET @saved_cs_client = @@character_set_client */;
90/*!40101 SET character_set_client = utf8 */;
91CREATE TABLE `applications` (
92 `id` int(11) NOT NULL AUTO_INCREMENT,
93 `listing_id` int(11) NOT NULL,
94 `jobseeker_id` int(11) NOT NULL,
95 `comments` text NOT NULL,
96 `date` datetime NOT NULL,
97 `resume` varchar(255) NOT NULL,
98 `file` text,
99 `mime_type` varchar(255) NOT NULL,
100 `file_id` text NOT NULL,
101 `username` varchar(255) DEFAULT NULL,
102 `email` varchar(100) DEFAULT NULL,
103 `hidden` tinyint(4) NOT NULL DEFAULT '0',
104 PRIMARY KEY (`id`),
105 KEY `listing_id` (`listing_id`,`jobseeker_id`),
106 KEY `jobseeker_id` (`jobseeker_id`),
107 KEY `date` (`date`),
108 KEY `username` (`username`),
109 KEY `hidden` (`hidden`)
110) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `applications`
115--
116
117LOCK TABLES `applications` WRITE;
118/*!40000 ALTER TABLE `applications` DISABLE KEYS */;
119INSERT INTO `applications` VALUES (1,14,1,'Please consider my candidature for this job.','2012-11-07 15:35:28','15','test_resume_4_2_3.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document','application_0e277fdc866ebfdc849b68125c9defe9',NULL,NULL,0),(2,13,1,'Interested in this job.','2012-11-07 15:36:01','15','','','',NULL,NULL,0);
120/*!40000 ALTER TABLE `applications` ENABLE KEYS */;
121UNLOCK TABLES;
122
123--
124-- Table structure for table `blog`
125--
126
127DROP TABLE IF EXISTS `blog`;
128/*!40101 SET @saved_cs_client = @@character_set_client */;
129/*!40101 SET character_set_client = utf8 */;
130CREATE TABLE `blog` (
131 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
132 `date` date DEFAULT NULL,
133 `title` varchar(255) DEFAULT NULL,
134 `text` longtext,
135 `active` tinyint(1) NOT NULL DEFAULT '0',
136 `keywords` varchar(255) DEFAULT NULL,
137 `description` varchar(255) DEFAULT NULL,
138 `image` varchar(255) DEFAULT NULL,
139 PRIMARY KEY (`sid`),
140 KEY `date` (`date`),
141 KEY `active` (`active`)
142) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
143/*!40101 SET character_set_client = @saved_cs_client */;
144
145--
146-- Dumping data for table `blog`
147--
148
149LOCK TABLES `blog` WRITE;
150/*!40000 ALTER TABLE `blog` DISABLE KEYS */;
151INSERT INTO `blog` VALUES (1,'2016-04-07','Hello World!','Test blog post',0,'','','');
152/*!40000 ALTER TABLE `blog` ENABLE KEYS */;
153UNLOCK TABLES;
154
155--
156-- Table structure for table `browse`
157--
158
159DROP TABLE IF EXISTS `browse`;
160/*!40101 SET @saved_cs_client = @@character_set_client */;
161/*!40101 SET character_set_client = utf8 */;
162CREATE TABLE `browse` (
163 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
164 `page_uri` varchar(255) NOT NULL,
165 `parameters` text,
166 `data` mediumtext,
167 PRIMARY KEY (`sid`),
168 UNIQUE KEY `sid` (`sid`)
169) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `browse`
174--
175
176LOCK TABLES `browse` WRITE;
177/*!40000 ALTER TABLE `browse` DISABLE KEYS */;
178INSERT INTO `browse` VALUES (7,'/categories/','a:2:{s:11:\"level1Field\";s:11:\"JobCategory\";s:15:\"listing_type_id\";s:3:\"Job\";}','a:9:{i:373;i:2;i:343;i:5;i:344;i:5;i:350;s:1:\"1\";i:360;s:1:\"1\";i:370;s:1:\"1\";i:359;s:1:\"1\";i:367;s:1:\"1\";i:346;s:1:\"1\";}'),(8,'/cities/','a:3:{s:11:\"level1Field\";s:4:\"City\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','a:5:{s:9:\"Cambridge\";i:3;s:10:\"Sacramento\";i:2;s:7:\"Durango\";i:2;s:13:\"San Francisco\";s:1:\"1\";s:7:\"Atlanta\";s:1:\"1\";}'),(9,'/category/','a:2:{s:11:\"level1Field\";s:11:\"JobCategory\";s:15:\"listing_type_id\";s:3:\"Job\";}','a:9:{i:373;i:2;i:343;i:5;i:344;i:5;i:350;s:1:\"1\";i:360;s:1:\"1\";i:370;s:1:\"1\";i:359;s:1:\"1\";i:367;s:1:\"1\";i:346;s:1:\"1\";}'),(10,'/states/','a:3:{s:11:\"level1Field\";s:5:\"State\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','a:4:{s:13:\"Massachusetts\";i:3;s:10:\"California\";i:3;s:8:\"Colorado\";i:2;s:7:\"Georgia\";s:1:\"1\";}'),(12,'/countries/','a:3:{s:11:\"level1Field\";s:7:\"Country\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','a:1:{s:13:\"United States\";i:9;}');
179/*!40000 ALTER TABLE `browse` ENABLE KEYS */;
180UNLOCK TABLES;
181
182--
183-- Table structure for table `contract_packages`
184--
185
186DROP TABLE IF EXISTS `contract_packages`;
187/*!40101 SET @saved_cs_client = @@character_set_client */;
188/*!40101 SET character_set_client = utf8 */;
189CREATE TABLE `contract_packages` (
190 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
191 `class_name` varchar(255) DEFAULT NULL,
192 `contract_id` int(10) unsigned DEFAULT NULL,
193 `fields` text,
194 PRIMARY KEY (`id`),
195 KEY `class_name` (`class_name`),
196 KEY `contract_id` (`contract_id`)
197) ENGINE=MyISAM DEFAULT CHARSET=utf8;
198/*!40101 SET character_set_client = @saved_cs_client */;
199
200--
201-- Dumping data for table `contract_packages`
202--
203
204LOCK TABLES `contract_packages` WRITE;
205/*!40000 ALTER TABLE `contract_packages` DISABLE KEYS */;
206/*!40000 ALTER TABLE `contract_packages` ENABLE KEYS */;
207UNLOCK TABLES;
208
209--
210-- Table structure for table `contracts`
211--
212
213DROP TABLE IF EXISTS `contracts`;
214/*!40101 SET @saved_cs_client = @@character_set_client */;
215/*!40101 SET character_set_client = utf8 */;
216CREATE TABLE `contracts` (
217 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
218 `user_sid` int(10) NOT NULL,
219 `product_sid` int(11) NOT NULL DEFAULT '0',
220 `creation_date` date DEFAULT NULL,
221 `expired_date` date DEFAULT NULL,
222 `price` float unsigned DEFAULT NULL,
223 `serialized_extra_info` text,
224 `gateway_id` varchar(255) DEFAULT NULL,
225 `invoice_id` varchar(255) DEFAULT NULL,
226 `number_of_postings` int(11) NOT NULL DEFAULT '0',
227 `status` varchar(255) NOT NULL DEFAULT 'active',
228 PRIMARY KEY (`id`),
229 KEY `user_sid` (`user_sid`),
230 KEY `expired_date` (`expired_date`),
231 KEY `creation_date` (`creation_date`),
232 KEY `gateway_id` (`gateway_id`),
233 KEY `product_sid` (`product_sid`)
234) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
235/*!40101 SET character_set_client = @saved_cs_client */;
236
237--
238-- Dumping data for table `contracts`
239--
240
241LOCK TABLES `contracts` WRITE;
242/*!40000 ALTER TABLE `contracts` DISABLE KEYS */;
243/*!40000 ALTER TABLE `contracts` ENABLE KEYS */;
244UNLOCK TABLES;
245
246--
247-- Table structure for table `email_templates`
248--
249
250DROP TABLE IF EXISTS `email_templates`;
251/*!40101 SET @saved_cs_client = @@character_set_client */;
252/*!40101 SET character_set_client = utf8 */;
253CREATE TABLE `email_templates` (
254 `sid` int(11) unsigned NOT NULL AUTO_INCREMENT,
255 `name` varchar(255) DEFAULT NULL,
256 `group` varchar(255) DEFAULT NULL,
257 `cc` varchar(100) DEFAULT NULL,
258 `subject` varchar(254) DEFAULT NULL,
259 `text` text,
260 `hidden` tinyint(1) DEFAULT '1',
261 `active` tinyint(1) NOT NULL DEFAULT '1',
262 PRIMARY KEY (`sid`),
263 UNIQUE KEY `name` (`name`),
264 KEY `group` (`group`)
265) ENGINE=MyISAM AUTO_INCREMENT=304 DEFAULT CHARSET=utf8;
266/*!40101 SET character_set_client = @saved_cs_client */;
267
268--
269-- Dumping data for table `email_templates`
270--
271
272LOCK TABLES `email_templates` WRITE;
273/*!40000 ALTER TABLE `email_templates` DISABLE KEYS */;
274INSERT INTO `email_templates` VALUES (13,'Resume Posting Confirmation','listing','','Your resume has been posted','Hello {$listing.user.FullName|escape},<br /><br />Your resume was successfully posted at <a href=\"{$siteUrl}\">{$siteUrl}</a>.<br /><br />You can edit your resume in <a href=\"{$siteUrl}/my-listings/resume/\">"My Account"</a> section.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(14,'Job Posting Confirmation','listing','','Your job has been posted','Hello {$user.FullName|escape},<br /><br />Your job <a href=\"{$siteUrl}{$listing|listing_url}\">{$listing.Title}</a> was successfully posted at <a href=\"{$siteUrl}\">{$siteUrl}</a>.<br /><br />You can edit, delete or make your job hidden in <a href=\"{$siteUrl}/my-listings/job/\">"My Account"</a> section.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(17,'Job Expiration Notice','listing','','Your job has been expired','Hello {$listing.user.FullName|escape},<br /><br />Your job "{$listing.Title}" has just been expired.<br /><br />To re-activate it, please go to <a href=\"{$siteUrl}/my-listings/job/\">Job Postings</a> section in "My Account".<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(18,'Resume Expiration Notice','listing','','Your resume has been expired','Hello {$listing.user.FullName|escape},<br /><br />Your resume has just been expired.<br /><br />To re-activate it, please go to My Resumes section in <a href=\"{$siteUrl}/my-listings/resume/\">"My Account"</a>.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(22,'Product Expiration Notice','product','','Product Expiration Notice','Hello {$user.FullName|escape},<br /><br />Your subscription to "{$product.caption}" has just expired.<br /><br />To purchase another available product, please visit our <a href=\"{$siteUrl}{if $user.group.id == \'JobSeeker\'}/jobseeker-products/{elseif $user.group.id == \'Employer\'}/employer-products/{else}/products/{/if}\">Pricing page</a>.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(24,'Order Confirmation','product','','Your order on {$GLOBALS.settings.site_title}','Hello {$user.FullName|escape},<br /><br />You have successfully purchased "{$product.caption}" on {$GLOBALS.settings.site_title}.<br /><br />Payment details:<br /><br />"{$product.caption}" x 1 = {currencyFormat amount=$product.price}<br />-----<br />Sub total: {currencyFormat amount=$invoice.sub_total}<br />{if $invoice.tax}Taxes: {currencyFormat amount=$invoice.tax}<br />{/if}Grand total: {currencyFormat amount=$invoice.total}<br /><br /><a href=\"{$siteUrl}/invoice/{$invoice.id}/{$invoice.hash}/\">View Invoice</a><br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(25,'Product Purchase Confirmation for Admin','product','','New payment received','Hello,<br /><br />On {$invoice.date|date} the user {$user.FullName|escape} has successfully purchased "{$product.caption}" on {$GLOBALS.settings.site_title}.<br /><br />Payment details:<br /><br />"{$product.caption}" x 1 = {currencyFormat amount=$product.price}<br />-----<br />Sub total: {currencyFormat amount=$invoice.sub_total}<br />{if $invoice.tax}Taxes: {currencyFormat amount=$invoice.tax}<br />{/if}Grand total: {currencyFormat amount=$invoice.total}<br /><br />To view payment details, please click <a href=\"{$GLOBALS.admin_site_url}/view-invoice/?sid={$invoice.id}\">here</a>.\r\n',1,1),(30,'Contact Form Email','other','','Message from {$name}','This message was sent via contact form on <a href=\"{$siteUrl}\">{$siteUrl}</a>\r\n<br/><br/>\r\n|| name: {$name}<br/>\r\n|| email: {$email}<br/>\r\n|| comments: {$comments}',1,1),(33,'Application Email to Employer','other','','Application for {$listing.Title}','Hello {$user.FullName|escape},<br /><br />You received a new application to your job posting "{$listing.Title}" from the following applicant:<br /><br />Name: {$applicant_request.name}<br />Email: {$applicant_request.email}<br />Cover Letter:<br /><span style=\"white-space: pre-line;\">{$applicant_request.comments}</span><br /><br /><a href=\"{$siteUrl}/system/applications/view/\">View all applications</a><br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(36,'Password Recovery','other','','Password recovery for {$GLOBALS.settings.site_title}','Hello {$user.FullName|escape},<br /><br />Someone has requested to change the password for your account at <a href=\"{$siteUrl}\">{$siteUrl}</a>. If it was not you, please ignore this message.<br /><br />Otherwise, to change your password you can by following the link below:<br /><br /><a href=\"{$siteUrl}/change-password/?username={$user.username}&verification_key={$user.verification_key}\">Change your password</a><br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(48,'Employer Welcome Email','user','','Welcome to {$GLOBALS.settings.site_title}!','Hello {$user.FullName|escape},<br /><br />Thank you for registering with {$siteUrl}.<br /><br />You will be pleasantly surprised when you see how easy it is to post jobs, search for resumes and track applications with us.<br /><br />We are happy you've chosen to be a part of our community and we hope you enjoy your stay.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(49,'Job Seeker Welcome Email','user','','Welcome to {$GLOBALS.settings.site_title}!','Hello {$user.FullName|escape},<br /><br />Thank you for registering with <a href=\"{$siteUrl}\">{$siteUrl}</a>.<br /><br />You will be pleasantly surprised when you see how easy it is create a resume, search for jobs and create job alerts with us.<br /><br />We are happy you've chosen to be a part of our community and we hope you enjoy your stay.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(203,'Job Alert','alerts','','New jobs at {$GLOBALS.settings.site_title}','Hi there,<br /><br />Here are the latest jobs that match your job alert request:<p>{foreach from=$listings item=listing}</p>\r\n<p><strong><a href=\"{$siteUrl}{$listing|listing_url}\">{$listing.Title}</a></strong><br />{$listing|location|escape}<br />{$listing.user.CompanyName|escape}</p>\r\n<p>{/foreach}</p>If you do not want to receive any email alerts from now on please unsubscribe using the link below:<br /><a href=\"{$siteUrl}/guest-alerts/unsubscribe/?key={$key}\">Unsubscribe</a>.<br /><br />Thanks,<br />The {$GLOBALS.settings.site_title} team',0,1),(301,'Admin Invite','other','','You\'ve been invited to manage {$GLOBALS.settings.site_title} job board','<p>Hi {$admin.name},</p>\n<p>{$inviter.name} has invited you to work on {$GLOBALS.settings.site_title} job board.</p>\n<p><a target=\"_blank\" href=\"{$GLOBALS.admin_site_url}/?action=activate&email={$admin.email|escape:\"url\"}&hash={$admin.hash|escape:\"url\"}\">Create Admin Account</a></p>\n<p style=\"text-align: center;\"><a href=\"https://www.smartjobboard.com/?utm_source=Invite&utm_medium=Email&utm_campaign=Invite_Emails\"><img class=\"logo__img\" src=\"https://www.smartjobboard.com/wp-content/uploads/2016/09/logo.png\" border=\"0\" /></a></p>',1,1),(302,'Admin Recover','other','','Password Reset','<p>Hi {$admin.name},</p>\n<p>You recently requested to reset your password for {$GLOBALS.settings.site_title}. Please click the link below to reset your password.</p>\n<p><a target=\"_blank\" href=\"{$GLOBALS.admin_site_url}/?action=password_recover&recover_key={$admin.recover_key|escape:\"url\"}\">{$GLOBALS.admin_site_url}/?action=password_recover&recover_key={$admin.recover_key|escape:\"url\"}</a></p>\n<p>If clicking the link does not work, please copy and paste the URL into your browser instead.</p>',1,1),(303,'Recurring Payment Failed','product','','Payment Failed','<p>Hello {$user.FullName|escape},</p>\r\n<p>Your recurring payment for \"{$product.caption}\" on {$GLOBALS.settings.site_title} was failed.</p>\r\n<p>The subscription is now canceled.</p>\r\n<p>Payment details: \"{$product.caption}\" - {currencyFormat amount=$product.price}</p>\r\n<p>----</p>\r\n<p>Sub total: {currencyFormat amount=$invoice.sub_total}</p>\r\n<p>{if $invoice.tax} Taxes: {currencyFormat amount=$invoice.tax} {/if}</p>\r\n<p>Grand total: {currencyFormat amount=$invoice.total}</p>\r\n<p>Please make sure your credit/debit card has sufficient available funds and your card is not expired.</p>\r\n<p>You can renew your subscription by subscribing again on our website.</p>\r\n<p>Thanks,<br />The {$GLOBALS.settings.site_title} team</p>',0,1);
275/*!40000 ALTER TABLE `email_templates` ENABLE KEYS */;
276UNLOCK TABLES;
277
278--
279-- Table structure for table `guest_alerts`
280--
281
282DROP TABLE IF EXISTS `guest_alerts`;
283/*!40101 SET @saved_cs_client = @@character_set_client */;
284/*!40101 SET character_set_client = utf8 */;
285CREATE TABLE `guest_alerts` (
286 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
287 `email` varchar(255) DEFAULT NULL,
288 `data` text,
289 `last_send` datetime DEFAULT NULL,
290 `email_frequency` enum('daily','weekly','monthly') NOT NULL DEFAULT 'daily',
291 `subscription_date` datetime DEFAULT NULL,
292 `status` tinyint(4) NOT NULL DEFAULT '1',
293 `alert_key` varchar(255) DEFAULT NULL,
294 PRIMARY KEY (`sid`),
295 KEY `last_send` (`last_send`),
296 KEY `email_frequency` (`email_frequency`),
297 KEY `email` (`email`),
298 KEY `alert_key` (`alert_key`)
299) ENGINE=MyISAM DEFAULT CHARSET=utf8;
300/*!40101 SET character_set_client = @saved_cs_client */;
301
302--
303-- Dumping data for table `guest_alerts`
304--
305
306LOCK TABLES `guest_alerts` WRITE;
307/*!40000 ALTER TABLE `guest_alerts` DISABLE KEYS */;
308/*!40000 ALTER TABLE `guest_alerts` ENABLE KEYS */;
309UNLOCK TABLES;
310
311--
312-- Table structure for table `invoices`
313--
314
315DROP TABLE IF EXISTS `invoices`;
316/*!40101 SET @saved_cs_client = @@character_set_client */;
317/*!40101 SET character_set_client = utf8 */;
318CREATE TABLE `invoices` (
319 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
320 `user_sid` int(10) DEFAULT NULL,
321 `date` datetime DEFAULT NULL,
322 `payment_method` varchar(255) DEFAULT NULL,
323 `sub_total` double DEFAULT '0',
324 `total` double DEFAULT '0',
325 `serialized_items_info` text,
326 `serialized_tax_info` text,
327 `status` varchar(255) DEFAULT NULL,
328 `include_tax` tinyint(4) DEFAULT NULL,
329 `callback_data` text,
330 `product_sid` varchar(255) DEFAULT NULL,
331 `status_paid` tinyint(1) NOT NULL DEFAULT '0',
332 `recurring_id` varchar(255) DEFAULT '',
333 PRIMARY KEY (`sid`)
334) ENGINE=MyISAM DEFAULT CHARSET=utf8;
335/*!40101 SET character_set_client = @saved_cs_client */;
336
337--
338-- Dumping data for table `invoices`
339--
340
341LOCK TABLES `invoices` WRITE;
342/*!40000 ALTER TABLE `invoices` DISABLE KEYS */;
343/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
344UNLOCK TABLES;
345
346--
347-- Table structure for table `listing_complex_fields`
348--
349
350DROP TABLE IF EXISTS `listing_complex_fields`;
351/*!40101 SET @saved_cs_client = @@character_set_client */;
352/*!40101 SET character_set_client = utf8 */;
353CREATE TABLE `listing_complex_fields` (
354 `sid` int(10) unsigned NOT NULL,
355 `field_sid` int(10) DEFAULT NULL,
356 `id` varchar(255) DEFAULT NULL,
357 `order` int(10) DEFAULT NULL,
358 `caption` varchar(255) DEFAULT NULL,
359 `type` varchar(255) DEFAULT NULL,
360 `is_required` tinyint(1) NOT NULL DEFAULT '0',
361 `maximum` float DEFAULT NULL,
362 `minimum` float DEFAULT NULL,
363 `maxlength` varchar(255) DEFAULT NULL,
364 `template` varchar(255) DEFAULT NULL,
365 `choiceLimit` int(11) DEFAULT '0',
366 PRIMARY KEY (`sid`),
367 KEY `field_sid` (`field_sid`),
368 KEY `id` (`id`),
369 KEY `order` (`order`)
370) ENGINE=MyISAM DEFAULT CHARSET=utf8;
371/*!40101 SET character_set_client = @saved_cs_client */;
372
373--
374-- Dumping data for table `listing_complex_fields`
375--
376
377LOCK TABLES `listing_complex_fields` WRITE;
378/*!40000 ALTER TABLE `listing_complex_fields` DISABLE KEYS */;
379INSERT INTO `listing_complex_fields` VALUES (1275915876,274,'WE_From',11,'From','date',0,NULL,NULL,NULL,NULL,0),(1275915985,274,'WE_To',14,'To','date',0,NULL,NULL,NULL,NULL,0),(1275916042,274,'WE_JobTitle',6,'Position','string',0,NULL,NULL,'256',NULL,0),(1275916199,273,'ED_To',8,'To','date',0,NULL,NULL,NULL,NULL,0),(1275916289,273,'ED_DegreeSpecialty',4,'Degree or Specialty','string',0,NULL,NULL,'256',NULL,0),(1276265223,273,'ED_From',6,'From','date',0,NULL,NULL,NULL,NULL,0),(1282192099,273,'ED_UniversityInstitution',5,'University or Institution','string',0,NULL,NULL,'256',NULL,0),(1282192477,274,'WE_Description',15,'Description','text',0,NULL,NULL,'','text.tpl',0),(1453279463,274,'WE_Company',8,'Company','string',0,NULL,NULL,NULL,NULL,0);
380/*!40000 ALTER TABLE `listing_complex_fields` ENABLE KEYS */;
381UNLOCK TABLES;
382
383--
384-- Table structure for table `listing_feeds`
385--
386
387DROP TABLE IF EXISTS `listing_feeds`;
388/*!40101 SET @saved_cs_client = @@character_set_client */;
389/*!40101 SET character_set_client = utf8 */;
390CREATE TABLE `listing_feeds` (
391 `sid` int(11) NOT NULL AUTO_INCREMENT,
392 `name` varchar(100) NOT NULL,
393 `template` varchar(200) NOT NULL,
394 `description` text NOT NULL,
395 `mime_type` varchar(255) NOT NULL DEFAULT 'application/rss+xml',
396 `id` varchar(255) NOT NULL,
397 `order` int(11) NOT NULL DEFAULT '0',
398 PRIMARY KEY (`sid`),
399 KEY `id` (`id`)
400) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
401/*!40101 SET character_set_client = @saved_cs_client */;
402
403--
404-- Dumping data for table `listing_feeds`
405--
406
407LOCK TABLES `listing_feeds` WRITE;
408/*!40000 ALTER TABLE `listing_feeds` DISABLE KEYS */;
409INSERT INTO `listing_feeds` VALUES (2,'Indeed','feed_indeed.tpl','Using this feed you can submit your jobs to Indeed.com.<br/> Use this link <a target=\"_blank\" href=\"http://www.indeed.com/hire?indpubnum=6053709130975284\">http://www.indeed.com/hire?indpubnum=6053709130975284</a> for instruction on how to get started.','text/xml; charset=utf-8','indeed',2),(3,'Latest Jobs (RSS)','feed_rss.tpl','','application/rss+xml; charset=utf-8','rss',1),(4,'Trovit','feed_trovit.tpl','Using this feed you can submit your jobs to job.trovit.com.<br/> Use this link <a href=\"http://about.trovit.com/your-ads-on-trovit/us/\" target=\"_blank\">http://about.trovit.com/your-ads-on-trovit/us/</a> for instruction on how to get started.','text/xml; charset=utf-8','trovit',4);
410/*!40000 ALTER TABLE `listing_feeds` ENABLE KEYS */;
411UNLOCK TABLES;
412
413--
414-- Table structure for table `listing_field_list`
415--
416
417DROP TABLE IF EXISTS `listing_field_list`;
418/*!40101 SET @saved_cs_client = @@character_set_client */;
419/*!40101 SET character_set_client = utf8 */;
420CREATE TABLE `listing_field_list` (
421 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
422 `field_sid` int(10) unsigned DEFAULT NULL,
423 `order` int(10) unsigned DEFAULT NULL,
424 `value` varchar(255) DEFAULT NULL,
425 PRIMARY KEY (`sid`),
426 KEY `field_sid` (`field_sid`),
427 KEY `order` (`order`),
428 KEY `value` (`value`)
429) ENGINE=MyISAM AUTO_INCREMENT=673 DEFAULT CHARSET=utf8;
430/*!40101 SET character_set_client = @saved_cs_client */;
431
432--
433-- Dumping data for table `listing_field_list`
434--
435
436LOCK TABLES `listing_field_list` WRITE;
437/*!40000 ALTER TABLE `listing_field_list` DISABLE KEYS */;
438INSERT INTO `listing_field_list` VALUES (76,199,1,'Full time'),(77,199,2,'Part time'),(78,199,3,'Contractor'),(79,199,4,'Intern'),(80,199,5,'Seasonal'),(87,213,1,'full time'),(88,213,2,'part time'),(89,213,3,'contractor'),(90,213,4,'intern'),(91,213,5,'seasonal'),(343,198,1,'Accounting'),(344,198,2,'Admin-Clerical'),(345,198,3,'Automotive'),(346,198,4,'Banking'),(347,198,5,'Biotech'),(348,198,6,'Business Development'),(349,198,7,'Construction'),(350,198,8,'Consultant'),(351,198,9,'Customer Service'),(352,198,10,'Design'),(353,198,11,'Distribution-Shipping'),(354,198,12,'Education'),(355,198,13,'Engineering'),(356,198,14,'Entry Level'),(357,198,15,'Executive'),(358,198,16,'Facilities'),(359,198,17,'Finance'),(360,198,18,'Franchise'),(361,198,19,'General Business'),(362,198,20,'General Labor'),(363,198,21,'Government'),(364,198,22,'Grocery'),(365,198,23,'Health Care'),(366,198,24,'Hospitality-Hotel'),(367,198,25,'Human Resources'),(368,198,26,'Information Technology'),(369,198,27,'Installation-Maint-Repair'),(370,198,28,'Insurance'),(371,198,29,'Inventory'),(372,198,30,'Legal'),(373,198,31,'Management'),(374,198,32,'Manufacturing'),(375,198,33,'Marketing'),(376,198,34,'Media-Journalism'),(377,198,35,'Nonprofit-Social Services'),(378,198,36,'Nurse'),(379,198,37,'Other'),(380,198,38,'Pharmaceutical'),(381,198,39,'Professional Services'),(382,198,40,'Purchasing-Procurement'),(383,198,41,'QA-Quality Control'),(384,198,42,'Real Estate'),(385,198,43,'Research'),(386,198,44,'Restaurant-Food Service'),(387,198,45,'Retail'),(388,198,46,'Sales'),(389,198,47,'Science'),(390,198,48,'Skilled Labor'),(391,198,49,'Strategy-Planning'),(392,198,50,'Supply Chain'),(393,198,51,'Telecommunications'),(394,198,52,'Training'),(395,198,53,'Transportation'),(396,198,54,'Veterinary Services'),(397,198,55,'Warehouse'),(398,215,1,'Alabama'),(399,215,2,'Alaska'),(400,215,3,'Alberta'),(401,215,4,'Arizona'),(402,215,5,'Arkansas'),(403,215,6,'British Columbia'),(404,215,7,'California'),(405,215,8,'Colorado'),(406,215,9,'Connecticut'),(407,215,10,'Delaware'),(408,215,11,'District of Columbia'),(409,215,12,'Florida'),(410,215,13,'Georgia'),(411,215,14,'Guam'),(412,215,15,'Hawaii'),(413,215,16,'Idaho'),(414,215,17,'Illinois'),(415,215,18,'Indiana'),(416,215,19,'Iowa'),(417,215,20,'Kansas'),(418,215,21,'Kentucky'),(419,215,22,'Louisiana'),(420,215,23,'Maine'),(421,215,24,'Manitoba'),(422,215,25,'Maryland'),(423,215,26,'Massachusetts'),(424,215,27,'Michigan'),(425,215,28,'Minnesota'),(426,215,29,'Mississippi'),(427,215,30,'Missouri'),(428,215,31,'Montana'),(429,215,32,'Nebraska'),(430,215,33,'Nevada'),(431,215,34,'New Hampshire'),(432,215,35,'New Jersey'),(433,215,36,'New Mexico'),(434,215,37,'New York'),(435,215,38,'North Carolina'),(436,215,39,'North Dakota'),(437,215,40,'Ohio'),(438,215,41,'Oklahoma'),(439,215,42,'Ontario'),(440,215,43,'Oregon'),(441,215,44,'Pennsylvania'),(442,215,45,'Puerto Rico'),(443,215,46,'Rhode Island'),(444,215,47,'South Carolina'),(445,215,48,'South Dakota'),(446,215,49,'Tennessee'),(447,215,50,'Texas'),(448,215,51,'Utah'),(449,215,52,'Vermont'),(450,215,53,'Virgin Islands'),(451,215,54,'Virginia'),(452,215,55,'Washington'),(453,215,56,'West Virginia'),(454,215,57,'Wisconsin'),(455,215,58,'Wyoming'),(456,215,59,'Outside US'),(545,1275915876,1,'1980'),(546,1275915876,2,'1981'),(547,1275915876,3,'1982'),(548,1275915876,4,'1983'),(549,1275915876,5,'1984'),(550,1275915876,6,'1985'),(551,1275915876,7,'1986'),(552,1275915876,8,'1987'),(553,1275915876,9,'1988'),(554,1275915876,10,'1989'),(555,1275915876,11,'1990'),(556,1275915876,12,'1991'),(557,1275915876,13,'1992'),(558,1275915876,14,'1993'),(559,1275915876,15,'1994'),(560,1275915876,16,'1995'),(561,1275915876,17,'1996'),(562,1275915876,18,'1997'),(563,1275915876,19,'1998'),(564,1275915876,20,'1999'),(565,1275915876,21,'2000'),(566,1275915876,22,'2001'),(567,1275915876,23,'2002'),(568,1275915876,24,'2003'),(569,1275915876,25,'2004'),(570,1275915876,26,'2005'),(571,1275915876,27,'2006'),(572,1275915876,28,'2007'),(573,1275915876,29,'2008'),(574,1275915876,30,'2009'),(575,1275915876,31,'2010'),(576,1275915985,1,'1980'),(577,1275915985,2,'1981'),(578,1275915985,3,'1982'),(579,1275915985,4,'1983'),(580,1275915985,5,'1984'),(581,1275915985,6,'1985'),(582,1275915985,7,'1986'),(583,1275915985,8,'1987'),(584,1275915985,9,'1988'),(585,1275915985,10,'1989'),(586,1275915985,11,'1990'),(587,1275915985,12,'1991'),(588,1275915985,13,'1992'),(589,1275915985,14,'1993'),(590,1275915985,15,'1994'),(591,1275915985,16,'1995'),(592,1275915985,17,'1996'),(593,1275915985,18,'1997'),(594,1275915985,19,'1998'),(595,1275915985,20,'1999'),(596,1275915985,21,'2000'),(597,1275915985,22,'2001'),(598,1275915985,23,'2002'),(599,1275915985,24,'2003'),(600,1275915985,25,'2004'),(601,1275915985,26,'2005'),(602,1275915985,27,'2006'),(603,1275915985,28,'2007'),(604,1275915985,29,'2008'),(605,1275915985,30,'2009'),(606,1275915985,31,'2010'),(607,1275916199,1,'1980'),(608,1275916199,2,'1981'),(609,1275916199,3,'1982'),(610,1275916199,4,'1983'),(611,1275916199,5,'1984'),(612,1275916199,6,'1985'),(613,1275916199,7,'1986'),(614,1275916199,8,'1987'),(615,1275916199,9,'1988'),(616,1275916199,10,'1989'),(617,1275916199,11,'1990'),(618,1275916199,12,'1991'),(619,1275916199,13,'1992'),(620,1275916199,14,'1993'),(621,1275916199,15,'1994'),(622,1275916199,16,'1995'),(623,1275916199,17,'1996'),(624,1275916199,18,'1997'),(625,1275916199,19,'1998'),(626,1275916199,20,'1999'),(627,1275916199,21,'2000'),(628,1275916199,22,'2001'),(629,1275916199,23,'2002'),(630,1275916199,24,'2003'),(631,1275916199,25,'2004'),(632,1275916199,26,'2005'),(633,1275916199,27,'2006'),(634,1275916199,28,'2007'),(635,1275916199,29,'2008'),(636,1275916199,30,'2009'),(637,1275916199,31,'2010'),(667,330,1,'test'),(668,330,2,'test1');
439/*!40000 ALTER TABLE `listing_field_list` ENABLE KEYS */;
440UNLOCK TABLES;
441
442--
443-- Table structure for table `listing_fields`
444--
445
446DROP TABLE IF EXISTS `listing_fields`;
447/*!40101 SET @saved_cs_client = @@character_set_client */;
448/*!40101 SET character_set_client = utf8 */;
449CREATE TABLE `listing_fields` (
450 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
451 `id` varchar(255) DEFAULT NULL,
452 `listing_type_sid` int(10) unsigned NOT NULL DEFAULT '0',
453 `order` int(10) unsigned DEFAULT NULL,
454 `caption` varchar(255) DEFAULT NULL,
455 `type` varchar(50) DEFAULT NULL,
456 `default_value` varchar(255) DEFAULT NULL,
457 `is_required` tinyint(1) NOT NULL DEFAULT '0',
458 `maxlength` varchar(255) DEFAULT '',
459 `width` int(5) DEFAULT '0',
460 `height` int(5) DEFAULT '0',
461 `second_width` int(5) DEFAULT '0',
462 `second_height` int(5) DEFAULT '0',
463 `template` varchar(255) DEFAULT NULL,
464 `minimum` float DEFAULT '0',
465 `maximum` float DEFAULT '0',
466 `choiceLimit` int(11) DEFAULT '0',
467 `add_parameter` varchar(20) DEFAULT NULL,
468 `parent_sid` int(10) DEFAULT NULL,
469 `hidden` tinyint(1) NOT NULL DEFAULT '0',
470 `display_as` varchar(255) DEFAULT NULL,
471 PRIMARY KEY (`sid`),
472 KEY `listing_type_sid` (`listing_type_sid`),
473 KEY `order` (`order`),
474 KEY `ufi` (`id`)
475) ENGINE=MyISAM AUTO_INCREMENT=368 DEFAULT CHARSET=utf8;
476/*!40101 SET character_set_client = @saved_cs_client */;
477
478--
479-- Dumping data for table `listing_fields`
480--
481
482LOCK TABLES `listing_fields` WRITE;
483/*!40000 ALTER TABLE `listing_fields` DISABLE KEYS */;
484INSERT INTO `listing_fields` VALUES (197,'Title',6,1,'Job Title','string','',1,'256',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(198,'JobCategory',0,2,'Categories','multilist','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,0,'multilist'),(199,'EmploymentType',0,2,'Job Type','list','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL,NULL,0,'multilist'),(203,'JobDescription',6,7,'Job Description','text',NULL,0,'99999',NULL,NULL,NULL,NULL,'text.tpl',NULL,NULL,0,NULL,NULL,0,NULL),(214,'Country',0,4,'Country','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,359,0,'country_name'),(215,'State',0,5,'State','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,359,0,'state_name'),(217,'ZipCode',0,16,'Zip Code','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,359,0,NULL),(218,'Resume',7,14,'Upload Resume','file',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(224,'Skills',7,7,'Personal Summary','text',NULL,0,'',NULL,NULL,NULL,NULL,'text.tpl',NULL,NULL,0,NULL,NULL,0,NULL),(234,'ApplicationSettings',6,10,'How to Apply','string',NULL,0,'256',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(273,'Education',7,12,'Education','complex',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(274,'WorkExperience',7,13,'Work Experience','complex',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL),(319,'access_type',7,16,'Let Employers Find My Resume','string','everyone',0,NULL,NULL,NULL,NULL,NULL,'let_employers_find_my_resume.tpl',NULL,NULL,0,NULL,NULL,0,NULL),(344,'City',0,14,'City','string','',0,'0',0,0,0,0,NULL,0,0,0,NULL,359,0,NULL),(359,'Location',0,17,'Location','location',NULL,0,'',0,0,0,0,NULL,0,0,0,NULL,NULL,0,NULL),(360,'expiration_date',6,13,'Expiration Date','date',NULL,0,'',0,0,0,0,NULL,0,0,0,NULL,NULL,0,NULL),(362,'Photo',7,18,'Photo','picture',NULL,0,'',250,250,0,0,NULL,0,0,0,NULL,NULL,0,NULL),(363,'Phone',7,19,'Phone','string',NULL,0,'',0,0,0,0,NULL,0,0,0,NULL,NULL,0,NULL),(364,'GooglePlace',0,17,'Location','google_place',NULL,0,'',0,0,0,0,'',0,0,0,NULL,NULL,0,NULL),(365,'Latitude',0,17,'Latitude','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,359,0,NULL),(366,'Longitude',0,18,'Longitude','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,359,0,NULL),(367,'Title',7,1,'Desired Job Title','string','',1,'256',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,0,NULL);
485/*!40000 ALTER TABLE `listing_fields` ENABLE KEYS */;
486UNLOCK TABLES;
487
488--
489-- Table structure for table `listing_types`
490--
491
492DROP TABLE IF EXISTS `listing_types`;
493/*!40101 SET @saved_cs_client = @@character_set_client */;
494/*!40101 SET character_set_client = utf8 */;
495CREATE TABLE `listing_types` (
496 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
497 `id` varchar(255) DEFAULT NULL,
498 `name` varchar(255) DEFAULT NULL,
499 `show_brief_or_detailed` tinyint(1) NOT NULL DEFAULT '0',
500 `waitApprove` tinyint(1) NOT NULL DEFAULT '0',
501 `email_alert` int(5) DEFAULT NULL,
502 `guest_alert_email` int(5) DEFAULT NULL,
503 PRIMARY KEY (`sid`),
504 UNIQUE KEY `ufi` (`id`)
505) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
506/*!40101 SET character_set_client = @saved_cs_client */;
507
508--
509-- Dumping data for table `listing_types`
510--
511
512LOCK TABLES `listing_types` WRITE;
513/*!40000 ALTER TABLE `listing_types` DISABLE KEYS */;
514INSERT INTO `listing_types` VALUES (6,'Job','Job',1,0,28,203),(7,'Resume','Resume',1,0,29,202);
515/*!40000 ALTER TABLE `listing_types` ENABLE KEYS */;
516UNLOCK TABLES;
517
518--
519-- Table structure for table `listings`
520--
521
522DROP TABLE IF EXISTS `listings`;
523/*!40101 SET @saved_cs_client = @@character_set_client */;
524/*!40101 SET character_set_client = utf8 */;
525CREATE TABLE `listings` (
526 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
527 `listing_type_sid` int(10) unsigned NOT NULL DEFAULT '0',
528 `user_sid` int(10) unsigned DEFAULT NULL,
529 `product_info` text,
530 `active` tinyint(4) unsigned DEFAULT '0',
531 `keywords` longtext,
532 `featured` tinyint(4) NOT NULL DEFAULT '0',
533 `views` int(11) NOT NULL DEFAULT '0',
534 `activation_date` datetime DEFAULT NULL,
535 `expiration_date` datetime DEFAULT NULL,
536 `featured_last_showed` datetime DEFAULT NULL,
537 `access_type` enum('everyone','no_one') NOT NULL DEFAULT 'everyone',
538 `access_list` text,
539 `contract_id` int(10) NOT NULL DEFAULT '0',
540 `data_source` int(10) unsigned DEFAULT NULL,
541 `external_id` varchar(1000) DEFAULT NULL,
542 `Title` varchar(255) DEFAULT NULL,
543 `JobCategory` text,
544 `Location_Country` text,
545 `Location_State` text,
546 `Location_ZipCode` varchar(255) DEFAULT NULL,
547 `EmploymentType` text,
548 `JobDescription` longtext,
549 `Skills` longtext,
550 `Resume` varchar(255) DEFAULT NULL,
551 `Location_City` varchar(255) DEFAULT NULL,
552 `preview` tinyint(1) DEFAULT '0',
553 `Location` varchar(500) DEFAULT NULL,
554 `complex` longtext,
555 `checkouted` tinyint(1) NOT NULL DEFAULT '1',
556 `Photo` varchar(255) DEFAULT NULL,
557 `Phone` varchar(255) DEFAULT NULL,
558 `GooglePlace` varchar(255) DEFAULT NULL,
559 `Location_Latitude` double DEFAULT NULL,
560 `Location_Longitude` double DEFAULT NULL,
561 `application_redirects` int(11) NOT NULL DEFAULT '0',
562 PRIMARY KEY (`sid`),
563 KEY `listing_type_sid` (`listing_type_sid`),
564 KEY `user_sid` (`user_sid`),
565 KEY `active` (`active`),
566 KEY `featured` (`featured`),
567 KEY `expiration_date` (`expiration_date`),
568 KEY `featured_last_showed` (`featured_last_showed`),
569 KEY `access_type` (`access_type`),
570 KEY `activation_date` (`activation_date`),
571 KEY `contract_id` (`contract_id`),
572 KEY `views` (`views`),
573 KEY `Title` (`Title`),
574 KEY `Resume` (`Resume`),
575 KEY `ZipCode` (`Location_ZipCode`),
576 KEY `City` (`Location_City`),
577 KEY `preview` (`preview`),
578 KEY `dash_act_lt` (`listing_type_sid`,`activation_date`),
579 KEY `dash_act_act_lt` (`active`,`listing_type_sid`,`activation_date`),
580 KEY `id_Photo` (`Photo`),
581 KEY `id_Phone` (`Phone`),
582 KEY `id_Location` (`GooglePlace`),
583 KEY `Location_Latitude` (`Location_Latitude`),
584 KEY `Location_Longitude` (`Location_Longitude`),
585 FULLTEXT KEY `keywords` (`keywords`),
586 FULLTEXT KEY `Location` (`Location`),
587 FULLTEXT KEY `GooglePlaceF` (`GooglePlace`)
588) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
589/*!40101 SET character_set_client = @saved_cs_client */;
590
591--
592-- Dumping data for table `listings`
593--
594
595LOCK TABLES `listings` WRITE;
596/*!40000 ALTER TABLE `listings` DISABLE KEYS */;
597INSERT INTO `listings` VALUES (13,6,8,'a:13:{s:5:\"price\";s:1:\"0\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"15\";s:18:\"number_of_listings\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:8:\"featured\";s:1:\"0\";s:13:\"renewal_price\";s:2:\"20\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:0:\"\";s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"100\";s:33:\"upgrade_to_priority_listing_price\";s:2:\"50\";s:11:\"product_sid\";s:1:\"7\";}',1,'Insurance agent [Job Sample] Part time Consultant Franchise Insurance <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Insurance agent will sell insurance policies to individuals and companies by understanding their needs, requirements and financial conditions. A candidate need to have very good communication and negotiation skills and must be hardworking and meet deadlines and targets.</p> <div> </div> 2013-03-18 United States California Sacramento 94205 38.47999954223633 -121.44000244140625 Sacramento, CA 94205, United States',0,5,'2013-01-24 09:13:17','2023-03-18 00:00:00',NULL,'everyone','',2,NULL,NULL,'Insurance agent [Job Sample]','350,360,370','United States','California','94205','77','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Insurance agent will sell insurance policies to individuals and companies by understanding their needs, requirements and financial conditions. A candidate need to have very good communication and negotiation skills and must be hardworking and meet deadlines and targets.</p>\r\n<div> </div>',NULL,NULL,'Sacramento',0,'United States California Sacramento 94205 38.47999954223633 -121.44000244140625',NULL,1,NULL,NULL,'Sacramento, CA 94205, United States',38.47999954223633,-121.44000244140625,0),(14,6,8,'a:13:{s:5:\"price\";s:1:\"0\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"15\";s:18:\"number_of_listings\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:8:\"featured\";s:1:\"0\";s:13:\"renewal_price\";s:2:\"20\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:0:\"\";s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"100\";s:33:\"upgrade_to_priority_listing_price\";s:2:\"50\";s:11:\"product_sid\";s:1:\"7\";}',1,'Featured Credit Analyst [Job Sample] Full time Accounting Admin-Clerical Banking <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Credit Analyst should analyze financial information and assess the risks of credit offer to individuals and businesses.</p> 2013-03-18 United States California Sacramento 38.58157189999999 -121.49439960000001 Sacramento, CA, United States',1,3,'2013-01-24 09:13:17','2023-03-18 00:00:00','2016-03-18 17:13:37','everyone','',2,NULL,NULL,'Credit Analyst [Job Sample]','343,344,346','United States','California','','76','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Credit Analyst should analyze financial information and assess the risks of credit offer to individuals and businesses.</p>',NULL,NULL,'Sacramento',0,'United States California Sacramento 38.58157189999999 -121.49439960000001',NULL,1,NULL,NULL,'Sacramento, CA, United States',38.58157189999999,-121.49439960000001,0),(15,7,1,'a:13:{s:5:\"price\";s:1:\"0\";s:16:\"listing_type_sid\";s:1:\"7\";s:17:\"expiration_period\";s:1:\"0\";s:18:\"number_of_listings\";s:0:\"\";s:16:\"listing_duration\";s:4:\"7300\";s:8:\"featured\";s:1:\"0\";s:13:\"renewal_price\";s:0:\"\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:2:\"10\";s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:0:\"\";s:33:\"upgrade_to_priority_listing_price\";s:2:\"30\";s:11:\"product_sid\";s:1:\"8\";}',1,'Featured Frontend developer Full time Engineering <strong>This is not a real Resume. Please, don't try to hire me. </strong><br /><br />Senior FrontEnd Developer (AngularJS/2, Ionic/Cordova, JavaScript, Node.js, TypeScript, ) Masters in Software Engineering Bachelor in Software Engineering Stanford University Massachusetts Institute of Technology 2011-01-01 2006-01-01 2014-01-01 2010-01-01 Senior Frontend Developer Junior Frontend Developer Yahoo Inc. Blink Inc. 2015-01-01 2014-01-01 1969-12-31 2015-01-01 AngularJS/2, Ionic/Cordova, JavaScript, Node.js, TypeScript Frontend: <br />AngularJS, Javascript, JQuery, Typescript, Everyone New York, NY, United States John Smith [Resume Sample] United States New York New York 40.7127837 -74.00594130000002',1,4,'2013-01-24 09:13:17','2023-03-18 00:00:00',NULL,'everyone','',3,NULL,NULL,'Frontend developer','355','United States','New York','','76',NULL,'<strong>This is not a real Resume. Please, don't try to hire me. </strong><br /><br />Senior FrontEnd Developer (AngularJS/2, Ionic/Cordova, JavaScript, Node.js, TypeScript, )','Resume_15','New York',0,'United States New_ York New_ York 40.7127837 -74.00594130000002','a:2:{s:9:\"Education\";a:4:{s:18:\"ED_DegreeSpecialty\";a:2:{i:1;s:31:\"Masters in Software Engineering\";i:2;s:32:\"Bachelor in Software Engineering\";}s:24:\"ED_UniversityInstitution\";a:2:{i:1;s:19:\"Stanford University\";i:2;s:37:\"Massachusetts Institute of Technology\";}s:7:\"ED_From\";a:2:{i:1;s:11:\"2011-01-01 \";i:2;s:11:\"2006-01-01 \";}s:5:\"ED_To\";a:2:{i:1;s:11:\"2014-01-01 \";i:2;s:11:\"2010-01-01 \";}}s:14:\"WorkExperience\";a:5:{s:11:\"WE_JobTitle\";a:2:{i:1;s:25:\"Senior Frontend Developer\";i:2;s:25:\"Junior Frontend Developer\";}s:10:\"WE_Company\";a:2:{i:1;s:10:\"Yahoo Inc.\";i:2;s:10:\"Blink Inc.\";}s:7:\"WE_From\";a:2:{i:1;s:11:\"2015-01-01 \";i:2;s:11:\"2014-01-01 \";}s:5:\"WE_To\";a:2:{i:1;N;i:2;s:11:\"2015-01-01 \";}s:14:\"WE_Description\";a:2:{i:1;s:59:\"AngularJS/2, Ionic/Cordova, JavaScript, Node.js, TypeScript\";i:2;s:69:\"Frontend: <br />AngularJS, Javascript, JQuery, Typescript, \";}}}',1,'Photo_15','','New York, NY, United States',40.7127837,-74.00594130000002,0),(19,6,6,'a:15:{s:12:\"pricing_type\";s:5:\"fixed\";s:5:\"price\";s:3:\"500\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:1:\"5\";s:13:\"renewal_price\";s:3:\"100\";s:8:\"featured\";s:1:\"1\";s:8:\"priority\";s:1:\"1\";s:18:\"number_of_pictures\";s:1:\"5\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:1:{i:1;s:0:\"\";}s:17:\"listings_range_to\";a:1:{i:1;s:0:\"\";}s:14:\"price_per_unit\";a:1:{i:1;s:0:\"\";}s:25:\"renewal_price_per_listing\";a:1:{i:1;s:0:\"\";}}s:5:\"video\";s:1:\"1\";s:33:\"upgrade_to_featured_listing_price\";s:0:\"\";s:33:\"upgrade_to_priority_listing_price\";s:0:\"\";s:11:\"product_sid\";s:1:\"2\";}',1,'Featured HR Specialist [Job Sample] Full time Human Resources <strong>This is not a real job. Please don't apply to it. </strong><br /><br />We are looking for an HR/ Office Manager. This is an opportunity to be a key part of growing the team throughout all departments. 2013-02-08 United States Colorado Durango 37.27528 -107.88006669999999 Durango, CO, United States',1,11,'2013-01-24 09:30:10','2023-02-08 00:00:00','2016-03-18 17:13:37','everyone',NULL,0,NULL,NULL,'HR Specialist [Job Sample]','367','United States','Colorado','','76','<strong>This is not a real job. Please don't apply to it. </strong><br /><br />We are looking for an HR/ Office Manager. This is an opportunity to be a key part of growing the team throughout all departments.',NULL,NULL,'Durango',0,'United States Colorado Durango 37.27528 -107.88006669999999',NULL,1,NULL,NULL,'Durango, CO, United States',37.27528,-107.88006669999999,0),(20,6,5,'a:15:{s:12:\"pricing_type\";s:12:\"volume_based\";s:5:\"price\";s:0:\"\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:0:\"\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:0:\"\";s:13:\"renewal_price\";s:0:\"\";s:8:\"featured\";s:1:\"0\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:1:\"3\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:5:{i:1;s:1:\"1\";i:2;s:2:\"11\";i:3;s:2:\"21\";i:4;s:2:\"31\";i:5;s:2:\"41\";}s:17:\"listings_range_to\";a:5:{i:1;s:2:\"10\";i:2;s:2:\"20\";i:3;s:2:\"30\";i:4;s:2:\"40\";i:5;s:2:\"50\";}s:14:\"price_per_unit\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}s:25:\"renewal_price_per_listing\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}}s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"150\";s:33:\"upgrade_to_priority_listing_price\";s:3:\"100\";s:11:\"product_sid\";s:1:\"1\";}',1,'Services Senior Manager [Job Sample] Full time Accounting Admin-Clerical <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Advisory Services professionals strive to help clients improve business performance, comply with regulatory requirements, and achieve sustainable value over time. Our approach incorporates the balancing of risk and control considerations with the more traditional performance and cost factors. Advisory professionals are also able to provide clients with relevant industry and functional skills where they need them most. We are currently seeking a Senior Associate to join us in our Los Angeles office, focused on the Aerospace & Defense industry.</p> 2013-02-23 United States Colorado Durango 81303 37.12459945678711 -107.92900085449219 Durango, CO 81303, United States',0,2,'2013-01-24 09:48:12','2023-02-23 00:00:00',NULL,'everyone','',0,NULL,NULL,'Services Senior Manager [Job Sample]','343,344','United States','Colorado','81303','76','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />Advisory Services professionals strive to help clients improve business performance, comply with regulatory requirements, and achieve sustainable value over time. Our approach incorporates the balancing of risk and control considerations with the more traditional performance and cost factors. Advisory professionals are also able to provide clients with relevant industry and functional skills where they need them most. We are currently seeking a Senior Associate to join us in our Los Angeles office, focused on the Aerospace & Defense industry.</p>',NULL,NULL,'Durango',0,'United States Colorado Durango 81303 37.12459945678711 -107.92900085449219',NULL,1,NULL,NULL,'Durango, CO 81303, United States',37.12459945678711,-107.92900085449219,0),(21,6,5,'a:15:{s:12:\"pricing_type\";s:12:\"volume_based\";s:5:\"price\";s:0:\"\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:0:\"\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:0:\"\";s:13:\"renewal_price\";s:0:\"\";s:8:\"featured\";s:1:\"0\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:1:\"3\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:5:{i:1;s:1:\"1\";i:2;s:2:\"11\";i:3;s:2:\"21\";i:4;s:2:\"31\";i:5;s:2:\"41\";}s:17:\"listings_range_to\";a:5:{i:1;s:2:\"10\";i:2;s:2:\"20\";i:3;s:2:\"30\";i:4;s:2:\"40\";i:5;s:2:\"50\";}s:14:\"price_per_unit\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}s:25:\"renewal_price_per_listing\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}}s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"150\";s:33:\"upgrade_to_priority_listing_price\";s:3:\"100\";s:11:\"product_sid\";s:1:\"1\";}',1,'Laboratory Manager [Job Sample] Full time Admin-Clerical Management <strong>This is not a real job. Please don't apply to it. </strong><br /><br />Laboratory Manager needed - Critical Access Hospital near Lubbock is seeking a qualified person to supervise and manage the hospital-based laboratory. 2013-02-23 United States Georgia Atlanta 33.7489954 -84.3879824 Atlanta, GA, United States',0,1,'2013-01-24 09:52:28','2023-02-23 00:00:00',NULL,'everyone',NULL,0,NULL,NULL,'Laboratory Manager [Job Sample]','344,373','United States','Georgia','','76','<strong>This is not a real job. Please don't apply to it. </strong><br /><br />Laboratory Manager needed - Critical Access Hospital near Lubbock is seeking a qualified person to supervise and manage the hospital-based laboratory.',NULL,NULL,'Atlanta',0,'United States Georgia Atlanta 33.7489954 -84.3879824',NULL,1,NULL,NULL,'Atlanta, GA, United States',33.7489954,-84.3879824,0),(22,6,4,'a:13:{s:5:\"price\";s:3:\"250\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"30\";s:18:\"number_of_listings\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:8:\"featured\";s:1:\"0\";s:13:\"renewal_price\";s:2:\"20\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:0:\"\";s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"100\";s:33:\"upgrade_to_priority_listing_price\";s:2:\"50\";s:11:\"product_sid\";s:1:\"4\";}',1,'Accountant [Job Sample] Full time Accounting Finance <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />What we need:</p> <p>Excellent interpersonal and communication skills. Ability to effectively communicate orally and in writing with all levels within the organization, as well as external parties.<br />Motivated, self-directed and results-driven approach to work, also takes ownership of assigned tasks.<br />The ability to meet deadlines.<br />Capable of establishing effective working relationships that promote teamwork and collaboration.<br />Willingness and ability to resolve issues that arise in the performance of the job duties.<br />Able to work in a dynamic and changing work environment.<br />Proficient with MS Office Suite required<br />Oracle experience preferred but not required.<br />Bachelors degree in Accounting/Finance<br />Refined products and/or pipelines experience preferred but not required.</p> 2013-02-23 United States California San Francisco 37.7749295 -122.41941550000001 San Francisco, CA, United States',0,1,'2013-01-24 09:57:07','2023-02-23 00:00:00',NULL,'everyone',NULL,0,NULL,NULL,'Accountant [Job Sample]','343,359','United States','California','','76','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />What we need:</p>\r\n<p>Excellent interpersonal and communication skills. Ability to effectively communicate orally and in writing with all levels within the organization, as well as external parties.<br />Motivated, self-directed and results-driven approach to work, also takes ownership of assigned tasks.<br />The ability to meet deadlines.<br />Capable of establishing effective working relationships that promote teamwork and collaboration.<br />Willingness and ability to resolve issues that arise in the performance of the job duties.<br />Able to work in a dynamic and changing work environment.<br />Proficient with MS Office Suite required<br />Oracle experience preferred but not required.<br />Bachelors degree in Accounting/Finance<br />Refined products and/or pipelines experience preferred but not required.</p>',NULL,NULL,'San Francisco',0,'United States California San_ Francisco 37.7749295 -122.41941550000001',NULL,1,NULL,NULL,'San Francisco, CA, United States',37.7749295,-122.41941550000001,0),(23,6,3,'a:15:{s:12:\"pricing_type\";s:5:\"fixed\";s:5:\"price\";s:3:\"500\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:1:\"5\";s:13:\"renewal_price\";s:3:\"100\";s:8:\"featured\";s:1:\"1\";s:8:\"priority\";s:1:\"1\";s:18:\"number_of_pictures\";s:1:\"5\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:1:{i:1;s:0:\"\";}s:17:\"listings_range_to\";a:1:{i:1;s:0:\"\";}s:14:\"price_per_unit\";a:1:{i:1;s:0:\"\";}s:25:\"renewal_price_per_listing\";a:1:{i:1;s:0:\"\";}}s:5:\"video\";s:1:\"1\";s:33:\"upgrade_to_featured_listing_price\";s:0:\"\";s:33:\"upgrade_to_priority_listing_price\";s:0:\"\";s:11:\"product_sid\";s:1:\"2\";}',1,'Featured Project Manager [Job Sample] Full time Management <strong>This is not a real job. Please don't apply to it. </strong><br /><br />Project manager is responsible for the planning, execution, closing of a project and accomplishing the stated project objectives 2013-02-08 United States Massachusetts Cambridge 42.3736158 -71.1097335 Cambridge, MA, United States',1,8,'2013-01-24 10:02:00','2023-02-08 00:00:00','2016-03-18 17:13:37','everyone',NULL,0,NULL,NULL,'Project Manager [Job Sample]','373','United States','Massachusetts','','76','<strong>This is not a real job. Please don't apply to it. </strong><br /><br />Project manager is responsible for the planning, execution, closing of a project and accomplishing the stated project objectives',NULL,NULL,'Cambridge',0,'United States Massachusetts Cambridge 42.3736158 -71.1097335',NULL,1,NULL,NULL,'Cambridge, MA, United States',42.3736158,-71.1097335,0),(24,6,3,'a:15:{s:12:\"pricing_type\";s:12:\"volume_based\";s:5:\"price\";s:0:\"\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:0:\"\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:0:\"\";s:13:\"renewal_price\";s:0:\"\";s:8:\"featured\";s:1:\"0\";s:8:\"priority\";s:1:\"0\";s:18:\"number_of_pictures\";s:1:\"3\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:5:{i:1;s:1:\"1\";i:2;s:2:\"11\";i:3;s:2:\"21\";i:4;s:2:\"31\";i:5;s:2:\"41\";}s:17:\"listings_range_to\";a:5:{i:1;s:2:\"10\";i:2;s:2:\"20\";i:3;s:2:\"30\";i:4;s:2:\"40\";i:5;s:2:\"50\";}s:14:\"price_per_unit\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}s:25:\"renewal_price_per_listing\";a:5:{i:1;s:2:\"20\";i:2;s:2:\"18\";i:3;s:2:\"16\";i:4;s:2:\"14\";i:5;s:2:\"12\";}}s:5:\"video\";s:1:\"0\";s:33:\"upgrade_to_featured_listing_price\";s:3:\"150\";s:33:\"upgrade_to_priority_listing_price\";s:3:\"100\";s:11:\"product_sid\";s:1:\"1\";}',1,'Office Manager [Job Sample] Full time Accounting Admin-Clerical <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />We're looking for an able to multi task person to work as office receptionist in our developing company.</p> <p>The Office Receptionist would be responsible for the following duties:<br />Schedules patient appointments.<br />Enters appointment date and time into computerized scheduler.<br />Records when appointments have been filled or canceled.<br />Telephones patients to remind them of appointments.<br />Telephones patients to reschedule missed appointments.<br />Calls patient referrals to solicit services.</p> 2013-02-23 United States Massachusetts Cambridge 42.3736158 -71.1097335 Cambridge, MA, United States',0,1,'2013-01-24 10:04:52','2023-02-23 00:00:00',NULL,'everyone',NULL,0,NULL,NULL,'Office Manager [Job Sample]','343,344','United States','Massachusetts','','76','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />We're looking for an able to multi task person to work as office receptionist in our developing company.</p>\r\n<p>The Office Receptionist would be responsible for the following duties:<br />Schedules patient appointments.<br />Enters appointment date and time into computerized scheduler.<br />Records when appointments have been filled or canceled.<br />Telephones patients to remind them of appointments.<br />Telephones patients to reschedule missed appointments.<br />Calls patient referrals to solicit services.</p>',NULL,NULL,'Cambridge',0,'United States Massachusetts Cambridge 42.3736158 -71.1097335',NULL,1,NULL,NULL,'Cambridge, MA, United States',42.3736158,-71.1097335,0),(25,6,3,'a:15:{s:12:\"pricing_type\";s:5:\"fixed\";s:5:\"price\";s:3:\"500\";s:16:\"listing_type_sid\";s:1:\"6\";s:17:\"expiration_period\";s:2:\"10\";s:16:\"listing_duration\";s:4:\"7300\";s:18:\"number_of_listings\";s:1:\"5\";s:13:\"renewal_price\";s:3:\"100\";s:8:\"featured\";s:1:\"1\";s:8:\"priority\";s:1:\"1\";s:18:\"number_of_pictures\";s:1:\"5\";s:20:\"volume_based_pricing\";a:4:{s:19:\"listings_range_from\";a:1:{i:1;s:0:\"\";}s:17:\"listings_range_to\";a:1:{i:1;s:0:\"\";}s:14:\"price_per_unit\";a:1:{i:1;s:0:\"\";}s:25:\"renewal_price_per_listing\";a:1:{i:1;s:0:\"\";}}s:5:\"video\";s:1:\"1\";s:33:\"upgrade_to_featured_listing_price\";s:0:\"\";s:33:\"upgrade_to_priority_listing_price\";s:0:\"\";s:11:\"product_sid\";s:1:\"2\";}',1,'Featured Office Receptionist [Job Sample] Full time Accounting Admin-Clerical <p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />We're looking for an able to multi task person to work as office receptionist in our developing company.</p> <p>The Office Receptionist would be responsible for the following duties:<br />Schedules patient appointments.<br />Enters appointment date and time into computerized scheduler.<br />Records when appointments have been filled or canceled.<br />Telephones patients to remind them of appointments.<br />Telephones patients to reschedule missed appointments.<br />Calls patient referrals to solicit services.</p> 2013-02-08 United States Massachusetts Cambridge 42.3736158 -71.1097335 Cambridge, MA, United States',1,8,'2013-01-24 10:06:16','2023-02-08 00:00:00','2016-03-18 17:13:37','everyone',NULL,0,NULL,NULL,'Office Receptionist [Job Sample]','343,344','United States','Massachusetts','','76','<p><strong>This is not a real job. Please don't apply to it. </strong><br /><br />We're looking for an able to multi task person to work as office receptionist in our developing company.</p>\r\n<p>The Office Receptionist would be responsible for the following duties:<br />Schedules patient appointments.<br />Enters appointment date and time into computerized scheduler.<br />Records when appointments have been filled or canceled.<br />Telephones patients to remind them of appointments.<br />Telephones patients to reschedule missed appointments.<br />Calls patient referrals to solicit services.</p>',NULL,NULL,'Cambridge',0,'United States Massachusetts Cambridge 42.3736158 -71.1097335',NULL,1,NULL,NULL,'Cambridge, MA, United States',42.3736158,-71.1097335,0);
598/*!40000 ALTER TABLE `listings` ENABLE KEYS */;
599UNLOCK TABLES;
600
601--
602-- Table structure for table `listings_active_period`
603--
604
605DROP TABLE IF EXISTS `listings_active_period`;
606/*!40101 SET @saved_cs_client = @@character_set_client */;
607/*!40101 SET character_set_client = utf8 */;
608CREATE TABLE `listings_active_period` (
609 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
610 `listing_sid` int(10) NOT NULL,
611 `number_of_days` int(10) DEFAULT '0',
612 `featured_period` int(10) DEFAULT '0',
613 PRIMARY KEY (`sid`),
614 KEY `listing_sid` (`listing_sid`)
615) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
616/*!40101 SET character_set_client = @saved_cs_client */;
617
618--
619-- Dumping data for table `listings_active_period`
620--
621
622LOCK TABLES `listings_active_period` WRITE;
623/*!40000 ALTER TABLE `listings_active_period` DISABLE KEYS */;
624INSERT INTO `listings_active_period` VALUES (1,3,-26,0),(2,11,-38,-38),(3,16,-48,0),(4,15,-48,0),(5,14,-48,0),(6,13,-48,0),(7,10,-38,0),(8,9,-103,-103),(9,8,-103,-103),(10,12,-38,0),(11,7,-103,0);
625/*!40000 ALTER TABLE `listings_active_period` ENABLE KEYS */;
626UNLOCK TABLES;
627
628--
629-- Table structure for table `listings_properties`
630--
631
632DROP TABLE IF EXISTS `listings_properties`;
633/*!40101 SET @saved_cs_client = @@character_set_client */;
634/*!40101 SET character_set_client = utf8 */;
635CREATE TABLE `listings_properties` (
636 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
637 `object_sid` int(10) unsigned DEFAULT NULL,
638 `id` varchar(255) DEFAULT NULL,
639 `value` text,
640 `add_parameter` varchar(255) DEFAULT NULL,
641 `complex_enum` int(10) DEFAULT NULL,
642 PRIMARY KEY (`sid`),
643 UNIQUE KEY `object_sid` (`object_sid`,`id`,`complex_enum`),
644 KEY `id` (`id`),
645 KEY `add_parameter` (`add_parameter`),
646 FULLTEXT KEY `value` (`value`)
647) ENGINE=MyISAM AUTO_INCREMENT=163 DEFAULT CHARSET=utf8;
648/*!40101 SET character_set_client = @saved_cs_client */;
649
650--
651-- Dumping data for table `listings_properties`
652--
653
654LOCK TABLES `listings_properties` WRITE;
655/*!40000 ALTER TABLE `listings_properties` DISABLE KEYS */;
656INSERT INTO `listings_properties` VALUES (85,13,'ApplicationSettings','','1',NULL),(87,14,'ApplicationSettings','','1',NULL),(131,19,'ApplicationSettings','','1',NULL),(133,20,'ApplicationSettings','','1',NULL),(135,21,'ApplicationSettings','','1',NULL),(137,22,'ApplicationSettings','','1',NULL),(139,23,'ApplicationSettings','','1',NULL),(141,24,'ApplicationSettings','','1',NULL),(143,25,'ApplicationSettings','','1',NULL);
657/*!40000 ALTER TABLE `listings_properties` ENABLE KEYS */;
658UNLOCK TABLES;
659
660--
661-- Table structure for table `navigation_menu`
662--
663
664DROP TABLE IF EXISTS `navigation_menu`;
665/*!40101 SET @saved_cs_client = @@character_set_client */;
666/*!40101 SET character_set_client = utf8 */;
667CREATE TABLE `navigation_menu` (
668 `id` int(11) NOT NULL AUTO_INCREMENT,
669 `name` varchar(255) NOT NULL,
670 `url` varchar(255) NOT NULL,
671 `parent` int(11) NOT NULL DEFAULT '0',
672 PRIMARY KEY (`id`),
673 KEY `parent` (`parent`)
674) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
675/*!40101 SET character_set_client = @saved_cs_client */;
676
677--
678-- Dumping data for table `navigation_menu`
679--
680
681LOCK TABLES `navigation_menu` WRITE;
682/*!40000 ALTER TABLE `navigation_menu` DISABLE KEYS */;
683INSERT INTO `navigation_menu` VALUES (1,'Jobs','/jobs/',0),(2,'Companies','/companies/',0),(3,'Post a Job','/add-listing/?listing_type_id=Job',0),(4,'Resume Search','/resumes/',0),(5,'Pricing','/employer-products/',0);
684/*!40000 ALTER TABLE `navigation_menu` ENABLE KEYS */;
685UNLOCK TABLES;
686
687--
688-- Table structure for table `pages`
689--
690
691DROP TABLE IF EXISTS `pages`;
692/*!40101 SET @saved_cs_client = @@character_set_client */;
693/*!40101 SET character_set_client = utf8 */;
694CREATE TABLE `pages` (
695 `uri` varchar(255) NOT NULL DEFAULT '',
696 `pass_parameters_via_uri` int(1) DEFAULT NULL,
697 `module` varchar(255) NOT NULL DEFAULT '',
698 `function` varchar(255) NOT NULL DEFAULT '',
699 `template` varchar(255) DEFAULT NULL,
700 `title` varchar(255) DEFAULT NULL,
701 `access_type` varchar(25) NOT NULL DEFAULT '',
702 `parameters` text NOT NULL,
703 `keywords` text,
704 `description` text NOT NULL,
705 `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
706 `content` mediumtext,
707 PRIMARY KEY (`ID`),
708 UNIQUE KEY `UNIQUE_KEY` (`uri`,`access_type`),
709 KEY `module` (`module`),
710 KEY `function` (`function`),
711 KEY `access_type` (`access_type`)
712) ENGINE=MyISAM AUTO_INCREMENT=579 DEFAULT CHARSET=utf8;
713/*!40101 SET character_set_client = @saved_cs_client */;
714
715--
716-- Dumping data for table `pages`
717--
718
719LOCK TABLES `pages` WRITE;
720/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
721INSERT INTO `pages` VALUES ('/',NULL,'dashboard','view','index.tpl','','admin','','','',1,NULL),('/edit-templates/',NULL,'template_manager','edit_templates','index.tpl','','admin','','','',31,NULL),('/edit-themes/',NULL,'template_manager','theme_editor','index.tpl','','admin','','','',32,NULL),('/user-pages/',NULL,'user_pages','edit_user_pages','index.tpl','','admin','','','',81,NULL),('/login/',0,'users','login','index.tpl','Sign in','user','N;','','',99,NULL),('/contact/',0,'static_content','show_static_content','../miscellaneous/contact_form_index.tpl','Contact Us','user','N;',NULL,'',111,''),('/payment-page/',NULL,'payment','payment_page','index.tpl','','user','N;','','',146,NULL),('/callback/',NULL,'payment','callback','','','user','N;','','',148,NULL),('/',0,'classifieds','search_form','main.tpl','','user','a:2:{s:15:\"listing_type_id\";s:3:\"Job\";s:13:\"form_template\";s:16:\"quick_search.tpl\";}','','',177,NULL),('/user-profile-fields/',NULL,'users','edit_user_profile','index.tpl','','admin','','','',178,NULL),('/add-user-profile-field/',NULL,'users','add_user_profile_field','index.tpl','','admin','','','',179,NULL),('/edit-user-profile/',NULL,'users','edit_user_profile','index.tpl','','admin','','','',180,NULL),('/delete-user-profile-field/',NULL,'users','delete_user_profile_field','index.tpl','','admin','','','',181,NULL),('/users/',NULL,'users','users','index.tpl','Users','admin','','','',183,NULL),('/edit-user/',NULL,'users','edit_user','index.tpl','Edit User','admin','','','',187,NULL),('/registration/',NULL,'users','registration','index.tpl','Registration','user','N;','','',188,NULL),('/listing-fields/',NULL,'classifieds','listing_fields','index.tpl','Listing Fields','admin','','','',189,NULL),('/delete-listing-field/',NULL,'classifieds','delete_listing_field','index.tpl','Delete Listing Field','admin','','','',191,NULL),('/edit-listing-field/',NULL,'classifieds','edit_listing_field','index.tpl','Edit Listing Field','admin','','','',192,NULL),('/edit-listing-type/',NULL,'classifieds','edit_listing_type','index.tpl','Edit Listing Type','admin','','','',195,NULL),('/add-listing-type-field/',NULL,'classifieds','add_listing_type_field','index.tpl','Add Listing Type Field','admin','','','',197,NULL),('/edit-listing-type-field/',NULL,'classifieds','edit_listing_type_field','index.tpl','Edit Listing Type Field','admin','','','',198,NULL),('/delete-listing-type-field/',NULL,'classifieds','delete_listing_type_field','index.tpl','Delete Listing Type Field','admin','','','',199,NULL),('/add-listing/',NULL,'classifieds','add_listing','index.tpl','','admin','','','',200,NULL),('/add-listing/',1,'classifieds','add_listing','index.tpl','','user','N;','','',205,NULL),('/pay-for-listing/',NULL,'classifieds','pay_for_listing','index.tpl','Pay For Listing','user','','','',210,NULL),('/edit-listing/',NULL,'classifieds','edit_listing','index.tpl','Edit Listing','admin','','','',214,NULL),('/my-listings/',1,'classifieds','my_listings','index.tpl','My Listings','user','N;','','',215,NULL),('/edit-list/',NULL,'classifieds','edit_list','index.tpl','Edit List','admin','','','',218,NULL),('/logout/',NULL,'users','logout','','','user','N;','','',224,NULL),('/edit-user-profile-field/',NULL,'users','edit_user_profile_field','index.tpl','Edit User Profile Field','admin','','','',229,NULL),('/password-recovery/',NULL,'users','password_recovery','','Password Recovery','user','N;','','',230,NULL),('/settings/',NULL,'miscellaneous','settings','','','admin','','','',235,NULL),('/edit-profile/',NULL,'users','edit_profile','','Edit Profile','user','N;','','',236,NULL),('/about/',0,'static_content','show_static_content',NULL,'About us','user','N;',NULL,'',240,'<p>You can fill this page with any relevant information.</p>'),('/ajax/',0,'miscellaneous','ajax','empty.tpl','Ajax','user','N;','','',255,NULL),('/jobs/',0,'classifieds','search_results','display.tpl','Jobs','user','a:5:{s:21:\"default_sorting_field\";s:15:\"activation_date\";s:21:\"default_sorting_order\";s:4:\"DESC\";s:25:\"default_listings_per_page\";s:2:\"20\";s:16:\"results_template\";s:23:\"search_results_jobs.tpl\";s:15:\"listing_type_id\";s:3:\"Job\";}',NULL,'',257,NULL),('/resumes/',0,'classifieds','search_results','display.tpl','Resumes','user','a:5:{s:21:\"default_sorting_field\";s:15:\"activation_date\";s:21:\"default_sorting_order\";s:4:\"DESC\";s:25:\"default_listings_per_page\";s:2:\"20\";s:16:\"results_template\";s:26:\"search_results_resumes.tpl\";s:15:\"listing_type_id\";s:6:\"Resume\";}',NULL,'',258,NULL),('/job/',1,'classifieds','display_listing','display.tpl',NULL,'user','a:2:{s:16:\"display_template\";s:15:\"display_job.tpl\";s:15:\"listing_type_id\";s:3:\"Job\";}',NULL,'',259,NULL),('/resume/',1,'classifieds','display_listing','display.tpl','Resume','user','a:2:{s:16:\"display_template\";s:18:\"display_resume.tpl\";s:15:\"listing_type_id\";s:6:\"Resume\";}',NULL,'',260,NULL),('/categories/',1,'classifieds','browse','','','user','a:2:{s:11:\"level1Field\";s:11:\"JobCategory\";s:15:\"listing_type_id\";s:3:\"Job\";}','','',261,NULL),('/cities/',1,'classifieds','browse','','','user','a:3:{s:11:\"level1Field\";s:4:\"City\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','','',262,NULL),('/my-jobs/',0,'classifieds','my_listings','','','user','a:1:{s:15:\"listing_type_id\";s:3:\"Job\";}','','',263,NULL),('/rss/',0,'classifieds','latest_listings','empty.tpl','Rss','user','a:4:{s:11:\"items_count\";s:2:\"10\";s:12:\"listing_type\";s:3:\"Job\";s:8:\"template\";s:12:\"feed_rss.tpl\";s:9:\"mime_type\";s:19:\"application/rss+xml\";}','','test description',264,NULL),('/my-account/',0,'menu','user_menu','index.tpl','My Account','user','N;','','',265,NULL),('/apply-now/',0,'classifieds','apply_now','blank.tpl','Apply now','user','N;','','',266,NULL),('/my-job-details/',1,'classifieds','display_my_listing','display.tpl','My Job Details','user','a:1:{s:16:\"display_template\";s:15:\"display_job.tpl\";}',NULL,'',269,NULL),('/my-resume-details/',1,'classifieds','display_my_listing','display.tpl',NULL,'user','a:1:{s:16:\"display_template\";s:18:\"display_resume.tpl\";}',NULL,'',270,NULL),('/terms-of-use/',0,'static_content','show_static_content','','Terms & Conditions','user','N;',NULL,'',277,'<h4>Introduction</h4>\r\n<p style=\"text-align:start\">Please read these Terms & Conditions carefully before using <u>[your site name]</u>.<br /><u>[your site name]</u> reserves the right to modify these Terms & Conditions at any time.</p>\r\n<h4><br />Services Provided</h4>\r\n<p><u>[your site name]</u> provides a service to bring Job Seekers and Employers together. Job Seekers and Employers can register, create profiles/job posts and search for jobs and resumes.</p>\r\n<h4><br />Privacy Policy</h4>\r\n<p>Job Seeker personal data will be available to Employers visiting <u>[your site name]</u>. Personal data includes a Name which is mandatory, an email Address which is mandatory and a Telephone Number which is optional.</p>\r\n<p>Personal data provided by the user may be used by <u>[your site name]</u> to notify the user of any news, and or promotional offers relating only to the <u>[your site name]</u> website. The user can unsubscribe from these notifications at anytime.</p>\r\n<p style=\"text-align:start\"><u>[your site name]</u> will not disclose user personal data to any third party.</p>\r\n<h4><br />Website Use</h4>\r\n<p><u>[your site name]</u> may not be used for any of the following purposes:</p>\r\n<ol><li>To contact <u>[your site name]</u> users regarding any issue apart from the purpose of recruitment.</li><li style=\"text-align:start\">To contact <u>[your site name]</u> users to offer any services from a 3rd party company.</li><li>To post any illegal content.</li></ol>\r\n<p>The user is required to provide truthful information in their profile or job post.</p>\r\n<p>It is prohibited to use any text or images from <u>[your site name]</u> for personal or commercial use.<br /> </p>\r\n<h4>User Information</h4>\r\n<p><u>[your site name]</u> does not hold responsibility for any untruthful and/or inaccurate information included in job posts and profiles.</p><u>[your site name]</u> reserves the right to edit or delete any information submitted by the user to the website.\r\n<h4><br />Liability</h4>\r\n<p><u>[your site name]</u> will not be responsible for any loss or damage the user may encounter from using the website.<br /> </p>\r\n<h4>Cookies Policy</h4>\r\n<p>Our website uses cookies.</p>\r\n<p>A cookie is a file containing an identifier (a string of letters and numbers) that is sent by a web server to a web browser and is stored by the browser. The identifier is then sent back to the server each time the browser requests a page from the server.</p>\r\n<p>We use Google Analytics to analyse the use of our website.</p>\r\n<p>Our analytics service provider generates statistical and other information about website use by means of cookies.</p>\r\n<p>You can delete cookies already stored on your computer. Please visit the 'Help' option in your browser menu to learn how to do this. Deleting cookies will have a negative impact on the usability of this website.</p>'),('/manage-breadcrumbs/',NULL,'breadcrumbs','manage_breadcrumbs','','Breadcrumbs','admin','','','',279,NULL),('/listing-feeds/',0,'classifieds','listing_feeds','empty.tpl','Listing Feeds','user','a:1:{s:14:\"count_listings\";s:2:\"20\";}','','',282,NULL),('/listing-import/',NULL,'listing_import','show_import','','','admin','','','',283,NULL),('/companies/',0,'classifieds','browseCompany','display.tpl','Companies','user','a:2:{s:16:\"display_template\";s:17:\"browseCompany.tpl\";s:15:\"listing_type_id\";s:3:\"Job\";}',NULL,'',314,NULL),('/task-scheduler-settings/',NULL,'miscellaneous','task_scheduler_settings','','Task Scheduler Settings','admin','','','',316,NULL),('/refine-search-settings/',NULL,'classifieds','refine_search','','','admin','','','',327,NULL),('/job-import/',0,'classifieds','job_import','index.tpl','Import','user','a:1:{s:15:\"listing_type_id\";s:3:\"Job\";}','','',333,NULL),('/jobg8_incoming/',0,'miscellaneous','jobg8_incoming','','','user','N;','','',336,NULL),('/jobg8_outgoing/',0,'miscellaneous','jobg8_outgoing','','','user','N;','','',338,NULL),('/apply-now-external/',0,'classifieds','apply_now_jobg8','','Apply Now','user','N;','','',339,NULL),('/company/',1,'classifieds','search_results','display.tpl',NULL,'user','a:5:{s:21:\"default_sorting_field\";s:15:\"activation_date\";s:21:\"default_sorting_order\";s:4:\"DESC\";s:25:\"default_listings_per_page\";s:2:\"20\";s:16:\"results_template\";s:23:\"search_results_jobs.tpl\";s:15:\"listing_type_id\";s:3:\"Job\";}',NULL,'',358,NULL),('/posting-pages/',1,'classifieds','posting_pages','index.tpl','','admin','','','',361,NULL),('/import-listings/',NULL,'classifieds','import_listings','index.tpl','Import Listings','admin','','','',366,NULL),('/listing-feeds/',NULL,'classifieds','listing_feeds','index.tpl','Listing Feeds','admin','','','',368,NULL),('/import-users/',NULL,'classifieds','import_users','index.tpl','Import Users','admin','','','',372,NULL),('/listing-actions/',NULL,'classifieds','listing_actions','index.tpl','Listing Actions','admin','','','',374,NULL),('/delete-uploaded-file/',NULL,'classifieds','delete_uploaded_file','index.tpl','Delete Uploaded File','admin','','','',375,NULL),('/manage-languages/',NULL,'I18N','manage_languages','index.tpl','Languages','admin','','','',380,NULL),('/manage-phrases/',NULL,'I18N','manage_phrases','index.tpl','Manage Phrases','admin','','','',381,NULL),('/edit-phrase/',NULL,'I18N','edit_phrase','index.tpl','Edit Phrase','admin','','','',383,NULL),('/add-import/',NULL,'listing_import','add_import','index.tpl','Add new import','admin','','','',386,NULL),('/show-import/',NULL,'listing_import','show_import','index.tpl','Show import','admin','','','',387,NULL),('/edit-import/',NULL,'listing_import','edit_import','index.tpl','Edit data soupce','admin','','','',388,NULL),('/run-import/',NULL,'listing_import','run_import','index.tpl','Run import from data source','admin','','','',389,NULL),('/delete-import/',NULL,'listing_import','delete_import','index.tpl','Delete data source','admin','','','',390,NULL),('/listing-import/user-fields/',NULL,'listing_import','user_fields','index.tpl','User Fields','admin','','','',391,NULL),('/maintenance-mode/',NULL,'miscellaneous','maintenance_mode','index.tpl','Maintenance Mode','user','','','',392,NULL),('/configure-gateway/',NULL,'payment','configure_gateway','index.tpl','Payment Gateway Control Panel','admin','','','',395,NULL),('/payment-page/',NULL,'payment','payment_page','index.tpl','Payment Gateway Control Panel','admin','','','',396,NULL),('/listing-rating/',NULL,'rating','listing_rating','index.tpl','Listing Rating','admin','','','',399,NULL),('/change-password/',NULL,'users','change_password','index.tpl','Change Password','user','N;','','',406,NULL),('/users/delete-uploaded-file/',1,'users','delete_uploaded_file','index.tpl','Delete Uploaded File','user','N;','','',408,NULL),('/add-user/',1,'users','add_user','index.tpl','Add User','admin','N;','','',409,NULL),('/states/',1,'classifieds','browse','','','user','a:3:{s:11:\"level1Field\";s:5:\"State\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','','',416,NULL),('/export-users/',NULL,'users','export_users','index.tpl','Export Users','admin','N;','','',417,NULL),('/export-listings/',NULL,'classifieds','export_listings','index.tpl','Export Listings','admin','','','',418,NULL),('/edit-listing-field/edit-fields/',NULL,'classifieds','edit_complex_fields','index.tpl','Edit Fields','admin','','','',419,NULL),('/classifieds/delete-uploaded-file/',1,'classifieds','delete_uploaded_file','index.tpl','Delete Uploaded File','user','N;','','',433,NULL),('/edit-profile/',NULL,'sub_admins','edit_profile','','','admin','','','',439,NULL),('/task-scheduler/',NULL,'miscellaneous','task_scheduler','empty.tpl','Run Task Scheduler','user','','','',440,NULL),('/job-preview/',1,'classifieds','display_my_listing','','Job Preview','user','a:1:{s:16:\"display_template\";s:15:\"display_job.tpl\";}','','',444,NULL),('/resume-preview/',1,'classifieds','display_my_listing','','Resume Preview','user','a:1:{s:16:\"display_template\";s:18:\"display_resume.tpl\";}','','',445,NULL),('/users/delete-uploaded-file/',NULL,'users','delete_uploaded_file','index.tpl','Delete Uploaded File','admin','','','',447,NULL),('/countries/',1,'classifieds','browse','','','user','a:3:{s:11:\"level1Field\";s:7:\"Country\";s:15:\"listing_type_id\";s:3:\"Job\";s:6:\"parent\";s:8:\"Location\";}','','',451,NULL),('/products/',NULL,'payment','products','index.tpl','Products','admin','','','',453,NULL),('/add-product/',NULL,'payment','add_product','index.tpl','Add Product','admin','','','',454,NULL),('/edit-product/',NULL,'payment','edit_product','index.tpl','Edit Product','admin','','','',458,NULL),('/products/',0,'payment','user_products','index.tpl','Products','user','N;','','',461,NULL),('/shopping-cart/',0,'payment','shopping_cart','index.tpl','Checkout','user','N;','','',463,NULL),('/user-products/',NULL,'payment','user_product','index.tpl','User Products','admin','a:1:{s:4:\"page\";s:13:\"user_products\";}','','',465,NULL),('/add-user-product/',NULL,'payment','user_product','empty.tpl','','admin','a:1:{s:4:\"page\";s:11:\"add_product\";}','','',466,NULL),('/promotions/',NULL,'payment','manage_promotions','index.tpl','Manage Promotions','admin','','','',476,NULL),('/add-promotion-code/',NULL,'payment','manage_promotions','index.tpl','Add New Promotion Code','admin','a:1:{s:6:\"action\";s:3:\"add\";}','','',477,NULL),('/edit-promotion-code/',NULL,'payment','manage_promotions','index.tpl','Edit Promotion Code','admin','a:1:{s:6:\"action\";s:4:\"edit\";}','','',478,NULL),('/edit-email-templates/',1,'template_manager','edit_email_templates','index.tpl','','admin','','','',483,NULL),('/edit-email-templates/delete-uploaded-file/',1,'template_manager','delete_uploaded_file','','Delete Uploaded File','admin','','','',485,NULL),('/wysiwyg/',1,'miscellaneous','wysiwyg','','','admin','','','',499,NULL),('/employer-products/',0,'payment','user_products','','Pricing','user','a:1:{s:11:\"userGroupID\";s:8:\"Employer\";}','','',500,NULL),('/jobseeker-products/',0,'payment','user_products','','Pricing','user','a:1:{s:11:\"userGroupID\";s:9:\"JobSeeker\";}','','',501,NULL),('/update-to-new-version/',NULL,'miscellaneous','update_to_new_version','','Update to new version','admin','','','',502,NULL),('/manage-employers/',NULL,'users','users','','','admin','a:1:{s:14:\"user_group_sid\";s:2:\"41\";}','','',503,NULL),('/manage-jobseekers/',NULL,'users','users','','','admin','a:1:{s:14:\"user_group_sid\";s:2:\"36\";}','','',504,NULL),('/guest-alerts/create/',0,'guest_alerts','create','blank.tpl','Create Guest Alert','user','N;','','',520,NULL),('/guest-alerts/unsubscribe/',0,'guest_alerts','unsubscribe','','Unsubscribe','user','N;','','',523,NULL),('/guest-alerts/',0,'guest_alerts','manage','','Manage Guest Alerts','admin','','','',524,NULL),('/guest-alerts/export/',NULL,'guest_alerts','export','','Export Guest Alerts','admin','','','',525,NULL),('/view-invoice/',NULL,'payment','edit_invoice','','Edit Invoice','admin','N;','','',534,NULL),('/manage-invoices/',NULL,'payment','manage_invoices','','Manage Invoices','admin','N;','','',535,NULL),('/invoice/',1,'payment','invoice','blank.tpl','','user','a:0:{}','','',537,NULL),('/paypal-pro-fill-payment-card/',0,'payment','paypal_pro_fill_payment_card','',NULL,'user','N;',NULL,'',541,NULL),('/promotions/log/',1,'payment','promotions_log','','Promotions Log','admin','','','',550,NULL),('/statistics/promotions/',NULL,'statistics','promotions','','Promotions Statistics','admin','','','',551,NULL),('/manage-jobs/',NULL,'classifieds','manage_listings','index.tpl','Manage Jobs','admin','a:1:{s:16:\"listing_type_sid\";s:1:\"6\";}','','',556,NULL),('/manage-resumes/',NULL,'classifieds','manage_listings','index.tpl','Manage Resumes','admin','a:1:{s:16:\"listing_type_sid\";s:1:\"7\";}','','',557,NULL),('/edit-job/',1,'classifieds','edit_listing','','Edit Job','user','s:0:\"\";','','',558,NULL),('/edit-resume/',1,'classifieds','edit_listing','','Edit Resume','user','s:0:\"\";','','',560,NULL),('/manage-resume/',1,'classifieds','manage_listing','','Manage Resume','user','s:0:\"\";','','',561,NULL),('/social-media/',1,'social_media','social_media','index.tpl','','admin','a:0:{};','','',562,NULL),('/manage-users/',1,'users','users','','','admin','s:0:\"\";','','',568,NULL),('/products/employer/',NULL,'payment','products','index.tpl','Products','admin','a:1:{s:13:\"user_group_id\";s:8:\"Employer\";}','','',569,NULL),('/products/jobseeker/',NULL,'payment','products','index.tpl','Products','admin','a:1:{s:13:\"user_group_id\";s:9:\"JobSeeker\";}','','',570,NULL),('/backfilling/',NULL,'miscellaneous','plugins',NULL,'Job Backfilling','admin','',NULL,'',571,NULL),('/customize-theme/',NULL,'template_manager','customize_theme','index.tpl','','admin','','','',572,NULL),('/navigation-menu/',NULL,'template_manager','navigation_menu','index.tpl','','admin','','','',573,NULL),('/blog/',1,'blog','blog','index.tpl','Blog','user','','','',574,NULL),('/blog/',1,'blog','blog','index.tpl','Blog','admin','','','',575,NULL),('/feeds/',1,'classifieds','listing_feeds','empty.tpl','Listing Feeds','user','a:0:{}','','',576,NULL),('/custom-fields/',NULL,'miscellaneous','custom_fields',NULL,'Custom Fields','admin','',NULL,'',577,NULL),('/admins/',NULL,'miscellaneous','admins',NULL,'Site Admins','admin','',NULL,'',578,NULL);
722/*!40000 ALTER TABLE `pages` ENABLE KEYS */;
723UNLOCK TABLES;
724
725--
726-- Table structure for table `parsers`
727--
728
729DROP TABLE IF EXISTS `parsers`;
730/*!40101 SET @saved_cs_client = @@character_set_client */;
731/*!40101 SET character_set_client = utf8 */;
732CREATE TABLE `parsers` (
733 `id` int(11) NOT NULL AUTO_INCREMENT,
734 `type_id` int(11) NOT NULL DEFAULT '0',
735 `name` varchar(100) DEFAULT NULL,
736 `description` text NOT NULL,
737 `url` text NOT NULL,
738 `usr_id` int(11) NOT NULL DEFAULT '0',
739 `usr_name` varchar(255) DEFAULT NULL,
740 `maper` text,
741 `default_value` text,
742 `maper_user` text,
743 `default_value_user` text,
744 `xml` text NOT NULL,
745 `active` tinyint(3) NOT NULL DEFAULT '0',
746 `add_new_user` tinyint(1) NOT NULL DEFAULT '0',
747 `username` varchar(255) NOT NULL,
748 `external_id` varchar(255) DEFAULT '0',
749 `product_sid` int(10) unsigned DEFAULT NULL,
750 `import_type` varchar(20) NOT NULL DEFAULT 'increment',
751 PRIMARY KEY (`id`),
752 KEY `type_id` (`type_id`),
753 KEY `active` (`active`),
754 KEY `usr_id` (`usr_id`)
755) ENGINE=MyISAM DEFAULT CHARSET=utf8;
756/*!40101 SET character_set_client = @saved_cs_client */;
757
758--
759-- Dumping data for table `parsers`
760--
761
762LOCK TABLES `parsers` WRITE;
763/*!40000 ALTER TABLE `parsers` DISABLE KEYS */;
764/*!40000 ALTER TABLE `parsers` ENABLE KEYS */;
765UNLOCK TABLES;
766
767--
768-- Table structure for table `payment_gateways`
769--
770
771DROP TABLE IF EXISTS `payment_gateways`;
772/*!40101 SET @saved_cs_client = @@character_set_client */;
773/*!40101 SET character_set_client = utf8 */;
774CREATE TABLE `payment_gateways` (
775 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
776 `id` varchar(64) NOT NULL DEFAULT '',
777 `name` varchar(255) DEFAULT NULL,
778 `caption` varchar(255) DEFAULT NULL,
779 `active` tinyint(4) DEFAULT NULL,
780 `position` int(11) DEFAULT NULL,
781 PRIMARY KEY (`sid`),
782 KEY `id` (`id`),
783 KEY `active` (`active`)
784) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
785/*!40101 SET character_set_client = @saved_cs_client */;
786
787--
788-- Dumping data for table `payment_gateways`
789--
790
791LOCK TABLES `payment_gateways` WRITE;
792/*!40000 ALTER TABLE `payment_gateways` DISABLE KEYS */;
793INSERT INTO `payment_gateways` VALUES (1,'2checkout','2Checkout','2Checkout',0,5),(2,'authnet_sim','Authorize.Net','Credit Card',0,4),(4,'paypal_standard','PayPal Standard','PayPal',0,2),(7,'paypal_pro','PayPal Pro','Credit Card',0,3),(8,'stripe','Stripe','Credit Card',0,0),(9,'invoice','Invoice','Pay by Invoice',1,6),(10,'paypal_express','PayPal Express','PayPal',0,1);
794/*!40000 ALTER TABLE `payment_gateways` ENABLE KEYS */;
795UNLOCK TABLES;
796
797--
798-- Table structure for table `payment_gateways_properties`
799--
800
801DROP TABLE IF EXISTS `payment_gateways_properties`;
802/*!40101 SET @saved_cs_client = @@character_set_client */;
803/*!40101 SET character_set_client = utf8 */;
804CREATE TABLE `payment_gateways_properties` (
805 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
806 `object_sid` int(10) unsigned DEFAULT NULL,
807 `id` varchar(255) DEFAULT NULL,
808 `value` text,
809 `add_parameter` varchar(255) DEFAULT NULL,
810 PRIMARY KEY (`sid`),
811 UNIQUE KEY `object_sid` (`object_sid`,`id`),
812 KEY `id` (`id`),
813 KEY `add_parameter` (`add_parameter`)
814) ENGINE=MyISAM AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
815/*!40101 SET character_set_client = @saved_cs_client */;
816
817--
818-- Dumping data for table `payment_gateways_properties`
819--
820
821LOCK TABLES `payment_gateways_properties` WRITE;
822/*!40000 ALTER TABLE `payment_gateways_properties` DISABLE KEYS */;
823INSERT INTO `payment_gateways_properties` VALUES (7,1,'2co_account_id','',''),(8,1,'secret_word','',''),(9,1,'demo','1',''),(10,4,'paypal_account_email','',''),(11,4,'currency_code','USD',''),(12,4,'use_sandbox','1',''),(13,2,'authnet_api_login_id','',''),(14,2,'authnet_api_transaction_key','',''),(15,2,'authnet_api_md5_hash_value','',''),(16,2,'currency_code','USD',''),(17,2,'authnet_use_test_account','1',''),(27,1,'2co_api_user_login','',''),(28,1,'2co_api_user_password','',''),(48,7,'country','US',''),(49,1,'sandbox','0',''),(50,7,'user_name','',''),(51,7,'user_password','',''),(52,7,'user_signature','',''),(53,7,'use_sandbox','1',''),(55,9,'mark_as_paid','0',''),(56,9,'payment_instructions','Payment instructions','');
824/*!40000 ALTER TABLE `payment_gateways_properties` ENABLE KEYS */;
825UNLOCK TABLES;
826
827--
828-- Table structure for table `permissions`
829--
830
831DROP TABLE IF EXISTS `permissions`;
832/*!40101 SET @saved_cs_client = @@character_set_client */;
833/*!40101 SET character_set_client = utf8 */;
834CREATE TABLE `permissions` (
835 `id` int(11) NOT NULL AUTO_INCREMENT,
836 `type` varchar(255) NOT NULL,
837 `name` varchar(255) NOT NULL,
838 `role` varchar(255) NOT NULL,
839 `value` varchar(255) NOT NULL,
840 `params` varchar(255) DEFAULT NULL,
841 `message` text,
842 PRIMARY KEY (`id`),
843 KEY `type` (`type`),
844 KEY `name` (`name`),
845 KEY `role` (`role`)
846) ENGINE=MyISAM AUTO_INCREMENT=328495 DEFAULT CHARSET=utf8;
847/*!40101 SET character_set_client = @saved_cs_client */;
848
849--
850-- Dumping data for table `permissions`
851--
852
853LOCK TABLES `permissions` WRITE;
854/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
855INSERT INTO `permissions` VALUES (325469,'product','post_job','10','inherit','',''),(325470,'product','post_resume','10','allow','3',''),(325473,'contract','post_resume','1','allow','3',NULL),(325474,'contract','post_job','1','inherit','',NULL),(325503,'contract','post_resume','5','allow','3',NULL),(325504,'contract','post_job','5','inherit','',NULL),(326669,'product','post_job','5','inherit','',''),(326670,'product','post_resume','5','inherit','',''),(326699,'product','post_job','4','allow','10',''),(326700,'product','post_resume','4','inherit','',''),(326759,'product','post_job','2','allow','',''),(326760,'product','post_resume','2','inherit','',''),(327119,'product','post_job','11','allow','',''),(327120,'product','post_resume','11','inherit','',''),(327359,'product','post_job','9','inherit','',''),(327360,'product','post_resume','9','allow','',''),(327838,'product','post_job','7','allow','10',''),(327839,'product','post_resume','7','inherit','',''),(328168,'product','post_job','1','allow','',''),(328169,'product','post_resume','1','inherit','',''),(328258,'product','post_job','3','inherit','',''),(328259,'product','post_resume','3','inherit','',''),(328378,'group','post_job','36','','',''),(328379,'group','post_resume','36','','',''),(328408,'group','post_job','41','','',''),(328409,'group','post_resume','41','','',''),(328465,'guest','post_job','guest','',NULL,NULL),(328466,'guest','post_resume','guest','',NULL,NULL),(328467,'product','resume_access','12','allow','',''),(328469,'product','post_job','12','deny','',''),(328470,'product','post_resume','12','inherit','',''),(328475,'product','resume_access','13','','',''),(328477,'product','post_job','13','allow','',''),(328478,'product','post_resume','13','inherit','',''),(328491,'product','resume_access','8','','',''),(328493,'product','post_job','8','inherit','',''),(328494,'product','post_resume','8','allow','1','');
856/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
857UNLOCK TABLES;
858
859--
860-- Table structure for table `posting_pages`
861--
862
863DROP TABLE IF EXISTS `posting_pages`;
864/*!40101 SET @saved_cs_client = @@character_set_client */;
865/*!40101 SET character_set_client = utf8 */;
866CREATE TABLE `posting_pages` (
867 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
868 `page_id` varchar(255) DEFAULT NULL,
869 `page_name` varchar(255) DEFAULT NULL,
870 `description` text,
871 `listing_type_sid` int(10) DEFAULT NULL,
872 `order` int(10) NOT NULL DEFAULT '0',
873 PRIMARY KEY (`sid`)
874) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;
875/*!40101 SET character_set_client = @saved_cs_client */;
876
877--
878-- Dumping data for table `posting_pages`
879--
880
881LOCK TABLES `posting_pages` WRITE;
882/*!40000 ALTER TABLE `posting_pages` DISABLE KEYS */;
883INSERT INTO `posting_pages` VALUES (11,'PostJob','Job','',6,2),(19,'General','Resume','',7,1);
884/*!40000 ALTER TABLE `posting_pages` ENABLE KEYS */;
885UNLOCK TABLES;
886
887--
888-- Table structure for table `products`
889--
890
891DROP TABLE IF EXISTS `products`;
892/*!40101 SET @saved_cs_client = @@character_set_client */;
893/*!40101 SET character_set_client = utf8 */;
894CREATE TABLE `products` (
895 `sid` int(11) unsigned NOT NULL AUTO_INCREMENT,
896 `name` varchar(255) DEFAULT NULL,
897 `detailed_description` text,
898 `user_group_sid` int(11) DEFAULT NULL,
899 `availability_from` datetime DEFAULT NULL,
900 `availability_to` datetime DEFAULT NULL,
901 `trial` tinyint(1) NOT NULL DEFAULT '0',
902 `active` tinyint(1) NOT NULL DEFAULT '0',
903 `serialized_extra_info` text,
904 `order` int(11) NOT NULL DEFAULT '1',
905 `number_of_postings` int(11) NOT NULL DEFAULT '0',
906 `recurring` tinyint(4) NOT NULL DEFAULT '0',
907 `deleted` tinyint(1) NOT NULL DEFAULT '0',
908 PRIMARY KEY (`sid`),
909 KEY `name` (`name`),
910 KEY `user_group_sid` (`user_group_sid`),
911 KEY `availability_from` (`availability_from`),
912 KEY `availability_to` (`availability_to`),
913 KEY `trial` (`trial`),
914 KEY `active` (`active`),
915 KEY `order` (`order`),
916 KEY `deleted` (`deleted`)
917) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
918/*!40101 SET character_set_client = @saved_cs_client */;
919
920--
921-- Dumping data for table `products`
922--
923
924LOCK TABLES `products` WRITE;
925/*!40000 ALTER TABLE `products` DISABLE KEYS */;
926INSERT INTO `products` VALUES (8,'Free Resume Posting','<p>- Resume Posting for 1 month;</p>\r\n<p>- Efficient Resume Management;</p>\r\n<p>- Upgrade to Priority Resume;</p>\r\n<p>- Many more...</p>',36,NULL,NULL,0,1,'a:9:{s:16:\"listing_type_sid\";s:1:\"7\";s:5:\"price\";s:4:\"0.00\";s:11:\"post_resume\";s:1:\"1\";s:18:\"number_of_listings\";s:1:\"1\";s:16:\"listing_duration\";s:2:\"30\";s:8:\"featured\";s:1:\"0\";s:13:\"resume_access\";s:0:\"\";s:17:\"expiration_period\";s:1:\"0\";s:7:\"default\";N;}',3,1,0,0),(13,'Free job posting','',41,NULL,NULL,0,1,'a:10:{s:16:\"listing_type_sid\";s:1:\"6\";s:5:\"price\";s:4:\"0.00\";s:8:\"post_job\";s:1:\"1\";s:18:\"number_of_listings\";s:0:\"\";s:16:\"listing_duration\";s:2:\"30\";s:8:\"featured\";s:1:\"0\";s:17:\"featured_employer\";s:1:\"0\";s:13:\"resume_access\";s:1:\"0\";s:17:\"expiration_period\";s:0:\"\";s:7:\"default\";N;}',2,0,0,0);
927/*!40000 ALTER TABLE `products` ENABLE KEYS */;
928UNLOCK TABLES;
929
930--
931-- Table structure for table `promotions`
932--
933
934DROP TABLE IF EXISTS `promotions`;
935/*!40101 SET @saved_cs_client = @@character_set_client */;
936/*!40101 SET character_set_client = utf8 */;
937CREATE TABLE `promotions` (
938 `sid` int(11) unsigned NOT NULL AUTO_INCREMENT,
939 `code` varchar(255) DEFAULT NULL,
940 `discount` float DEFAULT NULL,
941 `type` enum('percentage','fixed') NOT NULL DEFAULT 'fixed',
942 `product_sid` text,
943 `maximum_uses` int(11) DEFAULT '0',
944 `start_date` datetime DEFAULT NULL,
945 `end_date` datetime DEFAULT NULL,
946 `active` tinyint(4) NOT NULL DEFAULT '0',
947 PRIMARY KEY (`sid`)
948) ENGINE=MyISAM DEFAULT CHARSET=utf8;
949/*!40101 SET character_set_client = @saved_cs_client */;
950
951--
952-- Dumping data for table `promotions`
953--
954
955LOCK TABLES `promotions` WRITE;
956/*!40000 ALTER TABLE `promotions` DISABLE KEYS */;
957/*!40000 ALTER TABLE `promotions` ENABLE KEYS */;
958UNLOCK TABLES;
959
960--
961-- Table structure for table `promotions_history`
962--
963
964DROP TABLE IF EXISTS `promotions_history`;
965/*!40101 SET @saved_cs_client = @@character_set_client */;
966/*!40101 SET character_set_client = utf8 */;
967CREATE TABLE `promotions_history` (
968 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
969 `user_sid` int(10) unsigned DEFAULT NULL,
970 `code_sid` int(10) unsigned DEFAULT NULL,
971 `invoice_sid` int(10) unsigned DEFAULT NULL,
972 `product_sid` varchar(255) DEFAULT NULL,
973 `date` datetime DEFAULT NULL,
974 `code_info` text,
975 `amount` float DEFAULT NULL,
976 `paid` tinyint(1) NOT NULL DEFAULT '0',
977 PRIMARY KEY (`sid`),
978 UNIQUE KEY `user_sid` (`user_sid`,`code_sid`,`invoice_sid`)
979) ENGINE=MyISAM DEFAULT CHARSET=utf8;
980/*!40101 SET character_set_client = @saved_cs_client */;
981
982--
983-- Dumping data for table `promotions_history`
984--
985
986LOCK TABLES `promotions_history` WRITE;
987/*!40000 ALTER TABLE `promotions_history` DISABLE KEYS */;
988/*!40000 ALTER TABLE `promotions_history` ENABLE KEYS */;
989UNLOCK TABLES;
990
991--
992-- Table structure for table `refine_search`
993--
994
995DROP TABLE IF EXISTS `refine_search`;
996/*!40101 SET @saved_cs_client = @@character_set_client */;
997/*!40101 SET character_set_client = utf8 */;
998CREATE TABLE `refine_search` (
999 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
1000 `field_id` int(10) NOT NULL,
1001 `listing_type_sid` int(10) NOT NULL,
1002 `order` int(10) NOT NULL DEFAULT '0',
1003 `user_field` tinyint(1) NOT NULL DEFAULT '0',
1004 PRIMARY KEY (`id`),
1005 KEY `field_id` (`field_id`),
1006 KEY `listing_type_sid` (`listing_type_sid`),
1007 KEY `order` (`order`),
1008 KEY `user_field` (`user_field`)
1009) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;
1010/*!40101 SET character_set_client = @saved_cs_client */;
1011
1012--
1013-- Dumping data for table `refine_search`
1014--
1015
1016LOCK TABLES `refine_search` WRITE;
1017/*!40000 ALTER TABLE `refine_search` DISABLE KEYS */;
1018INSERT INTO `refine_search` VALUES (6,216,6,2,0),(8,198,7,5,0),(10,216,7,3,0),(11,213,7,7,0),(14,199,6,10,0),(33,198,6,8,0),(38,199,7,6,0);
1019/*!40000 ALTER TABLE `refine_search` ENABLE KEYS */;
1020UNLOCK TABLES;
1021
1022--
1023-- Table structure for table `relations_listing_fields_posting_pages`
1024--
1025
1026DROP TABLE IF EXISTS `relations_listing_fields_posting_pages`;
1027/*!40101 SET @saved_cs_client = @@character_set_client */;
1028/*!40101 SET character_set_client = utf8 */;
1029CREATE TABLE `relations_listing_fields_posting_pages` (
1030 `sid` int(10) NOT NULL AUTO_INCREMENT,
1031 `field_sid` int(10) NOT NULL,
1032 `page_sid` int(10) NOT NULL,
1033 `listing_type_sid` int(10) NOT NULL,
1034 `order` int(10) NOT NULL,
1035 PRIMARY KEY (`sid`),
1036 KEY `field_sid` (`field_sid`),
1037 KEY `page_sid` (`page_sid`),
1038 KEY `listing_type_sid` (`listing_type_sid`),
1039 KEY `order` (`order`)
1040) ENGINE=MyISAM AUTO_INCREMENT=409 DEFAULT CHARSET=utf8;
1041/*!40101 SET character_set_client = @saved_cs_client */;
1042
1043--
1044-- Dumping data for table `relations_listing_fields_posting_pages`
1045--
1046
1047LOCK TABLES `relations_listing_fields_posting_pages` WRITE;
1048/*!40000 ALTER TABLE `relations_listing_fields_posting_pages` DISABLE KEYS */;
1049INSERT INTO `relations_listing_fields_posting_pages` VALUES (43,199,19,7,5),(48,224,19,7,8),(50,367,19,7,4),(143,198,19,7,6),(174,218,19,7,9),(179,198,11,6,7),(180,199,11,6,4),(181,203,11,6,2),(185,197,11,6,1),(191,319,19,7,18),(229,234,11,6,14),(393,359,11,6,9),(394,359,19,7,15),(395,359,25,17,5),(396,359,26,21,5),(397,359,28,22,5),(398,359,29,23,6),(399,359,34,24,5),(400,360,11,6,15),(401,273,19,7,20),(403,274,19,7,19),(405,362,19,7,1),(406,363,19,7,16),(407,364,19,7,14),(408,364,11,6,12);
1050/*!40000 ALTER TABLE `relations_listing_fields_posting_pages` ENABLE KEYS */;
1051UNLOCK TABLES;
1052
1053--
1054-- Table structure for table `session`
1055--
1056
1057DROP TABLE IF EXISTS `session`;
1058/*!40101 SET @saved_cs_client = @@character_set_client */;
1059/*!40101 SET character_set_client = utf8 */;
1060CREATE TABLE `session` (
1061 `session_id` varchar(255) NOT NULL,
1062 `user_sid` int(11) NOT NULL,
1063 `time` int(11) NOT NULL,
1064 `data` longtext NOT NULL,
1065 PRIMARY KEY (`session_id`),
1066 KEY `time` (`time`),
1067 KEY `user_sid` (`user_sid`)
1068) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1069/*!40101 SET character_set_client = @saved_cs_client */;
1070
1071--
1072-- Dumping data for table `session`
1073--
1074
1075LOCK TABLES `session` WRITE;
1076/*!40000 ALTER TABLE `session` DISABLE KEYS */;
1077/*!40000 ALTER TABLE `session` ENABLE KEYS */;
1078UNLOCK TABLES;
1079
1080--
1081-- Table structure for table `settings`
1082--
1083
1084DROP TABLE IF EXISTS `settings`;
1085/*!40101 SET @saved_cs_client = @@character_set_client */;
1086/*!40101 SET character_set_client = utf8 */;
1087CREATE TABLE `settings` (
1088 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1089 `name` varchar(255) DEFAULT NULL,
1090 `value` text,
1091 PRIMARY KEY (`sid`),
1092 KEY `name` (`name`)
1093) ENGINE=MyISAM AUTO_INCREMENT=1238 DEFAULT CHARSET=utf8;
1094/*!40101 SET character_set_client = @saved_cs_client */;
1095
1096--
1097-- Dumping data for table `settings`
1098--
1099
1100LOCK TABLES `settings` WRITE;
1101/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
1102INSERT INTO `settings` VALUES (13,'system_email',''),(15,'i18n_default_language','en'),(16,'i18n_default_domain','Frontend'),(18,'escape_html_tags','htmlpurifier'),(19,'radius_search_unit','miles'),(20,'file_valid_types','doc,docx,png,jpg,gif,xls,xlsx,pdf,avi,wmv,mpg,3gp,flv'),(35,'transaction_currency','USD'),(37,'TEMPLATE_USER_THEME','Bootstrap'),(38,'TEMPLATE_ADMIN_THEME','default'),(40,'DEFAULT_PAGE_TEMPLATE','index.tpl'),(50,'htmltags','a:47:{s:1:\"a\";s:0:\"\";s:7:\"address\";s:0:\"\";s:1:\"b\";s:0:\"\";s:2:\"br\";s:0:\"\";s:3:\"big\";s:0:\"\";s:10:\"blockquote\";s:0:\"\";s:7:\"caption\";s:0:\"\";s:4:\"cite\";s:0:\"\";s:4:\"code\";s:0:\"\";s:3:\"del\";s:0:\"\";s:3:\"div\";s:0:\"\";s:2:\"em\";s:0:\"\";s:4:\"font\";s:0:\"\";s:2:\"h1\";s:0:\"\";s:2:\"h2\";s:0:\"\";s:2:\"h3\";s:0:\"\";s:2:\"h4\";s:0:\"\";s:2:\"h5\";s:0:\"\";s:2:\"h6\";s:0:\"\";s:2:\"hr\";s:0:\"\";s:1:\"i\";s:0:\"\";s:3:\"img\";s:0:\"\";s:3:\"ins\";s:0:\"\";s:3:\"kbd\";s:0:\"\";s:2:\"li\";s:0:\"\";s:2:\"ol\";s:0:\"\";s:1:\"p\";s:0:\"\";s:3:\"pre\";s:0:\"\";s:1:\"q\";s:0:\"\";s:4:\"samp\";s:0:\"\";s:5:\"small\";s:0:\"\";s:4:\"span\";s:0:\"\";s:6:\"strike\";s:0:\"\";s:6:\"strong\";s:0:\"\";s:3:\"sub\";s:0:\"\";s:3:\"sup\";s:0:\"\";s:5:\"table\";s:0:\"\";s:5:\"thead\";s:0:\"\";s:5:\"tbody\";s:0:\"\";s:5:\"tfoot\";s:0:\"\";s:2:\"tr\";s:0:\"\";s:2:\"td\";s:0:\"\";s:2:\"th\";s:0:\"\";s:2:\"tt\";s:0:\"\";s:1:\"u\";s:0:\"\";s:2:\"ul\";s:0:\"\";s:3:\"var\";s:0:\"\";}'),(51,'htmlFilter','<a>,<address>,<b>,<br>,<br/>,<br />,<big>,<blockquote>,<caption>,<cite>,<code>,<del>,<div>,<em>,<font>,<h1>,<h2>,<h3>,<h4>,<h5>,<h6>,<hr>,<i>,<img>,<ins>,<kbd>,<li>,<ol>,<p>,<pre>,<q>,<samp>,<small>,<span>,<strike>,<strong>,<sub>,<sup>,<table>,<thead>,<tbody>,<tfoot>,<tr>,<td>,<th>,<tt>,<u>,<ul>,<var>'),(52,'smtp','3'),(53,'smtp_port',''),(54,'smtp_host',''),(55,'smtp_username','admin'),(56,'smtp_password','adminpass'),(57,'smtp_sender',''),(58,'sendmail_path','/usr/sbin/sendmail'),(59,'smtp_security','none'),(61,'site_title','SmartJobBoard'),(67,'action','save_settings'),(75,'turn_on_refine_search_Resume','1'),(76,'turn_on_refine_search_Job','1'),(77,'error_control_mode','debug'),(86,'jobg8_wsdl_url','http://upload.testing.jobg8.com/AdvertUploadWebService.asmx?WSDL'),(90,'applications_jobg8_company_name_filter','0'),(91,'applications_jobg8_company_list','company 1\r\ncompany 2\r\nFusionCompany'),(105,'display_on_resume_page','1'),(106,'display_on_job_page','1'),(108,'maintenance_mode','0'),(109,'maintenance_mode_ip',''),(110,'count_listings','3'),(113,'IndeedPublisherID','6053709130975284'),(117,'refine_search_items_limit','20'),(119,'automatically_delete_expired_listings','1'),(120,'period_delete_expired_listings','10'),(121,'captcha_type','kCaptcha'),(142,'IndeedSiteType',''),(143,'IndeedJobType',''),(146,'lType',''),(147,'li_apiKey','77oi743bav9ehl'),(148,'li_secKey','UTUREXr0moeJ2RJc'),(171,'Keywords','IS_EMPTY'),(186,'submit','save'),(187,'page','#generalTab'),(192,'numberOfPageViewsToExecCronIfExceeded','50'),(196,'number_emails','2'),(197,'time_sending_emails','1313606116'),(198,'send_emails','2'),(202,'username','admin'),(203,'password','admin'),(209,'applications_jobg8_product_filter','0'),(210,'applications_jobg8_product_list',''),(211,'applications_jobg8_job_category_filter','0'),(214,'IndeedCountry','us'),(318,'enable_promotion_codes','1'),(355,'num_of_listings_sent_in_email_alerts','20'),(356,'mc_apikey',''),(357,'mc_listId',''),(698,'enableCache','0'),(700,'cacheHours','2'),(701,'cacheMinutes','0'),(741,'tax',''),(752,'profiler','0'),(758,'google_TrackingID',''),(955,'send_payment_to','SmartJobBoard'),(988,'task_scheduler_last_executed_time_hourly',NULL),(989,'task_scheduler_last_executed_time_daily',NULL),(1051,'timezone','America/New_York'),(1069,'jobG8BuyApplicationsStatus','1'),(1075,'facebookAppPages','a:0:{};'),(1078,'domain',''),(1079,'signup_employer_linkedin','0'),(1080,'signup_employer_facebook','0'),(1082,'public_resume_access','1'),(1083,'signup_jobseeker_linkedin','0'),(1084,'signup_jobseeker_facebook','0'),(1086,'home_page_title',''),(1087,'home_page_description',''),(1088,'search_by_radius','1'),(1090,'location_limit',''),(1091,'google_api_key','AIzaSyA_O3Q44rnb58PetTaYnx65CMftFND0qls'),(1092,'search_by_location','1'),(1101,'theme_font_Bootstrap','\"Fira Sans\", sans-serif'),(1102,'theme_logo_Bootstrap','logo.svg'),(1103,'theme_favicon_Bootstrap','favicon.ico'),(1104,'theme_main_banner_text_Bootstrap','<h1>Search <span style=\"color:#FFFFFF\">$listings_types.Job</span> live jobs</h1>\r\n<p>Finding your new job just got easier</p>'),(1105,'theme_secondary_banner_text_Bootstrap','<h3>POST YOUR JOB TODAY</h3>\r\n<div>Job seekers will be able to find<br />your first-class job</div><a class=\"btn btn__yellow btn__bold btn-post-job\" href=\"$GLOBALS.site_url/add-listing/?listing_type_id=Job\">Post a Job</a>'),(1111,'theme_custom_css_Bootstrap',''),(1112,'theme_custom_js_Bootstrap',''),(1113,'theme_footer_Bootstrap','<div><div><ul><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/\">Home</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/contact/\">Contact</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/about/\">About Us </a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/terms-of-use/\">Terms & Conditions</a></li></ul></div>\r\n<div><ul><li>Employer</li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/add-listing/?listing_type_id=Job\">Post a Job</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/resumes/\">Search Resumes</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/login/\">Sign in</a></li></ul></div>\r\n<div><ul><li>Job Seeker</li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/jobs/\">Find Jobs</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/add-listing/?listing_type_id=Resume\">Create Resume</a></li><li><a class=\"footer-nav__link\" href=\"$GLOBALS.site_url/login/\">Sign in</a></li></ul></div>\r\n<div><ul><li><a class=\"footer-nav__link footer-nav__link-social footer-nav__link-facebook\" href=\"\">Facebook</a></li><li><a class=\"footer-nav__link footer-nav__link-social footer-nav__link-twitter\" href=\"#\">Twitter</a></li><li><a class=\"footer-nav__link footer-nav__link-social footer-nav__link-plus\" href=\"#\">Google Plus</a></li><li><a class=\"footer-nav__link footer-nav__link-social footer-nav__link-in\" href=\"#\">LinkedIn</a></li></ul></div></div>\r\n<div>© 2008-$current_year Powered by <a href=\"http://www.smartjobboard.com\" target=\"_blank\" title=\"Job Board Software, Script\">SmartJobBoard Job Board Software</a></div>'),(1114,'theme_jobs_by_category_Bootstrap','1'),(1115,'theme_jobs_by_city_Bootstrap','1'),(1116,'theme_jobs_by_country_Bootstrap','0'),(1117,'theme_jobs_by_state_Bootstrap','1'),(1118,'theme_bottom_section_html_Bootstrap','<h3>Sign up for job alerts</h3>\r\n<div>Get job alerts straight to your inbox.</div>\r\n<div>Enter your email to get started. You will be able to unsubscribe at any moment.</div>'),(1120,'theme_button_color_1_Bootstrap','#419dd4'),(1121,'theme_button_color_2_Bootstrap','#ff6a50'),(1122,'theme_button_color_3_Bootstrap','#ffe15e'),(1124,'theme_main_banner_Bootstrap','top-banner.png'),(1125,'theme_secondary_banner_Bootstrap','post-a-job.svg'),(1128,'home_page_keywords',''),(1129,'db-patch-google-place-full-text','patched'),(1130,'db-patch-patch-apply_click','patched'),(1131,'db-patch-youtube-facebook-phrases','patched'),(1132,'db-patch-sl-76-more-results','patched'),(1133,'db-patch-locations-service','patched'),(1134,'db-patch-sl-96-themes','patched'),(1135,'db-patch-remove-add-listing-type','patched'),(1136,'IndeedKeywords',''),(1137,'IndeedLocation','Los Angeles'),(1138,'IndeedRadius',''),(1139,'db-patch-SL-49','patched'),(1140,'db-patch-SL-122','patched'),(1141,'db-patch-SL-100','patched'),(1142,'date_format','%b %d, %Y'),(1143,'db-patch-SL-120','patched'),(1144,'db-patch-SL-129','patched'),(1145,'db-patch-SL-119','patched'),(1146,'db-patch-SL-138','patched'),(1147,'db-patch-5.0.3','patched'),(1148,'db-patch-SL-141','patched'),(1149,'db-patch-bounce-emails','patched'),(1150,'db-patch-SL-143-stripe','patched'),(1151,'db-patch-SL-146-invoice-payment','patched'),(1152,'db-patch-SL-154','patched'),(1192,'db-patch-SL-153','patched'),(1193,'db-patch-SL-156','patched'),(1194,'db-patch-SL-161','patched'),(1195,'db-patch-SL-171','patched'),(1196,'db-patch-SL-172','patched'),(1197,'db-patch-5.0.5','patched'),(1198,'db-patch-SL-173','patched'),(1199,'db-patch-SL-194','patched'),(1201,'db-patch-SL-211','patched'),(1202,'db-patch-SL-210','patched'),(1203,'db-patch-SL-200','patched'),(1204,'db-patch-5.0.6','patched'),(1205,'db-patch-SL-219','patched'),(1206,'db-patch-user_session_data_storage','patched'),(1207,'db-patch-SL-223','patched'),(1208,'db-patch-SL-245','patched'),(1209,'db-patch-SL-237','patched'),(1210,'db-patch-tree-cleanup','patched'),(1211,'db-patch-5.0.7','patched'),(1212,'db-patch-SL-232','patched'),(1213,'db-patch-SL-252','patched'),(1214,'db-patch-SL_251','patched'),(1215,'facebook_footer','<p style=\"text-align: right;\">Powered by <a target=\"_top\" href=\"http://www.smartjobboard.com\">SmartJobBoard.com</a></p>'),(1216,'db-patch-SL-274','patched'),(1217,'db-patch-SL-275','patched'),(1218,'db-patch-5.0.8','patched'),(1219,'ZiprecruiterCountry','us'),(1220,'ZiprecruiterRadius','50'),(1221,'db-patch-SL-253','patched'),(1222,'Jobs2careersPublisherId','2552'),(1223,'Jobs2careersPublisherPassword','sCCVSazwPqQR6ANP'),(1224,'db-patch-SL-254','patched'),(1225,'ZiprecruiterApiKey',''),(1226,'enable_backfilling','1'),(1227,'db-patch-5.0.10','patched'),(1228,'db-patch-SL-226','patched'),(1229,'db-patch-5.0.11','patched'),(1230,'db-patch-5.0.12','patched'),(1231,'topresume_audience',''),(1232,'db-patch-SL-314','patched'),(1233,'db-patch-SL-319','patched'),(1234,'db-patch-SJB-317','patched'),(1235,'db-patch-SL-302','patched'),(1236,'db-patch-5.0.13','patched'),(1237,'db-patch-SL-325','patched');
1103/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
1104UNLOCK TABLES;
1105
1106--
1107-- Table structure for table `shopping_cart`
1108--
1109
1110DROP TABLE IF EXISTS `shopping_cart`;
1111/*!40101 SET @saved_cs_client = @@character_set_client */;
1112/*!40101 SET character_set_client = utf8 */;
1113CREATE TABLE `shopping_cart` (
1114 `sid` int(11) unsigned NOT NULL AUTO_INCREMENT,
1115 `user_sid` int(11) DEFAULT NULL,
1116 `product_info` text,
1117 PRIMARY KEY (`sid`)
1118) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1119/*!40101 SET character_set_client = @saved_cs_client */;
1120
1121--
1122-- Dumping data for table `shopping_cart`
1123--
1124
1125LOCK TABLES `shopping_cart` WRITE;
1126/*!40000 ALTER TABLE `shopping_cart` DISABLE KEYS */;
1127/*!40000 ALTER TABLE `shopping_cart` ENABLE KEYS */;
1128UNLOCK TABLES;
1129
1130--
1131-- Table structure for table `task_scheduler_log`
1132--
1133
1134DROP TABLE IF EXISTS `task_scheduler_log`;
1135/*!40101 SET @saved_cs_client = @@character_set_client */;
1136/*!40101 SET character_set_client = utf8 */;
1137CREATE TABLE `task_scheduler_log` (
1138 `sid` int(11) NOT NULL AUTO_INCREMENT,
1139 `last_executed_date` datetime NOT NULL,
1140 `notifieds_sent` int(11) NOT NULL,
1141 `expired_listings` int(11) NOT NULL,
1142 `expired_contracts` int(11) NOT NULL,
1143 `log_text` text NOT NULL,
1144 PRIMARY KEY (`sid`),
1145 KEY `last_executed_date` (`last_executed_date`)
1146) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1147/*!40101 SET character_set_client = @saved_cs_client */;
1148
1149--
1150-- Dumping data for table `task_scheduler_log`
1151--
1152
1153LOCK TABLES `task_scheduler_log` WRITE;
1154/*!40000 ALTER TABLE `task_scheduler_log` DISABLE KEYS */;
1155/*!40000 ALTER TABLE `task_scheduler_log` ENABLE KEYS */;
1156UNLOCK TABLES;
1157
1158--
1159-- Table structure for table `transactions`
1160--
1161
1162DROP TABLE IF EXISTS `transactions`;
1163/*!40101 SET @saved_cs_client = @@character_set_client */;
1164/*!40101 SET character_set_client = utf8 */;
1165CREATE TABLE `transactions` (
1166 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1167 `transaction_id` varchar(255) NOT NULL DEFAULT '',
1168 `user_sid` int(10) DEFAULT NULL,
1169 `invoice_sid` int(10) DEFAULT NULL,
1170 `payment_method` varchar(255) DEFAULT NULL,
1171 `description` text,
1172 `date` date DEFAULT NULL,
1173 `amount` double DEFAULT '0',
1174 PRIMARY KEY (`sid`)
1175) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1176/*!40101 SET character_set_client = @saved_cs_client */;
1177
1178--
1179-- Dumping data for table `transactions`
1180--
1181
1182LOCK TABLES `transactions` WRITE;
1183/*!40000 ALTER TABLE `transactions` DISABLE KEYS */;
1184/*!40000 ALTER TABLE `transactions` ENABLE KEYS */;
1185UNLOCK TABLES;
1186
1187--
1188-- Table structure for table `uploaded_files`
1189--
1190
1191DROP TABLE IF EXISTS `uploaded_files`;
1192/*!40101 SET @saved_cs_client = @@character_set_client */;
1193/*!40101 SET character_set_client = utf8 */;
1194CREATE TABLE `uploaded_files` (
1195 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1196 `id` varchar(255) DEFAULT NULL,
1197 `file_name` varchar(255) DEFAULT NULL,
1198 `file_group` varchar(255) DEFAULT NULL,
1199 `saved_file_name` varchar(255) DEFAULT NULL,
1200 `mime_type` varchar(255) DEFAULT NULL,
1201 `creation_time` varchar(255) DEFAULT NULL,
1202 PRIMARY KEY (`sid`),
1203 KEY `id` (`id`)
1204) ENGINE=MyISAM AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;
1205/*!40101 SET character_set_client = @saved_cs_client */;
1206
1207--
1208-- Dumping data for table `uploaded_files`
1209--
1210
1211LOCK TABLES `uploaded_files` WRITE;
1212/*!40000 ALTER TABLE `uploaded_files` DISABLE KEYS */;
1213INSERT INTO `uploaded_files` VALUES (7,'Logo_6','irg.jpg','pictures','irg_1.jpg','image/jpeg',NULL),(8,'Logo_6_thumb','irg.jpg','pictures','irg_1_thumb.jpg','image/jpeg',NULL),(9,'Logo_4','chilisoft.jpg','pictures','chilisoft_1.jpg','image/jpeg',NULL),(10,'Logo_4_thumb','chilisoft.jpg','pictures','chilisoft_1_thumb.jpg','image/jpeg',NULL),(11,'Logo_5','inventa.jpg','pictures','inventa_1.jpg','image/jpeg',NULL),(12,'Logo_5_thumb','inventa.jpg','pictures','inventa_1_thumb.jpg','image/jpeg',NULL),(13,'Logo_3','Jardini logo_1.jpg','pictures','Jardini logo_1_1.jpg','image/jpeg',NULL),(14,'Logo_3_thumb','Jardini logo_1.jpg','pictures','Jardini logo_1_1_thumb.jpg','image/jpeg',NULL),(17,'Logo_8','logo_emp.jpg','pictures','logo_emp_1.jpg','image/jpeg',NULL),(18,'Logo_8_thumb','logo_emp.jpg','pictures','logo_emp_1_thumb.jpg','image/jpeg',NULL),(21,'Resume_1','test_resume_4.docx','files','test_resume_4_1.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(22,'Resume_3','test_resume_4.docx','files','test_resume_4_2.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(23,'Resume_4','test_resume_4.docx','files','test_resume_4_3.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(25,'Resume_7','test_resume_4.docx','files','test_resume_4_4.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(41,'Resume_15','test_resume_4_2.docx','files','test_resume_4_2_1.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(43,'application_0e277fdc866ebfdc849b68125c9defe9','test_resume_4_2.docx','files','test_resume_4_2_3.docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document',NULL),(54,'Photo_15','tumblr_np40qa7UyM1qex968o1_500.jpg','pictures','tumblr_np40qa7UyM1qex968o1_500_1.png','image/jpeg','1453974284');
1214/*!40000 ALTER TABLE `uploaded_files` ENABLE KEYS */;
1215UNLOCK TABLES;
1216
1217--
1218-- Table structure for table `user_groups`
1219--
1220
1221DROP TABLE IF EXISTS `user_groups`;
1222/*!40101 SET @saved_cs_client = @@character_set_client */;
1223/*!40101 SET character_set_client = utf8 */;
1224CREATE TABLE `user_groups` (
1225 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1226 `id` varchar(255) DEFAULT NULL,
1227 `default_product` int(11) DEFAULT '0',
1228 `name` varchar(255) DEFAULT NULL,
1229 PRIMARY KEY (`sid`),
1230 UNIQUE KEY `ufi` (`id`)
1231) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;
1232/*!40101 SET character_set_client = @saved_cs_client */;
1233
1234--
1235-- Dumping data for table `user_groups`
1236--
1237
1238LOCK TABLES `user_groups` WRITE;
1239/*!40000 ALTER TABLE `user_groups` DISABLE KEYS */;
1240INSERT INTO `user_groups` VALUES (36,'JobSeeker',8,'Job Seeker'),(41,'Employer',13,'Employer');
1241/*!40000 ALTER TABLE `user_groups` ENABLE KEYS */;
1242UNLOCK TABLES;
1243
1244--
1245-- Table structure for table `user_groups_properties`
1246--
1247
1248DROP TABLE IF EXISTS `user_groups_properties`;
1249/*!40101 SET @saved_cs_client = @@character_set_client */;
1250/*!40101 SET character_set_client = utf8 */;
1251CREATE TABLE `user_groups_properties` (
1252 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1253 `object_sid` int(10) unsigned DEFAULT NULL,
1254 `id` varchar(255) DEFAULT NULL,
1255 `value` text,
1256 `add_parameter` varchar(255) DEFAULT NULL,
1257 PRIMARY KEY (`sid`),
1258 UNIQUE KEY `object_sid` (`object_sid`,`id`),
1259 KEY `id` (`id`),
1260 KEY `add_parameter` (`add_parameter`),
1261 FULLTEXT KEY `value` (`value`)
1262) ENGINE=MyISAM AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;
1263/*!40101 SET character_set_client = @saved_cs_client */;
1264
1265--
1266-- Dumping data for table `user_groups_properties`
1267--
1268
1269LOCK TABLES `user_groups_properties` WRITE;
1270/*!40000 ALTER TABLE `user_groups_properties` DISABLE KEYS */;
1271INSERT INTO `user_groups_properties` VALUES (103,36,'notify_on_contract_expiration','22',''),(104,36,'notify_on_listing_activation','13',''),(105,36,'notify_on_listing_expiration','18',''),(107,36,'notify_subscription_activation','24',''),(118,36,'welcome_email','49',''),(124,41,'notify_on_contract_expiration','22',''),(125,41,'notify_on_listing_activation','14',''),(126,41,'notify_on_listing_expiration','17',''),(128,41,'notify_subscription_activation','24',''),(139,41,'welcome_email','48','');
1272/*!40000 ALTER TABLE `user_groups_properties` ENABLE KEYS */;
1273UNLOCK TABLES;
1274
1275--
1276-- Table structure for table `user_profile_field_list`
1277--
1278
1279DROP TABLE IF EXISTS `user_profile_field_list`;
1280/*!40101 SET @saved_cs_client = @@character_set_client */;
1281/*!40101 SET character_set_client = utf8 */;
1282CREATE TABLE `user_profile_field_list` (
1283 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1284 `field_sid` int(10) unsigned DEFAULT NULL,
1285 `order` int(10) unsigned DEFAULT NULL,
1286 `value` varchar(255) DEFAULT NULL,
1287 PRIMARY KEY (`sid`),
1288 KEY `field_sid` (`field_sid`),
1289 KEY `order` (`order`),
1290 KEY `value` (`value`)
1291) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1292/*!40101 SET character_set_client = @saved_cs_client */;
1293
1294--
1295-- Dumping data for table `user_profile_field_list`
1296--
1297
1298LOCK TABLES `user_profile_field_list` WRITE;
1299/*!40000 ALTER TABLE `user_profile_field_list` DISABLE KEYS */;
1300/*!40000 ALTER TABLE `user_profile_field_list` ENABLE KEYS */;
1301UNLOCK TABLES;
1302
1303--
1304-- Table structure for table `user_profile_fields`
1305--
1306
1307DROP TABLE IF EXISTS `user_profile_fields`;
1308/*!40101 SET @saved_cs_client = @@character_set_client */;
1309/*!40101 SET character_set_client = utf8 */;
1310CREATE TABLE `user_profile_fields` (
1311 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1312 `user_group_sid` int(10) unsigned DEFAULT NULL,
1313 `order` int(10) unsigned DEFAULT NULL,
1314 `id` varchar(255) DEFAULT NULL,
1315 `caption` varchar(255) DEFAULT NULL,
1316 `type` varchar(50) DEFAULT NULL,
1317 `default_value` varchar(255) DEFAULT NULL,
1318 `is_required` tinyint(1) NOT NULL DEFAULT '0',
1319 `maxlength` int(10) DEFAULT NULL,
1320 `width` int(5) DEFAULT NULL,
1321 `height` int(5) DEFAULT NULL,
1322 `second_width` int(5) DEFAULT NULL,
1323 `second_height` int(5) DEFAULT NULL,
1324 `template` varchar(255) DEFAULT NULL,
1325 `parent_sid` int(10) DEFAULT NULL,
1326 `hidden` tinyint(1) NOT NULL DEFAULT '0',
1327 `display_as` varchar(255) DEFAULT NULL,
1328 `choiceLimit` int(11) DEFAULT '0',
1329 PRIMARY KEY (`sid`),
1330 KEY `user_group_sid` (`user_group_sid`),
1331 KEY `order` (`order`)
1332) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=utf8;
1333/*!40101 SET character_set_client = @saved_cs_client */;
1334
1335--
1336-- Dumping data for table `user_profile_fields`
1337--
1338
1339LOCK TABLES `user_profile_fields` WRITE;
1340/*!40000 ALTER TABLE `user_profile_fields` DISABLE KEYS */;
1341INSERT INTO `user_profile_fields` VALUES (58,41,4,'CompanyName','Company Name','string','',1,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(59,41,2,'FullName','Full Name','string',NULL,0,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(60,41,5,'WebSite','Website','string',NULL,0,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(61,41,7,'Country','Country','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,119,0,'country_name',0),(62,41,8,'State','State','string',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,119,0,'state_name',0),(63,41,9,'City','City','string',NULL,0,256,NULL,NULL,NULL,NULL,NULL,119,0,NULL,0),(67,41,9,'CompanyDescription','Company Description','text',NULL,0,NULL,NULL,NULL,NULL,NULL,'text.tpl',NULL,0,NULL,0),(81,41,8,'Logo','Logo','logo',NULL,0,NULL,250,250,150,150,NULL,NULL,0,NULL,0),(116,41,12,'ZipCode','Zip Code','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,119,0,NULL,0),(119,41,6,'Location','Location','location',NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(120,41,13,'Latitude','Latitude','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,119,0,NULL,0),(121,41,14,'Longitude','Longitude','string','',0,NULL,NULL,NULL,NULL,NULL,NULL,119,0,NULL,0),(122,41,7,'GooglePlace','Location','google_place',NULL,0,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(123,36,1,'FullName','Full Name','string',NULL,0,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(124,41,6,'Phone','Phone','string',NULL,0,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(125,36,2,'username','Email','unique_email',NULL,1,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(126,36,3,'password','Password','password',NULL,1,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(127,41,1,'username','Email','unique_email',NULL,1,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0),(128,41,3,'password','Password','password',NULL,1,256,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0);
1342/*!40000 ALTER TABLE `user_profile_fields` ENABLE KEYS */;
1343UNLOCK TABLES;
1344
1345--
1346-- Table structure for table `user_sessions`
1347--
1348
1349DROP TABLE IF EXISTS `user_sessions`;
1350/*!40101 SET @saved_cs_client = @@character_set_client */;
1351/*!40101 SET character_set_client = utf8 */;
1352CREATE TABLE `user_sessions` (
1353 `session_key` varchar(32) NOT NULL DEFAULT '',
1354 `user_sid` int(11) NOT NULL DEFAULT '0',
1355 `remote_ip` varchar(32) NOT NULL DEFAULT '',
1356 `user_agent` varchar(255) NOT NULL DEFAULT '',
1357 `start` int(11) NOT NULL DEFAULT '0',
1358 PRIMARY KEY (`session_key`),
1359 KEY `user_sid` (`user_sid`),
1360 KEY `remote_ip` (`remote_ip`),
1361 KEY `start` (`start`)
1362) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1363/*!40101 SET character_set_client = @saved_cs_client */;
1364
1365--
1366-- Dumping data for table `user_sessions`
1367--
1368
1369LOCK TABLES `user_sessions` WRITE;
1370/*!40000 ALTER TABLE `user_sessions` DISABLE KEYS */;
1371/*!40000 ALTER TABLE `user_sessions` ENABLE KEYS */;
1372UNLOCK TABLES;
1373
1374--
1375-- Table structure for table `users`
1376--
1377
1378DROP TABLE IF EXISTS `users`;
1379/*!40101 SET @saved_cs_client = @@character_set_client */;
1380/*!40101 SET character_set_client = utf8 */;
1381CREATE TABLE `users` (
1382 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1383 `username` varchar(255) DEFAULT NULL,
1384 `password` varchar(255) DEFAULT NULL,
1385 `email` varchar(255) DEFAULT NULL,
1386 `user_group_sid` int(10) unsigned DEFAULT NULL,
1387 `registration_date` datetime DEFAULT NULL,
1388 `active` int(1) unsigned DEFAULT '0',
1389 `verification_key` varchar(255) DEFAULT NULL,
1390 `featured` tinyint(4) NOT NULL DEFAULT '0',
1391 `ip` varchar(15) DEFAULT NULL,
1392 `reference_uid` varchar(255) DEFAULT NULL,
1393 `Location_Country` text,
1394 `Location_State` text,
1395 `Location_City` varchar(255) DEFAULT NULL,
1396 `CompanyName` varchar(255) DEFAULT NULL,
1397 `FullName` varchar(255) DEFAULT NULL,
1398 `WebSite` varchar(255) DEFAULT NULL,
1399 `CompanyDescription` longtext,
1400 `Logo` varchar(255) DEFAULT NULL,
1401 `trial` text,
1402 `Location_ZipCode` varchar(255) DEFAULT NULL,
1403 `Location_Latitude` double DEFAULT NULL,
1404 `Location_Longitude` double DEFAULT NULL,
1405 `GooglePlace` varchar(255) DEFAULT NULL,
1406 `Location` text,
1407 `extUserID` varchar(255) DEFAULT NULL,
1408 `Phone` varchar(255) DEFAULT NULL,
1409 PRIMARY KEY (`sid`),
1410 UNIQUE KEY `username` (`username`),
1411 KEY `email` (`email`),
1412 KEY `user_group_sid` (`user_group_sid`),
1413 KEY `active` (`active`),
1414 KEY `featured` (`featured`),
1415 KEY `password` (`password`),
1416 KEY `registration_date` (`registration_date`),
1417 KEY `verification_key` (`verification_key`),
1418 KEY `ip` (`ip`),
1419 KEY `reference_uid` (`reference_uid`),
1420 KEY `extUserID` (`extUserID`),
1421 KEY `CompanyName` (`CompanyName`),
1422 KEY `FullName` (`FullName`),
1423 KEY `Location_Latitude` (`Location_Latitude`),
1424 KEY `Location_Longitude` (`Location_Longitude`),
1425 KEY `GooglePlace` (`GooglePlace`),
1426 FULLTEXT KEY `GooglePlaceF` (`GooglePlace`)
1427) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;
1428/*!40101 SET character_set_client = @saved_cs_client */;
1429
1430--
1431-- Dumping data for table `users`
1432--
1433
1434LOCK TABLES `users` WRITE;
1435/*!40000 ALTER TABLE `users` DISABLE KEYS */;
1436INSERT INTO `users` VALUES (1,'js@mysmartjobboard.com','32981a13284db7a021131df49e6cd203','js@mail.com',36,'2012-04-24 11:59:33',1,'i83qfjnawldgkzro12yxv5emp4uhcbt9760s',0,'127.0.0.1',NULL,'227','7','Durango',NULL,'John Smith [Resume Sample]',NULL,NULL,NULL,'10','81303',NULL,NULL,NULL,NULL,NULL,NULL),(3,'jardini@mysmartjobboard.com','2f11cb292d739442ee9895cc084ed187','employer@gmail.com',41,'2012-04-24 12:00:09',1,'ohk8bxrg3qwmc20jvn9u4tis7dz5yafe1l6p',1,'192.168.0.50',NULL,'United States','Massachusetts','Cambridge','Jardini Sample Employer','John Brown','testurl.com','<p>Jardini Company is one of the largest companies in the construction and real estate industry.</p>','Logo_3',NULL,'02142',42.36360168457031,-71.0824966430664,'Cambridge, MA 02142, United States','United States Massachusetts Cambridge 02142 42.36360168457031 -71.0824966430664',NULL,NULL),(4,'chilisoft@mysmartjobboard.com','d3171941cd84c6e462bf4969796aedd1','cv.jf@hotmail.com',41,'2012-04-24 12:00:09',1,'cadh2zs80twrpqbfoku1jl735en4iv9gy6mx',1,'192.168.0.50',NULL,'United States','California','San Francisco','Chilisoft Sample Employer','Michael Huston','testurl.com','<p>As a distributor we focus on security solutions and carefully select leading or emerging products from reliable and reputable vendors that can benefit our resellers and and-user clients in our target markets. We work to ensure that our staff are well t</p>','Logo_4',NULL,'94103',37.77259826660156,-122.41000366210938,'San Francisco, CA 94103, United States','United States California San_ Francisco 94103 37.77259826660156 -122.41000366210938',NULL,NULL),(5,'inventa@mysmartjobboard.com','020bedb3ad0a7431baa53c0d6b078cff','mail@box.com',41,'2012-04-24 12:00:09',1,'d2lopfrqm3607w415yu8ibjc9egsavznxtkh',1,'192.168.0.50',NULL,'United States','Georgia','Atlanta','Inventa Sample Employer','Silvia','testurl.com','<p>Our company gained wide experience in co-operation with different organizations and companies. Today we're one of the best companies working on intellectual property market. Our company has already fulfilled works concerning protection of more than 400</p>','Logo_5',NULL,'30307',33.77239990234375,-84.3279037475586,'Atlanta, GA 30307, United States','United States Georgia Atlanta 30307 33.77239990234375 -84.3279037475586',NULL,NULL),(6,'irg@mysmartjobboard.com','dc2e69864af36f7ff06e82d5f9919dba','cv@irg.org',41,'2012-04-24 12:00:09',1,'t8befckq541oypdsun9ijlm2w6a0h7zv3grx',1,'192.168.0.50',NULL,'United States','Connecticut','Hartford','IRG Sample Employer','Steve Martin','testurl.com','<p>IRG is the Resource Company that provides development-related services for private- and public-sector clients. Our company offers a wide range of environmental services.</p>','Logo_6',NULL,'06141',41.7599983215332,-72.69000244140625,'Hartford, CT 06141, United States','United States Connecticut Hartford 06141 41.7599983215332 -72.69000244140625',NULL,NULL),(8,'test@mysmartjobboard.com','202cb962ac59075b964b07152d234b70','nwyksasdf@gmail.com',41,'2012-04-24 12:00:09',1,'ldjmnokuch4qvf917eix6tyzw3b8p0rga52s',0,'192.168.0.31',NULL,'United States','California','Sacramento','Sample Employer','Robert White','testurl.com','<p><strong>This is not a real company. Please don't try to contact us. </strong><br /><br />We're one of the leading management consulting firms in United States. We provide a complete consulting expertise. We have a wide range of products, processes and services to support your company's business needs.</p>','Logo_8','7','',38.58157189999999,-121.49439960000001,'Sacramento, CA, United States','United States California Sacramento 38.58157189999999 -121.49439960000001',NULL,NULL);
1437/*!40000 ALTER TABLE `users` ENABLE KEYS */;
1438UNLOCK TABLES;
1439
1440--
1441-- Table structure for table `users_properties`
1442--
1443
1444DROP TABLE IF EXISTS `users_properties`;
1445/*!40101 SET @saved_cs_client = @@character_set_client */;
1446/*!40101 SET character_set_client = utf8 */;
1447CREATE TABLE `users_properties` (
1448 `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
1449 `object_sid` int(10) unsigned DEFAULT NULL,
1450 `id` varchar(255) DEFAULT NULL,
1451 `value` text,
1452 `add_parameter` varchar(255) DEFAULT NULL,
1453 PRIMARY KEY (`sid`),
1454 KEY `object_sid` (`object_sid`),
1455 KEY `id` (`id`),
1456 KEY `add_parameter` (`add_parameter`)
1457) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1458/*!40101 SET character_set_client = @saved_cs_client */;
1459
1460--
1461-- Dumping data for table `users_properties`
1462--
1463
1464LOCK TABLES `users_properties` WRITE;
1465/*!40000 ALTER TABLE `users_properties` DISABLE KEYS */;
1466/*!40000 ALTER TABLE `users_properties` ENABLE KEYS */;
1467UNLOCK TABLES;
1468/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1469
1470/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1471/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1472/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1473/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1474/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1475/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1476/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1477
1478-- Dump completed on 2016-04-22 12:49:17