--
-- Host: localhost    Database: creativ5_products
-- ------------------------------------------------------


--
-- Current Database: `creativ5_products`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `creativ5_products` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `creativ5_products`;

--
-- Table structure for table `advert`
--

CREATE TABLE `advert` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `Suspend` varchar(20) DEFAULT 'YES',
  `Caption` varchar(255) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Description` text,
  `URL` varchar(255) DEFAULT NULL,
  `Image_1` varchar(75) DEFAULT NULL,
  `Delay` varchar(25) DEFAULT NULL,
  `Width` varchar(25) DEFAULT NULL,
  `Position` varchar(25) DEFAULT NULL,
  `Font_CAP` varchar(2) DEFAULT NULL,
  `Font_TTL` varchar(2) DEFAULT NULL,
  `Font_DES` varchar(2) DEFAULT NULL,
  `Desc_Align` varchar(25) DEFAULT NULL,
  `Close_Align` varchar(25) DEFAULT NULL,
  `BGColor` varchar(25) DEFAULT NULL,
  `BDRColor` varchar(25) DEFAULT NULL,
  `TXTColor` varchar(25) DEFAULT NULL,
  `LNKColor` varchar(25) DEFAULT NULL,
  `TIMESTAMP` varchar(50) DEFAULT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `advert`
--

INSERT INTO `advert` VALUES (1,'YES','Coming Soon!','My New Product','Add any info to this popup. Full settings from the first page of your admin - Floating Advertisment.','http://www.hamptonplace.com/','_comp1.jpg','2','150','5','1','2','1','justify','right','white','darkgray','dimgray','steelblue','20050216');

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `Sort_Order` bigint(25) DEFAULT NULL,
  `CT1` varchar(200) DEFAULT NULL,
  `CT2` varchar(200) DEFAULT NULL,
  `CT3` varchar(200) DEFAULT NULL,
  `CT4` varchar(200) DEFAULT NULL,
  `CT5` varchar(200) DEFAULT NULL,
  `CT6` varchar(200) DEFAULT NULL,
  `CT7` varchar(200) DEFAULT NULL,
  `CT8` varchar(200) DEFAULT NULL,
  `CT9` varchar(200) DEFAULT NULL,
  `CT10` varchar(200) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  `Manufacturer` varchar(200) DEFAULT NULL,
  `Product_Line` varchar(200) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Description` text,
  `Image_1` varchar(75) DEFAULT NULL,
  `Image_2` varchar(75) DEFAULT NULL,
  `Image_3` varchar(75) DEFAULT NULL,
  `Image_4` varchar(75) DEFAULT NULL,
  `Image_5` varchar(75) DEFAULT NULL,
  `Image_6` varchar(75) DEFAULT NULL,
  `Image_7` varchar(75) DEFAULT NULL,
  `Image_8` varchar(75) DEFAULT NULL,
  `Image_9` varchar(75) DEFAULT NULL,
  `Image_10` varchar(75) DEFAULT NULL,
  `Availability` varchar(255) DEFAULT NULL,
  `Suspend` varchar(20) DEFAULT 'NO',
  `Notes` text,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,0,'Gift Certificates','','','','','','','','','','','','','Gift Certificates','','','','','','','','','','','','','NO','','2007-01-20 05:00:00');

--
-- Table structure for table `categories2`
--

CREATE TABLE `categories2` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `Sort_Order` bigint(25) DEFAULT NULL,
  `CT1` varchar(200) DEFAULT NULL,
  `CT2` varchar(200) DEFAULT NULL,
  `CT3` varchar(200) DEFAULT NULL,
  `CT4` varchar(200) DEFAULT NULL,
  `CT5` varchar(200) DEFAULT NULL,
  `CT6` varchar(200) DEFAULT NULL,
  `CT7` varchar(200) DEFAULT NULL,
  `CT8` varchar(200) DEFAULT NULL,
  `CT9` varchar(200) DEFAULT NULL,
  `CT10` varchar(200) DEFAULT NULL,
  `URL` varchar(255) DEFAULT NULL,
  `Manufacturer` varchar(200) DEFAULT NULL,
  `Product_Line` varchar(200) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Description` text,
  `Image_1` varchar(75) DEFAULT NULL,
  `Image_2` varchar(75) DEFAULT NULL,
  `Image_3` varchar(75) DEFAULT NULL,
  `Image_4` varchar(75) DEFAULT NULL,
  `Image_5` varchar(75) DEFAULT NULL,
  `Image_6` varchar(75) DEFAULT NULL,
  `Image_7` varchar(75) DEFAULT NULL,
  `Image_8` varchar(75) DEFAULT NULL,
  `Image_9` varchar(75) DEFAULT NULL,
  `Image_10` varchar(75) DEFAULT NULL,
  `Availability` varchar(255) DEFAULT NULL,
  `Suspend` varchar(20) DEFAULT 'NO',
  `Notes` text,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories2`
--


--
-- Table structure for table `discounts`
--

CREATE TABLE `discounts` (
  `ID` bigint(30) NOT NULL AUTO_INCREMENT,
  `Status` varchar(10) DEFAULT 'Active',
  `C1` text,
  `C2` text,
  `C3` text,
  `C4` text,
  `C5` text,
  `Manufacturer` text,
  `Discount` decimal(6,4) DEFAULT NULL,
  `Code` varchar(50) DEFAULT NULL,
  `Month` varchar(2) DEFAULT NULL,
  `Day` varchar(2) DEFAULT NULL,
  `Year` varchar(4) DEFAULT NULL,
  `CronTime` int(8) DEFAULT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `discounts`
--


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `C1` varchar(255) DEFAULT NULL,
  `C2` varchar(255) DEFAULT NULL,
  `Anchor` varchar(200) DEFAULT NULL,
  `Question` text,
  `Answer` text,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'','','31208','How Do You Ship?','We ship Continental US, via UPS and USPS. Check our order faq for more details.','2005-06-15 04:00:00');

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `ID` bigint(30) NOT NULL AUTO_INCREMENT,
  `Suspend` varchar(10) DEFAULT 'NO',
  `Sort_Order` bigint(25) DEFAULT NULL,
  `C1` varchar(200) DEFAULT NULL,
  `C2` varchar(200) DEFAULT NULL,
  `C3` varchar(200) DEFAULT NULL,
  `C4` varchar(200) DEFAULT NULL,
  `C5` varchar(200) DEFAULT NULL,
  `Name` varchar(150) DEFAULT NULL,
  `Description` text,
  `Image_1` varchar(75) DEFAULT NULL,
  `Image_2` varchar(75) DEFAULT NULL,
  `Image_3` varchar(75) DEFAULT NULL,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `manufacturers`
--


--
-- Table structure for table `pdfs`
--

CREATE TABLE `pdfs` (
  `ID` bigint(30) NOT NULL AUTO_INCREMENT,
  `Suspend` varchar(10) DEFAULT 'YES',
  `C1` varchar(200) DEFAULT NULL,
  `C2` varchar(200) DEFAULT NULL,
  `C3` varchar(200) DEFAULT NULL,
  `C4` varchar(200) DEFAULT NULL,
  `C5` varchar(200) DEFAULT NULL,
  `DocType` varchar(30) DEFAULT NULL,
  `Title` varchar(255) DEFAULT NULL,
  `Description` text,
  `File1` varchar(75) DEFAULT NULL,
  `Notes` varchar(255) DEFAULT NULL,
  `PRINT_TIME` varchar(50) DEFAULT NULL,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pdfs`
--


--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `Rand_ID` bigint(25) DEFAULT NULL,
  `Sort_Order` bigint(25) DEFAULT NULL,
  `C1` varchar(200) DEFAULT NULL,
  `C2` varchar(200) DEFAULT NULL,
  `C3` varchar(200) DEFAULT NULL,
  `C4` varchar(200) DEFAULT NULL,
  `C5` varchar(200) DEFAULT NULL,
  `C6` varchar(200) DEFAULT NULL,
  `C7` varchar(200) DEFAULT NULL,
  `C8` varchar(200) DEFAULT NULL,
  `C9` varchar(200) DEFAULT NULL,
  `C10` varchar(200) DEFAULT NULL,
  `Post_Cat` varchar(20) DEFAULT 'NO',
  `Spec_PF` varchar(20) DEFAULT 'NO',
  `Spec_FP1` varchar(20) DEFAULT NULL,
  `Spec_FP2` varchar(20) DEFAULT NULL,
  `Spec_HB1` varchar(20) DEFAULT NULL,
  `Spec_HB2` varchar(20) DEFAULT NULL,
  `Spec_HB3` varchar(20) DEFAULT NULL,
  `Pop_New` varchar(20) DEFAULT NULL,
  `Specials` varchar(20) DEFAULT NULL,
  `Suspend` varchar(20) DEFAULT 'NO',
  `Post_Manufacturer` varchar(10) DEFAULT NULL,
  `Manufacturer` varchar(200) DEFAULT NULL,
  `Product_Line` varchar(200) DEFAULT NULL,
  `PLC` varchar(25) DEFAULT NULL,
  `Cat_No` varchar(50) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `Description_Page` text,
  `Description_Page_2` text,
  `Description_Cart` text,
  `Meta_Title` text,
  `Meta_Description` text,
  `Meta_Keywords` text,
  `Desc_Temp` varchar(50) DEFAULT NULL,
  `List_Price` varchar(20) DEFAULT NULL,
  `Retail_Price` varchar(20) DEFAULT NULL,
  `Wholesale_Price` varchar(20) DEFAULT NULL,
  `Handling_Price` varchar(20) DEFAULT NULL,
  `Taxable` varchar(20) DEFAULT NULL,
  `Wt` varchar(20) DEFAULT NULL,
  `Pack` varchar(150) DEFAULT NULL,
  `Size` varchar(150) DEFAULT NULL,
  `Ship_Size_H` varchar(25) DEFAULT NULL,
  `Ship_Size_W` varchar(25) DEFAULT NULL,
  `Ship_Size_L` varchar(25) DEFAULT NULL,
  `Handling_Term` varchar(255) DEFAULT NULL,
  `Shipping_Notes` text,
  `Image_1` varchar(75) DEFAULT NULL,
  `Image_2` varchar(75) DEFAULT NULL,
  `Image_3` varchar(75) DEFAULT NULL,
  `Image_4` varchar(75) DEFAULT NULL,
  `Image_5` varchar(75) DEFAULT NULL,
  `Image_6` varchar(75) DEFAULT NULL,
  `Image_7` varchar(75) DEFAULT NULL,
  `Image_8` varchar(75) DEFAULT NULL,
  `Image_9` varchar(75) DEFAULT NULL,
  `Image_10` varchar(75) DEFAULT NULL,
  `HR_Image_1` varchar(75) DEFAULT NULL,
  `HR_Image_2` varchar(75) DEFAULT NULL,
  `HR_Zoom_1` varchar(75) DEFAULT NULL,
  `HR_Zoom_2` varchar(75) DEFAULT NULL,
  `Pdf` varchar(75) DEFAULT NULL,
  `Special_Url` varchar(200) DEFAULT NULL,
  `Availability` varchar(255) DEFAULT NULL,
  `Add_To_Cart` varchar(20) DEFAULT 'YES',
  `List_Cart` varchar(20) DEFAULT NULL,
  `Quantity` bigint(30) DEFAULT NULL,
  `Use_Quantity` varchar(5) DEFAULT 'YES',
  `Testimonies` text,
  `Notes` text,
  `Size_1` varchar(50) DEFAULT NULL,
  `Size_2` varchar(50) DEFAULT NULL,
  `Size_3` varchar(50) DEFAULT NULL,
  `Size_4` varchar(50) DEFAULT NULL,
  `Size_5` varchar(50) DEFAULT NULL,
  `Size_6` varchar(50) DEFAULT NULL,
  `Size_7` varchar(50) DEFAULT NULL,
  `Size_8` varchar(50) DEFAULT NULL,
  `Size_9` varchar(50) DEFAULT NULL,
  `Size_10` varchar(50) DEFAULT NULL,
  `Size_11` varchar(50) DEFAULT NULL,
  `Size_12` varchar(50) DEFAULT NULL,
  `Size_13` varchar(50) DEFAULT NULL,
  `Size_14` varchar(50) DEFAULT NULL,
  `Size_15` varchar(50) DEFAULT NULL,
  `Size_16` varchar(50) DEFAULT NULL,
  `Size_17` varchar(50) DEFAULT NULL,
  `Size_18` varchar(50) DEFAULT NULL,
  `Color_1` varchar(50) DEFAULT NULL,
  `Color_2` varchar(50) DEFAULT NULL,
  `Color_3` varchar(50) DEFAULT NULL,
  `Color_4` varchar(50) DEFAULT NULL,
  `Color_5` varchar(50) DEFAULT NULL,
  `Color_6` varchar(50) DEFAULT NULL,
  `Color_7` varchar(50) DEFAULT NULL,
  `Color_8` varchar(50) DEFAULT NULL,
  `Color_9` varchar(50) DEFAULT NULL,
  `Color_10` varchar(50) DEFAULT NULL,
  `Color_11` varchar(50) DEFAULT NULL,
  `Color_12` varchar(50) DEFAULT NULL,
  `Color_13` varchar(50) DEFAULT NULL,
  `Color_14` varchar(50) DEFAULT NULL,
  `Color_15` varchar(50) DEFAULT NULL,
  `Bar_Code` varchar(250) DEFAULT NULL,
  `Ship_mod` varchar(20) DEFAULT NULL,
  `Price_mod` varchar(20) DEFAULT NULL,
  `Options_A_1` varchar(100) DEFAULT NULL,
  `Options_A_2` varchar(100) DEFAULT NULL,
  `Options_A_3` varchar(100) DEFAULT NULL,
  `Options_A_4` varchar(100) DEFAULT NULL,
  `Options_A_5` varchar(100) DEFAULT NULL,
  `Options_A_6` varchar(100) DEFAULT NULL,
  `Options_A_7` varchar(100) DEFAULT NULL,
  `Options_A_8` varchar(100) DEFAULT NULL,
  `Options_A_9` varchar(100) DEFAULT NULL,
  `Options_A_10` varchar(100) DEFAULT NULL,
  `Options_A_11` varchar(100) DEFAULT NULL,
  `Options_A_12` varchar(100) DEFAULT NULL,
  `Options_A_13` varchar(100) DEFAULT NULL,
  `Options_A_14` varchar(100) DEFAULT NULL,
  `Options_A_15` varchar(100) DEFAULT NULL,
  `Options_A_16` varchar(100) DEFAULT NULL,
  `Options_A_17` varchar(100) DEFAULT NULL,
  `Options_A_18` varchar(100) DEFAULT NULL,
  `Options_A_19` varchar(100) DEFAULT NULL,
  `Options_A_20` varchar(100) DEFAULT NULL,
  `Options_B_1` varchar(100) DEFAULT NULL,
  `Options_B_2` varchar(100) DEFAULT NULL,
  `Options_B_3` varchar(100) DEFAULT NULL,
  `Options_B_4` varchar(100) DEFAULT NULL,
  `Options_B_5` varchar(100) DEFAULT NULL,
  `Options_B_6` varchar(100) DEFAULT NULL,
  `Options_B_7` varchar(100) DEFAULT NULL,
  `Options_B_8` varchar(100) DEFAULT NULL,
  `Options_B_9` varchar(100) DEFAULT NULL,
  `Options_B_10` varchar(100) DEFAULT NULL,
  `Options_B_11` varchar(100) DEFAULT NULL,
  `Options_B_12` varchar(100) DEFAULT NULL,
  `Options_B_13` varchar(100) DEFAULT NULL,
  `Options_B_14` varchar(100) DEFAULT NULL,
  `Options_B_15` varchar(100) DEFAULT NULL,
  `Options_B_16` varchar(100) DEFAULT NULL,
  `Options_B_17` varchar(100) DEFAULT NULL,
  `Options_B_18` varchar(100) DEFAULT NULL,
  `Options_B_19` varchar(100) DEFAULT NULL,
  `Options_B_20` varchar(100) DEFAULT NULL,
  `Options_C_1` varchar(100) DEFAULT NULL,
  `Options_C_2` varchar(100) DEFAULT NULL,
  `Options_C_3` varchar(100) DEFAULT NULL,
  `Options_C_4` varchar(100) DEFAULT NULL,
  `Options_C_5` varchar(100) DEFAULT NULL,
  `Options_C_6` varchar(100) DEFAULT NULL,
  `Options_C_7` varchar(100) DEFAULT NULL,
  `Options_C_8` varchar(100) DEFAULT NULL,
  `Options_C_9` varchar(100) DEFAULT NULL,
  `Options_C_10` varchar(100) DEFAULT NULL,
  `Options_C_11` varchar(100) DEFAULT NULL,
  `Options_C_12` varchar(100) DEFAULT NULL,
  `Options_C_13` varchar(100) DEFAULT NULL,
  `Options_C_14` varchar(100) DEFAULT NULL,
  `Options_C_15` varchar(100) DEFAULT NULL,
  `Options_C_16` varchar(100) DEFAULT NULL,
  `Options_C_17` varchar(100) DEFAULT NULL,
  `Options_C_18` varchar(100) DEFAULT NULL,
  `Options_C_19` varchar(100) DEFAULT NULL,
  `Options_C_20` varchar(100) DEFAULT NULL,
  `Options_D_1` varchar(100) DEFAULT NULL,
  `Options_D_2` varchar(100) DEFAULT NULL,
  `Options_D_3` varchar(100) DEFAULT NULL,
  `Options_D_4` varchar(100) DEFAULT NULL,
  `Options_D_5` varchar(100) DEFAULT NULL,
  `Options_D_6` varchar(100) DEFAULT NULL,
  `Options_D_7` varchar(100) DEFAULT NULL,
  `Options_D_8` varchar(100) DEFAULT NULL,
  `Options_D_9` varchar(100) DEFAULT NULL,
  `Options_D_10` varchar(100) DEFAULT NULL,
  `Options_D_11` varchar(100) DEFAULT NULL,
  `Options_D_12` varchar(100) DEFAULT NULL,
  `Options_D_13` varchar(100) DEFAULT NULL,
  `Options_D_14` varchar(100) DEFAULT NULL,
  `Options_D_15` varchar(100) DEFAULT NULL,
  `Options_D_16` varchar(100) DEFAULT NULL,
  `Options_D_17` varchar(100) DEFAULT NULL,
  `Options_D_18` varchar(100) DEFAULT NULL,
  `Options_D_19` varchar(100) DEFAULT NULL,
  `Options_D_20` varchar(100) DEFAULT NULL,
  `Opt_Desc_1` varchar(200) DEFAULT NULL,
  `Opt_Desc_2` varchar(200) DEFAULT NULL,
  `Opt_Desc_3` varchar(200) DEFAULT NULL,
  `Opt_Desc_4` varchar(200) DEFAULT NULL,
  `Opt_Desc_5` varchar(200) DEFAULT NULL,
  `Opt_Desc_6` varchar(200) DEFAULT NULL,
  `Opt_Desc_7` varchar(200) DEFAULT NULL,
  `Opt_Desc_8` varchar(200) DEFAULT NULL,
  `Opt_Desc_9` varchar(200) DEFAULT NULL,
  `Opt_Desc_10` varchar(200) DEFAULT NULL,
  `Opt_Desc_11` varchar(200) DEFAULT NULL,
  `Opt_Desc_12` varchar(200) DEFAULT NULL,
  `Opt_Desc_13` varchar(200) DEFAULT NULL,
  `Opt_Desc_14` varchar(200) DEFAULT NULL,
  `Opt_Desc_15` varchar(200) DEFAULT NULL,
  `Opt_Desc_16` varchar(200) DEFAULT NULL,
  `Opt_Desc_17` varchar(200) DEFAULT NULL,
  `Opt_Desc_18` varchar(200) DEFAULT NULL,
  `Opt_Desc_19` varchar(200) DEFAULT NULL,
  `Opt_Desc_20` varchar(200) DEFAULT NULL,
  `Opt_Desc_21` varchar(200) DEFAULT NULL,
  `Opt_Desc_22` varchar(200) DEFAULT NULL,
  `Opt_Desc_23` varchar(200) DEFAULT NULL,
  `Opt_Desc_24` varchar(200) DEFAULT NULL,
  `Opt_Desc_25` varchar(200) DEFAULT NULL,
  `Opt_Desc_26` varchar(200) DEFAULT NULL,
  `Opt_Desc_27` varchar(200) DEFAULT NULL,
  `Opt_Desc_28` varchar(200) DEFAULT NULL,
  `Opt_Desc_29` varchar(200) DEFAULT NULL,
  `Opt_Desc_30` varchar(200) DEFAULT NULL,
  `Opt_Desc_31` varchar(200) DEFAULT NULL,
  `Opt_Desc_32` varchar(200) DEFAULT NULL,
  `Opt_Desc_33` varchar(200) DEFAULT NULL,
  `Opt_Desc_34` varchar(200) DEFAULT NULL,
  `Opt_Desc_35` varchar(200) DEFAULT NULL,
  `Opt_Desc_36` varchar(200) DEFAULT NULL,
  `Opt_Desc_37` varchar(200) DEFAULT NULL,
  `Opt_Desc_38` varchar(200) DEFAULT NULL,
  `Opt_Desc_39` varchar(200) DEFAULT NULL,
  `Opt_Desc_40` varchar(200) DEFAULT NULL,
  `Sku_1` varchar(50) DEFAULT NULL,
  `Sku_2` varchar(50) DEFAULT NULL,
  `Sku_3` varchar(50) DEFAULT NULL,
  `Sku_4` varchar(50) DEFAULT NULL,
  `Sku_5` varchar(50) DEFAULT NULL,
  `Sku_6` varchar(50) DEFAULT NULL,
  `Sku_7` varchar(50) DEFAULT NULL,
  `Sku_8` varchar(50) DEFAULT NULL,
  `Sku_9` varchar(50) DEFAULT NULL,
  `Sku_10` varchar(50) DEFAULT NULL,
  `Sku_11` varchar(50) DEFAULT NULL,
  `Sku_12` varchar(50) DEFAULT NULL,
  `Sku_13` varchar(50) DEFAULT NULL,
  `Sku_14` varchar(50) DEFAULT NULL,
  `Sku_15` varchar(50) DEFAULT NULL,
  `Sku_16` varchar(50) DEFAULT NULL,
  `Sku_17` varchar(50) DEFAULT NULL,
  `Sku_18` varchar(50) DEFAULT NULL,
  `Sku_19` varchar(50) DEFAULT NULL,
  `Sku_20` varchar(50) DEFAULT NULL,
  `Sku_21` varchar(50) DEFAULT NULL,
  `Sku_22` varchar(50) DEFAULT NULL,
  `Sku_23` varchar(50) DEFAULT NULL,
  `Sku_24` varchar(50) DEFAULT NULL,
  `Sku_25` varchar(50) DEFAULT NULL,
  `Sku_26` varchar(50) DEFAULT NULL,
  `Sku_27` varchar(50) DEFAULT NULL,
  `Sku_28` varchar(50) DEFAULT NULL,
  `Sku_29` varchar(50) DEFAULT NULL,
  `Sku_30` varchar(50) DEFAULT NULL,
  `Sku_31` varchar(50) DEFAULT NULL,
  `Sku_32` varchar(50) DEFAULT NULL,
  `Sku_33` varchar(50) DEFAULT NULL,
  `Sku_34` varchar(50) DEFAULT NULL,
  `Sku_35` varchar(50) DEFAULT NULL,
  `Sku_36` varchar(50) DEFAULT NULL,
  `Sku_37` varchar(50) DEFAULT NULL,
  `Sku_38` varchar(50) DEFAULT NULL,
  `Sku_39` varchar(50) DEFAULT NULL,
  `Sku_40` varchar(50) DEFAULT NULL,
  `Opt_Retail_1` varchar(20) DEFAULT NULL,
  `Opt_Retail_2` varchar(20) DEFAULT NULL,
  `Opt_Retail_3` varchar(20) DEFAULT NULL,
  `Opt_Retail_4` varchar(20) DEFAULT NULL,
  `Opt_Retail_5` varchar(20) DEFAULT NULL,
  `Opt_Retail_6` varchar(20) DEFAULT NULL,
  `Opt_Retail_7` varchar(20) DEFAULT NULL,
  `Opt_Retail_8` varchar(20) DEFAULT NULL,
  `Opt_Retail_9` varchar(20) DEFAULT NULL,
  `Opt_Retail_10` varchar(20) DEFAULT NULL,
  `Opt_Retail_11` varchar(20) DEFAULT NULL,
  `Opt_Retail_12` varchar(20) DEFAULT NULL,
  `Opt_Retail_13` varchar(20) DEFAULT NULL,
  `Opt_Retail_14` varchar(20) DEFAULT NULL,
  `Opt_Retail_15` varchar(20) DEFAULT NULL,
  `Opt_Retail_16` varchar(20) DEFAULT NULL,
  `Opt_Retail_17` varchar(20) DEFAULT NULL,
  `Opt_Retail_18` varchar(20) DEFAULT NULL,
  `Opt_Retail_19` varchar(20) DEFAULT NULL,
  `Opt_Retail_20` varchar(20) DEFAULT NULL,
  `Opt_Retail_21` varchar(20) DEFAULT NULL,
  `Opt_Retail_22` varchar(20) DEFAULT NULL,
  `Opt_Retail_23` varchar(20) DEFAULT NULL,
  `Opt_Retail_24` varchar(20) DEFAULT NULL,
  `Opt_Retail_25` varchar(20) DEFAULT NULL,
  `Opt_Retail_26` varchar(20) DEFAULT NULL,
  `Opt_Retail_27` varchar(20) DEFAULT NULL,
  `Opt_Retail_28` varchar(20) DEFAULT NULL,
  `Opt_Retail_29` varchar(20) DEFAULT NULL,
  `Opt_Retail_30` varchar(20) DEFAULT NULL,
  `Opt_Retail_31` varchar(20) DEFAULT NULL,
  `Opt_Retail_32` varchar(20) DEFAULT NULL,
  `Opt_Retail_33` varchar(20) DEFAULT NULL,
  `Opt_Retail_34` varchar(20) DEFAULT NULL,
  `Opt_Retail_35` varchar(20) DEFAULT NULL,
  `Opt_Retail_36` varchar(20) DEFAULT NULL,
  `Opt_Retail_37` varchar(20) DEFAULT NULL,
  `Opt_Retail_38` varchar(20) DEFAULT NULL,
  `Opt_Retail_39` varchar(20) DEFAULT NULL,
  `Opt_Retail_40` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_1` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_2` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_3` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_4` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_5` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_6` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_7` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_8` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_9` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_10` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_11` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_12` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_13` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_14` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_15` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_16` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_17` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_18` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_19` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_20` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_21` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_22` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_23` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_24` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_25` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_26` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_27` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_28` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_29` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_30` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_31` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_32` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_33` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_34` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_35` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_36` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_37` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_38` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_39` varchar(20) DEFAULT NULL,
  `Opt_Wholesale_40` varchar(20) DEFAULT NULL,
  `Opt_Wt_1` varchar(20) DEFAULT NULL,
  `Opt_Wt_2` varchar(20) DEFAULT NULL,
  `Opt_Wt_3` varchar(20) DEFAULT NULL,
  `Opt_Wt_4` varchar(20) DEFAULT NULL,
  `Opt_Wt_5` varchar(20) DEFAULT NULL,
  `Opt_Wt_6` varchar(20) DEFAULT NULL,
  `Opt_Wt_7` varchar(20) DEFAULT NULL,
  `Opt_Wt_8` varchar(20) DEFAULT NULL,
  `Opt_Wt_9` varchar(20) DEFAULT NULL,
  `Opt_Wt_10` varchar(20) DEFAULT NULL,
  `Opt_Wt_11` varchar(20) DEFAULT NULL,
  `Opt_Wt_12` varchar(20) DEFAULT NULL,
  `Opt_Wt_13` varchar(20) DEFAULT NULL,
  `Opt_Wt_14` varchar(20) DEFAULT NULL,
  `Opt_Wt_15` varchar(20) DEFAULT NULL,
  `Opt_Wt_16` varchar(20) DEFAULT NULL,
  `Opt_Wt_17` varchar(20) DEFAULT NULL,
  `Opt_Wt_18` varchar(20) DEFAULT NULL,
  `Opt_Wt_19` varchar(20) DEFAULT NULL,
  `Opt_Wt_20` varchar(20) DEFAULT NULL,
  `Opt_Wt_21` varchar(20) DEFAULT NULL,
  `Opt_Wt_22` varchar(20) DEFAULT NULL,
  `Opt_Wt_23` varchar(20) DEFAULT NULL,
  `Opt_Wt_24` varchar(20) DEFAULT NULL,
  `Opt_Wt_25` varchar(20) DEFAULT NULL,
  `Opt_Wt_26` varchar(20) DEFAULT NULL,
  `Opt_Wt_27` varchar(20) DEFAULT NULL,
  `Opt_Wt_28` varchar(20) DEFAULT NULL,
  `Opt_Wt_29` varchar(20) DEFAULT NULL,
  `Opt_Wt_30` varchar(20) DEFAULT NULL,
  `Opt_Wt_31` varchar(20) DEFAULT NULL,
  `Opt_Wt_32` varchar(20) DEFAULT NULL,
  `Opt_Wt_33` varchar(20) DEFAULT NULL,
  `Opt_Wt_34` varchar(20) DEFAULT NULL,
  `Opt_Wt_35` varchar(20) DEFAULT NULL,
  `Opt_Wt_36` varchar(20) DEFAULT NULL,
  `Opt_Wt_37` varchar(20) DEFAULT NULL,
  `Opt_Wt_38` varchar(20) DEFAULT NULL,
  `Opt_Wt_39` varchar(20) DEFAULT NULL,
  `Opt_Wt_40` varchar(20) DEFAULT NULL,
  `Rel_Prod_1_ID` varchar(20) DEFAULT NULL,
  `Rel_Prod_2_ID` varchar(20) DEFAULT NULL,
  `Rel_Prod_3_ID` varchar(20) DEFAULT NULL,
  `Rel_Prod_4_ID` varchar(20) DEFAULT NULL,
  `Extra_Field_1` varchar(20) DEFAULT NULL,
  `Extra_Field_2` varchar(20) DEFAULT NULL,
  `Extra_Field_3` varchar(20) DEFAULT NULL,
  `Extra_Field_4` varchar(20) DEFAULT NULL,
  `Extra_Field_5` varchar(20) DEFAULT NULL,
  `Extra_Field_6` varchar(20) DEFAULT NULL,
  `Extra_Field_7` varchar(20) DEFAULT NULL,
  `Extra_Field_8` varchar(20) DEFAULT NULL,
  `Extra_Field_9` varchar(20) DEFAULT NULL,
  `Extra_Field_10` varchar(20) DEFAULT NULL,
  `Extra_Field_11` varchar(20) DEFAULT NULL,
  `Extra_Field_12` varchar(20) DEFAULT NULL,
  `Extra_Field_13` varchar(20) DEFAULT NULL,
  `Extra_Field_14` varchar(20) DEFAULT NULL,
  `Extra_Field_15` varchar(20) DEFAULT NULL,
  `Extra_Field_16` varchar(20) DEFAULT NULL,
  `Extra_Field_17` varchar(20) DEFAULT NULL,
  `Extra_Field_18` varchar(20) DEFAULT NULL,
  `Extra_Field_19` varchar(20) DEFAULT NULL,
  `Extra_Field_20` varchar(20) DEFAULT NULL,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `products_c1` (`C1`),
  KEY `products_c2` (`C2`),
  KEY `products_c3` (`C3`),
  KEY `products_c4` (`C4`),
  KEY `products_c5` (`C5`),
  KEY `products_c6` (`C6`),
  KEY `products_c7` (`C7`),
  KEY `products_c8` (`C8`),
  KEY `products_c9` (`C9`),
  KEY `products_c10` (`C10`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--


--
-- Table structure for table `pub_photos`
--

CREATE TABLE `pub_photos` (
  `ID` bigint(30) NOT NULL AUTO_INCREMENT,
  `Suspend` varchar(10) DEFAULT 'YES',
  `C1` varchar(200) DEFAULT NULL,
  `C2` varchar(200) DEFAULT NULL,
  `C3` varchar(200) DEFAULT NULL,
  `C4` varchar(200) DEFAULT NULL,
  `C5` varchar(200) DEFAULT NULL,
  `Name` varchar(150) DEFAULT NULL,
  `Address` varchar(150) DEFAULT NULL,
  `Address2` varchar(150) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `Zip` varchar(12) DEFAULT NULL,
  `Country` varchar(75) DEFAULT NULL,
  `Phone` varchar(15) DEFAULT NULL,
  `Email` varchar(75) DEFAULT NULL,
  `Find_Us` varchar(100) DEFAULT NULL,
  `Photo` varchar(75) DEFAULT NULL,
  `Caption` varchar(150) DEFAULT NULL,
  `Description` text,
  `Remote_Address` varchar(50) DEFAULT NULL,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pub_photos`
--


--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `PID` varchar(20) DEFAULT NULL,
  `Approve` varchar(10) DEFAULT 'NO',
  `C1` varchar(255) DEFAULT NULL,
  `C2` varchar(255) DEFAULT NULL,
  `Anchor` varchar(200) DEFAULT NULL,
  `Product_Name` varchar(200) DEFAULT NULL,
  `Product_Manufacturer` varchar(200) DEFAULT NULL,
  `Product_Price` varchar(20) DEFAULT NULL,
  `URL` varchar(200) DEFAULT NULL,
  `Name` varchar(150) DEFAULT NULL,
  `Address` varchar(150) DEFAULT NULL,
  `Address2` varchar(150) DEFAULT NULL,
  `City` varchar(100) DEFAULT NULL,
  `State` varchar(50) DEFAULT NULL,
  `Zip` varchar(12) DEFAULT NULL,
  `Country` varchar(75) DEFAULT NULL,
  `Phone` varchar(15) DEFAULT NULL,
  `Email` varchar(75) DEFAULT NULL,
  `Find_Us` varchar(100) DEFAULT NULL,
  `Review` text,
  `Rating` varchar(50) DEFAULT NULL,
  `IP` varchar(75) DEFAULT NULL,
  `TIMESTAMP` varchar(50) DEFAULT NULL,
  `PRINT_TIME` varchar(50) DEFAULT NULL,
  `TIME_STAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reviews`
--


--
-- Table structure for table `testimonies`
--

CREATE TABLE `testimonies` (
  `ID` bigint(30) unsigned NOT NULL AUTO_INCREMENT,
  `Approve` varchar(10) DEFAULT 'NO',
  `C1` varchar(255) DEFAULT NULL,
  `C2` varchar(255) DEFAULT NULL,
  `Loc_1` varchar(255) DEFAULT NULL,
  `Loc_2` varchar(255) DEFAULT NULL,
  `Anchor` varchar(200) DEFAULT NULL,
  `Testimony` text,
  `TIMESTAMP` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonies`
--

INSERT INTO `testimonies` VALUES (1,'YES','','','','','','Hayes Realty Agents have been using Creative Image Experts for our business card needs. We appreciate the quality products, fast delivery, and the friendly, professional service that we receive. Next time you have a printing need, contact Rich Manning at Creative Image Experts. He\'ll work with you to provide the design that\'s just right for you!\r\n\r\nDianne Pakel\r\nHayes Realty\r\n330-493-7700\r\n<a href=\"http://www.HayesRealtyHomes.com/\" target=\"_blank\">http://www.HayesRealtyHomes.com/</a>','2009-03-28 17:40:53'),(2,'YES',NULL,NULL,NULL,NULL,NULL,'Rich Manning of Creative Image Experts has provided our company with great products and services to market our company. From business cards to flyers, brochures, etc., his products have been clean, crisp and have helped us advertise our message and present our marketing plan in a positive and innovative way.\r\n \r\nJorge Cerrezuela\r\nJeff\'s Motorcars\r\nNorth Canton, OH\r\n330.498.8228\r\n<a href=\"http://www.JeffsMotorcars.com/\" target=\"_blank\">http://www.JeffsMotorcars.com/</a>','2009-03-28 17:32:00');


