-- MySQL dump 8.23 -- -- Host: localhost Database: NuTek --------------------------------------------------------- -- Server version 3.23.58 -- -- Table structure for table `Main Table` -- CREATE TABLE Main Table ( ID int(11) default NULL, Company Name text, Address text, City text, State text, ZIP text, DATE datetime default NULL, Proposal No text, Phone No text, Title text, Surname text, First Name text, Last Name text, Cost Water double default NULL, Cost GAS double default NULL, Rooms double default NULL, Occupancy double default NULL, Temperature Rise double default NULL, Boiler double default NULL, Make1 text, Make2 text, Make3 text, Make4 text, Make5 text, Make6 text, SIZE1 double default NULL, SIZE2 double default NULL, SIZE3 double default NULL, SIZE4 double default NULL, SIZE5 double default NULL, SIZE6 double default NULL, LOADS1 double default NULL, LOADS2 double default NULL, LOADS3 double default NULL, LOADS4 double default NULL, LOADS5 double default NULL, LOADS6 double default NULL, Days Per Week double default NULL, Description text, Priceequ double default NULL, PERCENTOTH double default NULL, PERCENTTOTHSAV int(11) default NULL, INSTALL double default NULL, o3 H2o int(11) default NULL, O3 Hot int(11) default NULL, Dryer Save int(11) default NULL, O3 Chemical int(11) default NULL, Linen Savings int(11) default NULL, Flatwork int(11) default NULL, Ironer Savings int(11) default NULL, Gallons Per Pound double default NULL, Input chem text, Input linen text, Load Factor double default NULL, DisplayButton tinyint(1) default NULL ) TYPE=MyISAM; -- -- Dumping data for table `Main Table` -- INSERT INTO `Main Table` VALUES (4,'Marriott Textile Services','8440 Freeport Parkway','Irving','TX','75063','2001-06-05 00:00:00','TA100','9729298800','Gerneral Manager','Mr','John','Hopper',4.3,0.55,2600,77,85,80,'Passat Tunnel',NULL,NULL,NULL,NULL,NULL,150,0,0,0,0,0,240,0,0,0,0,0,7,'NuTek NT-800 Ozone Laundry Support System with Closed-Looped Recirculating Option',18208,0,0,5833.75,0,3,20,35,0,50,0,1.2,'.0085','0.035',90,0); INSERT INTO `Main Table` VALUES (7,'Red Roof Inn (Accor Econo. Lodging)','301 Ruisseau','Plano','TX','75023','2001-02-24 00:00:00','TA101','9728818191','Manager','Mr.','Scott','Pokorny',4.11,0.5,123,71,75,70,'Uni-Mac','Uni-Mac',NULL,NULL,NULL,NULL,50,50,0,0,0,0,11,11,0,0,0,0,7,'1ea. - NuTek NT-300 Ozone Laundry Support System 3ea. - 3/4\" Venturi Injectors',5600,0,0,500,13,97,50,0,10,1,0,2.3,'0.009','0.055',85,0); INSERT INTO `Main Table` VALUES (8,'Christian Care Center','1000 Wiggins Parkway','Mesquite','TX','75150-9974','2001-01-26 00:00:00','TA102','9726863721','EVS Dircetor','Mr.','Ian','Timothy',3.85,0.83,190,89,100,75,'Wascomat','Wascomat','Wascomat','Wascomat','Wascomat',NULL,50,50,50,50,50,0,13,13,13,13,13,0,7,'2ea. - NuTek NT-300 Ozone Laundry Support Systems with 5ea. - 3/4\" Venturi Injectors Model 684',16000,0,0,0,15,80,40,10,0,1,0,3.9,'0.013','0.045',85,0); INSERT INTO `Main Table` VALUES (9,'Hilltop Haven','308 E. College','Gunter','TX','75058','2001-01-31 00:00:00','TA103','9034332415','Administrator','Mr.','Gregg','Loshier',5.17,0.83,208,88,100,75,'Dexter','Dexter','Dexter','Dexter',NULL,NULL,55,55,55,55,0,0,12,12,12,12,0,0,7,'2ea. - NuTek NT-300 Ozone Laundry Support Systems',14775,0,0,0,20,70,35,10,0,1,0,3.25,'.0155','.045',85,0); INSERT INTO `Main Table` VALUES (10,'Lakewood Village','5100 Randal Mill Road','Fort Worth','TX','76112-1583','2001-01-30 00:00:00','TA104','8174518001','Laundry Manager','Mr.','Tom','Jenkins',4.15,0.83,40,100,100,70,'Wascomat','Wascomat',NULL,NULL,NULL,NULL,50,50,0,0,0,0,14,14,0,0,0,0,7,'NuTek NT-300 Ozoe Laundry Support System',7500,0,0,0,20,70,35,10,0,1,0,3.25,'0.02','0.045',85,0); INSERT INTO `Main Table` VALUES (11,'Embassy Suites Hotel','121 Centenial Ave.','Piscataway','NJ','08854','2001-01-30 00:00:00','TA105','7329800500','Chief Engineer','Mr.','John','Wagner',6.25,0.59,224,78.34,100,75,'Uni-Mac','Uni-Mac','Uni-Mac',NULL,NULL,NULL,50,50,50,0,0,0,15,15,14,0,0,0,7,'2ea - NuTek NT-300 Ozone Laundry Support System with 4 extra injectors.',16279,0,0,2475,13,80,45,15,7,1,0,2.5,'0.014','0.045',85,0); INSERT INTO `Main Table` VALUES (12,'Four Points Sheraton','525 33rd Ave S.W.','Cedar Rapids','IA','52404','2001-02-24 00:00:00','TA106','3193668671','Owner','Mr','Alan','Zazza',2.92,1.19,172,68,75,41,'Dexter','Dexter','Dexter',NULL,NULL,NULL,55,55,55,0,0,0,12,11,12,0,0,0,7,'2ea. - NuTek NT-300 Ozone Laundry Support Systems.',16500,0,0,1000,10,70,35,0,0,1,0,2.5,'0.012','0.035',85,0); INSERT INTO `Main Table` VALUES (15,'Embassy Suites Hotel Pittsburgh International Airport','550 Chernton Parkway','Coraopolis','PA','15108','2001-08-27 00:00:00','TA107','(412) 269-9070','Chief Engineer','Mr.','Tim','Stitsel',7.05,0.81,223,70,90,70,'Washex','Milnor','Washex',NULL,NULL,NULL,85,95,85,0,0,0,9,8,9,0,0,0,7,'NuTek NT-350 Ozone Laundry Support System with 3ea - 1\" ozone injectors.',15550,0,0,1950,20,85,35,20,5,25,10,2.5,'.016','.05',85,0); INSERT INTO `Main Table` VALUES (17,'Sofitel New York','45 West 44th Street','New York','NY','10036','2001-01-21 00:00:00','TA109','2123548844','VP Technical Service','Mr.','Robert','Moore',4.8,1.43,398,69,90,75,'Milnor','Milnor','Milnor','Milnor',NULL,NULL,135,165,165,165,0,0,7,7,7,8,0,0,6,'1ea - NuTek NT-400 & NT-300 Ozone Laundry Support Systems with extra injectors.',22688,0,0,1800,20,75,30,20,0,60,5,2.7,'0.01','0.035',85,0); INSERT INTO `Main Table` VALUES (19,'Sofitel San Francisco Bay','223 Twin Dolphin Drive','Redwood City','CA','94065','2001-12-08 00:00:00','TA108','6505989000','VP Technical Services','Mr','Robert','Moore',5.5,0.99,500,58,90,75,'Uni-Mac','Uni-Mac','Milnor','Milnor','Milnor',NULL,50,85,165,165,165,0,7,7,7,8,8,0,6,'1ea - NuTek NT-400 & NT-300 Ozone Laundry Support Systems with extra injectors. 1ea - Ozone Monitor (Installation includes metering devices.)',24050,0,0,10226,20,75,30,30,3,60,5,2.7,'0.01','0.035',85,0); INSERT INTO `Main Table` VALUES (20,'Friendship Manor Care','79 6th Avenue','Grinnel','IA','50112','2002-02-11 00:00:00','TA111','3193636350','Administrator','Mr','Alfredo','Egdabon',5.31,0.53,77,90,110,75,'Speed Queen','Speed Queen',NULL,NULL,NULL,NULL,50,50,0,0,0,0,15,15,0,0,0,0,7,NULL,0,0,0,0,13,80,30,10,7,1,0,3,'0.012','0.035',85,0); -- -- Table structure for table `ViewerLog` -- CREATE TABLE ViewerLog ( ID int(11) NOT NULL auto_increment, CID int(11) NOT NULL default '0', REMOTE_ADDR varchar(32) NOT NULL default '', REMTOE_PORT varchar(12) NOT NULL default '', HTTP_REFERER varchar(255) NOT NULL default '', REQUEST_URI varchar(200) NOT NULL default '', TS timestamp(14) NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM COMMENT='Log o viewers'; -- -- Dumping data for table `ViewerLog` -- -- -- Table structure for table `_tblPDFs` -- CREATE TABLE _tblPDFs ( intPdfID int(11) unsigned NOT NULL auto_increment, strPdfName varchar(100) default '0', txtPdfDescription text NOT NULL, chrPdfType char(1) default 'd', strPdfFileLocation varchar(200) NOT NULL default '', strPdfFileName varchar(200) NOT NULL default '', strDealerDomain varchar(255) NOT NULL default '', PRIMARY KEY (intPdfID) ) TYPE=MyISAM; -- -- Dumping data for table `_tblPDFs` -- INSERT INTO _tblPDFs VALUES (1,'Test on','This is the description','d','/usr/home/nutek/PDFs/','2887.pdf','web2.tyler.com'); INSERT INTO _tblPDFs VALUES (2,'test 2','This is the description of number 2\r\n','p','','','www.somewhereelese.com'); INSERT INTO _tblPDFs VALUES (3,'SyDerma Price List','This is the price list for 6-22 and fwd','d','/usr/home/nutek/syderma_html/notes/Syderma/','SyDerma Price List6-22.pdf','www.syderma.com'); INSERT INTO _tblPDFs VALUES (4,'test','s','d','location','name','domain'); -- -- Table structure for table `tblCategory` -- CREATE TABLE tblCategory ( intCategoryID int(11) NOT NULL auto_increment, strCategoryName varchar(100) NOT NULL default '0', intCategorySequence int(11) NOT NULL default '0', txtCategoryText tinytext NOT NULL, PRIMARY KEY (intCategoryID) ) TYPE=MyISAM; -- -- Dumping data for table `tblCategory` -- INSERT INTO tblCategory VALUES (8,'Price List',20,'List all Price list here'); INSERT INTO tblCategory VALUES (10,'Dealer Brochure',30,''); INSERT INTO tblCategory VALUES (9,'Schematics',20,''); INSERT INTO tblCategory VALUES (11,'Product Literature',40,''); -- -- Table structure for table `tblDealers` -- CREATE TABLE tblDealers ( intDealerID int(11) NOT NULL auto_increment, strDealerName varchar(200) NOT NULL default '', strDomain varchar(255) NOT NULL default '', chrDealerLevel char(2) NOT NULL default '', strDealerEmail varchar(255) NOT NULL default '', strDealerPassword varchar(10) NOT NULL default '', PRIMARY KEY (intDealerID), KEY strDealerEmail (strDealerEmail) ) TYPE=MyISAM; -- -- Dumping data for table `tblDealers` -- INSERT INTO tblDealers VALUES (1,'Bradley Thurston','www.nutek.com','3','bradley@ballistic.com','password'); INSERT INTO tblDealers VALUES (2,'Pat','www.sydurma','2','pat@ballistic.com','test'); INSERT INTO tblDealers VALUES (3,'bradley','www.syderma.com','','bradley@ballistic.com','password'); INSERT INTO tblDealers VALUES (4,'Admin','0','0','revo@ballistic.com','revo'); -- -- Table structure for table `tblDescriptions` -- CREATE TABLE tblDescriptions ( intDescriptionID int(11) NOT NULL auto_increment, strDescriptionName varchar(100) NOT NULL default '', txtDescriptionText text NOT NULL, strDescriptionLogo varchar(100) default NULL, PRIMARY KEY (intDescriptionID) ) TYPE=MyISAM; -- -- Dumping data for table `tblDescriptions` -- INSERT INTO tblDescriptions VALUES (8,'test','test',''); INSERT INTO tblDescriptions VALUES (17,'Dealer Price List','',''); INSERT INTO tblDescriptions VALUES (15,'Dealer Brochure','',''); INSERT INTO tblDescriptions VALUES (16,'Schematics','',''); INSERT INTO tblDescriptions VALUES (18,'Product Literature','',''); -- -- Table structure for table `tblDomain` -- CREATE TABLE tblDomain ( intDomainID int(11) NOT NULL auto_increment, strDomainName varchar(200) NOT NULL default '', strDomainLogo varchar(100) NOT NULL default '', strDomainAddress varchar(200) NOT NULL default '', strDomainCity varchar(100) NOT NULL default '', strDomainState varchar(10) NOT NULL default '', strDomainZip varchar(10) NOT NULL default '', strDomainPhone varchar(18) NOT NULL default '', tsInDate date NOT NULL default '0000-00-00', strDomainTempName varchar(100) NOT NULL default '', strDomainUserName varchar(15) NOT NULL default '', strDomainPassword varchar(15) NOT NULL default 'HFTPA', lastUpdate timestamp(14) NOT NULL, PRIMARY KEY (intDomainID) ) TYPE=MyISAM; -- -- Dumping data for table `tblDomain` -- INSERT INTO tblDomain VALUES (4,'www.syderma.com','','704-1 West Park Ave.','Edgewater','FL','32132','386-426-7088','2002-10-10','','','',20021012224640); INSERT INTO tblDomain VALUES (5,'www.crispair.com','','704-1 West Park Ave','Edgwater','Fl','32132','386.426.7088','2002-10-11','','','',20021106120345); INSERT INTO tblDomain VALUES (6,'www.nuteksolutions.com','','','','','','','2002-10-11','','','',20021011091636); INSERT INTO tblDomain VALUES (7,'www.ozone-laundry-systems.com','','704-1 West Park Ave.','Edgewater','FL','23132','386-426-7088','2002-10-11','','','',20021106001406); -- -- Table structure for table `tblDomainColors` -- CREATE TABLE tblDomainColors ( intDomainColorID int(11) NOT NULL auto_increment, intDomainID int(11) NOT NULL default '0', strDomainColorBgColor1 char(6) NOT NULL default '', strDomainColorFColor1 char(6) NOT NULL default '', PRIMARY KEY (intDomainColorID) ) TYPE=MyISAM; -- -- Dumping data for table `tblDomainColors` -- -- -- Table structure for table `tblDomains` -- CREATE TABLE tblDomains ( intDomainID int(11) NOT NULL auto_increment, strDomainName varchar(255) NOT NULL default '', PRIMARY KEY (intDomainID) ) TYPE=MyISAM COMMENT='List of domains '; -- -- Dumping data for table `tblDomains` -- INSERT INTO tblDomains VALUES (1,'www.syderma.com'); INSERT INTO tblDomains VALUES (2,'www.crispair.com'); INSERT INTO tblDomains VALUES (3,'www.nuteksolutions.com'); -- -- Table structure for table `tblFile` -- CREATE TABLE tblFile ( intFileID int(11) NOT NULL auto_increment, strFile varchar(200) NOT NULL default '0', intDomainID int(11) NOT NULL default '0', strFileURL varchar(255) NOT NULL default '', intFileTypeID int(11) unsigned default NULL, intFileCategoryID int(11) NOT NULL default '0', strFileLinkName varchar(200) NOT NULL default '0', strFileAltDescription text, intFileDescriptionID int(11) NOT NULL default '0', tsUpLoadDate timestamp(14) NOT NULL, PRIMARY KEY (intFileID) ) TYPE=MyISAM; -- -- Dumping data for table `tblFile` -- -- -- Table structure for table `tblType` -- CREATE TABLE tblType ( intTypeID int(11) NOT NULL auto_increment, strTypeName varchar(100) NOT NULL default '0', intTypeSequence int(11) NOT NULL default '0', txtTypeText tinytext NOT NULL, PRIMARY KEY (intTypeID) ) TYPE=MyISAM; -- -- Dumping data for table `tblType` -- INSERT INTO tblType VALUES (1,'Public',10,'This is a public Document\r\n'); INSERT INTO tblType VALUES (2,'Private',20,'This is a private Document ( dealers and dis..)'); -- -- Table structure for table `tblUsers` -- CREATE TABLE tblUsers ( intUserID int(11) NOT NULL auto_increment, strUserName varchar(20) NOT NULL default '0', strUserEmail varchar(200) NOT NULL default '', strUserPassword varchar(20) NOT NULL default '', intDomainID int(11) unsigned NOT NULL default '0', tmsLastChanged timestamp(14) NOT NULL, PRIMARY KEY (intUserID) ) TYPE=MyISAM; -- -- Dumping data for table `tblUsers` -- INSERT INTO tblUsers VALUES (23,'Brad White','','',0,20021011162736); INSERT INTO tblUsers VALUES (22,'Bradley Smith','Emi','',0,20021011162704); INSERT INTO tblUsers VALUES (79,'stepon','','63fb9bc3264a31f9',0,20040319144304); INSERT INTO tblUsers VALUES (78,'dmoxley','dmoxley@bellsouth.net','5d2e19393cc5ef67',0,20040108095338);