--
-- Host: localhost    Database: bozenka
-- ------------------------------------------------------


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

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

INSERT INTO `Category` VALUES (1,0,0,0,6,NULL,NULL,'Top Level',NULL,0),(2,0,8,7,0,'',NULL,'People','',0),(3,0,6,0,0,'',NULL,'Scrap Book - Sold Works','',0),(7,0,8,13,0,'',NULL,'Southwest','',0),(13,0,8,14,0,'',NULL,'Other Places','',0),(6,0,8,2,0,'',NULL,'Flowers','',0),(14,0,8,3,0,'',NULL,'Custom Ketubahs','',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=390 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (377,1,6),(338,90,13),(15,12,3),(5,4,3),(6,5,3),(7,6,3),(8,7,3),(349,13,2),(10,9,3),(244,72,3),(13,11,4),(350,15,2),(147,16,3),(343,17,7),(24,18,3),(61,19,3),(146,20,3),(312,21,7),(28,22,3),(136,23,3),(30,24,3),(314,25,7),(33,27,3),(34,28,3),(316,47,7),(351,30,2),(291,31,6),(313,32,7),(359,33,2),(292,34,6),(353,91,2),(42,36,3),(363,38,7),(46,39,3),(47,40,3),(48,41,3),(49,42,3),(50,43,3),(51,44,3),(52,45,3),(242,49,3),(317,50,7),(331,93,7),(356,54,13),(318,55,7),(126,56,3),(293,60,6),(236,89,3),(243,62,3),(358,63,6),(354,94,2),(330,92,7),(320,68,7),(295,69,6),(345,71,7),(246,73,3),(239,74,3),(322,75,7),(362,76,7),(306,77,2),(360,78,7),(247,79,3),(364,80,7),(296,81,6),(240,82,3),(248,84,3),(337,85,13),(327,86,7),(241,87,3),(332,95,7),(333,96,7),(355,104,2),(329,98,7),(297,99,6),(299,100,6),(335,101,7),(357,102,13),(366,107,13),(383,108,14),(368,109,14),(373,110,14),(370,111,14),(371,113,14),(384,115,14),(385,116,14),(386,117,14),(387,118,14),(388,119,14),(389,120,14);

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

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

INSERT INTO `Page` VALUES (1,'<H1><center>\r\n  <p align=\"center\">\r\nWelcome to the Bozenka website<br></p>\r\n</center></H1>',2,0,'RedHatLadies.jpg','Featured Artwork','9','',NULL,NULL),(2,'Bozenka is a Czechoslovakian-born artist who has lived in the valley for more than 30 years.  Betty Peterson paints under her birth name of Bozenka.\r\n\r\n\r\nShe paints varied subjects, flowers, places and people; her paintings are known for their vivid colors.\r\n\r\n<br><br><br>\r\nPeterson studied at the Kachina School of Art, Scottsdale Artists School, and was a student of the late muralist, Jay Datus.  She took a break from active painting for over 20 years during which time she earned an interior design degree and worked in the field of commercial design.',2,1,'betty.jpg',NULL,NULL,'About Boženka','About Boženka',NULL),(7,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(5,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(6,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,'',''),(13,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(14,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=121 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'Arizona Sunflowers','0','Oil on canvas \r\n<br>\r\n15 x 30 framed',NULL,NULL,1,1,'','',1800.00,'','','Sunflowers.jpg','',0.0000,1,1,'These were grown in my back yard! These are my spring 2007 crop and they were six feel tall.  Sunflowers are a painters dream.  The birds in my back yard loved them!  \r\n<br><br>\r\nOil on canvas \r\n<br>\r\n15 x 30 framed\r\n<br>\r\n$1,800',0.00,1,0,NULL),(91,'Buckskin Johnny','0','8 x 10 <BR>\r\nFramed oil on canvas ',NULL,NULL,1,1,'','',225.00,'','','BuckskinJohnny_640.jpg','',0.0000,1,1,'Prescott Arizona\'s Theatre group had just completed a skit at Fain Park and this buckskin dude needed a rest in the shade...Johnny is his name...<BR><BR>Oil on canvas\r\n<BR>8x10 framed<BR>\r\n$225',0.00,91,0,NULL),(49,'Burro Going to Market','0','To Market to market \r\n<br><br>\r\nOil on canvas\r\n<br>16 x 20 gallery wrap',NULL,NULL,1,1,'','',0.00,'','','Burro640.jpg','',0.0000,1,1,'To Market to market \r\n<br><br>\r\nThis happy burro is ready to go to the marketplace in San Miguel in central Mexico.  This is a way for the owner to earn a living by posing the burro with tourists…especially children.  Sometimes he even sells a sombrero or two. \r\n<br><br>\r\nOil on canvas\r\n<br>16 x 20 gallery wrap',0.00,49,0,NULL),(15,'Clammin\' & Jammin\'','0','Clammin\' & Jammin\' on Coronado Island\r\n<BR>\r\n16 x 20  Oil on canvas ',NULL,NULL,0,1,'','',800.00,'','','Clammin.jpg','',0.0000,1,1,'These two guys were clamming at 5:30 a.m. when I noticed the sun coming up and the reflections on the water.  I asked them if I could take their picture, informing them that they may end up in a painting.  They smilingly agreed and asked if they should pose.  I assured them that their pose was perfect sitting on a kitty litter bucket and just jamming. Two years later, I found them again, and they were still using the same kitty litter buckets for their clams! \r\n<BR><BR>\r\nOil on canvas<BR>\r\n16x20 Gallery Wrap<BR>$800',0.00,14,0,NULL),(12,'Basket Peddler','0','',NULL,NULL,0,0,'','',0.00,'','','BasketPed.jpg','',0.0000,1,1,'',0.00,4,NULL,NULL),(4,'Aldama Street','0','',NULL,NULL,1,1,'','',0.00,'','','AldamaStreet.jpg','',0.0000,1,1,'',0.00,7,NULL,NULL),(5,'Autumn Leaves','0','',NULL,NULL,1,1,'','',0.00,'','','AutumnLeaves.jpg','',0.0000,1,1,'',0.00,5,NULL,NULL),(6,'Mom\'s Hat','0','',NULL,NULL,1,1,'','',0.00,'','','MomsHat.jpg','',0.0000,1,1,'',0.00,8,NULL,NULL),(7,'French Countryside','0','',NULL,NULL,1,1,'','',0.00,'','','FrenchCountryside.jpg','',0.0000,1,1,'',0.00,6,NULL,NULL),(13,'Fiddlin\' In Prescott, Arizona','0','Framed 16 x 20 <br>Oil on canvas',NULL,NULL,0,1,'','',1000.00,'','','Fiddlin_In_AZ.jpg','',0.0000,1,1,'This happy fiddler was seen on \r\nWhiskey Row in Prescott, Arizona,\r\nplaying to OUR hearts content. \r\nThe city of Prescott has many special \r\nevents and this one was across \r\nthe street from Courthouse square. \r\nHe made beautiful fiddle music and \r\na fun painting. \r\n<br><br>\r\nOil on canvas <br>\r\n16x20 framed<BR>$1,000',0.00,13,0,NULL),(9,'Indian Child','0','',NULL,NULL,1,1,'','',0.00,'','','IndianChild.jpg','',0.0000,1,1,'',0.00,10,NULL,NULL),(11,'French Country Side','0','French Side Short Desc',NULL,NULL,1,1,'','',2500.00,'','','FrenchCountryside.jpg','',0.0000,1,1,'French Country Side Long Description',0.00,11,NULL,NULL),(16,'Three Pots','0','Three Pots \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n24 x 24 gallery wrap',NULL,NULL,1,1,'','',600.00,'','','PotsAtDump.jpg','',0.0000,1,1,'Three Pots \r\n<br><br>\r\nThe lore of the southwest is about Indians and what they left behind.  These are replicas of Indian pots that I found in Carefree at the Town Dump. It really is not a dump but a  place to see old time stuff that looks like what the Indians left behind. \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n24 x 24 gallery wrap',0.00,16,0,NULL),(17,'Door in San Miguel de Allende','0','Beautiful door in old San Miguel de Allende.',NULL,NULL,0,1,'','',2200.00,'','','SanMiguelDoor.jpg','',0.0000,1,1,'San Miguel de Allende is a colonial town in the mountians of Mexico.  Their beautiful doors lead to the courtyards which cannot be seen from the street. \r\n\r\nThis one usually had a couple of women selling flowers. The day I painted this...they took the day off.<BR><BR>\r\nOil on canvas<BR>\r\n30x48 framed<BR>$2,200',0.00,20,0,NULL),(18,'Girlfriends','0','',NULL,NULL,0,1,'','',0.00,'','','GirlFriends.jpg','',0.0000,1,1,'',0.00,17,NULL,NULL),(19,'Posada Carmena','0','',NULL,NULL,1,1,'','',1500.00,'','','PosadaCarmena.jpg','',0.0000,1,1,'',0.00,18,NULL,NULL),(20,'Prickly Pear Jelly','0','Colorful Prickly Pears\r\n<BR><BR>\r\nOil on canvas<br>\r\n24 x 24   gallery wrap\r\n',NULL,NULL,1,1,'','',400.00,'','','PricklyJelly.jpg','',0.0000,1,1,'Colorful Prickly Pears\r\n<br><br>\r\nThe southwest is covered with cactus and who would think that this could be beautiful and good for you! The ‘pears’ ripen in late August and are made into syrup, jelly and candy. I photographed these, painted a painting, then made prickly pear jelly!  Fun! Ask me for the recipe. \r\n<br><br>\r\nOil on canvas<br>\r\n24 x 24   gallery wrap',0.00,19,0,NULL),(21,'Equipale Chair','0','Equipale Chair\r\n<br>\r\n24x24 Gallery wrap oil',NULL,NULL,0,1,'','',1100.00,'','','Chair.jpg','',0.0000,1,1,'The Equipale chair is seen all over Mexico and the Southwest.  These are hand made from dyed pigskin and there are no two alike...we could say they are a work of original art!  I was fascinated by them and had to paint this one in our hosts back patio in Mexico.<BR><BR>Oil on canvas<BR>24x24 Gallery wrap<BR>$1,100',0.00,24,0,NULL),(22,'Blue Sweater','0','',NULL,NULL,1,1,'','',0.00,'','','BlueSweater.jpg','',0.0000,1,1,'',0.00,22,NULL,NULL),(23,'Guard House Pot','0','Guard house flower pot',NULL,NULL,0,1,'','',450.00,'','','Guardhouse_Pot.jpg','',0.0000,1,1,'There is a guard house near where we live and this big flower pot was full of color.  It was fun to paint.  It is 18 x 24 framed in a rustic frame. ',0.00,23,0,NULL),(24,'Sushi at 6 am on Coronado','0','',NULL,NULL,1,1,'','',0.00,'','','Sushi.jpg','',0.0000,1,1,'',0.00,25,NULL,NULL),(25,'Blue Agave','0','16 x 20 <br>Gallery wrap oil on canvas ',NULL,NULL,1,1,'','',800.00,'','','BlueAgave640.jpg','',0.0000,1,1,'Blue Agave cactus plants grow all over the Southwest. I got this particular image in the desert area of the Biltmore Estates. In Mexico they make tequila from this cactus.<BR><BR>Oil on canvas <BR>16x20 Gallery wrap<BR>\r\n$800',0.00,33,0,NULL),(28,'Harmony','0','',NULL,NULL,0,1,'','',0.00,'','','Harmony.jpg','',0.0000,1,1,'',0.00,28,NULL,NULL),(27,'Light & Shadows','0','',NULL,NULL,0,1,'','',0.00,'','','LightShadows.jpg','',0.0000,1,1,'',0.00,21,NULL,NULL),(47,'Basket Peddler - Giclee','0','The Basket Peddler of San Miguel \r\n<br><br>\r\nGiclee print - gallery wrap\r\n<br>\r\n36 x 48',NULL,NULL,1,1,'','',600.00,'','','BasketPed.jpg','',0.0000,1,1,'The Basket Peddler of San Miguel \r\n<br><br>\r\nThis man had fifteen baskets on his body…that I could see.  He spend his days walking around with the hope that he would sell a few baskets so he could feed his family.  We spent two weeks in San Miguel and he was on the streets every day during our stay. Amazing! \r\n<br><br>\r\nGiclee print\r\n<br>\r\n36 x 48 Gallery wrap<BR>$600',0.00,47,0,NULL),(30,'Gambler from Wickenberg','0','Gambler from Wickenberg\r\n<BR>\r\n16 x 20 framed oil ',NULL,NULL,0,1,'','',1100.00,'','','Gambler_from_Wickenberg.jpg','',0.0000,1,1,'This cowboy had the poker-face look down pat when he was playing cards.  He was a delightful subject and the painting ended up fun and games...no gun though. <BR><BR>\r\nOil on canvas<BR>16x20 framed<BR>\r\n$1,100',0.00,30,0,NULL),(31,'Sunflowers in France','0','Oil on canvas \r\n<br>\r\n48 x 30  gallery wrap',NULL,NULL,0,1,'','',2200.00,'','','Sunflowers_in_France_640.jpg','',0.0000,1,1,'We have traveled in France and this is a welcome scene throughout the country side.  The little villages are surrounded by fields of sunflowers wild with blooms.  We noted that they all face the sun…I guess that’s why they are called sunflowers.\r\n<br><br>\r\nOil on canvas \r\n<br>\r\n48 x 30  gallery wrap\r\n<br>\r\n$2,200',0.00,32,0,NULL),(32,'Sunset Palm Trees','0','Oil on canvas<br>\r\n12 x 24 framed ',NULL,NULL,0,1,'','',800.00,'','','Palms_III.jpg','',0.0000,1,1,'Sunset Palm Trees \r\n<br><br>\r\nPhoenix has many varieties of palm trees which line the canal.  In the late afternoon the sun sparkles in the fronds and makes interesting viewing. This was taken about 4:00 P.M. when the sun and the wind were at play with the birds. \r\n<br><br>\r\nOil on canvas\r\n<br>12 x 24 framed<BR>$800',0.00,31,0,NULL),(33,'Red Hat Ladies','0','The Red Hat Ladies Club \r\n<br>\r\n48 x 30 framed \r\n',NULL,NULL,0,1,'','',1100.00,'','','RedHatLadies.jpg','',0.0000,1,1,'Red Hat Ladies love to go to lunch and it\'s fun to see them.  We caught these in the act at Crescent Beach, British Columbia.  The pretty hat in the middle of the painting convinced me that this was an interesting group of ladies. We visited with them and, indeed, they were interesting! <BR><BR>\r\nOil on canvas<BR>48x30 framed<BR>$900',0.00,34,0,NULL),(34,'Tulips','0','Oil on canvas\r\n<br>\r\n16x20 framed',NULL,NULL,0,1,'','',800.00,'','','Tulips.jpg','',0.0000,1,1,'These tulips were the announcement for spring. The colors were so bright and beautiful that I had to paint them.  The vase is an antique and I have admired it and decided it was the right vase for the tulips. \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n16x20 framed\r\n<BR>\r\n$800',0.00,36,0,NULL),(36,'Basket Peddler','0','',NULL,NULL,0,1,'','',0.00,'','','BasketPed.jpg','',0.0000,1,1,'',0.00,38,NULL,NULL),(38,'San Miguel  de Allende Cathedral','0','Oil on Canvas \r\n<br>\r\n16x20 framed ',NULL,NULL,0,1,'','',900.00,'','','CathedralSanMiguel.jpg','',0.0000,1,1,'San Miguel Cathedral \r\n<br><br>\r\nThe city square in San Miguel has several churches and this beautiful cathedral which sits right in the middle of the little city.  There is also a lovely garden or park that is called Les Jardine.  Many city dwellers spend there evenings here because this is where the action is.  \r\n<br><br>\r\nOil on Canvas \r\n<br>\r\n16x20 framed <BR>$900',0.00,27,0,NULL),(39,'St Thomas','0','',NULL,NULL,1,1,'','',0.00,'','','StThomas_320.jpg','',0.0000,1,1,'',0.00,39,NULL,NULL),(40,'Mexican Village','0','',NULL,NULL,1,1,'','',0.00,'','','MexVill.jpg','',0.0000,1,1,'',0.00,40,NULL,NULL),(41,'Aspens in Flagstaff','0','',NULL,NULL,1,1,'','',0.00,'','','AspensFlag.jpg','',0.0000,1,1,'',0.00,41,NULL,NULL),(42,'My Hollyhocks','0','',NULL,NULL,1,1,'','',0.00,'','','MyHollyhocks.jpg','',0.0000,1,1,'',0.00,42,NULL,NULL),(43,'Mexican Village II','0','',NULL,NULL,1,1,'','',0.00,'','','MexVill2.jpg','',0.0000,1,1,'',0.00,43,NULL,NULL),(44,'Budgie Conference','0','',NULL,NULL,1,1,'','',0.00,'','','BudgieConference.jpg','',0.0000,1,1,'',0.00,44,NULL,NULL),(45,'Forgotten Corral','0','',NULL,NULL,0,1,'','',0.00,'','','ForgottenCorral.jpg','',0.0000,1,1,'',0.00,45,NULL,NULL),(50,'Prickly Pears at Sunrise','0','Colorful Prickly Pears\r\n<br><br>\r\nOil on canvas \r\n<br>24 x 24   gallery wrap',NULL,NULL,1,1,'','',1100.00,'','','PPearSunrise_640.jpg','',0.0000,1,1,'Colorful Prickly Pears\r\n<br><br>\r\nThe southwest is covered with cactus and who would think that this could be beautiful and good for you! The ‘pears’ ripen in late August and are made into syrup, jelly and candy. I photographed these, painted a painting, then made prickly pear jelly!  Fun! Ask me for the recipe. \r\n<br><br>\r\nOil on canvas <br>24x24 Gallery wrap<BR>$1,100',0.00,50,0,NULL),(54,'Window in Provence France','0','Window in Provence France\r\n<br>\r\n16 x 20 Oil on Canvas Gallery Wrap',NULL,NULL,1,1,'','',800.00,'','','Window_in_Provence_640.jpg','',0.0000,1,1,'In our travels in Provence, France, decorated windows are part of their summer.  This one was so colorful and interesting that it made an great subject for my canvas.<BR><BR>Oil on canvas <BR>16x20 Gallery Wrap<BR>$800',0.00,54,0,NULL),(55,'Pots of the Southwest','0','Three Pots \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n24 x 24 gallery wrap',NULL,NULL,1,1,'','',1100.00,'','','FoundPots_640.jpg','',0.0000,1,1,'Three Pots \r\n<br><br>\r\nThe lore of the southwest is about Indians and what they left behind.  These are replicas of Indian pots that I found in Carefree at the Town Dump. It really is not a dump but a  place to see old time stuff that looks like what the Indians left behind. \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n24x24 Gallery wrap<BR>$1,100',0.00,55,0,NULL),(56,'Mary\'s Daffadils','0','Mary\'s Daffadils',NULL,NULL,1,1,'','',0.00,'','','MarysDaffidils_640.jpg','',0.0000,1,1,'',0.00,56,0,NULL),(57,'','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,57,0,NULL),(60,'Sunflowers II','0','Oil on Canvas<br>\r\n12 x 16 framed',NULL,NULL,1,1,'','',600.00,'','','SunflowersII_640.jpg','',0.0000,1,1,'Sunflowers make such a big statement in a painting...these are fun and sassy. I grew them in my yard and they were over 6 feet tall.<BR><BR>\r\nOil on Canvas<br>\r\n12 x 16 framed<BR>\r\n$600',0.00,60,0,NULL),(93,'A Great Pot from the Town Dump','0','12 x 12 <BR> Gallery Wrap Oil on Canvas ',NULL,NULL,1,1,'','',200.00,'','','PotFromDump_640.jpg','',0.0000,1,1,'The Southwest has many wonderful places to find history <BR><BR>Oil on Canvas<BR>12x12 Gallery Wrap <BR>$200',0.00,94,0,NULL),(89,'Modern Bo Peep','0','',NULL,NULL,1,1,'','',0.00,'','','Modern_Bo_Peep.jpg','',0.0000,1,1,'',0.00,90,0,NULL),(62,'La Jolla Window','0','La Jolla Window <br>\r\n20 x 24 framed oil on canvas ',NULL,NULL,1,1,'','',0.00,'','','LaJollaWindow_640.jpg','',0.0000,1,1,'This is La Jolla\r\n<br><br>\r\nOn a recent trip to California we visited the beautiful land of La Jolla.  This is the window for Tommy Bahama’s clothing store. The day was beautiful and the clouds floated by and created a challenge for me to capture on canvas. This painting is beautifully framed in an elegant frame. \r\n<br><br>\r\nOil on canvas<p>\r\n18x24  framed',0.00,62,0,NULL),(63,'Pot of Geraniums','0','It’s a great pot of Geraniums\r\n<br><br>\r\nOil on canvas<br>\r\n16 x 20 framed ',NULL,NULL,1,1,'','',500.00,'','','PotOfGer_640.jpg','',0.0000,1,1,'It’s a great pot of Geraniums\r\n<br><br>\r\nGeraniums are a confirmation that all is well with the world because of their bright colors.  A group of us decided to paint with lots of color.  We put this bunch of geraniums in a pot and had fun using the brightest colors we could find in our paint box. \r\n<br><br>\r\nOil on canvas<br>\r\n16 x 20 framed<BR>\r\n$500',0.00,63,0,NULL),(95,'Bouganvia at the Posada Carmina','0','18 x 24<BR> Framed oil on canvas ',NULL,NULL,1,1,'','',900.00,'','','PosadaCarmina_640.jpg','',0.0000,1,1,'Posada Carmina is a beautiful boutique hotel in San Miguel de Alllende\r\nwhere a beautif HUGE fuscia bouganvia\r\ngrows right in the center.  Lovely to look at and lovely to paint.\r\n<BR><BR>Oil on canvas <BR>18x24 framed <BR>$900',0.00,96,0,NULL),(98,'Rush Ranch Family Home','0','18 x 24 <BR> Framed oil on canvas ',NULL,NULL,1,1,'','',1100.00,'','','RushRanchFamilyHome_640.jpg','',0.0000,1,1,'This old house must have many memories!  It is in Prescott Valley Az where the Rush family and the Fain family raised cattle in the l800\'s until approximately the 1950\'s.  History lives...but for how long?   <BR><BR>Oil on canvas<BR>18x24 framed <BR>$1,100',0.00,89,0,NULL),(96,'Old Barn on Rush Ranch','0','16 x 20<BR> Framed Oil on Canvas ',NULL,NULL,1,1,'','',500.00,'','','RushRanchBarn_640.jpg','',0.0000,1,1,'This old barn is found in Prescott Valley at the forgotten Rush Ranch.\r\nThis area is full of wonderful history and lends itself to fun painting. <BR><BR>Oil on Canvas <BR>16x20 framed <BR>$500',0.00,98,0,NULL),(67,'Canna Lilies on Coronado Island','0','Canna Lilies on Coronado Island\r\n8\"x 12\" wrap canvas ',NULL,NULL,1,1,'','',75.00,'','','Cannas_640.jpg','',0.0000,1,1,'These Lilies grow to an elegant height of six to seven feet and the color is very intensive.  In fact, it is difficult to get the color from a tube that describes the brilliance in real life. \r\n',0.00,67,0,NULL),(68,'Window on Camelback','0','Window on Camelback<br><br>\r\n16 x 20 framed ',NULL,NULL,1,1,'','',600.00,'','','WindowCamelback_640.jpg','',0.0000,1,1,'This window belongs to a building as you drive east on Camelback to Scottsdale.  The bright color of the building contrasts the cactus and makes interesting viewing.  This particular day, the late afternoon sun was sparkling.<BR><BR>Oil on canvas<BR>16x20 framed<BR>$600',0.00,68,0,NULL),(69,'Farmer\'s Market Flowers','0','Bouquet from the farmer’s market\r\n<br><br>\r\nOil on canvas\r\n<br>\r\n16 x 20 framed',NULL,NULL,1,1,'','',900.00,'','','FarmersMarketFlowers_640.jpg','',0.0000,1,1,'Bouquet from the farmer’s market\r\n<br><br>\r\nDowntown Phoenix has a farmer’s market on Central Avenue.  I found this bouquet of flowers from the Farm at South Mountain and brought them home.  I tossed them on the table and looked for a vase…then decided to paint them just the way they landed…next to the vase. \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n16 x 20 framed<BR>\r\n$900',0.00,69,0,NULL),(71,'Forgotten Rush Ranch','0','Forgotten Rush Ranch \r\n<br><br>\r\nOil on canvas…\r\n<br>\r\n12x24 framed',NULL,NULL,1,1,'','',1000.00,'','','RushRanch_640.jpg','',0.0000,1,1,'Lonesome Valley which is now Prescott Valley was settled by Ranchers in the mid 1800’s.This beautiful valley is surrounded by mountains and grass lands.  One early morning the sun was highlighting the old crumbling buildings that were the Rush Ranch.  Now it is forgotten and Stone Ridge homes surround the Ranch. \r\n<br><br>\r\nOil on canvas\r\n<br>\r\n12x24 framed<BR>$1,000',0.00,71,0,NULL),(94,'Little Boys Love the Beach','0','5 x 7 oil<BR>Framed oil on canvas',NULL,NULL,1,1,'','',95.00,'','','CoronadoBeach_640.jpg','',0.0000,1,1,'Children are wonderful to watch at the beach. \r\n<BR><BR>Oil on canvas\r\n<BR>5x7 framed <BR>$95',0.00,95,0,NULL),(72,'Three Pears','0','Oil on canvas<br>\r\n8 x 10 Framed',NULL,NULL,1,1,'','',0.00,'','','Pears3_640.jpg','',0.0000,1,1,'Pears are such an interesting fruit. Just look at their shape…Look at their cute fat bottoms and their carefree stems!  And the color changes within hours as they ripen.  Besides all that fun, they tasted wonderful. \r\n<br><br>\r\nOil on canvas\r\n<br>8 x 10 Framed',0.00,72,0,NULL),(73,'Greg’s early spring peaches','0','Oil on canvas\r\n<br>8 x 10 framed',NULL,NULL,1,1,'','',0.00,'','','GregPeaches_640.jpg','',0.0000,1,1,'These are the best tasting peaches from son Greg’s Urban Farm.  We ate till we couldn’t eat anymore.  They were so abundant this spring, I made peach jam for us and plenty of jam to give away. Here’s my fun painting of the event in a fabulous frame. \r\n<br><br>\r\nOil on canvas\r\n<br>8 x 10 framed',0.00,73,0,NULL),(74,'The man with the <BR>“Shady Ladies”','0','Oil on canvas\r\n<br>12 x 16',NULL,NULL,1,1,'','',0.00,'','','ManShadyLadies_640.jpg','',0.0000,1,1,'Fein Lake in Prescott Valley holds a frontier days event with skits, historical events, food and fun. This actor wore buckskins, a gun and a persona of the drunk in the skit.  The part he played was great fun and he needed a rest…under a shady tree.  I told him he would be a great painting…and here it is… \r\n<br><br>\r\nOil on canvas\r\n<br>12 x 16',0.00,74,0,NULL),(75,'Country Window','0','Oil on canvas\r\n<br>16 x 20',NULL,NULL,1,1,'','',900.00,'','','CountryWindow_640.jpg','',0.0000,1,1,'Country homes have interesting windows. This window reminded me of my old home in British Columbia.  Mother always had a geranium in the window and big fluffy curtains that reminded her of Slovakia. Europe has very beautiful windows and this reminded me of my heritage. \r\n<br><br>\r\nOil on canvas\r\n<br>16x20 framed<BR>$900',0.00,75,0,NULL),(76,'Six pounds of Sunflowers!','0','Oil on board  \r\n<br>\r\n12 x 16  framed',NULL,NULL,1,1,'','',500.00,'','','SunFlower6pound_640.jpg','',0.0000,1,1,'Sunflowers grow wild in the Prescott area and this one grew in our back yard.  However we planted the seed and this particular plant loved its place in the sun and grew and grew. We finally had to stake it to get it to six pounds. Son Jeff is roasting the seeds for a home-grown treat.  \r\n<br><br>\r\nOil on board  \r\n<br>\r\n12x16 framed<BR>$500',0.00,76,0,NULL),(77,'Waiting for Rain','0','36 x 48 Gallery Wrap <BR>\r\nOil on canvas ',NULL,NULL,1,1,'','',1800.00,'','','WaitingForRain_640.jpg','',0.0000,1,1,'Waiting for Rain \r\n<br><br>\r\nKids love umbrellas and playing in the rain.  Big sister is taking little brother for  a walk and hoping for a down pour.<BR><BR>\r\nOil on canvas <BR>36x48 Gallery Wrap <BR>$1,800',0.00,77,0,NULL),(92,'Broomsticks and Baskets','0','30 x 48 <BR>\r\nGalery Wrap Oil on canvas ',NULL,NULL,1,1,'','',1200.00,'','','Brooms__Baskets_640.jpg','',0.0000,1,1,'This closet of brooms and baskets was for sale in San Miguel de Allende.<BR><BR>Oil on canvas <BR>30x48 Galery Wrap <BR>$1,200',0.00,93,0,NULL),(78,'Autumn in the Aspens','0','8 x 10  framed <br>\r\nOil on canvas',NULL,NULL,1,1,'','',225.00,'','','AutumnInTheAspens_640.jpg','',0.0000,1,1,'Aspens in the Arizona north country is a wonderful sight to see.  The colors are very bright and the weather is crisp and beautiful.\r\n<BR><BR>\r\nOil on canvas<BR>\r\n8x10 framed<BR>\r\n$200',0.00,78,0,NULL),(79,'UrbanFarm.org','0','12 x 24 gallery wrap <br>\r\nOil on canvas',NULL,NULL,1,1,'','',0.00,'','','UrbanFarmOrg_640.jpg','',0.0000,1,1,'This is a recycled windmill that lives at the Urban Farm in central Phoenix.  It adds a country feel to the little farm that grows lots of organic foods. ',0.00,79,0,NULL),(80,'Lunch Break','0','16 x 20 framed <br>\r\nOil on canvas',NULL,NULL,1,1,'','',500.00,'','','LunchBreak_640.jpg','',0.0000,1,1,'Burros are so interesting and they perform so many tasks.  This burro hauls dirt for the many flower pots that the residents of San Miguel de Allende have around their homes.<BR><BR>Oil on canvas<BR>16x20 framed <BR>$500',0.00,80,0,NULL),(81,'Night Shade Bloom','0','10 x 12 framed <br>\r\nOil on canvas',NULL,NULL,1,1,'','',225.00,'','','NightShadeBloom_640.jpg','',0.0000,1,1,'Night Shade Bloom\r\n<br><br>\r\nThis is a flower that the old cowboys sang about…the loco weed which grows in the high country of Arizona.  The story says that the cattle would it this plant and get goofy.  It sure is a beautiful blossom.<BR><BR>\r\n10 x 12 framed <br>\r\nOil on canvas<BR>\r\n$225',0.00,81,0,NULL),(82,'SAS Flowers','0','12 x 12 gallery wrap <br>\r\nOil on canvas',NULL,NULL,1,1,'','',0.00,'','','SASflowers_640.jpg','',0.0000,1,1,'SAS Flowers\r\n<br><br>\r\nThis beautiful vase with flowers was the center piece of a table at a great event at the Scottsdale Artists School.  It made a wonderful subject for a still life.',0.00,82,0,NULL),(84,'St Michael’s Bridge','0','12 x 24 Framed <br>\r\nOil on canvas \r\n',NULL,NULL,1,1,'','',0.00,'','','StMichaelsBridgeBratislava_640.jpg','',0.0000,1,1,'St Michael’s Bridge\r\n<br><br>\r\nThis beautiful setting is in Bratislava, Slovakia. St Michael’s Bridge is in the old town where many ladies sell their tablecloths and embroidery.  This area is for walkers and diners.  This time of day created a very interesting subject. \r\n',0.00,84,0,NULL),(85,'Remember The Calliope','0','18 x 24 framed <br>\r\nOil on canvas',NULL,NULL,1,1,'','',1100.00,'','','CaliopeManInProvence_640.jpg','',0.0000,1,1,'This is the Calliope Man in Provence, France.  This interesting set up was seen under a bridge waiting for tourists to put money in his box.  The only thing that was missing was a monkey…however he had all the characters in doll form on his calliope.  A very interesting scene.<BR><BR>Oil on canvas<BR>18x24 framed <BR>$1,100',0.00,85,0,NULL),(86,'Window in San Miguel <BR>de Allende','0','16 x 20 framed <br>\r\nOil on canvas \r\n',NULL,NULL,1,1,'','',500.00,'','','WindowInSanMiguel_640.jpg','',0.0000,1,1,'The residents of San Miguel know how to do their windows.  It is a wonderful sight to walk down the street and see these beautiful windows full of flowers.<BR><BR>Oil on canvas <BR>16x20 framed <BR>$500',0.00,86,0,NULL),(87,'Out of the Shadows','0','12 x 16 framed <br>\r\nOil on Canvas',NULL,NULL,1,1,'','',0.00,'','','OutOfTheShadows_640.jpg','',0.0000,1,1,'Out of the Shadows \r\n<br><br>\r\nThis painting was inspired by an article in our newspaper that told of a fourteen year old school girl in Afghanistan who had acid thrown in her face because she went to school.  From her hospital bed she vowed that she would continue to go to school even if they did it again.  She is coming out of the shadows in spite of the culture.  \r\n',0.00,87,0,NULL),(90,'Path to Danube','0','16 x 20<BR>\r\nFramed Oil on canvas ',NULL,NULL,1,1,'','',900.00,'','','PathToDanube_640.jpg','',0.0000,1,1,'On a trip to Durenstein, Austria we found this charming path to the famous \r\nDanube River.  Note the vineyards on the other side of the river.<BR><BR>Oil on canvas <BR>16x20 framed <BR>$900',0.00,92,0,NULL),(99,'Silver Mums in mini frame','0','Oil on canvas <BR>\r\n5 x 7 Framed Mini<BR>',NULL,NULL,1,1,'','',95.00,'','','SilverMum_640.jpg','',0.0000,1,1,'Little flower paintings are great to put on a little easel, tuck in corners for extra decorating charm. <BR><BR>\r\nOil on canvas <BR>\r\n5 x 7 Framed Mini<BR>\r\n$95',0.00,99,0,NULL),(100,'Silver Rose','0','5 x 7 <BR> Framed Oil on Canvas <BR><BR>',NULL,NULL,1,1,'','',95.00,'','','SilverRose_640.jpg','',0.0000,1,1,'Framed in a mini silver frame, this charming rose can fit anywhere...<BR><BR>Oil on Canvas<BR>5 x 7 Framed <BR>$95',0.00,100,0,NULL),(101,'Sweet Bosc Pear','0','5 x 7 <BR> Framed Oil on canvas',NULL,NULL,1,1,'','',95.00,'','','SweetPear_640.jpg','',0.0000,1,1,'A juicy pear for your kitchen.  Pears reflect wondrous light and have cute bottoms.<BR><BR>Oil on canvas<BR>5x7 framed <BR>$95',0.00,101,0,NULL),(102,'Three Bras','0','16 x 20 <BR> Framed Oil on Canvas ',NULL,NULL,1,1,'','',1100.00,'','','ThreeBras_640.jpg','',0.0000,1,1,' This charming window was seen in Provence, France on one of my trips.  The French countryside uses all it\'s resources wisely...who needs a dryer when you have a window that\'s handy.<BR><BR>Oil on canvas<BR>16x20 framed <BR>$1,100',0.00,102,0,NULL),(103,'Three Roses','0','12 x 24<BR> Framed Oil on Canvas ',NULL,NULL,1,1,'','',500.00,'','','ThreeRoses_640.jpg','',0.0000,1,1,'Ah...a friend brought me these three roses...so I painted them to hold the memory...',0.00,103,0,NULL),(104,'Reading at the Top of the World','0','8 x 10<BR> Framed Oil on Canvas ',NULL,NULL,1,1,'','',125.00,'','','ReadingTopWorld_640.jpg','',0.0000,1,1,'This Charming little girl loves to read...by herself...on top of the hill.<BR><BR>\r\nOil on canvas <BR>8x10 framed<BR>$125',0.00,104,0,NULL),(106,'Commercial Work','0','Blue Agave Label<center>null</center>',NULL,NULL,1,1,'','',0.00,'','','BlueAgave640.jpg','',0.0000,1,1,'',0.00,106,0,NULL),(107,'Paintings for Commerical Use','0','Paintings for Commerical Use',NULL,NULL,1,1,'','',0.00,'','','FarmersMarketFlowers_640.jpg','',0.0000,1,1,'Paintings for Commerical Use',0.00,107,0,NULL),(108,'Aspen Trees','0','Short Description',NULL,NULL,1,1,'','',0.00,'','','Aspen_Katuba_640.jpg','',0.0000,1,1,'<center>In the Aspen Trees</center>',0.00,118,0,NULL),(109,'Mountain & Valley','0','Mountains & Valley',NULL,NULL,1,1,'','',0.00,'','','Mountain640.jpg','',0.0000,1,1,'',0.00,108,0,NULL),(110,'Aspen','0','Short Aspen & Path',NULL,NULL,1,1,'','',0.00,'','','Aspen.jpg','',0.0000,1,1,'Long Description',0.00,120,0,NULL),(111,'Cactus & Tree','0','Cactus & Tree',NULL,NULL,1,1,'','',0.00,'','','Cactus___Tree.jpg','',0.0000,1,1,'',0.00,119,0,NULL),(112,'Pond & Meadow','0','Pond & Meadow',NULL,NULL,1,1,'','',0.00,'','','Pond640.jpg','',0.0000,1,1,'',0.00,109,0,NULL),(113,'Desert Valley','0','Desert Valley',NULL,NULL,1,1,'','',0.00,'','','DesertValley640.jpg','',0.0000,1,1,'',0.00,110,0,NULL),(115,'Maple Tree','0','',NULL,NULL,1,1,'','',0.00,'','','Maple_Tree.JPG','',0.0000,1,1,'Maple Tree',0.00,113,0,NULL),(116,'Indian Blanket','0','',NULL,NULL,1,1,'','',0.00,'','','Indian_Blanket.jpg','',0.0000,1,1,'Indian Blanket',0.00,111,0,NULL),(117,'Camelback Mountain','0','',NULL,NULL,1,1,'','',0.00,'','','Camelback_Mountain.JPG','',0.0000,1,1,'Camelback Mountain',0.00,112,0,NULL),(118,'Desert Morning','0','',NULL,NULL,1,1,'','',0.00,'','','Desert_Morning.jpg','',0.0000,1,1,'Desert Morning',0.00,116,0,NULL),(119,'Penn Waterfall','0','',NULL,NULL,1,1,'','',0.00,'','','PA_Waterfall.jpg','',0.0000,1,1,'Penn Waterfall',0.00,117,0,NULL),(120,'Desert Cliffs','0','',NULL,NULL,1,1,'','',0.00,'','','Desert_Cliffs.jpg','',0.0000,1,1,'Desert Cliffs',0.00,115,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 'bozenka'
--

--
-- Dumping routines for database 'bozenka'
--


