--
-- Host: localhost    Database: philipfeaster
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `short_description` blob,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,8,NULL,NULL,'Top Level',NULL,0),(3,0,8,0,0,'',NULL,'<BR>PREVIOUS WORK','',0),(8,0,8,9,0,'',NULL,'<BR>SCULPTURES','',0),(9,0,8,3,0,'',NULL,'<BR>FISHING FLIES','',0);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=253 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (225,1,9),(227,2,9),(85,3,3),(195,4,3),(179,5,3),(248,6,8),(239,8,9),(86,7,3),(246,9,8),(196,10,3),(17,11,3),(18,12,3),(19,13,3),(20,14,3),(21,15,3),(30,16,3),(29,17,3),(24,18,3),(28,19,3),(26,20,3),(27,21,3),(31,22,3),(32,23,3),(33,24,3),(34,25,3),(35,26,3),(36,27,3),(37,29,3),(38,30,3),(39,31,3),(40,32,3),(41,33,3),(42,34,3),(43,35,3),(44,36,3),(45,37,3),(46,38,3),(47,39,3),(48,41,3),(49,42,3),(50,44,3),(51,45,3),(52,46,3),(53,47,3),(54,48,3),(56,49,3),(223,50,9),(232,52,9),(233,53,9),(217,54,8),(236,55,9),(238,56,9),(249,58,8),(74,61,3),(72,59,3),(71,60,3),(73,62,3),(75,63,3),(76,64,3),(77,65,3),(78,66,3),(79,67,3),(80,68,3),(81,69,3),(82,70,3),(83,71,3),(84,72,3),(88,73,3),(89,74,3),(90,75,3),(91,76,3),(92,77,3),(93,78,3),(94,79,3),(95,80,3),(96,81,3),(97,82,3),(98,83,3),(99,84,3),(100,85,3),(101,86,3),(102,87,3),(103,88,3),(104,89,3),(105,90,3),(107,91,3),(108,92,3),(109,93,3),(110,94,3),(111,95,3),(112,96,3),(113,97,3),(224,106,9),(230,109,9),(234,111,9),(251,136,8),(237,123,9),(250,135,8),(244,134,8),(220,126,3),(245,127,8),(198,128,8),(199,129,8),(200,130,8),(247,131,8),(211,132,8),(252,133,8);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` blob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Invoice`
--


--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'',1,1,'',NULL,NULL,'Tools and Techniques','<BR>Tools & Techniques',NULL),(2,'The site is under construction.  Please bear with us.<HR>',3,0,'portrait.jpg','','','ORIGINAL ART BY PHILIP FEASTER',NULL,NULL),(3,'<center><BR><BR>Wichita Art and Book Fair       -  May 8-9, 2010<BR><BR>Tulsa International Mayfest - May 13-16, 2010<BR><BR>57th Street Art Fair (Chicago) - June 5-6, 2010<BR><BR>District Art Annual (Kansas City)  -  June 26-26, 2010<BR><BR>Aspen Art Festival (Aspen, CO) -  July 17-18, 2010<BR><BR>Windsor Art Festival (Windsor, CO) -  July 31-August 1, 2010<BR><BR>Loveland Sculpture Invitational (Loveland, CO) - August 6-8, 2010<BR><BR>\r\nRedstone Art Festival (Park City, UT) -  August 14-15, 2010<BR><BR>\r\n',1,1,'',NULL,NULL,'Show Schedule','<BR>Show Schedule',NULL);

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` longblob,
  `list2` longblob,
  `image` varchar(255) DEFAULT NULL,
  `prices` longblob,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (1,'BLACK GNAT','0','Black Gnat pattern fishing fly carved in natural slate.\r\n\r\n<BR>\r\n12\" wide x 16\" high x 1/2\" thick.',NULL,NULL,0,1,'','',165.00,'','','Black_Gnat_8-08-04-1.jpg','',0.0000,1,1,'Fishing fly sculptures are carved using original artwork created by Philip Feaster.  Hand chisels and small grinding bits are used on natural stone pieces to produce a shadow relief representation of actual fishing fly patterns.  This sculpture is based upon the well known \"black gnat\" fly, which is used for trout and other species that are attracted to dry flies.  The colors seen are the actual colors of the stone.  Color is never added.',0.00,1,0,NULL),(2,'BAR FLY','0','Bar Fly pattern fishing fly carved in natural slate.\r\n\r\n<BR>\r\n18\" wide x 8\" high x 1/2\" thick.',NULL,NULL,0,0,'','',165.00,'','','Bar_Fly_8-08-04-3.jpg','',0.0000,1,1,'Fishing fly sculptures are carved using original artwork created by Philip Feaster.  Hand chisels and small grinding bits are used on natural stone pieces to produce a shadow relief representation of actual fishing fly patterns.  This sculpture is based upon the parachute pattern called a \"Bar Fly\".  This is a dry fly used in Colorado mostly for trout.  The colors seen are the natural colors of the stone.  ',0.00,2,0,NULL),(3,'Bodie Island Lighthouse','0','Natural slate with no color added.<BR>\r\n37\" high x 21\" wide x 2\" thick.',NULL,NULL,1,1,'','',2200.00,'','','Bodie_Island,_Cape_Hatteras.jpg','',0.0000,1,1,'',0.00,3,NULL,NULL),(4,'The Courtyard','0','Hand carved natural slate.  No colors have been added.\r\n<BR>\r\n38\" high x 22\" wide x 3\" thick.',NULL,NULL,1,1,'','',4800.00,'','','The_Courtyard.jpg','',0.0000,1,1,'',0.00,4,0,NULL),(5,'Fish Bones','0','Natural slate with a fossilized bone patina has been hand carved to create a stylized representation of an actual fossil.\r\n<BR>\r\n20\" high x 29\" wide x 2\" thick',NULL,NULL,1,1,'','',900.00,'','','Fish_Fossil.jpg','',0.0000,1,1,'',0.00,5,0,NULL),(6,'SANTORINI SUNRISE','0','Hand carved natural slate - no color added.<BR>\r\n20\" tall x 41\" long x 3\" thick.',NULL,NULL,0,1,'','',3800.00,'','','Santorini_Sunrise.jpg','',0.0000,1,1,'Hand carved natural slate - no color added.<BR>\r\n20\" tall x 41\" long x 3\" thick.',0.00,6,0,NULL),(7,'Fog Watch','0','Hand carved natural slate with no added color.<BR>\r\n19\" high x 37\" wide x 3\" thick',NULL,NULL,1,1,'','',1800.00,'','','Fog_Watch.jpg','',0.0000,1,1,'',0.00,7,NULL,NULL),(8,'STONE FLY NYMPH','0','Hand carved natural slate with no added color.<BR>\r\n8\" tall x 14\" wide x 1\" thick',NULL,NULL,0,0,'','',165.00,'','','Stone_Fly_Nymph.jpg','',0.0000,1,1,'',0.00,8,0,NULL),(9,'DUST DEVILS','0','Hand carved Slate mounted on slate.  All colors are natural - color is never added.<BR>\r\n48\" long x 24\" high x 4\" thick.',NULL,NULL,0,1,'','',4400.00,'','','The_Herd.jpg','',0.0000,1,1,'Hand carved Slate mounted on slate.  All colors are natural - color is never added.<BR>\r\n48\" long x 24\" high x 4\" thick.',0.00,9,0,NULL),(10,'The Patio','0','Hand carved slate mounted on slate - all natural stone colors.<BR>\r\n27\" tall x 45\" long x 4\" thick.',NULL,NULL,1,1,'','',4000.00,'','','The_Patio.jpg','',0.0000,1,1,'',0.00,10,0,NULL),(11,'Butterfly','0','Hand carved natural slate - no color added.',NULL,NULL,0,0,'','',385.00,'','','Butterfly1.jpg','',0.0000,1,1,'',0.00,11,NULL,NULL),(12,'Buffalo Stepping','0','Echo Canyon Flatstone - hand carved - no colors added',NULL,NULL,0,0,'','',1000.00,'','','Buffalo_Step.jpg','',0.0000,1,1,'',0.00,12,NULL,NULL),(13,'Bird','0','Echo Canyon Flagstone - hand carved - no colors added.',NULL,NULL,0,0,'','',850.00,'','','Bird.jpg','',0.0000,1,1,'',0.00,13,NULL,NULL),(14,'Bill Fish','0','Carrera Marble - Hand carved',NULL,NULL,0,0,'','',1500.00,'','','Bill_Fish_Detail.jpg','',0.0000,1,1,'',0.00,14,NULL,NULL),(15,'Barn Owl','0','Hand Carved Slate<BR>\r\n16\" tall x 16\" wide x 1\" thick',NULL,NULL,0,0,'','',750.00,'','','Barn_Owl.jpg','',0.0000,1,1,'',0.00,15,NULL,NULL),(16,'Baby Back Ribs','0','Hand carved natural slate - no colors added<BR>\r\n16\" x 16\" x 1\"',NULL,NULL,0,0,'','',750.00,'','','Baby_Back_Ribs.jpg','',0.0000,1,1,'',0.00,16,NULL,NULL),(17,'Autumn Royalty','0','Hand carved natural slate - no color added<BR>12\" x 12\" x 1\"',NULL,NULL,0,0,'','',450.00,'','','Autumn_Royalty.jpg','',0.0000,1,1,'',0.00,17,NULL,NULL),(18,'Arctic Wolves','0','Hand carved Travertine Marble',NULL,NULL,0,0,'','',950.00,'','','Arctic_Wolves.jpg','',0.0000,1,1,'',0.00,18,NULL,NULL),(19,'All Tucked In','0','Hand carved natural slate - no color added<BR>16\" x 16\" x 1\"',NULL,NULL,0,0,'','',650.00,'','','All_Tucked_In.jpg','',0.0000,1,1,'',0.00,19,NULL,NULL),(20,'Alert Nature','0','Hand Carved natural slate - no color added',NULL,NULL,0,0,'','',1250.00,'','','Alert.jpg','',0.0000,1,1,'',0.00,20,NULL,NULL),(21,'Aegean Sunset','0','Hand carved natural slate - no color added',NULL,NULL,0,0,'','',3200.00,'','','Aegean_Sunset.jpg','',0.0000,1,1,'',0.00,21,NULL,NULL),(22,'Cape Meares Lighthouse','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',1800.00,'','','Cape_Meares.jpg','',0.0000,1,1,'',0.00,22,NULL,NULL),(23,'Caress','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',3500.00,'','','Caress.jpg','',0.0000,1,1,'',0.00,23,NULL,NULL),(24,'Cheeta','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Cheeta.jpg','',0.0000,1,1,'',0.00,24,NULL,NULL),(25,'Chipmonk','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',280.00,'','','Chipmonk.jpg','',0.0000,1,1,'',0.00,25,NULL,NULL),(26,'Circle The Wagons','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',500.00,'','','Circle_The_Wagons.jpg','',0.0000,1,1,'',0.00,26,NULL,NULL),(27,'Heard Something','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',1600.00,'','','Coyote.jpg','',0.0000,1,1,'',0.00,27,NULL,NULL),(28,'Dangerous Look','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',850.00,'','','Dangerous_Look.jpg','',0.0000,1,1,'',0.00,28,NULL,NULL),(29,'Dead Fall','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',425.00,'','','Dead_Fall.jpg','',0.0000,1,1,'',0.00,29,NULL,NULL),(30,'Doe and Fawn','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',385.00,'','','Doe___Fawn.jpg','',0.0000,1,1,'',0.00,30,NULL,NULL),(31,'Down From The Hills','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',550.00,'','','Down_From_The_Hills.jpg','',0.0000,1,1,'',0.00,31,NULL,NULL),(32,'Elephant','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',350.00,'','','Elephant3.jpg','',0.0000,1,1,'',0.00,32,NULL,NULL),(33,'Grazing Elk','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',500.00,'','','Elk_-_Grazing.jpg','',0.0000,1,1,'',0.00,33,NULL,NULL),(34,'Elk','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',580.00,'','','Elk_1.jpg','',0.0000,1,1,'',0.00,34,NULL,NULL),(35,'Fuzzy','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',1200.00,'','','FUZZY.jpg','',0.0000,1,1,'',0.00,35,NULL,NULL),(36,'Fading Icon','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',3600.00,'','','Fading_Icon.jpg','',0.0000,1,1,'',0.00,36,NULL,NULL),(37,'Family Gathering','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',3000.00,'','','Family_Gathering.jpg','',0.0000,1,1,'',0.00,37,NULL,NULL),(38,'Bony Fish','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',450.00,'','','Fish_Bones.jpg','',0.0000,1,1,'',0.00,38,NULL,NULL),(39,'Flight','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',1400.00,'','','Flight.jpg','',0.0000,1,1,'',0.00,39,NULL,NULL),(40,'Fly Fishing','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',600.00,'','','Fly_Fisherman.jpg','',0.0000,1,1,'',0.00,40,NULL,NULL),(41,'Formal Gathering','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',1800.00,'','','Formal_Gathering.jpg','',0.0000,1,1,'',0.00,41,NULL,NULL),(42,'Foxy','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',680.00,'','','Fox.jpg','',0.0000,1,1,'',0.00,42,NULL,NULL),(43,'Grazing','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',3000.00,'','','Grazing.jpg','',0.0000,1,1,'',0.00,43,NULL,NULL),(44,'Hippo','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',450.00,'','','Hippo.jpg','',0.0000,1,1,'',0.00,44,NULL,NULL),(45,'Hooked','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Hooked.jpg','',0.0000,1,1,'',0.00,45,NULL,NULL),(46,'Interrupted','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',800.00,'','','Interrupted.jpg','',0.0000,1,1,'',0.00,46,NULL,NULL),(47,'Kudu 2','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Kudu_2.jpg','',0.0000,1,1,'',0.00,47,NULL,NULL),(48,'Kudu 3','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',3000.00,'','','Kudu_3.jpg','',0.0000,1,1,'',0.00,48,NULL,NULL),(49,'Kudu 1','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',900.00,'','','kudu_1.jpg','',0.0000,1,1,'',0.00,49,NULL,NULL),(50,'ALPINE CADDIS','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',165.00,'','','alpine_caddis.jpg','',0.0000,1,1,'',0.00,50,0,NULL),(52,'FOAMPY FLY','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',165.00,'','','Foampy_Fly.jpg','',0.0000,1,1,'',0.00,52,0,NULL),(53,'HOPPULATOR','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',165.00,'','','Hoppultor.jpg','',0.0000,1,1,'',0.00,53,0,NULL),(54,'KELP DANCE','0','Hand carved marble - no color added',NULL,NULL,0,1,'','',2700.00,'','','Kelp_Dance.jpg','',0.0000,1,1,'',0.00,54,0,NULL),(55,'PUFFER FLY','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',165.00,'','','Puffer_Fly.jpg','',0.0000,1,1,'',0.00,55,0,NULL),(56,'SHRIMP FLY','0','Hand carved slate - no color added',NULL,NULL,0,0,'','',165.00,'','','Shrimp_Fly.jpg','',0.0000,1,1,'',0.00,56,0,NULL),(136,'ATONEMENT','0','',NULL,NULL,0,1,'','',6800.00,'','','ATONEMENT.jpg','',0.0000,1,1,'',0.00,136,0,NULL),(58,'SUNSET RUN','0','Hand carved slate - no color added',NULL,NULL,0,1,'','',1800.00,'','','Sunset_Run.jpg','',0.0000,1,1,'Hand carved slate - no color added',0.00,58,0,NULL),(59,'Large Bear','0','hand carved slate - no color added',NULL,NULL,0,0,'','',2800.00,'','','Large_Bear_(medium_Detail).jpg','',0.0000,1,1,'',0.00,59,NULL,NULL),(60,'Lazy Afternoon','0','hand carved travertine - no color added',NULL,NULL,0,0,'','',750.00,'','','Lazy_afternoon.jpg','',0.0000,1,1,'',0.00,60,NULL,NULL),(61,'Living Fossil','0','hand carved slate - no color added',NULL,NULL,0,0,'','',600.00,'','','Living_Fossil.jpg','',0.0000,1,1,'',0.00,61,NULL,NULL),(62,'Lonely Journey','0','hand carved slate - no color added',NULL,NULL,0,0,'','',2800.00,'','','Lonely_Journey_2.jpg','',0.0000,1,1,'',0.00,62,NULL,NULL),(63,'Moonlight Madness','0','hand carved slate - no color added',NULL,NULL,0,0,'','',3800.00,'','','Moonlight_Madness.jpg','',0.0000,1,1,'',0.00,63,NULL,NULL),(64,'Mother\'s Pride and Joy','0','hand carved slate - no color added',NULL,NULL,0,0,'','',3800.00,'','','Mother::s_Pride_and_Joy.jpg','',0.0000,1,1,'',0.00,64,NULL,NULL),(65,'Mother\'s Shadow','0','hand carved slate - no color added',NULL,NULL,0,0,'','',650.00,'','','Mother::s_Shadow.jpg','',0.0000,1,1,'',0.00,65,NULL,NULL),(66,'Night Games','0','hand carved slate - no color added',NULL,NULL,0,0,'','',9000.00,'','','Night_Games.jpg','',0.0000,1,1,'',0.00,66,NULL,NULL),(67,'No Name','0','hand carved slate - no color added',NULL,NULL,0,0,'','',4500.00,'','','No_Name.jpg','',0.0000,1,1,'',0.00,67,NULL,NULL),(68,'Ocean Fish','0','hand carved slate - no color added',NULL,NULL,0,0,'','',485.00,'','','Ocean_Fish.jpg','',0.0000,1,1,'',0.00,68,NULL,NULL),(69,'Orangutan','0','hand carved slate - no color added',NULL,NULL,0,0,'','',600.00,'','','Orangutan.jpg','',0.0000,1,1,'',0.00,69,NULL,NULL),(70,'Out of the Shadows','0','hand carved slate - no color added',NULL,NULL,0,0,'','',485.00,'','','Out_Of_The_Shadows.jpg','',0.0000,1,1,'',0.00,70,NULL,NULL),(71,'Piegon Prince','0','hand carved slate on sandstone - no color added',NULL,NULL,0,0,'','',5500.00,'','','Piegon_Prince.jpg','',0.0000,1,1,'',0.00,71,NULL,NULL),(72,'Prong','0','hand carved Travertine - no color added',NULL,NULL,0,0,'','',3000.00,'','','Prong.jpg','',0.0000,1,1,'',0.00,72,NULL,NULL),(73,'Pure Silver','0','hand carved slate - no color added',NULL,NULL,0,0,'','',600.00,'','','Pure_Silver.jpg','',0.0000,1,1,'',0.00,73,NULL,NULL),(74,'Rabbit','0','hand carved slate - no color added',NULL,NULL,0,0,'','',365.00,'','','Rabbit.jpg','',0.0000,1,1,'',0.00,74,NULL,NULL),(75,'Ram','0','hand carved slate - no color added',NULL,NULL,0,0,'','',685.00,'','','Ram_2.jpg','',0.0000,1,1,'',0.00,75,NULL,NULL),(76,'Rhino Riders','0','hand carved slate - no color added',NULL,NULL,0,0,'','',600.00,'','','Rhino_Riders.jpg','',0.0000,1,1,'',0.00,76,NULL,NULL),(77,'Road Runner','0','hand carved sandstone - no color added',NULL,NULL,0,0,'','',685.00,'','','Road_Runner_2.jpg','',0.0000,1,1,'',0.00,77,NULL,NULL),(78,'Sea Turtle','0','hand carved slate - no color added',NULL,NULL,0,0,'','',650.00,'','','Sea_Turtle_1.jpg','',0.0000,1,1,'',0.00,78,NULL,NULL),(79,'Green Sea Turtle','0','hand carved slate - no color added',NULL,NULL,0,0,'','',2000.00,'','','Sea_Turtle_2.jpg','',0.0000,1,1,'',0.00,79,NULL,NULL),(80,'Sheep','0','hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Sheep.jpg','',0.0000,1,1,'',0.00,80,NULL,NULL),(81,'Sisters','0','hand carved slate - no color added',NULL,NULL,0,0,'','',1500.00,'','','Sisters.jpg','',0.0000,1,1,'',0.00,81,NULL,NULL),(82,'Standing Heron','0','hand carved slate - no color added',NULL,NULL,0,0,'','',275.00,'','','Small_Herron_Standing.jpg','',0.0000,1,1,'',0.00,82,NULL,NULL),(83,'Snow Leopard','0','hand carved slate - no color added',NULL,NULL,0,0,'','',3200.00,'','','Snow_Leopard.jpg','',0.0000,1,1,'',0.00,83,NULL,NULL),(84,'Soarting Presence','0','hand carved slate - no color added',NULL,NULL,0,0,'','',3000.00,'','','Soaring_Presence.jpg','',0.0000,1,1,'',0.00,84,NULL,NULL),(85,'Sound The Alarm','0','hand carved slate - no color added',NULL,NULL,0,0,'','',400.00,'','','Sound_The_Alarm.jpg','',0.0000,1,1,'',0.00,85,NULL,NULL),(86,'Spirit of The Hunt','0','hand carved Blue Stone - no color added',NULL,NULL,0,0,'','',3000.00,'','','Spirit_Of_The_Hunt.jpg','',0.0000,1,1,'',0.00,86,NULL,NULL),(87,'Squirrel','0','hand carved slate - no color added',NULL,NULL,0,0,'','',300.00,'','','Squirrel.jpg','',0.0000,1,1,'',0.00,87,NULL,NULL),(88,'Startled','0','hand carved slate - no color added',NULL,NULL,0,0,'','',1200.00,'','','Startled.jpg','',0.0000,1,1,'',0.00,88,NULL,NULL),(89,'Stress Test','0','hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Stress_Test.jpg','',0.0000,1,1,'',0.00,89,NULL,NULL),(90,'Sunset Elk','0','hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','Sunset_Elk.jpg','',0.0000,1,1,'',0.00,90,NULL,NULL),(91,'Sunset Flight','0','hand carved slate - no color added',NULL,NULL,0,0,'','',1800.00,'','','Sunset_Flight.jpg','',0.0000,1,1,'',0.00,91,NULL,NULL),(92,'Tempted Trout','0','hand carved slate - no color added',NULL,NULL,0,0,'','',275.00,'','','Tempted_Trout.jpg','',0.0000,1,1,'',0.00,92,NULL,NULL),(93,'Tired Youngster','0','hand carved slate - no color added',NULL,NULL,0,0,'','',2800.00,'','','Tired_Youngster.jpg','',0.0000,1,1,'',0.00,93,NULL,NULL),(94,'Underway','0','hand carved slate - no color added',NULL,NULL,0,0,'','',1800.00,'','','Underway.jpg','',0.0000,1,1,'',0.00,94,NULL,NULL),(95,'Twilight Gathering','0','hand carved slate - no color added',NULL,NULL,0,0,'','',400.00,'','','Twilight_Gathering.jpg','',0.0000,1,1,'',0.00,95,NULL,NULL),(96,'Weasel Tail','0','hand carved flagstone - no color added',NULL,NULL,0,0,'','',5500.00,'','','Weasel_Tail_1.jpg','',0.0000,1,1,'',0.00,96,NULL,NULL),(97,'Golden Bear','0','hand carved slate - no color added',NULL,NULL,0,0,'','',750.00,'','','golden_bear.jpg','',0.0000,1,1,'',0.00,97,NULL,NULL),(126,'THE POUNCE','0','',NULL,NULL,0,1,'','',1200.00,'','','Pounce.jpg','',0.0000,1,1,'Hand carved slate - no color added.\r\n\r\n28\" H x 17\" W x 2\" D',0.00,126,0,NULL),(106,'DAMSEL FLY','0','',NULL,NULL,0,0,'','',165.00,'','','Damsel_Fly_8-08-04-2.jpg','',0.0000,1,1,'',0.00,106,0,NULL),(109,'ELK HAIR CADDIS','0','',NULL,NULL,0,0,'','',165.00,'','','Elk_Hair_Caddis_8-08-04-3.jpg','',0.0000,1,1,'Hand carved slate - no color added',0.00,109,0,NULL),(111,'PRINCE NYMPH','0','',NULL,NULL,0,0,'','',165.00,'','','Prince_Nymph_8-08-04-1.jpg','',0.0000,1,1,'Hand carved slate - no color added',0.00,111,0,NULL),(135,'MOUNTAIN ELK','0','',NULL,NULL,0,1,'','',1800.00,'','','elk3.jpg','',0.0000,1,1,'',0.00,135,0,NULL),(123,'ROYAL WULFF','0','',NULL,NULL,0,0,'','',165.00,'','','Royal_Wulff_8-08-04-6.jpg','',0.0000,1,1,'Hand carved slate - no color added',0.00,123,0,NULL),(134,'TRIBAL','0','Lion?  Tiger?  Shaman in a mask?  Your guess is as good as any with this hand carved representation of primitive culture.\r\n\r\nSlate on Slate - 16\" by 16\" by 4\"',NULL,NULL,0,1,'','',950.00,'','','Tribal.JPG','',0.0000,1,1,'Lion?  Tiger?  Shaman in a mask?  Your guess is as good as any with this hand carved representation of primitive culture.\r\n\r\nSlate on Slate - 16\" by 16\" by 4\"',0.00,134,0,NULL),(127,'TOSCANA','0','6 pieces of hand carved slate - no colors added.  Size 48\" x 72\"',NULL,NULL,0,1,'','',24000.00,'','','toscana.jpg','',0.0000,1,1,'6 pieces of hand carved slate - no colors added.  Size 48\" x 72\"',0.00,127,0,NULL),(128,'Toscana Detail - Left','0','Detail of Left side of Toscana sculpture.',NULL,NULL,0,1,'','',0.00,'','','Toscana_Detail_Left.jpg','',0.0000,1,1,'',0.00,128,0,NULL),(129,'Toscana Detail - Center','0','Detail of Center of Toscana Sculpture',NULL,NULL,0,1,'','',0.00,'','','Toscana_Detail_Center.jpg','',0.0000,1,1,'',0.00,129,0,NULL),(130,'Toscana Detail - Right','0','Detail of right side of Toscana sculpture.',NULL,NULL,0,1,'','',0.00,'','','Toscana_Detail_Right.jpg','',0.0000,1,1,'',0.00,130,0,NULL),(131,'DELICIOUS','0','Hand Carved Echo Canyon Flagstone.  No colors added. 35\" H 26\" W by 2\" D',NULL,NULL,0,1,'','',4800.00,'','','Delicious_Web.jpg','',0.0000,1,1,'Hand Carved Echo Canyon Flagstone.  No colors added. 35\" H 26\" W by 2\" D',0.00,131,0,NULL),(132,'MYSTERIOUS','0','Slate on slate',NULL,NULL,0,1,'','',950.00,'','','mysterious.jpg','',0.0000,1,1,'',0.00,132,0,NULL),(133,'THE MISSION','0','Multiple piece slate sculpture mounted on steel frame with old rusty finish.  Size is 3 feet by 7 feet, with the frame. Suitable for outdoor locations.',NULL,NULL,0,1,'','',18000.00,'','','THEMISSION3.jpg','',0.0000,1,1,'',0.00,133,0,NULL);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--


--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--


--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shopping`
--


--
-- Dumping events for database 'philipfeaster'
--

--
-- Dumping routines for database 'philipfeaster'
--


