CREATE TABLE `poolgroups` (
  `pgID` int(12) NOT NULL AUTO_INCREMENT,
  `groupName` varchar(255) DEFAULT NULL,
  `ORind` int(1) DEFAULT NULL,
  `sortOrder` int(6) DEFAULT NULL,
  `pkgLowAs` decimal(12,2) DEFAULT NULL,
  `cov108` decimal(12,2) DEFAULT NULL,
  `cov109` decimal(12,2) DEFAULT NULL,
  `cov110` decimal(12,2) DEFAULT NULL,
  `cov111` decimal(12,2) DEFAULT NULL,
  `lin14` decimal(12,2) DEFAULT NULL,
  `lin15` decimal(12,2) DEFAULT NULL,
  `lin16` decimal(12,2) DEFAULT NULL,
  `lin18` decimal(12,2) DEFAULT NULL,
  `lin19` decimal(12,2) DEFAULT NULL,
  `lin20` decimal(12,2) DEFAULT NULL,
  `lin99` decimal(12,2) DEFAULT NULL,
  `lin112` decimal(12,2) DEFAULT NULL,
  `lin144` decimal(12,2) DEFAULT NULL,
  `lin145` decimal(12,2) DEFAULT NULL,
  `lin146` decimal(12,2) DEFAULT NULL,
  `acc128` decimal(12,2) DEFAULT NULL,
  `acc134` decimal(12,2) DEFAULT NULL,
  `acc135` decimal(12,2) DEFAULT NULL,
  `acc174` decimal(12,2) DEFAULT NULL,
  `acc175` decimal(12,2) DEFAULT NULL,
  `acc176` decimal(12,2) DEFAULT NULL,
  `acc177` decimal(12,2) DEFAULT NULL,
  PRIMARY KEY (`pgID`),
  KEY `cov110` (`cov110`),
  KEY `lin146` (`lin146`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

CREATE TABLE `poolpackages` (
  `ppkgID` int(12) NOT NULL AUTO_INCREMENT,
  `packageName` varchar(255) DEFAULT NULL,
  `packageDesc` text,
  `pgID` int(12) DEFAULT NULL,
  `ORind` int(12) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`ppkgID`)
) ENGINE=MyISAM AUTO_INCREMENT=168 DEFAULT CHARSET=latin1;

CREATE TABLE `poolpackagesdetails` (
  `pkgDID` int(12) NOT NULL AUTO_INCREMENT,
  `ppkgID` int(12) DEFAULT NULL,
  `stepID` int(2) DEFAULT NULL,
  `pID` int(12) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`pkgDID`)
) ENGINE=MyISAM AUTO_INCREMENT=765 DEFAULT CHARSET=latin1;

CREATE TABLE `poolpackagesv2` (
  `ppkgID` int(12) NOT NULL AUTO_INCREMENT,
  `packageName` varchar(255) DEFAULT NULL,
  `packageDesc` text,
  `pgID` int(12) DEFAULT NULL,
  `ORind` int(12) DEFAULT NULL,
  `pwString` varchar(1000) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`ppkgID`)
) ENGINE=MyISAM AUTO_INCREMENT=159 DEFAULT CHARSET=latin1;

CREATE TABLE `poolwizard` (
  `pID` int(8) NOT NULL AUTO_INCREMENT,
  `parentID` int(8) DEFAULT NULL,
  `stepID` int(8) NOT NULL,
  `shortDesc` varchar(255) NOT NULL,
  `cartDesc` varchar(255) NOT NULL,
  `longDesc` text,
  `fullDesc` text,
  `fullRoundDesc` text,
  `fullOvalDesc` text,
  `ISOtrig` int(12) DEFAULT NULL,
  `ORind` int(1) DEFAULT NULL,
  `pgID` int(12) DEFAULT NULL,
  `lcatID` int(1) DEFAULT NULL,
  `acatID` int(8) DEFAULT NULL,
  `regPrice` decimal(10,2) NOT NULL,
  `salePrice` decimal(10,2) NOT NULL,
  `priceTrig` int(1) DEFAULT NULL,
  `stockTrig` int(1) DEFAULT NULL,
  `inStockInd` int(1) DEFAULT NULL,
  `sortOrder` int(4) DEFAULT NULL,
  `thumbPath` varchar(255) DEFAULT NULL,
  `largePath` varchar(255) DEFAULT NULL,
  `linerDispImg` varchar(255) DEFAULT NULL,
  `headerImage` varchar(255) DEFAULT NULL,
  `poolHeight` varchar(255) DEFAULT NULL,
  `topLedge` varchar(255) DEFAULT NULL,
  `dateCreated` datetime NOT NULL,
  `dateModified` datetime NOT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=MyISAM AUTO_INCREMENT=250 DEFAULT CHARSET=latin1;

CREATE TABLE `poolwizardacats` (
  `acatID` int(8) NOT NULL AUTO_INCREMENT,
  `stepID` int(8) DEFAULT NULL,
  `acatName` varchar(255) DEFAULT NULL,
  `acatDesc` text,
  `ISOtrig` int(8) DEFAULT NULL,
  `sortOrder` int(8) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  PRIMARY KEY (`acatID`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

CREATE TABLE `poolwizardaccessory` (
  `id` int(12) NOT NULL AUTO_INCREMENT,
  `parentID` int(12) DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `imgPath` varchar(255) DEFAULT NULL,
  `desc` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

CREATE TABLE `poolwizardatc` (
  `pcID` int(12) NOT NULL AUTO_INCREMENT,
  `sessionID` varchar(255) DEFAULT NULL,
  `poolText` text,
  `pwString` text,
  `amt` decimal(12,2) DEFAULT NULL,
  `ipAddr` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `eMail` varchar(255) DEFAULT NULL,
  `cpID` int(12) DEFAULT NULL,
  `vID` int(12) DEFAULT NULL,
  `printed` int(1) DEFAULT NULL,
  `emailed` int(1) DEFAULT NULL,
  `addToCart` int(1) DEFAULT NULL,
  `dateCreated` datetime DEFAULT NULL,
  `dateModified` datetime DEFAULT NULL,
  `dateAdded` datetime DEFAULT NULL,
  PRIMARY KEY (`pcID`)
) ENGINE=MyISAM AUTO_INCREMENT=1823307 DEFAULT CHARSET=utf8;

CREATE TABLE `poolwizarddisclaimer` (
  `pwdID` int(8) NOT NULL AUTO_INCREMENT,
  `disclaimer` text,
  PRIMARY KEY (`pwdID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

CREATE TABLE `poolwizardsaleset` (
  `ssID` int(12) NOT NULL AUTO_INCREMENT,
  `saleSetName` varchar(255) DEFAULT NULL,
  `saleHeadName` varchar(255) DEFAULT NULL,
  `s1Header` varchar(255) DEFAULT NULL,
  `s2Header` varchar(255) DEFAULT NULL,
  `s3Header` varchar(255) DEFAULT NULL,
  `s4Header` varchar(255) DEFAULT NULL,
  `s5Header` varchar(255) DEFAULT NULL,
  `s6Header` varchar(255) DEFAULT NULL,
  `s7Header` varchar(255) DEFAULT NULL,
  `s2ImgTrig` varchar(255) DEFAULT NULL,
  `isActive` int(1) DEFAULT NULL,
  PRIMARY KEY (`ssID`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

CREATE TABLE `poolwizpooldetails` (
  `assocID` int(8) NOT NULL AUTO_INCREMENT,
  `pID` int(8) DEFAULT NULL,
  `baseDetails` text,
  `topledge` text,
  `uprightposts` text,
  `height` text,
  `shape` text,
  `ovalStructure` text,
  `warranty` text,
  `installs` text,
  `newHeader` varchar(255) DEFAULT NULL,
  `s2header` varchar(255) DEFAULT NULL,
  `s2roundImg` varchar(255) DEFAULT NULL,
  `s2ovalImg` varchar(255) DEFAULT NULL,
  `s2aImg` varchar(255) DEFAULT NULL,
  `s2Desc` text,
  `s2HamptonDesc` text,
  `s2HamptionOval` text,
  `s2HamptonAFrame` text,
  `s2Footer` text,
  `acc129` decimal(12,2) DEFAULT NULL,
  `acc131` decimal(12,2) DEFAULT NULL,
  `acc132` decimal(12,2) DEFAULT NULL,
  `acc133` double(12,2) DEFAULT NULL,
  PRIMARY KEY (`assocID`),
  KEY `acc129` (`acc129`),
  KEY `acc129_2` (`acc129`),
  KEY `acc129_3` (`acc129`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

