--
-- Host: localhost    Database: terrianndavis
-- ------------------------------------------------------


--
-- 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,
  `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=12 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Category` VALUES (1,0,0,0,2,NULL,'Top Level',NULL,1),(2,0,1,7,3,NULL,'Dinnerware','',2),(3,0,1,4,0,NULL,'Platters','',3),(4,0,1,5,0,NULL,'Plates','',4),(5,0,1,6,0,NULL,'Bowls','',5),(6,0,1,0,0,NULL,'Mugs and Cups','',6),(7,0,1,8,0,NULL,'Kitchen Accessories','',7),(8,0,1,9,0,NULL,'Bath Accessories','',8),(9,0,1,10,0,NULL,'Vases and Pots','',9),(10,0,1,11,0,NULL,'Boxes','',10),(11,0,1,0,0,NULL,'Miscellaneous','',11);

--
-- 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=43 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Inventory` VALUES (1,1,3),(2,2,3),(3,3,4),(4,4,4),(5,5,4),(6,6,5),(7,7,5),(8,8,5),(9,9,7),(10,10,7),(11,11,7),(12,12,7),(13,13,8),(14,14,9),(15,15,9),(16,16,9),(17,17,10),(18,18,10),(19,19,11),(20,20,11),(21,21,11),(22,22,11),(23,23,11),(32,24,6),(29,25,6),(30,26,6),(31,27,6),(38,28,12),(39,29,12),(40,30,12),(36,31,12),(37,32,12),(41,33,12),(42,34,4);

--
-- 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` tinyblob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- 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=5 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Page` VALUES (1,'Terri Ann Davis Designs are original works inspired by Terri\'s love of the Sonoran desert in Cave Creek, Arizona, known for it\'s majestic saguaro cacti and high desert vistas.  The enchantment and panorama of Sedona; Arizona\'s red rock country also lend to Terri\'s inspiration.  Her carefree southwestern designs include desert flora in bloom such as saguaro, ocotillo, agave, prickly pear and barrel cacti. Terri is also known for her happy horses, jumping jackrabbits and Sedona scenes.  Her ceramic art pieces, dinnerware and  crosses are created by hand by either a slip casting technique or hand built. Each piece is hand painted and signed at her Cave Creek studio. After glazing and kiln firing a one of a kind functional piece of whimsical art is produced.\r\n\r\n<P>Terri\'s ceramic collection is all non-toxic and safe for use in the microwave. Hand washing is recommended.<BR>\r\n<P>\r\n<P>Be sure to visit the <B>de la luz interior enhancements</B> page and see the faux finishes and textures applied to lamps, shades and home accessories.',2,0,'TADHMPG.jpg','Click an item to go to that page.','1,25,19,33,5,8,32,11','Terri Ann Davis<br>Designs',NULL,NULL),(2,'Ordering:\r\n<P>Due to the individuality of Terri\'s pieces the arrangement of designs vary from piece to piece. If you would like a specific arrangement of color, characters, etc. just specify when ordering.\r\n<P>\r\n<P>Design Variations:\r\n<P>\r\n<P>Border Colors: no border, red, yellow, yellow-orange, turquoise, rose, green or black & white.\r\n<P>\r\n<P>Themes: Sonoran Flora day or night, Sedona flora day or night, horses(specify colors), jackrabbit or Ponderosa pines.\r\n<P>\r\n<P>Delivery time is usually two to six weeks.\r\n<P>\r\n<P>Ask about other pieces not shown on the site.\r\n<P>\r\n<P>Enjoy the beauty of the Sonoran Desert\r\nwith a custom Terri Ann Davis design crafted just for you.',1,1,'8plate.jpg',NULL,NULL,'Ordering & Design Variations','Odering & Design Variations',NULL),(4,'<P><H1>USE AGREEMENT</H1><BR>\r\n<BR>\r\n<P>The artwork and photos throughout the pages of this Web site may not be copied or otherwise reproduced without the express written permission of <B>Terri Ann Davis Designs</B>.<BR>\r\n<P><B>Terri Ann Davis Designs</B> is a registered trade name and all artwork is protected by copyright laws.',1,1,'',NULL,NULL,'Terri Ann Davis Designs','Use Agreement',NULL);

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

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) 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` varchar(255) DEFAULT NULL,
  `list2` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `prices` varchar(255) DEFAULT NULL,
  `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=35 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Product` VALUES (1,'9 1/2\" Square Platter','0','This square platter looks beautiful in a plate stand or laying flat.  It\'s edges slightly  slope upward.',NULL,NULL,1,1,'','',72.00,'','','9square.jpg','',2.0000,1,1,'This square platter looks beautiful in a plate stand or laying flat.  It\'s edges slightly  slope upward.',0.00,1,NULL,NULL),(2,'14\" Oval Platter','0','This platter is 14\" long, 10 1/2\" wide and 2\" deep.  Perfect for serving family dish or to adorn your kitchen or dinning room.',NULL,NULL,1,1,'','',150.00,'','','14oval~1.jpg','',6.0000,1,1,'This platter is 14\" long, 10 1/2\" wide and 2\" deep.  Perfect for serving family dish or to adorn your kitchen or dinning room.',0.00,2,NULL,NULL),(3,'8\" plate','0','A great size for salad or bread.',NULL,NULL,1,1,'','',48.00,'','','8plate.jpg','',0.5000,1,1,'A great size for salad or bread.  ',0.00,3,NULL,NULL),(4,'6\" Plate','0','Perfect size for use as a saucer, dessert plate or just as a catch all for your kitchen counter.  Available with no border or B/W checked, yellow or rose borders.',NULL,NULL,1,1,'','',42.00,'','','6plate.jpg','',0.5000,1,1,'Perfect size for use as a saucer, dessert plate or just as a catch all for your kitchen counter.  Available with no border or B/W checked, yellow or rose borders.',0.00,4,NULL,NULL),(5,'Large Heart Plate','0','Serve a special snack to a cherished friend then hang this 10 1/2\" X 10\" symbol of love on the wall to remind you of time shared together.',NULL,NULL,1,1,'','',69.00,'','','lgheartp.jpg','',1.5000,1,1,'Serve a special snack to a cherished friend then hang this 10 1/2\" X 10\" symbol of love on the wall to remind you of time shared together.  ',0.00,5,NULL,NULL),(6,'Flutted Bowl','0','This delicately fluted bowl is available with rose or yellow outside and border colors.',NULL,NULL,1,1,'','',74.00,'','','flutdbol.jpg','',3.0000,1,1,'This delicately fluted bowl is available with rose or yellow outside and border colors.  ',0.00,6,NULL,NULL),(7,'Large Pasta Bowl','0','This 13\" X 3\" bowl is the perfect size for serving that big family size pasta dinner.  Also, use it as a  display piece in a stand or just sitting out on a counter top or table.',NULL,NULL,1,1,'','',150.00,'','','lgbowl.jpg','',6.0000,1,1,'This 13\" X 3\" bowl is the perfect size for serving that big family size pasta dinner.  Also, use it as a  display piece in a stand or just sitting out on a counter top or table.',0.00,7,NULL,NULL),(8,'Medium Pasta Bowl','0','10 1/2\" in diameter and 2 1/4\" deep this bowl work nicely to serve a dinner for 2.  Purchase one of our decorative wrought iron stands and display it while not in use.',NULL,NULL,1,1,'','',74.00,'','','medpas~1.jpg','',3.0000,1,1,'10 1/2\" in diameter and 2 1/4\" deep this bowl work nicely to serve a dinner for 2.  Purchase one of our decorative wrought iron stands and display it while not in use.',0.00,8,NULL,NULL),(9,'Butter Dish','0','Butter tray with cover.  Order with either a black and white check around the tray and a spiral on the handle or a brown tray with a bird on handle.\r\n',NULL,NULL,1,1,'','',56.00,'','','buterdsh.jpg','',1.0000,1,1,'Butter tray with cover.  Order with either a black and white check around the tray and a spiral on the handle or a brown tray with a bird on handle.\r\n',0.00,9,NULL,NULL),(10,'Cookie Jar','0','This pot belly shaped jar will surely add a fun attitude to any kitchen counter.  Order with either desert flora, a jackrabbit or 4 colorful ponies.',NULL,NULL,1,1,'','',130.00,'','','cookie2.jpg','',4.0000,1,1,'This pot belly shaped jar will surely add a fun attitude to any kitchen counter.  Order with either desert flora, a jackrabbit or 4 colorful ponies. ',0.00,10,NULL,NULL),(11,'Tea Pot','0','Give a southwest charm to a special tea party or enjoy as an addition to your tea pot collection.  Available with yellow or rose spout, handle and lid, or no trim color.',NULL,NULL,1,1,'','',130.00,'','','teapot2.jpg','',4.0000,1,1,'Give a southwest charm to a special tea party or enjoy as an addition to your tea pot collection.  Available with yellow or rose spout, handle and lid, or no trim color.',0.00,11,NULL,NULL),(12,'Napkin holder','0','Keep those napkins handy while adding color and a cheer to your kitchen.  This 5 1/2\" X 6 1/2\" napkin holder is a great idea!',NULL,NULL,1,1,'','',56.00,'','','napkin~1.jpg','',4.0000,1,1,'Keep those napkins handy while adding color and a cheer to your kitchen.  This 5 1/2\" X 6 1/2\" napkin holder is a great idea!',0.00,12,NULL,NULL),(13,'Tissue Box Cover','0','Fits perfectly over your cube shaped box of tissues.',NULL,NULL,1,1,'','',72.00,'','','tissue.jpg','',2.0000,1,1,'Fits perfectly over your cube shaped box of tissues.',0.00,13,NULL,NULL),(14,'6 1/4\" Vase','0','The classic lines of the 6 1/4\" tall vase are available with desert flora  with or without a pony.',NULL,NULL,1,1,'','',68.00,'','','614vase.jpg','',2.0000,1,1,'The classic lines of the 6 1/4\" tall vase are available with desert flora  with or without a pony.',0.00,14,NULL,NULL),(15,'Bud Vase','0','Approximately 7\" tall.',NULL,NULL,1,1,'','',58.00,'','','budvas.jpg','',1.0000,1,1,'Approximately 7\" tall. ',0.00,15,NULL,NULL),(16,'Tiny Jug','0','Only about 4\" tall, this cute little jug can hold a flower or just be enjoyed by itself.',NULL,NULL,1,1,'','',42.00,'','','tinyjug.jpg','',0.7500,1,1,'Only about 4\" tall, this cute little jug can hold a flower or just be enjoyed by itself.',0.00,16,NULL,NULL),(17,'Large Round Box','0','Young or old; anyone would enjoy this 5 3/4\" X 2 7/8\" box.  Use it as a catch all for change and stuff or for your special treasures.  Available with or without B&W trim.',NULL,NULL,1,1,'','',59.00,'','','lgrndbx.jpg','',0.7500,1,1,'Young or old; anyone would enjoy this 5 3/4\" X 2 7/8\" box.  Use it as a catch all for change and stuff or for your special treasures.  Available with or without B&W trim.',0.00,17,NULL,NULL),(18,'Assorted Tiny Boxes','0','Whether it be round, rectangle or heart shaped these 2 1/2\" boxes are just precious.  Surprise someone and put a ring or a chocolate kiss inside.',NULL,NULL,1,1,'','',32.00,'','','tnyboxs.jpg','',0.0000,1,1,'Whether it be round, rectangle or heart shaped these 2 1/2\" boxes are just precious.  Surprise someone and put a ring or a chocolate kiss inside.  ',0.00,18,NULL,NULL),(19,'Ceramic cross','0','About 6\" tall.',NULL,NULL,1,1,'','',49.00,'','','cross9.jpg','',1.0000,1,1,'About 6\" tall. ',0.00,19,NULL,NULL),(20,'Custom house tile','0','Have your house numbers, street address or family name placed on your personal house tile.  Can be mounted on a door or wall.',NULL,NULL,1,1,'','',96.00,'','','houstile.jpg','',3.0000,1,1,'Have your house numbers, street address or family name placed on your personal house tile.  Can be mounted on a door or wall.',0.00,20,NULL,NULL),(21,'8\" Tile','0','This tile can be purchased with or without a hanger on the back.  It can be used as a trivet or a wall decoration.  B&W, yellow and pink borders avaiable or no border.',NULL,NULL,1,1,'','',51.00,'','','8tile.jpg','',1.0000,1,1,'This tile can be purchased with or without a hanger on the back.  It can be used as a trivet or a wall decoration.  B&W, yellow and pink borders avaiable or no border.',0.00,21,NULL,NULL),(22,'Piggy Bank','0','5 1/2\" tall and 6\" long this happy little piggy just wants to devour all your change.  Comes with a rubber stopper.',NULL,NULL,1,1,'','',62.00,'','','pigbank.jpg','',1.0000,1,1,'5 1/2\" tall and 6\" long this happy little piggy just wants to devour all your change.  Comes with a rubber stopper. ',0.00,22,NULL,NULL),(23,'Tiny Birdhouse','0','Only about 5\" tall, this little collectable will brighten any window sill.',NULL,NULL,1,1,'','',52.00,'','','brdhous.jpg','',0.5000,1,1,'Only about 5\" tall, this little collectable will brighten any window sill.',0.00,23,NULL,NULL),(24,'Standard Mug','0','Standard Mug',NULL,NULL,1,1,'','',44.00,'','','mugstd.jpg','',0.0000,1,1,'Enjoy a Sonoran sunrise with a hot cup of your favorite coffee or tea in this mug.',0.00,24,NULL,NULL),(25,'Cappuccino cup & Saucer','0','Cappuccino Cup & Saucer',NULL,NULL,1,1,'','',58.00,'','','cupcpcnscr.jpg','',0.0000,1,1,'This desert scene will go well with your dessert and a hot cappuccino.',0.00,25,NULL,NULL),(26,'Small Tumbler','0','Small Tumbler',NULL,NULL,1,0,'','',48.00,'','','tumblrsm.jpg','',0.0000,1,1,'A cheerful cup for a cold lemonade or an iced coffee. Even the horses jump for joy.',0.00,26,NULL,NULL),(27,'Tall Tumbler - 7 3/4\"','0','Tall Tumbler -7 3/4\"',NULL,NULL,1,0,'','',70.00,'','','tumblrtall.jpg','',0.0000,1,1,'A hot desert thrist could be quenched with this tumbler. Even the saguaro is taller and greener on this one. ',0.00,27,NULL,NULL),(28,'Pitchers - click to enlarge','0','We have an assortment of different pitchers each with it\'s own distict finish',NULL,NULL,0,1,'','',0.00,'','','Page_3_pitchers.jpg','',0.0000,1,1,'',0.00,28,NULL,NULL),(29,'Animals - click to enlarge','0','From  barnyard to backyard you\'ll find your favorite creature for your comfort.',NULL,NULL,0,1,'','',0.00,'','','Animals.jpg','',0.0000,1,1,'',0.00,29,NULL,NULL),(30,'Vases & Pots - click to enlarge','0','There are many pots and vases in all shapes and sizes.',NULL,NULL,0,1,'','',0.00,'','','Vases_and_Pots.jpg','',0.0000,1,1,'',0.00,30,NULL,NULL),(31,'Accent Lamps and Shades','0','Try a hand painted and textured accent lamp and shade to give that special space an original flare.',NULL,NULL,1,0,'','',0.00,'','','3_mini__lamps.jpg','',0.0000,1,1,'',0.00,31,NULL,NULL),(32,'Small , Medium and Large Heart Boxes','0','These deligntful boxes have many uses; jewelry, potpourri or a sented candle.',NULL,NULL,1,1,'','',0.00,'','','Sm_Med_Lg_Heart_Boxes.jpg','',0.0000,1,1,'',0.00,32,NULL,NULL),(33,'Lamps & Shades','0','One of a kind lamps and shades designed to bring light and enchance the beauty of your home.',NULL,NULL,1,1,'','',0.00,'','','lamps.jpg','',0.0000,1,1,'',0.00,33,NULL,NULL),(34,'10\", 8','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,34,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',
  `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',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- 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(5) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

--
-- 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 PACK_KEYS=1;

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


--
-- Dumping events for database 'terrianndavis'
--

--
-- Dumping routines for database 'terrianndavis'
--


