CREATE TABLE `jobhead` (
	`OID` INT(11) NOT NULL AUTO_INCREMENT,
	`JOB` VARCHAR(10) NULL DEFAULT NULL,
	`col_OWSTATUS` VARCHAR(10) NULL DEFAULT NULL,
	`col_OWCOMMISSION` VARCHAR(500) NULL DEFAULT NULL,
	`colACCN` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWORDERDATE` DATETIME NULL DEFAULT NULL,
	`colDO` CHAR(1) NULL DEFAULT NULL,
	`col_OWWORKORDER` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWSALESLNAM_R` VARCHAR(50) NULL DEFAULT NULL,
	`col_OWSALESLNAM_L` VARCHAR(50) NULL DEFAULT NULL,
	`colLNAM_R` VARCHAR(50) NULL DEFAULT NULL,
	`colLNAM_L` VARCHAR(50) NULL DEFAULT NULL,
	`colSPH_R` DOUBLE NULL DEFAULT NULL,
	`colSPH_L` DOUBLE NULL DEFAULT NULL,
	`colCYL_R` DOUBLE NULL DEFAULT NULL,
	`colCYL_L` DOUBLE NULL DEFAULT NULL,
	`colADD_R` DOUBLE NULL DEFAULT NULL,
	`colADD_L` DOUBLE NULL DEFAULT NULL,
	`colPRVM_R` DOUBLE NULL DEFAULT NULL,
	`colPRVM_L` DOUBLE NULL DEFAULT NULL,
	`colMINEDG_R` DOUBLE NULL DEFAULT NULL,
	`colMINEDG_L` DOUBLE NULL DEFAULT NULL,
	`colMINCTR_R` DOUBLE NULL DEFAULT NULL,
	`colMINCTR_L` DOUBLE NULL DEFAULT NULL,
	`col_OWRODIS_R` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWRODIS_L` VARCHAR(30) NULL DEFAULT NULL,
	`colLIND_R` DOUBLE NULL DEFAULT NULL,
	`colLIND_L` DOUBLE NULL DEFAULT NULL,
	`colLTYPE_R` VARCHAR(50) NULL DEFAULT NULL,
	`colLTYPE_L` VARCHAR(50) NULL DEFAULT NULL,
	`colAMSG` VARCHAR(1200) NULL DEFAULT NULL,
	`col_OWORDERTYPE` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWLNAMEXT_R` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWLNAMEXT_L` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWACOATEXT_R` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWACOATEXT_L` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWTINTEXT_R` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWTINTEXT_L` VARCHAR(100) NULL DEFAULT NULL,
	`col_OWFREEFORM_R` CHAR(1) NULL DEFAULT NULL,
	`col_OWFREEFORM_L` CHAR(1) NULL DEFAULT NULL,
	`colPHOTO_R` CHAR(1) NULL DEFAULT NULL,
	`colPHOTO_L` CHAR(1) NULL DEFAULT NULL,
	`colPOLAR_R` CHAR(1) NULL DEFAULT NULL,
	`colPOLAR_L` CHAR(1) NULL DEFAULT NULL,
	`col_OWSPORT_R` CHAR(1) NULL DEFAULT NULL,
	`col_OWSPORT_L` CHAR(1) NULL DEFAULT NULL,
	`colLMATNAME_R` VARCHAR(15) NULL DEFAULT NULL,
	`colLMATNAME_L` VARCHAR(15) NULL DEFAULT NULL,
	`colACOAT_R` VARCHAR(30) NULL DEFAULT NULL,
	`colACOAT_L` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWHCOAT_R` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWHCOAT_L` VARCHAR(30) NULL DEFAULT NULL,
	`colTINT_R` VARCHAR(30) NULL DEFAULT NULL,
	`colTINT_L` VARCHAR(30) NULL DEFAULT NULL,
	`col_OWMBASE_R` DOUBLE NULL DEFAULT NULL,
	`col_OWMBASE_L` DOUBLE NULL DEFAULT NULL,
	`col_OWDELIVERYNOTE` VARCHAR(50) NULL DEFAULT NULL,
	`col_OWEXTACCN` VARCHAR(50) NULL DEFAULT NULL,
	`col_OWISCREDITNOTE` CHAR(1) NULL DEFAULT NULL,
	`col_OWISCOMPLAINT` CHAR(1) NULL DEFAULT NULL,
	`col_OWISPERSONALNEED` CHAR(1) NULL DEFAULT NULL,
	`col_OWDELACCN` VARCHAR(50) NULL DEFAULT NULL,
	`col_OWEXTORDERNO` VARCHAR(50) NULL DEFAULT NULL,
	`GCRecord` INT(11) NULL DEFAULT NULL,
	`OptimisticLockField` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`OID`),
	UNIQUE INDEX `Job` (`JOB`),
	INDEX `col_OWCOMMISSION` (`col_OWCOMMISSION`(255)),
	INDEX `col_OWORDERDATE` (`col_OWORDERDATE`),
	INDEX `colDO` (`colDO`),
	INDEX `col_OWSTATUS` (`col_OWSTATUS`),
	INDEX `colLNAM_R` (`colLNAM_R`),
	INDEX `colLNAM_L` (`colLNAM_L`),
	INDEX `col_OWWORKORDER` (`col_OWWORKORDER`),
	INDEX `col_OWSALESLNAM_R` (`col_OWSALESLNAM_R`),
	INDEX `col_OWSALESLNAM_L` (`col_OWSALESLNAM_L`),
	INDEX `col_OWDELACCN` (`col_OWDELACCN`),
	INDEX `col_OWORDERTYPE` (`col_OWORDERTYPE`),
	INDEX `colSPH_R` (`colSPH_R`),
	INDEX `colSPH_L` (`colSPH_L`),
	INDEX `colCYL_R` (`colCYL_R`),
	INDEX `colCYL_L` (`colCYL_L`),
	INDEX `colADD_R` (`colADD_R`),
	INDEX `colADD_L` (`colADD_L`),
	INDEX `colPRVM_R` (`colPRVM_R`),
	INDEX `colPRVM_L` (`colPRVM_L`),
	INDEX `colMINEDG_R` (`colMINEDG_R`),
	INDEX `colMINEDG_L` (`colMINEDG_L`),
	INDEX `colMINCTR_R` (`colMINCTR_R`),
	INDEX `colMINCTR_L` (`colMINCTR_L`),
	INDEX `colLIND_R` (`colLIND_R`),
	INDEX `colLIND_L` (`colLIND_L`),
	INDEX `colLMATNAME_R` (`colLMATNAME_R`),
	INDEX `colLMATNAME_L` (`colLMATNAME_L`),
	INDEX `colLTYPE_R` (`colLTYPE_R`),
	INDEX `colLTYPE_L` (`colLTYPE_L`),
	INDEX `colACOAT_R` (`colACOAT_R`),
	INDEX `colACOAT_L` (`colACOAT_L`),
	INDEX `colAMSG` (`colAMSG`(255)),
	INDEX `col_OWLNAMEXT_R` (`col_OWLNAMEXT_R`),
	INDEX `col_OWLNAMEXT_L` (`col_OWLNAMEXT_L`),
	INDEX `col_OWACOATEXT_R` (`col_OWACOATEXT_R`),
	INDEX `col_OWACOATEXT_L` (`col_OWACOATEXT_L`),
	INDEX `col_OWTINTEXT_R` (`col_OWTINTEXT_R`),
	INDEX `col_OWTINTEXT_L` (`col_OWTINTEXT_L`),
	INDEX `col_OWFREEFORM_R` (`col_OWFREEFORM_R`),
	INDEX `col_OWFREEFORM_L` (`col_OWFREEFORM_L`),
	INDEX `colTINT_R` (`colTINT_R`),
	INDEX `colTINT_L` (`colTINT_L`),
	INDEX `col_OWHCOAT_R` (`col_OWHCOAT_R`),
	INDEX `col_OWHCOAT_L` (`col_OWHCOAT_L`),
	INDEX `colPHOTO_R` (`colPHOTO_R`),
	INDEX `colPHOTO_L` (`colPHOTO_L`),
	INDEX `colPOLAR_R` (`colPOLAR_R`),
	INDEX `colPOLAR_L` (`colPOLAR_L`),
	INDEX `col_OWSPORT_R` (`col_OWSPORT_R`),
	INDEX `col_OWSPORT_L` (`col_OWSPORT_L`),
	INDEX `col_OWMBASE_R` (`col_OWMBASE_R`),
	INDEX `col_OWMBASE_L` (`col_OWMBASE_L`),
	INDEX `col_OWRODIS_R` (`col_OWRODIS_R`),
	INDEX `col_OWRODIS_L` (`col_OWRODIS_L`),
	INDEX `col_OWDELIVERYNOTE` (`col_OWDELIVERYNOTE`),
	INDEX `col_OWISCREDITNOTE` (`col_OWISCREDITNOTE`),
	INDEX `col_OWISCOMPLAINT` (`col_OWISCOMPLAINT`),
	INDEX `col_OWISPERSONALNEED` (`col_OWISPERSONALNEED`),
	INDEX `col_OWEXTACCN` (`col_OWEXTACCN`),
	INDEX `col_OWEXTORDERNO` (`col_OWEXTORDERNO`),
	INDEX `colACCN` (`colACCN`(10), `col_OWORDERDATE`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=10638132
;