--
-- Host: localhost    Database: desertdog
-- ------------------------------------------------------


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

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

INSERT INTO `Category` VALUES (1,0,0,0,3,NULL,NULL,'Top Level',NULL,0),(3,0,4,4,18,'A New Spin On Birdhouses.',NULL,'<font size=3><u><b>Story Houses</b></u></font>','Heaven-front.jpg',0),(4,0,6,5,23,'Rustic Metal Designs ',NULL,'<font size=3><u><b>Metal Art</b></u></font>','small_birdhouse.jpg',0),(9,0,5,10,0,'',NULL,'Wildlife','',0),(5,0,5,6,8,'',NULL,'<font size=3><u><b>Photography</b></u></font>','Pensive_Baby_Blues.jpg',0),(6,0,5,7,13,'',NULL,'<font size=3><u><b>Handmade Jewelry</b></u></font>','',0),(8,0,5,9,0,'',NULL,'Landscapes','',0),(7,0,5,29,11,'',NULL,'<font size=3><u><b>Artsy Adirondacks</b></u></font','Red___Cinnamon.jpg',0),(10,0,5,0,0,'',NULL,'Pets','',0),(11,0,5,12,0,'',NULL,'Funky','',0),(12,0,5,20,0,'For The Purists',NULL,'Organic','',0),(13,0,5,14,0,'',NULL,'Bracelets','',0),(14,0,5,15,0,'',NULL,'Earrings','',0),(15,0,5,16,0,'',NULL,'Necklaces','',0),(16,0,5,17,0,'',NULL,'Sets','',0),(17,0,5,0,0,'',NULL,'Zipper Pulls','',0),(18,0,1,32,0,'A New Twist On Bird Houses. Each Story House Is An Original Work Of Art. Created Using Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <br> Custom Theme Orders Are Available.',NULL,'One-of-a-kind','Believe_copy.jpg',0),(19,0,4,22,0,'Commissioned Story Houses For Your Favorite Canine.',NULL,'Canine Designs','St_Bernard_Love.jpg',0),(20,0,5,21,0,'',NULL,'Monotone','',0),(21,0,5,0,0,'',NULL,'Rustic','',0),(22,0,5,0,0,'Where Art Meets A Country Garden.',NULL,'Story Shelves','single_shelf_shot.jpg',0),(23,0,5,24,0,'',NULL,'Garden Stakes','',0),(24,0,5,25,0,'',NULL,'Welcome Stakes','',0),(25,0,5,26,0,'',NULL,'Welcome Signs','',0),(26,0,5,27,0,'',NULL,'Lease Holders','',0),(27,0,5,31,28,'',NULL,'Wind Bells','',0),(28,0,5,0,0,'',NULL,'Bell Ornaments','',0),(29,0,5,0,0,'',NULL,'<font size=3><u><b>Frisky Finds</b></u></','',0),(31,0,4,0,0,'Rusted Metal Birdhouses Make A Perfect Compliment To Any Garden Or Yard.',NULL,'Garden Art','small_birdhouse.jpg',0),(32,0,4,19,0,'If You Have A Particular Theme In Mind Or If You Would Like To Have A Story House Personalized Please Email The Specifics Of Your Request To Us. <br> Due To The Creative Nature Of Art, Unfortunately Not All Requests Can Be Accepted.',NULL,'Commissions','Heaven-back.jpg',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=35 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (3,2,19),(28,3,18),(29,4,18),(20,5,18),(32,6,18),(30,7,18),(31,8,18),(34,9,22);

--
-- 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,'<center><B>Inside Our Gallery You\'ll Find:</b><p>Original Photography By:<br> <b>Artistic Imagery</b><BR><br>Metal Art With A Rustic Flair By:<br><b>Desert Dog Designs</b><br><BR>A New Spin On Birdhouses By:<br><b>Story House Designs</b><br><br>Handmade Jewelry By:<BR><b>Accidental Artist</b><br><br>Artsy Adironacks By:<br><b>D & D Designs</b><p><b><marquee><font color=\"yellow\">Watch For New Artisans & Products In The Future!</marquee></font>',3,0,'Trickster_plastic_wrap.jpg','','2','Desert Dog Gallery.com',NULL,NULL),(4,NULL,0,2,NULL,NULL,NULL,NULL,'<br><b>ABC Animal Rescue</b><br>','http://www.animalsbenefitclub.com'),(5,NULL,0,2,NULL,NULL,NULL,NULL,'<b>Southwest Wildlife</b>','http://www.southwestwildlife.org'),(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,'',''),(13,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(14,'<center>Here Are Just A Handful Of Organizations Whose Mission Is The Protection & Presevation Of Animal Kind.<br>Organizations Made Possible By Some Rather Extraordinary People.<br>People Who Give Selflessly, Tirelessly & Unconditionally To The Animals That Misfortune & Fortune Have Placed In Their Generous Hands.<p>Please Help If You Can. <br>Even Small Gestures Have Large Meaning.<br><br><b>Animals Benefit Club (602) 867-2169</b><br>www.animalsbenefitclub.com<br><br><b>Southwest Wildlife (480) 471-9109 <br></b>www.southwestwildlife.org</center><b><center>Arizona Covey (602) 996-1934</b></center><br><br><b><center>Fallen Feathers (623) 566-0155</b></center>',3,1,'',NULL,NULL,'Helping Paws','<b><br>HELPING PAWS</b>',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=10 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,1,NULL,NULL),(2,'Commissioned Work','0','<center>We Will Design A Special Story House In Honor Of Your Canine Family Member.</center>',NULL,NULL,1,1,'','',85.00,'','','St_Bernard_Love.jpg','',0.0000,1,1,'<center>Please allow 4-6 Weeks For Delivery.<br>If You Are Interested Please E-Mail For Specific Details.</center>',0.00,2,NULL,NULL),(3,'\"BELIEVE\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Believe_copy.jpg','',0.0000,1,1,'<center>\"BELIEVE\"<BR>From The Faith Series.<BR> This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,3,NULL,NULL),(4,'\"FRIENDSHIP\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Friendship-front.jpg','',0.0000,1,1,'<center>\"FRIENDSHIP\"<BR>This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,4,NULL,NULL),(5,'\"IMAGINE\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Imagine-front.jpg','',0.0000,1,1,'<center>\"IMAGINE\" <br>This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,5,NULL,NULL),(6,'\"SPRINGTIME\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Springtime-back.jpg','',0.0000,1,1,'<center>\"SPRINGTIME\"<BR>This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.</center>',0.00,6,NULL,NULL),(7,'\"SUMMERTIME\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Summertime-front.jpg','',0.0000,1,1,'<center>\"SUMMERTIME\"<BR>This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,7,NULL,NULL),(8,'\"HELPING HANDS\"','0','click on photo to enlarge',NULL,NULL,1,1,'','',75.00,'','','Helping_Hands-back.jpg','',0.0000,1,1,'<center>\"HELPING HANDS\"<BR>This Story House Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,8,NULL,NULL),(9,'\"CREATE\" Double Shelf Display','0','click on picture to enlarge',NULL,NULL,1,1,'','',275.00,'','','PICT0007.jpg','',0.0000,1,1,'<center>\"CREATE\"<BR>This Story House Display Shelf Is An Original Work Of Art That Has Been Created With A Combination Of Imagination, Arcylic Paint, Assorted Embellishments & Finished With A Gloss Sealer. <BR> Recommended For Indoor Display.',0.00,9,NULL,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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

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

INSERT INTO `Shopping` VALUES (1,3,1107303761,1,'','desertdog','');

--
-- Dumping events for database 'desertdog'
--

--
-- Dumping routines for database 'desertdog'
--


