--
-- Host: localhost    Database: travelagent
-- ------------------------------------------------------


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

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

INSERT INTO `Category` VALUES (1,0,3,0,12,'Search the database of travel website designs.  When you ve found the template you would  like to use, click the order button.','','Designs','serv_title_web.gif',0),(19,0,3,20,0,'Israel, Egypt and other land tours','Israel, Egypt and other land tours','Middle East / North Africa','serv_title_web.gif',0),(11,0,1,15,0,'General Travel Website Designs','General Travel Templates','General','serv_title_web.gif',0),(14,0,3,18,0,'Safari Land Tours','Safari Land Tours','Safari','serv_title_web.gif',0),(15,0,3,16,0,'Snow Ski Vacations','Snow Ski Vacations','Skiing','serv_title_web.gif',0),(16,0,3,21,0,'Scuba Diving Excursions','Scuba Diving Excursions','Scuba','serv_title_web.gif',0),(17,0,3,14,0,'Cruise Vacations','Cruise Vacations','Cruises','serv_title_web.gif',0),(18,0,3,13,0,'Amusement Park Vacations','Disney, Six Flags, Sea World and other Amusement Park Vacations','Amusement Parks','serv_title_web.gif',0),(13,0,3,19,0,'European Vacations','European Vacations','Europe','serv_title_web.gif',0),(12,0,1,11,0,'All Travel Designs','All Travel Templates','All','serv_title_web.gif',0),(20,0,3,22,0,'Tours in Asia','Tours in Asia','Asia','serv_title_web.gif',0),(21,0,3,17,0,'Island travel.  Pacific / Caribbean','Island travel.  Pacific / Caribbean','Islands','serv_title_web.gif',0),(22,0,3,23,0,'Monuments, National Parks, Vacation Getaways','Monuments, National Parks, Vacation Getaways','America','serv_title_web.gif',0),(23,0,1,24,0,'',NULL,'Specials','',0),(24,0,1,0,0,'Not quite retired, you are welcomed to check out these classics.',NULL,'Archive','',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=440 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (265,40,12),(260,34,24),(361,47,12),(384,73,12),(372,60,12),(363,51,12),(380,69,12),(385,74,12),(233,8,24),(376,64,12),(375,63,12),(373,61,12),(371,59,12),(362,48,12),(365,52,12),(379,68,12),(359,42,12),(358,41,12),(386,75,12),(259,2,24),(366,53,12),(369,56,12),(238,7,24),(367,54,12),(368,55,12),(370,57,12),(357,30,24),(374,62,12),(382,71,12),(383,72,12),(234,4,11),(236,32,24),(239,19,24),(381,70,12),(237,35,24),(241,10,24),(243,31,24),(242,11,24),(244,12,24),(246,13,24),(245,5,24),(247,29,24),(248,25,24),(249,28,24),(250,27,24),(251,24,24),(252,15,24),(364,50,12),(253,6,24),(254,14,24),(360,43,12),(255,3,24),(257,23,24),(256,38,24),(235,37,24),(261,20,24),(262,21,24),(263,1,24),(378,66,12),(377,65,12),(240,36,24),(258,39,24),(387,76,12),(388,77,12),(389,78,12),(390,79,12),(392,80,12),(393,81,12),(394,83,12),(395,84,12),(396,85,12),(397,86,12),(398,87,12),(399,88,12),(400,89,12),(401,90,12),(402,91,12),(403,92,12),(404,93,12),(405,94,12),(406,95,12),(407,96,12),(408,97,12),(411,100,12),(413,102,12),(412,103,12),(414,104,12),(415,105,12),(416,106,12),(417,107,12),(418,108,12),(419,109,12),(420,110,12),(421,111,12),(422,112,12),(423,113,12),(424,114,12),(425,115,12),(426,116,12),(428,117,12),(431,119,12),(429,120,24),(430,121,12),(432,122,12),(436,123,12),(437,124,12),(438,125,12),(439,126,12),(427,127,12),(433,128,12),(434,129,12),(435,130,12);

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

--
-- Dumping data for table `Invoice`
--

INSERT INTO `Invoice` VALUES (4,'2002-03-12 10:26:18',11,11,1,'Shipping',0.00,'',NULL,NULL),(3,'2002-02-17 15:06:38',10,10,1,'Shipping',0.00,'',NULL,NULL),(5,'2002-04-13 09:08:04',13,13,1,'Shipping',0.00,'',NULL,NULL),(9,'2002-04-18 08:35:59',17,17,1,'Shipping',0.00,'',NULL,NULL),(8,'2002-04-17 14:52:39',16,16,1,'Shipping',0.00,'',NULL,NULL),(10,'2002-08-03 15:02:07',21,21,1,'Shipping',0.00,'I AM INTERESTED IN SUBSCRIBING TO VACATION PORT & NEED APRICE & SET UP INFO.',NULL,NULL),(11,'2002-10-03 17:59:57',25,25,1,'Shipping',0.00,'',NULL,NULL),(12,'2002-11-16 10:49:44',28,28,1,'Shipping',0.00,'Attention: Mickey\r\nThanks for your help. It was nice speaking with you today.\r\nPlease make Domain Name \r\nEventful Travel.\r\nI am looking forward to speaking with you and the designer. I will e-mail my business card file to you(for design).\r\nThank you,\r\nAlana Keller',NULL,NULL),(13,'2003-01-13 13:04:28',31,31,1,'Shipping',0.00,'I also like the Alaskan Cruise template but with the Cruise World 2 pictures.  How might that chnage the price.  It may not be worth it to me.  I don\'t need email accts. or a domain as I already have those.  I may trade those services to polish up my logo if possible.',NULL,NULL),(14,'2003-02-28 08:33:13',33,33,1,'Shipping',0.00,'',NULL,NULL),(15,'2003-03-18 13:31:09',34,34,1,'Shipping',0.00,'',NULL,NULL),(16,'2003-04-01 18:19:59',35,35,1,'Shipping',0.00,'',NULL,NULL),(17,'2003-06-30 12:12:09',38,38,1,'Shipping',0.00,'',NULL,NULL);

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

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

INSERT INTO `Page` VALUES (1,'welcome',2,0,'','','30,8,23,20,1','',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=132 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'World Travel','0','',NULL,NULL,1,1,'','',300.00,'','','world_travel.jpg','',0.0000,1,1,'',0.00,1,0,NULL),(2,'Travel Cruise','0','',NULL,NULL,1,1,'','',300.00,'','','travel_cruise.jpg','',0.0000,1,1,'',0.00,2,0,NULL),(3,'Scuba','0','',NULL,NULL,1,1,'','',300.00,'','','scuba.jpg','',0.0000,1,1,'',0.00,3,0,NULL),(4,'Basic Red','0','',NULL,NULL,1,1,'','',300.00,'','','red_site2.jpg','',0.0000,1,1,'',0.00,4,0,NULL),(5,'Foreign Lands','0','',NULL,NULL,1,1,'','',300.00,'','','img_fl.jpg','',0.0000,1,1,'',0.00,5,0,NULL),(6,'Red Rock','0','',NULL,NULL,1,1,'','',300.00,'','','red_rock.jpg','',0.0000,1,1,'',0.00,6,0,NULL),(7,'City Flight','0','',NULL,NULL,1,1,'','',300.00,'','','city_flight.jpg','',0.0000,1,1,'',0.00,7,0,NULL),(8,'Amusement Park Fun','0','',NULL,NULL,1,1,'','',300.00,'','','amusement_big.jpg','',0.0000,1,1,'',0.00,8,0,NULL),(10,'Discover Safari','0','',NULL,NULL,1,1,'','',300.00,'','','discover.gif','',0.0000,1,1,'',0.00,10,0,NULL),(11,'Egyptian','0','',NULL,NULL,1,1,'','',300.00,'','','egyptian.gif','',0.0000,1,1,'',0.00,11,0,NULL),(12,'Fishermen','0','',NULL,NULL,1,1,'','',300.00,'','','fishermen.gif','',0.0000,1,1,'',0.00,12,0,NULL),(13,'Forest','0','',NULL,NULL,1,1,'','',300.00,'','','Forest4.jpg','',0.0000,1,1,'',0.00,13,0,NULL),(14,'Rushmore','0','',NULL,NULL,1,1,'','',300.00,'','','mt_rush.gif','',0.0000,1,1,'',0.00,14,0,NULL),(15,'Paradise','0','',NULL,NULL,1,1,'','',300.00,'','','paradise.gif','',0.0000,1,1,'',0.00,15,0,NULL),(19,'Clean Cut','0','',NULL,NULL,1,1,'','',300.00,'','','very_cleancut.gif','',0.0000,1,1,'',0.00,18,0,NULL),(20,'World Cruise 1','0','',NULL,NULL,1,1,'','',300.00,'','','world_cruise1.jpg','',0.0000,1,1,'',0.00,20,0,NULL),(21,'World Cruise 2','0','',NULL,NULL,1,1,'','',300.00,'','','world_cruise2.jpg','',0.0000,1,1,'',0.00,21,0,NULL),(23,'Ski','0','',NULL,NULL,1,1,'','',300.00,'','','ski.jpg','',0.0000,1,1,'',0.00,23,0,NULL),(24,'Out of Africa','0','',NULL,NULL,1,1,'','',300.00,'','','africa.jpg','',0.0000,1,1,'',0.00,24,0,NULL),(25,'Grassy River','0','',NULL,NULL,1,1,'','',300.00,'','','amazon.jpg','',0.0000,1,1,'',0.00,25,0,NULL),(35,'Canoe','0','',NULL,NULL,1,1,'','',300.00,'','','airplane_boat.jpg','',0.0000,1,1,'',0.00,35,0,NULL),(27,'Middle East','0','',NULL,NULL,1,1,'','',300.00,'','','lsrael.jpg','',0.0000,1,1,'',0.00,27,0,NULL),(28,'Map','0','',NULL,NULL,1,1,'','',300.00,'','','map.jpg','',0.0000,1,1,'',0.00,28,0,NULL),(29,'Forest Walk','0','',NULL,NULL,1,1,'','',300.00,'','','trees.jpg','',0.0000,1,1,'',0.00,29,0,NULL),(30,'Alaskan Adventure','0','',NULL,NULL,1,1,'','',300.00,'','','img_alaska1.gif','',0.0000,1,1,'Home page is shown above.  Inside pages will be adjusted to hold content.',0.00,30,0,NULL),(31,'European Escape','0','',NULL,NULL,1,1,'','',300.00,'','','img_europe.gif','',0.0000,1,1,'',0.00,31,0,NULL),(32,'Blizzard Bliss','0','',NULL,NULL,1,1,'','',300.00,'','','snowski.gif','',0.0000,1,1,'',0.00,32,0,NULL),(34,'Tropical Adventures','0','',NULL,NULL,1,1,'','',300.00,'','','tropical_adventures.jpg','',0.0000,1,1,'',0.00,34,0,NULL),(36,'Cruisin Travel','0','',NULL,NULL,1,1,'','',300.00,'','','worldtours.jpg','',0.0000,1,1,'',0.00,36,0,NULL),(37,'Big Cat Safari','0','Big Cat Safari',NULL,NULL,1,1,'','',300.00,'','','big_cats_safari.jpg','',0.0000,1,1,'',0.00,37,0,NULL),(38,'Simply Business','0','',NULL,NULL,1,1,'','',300.00,'','','SimplyBusiness.jpg','',0.0000,1,1,'',0.00,38,0,NULL),(39,'Travel Agent Launch','0','<p align=\"center\"><b><br>\r\n                </b> <b><u><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Online \r\n                Marketing Suite of Services</font></u><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">:</font></b> \r\n              </p>\r\n              <ul>\r\n                <li> Website Creation <font size=\"1\"><i>($595 value)</i> </font></li>\r\n                <li><font size=\"1\"> Website Hosting <i>($24.95 per month - or \r\n                  $299.40 for the year) </i><br>\r\n                  <img src=\"imgs/blank.gif\" width=\"28\" height=\"8\">Includes email \r\n                  and domain name for the first year </font></li>\r\n                <li><font size=\"1\"> MetaTag Optimization <i>($100 - Home page \r\n                  only)</i></font></li>\r\n                <li> \r\n                  <div align=\"left\"><font size=\"1\"> Link in the Primary Hub System \r\n                    of Links <i>($100 per year)</i> </font></div>\r\n                </li>\r\n                <li><font size=\"1\"> Manual Submission to the Search Engines <i>($39.99 \r\n                  / month - or $479.88 / year)<br>\r\n                  </i></font></li>\r\n              </ul>\r\n              <div align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"1\" color=\"#000000\">Total \r\n                </font><font color=\"#000000\" size=\"1\"><b><font face=\"Arial, Helvetica, sans-serif\">$1574.28</font></b><font face=\"Arial, Helvetica, sans-serif\"> \r\n                Value!</font></font></div>\r\n              <p align=\"center\">We are discounting all of these services to: <br>\r\n                <b><font size=\"3\">$900</font></b><font size=\"3\"><font size=\"2\"> \r\n                total</font></font><font size=\"2\"> </font>for the year <b>AND</b> \r\n                we are offering <b>0% Financing</b> for the whole package!<font size=\"1\"><br>\r\n                <br>\r\n                <font size=\"2\">Total Cost to You:</font><font size=\"3\"><b> only \r\n                $75 per month!</b> <font size=\"1\"> <br>\r\n                (pricing for individual components still available) </font></font></font></p>\r\n            ',NULL,NULL,1,1,'','',300.00,'','','','',0.0000,1,1,'<p align=\"center\"><b><br>\r\n                </b> <b><u><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">Online \r\n                Marketing Suite of Services</font></u><font face=\"Arial, Helvetica, sans-serif\" size=\"2\">:</font></b> \r\n              </p>\r\n              <ul>\r\n                <li> Website Creation <font size=\"1\"><i>($595 value)</i> </font></li>\r\n                <li><font size=\"1\"> Website Hosting <i>($24.95 per month - or \r\n                  $299.40 for the year) </i><br>\r\n                  <img src=\"imgs/blank.gif\" width=\"28\" height=\"8\">Includes email \r\n                  and domain name for the first year </font></li>\r\n                <li><font size=\"1\"> MetaTag Optimization <i>($100 - Home page \r\n                  only)</i></font></li>\r\n                <li> \r\n                  <div align=\"left\"><font size=\"1\"> Link in the Primary Hub System \r\n                    of Links <i>($100 per year)</i> </font></div>\r\n                </li>\r\n                <li><font size=\"1\"> Manual Submission to the Search Engines <i>($39.99 \r\n                  / month - or $479.88 / year)<br>\r\n                  </i></font></li>\r\n              </ul>\r\n              <div align=\"center\"><font face=\"Arial, Helvetica, sans-serif\" size=\"1\" color=\"#000000\">Total \r\n                </font><font color=\"#000000\" size=\"1\"><b><font face=\"Arial, Helvetica, sans-serif\">$1574.28</font></b><font face=\"Arial, Helvetica, sans-serif\"> \r\n                Value!</font></font></div>\r\n              <p align=\"center\">We are discounting all of these services to: <br>\r\n                <b><font size=\"3\">$900</font></b><font size=\"3\"><font size=\"2\"> \r\n                total</font></font><font size=\"2\"> </font>for the year <b>AND</b> \r\n                we are offering <b>0% Financing</b> for the whole package!<font size=\"1\"><br>\r\n                <br>\r\n                <font size=\"2\">Total Cost to You:</font><font size=\"3\"><b> only \r\n                $75 per month!</b> <font size=\"1\"> <br>\r\n                (pricing for individual components still available) </font></font></font></p>\r\n            ',0.00,39,0,NULL),(40,'Aquamarine','TAS001','',NULL,NULL,1,1,'','',380.00,'','','Aquamarine.jpg','',0.0000,1,1,'',0.00,40,0,NULL),(41,'Backgreen','TAS002','',NULL,NULL,1,1,'','',380.00,'','','Backgreen.jpg','',0.0000,1,1,'',0.00,41,0,NULL),(42,'Balckandgreen','TAS003','',NULL,NULL,1,1,'','',380.00,'','','Balckandgreen.jpg','',0.0000,1,1,'',0.00,42,0,NULL),(43,'Beachhead','TAS004','',NULL,NULL,1,1,'','',380.00,'','','Beachhead.png','',0.0000,1,1,'',0.00,43,0,NULL),(44,'Beachresort','TAS004','',NULL,NULL,1,1,'','',380.00,'','','Beachresort.jpg','',0.0000,1,1,'',0.00,44,0,NULL),(45,'Beachresort','TAS004','',NULL,NULL,1,1,'','',380.00,'','','Beachresort.jpg','',0.0000,1,1,'',0.00,45,0,NULL),(46,'Beachresort','TAS004','',NULL,NULL,1,1,'','',380.00,'','','Beachresort.jpg','',0.0000,1,1,'',0.00,46,0,NULL),(47,'Beachresort','TAS005','',NULL,NULL,1,1,'','',380.00,'','','Beachresort.jpg','',0.0000,1,1,'',0.00,47,0,NULL),(48,'Beachside','TAS006','',NULL,NULL,1,1,'','',380.00,'','','Beachside.jpg','',0.0000,1,1,'',0.00,48,0,NULL),(49,'Beachsideview','TAS007','',NULL,NULL,1,1,'','',380.00,'','','Beachsideview.jpg','',0.0000,1,1,'',0.00,49,0,NULL),(50,'Beachway','TAS007','',NULL,NULL,1,1,'','',380.00,'','','Beachway.jpg','',0.0000,1,1,'',0.00,50,0,NULL),(51,'Beachsideview','TAS008','',NULL,NULL,1,1,'','',380.00,'','','Beachsideview.jpg','',0.0000,1,1,'',0.00,51,0,NULL),(52,'Blackandblue','TAS009','',NULL,NULL,1,1,'','',380.00,'','','Blackandblue.jpg','',0.0000,1,1,'',0.00,52,0,NULL),(53,'Blueview','TAS010','',NULL,NULL,1,1,'','',380.00,'','','Blueview.jpg','',0.0000,1,1,'',0.00,53,0,NULL),(54,'Boatview','TAS011','',NULL,NULL,1,1,'','',380.00,'','','Boatview.jpg','',0.0000,1,1,'',0.00,54,0,NULL),(55,'Choosy','TAS012','',NULL,NULL,1,1,'','',380.00,'','','Choosy.jpg','',0.0000,1,1,'',0.00,55,0,NULL),(56,'Coolview','TAS013','',NULL,NULL,1,1,'','',380.00,'','','Coolview.jpg','',0.0000,1,1,'',0.00,56,0,NULL),(57,'Cuteworld','TAS014','',NULL,NULL,1,1,'','',380.00,'','','Cuteworld.jpg','',0.0000,1,1,'',0.00,57,0,NULL),(58,'Darkandorange','TAS015','',NULL,NULL,1,1,'','',380.00,'','','Darkandorange.jpg','',0.0000,1,1,'',0.00,58,0,NULL),(59,'Darkaqua','TAS016','',NULL,NULL,1,1,'','',380.00,'','','Darkaqua.jpg','',0.0000,1,1,'',0.00,59,0,NULL),(60,'Darkblue','TAS016','',NULL,NULL,1,1,'','',380.00,'','','Darkblue.jpg','',0.0000,1,1,'',0.00,60,0,NULL),(61,'Darkflesh','TAS017','',NULL,NULL,1,1,'','',380.00,'','','Darkflesh.jpg','',0.0000,1,1,'',0.00,61,0,NULL),(62,'Darkness','TAS018','',NULL,NULL,1,1,'','',380.00,'','','Darkness.jpg','',0.0000,1,1,'',0.00,62,0,NULL),(63,'Darkorange','TAS019','',NULL,NULL,1,1,'','',380.00,'','','Darkorange.jpg','',0.0000,1,1,'',0.00,63,0,NULL),(64,'Daylight','TAS020','',NULL,NULL,1,1,'','',380.00,'','','Daylight.jpg','',0.0000,1,1,'',0.00,64,0,NULL),(65,'Dimbackground','TAS021','',NULL,NULL,1,1,'','',380.00,'','','Dimbackground.jpg','',0.0000,1,1,'',0.00,65,0,NULL),(66,'Disneyworld','TAS022','',NULL,NULL,1,1,'','',380.00,'','','Disneyworld.jpg','',0.0000,1,1,'',0.00,66,0,NULL),(67,'Dividedblack','TAS023','',NULL,NULL,1,1,'','',380.00,'','','Dividedblack.jpg','',0.0000,1,1,'',0.00,67,0,NULL),(68,'Dividedblack','TAS023','',NULL,NULL,1,1,'','',380.00,'','','Dividedblack.jpg','',0.0000,1,1,'',0.00,68,0,NULL),(69,'Dividedtour','TAS024','',NULL,NULL,1,1,'','',380.00,'','','Dividedtour.jpg','',0.0000,1,1,'',0.00,69,0,NULL),(70,'Fallsview','TAS025','',NULL,NULL,1,1,'','',380.00,'','','Fallsview.jpg','',0.0000,1,1,'',0.00,70,0,NULL),(71,'Familyday','TAS026','',NULL,NULL,1,1,'','',380.00,'','','Familyday.jpg','',0.0000,1,1,'',0.00,71,0,NULL),(72,'Fivecolors','TAS027','',NULL,NULL,1,1,'','',380.00,'','','Fivecolors.jpg','',0.0000,1,1,'',0.00,72,0,NULL),(73,'Fleshbackground','TAS028','',NULL,NULL,1,1,'','',380.00,'','','Fleshbackground.jpg','',0.0000,1,1,'',0.00,73,0,NULL),(74,'Flesshy','TAS029','',NULL,NULL,1,1,'','',380.00,'','','Flesshy.jpg','',0.0000,1,1,'',0.00,74,0,NULL),(75,'Frontbeach','TAS030','',NULL,NULL,1,1,'','',380.00,'','','Frontbeach.jpg','',0.0000,1,1,'',0.00,75,0,NULL),(76,'Frontcover','TAS031','',NULL,NULL,1,1,'','',380.00,'','','Frontcover.jpg','',0.0000,1,1,'',0.00,76,0,NULL),(77,'Frontview','TAS032','',NULL,NULL,1,1,'','',380.00,'','','Frontview.jpg','',0.0000,1,1,'',0.00,77,0,NULL),(78,'Glodenbrown','TAS033','',NULL,NULL,1,1,'','',380.00,'','','Glodenbrown.jpg','',0.0000,1,1,'',0.00,78,0,NULL),(79,'Grayscale','TAS034','',NULL,NULL,1,1,'','',380.00,'','','Grayscale.jpg','',0.0000,1,1,'',0.00,79,0,NULL),(80,'Greenny','TAS035','',NULL,NULL,1,1,'','',380.00,'','','Greenny.jpg','',0.0000,1,1,'',0.00,80,0,NULL),(81,'Greenworld','TS036','',NULL,NULL,1,1,'','',380.00,'','','Greenworld.jpg','',0.0000,1,1,'',0.00,81,0,NULL),(83,'Lightblue','TAS038','',NULL,NULL,1,1,'','',380.00,'','','Lightblue.jpg','',0.0000,1,1,'',0.00,83,0,NULL),(84,'Lightgreen','TASO39','',NULL,NULL,1,1,'','',380.00,'','','Lightgreen.jpg','',0.0000,1,1,'',0.00,84,0,NULL),(85,'Lightyellow','TAS040','',NULL,NULL,1,1,'','',380.00,'','','Lightyellow.jpg','',0.0000,1,1,'',0.00,85,0,NULL),(86,'Longgreen','TAS041','',NULL,NULL,1,1,'','',380.00,'','','Longgreen.jpg','',0.0000,1,1,'',0.00,86,0,NULL),(87,'Longgreen2','TAS042','',NULL,NULL,1,1,'','',380.00,'','','Longgreen2.jpg','',0.0000,1,1,'',0.00,87,0,NULL),(88,'Longtemplate','TAS043','',NULL,NULL,1,1,'','',380.00,'','','Longtemplate.jpg','',0.0000,1,1,'',0.00,88,0,NULL),(89,'Menubuttom','TAS044','',NULL,NULL,1,1,'','',380.00,'','','Menubuttom.jpg','',0.0000,1,1,'',0.00,89,0,NULL),(90,'Midblue','TAS045','',NULL,NULL,1,1,'','',380.00,'','','Midblue.jpg','',0.0000,1,1,'',0.00,90,0,NULL),(91,'Mintblue','TAS046','',NULL,NULL,1,1,'','',380.00,'','','Mintblue.jpg','',0.0000,1,1,'',0.00,91,0,NULL),(92,'Mintgreen','TAS047','',NULL,NULL,1,1,'','',380.00,'','','Mintgreen.jpg','',0.0000,1,1,'',0.00,92,0,NULL),(93,'Mintphotogalore','TAS048','',NULL,NULL,1,1,'','',380.00,'','','Mintphotogalore.jpg','',0.0000,1,1,'',0.00,93,0,NULL),(94,'Modernwhite','TAS049','',NULL,NULL,1,1,'','',380.00,'','','Modernwhite.jpg','',0.0000,1,1,'',0.00,94,0,NULL),(95,'Mountainhigh','TAS050','',NULL,NULL,1,1,'','',380.00,'','','Mountainhigh.jpg','',0.0000,1,1,'',0.00,95,0,NULL),(96,'Mystery','TAS051','',NULL,NULL,1,1,'','',380.00,'','','Mystery.jpg','',0.0000,1,1,'',0.00,96,0,NULL),(97,'Optiontravel','TAS052','',NULL,NULL,1,1,'','',380.00,'','','Optiontravel.jpg','',0.0000,1,1,'',0.00,97,0,NULL),(100,'Orangewhite','TAS055','',NULL,NULL,1,1,'','',380.00,'','','Orangewhite.jpg','',0.0000,1,1,'',0.00,100,0,NULL),(101,'Photogalore','TAS056','',NULL,NULL,1,1,'','',380.00,'','','Photogalore.jpg','',0.0000,1,1,'',0.00,101,0,NULL),(102,'Photogalore2','TAS056','',NULL,NULL,1,1,'','',380.00,'','','Photogalore2.jpg','',0.0000,1,1,'',0.00,102,0,NULL),(103,'Photogalore','TAS057','',NULL,NULL,1,1,'','',380.00,'','','Photogalore.jpg','',0.0000,1,1,'',0.00,103,0,NULL),(104,'Puzzle','TAS058','',NULL,NULL,1,1,'','',380.00,'','','Puzzle.jpg','',0.0000,1,1,'',0.00,104,0,NULL),(105,'Safetrip','TAS059','',NULL,NULL,1,1,'','',380.00,'','','Safetrip.jpg','',0.0000,1,1,'',0.00,105,0,NULL),(106,'Simpleblack','TAS60','',NULL,NULL,1,1,'','',380.00,'','','Simpleblack.jpg','',0.0000,1,1,'',0.00,106,0,NULL),(107,'Simplegreen','TAS061','',NULL,NULL,1,1,'','',380.00,'','','Simplegreen.jpg','',0.0000,1,1,'',0.00,107,0,NULL),(108,'Simpletemplate','TAS062','',NULL,NULL,1,1,'','',380.00,'','','Simpletemplate.jpg','',0.0000,1,1,'',0.00,108,0,NULL),(109,'Simpletemplate2','TAS063','',NULL,NULL,1,1,'','',380.00,'','','Simpletemplate2.jpg','',0.0000,1,1,'',0.00,109,0,NULL),(110,'Simpleview','TAS064','',NULL,NULL,1,1,'','',380.00,'','','Simpleview.jpg','',0.0000,1,1,'',0.00,110,0,NULL),(111,'Slimgreen','TAS065','',NULL,NULL,1,1,'','',380.00,'','','Slimgreen.jpg','',0.0000,1,1,'',0.00,111,0,NULL),(112,'Sunsetbeach','TAS066','',NULL,NULL,1,1,'','',380.00,'','','Sunsetbeach.jpg','',0.0000,1,1,'',0.00,112,0,NULL),(113,'Tourguide','TAS067','',NULL,NULL,1,1,'','',380.00,'','','Tourguide.jpg','',0.0000,1,1,'',0.00,113,0,NULL),(114,'Translucentblack','TAS068','',NULL,NULL,1,1,'','',380.00,'','','Translucentblack.jpg','',0.0000,1,1,'',0.00,114,0,NULL),(115,'Transparentbeach','TAS069','',NULL,NULL,1,1,'','',380.00,'','','Transparentbeach.jpg','',0.0000,1,1,'',0.00,115,0,NULL),(116,'Travelagent','TAS070','',NULL,NULL,1,1,'','',380.00,'','','Travelagent.jpg','',0.0000,1,1,'',0.00,116,0,NULL),(117,'Vegasnation','TAS071','',NULL,NULL,1,1,'','',380.00,'','','Vegasnation.jpg','',0.0000,1,1,'',0.00,117,0,NULL),(118,'Wordandbags','TAS072','',NULL,NULL,1,1,'','',380.00,'','','Wordandbags.jpg','',0.0000,1,1,'',0.00,118,0,NULL),(119,'Worldtravel','TAS072','',NULL,NULL,1,1,'','',380.00,'','','Worldtravel.jpg','',0.0000,1,1,'',0.00,119,0,NULL),(120,'Wordandbags','TAS073','',NULL,NULL,1,1,'','',380.00,'','','Wordandbags.jpg','',0.0000,1,1,'',0.00,120,0,NULL),(121,'Wordandbags','TAS073','',NULL,NULL,1,1,'','',380.00,'','','Wordandbags.jpg','',0.0000,1,1,'',0.00,121,0,NULL),(122,'beachshore','TAS074','',NULL,NULL,1,1,'','',380.00,'','','beachshore.jpg','',0.0000,1,1,'',0.00,122,0,NULL),(123,'sexybackground','TAS075','',NULL,NULL,1,1,'','',380.00,'','','sexybackground.jpg','',0.0000,1,1,'',0.00,123,0,NULL),(124,'slimdelight','TAS076','',NULL,NULL,1,1,'','',380.00,'','','slimdelight.jpg','',0.0000,1,1,'',0.00,124,0,NULL),(125,'threecolors','TAS077','',NULL,NULL,1,1,'','',380.00,'','','threecolors.jpg','',0.0000,1,1,'',0.00,125,0,NULL),(126,'travelworld','TAS078','',NULL,NULL,1,1,'','',380.00,'','','travelworld.jpg','',0.0000,1,1,'',0.00,126,0,NULL),(127,'Underwater','TAS079','',NULL,NULL,1,1,'','',380.00,'','','Underwater.jpg','',0.0000,1,1,'',0.00,127,0,NULL),(128,'crossimage','TAS080','',NULL,NULL,1,1,'','',380.00,'','','crossimage.jpg','',0.0000,1,1,'',0.00,128,0,NULL),(129,'darkgreen','TAS081','',NULL,NULL,1,1,'','',380.00,'','','darkgreen.jpg','',0.0000,1,1,'',0.00,129,0,NULL),(130,'graytray','TAS082','',NULL,NULL,1,1,'','',380.00,'','','graytray.jpg','',0.0000,1,1,'',0.00,130,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 AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` VALUES (4,1,1,'World Travel','0',249.00,'','',4,NULL),(3,36,1,'Cruisin Travel','0',249.00,'','',3,NULL),(5,13,1,'Forest','0',249.00,'','',5,NULL),(6,3,1,'Scuba','0',249.00,'','',8,NULL),(7,19,1,'Clean Cut','0',249.00,'','',9,NULL),(8,36,1,'Cruisin Travel','0',249.00,'','',10,NULL),(9,21,1,'World Cruise 2','0',249.00,'','',11,NULL),(10,21,1,'World Cruise 2','0',249.00,'','',12,NULL),(11,21,1,'World Cruise 2','0',495.00,'','',13,NULL),(12,36,1,'Cruisin Travel','0',495.00,'','',15,NULL),(13,39,1,'Travel Agent Launch','0',75.00,'','',17,NULL);

--
-- 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;

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

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

INSERT INTO `Shopping` VALUES (340,126,1395103110,1,'','travelagent','');

--
-- Dumping events for database 'travelagent'
--

--
-- Dumping routines for database 'travelagent'
--


