bom_file SQL

CREATE TABLE IF NOT EXISTS `bom_file` (
  `id` int(7) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` smallint(5) unsigned NOT NULL,
  `contact_id_requestor` mediumint(6) unsigned NOT NULL,
  `contact_id_uploader` mediumint(6) unsigned NOT NULL,
  `uri` varchar(128) NOT NULL,
  `separator` char(1) NOT NULL DEFAULT ',' COMMENT 'Char used to separate fields for uploaded CSV files',
  `delimiter` char(6) NOT NULL DEFAULT '"' COMMENT '&#34=" ... &#39='' ... char used to delimit text in uploaded CSV fields',
  `first_data_row` tinyint(1) DEFAULT NULL COMMENT 'Which row has the first content?',
  `partnumber_column` tinyint(2) DEFAULT NULL,
  `quantity_column` tinyint(2) DEFAULT NULL,
  `row_count` smallint(5) unsigned NOT NULL DEFAULT '0',
  `stage_number` tinyint(1) NOT NULL,
  `is_archived` tinyint(1) NOT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `datetime_created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `company_id` (`company_id`,`contact_id_uploader`),
  KEY `contact_id_requester` (`contact_id_requestor`),
  KEY `stage` (`stage_number`)
) ENGINE=MyISAM  DEFAULT CHARSET=ucs2 AUTO_INCREMENT=13 ;

INSERT INTO `bom_file` (`id`, `company_id`, `contact_id_requestor`, `contact_id_uploader`, `uri`, `separator`, `delimiter`, `first_data_row`, `partnumber_column`, `quantity_column`, `row_count`, `stage_number`, `is_archived`, `notes`, `datetime_created`) VALUES
(11, 2, 1, 0, 'C:\\path\\uploads\\boms\\uploadTester_1333123325.csv', ',', '"', 1, NULL, NULL, 0, 0, 0, NULL, '2012-03-30 16:02:05'),
(12, 0, 0, 0, 'C:\\path\\uploads\\boms\\uploadTester_1333139972.csv', '^', ''', 3, 1, 3, 0, 0, 0, '1', '2012-03-30 20:39:32');