-- MySQL dump 8.23 -- -- Host: localhost Database: nutek2 --------------------------------------------------------- -- Server version 3.23.58 -- -- Table structure for table `dist` -- CREATE TABLE dist ( distID int(11) unsigned NOT NULL auto_increment, distcompanyname varchar(100) default NULL, distcontactname varchar(60) default NULL, distcontacttitle varchar(60) default NULL, distaddress1 blob, distcity varchar(40) default NULL, diststate varchar(20) default NULL, distzipcode int(7) default NULL, distphoneno text, distfaxno text, PRIMARY KEY (distID) ) TYPE=MyISAM; -- -- Dumping data for table `dist` -- INSERT INTO dist VALUES (2,'NuTek, Inc.','Tom Allen','President','PO Box 9908','Tyler','TX',75711,'(903)530-6169','(413)674-9534'); INSERT INTO dist VALUES (7,'ILMC','Larry Vassil','President','5163 West 137th St.','Brookpark','OH',44142,'(216)916-1590','(216)916-1594'); INSERT INTO dist VALUES (8,'BIOPUR','Mark Meyer','','PO Box 9098','Greensboro','NC',27429,'(336)337-1009','(336)574-1841'); INSERT INTO dist VALUES (9,'Mike','','','','','',0,'()-','()-'); INSERT INTO dist VALUES (10,'American Chemical Systems','Brad Wickham','','PO Box 782647','Wichita','KS',67278,'(800)889-3489','(316)683-3489'); INSERT INTO dist VALUES (11,'M & L Suply','Ray Salmons','Sales Representative','987 East Tallmedge Ave.','Akron','OH',44310,'(330)633-6241','(330)633-3915'); -- -- Table structure for table `nutek` -- CREATE TABLE nutek ( ID int(11) unsigned NOT NULL auto_increment, distID int(11) NOT NULL default '0', date text, proposalno varchar(20) default NULL, phoneno text, companyname varchar(80) default NULL, address blob, city varchar(50) default NULL, state varchar(20) default NULL, zip int(7) default NULL, surname varchar(60) default NULL, firstname varchar(60) default NULL, lastname varchar(60) default NULL, title varchar(20) default NULL, costwater double default NULL, costgas double default NULL, o3h2o double default NULL, temperaturerise double default NULL, o3hot double default NULL, make1 varchar(100) default NULL, size1 double default NULL, loads1 double default NULL, boiler double default NULL, dryersave double default NULL, make2 varchar(100) default NULL, size2 double default NULL, loads2 double default NULL, gallonsperpound double default NULL, ironersavings double default NULL, make3 varchar(100) default NULL, size3 double default NULL, loads3 double default NULL, inputchem double default NULL, o3chemical double default NULL, make4 varchar(100) default NULL, size4 double default NULL, loads4 double default NULL, inputlinen double default NULL, linensavings double default NULL, make5 varchar(100) default NULL, size5 double default NULL, loads5 double default NULL, loadfactor double default NULL, make6 varchar(100) default NULL, size6 double default NULL, loads6 double default NULL, totalloads double default NULL, flatwork double default NULL, occupancy double default NULL, description blob, installation double default NULL, rooms double default NULL, priceequ double default NULL, totalequip double default NULL, daysperweek int(11) default NULL, payment double default NULL, roi double default NULL, dryercostbtu double default NULL, dryerthermsbtu double default NULL, year1 double default NULL, year2 double default NULL, year3 double default NULL, year4 double default NULL, year5 double default NULL, year6 double default NULL, wscostperpound double default NULL, ozswcst double default NULL, ccstperld1 double default NULL, cstpermo1 double default NULL, ocstperld1 double default NULL, ozpermo1 double default NULL, savperld1 double default NULL, netpermo1 double default NULL, hwcostperpound double default NULL, ozhwcst double default NULL, ccstperld2 double default NULL, cstpermo2 double default NULL, ocstperld2 double default NULL, ozpermo2 double default NULL, savperld2 double default NULL, netpermo2 double default NULL, dryercost double default NULL, ozotcst double default NULL, ccstperld3 double default NULL, cstpermo3 double default NULL, ocstperld3 double default NULL, ozpermo3 double default NULL, savperld3 double default NULL, netpermo3 double default NULL, cironercst double default NULL, o3ironercst double default NULL, ccstperld4 double default NULL, cstpermo4 double default NULL, ocstperld4 double default NULL, ozpermo4 double default NULL, savperld4 double default NULL, netpermo4 double default NULL, cchemcst double default NULL, ochemcst double default NULL, ccstperld5 double default NULL, cstpermo5 double default NULL, ocstperld5 double default NULL, ozpermo5 double default NULL, savperld5 double default NULL, netpermo5 double default NULL, clinencst double default NULL, o3linencst double default NULL, ccstperld6 double default NULL, cstpermo6 double default NULL, ocstperld6 double default NULL, ozpermo6 double default NULL, savperld6 double default NULL, netpermo6 double default NULL, totalcostperpound double default NULL, ozttllb double default NULL, ttlccost double default NULL, ttlocost double default NULL, ttlsave double default NULL, nutek1 double default NULL, net1 double default NULL, ancash1 double default NULL, acash1 double default NULL, eyr1 double default NULL, roi1 double default NULL, nutek2 double default NULL, net2 double default NULL, ancash2 double default NULL, acash2 double default NULL, eyr2 double default NULL, roi2 double default NULL, nutek3 double default NULL, net3 double default NULL, ancash3 double default NULL, acash3 double default NULL, eyr3 double default NULL, roi3 double default NULL, nutek4 double default NULL, net4 double default NULL, ancash4 double default NULL, acash4 double default NULL, eyr4 double default NULL, roi4 double default NULL, nutek5 double default NULL, net5 double default NULL, ancash5 double default NULL, acash5 double default NULL, eyr5 double default NULL, roi5 double default NULL, nutek6 double default NULL, net6 double default NULL, ancash6 double default NULL, acash6 double default NULL, eyr6 double default NULL, roi6 double default NULL, processed double default NULL, lbsdayroom double default NULL, u2h double default NULL, u6h double default NULL, u1h double default NULL, u5h double default NULL, wusage double default NULL, u4h double default NULL, u7h double default NULL, hwusage double default NULL, u8h double default NULL, therms double default NULL, u3h double default NULL, sttl double default NULL, drtherms double default NULL, httl double default NULL, hall double default NULL, ironertherms double default NULL, thermsttl double default NULL, savedtherms double default NULL, text350 double default NULL, kwh double default NULL, wesaved double default NULL, text353 double default NULL, labor double default NULL, linensaved double default NULL, text368 double default NULL, linen double default NULL, PRIMARY KEY (ID) ) TYPE=MyISAM; -- -- Dumping data for table `nutek` -- INSERT INTO nutek VALUES (1,2,'03/26/2004','TA116','(828)252-2711','The Grove Park Inn','290 Macon Ave.','Asheville','NC',28804,'Mr.','Bill','Cummings','Laundry GM',8,0.6,18,110,75,'Washex',450,11,80,35,'Washex',450,11,2.4,7,'Washex',450,11,0.007,0,'Washex',250,11,0.024,10,'Washex',195,10,85,'Washex',135,10,64,50,77,'Ozone Machines',5000,749,86764,91764,7,5898.6419256765,11.6676009269891,2500,2000,75,65,55,45,40,25,0.0192,0.015744,25.0809228,8362.230470748,19.4940207,6499.501441587,5.5869021,1862.729029161,0.00989604,0.00247401,25.0809228,8362.230470748,19.4940207,6499.501441587,5.5869021,1862.729029161,0.003375,0.00219375,25.0809228,8362.230470748,19.4940207,6499.501441587,5.5869021,1862.729029161,0.0021,0.001953,13.933846,4645.68359486,10.8300115,3610.834134215,3.1038345,1034.849460645,0.007,0.007,10.86839988,3294.212003628,8.44740897,2560.409658807,2.42099091,733.802344821001,0.024,0.0216,7.52427684,2280.608310204,5.84820621,1772.591302251,1.67607063,508.017007953,0.06557104,0.05096476,35307.195320936,27442.339420034,7864.85590090201,5898.6419256765,1966.2139752255,23594.567702706,23594.567702706,73411.2,-49816.632297294,5112.1563355863,2752.6995653157,33032.3947837884,56626.9624864944,59646.6,-3019.63751350556,4325.6707454961,3539.1851554059,42470.2218648708,99097.1843513653,45882,53215.1843513653,3539.1851554059,4325.6707454961,51908.0489459532,151005.233297319,32117.4,118887.833297319,3145.9423603608,4718.9135405412,56626.9624864944,207632.195783813,18352.8,189279.395783813,1966.2139752255,5898.6419256765,70783.703108118,278415.898891931,18352.8,260063.098891931,6466460,30.7185836823527,124156.032,506070.782608696,63992.3468184,155195.04,15519504,15519.504,108636.528,9311702.4,14549.535,106653.911364,45265.22,769902.350608696,25865.84,263482.6378184,1033384.9884271,24249.225,132519.751364,90740.923273,54444.5539638,1551950.4,2793510.72,22348.08576,56230.0869565217,8621.94666666667,15519.504,86219.4666666667); INSERT INTO nutek VALUES (2,10,'03/29/2004','Test','(123)456-7890','Hotel Test Client','','Anywhere','KS',0,'','','','',5,0.6,18,100,85,'UniMac',75,8,75,30,'UniMac',75,8,2.1,10,'',0,0,0.01,0,'',0,0,0.03,5,'',0,0,85,'',0,0,16,1,70,'Ozone System',0,200,9000,9000,7,290.6762919921,23.2217080854446,2500,2000,75,65,55,45,40,25,0.0105,0.00861,4.183347675,1014.378144234,3.3841716825,820.5939495726,0.7991759925,193.7841946614,0.00839664,0.001259496,4.183347675,1014.378144234,3.3841716825,820.5939495726,0.7991759925,193.7841946614,0.0066825,0.00467775,0,0,0,0,0,0,4.2e-05,3.78e-05,0,0,0,0,0,0,0.01,0.01,0,0,0,0,0,0,0.03,0.0285,0,0,0,0,0,0,0.06562114,0.053085046,2028.756288468,1641.1878991452,387.5683893228,290.6762919921,96.8920973307001,1162.7051679684,1162.7051679684,7200,-6037.2948320316,251.91945305982,135.64893626298,1627.78723515576,2790.49240312416,5850,-3059.50759687584,213.16261412754,174.40577519526,2092.86930234312,4883.36170546728,4500,383.361705467285,174.40577519526,213.16261412754,2557.95136953048,7441.31307499777,3150,4291.31307499777,155.02735572912,232.54103359368,2790.49240312416,10231.8054781219,1800,8431.80547812193,96.8920973307001,290.6762919921,3488.1155039052,13719.9209820271,1800,11919.9209820271,371280,7.26575342465753,3898.44,29056.6956521739,3117.5044992,11138.4,779688,1764.32256,6237.504,467812.8,16.7076,5195.840832,3712.8,46432.5996521739,2940.5376,12509.7746592,58942.3743113739,27.846,8136.378432,5301.4105872,3180.84635232,89107.2,140343.84,701.7192,3228.52173913043,247.52,556.92,4950.4); INSERT INTO nutek VALUES (6,7,'04/02/2004','WJ102','(216)267-7229','North Park Retirement Community','6360 Elmdale Rd.','Brookpark','OH',44142,'Mr.','Gary','Wheeler','Purchasing Agent',5.5,0.7,0,90,90,'Milnor System 4',50,12,70,20,'',0,0,1.9,0,'',0,0,0.012,0,'',0,0,0.035,5,'',0,0,85,'',0,0,12,1,100,'UV Ozone Unit',200,68,2500,2700,6,72.4684693698001,18.6287914142504,2400,2000,50,50,50,50,50,50,0.01045,0.01045,3.12502415,974.257529004,2.660125065,829.3205902644,0.464899085,144.9369387396,0.00854658,0.000854658,0,0,0,0,0,0,0.0074844,0.00598752,0,0,0,0,0,0,4.9e-05,4.9e-05,0,0,0,0,0,0,0.012,0.012,0,0,0,0,0,0,0.035,0.03325,0,0,0,0,0,0,0.07352998,0.062591178,974.257529004,829.3205902644,144.9369387396,72.4684693698001,72.4684693698001,869.621632437601,869.621632437601,2160,-1290.3783675624,72.4684693698001,72.4684693698001,869.621632437601,1739.2432648752,1755,-15.7567351247985,72.4684693698001,72.4684693698001,869.621632437601,2608.8648973128,1350,1258.8648973128,72.4684693698001,72.4684693698001,869.621632437601,3478.4865297504,945,2533.4865297504,72.4684693698001,72.4684693698001,869.621632437601,4348.108162188,540,3808.108162188,72.4684693698001,72.4684693698001,869.621632437601,5217.7297946256,540,4677.7297946256,159120,6.41095890410959,1662.804,12452.8695652174,1359.9318096,5569.2,302328,882.16128,2673.216,181396.8,8.019648,1942.759728,1909.44,20695.2855652174,1260.2304,5822.3567376,26517.6423028174,11.45664,3202.990128,2000.5298352,1400.37088464,38188.8,0,0,1383.65217391304,106.08,278.46,2121.6); INSERT INTO nutek VALUES (4,7,'04/02/2004','WJ101','(216)252-7555','Covenant Care Center (SS)','4401 West 150th','Cleveland','OH',44135,'Mr','Garry','Wheeler','Purchasing Agent',5.5,0.7,13,100,75,'UniMac',60,15,75,30,'UniMac',60,14,2.4,0,'UniMac',60,14,0.009,0,'',0,0,0.03,0,'',0,0,85,'',0,0,43,1,90,'NT-300 Ozone System',700,220,9000,9700,7,616.0736252601,11.8086535467714,2400,2000,75,65,55,45,40,25,0.0132,0.011484,3.61737492,1644.639507378,2.98711896,1358.093635164,0.63025596,286.545872214,0.01119552,0.00279888,3.61737492,1534.9968735528,2.98711896,1267.5540594864,0.63025596,267.4428140664,0.0074844,0.00523908,3.61737492,1534.9968735528,2.98711896,1267.5540594864,0.63025596,267.4428140664,4.9e-05,4.9e-05,0,0,0,0,0,0,0.009,0.009,0,0,0,0,0,0,0.03,0.03,0,0,0,0,0,0,0.07092892,0.05857096,4714.6332544836,3893.2017541368,821.4315003468,616.0736252601,205.3578750867,2464.2945010404,2464.2945010404,7760,-5295.7054989596,533.93047522542,287.50102512138,3450.01230145656,5914.30680249696,6305,-390.69319750304,451.78732519074,369.64417515606,4435.73010187272,10350.0369043697,4850,5500.03690436968,369.64417515606,451.78732519074,5421.44790228888,15771.4848066586,3395,12376.4848066586,328.57260013872,492.85890020808,5914.30680249696,21685.7916091555,1940,19745.7916091555,205.3578750867,616.0736252601,7392.8835031212,29078.6751122767,1940,27138.6751122767,798252,11.0454130344541,10536.9264,62471.8956521739,8936.84623104,23947.56,1915804.8,4425.509088,13410.6336,1149482.88,40.2319008,12766.9231872,7184.268,99830.0892521739,12766.9231872,31123.78161984,130953.870872014,57.474144,19089.0790272,11471.8391424,8030.28739968,191580.48,249054.624,1369.800432,6941.32173913044,0,0,10643.36); INSERT INTO nutek VALUES (5,7,'04/02/2004','WJ101','(216)252-7555','Covenant Care Center','4401 West 150th','Cleveland','OH',44135,'Mr','Garry','Wheeler','Purchasing Agent',5.5,0.7,13,100,75,'UniMac',60,15,75,30,'UniMac',60,14,2.4,0,'UniMac',60,14,0.009,0,'',0,0,0.03,0,'',0,0,85,'',0,0,43,1,90,'NT-300 Ozone System',700,220,9000,9700,7,350.094105447806,11.8086535467714,2400,2000,42.62,42.62,42.62,42.62,42.62,42.62,0.0132,0.011484,3.61737492,1644.639507378,2.98711896,1358.093635164,0.63025596,286.545872214,0.01119552,0.00279888,3.61737492,1534.9968735528,2.98711896,1267.5540594864,0.63025596,267.4428140664,0.0074844,0.00523908,3.61737492,1534.9968735528,2.98711896,1267.5540594864,0.63025596,267.4428140664,4.9e-05,4.9e-05,0,0,0,0,0,0,0.009,0.009,0,0,0,0,0,0,0.03,0.03,0,0,0,0,0,0,0.07092892,0.05857096,4714.6332544836,3893.2017541368,821.4315003468,350.094105447806,471.337394898994,5656.04873878793,5656.04873878793,7760,-2103.95126121207,350.094105447806,471.337394898994,5656.04873878793,11312.0974775759,6305,5007.09747757585,350.094105447806,471.337394898994,5656.04873878793,16968.1462163638,4850,12118.1462163638,350.094105447806,471.337394898994,5656.04873878793,22624.1949551517,3395,19229.1949551517,350.094105447806,471.337394898994,5656.04873878793,28280.2436939396,1940,26340.2436939396,350.094105447806,471.337394898994,5656.04873878793,33936.2924327276,1940,31996.2924327276,798252,11.0454130344541,10536.9264,62471.8956521739,8936.84623104,23947.56,1915804.8,4425.509088,13410.6336,1149482.88,40.2319008,12766.9231872,7184.268,99830.0892521739,6322.15584,31123.78161984,130953.870872014,57.474144,19089.0790272,11471.8391424,8030.28739968,191580.48,249054.624,1369.800432,6941.32173913044,0,0,10643.36); -- -- Table structure for table `security` -- CREATE TABLE security ( id tinyint(10) unsigned NOT NULL auto_increment, distusername varchar(50) default NULL, distuserpass varchar(50) default NULL, distID int(11) default NULL, level varchar(20) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `security` -- INSERT INTO security VALUES (9,'tallen','longhorn',2,NULL); INSERT INTO security VALUES (11,'taness','longhorn',7,NULL); INSERT INTO security VALUES (5,'test','test',6,NULL); INSERT INTO security VALUES (10,'lwvness','heafkl6',7,NULL); INSERT INTO security VALUES (12,'markmeyer','got2bfre',8,NULL); INSERT INTO security VALUES (13,'mike','mike',9,NULL); INSERT INTO security VALUES (14,'bwickham','mallard',10,NULL); INSERT INTO security VALUES (15,'ericj','ericj',2,NULL); INSERT INTO security VALUES (16,'wjohnson','6914lake',7,NULL); INSERT INTO security VALUES (17,'mandl','supply',11,NULL);