- 22 Dec 2010, 17:59
#1183
Hi,
In testing out the development version, I got this query error during step 3 of Loading Data during set up:
thanks,
Brett
Query Error -- Please Report This Bug!
MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
/*!40101 SET SQL_MODE=''*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_M' at line 7
/*
SQLyog Enterprise - MySQL GUI v8.02 RC
MySQL - 5.1.31-community : Database - cats_dev
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*Table structure for table `access_level` */
CREATE TABLE `access_level` (
`access_level_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`long_description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`access_level_id`),
KEY `IDX_access_level` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `access_level` */
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (0,'Account Disabled','Disabled - The lowest access level. User cannot log in.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (100,'Read Only','Read Only - A standard user that can view data on the system in a read-only mode.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (200,'Add / Edit','Edit - All lower access, plus the ability to edit information on the system.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (300,'Add / Edit / Delete','Delete - All lower access, plus the ability to delete information on the system.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (400,'Site Administrator','Site Administrator - All lower access, plus the ability to add, edit, and remove site users, as well as the ability to edit site settings.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (500,'Root','Root Administrator - All lower access, plus the ability to add, edit, and remove sites, as well as the ability to assign Site Administrator status to a user.');
/*Table structure for table `activity` */
CREATE TABLE `activity` (
`activity_id` int(11) NOT NULL AUTO_INCREMENT,
`data_item_id` int(11) NOT NULL DEFAULT '0',
`data_item_type` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) DEFAULT NULL,
`site_id` int(11) NOT NULL DEFAULT '0',
`entered_by` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` int(11) NOT NULL DEFAULT '0',
`notes` text COLLATE utf8_unicode_ci,
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`activity_id`),
KEY `IDX_entered_by` (`entered_by`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_type` (`type`),
KEY `IDX_data_item_type` (`data_item_type`),
KEY `IDX_type_id` (`data_item_type`,`data_item_id`),
KEY `IDX_joborder_id` (`joborder_id`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_data_item_id_type_site` (`site_id`,`data_item_id`,`data_item_type`),
KEY `IDX_site_created` (`site_id`,`date_created`),
KEY `IDX_activity_site_type_created_job` (`site_id`,`data_item_type`,`date_created`,`entered_by`,`joborder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `activity` */
/*Table structure for table `activity_type` */
CREATE TABLE `activity_type` (
`activity_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`activity_type_id`),
KEY `IDX_activity_type1` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `activity_type` */
insert into `activity_type`(`activity_type_id`,`short_description`) values (100,'Call');
insert into `activity_type`(`activity_type_id`,`short_description`) values (200,'Email');
insert into `activity_type`(`activity_type_id`,`short_description`) values (300,'Meeting');
insert into `activity_type`(`activity_type_id`,`short_description`) values (400,'Other');
insert into `activity_type`(`activity_type_id`,`short_description`) values (500,'Call (Talked)');
insert into `activity_type`(`activity_type_id`,`short_description`) values (600,'Call (LVM)');
insert into `activity_type`(`activity_type_id`,`short_description`) values (700,'Call (Missed)');
/*Table structure for table `attachment` */
CREATE TABLE `attachment` (
`attachment_id` int(11) NOT NULL AUTO_INCREMENT,
`data_item_id` int(11) NOT NULL DEFAULT '0',
`data_item_type` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`stored_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`content_type` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`resume` int(1) NOT NULL DEFAULT '0',
`text` text COLLATE utf8_unicode_ci,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`profile_image` int(1) DEFAULT '0',
`directory_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`md5_sum` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`file_size_kb` int(11) DEFAULT '0',
`md5_sum_text` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`attachment_id`),
KEY `IDX_type_id` (`data_item_type`,`data_item_id`),
KEY `IDX_data_item_id` (`data_item_id`),
KEY `IDX_CANDIDATE_MD5_SUM` (`md5_sum`),
KEY `IDX_site_file_size` (`site_id`,`file_size_kb`),
KEY `IDX_site_file_size_created` (`site_id`,`file_size_kb`,`date_created`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `attachment` */
/*Table structure for table `calendar_event` */
CREATE TABLE `calendar_event` (
`calendar_event_id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` text COLLATE utf8_unicode_ci NOT NULL,
`all_day` int(1) NOT NULL DEFAULT '0',
`data_item_id` int(11) NOT NULL DEFAULT '-1',
`data_item_type` int(11) NOT NULL DEFAULT '-1',
`entered_by` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`site_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '-1',
`description` text COLLATE utf8_unicode_ci,
`duration` int(11) NOT NULL DEFAULT '60',
`reminder_enabled` int(1) NOT NULL DEFAULT '0',
`reminder_email` text COLLATE utf8_unicode_ci,
`reminder_time` int(11) DEFAULT '0',
`public` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`calendar_event_id`),
KEY `IDX_site_id_date` (`site_id`,`date`),
KEY `IDX_site_data_item_type_id` (`site_id`,`data_item_type`,`data_item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `calendar_event` */
/*Table structure for table `calendar_event_type` */
CREATE TABLE `calendar_event_type` (
`calendar_event_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`icon_image` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`calendar_event_type_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `calendar_event_type` */
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (100,'Call','images/phone.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (200,'Email','images/email.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (300,'Meeting','images/meeting.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (400,'Interview','images/interview.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (500,'Personal','images/personal.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (600,'Other','');
/*Table structure for table `candidate` */
CREATE TABLE `candidate` (
`candidate_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT '0',
`last_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`first_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`middle_name` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_home` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_cell` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_work` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`address` text COLLATE utf8_unicode_ci,
`city` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`zip` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`source` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_available` datetime DEFAULT NULL,
`can_relocate` int(1) NOT NULL DEFAULT '0',
`notes` text COLLATE utf8_unicode_ci,
`key_skills` text COLLATE utf8_unicode_ci,
`current_employer` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`entered_by` int(11) NOT NULL DEFAULT '0' COMMENT 'Created-by user.',
`owner` int(11) DEFAULT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`email1` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`email2` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`web_site` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`import_id` int(11) NOT NULL DEFAULT '0',
`is_hot` int(1) NOT NULL DEFAULT '0',
`eeo_ethnic_type_id` int(11) DEFAULT '0',
`eeo_veteran_type_id` int(11) DEFAULT '0',
`eeo_disability_status` varchar(5) COLLATE utf8_unicode_ci DEFAULT '',
`eeo_gender` varchar(5) COLLATE utf8_unicode_ci DEFAULT '',
`desired_pay` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`current_pay` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`is_active` int(1) DEFAULT '1',
`is_admin_hidden` int(1) DEFAULT '0',
`best_time_to_call` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`candidate_id`),
KEY `IDX_first_name` (`first_name`),
KEY `IDX_last_name` (`last_name`),
KEY `IDX_phone_home` (`phone_home`),
KEY `IDX_phone_cell` (`phone_cell`),
KEY `IDX_phone_work` (`phone_work`),
KEY `IDX_key_skills` (`key_skills`(255)),
KEY `IDX_entered_by` (`entered_by`),
KEY `IDX_owner` (`owner`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_site_first_last_modified` (`site_id`,`first_name`,`last_name`,`date_modified`),
KEY `IDX_site_id_email_1_2` (`site_id`,`email1`(8),`email2`(8))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate` */
/*Table structure for table `candidate_joborder` */
CREATE TABLE `candidate_joborder` (
`candidate_joborder_id` int(11) NOT NULL AUTO_INCREMENT,
`candidate_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`date_submitted` datetime DEFAULT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`rating_value` int(5) DEFAULT NULL,
`added_by` int(11) DEFAULT NULL,
PRIMARY KEY (`candidate_joborder_id`),
KEY `IDX_candidate_id` (`candidate_id`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_date_submitted` (`date_submitted`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_status_special` (`site_id`,`status`),
KEY `IDX_site_joborder` (`site_id`,`joborder_id`),
KEY `IDX_joborder_id` (`joborder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder` */
/*Table structure for table `candidate_joborder_status` */
CREATE TABLE `candidate_joborder_status` (
`candidate_joborder_status_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`can_be_scheduled` int(1) NOT NULL DEFAULT '0',
`triggers_email` int(1) NOT NULL DEFAULT '1',
`is_enabled` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`candidate_joborder_status_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder_status` */
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (100,'No Contact',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (200,'Contacted',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (300,'Qualifying',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (400,'Submitted',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (500,'Interviewing',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (600,'Offered',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (700,'Client Declined',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (800,'Placed',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (0,'No Status',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (650,'Not in Consideration',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (250,'Candidate Responded',0,0,1);
/*Table structure for table `candidate_joborder_status_history` */
CREATE TABLE `candidate_joborder_status_history` (
`candidate_joborder_status_history_id` int(11) NOT NULL AUTO_INCREMENT,
`candidate_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status_from` int(11) NOT NULL DEFAULT '0',
`status_to` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`candidate_joborder_status_history_id`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_status_to` (`status_to`),
KEY `IDX_status_to_site_id` (`status_to`,`site_id`),
KEY `IDX_candidate_joborder_status_to_site` (`candidate_id`,`joborder_id`,`status_to`,`site_id`),
KEY `IDX_joborder_site` (`joborder_id`,`site_id`),
KEY `IDX_site_joborder_status_to` (`site_id`,`joborder_id`,`status_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder_status_history` */
/*Table structure for table `candidate_jobordrer_status_type` */
CREATE TABLE `candidate_jobordrer_status_type` (
`candidate_status_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`can_be_scheduled` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`candidate_status_type_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_jobordrer_status_type` */
/*Table structure for table `candidate_source` */
CREATE TABLE `candidate_source` (
`source_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
PRIMARY KEY (`source_id`),
KEY `siteID` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_source` */
/*Table structure for table `candidate_tag` */
CREATE TABLE `candidate_tag` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`site_id` int(10) unsigned DEFAULT NULL,
`candidate_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*Data for the table `candidate_tag` */
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (55,1,1,5);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (56,1,1,78);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (57,1,1,80);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (58,1,1,81);
/*Table structure for table `career_portal_questionnaire` */
CREATE TABLE `career_portal_questionnaire` (
`career_portal_questionnaire_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`site_id` int(11) NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`career_portal_questionnaire_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire` */
/*Table structure for table `career_portal_questionnaire_answer` */
CREATE TABLE `career_portal_questionnaire_answer` (
`career_portal_questionnaire_answer_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_questionnaire_question_id` int(11) NOT NULL,
`career_portal_questionnaire_id` int(11) NOT NULL,
`text` varchar(255) NOT NULL DEFAULT '',
`action_source` varchar(128) DEFAULT NULL,
`action_notes` text,
`action_is_hot` tinyint(1) DEFAULT '0',
`action_is_active` tinyint(1) DEFAULT '0',
`action_can_relocate` tinyint(1) DEFAULT '0',
`action_key_skills` varchar(255) DEFAULT NULL,
`position` int(4) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`career_portal_questionnaire_answer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_answer` */
/*Table structure for table `career_portal_questionnaire_history` */
CREATE TABLE `career_portal_questionnaire_history` (
`career_portal_questionnaire_history_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT '0',
`candidate_id` int(11) NOT NULL DEFAULT '0',
`question` varchar(255) NOT NULL DEFAULT '',
`answer` varchar(255) NOT NULL DEFAULT '',
`questionnaire_title` varchar(255) NOT NULL DEFAULT '',
`questionnaire_description` varchar(255) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`career_portal_questionnaire_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_history` */
/*Table structure for table `career_portal_questionnaire_question` */
CREATE TABLE `career_portal_questionnaire_question` (
`career_portal_questionnaire_question_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_questionnaire_id` int(11) NOT NULL,
`text` varchar(255) NOT NULL DEFAULT '',
`minimum_length` int(11) DEFAULT NULL,
`maximum_length` int(11) DEFAULT NULL,
`required` tinyint(1) NOT NULL DEFAULT '0',
`position` int(4) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`career_portal_questionnaire_question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_question` */
/*Table structure for table `career_portal_template` */
CREATE TABLE `career_portal_template` (
`career_portal_template_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_name` varchar(255) DEFAULT NULL,
`setting` varchar(128) NOT NULL DEFAULT '',
`value` text,
PRIMARY KEY (`career_portal_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_template` */
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (56,'Blank Page','Left','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (57,'Blank Page','Footer','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (58,'Blank Page','Header','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (59,'Blank Page','Content - Main','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (60,'Blank Page','CSS','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (61,'Blank Page','Content - Search Results','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (62,'Blank Page','Content - Questionnaire','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (63,'Blank Page','Content - Job Details','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (64,'Blank Page','Content - Thanks for your Submission','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (65,'Blank Page','Content - Apply for Position','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (66,'CATS 2.0','Left','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (67,'CATS 2.0','Footer','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (68,'CATS 2.0','Header','
\r\n
\"IMAGE:
\r\n
\r\n
Shortcuts:
\r\n \"IMAGE:\r\n\" onmouseover=\"buttonMouseOver(\'rssFeed\',true);\" onmouseout=\"buttonMouseOver(\'rssFeed\',false);\">\"IMAGE:\r\n \"IMAGE:\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (69,'CATS 2.0','Content - Main','
\r\n \r\n
Available Openings at
\r\n
\r\n
Change your life today by becoming an integral part of our winning team.
\r\n
If you are interested, we invite you to view the current opening positions at our company.
Have you applied with us before?
\r\n
\r\n
\r\n
Perform an action:
\r\n
* \r\n Visit our website
\r\n
\r\n
\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (70,'CATS 2.0','CSS','table.sortable\r\n{\r\ntext-align:left;\r\nempty-cells: show;\r\nwidth: 940px;\r\n}\r\ntd\r\n{\r\npadding:5px;\r\n}\r\ntr.rowHeading\r\n{\r\n background: #e0e0e0; border: 1px solid #cccccc; border-left: none; border-right: none;\r\n}\r\ntr.oddTableRow\r\n{\r\nbackground: #ebebeb; \r\n}\r\ntr.evenTableRow\r\n{\r\n background: #ffffff; \r\n}\r\na.sortheader:hover,\r\na.sortheader:link,\r\na.sortheader:visited\r\n{\r\ncolor:#000;\r\n}\r\n\r\nbody, html { margin: 0; padding: 0; background: #ffffff; font: normal 12px/14px Arial, Helvetica, sans-serif; color: #000000; }\r\n#container { margin: 0 auto; padding: 0; width: 940px; height: auto; }\r\n#logo { float: left; margin: 0; }\r\n #logo img { width: 424px; height: 103px; }\r\n#actions { float: right; margin: 0; width: 310px; height: 100px; background: #efefef; border: 1px solid #cccccc; }\r\n #actions img { float: left; margin: 2px 6px 2px 15px; width: 130px; height: 25px; }\r\n#footer { clear: both; margin: 20px auto 0 auto; width: 150px; }\r\n #footer img { width: 137px; height: 38px; }\r\n\r\na:link, a:active { color: #1763b9; }\r\na:hover { color: #c75a01; }\r\na:visited { color: #333333; }\r\nimg { border: none; }\r\n\r\nh1 { margin: 0 0 10px 0; font: bold 18px Arial, Helvetica, sans-serif; }\r\nh2 { margin: 8px 0 8px 15px; font: bold 14px Arial, Helvetica, sans-serif; }\r\nh3 { margin: 0; font: bold 14px Arial, Helvetica, sans-serif; }\r\np { font: normal 12px Arial, Helvetica, sans-serif; }\r\np.instructions { margin: 0 0 0 10px; font: italic 12px Arial, Helvetica, sans-serif; color: #666666; }\r\n\r\n\r\n/* CONTENTS ON PAGE SPECS */\r\n#careerContent { clear: both; padding: 15px 0 0 0; }\r\n\r\n \r\n/* DISPLAY JOB DETAILS */\r\n#detailsTable { width: 400px; }\r\n #detailsTable td.detailsHeader { width: 30%; }\r\ndiv#descriptive { float: left; width: 585px; }\r\ndiv#detailsTools { float: right; padding: 0 0 8px 0; width: 280px; background: #ffffff; border: 1px solid #cccccc; }\r\n div#detailsTools img { margin: 2px 6px 5px 15px; }\r\n\r\n/* DISPLAY APPLICATION FORM */\r\ndiv.applyBoxLeft, div.applyBoxRight { width: 450px; height: 470px; background: #f9f9f9; border: 1px solid #cccccc; border-top: none; }\r\ndiv.applyBoxLeft { float: left; margin: 0 10px 0 0; }\r\ndiv.applyBoxRight { float: right; margin: 0 0 0 10px; }\r\n div.applyBoxLeft div, div.applyBoxRight div { margin: 0 0 5px 0; padding: 3px 10px; background: #efefef; border-top: 1px solid #cccccc; border-bottom: 1px solid #cccccc; }\r\n div.applyBoxLeft table, div.applyBoxRight table { margin: 0 auto; width: 420px; }\r\n div.applyBoxLeft table td, div.applyBoxRight table td { padding: 3px; vertical-align: top; }\r\n td.label { text-align: right; width: 110px; }\r\n form#applyToJobForm { }\r\n form#applyToJobForm label { font-weight: bold; }\r\n form#applyToJobForm input.inputBoxName, form#applyToJobForm input.inputBoxNormal { width: 285px; height: 15px; }\r\n form#applyToJobForm input.submitButton { width: 197px; height: 27px; background: url(\'images/careers_submit.gif\') no-repeat; }\r\n\r\n form#applyToJobForm input.submitButtonDown { width: 197px; height: 27px; background: url(\'images/careers_submit-o.gif\') no-repeat; }\r\n form#applyToJobForm textarea { margin: 8px 0 0 0; width: 410px; height: 170px; }\r\n form#applyToJobForm textarea.inputBoxArea{ width: 285px; height: 70px; }\r\n\r\n');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (71,'CATS 2.0','Content - Search Results','
\r\n \r\n
Current Available Openings, Recently Posted Jobs:
\r\n\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (72,'CATS 2.0','Content - Questionnaire','
\r\n\r\n
\r\n
\r\n\r\n
\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (73,'CATS 2.0','Content - Job Details','
\r\n \r\n
Position Details:
In testing out the development version, I got this query error during step 3 of Loading Data during set up:
thanks,
Brett
Query Error -- Please Report This Bug!
MySQL Query Failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
/*!40101 SET SQL_MODE=''*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_M' at line 7
/*
SQLyog Enterprise - MySQL GUI v8.02 RC
MySQL - 5.1.31-community : Database - cats_dev
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*Table structure for table `access_level` */
CREATE TABLE `access_level` (
`access_level_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`long_description` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`access_level_id`),
KEY `IDX_access_level` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `access_level` */
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (0,'Account Disabled','Disabled - The lowest access level. User cannot log in.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (100,'Read Only','Read Only - A standard user that can view data on the system in a read-only mode.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (200,'Add / Edit','Edit - All lower access, plus the ability to edit information on the system.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (300,'Add / Edit / Delete','Delete - All lower access, plus the ability to delete information on the system.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (400,'Site Administrator','Site Administrator - All lower access, plus the ability to add, edit, and remove site users, as well as the ability to edit site settings.');
insert into `access_level`(`access_level_id`,`short_description`,`long_description`) values (500,'Root','Root Administrator - All lower access, plus the ability to add, edit, and remove sites, as well as the ability to assign Site Administrator status to a user.');
/*Table structure for table `activity` */
CREATE TABLE `activity` (
`activity_id` int(11) NOT NULL AUTO_INCREMENT,
`data_item_id` int(11) NOT NULL DEFAULT '0',
`data_item_type` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) DEFAULT NULL,
`site_id` int(11) NOT NULL DEFAULT '0',
`entered_by` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` int(11) NOT NULL DEFAULT '0',
`notes` text COLLATE utf8_unicode_ci,
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`activity_id`),
KEY `IDX_entered_by` (`entered_by`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_type` (`type`),
KEY `IDX_data_item_type` (`data_item_type`),
KEY `IDX_type_id` (`data_item_type`,`data_item_id`),
KEY `IDX_joborder_id` (`joborder_id`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_data_item_id_type_site` (`site_id`,`data_item_id`,`data_item_type`),
KEY `IDX_site_created` (`site_id`,`date_created`),
KEY `IDX_activity_site_type_created_job` (`site_id`,`data_item_type`,`date_created`,`entered_by`,`joborder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `activity` */
/*Table structure for table `activity_type` */
CREATE TABLE `activity_type` (
`activity_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`activity_type_id`),
KEY `IDX_activity_type1` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `activity_type` */
insert into `activity_type`(`activity_type_id`,`short_description`) values (100,'Call');
insert into `activity_type`(`activity_type_id`,`short_description`) values (200,'Email');
insert into `activity_type`(`activity_type_id`,`short_description`) values (300,'Meeting');
insert into `activity_type`(`activity_type_id`,`short_description`) values (400,'Other');
insert into `activity_type`(`activity_type_id`,`short_description`) values (500,'Call (Talked)');
insert into `activity_type`(`activity_type_id`,`short_description`) values (600,'Call (LVM)');
insert into `activity_type`(`activity_type_id`,`short_description`) values (700,'Call (Missed)');
/*Table structure for table `attachment` */
CREATE TABLE `attachment` (
`attachment_id` int(11) NOT NULL AUTO_INCREMENT,
`data_item_id` int(11) NOT NULL DEFAULT '0',
`data_item_type` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`original_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`stored_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`content_type` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`resume` int(1) NOT NULL DEFAULT '0',
`text` text COLLATE utf8_unicode_ci,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`profile_image` int(1) DEFAULT '0',
`directory_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`md5_sum` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`file_size_kb` int(11) DEFAULT '0',
`md5_sum_text` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`attachment_id`),
KEY `IDX_type_id` (`data_item_type`,`data_item_id`),
KEY `IDX_data_item_id` (`data_item_id`),
KEY `IDX_CANDIDATE_MD5_SUM` (`md5_sum`),
KEY `IDX_site_file_size` (`site_id`,`file_size_kb`),
KEY `IDX_site_file_size_created` (`site_id`,`file_size_kb`,`date_created`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `attachment` */
/*Table structure for table `calendar_event` */
CREATE TABLE `calendar_event` (
`calendar_event_id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` text COLLATE utf8_unicode_ci NOT NULL,
`all_day` int(1) NOT NULL DEFAULT '0',
`data_item_id` int(11) NOT NULL DEFAULT '-1',
`data_item_type` int(11) NOT NULL DEFAULT '-1',
`entered_by` int(11) NOT NULL DEFAULT '0',
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`site_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '-1',
`description` text COLLATE utf8_unicode_ci,
`duration` int(11) NOT NULL DEFAULT '60',
`reminder_enabled` int(1) NOT NULL DEFAULT '0',
`reminder_email` text COLLATE utf8_unicode_ci,
`reminder_time` int(11) DEFAULT '0',
`public` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`calendar_event_id`),
KEY `IDX_site_id_date` (`site_id`,`date`),
KEY `IDX_site_data_item_type_id` (`site_id`,`data_item_type`,`data_item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `calendar_event` */
/*Table structure for table `calendar_event_type` */
CREATE TABLE `calendar_event_type` (
`calendar_event_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`icon_image` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`calendar_event_type_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `calendar_event_type` */
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (100,'Call','images/phone.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (200,'Email','images/email.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (300,'Meeting','images/meeting.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (400,'Interview','images/interview.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (500,'Personal','images/personal.gif');
insert into `calendar_event_type`(`calendar_event_type_id`,`short_description`,`icon_image`) values (600,'Other','');
/*Table structure for table `candidate` */
CREATE TABLE `candidate` (
`candidate_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT '0',
`last_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`first_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`middle_name` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_home` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_cell` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone_work` varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
`address` text COLLATE utf8_unicode_ci,
`city` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`state` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`zip` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
`source` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`date_available` datetime DEFAULT NULL,
`can_relocate` int(1) NOT NULL DEFAULT '0',
`notes` text COLLATE utf8_unicode_ci,
`key_skills` text COLLATE utf8_unicode_ci,
`current_employer` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`entered_by` int(11) NOT NULL DEFAULT '0' COMMENT 'Created-by user.',
`owner` int(11) DEFAULT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`email1` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`email2` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`web_site` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
`import_id` int(11) NOT NULL DEFAULT '0',
`is_hot` int(1) NOT NULL DEFAULT '0',
`eeo_ethnic_type_id` int(11) DEFAULT '0',
`eeo_veteran_type_id` int(11) DEFAULT '0',
`eeo_disability_status` varchar(5) COLLATE utf8_unicode_ci DEFAULT '',
`eeo_gender` varchar(5) COLLATE utf8_unicode_ci DEFAULT '',
`desired_pay` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`current_pay` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
`is_active` int(1) DEFAULT '1',
`is_admin_hidden` int(1) DEFAULT '0',
`best_time_to_call` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`candidate_id`),
KEY `IDX_first_name` (`first_name`),
KEY `IDX_last_name` (`last_name`),
KEY `IDX_phone_home` (`phone_home`),
KEY `IDX_phone_cell` (`phone_cell`),
KEY `IDX_phone_work` (`phone_work`),
KEY `IDX_key_skills` (`key_skills`(255)),
KEY `IDX_entered_by` (`entered_by`),
KEY `IDX_owner` (`owner`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_site_first_last_modified` (`site_id`,`first_name`,`last_name`,`date_modified`),
KEY `IDX_site_id_email_1_2` (`site_id`,`email1`(8),`email2`(8))
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate` */
/*Table structure for table `candidate_joborder` */
CREATE TABLE `candidate_joborder` (
`candidate_joborder_id` int(11) NOT NULL AUTO_INCREMENT,
`candidate_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`status` int(11) NOT NULL DEFAULT '0',
`date_submitted` datetime DEFAULT NULL,
`date_created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`rating_value` int(5) DEFAULT NULL,
`added_by` int(11) DEFAULT NULL,
PRIMARY KEY (`candidate_joborder_id`),
KEY `IDX_candidate_id` (`candidate_id`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_date_submitted` (`date_submitted`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_status_special` (`site_id`,`status`),
KEY `IDX_site_joborder` (`site_id`,`joborder_id`),
KEY `IDX_joborder_id` (`joborder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder` */
/*Table structure for table `candidate_joborder_status` */
CREATE TABLE `candidate_joborder_status` (
`candidate_joborder_status_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`can_be_scheduled` int(1) NOT NULL DEFAULT '0',
`triggers_email` int(1) NOT NULL DEFAULT '1',
`is_enabled` int(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`candidate_joborder_status_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder_status` */
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (100,'No Contact',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (200,'Contacted',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (300,'Qualifying',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (400,'Submitted',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (500,'Interviewing',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (600,'Offered',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (700,'Client Declined',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (800,'Placed',0,1,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (0,'No Status',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (650,'Not in Consideration',0,0,1);
insert into `candidate_joborder_status`(`candidate_joborder_status_id`,`short_description`,`can_be_scheduled`,`triggers_email`,`is_enabled`) values (250,'Candidate Responded',0,0,1);
/*Table structure for table `candidate_joborder_status_history` */
CREATE TABLE `candidate_joborder_status_history` (
`candidate_joborder_status_history_id` int(11) NOT NULL AUTO_INCREMENT,
`candidate_id` int(11) NOT NULL DEFAULT '0',
`joborder_id` int(11) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status_from` int(11) NOT NULL DEFAULT '0',
`status_to` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`candidate_joborder_status_history_id`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_status_to` (`status_to`),
KEY `IDX_status_to_site_id` (`status_to`,`site_id`),
KEY `IDX_candidate_joborder_status_to_site` (`candidate_id`,`joborder_id`,`status_to`,`site_id`),
KEY `IDX_joborder_site` (`joborder_id`,`site_id`),
KEY `IDX_site_joborder_status_to` (`site_id`,`joborder_id`,`status_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_joborder_status_history` */
/*Table structure for table `candidate_jobordrer_status_type` */
CREATE TABLE `candidate_jobordrer_status_type` (
`candidate_status_type_id` int(11) NOT NULL DEFAULT '0',
`short_description` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`can_be_scheduled` int(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`candidate_status_type_id`),
KEY `IDX_short_description` (`short_description`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_jobordrer_status_type` */
/*Table structure for table `candidate_source` */
CREATE TABLE `candidate_source` (
`source_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`site_id` int(11) DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
PRIMARY KEY (`source_id`),
KEY `siteID` (`site_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*Data for the table `candidate_source` */
/*Table structure for table `candidate_tag` */
CREATE TABLE `candidate_tag` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`site_id` int(10) unsigned DEFAULT NULL,
`candidate_id` int(10) unsigned NOT NULL,
`tag_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;
/*Data for the table `candidate_tag` */
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (55,1,1,5);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (56,1,1,78);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (57,1,1,80);
insert into `candidate_tag`(`id`,`site_id`,`candidate_id`,`tag_id`) values (58,1,1,81);
/*Table structure for table `career_portal_questionnaire` */
CREATE TABLE `career_portal_questionnaire` (
`career_portal_questionnaire_id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`site_id` int(11) NOT NULL DEFAULT '0',
`description` varchar(255) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`career_portal_questionnaire_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire` */
/*Table structure for table `career_portal_questionnaire_answer` */
CREATE TABLE `career_portal_questionnaire_answer` (
`career_portal_questionnaire_answer_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_questionnaire_question_id` int(11) NOT NULL,
`career_portal_questionnaire_id` int(11) NOT NULL,
`text` varchar(255) NOT NULL DEFAULT '',
`action_source` varchar(128) DEFAULT NULL,
`action_notes` text,
`action_is_hot` tinyint(1) DEFAULT '0',
`action_is_active` tinyint(1) DEFAULT '0',
`action_can_relocate` tinyint(1) DEFAULT '0',
`action_key_skills` varchar(255) DEFAULT NULL,
`position` int(4) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`career_portal_questionnaire_answer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_answer` */
/*Table structure for table `career_portal_questionnaire_history` */
CREATE TABLE `career_portal_questionnaire_history` (
`career_portal_questionnaire_history_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` int(11) NOT NULL DEFAULT '0',
`candidate_id` int(11) NOT NULL DEFAULT '0',
`question` varchar(255) NOT NULL DEFAULT '',
`answer` varchar(255) NOT NULL DEFAULT '',
`questionnaire_title` varchar(255) NOT NULL DEFAULT '',
`questionnaire_description` varchar(255) NOT NULL DEFAULT '',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`career_portal_questionnaire_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_history` */
/*Table structure for table `career_portal_questionnaire_question` */
CREATE TABLE `career_portal_questionnaire_question` (
`career_portal_questionnaire_question_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_questionnaire_id` int(11) NOT NULL,
`text` varchar(255) NOT NULL DEFAULT '',
`minimum_length` int(11) DEFAULT NULL,
`maximum_length` int(11) DEFAULT NULL,
`required` tinyint(1) NOT NULL DEFAULT '0',
`position` int(4) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`career_portal_questionnaire_question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_questionnaire_question` */
/*Table structure for table `career_portal_template` */
CREATE TABLE `career_portal_template` (
`career_portal_template_id` int(11) NOT NULL AUTO_INCREMENT,
`career_portal_name` varchar(255) DEFAULT NULL,
`setting` varchar(128) NOT NULL DEFAULT '',
`value` text,
PRIMARY KEY (`career_portal_template_id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8;
/*Data for the table `career_portal_template` */
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (56,'Blank Page','Left','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (57,'Blank Page','Footer','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (58,'Blank Page','Header','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (59,'Blank Page','Content - Main','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (60,'Blank Page','CSS','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (61,'Blank Page','Content - Search Results','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (62,'Blank Page','Content - Questionnaire','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (63,'Blank Page','Content - Job Details','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (64,'Blank Page','Content - Thanks for your Submission','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (65,'Blank Page','Content - Apply for Position','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (66,'CATS 2.0','Left','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (67,'CATS 2.0','Footer','');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (68,'CATS 2.0','Header','
\r\n
\"IMAGE:
\r\n
\r\n
Shortcuts:
\r\n \"IMAGE:\r\n\" onmouseover=\"buttonMouseOver(\'rssFeed\',true);\" onmouseout=\"buttonMouseOver(\'rssFeed\',false);\">\"IMAGE:\r\n \"IMAGE:\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (69,'CATS 2.0','Content - Main','
\r\n \r\n
Available Openings at
\r\n
\r\n
Change your life today by becoming an integral part of our winning team.
\r\n
If you are interested, we invite you to view the current opening positions at our company.
Have you applied with us before?
\r\n
\r\n
\r\n
Perform an action:
\r\n
* \r\n Visit our website
\r\n
\r\n
\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (70,'CATS 2.0','CSS','table.sortable\r\n{\r\ntext-align:left;\r\nempty-cells: show;\r\nwidth: 940px;\r\n}\r\ntd\r\n{\r\npadding:5px;\r\n}\r\ntr.rowHeading\r\n{\r\n background: #e0e0e0; border: 1px solid #cccccc; border-left: none; border-right: none;\r\n}\r\ntr.oddTableRow\r\n{\r\nbackground: #ebebeb; \r\n}\r\ntr.evenTableRow\r\n{\r\n background: #ffffff; \r\n}\r\na.sortheader:hover,\r\na.sortheader:link,\r\na.sortheader:visited\r\n{\r\ncolor:#000;\r\n}\r\n\r\nbody, html { margin: 0; padding: 0; background: #ffffff; font: normal 12px/14px Arial, Helvetica, sans-serif; color: #000000; }\r\n#container { margin: 0 auto; padding: 0; width: 940px; height: auto; }\r\n#logo { float: left; margin: 0; }\r\n #logo img { width: 424px; height: 103px; }\r\n#actions { float: right; margin: 0; width: 310px; height: 100px; background: #efefef; border: 1px solid #cccccc; }\r\n #actions img { float: left; margin: 2px 6px 2px 15px; width: 130px; height: 25px; }\r\n#footer { clear: both; margin: 20px auto 0 auto; width: 150px; }\r\n #footer img { width: 137px; height: 38px; }\r\n\r\na:link, a:active { color: #1763b9; }\r\na:hover { color: #c75a01; }\r\na:visited { color: #333333; }\r\nimg { border: none; }\r\n\r\nh1 { margin: 0 0 10px 0; font: bold 18px Arial, Helvetica, sans-serif; }\r\nh2 { margin: 8px 0 8px 15px; font: bold 14px Arial, Helvetica, sans-serif; }\r\nh3 { margin: 0; font: bold 14px Arial, Helvetica, sans-serif; }\r\np { font: normal 12px Arial, Helvetica, sans-serif; }\r\np.instructions { margin: 0 0 0 10px; font: italic 12px Arial, Helvetica, sans-serif; color: #666666; }\r\n\r\n\r\n/* CONTENTS ON PAGE SPECS */\r\n#careerContent { clear: both; padding: 15px 0 0 0; }\r\n\r\n \r\n/* DISPLAY JOB DETAILS */\r\n#detailsTable { width: 400px; }\r\n #detailsTable td.detailsHeader { width: 30%; }\r\ndiv#descriptive { float: left; width: 585px; }\r\ndiv#detailsTools { float: right; padding: 0 0 8px 0; width: 280px; background: #ffffff; border: 1px solid #cccccc; }\r\n div#detailsTools img { margin: 2px 6px 5px 15px; }\r\n\r\n/* DISPLAY APPLICATION FORM */\r\ndiv.applyBoxLeft, div.applyBoxRight { width: 450px; height: 470px; background: #f9f9f9; border: 1px solid #cccccc; border-top: none; }\r\ndiv.applyBoxLeft { float: left; margin: 0 10px 0 0; }\r\ndiv.applyBoxRight { float: right; margin: 0 0 0 10px; }\r\n div.applyBoxLeft div, div.applyBoxRight div { margin: 0 0 5px 0; padding: 3px 10px; background: #efefef; border-top: 1px solid #cccccc; border-bottom: 1px solid #cccccc; }\r\n div.applyBoxLeft table, div.applyBoxRight table { margin: 0 auto; width: 420px; }\r\n div.applyBoxLeft table td, div.applyBoxRight table td { padding: 3px; vertical-align: top; }\r\n td.label { text-align: right; width: 110px; }\r\n form#applyToJobForm { }\r\n form#applyToJobForm label { font-weight: bold; }\r\n form#applyToJobForm input.inputBoxName, form#applyToJobForm input.inputBoxNormal { width: 285px; height: 15px; }\r\n form#applyToJobForm input.submitButton { width: 197px; height: 27px; background: url(\'images/careers_submit.gif\') no-repeat; }\r\n\r\n form#applyToJobForm input.submitButtonDown { width: 197px; height: 27px; background: url(\'images/careers_submit-o.gif\') no-repeat; }\r\n form#applyToJobForm textarea { margin: 8px 0 0 0; width: 410px; height: 170px; }\r\n form#applyToJobForm textarea.inputBoxArea{ width: 285px; height: 70px; }\r\n\r\n');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (71,'CATS 2.0','Content - Search Results','
\r\n \r\n
Current Available Openings, Recently Posted Jobs:
\r\n\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (72,'CATS 2.0','Content - Questionnaire','
\r\n\r\n
\r\n
\r\n\r\n
\r\n
');
insert into `career_portal_template`(`career_portal_template_id`,`career_portal_name`,`setting`,`value`) values (73,'CATS 2.0','Content - Job Details','
\r\n \r\n
Position Details:
- By Staylor
- By RussH