-- MySQL dump 10.9 -- -- Host: localhost Database: audarya -- ------------------------------------------------------ -- Server version 4.1.20-standard /*!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,MYSQL40' */; /*!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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_banner` -- /*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */; LOCK TABLES `jos_banner` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_bannerclient` -- /*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */; LOCK TABLES `jos_bannerclient` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_categories` -- /*!40000 ALTER TABLE `jos_categories` DISABLE KEYS */; LOCK TABLES `jos_categories` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- 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.6\nDEV_STATUS=stable'),(21,'Site Backup','option=com_babackup',0,0,'','Site Backup','com_babackup',0,'js/ThemeOffice/config.png',0,''),(22,'View Backups','',0,21,'option=com_babackup&task=show','View Backups','com_babackup',0,'js/ThemeOffice/preview.png',0,''),(23,'View BD Backups','',0,21,'option=com_babackup&task=showdb','View BD Backups','com_babackup',1,'js/ThemeOffice/db.png',0,''),(24,'Create Backup','',0,21,'option=com_babackup&task=confirm','Create Backup','com_babackup',2,'js/ThemeOffice/backup.png',0,''),(25,'Credits','',0,21,'option=com_babackup&task=credits','Credits','com_babackup',3,'js/ThemeOffice/users.png',0,''); 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_contact_details` -- /*!40000 ALTER TABLE `jos_contact_details` DISABLE KEYS */; LOCK TABLES `jos_contact_details` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_content` -- /*!40000 ALTER TABLE `jos_content` DISABLE KEYS */; LOCK TABLES `jos_content` WRITE; 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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_content_frontpage` -- /*!40000 ALTER TABLE `jos_content_frontpage` DISABLE KEYS */; LOCK TABLES `jos_content_frontpage` WRITE; 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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM; -- -- 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`) ) TYPE=MyISAM; -- -- 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' ) TYPE=MyISAM; -- -- 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' ) TYPE=MyISAM; -- -- 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`) ) TYPE=MyISAM; -- -- 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_mambots` -- DROP TABLE IF EXISTS `jos_mambots`; CREATE TABLE `jos_mambots` ( `id` int(11) NOT NULL, `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`) ) TYPE=MyISAM; -- -- 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,'mosproductsnap','mosproductsnap','content',0,0,0,0,0,0,'0000-00-00 00:00:00',''),(21,'ProductSearchBot','virtuemart.searchbot','search',0,0,0,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, `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`) ) TYPE=MyISAM; -- -- 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',-2,0,10,0,0,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','Movies','index.php?option=com_content&task=category§ionid=1&id=1','content_category',-2,0,1,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(3,'mainmenu','Books','index.php?option=com_content&task=category§ionid=1&id=2','content_category',-2,0,2,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(4,'mainmenu','Temples','index.php?option=com_content&task=category§ionid=1&id=3','content_category',-2,0,3,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(5,'mainmenu','Music','index.php?option=com_content&task=category§ionid=1&id=4','content_category',-2,0,4,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(6,'mainmenu','Traditional Music','index.php?option=com_content&task=category§ionid=1&id=4','content_category',-2,0,4,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(7,'mainmenu','Modern Music','index.php?option=com_content&task=category§ionid=1&id=5','content_category',-2,0,5,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(8,'mainmenu','Temple construction','index.php?option=com_content&task=category§ionid=1&id=3','content_category',-2,0,3,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(9,'mainmenu','Book Publications','index.php?option=com_content&task=category§ionid=1&id=2','content_category',-2,0,2,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(10,'mainmenu','Movie Productions','index.php?option=com_content&task=category§ionid=1&id=1','content_category',-2,0,1,0,0,0,'0000-00-00 00:00:00',0,0,0,0,''),(11,'topmenu','Nominate','index.php?option=com_content&task=new§ionid=2','submit_content',1,0,2,0,1,0,'0000-00-00 00:00:00',0,0,2,0,'menu_image=-1'); 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, `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`) ) TYPE=MyISAM; -- -- 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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM; -- -- 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','',1,'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',0,'mod_mainmenu',0,0,1,'menutype=mainmenu',1,0),(4,'Login Form','',5,'left',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,0),(5,'Syndicate','',7,'left',0,'0000-00-00 00:00:00',1,'mod_rssfeed',0,0,1,'',1,0),(6,'Latest News','',4,'user1',0,'0000-00-00 00:00:00',1,'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','',1,'right',0,'0000-00-00 00:00:00',1,'mod_whosonline',0,0,1,'online=1\nusers=1\nmoduleclass_sfx=',0,0),(9,'Popular','',6,'user2',0,'0000-00-00 00:00:00',1,'mod_mostread',0,0,1,'',0,0),(10,'Template Chooser','',8,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),(11,'Archive','',9,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),(12,'Sections','',10,'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',1,'mod_newsflash',0,0,1,'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=',0,0),(14,'Related Items','',11,'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','',9,'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',1,'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','',12,'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','',1,'left',62,'2006-07-25 18:58:36',1,'mod_product_categories',0,0,0,'menutype=dtree\njscook_type=tree\njscookMenu_style=ThemeOffice\nmenu_orientation=hbr\njscookTree_style=ThemeXP\nroot_label=Categories\nmoduleclass_sfx=\nclass_sfx=',0,0),(34,'Product Scroller','',21,'left',0,'0000-00-00 00:00:00',0,'mod_productscroller',0,0,1,'',0,0),(35,'VirtueMart Module','',20,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart',0,0,1,'',0,0),(36,'All-In-One New/Featured/TopTen/Random Products Module','',19,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_allinone',0,0,1,'',0,0),(37,'Your Cart Module','',18,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_cart',0,0,1,'',0,0),(38,'Featured Products','',17,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_featureprod',0,0,1,'',0,0),(39,'Latest products','',16,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_latestprod',0,0,1,'',0,0),(40,'Manufacturer Module','',15,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_manufacturers',0,0,1,'',0,0),(41,'Random Products Module','',14,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_randomprod',0,0,1,'',0,0),(42,'VirtueMart Search Module','',13,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_search',0,0,1,'',0,0),(43,'VirtueMart TopTen products Module','',22,'left',0,'0000-00-00 00:00:00',0,'mod_virtuemart_topten',0,0,1,'',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`) ) TYPE=MyISAM; -- -- 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,0),(35,0),(36,0),(37,0),(38,0),(39,0),(40,0),(41,0),(42,0),(43,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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_newsfeeds` -- /*!40000 ALTER TABLE `jos_newsfeeds` DISABLE KEYS */; LOCK TABLES `jos_newsfeeds` WRITE; 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, `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)) ) TYPE=MyISAM; -- -- Dumping data for table `jos_poll_data` -- /*!40000 ALTER TABLE `jos_poll_data` DISABLE KEYS */; LOCK TABLES `jos_poll_data` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- 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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_poll_menu` -- /*!40000 ALTER TABLE `jos_poll_menu` DISABLE KEYS */; LOCK TABLES `jos_poll_menu` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_polls` -- /*!40000 ALTER TABLE `jos_polls` DISABLE KEYS */; LOCK TABLES `jos_polls` WRITE; 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, `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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_sections` -- /*!40000 ALTER TABLE `jos_sections` DISABLE KEYS */; LOCK TABLES `jos_sections` WRITE; INSERT INTO `jos_sections` VALUES (2,'Top links','Top links','','content','left','',1,0,'0000-00-00 00:00:00',1,0,0,'imagefolders=*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`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_session` -- /*!40000 ALTER TABLE `jos_session` DISABLE KEYS */; LOCK TABLES `jos_session` WRITE; INSERT INTO `jos_session` VALUES ('admin','1153860517','3b2e70a716c6b3de3eb604d5ae86649b',1,62,'Super Administrator',0),('admin','1153858892','4663de0f2e5046b40314465dad9f26a1',0,62,'Super Administrator',2); 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' ) TYPE=MyISAM; -- -- 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, `position` varchar(10) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM; -- -- 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`) ) TYPE=MyISAM; -- -- 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 ('joomla_admin',0,1),('audaryaaward',0,0); 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, `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`) ) TYPE=MyISAM; -- -- 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','imlitala@mac.com','e4ddc8ecdc001a7510e7b9db15db0abc','Super Administrator',0,1,25,'2006-07-25 15:18:22','2006-07-26 01:44:40','','expired=\nexpired_time='); 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`) ) TYPE=MyISAM; -- -- 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, `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`) ) TYPE=MyISAM 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`) ) TYPE=MyISAM 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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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; INSERT INTO `jos_vm_category` VALUES (1,1,'Movie Production','','','','Y',1153833487,1153833487,'browse_1',1,'shop.flypage',1),(2,1,'Book Publication','','','','Y',1153833505,1153833505,'browse_1',1,'shop.flypage',2),(3,1,'Temple construction','','','','Y',1153833527,1153833527,'browse_1',1,'shop.flypage',3),(4,1,'Traditional Music','','','','Y',1153833542,1153833542,'browse_1',1,'shop.flypage',4),(5,1,'Modern Music','','','','Y',1153833555,1153833555,'browse_1',1,'shop.flypage',5),(6,1,'Vaishnava community','','','','Y',1153833573,1153833573,'browse_1',1,'shop.flypage',6),(7,1,'Drama Presentation','','','','Y',1153833588,1153833588,'browse_1',1,'shop.flypage',7),(8,1,'Dham seva','','','','Y',1153833610,1153833648,'browse_1',1,'shop.flypage',8),(9,1,'Vaishnava Journal','','','','Y',1153833635,1153833635,'browse_1',1,'shop.flypage',9),(10,1,'Art contribution','','','','Y',1153833677,1153833677,'browse_1',1,'shop.flypage',10),(11,1,'Innovative Preaching','','','','Y',1153833697,1153833697,'browse_1',1,'shop.flypage',11),(12,1,'Vaishnava charity','','','','Y',1153833736,1153833736,'browse_1',1,'shop.flypage',12),(13,1,'Effort for Vaishnava Unity','','','','Y',1153833762,1153833762,'browse_1',1,'shop.flypage',13),(14,1,'Applied Ecology','','','','Y',1153833791,1153833791,'browse_1',1,'shop.flypage',14),(15,1,'Distributor of Vaishnava literature','','','','Y',1153833810,1153833810,'browse_1',1,'shop.flypage',15); 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`) ) TYPE=MyISAM 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; INSERT INTO `jos_vm_category_xref` VALUES (0,1,NULL),(0,2,NULL),(0,3,NULL),(0,4,NULL),(0,5,NULL),(0,6,NULL),(0,7,NULL),(0,8,NULL),(0,9,NULL),(0,10,NULL),(0,11,NULL),(0,12,NULL),(0,13,NULL),(0,14,NULL),(0,15,NULL); 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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; 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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, `currency_name` varchar(64) default NULL, `currency_code` char(3) default NULL, PRIMARY KEY (`currency_id`), KEY `idx_currency_name` (`currency_name`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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 of an item, so that it 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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
  1. User Maintenance
    2. \r\n
  2. Module Maintenance
    3. \r\n
  3. Function Maintenance
    4. \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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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, `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`) ) TYPE=MyISAM 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$discount_total = $db->f(\"coupon_discount\") + $db->f(\"order_discount\");\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-$discount_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 \'
\';\necho \'\';\n\nforeach( $post_variables as $name => $value ) {\necho \'\';\n}\n\necho \'
\';\n\n}\n?>',''),(5,1,'PayMate','ps_paymate',5,'0.00',0,'PM','P',0,'N','','\n ',''),(6,1,'WorldPay','ps_worldpay',5,'0.00',0,'WP','P',0,'N','','
\n \n \" />\n f(\"order_id\") ?>\" />\n f(\"order_total\") ?>\" />\n \" />\n \n email?>\" />\n address_1?> address_2?> city?> state?>\" />\n title?>first_name?>. middle_name?>last_name?>\" />\n country?>\"/>\n zip?>\" />\n phone_1?>\">\n \n
\n \n
',''),(7,1,'2Checkout','ps_twocheckout',5,'0.00',0,'2CO','P',0,'N','','f(\"user_info_id\").\"\'\"; \n $dbbt = new ps_DB;\n $dbbt->setQuery($q);\n $dbbt->query();\n $dbbt->next_record(); \n // Get ship_to information\n if( $db->f(\"user_info_id\") != $dbbt->f(\"user_info_id\")) {\n $q2 = \"SELECT * FROM #__vm_user_info WHERE user_info_id=\'\".$db->f(\"user_info_id\").\"\'\"; \n $dbst = new ps_DB;\n $dbst->setQuery($q2);\n $dbst->query();\n $dbst->next_record();\n }\n else {\n $dbst = $dbbt;\n }\n \n //Authnet vars to send\n $formdata = array (\n \'x_login\' => TWOCO_LOGIN,\n \'x_email_merchant\' => ((TWOCO_MERCHANT_EMAIL == \'True\') ? \'TRUE\' : \'FALSE\'),\n \n // Customer Name and Billing Address\n \'x_first_name\' => $dbbt->f(\"first_name\"),\n \'x_last_name\' => $dbbt->f(\"last_name\"),\n \'x_company\' => $dbbt->f(\"company\"),\n \'x_address\' => $dbbt->f(\"address_1\"),\n \'x_city\' => $dbbt->f(\"city\"),\n \'x_state\' => $dbbt->f(\"state\"),\n \'x_zip\' => $dbbt->f(\"zip\"),\n \'x_country\' => $dbbt->f(\"country\"),\n \'x_phone\' => $dbbt->f(\"phone_1\"),\n \'x_fax\' => $dbbt->f(\"fax\"),\n \'x_email\' => $dbbt->f(\"email\"),\n \n // Customer Shipping Address\n \'x_ship_to_first_name\' => $dbst->f(\"first_name\"),\n \'x_ship_to_last_name\' => $dbst->f(\"last_name\"),\n \'x_ship_to_company\' => $dbst->f(\"company\"),\n \'x_ship_to_address\' => $dbst->f(\"address_1\"),\n \'x_ship_to_city\' => $dbst->f(\"city\"),\n \'x_ship_to_state\' => $dbst->f(\"state\"),\n \'x_ship_to_zip\' => $dbst->f(\"zip\"),\n \'x_ship_to_country\' => $dbst->f(\"country\"),\n \n \'x_invoice_num\' => $db->f(\"order_number\"),\n \'x_receipt_link_url\' => SECUREURL.\"2checkout_notify.php\"\n );\n \n if( TWOCO_TESTMODE == \"Y\" )\n $formdata[\'demo\'] = \"Y\";\n \n $version = \"2\";\n $url = \"https://www2.2checkout.com/2co/buyer/purchase\";\n $formdata[\'x_amount\'] = number_format($db->f(\"order_total\"), 2, \'.\', \'\');\n \n //build the post string\n $poststring = \'\';\n foreach($formdata AS $key => $val){\n $poststring .= \"\n \";\n }\n \n ?>\n
\" method=\"post\" target=\"_blank\">\n \n

Click on the Image below to pay...

\n \n
',''),(8,1,'NoChex','ps_nochex',5,'0.00',0,'NOCHEX','P',0,'N','','
\n \" />\n f(\"order_total\"))?>\" />\n p(\"order_id\") ?>\" />\n \" />\n f(\"order_id\") ?>\" />\n \n
',''),(9,1,'Credit Card (PayMeNow)','ps_paymenow',5,'0.00',0,'PN','Y',0,'N','1,2,3,','',''),(10,1,'eWay','ps_eway',5,'0.00',0,'EW','Y',0,'N','','',''),(11,1,'eCheck.net','ps_echeck',5,'0.00',0,'ECK','B',0,'N','','',''),(12,1,'Credit Card (eProcessingNetwork)','ps_epn',5,'0.00',0,'EPN','Y',0,'N','1,2,3,','',''),(13,1,'iKobo','',5,'0.00',0,'IK','P',0,'N','','
\n Click on the image below to Pay with iKobo\n \n \n p(\"order_id\") ?>\" /> \n f(\"order_total\"))?>\" /> \n first_name?>\" /> \n last_name?>\" /> \n address_1?> address_2?>\" /> \n city?>\" /> \n state?>\" /> \n zip?>\" /> \n phone_1?>\" /> \n email?>\" /> \n
>',''),(14,1,'iTransact','',5,'0.00',0,'ITR','P',0,'N','','f(\"order_total\");$first_name = $user->first_name;$last_name = $user->last_name;$address = $user->address_1;$city = $user->city;$state = $user->state;$zip = $user->zip;$country = $user->country;$email = $user->email;$phone = $user->phone_1;$home_page = $mosConfig_live_site.\"/index.php\";$ret_addr = $mosConfig_live_site.\"/index.php\";$cc_payment_image = $mosConfig_live_site.\"/components/com_virtuemart/shop_image/ps_image/cc_payment.jpg\";\n ?>\n
\n \" />\n \" />\n \" />\n \" />\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \" />\n \n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n \" />\n

\" />

\n
',''),(15,1,'Dankort / PBS','ps_pbs',5,'0.00',0,'PBS','P',0,'N','','',''),(16,1,'Verisign PayFlow Pro','ps_pfp',5,'0.00',0,'PFP','Y',0,'Y','1,2,6,7,','',''); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_payment_method` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product` -- DROP TABLE IF EXISTS `jos_vm_product`; CREATE TABLE `jos_vm_product` ( `product_id` int(11) NOT NULL, `vendor_id` int(11) NOT NULL default '0', `product_parent_id` int(11) NOT NULL default '0', `product_sku` varchar(64) NOT NULL default '', `product_s_desc` varchar(255) default NULL, `product_desc` text, `product_thumb_image` varchar(255) default NULL, `product_full_image` varchar(255) default NULL, `product_publish` char(1) default NULL, `product_weight` decimal(10,4) default NULL, `product_weight_uom` varchar(32) default 'pounds.', `product_length` decimal(10,4) default NULL, `product_width` decimal(10,4) default NULL, `product_height` decimal(10,4) default NULL, `product_lwh_uom` varchar(32) default 'inches', `product_url` varchar(255) default NULL, `product_in_stock` int(11) default NULL, `product_available_date` int(11) default NULL, `product_availability` varchar(56) NOT NULL default '', `product_special` char(1) default NULL, `product_discount_id` int(11) default NULL, `ship_code_id` int(11) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `product_name` varchar(64) default NULL, `product_sales` int(11) NOT NULL default '0', `attribute` text, `custom_attribute` text NOT NULL, `product_tax_id` tinyint(2) NOT NULL default '0', `product_unit` varchar(32) default NULL, `product_packaging` int(11) default NULL, PRIMARY KEY (`product_id`), KEY `idx_product_vendor_id` (`vendor_id`), KEY `idx_product_product_parent_id` (`product_parent_id`), KEY `idx_product_sku` (`product_sku`), KEY `idx_product_ship_code_id` (`ship_code_id`), KEY `idx_product_name` (`product_name`) ) TYPE=MyISAM COMMENT='All products are stored here.'; -- -- Dumping data for table `jos_vm_product` -- /*!40000 ALTER TABLE `jos_vm_product` DISABLE KEYS */; LOCK TABLES `jos_vm_product` WRITE; INSERT INTO `jos_vm_product` VALUES (1,1,0,'asdfasd','asdfasdfasdfasdf','','','','Y','0.0000','pounds','0.0000','0.0000','0.0000','inches','',0,-19800,'','N',0,NULL,1153837235,1153837235,'adsfsadf',0,'','',2,'piece',0); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_attribute` -- DROP TABLE IF EXISTS `jos_vm_product_attribute`; CREATE TABLE `jos_vm_product_attribute` ( `product_id` int(11) NOT NULL default '0', `attribute_name` char(255) NOT NULL default '', `attribute_value` char(255) NOT NULL default '', KEY `idx_product_attribute_product_id` (`product_id`), KEY `idx_product_attribute_name` (`attribute_name`) ) TYPE=MyISAM COMMENT='Stores attributes + their specific values for Child Products'; -- -- Dumping data for table `jos_vm_product_attribute` -- /*!40000 ALTER TABLE `jos_vm_product_attribute` DISABLE KEYS */; LOCK TABLES `jos_vm_product_attribute` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_attribute` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_attribute_sku` -- DROP TABLE IF EXISTS `jos_vm_product_attribute_sku`; CREATE TABLE `jos_vm_product_attribute_sku` ( `product_id` int(11) NOT NULL default '0', `attribute_name` char(255) NOT NULL default '', `attribute_list` int(11) NOT NULL default '0', KEY `idx_product_attribute_sku_product_id` (`product_id`), KEY `idx_product_attribute_sku_attribute_name` (`attribute_name`), KEY `idx_product_attribute_list` (`attribute_list`) ) TYPE=MyISAM COMMENT='Attributes for a Parent Product used by its Child Products'; -- -- Dumping data for table `jos_vm_product_attribute_sku` -- /*!40000 ALTER TABLE `jos_vm_product_attribute_sku` DISABLE KEYS */; LOCK TABLES `jos_vm_product_attribute_sku` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_attribute_sku` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_category_xref` -- DROP TABLE IF EXISTS `jos_vm_product_category_xref`; CREATE TABLE `jos_vm_product_category_xref` ( `category_id` int(11) NOT NULL default '0', `product_id` int(11) NOT NULL default '0', `product_list` int(11) default NULL, KEY `idx_product_category_xref_category_id` (`category_id`), KEY `idx_product_category_xref_product_id` (`product_id`), KEY `idx_product_category_xref_product_list` (`product_list`) ) TYPE=MyISAM COMMENT='Maps Products to Categories'; -- -- Dumping data for table `jos_vm_product_category_xref` -- /*!40000 ALTER TABLE `jos_vm_product_category_xref` DISABLE KEYS */; LOCK TABLES `jos_vm_product_category_xref` WRITE; INSERT INTO `jos_vm_product_category_xref` VALUES (1,1,NULL); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_category_xref` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_discount` -- DROP TABLE IF EXISTS `jos_vm_product_discount`; CREATE TABLE `jos_vm_product_discount` ( `discount_id` int(11) NOT NULL, `amount` decimal(12,2) NOT NULL default '0.00', `is_percent` tinyint(1) NOT NULL default '0', `start_date` int(11) NOT NULL default '0', `end_date` int(11) NOT NULL default '0', PRIMARY KEY (`discount_id`) ) TYPE=MyISAM COMMENT='Discounts that can be assigned to products'; -- -- Dumping data for table `jos_vm_product_discount` -- /*!40000 ALTER TABLE `jos_vm_product_discount` DISABLE KEYS */; LOCK TABLES `jos_vm_product_discount` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_discount` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_download` -- DROP TABLE IF EXISTS `jos_vm_product_download`; CREATE TABLE `jos_vm_product_download` ( `product_id` int(11) NOT NULL default '0', `user_id` int(11) NOT NULL default '0', `order_id` int(11) NOT NULL default '0', `end_date` int(11) NOT NULL default '0', `download_max` int(11) NOT NULL default '0', `download_id` varchar(32) NOT NULL default '', `file_name` varchar(255) NOT NULL default '', PRIMARY KEY (`download_id`) ) TYPE=MyISAM COMMENT='Active downloads for selling downloadable goods'; -- -- Dumping data for table `jos_vm_product_download` -- /*!40000 ALTER TABLE `jos_vm_product_download` DISABLE KEYS */; LOCK TABLES `jos_vm_product_download` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_download` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_files` -- DROP TABLE IF EXISTS `jos_vm_product_files`; CREATE TABLE `jos_vm_product_files` ( `file_id` int(19) NOT NULL, `file_product_id` int(11) NOT NULL default '0', `file_name` varchar(128) NOT NULL default '', `file_title` varchar(128) NOT NULL default '', `file_description` mediumtext NOT NULL, `file_extension` varchar(128) NOT NULL default '', `file_mimetype` varchar(64) NOT NULL default '', `file_url` varchar(254) NOT NULL default '', `file_published` tinyint(1) NOT NULL default '0', `file_is_image` tinyint(1) NOT NULL default '0', `file_image_height` int(11) NOT NULL default '0', `file_image_width` int(11) NOT NULL default '0', `file_image_thumb_height` int(11) NOT NULL default '50', `file_image_thumb_width` int(11) NOT NULL default '0', PRIMARY KEY (`file_id`) ) TYPE=MyISAM COMMENT='Additional Images and Files which are assigned to products'; -- -- Dumping data for table `jos_vm_product_files` -- /*!40000 ALTER TABLE `jos_vm_product_files` DISABLE KEYS */; LOCK TABLES `jos_vm_product_files` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_files` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_mf_xref` -- DROP TABLE IF EXISTS `jos_vm_product_mf_xref`; CREATE TABLE `jos_vm_product_mf_xref` ( `product_id` int(11) default NULL, `manufacturer_id` int(11) default NULL, KEY `idx_product_mf_xref_product_id` (`product_id`), KEY `idx_product_mf_xref_manufacturer_id` (`manufacturer_id`) ) TYPE=MyISAM COMMENT='Maps a product to a manufacturer'; -- -- Dumping data for table `jos_vm_product_mf_xref` -- /*!40000 ALTER TABLE `jos_vm_product_mf_xref` DISABLE KEYS */; LOCK TABLES `jos_vm_product_mf_xref` WRITE; INSERT INTO `jos_vm_product_mf_xref` VALUES (1,1); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_mf_xref` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_price` -- DROP TABLE IF EXISTS `jos_vm_product_price`; CREATE TABLE `jos_vm_product_price` ( `product_price_id` int(11) NOT NULL, `product_id` int(11) NOT NULL default '0', `product_price` decimal(12,5) default NULL, `product_currency` char(16) default NULL, `product_price_vdate` int(11) default NULL, `product_price_edate` int(11) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `shopper_group_id` int(11) default NULL, `price_quantity_start` int(11) unsigned NOT NULL default '0', `price_quantity_end` int(11) unsigned NOT NULL default '0', PRIMARY KEY (`product_price_id`), KEY `idx_product_price_product_id` (`product_id`), KEY `idx_product_price_shopper_group_id` (`shopper_group_id`) ) TYPE=MyISAM COMMENT='Holds price records for a product'; -- -- Dumping data for table `jos_vm_product_price` -- /*!40000 ALTER TABLE `jos_vm_product_price` DISABLE KEYS */; LOCK TABLES `jos_vm_product_price` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_price` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_product_type_xref` -- DROP TABLE IF EXISTS `jos_vm_product_product_type_xref`; CREATE TABLE `jos_vm_product_product_type_xref` ( `product_id` int(11) NOT NULL default '0', `product_type_id` int(11) NOT NULL default '0', KEY `idx_product_product_type_xref_product_id` (`product_id`), KEY `idx_product_product_type_xref_product_type_id` (`product_type_id`) ) TYPE=MyISAM COMMENT='Maps products to a product type'; -- -- Dumping data for table `jos_vm_product_product_type_xref` -- /*!40000 ALTER TABLE `jos_vm_product_product_type_xref` DISABLE KEYS */; LOCK TABLES `jos_vm_product_product_type_xref` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_product_type_xref` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_relations` -- DROP TABLE IF EXISTS `jos_vm_product_relations`; CREATE TABLE `jos_vm_product_relations` ( `product_id` int(11) NOT NULL default '0', `related_products` text, PRIMARY KEY (`product_id`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_vm_product_relations` -- /*!40000 ALTER TABLE `jos_vm_product_relations` DISABLE KEYS */; LOCK TABLES `jos_vm_product_relations` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_relations` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_reviews` -- DROP TABLE IF EXISTS `jos_vm_product_reviews`; CREATE TABLE `jos_vm_product_reviews` ( `product_id` varchar(255) NOT NULL default '', `comment` text NOT NULL, `userid` int(11) NOT NULL default '0', `time` int(11) NOT NULL default '0', `user_rating` tinyint(1) NOT NULL default '0', `review_ok` int(11) NOT NULL default '0', `review_votes` int(11) NOT NULL default '0' ) TYPE=MyISAM; -- -- Dumping data for table `jos_vm_product_reviews` -- /*!40000 ALTER TABLE `jos_vm_product_reviews` DISABLE KEYS */; LOCK TABLES `jos_vm_product_reviews` WRITE; INSERT INTO `jos_vm_product_reviews` VALUES ('1','mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,mnnvvhv,hv,jhvgj,hg,jhg,jhg,',62,1153858649,5,0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_reviews` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_type` -- DROP TABLE IF EXISTS `jos_vm_product_type`; CREATE TABLE `jos_vm_product_type` ( `product_type_id` int(11) NOT NULL, `product_type_name` varchar(255) NOT NULL default '', `product_type_description` text, `product_type_publish` char(1) default NULL, `product_type_browsepage` varchar(255) default NULL, `product_type_flypage` varchar(255) default NULL, `product_type_list_order` int(11) default NULL, PRIMARY KEY (`product_type_id`) ) TYPE=MyISAM; -- -- Dumping data for table `jos_vm_product_type` -- /*!40000 ALTER TABLE `jos_vm_product_type` DISABLE KEYS */; LOCK TABLES `jos_vm_product_type` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_type` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_type_parameter` -- DROP TABLE IF EXISTS `jos_vm_product_type_parameter`; CREATE TABLE `jos_vm_product_type_parameter` ( `product_type_id` int(11) NOT NULL default '0', `parameter_name` varchar(255) NOT NULL default '', `parameter_label` varchar(255) NOT NULL default '', `parameter_description` text, `parameter_list_order` int(11) NOT NULL default '0', `parameter_type` char(1) NOT NULL default 'T', `parameter_values` varchar(255) default NULL, `parameter_multiselect` char(1) default NULL, `parameter_default` varchar(255) default NULL, `parameter_unit` varchar(32) default NULL, PRIMARY KEY (`product_type_id`,`parameter_name`), KEY `idx_product_type_parameter_product_type_id` (`product_type_id`), KEY `idx_product_type_parameter_parameter_order` (`parameter_list_order`) ) TYPE=MyISAM COMMENT='Parameters which are part of a product type'; -- -- Dumping data for table `jos_vm_product_type_parameter` -- /*!40000 ALTER TABLE `jos_vm_product_type_parameter` DISABLE KEYS */; LOCK TABLES `jos_vm_product_type_parameter` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_type_parameter` ENABLE KEYS */; -- -- Table structure for table `jos_vm_product_votes` -- DROP TABLE IF EXISTS `jos_vm_product_votes`; CREATE TABLE `jos_vm_product_votes` ( `product_id` int(255) NOT NULL default '0', `votes` text NOT NULL, `allvotes` int(11) NOT NULL default '0', `rating` tinyint(1) NOT NULL default '0', `lastip` varchar(50) NOT NULL default '0' ) TYPE=MyISAM COMMENT='Stores all votes for a product'; -- -- Dumping data for table `jos_vm_product_votes` -- /*!40000 ALTER TABLE `jos_vm_product_votes` DISABLE KEYS */; LOCK TABLES `jos_vm_product_votes` WRITE; INSERT INTO `jos_vm_product_votes` VALUES (1,'5',1,5,'127.0.0.1'); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_product_votes` ENABLE KEYS */; -- -- Table structure for table `jos_vm_shipping_carrier` -- DROP TABLE IF EXISTS `jos_vm_shipping_carrier`; CREATE TABLE `jos_vm_shipping_carrier` ( `shipping_carrier_id` int(11) NOT NULL, `shipping_carrier_name` char(80) NOT NULL default '', `shipping_carrier_list_order` int(11) NOT NULL default '0', PRIMARY KEY (`shipping_carrier_id`) ) TYPE=MyISAM COMMENT='Shipping Carriers as used by the Standard Shipping Module'; -- -- Dumping data for table `jos_vm_shipping_carrier` -- /*!40000 ALTER TABLE `jos_vm_shipping_carrier` DISABLE KEYS */; LOCK TABLES `jos_vm_shipping_carrier` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_shipping_carrier` ENABLE KEYS */; -- -- Table structure for table `jos_vm_shipping_rate` -- DROP TABLE IF EXISTS `jos_vm_shipping_rate`; CREATE TABLE `jos_vm_shipping_rate` ( `shipping_rate_id` int(11) NOT NULL, `shipping_rate_name` varchar(255) NOT NULL default '', `shipping_rate_carrier_id` int(11) NOT NULL default '0', `shipping_rate_country` text NOT NULL, `shipping_rate_zip_start` varchar(32) NOT NULL default '', `shipping_rate_zip_end` varchar(32) NOT NULL default '', `shipping_rate_weight_start` decimal(10,3) NOT NULL default '0.000', `shipping_rate_weight_end` decimal(10,3) NOT NULL default '0.000', `shipping_rate_value` decimal(10,2) NOT NULL default '0.00', `shipping_rate_package_fee` decimal(10,2) NOT NULL default '0.00', `shipping_rate_currency_id` int(11) NOT NULL default '0', `shipping_rate_vat_id` int(11) NOT NULL default '0', `shipping_rate_list_order` int(11) NOT NULL default '0', PRIMARY KEY (`shipping_rate_id`) ) TYPE=MyISAM COMMENT='Shipping Rates, used by the Standard Shipping Module'; -- -- Dumping data for table `jos_vm_shipping_rate` -- /*!40000 ALTER TABLE `jos_vm_shipping_rate` DISABLE KEYS */; LOCK TABLES `jos_vm_shipping_rate` WRITE; UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_shipping_rate` ENABLE KEYS */; -- -- Table structure for table `jos_vm_shopper_group` -- DROP TABLE IF EXISTS `jos_vm_shopper_group`; CREATE TABLE `jos_vm_shopper_group` ( `shopper_group_id` int(11) NOT NULL, `vendor_id` int(11) default NULL, `shopper_group_name` varchar(32) default NULL, `shopper_group_desc` text, `shopper_group_discount` decimal(5,2) NOT NULL default '0.00', `show_price_including_tax` tinyint(1) NOT NULL default '1', `default` tinyint(1) NOT NULL default '0', PRIMARY KEY (`shopper_group_id`), KEY `idx_shopper_group_vendor_id` (`vendor_id`), KEY `idx_shopper_group_name` (`shopper_group_name`) ) TYPE=MyISAM COMMENT='Shopper Groups that users can be assigned to'; -- -- Dumping data for table `jos_vm_shopper_group` -- /*!40000 ALTER TABLE `jos_vm_shopper_group` DISABLE KEYS */; LOCK TABLES `jos_vm_shopper_group` WRITE; INSERT INTO `jos_vm_shopper_group` VALUES (5,1,'-default-','This is the default shopper group.','0.00',1,1),(6,1,'Gold Level','Gold Level phpShoppers.','0.00',1,0),(7,1,'Wholesale','Shoppers that can buy at wholesale.','0.00',0,0); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_shopper_group` ENABLE KEYS */; -- -- Table structure for table `jos_vm_shopper_vendor_xref` -- DROP TABLE IF EXISTS `jos_vm_shopper_vendor_xref`; CREATE TABLE `jos_vm_shopper_vendor_xref` ( `user_id` int(11) default NULL, `vendor_id` int(11) default NULL, `shopper_group_id` int(11) default NULL, `customer_number` varchar(32) default NULL, KEY `idx_shopper_vendor_xref_user_id` (`user_id`), KEY `idx_shopper_vendor_xref_vendor_id` (`vendor_id`), KEY `idx_shopper_vendor_xref_shopper_group_id` (`shopper_group_id`) ) TYPE=MyISAM COMMENT='Maps a user to a Shopper Group of a Vendor'; -- -- Dumping data for table `jos_vm_shopper_vendor_xref` -- /*!40000 ALTER TABLE `jos_vm_shopper_vendor_xref` DISABLE KEYS */; LOCK TABLES `jos_vm_shopper_vendor_xref` WRITE; INSERT INTO `jos_vm_shopper_vendor_xref` VALUES (62,1,5,''); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_shopper_vendor_xref` ENABLE KEYS */; -- -- Table structure for table `jos_vm_state` -- DROP TABLE IF EXISTS `jos_vm_state`; CREATE TABLE `jos_vm_state` ( `state_id` int(11) NOT NULL, `country_id` int(11) NOT NULL default '1', `state_name` varchar(64) default NULL, `state_3_code` char(3) default NULL, `state_2_code` char(2) default NULL, PRIMARY KEY (`state_id`), UNIQUE KEY `state_3_code` (`state_3_code`,`state_2_code`), KEY `idx_country_id` (`country_id`) ) TYPE=MyISAM COMMENT='States that are assigned to a country'; -- -- Dumping data for table `jos_vm_state` -- /*!40000 ALTER TABLE `jos_vm_state` DISABLE KEYS */; LOCK TABLES `jos_vm_state` WRITE; INSERT INTO `jos_vm_state` VALUES (1,223,'Alabama','ALA','AL'),(2,223,'Alaska','ALK','AK'),(3,223,'Arizona','ARZ','AZ'),(4,223,'Arkansas','ARK','AR'),(5,223,'California','CAL','CA'),(6,223,'Colorado','COL','CO'),(7,223,'Connecticut','CCT','CT'),(8,223,'Delaware','DEL','DE'),(9,223,'District Of Columbia','DOC','DC'),(10,223,'Florida','FLO','FL'),(11,223,'Georgia','GEA','GA'),(12,223,'Hawaii','HWI','HI'),(13,223,'Idaho','IDA','ID'),(14,223,'Illinois','ILL','IL'),(15,223,'Indiana','IND','IN'),(16,223,'Iowa','IOA','IA'),(17,223,'Kansas','KAS','KS'),(18,223,'Kentucky','KTY','KY'),(19,223,'Louisiana','LOA','LA'),(20,223,'Maine','MAI','ME'),(21,223,'Maryland','MLD','MD'),(22,223,'Massachusetts','MSA','MA'),(23,223,'Michigan','MIC','MI'),(24,223,'Minnesota','MIN','MN'),(25,223,'Mississippi','MIS','MS'),(26,223,'Missouri','MIO','MO'),(27,223,'Montana','MOT','MT'),(28,223,'Nebraska','NEB','NE'),(29,223,'Nevada','NEV','NV'),(30,223,'New Hampshire','NEH','NH'),(31,223,'New Jersey','NEJ','NJ'),(32,223,'New Mexico','NEM','NM'),(33,223,'New York','NEY','NY'),(34,223,'North Carolina','NOC','NC'),(35,223,'North Dakota','NOD','ND'),(36,223,'Ohio','OHI','OH'),(37,223,'Oklahoma','OKL','OK'),(38,223,'Oregon','ORN','OR'),(39,223,'Pennsylvania','PEA','PA'),(40,223,'Rhode Island','RHI','RI'),(41,223,'South Carolina','SOC','SC'),(42,223,'South Dakota','SOD','SD'),(43,223,'Tennessee','TEN','TN'),(44,223,'Texas','TXS','TX'),(45,223,'Utah','UTA','UT'),(46,223,'Vermont','VMT','VT'),(47,223,'Virginia','VIA','VA'),(48,223,'Washington','WAS','WA'),(49,223,'West Virginia','WEV','WV'),(50,223,'Wisconsin','WIS','WI'),(51,223,'Wyoming','WYO','WY'),(52,38,'Alberta','ALB','AB'),(53,38,'British Columbia','BRC','BC'),(54,38,'Manitoba','MAB','MB'),(55,38,'New Brunswick','NEB','NB'),(56,38,'Newfoundland and Labrador','NFL','NL'),(57,38,'Northwest Territories','NWT','NT'),(58,38,'Nova Scotia','NOS','NS'),(59,38,'Nunavut','NUT','NU'),(60,38,'Ontario','ONT','ON'),(61,38,'Prince Edward Island','PEI','PE'),(62,38,'Quebec','QEC','QC'),(63,38,'Saskatchewan','SAK','SK'),(64,38,'Yukon','YUT','YT'),(65,222,'England','ENG','EN'),(66,222,'Northern Ireland','NOI','NI'),(67,222,'Scotland','SCO','SD'),(68,222,'Wales','WLS','WS'),(69,13,'Australian Capital Territory','ACT','AT'),(70,13,'New South Wales','NSW','NW'),(71,13,'Northern Territory','NOT','NT'),(72,13,'Queensland','QLD','QL'),(73,13,'South Australia','SOA','SA'),(74,13,'Tasmania','TAS','TA'),(75,13,'Victoria','VIC','VI'),(76,13,'Western Australia','WEA','WA'),(77,138,'Aguascalientes','AGS','AG'),(78,138,'Baja California Norte','BCN','BN'),(79,138,'Baja California Sur','BCS','BS'),(80,138,'Campeche','CAM','CA'),(81,138,'Chiapas','CHI','CS'),(82,138,'Chihuahua','CHA','CH'),(83,138,'Coahuila','COA','CO'),(84,138,'Colima','COL','CM'),(85,138,'Distrito Federal','DFM','DF'),(86,138,'Durango','DGO','DO'),(87,138,'Guanajuato','GTO','GO'),(88,138,'Guerrero','GRO','GU'),(89,138,'Hidalgo','HGO','HI'),(90,138,'Jalisco','JAL','JA'),(91,138,'México (Estado de)','EDM','EM'),(92,138,'Michoacán','MCN','MI'),(93,138,'Morelos','MOR','MO'),(94,138,'Nayarit','NAY','NY'),(95,138,'Nuevo León','NUL','NL'),(96,138,'Oaxaca','OAX','OA'),(97,138,'Puebla','PUE','PU'),(98,138,'Querétaro','QRO','QU'),(99,138,'Quintana Roo','QUR','QR'),(100,138,'San Luis Potosí','SLP','SP'),(101,138,'Sinaloa','SIN','SI'),(102,138,'Sonora','SON','SO'),(103,138,'Tabasco','TAB','TA'),(104,138,'Tamaulipas','TAM','TM'),(105,138,'Tlaxcala','TLX','TX'),(106,138,'Veracruz','VER','VZ'),(107,138,'Yucatán','YUC','YU'),(108,138,'Zacatecas','ZAC','ZA'),(109,30,'Acre','ACR','AC'),(110,30,'Alagoas','ALG','AL'),(111,30,'Amapá','AMP','AP'),(112,30,'Amazonas','AMZ','AM'),(113,30,'Bahía','BAH','BA'),(114,30,'Ceará','CEA','CE'),(115,30,'Distrito Federal','DFB','DF'),(116,30,'Espirito Santo','ESS','ES'),(117,30,'Goiás','GOI','GO'),(118,30,'Maranhão','MAR','MA'),(119,30,'Mato Grosso','MAT','MT'),(120,30,'Mato Grosso do Sul','MGS','MS'),(121,30,'Minas Geraís','MIG','MG'),(122,30,'Paraná','PAR','PR'),(123,30,'Paraíba','PRB','PB'),(124,30,'Pará','PAB','PA'),(125,30,'Pernambuco','PER','PR'),(126,30,'Piauí','PIA','PI'),(127,30,'Rio Grande do Norte','RGN','RN'),(128,30,'Rio Grande do Sul','RGS','RS'),(129,30,'Rio de Janeiro','RDJ','RJ'),(130,30,'Rondônia','RON','RO'),(131,30,'Roraima','ROR','RR'),(132,30,'Santa Catarina','SAC','SC'),(133,30,'Sergipe','SER','SE'),(134,30,'São Paulo','SAP','SP'),(135,30,'Tocantins','TOC','TO'),(136,44,'Anhui','ANH','AN'),(137,44,'Beijing','BEI','BE'),(138,44,'Fujian','FUJ','FJ'),(139,44,'Gansu','GAN','GU'),(140,44,'Guangdong','GUA','GU'),(141,44,'Guangxi Zhuang','GUZ','GZ'),(142,44,'Guizhou','GUI','GI'),(143,44,'Hainan','HAI','HA'),(144,44,'Hebei','HEB','HE'),(145,44,'Heilongjiang','HEI','HG'),(146,44,'Henan','HEN','HN'),(147,44,'Hubei','HUB','HI'),(148,44,'Hunan','HUN','HU'),(149,44,'Jiangsu','JIA','JI'),(150,44,'Jiangxi','JIX','JX'),(151,44,'Jilin','JIL','JN'),(152,44,'Liaoning','LIA','LI'),(153,44,'Nei Mongol','NML','NM'),(154,44,'Ningxia Hui','NIH','NH'),(155,44,'Qinghai','QIN','QI'),(156,44,'Shaanxi','SHA','SH'),(157,44,'Shandong','SNG','SG'),(158,44,'Shanghai','SHH','SI'),(159,44,'Shanxi','SHX','SX'),(160,44,'Sichuan','SIC','SN'),(161,44,'Tianjin','TIA','TI'),(162,44,'Xinjiang Uygur','XIU','XU'),(163,44,'Xizang','XIZ','XI'),(164,44,'Yunnan','YUN','YU'),(165,44,'Zhejiang','ZHE','ZH'); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_state` ENABLE KEYS */; -- -- Table structure for table `jos_vm_tax_rate` -- DROP TABLE IF EXISTS `jos_vm_tax_rate`; CREATE TABLE `jos_vm_tax_rate` ( `tax_rate_id` int(11) NOT NULL, `vendor_id` int(11) default NULL, `tax_state` varchar(64) default NULL, `tax_country` varchar(64) default NULL, `mdate` int(11) default NULL, `tax_rate` decimal(10,4) default NULL, PRIMARY KEY (`tax_rate_id`), KEY `idx_tax_rate_vendor_id` (`vendor_id`) ) TYPE=MyISAM COMMENT='The tax rates for your store'; -- -- Dumping data for table `jos_vm_tax_rate` -- /*!40000 ALTER TABLE `jos_vm_tax_rate` DISABLE KEYS */; LOCK TABLES `jos_vm_tax_rate` WRITE; INSERT INTO `jos_vm_tax_rate` VALUES (2,1,'CA','USA',964565926,'0.0825'); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_tax_rate` ENABLE KEYS */; -- -- Table structure for table `jos_vm_user_info` -- DROP TABLE IF EXISTS `jos_vm_user_info`; CREATE TABLE `jos_vm_user_info` ( `user_info_id` varchar(32) NOT NULL default '', `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, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `perms` varchar(40) NOT NULL default 'shopper', `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 (`user_info_id`), KEY `idx_user_info_user_id` (`user_id`) ) TYPE=MyISAM COMMENT='Customer Information, BT = BillTo and ST = ShipTo'; -- -- Dumping data for table `jos_vm_user_info` -- /*!40000 ALTER TABLE `jos_vm_user_info` DISABLE KEYS */; LOCK TABLES `jos_vm_user_info` WRITE; INSERT INTO `jos_vm_user_info` VALUES ('f6e9c743b3abfa42cf93ed008e77002a',62,'BT',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,'','','US','','imlitala@mac.com',NULL,NULL,NULL,NULL,NULL,1153820902,1153831812,'shopper','','','','','','Checking'); UNLOCK TABLES; /*!40000 ALTER TABLE `jos_vm_user_info` ENABLE KEYS */; -- -- Table structure for table `jos_vm_vendor` -- DROP TABLE IF EXISTS `jos_vm_vendor`; CREATE TABLE `jos_vm_vendor` ( `vendor_id` int(11) NOT NULL, `vendor_name` varchar(64) default NULL, `contact_last_name` varchar(32) NOT NULL default '', `contact_first_name` varchar(32) NOT NULL default '', `contact_middle_name` varchar(32) default NULL, `contact_title` varchar(32) default NULL, `contact_phone_1` varchar(32) NOT NULL default '', `contact_phone_2` varchar(32) default NULL, `contact_fax` varchar(32) default NULL, `contact_email` varchar(255) default NULL, `vendor_phone` varchar(32) default NULL, `vendor_address_1` varchar(64) NOT NULL default '', `vendor_address_2` varchar(64) default NULL, `vendor_city` varchar(32) NOT NULL default '', `vendor_state` varchar(32) NOT NULL default '', `vendor_country` varchar(32) NOT NULL default 'US', `vendor_zip` varchar(32) NOT NULL default '', `vendor_store_name` varchar(128) NOT NULL default '', `vendor_store_desc` text, `vendor_category_id` int(11) default NULL, `vendor_thumb_image` varchar(255) default NULL, `vendor_full_image` varchar(255) default NULL, `vendor_currency` varchar(16) default NULL, `cdate` int(11) default NULL, `mdate` int(11) default NULL, `vendor_image_path` varchar(255) default NULL, `vendor_terms_of_service` text NOT NULL, `vendor_url` varchar(255) NOT NULL default '', `vendor_min_pov` decimal(10,2) default NULL, `vendor_freeshipping` decimal(10,2) NOT NULL default '0.00', `vendor_currency_display_style` varchar(64) NOT NULL default '', PRIMARY KEY (`vendor_id`), KEY `idx_vendor_name` (`vendor_name`), KEY `idx_vendor_category_id` (`vendor_category_id`) ) TYPE=MyISAM COMMENT='Vendors manage their products in your store'; -- -- Dumping data for table `jos_vm_vendor` -- /*!40000 ALTER TABLE `jos_vm_vendor` DISABLE KEYS */; LOCK TABLES `jos_vm_vendor` WRITE; INSERT INTO `jos_vm_vendor` VALUES (1,'Washupito\\\'s Tiendita','Owner','Demo','Store','Mr.','555-555-1212','555-555-1212','555-555-1212','imlitala@mac.com','555-555-1212','100 Washupito Avenue, N.W.','','Lake Forest','CA','USA','92630','Washupito\\\'s Tiendita','

The Audarya Award</