--
-- Host: localhost    Database: donate
-- ------------------------------------------------------


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

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


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

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

INSERT INTO `Invoice` VALUES (2,'2003-06-17 21:03:56',2,2,1,'',0.00,'',NULL,NULL),(3,'2003-07-11 14:12:37',3,4,1,'',0.00,'',NULL,NULL),(4,'2003-10-26 07:32:59',5,5,1,'',0.00,'',NULL,NULL),(5,'2003-11-17 13:41:50',6,6,1,'',0.00,'',NULL,NULL),(6,'2003-12-31 10:10:24',7,7,1,'',0.00,'',NULL,NULL),(7,'2003-12-31 17:28:22',8,8,1,'',0.00,'',NULL,NULL),(8,'2004-01-13 20:20:05',9,9,1,'',0.00,'',NULL,NULL),(9,'2004-02-12 14:52:04',10,10,1,'',0.00,'',NULL,NULL),(11,'2004-05-07 10:28:48',12,12,1,'',0.00,'',NULL,NULL),(12,'2004-05-10 09:15:07',13,14,1,'',0.00,'',NULL,NULL),(13,'2004-06-02 18:33:43',15,15,1,'',0.00,'',NULL,NULL),(14,'2004-07-07 11:07:36',16,16,1,'',0.00,'',NULL,NULL),(15,'2004-07-22 09:59:31',17,17,1,'',0.00,'',NULL,NULL),(16,'2004-07-27 13:11:03',18,18,1,'',0.00,'',NULL,NULL),(18,'2004-09-23 08:17:13',20,21,1,'Shipping',9.00,'',NULL,NULL),(19,'2004-09-24 10:58:37',22,22,1,'Shipping',11.00,'',NULL,NULL),(21,'2005-05-31 12:11:48',24,25,1,'Shipping',9.00,'Phone - Post Card',NULL,NULL),(22,'2005-06-28 14:41:43',26,27,1,'Shipping',18.00,'GPH Post Card',NULL,NULL),(23,'2005-07-13 13:01:45',28,28,1,'Shipping',9.00,'Phone',NULL,NULL),(24,'2005-08-03 11:02:35',29,29,1,'Shipping',9.00,'',NULL,NULL),(25,'2005-09-20 11:31:33',30,31,1,'Shipping',9.00,'Phone Order\r\nPO Box 177',NULL,NULL),(26,'2005-09-20 16:37:10',32,32,1,'Shipping',9.00,'Phone Order - Invoice',NULL,NULL),(27,'2005-12-20 13:05:41',33,34,0,'Shipping',13.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,'<table width=\"700\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"left\">\r\n  <tr valign=\"top\"> \r\n    <td wrap> \r\n      <p align=\"center\"><b><font size=\"5\" color=\"#3366CC\">Equipping Families For Every Age And Stage Of Life</font></b></p>\r\n      <p align=\"left\">Would you like to be part of equipping families for every \r\n        age and stage of life? You can by making a tax deductible donation to \r\n        Family Matters, a ministry committed to equipping couples, parents and \r\n        grandparents to keep their commitments and bring the best out of those \r\n        they love the most. Your donations will be used to develop additional \r\n        tools to encourage and strengthen families all over the country. Options \r\n        for making a tax-deductible gift are below:</p>\r\n      <ol>\r\n        <li>\r\n          <p><a href=\"http://donations.efamilymatters.net/pk4/store.pl?view_product=1\">Donate \r\n            online</a></p>\r\n        </li>\r\n        <li>\r\n          <p> Call <b><font color=\"#FF0000\">1-800-467-4596</font></b> and make \r\n            a donation by credit card.</p>\r\n        </li>\r\n        <li>\r\n          <p> Make a check out to Family Matters and mail to :<br>\r\n            Family Matters<br>\r\n            13402 N. Scottsdale Rd., Suite A-120<br>\r\n            Scottsdale, AZ 85254</p>\r\n        </li>\r\n        <li>\r\n          <p> Donations can be made through your own foundation or organizations \r\n            such as United Way.</p>\r\n        </li>\r\n        <li>\r\n          <p>Donations of stock can be made through your investment broker.</p>\r\n        </li>\r\n      </ol>\r\n      <p align=\"center\"><br>\r\n        A tax-deductible receipt will be mailed promptly upon receipt of your \r\n        donation.</p>\r\n      <p align=\"center\"><b><font color=\"#3366CC\" size=\"4\">Thanks for being a partner \r\n        of Family Matters!</font></b></p>\r\n      <p></p>\r\n    </td>\r\n  </tr>\r\n</table>',6,0,'FamilySky.gif','','1','Donations to Family Matters',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,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'Grandparenthood: More Than Rocking Chairs','DCA5WB','<p>This is a limited time offer for Pastors, ministers and class leaders. <b><font color=\"#660000\">Purchase \r\n  kits at a discounted price of $99.95 - that\'s $50 off!</font></b></p>',NULL,NULL,1,1,'','Choose a Format',149.95,'','DVD, VHS','','',0.0000,1,1,'<div align=\"center\"><font size=\"5\" color=\"#660000\"><b>An amazing 33% off for Pastors! \r\n  </b><b></b></font> </div>\r\n<p>This is a limited time offer for Pastors, ministers and class leaders. <b><font color=\"#660000\">Purchase \r\n  kits at a discounted price of $99.95 - that\'s $50 off!</font></b></p>\r\n<p>Finaly, something to equip the most strategic and influential generation in \r\n  your church. This ground-breaking video study will make a dramaitc dfference \r\n  in your ministry as you reach out to the forefront of the baby-boomer generation.</p>\r\n<p>Don\'t forget to <a href=\"http://donations.efamilymatters.net/pk4/store.pl?view_product=4\"><b>order \r\n  more workbooks!</b></a> Every participant in your group should have his or her \r\n  own workbook. It is an excellent, personalized study tool with session outlines, \r\n  discussion guides, additional scripture studies and fun projects.</p>',0.00,1,NULL),(2,'Grandparenthood: More Than Rocking Chairs    LB9F','LB9F','',NULL,NULL,1,1,'','Retail Pirce <s>$149.95</s>',119.95,'','DVD,VHS','','',0.0000,1,1,'<p><b>You can order a kit now for only $119.95 (20% off the retail \r\n              price)</b>. If you order a kit now and <a href=\"http://www.grandparenthood.net/promos/register.html\">register</a> for the drawing and WIN you can \r\n              have your choice of getting a complete refund or use the second \r\n              free kit for your library, as a giveaway, or to have one of each \r\n              format!</p>\r\n            <p>Don\'t forget to<a href=\"http://donations.efamilymatters.net/pk4/store.pl?view_product=4\"><b> \r\n              order more workbooks</b></a>! Every participant in your group should \r\n              have his or her own workbook. It is an excellent, personalized study \r\n              tool with session outlines, discussion guides, additional scripture \r\n              studies and fun projects.</p>',0.00,2,NULL),(3,'Grandparenthood: More Than Rocking Chairs    9GFZ','9GFZ','',NULL,NULL,1,1,'','Retail Pirce <s>$149.95</s>',129.95,'','DVD, VHS','','',0.0000,1,1,'<p><font size=\"4\" color=\"#333399\">Evaluate <b><font color=\"#660000\">Grandparenthood</font></b> \r\n  <i>FREE</i> for 30 days.</font>\r\n\r\n<p><b><i>Terms and Conditions:<br>\r\n</i></b><font size=\"2\">If you choose to keep this copy of Grandparenthood, you \r\npay only $129.95 - that\'s $20 off retail! The credit card you use to pay for shipping \r\nwill be billed the purchase price of the kit. You will not be notified that your \r\ntrial period is approaching expiration or has expired. You will need to ship the \r\nkit to Family Matters (at your expense) with a postmark date of no later than \r\n30 days from the date on your invoice. The 30-day free trial begins upon shipment \r\nof your kit and will be clearly stated on your invoice. All shipping costs must be \r\nincurred by purchaser. Returns received postmarked after the trial period expires \r\nsubject to charge. A receipt will be mailed after the credit card is charged. \r\nPayment is required within 30 days of invoice.<br>\r\n</font>\r\n<p><b><font color=\"#FF0000\" size=\"2\">Please note:</font></b><font size=\"2\"> The \r\n  full amount of the order will show up when you check out. Please be assured, \r\n  you will only be charged $9.00 of that amount for Shipping and Handling initially. \r\n  The remaining balance will be charged to your credit card 30 days after the \r\n  invoice date.</font></p>',0.00,3,NULL),(4,'Grandparenthood Additional Workbooks','GPHWB','Two workbooks are included with your Grandparenthood kit. You may order additional workbooks at $8 each. ',NULL,NULL,1,1,'','',8.00,'','','GPhood200W.jpg','',0.0000,1,1,'<p>Two workbooks are included with your Grandparenthood kit. You may order additional \r\n  workbooks at $8 each. </p>\r\n<p><b>Order Additional Easy-to-use Participant\'s Workbooks with:</b></p>\r\n<ul>\r\n  <li>Session outlines</li>\r\n  <li>Note taking pages</li>\r\n  <li>Lively discussion questions</li>\r\n  <li>Relevant scriptural studies</li>\r\n  <li>Practical action points</li>\r\n  <li>Powerful prayer times</li>\r\n  <li>Fun, relationship-building projects</li>\r\n</ul>',0.00,4,NULL),(5,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Workbooks','CW5WB','<p>This is a limited time offer for pastors, ministers and class leaders. <b class=\"red\"><font color=\"#660000\">Purchase \r\n    Grandparenthood for $149.95 and get 5 additional workbooks FREE - that\'s 7 \r\n    workbooks total!</font></b></p>',NULL,NULL,1,1,'','Format',149.95,'','DVD,VHS','','',0.0000,1,1,'<p><font size=\"5\" color=\"#660000\"><b>5 FREE Workbooks - That\'s a $40 value!</b></font> \r\n  </p>\r\n</div>\r\n<p>This is a limited time offer for pastors, ministers and class leaders. <b class=\"red\"><font color=\"#660000\">Purchase \r\n  Grandparenthood for $149.95 and get 5 additional workbooks FREE - that\'s 7 workbooks \r\n  total!</font></b></p>\r\n<p>Finaly, something to equip the most strategic and influential generation in \r\n  your church. This ground-breaking video study will make a dramaitc dfference \r\n  in your ministry as you reach out to the forefront of the baby-boomer generation.</p>\r\n<p>Don\'t forget to <a href=\"http://donations.efamilymatters.net/pk4/store.pl?view_product=4\"><b>order \r\n  more workbooks!</b></a> Every participant in your group should have his or her \r\n  own workbook. It is an excellent, personalized study tool with session outlines, \r\n  discussion guides, additional scripture studies and fun projects.</p>',0.00,5,NULL),(8,'Help For The Hurried Family Pack','CW0206Hur','',NULL,NULL,1,1,'','',24.99,'','','','',0.0000,1,1,'Every parent wants a great relationship with their child. Between the hustel and bussle of regular family life and a culture that is competing to meet a child\'s needs, families need a game plan to keep from reaching meltdown. One of America\'s top advocates for the family has just the tools to help you. Order Dr. Tim Kimmel\'s Grace Based Parenting - winner of the 2005 Gold Medalion Book Award - with Raising Kids Who Turn Out Right for only $24.99 and receive his best-seller Little House On The Freeway FREE (a $12.99 value)!',0.00,8,NULL),(7,'Great Relationships Start At Home','CW0206Rel','',NULL,NULL,1,1,'','',24.99,'','','','',0.0000,1,1,'Every parent wants a great relationship with their child. Between the hustel and bussle of regular family life and a culture that is competing to meet a child\'s needs, families need a game plan to keep from reaching meltdown. One of America\'s top advocates for the family has just the tools to help you. Order Dr. Tim Kimmel\'s Grace Based Parenting - winner of the 2005 Gold Medalion Book Award - with Raising Kids Who Turn Out Right for only $24.99 and receive his best-seller Little House On The Freeway FREE (a $12.99 value)!',0.00,7,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=26 DEFAULT CHARSET=latin1;

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

INSERT INTO `Sale` VALUES (2,1,1,'Donation','0',1000.00,' 1000.00','',2,NULL),(3,1,1,'Donation','0',100.00,' 100.00','',3,NULL),(4,1,3,'Donation','0',500.00,' 500.00','',4,NULL),(5,1,2,'Donation','0',100.00,' 100.00','',5,NULL),(6,1,1,'Donation','0',100.00,' 100.00','',6,NULL),(7,1,1,'Donation','0',100.00,' 100.00','',7,NULL),(8,1,1,'Donation','0',100.00,' 100.00','',8,NULL),(9,1,1,'Donation','0',100.00,' 100.00','',9,NULL),(10,1,1,'Donation','0',100.00,' 100.00','',12,NULL),(11,1,1,'Donation','0',1000.00,' 1000.00','',13,NULL),(12,1,1,'Donation','0',100.00,' 100.00','',14,NULL),(14,1,1,'33% off Grandparenthood: More Than Rocking Chairs','DCA4',99.95,'','DVD',18,NULL),(15,4,8,'Grandparenthood Additional Workbooks','GPHWB',8.00,'','',19,NULL),(16,2,1,'Grandparenthood: More Than Rocking Chairs    LB9F','LB9F',119.95,'','DVD',19,NULL),(19,4,30,'Grandparenthood Additional Workbooks','GPHWB',8.00,'','',22,NULL),(18,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',21,NULL),(20,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',22,NULL),(21,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',23,NULL),(22,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',24,NULL),(23,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',25,NULL),(24,5,1,'Grandparenthood: More Than Rocking Chairs - with 5 FREE Work','CW5WB',149.95,'','DVD',26,NULL),(25,4,26,'Grandparenthood Additional Workbooks','GPHWB',8.00,'','',27,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 AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

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

INSERT INTO `Shipping` VALUES (NULL,NULL,0.00,0.00,5,14,NULL,NULL),(NULL,NULL,99.00,9.00,5,13,NULL,NULL),(NULL,NULL,160.00,11.00,5,12,NULL,NULL),(NULL,NULL,206.00,13.00,5,11,NULL,NULL),(NULL,NULL,230.00,15.00,5,10,NULL,NULL),(NULL,NULL,300.00,18.00,5,9,NULL,NULL),(NULL,NULL,7.99,3.50,5,15,NULL,NULL),(NULL,NULL,10.00,4.75,5,16,NULL,NULL),(NULL,NULL,21.00,5.00,5,17,NULL,NULL),(NULL,NULL,40.00,5.75,5,18,NULL,NULL),(NULL,NULL,55.00,6.50,5,19,NULL,NULL),(NULL,NULL,71.00,7.50,5,20,NULL,NULL),(NULL,NULL,88.00,8.25,5,21,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 DEFAULT CHARSET=latin1;

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


--
-- Dumping events for database 'donate'
--

--
-- Dumping routines for database 'donate'
--


