SET FOREIGN_KEY_CHECKS=0;

DROP TABLE IF EXISTS `job_steps`;
CREATE TABLE `job_steps` (
  `step_number` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `step_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `step_key` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`step_number`)
);

INSERT INTO `job_steps` VALUES ('0', 'Quote Letter in progress', 'quote_letter');
INSERT INTO `job_steps` VALUES ('1', 'Created', 'created');
INSERT INTO `job_steps` VALUES ('2', 'Job ticket in progress', 'job_ticket');
INSERT INTO `job_steps` VALUES ('3', 'RFQ', 'rfq');
INSERT INTO `job_steps` VALUES ('4', 'PO(s) in progress', 'purchase_order');
INSERT INTO `job_steps` VALUES ('5', 'Invoice (in progress)', 'invoice');
INSERT INTO `job_steps` VALUES ('6', 'Closed', 'closed');