-- MySQL dump 10.10
--
-- Host: localhost Database: joomla
-- ------------------------------------------------------
-- Server version 5.0.18
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner`;
CREATE TABLE `jos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_banner`
--
/*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */;
LOCK TABLES `jos_banner` WRITE;
INSERT INTO `jos_banner` VALUES (1,1,'banner','OSM 1',0,45,0,'osmbanner1.png','http://www.opensourcematters.org','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL),(2,1,'banner','OSM 2',0,52,1,'osmbanner2.png','http://www.opensourcematters.org','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */;
--
-- Table structure for table `jos_bannerclient`
--
DROP TABLE IF EXISTS `jos_bannerclient`;
CREATE TABLE `jos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_bannerclient`
--
/*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */;
LOCK TABLES `jos_bannerclient` WRITE;
INSERT INTO `jos_bannerclient` VALUES (1,'Open Source Matters','Administrator','admin@opensourcematters.org','',0,'00:00:00',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_bannerclient` ENABLE KEYS */;
--
-- Table structure for table `jos_bannerfinish`
--
DROP TABLE IF EXISTS `jos_bannerfinish`;
CREATE TABLE `jos_bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_bannerfinish`
--
/*!40000 ALTER TABLE `jos_bannerfinish` DISABLE KEYS */;
LOCK TABLES `jos_bannerfinish` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_bannerfinish` ENABLE KEYS */;
--
-- Table structure for table `jos_categories`
--
DROP TABLE IF EXISTS `jos_categories`;
CREATE TABLE `jos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_categories`
--
/*!40000 ALTER TABLE `jos_categories` DISABLE KEYS */;
LOCK TABLES `jos_categories` WRITE;
INSERT INTO `jos_categories` VALUES (1,0,'Latest','Latest News','taking_notes.jpg','1','left','The latest news from the Joomla! Team',1,0,'0000-00-00 00:00:00','',0,0,1,''),(2,0,'Joomla!','Joomla!','clock.jpg','com_weblinks','left','A selection of links that are all related to the Joomla! Project.',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),(3,0,'Newsflash','Newsflash','','2','left','',1,0,'0000-00-00 00:00:00','',0,0,0,''),(4,0,'Joomla!','Joomla!','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(5,0,'Business: general','Business: general','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(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,''),(9,0,'Finance','Finance','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,5,0,0,''),(10,0,'Linux','Linux','','com_newsfeeds','left',' \r\n',1,0,'0000-00-00 00:00:00',NULL,6,0,0,''),(11,0,'Internet','Internet','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,7,0,0,''),(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,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_categories` ENABLE KEYS */;
--
-- Table structure for table `jos_components`
--
DROP TABLE IF EXISTS `jos_components`;
CREATE TABLE `jos_components` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`menuid` int(11) unsigned NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`admin_menu_link` varchar(255) NOT NULL default '',
`admin_menu_alt` varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`admin_menu_img` varchar(255) NOT NULL default '',
`iscore` tinyint(4) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_components`
--
/*!40000 ALTER TABLE `jos_components` DISABLE KEYS */;
LOCK TABLES `jos_components` WRITE;
INSERT INTO `jos_components` VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,''),(2,'Manage Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,''),(3,'Manage Clients','',0,1,'option=com_banners&task=listclients','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,''),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/globe2.png',0,''),(5,'Weblink Items','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,''),(6,'Weblink Categories','',0,4,'option=categories§ion=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,''),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/user.png',1,''),(8,'Manage Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,''),(9,'Contact Categories','',0,7,'option=categories§ion=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,''),(10,'FrontPage','option=com_frontpage',0,0,'','Manage Front Page Items','com_frontpage',0,'js/ThemeOffice/component.png',1,''),(11,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,''),(12,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,''),(13,'Manage News Feeds','',0,12,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,''),(14,'Manage Categories','',0,12,'option=com_categories§ion=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,''),(15,'Login','option=com_login',0,0,'','','com_login',0,'',1,''),(16,'Search','option=com_search',0,0,'','','com_search',0,'',1,''),(17,'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,''),(18,'Mass Mail','',0,0,'option=com_massmail&hidemainmenu=1','Send Mass Mail','com_massmail',0,'js/ThemeOffice/mass_email.png',0,''),(19,'VirtueMart','option=com_virtuemart',0,0,'option=com_virtuemart','VirtueMart','com_virtuemart',0,'js/ThemeOffice/component.png',0,''),(20,'virtuemart_version','',0,9999,'','','',0,'',0,'RELEASE=1.0.0\nDEV_STATUS=final'),(21,'joomlaXplorer','option=com_joomlaxplorer',0,0,'option=com_joomlaxplorer','joomlaXplorer','com_joomlaxplorer',0,'../administrator/components/com_joomlaxplorer/_img/joomla_x_icon.png',0,''),(22,'Letterman','option=com_letterman',0,0,'option=com_letterman','Letterman','com_letterman',0,'js/ThemeOffice/edit.png',0,''),(23,'Newsletter Management','',0,22,'option=com_letterman','Newsletter Management','com_letterman',0,'js/ThemeOffice/edit.png',0,''),(24,'Subscriber Management','',0,22,'option=com_letterman&task=subscribers','Subscriber Management','com_letterman',1,'js/ThemeOffice/users.png',0,''),(25,'Configuration','',0,22,'option=com_letterman&task=config','Configuration','com_letterman',2,'js/ThemeOffice/config.png',0,''),(26,'virtuemart_version','',0,9999,'','','',0,'',0,'RELEASE=1.0.4\nDEV_STATUS=stable');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_components` ENABLE KEYS */;
--
-- Table structure for table `jos_contact_details`
--
DROP TABLE IF EXISTS `jos_contact_details`;
CREATE TABLE `jos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_contact_details`
--
/*!40000 ALTER TABLE `jos_contact_details` DISABLE KEYS */;
LOCK TABLES `jos_contact_details` WRITE;
INSERT INTO `jos_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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_contact_details` ENABLE KEYS */;
--
-- Table structure for table `jos_content`
--
DROP TABLE IF EXISTS `jos_content`;
CREATE TABLE `jos_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_content`
--
/*!40000 ALTER TABLE `jos_content` DISABLE KEYS */;
LOCK TABLES `jos_content` WRITE;
INSERT INTO `jos_content` VALUES (1,'Welcome to Joomla!','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 really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive.
{mosimage}Joomla! is set to change all that ... Joomla! is different from the normal models for portal software. For a start, it\'s not complicated. Joomla! has been developed for the masses. It\'s licensed under the GNU/GPL license, easy to install and administer and reliable. Joomla! doesn\'t even require the user or administrator of the system to know HTML to operate it once it\'s up and running.','
Joomla! features:
\r\n
\r\n
Completely database driven site engines
\r\n
News, products or services sections fully editable and manageable
\r\n
Topics sections can be added to by contributing authors
\r\n
Fully customisable layouts including left, center and right menu boxes
\r\n
Browser upload of images to your own library for use anywhere in the site
\r\n
Dynamic Forum/Poll/Voting booth for on-the-spot results
\r\n
Runs on Linux, FreeBSD, MacOSX server, Solaris and AIX \r\n
\r\n
Extensive Administration:
\r\n
\r\n
Change order of objects including news, FAQs, articles etc.
\r\n
Random Newsflash generator
\r\n
Remote author submission module for News, Articles, FAQs and Links
\r\n
Object hierarchy - as many sections, departments, divisions and pages as you want
\r\n
Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs and JPEGs online for easy use
\r\n
Automatic Path-Finder. Place a picture and let Joomla! fix the link
\r\n
News feed manager. Choose from over 360 news feeds from around the world
\r\n
Archive manager. Put your old articles into cold storage rather than throw them out
\r\n
Email-a-friend and Print-format for every story and article
\r\n
In-line Text editor similar to Word Pad
\r\n
User editable look and feel
\r\n
Polls/Surveys - Now put a different one on each page
\r\n
Custom Page Modules. Download custom page modules to spice up your site
\r\n
Template Manager. Download templates and implement them in seconds
\r\n
Layout preview. See how it looks before going live
\r\n
Banner manager. Make money out of your site
',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|Joomla! Logo|1|Example Caption|bottom|center|120','','',1,0,1,'','',0,0),(2,'Newsflash 1','','Joomla! 1.0 - \'Experience the Freedom\'!. 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),(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),(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),(5,'Joomla! License Guidelines','','
This website is powered by Joomla! The software and default templates on which it runs are Copyright 2005 Open Source Matters. All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.
','',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),(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.','
{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.
\r\n\r\n
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.
\r\n\r\n
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.
\r\n\r\n
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.
\r\n\r\n
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.
{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.
{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.
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.
','
{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.
\r\n\r\n{mospagebreak}
{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.
\r\n\r\n
{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.
\r\n\r\n
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.
\r\n\r\n{mospagebreak}
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.
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.
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.
','
{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.
\r\n\r\n
{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.
\r\n\r\n
{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.
\r\n\r\n
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.
\r\n\r\n
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.
',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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_content` ENABLE KEYS */;
--
-- Table structure for table `jos_content_frontpage`
--
DROP TABLE IF EXISTS `jos_content_frontpage`;
CREATE TABLE `jos_content_frontpage` (
`content_id` int(11) NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_content_frontpage`
--
/*!40000 ALTER TABLE `jos_content_frontpage` DISABLE KEYS */;
LOCK TABLES `jos_content_frontpage` WRITE;
INSERT INTO `jos_content_frontpage` VALUES (1,1),(2,2),(3,3),(4,4),(5,5);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_content_frontpage` ENABLE KEYS */;
--
-- Table structure for table `jos_content_rating`
--
DROP TABLE IF EXISTS `jos_content_rating`;
CREATE TABLE `jos_content_rating` (
`content_id` int(11) NOT NULL default '0',
`rating_sum` int(11) unsigned NOT NULL default '0',
`rating_count` int(11) unsigned NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_content_rating`
--
/*!40000 ALTER TABLE `jos_content_rating` DISABLE KEYS */;
LOCK TABLES `jos_content_rating` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_content_rating` ENABLE KEYS */;
--
-- Table structure for table `jos_core_acl_aro`
--
DROP TABLE IF EXISTS `jos_core_acl_aro`;
CREATE TABLE `jos_core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_acl_aro`
--
/*!40000 ALTER TABLE `jos_core_acl_aro` DISABLE KEYS */;
LOCK TABLES `jos_core_acl_aro` WRITE;
INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_acl_aro` ENABLE KEYS */;
--
-- Table structure for table `jos_core_acl_aro_groups`
--
DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;
CREATE TABLE `jos_core_acl_aro_groups` (
`group_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_acl_aro_groups`
--
/*!40000 ALTER TABLE `jos_core_acl_aro_groups` DISABLE KEYS */;
LOCK TABLES `jos_core_acl_aro_groups` WRITE;
INSERT INTO `jos_core_acl_aro_groups` VALUES (17,0,'ROOT',1,22),(28,17,'USERS',2,21),(29,28,'Public Frontend',3,12),(18,29,'Registered',4,11),(19,18,'Author',5,10),(20,19,'Editor',6,9),(21,20,'Publisher',7,8),(30,28,'Public Backend',13,20),(23,30,'Manager',14,19),(24,23,'Administrator',15,18),(25,24,'Super Administrator',16,17);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_acl_aro_groups` ENABLE KEYS */;
--
-- Table structure for table `jos_core_acl_aro_sections`
--
DROP TABLE IF EXISTS `jos_core_acl_aro_sections`;
CREATE TABLE `jos_core_acl_aro_sections` (
`section_id` int(11) NOT NULL auto_increment,
`value` varchar(230) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`section_id`),
UNIQUE KEY `value_aro_sections` (`value`),
UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_acl_aro_sections`
--
/*!40000 ALTER TABLE `jos_core_acl_aro_sections` DISABLE KEYS */;
LOCK TABLES `jos_core_acl_aro_sections` WRITE;
INSERT INTO `jos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_acl_aro_sections` ENABLE KEYS */;
--
-- Table structure for table `jos_core_acl_groups_aro_map`
--
DROP TABLE IF EXISTS `jos_core_acl_groups_aro_map`;
CREATE TABLE `jos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL default '0',
`section_value` varchar(240) NOT NULL default '',
`aro_id` int(11) NOT NULL default '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--
/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` DISABLE KEYS */;
LOCK TABLES `jos_core_acl_groups_aro_map` WRITE;
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (25,'',10);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` ENABLE KEYS */;
--
-- Table structure for table `jos_core_log_items`
--
DROP TABLE IF EXISTS `jos_core_log_items`;
CREATE TABLE `jos_core_log_items` (
`time_stamp` date NOT NULL default '0000-00-00',
`item_table` varchar(50) NOT NULL default '',
`item_id` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_log_items`
--
/*!40000 ALTER TABLE `jos_core_log_items` DISABLE KEYS */;
LOCK TABLES `jos_core_log_items` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_log_items` ENABLE KEYS */;
--
-- Table structure for table `jos_core_log_searches`
--
DROP TABLE IF EXISTS `jos_core_log_searches`;
CREATE TABLE `jos_core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_core_log_searches`
--
/*!40000 ALTER TABLE `jos_core_log_searches` DISABLE KEYS */;
LOCK TABLES `jos_core_log_searches` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_core_log_searches` ENABLE KEYS */;
--
-- Table structure for table `jos_groups`
--
DROP TABLE IF EXISTS `jos_groups`;
CREATE TABLE `jos_groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_groups`
--
/*!40000 ALTER TABLE `jos_groups` DISABLE KEYS */;
LOCK TABLES `jos_groups` WRITE;
INSERT INTO `jos_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_groups` ENABLE KEYS */;
--
-- Table structure for table `jos_letterman`
--
DROP TABLE IF EXISTS `jos_letterman`;
CREATE TABLE `jos_letterman` (
`id` int(11) NOT NULL auto_increment,
`subject` varchar(50) NOT NULL default '',
`headers` text NOT NULL,
`message` text NOT NULL,
`html_message` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`send` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`access` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store all newsletters for Letterman.';
--
-- Dumping data for table `jos_letterman`
--
/*!40000 ALTER TABLE `jos_letterman` DISABLE KEYS */;
LOCK TABLES `jos_letterman` WRITE;
INSERT INTO `jos_letterman` VALUES (1,'Sample Newsletter','','Hello [NAME],\r\n\r\nthis is a nice sample Newsletter *Text Edition* from your guys at the newsletter team!.\r\n\r\nAfter having set up this newsletter component you can easily delete or modify this Newsletter.\r\n\r\nNow please enjoy Letterman!\r\n\r\nRegards, XXX\r\n','\r\n
Hello [NAME],
this is a nice sample Newsletter with Graphics from your guys at the newsletter team!.
After having set up this newsletter component you can easily delete or modify this Newsletter.
Now please enjoy Letterman!
Regards, XXX
',1,0,'0000-00-00 00:00:00','2005-02-04 00:00:00','2007-02-23 00:00:00','2005-02-01 15:26:02','2005-02-07 15:42:13',6,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_letterman` ENABLE KEYS */;
--
-- Table structure for table `jos_letterman_subscribers`
--
DROP TABLE IF EXISTS `jos_letterman_subscribers`;
CREATE TABLE `jos_letterman_subscribers` (
`subscriber_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`subscriber_name` varchar(64) NOT NULL default '',
`subscriber_email` varchar(64) NOT NULL default '',
`confirmed` tinyint(1) NOT NULL default '0',
`subscribe_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`subscriber_id`),
UNIQUE KEY `subscriber_email` (`subscriber_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Subscribers for Letterman are stored here.';
--
-- Dumping data for table `jos_letterman_subscribers`
--
/*!40000 ALTER TABLE `jos_letterman_subscribers` DISABLE KEYS */;
LOCK TABLES `jos_letterman_subscribers` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_letterman_subscribers` ENABLE KEYS */;
--
-- Table structure for table `jos_mambots`
--
DROP TABLE IF EXISTS `jos_mambots`;
CREATE TABLE `jos_mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_mambots`
--
/*!40000 ALTER TABLE `jos_mambots` DISABLE KEYS */;
LOCK TABLES `jos_mambots` WRITE;
INSERT INTO `jos_mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00',''),(2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00',''),(3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00',''),(4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00',''),(5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00',''),(9,'No WYSIWYG Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced'),(11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(14,'Search Categories','categories.searchbot','search',0,4,1,0,0,0,'0000-00-00 00:00:00',''),(15,'Search Sections','sections.searchbot','search',0,5,1,0,0,0,'0000-00-00 00:00:00',''),(16,'Email Cloaking','mosemailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00',''),(17,'GeSHi','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),(18,'Search Newsfeeds','newsfeeds.searchbot','search',0,6,1,0,0,0,'0000-00-00 00:00:00',''),(19,'Load Module Positions','mosloadposition','content',0,6,1,0,0,0,'0000-00-00 00:00:00',''),(20,'HTMLArea3 XTD','htmlarea3_xtd','editors',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(21,'ProductSearchBot','virtuemart.searchbot','search',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(22,'mosproductsnap','mosproductsnap','content',0,0,1,0,0,0,'0000-00-00 00:00:00','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_mambots` ENABLE KEYS */;
--
-- Table structure for table `jos_menu`
--
DROP TABLE IF EXISTS `jos_menu`;
CREATE TABLE `jos_menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`componentid` int(11) unsigned NOT NULL default '0',
`sublevel` int(11) default '0',
`ordering` int(11) default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL default '0',
`browserNav` tinyint(4) default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`utaccess` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_menu`
--
/*!40000 ALTER TABLE `jos_menu` DISABLE KEYS */;
LOCK TABLES `jos_menu` WRITE;
INSERT INTO `jos_menu` VALUES (1,'mainmenu','Home','index.php?option=com_frontpage','components',1,0,10,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Welcome to the Frontpage\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0'),(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,''),(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,''),(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='),(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,''),(6,'mainmenu','Joomla! 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,''),(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='),(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.joomla.org'),(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=0\nintro=6\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='),(10,'othermenu','Joomla! Home','http://www.joomla.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(11,'othermenu','Joomla! Forums','http://forum.joomla.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(12,'othermenu','OSM Home','http://www.opensourcematters.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(24,'othermenu','Administrator','administrator/','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),(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,''),(13,'usermenu','Submit News','index.php?option=com_content&task=new§ionid=1&Itemid=0','url',1,0,0,0,2,0,'2000-00-00 00:00:00',0,0,1,2,''),(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,''),(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,''),(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,''),(17,'topmenu','Home','index.php','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(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,''),(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,''),(20,'topmenu','Links','index.php?option=com_weblinks&Itemid=22','url',1,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),(25,'mainmenu','FAQs','index.php?option=com_content&task=category§ionid=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'),(26,'mainmenu','Our Online-Shop','index.php?option=com_virtuemart','components',1,0,19,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_menu` ENABLE KEYS */;
--
-- Table structure for table `jos_messages`
--
DROP TABLE IF EXISTS `jos_messages`;
CREATE TABLE `jos_messages` (
`message_id` int(10) unsigned NOT NULL auto_increment,
`user_id_from` int(10) unsigned NOT NULL default '0',
`user_id_to` int(10) unsigned NOT NULL default '0',
`folder_id` int(10) unsigned NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) NOT NULL default '0',
`priority` int(1) unsigned NOT NULL default '0',
`subject` varchar(230) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_messages`
--
/*!40000 ALTER TABLE `jos_messages` DISABLE KEYS */;
LOCK TABLES `jos_messages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_messages` ENABLE KEYS */;
--
-- Table structure for table `jos_messages_cfg`
--
DROP TABLE IF EXISTS `jos_messages_cfg`;
CREATE TABLE `jos_messages_cfg` (
`user_id` int(10) unsigned NOT NULL default '0',
`cfg_name` varchar(100) NOT NULL default '',
`cfg_value` varchar(255) NOT NULL default '',
UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_messages_cfg`
--
/*!40000 ALTER TABLE `jos_messages_cfg` DISABLE KEYS */;
LOCK TABLES `jos_messages_cfg` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_messages_cfg` ENABLE KEYS */;
--
-- Table structure for table `jos_modules`
--
DROP TABLE IF EXISTS `jos_modules`;
CREATE TABLE `jos_modules` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) default NULL,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`module` varchar(50) default NULL,
`numnews` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`showtitle` tinyint(3) unsigned NOT NULL default '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_modules`
--
/*!40000 ALTER TABLE `jos_modules` DISABLE KEYS */;
LOCK TABLES `jos_modules` WRITE;
INSERT INTO `jos_modules` VALUES (1,'Polls','',3,'right',0,'0000-00-00 00:00:00',1,'mod_poll',0,0,1,'',0,0),(2,'User Menu','',3,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,1,1,'menutype=usermenu',1,0),(3,'Main Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu',1,0),(4,'Login Form','',5,'left',0,'0000-00-00 00:00:00',0,'mod_login',0,0,1,'',1,0),(5,'Syndicate','',8,'left',0,'0000-00-00 00:00:00',1,'mod_rssfeed',0,0,1,'',1,0),(6,'Latest News','',2,'user1',0,'0000-00-00 00:00:00',0,'mod_latestnews',0,0,1,'',1,0),(7,'Statistics','',6,'left',0,'0000-00-00 00:00:00',0,'mod_stats',0,0,1,'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=',0,0),(8,'Who\'s Online','',4,'right',0,'0000-00-00 00:00:00',1,'mod_whosonline',0,0,1,'online=1\nusers=1\nmoduleclass_sfx=',0,0),(9,'Popular','',2,'user2',0,'0000-00-00 00:00:00',0,'mod_mostread',0,0,1,'',0,0),(10,'Template Chooser','',9,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),(11,'Archive','',10,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),(12,'Sections','',11,'left',0,'0000-00-00 00:00:00',0,'mod_sections',0,0,1,'',1,0),(13,'Newsflash','',1,'top',0,'0000-00-00 00:00:00',0,'mod_newsflash',0,0,1,'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=',0,0),(14,'Related Items','',12,'left',0,'0000-00-00 00:00:00',0,'mod_related_items',0,0,1,'',0,0),(15,'Search','',1,'user4',0,'0000-00-00 00:00:00',1,'mod_search',0,0,0,'',0,0),(16,'Random Image','',5,'right',0,'0000-00-00 00:00:00',1,'mod_random_image',0,0,1,'',0,0),(17,'Top Menu','',1,'user3',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0',1,0),(18,'Banners','',1,'banner',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'banner_cids=\nmoduleclass_sfx=\n',1,0),(19,'Components','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1,1),(20,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0,1),(21,'Latest Items','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0,1),(22,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0,1),(23,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1,1),(24,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',1,1),(25,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',1,1),(26,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',1,1),(27,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',1,1),(28,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',1,1),(29,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1),(30,'Other Menu','',4,'left',0,'0000-00-00 00:00:00',0,'mod_mainmenu',0,0,0,'menutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=',0,0),(31,'Wrapper','',13,'left',0,'0000-00-00 00:00:00',0,'mod_wrapper',0,0,1,'',0,0),(32,'Logged','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1),(33,'Product Categories Module','',14,'left',0,'0000-00-00 00:00:00',0,'mod_product_categories',0,0,1,'',0,0),(34,'Product Scroller','',1,'right',0,'0000-00-00 00:00:00',1,'mod_productscroller',0,0,1,'pretext=\nNumberOfProducts=5\nScrollSortMethod=random\nshow_product_name=yes\nshow_addtocart=yes\nshow_price=yes\nScrollHeight=125\nScrollWidth=150\nScrollBehavior=scroll\nScrollDirection=up\nScrollAmount=1\nScrollDelay=80\nScrollAlign=left\nScrollSpaceChar= \nScrollSpaceCharTimes=5\nScrollLineChar= \nScrollLineCharTimes=2\nScrollCSSOverride=no\nScrollTextAlign=left\nScrollTextWeight=normal\nScrollTextSize=10\nScrollTextColor=#000000\nScrollBGColor=transparent\nScrollMargin=2\nmoduleclass_sfx=\nclass_sfx=',0,0),(35,'Online-Shop','',1,'left',0,'0000-00-00 00:00:00',1,'mod_virtuemart',0,0,1,'class_sfx=\nmoduleclass_sfx=\npretext=\nshow_login_form=yes\nshow_categories=yes\nshow_listall=yes\nshow_minicart=no\nshow_productsearch=yes\nshow_product_parameter_search=no\nmenutype=links\njscook_type=menu\njscookMenu_style=ThemeOffice\nmenu_orientation=hbr\njscookTree_style=ThemeXP\nroot_label=Shop',0,0),(36,'All-In-One New/Featured/TopTen/Random Products Module','',15,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_allinone',0,0,1,'',0,0),(37,'Your Cart','',2,'top',0,'0000-00-00 00:00:00',1,'mod_virtuemart_cart',0,0,1,'moduleclass_sfx=\nclass_sfx=',0,0),(38,'Featured Products','',1,'user1',0,'0000-00-00 00:00:00',1,'mod_virtuemart_featureprod',0,0,1,'max_items=2\nshow_price=1\nshow_addtocart=0\ndisplay_style=horizontal\nproducts_per_row=4\ncategory_id=\nmoduleclass_sfx=\nclass_sfx=',0,0),(39,'Latest products','',2,'right',0,'0000-00-00 00:00:00',1,'mod_virtuemart_latestprod',0,0,1,'max_items=2\nshow_price=1\nshow_addtocart=1\ndisplay_style=vertical\nproducts_per_row=4\ncategory_id=\nmoduleclass_sfx=\nclass_sfx=',0,0),(40,'Manufacturer Module','',16,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_manufacturers',0,0,1,'',0,0),(41,'VirtueMart Search Module','',17,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_search',0,0,1,'',0,0),(42,'Random Products','',1,'user2',0,'0000-00-00 00:00:00',1,'mod_virtuemart_randomprod',0,0,1,'max_items=2\nshow_price=1\nshow_addtocart=0\ndisplay_style=horizontal\nproducts_per_row=4\ncategory_id=\nmoduleclass_sfx=\nclass_sfx=',0,0),(43,'Top-Ten Products','',7,'left',0,'0000-00-00 00:00:00',1,'mod_virtuemart_topten',0,0,1,'num_topsellers=10\nmoduleclass_sfx=\nclass_sfx=',0,0),(44,'Our Newsletter','',9,'left',0,'0000-00-00 00:00:00',1,'mod_lettermansubscribe',0,0,1,'pretext=\nchars_limit=0\nchars=15\nhide_name_field=0\nmoduleclass_sfx=\nclass_sfx=',0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_modules` ENABLE KEYS */;
--
-- Table structure for table `jos_modules_menu`
--
DROP TABLE IF EXISTS `jos_modules_menu`;
CREATE TABLE `jos_modules_menu` (
`moduleid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_modules_menu`
--
/*!40000 ALTER TABLE `jos_modules_menu` DISABLE KEYS */;
LOCK TABLES `jos_modules_menu` WRITE;
INSERT INTO `jos_modules_menu` VALUES (1,1),(2,0),(3,0),(4,1),(5,1),(6,1),(6,2),(6,4),(6,27),(6,36),(8,1),(9,1),(9,2),(9,4),(9,27),(9,36),(10,1),(13,0),(15,0),(17,0),(18,0),(30,0),(33,0),(34,1),(35,0),(36,0),(37,0),(38,1),(39,1),(40,0),(41,0),(42,1),(43,0),(44,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_modules_menu` ENABLE KEYS */;
--
-- Table structure for table `jos_newsfeeds`
--
DROP TABLE IF EXISTS `jos_newsfeeds`;
CREATE TABLE `jos_newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`link` text NOT NULL,
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(11) unsigned NOT NULL default '1',
`cache_time` int(11) unsigned NOT NULL default '3600',
`checked_out` tinyint(3) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_newsfeeds`
--
/*!40000 ALTER TABLE `jos_newsfeeds` DISABLE KEYS */;
LOCK TABLES `jos_newsfeeds` WRITE;
INSERT INTO `jos_newsfeeds` VALUES (4,1,'Joomla! - Official News','http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1','',1,5,3600,0,'0000-00-00 00:00:00',8),(4,2,'Joomla! - Community News','http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33','',1,5,3600,0,'0000-00-00 00:00:00',9),(4,3,'OpenSourceMatters','http://www.opensourcematters.org/index2.php?option=com_rss&feed=RSS2.0&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',10),(10,4,'Linux Today','http://linuxtoday.com/backend/my-netscape.rdf','',1,3,3600,0,'0000-00-00 00:00:00',1),(5,5,'Business News','http://headlines.internet.com/internetnews/bus-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',2),(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),(10,7,'Linux Central:New Products','http://linuxcentral.com/backend/lcnew.rdf','',1,3,3600,0,'0000-00-00 00:00:00',4),(10,8,'Linux Central:Best Selling','http://linuxcentral.com/backend/lcbestns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',5),(10,9,'Linux Central:Daily Specials','http://linuxcentral.com/backend/lcspecialns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',6),(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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_newsfeeds` ENABLE KEYS */;
--
-- Table structure for table `jos_poll_data`
--
DROP TABLE IF EXISTS `jos_poll_data`;
CREATE TABLE `jos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_poll_data`
--
/*!40000 ALTER TABLE `jos_poll_data` DISABLE KEYS */;
LOCK TABLES `jos_poll_data` WRITE;
INSERT INTO `jos_poll_data` VALUES (1,14,'Absolutely simple',1),(2,14,'Reasonably easy',0),(3,14,'Not straight-forward but I worked it out',0),(4,14,'I had to install extra server stuff',0),(5,14,'I had no idea and got my friend to do it',0),(6,14,'My dog ran away with the README ...',0),(7,14,'',0),(8,14,'',0),(9,14,'',0),(10,14,'',0),(11,14,'',0),(12,14,'',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_poll_data` ENABLE KEYS */;
--
-- Table structure for table `jos_poll_date`
--
DROP TABLE IF EXISTS `jos_poll_date`;
CREATE TABLE `jos_poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_poll_date`
--
/*!40000 ALTER TABLE `jos_poll_date` DISABLE KEYS */;
LOCK TABLES `jos_poll_date` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_poll_date` ENABLE KEYS */;
--
-- Table structure for table `jos_poll_menu`
--
DROP TABLE IF EXISTS `jos_poll_menu`;
CREATE TABLE `jos_poll_menu` (
`pollid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_poll_menu`
--
/*!40000 ALTER TABLE `jos_poll_menu` DISABLE KEYS */;
LOCK TABLES `jos_poll_menu` WRITE;
INSERT INTO `jos_poll_menu` VALUES (14,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_poll_menu` ENABLE KEYS */;
--
-- Table structure for table `jos_polls`
--
DROP TABLE IF EXISTS `jos_polls`;
CREATE TABLE `jos_polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_polls`
--
/*!40000 ALTER TABLE `jos_polls` DISABLE KEYS */;
LOCK TABLES `jos_polls` WRITE;
INSERT INTO `jos_polls` VALUES (14,'This Joomla! installation was ....',0,0,'2000-00-00 00:00:00',1,0,86400);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_polls` ENABLE KEYS */;
--
-- Table structure for table `jos_sections`
--
DROP TABLE IF EXISTS `jos_sections`;
CREATE TABLE `jos_sections` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`scope` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_sections`
--
/*!40000 ALTER TABLE `jos_sections` DISABLE KEYS */;
LOCK TABLES `jos_sections` WRITE;
INSERT INTO `jos_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,''),(2,'Newsflashes','Newsflashes','','content','left','',1,0,'0000-00-00 00:00:00',2,0,1,''),(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,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_sections` ENABLE KEYS */;
--
-- Table structure for table `jos_session`
--
DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_session`
--
/*!40000 ALTER TABLE `jos_session` DISABLE KEYS */;
LOCK TABLES `jos_session` WRITE;
INSERT INTO `jos_session` VALUES ('','1152003617','32484be25f47553b953b227617da7c34',1,0,'',0),('admin','1152003860','4f06b573159bcb6a910aa31bb5c413ec',1,62,'Super Administrator',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_session` ENABLE KEYS */;
--
-- Table structure for table `jos_stats_agents`
--
DROP TABLE IF EXISTS `jos_stats_agents`;
CREATE TABLE `jos_stats_agents` (
`agent` varchar(255) NOT NULL default '',
`type` tinyint(1) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_stats_agents`
--
/*!40000 ALTER TABLE `jos_stats_agents` DISABLE KEYS */;
LOCK TABLES `jos_stats_agents` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_stats_agents` ENABLE KEYS */;
--
-- Table structure for table `jos_template_positions`
--
DROP TABLE IF EXISTS `jos_template_positions`;
CREATE TABLE `jos_template_positions` (
`id` int(11) NOT NULL auto_increment,
`position` varchar(10) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_template_positions`
--
/*!40000 ALTER TABLE `jos_template_positions` DISABLE KEYS */;
LOCK TABLES `jos_template_positions` WRITE;
INSERT INTO `jos_template_positions` VALUES (1,'left',''),(2,'right',''),(3,'top',''),(4,'bottom',''),(5,'inset',''),(6,'banner',''),(7,'header',''),(8,'footer',''),(9,'newsflash',''),(10,'legals',''),(11,'pathway',''),(12,'toolbar',''),(13,'cpanel',''),(14,'user1',''),(15,'user2',''),(16,'user3',''),(17,'user4',''),(18,'user5',''),(19,'user6',''),(20,'user7',''),(21,'user8',''),(22,'user9',''),(23,'advert1',''),(24,'advert2',''),(25,'advert3',''),(26,'icon',''),(27,'debug','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_template_positions` ENABLE KEYS */;
--
-- Table structure for table `jos_templates_menu`
--
DROP TABLE IF EXISTS `jos_templates_menu`;
CREATE TABLE `jos_templates_menu` (
`template` varchar(50) NOT NULL default '',
`menuid` int(11) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`template`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_templates_menu`
--
/*!40000 ALTER TABLE `jos_templates_menu` DISABLE KEYS */;
LOCK TABLES `jos_templates_menu` WRITE;
INSERT INTO `jos_templates_menu` VALUES ('rhuk_solarflare_ii',0,0),('joomla_admin',0,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_templates_menu` ENABLE KEYS */;
--
-- Table structure for table `jos_users`
--
DROP TABLE IF EXISTS `jos_users`;
CREATE TABLE `jos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`username` varchar(25) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_users`
--
/*!40000 ALTER TABLE `jos_users` DISABLE KEYS */;
LOCK TABLES `jos_users` WRITE;
INSERT INTO `jos_users` VALUES (62,'Administrator','admin','a@b.com','5f4dcc3b5aa765d61d8327deb882cf99','Super Administrator',0,1,25,'2006-07-04 18:39:32','2006-07-04 18:41:59','','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_users` ENABLE KEYS */;
--
-- Table structure for table `jos_usertypes`
--
DROP TABLE IF EXISTS `jos_usertypes`;
CREATE TABLE `jos_usertypes` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
`mask` varchar(11) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_usertypes`
--
/*!40000 ALTER TABLE `jos_usertypes` DISABLE KEYS */;
LOCK TABLES `jos_usertypes` WRITE;
INSERT INTO `jos_usertypes` VALUES (0,'superadministrator',''),(1,'administrator',''),(2,'editor',''),(3,'user',''),(4,'author',''),(5,'publisher',''),(6,'manager','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_usertypes` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_affiliate`
--
DROP TABLE IF EXISTS `jos_vm_affiliate`;
CREATE TABLE `jos_vm_affiliate` (
`affiliate_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`active` char(1) NOT NULL default 'N',
`rate` int(11) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store affiliate user entries';
--
-- Dumping data for table `jos_vm_affiliate`
--
/*!40000 ALTER TABLE `jos_vm_affiliate` DISABLE KEYS */;
LOCK TABLES `jos_vm_affiliate` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_affiliate` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_affiliate_sale`
--
DROP TABLE IF EXISTS `jos_vm_affiliate_sale`;
CREATE TABLE `jos_vm_affiliate_sale` (
`order_id` int(11) NOT NULL default '0',
`visit_id` varchar(32) NOT NULL default '',
`affiliate_id` int(11) NOT NULL default '0',
`rate` int(2) NOT NULL default '0',
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores orders that affiliates have placed';
--
-- Dumping data for table `jos_vm_affiliate_sale`
--
/*!40000 ALTER TABLE `jos_vm_affiliate_sale` DISABLE KEYS */;
LOCK TABLES `jos_vm_affiliate_sale` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_affiliate_sale` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_auth_user_vendor`
--
DROP TABLE IF EXISTS `jos_vm_auth_user_vendor`;
CREATE TABLE `jos_vm_auth_user_vendor` (
`user_id` int(11) default NULL,
`vendor_id` int(11) default NULL,
KEY `idx_auth_user_vendor_user_id` (`user_id`),
KEY `idx_auth_user_vendor_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps a user to a vendor';
--
-- Dumping data for table `jos_vm_auth_user_vendor`
--
/*!40000 ALTER TABLE `jos_vm_auth_user_vendor` DISABLE KEYS */;
LOCK TABLES `jos_vm_auth_user_vendor` WRITE;
INSERT INTO `jos_vm_auth_user_vendor` VALUES (62,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_auth_user_vendor` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_category`
--
DROP TABLE IF EXISTS `jos_vm_category`;
CREATE TABLE `jos_vm_category` (
`category_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`category_name` varchar(128) NOT NULL default '',
`category_description` text,
`category_thumb_image` varchar(255) default NULL,
`category_full_image` varchar(255) default NULL,
`category_publish` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`category_browsepage` varchar(255) NOT NULL default 'browse_1',
`products_per_row` tinyint(2) NOT NULL default '1',
`category_flypage` varchar(255) default NULL,
`list_order` int(11) default NULL,
PRIMARY KEY (`category_id`),
KEY `idx_category_vendor_id` (`vendor_id`),
KEY `idx_category_name` (`category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Product Categories are stored here';
--
-- Dumping data for table `jos_vm_category`
--
/*!40000 ALTER TABLE `jos_vm_category` DISABLE KEYS */;
LOCK TABLES `jos_vm_category` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_category` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_category_xref`
--
DROP TABLE IF EXISTS `jos_vm_category_xref`;
CREATE TABLE `jos_vm_category_xref` (
`category_parent_id` int(11) NOT NULL default '0',
`category_child_id` int(11) NOT NULL default '0',
`category_list` int(11) default NULL,
KEY `category_xref_category_parent_id` (`category_parent_id`),
KEY `category_xref_category_child_id` (`category_child_id`),
KEY `idx_category_xref_category_list` (`category_list`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Category child-parent relation list';
--
-- Dumping data for table `jos_vm_category_xref`
--
/*!40000 ALTER TABLE `jos_vm_category_xref` DISABLE KEYS */;
LOCK TABLES `jos_vm_category_xref` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_category_xref` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_country`
--
DROP TABLE IF EXISTS `jos_vm_country`;
CREATE TABLE `jos_vm_country` (
`country_id` int(11) NOT NULL auto_increment,
`zone_id` int(11) NOT NULL default '1',
`country_name` varchar(64) default NULL,
`country_3_code` char(3) default NULL,
`country_2_code` char(2) default NULL,
PRIMARY KEY (`country_id`),
KEY `idx_country_name` (`country_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Country records';
--
-- Dumping data for table `jos_vm_country`
--
/*!40000 ALTER TABLE `jos_vm_country` DISABLE KEYS */;
LOCK TABLES `jos_vm_country` WRITE;
INSERT INTO `jos_vm_country` VALUES (1,1,'Afghanistan','AFG','AF'),(2,1,'Albania','ALB','AL'),(3,1,'Algeria','DZA','DZ'),(4,1,'American Samoa','ASM','AS'),(5,1,'Andorra','AND','AD'),(6,1,'Angola','AGO','AO'),(7,1,'Anguilla','AIA','AI'),(8,1,'Antarctica','ATA','AQ'),(9,1,'Antigua and Barbuda','ATG','AG'),(10,1,'Argentina','ARG','AR'),(11,1,'Armenia','ARM','AM'),(12,1,'Aruba','ABW','AW'),(13,1,'Australia','AUS','AU'),(14,1,'Austria','AUT','AT'),(15,1,'Azerbaijan','AZE','AZ'),(16,1,'Bahamas','BHS','BS'),(17,1,'Bahrain','BHR','BH'),(18,1,'Bangladesh','BGD','BD'),(19,1,'Barbados','BRB','BB'),(20,1,'Belarus','BLR','BY'),(21,1,'Belgium','BEL','BE'),(22,1,'Belize','BLZ','BZ'),(23,1,'Benin','BEN','BJ'),(24,1,'Bermuda','BMU','BM'),(25,1,'Bhutan','BTN','BT'),(26,1,'Bolivia','BOL','BO'),(27,1,'Bosnia and Herzegowina','BIH','BA'),(28,1,'Botswana','BWA','BW'),(29,1,'Bouvet Island','BVT','BV'),(30,1,'Brazil','BRA','BR'),(31,1,'British Indian Ocean Territory','IOT','IO'),(32,1,'Brunei Darussalam','BRN','BN'),(33,1,'Bulgaria','BGR','BG'),(34,1,'Burkina Faso','BFA','BF'),(35,1,'Burundi','BDI','BI'),(36,1,'Cambodia','KHM','KH'),(37,1,'Cameroon','CMR','CM'),(38,1,'Canada','CAN','CA'),(39,1,'Cape Verde','CPV','CV'),(40,1,'Cayman Islands','CYM','KY'),(41,1,'Central African Republic','CAF','CF'),(42,1,'Chad','TCD','TD'),(43,1,'Chile','CHL','CL'),(44,1,'China','CHN','CN'),(45,1,'Christmas Island','CXR','CX'),(46,1,'Cocos (Keeling) Islands','CCK','CC'),(47,1,'Colombia','COL','CO'),(48,1,'Comoros','COM','KM'),(49,1,'Congo','COG','CG'),(50,1,'Cook Islands','COK','CK'),(51,1,'Costa Rica','CRI','CR'),(52,1,'Cote D\'Ivoire','CIV','CI'),(53,1,'Croatia','HRV','HR'),(54,1,'Cuba','CUB','CU'),(55,1,'Cyprus','CYP','CY'),(56,1,'Czech Republic','CZE','CZ'),(57,1,'Denmark','DNK','DK'),(58,1,'Djibouti','DJI','DJ'),(59,1,'Dominica','DMA','DM'),(60,1,'Dominican Republic','DOM','DO'),(61,1,'East Timor','TMP','TP'),(62,1,'Ecuador','ECU','EC'),(63,1,'Egypt','EGY','EG'),(64,1,'El Salvador','SLV','SV'),(65,1,'Equatorial Guinea','GNQ','GQ'),(66,1,'Eritrea','ERI','ER'),(67,1,'Estonia','EST','EE'),(68,1,'Ethiopia','ETH','ET'),(69,1,'Falkland Islands (Malvinas)','FLK','FK'),(70,1,'Faroe Islands','FRO','FO'),(71,1,'Fiji','FJI','FJ'),(72,1,'Finland','FIN','FI'),(73,1,'France','FRA','FR'),(74,1,'France, Metropolitan','FXX','FX'),(75,1,'French Guiana','GUF','GF'),(76,1,'French Polynesia','PYF','PF'),(77,1,'French Southern Territories','ATF','TF'),(78,1,'Gabon','GAB','GA'),(79,1,'Gambia','GMB','GM'),(80,1,'Georgia','GEO','GE'),(81,1,'Germany','DEU','DE'),(82,1,'Ghana','GHA','GH'),(83,1,'Gibraltar','GIB','GI'),(84,1,'Greece','GRC','GR'),(85,1,'Greenland','GRL','GL'),(86,1,'Grenada','GRD','GD'),(87,1,'Guadeloupe','GLP','GP'),(88,1,'Guam','GUM','GU'),(89,1,'Guatemala','GTM','GT'),(90,1,'Guinea','GIN','GN'),(91,1,'Guinea-bissau','GNB','GW'),(92,1,'Guyana','GUY','GY'),(93,1,'Haiti','HTI','HT'),(94,1,'Heard and Mc Donald Islands','HMD','HM'),(95,1,'Honduras','HND','HN'),(96,1,'Hong Kong','HKG','HK'),(97,1,'Hungary','HUN','HU'),(98,1,'Iceland','ISL','IS'),(99,1,'India','IND','IN'),(100,1,'Indonesia','IDN','ID'),(101,1,'Iran (Islamic Republic of)','IRN','IR'),(102,1,'Iraq','IRQ','IQ'),(103,1,'Ireland','IRL','IE'),(104,1,'Israel','ISR','IL'),(105,1,'Italy','ITA','IT'),(106,1,'Jamaica','JAM','JM'),(107,1,'Japan','JPN','JP'),(108,1,'Jordan','JOR','JO'),(109,1,'Kazakhstan','KAZ','KZ'),(110,1,'Kenya','KEN','KE'),(111,1,'Kiribati','KIR','KI'),(112,1,'Korea, Democratic People\'s Republic of','PRK','KP'),(113,1,'Korea, Republic of','KOR','KR'),(114,1,'Kuwait','KWT','KW'),(115,1,'Kyrgyzstan','KGZ','KG'),(116,1,'Lao People\'s Democratic Republic','LAO','LA'),(117,1,'Latvia','LVA','LV'),(118,1,'Lebanon','LBN','LB'),(119,1,'Lesotho','LSO','LS'),(120,1,'Liberia','LBR','LR'),(121,1,'Libyan Arab Jamahiriya','LBY','LY'),(122,1,'Liechtenstein','LIE','LI'),(123,1,'Lithuania','LTU','LT'),(124,1,'Luxembourg','LUX','LU'),(125,1,'Macau','MAC','MO'),(126,1,'Macedonia, The Former Yugoslav Republic of','MKD','MK'),(127,1,'Madagascar','MDG','MG'),(128,1,'Malawi','MWI','MW'),(129,1,'Malaysia','MYS','MY'),(130,1,'Maldives','MDV','MV'),(131,1,'Mali','MLI','ML'),(132,1,'Malta','MLT','MT'),(133,1,'Marshall Islands','MHL','MH'),(134,1,'Martinique','MTQ','MQ'),(135,1,'Mauritania','MRT','MR'),(136,1,'Mauritius','MUS','MU'),(137,1,'Mayotte','MYT','YT'),(138,1,'Mexico','MEX','MX'),(139,1,'Micronesia, Federated States of','FSM','FM'),(140,1,'Moldova, Republic of','MDA','MD'),(141,1,'Monaco','MCO','MC'),(142,1,'Mongolia','MNG','MN'),(143,1,'Montserrat','MSR','MS'),(144,1,'Morocco','MAR','MA'),(145,1,'Mozambique','MOZ','MZ'),(146,1,'Myanmar','MMR','MM'),(147,1,'Namibia','NAM','NA'),(148,1,'Nauru','NRU','NR'),(149,1,'Nepal','NPL','NP'),(150,1,'Netherlands','NLD','NL'),(151,1,'Netherlands Antilles','ANT','AN'),(152,1,'New Caledonia','NCL','NC'),(153,1,'New Zealand','NZL','NZ'),(154,1,'Nicaragua','NIC','NI'),(155,1,'Niger','NER','NE'),(156,1,'Nigeria','NGA','NG'),(157,1,'Niue','NIU','NU'),(158,1,'Norfolk Island','NFK','NF'),(159,1,'Northern Mariana Islands','MNP','MP'),(160,1,'Norway','NOR','NO'),(161,1,'Oman','OMN','OM'),(162,1,'Pakistan','PAK','PK'),(163,1,'Palau','PLW','PW'),(164,1,'Panama','PAN','PA'),(165,1,'Papua New Guinea','PNG','PG'),(166,1,'Paraguay','PRY','PY'),(167,1,'Peru','PER','PE'),(168,1,'Philippines','PHL','PH'),(169,1,'Pitcairn','PCN','PN'),(170,1,'Poland','POL','PL'),(171,1,'Portugal','PRT','PT'),(172,1,'Puerto Rico','PRI','PR'),(173,1,'Qatar','QAT','QA'),(174,1,'Reunion','REU','RE'),(175,1,'Romania','ROM','RO'),(176,1,'Russian Federation','RUS','RU'),(177,1,'Rwanda','RWA','RW'),(178,1,'Saint Kitts and Nevis','KNA','KN'),(179,1,'Saint Lucia','LCA','LC'),(180,1,'Saint Vincent and the Grenadines','VCT','VC'),(181,1,'Samoa','WSM','WS'),(182,1,'San Marino','SMR','SM'),(183,1,'Sao Tome and Principe','STP','ST'),(184,1,'Saudi Arabia','SAU','SA'),(185,1,'Senegal','SEN','SN'),(186,1,'Seychelles','SYC','SC'),(187,1,'Sierra Leone','SLE','SL'),(188,1,'Singapore','SGP','SG'),(189,1,'Slovakia (Slovak Republic)','SVK','SK'),(190,1,'Slovenia','SVN','SI'),(191,1,'Solomon Islands','SLB','SB'),(192,1,'Somalia','SOM','SO'),(193,1,'South Africa','ZAF','ZA'),(194,1,'South Georgia and the South Sandwich Islands','SGS','GS'),(195,1,'Spain','ESP','ES'),(196,1,'Sri Lanka','LKA','LK'),(197,1,'St. Helena','SHN','SH'),(198,1,'St. Pierre and Miquelon','SPM','PM'),(199,1,'Sudan','SDN','SD'),(200,1,'Suriname','SUR','SR'),(201,1,'Svalbard and Jan Mayen Islands','SJM','SJ'),(202,1,'Swaziland','SWZ','SZ'),(203,1,'Sweden','SWE','SE'),(204,1,'Switzerland','CHE','CH'),(205,1,'Syrian Arab Republic','SYR','SY'),(206,1,'Taiwan','TWN','TW'),(207,1,'Tajikistan','TJK','TJ'),(208,1,'Tanzania, United Republic of','TZA','TZ'),(209,1,'Thailand','THA','TH'),(210,1,'Togo','TGO','TG'),(211,1,'Tokelau','TKL','TK'),(212,1,'Tonga','TON','TO'),(213,1,'Trinidad and Tobago','TTO','TT'),(214,1,'Tunisia','TUN','TN'),(215,1,'Turkey','TUR','TR'),(216,1,'Turkmenistan','TKM','TM'),(217,1,'Turks and Caicos Islands','TCA','TC'),(218,1,'Tuvalu','TUV','TV'),(219,1,'Uganda','UGA','UG'),(220,1,'Ukraine','UKR','UA'),(221,1,'United Arab Emirates','ARE','AE'),(222,1,'United Kingdom','GBR','GB'),(223,1,'United States','USA','US'),(224,1,'United States Minor Outlying Islands','UMI','UM'),(225,1,'Uruguay','URY','UY'),(226,1,'Uzbekistan','UZB','UZ'),(227,1,'Vanuatu','VUT','VU'),(228,1,'Vatican City State (Holy See)','VAT','VA'),(229,1,'Venezuela','VEN','VE'),(230,1,'Viet Nam','VNM','VN'),(231,1,'Virgin Islands (British)','VGB','VG'),(232,1,'Virgin Islands (U.S.)','VIR','VI'),(233,1,'Wallis and Futuna Islands','WLF','WF'),(234,1,'Western Sahara','ESH','EH'),(235,1,'Yemen','YEM','YE'),(236,1,'Yugoslavia','YUG','YU'),(237,1,'Zaire','ZAR','ZR'),(238,1,'Zambia','ZMB','ZM'),(239,1,'Zimbabwe','ZWE','ZW');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_country` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_coupons`
--
DROP TABLE IF EXISTS `jos_vm_coupons`;
CREATE TABLE `jos_vm_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(12,2) NOT NULL default '0.00',
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store coupon codes';
--
-- Dumping data for table `jos_vm_coupons`
--
/*!40000 ALTER TABLE `jos_vm_coupons` DISABLE KEYS */;
LOCK TABLES `jos_vm_coupons` WRITE;
INSERT INTO `jos_vm_coupons` VALUES (1,'test1','total','gift','6.00'),(2,'test2','percent','permanent','15.00'),(3,'test3','total','permanent','4.00'),(4,'test4','total','gift','15.00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_coupons` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_creditcard`
--
DROP TABLE IF EXISTS `jos_vm_creditcard`;
CREATE TABLE `jos_vm_creditcard` (
`creditcard_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`creditcard_name` varchar(70) NOT NULL default '',
`creditcard_code` varchar(30) NOT NULL default '',
PRIMARY KEY (`creditcard_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store credit card types';
--
-- Dumping data for table `jos_vm_creditcard`
--
/*!40000 ALTER TABLE `jos_vm_creditcard` DISABLE KEYS */;
LOCK TABLES `jos_vm_creditcard` WRITE;
INSERT INTO `jos_vm_creditcard` VALUES (1,1,'Visa','VISA'),(2,1,'MasterCard','MC'),(3,1,'American Express','amex'),(4,1,'Discover Card','discover'),(5,1,'Diners Club','diners'),(6,1,'JCB','jcb'),(7,1,'Australian Bankcard','australian_bc');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_creditcard` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_csv`
--
DROP TABLE IF EXISTS `jos_vm_csv`;
CREATE TABLE `jos_vm_csv` (
`field_id` int(11) NOT NULL auto_increment,
`field_name` varchar(128) NOT NULL default '',
`field_default_value` text,
`field_ordering` int(3) NOT NULL default '0',
`field_required` char(1) default 'N',
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds all fields which are used on CVS Ex-/Import';
--
-- Dumping data for table `jos_vm_csv`
--
/*!40000 ALTER TABLE `jos_vm_csv` DISABLE KEYS */;
LOCK TABLES `jos_vm_csv` WRITE;
INSERT INTO `jos_vm_csv` VALUES (1,'product_sku','',1,'Y'),(2,'product_s_desc','',2,'N'),(3,'product_desc','',3,'N'),(4,'product_thumb_image','',4,'N'),(5,'product_full_image','',5,'N'),(6,'product_weight','',6,'N'),(7,'product_weight_uom','KG',7,'N'),(8,'product_length','',8,'N'),(9,'product_width','',9,'N'),(10,'product_height','',10,'N'),(11,'product_lwh_uom','',11,'N'),(12,'product_in_stock','0',12,'N'),(13,'product_available_date','',13,'N'),(14,'product_discount_id','',14,'N'),(15,'product_name','',15,'Y'),(16,'product_price','',16,'N'),(17,'category_path','',17,'Y'),(18,'manufacturer_id','',18,'N'),(19,'product_tax_id','',19,'N'),(20,'product_sales','',20,'N'),(21,'product_parent_id','0',21,'N'),(22,'attribute','',22,'N'),(23,'custom_attribute','',23,'N'),(24,'attributes','',24,'N'),(25,'attribute_values','',25,'N');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_csv` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_currency`
--
DROP TABLE IF EXISTS `jos_vm_currency`;
CREATE TABLE `jos_vm_currency` (
`currency_id` int(11) NOT NULL auto_increment,
`currency_name` varchar(64) default NULL,
`currency_code` char(3) default NULL,
PRIMARY KEY (`currency_id`),
KEY `idx_currency_name` (`currency_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store currencies';
--
-- Dumping data for table `jos_vm_currency`
--
/*!40000 ALTER TABLE `jos_vm_currency` DISABLE KEYS */;
LOCK TABLES `jos_vm_currency` WRITE;
INSERT INTO `jos_vm_currency` VALUES (1,'Andorran Peseta','ADP'),(2,'United Arab Emirates Dirham','AED'),(3,'Afghanistan Afghani','AFA'),(4,'Albanian Lek','ALL'),(5,'Netherlands Antillian Guilder','ANG'),(6,'Angolan Kwanza','AOK'),(7,'Argentinian Austral','ARA'),(9,'Australian Dollar','AUD'),(10,'Aruban Florin','AWG'),(11,'Barbados Dollar','BBD'),(12,'Bangladeshi Taka','BDT'),(14,'Bulgarian Lev','BGL'),(15,'Bahraini Dinar','BHD'),(16,'Burundi Franc','BIF'),(17,'Bermudian Dollar','BMD'),(18,'Brunei Dollar','BND'),(19,'Bolivian Boliviano','BOB'),(20,'Brazilian Real','BRL'),(21,'Bahamian Dollar','BSD'),(22,'Bhutan Ngultrum','BTN'),(23,'Burma Kyat','BUK'),(24,'Botswanian Pula','BWP'),(25,'Belize Dollar','BZD'),(26,'Canadian Dollar','CAD'),(27,'Swiss Franc','CHF'),(28,'Chilean Unidades de Fomento','CLF'),(29,'Chilean Peso','CLP'),(30,'Yuan (Chinese) Renminbi','CNY'),(31,'Colombian Peso','COP'),(32,'Costa Rican Colon','CRC'),(33,'Czech Koruna','CZK'),(34,'Cuban Peso','CUP'),(35,'Cape Verde Escudo','CVE'),(36,'Cyprus Pound','CYP'),(40,'Danish Krone','DKK'),(41,'Dominican Peso','DOP'),(42,'Algerian Dinar','DZD'),(43,'Ecuador Sucre','ECS'),(44,'Egyptian Pound','EGP'),(46,'Ethiopian Birr','ETB'),(47,'Euro','EUR'),(49,'Fiji Dollar','FJD'),(50,'Falkland Islands Pound','FKP'),(52,'British Pound','GBP'),(53,'Ghanaian Cedi','GHC'),(54,'Gibraltar Pound','GIP'),(55,'Gambian Dalasi','GMD'),(56,'Guinea Franc','GNF'),(58,'Guatemalan Quetzal','GTQ'),(59,'Guinea-Bissau Peso','GWP'),(60,'Guyanan Dollar','GYD'),(61,'Hong Kong Dollar','HKD'),(62,'Honduran Lempira','HNL'),(63,'Haitian Gourde','HTG'),(64,'Hungarian Forint','HUF'),(65,'Indonesian Rupiah','IDR'),(66,'Irish Punt','IEP'),(67,'Israeli Shekel','ILS'),(68,'Indian Rupee','INR'),(69,'Iraqi Dinar','IQD'),(70,'Iranian Rial','IRR'),(73,'Jamaican Dollar','JMD'),(74,'Jordanian Dinar','JOD'),(75,'Japanese Yen','JPY'),(76,'Kenyan Schilling','KES'),(77,'Kampuchean (Cambodian) Riel','KHR'),(78,'Comoros Franc','KMF'),(79,'North Korean Won','KPW'),(80,'(South) Korean Won','KRW'),(81,'Kuwaiti Dinar','KWD'),(82,'Cayman Islands Dollar','KYD'),(83,'Lao Kip','LAK'),(84,'Lebanese Pound','LBP'),(85,'Sri Lanka Rupee','LKR'),(86,'Liberian Dollar','LRD'),(87,'Lesotho Loti','LSL'),(89,'Libyan Dinar','LYD'),(90,'Moroccan Dirham','MAD'),(91,'Malagasy Franc','MGF'),(92,'Mongolian Tugrik','MNT'),(93,'Macau Pataca','MOP'),(94,'Mauritanian Ouguiya','MRO'),(95,'Maltese Lira','MTL'),(96,'Mauritius Rupee','MUR'),(97,'Maldive Rufiyaa','MVR'),(98,'Malawi Kwacha','MWK'),(99,'Mexican Peso','MXP'),(100,'Malaysian Ringgit','MYR'),(101,'Mozambique Metical','MZM'),(102,'Nigerian Naira','NGN'),(103,'Nicaraguan Cordoba','NIC'),(105,'Norwegian Kroner','NOK'),(106,'Nepalese Rupee','NPR'),(107,'New Zealand Dollar','NZD'),(108,'Omani Rial','OMR'),(109,'Panamanian Balboa','PAB'),(110,'Peruvian Inti','PEI'),(111,'Papua New Guinea Kina','PGK'),(112,'Philippine Peso','PHP'),(113,'Pakistan Rupee','PKR'),(114,'Polish Zloty','PLZ'),(116,'Paraguay Guarani','PYG'),(117,'Qatari Rial','QAR'),(118,'Romanian Leu','ROL'),(119,'Rwanda Franc','RWF'),(120,'Saudi Arabian Riyal','SAR'),(121,'Solomon Islands Dollar','SBD'),(122,'Seychelles Rupee','SCR'),(123,'Sudanese Pound','SDP'),(124,'Swedish Krona','SEK'),(125,'Singapore Dollar','SGD'),(126,'St. Helena Pound','SHP'),(127,'Sierra Leone Leone','SLL'),(128,'Somali Schilling','SOS'),(129,'Suriname Guilder','SRG'),(130,'Sao Tome and Principe Dobra','STD'),(131,'Russian Ruble','SUR'),(132,'El Salvador Colon','SVC'),(133,'Syrian Potmd','SYP'),(134,'Swaziland Lilangeni','SZL'),(135,'Thai Bath','THB'),(136,'Tunisian Dinar','TND'),(137,'Tongan Pa\'anga','TOP'),(138,'East Timor Escudo','TPE'),(139,'Turkish Lira','TRL'),(140,'Trinidad and Tobago Dollar','TTD'),(141,'Taiwan Dollar','TWD'),(142,'Tanzanian Schilling','TZS'),(143,'Uganda Shilling','UGS'),(144,'US Dollar','USD'),(145,'Uruguayan Peso','UYP'),(146,'Venezualan Bolivar','VEB'),(147,'Vietnamese Dong','VND'),(148,'Vanuatu Vatu','VUV'),(149,'Samoan Tala','WST'),(150,'Democratic Yemeni Dinar','YDD'),(151,'Yemeni Rial','YER'),(152,'New Yugoslavia Dinar','YUD'),(153,'South African Rand','ZAR'),(154,'Zambian Kwacha','ZMK'),(155,'Zaire Zaire','ZRZ'),(156,'Zimbabwe Dollar','ZWD'),(157,'Slovak Koruna','SKK');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_currency` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_function`
--
DROP TABLE IF EXISTS `jos_vm_function`;
CREATE TABLE `jos_vm_function` (
`function_id` int(11) NOT NULL auto_increment,
`module_id` int(11) default NULL,
`function_name` varchar(32) default NULL,
`function_class` varchar(32) default NULL,
`function_method` varchar(32) default NULL,
`function_description` text,
`function_perms` varchar(255) default NULL,
PRIMARY KEY (`function_id`),
KEY `idx_function_module_id` (`module_id`),
KEY `idx_function_name` (`function_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to map a function alias to a ''real'' class::function';
--
-- Dumping data for table `jos_vm_function`
--
/*!40000 ALTER TABLE `jos_vm_function` DISABLE KEYS */;
LOCK TABLES `jos_vm_function` WRITE;
INSERT INTO `jos_vm_function` VALUES (1,1,'userAdd','ps_user','add','','admin,storeadmin'),(2,1,'userDelete','ps_user','delete','','admin,storeadmin'),(3,1,'userUpdate','ps_user','update','','admin,storeadmin'),(4,1,'adminPasswdUpdate','ps_user','update_admin_passwd','Updates Site Administrator Password','admin'),(31,2,'productAdd','ps_product','add','','admin,storeadmin'),(6,1,'functionAdd','ps_function','add','','admin'),(7,1,'functionUpdate','ps_function','update','','admin'),(8,1,'functionDelete','ps_function','delete','','admin'),(9,1,'userLogout','ps_user','logout','','none'),(10,1,'userAddressAdd','ps_user_address','add','','admin,storeadmin,shopper,demo'),(11,1,'userAddressUpdate','ps_user_address','update','','admin,storeadmin,shopper'),(12,1,'userAddressDelete','ps_user_address','delete','','admin,storeadmin,shopper'),(13,1,'moduleAdd','ps_module','add','','admin'),(14,1,'moduleUpdate','ps_module','update','','admin'),(15,1,'moduleDelete','ps_module','delete','','admin'),(16,1,'userLogin','ps_user','login','','none'),(17,3,'vendorAdd','ps_vendor','add','','admin'),(18,3,'vendorUpdate','ps_vendor','update','','admin,storeadmin'),(19,3,'vendorDelete','ps_vendor','delete','','admin'),(20,3,'vendorCategoryAdd','ps_vendor_category','add','','admin'),(21,3,'vendorCategoryUpdate','ps_vendor_category','update','','admin'),(22,3,'vendorCategoryDelete','ps_vendor_category','delete','','admin'),(23,4,'shopperAdd','ps_shopper','add','','none'),(24,4,'shopperDelete','ps_shopper','delete','','admin,storeadmin'),(25,4,'shopperUpdate','ps_shopper','update','','admin,storeadmin,shopper'),(26,4,'shopperGroupAdd','ps_shopper_group','add','','admin,storeadmin'),(27,4,'shopperGroupUpdate','ps_shopper_group','update','','admin,storeadmin'),(28,4,'shopperGroupDelete','ps_shopper_group','delete','','admin,storeadmin'),(29,5,'orderSearch','ps_order','find','','admin,storeadmin,demo'),(30,5,'orderStatusSet','ps_order','order_status_update','','admin,storeadmin'),(32,2,'productDelete','ps_product','delete','','admin,storeadmin'),(33,2,'productUpdate','ps_product','update','','admin,storeadmin'),(34,2,'productCategoryAdd','ps_product_category','add','','admin,storeadmin'),(35,2,'productCategoryUpdate','ps_product_category','update','','admin,storeadmin'),(36,2,'productCategoryDelete','ps_product_category','delete','','admin,storeadmin'),(37,2,'productPriceAdd','ps_product_price','add','','admin,storeadmin'),(38,2,'productPriceUpdate','ps_product_price','update','','admin,storeadmin'),(39,2,'productPriceDelete','ps_product_price','delete','','admin,storeadmin'),(40,2,'productAttributeAdd','ps_product_attribute','add','','admin,storeadmin'),(41,2,'productAttributeUpdate','ps_product_attribute','update','','admin,storeadmin'),(42,2,'productAttributeDelete','ps_product_attribute','delete','','admin,storeadmin'),(43,7,'cartAdd','ps_cart','add','','none'),(44,7,'cartUpdate','ps_cart','update','','none'),(45,7,'cartDelete','ps_cart','delete','','none'),(46,10,'checkoutComplete','ps_checkout','add','','shopper,storeadmin,admin'),(47,1,'setLanguage','ps_module','set_language','','none'),(48,8,'paymentMethodUpdate','ps_payment_method','update','','admin,storeadmin'),(49,8,'paymentMethodAdd','ps_payment_method','add','','admin,storeadmin'),(50,8,'paymentMethodDelete','ps_payment_method','delete','','admin,storeadmin'),(51,5,'orderDelete','ps_order','delete','','admin,storeadmin'),(52,11,'addTaxRate','ps_tax','add','','admin,storeadmin'),(53,11,'updateTaxRate','ps_tax','update','','admin,storeadmin'),(54,11,'deleteTaxRate','ps_tax','delete','','admin,storeadmin'),(55,10,'checkoutValidateST','ps_checkout','validate_shipto','','none'),(59,5,'orderStatusUpdate','ps_order_status','update','','admin,storeadmin'),(60,5,'orderStatusAdd','ps_order_status','add','','storeadmin,admin'),(61,5,'orderStatusDelete','ps_order_status','delete','','admin,storeadmin'),(62,1,'currencyAdd','ps_currency','add','add a currency','storeadmin,admin'),(63,1,'currencyUpdate','ps_currency','update',' update a currency','storeadmin,admin'),(64,1,'currencyDelete','ps_currency','delete','delete a currency','storeadmin,admin'),(65,1,'countryAdd','ps_country','add','Add a country ','storeadmin,admin'),(66,1,'countryUpdate','ps_country','update','Update a country record','storeadmin,admin'),(67,1,'countryDelete','ps_country','delete','Delete a country record','storeadmin,admin'),(68,2,'product_csv','ps_csv','upload_csv','','admin'),(110,7,'waitingListAdd','zw_waiting_list','add','','none'),(111,13,'addzone','ps_zone','add','This will add a zone','admin,storeadmin'),(112,13,'updatezone','ps_zone','update','This will update a zone','admin,storeadmin'),(113,13,'deletezone','ps_zone','delete','This will delete a zone','admin,storeadmin'),(114,13,'zoneassign','ps_zone','assign','This will assign a country to a zone','admin,storeadmin'),(115,1,'writeConfig','ps_config','writeconfig','This will write the configuration details to phpshop.cfg.php','admin'),(116,12839,'carrierAdd','ps_shipping','add','','admin,storeadmin'),(117,12839,'carrierDelete','ps_shipping','delete','','admin,storeadmin'),(118,12839,'carrierUpdate','ps_shipping','update','','admin,storeadmin'),(119,12839,'rateAdd','ps_shipping','rate_add','','admin,storeadmin'),(120,12839,'rateUpdate','ps_shipping','rate_update','','admin,shopadmin'),(121,12839,'rateDelete','ps_shipping','rate_delete','','admin,storeadmin'),(122,10,'checkoutProcess','ps_checkout','process','','shopper,storeadmin,admin,demo'),(123,5,'downloadRequest','ps_order','download_request','This checks if the download request is valid and sends the file to the browser as file download if the request was successful, otherwise echoes an error','admin,storeadmin,shopper'),(124,98,'affiliateAdd','ps_affiliate','add','','admin,storeadmin'),(125,98,'affiliateUpdate','ps_affiliate','update','','admin,storeadmin'),(126,98,'affiliateDelete','ps_affiliate','delete','','admin,storeadmin'),(127,98,'affiliateEmail','ps_affiliate','email','','admin,storeadmin'),(128,99,'manufacturerAdd','ps_manufacturer','add','','admin,storeadmin'),(129,99,'manufacturerUpdate','ps_manufacturer','update','','admin,storeadmin'),(130,99,'manufacturerDelete','ps_manufacturer','delete','','admin,storeadmin'),(131,99,'manufacturercategoryAdd','ps_manufacturer_category','add','','admin,storeadmin'),(132,99,'manufacturercategoryUpdate','ps_manufacturer_category','update','','admin,storeadmin'),(133,99,'manufacturercategoryDelete','ps_manufacturer_category','delete','','admin,storeadmin'),(134,7,'addReview','ps_reviews','process_review','This lets the user add a review and rating to a product.','admin,storeadmin,shopper,demo'),(135,7,'productReviewDelete','ps_reviews','delete_review','This deletes a review and from a product.','admin,storeadmin'),(136,8,'creditcardAdd','ps_creditcard','add','Adds a Credit Card entry.','admin,storeadmin'),(137,8,'creditcardUpdate','ps_creditcard','update','Updates a Credit Card entry.','admin,storeadmin'),(138,8,'creditcardDelete','ps_creditcard','delete','Deletes a Credit Card entry.','admin,storeadmin'),(139,2,'changePublishState','vmAbstractObject.class','handlePublishState','Changes the publish field, so that a record can be published or unpublished easily.','admin,storeadmin'),(140,2,'export_csv','ps_csv','export_csv','This function exports all relevant product data to CSV.','admin,storeadmin'),(141,2,'reorder','ps_product_category','reorder','Changes the list order of a category.','admin,storeadmin'),(142,2,'discountAdd','ps_product_discount','add','Adds a discount.','admin,storeadmin'),(143,2,'discountUpdate','ps_product_discount','update','Updates a discount.','admin,storeadmin'),(144,2,'discountDelete','ps_product_discount','delete','Deletes a discount.','admin,storeadmin'),(145,8,'shippingmethodSave','ps_shipping_method','save','','admin,storeadmin'),(146,2,'uploadProductFile','ps_product_files','add','Uploads and Adds a Product Image/File.','admin,storeadmin'),(147,2,'updateProductFile','ps_product_files','update','Updates a Product Image/File.','admin,storeadmin'),(148,2,'deleteProductFile','ps_product_files','delete','Deletes a Product Image/File.','admin,storeadmin'),(149,12843,'couponAdd','ps_coupon','add_coupon_code','Adds a Coupon.','admin,storeadmin'),(150,12843,'couponUpdate','ps_coupon','update_coupon','Updates a Coupon.','admin,storeadmin'),(151,12843,'couponDelete','ps_coupon','remove_coupon_code','Deletes a Coupon.','admin,storeadmin'),(152,12843,'couponProcess','ps_coupon','process_coupon_code','Processes a Coupon.','admin,storeadmin,shopper,demo'),(153,2,'ProductTypeAdd','ps_product_type','add','Function add a Product Type and create new table product_type_.','admin'),(154,2,'ProductTypeUpdate','ps_product_type','update','Update a Product Type.','admin'),(155,2,'ProductTypeDelete','ps_product_type','delete','Delete a Product Type and drop table product_type_.','admin'),(156,2,'ProductTypeReorder','ps_product_type','reorder','Changes the list order of a Product Type.','admin'),(157,2,'ProductTypeAddParam','ps_product_type_parameter','add_parameter','Function add a Parameter into a Product Type and create new column in table product_type_.','admin'),(158,2,'ProductTypeUpdateParam','ps_product_type_parameter','update_parameter','Function update a Parameter in a Product Type and a column in table product_type_.','admin'),(159,2,'ProductTypeDeleteParam','ps_product_type_parameter','delete_parameter','Function delete a Parameter from a Product Type and drop a column in table product_type_.','admin'),(160,2,'ProductTypeReorderParam','ps_product_type_parameter','reorder_parameter','Changes the list order of a Parameter.','admin'),(161,2,'productProductTypeAdd','ps_product_product_type','add','Add a Product into a Product Type.','admin,storeadmin'),(162,2,'productProductTypeDelete','ps_product_product_type','delete','Delete a Product from a Product Type.','admin,storeadmin'),(163,1,'stateAdd','ps_country','addState','Add a State ','storeadmin,admin'),(164,1,'stateUpdate','ps_country','updateState','Update a state record','storeadmin,admin'),(165,1,'stateDelete','ps_country','deleteState','Delete a state record','storeadmin,admin'),(166,2,'csvFieldAdd','ps_csv','add','Add a CSV Field ','storeadmin,admin'),(167,2,'csvFieldUpdate','ps_csv','update','Update a CSV Field','storeadmin,admin'),(168,2,'csvFieldDelete','ps_csv','delete','Delete a CSV Field','storeadmin,admin');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_function` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_manufacturer`
--
DROP TABLE IF EXISTS `jos_vm_manufacturer`;
CREATE TABLE `jos_vm_manufacturer` (
`manufacturer_id` int(11) NOT NULL auto_increment,
`mf_name` varchar(64) default NULL,
`mf_email` varchar(255) default NULL,
`mf_desc` text,
`mf_category_id` int(11) default NULL,
`mf_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Manufacturers are those who create products';
--
-- Dumping data for table `jos_vm_manufacturer`
--
/*!40000 ALTER TABLE `jos_vm_manufacturer` DISABLE KEYS */;
LOCK TABLES `jos_vm_manufacturer` WRITE;
INSERT INTO `jos_vm_manufacturer` VALUES (1,'Manufacturer','info@manufacturer.com','An example for a manufacturer',1,'http://www.a-url.com');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_manufacturer` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_manufacturer_category`
--
DROP TABLE IF EXISTS `jos_vm_manufacturer_category`;
CREATE TABLE `jos_vm_manufacturer_category` (
`mf_category_id` int(11) NOT NULL auto_increment,
`mf_category_name` varchar(64) default NULL,
`mf_category_desc` text,
PRIMARY KEY (`mf_category_id`),
KEY `idx_manufacturer_category_category_name` (`mf_category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Manufactorers are assigned to these categories';
--
-- Dumping data for table `jos_vm_manufacturer_category`
--
/*!40000 ALTER TABLE `jos_vm_manufacturer_category` DISABLE KEYS */;
LOCK TABLES `jos_vm_manufacturer_category` WRITE;
INSERT INTO `jos_vm_manufacturer_category` VALUES (1,'-default-','This is the default manufacturer category');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_manufacturer_category` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_module`
--
DROP TABLE IF EXISTS `jos_vm_module`;
CREATE TABLE `jos_vm_module` (
`module_id` int(11) NOT NULL auto_increment,
`module_name` varchar(255) default NULL,
`module_description` text,
`module_perms` varchar(255) default NULL,
`module_publish` char(1) default NULL,
`list_order` int(11) default NULL,
PRIMARY KEY (`module_id`),
KEY `idx_module_name` (`module_name`),
KEY `idx_module_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='VirtueMart Core Modules, not: Joomla modules';
--
-- Dumping data for table `jos_vm_module`
--
/*!40000 ALTER TABLE `jos_vm_module` DISABLE KEYS */;
LOCK TABLES `jos_vm_module` WRITE;
INSERT INTO `jos_vm_module` VALUES (1,'admin','
ADMINISTRATIVE USERS ONLY
\r\n\r\n
Only used for the following:
\r\n\r\n\r\n
User Maintenance
\r\n
Module Maintenance
\r\n
Function Maintenance
\r\n\r\n','admin','Y',1),(2,'product','
Here you can adminster your online catalog of products. The Product Administrator allows you to create product categories, create new products, edit product attributes, and add product items for each attribute value.
','storeadmin,admin','Y',4),(3,'vendor','
ADMINISTRATIVE USERS ONLY
\r\n
Here you can manage the vendors on the phpShop system.
','admin','Y',6),(4,'shopper','
Manage shoppers in your store. Allows you to create shopper groups. Shopper groups can be used when setting the price for a product. This allows you to create different prices for different types of users. An example of this would be to have a \'wholesale\' group and a \'retail\' group.
','admin,storeadmin','Y',4),(5,'order','
View Order and Update Order Status.
','admin,storeadmin','Y',5),(6,'msgs','This module is unprotected an used for displaying system messages to users. We need to have an area that does not require authorization when things go wrong.','none','N',99),(7,'shop','This is the Washupito store module. This is the demo store included with the phpShop distribution.','none','Y',99),(8,'store','','storeadmin,admin','Y',2),(9,'account','This module allows shoppers to update their account information and view previously placed orders.','shopper,storeadmin,admin,demo','N',99),(10,'checkout','','none','N',99),(11,'tax','The tax module allows you to set tax rates for states or regions within a country. The rate is set as a decimal figure. For example, 2 percent tax would be 0.02.','admin,storeadmin','Y',8),(12,'reportbasic','The report basic module allows you to do queries on all orders.','admin,storeadmin','Y',7),(13,'zone','This is the zone-shipping module. Here you can manage your shipping costs according to Zones.','admin,storeadmin','N',9),(12839,'shipping','
Shipping
Let this module calculate the shipping fees for your customers. Create carriers for shipping areas and weight groups.
','admin,storeadmin','Y',10),(98,'affiliate','administrate the affiliates on your store.','storeadmin,admin','N',99),(99,'manufacturer','Manage the manufacturers of products in your store.','storeadmin,admin','Y',12),(12842,'help','Help Module','admin,storeadmin','Y',13),(12843,'coupon','Coupon Management','admin,storeadmin','Y',11);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_module` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_order_history`
--
DROP TABLE IF EXISTS `jos_vm_order_history`;
CREATE TABLE `jos_vm_order_history` (
`order_status_history_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`order_status_code` char(1) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`customer_notified` int(1) default '0',
`comments` text,
PRIMARY KEY (`order_status_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all actions and changes that occur to an order';
--
-- Dumping data for table `jos_vm_order_history`
--
/*!40000 ALTER TABLE `jos_vm_order_history` DISABLE KEYS */;
LOCK TABLES `jos_vm_order_history` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_order_history` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_order_item`
--
DROP TABLE IF EXISTS `jos_vm_order_item`;
CREATE TABLE `jos_vm_order_item` (
`order_item_id` int(11) NOT NULL auto_increment,
`order_id` int(11) default NULL,
`user_info_id` varchar(32) default NULL,
`vendor_id` int(11) default NULL,
`product_id` int(11) default NULL,
`order_item_sku` varchar(64) NOT NULL default '',
`order_item_name` varchar(64) NOT NULL default '',
`product_quantity` int(11) default NULL,
`product_item_price` decimal(15,5) default NULL,
`product_final_price` decimal(12,2) NOT NULL default '0.00',
`order_item_currency` varchar(16) default NULL,
`order_status` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`product_attribute` text,
PRIMARY KEY (`order_item_id`),
KEY `idx_order_item_order_id` (`order_id`),
KEY `idx_order_item_user_info_id` (`user_info_id`),
KEY `idx_order_item_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all items (products) which are part of an order';
--
-- Dumping data for table `jos_vm_order_item`
--
/*!40000 ALTER TABLE `jos_vm_order_item` DISABLE KEYS */;
LOCK TABLES `jos_vm_order_item` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_order_item` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_order_payment`
--
DROP TABLE IF EXISTS `jos_vm_order_payment`;
CREATE TABLE `jos_vm_order_payment` (
`order_id` int(11) NOT NULL default '0',
`payment_method_id` int(11) default NULL,
`order_payment_code` varchar(30) NOT NULL default '',
`order_payment_number` blob,
`order_payment_expire` int(11) default NULL,
`order_payment_name` varchar(255) default NULL,
`order_payment_log` text,
`order_payment_trans_id` text NOT NULL,
KEY `idx_order_payment_order_id` (`order_id`),
KEY `idx_order_payment_method_id` (`payment_method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The payment method that was chosen for a specific order';
--
-- Dumping data for table `jos_vm_order_payment`
--
/*!40000 ALTER TABLE `jos_vm_order_payment` DISABLE KEYS */;
LOCK TABLES `jos_vm_order_payment` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_order_payment` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_order_status`
--
DROP TABLE IF EXISTS `jos_vm_order_status`;
CREATE TABLE `jos_vm_order_status` (
`order_status_id` int(11) NOT NULL auto_increment,
`order_status_code` char(1) NOT NULL default '',
`order_status_name` varchar(64) default NULL,
`list_order` int(11) default NULL,
`vendor_id` int(11) default NULL,
PRIMARY KEY (`order_status_id`),
KEY `idx_order_status_list_order` (`list_order`),
KEY `idx_order_status_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='All available order statuses';
--
-- Dumping data for table `jos_vm_order_status`
--
/*!40000 ALTER TABLE `jos_vm_order_status` DISABLE KEYS */;
LOCK TABLES `jos_vm_order_status` WRITE;
INSERT INTO `jos_vm_order_status` VALUES (1,'P','Pending',1,1),(2,'C','Confirmed',2,1),(3,'X','Cancelled',3,1),(4,'R','Refunded',4,1),(5,'S','Shipped',5,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_order_status` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_order_user_info`
--
DROP TABLE IF EXISTS `jos_vm_order_user_info`;
CREATE TABLE `jos_vm_order_user_info` (
`order_info_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`address_type` char(2) default NULL,
`address_type_name` varchar(32) default NULL,
`company` varchar(64) default NULL,
`title` varchar(32) default NULL,
`last_name` varchar(32) default NULL,
`first_name` varchar(32) default NULL,
`middle_name` varchar(32) default NULL,
`phone_1` varchar(32) default NULL,
`phone_2` varchar(32) default NULL,
`fax` varchar(32) default NULL,
`address_1` varchar(64) NOT NULL default '',
`address_2` varchar(64) default NULL,
`city` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default 'US',
`zip` varchar(32) NOT NULL default '',
`user_email` varchar(255) default NULL,
`extra_field_1` varchar(255) default NULL,
`extra_field_2` varchar(255) default NULL,
`extra_field_3` varchar(255) default NULL,
`extra_field_4` char(1) default NULL,
`extra_field_5` char(1) default NULL,
`bank_account_nr` varchar(32) NOT NULL default '',
`bank_name` varchar(32) NOT NULL default '',
`bank_sort_code` varchar(16) NOT NULL default '',
`bank_iban` varchar(64) NOT NULL default '',
`bank_account_holder` varchar(48) NOT NULL default '',
`bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL default 'Checking',
PRIMARY KEY (`order_info_id`),
KEY `idx_order_info_order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the BillTo and ShipTo Information at order time';
--
-- Dumping data for table `jos_vm_order_user_info`
--
/*!40000 ALTER TABLE `jos_vm_order_user_info` DISABLE KEYS */;
LOCK TABLES `jos_vm_order_user_info` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_order_user_info` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_orders`
--
DROP TABLE IF EXISTS `jos_vm_orders`;
CREATE TABLE `jos_vm_orders` (
`order_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`vendor_id` int(11) NOT NULL default '0',
`order_number` varchar(32) default NULL,
`user_info_id` varchar(32) default NULL,
`order_total` decimal(15,2) NOT NULL default '0.00',
`order_subtotal` decimal(15,5) default NULL,
`order_tax` decimal(10,2) default NULL,
`order_tax_details` text NOT NULL,
`order_shipping` decimal(10,2) default NULL,
`order_shipping_tax` decimal(10,2) default NULL,
`coupon_discount` decimal(12,2) NOT NULL default '0.00',
`order_discount` decimal(12,2) NOT NULL default '0.00',
`order_currency` varchar(16) default NULL,
`order_status` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`ship_method_id` varchar(255) default NULL,
`customer_note` text NOT NULL,
`ip_address` varchar(15) NOT NULL default '',
PRIMARY KEY (`order_id`),
KEY `idx_orders_user_id` (`user_id`),
KEY `idx_orders_vendor_id` (`vendor_id`),
KEY `idx_orders_order_number` (`order_number`),
KEY `idx_orders_user_info_id` (`user_info_id`),
KEY `idx_orders_ship_method_id` (`ship_method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store all orders';
--
-- Dumping data for table `jos_vm_orders`
--
/*!40000 ALTER TABLE `jos_vm_orders` DISABLE KEYS */;
LOCK TABLES `jos_vm_orders` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_orders` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_payment_method`
--
DROP TABLE IF EXISTS `jos_vm_payment_method`;
CREATE TABLE `jos_vm_payment_method` (
`payment_method_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) default NULL,
`payment_method_name` varchar(255) default NULL,
`payment_class` varchar(50) NOT NULL default '',
`shopper_group_id` int(11) default NULL,
`payment_method_discount` decimal(12,2) default NULL,
`list_order` int(11) default NULL,
`payment_method_code` varchar(8) default NULL,
`enable_processor` char(1) default NULL,
`is_creditcard` tinyint(1) NOT NULL default '0',
`payment_enabled` char(1) NOT NULL default 'N',
`accepted_creditcards` varchar(128) NOT NULL default '',
`payment_extrainfo` text NOT NULL,
`payment_passkey` blob NOT NULL,
PRIMARY KEY (`payment_method_id`),
KEY `idx_payment_method_vendor_id` (`vendor_id`),
KEY `idx_payment_method_name` (`payment_method_name`),
KEY `idx_payment_method_list_order` (`list_order`),
KEY `idx_payment_method_shopper_group_id` (`shopper_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The payment methods of your store';
--
-- Dumping data for table `jos_vm_payment_method`
--
/*!40000 ALTER TABLE `jos_vm_payment_method` DISABLE KEYS */;
LOCK TABLES `jos_vm_payment_method` WRITE;
INSERT INTO `jos_vm_payment_method` VALUES (1,1,'Purchase Order','',6,'0.00',4,'PO','N',0,'Y','','',''),(2,1,'Cash On Delivery','',5,'-2.00',5,'COD','N',0,'Y','','',''),(3,1,'Credit Card','ps_authorize',5,'0.00',0,'AN','Y',0,'Y','1,2,6,7,','',''),(4,1,'PayPal','ps_paypal',5,'0.00',0,'PP','P',0,'Y','','\nf(\"order_tax\") + $db->f(\"order_shipping_tax\");\n$post_variables = Array(\n\"cmd\" => \"_xclick\",\n\"business\" => PAYPAL_EMAIL,\n\"receiver_email\" => PAYPAL_EMAIL,\n\"item_name\" => $VM_LANG->_PHPSHOP_ORDER_PRINT_PO_NUMBER.\": \". $db->f(\"order_id\"),\n\"order_id\" => $db->f(\"order_id\"),\n\"invoice\" => $db->f(\"order_number\"),\n\"amount\" => round( $db->f(\"order_subtotal\")+$tax_total, 2),\n\"shipping\" => sprintf(\"%.2f\", $db->f(\"order_shipping\")),\n\"currency_code\" => $_SESSION[\'vendor_currency\'],\n\"image_url\" => $vendor_image_url,\n\"return\" => SECUREURL .\"index.php?option=com_virtuemart&page=checkout.result&order_id=\".$db->f(\"order_id\"),\n\"notify_url\" => SECUREURL .\"administrator/components/com_virtuemart/notify.php\",\n\"cancel_return\" => SECUREURL .\"index.php\",\n\"undefined_quantity\" => \"0\",\n\"test_ipn\" => PAYPAL_DEBUG,\n\"pal\" => \"NRUBJXESJTY24\",\n\"no_shipping\" => \"1\",\n\"no_note\" => \"1\"\n);\nif( $page == \"checkout.thankyou\" ) {\n$query_string = \"?\";\nforeach( $post_variables as $name => $value ) {\n$query_string .= $name. \"=\" . urlencode($value) .\"&\";\n}\nmosRedirect( $url . $query_string );\n} else {\n\necho \'\';\n\n}\n?>',''),(5,1,'PayMate','ps_paymate',5,'0.00',0,'PM','P',0,'N','','\n
You haven\'t configured any terms of service yet. Click here to change this text.
','http://virtuemart.net','0.00','0.00','1|$|2|.| |2|1');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_vendor` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_vendor_category`
--
DROP TABLE IF EXISTS `jos_vm_vendor_category`;
CREATE TABLE `jos_vm_vendor_category` (
`vendor_category_id` int(11) NOT NULL auto_increment,
`vendor_category_name` varchar(64) default NULL,
`vendor_category_desc` text,
PRIMARY KEY (`vendor_category_id`),
KEY `idx_vendor_category_category_name` (`vendor_category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The categories that vendors are assigned to';
--
-- Dumping data for table `jos_vm_vendor_category`
--
/*!40000 ALTER TABLE `jos_vm_vendor_category` DISABLE KEYS */;
LOCK TABLES `jos_vm_vendor_category` WRITE;
INSERT INTO `jos_vm_vendor_category` VALUES (6,'-default-','Default');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_vendor_category` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_visit`
--
DROP TABLE IF EXISTS `jos_vm_visit`;
CREATE TABLE `jos_vm_visit` (
`visit_id` varchar(255) NOT NULL default '',
`affiliate_id` int(11) NOT NULL default '0',
`pages` int(11) NOT NULL default '0',
`entry_page` varchar(255) NOT NULL default '',
`exit_page` varchar(255) NOT NULL default '',
`sdate` int(11) NOT NULL default '0',
`edate` int(11) NOT NULL default '0',
PRIMARY KEY (`visit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Records the visit of an affiliate';
--
-- Dumping data for table `jos_vm_visit`
--
/*!40000 ALTER TABLE `jos_vm_visit` DISABLE KEYS */;
LOCK TABLES `jos_vm_visit` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_visit` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_waiting_list`
--
DROP TABLE IF EXISTS `jos_vm_waiting_list`;
CREATE TABLE `jos_vm_waiting_list` (
`waiting_list_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`notify_email` varchar(150) NOT NULL default '',
`notified` enum('0','1') default '0',
`notify_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`waiting_list_id`),
KEY `product_id` (`product_id`),
KEY `notify_email` (`notify_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores notifications, users waiting f. products out of stock';
--
-- Dumping data for table `jos_vm_waiting_list`
--
/*!40000 ALTER TABLE `jos_vm_waiting_list` DISABLE KEYS */;
LOCK TABLES `jos_vm_waiting_list` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_waiting_list` ENABLE KEYS */;
--
-- Table structure for table `jos_vm_zone_shipping`
--
DROP TABLE IF EXISTS `jos_vm_zone_shipping`;
CREATE TABLE `jos_vm_zone_shipping` (
`zone_id` int(11) NOT NULL auto_increment,
`zone_name` varchar(255) default NULL,
`zone_cost` decimal(10,2) default NULL,
`zone_limit` decimal(10,2) default NULL,
`zone_description` text NOT NULL,
`zone_tax_rate` int(11) NOT NULL default '0',
PRIMARY KEY (`zone_id`),
KEY `zone_id` (`zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The Zones managed by the Zone Shipping Module';
--
-- Dumping data for table `jos_vm_zone_shipping`
--
/*!40000 ALTER TABLE `jos_vm_zone_shipping` DISABLE KEYS */;
LOCK TABLES `jos_vm_zone_shipping` WRITE;
INSERT INTO `jos_vm_zone_shipping` VALUES (1,'Default','6.00','35.00','This is the default Shipping Zone. This is the zone information that all countries will use until you assign each individual country to a Zone.',2),(2,'Zone 1','1000.00','10000.00','This is a zone example',2),(3,'Zone 2','2.00','22.00','This is the second zone. You can use this for notes about this zone',2),(4,'Zone 3','11.00','64.00','Another usefull thing might be details about this zone or special instructions.',2);
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_vm_zone_shipping` ENABLE KEYS */;
--
-- Table structure for table `jos_weblinks`
--
DROP TABLE IF EXISTS `jos_weblinks`;
CREATE TABLE `jos_weblinks` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`url` varchar(250) NOT NULL default '',
`description` varchar(250) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`archived` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '1',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_weblinks`
--
/*!40000 ALTER TABLE `jos_weblinks` DISABLE KEYS */;
LOCK TABLES `jos_weblinks` WRITE;
INSERT INTO `jos_weblinks` VALUES (1,2,0,'Joomla!','http://www.joomla.org','Home of Joomla!','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'),(2,2,0,'php.net','http://www.php.net','The language that Joomla! is developed in','2004-07-07 11:33:24',0,1,0,'0000-00-00 00:00:00',3,0,1,''),(3,2,0,'MySQL','http://www.mysql.com','The database that Joomla! uses','2004-07-07 10:18:31',0,1,0,'0000-00-00 00:00:00',5,0,1,''),(4,2,0,'OpenSourceMatters','http://www.opensourcematters.org','Home of OSM','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'),(5,2,0,'Joomla! - Forums','http://forum.joomla.org','Joomla! Forums','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0');
UNLOCK TABLES;
/*!40000 ALTER TABLE `jos_weblinks` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
![](\"components/com_letterman/letterman.gif\")
![\"Pay](\"https://www.paymate.com.au/homepage/images/butt_PayNow.gif\")
\n