--
-- Host: localhost    Database: dressedup
-- ------------------------------------------------------


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

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

INSERT INTO `Category` VALUES (1,0,0,0,2,NULL,NULL,'Top Level',NULL,0),(2,0,1,3,0,'',NULL,'ON TOP','',0),(3,0,1,4,0,'',NULL,'BOTTOMS UP','',0),(4,0,1,5,0,'',NULL,'FEELING FLIRTY','',0),(5,0,1,6,0,'',NULL,'BUCKLE MY SHOE','',0),(6,0,1,7,0,'',NULL,'STYLE ME PRETTY','',0),(7,0,1,8,0,'',NULL,'ON MY ARM','',0),(8,0,1,0,0,'',NULL,'LAST CHANCE','',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=159 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (132,72,4),(63,17,7),(26,5,7),(25,6,7),(130,70,4),(29,8,7),(107,34,8),(12,11,7),(30,12,7),(32,13,7),(158,79,2),(37,15,7),(38,16,7),(131,71,4),(27,19,7),(52,20,7),(129,21,7),(43,22,6),(44,23,6),(45,24,6),(46,25,6),(47,26,6),(49,28,6),(104,29,8),(105,30,8),(60,31,4),(59,32,4),(106,33,8),(151,35,2),(150,36,2),(152,37,2),(147,38,2),(149,39,2),(148,40,2),(141,41,2),(140,42,2),(137,77,4),(136,76,4),(154,45,2),(135,75,4),(139,78,3),(143,48,2),(144,49,2),(142,50,2),(134,74,2),(112,52,8),(91,53,2),(133,73,4),(145,55,2),(146,56,2),(110,59,6),(128,60,7),(127,61,7),(157,62,2),(156,63,2),(155,64,2),(120,65,6),(122,66,6),(123,67,7),(124,68,7),(125,69,3);

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

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

INSERT INTO `Page` VALUES (1,'         Welcome to Dressed Up Boutique.\r\n              \r\n         We are officially opening our webstore for shopping while we continue to add new inventory.  Please feel welcome to shop around and contact us with any questions or concerns. \r\n\r\n<P>Are you local and interested in hosting your own Dressed Up Boutique Party?  Email Rebecca for details and information regarding our hostess plan.\r\n\r\n<P>dressedupboutique@q.com<P>',2,0,'','','','',NULL,NULL),(2,'This is the about us page',5,1,'',NULL,NULL,'About Us','About Us',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) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=80 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (6,'Dancing in September-In Chocolate','JX30268','This hobo style is such a fun bag that moves from day to night without effort.  Start off carrying it to a casual afternoon movie and then let it dress you up for a night on the town.   ',NULL,NULL,1,1,'','',55.00,'','','dressedupboutiqueinventroy_077.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizers\r\n-Braided Handle\r\n-Drop Chain and Braid on Front\r\n-Leather',0.00,5,0),(5,'Dancing in September-In Red','JX30268','This bag is the perfect way to add a pop of color to any look.  There is no way to feel drab carrying this beauty.  Perfect for meeting friends for coffee and scones.',NULL,NULL,1,1,'','',55.00,'','','dressedupboutiqueinventroy_076.JPG','',0.0000,1,1,'-Back zippered pocket\r\n-2 Interior zippered pockets\r\n-2 organizers\r\n-Braided Handles\r\n-Drop chain and braid on front\r\n-Faux Leather',0.00,1,0),(8,'Just In Time For Love- In Buttercream','JX30265','This bag is the definition of style and function.  Wide mouth opening with a seamless design make this bag a winner.  Wear while window shopping in the city.',NULL,NULL,1,1,'','',50.00,'','','dressedupboutiqueinventroy_080.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Beautifully Lined\r\n-Leather\r\n-Imported',0.00,6,0),(71,'Summer Favorite-Tube Dress in Royal Blue','0','This is sure to be your summer favorite.  This tube style dress is perfect for day or evening.  Super comfortable material with great flow and construction.  Trust me, you will be wearing this dress often.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Medium, Large','','dressedupspring_008.JPG','',0.0000,1,1,'-100% Spandex\r\n-Bust is Lined\r\n-Hangs to the Knee\r\n-Braided Tie at High Waist\r\n-Fits True to Size (In My Opinion)\r\n-Machine or Hand Wash\r\n-Imported',0.00,73,0),(72,'Summer Favorite-Tube Dress in Magenta','0','This is sure to be your summer favorite.  This tube style dress is perfect for day or evening.  Super comfortable material with great flow and construction.  Trust me, you will be wearing this dress often.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Meduim, Large','','dressedupspring_005.JPG','',0.0000,1,1,'-100% Spandex\r\n-Bust is Lined\r\n-Hangs to the Knee\r\n-Braided Tie at High Waist\r\n-Fits True to Size (In My Opinion)\r\n-Machine or Hand Wash\r\n-Imported',0.00,74,0),(11,'Take Me Away-In Black','100422BC','Pack this bag for your next getaway to the city.  Lots of space inside for all of your goodies and more.  The hardware on the front dresses up any outfit and puts the finishing touch on your look.',NULL,NULL,1,1,'','',40.00,'','','dressedupboutiqueinventroy_092.JPG','',0.0000,1,1,'-Small Front Zippered Pocket\r\n-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Faux Leather\r\n-Beautifully Lined',0.00,11,0),(12,'Just In Time For Love-In Chocolate','JX30265','This shoulder bag is a stylish match for those needing a little exta room without missing out the style.    ',NULL,NULL,1,1,'','',50.00,'','','dressedupboutiqueinventroy_094.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Leather Exterior\r\n-Beautifully Lined\r\n-Leather',0.00,12,0),(13,'Meet Me In Central Park-In Camel','A-293','Looking for the perfect shoulder bag to accompany you on your next outing?  This bag will be the perfect match for you.  Soft shoulder handles with great hardware detail on the front.  What a perfect bag to take on your next adventure.',NULL,NULL,1,1,'','',33.00,'','','dressedupboutiqueinventroy_095.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Faux Leather\r\n-Imported\r\n',0.00,13,0),(15,'Take Me Away- In Teal','100422BC','Add a bolt of color to your wardrobe with this number.  This teal bag can be worn to warm up your current fall ensemble or taken into spring to pair with your favorite skirt. Wear this lovely to your favorite cafe for al fresco dining. ',NULL,NULL,1,1,'','',40.00,'','','dressedupboutiqueinventroy_097.JPG','',0.0000,1,1,'-Small Front Zippered Pocket\r\n-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Buttercream Interior Lining\r\n-Single Handle\r\n-Faux Leather\r\n-Imported\r\n',0.00,16,0),(16,'Take Me Away-In Winter White','100422BC','This chic bag can easily be taken from Winter to Spring with little effort. Generous interior space with a streamlined design. What a complimentary bag to carry when sneaking away for a long weekend.  ',NULL,NULL,1,1,'','',40.00,'','','dressedupboutiqueinventory_053.JPG','',0.0000,1,1,'-Small front Zippered Pocket\r\n-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Single Handle\r\n-Buttercream Interior Lining\r\n-Faux Leather\r\n-Imported',0.00,15,0),(17,'The Jessica Bag-In White','0207','This shoulder style tote bag has plenty of interior room without looking the part.  Lots of hardware on exterior bag dresses it up for any day.  Soft double shoulder handles make it comfortable to carry when shoe shopping with girlfriends.  ',NULL,NULL,1,1,'','',45.00,'','','dressedupboutiqueinventory_054.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-Interior Zippered Pocket\r\n-2 Organizer Pockets\r\n-2 Side Zippered Pockets\r\n-Apricot Lining\r\n-Magnetic Front Buckle\r\n-Double Handle\r\n-Faux Leather \r\n-Imported',0.00,17,0),(59,'Triple Chain Necklace-Gold and Brown cameo','0','This necklace has three very fun and flirty chains with charms; A Gold and Brown Cameo and a small puffed heart. Would wear beautifully with a T Shirt or simple blouse.',NULL,NULL,1,1,'','',11.00,'','','dressedupaccessories_095.JPG','',0.0000,1,1,'-Chains measure 7 1/2\'\' long\r\n-Two Charms; Gold and Brown Cameo, Small Puffed Heart',0.00,67,0),(19,'Head Over Heels','1030','This is a one of a kind beauty and not for the faint at heart.  Stylish and chic with plenty of interior space for all things fabulous.  Carry this bag and be noticed.  A perfect statement piece for an evening in the city.',NULL,NULL,1,1,'','',58.00,'','','dressedupboutiqueinventory_059.JPG','',0.0000,1,1,'-2 Interior Pockets\r\n-Back Zippered Pocket\r\n-Double Handle\r\n-Additional Shoulder Strap\r\n-Faux Leather Exterior\r\n',0.00,19,0),(20,'Garden Party-In Black','99725','This handbag is the perfect way to add a little something to your ensemble.  Four oversized rosettes trimmed in layers of faux leather and tulle surround the exterior.  A perfect bag for day or night.',NULL,NULL,1,1,'','',65.00,'','','dressedupboutiqueinventory_060.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Double Handles\r\n-Zipper Top Closure\r\n-Faux Leather\r\n-Imported',0.00,24,0),(21,'Garden Party-In White','99725','This handbag is the perfect way to add a little something to your ensemble.  Four oversized rosettes trimmed in layers of faux leather and tulle surround the exterior.  A perfect bag for day or night.\r\n\r\n<P>SOLD OUT!!',NULL,NULL,1,1,'','',65.00,'','','dressedupboutiqueinventory_025.JPG','',0.0000,1,1,'-Back Zippered Pocket\r\n-2 Interior Zippered Pockets\r\n-2 Organizer Pockets\r\n-Double Handles\r\n-Faux Leather\r\n-Imported',0.00,20,0),(35,'Polka Dotted Blouse-In Pink','0','This fun and flirty blouse is perfect for upcoming Spring.  Delicate sheer polka dots are perfect for those days when you need something a little more feminine.  Can\'t wait until the new season?  Then pair it with your favorite cardigan and you\'re ready to go.<P>Only One Left!',NULL,NULL,1,1,'Size','',30.00,'Medium, ','','dressedupontop_004.JPG','',0.0000,1,1,'-100% Sheer Poly\r\n-Front Tie Tassle\r\n-Hand Wash\r\n-Imported\r\n\r\n',0.00,43,0),(70,'Summer Favorite-Tube Dress In Jade','0','This is sure to be your summer favorite.  This tube style dress is perfect for day or evening.  Super comfortable material with great flow and construction.  Trust me, you will be wearing this dress often.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Medium, Large','','dressedupspring_003.JPG','',0.0000,1,1,'-100% Spandex\r\n-Bust is Lined\r\n-Hangs to the Knee\r\n-Braided Tie at High Waist\r\n-Fits True to Size (In My Opinion)\r\n-Machine or Hand Wash\r\n-Imported',0.00,72,0),(22,'My Favorite Scarf-In Sand','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_017.JPG','',0.0000,1,1,'',0.00,21,0),(23,'My Favorite Scarf-In Black','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_012.JPG','',0.0000,1,1,'',0.00,22,0),(24,'My Favorite Scarf-In Cranberry','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_021.JPG','',0.0000,1,1,'',0.00,23,0),(25,'My Favorite Scarf-In Charcoal','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_023.JPG','',0.0000,1,1,'',0.00,25,0),(26,'My favorite Scarf-In Teal','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_025.JPG','',0.0000,1,1,'',0.00,27,0),(27,'My Favorite Scarf-In Eggplant','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_026.JPG','',0.0000,1,1,'',0.00,28,0),(28,'My Favorite Scarf-In Chocolate','0','Sure to become your favorite scarf too.  Longer unending loop makes it perfect for doubling up around the neck for that chic lioness collar.  This scarf is gauranteed to turn heads. ',NULL,NULL,1,1,'','',13.00,'','','stylemepretty_029.JPG','',0.0000,1,1,'',0.00,29,0),(29,'The Perfect Peacoat-In Black Fleece','0','Looking for the perfect Peacoat?  Stop your search right now. This well constructed lightweight coat is the perfect addition on those chilly nights.   Soft to the touch and pleasing to the eyes.\r\n<P>New Sale Price (Was $39.00)',NULL,NULL,1,1,'Size','',28.00,'Small, Medium, Large','','dressedupboutiquepeacoats_003.JPG','',0.0000,1,1,'-4 Oversized Front Buttons\r\n-Extended Length Tie at Waist\r\n-Strap and Button Detail on Sleeves\r\n-Length Designed to Hit Right Below the Bottom\r\n-2 Side Coat Pockets',0.00,30,0),(30,'The Perfect Peacoat-In Charcoal Fleece','0','Looking for the perfect Peacoat?  Stop your search right now. This well tailored lightweight coat is the perfect addition on those chilly nights.\r\n<P>New Sale Price (Was $39.00)',NULL,NULL,1,1,'Size','',28.00,'Small, Medium, Large','','dressedupboutiquepeacoats_006.JPG','',0.0000,1,1,'-4 Oversized Front Buttons\r\n-Extended Length Tie at Waist\r\n-Strap and Button Detail on Sleeves\r\n-Length Designed to Hit Right Below the Bottom\r\n-2 Side Coat Pockets',0.00,31,0),(31,'Cross My Heart Dress-In Charcoal','0','If you\'re looking for a versatile party dress, then this one is for you. This nylon/acrylic blend moves freely and feels light and airy.  Embellished shoulders and matching belt detail are all the accessories that you will need with this number.  Wear with flats for daytime or dress it up with tights and heels for night. ',NULL,NULL,1,1,'Size','',32.00,'Small, Medium, Large','','dressedupfeelingflirty_003.JPG','',0.0000,1,1,'-Nylon/Acrylic Blend\r\n-Poly Interior Lining \r\n-From the waist down the skirt of the dress measure 19 inches long  (measured from waist down)\r\n-Imported\r\n-May Be Hand Washed',0.00,32,0),(32,'Cross My Heart Dress-In Cafe','0','If you\'re looking for a versatile party dress, then this one is for you. This nylon/acrylic blend moves freely and feels light and airy.  Embellished shoulders and matching belt detail are all the accessories that you will need with this number.  Wear with flats for daytime or dress it up with tights and heels for night. ',NULL,NULL,1,1,'Size','',32.00,'Small, Medium, Large','','dressedupfeelingflirty_008.JPG','',0.0000,1,1,'-Nylon/Acrylic Blend\r\n\r\n-Interior Poly Lining\r\n\r\n-From the waist down, the skirt of the dress measure 19 inches long (measured from waist down)\r\n\r\n-Imported\r\n\r\n-May Be Hand Washed',0.00,33,0),(33,'Saturday Night Party Dress-In Chocolate','0','Fun and Flirty.  This dress covers both. Stud detail on the shoulders is a perfect compliment to this dress.  Constructed so that it bubbles perfectly at the bottom and creates gathered side pockets.  Waist belt with toggle hardware. Looks and feels like silk without the delicate maintenance. This 100% poly dress can be handwashed.  Pair with your most fabulous pair of ankle booties or heels for a night on the town.\r\n\r\n(Was Originally $38.00)',NULL,NULL,1,1,'Size','',27.00,'Small, Medium,Large','','dressedupfeelingflirty_012.JPG','',0.0000,1,1,'-100% Poly Shell\r\n\r\n-100% Poly Lining\r\n\r\n-Approximate length of the skirt part of dress is 15 inches long.\r\n\r\n-Imported\r\n\r\n-May Be Hand Washed',0.00,34,0),(34,'Saturday Night Party Dress-In Black','0','Fun and Flirty.  This dress covers both. Stud detail on the shoulders is a perfect compliment to this dress.  Constructed so that it bubbles perfectly at the bottom and creates gathered side pockets.  Waist belt with toggle hardware. Looks and feels like silk without the delicate maintenance. This 100% poly dress can be handwashed.  Pair with your most fabulous pair of ankle booties or heels for a night on the town.\r\n\r\n(Was Originally $38.00)',NULL,NULL,1,1,'Size','',27.00,'Large','','dressedupfeelingflirty_016.JPG','',0.0000,1,1,'-100% Poly Shell\r\n\r\n-100% Poly Interior Lining\r\n\r\n-Approximate skirt part of the dress measures 15 inches long (measured from waist down)\r\n\r\n-Imported\r\n\r\n-May Be Hand Washed',0.00,35,0),(36,'Polka Dotted Blouse-In Black','0','This fun and flirty blouse is perfect for upcoming Spring.  Delicate sheer polka dots are perfect for those days when you need something a little more feminine.  Can\'t wait until the new season?  Then pair it with your favorite cardigan and you\'re ready to go.',NULL,NULL,1,1,'Size','',30.00,'Small','','dressedupontop_007.JPG','',0.0000,1,1,'-100% Sheer Poly\r\n-Front Tie Tassle\r\n-Hand Wash\r\n-Imported',0.00,44,0),(37,'Polka Dotted Blouse-In White','0','This fun and flirty blouse is perfect for upcoming Spring.  Delicate sheer polka dots are perfect for those days when you need something a little more feminine.  Can\'t wait until the new season?  Then pair it with your favorite cardigan and you\'re ready to go.',NULL,NULL,1,1,'Size','',30.00,'Medium, Large','','dressedupontop_011.JPG','',0.0000,1,1,'-100% Sheer Poly\r\n-Front Tie Tassle\r\n-Hand Wash\r\n-Imported',0.00,45,0),(38,'Lace Vest-In Pale Gray','0','This delicate vest is the perfect pairing with your already favorite top or light sweater.  Think outside the box with this one, also wear it over a dress, tank or blouse.  Many options with this piece.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Large','','dressedupontop_019.JPG','',0.0000,1,1,'-100% Poly\r\n-Front Button Closure Under Tie\r\n-Decorative Beading Around Neck Down To Tie\r\n-Lace Trim Around Base of Vest\r\n-Hand wash\r\n-Imported\r\n',0.00,46,0),(39,'Lace Vest-In White','0','This delicate vest is the perfect pairing with your already favorite top or light sweater.  Think outside the box with this one, also wear it over a dress, tank or blouse.  Many options with this piece.  ',NULL,NULL,1,1,'Size','',24.00,'Large','','dressedupontop_010.JPG','',0.0000,1,1,'-100% Poly \r\n-Front Button Closure Under Front Tie\r\n-Decorative Beading Around Collar Down To Front Tie\r\n-Lace Trim Around Base Of Vest\r\n-Hand Wash\r\n-Imported',0.00,48,0),(40,'Lace Vest-In Sand','0','This delicate vest is the perfect pairing with your already favorite top or light sweater.  Think outside the box with this one, also wear it over a dress, tank or blouse.  Many options with this piece.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Medium','','dressedupontop_014.JPG','',0.0000,1,1,'-100% Poly\r\n-Front Button Closure Under Front Tie\r\n-Decorative Beading Around Collar Down To The Front Tie\r\n-Hand Wash\r\n-Imported',0.00,49,0),(41,'Collared Pearl Blouse-In Pale Gray','0','This is a statement blouse for sure. Lightweight,girly and constructed with all of the accessories that you will need for an evening out.  Pair with your pencil skirt, slacks or favorite jeans and heels and you\'re ready to go.',NULL,NULL,1,1,'Size','',36.00,'Small, ','','dressedupontop_026.JPG','',0.0000,1,1,'-Poly and Spandex Blend Shell\r\n-Gathered Collar with Faux Pearl Beading and Lace Detail\r\n-Cap Sleeve\r\n-Hand wash\r\n-Imported',0.00,51,0),(42,'Collared Pearl Blouse- In Pale Peach','0','This is a statement blouse for sure. Lightweight,girly and constructed with all of the accessories that you will need for an evening out.  Pair with your pencil skirt, slacks or favorite jeans and heels and you\'re ready to go.\r\n<P>Only One Left!',NULL,NULL,1,1,'Size','',36.00,'Small, ','','dressedupontop_016.JPG','',0.0000,1,1,'-100% Poly Spandex Blend\r\n-Gathered Collar With Faux Pearls and Lace Detail\r\n-Cap Sleeves\r\n-Hand Wash\r\n-Imported\r\n',0.00,54,0),(78,'Black Skinny Jean by LA Idol','0','If you are looking for a perfect black skinny jean then stop right now.  This pair will be all that you are looking for. LA Idol makes a great jean with lots of give and stretch.  Crystal buttons on all pockets add a little extra detail and sparkle.  Extra length provides for the cute ankle bunching.  (If in doubt with sizing, I recommend sizing up one.)',NULL,NULL,1,1,'Size','',39.00,'3,7,9,11,13','','dressedupspring_034.JPG','',0.0000,1,1,'-Cotton/Spandex Blend\r\n-Crystal Button Detail on All Pockets\r\n-3 Front Pockets, 2 Back Buttoned Pockets\r\n-Machine Wash Cold\r\n-Imported',0.00,79,0),(77,'Spring Floral Dress','0','This fun floral dress is perfect for Spring and Summer.  It\'s got great detail with a thin tie at the wasit and two front pockets.  The back of the dress has a key hole with a tie to match the front.  Adjustable straps.  Pair this with your favorite cardi and you\'re ready to go!',NULL,NULL,1,1,'Size','',29.00,'Small, Medium, Large','','dressedupspring_015.JPG','',0.0000,1,1,'-100% Rayon\r\n-Adjustable Shoulder Straps\r\n-Front Tie at Waist\r\n-Two Front Pockets\r\n-Keyhole Opening In Back With Tie\r\n-This Dress Hits About Mid Thigh\r\n-Dry Clean\r\n-Imported',0.00,78,0),(45,'Pretty Sheer Top','0','This darling little sheer top is another pefect item for your Spring wardrobe.  Ruffles around the collar as well as stipes of eyelit lace detail make this the perfect feminine blouse for all occasions.  ',NULL,NULL,1,1,'Size','Color',28.00,'Small, Medium','White, Black, Pale Pink','dressedupontop_028.JPG','',0.0000,1,1,'-100% Poly\r\n-Ruffle Detail Around Arm and Collar\r\n-Bow On Left Shoulder\r\n-Rouched Band Around Waist\r\n-Hand Wash\r\n-Imported',0.00,56,0),(75,'Summer Maxi-In Black','0','This is a fun play on the Maxi Dress.  It\'s tube style with a smocked bust and ruffle overlay are a perfect compliment to the floor length dress.  Printed white flowers at the dress base are adorned with crystal accents in the flowers center.',NULL,NULL,1,1,'Size','',27.00,'Small, Medium, Large','','dressedupspring_012.JPG','',0.0000,1,1,'-Rayon/Spandex Blend\r\n-Floor Length Maxi\r\n-Smocked Bust with Ruffle Overlay\r\n-Machine or Hand Wash Cold\r\n-Imported',0.00,76,0),(76,'Summer Maxi Dress-In Blue','0','This is a fun play on the Maxi Dress.  It\'s tube style with a smocked bust and ruffle overlay are a perfect compliment to the floor length dress.  Printed white flowers at the dress base are adorned with crystal accents in the flowers center.',NULL,NULL,1,1,'Size','',27.00,'Small, Medium, Large','','dressedupspring_019.JPG','',0.0000,1,1,'-Rayon/Spandex Blend\r\n-Smocked Bust with Ruffle Overlay\r\n-Floor Length Maxi\r\n-Machine or Hand Wash Cold\r\n-Imported',0.00,77,0),(48,'Front Tie Cardigan By Mustard Seed-In Cafe','0','Such a fun play on the essential cardigan.  Drawstring tie in lou of buttons give this piece a little something extra.  Lightweight feel and great construction.  Pair this over your favorite blouse or Spring dress.',NULL,NULL,1,1,'Size','',22.00,'Small, ','','dressedupontop_052.JPG','',0.0000,1,1,'100% Cotton\r\n-Generous Draw String Tie\r\n-Cableknit Detail On Sleeves\r\n-Hand Wash',0.00,57,0),(49,'Front Tie Cardigan By Mustard Seed-In Gray','0','Such a fun play on the essential cardigan.  Drawstring tie in lou of buttons give this piece a little something extra.  Lightweight feel and great construction.  Pair this over your favorite blouse or Spring dress.\r\n\r\n<P>Only One Left',NULL,NULL,1,1,'Size','',22.00,'Small, Medium','','dressedupontop_056.JPG','',0.0000,1,1,'-100% Cotton\r\n-Generous Drawstring Tie\r\n-Cableknit Detail On Sleeves\r\n-Hand Wash',0.00,59,0),(50,'Front Tie Cardigan By Mustard Seed -In Black','0','Such a fun play on the essential cardigan.  Drawstring tie in lou of buttons give this piece a little something extra.  Lightweight feel and great construction.  Pair this over your favorite blouse or Spring dress.',NULL,NULL,1,1,'Size','',22.00,'Medium','','dressedupontop_054.JPG','',0.0000,1,1,'-100% Cotton\r\n-Generous Drawstring Tie\r\n-Cableknit Detail On Sleeves\r\n-Hand Wash',0.00,60,0),(74,'Pink with Lace by Jolie','0','I love this blouse!  The powdery pink color with lace sleeves and gathered neckline are perfect for each other.  The drawstring tie at the waist is the perfect detail to finish this Spring time favorite.',NULL,NULL,1,1,'Size','',23.00,'Small, Medium, Large','','dressedupspring_020.JPG','',0.0000,1,1,'-Rayon/Spandex Blend\r\n-Drawstring Tie at Waist\r\n-Hand Wash\r\n-Made in USA',0.00,37,0),(52,'Crew Neck Sweater-In Black','0','The perfect and very classic crew neck sweater.  Made from lightweight cotton. This sweater can hold its own or pairs perfectly with anything from pearls to cropped blazers.  <P>Was Originally $22.00',NULL,NULL,1,1,'Size','',14.00,'Small, Medium','','dressedupontop_060.JPG','',0.0000,1,1,'-100% Cotton\r\n-Full Length Sleeves\r\n-Crew Neck\r\n-Hand Wash\r\n-Imported',0.00,62,0),(53,'V-Neck Sweater-In Gray','0','Just a great sweater for everyday.  Comfortable cotton with a deep v neck line that looks great with chinos or jeans.  3/4 length sleeves gives it a more casual feel.  It\'s light weight  will make it a great transition piece for Spring.',NULL,NULL,1,1,'Size','',24.00,'Small, Medium, Large','','dressedupontop_063.JPG','',0.0000,1,1,'-100% Cotton\r\n-3/4 Length Sleeves\r\n-Hand Wash\r\n-Imported',0.00,65,0),(73,'Summer Favorite-Tube Dress in Black','0','This is sure to be your summer favorite.  This tube style dress is perfect for day or evening.  Super comfortable material with great flow and construction.  Trust me, you will be wearing this dress often.  ',NULL,NULL,1,1,'Size','',24.00,'Small, Medium, Large','','dressedupspring_010.JPG','',0.0000,1,1,'-100% Spandex\r\n-Bust is Lined\r\n-Hangs to the Knee\r\n-Braided Tie at Waist\r\n-Fits True to Size (In My Opinion)\r\n-Machine or Hand Wash\r\n-Imported',0.00,75,0),(55,'Grandpa Cardi-In Sand','0','This is our take on the fun grandpa cardi.  Cozy with extra length in the sleeves.  Our granpa cardi is however light in weight and can be worn comfortably over other pieces throughout Spring and even during Summer nights.',NULL,NULL,1,1,'Size','',23.00,'Medium','','dressedupontop_070.JPG','',0.0000,1,1,'-Acrylic/Rayon Blend\r\n-Extra Length Sleeves\r\n-Double Front Pockets\r\n-6 Button Closure\r\n-Hand Wash\r\n-Imported\r\n',0.00,57,0),(79,'Rouched Top-In Teal','0','This is such a fun and flirty top.  It has delicate capped sleeves and gathered detail on the front.  The top is vibrant in color and has a great soft feel to it.  It is not clingy and has a little give to it.',NULL,NULL,1,1,'Size','',22.00,'Small, Medium','','dressedupspring_024.JPG','',0.0000,1,1,'-Rayon/Spandex Blend\r\n-Capped Sleeves\r\n-Hand Wash\r\n-Imported',0.00,36,0),(56,'My Favorite Cardigan-In White','0','Named My Favorite Cardigan because it is just that...my very favorite cardigan. This is the perfect sweater when you need just a light layer over your sundress or current top.  I add this sweater to my outfit at least once a week.  It\'s delicate and very functional.  A favorite go to piece.',NULL,NULL,1,1,'Size','',18.00,'Small, Medium','','dressedupontop_073.JPG','',0.0000,1,1,'-100% Cotton\r\n-Full Length Sleeves\r\n-9 Button Closure (extra buttons provided)\r\n-Hand Wash\r\n-Imported\r\n',0.00,66,0),(60,'Green With Envy Shoulder Bag','0','This is my favorite bag for Spring so far. The green is so vibrant and stunning...do not carry if you do not like to be noticed!  Lots of great interior space pairs well with the great design and construction of this bag.  Wear this bag anywhere this Spring!\r\n\r\n<P>SOLD OUT!!',NULL,NULL,1,1,'','',45.00,'','','dresseupstyleandflirty_012.JPG','',0.0000,1,1,'-Lots of Great Light-Weight Hardware on Front of Bag\r\n-Double Shoulder Straps\r\n-Large Interior\r\n-1 Interior Pocket\r\n-2 Organizer Pockets\r\n-1 Rear Zipper Pocket\r\n-Fun Cheetah In Yellow and Brown Interior\r\n-Faux Leather\r\n-Imported',0.00,47,0),(61,'Granny Wallet-In Yellow','0','Darling little clasp wallet in a yellow vintage print.  Lots of interior compartments.  Throw in your bag or carry as a clutch on its own and go!\r\n\r\n<P>SOLD OUT!',NULL,NULL,1,1,'','',10.00,'','','dresseupstyleandflirty_025.JPG','',0.0000,1,1,'-7\" In Length\r\n-4.5\" In Width\r\n-Metal Clasp\r\n-Zippered Coin Pocket\r\n-ID Pocket\r\n-5 Credit Card Pockets\r\n-2 Envelope Pockets ',0.00,50,0),(62,'Spring Peasant Blouse-In White/Blue','0','Such a fun a flirty take on the Peasant Blouse. It has great construction with rouched sides and fluttery sleeves.  Great contrasting stitching detail around neck, sleeves and bottom. This is a fun blouse to wear and pairs nicely with a skinny jean or a wide trouser leg.',NULL,NULL,1,1,'Size','',32.00,'Small, Large','','dresseupstyleandflirty_033.JPG','',0.0000,1,1,'-Cotton/Poly Blend\r\n-White Blouse with Blue and Gray Stitching Trim\r\n-Hand Wash\r\n-Imported\r\n-This Blouse Runs Pretty True To Size',0.00,38,0),(63,'Spring Peasant Blouse-In Pale Gray','0','Such a fun a flirty take on the Peasant Blouse. It has great construction with rouched sides and fluttery sleeves.  Great contrasting stitching detail around neck, sleeves and bottom. This is a fun blouse to wear and pairs nicely with skinny jeans or a wide trouser leg.',NULL,NULL,1,1,'Size','',32.00,'Small, Large','','dresseupstyleandflirty_038.JPG','',0.0000,1,1,'-Cotton/Poly Blend\r\n-Pale Gray Blouse With Blue and White Stitching Design\r\n-Hand Wash\r\n-Imported\r\n-This Blouse Runs Pretty True To Size',0.00,41,0),(64,'Spring Peasant Blouse-In Beige','0','Such a fun a flirty take on the Peasant Blouse. It has great construction with rouched sides and fluttery sleeves.  Great contrasting stitching detail around neck, sleeves and bottom. This is a fun blouse to wear and pairs nicely with skinny jeans or a wide trouser leg.',NULL,NULL,1,1,'Size','',32.00,'Small, Medium, Large','','dresseupstyleandflirty_039.JPG','',0.0000,1,1,'-Cotton/Poly Blend\r\n-The Blouse Is Beige While The Stitching is Brown and White\r\n-Hand Wash\r\n-Imported\r\n-This Blouse Runs Pretty True To Size',0.00,42,0),(65,'Rosette Headband with Clear Sparkle','0','A shiny take on the ever popular flowery headband.  This simple black rosette is outlined with clear crystals to give it a little something extra.',NULL,NULL,1,1,'','',6.00,'','','dressu2_006.JPG','',0.0000,1,1,'',0.00,68,0),(66,' Crystal Cuffed Bracelet','0','This cuff is a great way to add some color to your day.  Vibrant crystals surround the metal cuff in a pattern of petals and lace.  This bracelet opens at the seem allowing for an easy on or off.\r\n<P>Also available in pink.',NULL,NULL,1,1,'Color','',15.00,'Vibrant Red, Vibrant Pink','','dressu2_004.JPG','',0.0000,1,1,'',0.00,69,0),(67,'Wallet with Fluer de Lis Crystal Detail-In Bronze','0','This is a great wallet with lots of room for all of your goodies.  The crystal Fluer de Lis detail on the front keeps it youthful and trendy. (Click on Photo to enlarge and read description of interior) <P>Only Two Left!',NULL,NULL,1,1,'','',18.00,'','','dreesu2_035.JPG','',0.0000,1,1,'-11 Credit Card Slots\r\n-ID Slot\r\n-Checkbook Cover\r\n-3 Envelopes \r\n-Back Zippered Pocket with Interior Change Pocket and 2 Envelopes\r\n-Crystal Fluer de Lis\r\n-Button Snap Closure',0.00,26,0),(68,'Herringbone Patterend Wallet-In Brown and White','0','This is a double zippered wallet that can be used as a wristlet.  Faux leather herringbone pattern on both sides. Lots of storage room inside.<P>(Click on photo to enlarge and read description of the inside)',NULL,NULL,1,1,'','',16.00,'','','dreesu2_037.JPG','',0.0000,1,1,'-Approximately 8\" In Length\r\n-3.5\" In Width\r\n-First Zippered Pocket Contains 8 Credit card or ID Slots and is divided in the center.\r\n-Second Zippered Pocket Contains 2 Envelopes and a Zippered Coin Pocket with additional room on each side.\r\n-Wristlet Has a Substantial Lobster Claw and Can be Removed\r\n-Faux Leather\r\n-Imported',0.00,70,0),(69,'Boyfriend Capri','0','This is a great jean....one of our best sellers.  It is a boyfriend capri that can be unrolled and worn as a pair of skinny jeans. Light distressing breaks up the denim only on the front.  The back has two plain pockets and solid denim-no distressing.  This jean wears so well and fits very true to size.  This will quickly become one of your favorite pairs of denim...trust me! I have worn this pair with ballet flats, flip flops, wedges and heels...they are so versatile and the fit is great.',NULL,NULL,1,1,'Size','',26.00,'0,1,3,5,7,9,13','','dreesu2_011.JPG','',0.0000,1,1,'-Cotton/Spandex Blend\r\n-5 Pockets (3 Front and 2 back)\r\n-Zipper and One Button Closure\r\n-Wear Rolled or Unrolled\r\n-Light Distressing on Front\r\n-Imported',0.00,71,0);

--
-- 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 '0',
  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 AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `Shipping` VALUES (NULL,NULL,50.00,7.95,5,4,NULL,NULL),(NULL,NULL,0.00,6.95,5,3,NULL,NULL);

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

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

INSERT INTO `Shopping` VALUES (16,78,1313436574,1,'7','dressedup','');

--
-- Dumping events for database 'dressedup'
--

--
-- Dumping routines for database 'dressedup'
--


