DROP TABLE IF EXISTS `notes`;
CREATE TABLE `notes` (
  `id`                   INT(11)                 NOT NULL AUTO_INCREMENT,
  `order_id`             INT(11)                 NOT NULL,
  `note`                 TEXT CHARACTER SET utf8
                         COLLATE utf8_unicode_ci NOT NULL,
  `verification_type_id` INT(11),
  `verification_id`      INT(11),
  `email`                CHAR(1)                          DEFAULT NULL,
  `fax`                  CHAR(1)                          DEFAULT NULL,
  `leftmessage`          CHAR(1)                          DEFAULT NULL,
  `onlinereq`            CHAR(1)                          DEFAULT NULL,
  `priority`             CHAR(1)                          DEFAULT NULL,
  `status`               CHAR(1)                          DEFAULT NULL,
  `other`               CHAR(1)                          DEFAULT NULL,
  `user`                 INT(11)                 NOT NULL,
  `updated_by`           INT(11)                 NOT NULL,
  `created_at`           DATETIME                NOT NULL,
  `updated_at`           DATETIME                NOT NULL,
  PRIMARY KEY (`id`)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

DROP TABLE IF EXISTS `verification_types`;
CREATE TABLE `verification_types` (
  `id`   INT(11)  NOT NULL AUTO_INCREMENT,
  `name` TINYTEXT NOT NULL,
  PRIMARY KEY (`id`)
)
  ENGINE = MyISAM
  DEFAULT CHARSET = utf8;

INSERT INTO `verification_types` (`id`, `name`) VALUES
  (1, 'Criminal'),
  (2, 'Academic'),
  (3, 'ID'),
  (4, 'Employment'),
  (5, 'Reference'),
  (6, 'LRC'),
  (7, 'MVR'),
  (8, 'Malpractice'),
  (9, 'Drug');


ALTER TABLE `notes`
  AUTO_INCREMENT = 1;

ALTER TABLE `verification_types`
  AUTO_INCREMENT = 10;
