/*
MySQL Backup
Source Server Version: 5.0.51
Source Database: gages
Date: 1/6/2011 13:36:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
--  Table structure for `calibrationcolumns`
-- ----------------------------
DROP TABLE IF EXISTS `calibrationcolumns`;
CREATE TABLE `calibrationcolumns` (
  `ID` int(11) NOT NULL auto_increment,
  `Show` tinyint(4) default NULL,
  `Order` int(11) default NULL,
  `Width` int(11) default NULL,
  `Heading` varchar(30) default NULL,
  `FieldName` varchar(30) default NULL,
  `ReadOnly` tinyint(4) default NULL,
  `ListItems` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=22;

-- ----------------------------
--  Table structure for `calibrationheader`
-- ----------------------------
DROP TABLE IF EXISTS `calibrationheader`;
CREATE TABLE `calibrationheader` (
  `Calibration_ID` int(11) NOT NULL auto_increment,
  `Gage_ID` int(11) default NULL,
  `CalibrationDate` datetime default NULL,
  `Disposition` varchar(50) default NULL,
  `Inspector` varchar(50) default NULL,
  `TestMemo` longtext,
  `Standard` varchar(50) default NULL,
  PRIMARY KEY  (`Calibration_ID`),
  KEY `Date` (`CalibrationDate`),
  KEY `GageID` (`Gage_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1106;

-- ----------------------------
--  Table structure for `checkoutcolumns`
-- ----------------------------
DROP TABLE IF EXISTS `checkoutcolumns`;
CREATE TABLE `checkoutcolumns` (
  `ID` int(11) NOT NULL auto_increment,
  `Show` tinyint(4) default NULL,
  `Order` int(11) default NULL,
  `Width` int(11) default NULL,
  `Heading` varchar(30) default NULL,
  `FieldName` varchar(30) default NULL,
  `ReadOnly` tinyint(4) default NULL,
  `ListItems` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=16;

-- ----------------------------
--  Table structure for `findgagecolumns`
-- ----------------------------
DROP TABLE IF EXISTS `findgagecolumns`;
CREATE TABLE `findgagecolumns` (
  `ID` int(11) NOT NULL auto_increment,
  `Show` tinyint(4) default NULL,
  `Order` int(11) default NULL,
  `Width` int(11) default NULL,
  `Heading` varchar(30) default NULL,
  `FieldName` varchar(30) default NULL,
  `ReadOnly` tinyint(4) default NULL,
  `ListItems` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=51;

-- ----------------------------
--  Table structure for `frequency`
-- ----------------------------
DROP TABLE IF EXISTS `frequency`;
CREATE TABLE `frequency` (
  `ID` int(11) NOT NULL auto_increment,
  `Frequency` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`Frequency`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `gagecolumns`
-- ----------------------------
DROP TABLE IF EXISTS `gagecolumns`;
CREATE TABLE `gagecolumns` (
  `ID` int(11) NOT NULL auto_increment,
  `Show` tinyint(4) default NULL,
  `Order` int(11) default NULL,
  `Width` int(11) default NULL,
  `Heading` varchar(30) default NULL,
  `FieldName` varchar(30) default NULL,
  `ReadOnly` tinyint(4) default NULL,
  `ListItems` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=51;

-- ----------------------------
--  Table structure for `gagelog`
-- ----------------------------
DROP TABLE IF EXISTS `gagelog`;
CREATE TABLE `gagelog` (
  `ID` int(11) NOT NULL auto_increment,
  `Gage_ID` int(11) default NULL,
  `SerialNumber` varchar(15) default NULL,
  `Suffix` varchar(50) default NULL,
  `Department` varchar(15) default NULL,
  `Machine` varchar(15) default NULL,
  `PartNumber` varchar(20) default NULL,
  `Operation` varchar(10) default NULL,
  `OutDate` datetime default NULL,
  `InDate` datetime default NULL,
  `Description` varchar(50) default NULL,
  `Location` varchar(40) default NULL,
  `TestMemo` longtext,
  PRIMARY KEY  (`ID`),
  KEY `GageID` (`SerialNumber`),
  KEY `GageID1` (`Gage_ID`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `gagemaster`
-- ----------------------------
DROP TABLE IF EXISTS `gagemaster`;
CREATE TABLE `gagemaster` (
  `Gage_ID` int(11) NOT NULL auto_increment,
  `Machine` varchar(50) default NULL,
  `Category` varchar(50) default NULL,
  `GageType` varchar(50) default NULL,
  `GageSN` varchar(15) default NULL,
  `Suffix` varchar(50) default NULL,
  `Bom` varchar(50) default NULL,
  `GAGEDESCRIPTION` varchar(255) default NULL,
  `GAGELOCATION` varchar(40) default NULL,
  `Size` varchar(50) default NULL,
  `FigureCode` varchar(50) default NULL,
  `ProductType` varchar(50) default NULL,
  `Ownership` varchar(20) default NULL,
  `PurchaseValue` double default NULL,
  `Released` datetime default NULL,
  `ReleasedBy` varchar(50) default NULL,
  `Standard` varchar(50) default NULL,
  `Tracibility` varchar(30) default NULL,
  `Frequency` double default NULL,
  `Range` varchar(50) default NULL,
  `Manufacturer` varchar(50) default NULL,
  `MfgSN` varchar(50) default NULL,
  `DueDate` datetime default NULL,
  `Active` tinyint(4) default NULL,
  `AltGageID` varchar(50) default NULL,
  `OrgGageSN` varchar(50) default NULL,
  `DwgID` varchar(50) default NULL,
  `DrawnBy` varchar(50) default NULL,
  `DrawnDate` varchar(50) default NULL,
  `GAGEMEMO` longtext,
  `Drawing_HYPERLINK` varchar(100) default NULL,
  `Pdf_HYPERLINK` varchar(100) default NULL,
  `PICTURELINK` varchar(255) default NULL,
  `CHECKEDOUT` int(11) default NULL,
  `CHECKEDOUTKIT` int(11) default NULL,
  `CHECKEDOUTDATE` datetime default NULL,
  PRIMARY KEY  (`Gage_ID`),
  KEY `DwgID` (`DwgID`),
  KEY `Figure Code` (`FigureCode`),
  KEY `GageLocation` (`GAGELOCATION`),
  KEY `GageSN` (`GageSN`),
  KEY `GageType` (`GageType`),
  KEY `GageType1` (`ProductType`),
  KEY `OldGageID` (`AltGageID`)
) ENGINE=InnoDB AUTO_INCREMENT=2406;

-- ----------------------------
--  Table structure for `gagetype`
-- ----------------------------
DROP TABLE IF EXISTS `gagetype`;
CREATE TABLE `gagetype` (
  `ID` int(11) NOT NULL auto_increment,
  `gtype` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`gtype`)
) ENGINE=InnoDB AUTO_INCREMENT=76;

-- ----------------------------
--  Table structure for `location`
-- ----------------------------
DROP TABLE IF EXISTS `location`;
CREATE TABLE `location` (
  `ID` int(11) NOT NULL auto_increment,
  `Location` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`Location`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `overduecolumns`
-- ----------------------------
DROP TABLE IF EXISTS `overduecolumns`;
CREATE TABLE `overduecolumns` (
  `ID` int(11) NOT NULL auto_increment,
  `Show` tinyint(4) default NULL,
  `Order` int(11) default NULL,
  `Width` int(11) default NULL,
  `Heading` varchar(30) default NULL,
  `FieldName` varchar(30) default NULL,
  `ReadOnly` tinyint(4) default NULL,
  `ListItems` longtext,
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=36;

-- ----------------------------
--  Table structure for `ownership`
-- ----------------------------
DROP TABLE IF EXISTS `ownership`;
CREATE TABLE `ownership` (
  `ID` int(11) NOT NULL auto_increment,
  `Ownership` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`Ownership`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `status`
-- ----------------------------
DROP TABLE IF EXISTS `status`;
CREATE TABLE `status` (
  `ID` int(11) NOT NULL auto_increment,
  `Status` varchar(50) default NULL,
  `Description` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`Status`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `testpointresults`
-- ----------------------------
DROP TABLE IF EXISTS `testpointresults`;
CREATE TABLE `testpointresults` (
  `TestPointResults_ID` int(11) NOT NULL auto_increment,
  `Calibration_ID` int(11) default NULL,
  `TestPoint_ID` int(11) default NULL,
  `Result` varchar(50) default NULL,
  PRIMARY KEY  (`TestPointResults_ID`),
  KEY `Calibration_ID` (`Calibration_ID`),
  KEY `TestPoint_ID` (`TestPoint_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3832;

-- ----------------------------
--  Table structure for `testpoints`
-- ----------------------------
DROP TABLE IF EXISTS `testpoints`;
CREATE TABLE `testpoints` (
  `TestPoint_ID` int(11) NOT NULL auto_increment,
  `Gage_ID` double default NULL,
  `SN` varchar(255) default NULL,
  `Test_Point` varchar(255) default NULL,
  PRIMARY KEY  (`TestPoint_ID`),
  KEY `Gage_ID` (`Gage_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4163;

-- ----------------------------
--  Table structure for `tracibility`
-- ----------------------------
DROP TABLE IF EXISTS `tracibility`;
CREATE TABLE `tracibility` (
  `ID` int(11) NOT NULL auto_increment,
  `tracibility` varchar(50) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `ID` (`tracibility`)
) ENGINE=InnoDB;

-- ----------------------------
--  Table structure for `variables`
-- ----------------------------
DROP TABLE IF EXISTS `variables`;
CREATE TABLE `variables` (
  `ID` int(11) NOT NULL auto_increment,
  `String` varchar(150) default NULL,
  `Number` varchar(50) default NULL,
  `identifier` int(11) default NULL,
  PRIMARY KEY  (`ID`),
  KEY `identifier` (`identifier`),
  KEY `Number` (`Number`)
) ENGINE=InnoDB AUTO_INCREMENT=11;

-- ----------------------------
--  Records 
-- ----------------------------
INSERT INTO `calibrationcolumns` VALUES ('17','1','3','60','Disposition','Disposition','0','Good\r\nOK\r\nBAD\r\nBest');
INSERT INTO `calibrationcolumns` VALUES ('18','1','2','100','Inspector','Inspector','0','WLS\r\nCONTRACTOR:  D.L. ELLIS');
INSERT INTO `calibrationcolumns` VALUES ('20','1','4','60','Test Memo','TestMemo','0',NULL);
INSERT INTO `calibrationcolumns` VALUES ('21','1','5','100','Standard','Standard','0','7G-00912');
INSERT INTO `checkoutcolumns` VALUES ('10','1','1','60','GageSN','GageSN','0',NULL);
INSERT INTO `checkoutcolumns` VALUES ('12','1','4','200','Machine','Machine','0','A - American Lathe\r\nB\r\nC - Mazak H-800 # 2 North\r\nD - Mazak VTC-200B\r\nE - Mazak QT-25C Cap/Nozl\r\nF - Mazak VTC-16B\r\nG - Mazak QT-25C Cap/Nozl\r\nH - Leadwell\r\nI - Mazak SQT200 MSY\r\nJ - Mazak Integrex 300 III ST\r\nK - Mazak QT15 Hydrant\r\nL - Mazak QT15 Landis\r\nM - Mazak QT28 18/28 Cell\r\nN - Mazak SQT18M 18/28\r\nO - Okuma Cap/Robot\r\nP - Mazak 620 Multiplex\r\nQ - Mazak 630 Multiplex 1\r\nR - Cincinnati Magnum\r\nS\r\nT - Mazak 630 Multiplex 2\r\nU - Mazak QT15N Landis\r\nV - Mazak H800 # 1 South\r\nW - Mazak 630 Multiplex 3\r\nX - Mazak 630 Multiplex 4\r\nY - Masco\r\nZ\r\nAA - Okuma # 1\r\nBB - Okuma # 2\r\nCC - Okuma # 3\r\nDD - Mazak FH8800 1 South\r\nEE - Mazak FH8800 2 North\r\nAABBCC - Okumas Body Cell\r\nFF - Mazak FH8800 Palletech\r\nQTWX - Multiplex 630s');
INSERT INTO `checkoutcolumns` VALUES ('13','1','5','60','Date','OutDate','0',NULL);
INSERT INTO `checkoutcolumns` VALUES ('14','1','6','60','Test Memo','TestMemo','0',NULL);
INSERT INTO `checkoutcolumns` VALUES ('15','1','2','40','Suffix','Suffix','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('1','1','4','150','Gage Type','GageType','0','Block - V\r\nBlocks - 1-2-3\r\nCaliper - Dial\r\nCaliper - Digital\r\nCaliper - Internal Dial\r\nCaliper - Vernier\r\nChecking Fixture\r\nCoaxial Indicator\r\nCoordinate Measuring Machine\r\nCylindrical Square\r\nDrill Blank\r\nF.A.I.R.\r\nFiber Optic Scope\r\nGage - Blocks\r\nGage - Bore Dog Bone\r\nGage - Chamfer\r\nGage - Conical Bluing\r\nGage - Depth\r\nGage - Dial Bore\r\nGage - Dial Thickness\r\nGage - Elect. Height\r\nGage - Electronic Dial Bore\r\nGage - Force\r\nGage - Gear\r\nGage - Go/No Go Thread Plug\r\nGage - Pin Set\r\nGage - Plug\r\nGage - Plug/Depth\r\nGage - Plug/Thread\r\nGage - Pressure\r\nGage - Radius\r\nGage - Ring\r\nGage - Snap\r\nGage - Spline\r\nGage - Step\r\nGage - Sunnen\r\nGage - Swing\r\nGage - Thread Ring\r\nGroove Measuring Instrument\r\nHardness Tester\r\nHeight Master\r\nHeight Stand\r\nIndicator - Dial\r\nIndicator - Drop\r\nIndicator - Test\r\nIndicator - Travel\r\nLazy Susan\r\nMicrometer - Blade\r\nMicrometer - Depth\r\nMicrometer - Digital\r\nMicrometer - Disc\r\nMicrometer - Flange\r\nMicrometer - Flute\r\nMicrometer - Groove\r\nMicrometer - Indicating\r\nMicrometer - Internal\r\nMicrometer - OD\r\nMicrometer - Point\r\nMicrometer - Super\r\nMicrometer - Thread\r\nMicrometer - Tube\r\nMicrometer - V-Anvil\r\nMicrometer - Wall Thickness\r\nOptical Flat\r\nOven\r\nPI Tape\r\nProtractor\r\nScale - Digital\r\nScale-Tape\r\nScale-Ruler\r\nSetting Master - Johnson Gage\r\nSetting Master - Master Thread\r\nSetting Master - Micro-Hite\r\nShadow Graph\r\nShelf Life Item\r\nSine Bar\r\nSurface Plate\r\nTemplate - BCD\r\nTemplate - MJ\r\nTemplate - CAP\r\nTemplate - TAP\r\nTemplate - 250 lbs. FLG\r\nThread Measuring Wires\r\nTommy Handle\r\nTorque Wrench - Dial\r\nTorque Wrench - Digital\r\nTorque Wrench - Manual\r\nTri-Roll\r\nGage-profile');
INSERT INTO `findgagecolumns` VALUES ('2','1','3','50','Category','Category','0','A\r\nB\r\nC\r\nD\r\nE\r\nF');
INSERT INTO `findgagecolumns` VALUES ('3','1','5','60','GageSN','GageSN','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('5','1','19','50','Frequency','Frequency','0','0\r\n3\r\n6\r\n9\r\n12\r\n18\r\n24\r\n36\r\n60\r\n120');
INSERT INTO `findgagecolumns` VALUES ('6','1','33','50','Picture','PICTURE','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('7','1','30','50','Memo','GAGEMEMO','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('8','1','23','50','Due Date','DueDate','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('9','1','8','200','Description','GAGEDESCRIPTION','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('10','1','31','50','Drawing Link','Drawing_HYPERLINK','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('11','1','32','50','Gage Link','Pdf_HYPERLINK','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('12','1','11','60','Figue Code','FigureCode','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('16','1','10','30','Size','Size','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('17','1','6','40','Suffix','Suffix','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('18','1','21','75','Manufacturer','Manufacturer','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('19','1','22','50','Mfg SN','MfgSN','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('20','1','9','75','Gage Location','GAGELOCATION','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('21','1','26','50','Orig SN','OrgGageSN','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('22','1','13','150','Product Type','ProductType','0','ALL\r\nBARREL\r\nBOTTOM PLATE\r\nCHECK\r\nCOUPLING\r\nDIRT SHIELD\r\nDOME\r\nELBOW\r\nFLANGE\r\nHYDRANT CAP\r\nINCREASING CHECK\r\nINSERT RING\r\nOPERTATING NUT\r\nO-RING\r\nNOZZLE\r\nNOZZLE CAP\r\nRS VALVE BODY\r\nSEAT RING\r\nUPPER STEM');
INSERT INTO `findgagecolumns` VALUES ('34','1','7','40','BOM','Bom','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('36','1','1','50','Machine','Machine','0','A - Mazak 630 Mplex Pipe Cell\r\nB - Haas Tool Room Lathe\r\nC - Mazak H-800 # 2 North\r\nD - Mazak VTC-200B\r\nE - Mazak QT-25C # 1\r\nF - Mazak VTC-16B\r\nG - Mazak QT-25C # 2\r\nH - Haas Tool Room Mill\r\nI - Mazak SQT200 MSY\r\nJ - Mazak Integrex 300 III ST\r\nK - Mazak QT15N Hydrant\r\nL - Mazak QT15N # 2\r\nM - Mazak QT28\r\nN - Mazak SQT18M 18/28\r\nO - Okuma Cap/Robot\r\nP - Mazak 620 Multiplex\r\nQ - Mazak 630 Multiplex 1\r\nR - Cincinnati Magnum\r\nS - Mazak Slant Turn 50 Lathe\r\nT - Mazak 630 Multiplex 2\r\nU - Mazak QT15N # 1\r\nV - Mazak H800 # 1 South\r\nW - Mazak 630 Multiplex 3\r\nX - Mazak 630 Multiplex 4\r\nY - Masco\r\nZ - Mazak QTN250-MS Hydrant\r\nDD - Mazak FH8800 1 South\r\nEE - Mazak FH8800 2 North\r\nFF - Mazak FH8800 Palletech\r\nGG - HAAS LATHE SL20 Cell\r\nHH - HAAS LATHE SL30 Cell\r\nII - HAAS MILL VF6/50 Cell\r\nAABBCC - Okumas Body Cell\r\nQTWX - Multiplex 630s\r\n18/28/VTC 200 Cell\r\nIntegrex/SQT 200/Okuma Cap Cell');
INSERT INTO `findgagecolumns` VALUES ('37','1','28','75','Drawn By','DrawnBy','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('38','1','29','50','Drawn Date','DrawnDate','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('39','1','14','60','Ownership','Ownership','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('40','1','15','60','Purchased Value','PurchaseValue','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('41','1','16','50','Released','Released','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('42','1','17','60','Released By','ReleasedBy','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('43','1','18','60','Tracibility','Tracibility','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('44','1','20','60','Range','Range','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('46','1','27','50','Dwg ID','DwgID','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('47','1','25','50','AltGageID','AltGageID','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('48','0','34','50','CHECKEDOUT','CHECKEDOUT','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('49','0','35','50','CHECKEDOUTKIT','CHECKEDOUTKIT','0',NULL);
INSERT INTO `findgagecolumns` VALUES ('50','0','36','50','CHECKEDOUTDATE','CHECKEDOUTDATE','0',NULL);
INSERT INTO `gagecolumns` VALUES ('1','1','4','150','Gage Type','GageType','0','Block - V\r\nBlocks - 1-2-3\r\nCaliper - Dial\r\nCaliper - Digital\r\nCaliper - Internal Dial\r\nCaliper - Vernier\r\nChecking Fixture\r\nCoaxial Indicator\r\nCoordinate Measuring Machine\r\nCylindrical Square\r\nDrill Blank\r\nF.A.I.R.\r\nFiber Optic Scope\r\nGage - Blocks\r\nGage - Bore Dog Bone\r\nGage - Chamfer\r\nGage - Conical Bluing\r\nGage - Depth\r\nGage - Dial Bore\r\nGage - Dial Thickness\r\nGage - Elect. Height\r\nGage - Electronic Dial Bore\r\nGage - Force\r\nGage - Gear\r\nGage - Go/No Go Thread Plug\r\nGage - Pin Set\r\nGage - Plug\r\nGage - Plug/Depth\r\nGage - Plug/Thread\r\nGage - Pressure\r\nGage - Radius\r\nGage - Ring\r\nGage - Snap\r\nGage - Spline\r\nGage - Step\r\nGage - Sunnen\r\nGage - Swing\r\nGage - Thread Ring\r\nGroove Measuring Instrument\r\nHardness Tester\r\nHeight Master\r\nHeight Stand\r\nIndicator - Dial\r\nIndicator - Drop\r\nIndicator - Test\r\nIndicator - Travel\r\nLazy Susan\r\nMicrometer - Blade\r\nMicrometer - Depth\r\nMicrometer - Digital\r\nMicrometer - Disc\r\nMicrometer - Flange\r\nMicrometer - Flute\r\nMicrometer - Groove\r\nMicrometer - Indicating\r\nMicrometer - Internal\r\nMicrometer - OD\r\nMicrometer - Point\r\nMicrometer - Super\r\nMicrometer - Thread\r\nMicrometer - Tube\r\nMicrometer - V-Anvil\r\nMicrometer - Wall Thickness\r\nOptical Flat\r\nOven\r\nPI Tape\r\nProtractor\r\nScale - Digital\r\nScale-Tape\r\nScale-Ruler\r\nSetting Master - Johnson Gage\r\nSetting Master - Master Thread\r\nSetting Master - Micro-Hite\r\nShadow Graph\r\nShelf Life Item\r\nSine Bar\r\nSurface Plate\r\nTemplate - BCD\r\nTemplate - MJ\r\nTemplate - CAP\r\nTemplate - TAP\r\nTemplate - 250 lbs. FLG\r\nThread Measuring Wires\r\nTommy Handle\r\nTorque Wrench - Dial\r\nTorque Wrench - Digital\r\nTorque Wrench - Manual\r\nTri-Roll\r\nGage-profile');
INSERT INTO `gagecolumns` VALUES ('2','1','3','50','Category','Category','0','A\r\nB\r\nC\r\nD\r\nE\r\nF');
INSERT INTO `gagecolumns` VALUES ('3','1','5','60','GageSN','GageSN','0',NULL);
INSERT INTO `gagecolumns` VALUES ('5','1','19','50','Frequency','Frequency','0','0\r\n3\r\n6\r\n9\r\n12\r\n18\r\n24\r\n36\r\n60\r\n120');
INSERT INTO `gagecolumns` VALUES ('6','1','33','50','Picture','PICTURELINK','0',NULL);
INSERT INTO `gagecolumns` VALUES ('7','1','30','50','Memo','GAGEMEMO','0',NULL);
INSERT INTO `gagecolumns` VALUES ('8','1','23','50','Due Date','DueDate','0',NULL);
INSERT INTO `gagecolumns` VALUES ('9','1','8','200','Description','GAGEDESCRIPTION','0',NULL);
INSERT INTO `gagecolumns` VALUES ('10','1','31','50','Drawing Link','Drawing_HYPERLINK','0',NULL);
INSERT INTO `gagecolumns` VALUES ('11','1','32','50','Certification Link','Pdf_HYPERLINK','0',NULL);
INSERT INTO `gagecolumns` VALUES ('12','1','11','60','Figue Code','FigureCode','0',NULL);
INSERT INTO `gagecolumns` VALUES ('16','1','10','30','Size','Size','0',NULL);
INSERT INTO `gagecolumns` VALUES ('17','1','6','40','Suffix','Suffix','0',NULL);
INSERT INTO `gagecolumns` VALUES ('18','1','21','75','Manufacturer','Manufacturer','0',NULL);
INSERT INTO `gagecolumns` VALUES ('19','1','22','50','Mfg SN','MfgSN','0',NULL);
INSERT INTO `gagecolumns` VALUES ('20','1','9','75','Gage Location','GAGELOCATION','0',NULL);
INSERT INTO `gagecolumns` VALUES ('21','1','26','50','Orig SN','OrgGageSN','0',NULL);
INSERT INTO `gagecolumns` VALUES ('22','1','13','150','Product Type','ProductType','0','ALL\r\nBARREL\r\nBOTTOM PLATE\r\nCHECK\r\nCOUPLING\r\nDIRT SHIELD\r\nDOME\r\nELBOW\r\nFLANGE\r\nHYDRANT CAP\r\nINCREASING CHECK\r\nINSERT RING\r\nOPERTATING NUT\r\nO-RING\r\nNOZZLE\r\nNOZZLE CAP\r\nRS VALVE BODY\r\nSEAT RING\r\nUPPER STEM');
INSERT INTO `gagecolumns` VALUES ('34','1','7','40','BOM','Bom','0',NULL);
INSERT INTO `gagecolumns` VALUES ('36','1','1','50','Machine','Machine','0','A - Mazak 630 Mplex Pipe Cell\r\nB - Haas Tool Room Lathe\r\nC - Mazak H-800 # 2 North\r\nD - Mazak VTC-200B\r\nE - Mazak QT-25C # 1\r\nF - Mazak VTC-16B\r\nG - Mazak QT-25C # 2\r\nH - Haas Tool Room Mill\r\nI - Mazak SQT200 MSY\r\nJ - Mazak Integrex 300 III ST\r\nK - Mazak QT15N Hydrant\r\nL - Mazak QT15N # 2\r\nM - Mazak QT28\r\nN - Mazak SQT18M 18/28\r\nO - Okuma Cap/Robot\r\nP - Mazak 620 Multiplex\r\nQ - Mazak 630 Multiplex 1\r\nR - Cincinnati Magnum\r\nS - Mazak Slant Turn 50 Lathe\r\nT - Mazak 630 Multiplex 2\r\nU - Mazak QT15N # 1\r\nV - Mazak H800 # 1 South\r\nW - Mazak 630 Multiplex 3\r\nX - Mazak 630 Multiplex 4\r\nY - Masco\r\nZ - Mazak QTN250-MS Hydrant\r\nDD - Mazak FH8800 1 South\r\nEE - Mazak FH8800 2 North\r\nFF - Mazak FH8800 Palletech\r\nGG - HAAS LATHE SL20 Cell\r\nHH - HAAS LATHE SL30 Cell\r\nII - HAAS MILL VF6/50 Cell\r\nAABBCC - Okumas Body Cell\r\nQTWX - Multiplex 630s\r\n18/28/VTC 200 Cell\r\nIntegrex/SQT 200/Okuma Cap Cell');
INSERT INTO `gagecolumns` VALUES ('37','1','28','75','Drawn By','DrawnBy','0',NULL);
INSERT INTO `gagecolumns` VALUES ('38','1','29','50','Drawn Date','DrawnDate','0',NULL);
INSERT INTO `gagecolumns` VALUES ('39','1','14','60','Ownership','Ownership','0',NULL);
INSERT INTO `gagecolumns` VALUES ('40','1','15','60','Purchased Value','PurchaseValue','0',NULL);
INSERT INTO `gagecolumns` VALUES ('41','1','16','50','Released','Released','0',NULL);
INSERT INTO `gagecolumns` VALUES ('42','1','17','60','Released By','ReleasedBy','0',NULL);
INSERT INTO `gagecolumns` VALUES ('43','1','18','60','Tracibility','Tracibility','0',NULL);
INSERT INTO `gagecolumns` VALUES ('44','1','20','60','Range','Range','0',NULL);
INSERT INTO `gagecolumns` VALUES ('46','1','27','50','Dwg ID','DwgID','0',NULL);
INSERT INTO `gagecolumns` VALUES ('47','1','25','50','AltGageID','AltGageID','0',NULL);
INSERT INTO `gagecolumns` VALUES ('48','0','34','50','CHECKEDOUT','CHECKEDOUT','0',NULL);
INSERT INTO `gagecolumns` VALUES ('49','0','35','50','CHECKEDOUTKIT','CHECKEDOUTKIT','0',NULL);
INSERT INTO `gagecolumns` VALUES ('50','0','36','50','CHECKEDOUTDATE','CHECKEDOUTDATE','0',NULL);
INSERT INTO `gagemaster` VALUES ('2','Personal Property','A','Caliper - Dial','7G-00001','002',NULL,'DIAL CALIPER, 6\"','#7017 K. CRAIN','0600','ALL','ALL',NULL,'0',NULL,NULL,NULL,NULL,'12','0-6\"','FRANKFORD ARSENAL','','2008-05-24 00:00:00','1',NULL,'A0002',NULL,NULL,NULL,'Standard:  MODEL RS43A1 JOB BLOCK SET\r\nMake:  STARRETT\r\nSerial #:  32978.3, E0012\r\nCalibration Cycle:  5 YEAR',NULL,'','P:\\engineering\\applications\\JPG\\Gauges\\7G-00001.JPG','0','0','2000-12-14 00:00:00');
INSERT INTO `gagemaster` VALUES ('3','Personal Property','A','Caliper - Dial','7G-00005','001',NULL,'DIAL CALIPER, 12\"','#7279 J. HUBBARD','1200','ALL','ALL','personal property','0',NULL,NULL,NULL,NULL,'12','0-12\"',NULL,'1-01352','2012-01-04 00:00:00','1',NULL,'',NULL,NULL,NULL,'INDIVIDUALS PROPERTY\r\n\r\nStandard: MODEL RS43A1 JOB BLOCK SET\r\nMake:  STARRETT\r\nSerial #:  32978.3, E0012\r\nCalibration Cycle:  5 YEAR','',NULL,'P:\\engineering\\applications\\JPG\\Gauges\\7G-00005.JPG','0','0','2008-04-02 23:55:21');
INSERT INTO `gagemaster` VALUES ('4','M - Mazak QT28','A','Caliper - Digital','7G-00006','001','','DIGITAL CALIPER, 18\"','Mazak QT28','1800','ALL','ALL','','0',NULL,NULL,NULL,NULL,'12','0-18\"','MITUTOYO MODEL CD-18\"C','0014555','2011-10-15 00:00:00','1',NULL,'A0006',NULL,NULL,NULL,'CALIPER WAS SENT FOR REPAIR ','',NULL,'P:\\engineering\\applications\\JPG\\Gauges\\7G-00006.JPG','18','2279','2009-03-23 14:29:09');
INSERT INTO `gagemaster` VALUES ('8',NULL,'A','Thickness Gauge','7G-00010','001',NULL,'H&HIP','QC LAB',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,'0','0-6\"',NULL,NULL,'2007-05-04 00:00:00','1',NULL,'A0010',NULL,NULL,NULL,NULL,NULL,NULL,'P:\\engineering\\applications\\JPG\\Gauges\\7G-00010.jpg','0','0',NULL);
INSERT INTO `gagemaster` VALUES ('10',NULL,'A','Gage - Depth','7G-00012','001',NULL,'Depth Gauge','QC LAB','0900','ALL','ALL',NULL,'0',NULL,NULL,NULL,NULL,'12','0-9\"','STARRETT',NULL,'2011-05-06 00:00:00','1',NULL,'A0012',NULL,NULL,NULL,'Standard:  MODEL RS43A1 JOB BLOCK SET\r\nMake:  STARRETT\r\nSerial #:  32978.3, E0012\r\nCalibration Cycle:  5 YEAR',NULL,'','P:\\engineering\\applications\\JPG\\Gauges\\7G-00012.jpg','0','0',NULL);
INSERT INTO `gagemaster` VALUES ('2404','18/28/VTC 200 Cell',NULL,'Gage - Go/No Go Thread Plug','7G-10043','004',NULL,'3/8-16 UNC-2B GO / NO GO GAGE','3/8-16UNC',NULL,NULL,NULL,NULL,NULL,'2011-01-06 00:00:00','R. SMITH',NULL,NULL,'0',NULL,'GREENFIELD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'CALIBRATION NOT REQUIRED',NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `gagemaster` VALUES ('2405','8/28/VTC 200 Cell',NULL,'Gage - Go/No Go Thread Plug','7G-10043 ','005','','.2764 GO .2817 NO GO GAGE','M42','5/16 - 18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,NULL,NULL,NULL,'G-1311',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO `gagetype` VALUES ('1','Block - V');
INSERT INTO `gagetype` VALUES ('2','Blocks - 1-2-3');
INSERT INTO `gagetype` VALUES ('3','Caliper - Dial');
INSERT INTO `gagetype` VALUES ('4','Caliper - Digital');
INSERT INTO `gagetype` VALUES ('5','Caliper - Internal Dial');
INSERT INTO `gagetype` VALUES ('6','Caliper - Vernier');
INSERT INTO `gagetype` VALUES ('7','Checking Fixture');
INSERT INTO `gagetype` VALUES ('8','Coaxial Indicator');
INSERT INTO `gagetype` VALUES ('9','Coordinate Measuring Machine');
INSERT INTO `gagetype` VALUES ('10','Cylindrical Square');
INSERT INTO `gagetype` VALUES ('11','Drill Blank');
INSERT INTO `gagetype` VALUES ('12','F.A.I.R.');
INSERT INTO `gagetype` VALUES ('13','Fiber Optic Scope');
INSERT INTO `gagetype` VALUES ('14','Gage - Blocks');
INSERT INTO `gagetype` VALUES ('15','Gage - Chamfer');
INSERT INTO `gagetype` VALUES ('16','Gage - Conical Bluing');
INSERT INTO `gagetype` VALUES ('17','Gage - Depth');
INSERT INTO `gagetype` VALUES ('18','Gage - Dial Bore');
INSERT INTO `gagetype` VALUES ('19','Gage - Dial Thickness');
INSERT INTO `gagetype` VALUES ('20','Gage - Elect. Height');
INSERT INTO `gagetype` VALUES ('21','Gage - Electronic Dial Bore');
INSERT INTO `gagetype` VALUES ('22','Gage - Force');
INSERT INTO `gagetype` VALUES ('23','Gage - Gear');
INSERT INTO `gagetype` VALUES ('24','Gage - Go/No Go Thread Plug');
INSERT INTO `gagetype` VALUES ('25','Gage - Pin Set');
INSERT INTO `gagetype` VALUES ('26','Gage - Plug');
INSERT INTO `gagetype` VALUES ('27','Gage - Plug/Depth');
INSERT INTO `gagetype` VALUES ('28','Gage - Pressure');
INSERT INTO `gagetype` VALUES ('29','Gage - Radius');
INSERT INTO `gagetype` VALUES ('30','Gage - Ring');
INSERT INTO `gagetype` VALUES ('31','Gage - Snap');
INSERT INTO `gagetype` VALUES ('32','Gage - Spline');
INSERT INTO `gagetype` VALUES ('33','Gage - Step');
INSERT INTO `gagetype` VALUES ('34','Gage - Sunnen');
INSERT INTO `gagetype` VALUES ('35','Gage - Swing');
INSERT INTO `gagetype` VALUES ('36','Gage - Thread Ring');
INSERT INTO `gagetype` VALUES ('37','Groove Measuring Instrument');
INSERT INTO `gagetype` VALUES ('38','Hardness Tester');
INSERT INTO `gagetype` VALUES ('39','Height Master');
INSERT INTO `gagetype` VALUES ('40','Height Stand');
INSERT INTO `gagetype` VALUES ('41','Indicator - Dial');
INSERT INTO `gagetype` VALUES ('42','Indicator - Drop');
INSERT INTO `gagetype` VALUES ('43','Indicator - Test');
INSERT INTO `gagetype` VALUES ('44','Indicator - Travel');
INSERT INTO `gagetype` VALUES ('45','Lazy Susan');
INSERT INTO `gagetype` VALUES ('46','Micrometer - Blade');
INSERT INTO `gagetype` VALUES ('47','Micrometer - Depth');
INSERT INTO `gagetype` VALUES ('48','Micrometer - Digital');
INSERT INTO `gagetype` VALUES ('49','Micrometer - Disc');
INSERT INTO `gagetype` VALUES ('50','Micrometer - Flange');
INSERT INTO `gagetype` VALUES ('51','Micrometer - Flute');
INSERT INTO `gagetype` VALUES ('52','Micrometer - Groove');
INSERT INTO `gagetype` VALUES ('53','Micrometer - Indicating');
INSERT INTO `gagetype` VALUES ('54','Micrometer - Internal');
INSERT INTO `gagetype` VALUES ('55','Micrometer - OD');
INSERT INTO `gagetype` VALUES ('56','Micrometer - Point');
INSERT INTO `gagetype` VALUES ('57','Micrometer - Super');
INSERT INTO `gagetype` VALUES ('58','Micrometer - Thread');
INSERT INTO `gagetype` VALUES ('59','Micrometer - Tube');
INSERT INTO `gagetype` VALUES ('60','Micrometer - V-Anvil');
INSERT INTO `gagetype` VALUES ('61','Micrometer - Wall Thickness');
INSERT INTO `gagetype` VALUES ('62','Optical Flat');
INSERT INTO `gagetype` VALUES ('63','Oven');
INSERT INTO `gagetype` VALUES ('64','PI Tape');
INSERT INTO `gagetype` VALUES ('65','Protractor');
INSERT INTO `gagetype` VALUES ('66','Setting Master - Johnson Gage');
INSERT INTO `gagetype` VALUES ('67','Setting Master - Master Thread');
INSERT INTO `gagetype` VALUES ('68','Setting Master - Micro-Hite');
INSERT INTO `gagetype` VALUES ('69','Shadow Graph');
INSERT INTO `gagetype` VALUES ('70','Shelf Life Item');
INSERT INTO `gagetype` VALUES ('71','Sine Bar');
INSERT INTO `gagetype` VALUES ('72','Surface Plate');
INSERT INTO `gagetype` VALUES ('73','Thread Measuring Wires');
INSERT INTO `gagetype` VALUES ('74','Tommy Handle');
INSERT INTO `gagetype` VALUES ('75','Tri-Roll');
INSERT INTO `overduecolumns` VALUES ('17','1','1','60','Due Date','DueDate','0',NULL);
INSERT INTO `overduecolumns` VALUES ('18','1','2','70','GageSN','GageSN','0',NULL);
INSERT INTO `overduecolumns` VALUES ('28','1','3','40','Suffix','Suffix','0',NULL);
INSERT INTO `overduecolumns` VALUES ('33','1','5','50','Size','Size','0',NULL);
INSERT INTO `overduecolumns` VALUES ('34','1','6','250','Description','GAGEDESCRIPTION','0',NULL);
INSERT INTO `overduecolumns` VALUES ('35','1','7','150','Location','GAGELOCATION','0',NULL);