--
-- Host: localhost    Database: petersonv
-- ------------------------------------------------------


--
-- 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(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

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

INSERT INTO `Category` VALUES (1,0,0,0,16,NULL,NULL,'Top Level',NULL,0),(15,0,5,20,0,'These are some examples of custom posters that we designed for customers.',NULL,'Graphic Design','',0),(16,0,6,17,0,'',NULL,'Martin Vega Rivas Oil Paintings','',0),(20,0,5,21,0,'',NULL,'Mud Valley Road Cartoon Strip','MUDVALLEYROADLOGO.jpg',0),(21,0,5,22,0,'',NULL,'Toy Designs','',0),(17,0,5,15,0,'',NULL,'Art by Ellie Peterson','',0),(22,0,5,0,0,'Personalized cartoons for your loved ones. ',NULL,'Careertoons','',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=203 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (1,10,8),(48,56,14),(3,12,8),(4,14,8),(5,15,8),(6,16,8),(7,17,8),(8,19,8),(9,20,8),(10,21,8),(11,22,8),(13,23,8),(23,24,10),(34,45,10),(22,26,10),(25,27,10),(18,31,8),(19,33,8),(167,131,15),(21,36,8),(26,37,10),(46,55,14),(28,39,10),(49,57,14),(31,42,9),(32,43,9),(35,46,8),(36,47,9),(37,48,9),(38,49,10),(39,50,10),(40,51,13),(41,52,9),(42,53,9),(44,54,8),(177,142,15),(158,94,15),(52,60,15),(54,61,16),(57,62,16),(58,63,16),(61,64,16),(62,65,16),(63,66,16),(64,67,17),(66,68,17),(72,69,17),(78,70,17),(79,71,17),(82,75,17),(80,73,17),(81,74,17),(155,89,15),(85,78,18),(87,80,18),(157,93,15),(159,95,15),(91,84,15),(153,90,15),(178,143,15),(156,92,15),(150,97,20),(111,99,20),(108,100,20),(134,103,21),(110,102,20),(135,104,21),(136,105,21),(137,107,21),(138,108,21),(191,156,15),(140,110,21),(149,111,21),(142,112,21),(143,113,21),(144,114,21),(145,115,21),(146,116,21),(147,117,21),(148,118,21),(128,119,22),(129,120,22),(130,121,22),(131,122,22),(132,123,22),(160,124,17),(161,125,17),(162,126,17),(163,127,17),(164,128,17),(165,129,17),(166,130,17),(168,132,15),(169,133,15),(170,134,15),(171,135,15),(172,136,15),(173,137,15),(192,157,15),(175,139,15),(176,141,15),(179,144,15),(180,145,15),(181,146,15),(202,167,15),(183,148,15),(184,149,15),(185,150,15),(186,151,15),(187,152,15),(188,153,15),(189,154,15),(190,155,15),(193,158,15),(194,159,15),(195,160,15),(196,161,15),(197,162,17),(198,163,16),(199,164,16),(200,165,15),(201,166,15);

--
-- 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=18 DEFAULT CHARSET=latin1;

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

INSERT INTO `Page` VALUES (1,'     <center>Graphic Illustration & Design</center>',2,0,'SOULOGO2[1].jpg','','108,70,71,47,92,117','Ellie Faye Peterson',NULL,NULL),(14,'Martin and Ellie met in Tahlequah Oklahoma in 2001 and were married in 2004. They are both artists and enjoy pursuing all sorts of artistic endeavors, together. Martin paints long lonely hallways filled with mystic light and Ellie draws what makes her laugh.      <P>\r\nPlease don´t forget to sign our guest book before you leave. Thanks for visiting. ',1,1,'ellieandmartin_6.jpg',NULL,NULL,'Ellie and Martin','Ellie and Martin',NULL),(16,'Miami, Oklahoma <BR>Designs of Autumn<BR>September 16-17, 2005<HR>\r\nFin and Feather <BR>September 23,24-25, 2005 <HR>\r\nSouthlake, Texas <BR>Octoberfest<BR>October 7,8-9',1,1,'boothsetup.jpg',NULL,NULL,'Show Schedule','',NULL),(17,'Miami, Oklahoma<BR>Designs of Autumn<BR>September 16th and 17th 2005<BR><HR>\r\nFin and Feather<BR>September 23th ,24th and 25th 2005<HR>\r\nSouthlake, Texas <BR>Octoberfest<BR>October 7th, 8th and 9th 2005<P>\r\n\r\n<BR>\r\nWe are currently in San Miguel de Allende Mexico and not attending any art shows, but we plan to start showing again in 2008 with lots of new paintings. Thank you for your patience.    ',1,1,'Ellie,Martin,Dominique2.jpg',NULL,NULL,'Art Shows','Art Shows',NULL),(3,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(4,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(5,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(6,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(7,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(8,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(9,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(10,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(11,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(12,NULL,0,2,NULL,NULL,NULL,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=168 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (5,'','0','',NULL,NULL,1,1,'','',1500.00,'','','oil_on_canvas_tortilleria.gif','',0.0000,1,1,'',0.00,5,NULL,NULL),(56,'Los Portales de San Miguel','0002','What a familiar scene from the Jardin in San Miguel de Allende. Now this charming image created by Jerald Peterson is available as a poster. ',NULL,NULL,1,1,'','',32.00,'','','portalesPOSTER_web_2.gif','',0.0000,1,1,'This large poster measures 24\" by 36\"',0.00,56,NULL,NULL),(3,'','0','',NULL,NULL,1,1,'','',1500.00,'','','oil_on_canvas_tortilleria.gif','',0.0000,1,1,'',0.00,3,NULL,NULL),(24,'Our wedding cake','0','',NULL,NULL,1,1,'','',0.00,'','','weddingcake.gif','',0.0000,1,1,'Our good friend Angela made us this beautiful cake from scratch! Our friend Micky threw together the gorgeous bouquet at the last minute. What a blessing to have such talented friends.\r\n ',0.00,24,NULL,NULL),(12,'Yellow Roses','0','16 by 20 Oil painting',NULL,NULL,1,1,'','',500.00,'','','yellowroses.gif','',0.0000,1,1,'',0.00,12,NULL,NULL),(10,'Tortilleria','0','30 by 40 oil painting',NULL,NULL,1,1,'','',1500.00,'','','oil_on_canvas_tortilleria.gif','',0.0000,1,1,'40 by 50 (framed size) of a tortilleria in San Miguel de Allende',0.00,10,NULL,NULL),(13,'Illinois river','0','9 by 12 Oil painting',NULL,NULL,1,1,'','',300.00,'','','oil_on_canvas_illinois_rive.gif','',0.0000,1,1,'',0.00,13,NULL,NULL),(14,'Illinois River','0','9 by 12 oil painting',NULL,NULL,1,1,'','',400.00,'','','oil_on_canvas_illinois_rive.gif','',0.0000,1,1,'',0.00,14,NULL,NULL),(15,'Tagine pot','0','16 by 20 Oil painting',NULL,NULL,1,1,'','',500.00,'','','stilllife_homework_2_peters.gif','',0.0000,1,1,'',0.00,15,NULL,NULL),(16,'Pears and Apples','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','pears-and-apples.gif','',0.0000,1,1,'',0.00,16,NULL,NULL),(17,'Painting watercolors','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','Painting-watercolors.gif','',0.0000,1,1,'',0.00,17,NULL,NULL),(18,'Bananas and grapes','0','16 by 20 oli painting',NULL,NULL,1,1,'','',500.00,'','','bananas-and-grapes.gif','',0.0000,1,1,'',0.00,18,NULL,NULL),(19,'Grandma\'s breakfast','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','Grandmas-breakfast.gif','',0.0000,1,1,'',0.00,19,NULL,NULL),(20,'Cowboy hat and pepper','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','cowboy-hat-and-pepper.gif','',0.0000,1,1,'',0.00,20,NULL,NULL),(21,'Empty wine glass','0','16 by 20 original oil painting',NULL,NULL,1,1,'','',0.00,'','','stilllife_random_peterson.gif','',0.0000,1,1,'',0.00,21,NULL,NULL),(22,'Empty wine glass 2','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','still_life_random_2.gif','',0.0000,1,1,'',0.00,22,NULL,NULL),(23,'Clay pot and peppers','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','clay-pot-and-peppers.gif','',0.0000,1,1,'',0.00,23,NULL,NULL),(26,'Martin cooks cow head barbacoa','0','',NULL,NULL,1,1,'','',0.00,'','','Martin_and_the_cowhead.jpg','',0.0000,1,1,'For my parents 40th wedding anniversary Martin made a Mexican specialty, cow head tacos. Boy weren\'t they surprised!\r\n',0.00,26,NULL,NULL),(27,'Misty morning','0','',NULL,NULL,1,1,'','',0.00,'','','misty_morning.gif','',0.0000,1,1,'Someone needs to write a song about this picture! ',0.00,27,NULL,NULL),(28,'guy with hat','0','',NULL,NULL,1,1,'','',0.00,'','','presentationguywithhat.jpg','',0.0000,1,1,'',0.00,28,NULL,NULL),(29,'guy with hat','0','',NULL,NULL,1,1,'','',0.00,'','','presentationguywithhat.jpg','',0.0000,1,1,'',0.00,29,NULL,NULL),(30,'bananas and grapes','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','bananas-and-grapes.gif','',0.0000,1,1,'',0.00,30,NULL,NULL),(31,'bananas and grapes','0','',NULL,NULL,1,1,'','',500.00,'','','bananas-and-grapes.gif','',0.0000,1,1,'',0.00,31,NULL,NULL),(32,'blue and white vases','0','',NULL,NULL,1,1,'','',500.00,'','','blue-and-white-vases.gif','',0.0000,1,1,'',0.00,32,NULL,NULL),(33,'Blue and white vessels','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','blue-and-white-vases.gif','',0.0000,1,1,'',0.00,33,NULL,NULL),(132,'','0','',NULL,NULL,1,1,'','',0.00,'','','Halloween_cover_08.jpg','',0.0000,1,1,'',0.00,136,0,NULL),(131,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bob_Moons_Plumbing_9-26-08.gif','',0.0000,1,1,'',0.00,131,0,NULL),(36,'Clay pot and mangos','0','16 by 20 oil painting',NULL,NULL,1,1,'','',500.00,'','','stilllife_fabric_elliepeter.gif','',0.0000,1,1,'',0.00,36,NULL,NULL),(45,'Martin building frames','0','',NULL,NULL,1,1,'','',0.00,'','','MARTINFRAMES.jpg','',0.0000,1,1,'We build many of our own frames for our work. Here Martin takes a moment to pose for the camera.   ',0.00,45,NULL,NULL),(37,'Ellie\'s big hat','0','',NULL,NULL,1,1,'','',0.00,'','','ellieinhat.gif','',0.0000,1,1,'Here is Ellie posing in a large hat. This picture may be familiar to those of you who have visited www.jeraldpeterson.com.',0.00,37,NULL,NULL),(55,'Overview of San Miguel','0001','A beautiful painting of San Miguel de Allende by Jerald Peterson available for the first time in a poster.',NULL,NULL,1,1,'','',32.00,'','','overviewPOSTER_web_2.gif','',0.0000,1,1,'',0.00,55,NULL,NULL),(39,'Yellow mums','0','',NULL,NULL,1,1,'','',0.00,'','','yellowmumsinhouse.gif','',0.0000,1,1,'We\'re in the process of arguing over who will paint this one! ',0.00,39,NULL,NULL),(42,'Yellow wall','0','36\" by 48\" original oil painting on canvas',NULL,NULL,1,1,'','',1600.00,'','','yellowwall.jpg','',0.0000,1,1,'',0.00,42,NULL,NULL),(43,'Pink rose','0','22\" by 28\" original oil painting on canvas',NULL,NULL,1,1,'','',600.00,'','','pinkrose.jpg','',0.0000,1,1,'',0.00,43,NULL,NULL),(46,'El Chareque','0','30\" by 40\" original oil painitng on canvas. ',NULL,NULL,1,1,'','',1600.00,'','','oil_on_canvas_lechareque.jpg','',0.0000,1,1,'',0.00,46,NULL,NULL),(47,'Light and Shadow','0','',NULL,NULL,1,1,'','',1500.00,'','','martinlightandshadow_2.jpg','',0.0000,1,1,'',0.00,47,NULL,NULL),(48,'Three arches','0','',NULL,NULL,1,1,'','',1500.00,'','','martinthreearches.jpg','',0.0000,1,1,'',0.00,48,NULL,NULL),(49,'','0','Dominic McCoy Vega, born May 20th 2005 ',NULL,NULL,1,1,'','',0.00,'','','martinanddominic.jpg','',0.0000,1,1,'',0.00,49,NULL,NULL),(50,'','0','July 20th, 2005',NULL,NULL,1,1,'','',0.00,'','','dominictwomonthsold.jpg','',0.0000,1,1,'',0.00,50,NULL,NULL),(51,'','0','',NULL,NULL,1,1,'','',0.00,'','','boothsetup.jpg','',0.0000,1,1,'',0.00,51,NULL,NULL),(52,'The stairway','0','24 by 30 oil painting',NULL,NULL,1,1,'','',800.00,'','','martinstairway.jpg','',0.0000,1,1,'',0.00,52,NULL,NULL),(53,'Mi cielo azul','0','24 by 30 oil painting',NULL,NULL,1,1,'','',750.00,'','','martinmicieloazul.jpg','',0.0000,1,1,'',0.00,53,NULL,NULL),(54,'The balloon man','0','30 by 40 oil painting',NULL,NULL,1,1,'','',2000.00,'','','ellietheballoonman.jpg','',0.0000,1,1,'',0.00,54,NULL,NULL),(57,'East Window','0003','This poster is of a painting by Martin. It is also 24\" by 36\"',NULL,NULL,1,1,'','',32.00,'','','eastwindow_2_web.gif','',0.0000,1,1,'',0.00,57,NULL,NULL),(142,'','0','',NULL,NULL,1,1,'','',0.00,'','','ntune_gateway_08.gif','',0.0000,1,1,'',0.00,142,0,NULL),(143,'','0','',NULL,NULL,1,1,'','',0.00,'','','Grand_View_back_to_school_08.gif','',0.0000,1,1,'',0.00,143,0,NULL),(93,'Logo Design','0','',NULL,NULL,1,1,'','',0.00,'','','LOGO.jpg','',0.0000,1,1,'',0.00,93,NULL,NULL),(89,'Graphic Illustration','0','Anti-drug poster by Ellie Peterson',NULL,NULL,1,1,'','',0.00,'','','1crankposteroo.jpg','',0.0000,1,1,'',0.00,89,NULL,NULL),(94,'Ad Design','0','',NULL,NULL,1,1,'','',0.00,'','','AD11QUEBRADA.jpg','',0.0000,1,1,'',0.00,94,NULL,NULL),(60,'Bruno and Chilas Wedding','0','',NULL,NULL,1,1,'','',0.00,'','','BRUNOYISIADORA_web.gif','',0.0000,1,1,'',0.00,62,NULL,NULL),(61,'Tres Arcos','0','This is an original oil painting by Martin Vega that measures 30 by 40 inches.',NULL,NULL,1,1,'','',2000.00,'','','MARTINTRESARCOS2.jpg','',0.0000,1,1,'',0.00,60,NULL,NULL),(62,'Revealing Light','0','This is an original oil painting by Martin Vega Rivas that measures 30 by 40 inches.',NULL,NULL,1,1,'','',2000.00,'','','MARTINLIGHTANDSHADOW2.jpg','',0.0000,1,1,'',0.00,61,NULL,NULL),(63,'Mission Refuge','0','The original oil painting was sold in 2006.  Limited edition giclee prints on canvas are available to our customers.    ',NULL,NULL,1,1,'','',0.00,'','','martinstairway.jpg','',0.0000,1,1,'',0.00,63,NULL,NULL),(64,'East Window','0','The original painting was sold in 2006 and is now in New York.  Giclee prints on canvas are available to our customers.  ',NULL,NULL,1,1,'','',0.00,'','','eastwindow.jpg','',0.0000,1,1,'',0.00,64,NULL,NULL),(65,'Mi Cielo Azul','0','This recognizable doorway in San Miguel was painted in 2005.  Giclee prints are available to our customers.',NULL,NULL,1,1,'','',0.00,'','','martinmicieloazul.jpg','',0.0000,1,1,'',0.00,65,NULL,NULL),(66,'Arches Study','0','This original oil painting measures  30 by 40 inches. ',NULL,NULL,1,1,'','',2000.00,'','','archespainting.jpg','',0.0000,1,1,'',0.00,66,NULL,NULL),(67,'Balloon Man','0','This is an original oil painting that measures 30 by 40 inches.  ',NULL,NULL,1,1,'','',2000.00,'','','balloonman.jpg','',0.0000,1,1,'',0.00,67,NULL,NULL),(68,'El Chareque','0','The original oil painting is in Oklahoma. Limited edition prints are available to our customers. ',NULL,NULL,1,1,'','',0.00,'','','PAINTING10.jpg','',0.0000,1,1,'',0.00,68,NULL,NULL),(69,'Numero 32','0','This original watercolor was sold in 2005. Limited edition photo prints are available to our customers.',NULL,NULL,1,1,'','',0.00,'','','PAINTING3.jpg','',0.0000,1,1,'',0.00,69,NULL,NULL),(70,'Fish in Hats I','0','Limited edition prints are available to our customers of these delightful paintings. The originals were acrylics.  ',NULL,NULL,1,1,'','',0.00,'','','PAINTING4.jpg','',0.0000,1,1,'',0.00,70,NULL,NULL),(71,'Fish in Hats II','0','More fish, more hats. Limited edition prints are available. ',NULL,NULL,1,1,'','',0.00,'','','PAINTING5.jpg','',0.0000,1,1,'',0.00,71,NULL,NULL),(73,'Intergalactic Cafe','0','This original acrylic painting measures 30 by 40 inches. The frame is handpainted by the artist. ',NULL,NULL,1,1,'','',1000.00,'','','PAINTING7.jpg','',0.0000,1,1,'',0.00,73,NULL,NULL),(74,'Illinois River','0','Limited edition prints of this small plein air oil painting are available to our customers.  ',NULL,NULL,1,1,'','',0.00,'','','PAINTING8.jpg','',0.0000,1,1,'',0.00,74,NULL,NULL),(75,'Tortilleria','0','This original oil painting measures 24 by 36 inches. ',NULL,NULL,1,1,'','',0.00,'','','oil_on_canvas_tortilleria.jpg','',0.0000,1,1,'',0.00,75,NULL,NULL),(78,'','0','',NULL,NULL,1,1,'','',0.00,'','','AD11QUEBRADA.jpg','',0.0000,1,1,'',0.00,78,NULL,NULL),(80,'','0','',NULL,NULL,1,1,'','',0.00,'','','ADBARSANMIGUEL.jpg','',0.0000,1,1,'',0.00,80,NULL,NULL),(95,'Ad Design','0','',NULL,NULL,1,1,'','',0.00,'','','ADBARSANMIGUEL.jpg','',0.0000,1,1,'',0.00,102,NULL,NULL),(84,'Page Design','0','',NULL,NULL,1,1,'','',0.00,'','','1butterflyposter.jpg','',0.0000,1,1,'',0.00,84,NULL,NULL),(90,'Graphic Illustration','0','',NULL,NULL,1,1,'','',0.00,'','','1flyingposteroo.jpg','',0.0000,1,1,'',0.00,90,NULL,NULL),(144,'','0','',NULL,NULL,1,1,'','',0.00,'','','Kate_Miller_business_women_08-1.gif','',0.0000,1,1,'',0.00,144,0,NULL),(92,'Poster Design','0','',NULL,NULL,1,1,'','',0.00,'','','1operaposteroo.jpg','',0.0000,1,1,'',0.00,92,NULL,NULL),(97,'','0','This is an Oklahoma based cartoon that explores the personal lives of several road side residents by Ellie Peterson. Stay tuned for new exciting episodes. ',NULL,NULL,1,1,'','',0.00,'','','MUDVALLEYROADLOGO.jpg','',0.0000,1,1,'',0.00,95,NULL,NULL),(100,'','0','',NULL,NULL,1,1,'','',0.00,'','','MUDVALLEYROAD2.jpg','',0.0000,1,1,'',0.00,99,NULL,NULL),(104,'Witches Brew','0','Gather ingredients for a gross slimey brew first.',NULL,NULL,1,1,'','',0.00,'','','TOYDESIGN2.jpg','',0.0000,1,1,'',0.00,104,NULL,NULL),(99,'','0','',NULL,NULL,1,1,'','',0.00,'','','MUDVALLEYROAD1.jpg','',0.0000,1,1,'',0.00,97,NULL,NULL),(103,'Groovin Gator','0','This groovin gator dances with children.   ',NULL,NULL,1,1,'','',0.00,'','','TOYDESIGN1.jpg','',0.0000,1,1,'',0.00,103,NULL,NULL),(105,'Baby Raindrop','0','Cuddly baby raindrop for little girls.',NULL,NULL,1,1,'','',0.00,'','','TOYDESIGN3.jpg','',0.0000,1,1,'',0.00,105,NULL,NULL),(102,'','0','',NULL,NULL,1,1,'','',0.00,'','','MUDVALLEYROAD3.jpg','',0.0000,1,1,'',0.00,100,NULL,NULL),(107,'Martian Playground','0','Fun for Martians',NULL,NULL,1,1,'','',0.00,'','','toydesignalienplayground.jpg','',0.0000,1,1,'',0.00,107,NULL,NULL),(108,'Buffet table surprise mask','0','Scare your friends disguised as a scary entree.',NULL,NULL,1,1,'','',0.00,'','','toydesignbuffettablesurprise.jpg','',0.0000,1,1,'',0.00,108,NULL,NULL),(156,'','0','',NULL,NULL,1,1,'','',0.00,'','','Tahlequah_Public_Schools.jpg','',0.0000,1,1,'',0.00,156,0,NULL),(157,'','0','',NULL,NULL,1,1,'','',0.00,'','','tenkiller.jpg','',0.0000,1,1,'',0.00,157,0,NULL),(110,'Hip Hop Bop','0','A hip hop snail who moves to a hip hop beat.',NULL,NULL,1,1,'','',0.00,'','','toydesignhiphopbop.jpg','',0.0000,1,1,'',0.00,110,NULL,NULL),(111,'Hootinany Hippies','0','These little hippies live on a commune and would like to take a road trip. ',NULL,NULL,1,1,'','',0.00,'','','toydesignhootinanyhippies.jpg','',0.0000,1,1,'',0.00,111,NULL,NULL),(112,'Intergalactic Cafe in a case','0','Cute intergalactic cafe drive-thru with real little martians in space cars.',NULL,NULL,1,1,'','',0.00,'','','toydesignintergalacticcafe.jpg','',0.0000,1,1,'',0.00,112,NULL,NULL),(113,'Molly and McGraw','0','Molly doll who takes care of her own dog. ',NULL,NULL,1,1,'','',0.00,'','','toydesignmollyandmcgraw.jpg','',0.0000,1,1,'',0.00,113,NULL,NULL),(114,'Peanut butter Factory','0','',NULL,NULL,1,1,'','',0.00,'','','toydesignpeanutbutterfactory.jpg','',0.0000,1,1,'',0.00,114,NULL,NULL),(115,'The Punk Factory','0','Make your own punks and decorate them.',NULL,NULL,1,1,'','',0.00,'','','toydesignpunkfactory.jpg','',0.0000,1,1,'',0.00,115,NULL,NULL),(116,'Rainbow wishes','0','Tiny land of rainbow fairies.',NULL,NULL,1,1,'','',0.00,'','','toydesignrainbow.jpg','',0.0000,1,1,'',0.00,116,NULL,NULL),(117,'Sir Snagglepuss','0','The Well Mannered Talking Society Monster.',NULL,NULL,1,1,'','',0.00,'','','toydesignsirsnagglepuss.jpg','',0.0000,1,1,'',0.00,117,NULL,NULL),(118,'Texas Jack','0','Bucking Bronco and Texas Jack.',NULL,NULL,1,1,'','',0.00,'','','toydesigntexasjack.jpg','',0.0000,1,1,'',0.00,118,NULL,NULL),(119,'','0','',NULL,NULL,1,1,'','',0.00,'','','CAREERTOON1.jpg','',0.0000,1,1,'',0.00,119,NULL,NULL),(120,'','0','',NULL,NULL,1,1,'','',0.00,'','','CAREERTOON2.jpg','',0.0000,1,1,'',0.00,120,NULL,NULL),(121,'','0','',NULL,NULL,1,1,'','',0.00,'','','CAREERTOON3.jpg','',0.0000,1,1,'',0.00,121,NULL,NULL),(122,'','0','',NULL,NULL,1,1,'','',0.00,'','','CAREERTOON4.jpg','',0.0000,1,1,'',0.00,122,NULL,NULL),(123,'','0','',NULL,NULL,1,1,'','',0.00,'','','CAREERTOON5.jpg','',0.0000,1,1,'',0.00,123,NULL,NULL),(124,'Grandmas Breakfast','0','Grandmas breakfast. A nice little oil. Sold, but prints are available. ',NULL,NULL,1,1,'','',0.00,'','','Grandmas-breakfast.gif','',0.0000,1,1,'',0.00,124,NULL,NULL),(125,'Watercolors','0','Oil on canvas. 16 by 20 inches. ',NULL,NULL,1,1,'','',300.00,'','','Painting-watercolors.gif','',0.0000,1,1,'',0.00,125,NULL,NULL),(126,'Blue and White Vase','0','Oil on canvas. 16 by 20 inches',NULL,NULL,1,1,'','',300.00,'','','blue-and-white-vases.gif','',0.0000,1,1,'',0.00,126,NULL,NULL),(127,'Pears and Apples','0','Oil on canvas. Prints available',NULL,NULL,1,1,'','',0.00,'','','pears-and-apples.gif','',0.0000,1,1,'',0.00,127,NULL,NULL),(128,'Grandmas Roses','0','A painting for Grandma. Prints available',NULL,NULL,1,1,'','',0.00,'','','yellowroses.gif','',0.0000,1,1,'',0.00,128,NULL,NULL),(129,'Artists collection','0','',NULL,NULL,1,1,'','',0.00,'','','winostilllife_3.jpg','',0.0000,1,1,'',0.00,129,NULL,NULL),(130,'Artists collection II','0','',NULL,NULL,1,1,'','',0.00,'','','winostilllife_4.jpg','',0.0000,1,1,'',0.00,130,NULL,NULL),(133,'','0','',NULL,NULL,1,1,'','',0.00,'','','Heavenly_Bride_2-17-08.gif','',0.0000,1,1,'',0.00,132,0,NULL),(134,'','0','',NULL,NULL,1,1,'','',0.00,'','','Loves_Briar_Patch_Gateway_to_Adventure.gif','',0.0000,1,1,'',0.00,137,0,NULL),(135,'','0','',NULL,NULL,1,1,'','',0.00,'','','House_Filler_Gateway_05-08.gif','',0.0000,1,1,'',0.00,133,0,NULL),(136,'','0','',NULL,NULL,1,1,'','',0.00,'','','NSU_2-17-08.gif','',0.0000,1,1,'',0.00,138,0,NULL),(137,'','0','',NULL,NULL,1,1,'','',0.00,'','','salvation_army_heart_o_hills_map_08.gif','',0.0000,1,1,'',0.00,134,0,NULL),(158,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bill_Willis.jpg','',0.0000,1,1,'',0.00,158,0,NULL),(139,'','0','',NULL,NULL,1,1,'','',0.00,'','','Southside_Drive_In_6-19-08.gif','',0.0000,1,1,'',0.00,140,0,NULL),(140,'','0','',NULL,NULL,1,1,'','',0.00,'','','everything_under_the_sun_gateway_08.gif','',0.0000,1,1,'',0.00,141,0,NULL),(141,'','0','',NULL,NULL,1,1,'','',0.00,'','','Peterson_Fine_Art_Map_08.gif','',0.0000,1,1,'',0.00,135,0,NULL),(145,'','0','',NULL,NULL,1,1,'','',0.00,'','','cherry_springs_gateway_08_spec.gif','',0.0000,1,1,'',0.00,145,0,NULL),(146,'','0','',NULL,NULL,1,1,'','',0.00,'','','Southside_Drive_In_6-19-08.gif','',0.0000,1,1,'',0.00,146,0,NULL),(167,'','0','',NULL,NULL,1,1,'','',0.00,'','','cherrysprings.jpg','',0.0000,1,1,'',0.00,167,0,NULL),(148,'','0','',NULL,NULL,1,1,'','',0.00,'','','Davis_Interiors_12-14-08.jpg','',0.0000,1,1,'',0.00,148,0,NULL),(149,'','0','',NULL,NULL,1,1,'','',0.00,'','','eagle_paint_4x14_12-11-08.jpg','',0.0000,1,1,'',0.00,149,0,NULL),(150,'','0','',NULL,NULL,1,1,'','',0.00,'','','keys_family_dentistry_12-9-08.jpg','',0.0000,1,1,'',0.00,150,0,NULL),(151,'','0','',NULL,NULL,1,1,'','',0.00,'','','Look-n-Good_Leathers,_On_the_Move_11-30-08.jpg','',0.0000,1,1,'',0.00,151,0,NULL),(152,'','0','',NULL,NULL,1,1,'','',0.00,'','','Village_Cafe,_On_The_Move_4x14.jpg','',0.0000,1,1,'',0.00,152,0,NULL),(153,'','0','',NULL,NULL,1,1,'','',0.00,'','','History_of_Tahlequah_Cover_08.jpg','',0.0000,1,1,'',0.00,153,0,NULL),(154,'','0','',NULL,NULL,1,1,'','',0.00,'','','talking_leaves_calendar_2009.jpg','',0.0000,1,1,'',0.00,154,0,NULL),(155,'','0','',NULL,NULL,1,1,'','',0.00,'','','ADBANNER.jpg','',0.0000,1,1,'',0.00,155,0,NULL),(159,'','0','',NULL,NULL,1,1,'','',0.00,'','','charlotte_folly_spec_2-28-08.jpg','',0.0000,1,1,'',0.00,159,0,NULL),(160,'','0','',NULL,NULL,1,1,'','',0.00,'','','charlotte_folly_spec_2-28-08_2.jpg','',0.0000,1,1,'',0.00,160,0,NULL),(161,'','0','',NULL,NULL,1,1,'','',0.00,'','','Graduation_cover_08.jpg','',0.0000,1,1,'',0.00,161,0,NULL),(162,'','0','',NULL,NULL,1,1,'','',0.00,'','','favorite-shoes.gif','',0.0000,1,1,'',0.00,162,0,NULL),(163,'','0','',NULL,NULL,1,1,'','',0.00,'','','MARTINFRAMES.jpg','',0.0000,1,1,'',0.00,163,0,NULL),(164,'','0','',NULL,NULL,1,1,'','',0.00,'','','BOOTHPICTURES.jpg','',0.0000,1,1,'',0.00,164,0,NULL),(165,'','0','',NULL,NULL,1,1,'','',0.00,'','','Cherry_Springs_3-9-08.jpg','',0.0000,1,1,'',0.00,165,0,NULL),(166,'','0','',NULL,NULL,1,1,'','',0.00,'','','cherry_springs_5-4-08.jpg','',0.0000,1,1,'',0.00,166,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 'petersonv'
--

--
-- Dumping routines for database 'petersonv'
--


