/*
 Navicat Premium Data Transfer

 Source Server         : Localhost
 Source Server Type    : MySQL
 Source Server Version : 50534
 Source Host           : localhost
 Source Database       : itrims_angular

 Target Server Type    : MySQL
 Target Server Version : 50534
 File Encoding         : utf-8

 Date: 10/05/2016 17:13:42 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `employment`
-- ----------------------------
DROP TABLE IF EXISTS `employment`;
CREATE TABLE `employment` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '',
  `is_active` char(1) DEFAULT NULL,
  `type_id` int(10) DEFAULT NULL,
  `work_number_code` varchar(255) DEFAULT '1',
  `is_contact_mail` char(1) DEFAULT NULL,
  `is_contact_phone` char(1) DEFAULT NULL,
  `is_contact_fax` char(1) DEFAULT NULL,
  `is_contact_email` char(1) DEFAULT NULL,
  `is_contact_online` char(1) DEFAULT NULL,
  `contact_name` varchar(100) DEFAULT NULL,
  `website` varchar(100) DEFAULT NULL,
  `street_address1` varchar(100) DEFAULT NULL,
  `street_address2` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `state_id` char(2) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `country_id` char(2) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `recruiter_notes` text,
  `employee_instructions` text,
  `fee` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `employment`
-- ----------------------------
BEGIN;
INSERT INTO `employment` VALUES ('7', 'sdfgsfd', '1', null, '2', '1', '1', null, null, null, null, null, null, null, null, null, null, 'US', '34234324', null, null, null, null, null), ('8', 'asfasdf', '1', '1', null, '1', '1', null, null, null, null, null, null, null, 'Texas', 'AR', null, 'US', null, null, null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `messages`
-- ----------------------------
DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `id` tinyint(3) unsigned NOT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  `label` varchar(50) NOT NULL,
  `text` text,
  `has_expiration` char(1) DEFAULT NULL,
  `expiration` date DEFAULT NULL,
  `ord` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `messages`
-- ----------------------------
BEGIN;
INSERT INTO `messages` VALUES ('1', '1', 'No Name Attached Note', 'ID - No name attached = The social security number provided is a valid number, however, there was no name attached to it. This could be due to several reasons, including but not limited to, not having established credit yet, non US citizen, or recently issued number. Only employers may register to use the Social Security Number Verification Service to verify current or former employee social security numbers, and only for wage reporting. For specific information, please contact the Social Security Administration directly at http://www.ssa.gov/employer/ssnv.htm/. The Business Services Online Welcome page will provide the relevant information. Thank you!', null, null, '0'), ('2', '1', 'Unable to determine', 'ID – Unable to Determine = We were unable to verify the Social Security Number provided. This social security number could have been issued after June, 2011 when the Social Security Administration implemented a new randomization process. Social security numbers issued after June, 2011 will no longer be able to be verified through consumer reporting agencies. Only employers may register to use the Social Security Number Verification Service to verify current or former employee social security numbers, and only for wage reporting. For specific information, please contact the Social Security Administration directly at http://www.ssa.gov/employer/ssnv.htm/. The Business Services Online Welcome page will provide the relevant information. Thank you', null, null, '1'), ('3', '2', 'NSC Website', 'NSC Website Message', null, null, '0'), ('4', '2', 'General', 'General Message', '1', null, '2'), ('5', '2', 'ID', 'dfasdf', '1', null, '3'), ('6', '2', 'Order Entry', 'adsfasdf', '1', null, '4'), ('7', '2', 'Academic', 'asdf', '1', null, '5'), ('8', '2', 'Criminal', 'asdfa', '1', null, '6'), ('9', '2', 'References', 'sdfadsafds', '1', '2016-08-29', '7'), ('10', '2', 'LRC', 'asdfasdf', '1', '2016-09-26', '8'), ('11', '2', 'MVR', null, '1', null, '9'), ('12', '2', 'Malpractice', null, '1', null, '10'), ('13', '1', 'NSC Statement', 'sdfasdfad', '', '2016-06-13', '2'), ('14', '1', 'OOC Statement', null, null, null, '3'), ('15', '1', 'Request Disclaimer', null, null, null, '4'), ('16', '1', 'Results Disclaimer (Excluding Crim) ', null, null, null, '5'), ('17', '1', 'Results Disclaimer (Criminal Only) ', null, null, null, '6'), ('18', '3', 'Recruiter Message (Message to All Active Recruiter', null, '1', null, '0'), ('19', '2', 'Work Number Website', 'Work Number Website', null, null, '1'), ('20', '2', 'E/V', null, '1', null, '11'), ('21', '2', 'Drug Screening', null, '1', null, '12');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;