# $Id: sample_data.sql,v 1.7 2005/02/16 15:44:24 stingrey Exp $

#
# Dumping data for table `#__banner`
#

INSERT INTO `#__banner` VALUES (1, 1, 'banner', 'Ka-Ching', 0, 42, 0, 'ka-chingBanner.gif', 'http://www.miro.com.au', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL);
INSERT INTO `#__banner` VALUES (2, 1, 'banner', 'Oi!', 0, 48, 0, 'OiBanner.gif', 'http://www.miro.com.au', '2004-07-07 15:31:29', 1, 0, '2000-00-00 00:00:00', NULL, NULL);

#
# Dumping data for table `#__bannerclient`
#

INSERT INTO `#__bannerclient` VALUES (1, 'Miro International Pty.', 'Administrator', 'admin@miro.com.au', '', 0, '00:00:00', NULL);

#
# Dumping data for table `#__categories`
#

INSERT INTO `#__categories` VALUES (1, 0, 'Latest', 'Latest News', 'taking_notes.jpg', '1', 'left', 'The latest news from the Mambo Team', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 1, '');
INSERT INTO `#__categories` VALUES (2, 0, 'Mambo', 'Mambo', 'clock.jpg', 'com_weblinks', 'left', 'A selection of links that are all related to the Mambo project.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');
INSERT INTO `#__categories` VALUES (3, 0, 'Newsflash', 'Newsflash', '', '2', 'left', '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '');
INSERT INTO `#__categories` VALUES (4, 0, 'Mambo', 'Mambo', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, '');
INSERT INTO `#__categories` VALUES (5, 0, 'Business: general', 'Business: general', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
INSERT INTO `#__categories` VALUES (7, 0, 'Examples', 'Example FAQs', 'key.jpg', '3', 'left', 'Here you will find an example set of FAQs.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 2, '');
INSERT INTO `#__categories` VALUES (9, 0, 'Finance', 'Finance', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, '');
INSERT INTO `#__categories` VALUES (10, 0, 'Linux', 'Linux', '', 'com_newsfeeds', 'left', '<br />\r\n', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, '');
INSERT INTO `#__categories` VALUES (11, 0, 'Internet', 'Internet', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 0, 0, '');
INSERT INTO `#__categories` VALUES (12, 0, 'Contacts', 'Contacts', '', 'com_contact_details', 'left', 'Contact Details for this website', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');


#
# Dumping data for table `#__contact_details`
#

INSERT INTO `#__contact_details` VALUES (1, 'Name', 'Position', 'Street', 'Suburb', 'State', 'Country', 'Zip Code', 'Telephone', 'Fax', 'Miscellanous info', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0);

#
# Dumping data for table `#__content`
#

INSERT INTO `#__content` VALUES (1, 'Welcome to Mambo', 'Welcome', 'If you''ve read anything at all about Content Management Systems (CMS), you''ll probably know at least three things: CMS are the most exciting way to do business, CMS can be really, I mean <i>really</i>, complicated and lastly Portals are absolutely, outrageously, often <i>unaffordably</i> expensive. <br /><br />{mosimage}Mambo is set to change all that ... Mambo is different from the normal models for portal software. For a start, it''s not complicated. Mambo has been developed for the masses. It''s licensed under the GNU/GPL license, easy to install and administer and reliable. Mambo doesn''t even require the user or administrator of the system to know HTML to operate it once it''s up and running.', '<h4><font color="#ff6600">Mambo features:</font></h4>\r\n<ul>\r\n<li>Completely database driven site engins </li>\r\n<li>News, products or services sections fully editable and manageable</li> \r\n<li>Topics sections can be added to by contributing authors </li>\r\n<li>Fully customisable layouts including left, center and right menu boxes </li>\r\n<li>Browser upload of images to your own library for use anywhere in the site </li>\r\n<li>Dynamic Forum/Poll/Voting booth for on-the-spot results </li>\r\n<li>Runs on Linux, FreeBSD, MacOSX server, Solaris and AIX \r\n</li></ul>\r\n<h4>Extensive Administration:</h4>\r\n<ul>\r\n<li>Change order of objects including news, FAQs, articles etc. </li>\r\n<li>Random Newsflash generator </li>\r\n<li>Remote author submission module for News, Articles, FAQs and Links </li>\r\n<li>Object hierarchy - as many sections, departments, divisions and pages as you want </li>\r\n<li>Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs and JPEGs online for easy use </li>\r\n<li>Automatic Path-Finder. Place a picture and let Mambo fix the link </li>\r\n<li>News feed manager. Choose from over 360 news feeds from around the world </li>\r\n<li>Archive manager. Put your old articles into cold storage rather than throw them out </li>\r\n<li>Email-a-friend and Print-format for every story and article </li>\r\n<li>In-line Text editor similar to Word Pad </li>\r\n<li>User editable look and feel </li>\r\n<li>Polls/Surveys - Now put a different one on each page </li>\r\n<li>Custom Page Modules. Download custom page modules to spice up your site </li>\r\n<li>Template Manager. Download templates and implement them in seconds </li>\r\n<li>Layout preview. See how it looks before going live </li>\r\n<li>Banner manager. Make money out of your site</li></ul>', 1, 1, 0, 1, '2004-06-12 11:54:06', 62, 'Web Master', '2004-06-12 12:33:27', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'asterisk.png|left|Mambo Logo|1|Mambo Flower Logo|bottom|center|120', '', '', 1, 0, 1, '', '', 0, 0);
INSERT INTO `#__content` VALUES (2, 'Newsflash 1', '', 'Mambo 4.5 is ''Power In Simplicity''!. It has never been easier to create\r\nyour own dynamic site. Manage all your content from the best CMS admin\r\ninterface.', '', 1, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 1, '', '', 0, 0);
INSERT INTO `#__content` VALUES (3, 'Newsflash 2', '', 'Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards.', '', 1, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 2, '', '', 0, 0);
INSERT INTO `#__content` VALUES (4, 'Newsflash 3', '', 'Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn''t mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.', '', 1, 2, 1, 3, '2004-08-09 08:30:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2004-08-09 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 3, '', '', 0, 1);
INSERT INTO `#__content` VALUES (5, 'Mambo License Guidelines', '', 'Learn more about how Mambo is licensed and how this affects you.<br />  <br />  Mambo is released under the GNU General Public license (GNU GPL).The\r\nGNU GPL provides for a person or persons to distribute Mambo for a fee,\r\nbut not actually charging for the software itself, because Mambo is\r\nfree. Mambo is free to share and change, but if you do change it in\r\nanyway, can you also change the license and make it commercial? No! The\r\nwhole GPL is devoted to ensuring this does not happen. Copyright, a\r\nmuch more refined and stringent law will prevent this as well.<br />  <br />  So with regard to Mambo, the GPL and copyright:  <p>You <strong>MAY</strong> distribute it and charge for that service. You <strong>MAY</strong> change it, add design and content to it and you <strong>MAY</strong> charge for that. You may <strong>NOT</strong> alter the license and you must <strong>NOT</strong> alter the copyright. You do <strong>NOT</strong>     have to show a ''Powered by Mambo'' graphic, as it not a copyright notice.</p>  <p>In other words, you must NOT pretend that Mambo is yours, and you must NOT charge     people for Mambo.</p>\r\nUse Mambo to empower yourself and your clients by taking away the\r\n''Black Magic'' that surrounds putting content on the internet. Charge\r\nfor the value you add and not for the hard work that Miro, the Mambo\r\nDevelopment Team and the Mambo community have put into it.<br />  <br />  <strong>Guidelines:</strong>  <p>Mambo is "free" software released under the GNU General Public License (GPL). </p>  <p>The\r\nword "free'''' has two legitimate general meanings; it can refer either\r\nto freedom or to price. When we speak of "free software'''', we''re\r\ntalking about freedom, not price. (Think of "free speech'''', not "free\r\nbeer''''.) </p>  <p><em>Free software is a matter of the users'' freedom\r\nto run, copy, distribute, study, change and improve the software. More\r\nprecisely, it refers to four kinds of freedom, for the users of the\r\nsoftware:</em></p>  <ul>  <li>The freedom to run the program, for any purpose.</li><li> The freedom to study how the program works, and adapt it to your needs        <ul><li><em>Access to the source code is a precondition for this. </em></li></ul>    </li><li>The freedom to redistribute copies so you can help your neighbour.</li><li>The  freedom to improve the program, and release your improvements to the  public, so that the whole community benefits. <ul><li><em>Access to the source code is a precondition for this </em></li></ul>    </li>  </ul>{mospagebreak heading=Introduction&title=Guidelines}  <p><strong>1. What license is Mambo released under?</strong></p>  <p>Mambo  is released under the GNU GPL. A copy of this is included with your  copy     of Mambo and can also be found at <em>http://www.fsf.org/licenses/gpl.html</em>.     Unofficial translations can also be found at <em>http://www.fsf.org/licenses/translations.html</em>.</p>  <p><strong>2. Who owns the copyright to Mambo?</strong></p>  <p>The\r\ncopyright to Mambo is held by Miro International Pty Ltd. Miro were the\r\noriginal authors of Mambo and continue to actively support the project.</p>  <p><strong>3. Are there any restrictions to your use of Mambo?</strong></p>  <p>The GNU GPL grants you the freedom to use the software for whatever purpose you     see fit.</p>  <strong>4. May I charge money for Mambo?</strong>  <p>The\r\nGPL allows everyone the freedom to do this. The right to charge money\r\nto distribute Mambo is part of the definition of "free" software. </p>  <p>When\r\npeople think of "selling software'''', they usually imagine doing it the\r\nway most companies do it: making the software proprietary rather than\r\nfree. So to avoid ambiguity you may you may charge to distribute the\r\nsoftware and any other service you provide along the way. You may not\r\ncharge for the software itself.</p>  <p>Remember if  someone pays your fee the GPL also gives him or her the freedom to pass on the software with or without a fee.</p>  <p><strong>5. May I remove "powered by Mambo, Copyright Miro etc" from the footer?</strong></p>  <p>Yes you can although we would hope that you would retain it as a badge of honour.</p>  <p><strong>6. May I remove the "copyright" statements from the source code to Mambo?</strong></p>  <p>No, you must keep all copyright notices and credits in the source code.</p>  <p><strong>7. Does the GPL mean that my website content is also GPL?</strong></p>  <p>No.\r\nThe copyright and license of Mambo does not cover the content that you\r\ncreate. Using Mambo does not place any restrictions, legally, on the\r\nlicense or copyright you use for the content of your website.</p>  <p><strong>8. I have modified Mambo for my own web site. Do I have to release these     modifications?</strong></p>  <p>The\r\nGPL permits anyone to make a modified version for their own use without\r\nthe requirement to distribute it or pass on those changes to others.</p>  <p><strong>9. I have made a modification (hack) to the Mambo core code. Do I have     to release it under the GPL?</strong></p>  <p>If\r\nyou chose to distribute your modifications to others it must be\r\nreleased under the same terms that you received the original code. So\r\nyour modifications must be released under the GPL. You may of course in\r\nthis case modify the headers for the source code to include your own\r\ncopyright statement. If you do so you must clearly annotate in the\r\nsource code your amendments, changes or additions.</p>  <p><strong>10. I have written a Component, Module, Template for Mambo. Do I have     to release it under the GPL? </strong></p>  <p>No  The GPL allows you to write your own extensions for Mambo and to  release those extensions under whatever license you chose.</p>  <p><strong>11.\r\nI have written a Component, Module, Template for Mambo and released it\r\nunder the GPL and I charge a fee for it, but website X is giving it\r\naway for free.</strong></p>  <p>If someone pays your fee the GPL also\r\ngives him or her the freedom to pass on the software with or without a\r\nfee. Placing a restriction on someone''s use of GPL licensed software is\r\nin breach of the GPL itself.</p>  <p><strong>12. May I purchase a copy of Mambo, which has the copyright statements     removed?</strong></p>  <p>Although other GPL products may be available in this way Mambo is not.</p>  <p><strong>13. I believe person A is in breach of the GPL what should I do?</strong></p>  <p>You should report it. First check all the facts that you can and then report it     by sending an e-mail to <em>license-violation@mamboserver.com</em>.</p>  <p><strong>14. Who has the power to enforce the GNU GPL license of Mambo?</strong></p>  <p>Only\r\nthe copyright holder, Miro International Pty Ltd, has the power to do\r\nthis. If the Mambo Development Team finds, or is made aware of, a\r\nbreach of the GPL they will report it to Miro for them to take any\r\nnecessary action. </p>  <p><strong><em>Miro takes copyright infringement very seriously and will prosecute to     the full extent of the law.</em></strong></p>  <p><strong>15.\r\nWebsite X is using, or offering, my non-GPL Component, Module, Template\r\nwithout my permission, or in breach of its license, can you help me?</strong></p>  <p>Whilst\r\nthis is not within the remit or responsibility of Mambo we are willing\r\nto act as intermediaries in this on your behalf. In most cases these\r\nsituations arise out of simple misunderstandings and can be settled\r\namicably. You should e-mail full details to <em>license-violation@mamboserver.com</em>.</p>  <p><strong>DISCLAIMER</strong></p>  <p>This\r\ndocument refers to the software program Mambo, Version 4.x and all\r\nsubsequent versions, released under the GNU General Public License and\r\ncopyright Miro International Pty Ltd.</p>  <p>This document is subject to additions, modifications and other changes at any time without notice.</p>  <p>A\r\nlawyer has not prepared this document. You should consult a lawyer\r\nexperienced in copyright, licensing and intellectual property for\r\nclarification.</p>  <p>Document Rev. 1.4 - 17th August 2004<br />  <br />  </p>  <br />', '', 1, 0, 0, 0, '2004-08-19 20:11:07', 62, '', '2004-08-19 20:14:49', 62, 0, '0000-00-00 00:00:00', '2004-08-19 00:00:00', '0000-00-00 00:00:00', '', '', 'menu_image=\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 11, '', '', 0, 10);
INSERT INTO `#__content` VALUES (6, 'Example News Item 1', 'News1', '{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum.', '<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\n<p>Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n<p>Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.</p>', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:05:05', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/coffee.jpg|left||0\r\nfood/bread.jpg|right||0', '', '', 1, 0, 2, '', '', 0, 4);
INSERT INTO `#__content` VALUES (7, 'Example News Item 2', 'News2', '<p>{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>', '', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:11:30', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/bun.jpg|right||0', '', '', 1, 0, 3, '', '', 0, 2);
INSERT INTO `#__content` VALUES (8, 'Example News Item 3', 'News3', '<p>{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>', '', 1, 1, 0, 1, '2004-04-12 11:54:06', 62, '', '2004-07-07 18:08:23', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/pears.jpg|right||0', '', '', 1, 0, 4, '', '', 0, 1);
INSERT INTO `#__content` VALUES (9, 'Example News Item 4', 'News4', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>', '<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n{mospagebreak}<p>{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\n<p>{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n{mospagebreak}<p>Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.</p>', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/strawberry.jpg|left||0\r\nfruit/pears.jpg|right||0\r\nfruit/cherry.jpg|left||0', '', '', 1, 0, 5, '', '', 0, 6);
INSERT INTO `#__content` VALUES (10, 'Example FAQ Item 1', 'FAQ1', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>', '', 1, 3, 0, 7, '2004-05-12 11:54:06', 62, '', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 5, '', '', 0, 8);
INSERT INTO `#__content` VALUES (11, 'Example FAQ Item 2', 'FAQ2', '<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>', '<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\n<p>{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n<p>Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.</p>', 1, 3, 0, 7, '2004-05-12 11:54:06', 62, 'Web master', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'fruit/cherry.jpg|left||0\r\nfruit/peas.jpg|right||0\r\nfood/milk.jpg|left||0', '', '', 1, 0, 5, '', '', 0, 10);

#
# Dumping data for table `#__content_frontpage`
#

INSERT INTO `#__content_frontpage` VALUES (1, 1);
INSERT INTO `#__content_frontpage` VALUES (2, 2);
INSERT INTO `#__content_frontpage` VALUES (3, 3);
INSERT INTO `#__content_frontpage` VALUES (4, 4);
INSERT INTO `#__content_frontpage` VALUES (5, 5);

#
# Dumping data for table `#__menu`
#

INSERT INTO `#__menu` VALUES (2, 'mainmenu', 'News', 'index.php?option=com_content&task=section&id=1', 'content_section', 1, 0, 1, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (3, 'mainmenu', 'Contact Us', 'index.php?option=com_contact', 'components', 1, 0, 7, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (23, 'mainmenu', 'Links', 'index.php?option=com_weblinks', 'components', 1, 0, 4, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\nitem_description=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons=');
INSERT INTO `#__menu` VALUES (5, 'mainmenu', 'Search', 'index.php?option=com_search', 'components', 1, 0, 16, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (6, 'mainmenu', 'Mambo License', 'index.php?option=com_content&task=view&id=5', 'content_typed', 1, 0, 11, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, '');
INSERT INTO `#__menu` VALUES (7, 'mainmenu', 'News Feeds', 'index.php?option=com_newsfeeds', 'components', 1, 0, 12, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=');
INSERT INTO `#__menu` VALUES (8, 'mainmenu', 'Wrapper', 'index.php?option=com_wrapper', 'wrapper', 1, 0, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=1\nurl=www.mamboserver.com');
INSERT INTO `#__menu` VALUES (9, 'mainmenu', 'Blog', 'index.php?option=com_content&task=blogsection&id=0', 'content_blog_section', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog of all section with no images\npage_title=1\nleading=1\nintro=3\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=');
INSERT INTO `#__menu` VALUES (10, 'othermenu', 'MamboServer', 'http://www.mamboserver.com', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (11, 'othermenu', 'Administrator', 'administrator/', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1');
INSERT INTO `#__menu` VALUES (12, 'othermenu', 'MamboForge', 'http://mamboforge.net', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (21, 'usermenu', 'Your Details', 'index.php?option=com_user&task=UserDetails', 'url', 1, 0, 0, 0, 1, 0, '2000-00-00 00:00:00', 0, 0, 1, 3, '');
INSERT INTO `#__menu` VALUES (13, 'usermenu', 'Submit News', 'index.php?option=com_content&task=new&sectionid=1&Itemid=0', 'url', 1, 0, 0, 0, 2, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, '');
INSERT INTO `#__menu` VALUES (14, 'usermenu', 'Submit WebLink', 'index.php?option=com_weblinks&task=new', 'url', 1, 0, 0, 0, 4, 0, '2000-00-00 00:00:00', 0, 0, 1, 2, '');
INSERT INTO `#__menu` VALUES (15, 'usermenu', 'Check-In My Items', 'index.php?option=com_user&task=CheckIn', 'url', 1, 0, 0, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, '');
INSERT INTO `#__menu` VALUES (16, 'usermenu', 'Logout', 'index.php?option=com_login', 'components', 1, 0, 15, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, '');
INSERT INTO `#__menu` VALUES (17, 'topmenu', 'Home', 'index.php', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (18, 'topmenu', 'Contact Us', 'index.php?option=com_contact&Itemid=3', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (19, 'topmenu', 'News', 'index.php?option=com_content&task=section&id=1&Itemid=2', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, '');
INSERT INTO `#__menu` VALUES (20, 'topmenu', 'Links', 'index.php?option=com_weblinks&Itemid=22', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1');
INSERT INTO `#__menu` VALUES (25, 'mainmenu', 'FAQ''s', 'index.php?option=com_content&task=category&sectionid=3&id=7', 'content_category', 1, 0, 7, 0, 9, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\ntitle=1\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1');

#
# Dumping data for table `#__newsfeeds`
#

INSERT INTO `#__newsfeeds` VALUES (4, 1, 'Mamboforge.net', 'http://mamboforge.net/export/rss_sfnews.php', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 8);
INSERT INTO `#__newsfeeds` VALUES (4, 2, 'Mamboportal', 'http://www.mamboportal.com/index2.php?option=com_rss&no_html=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 9);
INSERT INTO `#__newsfeeds` VALUES (4, 3, 'Mambohut', 'http://www.mambohut.com/index2.php?option=com_rss&no_html=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 10);
INSERT INTO `#__newsfeeds` VALUES (10, 4, 'Linux Today', 'http://linuxtoday.com/backend/my-netscape.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 1);
INSERT INTO `#__newsfeeds` VALUES (5, 5, 'Business News', 'http://headlines.internet.com/internetnews/bus-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 2);
INSERT INTO `#__newsfeeds` VALUES (11, 6, 'Web Developer News', 'http://headlines.internet.com/internetnews/wd-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 3);
INSERT INTO `#__newsfeeds` VALUES (10, 7, 'Linux Central:New Products', 'http://linuxcentral.com/backend/lcnew.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 4);
INSERT INTO `#__newsfeeds` VALUES (10, 8, 'Linux Central:Best Selling', 'http://linuxcentral.com/backend/lcbestns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 5);
INSERT INTO `#__newsfeeds` VALUES (10, 9, 'Linux Central:Daily Specials', 'http://linuxcentral.com/backend/lcspecialns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 6);
INSERT INTO `#__newsfeeds` VALUES (9, 10, 'Internet:Finance News', 'http://headlines.internet.com/internetnews/fina-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 7);

#
# Dumping data for table `#__poll_data`
#

INSERT INTO `#__poll_data` VALUES (1, 14, 'Absolutely simple', 1);
INSERT INTO `#__poll_data` VALUES (2, 14, 'Reasonably easy', 0);
INSERT INTO `#__poll_data` VALUES (3, 14, 'Not straight-forward but I worked it out', 0);
INSERT INTO `#__poll_data` VALUES (4, 14, 'I had to install extra server stuff', 0);
INSERT INTO `#__poll_data` VALUES (5, 14, 'I had no idea and got my friend to do it', 0);
INSERT INTO `#__poll_data` VALUES (6, 14, 'My dog ran away with the README ...', 0);
INSERT INTO `#__poll_data` VALUES (7, 14, '', 0);
INSERT INTO `#__poll_data` VALUES (8, 14, '', 0);
INSERT INTO `#__poll_data` VALUES (9, 14, '', 0);
INSERT INTO `#__poll_data` VALUES (10, 14, '', 0);
INSERT INTO `#__poll_data` VALUES (11, 14, '', 0);
INSERT INTO `#__poll_data` VALUES (12, 14, '', 0);

#
# Dumping data for table `#__polls`
#

INSERT INTO `#__polls` VALUES (14, 'This Mambo installation was ....', 0, 0, '2000-00-00 00:00:00', 1, 0, 86400);

#
# Dumping data for table `#__poll_menu`
#

INSERT INTO `#__poll_menu` VALUES (14, 1);

#
# Dumping data for table `#__sections`
#

INSERT INTO `#__sections` VALUES (1, 'News', 'The News', 'articles.jpg', 'content', 'right', 'Select a news topic from the list below, then select a news article to read.', 1, 0, '0000-00-00 00:00:00', 1, 0, 1, '');
INSERT INTO `#__sections` VALUES (2, 'Newsflashes', 'Newsflashes', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, '');
INSERT INTO `#__sections` VALUES (3, 'FAQs', 'Frequently Asked Questions', 'pastarchives.jpg', 'content', 'left', 'From the list below choose one of our FAQs topics, then select an FAQ to read. If you have a question which is not in this section, please contact us.', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, '');


#
# Dumping data for table `#__weblinks`
#

INSERT INTO `#__weblinks` VALUES (1, 2, 0, 'Mambo', 'http://www.mamboserver.com', 'Home of Mambo', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0');
INSERT INTO `#__weblinks` VALUES (2, 2, 0, 'MamboForge', 'http://mamboforge.net', 'Get your Mambo add-ons here!', '2004-07-07 10:18:31', 0, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, '');
INSERT INTO `#__weblinks` VALUES (3, 2, 0, 'Miro International Pty Ltd', 'http://www.miro.com.au', 'Where Mambo was born', '2004-07-07 11:32:45', 1, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, '');
INSERT INTO `#__weblinks` VALUES (4, 2, 0, 'php.net', 'http://www.php.net', 'The language that Mambo is developed in', '2004-07-07 11:33:24', 0, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, '');
INSERT INTO `#__weblinks` VALUES (5, 2, 0, 'MySQL', 'http://www.mysql.com', 'The database that Mambo uses', '2004-07-07 10:18:31', 0, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, '');

INSERT INTO `#__pshop_category` VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992', 1, 'Hand Tools', 'Hand Tools', NULL, NULL, 'Y', 950319905, 960304194, 'browse_3', '3', '', '1');
INSERT INTO `#__pshop_category` VALUES ('1c914424d2569bea3439fbcca9123a27', 1, 'Power Tools', 'Power Tools', NULL, NULL, 'Y', 950319916, 960304104, 'browse_4', '4', '', '2');
INSERT INTO `#__pshop_category` VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a', 1, 'Garden Tools', 'Garden Tools', NULL, NULL, 'Y', 950321122, 960304338, 'browse_2', '2', 'shop.garden_flypage', '3');
INSERT INTO `#__pshop_category` VALUES ('f85e462baf927f8e53989dd969c0e430', 1, 'Outdoor Tools', 'Outdoor Tools', NULL, NULL, 'Y', 955626629, 958889528, 'browse_1', '1', NULL, '4');
INSERT INTO `#__pshop_category` VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a', 1, 'Indoor Tools', 'Indoor Tools', NULL, NULL, 'Y', 958892894, 958892894, 'browse_1', '1', NULL, '5');
		
		
INSERT INTO `#__pshop_category_xref` VALUES ('0', '541a03b2b0e1b6dbd972e9f5af5ca992', NULL);
INSERT INTO `#__pshop_category_xref` VALUES ('0', '1c914424d2569bea3439fbcca9123a27', NULL);
INSERT INTO `#__pshop_category_xref` VALUES ('0', '6834dda8e3e6e5aa18bafc63a57fd04a', NULL);
INSERT INTO `#__pshop_category_xref` VALUES ('1c914424d2569bea3439fbcca9123a27', 'f85e462baf927f8e53989dd969c0e430', NULL);
INSERT INTO `#__pshop_category_xref` VALUES ('1c914424d2569bea3439fbcca9123a27', '2f34f8bf003a5f27bed2e8dfe0b6f33a', NULL);

INSERT INTO `#__pshop_coupons` VALUES (1, 'test1', 'total', 'gift', 6.00);
INSERT INTO `#__pshop_coupons` VALUES (2, 'test2', 'percent', 'permanent', 15.00);
INSERT INTO `#__pshop_coupons` VALUES (3, 'test3', 'total', 'permanent', 4.00);
INSERT INTO `#__pshop_coupons` VALUES (4, 'test4', 'total', 'gift', 15.00);
			
INSERT INTO `#__pshop_product` VALUES (1, 1, 0, 'G01', '<p>Nice hand shovel to dig with in the yard.</p>\r\n', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', '8d886c5855770cc01a3b8a2db57f6600.jpg', 'cca3cd5db813ee6badf6a3598832f2fc.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 10, 1072911600, '48h.gif', 'Y', 1, NULL, 950320117, 1084907592, 'Hand Shovel', 0, '', '', 2);
INSERT INTO `#__pshop_product` VALUES (2, 1, 0, 'G02', 'A really long ladder to reach high places.', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', 'ffd5d5ace2840232c8c32de59553cd8d.jpg', '8cb8d644ef299639b7eab25829d13dbc.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 76, 1072911600, '3-5d.gif', 'N', 0, NULL, 950320180, 1084907618, 'Ladder', 0, '', '', 2);
INSERT INTO `#__pshop_product` VALUES (3, 1, 0, 'G03', 'Nice shovel.  You can dig your way to China with this one.', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', '8147a3a9666aec0296525dbd81f9705e.jpg', '520efefd6d7977f91b16fac1149c7438.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 32, 1072911600, '7d.gif', 'N', 0, NULL, 950320243, 1084907765, 'Shovel', 0, 'Size,XL[+1.99],M,S[-2.99];Colour,Red,Green,Yellow,ExpensiveColor[=24.00]', '', 2);
INSERT INTO `#__pshop_product` VALUES (4, 1, 0, 'G04', 'This shovel is smaller but you\'ll be able to dig real quick.', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', 'a04395a8aefacd9c1659ebca4dbfd4ba.jpg', '1b0c96d67abdbea648cd0ea96fd6abcb.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 98, 1088632800, 'on-order.gif', 'N', 0, NULL, 950320378, 1084907867, 'Smaller Shovel', 0, 'Size,big[+2.99],medium;Color,red[+0.99],green[-0.99]', '', 2);
INSERT INTO `#__pshop_product` VALUES (5, 1, 0, 'H01', 'This saw is great for getting cutting through downed limbs.', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', '1aa8846d3cfe3504b2ccaf7c23bb748f.jpg', 'e614ba08c3ee0c2adc62fd9e5b9440eb.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 32, 1072911600, '1-4w.gif', 'Y', 2, NULL, 950321256, 1084907669, 'Nice Saw', 0, 'Size,big,small,medium;Power,100W,200W,500W', '', 2);
INSERT INTO `#__pshop_product` VALUES (6, 1, 0, 'H02', 'A great hammer to hammer away with.', '\r\n<ul>  <li>Hand crafted handle with maximum grip torque  </li><li>Titanium tipped shovel platter  </li><li>Half degree offset for less accidents  </li><li>Includes HowTo Video narrated by Bob Costas  </li></ul>    <b>Specifications</b><br>  5\" Diameter<br>  Tungsten handle tip with 5 point loft<br>\r\n', 'dccb8223891a17d752bfc1477d320da9.jpg', '578563851019e01264a9b40dcf1c4ab6.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 500, 1072911600, '24h.gif', 'N', 0, NULL, 950321631, 1084907947, 'Hammer', 0, 'Size,big,medium,small;Material,wood and metal,plastic and metal[-0.99]', '', 2);
INSERT INTO `#__pshop_product` VALUES (7, 1, 0, 'P01', 'Don\'t do it with an axe.  Get a chain saw.', '\r\n<ul>  <li>Tool-free tensioner for easy, convenient chain adjustment  </li><li>3-Way Auto Stop; stops chain a fraction of a second  </li><li>Automatic chain oiler regulates oil for proper chain lubrication  </li><li>Small radius guide bar reduces kick-back  </li></ul>  <br>  <b>Specifications</b><br>  12.5 AMPS   <br>   16\" Bar Length   <br>   3.5 HP   <br>   8.05 LBS. Weight   <br>\r\n', '8716aefc3b0dce8870360604e6eb8744.jpg', 'c3a5bf074da14f30c849d13a2dd87d2c.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 45, 1088632800, '48h.gif', 'N', 0, NULL, 950321725, 1084907512, 'Chain Saw', 0, '', '', 2);
INSERT INTO `#__pshop_product` VALUES (8, 1, 0, 'P02', 'Cut rings around wood.  This saw can handle the most delicate projects.', '\r\n<ul>  <li>Patented Sightline; Window provides maximum visibility for straight cuts  </li><li>Adjustable dust chute for cleaner work area  </li><li>Bail handle for controlled cutting in 90° to 45° applications  </li><li>1-1/2 to 2-1/2 lbs. lighter and 40% less noise than the average circular saw                     </li><li><b>Includes:</b>Carbide blade  </li></ul>  <br>  <b>Specifications</b><br>  10.0 AMPS   <br>   4,300 RPM   <br>   Capacity: 2-1/16\" at 90°, 1-3/4\" at 45°<br>\r\n', 'b4a748303d0d996b29d5a1e1d1112537.jpg', '9a4448bb13e2f7699613b2cfd7cd51ad.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 33, 1072911600, '3-5d.gif', 'Y', 1, NULL, 950321795, 1084907537, 'Circular Saw', 0, 'Size,XL[+1],M,S[-2];Power,strong,middle,poor[=24]', '', 2);
INSERT INTO `#__pshop_product` VALUES (9, 1, 0, 'P03', 'Drill through anything.  This drill has the power you need for those demanding hole boring duties.', '\r\n<font color=\"#000000\" size=\"3\"><ul><li>High power motor and double gear reduction for increased durability and improved performance  </li><li>Mid-handle design and two finger trigger for increased balance and comfort  </li><li>Variable speed switch with lock-on button for continuous use  </li><li><b>Includes:</b> Chuck key &amp; holder  </li></ul>  <br>  <b>Specifications</b><br>  4.0 AMPS   <br>   0-1,350 RPM   <br>   Capacity: 3/8\" Steel, 1\" Wood   <br><br>  </font>\r\n', 'c70a3f47baf9a4020aeeee919eb3fda4.jpg', '1ff5f2527907ca86103288e1b7cc3446.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 3, 1072911600, '2-3d.gif', 'N', 0, NULL, 950321879, 1084907557, 'Drill', 0, '', '', 2);
INSERT INTO `#__pshop_product` VALUES (10, 1, 0, 'P04', 'Blast away that paint job from the past.  Use this power sander to really show them you mean business.', '\r\n<ul>  <li>Lever activated paper clamps for simple sandpaper changes  </li><li>Dust sealed rocker switch extends product life and keeps dust out of motor  </li><li>Flush sands on three sides to get into corners  </li><li>Front handle for extra control  </li><li>Dust extraction port for cleaner work environment   </li></ul>  <br>  <b>Specifications</b><br>  1.2 AMPS    <br>   10,000 OPM    <br>\r\n', '7a36a05526e93964a086f2ddf17fc609.jpg', '480655b410d98a5cc3bef3927e786866.jpg', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 2, 1072911600, '1-2m.gif', 'N', 2, NULL, 950321963, 1084907719, 'Power Sander', 0, 'Size,big,medium,small;Power,100W,200W,300W', '', 2);
INSERT INTO `#__pshop_product` VALUES (11, 1, 1, 'G01-01', '', '', '', '', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 0, '', '', 0, NULL, 955696949, 960372163, 'Hand Shovel', 0, NULL, '', 0);
INSERT INTO `#__pshop_product` VALUES (12, 1, 1, 'G01-02', '', '', '', '', 'Y', '10.0000', '', '0.0000', '0.0000', '0.0000', '', '', 0, 0, '', '', 0, NULL, 955697006, 960372187, 'Hand Shovel', 0, NULL, '', 0);
INSERT INTO `#__pshop_product` VALUES (13, 1, 1, 'G01-03', '', '', '', '', 'Y', '10.0000', '', '0.0000', '0.0000', '0.0000', '', '', 0, 0, '', '', 0, NULL, 955697044, 960372206, 'Hand Shovel', 0, NULL, '', 0);
INSERT INTO `#__pshop_product` VALUES (14, 1, 2, 'L01', '', '', '', '', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 22, 1072911600, '', 'N', 0, NULL, 962351149, 1084902820, 'Metal Ladder', 0, NULL, '', 2);
INSERT INTO `#__pshop_product` VALUES (15, 1, 2, 'L02', '', '', '', '', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 0, '', '', 0, NULL, 962351165, 962351165, 'Wooden Ladder', 0, NULL, '', 0);
INSERT INTO `#__pshop_product` VALUES (16, 1, 2, 'L03', '', '', '', '', 'Y', '10.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 0, '', '', 0, NULL, 962351180, 962351180, 'Plastic Ladder', 0, NULL, '', 0);
		 
INSERT INTO `#__pshop_product_attribute` VALUES (11, 'Color', 'Red');
INSERT INTO `#__pshop_product_attribute` VALUES (12, 'Color', 'Green');
INSERT INTO `#__pshop_product_attribute` VALUES (13, 'Color', 'Blue');
INSERT INTO `#__pshop_product_attribute` VALUES (11, 'Size', 'Small');
INSERT INTO `#__pshop_product_attribute` VALUES (12, 'Size', 'Medium');
INSERT INTO `#__pshop_product_attribute` VALUES (13, 'Size', 'Large');
INSERT INTO `#__pshop_product_attribute` VALUES (14, 'Material', 'Metal');
INSERT INTO `#__pshop_product_attribute` VALUES (15, 'Material', 'Wood');
INSERT INTO `#__pshop_product_attribute` VALUES (16, 'Material', 'Plastic');
		
INSERT INTO `#__pshop_product_attribute_sku` VALUES (1, 'Color', 1);
INSERT INTO `#__pshop_product_attribute_sku` VALUES (1, 'Size', 2);
INSERT INTO `#__pshop_product_attribute_sku` VALUES (2, 'Material', 1);
		
INSERT INTO `#__pshop_product_category_xref` VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992', 1, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a', 2, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a', 3, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a', 4, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992', 5, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992', 6, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('f85e462baf927f8e53989dd969c0e430', 7, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('1c914424d2569bea3439fbcca9123a27', 8, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a', 9, NULL);
INSERT INTO `#__pshop_product_category_xref` VALUES ('1c914424d2569bea3439fbcca9123a27', 10, NULL);
		
INSERT INTO `#__pshop_product_discount` VALUES (1, '20.00', 1, 1097704800, 1101337200);
INSERT INTO `#__pshop_product_discount` VALUES (2, '2.00', 0, 1098655200, 0);
		
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('1', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('2', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('3', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('4', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('5', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('6', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('7', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('8', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('9', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('10', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('11', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('12', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('13', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('14', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('15', '1');
INSERT INTO `#__pshop_product_mf_xref` VALUES  ('16', '1');
		
INSERT INTO `#__pshop_product_price` VALUES (1, 5, '24.99', 'USD', 0, 0, 950321309, 950321309, 5);
INSERT INTO `#__pshop_product_price` VALUES (2, 1, '4.99', 'USD', 0, 0, 950321324, 950321324, 5);
INSERT INTO `#__pshop_product_price` VALUES (3, 2, '49.99', 'USD', 0, 0, 950321340, 950321340, 5);
INSERT INTO `#__pshop_product_price` VALUES (4, 3, '24.99', 'USD', 0, 0, 950321368, 950321368, 5);
INSERT INTO `#__pshop_product_price` VALUES (5, 4, '19.99', 'USD', 0, 0, 950321385, 950321385, 5);
INSERT INTO `#__pshop_product_price` VALUES (6, 6, '1.00', 'USD', 0, 0, 950321686, 963808699, 5);
INSERT INTO `#__pshop_product_price` VALUES (7, 7, '149.99', 'USD', 0, 0, 950321754, 966506270, 5);
INSERT INTO `#__pshop_product_price` VALUES (8, 8, '220.90', 'USD', 0, 0, 950321833, 955614388, 5);
INSERT INTO `#__pshop_product_price` VALUES (9, 9, '48.12', 'USD', 0, 0, 950321933, 950321933, 5);
INSERT INTO `#__pshop_product_price` VALUES (10, 10, '74.99', 'USD', 0, 0, 950322005, 950322005, 5);
INSERT INTO `#__pshop_product_price` VALUES (11, 1, '2.99', 'USD', 0, 0, 955626841, 955626841, 6);
INSERT INTO `#__pshop_product_price` VALUES (12, 13, '14.99', 'USD', 0, 0, 955697213, 955697213, 5);
INSERT INTO `#__pshop_product_price` VALUES (13, 14, '79.99', 'USD', 0, 0, 962351197, 962351271, 5);
INSERT INTO `#__pshop_product_price` VALUES (14, 15, '49.99', 'USD', 0, 0, 962351233, 962351233, 5);
INSERT INTO `#__pshop_product_price` VALUES (15, 16, '59.99', 'USD', 0, 0, 962351259, 962351259, 5);
INSERT INTO `#__pshop_product_price` VALUES (16, 7, '2.99', 'USD', 0, 0, 966589140, 966589140, 6);
