Am Freitag Abend 15.04.05 zwischen 22.00 und 24.00 Uhr ist der Fileserver wegen Wartungsarbeiten nicht erreichbar. Vielen Dank für Ihr Verständnis. WI Informatik
','',1,2,0,3,'2004-08-09 08:30:34',62,'','2005-04-15 16:17:54',62,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','wicor.jpg|||0||bottom||','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',7,0,2,'','',0,3);
INSERT INTO mos_content VALUES (3,'News','','Dies könnte der neue Internet-Auftritt der Business Area ETBA sein.','',1,2,0,3,'2004-08-09 08:30:34',62,'','2005-05-03 10:13:16',63,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',6,0,3,'','',0,0);
INSERT INTO mos_content VALUES (4,'Newsflash 3','','Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn\'t mttaer in waht oredr the ltteers in a wrod are, the olny iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.','',0,2,1,3,'2004-08-09 08:30:34',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','','','',1,0,4,'','',0,0);
INSERT INTO mos_content VALUES (11,'Mambo License Guidelines','','','',1,0,0,0,'2004-08-19 20:11:07',62,'','2005-03-08 10:12:20',62,0,'0000-00-00 00:00:00','2004-08-19 00:00:00','0000-00-00 00:00:00','','','menu_image=-1\r\nitem_title=1\r\npageclass_sfx=\r\nback_button=\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=',1,0,11,'','',0,317);
INSERT INTO mos_content VALUES (14,'Test','','Hallo','',-2,1,0,1,'2005-04-20 08:57:32',62,'','2005-04-20 09:01:01',62,0,'0000-00-00 00:00:00','2005-04-20 00:00:00','0000-00-00 00:00:00','food/bread.jpg','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',2,0,4,'','',0,3);
INSERT INTO mos_content VALUES (15,'Blank','','','',1,2,0,3,'2005-04-20 13:10:00',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-04-20 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',1,0,1,'','',0,6);
INSERT INTO mos_content VALUES (16,'Calendered Board','Calendered Board','
Field of application
Types:
Transformerboard T1
Filed of application
IEC/GOST Nr.
{mosimage}
Pressspan
dito
{mosimage}
Isolierpressspan
dito
{mosimage}
','',1,1,0,1,'2005-04-20 13:38:19',62,'','2005-04-20 14:09:13',62,0,'0000-00-00 00:00:00','2005-04-20 00:00:00','0000-00-00 00:00:00','pastarchives.jpg\r\ntaking_notes.jpg\r\nbox_msas.gif','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',2,0,5,'','',0,32);
INSERT INTO mos_content VALUES (17,'Test','','Dies ist meine erste Seite{mosimage}','',-2,1,0,1,'2005-05-03 10:08:27',63,'','2005-05-03 10:30:37',63,0,'0000-00-00 00:00:00','2005-05-03 00:00:00','0000-00-00 00:00:00','key.jpg','','',2,0,1,'','',0,1);
INSERT INTO mos_content VALUES (18,'Test ...','','sfsdfsdf','',-2,1,0,1,'2005-05-03 10:31:21',64,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-05-03 00:00:00','0000-00-00 00:00:00','','','',1,0,2,'','',0,0);
INSERT INTO mos_content VALUES (19,'Meine erste Seite','','mvcmxcmv.,xmvxmv.xm {mosimage}y cbnmbc nbyxmbcmyxb','',1,1,0,1,'2005-05-03 15:16:42',64,'','2005-05-03 15:18:47',64,0,'0000-00-00 00:00:00','2005-05-03 00:00:00','0000-00-00 00:00:00','usb_keys.jpg','','',2,0,3,'','',0,1);
INSERT INTO mos_content VALUES (12,'Board - cellulose based','Board - cellulose based','
The Electrical Technology Business Area (ETBA) is one of three business areas of the WICOR Group. The ETBA consists of a worldwide sales and sourcing company, Weidmann Systems International (WSI), and strategically located manufacturing operations worldwide that provide electrical insulation solutions to the OEM, Repair, and Utility industries.
WICOR Holding AG Rapperswil, Switzerland
Weidmann Electrical Technology
Weidmann Systems International Inc. Lyndonville, VT, USA
Mexico City, Mexico Buenos Aires, Argentina São Paulo, Brazil
Weidmann-ACTI Inc. Lyndonville, VT, USA
EHV-Weidmann Industries Inc. St. Johnsbury, VT, USA Rockford, TN, USA
EHV-Weidmann de Mexico S.A. Saltillo, Mexico
Weidmann do Brasil Ltda. Diadema, Brazil
Weidmann Industries, LP Fergus, ON, Canada
Weidmann Systems International AG Rapperswil, Switzerland
Bourgoin-Jallieu, France Pool-in-Wharfedale, England Kiev, Ukraine
Weidmann Transformerboard Systems AG Rapperswil, Switzerland
Izo-Prod d.o.o. Zagreb-Stupnik, Croatia
Yürwas Yürekten- Weidmann AS Izmit, Turkey (Minority Participation)
Procelis, S.A.S. Bourgoin-Jallieu, France
Whiteley Ltd. / Electrical Technology Division Pool-in-Wharfedale, England
OJSC Malin Paper Mill Malin, Zhitomir, Ukraine
Weidmann Systems International Ltd. Hong Kong, China
Singapore, Singapore Shanghai, China Beijing, China Gallan & Associates, Sydney, Australia
Taizhou Weidmann High Voltage Insulation Co. Ltd. Taizhou, Jiangsu, China
Oji Paper Co., Ltd. / Specialty Products Division Tokyo, Japan (Licensing Partner)
Govik Electricals Pvt. Ltd. Bombay, India (Licensing Partner)
','',1,1,0,1,'2005-04-19 16:48:05',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-04-19 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\r\nback_button=\r\nitem_title=1\r\nlink_titles=\r\nintrotext=1\r\nsection=0\r\nsection_link=0\r\ncategory=0\r\ncategory_link=0\r\nrating=\r\nauthor=\r\ncreatedate=\r\nmodifydate=\r\npdf=\r\nprint=\r\nemail=\r\nkeyref=\r\ndocbook_type=',1,0,6,'','',0,76);
#
# Table structure for table `mos_content_frontpage`
#
DROP table IF EXISTS mos_content_frontpage;
CREATE TABLE `mos_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 `mos_content_frontpage`
#
INSERT INTO mos_content_frontpage VALUES (17,1);
INSERT INTO mos_content_frontpage VALUES (3,3);
INSERT INTO mos_content_frontpage VALUES (14,2);
#
# Table structure for table `mos_content_rating`
#
DROP table IF EXISTS mos_content_rating;
CREATE TABLE `mos_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 `mos_content_rating`
#
#
# Table structure for table `mos_core_acl_aro`
#
DROP table IF EXISTS mos_core_acl_aro;
CREATE TABLE `mos_core_acl_aro` (
`aro_id` int(11) NOT NULL auto_increment,
`section_value` varchar(240) NOT NULL default '0',
`value` varchar(240) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`aro_id`),
UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
UNIQUE KEY `mos_gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `mos_gacl_hidden_aro` (`hidden`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_core_acl_aro`
#
INSERT INTO mos_core_acl_aro VALUES (10,'users','62',0,'Administrator',0);
INSERT INTO mos_core_acl_aro VALUES (11,'users','63',0,'Grob Edwin',0);
INSERT INTO mos_core_acl_aro VALUES (12,'users','64',0,'Testuser',0);
INSERT INTO mos_core_acl_aro VALUES (13,'users','65',0,'Manager',0);
#
# Table structure for table `mos_core_acl_aro_groups`
#
DROP table IF EXISTS mos_core_acl_aro_groups;
CREATE TABLE `mos_core_acl_aro_groups` (
`group_id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`lft` int(11) NOT NULL default '0',
`rgt` int(11) NOT NULL default '0',
PRIMARY KEY (`group_id`),
KEY `parent_id_aro_groups` (`parent_id`),
KEY `mos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `mos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_core_acl_aro_groups`
#
INSERT INTO mos_core_acl_aro_groups VALUES (17,0,'ROOT',1,22);
INSERT INTO mos_core_acl_aro_groups VALUES (28,17,'USERS',2,21);
INSERT INTO mos_core_acl_aro_groups VALUES (29,28,'Public Frontend',3,12);
INSERT INTO mos_core_acl_aro_groups VALUES (18,29,'Registered',4,11);
INSERT INTO mos_core_acl_aro_groups VALUES (19,18,'Author',5,10);
INSERT INTO mos_core_acl_aro_groups VALUES (20,19,'Editor',6,9);
INSERT INTO mos_core_acl_aro_groups VALUES (21,20,'Publisher',7,8);
INSERT INTO mos_core_acl_aro_groups VALUES (30,28,'Public Backend',13,20);
INSERT INTO mos_core_acl_aro_groups VALUES (23,30,'Manager',14,19);
INSERT INTO mos_core_acl_aro_groups VALUES (24,23,'Administrator',15,18);
INSERT INTO mos_core_acl_aro_groups VALUES (25,24,'Super Administrator',16,17);
#
# Table structure for table `mos_core_acl_aro_sections`
#
DROP table IF EXISTS mos_core_acl_aro_sections;
CREATE TABLE `mos_core_acl_aro_sections` (
`section_id` int(11) NOT NULL auto_increment,
`value` varchar(230) NOT NULL default '',
`order_value` int(11) NOT NULL default '0',
`name` varchar(230) NOT NULL default '',
`hidden` int(11) NOT NULL default '0',
PRIMARY KEY (`section_id`),
UNIQUE KEY `value_aro_sections` (`value`),
UNIQUE KEY `mos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `mos_gacl_hidden_aro_sections` (`hidden`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_core_acl_aro_sections`
#
INSERT INTO mos_core_acl_aro_sections VALUES (10,'users',1,'Users',0);
#
# Table structure for table `mos_core_acl_groups_aro_map`
#
DROP table IF EXISTS mos_core_acl_groups_aro_map;
CREATE TABLE `mos_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 `mos_core_acl_groups_aro_map`
#
INSERT INTO mos_core_acl_groups_aro_map VALUES (19,'',12);
INSERT INTO mos_core_acl_groups_aro_map VALUES (21,'',11);
INSERT INTO mos_core_acl_groups_aro_map VALUES (23,'',13);
INSERT INTO mos_core_acl_groups_aro_map VALUES (25,'',10);
#
# Table structure for table `mos_core_log_items`
#
DROP table IF EXISTS mos_core_log_items;
CREATE TABLE `mos_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 `mos_core_log_items`
#
#
# Table structure for table `mos_core_log_searches`
#
DROP table IF EXISTS mos_core_log_searches;
CREATE TABLE `mos_core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Dumping data for table `mos_core_log_searches`
#
#
# Table structure for table `mos_groups`
#
DROP table IF EXISTS mos_groups;
CREATE TABLE `mos_groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_groups`
#
INSERT INTO mos_groups VALUES (0,'Public');
INSERT INTO mos_groups VALUES (1,'Registered');
INSERT INTO mos_groups VALUES (2,'Special');
#
# Table structure for table `mos_mambots`
#
DROP table IF EXISTS mos_mambots;
CREATE TABLE `mos_mambots` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_mambots`
#
INSERT INTO mos_mambots VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (9,'No WYSIWYG Editor','none','editors',0,0,0,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced');
INSERT INTO mos_mambots VALUES (11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (14,'Search Categories','categories.searchbot','search',0,4,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (15,'Search Sections','sections.searchbot','search',0,5,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (16,'Email Cloaking','mosemailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (17,'GeSHi','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (18,'Search Newsfeeds','newsfeeds.searchbot','search',0,6,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (19,'Load Module Positions','mosloadposition','content',0,6,1,0,0,0,'0000-00-00 00:00:00','');
#
# Table structure for table `mos_menu`
#
DROP table IF EXISTS mos_menu;
CREATE TABLE `mos_menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`type` varchar(50) NOT NULL default '',
`published` tinyint(1) NOT NULL default '0',
`parent` int(11) unsigned NOT NULL default '0',
`componentid` int(11) unsigned NOT NULL default '0',
`sublevel` int(11) default '0',
`ordering` int(11) default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL default '0',
`browserNav` tinyint(4) default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`utaccess` tinyint(3) unsigned NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_menu`
#
INSERT INTO mos_menu VALUES (1,'topmenusmall','Home','index.php?option=com_frontpage','components',1,0,10,0,4,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');
INSERT INTO mos_menu VALUES (2,'topmenu','News/Press','index.php?option=com_content&task=section&id=1','content_section',1,0,1,0,6,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\r\npage_title=1\r\npageclass_sfx=\r\nback_button=\r\norderby=\r\nother_cat_section=1\r\ndescription=0\r\ndescription_image=0\r\nother_cat=1\r\nempty_cat=0\r\ncat_items=1\r\ncat_description=1\r\ndate_format=\r\ndate=\r\nauthor=\r\nhits=\r\nheadings=1\r\nnavigation=1\r\norder_select=1\r\ndisplay=1\r\ndisplay_num=50\r\nfilter=1\r\nfilter_type=title');
INSERT INTO mos_menu VALUES (3,'topmenusmall','Contact Us','index.php?option=com_contact','components',1,0,7,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\r\npageclass_sfx=\r\nback_button=\r\npage_title=1\r\nheader=\r\nother_cat_section=1\r\nother_cat=1\r\ncat_description=1\r\ncat_items=1\r\ndescription=1\r\ndescription_text=\r\nimage=-1\r\nimage_align=right\r\nheadings=1\r\nposition=1\r\nemail=0\r\ntelephone=1\r\nfax=1');
INSERT INTO mos_menu VALUES (4,'mainmenu','Links','index.php?option=com_weblinks','components',1,0,4,0,9,0,'0000-00-00 00:00:00',0,0,0,3,'image=web_links.jpg\r\nimage_align=right');
INSERT INTO mos_menu VALUES (5,'othermenu','MamboServer','http://www.mamboserver.com','url',0,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (6,'othermenu','Administrator','administrator/','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1');
INSERT INTO mos_menu VALUES (7,'othermenu','MamboForge','http://mamboforge.net','url',0,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (21,'usermenu','Your Details','index.php?option=com_user&task=UserDetails','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,1,3,'');
INSERT INTO mos_menu VALUES (22,'usermenu','Submit News','index.php?option=com_content&task=new§ionid=1&Itemid=0','url',1,0,0,0,2,0,'0000-00-00 00:00:00',0,0,1,2,'');
INSERT INTO mos_menu VALUES (23,'usermenu','Submit WebLink','index.php?option=com_weblinks&task=new','url',1,0,0,0,4,0,'2000-00-00 00:00:00',0,0,1,2,'');
INSERT INTO mos_menu VALUES (24,'usermenu','Check-In My Items','index.php?option=com_user&task=CheckIn','url',1,0,0,0,5,0,'0000-00-00 00:00:00',0,0,1,2,'');
INSERT INTO mos_menu VALUES (11,'topmenu','Home','index.php','url',0,0,0,0,11,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (27,'mainmenu','Search','index.php?option=com_search','components',1,0,16,0,8,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (28,'topmenu','Contact Us','index.php?option=com_contact&Itemid=3','url',0,0,0,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1');
INSERT INTO mos_menu VALUES (29,'topmenu','News','index.php?option=com_content&task=section&id=1&Itemid=2','url',0,0,0,0,12,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (30,'topmenu','Links','index.php?option=com_weblinks&Itemid=4','url',0,0,0,0,9,0,'0000-00-00 00:00:00',0,0,0,3,'');
INSERT INTO mos_menu VALUES (33,'mainmenu','Mambo License','index.php?option=com_content&task=view&id=11','content_typed',-2,0,11,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'');
INSERT INTO mos_menu VALUES (34,'usermenu','Logout','index.php?logout','components',1,0,15,0,5,0,'0000-00-00 00:00:00',0,0,1,3,'');
INSERT INTO mos_menu VALUES (37,'mainmenu','News Feeds','index.php?option=com_newsfeeds','components',0,0,12,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\r\npageclass_sfx=\r\nback_button=\r\npage_title=1\r\nheader=');
INSERT INTO mos_menu VALUES (38,'mainmenu','Wrapper','index.php?option=com_wrapper','wrapper',-2,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\r\npageclass_sfx=\r\nback_button=\r\npage_title=1\r\nheader=\r\nscrolling=auto\r\nwidth=100%\r\nheight=600\r\nheight_auto=1\r\nurl=www.mamboserver.com');
INSERT INTO mos_menu VALUES (39,'mainmenu','Blog','index.php?option=com_content&task=blogsection&id=0','content_blog_section',-2,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'count=8\r\nintro=3\r\nimage=0\r\norderby=date asc\r\nheader=A blog of all section with no images\r\nempty=');
INSERT INTO mos_menu VALUES (40,'mainmenu','About Us','index.php?option=com_content&task=view&id=11','content_typed',-2,0,11,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (41,'topmenu','Markets','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,4,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (42,'topmenu','Competence','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (43,'topmenu','Products/Services','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (44,'mainmenu','Career/Jobs','index.php?option=com_content&task=view&id=11','content_typed',0,0,11,0,6,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (45,'mainmenu','B2B','index.php?option=com_content&task=view&id=11','content_typed',-2,0,11,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (46,'Markets','Trafo Users','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (47,'Markets','PX','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (48,'Markets','DX','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (49,'Markets','Trafo related Industries','index.php?option=com_content&task=view&id=11','content_typed',1,0,11,0,4,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (50,'Markets','Board - cell. based','index.php?option=com_content&task=view&id=11','content_typed',-2,48,11,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (51,'Markets','Board - High Temp.','index.php?option=com_content&task=view&id=11','content_typed',1,48,11,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (52,'Markets','Board - cell. based','index.php?option=com_content&task=view&id=12','content_item_link',1,48,12,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (53,'topmenu','About us','index.php?option=com_content&task=view&id=13','content_item_link',1,0,13,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (54,'topmenu','Overview','index.php?option=com_content&task=section&id=3','content_section',1,43,3,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\npage_title=1\r\npageclass_sfx=\r\nback_button=\r\norderby=\r\nother_cat_section=1\r\ndescription=0\r\ndescription_image=0\r\nother_cat=1\r\nempty_cat=0\r\ncat_items=1\r\ncat_description=1\r\ndate_format=\r\ndate=\r\nauthor=\r\nhits=\r\nheadings=1\r\nnavigation=1\r\norder_select=1\r\ndisplay=1\r\ndisplay_num=50\r\nfilter=1\r\nfilter_type=title');
INSERT INTO mos_menu VALUES (55,'topmenu','Board - cellulose based','index.php?option=com_content&task=section&id=3','content_section',1,43,3,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\npage_title=0\r\npageclass_sfx=\r\nback_button=0\r\norderby=\r\nother_cat_section=0\r\ndescription=0\r\ndescription_image=0\r\nother_cat=1\r\nempty_cat=0\r\ncat_items=1\r\ncat_description=1\r\ndate_format=\r\ndate=\r\nauthor=\r\nhits=\r\nheadings=1\r\nnavigation=1\r\norder_select=1\r\ndisplay=1\r\ndisplay_num=50\r\nfilter=1\r\nfilter_type=title');
INSERT INTO mos_menu VALUES (56,'topmenu','Board - High Temp','index.php?option=com_content&task=section&id=3','content_section',1,43,3,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\r\npage_title=0\r\npageclass_sfx=\r\nback_button=0\r\norderby=\r\nother_cat_section=0\r\ndescription=0\r\ndescription_image=0\r\nother_cat=1\r\nempty_cat=0\r\ncat_items=1\r\ncat_description=1\r\ndate_format=\r\ndate=\r\nauthor=\r\nhits=\r\nheadings=1\r\nnavigation=1\r\norder_select=1\r\ndisplay=1\r\ndisplay_num=50\r\nfilter=1\r\nfilter_type=title');
INSERT INTO mos_menu VALUES (57,'topmenu','calendered','index.php?option=com_content&task=view&id=12','content_item_link',-2,55,12,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (58,'topmenu','calendered','index.php?option=com_content&task=view&id=12','content_item_link',-2,55,12,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (59,'topmenu','Calendered Board','index.php?option=com_content&task=view&id=16','content_item_link',1,55,16,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (60,'topmenu','B2B','http://www.weidmannb2b.biz','url',1,0,0,0,8,0,'0000-00-00 00:00:00',0,1,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (61,'mainmenu','Test','index.php?option=com_phpshop','components',0,0,19,0,11,0,'0000-00-00 00:00:00',0,0,0,0,'');
INSERT INTO mos_menu VALUES (62,'topmenu','Career/Jobs','index.php?option=com_content&task=view&id=15','content_item_link',1,0,15,0,7,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (63,'topmenusmall','SBB','http:/www.sbb.ch','url',-2,0,0,0,0,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (64,'topmenusmall','Wetter','http://www.wetter.com','url',-2,0,0,0,0,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (65,'mainmenu','Home','index.php?option=com_frontpage','components',1,0,10,0,7,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');
INSERT INTO mos_menu VALUES (66,'topmenu','- - - - - - -','','separator',-2,0,0,0,0,0,'0000-00-00 00:00:00',0,3,0,0,'menu_image=-1');
INSERT INTO mos_menu VALUES (67,'AboutUs','Location','index.php?option=com_content&task=view&id=15','content_item_link',1,0,15,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
#
# Table structure for table `mos_messages`
#
DROP table IF EXISTS mos_messages;
CREATE TABLE `mos_messages` (
`message_id` int(10) unsigned NOT NULL auto_increment,
`user_id_from` int(10) unsigned NOT NULL default '0',
`user_id_to` int(10) unsigned NOT NULL default '0',
`folder_id` int(10) unsigned NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00',
`state` int(11) NOT NULL default '0',
`priority` int(1) unsigned NOT NULL default '0',
`subject` varchar(230) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`message_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_messages`
#
#
# Table structure for table `mos_messages_cfg`
#
DROP table IF EXISTS mos_messages_cfg;
CREATE TABLE `mos_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 `mos_messages_cfg`
#
INSERT INTO mos_messages_cfg VALUES (62,'lock','1');
INSERT INTO mos_messages_cfg VALUES (62,'mail_on_new','0');
#
# Table structure for table `mos_modules`
#
DROP table IF EXISTS mos_modules;
CREATE TABLE `mos_modules` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL default '0',
`position` varchar(10) default NULL,
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`module` varchar(50) default NULL,
`numnews` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`showtitle` tinyint(3) unsigned NOT NULL default '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_modules`
#
INSERT INTO mos_modules VALUES (1,'Polls','',1,'right',0,'0000-00-00 00:00:00',0,'mod_poll',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (2,'User Menu','',7,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,1,1,'menutype=usermenu',1,0);
INSERT INTO mos_modules VALUES (3,'Main Menu','',4,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=mainmenu\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',1,0);
INSERT INTO mos_modules VALUES (4,'Login Form','',3,'right',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'moduleclass_sfx=\r\npretext=\r\nposttext=\r\nlogin=\r\nlogout=\r\nlogin_message=0\r\nlogout_message=0\r\ngreeting=1\r\nname=0',1,0);
INSERT INTO mos_modules VALUES (5,'Syndicate','',7,'right',0,'0000-00-00 00:00:00',0,'mod_rssfeed',0,0,1,'text=\r\ncache=0\r\nmoduleclass_sfx=\r\nrss091=1\r\nrss10=1\r\nrss20=1\r\natom=1\r\nopml=1\r\nrss091_image=\r\nrss10_image=\r\nrss20_image=\r\natom_image=\r\nopml_image=',1,0);
INSERT INTO mos_modules VALUES (6,'Latest News','',4,'user1',0,'0000-00-00 00:00:00',1,'mod_latestnews',0,0,1,'',1,0);
INSERT INTO mos_modules VALUES (7,'Statistics','',8,'left',0,'0000-00-00 00:00:00',0,'mod_stats',0,0,1,'serverinfo=1\r\nsiteinfo=1\r\ncounter=1\r\nincrease=0\r\nmoduleclass_sfx=',0,0);
INSERT INTO mos_modules VALUES (8,'Who\'s Online','',4,'right',0,'0000-00-00 00:00:00',0,'mod_whosonline',0,0,1,'online=1\r\nusers=1\r\nmoduleclass_sfx=',0,0);
INSERT INTO mos_modules VALUES (9,'Popular','',6,'user2',0,'0000-00-00 00:00:00',0,'mod_mostread',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (10,'Other MS Templates','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'title_length=20\r\nshow_preview=1\r\npreview_width=140\r\npreview_height=90\r\nmoduleclass_sfx=',0,0);
INSERT INTO mos_modules VALUES (11,'Archive','',9,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0);
INSERT INTO mos_modules VALUES (12,'Sections','',10,'left',0,'0000-00-00 00:00:00',0,'mod_sections',0,0,1,'',1,0);
INSERT INTO mos_modules VALUES (13,'Newsflash','',5,'right',0,'0000-00-00 00:00:00',0,'mod_newsflash',0,0,1,'catid=3\r\nstyle=random\r\nimage=0\r\nlink_titles=\r\nreadmore=0\r\nitem_title=0\r\nitems=\r\ncache=0\r\nmoduleclass_sfx=',0,0);
INSERT INTO mos_modules VALUES (14,'Related Items','',11,'left',0,'0000-00-00 00:00:00',0,'mod_related_items',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (15,'Search','',1,'user4',0,'0000-00-00 00:00:00',1,'mod_search',0,0,0,'moduleclass_sfx=\r\ncache=0\r\nwidth=20\r\ntext=\r\nbutton=\r\nbutton_pos=right\r\nbutton_text=',0,0);
INSERT INTO mos_modules VALUES (16,'Random Image','',8,'right',0,'0000-00-00 00:00:00',0,'mod_random_image',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (17,'Top Menu','',1,'user3',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=topmenu\r\nmenu_style=list_flat\r\nmenu_images=n\r\nmenu_images_align=left\r\nexpand_menu=n\r\nclass_sfx=-nav\r\nmoduleclass_sfx=\r\nindent_image1=0\r\nindent_image2=0\r\nindent_image3=0\r\nindent_image4=0\r\nindent_image5=0\r\nindent_image6=0',1,0);
INSERT INTO mos_modules VALUES (18,'Banners','',1,'banner',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'banner_cids=\r\nmoduleclass_sfx=\r\n',1,0);
INSERT INTO mos_modules VALUES (19,'Components','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (20,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0,1);
INSERT INTO mos_modules VALUES (21,'Latest Items','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0,1);
INSERT INTO mos_modules VALUES (22,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0,1);
INSERT INTO mos_modules VALUES (23,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (24,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (25,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (26,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (27,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (28,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (29,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1);
INSERT INTO mos_modules VALUES (30,'Mamboforge','',1,'cpanel',0,'0000-00-00 00:00:00',0,'',0,99,1,'rssurl=http://mamboforge.net/export/rss_sfnews.php\r\nrssitems=5\r\nrssdesc=1\r\ncache=0\r\nmoduleclass_sfx=',0,1);
INSERT INTO mos_modules VALUES (31,'Other Menu','',6,'right',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=othermenu\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (32,'Wrapper','',13,'left',0,'0000-00-00 00:00:00',0,'mod_wrapper',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (33,'Logged','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1);
INSERT INTO mos_modules VALUES (34,'template club','',12,'left',0,'0000-00-00 00:00:00',0,'',0,0,0,'moduleclass_sfx=\r\nrssurl=\r\nrssdesc=1\r\nrssimage=1\r\nrssitems=3\r\nrssitemdesc=1\r\nword_count=0\r\ncache=0',0,0);
INSERT INTO mos_modules VALUES (35,'mambo-phpShop Module','',14,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (36,'phpShop latest products','',5,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop_latestprod',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (39,'AboutUs','',3,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=AboutUs\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (37,'phpShop Search Module','',15,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop_search',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (38,'topmenusmall','',1,'user5',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=-topnav\r\nmoduleclass_sfx=\r\nmenutype=topmenusmall\r\nmenu_style=list_flat\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=-1\r\nindent_image2=-1\r\nindent_image3=-1\r\nindent_image4=-1\r\nindent_image5=-1\r\nindent_image6=-1\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (40,'Markets','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=Markets\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (41,'Products','',1,'left',0,'0000-00-00 00:00:00',0,'mod_mainmenu',0,0,1,'menutype=Products',0,0);
#
# Table structure for table `mos_modules_menu`
#
DROP table IF EXISTS mos_modules_menu;
CREATE TABLE `mos_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 `mos_modules_menu`
#
INSERT INTO mos_modules_menu VALUES (1,1);
INSERT INTO mos_modules_menu VALUES (2,0);
INSERT INTO mos_modules_menu VALUES (4,3);
INSERT INTO mos_modules_menu VALUES (5,1);
INSERT INTO mos_modules_menu VALUES (6,1);
INSERT INTO mos_modules_menu VALUES (6,2);
INSERT INTO mos_modules_menu VALUES (6,4);
INSERT INTO mos_modules_menu VALUES (6,27);
INSERT INTO mos_modules_menu VALUES (6,36);
INSERT INTO mos_modules_menu VALUES (8,1);
INSERT INTO mos_modules_menu VALUES (9,1);
INSERT INTO mos_modules_menu VALUES (9,2);
INSERT INTO mos_modules_menu VALUES (9,4);
INSERT INTO mos_modules_menu VALUES (9,27);
INSERT INTO mos_modules_menu VALUES (9,36);
INSERT INTO mos_modules_menu VALUES (10,1);
INSERT INTO mos_modules_menu VALUES (13,1);
INSERT INTO mos_modules_menu VALUES (15,0);
INSERT INTO mos_modules_menu VALUES (17,0);
INSERT INTO mos_modules_menu VALUES (18,0);
INSERT INTO mos_modules_menu VALUES (31,1);
INSERT INTO mos_modules_menu VALUES (34,2);
INSERT INTO mos_modules_menu VALUES (34,3);
INSERT INTO mos_modules_menu VALUES (34,4);
INSERT INTO mos_modules_menu VALUES (34,27);
INSERT INTO mos_modules_menu VALUES (34,33);
INSERT INTO mos_modules_menu VALUES (34,39);
INSERT INTO mos_modules_menu VALUES (35,0);
INSERT INTO mos_modules_menu VALUES (36,1);
INSERT INTO mos_modules_menu VALUES (37,0);
INSERT INTO mos_modules_menu VALUES (38,0);
INSERT INTO mos_modules_menu VALUES (39,53);
INSERT INTO mos_modules_menu VALUES (40,41);
INSERT INTO mos_modules_menu VALUES (41,0);
#
# Table structure for table `mos_newsfeeds`
#
DROP table IF EXISTS mos_newsfeeds;
CREATE TABLE `mos_newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`link` text NOT NULL,
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(11) unsigned NOT NULL default '1',
`cache_time` int(11) unsigned NOT NULL default '3600',
`checked_out` tinyint(3) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_newsfeeds`
#
INSERT INTO mos_newsfeeds VALUES (66,16,'Mamboforge.net','http://mamboforge.net/export/rss_sfnews.php','',1,5,3600,0,'0000-00-00 00:00:00',16);
INSERT INTO mos_newsfeeds VALUES (66,17,'Mamboportal','http://www.mamboportal.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',17);
INSERT INTO mos_newsfeeds VALUES (66,18,'Mambohut','http://www.mambohut.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',18);
#
# Table structure for table `mos_poll_data`
#
DROP table IF EXISTS mos_poll_data;
CREATE TABLE `mos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM;
#
# Dumping data for table `mos_poll_data`
#
#
# Table structure for table `mos_poll_date`
#
DROP table IF EXISTS mos_poll_date;
CREATE TABLE `mos_poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_poll_date`
#
#
# Table structure for table `mos_poll_menu`
#
DROP table IF EXISTS mos_poll_menu;
CREATE TABLE `mos_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 `mos_poll_menu`
#
#
# Table structure for table `mos_polls`
#
DROP table IF EXISTS mos_polls;
CREATE TABLE `mos_polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_polls`
#
#
# Table structure for table `mos_pshop_affiliate`
#
DROP table IF EXISTS mos_pshop_affiliate;
CREATE TABLE `mos_pshop_affiliate` (
`affiliate_id` int(11) NOT NULL auto_increment,
`user_id` varchar(32) NOT NULL default '',
`active` char(1) NOT NULL default 'N',
`rate` int(11) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_affiliate`
#
#
# Table structure for table `mos_pshop_affiliate_sale`
#
DROP table IF EXISTS mos_pshop_affiliate_sale;
CREATE TABLE `mos_pshop_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;
#
# Dumping data for table `mos_pshop_affiliate_sale`
#
#
# Table structure for table `mos_pshop_auth_user_vendor`
#
DROP table IF EXISTS mos_pshop_auth_user_vendor;
CREATE TABLE `mos_pshop_auth_user_vendor` (
`user_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_auth_user_vendor`
#
INSERT INTO mos_pshop_auth_user_vendor VALUES ('62',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('63',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('64',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('65',1);
#
# Table structure for table `mos_pshop_category`
#
DROP table IF EXISTS mos_pshop_category;
CREATE TABLE `mos_pshop_category` (
`category_id` varchar(32) NOT NULL default '',
`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;
#
# Dumping data for table `mos_pshop_category`
#
INSERT INTO mos_pshop_category VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',1,'Hand Tools','Hand Tools','','','Y',950319905,960304194,'browse_3',3,'',1);
INSERT INTO mos_pshop_category VALUES ('1c914424d2569bea3439fbcca9123a27',1,'Power Tools','Power Tools','','','Y',950319916,960304104,'browse_4',4,'',2);
INSERT INTO mos_pshop_category VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',1,'Garden Tools','Garden Tools','','','Y',950321122,960304338,'browse_2',2,'shop.garden_flypage',3);
INSERT INTO mos_pshop_category VALUES ('f85e462baf927f8e53989dd969c0e430',1,'Outdoor Tools','Outdoor Tools','','','Y',955626629,958889528,'browse_1',1,'',4);
INSERT INTO mos_pshop_category VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a',1,'Indoor Tools','Indoor Tools','','','Y',958892894,958892894,'browse_1',1,'',5);
#
# Table structure for table `mos_pshop_category_xref`
#
DROP table IF EXISTS mos_pshop_category_xref;
CREATE TABLE `mos_pshop_category_xref` (
`category_parent_id` varchar(32) NOT NULL default '0',
`category_child_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_category_xref`
#
INSERT INTO mos_pshop_category_xref VALUES ('0','541a03b2b0e1b6dbd972e9f5af5ca992');
INSERT INTO mos_pshop_category_xref VALUES ('0','1c914424d2569bea3439fbcca9123a27');
INSERT INTO mos_pshop_category_xref VALUES ('0','6834dda8e3e6e5aa18bafc63a57fd04a');
INSERT INTO mos_pshop_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27','f85e462baf927f8e53989dd969c0e430');
INSERT INTO mos_pshop_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27','2f34f8bf003a5f27bed2e8dfe0b6f33a');
#
# Table structure for table `mos_pshop_country`
#
DROP table IF EXISTS mos_pshop_country;
CREATE TABLE `mos_pshop_country` (
`country_id` int(11) NOT NULL auto_increment,
`zone_id` int(11) NOT NULL default '1',
`country_name` varchar(64) default NULL,
`country_3_code` char(3) default NULL,
`country_2_code` char(2) default NULL,
PRIMARY KEY (`country_id`),
KEY `idx_country_name` (`country_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_country`
#
INSERT INTO mos_pshop_country VALUES (1,1,'Afghanistan','AFG','AF');
INSERT INTO mos_pshop_country VALUES (2,1,'Albania','ALB','AL');
INSERT INTO mos_pshop_country VALUES (3,1,'Algeria','DZA','DZ');
INSERT INTO mos_pshop_country VALUES (4,1,'American Samoa','ASM','AS');
INSERT INTO mos_pshop_country VALUES (5,1,'Andorra','AND','AD');
INSERT INTO mos_pshop_country VALUES (6,1,'Angola','AGO','AO');
INSERT INTO mos_pshop_country VALUES (7,1,'Anguilla','AIA','AI');
INSERT INTO mos_pshop_country VALUES (8,1,'Antarctica','ATA','AQ');
INSERT INTO mos_pshop_country VALUES (9,1,'Antigua and Barbuda','ATG','AG');
INSERT INTO mos_pshop_country VALUES (10,1,'Argentina','ARG','AR');
INSERT INTO mos_pshop_country VALUES (11,1,'Armenia','ARM','AM');
INSERT INTO mos_pshop_country VALUES (12,1,'Aruba','ABW','AW');
INSERT INTO mos_pshop_country VALUES (13,1,'Australia','AUS','AU');
INSERT INTO mos_pshop_country VALUES (14,1,'Austria','AUT','AT');
INSERT INTO mos_pshop_country VALUES (15,1,'Azerbaijan','AZE','AZ');
INSERT INTO mos_pshop_country VALUES (16,1,'Bahamas','BHS','BS');
INSERT INTO mos_pshop_country VALUES (17,1,'Bahrain','BHR','BH');
INSERT INTO mos_pshop_country VALUES (18,1,'Bangladesh','BGD','BD');
INSERT INTO mos_pshop_country VALUES (19,1,'Barbados','BRB','BB');
INSERT INTO mos_pshop_country VALUES (20,1,'Belarus','BLR','BY');
INSERT INTO mos_pshop_country VALUES (21,1,'Belgium','BEL','BE');
INSERT INTO mos_pshop_country VALUES (22,1,'Belize','BLZ','BZ');
INSERT INTO mos_pshop_country VALUES (23,1,'Benin','BEN','BJ');
INSERT INTO mos_pshop_country VALUES (24,1,'Bermuda','BMU','BM');
INSERT INTO mos_pshop_country VALUES (25,1,'Bhutan','BTN','BT');
INSERT INTO mos_pshop_country VALUES (26,1,'Bolivia','BOL','BO');
INSERT INTO mos_pshop_country VALUES (27,1,'Bosnia and Herzegowina','BIH','BA');
INSERT INTO mos_pshop_country VALUES (28,1,'Botswana','BWA','BW');
INSERT INTO mos_pshop_country VALUES (29,1,'Bouvet Island','BVT','BV');
INSERT INTO mos_pshop_country VALUES (30,1,'Brazil','BRA','BR');
INSERT INTO mos_pshop_country VALUES (31,1,'British Indian Ocean Territory','IOT','IO');
INSERT INTO mos_pshop_country VALUES (32,1,'Brunei Darussalam','BRN','BN');
INSERT INTO mos_pshop_country VALUES (33,1,'Bulgaria','BGR','BG');
INSERT INTO mos_pshop_country VALUES (34,1,'Burkina Faso','BFA','BF');
INSERT INTO mos_pshop_country VALUES (35,1,'Burundi','BDI','BI');
INSERT INTO mos_pshop_country VALUES (36,1,'Cambodia','KHM','KH');
INSERT INTO mos_pshop_country VALUES (37,1,'Cameroon','CMR','CM');
INSERT INTO mos_pshop_country VALUES (38,1,'Canada','CAN','CA');
INSERT INTO mos_pshop_country VALUES (39,1,'Cape Verde','CPV','CV');
INSERT INTO mos_pshop_country VALUES (40,1,'Cayman Islands','CYM','KY');
INSERT INTO mos_pshop_country VALUES (41,1,'Central African Republic','CAF','CF');
INSERT INTO mos_pshop_country VALUES (42,1,'Chad','TCD','TD');
INSERT INTO mos_pshop_country VALUES (43,1,'Chile','CHL','CL');
INSERT INTO mos_pshop_country VALUES (44,1,'China','CHN','CN');
INSERT INTO mos_pshop_country VALUES (45,1,'Christmas Island','CXR','CX');
INSERT INTO mos_pshop_country VALUES (46,1,'Cocos (Keeling) Islands','CCK','CC');
INSERT INTO mos_pshop_country VALUES (47,1,'Colombia','COL','CO');
INSERT INTO mos_pshop_country VALUES (48,1,'Comoros','COM','KM');
INSERT INTO mos_pshop_country VALUES (49,1,'Congo','COG','CG');
INSERT INTO mos_pshop_country VALUES (50,1,'Cook Islands','COK','CK');
INSERT INTO mos_pshop_country VALUES (51,1,'Costa Rica','CRI','CR');
INSERT INTO mos_pshop_country VALUES (52,1,'Cote D\'Ivoire','CIV','CI');
INSERT INTO mos_pshop_country VALUES (53,1,'Croatia','HRV','HR');
INSERT INTO mos_pshop_country VALUES (54,1,'Cuba','CUB','CU');
INSERT INTO mos_pshop_country VALUES (55,1,'Cyprus','CYP','CY');
INSERT INTO mos_pshop_country VALUES (56,1,'Czech Republic','CZE','CZ');
INSERT INTO mos_pshop_country VALUES (57,1,'Denmark','DNK','DK');
INSERT INTO mos_pshop_country VALUES (58,1,'Djibouti','DJI','DJ');
INSERT INTO mos_pshop_country VALUES (59,1,'Dominica','DMA','DM');
INSERT INTO mos_pshop_country VALUES (60,1,'Dominican Republic','DOM','DO');
INSERT INTO mos_pshop_country VALUES (61,1,'East Timor','TMP','TP');
INSERT INTO mos_pshop_country VALUES (62,1,'Ecuador','ECU','EC');
INSERT INTO mos_pshop_country VALUES (63,1,'Egypt','EGY','EG');
INSERT INTO mos_pshop_country VALUES (64,1,'El Salvador','SLV','SV');
INSERT INTO mos_pshop_country VALUES (65,1,'Equatorial Guinea','GNQ','GQ');
INSERT INTO mos_pshop_country VALUES (66,1,'Eritrea','ERI','ER');
INSERT INTO mos_pshop_country VALUES (67,1,'Estonia','EST','EE');
INSERT INTO mos_pshop_country VALUES (68,1,'Ethiopia','ETH','ET');
INSERT INTO mos_pshop_country VALUES (69,1,'Falkland Islands (Malvinas)','FLK','FK');
INSERT INTO mos_pshop_country VALUES (70,1,'Faroe Islands','FRO','FO');
INSERT INTO mos_pshop_country VALUES (71,1,'Fiji','FJI','FJ');
INSERT INTO mos_pshop_country VALUES (72,1,'Finland','FIN','FI');
INSERT INTO mos_pshop_country VALUES (73,1,'France','FRA','FR');
INSERT INTO mos_pshop_country VALUES (74,1,'France, Metropolitan','FXX','FX');
INSERT INTO mos_pshop_country VALUES (75,1,'French Guiana','GUF','GF');
INSERT INTO mos_pshop_country VALUES (76,1,'French Polynesia','PYF','PF');
INSERT INTO mos_pshop_country VALUES (77,1,'French Southern Territories','ATF','TF');
INSERT INTO mos_pshop_country VALUES (78,1,'Gabon','GAB','GA');
INSERT INTO mos_pshop_country VALUES (79,1,'Gambia','GMB','GM');
INSERT INTO mos_pshop_country VALUES (80,1,'Georgia','GEO','GE');
INSERT INTO mos_pshop_country VALUES (81,1,'Germany','DEU','DE');
INSERT INTO mos_pshop_country VALUES (82,1,'Ghana','GHA','GH');
INSERT INTO mos_pshop_country VALUES (83,1,'Gibraltar','GIB','GI');
INSERT INTO mos_pshop_country VALUES (84,1,'Greece','GRC','GR');
INSERT INTO mos_pshop_country VALUES (85,1,'Greenland','GRL','GL');
INSERT INTO mos_pshop_country VALUES (86,1,'Grenada','GRD','GD');
INSERT INTO mos_pshop_country VALUES (87,1,'Guadeloupe','GLP','GP');
INSERT INTO mos_pshop_country VALUES (88,1,'Guam','GUM','GU');
INSERT INTO mos_pshop_country VALUES (89,1,'Guatemala','GTM','GT');
INSERT INTO mos_pshop_country VALUES (90,1,'Guinea','GIN','GN');
INSERT INTO mos_pshop_country VALUES (91,1,'Guinea-bissau','GNB','GW');
INSERT INTO mos_pshop_country VALUES (92,1,'Guyana','GUY','GY');
INSERT INTO mos_pshop_country VALUES (93,1,'Haiti','HTI','HT');
INSERT INTO mos_pshop_country VALUES (94,1,'Heard and Mc Donald Islands','HMD','HM');
INSERT INTO mos_pshop_country VALUES (95,1,'Honduras','HND','HN');
INSERT INTO mos_pshop_country VALUES (96,1,'Hong Kong','HKG','HK');
INSERT INTO mos_pshop_country VALUES (97,1,'Hungary','HUN','HU');
INSERT INTO mos_pshop_country VALUES (98,1,'Iceland','ISL','IS');
INSERT INTO mos_pshop_country VALUES (99,1,'India','IND','IN');
INSERT INTO mos_pshop_country VALUES (100,1,'Indonesia','IDN','ID');
INSERT INTO mos_pshop_country VALUES (101,1,'Iran (Islamic Republic of)','IRN','IR');
INSERT INTO mos_pshop_country VALUES (102,1,'Iraq','IRQ','IQ');
INSERT INTO mos_pshop_country VALUES (103,1,'Ireland','IRL','IE');
INSERT INTO mos_pshop_country VALUES (104,1,'Israel','ISR','IL');
INSERT INTO mos_pshop_country VALUES (105,1,'Italy','ITA','IT');
INSERT INTO mos_pshop_country VALUES (106,1,'Jamaica','JAM','JM');
INSERT INTO mos_pshop_country VALUES (107,1,'Japan','JPN','JP');
INSERT INTO mos_pshop_country VALUES (108,1,'Jordan','JOR','JO');
INSERT INTO mos_pshop_country VALUES (109,1,'Kazakhstan','KAZ','KZ');
INSERT INTO mos_pshop_country VALUES (110,1,'Kenya','KEN','KE');
INSERT INTO mos_pshop_country VALUES (111,1,'Kiribati','KIR','KI');
INSERT INTO mos_pshop_country VALUES (112,1,'Korea, Democratic People\'s Republic of','PRK','KP');
INSERT INTO mos_pshop_country VALUES (113,1,'Korea, Republic of','KOR','KR');
INSERT INTO mos_pshop_country VALUES (114,1,'Kuwait','KWT','KW');
INSERT INTO mos_pshop_country VALUES (115,1,'Kyrgyzstan','KGZ','KG');
INSERT INTO mos_pshop_country VALUES (116,1,'Lao People\'s Democratic Republic','LAO','LA');
INSERT INTO mos_pshop_country VALUES (117,1,'Latvia','LVA','LV');
INSERT INTO mos_pshop_country VALUES (118,1,'Lebanon','LBN','LB');
INSERT INTO mos_pshop_country VALUES (119,1,'Lesotho','LSO','LS');
INSERT INTO mos_pshop_country VALUES (120,1,'Liberia','LBR','LR');
INSERT INTO mos_pshop_country VALUES (121,1,'Libyan Arab Jamahiriya','LBY','LY');
INSERT INTO mos_pshop_country VALUES (122,1,'Liechtenstein','LIE','LI');
INSERT INTO mos_pshop_country VALUES (123,1,'Lithuania','LTU','LT');
INSERT INTO mos_pshop_country VALUES (124,1,'Luxembourg','LUX','LU');
INSERT INTO mos_pshop_country VALUES (125,1,'Macau','MAC','MO');
INSERT INTO mos_pshop_country VALUES (126,1,'Macedonia, The Former Yugoslav Republic of','MKD','MK');
INSERT INTO mos_pshop_country VALUES (127,1,'Madagascar','MDG','MG');
INSERT INTO mos_pshop_country VALUES (128,1,'Malawi','MWI','MW');
INSERT INTO mos_pshop_country VALUES (129,1,'Malaysia','MYS','MY');
INSERT INTO mos_pshop_country VALUES (130,1,'Maldives','MDV','MV');
INSERT INTO mos_pshop_country VALUES (131,1,'Mali','MLI','ML');
INSERT INTO mos_pshop_country VALUES (132,1,'Malta','MLT','MT');
INSERT INTO mos_pshop_country VALUES (133,1,'Marshall Islands','MHL','MH');
INSERT INTO mos_pshop_country VALUES (134,1,'Martinique','MTQ','MQ');
INSERT INTO mos_pshop_country VALUES (135,1,'Mauritania','MRT','MR');
INSERT INTO mos_pshop_country VALUES (136,1,'Mauritius','MUS','MU');
INSERT INTO mos_pshop_country VALUES (137,1,'Mayotte','MYT','YT');
INSERT INTO mos_pshop_country VALUES (138,1,'Mexico','MEX','MX');
INSERT INTO mos_pshop_country VALUES (139,1,'Micronesia, Federated States of','FSM','FM');
INSERT INTO mos_pshop_country VALUES (140,1,'Moldova, Republic of','MDA','MD');
INSERT INTO mos_pshop_country VALUES (141,1,'Monaco','MCO','MC');
INSERT INTO mos_pshop_country VALUES (142,1,'Mongolia','MNG','MN');
INSERT INTO mos_pshop_country VALUES (143,1,'Montserrat','MSR','MS');
INSERT INTO mos_pshop_country VALUES (144,1,'Morocco','MAR','MA');
INSERT INTO mos_pshop_country VALUES (145,1,'Mozambique','MOZ','MZ');
INSERT INTO mos_pshop_country VALUES (146,1,'Myanmar','MMR','MM');
INSERT INTO mos_pshop_country VALUES (147,1,'Namibia','NAM','NA');
INSERT INTO mos_pshop_country VALUES (148,1,'Nauru','NRU','NR');
INSERT INTO mos_pshop_country VALUES (149,1,'Nepal','NPL','NP');
INSERT INTO mos_pshop_country VALUES (150,1,'Netherlands','NLD','NL');
INSERT INTO mos_pshop_country VALUES (151,1,'Netherlands Antilles','ANT','AN');
INSERT INTO mos_pshop_country VALUES (152,1,'New Caledonia','NCL','NC');
INSERT INTO mos_pshop_country VALUES (153,1,'New Zealand','NZL','NZ');
INSERT INTO mos_pshop_country VALUES (154,1,'Nicaragua','NIC','NI');
INSERT INTO mos_pshop_country VALUES (155,1,'Niger','NER','NE');
INSERT INTO mos_pshop_country VALUES (156,1,'Nigeria','NGA','NG');
INSERT INTO mos_pshop_country VALUES (157,1,'Niue','NIU','NU');
INSERT INTO mos_pshop_country VALUES (158,1,'Norfolk Island','NFK','NF');
INSERT INTO mos_pshop_country VALUES (159,1,'Northern Mariana Islands','MNP','MP');
INSERT INTO mos_pshop_country VALUES (160,1,'Norway','NOR','NO');
INSERT INTO mos_pshop_country VALUES (161,1,'Oman','OMN','OM');
INSERT INTO mos_pshop_country VALUES (162,1,'Pakistan','PAK','PK');
INSERT INTO mos_pshop_country VALUES (163,1,'Palau','PLW','PW');
INSERT INTO mos_pshop_country VALUES (164,1,'Panama','PAN','PA');
INSERT INTO mos_pshop_country VALUES (165,1,'Papua New Guinea','PNG','PG');
INSERT INTO mos_pshop_country VALUES (166,1,'Paraguay','PRY','PY');
INSERT INTO mos_pshop_country VALUES (167,1,'Peru','PER','PE');
INSERT INTO mos_pshop_country VALUES (168,1,'Philippines','PHL','PH');
INSERT INTO mos_pshop_country VALUES (169,1,'Pitcairn','PCN','PN');
INSERT INTO mos_pshop_country VALUES (170,1,'Poland','POL','PL');
INSERT INTO mos_pshop_country VALUES (171,1,'Portugal','PRT','PT');
INSERT INTO mos_pshop_country VALUES (172,1,'Puerto Rico','PRI','PR');
INSERT INTO mos_pshop_country VALUES (173,1,'Qatar','QAT','QA');
INSERT INTO mos_pshop_country VALUES (174,1,'Reunion','REU','RE');
INSERT INTO mos_pshop_country VALUES (175,1,'Romania','ROM','RO');
INSERT INTO mos_pshop_country VALUES (176,1,'Russian Federation','RUS','RU');
INSERT INTO mos_pshop_country VALUES (177,1,'Rwanda','RWA','RW');
INSERT INTO mos_pshop_country VALUES (178,1,'Saint Kitts and Nevis','KNA','KN');
INSERT INTO mos_pshop_country VALUES (179,1,'Saint Lucia','LCA','LC');
INSERT INTO mos_pshop_country VALUES (180,1,'Saint Vincent and the Grenadines','VCT','VC');
INSERT INTO mos_pshop_country VALUES (181,1,'Samoa','WSM','WS');
INSERT INTO mos_pshop_country VALUES (182,1,'San Marino','SMR','SM');
INSERT INTO mos_pshop_country VALUES (183,1,'Sao Tome and Principe','STP','ST');
INSERT INTO mos_pshop_country VALUES (184,1,'Saudi Arabia','SAU','SA');
INSERT INTO mos_pshop_country VALUES (185,1,'Senegal','SEN','SN');
INSERT INTO mos_pshop_country VALUES (186,1,'Seychelles','SYC','SC');
INSERT INTO mos_pshop_country VALUES (187,1,'Sierra Leone','SLE','SL');
INSERT INTO mos_pshop_country VALUES (188,1,'Singapore','SGP','SG');
INSERT INTO mos_pshop_country VALUES (189,1,'Slovakia (Slovak Republic)','SVK','SK');
INSERT INTO mos_pshop_country VALUES (190,1,'Slovenia','SVN','SI');
INSERT INTO mos_pshop_country VALUES (191,1,'Solomon Islands','SLB','SB');
INSERT INTO mos_pshop_country VALUES (192,1,'Somalia','SOM','SO');
INSERT INTO mos_pshop_country VALUES (193,1,'South Africa','ZAF','ZA');
INSERT INTO mos_pshop_country VALUES (194,1,'South Georgia and the South Sandwich Islands','SGS','GS');
INSERT INTO mos_pshop_country VALUES (195,1,'Spain','ESP','ES');
INSERT INTO mos_pshop_country VALUES (196,1,'Sri Lanka','LKA','LK');
INSERT INTO mos_pshop_country VALUES (197,1,'St. Helena','SHN','SH');
INSERT INTO mos_pshop_country VALUES (198,1,'St. Pierre and Miquelon','SPM','PM');
INSERT INTO mos_pshop_country VALUES (199,1,'Sudan','SDN','SD');
INSERT INTO mos_pshop_country VALUES (200,1,'Suriname','SUR','SR');
INSERT INTO mos_pshop_country VALUES (201,1,'Svalbard and Jan Mayen Islands','SJM','SJ');
INSERT INTO mos_pshop_country VALUES (202,1,'Swaziland','SWZ','SZ');
INSERT INTO mos_pshop_country VALUES (203,1,'Sweden','SWE','SE');
INSERT INTO mos_pshop_country VALUES (204,1,'Switzerland','CHE','CH');
INSERT INTO mos_pshop_country VALUES (205,1,'Syrian Arab Republic','SYR','SY');
INSERT INTO mos_pshop_country VALUES (206,1,'Taiwan','TWN','TW');
INSERT INTO mos_pshop_country VALUES (207,1,'Tajikistan','TJK','TJ');
INSERT INTO mos_pshop_country VALUES (208,1,'Tanzania, United Republic of','TZA','TZ');
INSERT INTO mos_pshop_country VALUES (209,1,'Thailand','THA','TH');
INSERT INTO mos_pshop_country VALUES (210,1,'Togo','TGO','TG');
INSERT INTO mos_pshop_country VALUES (211,1,'Tokelau','TKL','TK');
INSERT INTO mos_pshop_country VALUES (212,1,'Tonga','TON','TO');
INSERT INTO mos_pshop_country VALUES (213,1,'Trinidad and Tobago','TTO','TT');
INSERT INTO mos_pshop_country VALUES (214,1,'Tunisia','TUN','TN');
INSERT INTO mos_pshop_country VALUES (215,1,'Turkey','TUR','TR');
INSERT INTO mos_pshop_country VALUES (216,1,'Turkmenistan','TKM','TM');
INSERT INTO mos_pshop_country VALUES (217,1,'Turks and Caicos Islands','TCA','TC');
INSERT INTO mos_pshop_country VALUES (218,1,'Tuvalu','TUV','TV');
INSERT INTO mos_pshop_country VALUES (219,1,'Uganda','UGA','UG');
INSERT INTO mos_pshop_country VALUES (220,1,'Ukraine','UKR','UA');
INSERT INTO mos_pshop_country VALUES (221,1,'United Arab Emirates','ARE','AE');
INSERT INTO mos_pshop_country VALUES (222,1,'United Kingdom','GBR','GB');
INSERT INTO mos_pshop_country VALUES (223,1,'United States','USA','US');
INSERT INTO mos_pshop_country VALUES (224,1,'United States Minor Outlying Islands','UMI','UM');
INSERT INTO mos_pshop_country VALUES (225,1,'Uruguay','URY','UY');
INSERT INTO mos_pshop_country VALUES (226,1,'Uzbekistan','UZB','UZ');
INSERT INTO mos_pshop_country VALUES (227,1,'Vanuatu','VUT','VU');
INSERT INTO mos_pshop_country VALUES (228,1,'Vatican City State (Holy See)','VAT','VA');
INSERT INTO mos_pshop_country VALUES (229,1,'Venezuela','VEN','VE');
INSERT INTO mos_pshop_country VALUES (230,1,'Viet Nam','VNM','VN');
INSERT INTO mos_pshop_country VALUES (231,1,'Virgin Islands (British)','VGB','VG');
INSERT INTO mos_pshop_country VALUES (232,1,'Virgin Islands (U.S.)','VIR','VI');
INSERT INTO mos_pshop_country VALUES (233,1,'Wallis and Futuna Islands','WLF','WF');
INSERT INTO mos_pshop_country VALUES (234,1,'Western Sahara','ESH','EH');
INSERT INTO mos_pshop_country VALUES (235,1,'Yemen','YEM','YE');
INSERT INTO mos_pshop_country VALUES (236,1,'Yugoslavia','YUG','YU');
INSERT INTO mos_pshop_country VALUES (237,1,'Zaire','ZAR','ZR');
INSERT INTO mos_pshop_country VALUES (238,1,'Zambia','ZMB','ZM');
INSERT INTO mos_pshop_country VALUES (239,1,'Zimbabwe','ZWE','ZW');
#
# Table structure for table `mos_pshop_coupons`
#
DROP table IF EXISTS mos_pshop_coupons;
CREATE TABLE `mos_pshop_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (`coupon_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_coupons`
#
INSERT INTO mos_pshop_coupons VALUES (1,'test1',total,gift,6.00);
INSERT INTO mos_pshop_coupons VALUES (2,'test2',percent,permanent,15.00);
INSERT INTO mos_pshop_coupons VALUES (3,'test3',total,permanent,4.00);
INSERT INTO mos_pshop_coupons VALUES (4,'test4',total,gift,15.00);
#
# Table structure for table `mos_pshop_creditcard`
#
DROP table IF EXISTS mos_pshop_creditcard;
CREATE TABLE `mos_pshop_creditcard` (
`creditcard_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`creditcard_name` varchar(70) NOT NULL default '',
`creditcard_code` varchar(30) NOT NULL default '',
PRIMARY KEY (`creditcard_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_creditcard`
#
INSERT INTO mos_pshop_creditcard VALUES (1,1,'Visa','VISA');
INSERT INTO mos_pshop_creditcard VALUES (2,1,'MasterCard','MC');
INSERT INTO mos_pshop_creditcard VALUES (3,1,'American Express','amex');
INSERT INTO mos_pshop_creditcard VALUES (4,1,'Discover Card','discover');
INSERT INTO mos_pshop_creditcard VALUES (5,1,'Diners Club','diners');
INSERT INTO mos_pshop_creditcard VALUES (6,1,'JCB','jcb');
INSERT INTO mos_pshop_creditcard VALUES (7,1,'Australian Bankcard','australian_bc');
#
# Table structure for table `mos_pshop_csv`
#
DROP table IF EXISTS mos_pshop_csv;
CREATE TABLE `mos_pshop_csv` (
`csv_product_sku` int(2) default NULL,
`csv_product_s_desc` int(2) default NULL,
`csv_product_desc` int(2) default NULL,
`csv_product_thumb_image` int(2) default NULL,
`csv_product_full_image` int(2) default NULL,
`csv_product_weight` int(2) default NULL,
`csv_product_weight_uom` int(2) default NULL,
`csv_product_length` int(2) default NULL,
`csv_product_width` int(2) default NULL,
`csv_product_height` int(2) default NULL,
`csv_product_lwh_uom` int(2) default NULL,
`csv_product_in_stock` int(2) default NULL,
`csv_product_available_date` int(2) default NULL,
`csv_product_special` int(2) default NULL,
`csv_product_discount_id` int(2) default NULL,
`csv_product_name` int(2) default NULL,
`csv_product_price` int(2) default NULL,
`csv_category_path` int(2) default NULL,
`csv_manufacturer_id` int(2) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_csv`
#
INSERT INTO mos_pshop_csv VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19);
#
# Table structure for table `mos_pshop_currency`
#
DROP table IF EXISTS mos_pshop_currency;
CREATE TABLE `mos_pshop_currency` (
`currency_id` int(11) NOT NULL auto_increment,
`currency_name` varchar(64) default NULL,
`currency_code` char(3) default NULL,
PRIMARY KEY (`currency_id`),
KEY `idx_currency_name` (`currency_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_currency`
#
INSERT INTO mos_pshop_currency VALUES (1,'Andorran Peseta','ADP');
INSERT INTO mos_pshop_currency VALUES (2,'United Arab Emirates Dirham','AED');
INSERT INTO mos_pshop_currency VALUES (3,'Afghanistan Afghani','AFA');
INSERT INTO mos_pshop_currency VALUES (4,'Albanian Lek','ALL');
INSERT INTO mos_pshop_currency VALUES (5,'Netherlands Antillian Guilder','ANG');
INSERT INTO mos_pshop_currency VALUES (6,'Angolan Kwanza','AOK');
INSERT INTO mos_pshop_currency VALUES (7,'Argentinian Austral','ARA');
INSERT INTO mos_pshop_currency VALUES (9,'Australian Dollar','AUD');
INSERT INTO mos_pshop_currency VALUES (10,'Aruban Florin','AWG');
INSERT INTO mos_pshop_currency VALUES (11,'Barbados Dollar','BBD');
INSERT INTO mos_pshop_currency VALUES (12,'Bangladeshi Taka','BDT');
INSERT INTO mos_pshop_currency VALUES (14,'Bulgarian Lev','BGL');
INSERT INTO mos_pshop_currency VALUES (15,'Bahraini Dinar','BHD');
INSERT INTO mos_pshop_currency VALUES (16,'Burundi Franc','BIF');
INSERT INTO mos_pshop_currency VALUES (17,'Bermudian Dollar','BMD');
INSERT INTO mos_pshop_currency VALUES (18,'Brunei Dollar','BND');
INSERT INTO mos_pshop_currency VALUES (19,'Bolivian Boliviano','BOB');
INSERT INTO mos_pshop_currency VALUES (20,'Brazilian Real','BRL');
INSERT INTO mos_pshop_currency VALUES (21,'Bahamian Dollar','BSD');
INSERT INTO mos_pshop_currency VALUES (22,'Bhutan Ngultrum','BTN');
INSERT INTO mos_pshop_currency VALUES (23,'Burma Kyat','BUK');
INSERT INTO mos_pshop_currency VALUES (24,'Botswanian Pula','BWP');
INSERT INTO mos_pshop_currency VALUES (25,'Belize Dollar','BZD');
INSERT INTO mos_pshop_currency VALUES (26,'Canadian Dollar','CAD');
INSERT INTO mos_pshop_currency VALUES (27,'Swiss Franc','CHF');
INSERT INTO mos_pshop_currency VALUES (28,'Chilean Unidades de Fomento','CLF');
INSERT INTO mos_pshop_currency VALUES (29,'Chilean Peso','CLP');
INSERT INTO mos_pshop_currency VALUES (30,'Yuan (Chinese) Renminbi','CNY');
INSERT INTO mos_pshop_currency VALUES (31,'Colombian Peso','COP');
INSERT INTO mos_pshop_currency VALUES (32,'Costa Rican Colon','CRC');
INSERT INTO mos_pshop_currency VALUES (33,'Czech Koruna','CSK');
INSERT INTO mos_pshop_currency VALUES (34,'Cuban Peso','CUP');
INSERT INTO mos_pshop_currency VALUES (35,'Cape Verde Escudo','CVE');
INSERT INTO mos_pshop_currency VALUES (36,'Cyprus Pound','CYP');
INSERT INTO mos_pshop_currency VALUES (40,'Danish Krone','DKK');
INSERT INTO mos_pshop_currency VALUES (41,'Dominican Peso','DOP');
INSERT INTO mos_pshop_currency VALUES (42,'Algerian Dinar','DZD');
INSERT INTO mos_pshop_currency VALUES (43,'Ecuador Sucre','ECS');
INSERT INTO mos_pshop_currency VALUES (44,'Egyptian Pound','EGP');
INSERT INTO mos_pshop_currency VALUES (46,'Ethiopian Birr','ETB');
INSERT INTO mos_pshop_currency VALUES (47,'Euro','EUR');
INSERT INTO mos_pshop_currency VALUES (49,'Fiji Dollar','FJD');
INSERT INTO mos_pshop_currency VALUES (50,'Falkland Islands Pound','FKP');
INSERT INTO mos_pshop_currency VALUES (52,'British Pound','GBP');
INSERT INTO mos_pshop_currency VALUES (53,'Ghanaian Cedi','GHC');
INSERT INTO mos_pshop_currency VALUES (54,'Gibraltar Pound','GIP');
INSERT INTO mos_pshop_currency VALUES (55,'Gambian Dalasi','GMD');
INSERT INTO mos_pshop_currency VALUES (56,'Guinea Franc','GNF');
INSERT INTO mos_pshop_currency VALUES (58,'Guatemalan Quetzal','GTQ');
INSERT INTO mos_pshop_currency VALUES (59,'Guinea-Bissau Peso','GWP');
INSERT INTO mos_pshop_currency VALUES (60,'Guyanan Dollar','GYD');
INSERT INTO mos_pshop_currency VALUES (61,'Hong Kong Dollar','HKD');
INSERT INTO mos_pshop_currency VALUES (62,'Honduran Lempira','HNL');
INSERT INTO mos_pshop_currency VALUES (63,'Haitian Gourde','HTG');
INSERT INTO mos_pshop_currency VALUES (64,'Hungarian Forint','HUF');
INSERT INTO mos_pshop_currency VALUES (65,'Indonesian Rupiah','IDR');
INSERT INTO mos_pshop_currency VALUES (66,'Irish Punt','IEP');
INSERT INTO mos_pshop_currency VALUES (67,'Israeli Shekel','ILS');
INSERT INTO mos_pshop_currency VALUES (68,'Indian Rupee','INR');
INSERT INTO mos_pshop_currency VALUES (69,'Iraqi Dinar','IQD');
INSERT INTO mos_pshop_currency VALUES (70,'Iranian Rial','IRR');
INSERT INTO mos_pshop_currency VALUES (73,'Jamaican Dollar','JMD');
INSERT INTO mos_pshop_currency VALUES (74,'Jordanian Dinar','JOD');
INSERT INTO mos_pshop_currency VALUES (75,'Japanese Yen','JPY');
INSERT INTO mos_pshop_currency VALUES (76,'Kenyan Schilling','KES');
INSERT INTO mos_pshop_currency VALUES (77,'Kampuchean (Cambodian) Riel','KHR');
INSERT INTO mos_pshop_currency VALUES (78,'Comoros Franc','KMF');
INSERT INTO mos_pshop_currency VALUES (79,'North Korean Won','KPW');
INSERT INTO mos_pshop_currency VALUES (80,'(South) Korean Won','KRW');
INSERT INTO mos_pshop_currency VALUES (81,'Kuwaiti Dinar','KWD');
INSERT INTO mos_pshop_currency VALUES (82,'Cayman Islands Dollar','KYD');
INSERT INTO mos_pshop_currency VALUES (83,'Lao Kip','LAK');
INSERT INTO mos_pshop_currency VALUES (84,'Lebanese Pound','LBP');
INSERT INTO mos_pshop_currency VALUES (85,'Sri Lanka Rupee','LKR');
INSERT INTO mos_pshop_currency VALUES (86,'Liberian Dollar','LRD');
INSERT INTO mos_pshop_currency VALUES (87,'Lesotho Loti','LSL');
INSERT INTO mos_pshop_currency VALUES (89,'Libyan Dinar','LYD');
INSERT INTO mos_pshop_currency VALUES (90,'Moroccan Dirham','MAD');
INSERT INTO mos_pshop_currency VALUES (91,'Malagasy Franc','MGF');
INSERT INTO mos_pshop_currency VALUES (92,'Mongolian Tugrik','MNT');
INSERT INTO mos_pshop_currency VALUES (93,'Macau Pataca','MOP');
INSERT INTO mos_pshop_currency VALUES (94,'Mauritanian Ouguiya','MRO');
INSERT INTO mos_pshop_currency VALUES (95,'Maltese Lira','MTL');
INSERT INTO mos_pshop_currency VALUES (96,'Mauritius Rupee','MUR');
INSERT INTO mos_pshop_currency VALUES (97,'Maldive Rufiyaa','MVR');
INSERT INTO mos_pshop_currency VALUES (98,'Malawi Kwacha','MWK');
INSERT INTO mos_pshop_currency VALUES (99,'Mexican Peso','MXP');
INSERT INTO mos_pshop_currency VALUES (100,'Malaysian Ringgit','MYR');
INSERT INTO mos_pshop_currency VALUES (101,'Mozambique Metical','MZM');
INSERT INTO mos_pshop_currency VALUES (102,'Nigerian Naira','NGN');
INSERT INTO mos_pshop_currency VALUES (103,'Nicaraguan Cordoba','NIC');
INSERT INTO mos_pshop_currency VALUES (105,'Norwegian Kroner','NOK');
INSERT INTO mos_pshop_currency VALUES (106,'Nepalese Rupee','NPR');
INSERT INTO mos_pshop_currency VALUES (107,'New Zealand Dollar','NZD');
INSERT INTO mos_pshop_currency VALUES (108,'Omani Rial','OMR');
INSERT INTO mos_pshop_currency VALUES (109,'Panamanian Balboa','PAB');
INSERT INTO mos_pshop_currency VALUES (110,'Peruvian Inti','PEI');
INSERT INTO mos_pshop_currency VALUES (111,'Papua New Guinea Kina','PGK');
INSERT INTO mos_pshop_currency VALUES (112,'Philippine Peso','PHP');
INSERT INTO mos_pshop_currency VALUES (113,'Pakistan Rupee','PKR');
INSERT INTO mos_pshop_currency VALUES (114,'Polish Zloty','PLZ');
INSERT INTO mos_pshop_currency VALUES (116,'Paraguay Guarani','PYG');
INSERT INTO mos_pshop_currency VALUES (117,'Qatari Rial','QAR');
INSERT INTO mos_pshop_currency VALUES (118,'Romanian Leu','ROL');
INSERT INTO mos_pshop_currency VALUES (119,'Rwanda Franc','RWF');
INSERT INTO mos_pshop_currency VALUES (120,'Saudi Arabian Riyal','SAR');
INSERT INTO mos_pshop_currency VALUES (121,'Solomon Islands Dollar','SBD');
INSERT INTO mos_pshop_currency VALUES (122,'Seychelles Rupee','SCR');
INSERT INTO mos_pshop_currency VALUES (123,'Sudanese Pound','SDP');
INSERT INTO mos_pshop_currency VALUES (124,'Swedish Krona','SEK');
INSERT INTO mos_pshop_currency VALUES (125,'Singapore Dollar','SGD');
INSERT INTO mos_pshop_currency VALUES (126,'St. Helena Pound','SHP');
INSERT INTO mos_pshop_currency VALUES (127,'Sierra Leone Leone','SLL');
INSERT INTO mos_pshop_currency VALUES (128,'Somali Schilling','SOS');
INSERT INTO mos_pshop_currency VALUES (129,'Suriname Guilder','SRG');
INSERT INTO mos_pshop_currency VALUES (130,'Sao Tome and Principe Dobra','STD');
INSERT INTO mos_pshop_currency VALUES (131,'USSR Rouble','SUR');
INSERT INTO mos_pshop_currency VALUES (132,'El Salvador Colon','SVC');
INSERT INTO mos_pshop_currency VALUES (133,'Syrian Potmd','SYP');
INSERT INTO mos_pshop_currency VALUES (134,'Swaziland Lilangeni','SZL');
INSERT INTO mos_pshop_currency VALUES (135,'Thai Bath','THB');
INSERT INTO mos_pshop_currency VALUES (136,'Tunisian Dinar','TND');
INSERT INTO mos_pshop_currency VALUES (137,'Tongan Pa\'anga','TOP');
INSERT INTO mos_pshop_currency VALUES (138,'East Timor Escudo','TPE');
INSERT INTO mos_pshop_currency VALUES (139,'Turkish Lira','TRL');
INSERT INTO mos_pshop_currency VALUES (140,'Trinidad and Tobago Dollar','TTD');
INSERT INTO mos_pshop_currency VALUES (141,'Taiwan Dollar','TWD');
INSERT INTO mos_pshop_currency VALUES (142,'Tanzanian Schilling','TZS');
INSERT INTO mos_pshop_currency VALUES (143,'Uganda Shilling','UGS');
INSERT INTO mos_pshop_currency VALUES (144,'US Dollar','USD');
INSERT INTO mos_pshop_currency VALUES (145,'Uruguayan Peso','UYP');
INSERT INTO mos_pshop_currency VALUES (146,'Venezualan Bolivar','VEB');
INSERT INTO mos_pshop_currency VALUES (147,'Vietnamese Dong','VND');
INSERT INTO mos_pshop_currency VALUES (148,'Vanuatu Vatu','VUV');
INSERT INTO mos_pshop_currency VALUES (149,'Samoan Tala','WST');
INSERT INTO mos_pshop_currency VALUES (150,'Democratic Yemeni Dinar','YDD');
INSERT INTO mos_pshop_currency VALUES (151,'Yemeni Rial','YER');
INSERT INTO mos_pshop_currency VALUES (152,'New Yugoslavia Dinar','YUD');
INSERT INTO mos_pshop_currency VALUES (153,'South African Rand','ZAR');
INSERT INTO mos_pshop_currency VALUES (154,'Zambian Kwacha','ZMK');
INSERT INTO mos_pshop_currency VALUES (155,'Zaire Zaire','ZRZ');
INSERT INTO mos_pshop_currency VALUES (156,'Zimbabwe Dollar','ZWD');
#
# Table structure for table `mos_pshop_function`
#
DROP table IF EXISTS mos_pshop_function;
CREATE TABLE `mos_pshop_function` (
`function_id` int(11) NOT NULL auto_increment,
`module_id` int(11) default NULL,
`function_name` varchar(32) default NULL,
`function_class` varchar(32) default NULL,
`function_method` varchar(32) default NULL,
`function_description` text,
`function_perms` varchar(255) default NULL,
PRIMARY KEY (`function_id`),
KEY `idx_function_module_id` (`module_id`),
KEY `idx_function_name` (`function_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_function`
#
INSERT INTO mos_pshop_function VALUES (1,1,'userAdd','ps_user','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (2,1,'userDelete','ps_user','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (3,1,'userUpdate','ps_user','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (4,1,'adminPasswdUpdate','ps_user','update_admin_passwd','Updates Site Administrator Password','admin');
INSERT INTO mos_pshop_function VALUES (31,2,'productAdd','ps_product','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (6,1,'functionAdd','ps_function','add','','admin');
INSERT INTO mos_pshop_function VALUES (7,1,'functionUpdate','ps_function','update','','admin');
INSERT INTO mos_pshop_function VALUES (8,1,'functionDelete','ps_function','delete','','admin');
INSERT INTO mos_pshop_function VALUES (9,1,'userLogout','ps_user','logout','','none');
INSERT INTO mos_pshop_function VALUES (10,1,'userAddressAdd','ps_user_address','add','','admin,storeadmin,shopper,demo');
INSERT INTO mos_pshop_function VALUES (11,1,'userAddressUpdate','ps_user_address','update','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (12,1,'userAddressDelete','ps_user_address','delete','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (13,1,'moduleAdd','ps_module','add','','admin');
INSERT INTO mos_pshop_function VALUES (14,1,'moduleUpdate','ps_module','update','','admin');
INSERT INTO mos_pshop_function VALUES (15,1,'moduleDelete','ps_module','delete','','admin');
INSERT INTO mos_pshop_function VALUES (16,1,'userLogin','ps_user','login','','none');
INSERT INTO mos_pshop_function VALUES (17,3,'vendorAdd','ps_vendor','add','','admin');
INSERT INTO mos_pshop_function VALUES (18,3,'vendorUpdate','ps_vendor','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (19,3,'vendorDelete','ps_vendor','delete','','admin');
INSERT INTO mos_pshop_function VALUES (20,3,'vendorCategoryAdd','ps_vendor_category','add','','admin');
INSERT INTO mos_pshop_function VALUES (21,3,'vendorCategoryUpdate','ps_vendor_category','update','','admin');
INSERT INTO mos_pshop_function VALUES (22,3,'vendorCategoryDelete','ps_vendor_category','delete','','admin');
INSERT INTO mos_pshop_function VALUES (23,4,'shopperAdd','ps_shopper','add','','none');
INSERT INTO mos_pshop_function VALUES (24,4,'shopperDelete','ps_shopper','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (25,4,'shopperUpdate','ps_shopper','update','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (26,4,'shopperGroupAdd','ps_shopper_group','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (27,4,'shopperGroupUpdate','ps_shopper_group','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (28,4,'shopperGroupDelete','ps_shopper_group','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (29,5,'orderSearch','ps_order','find','','admin,storeadmin,demo');
INSERT INTO mos_pshop_function VALUES (30,5,'orderStatusSet','ps_order','order_status_update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (32,2,'productDelete','ps_product','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (33,2,'productUpdate','ps_product','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (34,2,'productCategoryAdd','ps_product_category','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (35,2,'productCategoryUpdate','ps_product_category','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (36,2,'productCategoryDelete','ps_product_category','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (37,2,'productPriceAdd','ps_product_price','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (38,2,'productPriceUpdate','ps_product_price','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (39,2,'productPriceDelete','ps_product_price','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (40,2,'productAttributeAdd','ps_product_attribute','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (41,2,'productAttributeUpdate','ps_product_attribute','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (42,2,'productAttributeDelete','ps_product_attribute','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (43,7,'cartAdd','ps_cart','add','','none');
INSERT INTO mos_pshop_function VALUES (44,7,'cartUpdate','ps_cart','update','','none');
INSERT INTO mos_pshop_function VALUES (45,7,'cartDelete','ps_cart','delete','','none');
INSERT INTO mos_pshop_function VALUES (46,10,'checkoutComplete','ps_checkout','add','','shopper,storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (47,1,'setLanguage','ps_module','set_language','','none');
INSERT INTO mos_pshop_function VALUES (48,8,'paymentMethodUpdate','ps_payment_method','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (49,8,'paymentMethodAdd','ps_payment_method','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (50,8,'paymentMethodDelete','ps_payment_method','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (51,5,'orderDelete','ps_order','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (52,11,'addTaxRate','ps_tax','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (53,11,'updateTaxRate','ps_tax','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (54,11,'deleteTaxRate','ps_tax','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (55,10,'checkoutValidateST','ps_checkout','validate_shipto','','none');
INSERT INTO mos_pshop_function VALUES (59,5,'orderStatusUpdate','ps_order_status','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (60,5,'orderStatusAdd','ps_order_status','add','','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (61,5,'orderStatusDelete','ps_order_status','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (62,1,'currencyAdd','ps_currency','add','add a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (63,1,'currencyUpdate','ps_currency','update',' update a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (64,1,'currencyDelete','ps_currency','delete','delete a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (65,1,'countryAdd','ps_country','add','Add a country ','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (66,1,'countryUpdate','ps_country','update','Update a country record','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (67,1,'countryDelete','ps_country','delete','Delete a country record','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (68,2,'product_csv','ps_csv','upload_csv','','admin');
INSERT INTO mos_pshop_function VALUES (110,7,'waitingListAdd','zw_waiting_list','add','','none');
INSERT INTO mos_pshop_function VALUES (111,13,'addzone','ps_zone','add','This will add a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (112,13,'updatezone','ps_zone','update','This will update a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (113,13,'deletezone','ps_zone','delete','This will delete a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (114,13,'zoneassign','ps_zone','assign','This will assign a country to a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (115,1,'writeConfig','ps_config','writeconfig','This will write the configuration details to phpshop.cfg.php','admin');
INSERT INTO mos_pshop_function VALUES (116,12839,'carrierAdd','ps_shipping','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (117,12839,'carrierDelete','ps_shipping','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (118,12839,'carrierUpdate','ps_shipping','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (119,12839,'rateAdd','ps_shipping','rate_add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (120,12839,'rateUpdate','ps_shipping','rate_update','','admin,shopadmin');
INSERT INTO mos_pshop_function VALUES (121,12839,'rateDelete','ps_shipping','rate_delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (122,10,'checkoutProcess','ps_checkout','process','','shopper,storeadmin,admin,demo');
INSERT INTO mos_pshop_function VALUES (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');
INSERT INTO mos_pshop_function VALUES (124,98,'affiliateAdd','ps_affiliate','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (125,98,'affiliateUpdate','ps_affiliate','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (126,98,'affiliateDelete','ps_affiliate','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (127,98,'affiliateEmail','ps_affiliate','email','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (128,99,'manufacturerAdd','ps_manufacturer','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (129,99,'manufacturerUpdate','ps_manufacturer','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (130,99,'manufacturerDelete','ps_manufacturer','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (131,99,'manufacturercategoryAdd','ps_manufacturer_category','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (132,99,'manufacturercategoryUpdate','ps_manufacturer_category','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (133,99,'manufacturercategoryDelete','ps_manufacturer_category','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (134,7,'addReview','ps_reviews','process_review','This lets the user add a review and rating to a product.','admin,storeadmin,shopper,demo');
INSERT INTO mos_pshop_function VALUES (135,7,'productReviewDelete','ps_reviews','delete_review','This deletes a review and from a product.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (136,8,'creditcardAdd','ps_creditcard','add','Adds a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (137,8,'creditcardUpdate','ps_creditcard','update','Updates a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (138,8,'creditcardDelete','ps_creditcard','delete','Deletes a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (139,2,'publishProduct','ps_product','product_publish','Changes the product_publish field, so that a product can be published or unpublished easily.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (140,2,'export_csv','ps_csv','export_csv','This function exports all relevant product data to CSV.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (141,2,'reorder','ps_product_category','reorder','Changes the list order of a category.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (142,2,'discountAdd','ps_product_discount','add','Adds a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (143,2,'discountUpdate','ps_product_discount','update','Updates a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (144,2,'discountDelete','ps_product_discount','delete','Deletes a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (145,8,'shippingmethodSave','ps_shipping_method','save','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (146,2,'uploadProductFile','ps_product_files','add','Uploads and Adds a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (147,2,'updateProductFile','ps_product_files','update','Updates a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (148,2,'deleteProductFile','ps_product_files','delete','Deletes a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (149,12843,'couponAdd','ps_coupon','add_coupon_code','Adds a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (150,12843,'couponUpdate','ps_coupon','update_coupon','Updates a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (151,12843,'couponDelete','ps_coupon','remove_coupon_code','Deletes a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (152,12843,'couponProcess','ps_coupon','process_coupon_code','Processes a Coupon.','admin,storeadmin,shopper,demo');
#
# Table structure for table `mos_pshop_manufacturer`
#
DROP table IF EXISTS mos_pshop_manufacturer;
CREATE TABLE `mos_pshop_manufacturer` (
`manufacturer_id` int(11) NOT NULL auto_increment,
`mf_name` varchar(64) default NULL,
`mf_email` varchar(255) default NULL,
`mf_desc` text,
`mf_category_id` int(11) default NULL,
`mf_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`manufacturer_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_manufacturer`
#
INSERT INTO mos_pshop_manufacturer VALUES (1,'Manufacturer','info@manufacturer.com','An example for a manufacturer',1,'http://www.a-url.com');
#
# Table structure for table `mos_pshop_manufacturer_category`
#
DROP table IF EXISTS mos_pshop_manufacturer_category;
CREATE TABLE `mos_pshop_manufacturer_category` (
`mf_category_id` int(11) NOT NULL auto_increment,
`mf_category_name` varchar(64) default NULL,
`mf_category_desc` text,
PRIMARY KEY (`mf_category_id`),
KEY `idx_manufacturer_category_category_name` (`mf_category_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_manufacturer_category`
#
INSERT INTO mos_pshop_manufacturer_category VALUES (1,'-default-','This is the default manufacturer category');
#
# Table structure for table `mos_pshop_module`
#
DROP table IF EXISTS mos_pshop_module;
CREATE TABLE `mos_pshop_module` (
`module_id` int(11) NOT NULL auto_increment,
`module_name` varchar(255) default NULL,
`module_description` text,
`module_perms` varchar(255) default NULL,
`module_header` varchar(255) default NULL,
`module_footer` varchar(255) default NULL,
`module_publish` char(1) default NULL,
`list_order` int(11) default NULL,
`language_code_1` varchar(4) default NULL,
`language_code_2` varchar(4) default NULL,
`language_code_3` varchar(4) default NULL,
`language_code_4` varchar(4) default NULL,
`language_code_5` varchar(4) default NULL,
`language_file_1` varchar(255) default NULL,
`language_file_2` varchar(255) default NULL,
`language_file_3` varchar(255) default NULL,
`language_file_4` varchar(255) default NULL,
`language_file_5` varchar(255) default NULL,
`module_label_1` varchar(255) default NULL,
`module_label_2` varchar(255) default NULL,
`module_label_3` varchar(255) default NULL,
`module_label_4` varchar(255) default NULL,
`module_label_5` varchar(255) default NULL,
PRIMARY KEY (`module_id`),
KEY `idx_module_name` (`module_name`),
KEY `idx_module_list_order` (`list_order`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_module`
#
INSERT INTO mos_pshop_module VALUES (1,'admin','
ADMINISTRATIVE USERS ONLY
\r\n\r\n
Only used for the following:
\r\n\r\n\r\n
User Maintenance
\r\n
Module Maintenance
\r\n
Function Maintenance
\r\n\r\n','admin','header.ihtml','footer.ihtml','Y',1,'eng','esl','','','','lang_eng.inc','lang_esl.inc','','','','Admin','Admin','','','');
INSERT INTO mos_pshop_module VALUES (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','header.ihtml','footer.ihtml','Y',4,'eng','esl','','','','lang_en.inc','lang_es.inc','','','','Products','Mis Productos','','','');
INSERT INTO mos_pshop_module VALUES (3,'vendor','
ADMINISTRATIVE USERS ONLY
\r\n
Here you can manage the vendors on the phpShop system.
','admin','header.ihtml','footer.ihtml','Y',6,'eng','esl','','','','lang_en.inc','lang_es.inc','','','','Vendors','Los Distribuidores','','','');
INSERT INTO mos_pshop_module VALUES (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','header.ihtml','footer.ihtml','Y',4,'eng','esl','','','','lang_en.inc','lang_es.inc','','','','Shoppers','Mis Clientes','','','');
INSERT INTO mos_pshop_module VALUES (5,'order','
View Order and Update Order Status.
','admin,storeadmin','header.ihtml','footer.ihtml','Y',5,'eng','esl','','','','lang_en.inc','lang_es.inc','','','','Orders','Mis Ordenes','','','');
INSERT INTO mos_pshop_module VALUES (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','header.ihtml','footer.ihtml','N',99,'eng','esl','','','','lang_en.inc','','','','','Admin','','','','');
INSERT INTO mos_pshop_module VALUES (7,'shop','This is the Washupito store module. This is the demo store included with the phpShop distribution.','none','s_header.ihtml','s_footer.ihtml','Y',99,'eng','esl','','','','','','','','','Shop','Visita la Tienda','','','');
INSERT INTO mos_pshop_module VALUES (8,'store','','storeadmin,admin','header.ihtml','footer.ihtml','Y',2,'eng','esl','','','','lang_en.inc','lang_es.inc','','','','Store','Mi Tienda','','','');
INSERT INTO mos_pshop_module VALUES (9,'account','This module allows shoppers to update their account information and view previously placed orders.','shopper,storeadmin,admin,demo','s_header.ihtml','s_footer.ihtml','N',99,'eng','esl','','','','','','','','','Account','Account','','','');
INSERT INTO mos_pshop_module VALUES (10,'checkout','','none','s_header.ihtml','s_footer.ihtml','N',99,'eng','esl','','','','','','','','','Checkout','Checkout','','','');
INSERT INTO mos_pshop_module VALUES (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','header.ihtml','footer.ihtml','Y',8,'eng','esl','','','','','','','','','Taxes','Impuestos','','','');
INSERT INTO mos_pshop_module VALUES (12,'reportbasic','The report basic module allows you to do queries on all orders.','admin,storeadmin','header.ihtml','footer.ihtml','Y',7,'eng','esl','','','','','','','','','Report Basic','Report Basic','','','');
INSERT INTO mos_pshop_module VALUES (13,'zone','This is the zone-shipping module. Here you can manage your shipping costs according to Zones.','admin,storeadmin','header.ihtml','footer.ihtml','N',9,'eng','esl','','','','','','','','','Zone Shipping','Zone Shipping','','','');
INSERT INTO mos_pshop_module VALUES (12839,'shipping','
Shipping
Let this module calculate the shipping fees for your customers. Create carriers for shipping areas and weight groups.
','admin,storeadmin','header.ihtml','footer.ihtml','Y',10,'eng','ger','','','','','','','','','Shipping','Versand','','','');
INSERT INTO mos_pshop_module VALUES (98,'affiliate','administrate the affiliates on your store.','storeadmin,admin','header.ihtml','footer.ihtml','N',99,'EN','ES','','','','lang_en.inc','lang_es.inc','','','','affiliates','','','','');
INSERT INTO mos_pshop_module VALUES (99,'manufacturer','Manage the manufacturers of products in your store.','storeadmin,admin','header.ihtml','footer.ihtml','Y',12,'EN','ES','','','','lang_en.inc','lang_es.inc','','','','manufacturer','','','','');
INSERT INTO mos_pshop_module VALUES (12842,'help','Help for mambo-phpshop','admin,storeadmin','header.ihtml','footer.ihtml','Y',13,'eng','','','','','','','','','','Help','','','','');
INSERT INTO mos_pshop_module VALUES (12843,'coupon','Coupon Management','admin,storeadmin','header.ihtml','footer.ihtml','Y',11,'eng','','','','','','','','','','Coupon','','','','');
#
# Table structure for table `mos_pshop_order_item`
#
DROP table IF EXISTS mos_pshop_order_item;
CREATE TABLE `mos_pshop_order_item` (
`order_item_id` int(11) NOT NULL auto_increment,
`order_id` int(11) default NULL,
`user_info_id` varchar(32) default NULL,
`vendor_id` int(11) default NULL,
`product_id` int(11) default NULL,
`product_quantity` int(11) default NULL,
`product_item_price` decimal(10,2) default NULL,
`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`),
KEY `idx_order_item_product_id` (`product_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_order_item`
#
#
# Table structure for table `mos_pshop_order_payment`
#
DROP table IF EXISTS mos_pshop_order_payment;
CREATE TABLE `mos_pshop_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;
#
# Dumping data for table `mos_pshop_order_payment`
#
#
# Table structure for table `mos_pshop_order_status`
#
DROP table IF EXISTS mos_pshop_order_status;
CREATE TABLE `mos_pshop_order_status` (
`order_status_id` int(11) NOT NULL auto_increment,
`order_status_code` char(1) NOT NULL default '',
`order_status_name` varchar(64) default NULL,
`list_order` int(11) default NULL,
`vendor_id` int(11) default NULL,
PRIMARY KEY (`order_status_id`),
KEY `idx_order_status_list_order` (`list_order`),
KEY `idx_order_status_vendor_id` (`vendor_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_order_status`
#
INSERT INTO mos_pshop_order_status VALUES (1,'P','Pending',1,1);
INSERT INTO mos_pshop_order_status VALUES (2,'C','Confirmed',2,1);
INSERT INTO mos_pshop_order_status VALUES (3,'X','Cancelled',3,1);
INSERT INTO mos_pshop_order_status VALUES (4,'R','Refunded',4,1);
INSERT INTO mos_pshop_order_status VALUES (5,'S','Shipped',5,1);
#
# Table structure for table `mos_pshop_orders`
#
DROP table IF EXISTS mos_pshop_orders;
CREATE TABLE `mos_pshop_orders` (
`order_id` int(11) NOT NULL auto_increment,
`user_id` varchar(32) NOT NULL default '',
`vendor_id` int(11) NOT NULL default '0',
`order_number` varchar(32) default NULL,
`user_info_id` varchar(32) default NULL,
`order_total` decimal(10,2) NOT NULL default '0.00',
`order_subtotal` decimal(10,2) default NULL,
`order_tax` decimal(10,2) default NULL,
`order_shipping` decimal(10,2) default NULL,
`order_shipping_tax` decimal(10,2) default NULL,
`coupon_discount` decimal(10,2) NOT NULL default '0.00',
`order_discount` decimal(10,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;
#
# Dumping data for table `mos_pshop_orders`
#
#
# Table structure for table `mos_pshop_payment_method`
#
DROP table IF EXISTS mos_pshop_payment_method;
CREATE TABLE `mos_pshop_payment_method` (
`payment_method_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) default NULL,
`payment_method_name` varchar(255) default NULL,
`payment_class` varchar(50) NOT NULL default '',
`shopper_group_id` int(11) default NULL,
`payment_method_discount` decimal(10,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;
#
# Dumping data for table `mos_pshop_payment_method`
#
INSERT INTO mos_pshop_payment_method VALUES (1,1,'Purchase Order','',6,0.00,4,'PO','N',0,'Y','','','');
INSERT INTO mos_pshop_payment_method VALUES (2,1,'Cash On Delivery','',5,-2.00,5,'COD','N',0,'Y','','','');
INSERT INTO mos_pshop_payment_method VALUES (3,1,'Credit Card','ps_authorize',5,0.00,0,'AN','Y',0,'Y','1,2,6,7,','','');
INSERT INTO mos_pshop_payment_method VALUES (4,1,'PayPal','ps_paypal',5,0.00,0,'PP','P',0,'Y','','','');
INSERT INTO mos_pshop_payment_method VALUES (5,1,'PayMate','ps_paymate',5,0.00,0,'PM','P',0,'N','','\r\n
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','8d886c5855770cc01a3b8a2db57f6600.jpg','cca3cd5db813ee6badf6a3598832f2fc.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',10,1072911600,'48h.gif','Y',1,,950320117,1084907592,'Hand Shovel',0,'','',2);
INSERT INTO mos_pshop_product VALUES (2,1,0,'G02','A really long ladder to reach high places.','\r\n
Hand crafted handle with maximum grip torque
Titanium tipped shovel platter
Half degree offset for less accidents
Includes HowTo Video narrated by Bob Costas
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','ffd5d5ace2840232c8c32de59553cd8d.jpg','8cb8d644ef299639b7eab25829d13dbc.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',76,1072911600,'3-5d.gif','N',0,,950320180,1084907618,'Ladder',0,'','',2);
INSERT INTO mos_pshop_product VALUES (3,1,0,'G03','Nice shovel. You can dig your way to China with this one.','\r\n
Hand crafted handle with maximum grip torque
Titanium tipped shovel platter
Half degree offset for less accidents
Includes HowTo Video narrated by Bob Costas
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','8147a3a9666aec0296525dbd81f9705e.jpg','520efefd6d7977f91b16fac1149c7438.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',32,1072911600,'7d.gif','N',0,,950320243,1084907765,'Shovel',0,'Size,XL[+1.99],M,S[-2.99];Colour,Red,Green,Yellow,ExpensiveColor[=24.00]','',2);
INSERT INTO mos_pshop_product VALUES (4,1,0,'G04','This shovel is smaller but you\'ll be able to dig real quick.','\r\n
Hand crafted handle with maximum grip torque
Titanium tipped shovel platter
Half degree offset for less accidents
Includes HowTo Video narrated by Bob Costas
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','a04395a8aefacd9c1659ebca4dbfd4ba.jpg','1b0c96d67abdbea648cd0ea96fd6abcb.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',98,1088632800,'on-order.gif','N',0,,950320378,1084907867,'Smaller Shovel',0,'Size,big[+2.99],medium;Color,red[+0.99],green[-0.99]','',2);
INSERT INTO mos_pshop_product VALUES (5,1,0,'H01','This saw is great for getting cutting through downed limbs.','\r\n
Hand crafted handle with maximum grip torque
Titanium tipped shovel platter
Half degree offset for less accidents
Includes HowTo Video narrated by Bob Costas
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','1aa8846d3cfe3504b2ccaf7c23bb748f.jpg','e614ba08c3ee0c2adc62fd9e5b9440eb.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',32,1072911600,'1-4w.gif','Y',2,,950321256,1084907669,'Nice Saw',0,'Size,big,small,medium;Power,100W,200W,500W','',2);
INSERT INTO mos_pshop_product VALUES (6,1,0,'H02','A great hammer to hammer away with.','\r\n
Hand crafted handle with maximum grip torque
Titanium tipped shovel platter
Half degree offset for less accidents
Includes HowTo Video narrated by Bob Costas
Specifications 5\" Diameter Tungsten handle tip with 5 point loft \r\n','dccb8223891a17d752bfc1477d320da9.jpg','578563851019e01264a9b40dcf1c4ab6.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',500,1072911600,'24h.gif','N',0,,950321631,1084907947,'Hammer',0,'Size,big,medium,small;Material,wood and metal,plastic and metal[-0.99]','',2);
INSERT INTO mos_pshop_product VALUES (7,1,0,'P01','Don\'t do it with an axe. Get a chain saw.','\r\n
Tool-free tensioner for easy, convenient chain adjustment
3-Way Auto Stop; stops chain a fraction of a second
Automatic chain oiler regulates oil for proper chain lubrication
Small radius guide bar reduces kick-back
Specifications 12.5 AMPS 16\" Bar Length 3.5 HP 8.05 LBS. Weight \r\n','8716aefc3b0dce8870360604e6eb8744.jpg','c3a5bf074da14f30c849d13a2dd87d2c.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',45,1088632800,'48h.gif','N',0,,950321725,1084907512,'Chain Saw',0,'','',2);
INSERT INTO mos_pshop_product VALUES (8,1,0,'P02','Cut rings around wood. This saw can handle the most delicate projects.','\r\n
Patented Sightline; Window provides maximum visibility for straight cuts
Adjustable dust chute for cleaner work area
Bail handle for controlled cutting in 90° to 45° applications
1-1/2 to 2-1/2 lbs. lighter and 40% less noise than the average circular saw
Includes:Carbide blade
Specifications 10.0 AMPS 4,300 RPM Capacity: 2-1/16\" at 90°, 1-3/4\" at 45° \r\n','b4a748303d0d996b29d5a1e1d1112537.jpg','9a4448bb13e2f7699613b2cfd7cd51ad.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',33,1072911600,'3-5d.gif','Y',1,,950321795,1084907537,'Circular Saw',0,'Size,XL[+1],M,S[-2];Power,strong,middle,poor[=24]','',2);
INSERT INTO mos_pshop_product VALUES (9,1,0,'P03','Drill through anything. This drill has the power you need for those demanding hole boring duties.','\r\n
High power motor and double gear reduction for increased durability and improved performance
Mid-handle design and two finger trigger for increased balance and comfort
Variable speed switch with lock-on button for continuous use
\r\n','c70a3f47baf9a4020aeeee919eb3fda4.jpg','1ff5f2527907ca86103288e1b7cc3446.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',3,1072911600,'2-3d.gif','N',0,,950321879,1084907557,'Drill',0,'','',2);
INSERT INTO mos_pshop_product VALUES (10,1,0,'P04','Blast away that paint job from the past. Use this power sander to really show them you mean business.','\r\n
Lever activated paper clamps for simple sandpaper changes
Dust sealed rocker switch extends product life and keeps dust out of motor
Flush sands on three sides to get into corners
Front handle for extra control
Dust extraction port for cleaner work environment
Specifications 1.2 AMPS 10,000 OPM \r\n','7a36a05526e93964a086f2ddf17fc609.jpg','480655b410d98a5cc3bef3927e786866.jpg','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',2,1072911600,'1-2m.gif','N',2,,950321963,1084907719,'Power Sander',0,'Size,big,medium,small;Power,100W,200W,300W','',2);
INSERT INTO mos_pshop_product VALUES (11,1,1,'G01-01','','','','','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'','',0,,955696949,960372163,'Hand Shovel',0,'','',0);
INSERT INTO mos_pshop_product VALUES (12,1,1,'G01-02','','','','','Y',10.0000,'',0.0000,0.0000,0.0000,'','',0,0,'','',0,,955697006,960372187,'Hand Shovel',0,'','',0);
INSERT INTO mos_pshop_product VALUES (13,1,1,'G01-03','','','','','Y',10.0000,'',0.0000,0.0000,0.0000,'','',0,0,'','',0,,955697044,960372206,'Hand Shovel',0,'','',0);
INSERT INTO mos_pshop_product VALUES (14,1,2,'L01','','','','','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',22,1072911600,'','N',0,,962351149,1084902820,'Metal Ladder',0,'','',2);
INSERT INTO mos_pshop_product VALUES (15,1,2,'L02','','','','','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'','',0,,962351165,962351165,'Wooden Ladder',0,'','',0);
INSERT INTO mos_pshop_product VALUES (16,1,2,'L03','','','','','Y',10.0000,'pounds',0.0000,0.0000,0.0000,'inches','',0,0,'','',0,,962351180,962351180,'Plastic Ladder',0,'','',0);
#
# Table structure for table `mos_pshop_product_attribute`
#
DROP table IF EXISTS mos_pshop_product_attribute;
CREATE TABLE `mos_pshop_product_attribute` (
`product_id` int(11) NOT NULL default '0',
`attribute_name` char(255) NOT NULL default '',
`attribute_value` char(255) default NULL,
KEY `idx_product_attribute_product_id` (`product_id`),
KEY `idx_product_attribute_name` (`attribute_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_product_attribute`
#
INSERT INTO mos_pshop_product_attribute VALUES (11,'Color','Red');
INSERT INTO mos_pshop_product_attribute VALUES (12,'Color','Green');
INSERT INTO mos_pshop_product_attribute VALUES (13,'Color','Blue');
INSERT INTO mos_pshop_product_attribute VALUES (11,'Size','Small');
INSERT INTO mos_pshop_product_attribute VALUES (12,'Size','Medium');
INSERT INTO mos_pshop_product_attribute VALUES (13,'Size','Large');
INSERT INTO mos_pshop_product_attribute VALUES (14,'Material','Metal');
INSERT INTO mos_pshop_product_attribute VALUES (15,'Material','Wood');
INSERT INTO mos_pshop_product_attribute VALUES (16,'Material','Plastic');
#
# Table structure for table `mos_pshop_product_attribute_sku`
#
DROP table IF EXISTS mos_pshop_product_attribute_sku;
CREATE TABLE `mos_pshop_product_attribute_sku` (
`product_id` int(11) NOT NULL default '0',
`attribute_name` char(255) NOT NULL default '',
`attribute_list` int(11) default NULL,
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;
#
# Dumping data for table `mos_pshop_product_attribute_sku`
#
INSERT INTO mos_pshop_product_attribute_sku VALUES (1,'Color',1);
INSERT INTO mos_pshop_product_attribute_sku VALUES (1,'Size',2);
INSERT INTO mos_pshop_product_attribute_sku VALUES (2,'Material',1);
#
# Table structure for table `mos_pshop_product_category_xref`
#
DROP table IF EXISTS mos_pshop_product_category_xref;
CREATE TABLE `mos_pshop_product_category_xref` (
`category_id` varchar(32) default NULL,
`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;
#
# Dumping data for table `mos_pshop_product_category_xref`
#
INSERT INTO mos_pshop_product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',1);
INSERT INTO mos_pshop_product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',2);
INSERT INTO mos_pshop_product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',3);
INSERT INTO mos_pshop_product_category_xref VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',4);
INSERT INTO mos_pshop_product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',5);
INSERT INTO mos_pshop_product_category_xref VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',6);
INSERT INTO mos_pshop_product_category_xref VALUES ('f85e462baf927f8e53989dd969c0e430',7);
INSERT INTO mos_pshop_product_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27',8);
INSERT INTO mos_pshop_product_category_xref VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a',9);
INSERT INTO mos_pshop_product_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27',10);
#
# Table structure for table `mos_pshop_product_discount`
#
DROP table IF EXISTS mos_pshop_product_discount;
CREATE TABLE `mos_pshop_product_discount` (
`discount_id` int(11) NOT NULL auto_increment,
`amount` decimal(5,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;
#
# Dumping data for table `mos_pshop_product_discount`
#
INSERT INTO mos_pshop_product_discount VALUES (1,20.00,1,1097704800,1101337200);
INSERT INTO mos_pshop_product_discount VALUES (2,2.00,0,1098655200,0);
#
# Table structure for table `mos_pshop_product_download`
#
DROP table IF EXISTS mos_pshop_product_download;
CREATE TABLE `mos_pshop_product_download` (
`product_id` int(11) NOT NULL default '0',
`user_id` varchar(255) NOT NULL default '',
`order_id` varchar(255) NOT NULL default '',
`end_date` varchar(255) NOT NULL default '',
`download_max` varchar(255) NOT NULL default '',
`download_id` varchar(255) NOT NULL default '',
`file_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`download_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_product_download`
#
#
# Table structure for table `mos_pshop_product_files`
#
DROP table IF EXISTS mos_pshop_product_files;
CREATE TABLE `mos_pshop_product_files` (
`file_id` int(19) NOT NULL auto_increment,
`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;
#
# Dumping data for table `mos_pshop_product_files`
#
#
# Table structure for table `mos_pshop_product_mf_xref`
#
DROP table IF EXISTS mos_pshop_product_mf_xref;
CREATE TABLE `mos_pshop_product_mf_xref` (
`product_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_product_mf_xref`
#
INSERT INTO mos_pshop_product_mf_xref VALUES ('1',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('2',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('3',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('4',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('5',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('6',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('7',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('8',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('9',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('10',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('11',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('12',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('13',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('14',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('15',1);
INSERT INTO mos_pshop_product_mf_xref VALUES ('16',1);
#
# Table structure for table `mos_pshop_product_price`
#
DROP table IF EXISTS mos_pshop_product_price;
CREATE TABLE `mos_pshop_product_price` (
`product_price_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`product_price` decimal(10,2) 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,
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;
#
# Dumping data for table `mos_pshop_product_price`
#
INSERT INTO mos_pshop_product_price VALUES (1,5,24.99,'USD',0,0,950321309,950321309,5);
INSERT INTO mos_pshop_product_price VALUES (2,1,4.99,'USD',0,0,950321324,950321324,5);
INSERT INTO mos_pshop_product_price VALUES (3,2,49.99,'USD',0,0,950321340,950321340,5);
INSERT INTO mos_pshop_product_price VALUES (4,3,24.99,'USD',0,0,950321368,950321368,5);
INSERT INTO mos_pshop_product_price VALUES (5,4,19.99,'USD',0,0,950321385,950321385,5);
INSERT INTO mos_pshop_product_price VALUES (6,6,1.00,'USD',0,0,950321686,963808699,5);
INSERT INTO mos_pshop_product_price VALUES (7,7,149.99,'USD',0,0,950321754,966506270,5);
INSERT INTO mos_pshop_product_price VALUES (8,8,220.90,'USD',0,0,950321833,955614388,5);
INSERT INTO mos_pshop_product_price VALUES (9,9,48.12,'USD',0,0,950321933,950321933,5);
INSERT INTO mos_pshop_product_price VALUES (10,10,74.99,'USD',0,0,950322005,950322005,5);
INSERT INTO mos_pshop_product_price VALUES (11,1,2.99,'USD',0,0,955626841,955626841,6);
INSERT INTO mos_pshop_product_price VALUES (12,13,14.99,'USD',0,0,955697213,955697213,5);
INSERT INTO mos_pshop_product_price VALUES (13,14,79.99,'USD',0,0,962351197,962351271,5);
INSERT INTO mos_pshop_product_price VALUES (14,15,49.99,'USD',0,0,962351233,962351233,5);
INSERT INTO mos_pshop_product_price VALUES (15,16,59.99,'USD',0,0,962351259,962351259,5);
INSERT INTO mos_pshop_product_price VALUES (16,7,2.99,'USD',0,0,966589140,966589140,6);
#
# Table structure for table `mos_pshop_product_reviews`
#
DROP table IF EXISTS mos_pshop_product_reviews;
CREATE TABLE `mos_pshop_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 `mos_pshop_product_reviews`
#
#
# Table structure for table `mos_pshop_product_votes`
#
DROP table IF EXISTS mos_pshop_product_votes;
CREATE TABLE `mos_pshop_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;
#
# Dumping data for table `mos_pshop_product_votes`
#
#
# Table structure for table `mos_pshop_shipping_carrier`
#
DROP table IF EXISTS mos_pshop_shipping_carrier;
CREATE TABLE `mos_pshop_shipping_carrier` (
`shipping_carrier_id` int(11) NOT NULL auto_increment,
`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;
#
# Dumping data for table `mos_pshop_shipping_carrier`
#
INSERT INTO mos_pshop_shipping_carrier VALUES (1,'DHL',0);
INSERT INTO mos_pshop_shipping_carrier VALUES (2,'UPS',1);
#
# Table structure for table `mos_pshop_shipping_rate`
#
DROP table IF EXISTS mos_pshop_shipping_rate;
CREATE TABLE `mos_pshop_shipping_rate` (
`shipping_rate_id` int(11) NOT NULL auto_increment,
`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;
#
# Dumping data for table `mos_pshop_shipping_rate`
#
INSERT INTO mos_pshop_shipping_rate VALUES (1,'Inland > 4kg',1,'DEU','00000','99999',0.000,4.000,5.62,2.00,47,0,1);
INSERT INTO mos_pshop_shipping_rate VALUES (2,'Inland > 8kg',1,'DEU','00000','99999',4.000,8.000,6.39,2.00,47,0,2);
INSERT INTO mos_pshop_shipping_rate VALUES (3,'Inland > 12kg',1,'DEU','00000','99999',8.000,12.000,7.16,2.00,47,0,3);
INSERT INTO mos_pshop_shipping_rate VALUES (4,'Inland > 20kg',1,'DEU','00000','99999',12.000,20.000,8.69,2.00,47,0,4);
INSERT INTO mos_pshop_shipping_rate VALUES (5,'EU+ > 4kg',1,'AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999',0.000,4.000,14.00,2.00,47,0,5);
INSERT INTO mos_pshop_shipping_rate VALUES (6,'EU+ > 8kg',1,'AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999',4.000,8.000,18.00,2.00,47,0,6);
INSERT INTO mos_pshop_shipping_rate VALUES (7,'EU+ > 12kg',1,'AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999',8.000,12.000,22.00,2.00,47,0,7);
INSERT INTO mos_pshop_shipping_rate VALUES (8,'EU+ > 20kg',1,'AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999',12.000,20.000,30.00,2.00,47,0,8);
INSERT INTO mos_pshop_shipping_rate VALUES (9,'Europe > 4kg',1,'ALB;ARM;AZE;BLR;BIH;BGR;EST;GEO;GIB;ISL;YUG;KAZ;HRV;LVA;LTU;MLT;MKD;MDA;NOR;ROM;RUS;SVN;TUR;UKR;HUN;BLR;CYP','00000','99999',0.000,4.000,23.00,2.00,47,0,9);
INSERT INTO mos_pshop_shipping_rate VALUES (10,'Europe > 8kg',1,'ALB;ARM;AZE;BLR;BIH;BGR;EST;GEO;GIB;ISL;YUG;KAZ;HRV;LVA;LTU;MLT;MKD;MDA;NOR;ROM;RUS;SVN;TUR;UKR;HUN;BLR;CYP','00000','99999',4.000,8.000,29.00,2.00,47,0,10);
INSERT INTO mos_pshop_shipping_rate VALUES (11,'Europe > 12kg',1,'ALB;ARM;AZE;BLR;BIH;BGR;EST;GEO;GIB;ISL;YUG;KAZ;HRV;LVA;LTU;MLT;MKD;MDA;NOR;ROM;RUS;SVN;TUR;UKR;HUN;BLR;CYP','00000','99999',8.000,12.000,36.00,2.00,47,0,11);
INSERT INTO mos_pshop_shipping_rate VALUES (12,'Europe > 20kg',1,'ALB;ARM;AZE;BLR;BIH;BGR;EST;GEO;GIB;ISL;YUG;KAZ;HRV;LVA;LTU;MLT;MKD;MDA;NOR;ROM;RUS;SVN;TUR;UKR;HUN;BLR;CYP','00000','99999',12.000,20.000,48.00,2.00,47,0,12);
INSERT INTO mos_pshop_shipping_rate VALUES (13,'World_1 > 4kg',1,'EGY;DZA;BHR;IRQ;IRN;ISR;YEM;JOR;CAN;QAT;KWT;LBN;LBY;MAR;OMN;SAU;SYR;TUN;ARE;USA','00000','99999',0.000,4.000,26.00,2.00,47,0,13);
INSERT INTO mos_pshop_shipping_rate VALUES (14,'World_1 > 8kg',1,'EGY;DZA;BHR;IRQ;IRN;ISR;YEM;JOR;CAN;QAT;KWT;LBN;LBY;MAR;OMN;SAU;SYR;TUN;ARE;USA','00000','99999',4.000,8.000,35.00,2.00,47,0,14);
INSERT INTO mos_pshop_shipping_rate VALUES (15,'World_1 >12kg',1,'EGY;DZA;BHR;IRQ;IRN;ISR;YEM;JOR;CAN;QAT;KWT;LBN;LBY;MAR;OMN;SAU;SYR;TUN;ARE;USA','00000','99999',8.000,12.000,43.00,2.00,47,0,15);
INSERT INTO mos_pshop_shipping_rate VALUES (16,'World_1 >20kg',1,'EGY;DZA;BHR;IRQ;IRN;ISR;YEM;JOR;CAN;QAT;KWT;LBN;LBY;MAR;OMN;SAU;SYR;TUN;ARE;USA','00000','99999',12.000,20.000,59.00,2.00,47,0,16);
INSERT INTO mos_pshop_shipping_rate VALUES (17,'World_2 > 4kg',1,'','00000','99999',0.000,4.000,32.00,2.00,47,0,17);
INSERT INTO mos_pshop_shipping_rate VALUES (18,'World_2 > 8kg',1,'','00000','99999',4.000,8.000,47.00,2.00,47,0,18);
INSERT INTO mos_pshop_shipping_rate VALUES (19,'World_2 > 12kg',1,'','00000','99999',8.000,12.000,61.00,2.00,47,0,19);
INSERT INTO mos_pshop_shipping_rate VALUES (20,'World_2 > 20kg',1,'','00000','99999',12.000,20.000,90.00,2.00,47,0,20);
INSERT INTO mos_pshop_shipping_rate VALUES (21,'UPS Express',2,'AND;BEL;DNK;FRO;FIN;FRA;GRC;GRL;GBR;IRL;ITA;LIE;LUX;MCO;NLD;AUT;POL;PRT;SMR;SWE;CHE;SVK;ESP;CZE','00000','99999',0.000,20.000,5.00,2.00,47,0,21);
#
# Table structure for table `mos_pshop_shopper_group`
#
DROP table IF EXISTS mos_pshop_shopper_group;
CREATE TABLE `mos_pshop_shopper_group` (
`shopper_group_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) default NULL,
`shopper_group_name` varchar(32) default NULL,
`shopper_group_desc` text,
`shopper_group_discount` decimal(3,2) NOT NULL default '0.00',
`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;
#
# Dumping data for table `mos_pshop_shopper_group`
#
INSERT INTO mos_pshop_shopper_group VALUES (5,1,'-default-','This is the default shopper group.',0.00,1);
INSERT INTO mos_pshop_shopper_group VALUES (6,1,'Gold Level','Gold Level phpShoppers.',0.00,0);
INSERT INTO mos_pshop_shopper_group VALUES (7,1,'Wholesale','Shoppers that can buy at wholesale.',0.00,0);
#
# Table structure for table `mos_pshop_shopper_vendor_xref`
#
DROP table IF EXISTS mos_pshop_shopper_vendor_xref;
CREATE TABLE `mos_pshop_shopper_vendor_xref` (
`user_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_shopper_vendor_xref`
#
INSERT INTO mos_pshop_shopper_vendor_xref VALUES ('62',1,5,'');
INSERT INTO mos_pshop_shopper_vendor_xref VALUES ('63',1,5,'');
INSERT INTO mos_pshop_shopper_vendor_xref VALUES ('64',1,5,'');
INSERT INTO mos_pshop_shopper_vendor_xref VALUES ('65',1,5,'');
#
# Table structure for table `mos_pshop_tax_rate`
#
DROP table IF EXISTS mos_pshop_tax_rate;
CREATE TABLE `mos_pshop_tax_rate` (
`tax_rate_id` int(11) NOT NULL auto_increment,
`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;
#
# Dumping data for table `mos_pshop_tax_rate`
#
INSERT INTO mos_pshop_tax_rate VALUES (2,1,'CA','USA',964565926,0.0825);
#
# Table structure for table `mos_pshop_user_info`
#
DROP table IF EXISTS mos_pshop_user_info;
CREATE TABLE `mos_pshop_user_info` (
`user_info_id` int(11) NOT NULL auto_increment,
`user_id` varchar(32) NOT NULL default '',
`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',
PRIMARY KEY (`user_info_id`),
KEY `idx_user_info_user_id` (`user_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_user_info`
#
#
# Table structure for table `mos_pshop_vendor`
#
DROP table IF EXISTS mos_pshop_vendor;
CREATE TABLE `mos_pshop_vendor` (
`vendor_id` int(11) NOT NULL auto_increment,
`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;
#
# Dumping data for table `mos_pshop_vendor`
#
INSERT INTO mos_pshop_vendor VALUES (1,'Weidmann Electrical Technology','Owner','Demo','Store','Mr.','555-555-1212','555-555-1212','555-555-1212','notreal@nowhere.no','555-555-1212','100 Washupito Avenue, N.W.','','Rapperswil','n/a','CHE','8640','Weidmann Electrical Technology','
We have the best tools for do-it-yourselfers. Check us out!
We were established in 1969 in a time when getting good tools was expensive, but the quality was good. Now that only a select few of those authentic tools survive, we have dedicated this store to bringing the experience alive for collectors and master mechanics everywhere.
You can easily find products selecting the category you would like to browse above.
Welcome to your new installation of mambo-phpShop.
The page you see is the default Store Description. It can be changed in the Shop Administration under "Store" => "Edit Store". That\\\'s where you will have to make your first moves to customize you Online Store.
Remember to install the mambo-phpShop Main module! It is required for full Store navigation.
When all you see in your new mambo-phpShop installation is this Store Summary, you will have to install the required mambo-phpShop Main Module before you can browse categories and products.
Please don\\\'t forget to read the accompanied README file.
![](\"images/empty.gif\"){kind=spacer}
![\"\"](\"images/stories/templateclubpromo.gif\")
',12,'left',0,'0000-00-00 00:00:00',0,'',0,0,0,'moduleclass_sfx=\r\nrssurl=\r\nrssdesc=1\r\nrssimage=1\r\nrssitems=3\r\nrssitemdesc=1\r\nword_count=0\r\ncache=0',0,0);
INSERT INTO mos_modules VALUES (35,'mambo-phpShop Module','',14,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (36,'phpShop latest products','',5,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop_latestprod',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (39,'AboutUs','',3,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=AboutUs\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (37,'phpShop Search Module','',15,'left',0,'0000-00-00 00:00:00',0,'mod_phpshop_search',0,0,1,'',0,0);
INSERT INTO mos_modules VALUES (38,'topmenusmall','',1,'user5',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'class_sfx=-topnav\r\nmoduleclass_sfx=\r\nmenutype=topmenusmall\r\nmenu_style=list_flat\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=-1\r\nindent_image2=-1\r\nindent_image3=-1\r\nindent_image4=-1\r\nindent_image5=-1\r\nindent_image6=-1\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (40,'Markets','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'class_sfx=\r\nmoduleclass_sfx=\r\nmenutype=Markets\r\nmenu_style=vert_indent\r\ncache=0\r\nmenu_images=0\r\nmenu_images_align=0\r\nexpand_menu=0\r\nindent_image=0\r\nindent_image1=\r\nindent_image2=\r\nindent_image3=\r\nindent_image4=\r\nindent_image5=\r\nindent_image6=\r\nspacer=\r\nend_spacer=',0,0);
INSERT INTO mos_modules VALUES (41,'Products','',1,'left',0,'0000-00-00 00:00:00',0,'mod_mainmenu',0,0,1,'menutype=Products',0,0);
#
# Table structure for table `mos_modules_menu`
#
DROP table IF EXISTS mos_modules_menu;
CREATE TABLE `mos_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 `mos_modules_menu`
#
INSERT INTO mos_modules_menu VALUES (1,1);
INSERT INTO mos_modules_menu VALUES (2,0);
INSERT INTO mos_modules_menu VALUES (4,3);
INSERT INTO mos_modules_menu VALUES (5,1);
INSERT INTO mos_modules_menu VALUES (6,1);
INSERT INTO mos_modules_menu VALUES (6,2);
INSERT INTO mos_modules_menu VALUES (6,4);
INSERT INTO mos_modules_menu VALUES (6,27);
INSERT INTO mos_modules_menu VALUES (6,36);
INSERT INTO mos_modules_menu VALUES (8,1);
INSERT INTO mos_modules_menu VALUES (9,1);
INSERT INTO mos_modules_menu VALUES (9,2);
INSERT INTO mos_modules_menu VALUES (9,4);
INSERT INTO mos_modules_menu VALUES (9,27);
INSERT INTO mos_modules_menu VALUES (9,36);
INSERT INTO mos_modules_menu VALUES (10,1);
INSERT INTO mos_modules_menu VALUES (13,1);
INSERT INTO mos_modules_menu VALUES (15,0);
INSERT INTO mos_modules_menu VALUES (17,0);
INSERT INTO mos_modules_menu VALUES (18,0);
INSERT INTO mos_modules_menu VALUES (31,1);
INSERT INTO mos_modules_menu VALUES (34,2);
INSERT INTO mos_modules_menu VALUES (34,3);
INSERT INTO mos_modules_menu VALUES (34,4);
INSERT INTO mos_modules_menu VALUES (34,27);
INSERT INTO mos_modules_menu VALUES (34,33);
INSERT INTO mos_modules_menu VALUES (34,39);
INSERT INTO mos_modules_menu VALUES (35,0);
INSERT INTO mos_modules_menu VALUES (36,1);
INSERT INTO mos_modules_menu VALUES (37,0);
INSERT INTO mos_modules_menu VALUES (38,0);
INSERT INTO mos_modules_menu VALUES (39,53);
INSERT INTO mos_modules_menu VALUES (40,41);
INSERT INTO mos_modules_menu VALUES (41,0);
#
# Table structure for table `mos_newsfeeds`
#
DROP table IF EXISTS mos_newsfeeds;
CREATE TABLE `mos_newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`link` text NOT NULL,
`filename` varchar(200) default NULL,
`published` tinyint(1) NOT NULL default '0',
`numarticles` int(11) unsigned NOT NULL default '1',
`cache_time` int(11) unsigned NOT NULL default '3600',
`checked_out` tinyint(3) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_newsfeeds`
#
INSERT INTO mos_newsfeeds VALUES (66,16,'Mamboforge.net','http://mamboforge.net/export/rss_sfnews.php','',1,5,3600,0,'0000-00-00 00:00:00',16);
INSERT INTO mos_newsfeeds VALUES (66,17,'Mamboportal','http://www.mamboportal.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',17);
INSERT INTO mos_newsfeeds VALUES (66,18,'Mambohut','http://www.mambohut.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',18);
#
# Table structure for table `mos_poll_data`
#
DROP table IF EXISTS mos_poll_data;
CREATE TABLE `mos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(4) NOT NULL default '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) TYPE=MyISAM;
#
# Dumping data for table `mos_poll_data`
#
#
# Table structure for table `mos_poll_date`
#
DROP table IF EXISTS mos_poll_date;
CREATE TABLE `mos_poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_poll_date`
#
#
# Table structure for table `mos_poll_menu`
#
DROP table IF EXISTS mos_poll_menu;
CREATE TABLE `mos_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 `mos_poll_menu`
#
#
# Table structure for table `mos_polls`
#
DROP table IF EXISTS mos_polls;
CREATE TABLE `mos_polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_polls`
#
#
# Table structure for table `mos_pshop_affiliate`
#
DROP table IF EXISTS mos_pshop_affiliate;
CREATE TABLE `mos_pshop_affiliate` (
`affiliate_id` int(11) NOT NULL auto_increment,
`user_id` varchar(32) NOT NULL default '',
`active` char(1) NOT NULL default 'N',
`rate` int(11) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_affiliate`
#
#
# Table structure for table `mos_pshop_affiliate_sale`
#
DROP table IF EXISTS mos_pshop_affiliate_sale;
CREATE TABLE `mos_pshop_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;
#
# Dumping data for table `mos_pshop_affiliate_sale`
#
#
# Table structure for table `mos_pshop_auth_user_vendor`
#
DROP table IF EXISTS mos_pshop_auth_user_vendor;
CREATE TABLE `mos_pshop_auth_user_vendor` (
`user_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_auth_user_vendor`
#
INSERT INTO mos_pshop_auth_user_vendor VALUES ('62',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('63',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('64',1);
INSERT INTO mos_pshop_auth_user_vendor VALUES ('65',1);
#
# Table structure for table `mos_pshop_category`
#
DROP table IF EXISTS mos_pshop_category;
CREATE TABLE `mos_pshop_category` (
`category_id` varchar(32) NOT NULL default '',
`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;
#
# Dumping data for table `mos_pshop_category`
#
INSERT INTO mos_pshop_category VALUES ('541a03b2b0e1b6dbd972e9f5af5ca992',1,'Hand Tools','Hand Tools','','','Y',950319905,960304194,'browse_3',3,'',1);
INSERT INTO mos_pshop_category VALUES ('1c914424d2569bea3439fbcca9123a27',1,'Power Tools','Power Tools','','','Y',950319916,960304104,'browse_4',4,'',2);
INSERT INTO mos_pshop_category VALUES ('6834dda8e3e6e5aa18bafc63a57fd04a',1,'Garden Tools','Garden Tools','','','Y',950321122,960304338,'browse_2',2,'shop.garden_flypage',3);
INSERT INTO mos_pshop_category VALUES ('f85e462baf927f8e53989dd969c0e430',1,'Outdoor Tools','Outdoor Tools','','','Y',955626629,958889528,'browse_1',1,'',4);
INSERT INTO mos_pshop_category VALUES ('2f34f8bf003a5f27bed2e8dfe0b6f33a',1,'Indoor Tools','Indoor Tools','','','Y',958892894,958892894,'browse_1',1,'',5);
#
# Table structure for table `mos_pshop_category_xref`
#
DROP table IF EXISTS mos_pshop_category_xref;
CREATE TABLE `mos_pshop_category_xref` (
`category_parent_id` varchar(32) NOT NULL default '0',
`category_child_id` varchar(32) 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;
#
# Dumping data for table `mos_pshop_category_xref`
#
INSERT INTO mos_pshop_category_xref VALUES ('0','541a03b2b0e1b6dbd972e9f5af5ca992');
INSERT INTO mos_pshop_category_xref VALUES ('0','1c914424d2569bea3439fbcca9123a27');
INSERT INTO mos_pshop_category_xref VALUES ('0','6834dda8e3e6e5aa18bafc63a57fd04a');
INSERT INTO mos_pshop_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27','f85e462baf927f8e53989dd969c0e430');
INSERT INTO mos_pshop_category_xref VALUES ('1c914424d2569bea3439fbcca9123a27','2f34f8bf003a5f27bed2e8dfe0b6f33a');
#
# Table structure for table `mos_pshop_country`
#
DROP table IF EXISTS mos_pshop_country;
CREATE TABLE `mos_pshop_country` (
`country_id` int(11) NOT NULL auto_increment,
`zone_id` int(11) NOT NULL default '1',
`country_name` varchar(64) default NULL,
`country_3_code` char(3) default NULL,
`country_2_code` char(2) default NULL,
PRIMARY KEY (`country_id`),
KEY `idx_country_name` (`country_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_country`
#
INSERT INTO mos_pshop_country VALUES (1,1,'Afghanistan','AFG','AF');
INSERT INTO mos_pshop_country VALUES (2,1,'Albania','ALB','AL');
INSERT INTO mos_pshop_country VALUES (3,1,'Algeria','DZA','DZ');
INSERT INTO mos_pshop_country VALUES (4,1,'American Samoa','ASM','AS');
INSERT INTO mos_pshop_country VALUES (5,1,'Andorra','AND','AD');
INSERT INTO mos_pshop_country VALUES (6,1,'Angola','AGO','AO');
INSERT INTO mos_pshop_country VALUES (7,1,'Anguilla','AIA','AI');
INSERT INTO mos_pshop_country VALUES (8,1,'Antarctica','ATA','AQ');
INSERT INTO mos_pshop_country VALUES (9,1,'Antigua and Barbuda','ATG','AG');
INSERT INTO mos_pshop_country VALUES (10,1,'Argentina','ARG','AR');
INSERT INTO mos_pshop_country VALUES (11,1,'Armenia','ARM','AM');
INSERT INTO mos_pshop_country VALUES (12,1,'Aruba','ABW','AW');
INSERT INTO mos_pshop_country VALUES (13,1,'Australia','AUS','AU');
INSERT INTO mos_pshop_country VALUES (14,1,'Austria','AUT','AT');
INSERT INTO mos_pshop_country VALUES (15,1,'Azerbaijan','AZE','AZ');
INSERT INTO mos_pshop_country VALUES (16,1,'Bahamas','BHS','BS');
INSERT INTO mos_pshop_country VALUES (17,1,'Bahrain','BHR','BH');
INSERT INTO mos_pshop_country VALUES (18,1,'Bangladesh','BGD','BD');
INSERT INTO mos_pshop_country VALUES (19,1,'Barbados','BRB','BB');
INSERT INTO mos_pshop_country VALUES (20,1,'Belarus','BLR','BY');
INSERT INTO mos_pshop_country VALUES (21,1,'Belgium','BEL','BE');
INSERT INTO mos_pshop_country VALUES (22,1,'Belize','BLZ','BZ');
INSERT INTO mos_pshop_country VALUES (23,1,'Benin','BEN','BJ');
INSERT INTO mos_pshop_country VALUES (24,1,'Bermuda','BMU','BM');
INSERT INTO mos_pshop_country VALUES (25,1,'Bhutan','BTN','BT');
INSERT INTO mos_pshop_country VALUES (26,1,'Bolivia','BOL','BO');
INSERT INTO mos_pshop_country VALUES (27,1,'Bosnia and Herzegowina','BIH','BA');
INSERT INTO mos_pshop_country VALUES (28,1,'Botswana','BWA','BW');
INSERT INTO mos_pshop_country VALUES (29,1,'Bouvet Island','BVT','BV');
INSERT INTO mos_pshop_country VALUES (30,1,'Brazil','BRA','BR');
INSERT INTO mos_pshop_country VALUES (31,1,'British Indian Ocean Territory','IOT','IO');
INSERT INTO mos_pshop_country VALUES (32,1,'Brunei Darussalam','BRN','BN');
INSERT INTO mos_pshop_country VALUES (33,1,'Bulgaria','BGR','BG');
INSERT INTO mos_pshop_country VALUES (34,1,'Burkina Faso','BFA','BF');
INSERT INTO mos_pshop_country VALUES (35,1,'Burundi','BDI','BI');
INSERT INTO mos_pshop_country VALUES (36,1,'Cambodia','KHM','KH');
INSERT INTO mos_pshop_country VALUES (37,1,'Cameroon','CMR','CM');
INSERT INTO mos_pshop_country VALUES (38,1,'Canada','CAN','CA');
INSERT INTO mos_pshop_country VALUES (39,1,'Cape Verde','CPV','CV');
INSERT INTO mos_pshop_country VALUES (40,1,'Cayman Islands','CYM','KY');
INSERT INTO mos_pshop_country VALUES (41,1,'Central African Republic','CAF','CF');
INSERT INTO mos_pshop_country VALUES (42,1,'Chad','TCD','TD');
INSERT INTO mos_pshop_country VALUES (43,1,'Chile','CHL','CL');
INSERT INTO mos_pshop_country VALUES (44,1,'China','CHN','CN');
INSERT INTO mos_pshop_country VALUES (45,1,'Christmas Island','CXR','CX');
INSERT INTO mos_pshop_country VALUES (46,1,'Cocos (Keeling) Islands','CCK','CC');
INSERT INTO mos_pshop_country VALUES (47,1,'Colombia','COL','CO');
INSERT INTO mos_pshop_country VALUES (48,1,'Comoros','COM','KM');
INSERT INTO mos_pshop_country VALUES (49,1,'Congo','COG','CG');
INSERT INTO mos_pshop_country VALUES (50,1,'Cook Islands','COK','CK');
INSERT INTO mos_pshop_country VALUES (51,1,'Costa Rica','CRI','CR');
INSERT INTO mos_pshop_country VALUES (52,1,'Cote D\'Ivoire','CIV','CI');
INSERT INTO mos_pshop_country VALUES (53,1,'Croatia','HRV','HR');
INSERT INTO mos_pshop_country VALUES (54,1,'Cuba','CUB','CU');
INSERT INTO mos_pshop_country VALUES (55,1,'Cyprus','CYP','CY');
INSERT INTO mos_pshop_country VALUES (56,1,'Czech Republic','CZE','CZ');
INSERT INTO mos_pshop_country VALUES (57,1,'Denmark','DNK','DK');
INSERT INTO mos_pshop_country VALUES (58,1,'Djibouti','DJI','DJ');
INSERT INTO mos_pshop_country VALUES (59,1,'Dominica','DMA','DM');
INSERT INTO mos_pshop_country VALUES (60,1,'Dominican Republic','DOM','DO');
INSERT INTO mos_pshop_country VALUES (61,1,'East Timor','TMP','TP');
INSERT INTO mos_pshop_country VALUES (62,1,'Ecuador','ECU','EC');
INSERT INTO mos_pshop_country VALUES (63,1,'Egypt','EGY','EG');
INSERT INTO mos_pshop_country VALUES (64,1,'El Salvador','SLV','SV');
INSERT INTO mos_pshop_country VALUES (65,1,'Equatorial Guinea','GNQ','GQ');
INSERT INTO mos_pshop_country VALUES (66,1,'Eritrea','ERI','ER');
INSERT INTO mos_pshop_country VALUES (67,1,'Estonia','EST','EE');
INSERT INTO mos_pshop_country VALUES (68,1,'Ethiopia','ETH','ET');
INSERT INTO mos_pshop_country VALUES (69,1,'Falkland Islands (Malvinas)','FLK','FK');
INSERT INTO mos_pshop_country VALUES (70,1,'Faroe Islands','FRO','FO');
INSERT INTO mos_pshop_country VALUES (71,1,'Fiji','FJI','FJ');
INSERT INTO mos_pshop_country VALUES (72,1,'Finland','FIN','FI');
INSERT INTO mos_pshop_country VALUES (73,1,'France','FRA','FR');
INSERT INTO mos_pshop_country VALUES (74,1,'France, Metropolitan','FXX','FX');
INSERT INTO mos_pshop_country VALUES (75,1,'French Guiana','GUF','GF');
INSERT INTO mos_pshop_country VALUES (76,1,'French Polynesia','PYF','PF');
INSERT INTO mos_pshop_country VALUES (77,1,'French Southern Territories','ATF','TF');
INSERT INTO mos_pshop_country VALUES (78,1,'Gabon','GAB','GA');
INSERT INTO mos_pshop_country VALUES (79,1,'Gambia','GMB','GM');
INSERT INTO mos_pshop_country VALUES (80,1,'Georgia','GEO','GE');
INSERT INTO mos_pshop_country VALUES (81,1,'Germany','DEU','DE');
INSERT INTO mos_pshop_country VALUES (82,1,'Ghana','GHA','GH');
INSERT INTO mos_pshop_country VALUES (83,1,'Gibraltar','GIB','GI');
INSERT INTO mos_pshop_country VALUES (84,1,'Greece','GRC','GR');
INSERT INTO mos_pshop_country VALUES (85,1,'Greenland','GRL','GL');
INSERT INTO mos_pshop_country VALUES (86,1,'Grenada','GRD','GD');
INSERT INTO mos_pshop_country VALUES (87,1,'Guadeloupe','GLP','GP');
INSERT INTO mos_pshop_country VALUES (88,1,'Guam','GUM','GU');
INSERT INTO mos_pshop_country VALUES (89,1,'Guatemala','GTM','GT');
INSERT INTO mos_pshop_country VALUES (90,1,'Guinea','GIN','GN');
INSERT INTO mos_pshop_country VALUES (91,1,'Guinea-bissau','GNB','GW');
INSERT INTO mos_pshop_country VALUES (92,1,'Guyana','GUY','GY');
INSERT INTO mos_pshop_country VALUES (93,1,'Haiti','HTI','HT');
INSERT INTO mos_pshop_country VALUES (94,1,'Heard and Mc Donald Islands','HMD','HM');
INSERT INTO mos_pshop_country VALUES (95,1,'Honduras','HND','HN');
INSERT INTO mos_pshop_country VALUES (96,1,'Hong Kong','HKG','HK');
INSERT INTO mos_pshop_country VALUES (97,1,'Hungary','HUN','HU');
INSERT INTO mos_pshop_country VALUES (98,1,'Iceland','ISL','IS');
INSERT INTO mos_pshop_country VALUES (99,1,'India','IND','IN');
INSERT INTO mos_pshop_country VALUES (100,1,'Indonesia','IDN','ID');
INSERT INTO mos_pshop_country VALUES (101,1,'Iran (Islamic Republic of)','IRN','IR');
INSERT INTO mos_pshop_country VALUES (102,1,'Iraq','IRQ','IQ');
INSERT INTO mos_pshop_country VALUES (103,1,'Ireland','IRL','IE');
INSERT INTO mos_pshop_country VALUES (104,1,'Israel','ISR','IL');
INSERT INTO mos_pshop_country VALUES (105,1,'Italy','ITA','IT');
INSERT INTO mos_pshop_country VALUES (106,1,'Jamaica','JAM','JM');
INSERT INTO mos_pshop_country VALUES (107,1,'Japan','JPN','JP');
INSERT INTO mos_pshop_country VALUES (108,1,'Jordan','JOR','JO');
INSERT INTO mos_pshop_country VALUES (109,1,'Kazakhstan','KAZ','KZ');
INSERT INTO mos_pshop_country VALUES (110,1,'Kenya','KEN','KE');
INSERT INTO mos_pshop_country VALUES (111,1,'Kiribati','KIR','KI');
INSERT INTO mos_pshop_country VALUES (112,1,'Korea, Democratic People\'s Republic of','PRK','KP');
INSERT INTO mos_pshop_country VALUES (113,1,'Korea, Republic of','KOR','KR');
INSERT INTO mos_pshop_country VALUES (114,1,'Kuwait','KWT','KW');
INSERT INTO mos_pshop_country VALUES (115,1,'Kyrgyzstan','KGZ','KG');
INSERT INTO mos_pshop_country VALUES (116,1,'Lao People\'s Democratic Republic','LAO','LA');
INSERT INTO mos_pshop_country VALUES (117,1,'Latvia','LVA','LV');
INSERT INTO mos_pshop_country VALUES (118,1,'Lebanon','LBN','LB');
INSERT INTO mos_pshop_country VALUES (119,1,'Lesotho','LSO','LS');
INSERT INTO mos_pshop_country VALUES (120,1,'Liberia','LBR','LR');
INSERT INTO mos_pshop_country VALUES (121,1,'Libyan Arab Jamahiriya','LBY','LY');
INSERT INTO mos_pshop_country VALUES (122,1,'Liechtenstein','LIE','LI');
INSERT INTO mos_pshop_country VALUES (123,1,'Lithuania','LTU','LT');
INSERT INTO mos_pshop_country VALUES (124,1,'Luxembourg','LUX','LU');
INSERT INTO mos_pshop_country VALUES (125,1,'Macau','MAC','MO');
INSERT INTO mos_pshop_country VALUES (126,1,'Macedonia, The Former Yugoslav Republic of','MKD','MK');
INSERT INTO mos_pshop_country VALUES (127,1,'Madagascar','MDG','MG');
INSERT INTO mos_pshop_country VALUES (128,1,'Malawi','MWI','MW');
INSERT INTO mos_pshop_country VALUES (129,1,'Malaysia','MYS','MY');
INSERT INTO mos_pshop_country VALUES (130,1,'Maldives','MDV','MV');
INSERT INTO mos_pshop_country VALUES (131,1,'Mali','MLI','ML');
INSERT INTO mos_pshop_country VALUES (132,1,'Malta','MLT','MT');
INSERT INTO mos_pshop_country VALUES (133,1,'Marshall Islands','MHL','MH');
INSERT INTO mos_pshop_country VALUES (134,1,'Martinique','MTQ','MQ');
INSERT INTO mos_pshop_country VALUES (135,1,'Mauritania','MRT','MR');
INSERT INTO mos_pshop_country VALUES (136,1,'Mauritius','MUS','MU');
INSERT INTO mos_pshop_country VALUES (137,1,'Mayotte','MYT','YT');
INSERT INTO mos_pshop_country VALUES (138,1,'Mexico','MEX','MX');
INSERT INTO mos_pshop_country VALUES (139,1,'Micronesia, Federated States of','FSM','FM');
INSERT INTO mos_pshop_country VALUES (140,1,'Moldova, Republic of','MDA','MD');
INSERT INTO mos_pshop_country VALUES (141,1,'Monaco','MCO','MC');
INSERT INTO mos_pshop_country VALUES (142,1,'Mongolia','MNG','MN');
INSERT INTO mos_pshop_country VALUES (143,1,'Montserrat','MSR','MS');
INSERT INTO mos_pshop_country VALUES (144,1,'Morocco','MAR','MA');
INSERT INTO mos_pshop_country VALUES (145,1,'Mozambique','MOZ','MZ');
INSERT INTO mos_pshop_country VALUES (146,1,'Myanmar','MMR','MM');
INSERT INTO mos_pshop_country VALUES (147,1,'Namibia','NAM','NA');
INSERT INTO mos_pshop_country VALUES (148,1,'Nauru','NRU','NR');
INSERT INTO mos_pshop_country VALUES (149,1,'Nepal','NPL','NP');
INSERT INTO mos_pshop_country VALUES (150,1,'Netherlands','NLD','NL');
INSERT INTO mos_pshop_country VALUES (151,1,'Netherlands Antilles','ANT','AN');
INSERT INTO mos_pshop_country VALUES (152,1,'New Caledonia','NCL','NC');
INSERT INTO mos_pshop_country VALUES (153,1,'New Zealand','NZL','NZ');
INSERT INTO mos_pshop_country VALUES (154,1,'Nicaragua','NIC','NI');
INSERT INTO mos_pshop_country VALUES (155,1,'Niger','NER','NE');
INSERT INTO mos_pshop_country VALUES (156,1,'Nigeria','NGA','NG');
INSERT INTO mos_pshop_country VALUES (157,1,'Niue','NIU','NU');
INSERT INTO mos_pshop_country VALUES (158,1,'Norfolk Island','NFK','NF');
INSERT INTO mos_pshop_country VALUES (159,1,'Northern Mariana Islands','MNP','MP');
INSERT INTO mos_pshop_country VALUES (160,1,'Norway','NOR','NO');
INSERT INTO mos_pshop_country VALUES (161,1,'Oman','OMN','OM');
INSERT INTO mos_pshop_country VALUES (162,1,'Pakistan','PAK','PK');
INSERT INTO mos_pshop_country VALUES (163,1,'Palau','PLW','PW');
INSERT INTO mos_pshop_country VALUES (164,1,'Panama','PAN','PA');
INSERT INTO mos_pshop_country VALUES (165,1,'Papua New Guinea','PNG','PG');
INSERT INTO mos_pshop_country VALUES (166,1,'Paraguay','PRY','PY');
INSERT INTO mos_pshop_country VALUES (167,1,'Peru','PER','PE');
INSERT INTO mos_pshop_country VALUES (168,1,'Philippines','PHL','PH');
INSERT INTO mos_pshop_country VALUES (169,1,'Pitcairn','PCN','PN');
INSERT INTO mos_pshop_country VALUES (170,1,'Poland','POL','PL');
INSERT INTO mos_pshop_country VALUES (171,1,'Portugal','PRT','PT');
INSERT INTO mos_pshop_country VALUES (172,1,'Puerto Rico','PRI','PR');
INSERT INTO mos_pshop_country VALUES (173,1,'Qatar','QAT','QA');
INSERT INTO mos_pshop_country VALUES (174,1,'Reunion','REU','RE');
INSERT INTO mos_pshop_country VALUES (175,1,'Romania','ROM','RO');
INSERT INTO mos_pshop_country VALUES (176,1,'Russian Federation','RUS','RU');
INSERT INTO mos_pshop_country VALUES (177,1,'Rwanda','RWA','RW');
INSERT INTO mos_pshop_country VALUES (178,1,'Saint Kitts and Nevis','KNA','KN');
INSERT INTO mos_pshop_country VALUES (179,1,'Saint Lucia','LCA','LC');
INSERT INTO mos_pshop_country VALUES (180,1,'Saint Vincent and the Grenadines','VCT','VC');
INSERT INTO mos_pshop_country VALUES (181,1,'Samoa','WSM','WS');
INSERT INTO mos_pshop_country VALUES (182,1,'San Marino','SMR','SM');
INSERT INTO mos_pshop_country VALUES (183,1,'Sao Tome and Principe','STP','ST');
INSERT INTO mos_pshop_country VALUES (184,1,'Saudi Arabia','SAU','SA');
INSERT INTO mos_pshop_country VALUES (185,1,'Senegal','SEN','SN');
INSERT INTO mos_pshop_country VALUES (186,1,'Seychelles','SYC','SC');
INSERT INTO mos_pshop_country VALUES (187,1,'Sierra Leone','SLE','SL');
INSERT INTO mos_pshop_country VALUES (188,1,'Singapore','SGP','SG');
INSERT INTO mos_pshop_country VALUES (189,1,'Slovakia (Slovak Republic)','SVK','SK');
INSERT INTO mos_pshop_country VALUES (190,1,'Slovenia','SVN','SI');
INSERT INTO mos_pshop_country VALUES (191,1,'Solomon Islands','SLB','SB');
INSERT INTO mos_pshop_country VALUES (192,1,'Somalia','SOM','SO');
INSERT INTO mos_pshop_country VALUES (193,1,'South Africa','ZAF','ZA');
INSERT INTO mos_pshop_country VALUES (194,1,'South Georgia and the South Sandwich Islands','SGS','GS');
INSERT INTO mos_pshop_country VALUES (195,1,'Spain','ESP','ES');
INSERT INTO mos_pshop_country VALUES (196,1,'Sri Lanka','LKA','LK');
INSERT INTO mos_pshop_country VALUES (197,1,'St. Helena','SHN','SH');
INSERT INTO mos_pshop_country VALUES (198,1,'St. Pierre and Miquelon','SPM','PM');
INSERT INTO mos_pshop_country VALUES (199,1,'Sudan','SDN','SD');
INSERT INTO mos_pshop_country VALUES (200,1,'Suriname','SUR','SR');
INSERT INTO mos_pshop_country VALUES (201,1,'Svalbard and Jan Mayen Islands','SJM','SJ');
INSERT INTO mos_pshop_country VALUES (202,1,'Swaziland','SWZ','SZ');
INSERT INTO mos_pshop_country VALUES (203,1,'Sweden','SWE','SE');
INSERT INTO mos_pshop_country VALUES (204,1,'Switzerland','CHE','CH');
INSERT INTO mos_pshop_country VALUES (205,1,'Syrian Arab Republic','SYR','SY');
INSERT INTO mos_pshop_country VALUES (206,1,'Taiwan','TWN','TW');
INSERT INTO mos_pshop_country VALUES (207,1,'Tajikistan','TJK','TJ');
INSERT INTO mos_pshop_country VALUES (208,1,'Tanzania, United Republic of','TZA','TZ');
INSERT INTO mos_pshop_country VALUES (209,1,'Thailand','THA','TH');
INSERT INTO mos_pshop_country VALUES (210,1,'Togo','TGO','TG');
INSERT INTO mos_pshop_country VALUES (211,1,'Tokelau','TKL','TK');
INSERT INTO mos_pshop_country VALUES (212,1,'Tonga','TON','TO');
INSERT INTO mos_pshop_country VALUES (213,1,'Trinidad and Tobago','TTO','TT');
INSERT INTO mos_pshop_country VALUES (214,1,'Tunisia','TUN','TN');
INSERT INTO mos_pshop_country VALUES (215,1,'Turkey','TUR','TR');
INSERT INTO mos_pshop_country VALUES (216,1,'Turkmenistan','TKM','TM');
INSERT INTO mos_pshop_country VALUES (217,1,'Turks and Caicos Islands','TCA','TC');
INSERT INTO mos_pshop_country VALUES (218,1,'Tuvalu','TUV','TV');
INSERT INTO mos_pshop_country VALUES (219,1,'Uganda','UGA','UG');
INSERT INTO mos_pshop_country VALUES (220,1,'Ukraine','UKR','UA');
INSERT INTO mos_pshop_country VALUES (221,1,'United Arab Emirates','ARE','AE');
INSERT INTO mos_pshop_country VALUES (222,1,'United Kingdom','GBR','GB');
INSERT INTO mos_pshop_country VALUES (223,1,'United States','USA','US');
INSERT INTO mos_pshop_country VALUES (224,1,'United States Minor Outlying Islands','UMI','UM');
INSERT INTO mos_pshop_country VALUES (225,1,'Uruguay','URY','UY');
INSERT INTO mos_pshop_country VALUES (226,1,'Uzbekistan','UZB','UZ');
INSERT INTO mos_pshop_country VALUES (227,1,'Vanuatu','VUT','VU');
INSERT INTO mos_pshop_country VALUES (228,1,'Vatican City State (Holy See)','VAT','VA');
INSERT INTO mos_pshop_country VALUES (229,1,'Venezuela','VEN','VE');
INSERT INTO mos_pshop_country VALUES (230,1,'Viet Nam','VNM','VN');
INSERT INTO mos_pshop_country VALUES (231,1,'Virgin Islands (British)','VGB','VG');
INSERT INTO mos_pshop_country VALUES (232,1,'Virgin Islands (U.S.)','VIR','VI');
INSERT INTO mos_pshop_country VALUES (233,1,'Wallis and Futuna Islands','WLF','WF');
INSERT INTO mos_pshop_country VALUES (234,1,'Western Sahara','ESH','EH');
INSERT INTO mos_pshop_country VALUES (235,1,'Yemen','YEM','YE');
INSERT INTO mos_pshop_country VALUES (236,1,'Yugoslavia','YUG','YU');
INSERT INTO mos_pshop_country VALUES (237,1,'Zaire','ZAR','ZR');
INSERT INTO mos_pshop_country VALUES (238,1,'Zambia','ZMB','ZM');
INSERT INTO mos_pshop_country VALUES (239,1,'Zimbabwe','ZWE','ZW');
#
# Table structure for table `mos_pshop_coupons`
#
DROP table IF EXISTS mos_pshop_coupons;
CREATE TABLE `mos_pshop_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(10,2) NOT NULL default '0.00',
PRIMARY KEY (`coupon_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_coupons`
#
INSERT INTO mos_pshop_coupons VALUES (1,'test1',total,gift,6.00);
INSERT INTO mos_pshop_coupons VALUES (2,'test2',percent,permanent,15.00);
INSERT INTO mos_pshop_coupons VALUES (3,'test3',total,permanent,4.00);
INSERT INTO mos_pshop_coupons VALUES (4,'test4',total,gift,15.00);
#
# Table structure for table `mos_pshop_creditcard`
#
DROP table IF EXISTS mos_pshop_creditcard;
CREATE TABLE `mos_pshop_creditcard` (
`creditcard_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`creditcard_name` varchar(70) NOT NULL default '',
`creditcard_code` varchar(30) NOT NULL default '',
PRIMARY KEY (`creditcard_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_creditcard`
#
INSERT INTO mos_pshop_creditcard VALUES (1,1,'Visa','VISA');
INSERT INTO mos_pshop_creditcard VALUES (2,1,'MasterCard','MC');
INSERT INTO mos_pshop_creditcard VALUES (3,1,'American Express','amex');
INSERT INTO mos_pshop_creditcard VALUES (4,1,'Discover Card','discover');
INSERT INTO mos_pshop_creditcard VALUES (5,1,'Diners Club','diners');
INSERT INTO mos_pshop_creditcard VALUES (6,1,'JCB','jcb');
INSERT INTO mos_pshop_creditcard VALUES (7,1,'Australian Bankcard','australian_bc');
#
# Table structure for table `mos_pshop_csv`
#
DROP table IF EXISTS mos_pshop_csv;
CREATE TABLE `mos_pshop_csv` (
`csv_product_sku` int(2) default NULL,
`csv_product_s_desc` int(2) default NULL,
`csv_product_desc` int(2) default NULL,
`csv_product_thumb_image` int(2) default NULL,
`csv_product_full_image` int(2) default NULL,
`csv_product_weight` int(2) default NULL,
`csv_product_weight_uom` int(2) default NULL,
`csv_product_length` int(2) default NULL,
`csv_product_width` int(2) default NULL,
`csv_product_height` int(2) default NULL,
`csv_product_lwh_uom` int(2) default NULL,
`csv_product_in_stock` int(2) default NULL,
`csv_product_available_date` int(2) default NULL,
`csv_product_special` int(2) default NULL,
`csv_product_discount_id` int(2) default NULL,
`csv_product_name` int(2) default NULL,
`csv_product_price` int(2) default NULL,
`csv_category_path` int(2) default NULL,
`csv_manufacturer_id` int(2) default NULL
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_csv`
#
INSERT INTO mos_pshop_csv VALUES (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19);
#
# Table structure for table `mos_pshop_currency`
#
DROP table IF EXISTS mos_pshop_currency;
CREATE TABLE `mos_pshop_currency` (
`currency_id` int(11) NOT NULL auto_increment,
`currency_name` varchar(64) default NULL,
`currency_code` char(3) default NULL,
PRIMARY KEY (`currency_id`),
KEY `idx_currency_name` (`currency_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_currency`
#
INSERT INTO mos_pshop_currency VALUES (1,'Andorran Peseta','ADP');
INSERT INTO mos_pshop_currency VALUES (2,'United Arab Emirates Dirham','AED');
INSERT INTO mos_pshop_currency VALUES (3,'Afghanistan Afghani','AFA');
INSERT INTO mos_pshop_currency VALUES (4,'Albanian Lek','ALL');
INSERT INTO mos_pshop_currency VALUES (5,'Netherlands Antillian Guilder','ANG');
INSERT INTO mos_pshop_currency VALUES (6,'Angolan Kwanza','AOK');
INSERT INTO mos_pshop_currency VALUES (7,'Argentinian Austral','ARA');
INSERT INTO mos_pshop_currency VALUES (9,'Australian Dollar','AUD');
INSERT INTO mos_pshop_currency VALUES (10,'Aruban Florin','AWG');
INSERT INTO mos_pshop_currency VALUES (11,'Barbados Dollar','BBD');
INSERT INTO mos_pshop_currency VALUES (12,'Bangladeshi Taka','BDT');
INSERT INTO mos_pshop_currency VALUES (14,'Bulgarian Lev','BGL');
INSERT INTO mos_pshop_currency VALUES (15,'Bahraini Dinar','BHD');
INSERT INTO mos_pshop_currency VALUES (16,'Burundi Franc','BIF');
INSERT INTO mos_pshop_currency VALUES (17,'Bermudian Dollar','BMD');
INSERT INTO mos_pshop_currency VALUES (18,'Brunei Dollar','BND');
INSERT INTO mos_pshop_currency VALUES (19,'Bolivian Boliviano','BOB');
INSERT INTO mos_pshop_currency VALUES (20,'Brazilian Real','BRL');
INSERT INTO mos_pshop_currency VALUES (21,'Bahamian Dollar','BSD');
INSERT INTO mos_pshop_currency VALUES (22,'Bhutan Ngultrum','BTN');
INSERT INTO mos_pshop_currency VALUES (23,'Burma Kyat','BUK');
INSERT INTO mos_pshop_currency VALUES (24,'Botswanian Pula','BWP');
INSERT INTO mos_pshop_currency VALUES (25,'Belize Dollar','BZD');
INSERT INTO mos_pshop_currency VALUES (26,'Canadian Dollar','CAD');
INSERT INTO mos_pshop_currency VALUES (27,'Swiss Franc','CHF');
INSERT INTO mos_pshop_currency VALUES (28,'Chilean Unidades de Fomento','CLF');
INSERT INTO mos_pshop_currency VALUES (29,'Chilean Peso','CLP');
INSERT INTO mos_pshop_currency VALUES (30,'Yuan (Chinese) Renminbi','CNY');
INSERT INTO mos_pshop_currency VALUES (31,'Colombian Peso','COP');
INSERT INTO mos_pshop_currency VALUES (32,'Costa Rican Colon','CRC');
INSERT INTO mos_pshop_currency VALUES (33,'Czech Koruna','CSK');
INSERT INTO mos_pshop_currency VALUES (34,'Cuban Peso','CUP');
INSERT INTO mos_pshop_currency VALUES (35,'Cape Verde Escudo','CVE');
INSERT INTO mos_pshop_currency VALUES (36,'Cyprus Pound','CYP');
INSERT INTO mos_pshop_currency VALUES (40,'Danish Krone','DKK');
INSERT INTO mos_pshop_currency VALUES (41,'Dominican Peso','DOP');
INSERT INTO mos_pshop_currency VALUES (42,'Algerian Dinar','DZD');
INSERT INTO mos_pshop_currency VALUES (43,'Ecuador Sucre','ECS');
INSERT INTO mos_pshop_currency VALUES (44,'Egyptian Pound','EGP');
INSERT INTO mos_pshop_currency VALUES (46,'Ethiopian Birr','ETB');
INSERT INTO mos_pshop_currency VALUES (47,'Euro','EUR');
INSERT INTO mos_pshop_currency VALUES (49,'Fiji Dollar','FJD');
INSERT INTO mos_pshop_currency VALUES (50,'Falkland Islands Pound','FKP');
INSERT INTO mos_pshop_currency VALUES (52,'British Pound','GBP');
INSERT INTO mos_pshop_currency VALUES (53,'Ghanaian Cedi','GHC');
INSERT INTO mos_pshop_currency VALUES (54,'Gibraltar Pound','GIP');
INSERT INTO mos_pshop_currency VALUES (55,'Gambian Dalasi','GMD');
INSERT INTO mos_pshop_currency VALUES (56,'Guinea Franc','GNF');
INSERT INTO mos_pshop_currency VALUES (58,'Guatemalan Quetzal','GTQ');
INSERT INTO mos_pshop_currency VALUES (59,'Guinea-Bissau Peso','GWP');
INSERT INTO mos_pshop_currency VALUES (60,'Guyanan Dollar','GYD');
INSERT INTO mos_pshop_currency VALUES (61,'Hong Kong Dollar','HKD');
INSERT INTO mos_pshop_currency VALUES (62,'Honduran Lempira','HNL');
INSERT INTO mos_pshop_currency VALUES (63,'Haitian Gourde','HTG');
INSERT INTO mos_pshop_currency VALUES (64,'Hungarian Forint','HUF');
INSERT INTO mos_pshop_currency VALUES (65,'Indonesian Rupiah','IDR');
INSERT INTO mos_pshop_currency VALUES (66,'Irish Punt','IEP');
INSERT INTO mos_pshop_currency VALUES (67,'Israeli Shekel','ILS');
INSERT INTO mos_pshop_currency VALUES (68,'Indian Rupee','INR');
INSERT INTO mos_pshop_currency VALUES (69,'Iraqi Dinar','IQD');
INSERT INTO mos_pshop_currency VALUES (70,'Iranian Rial','IRR');
INSERT INTO mos_pshop_currency VALUES (73,'Jamaican Dollar','JMD');
INSERT INTO mos_pshop_currency VALUES (74,'Jordanian Dinar','JOD');
INSERT INTO mos_pshop_currency VALUES (75,'Japanese Yen','JPY');
INSERT INTO mos_pshop_currency VALUES (76,'Kenyan Schilling','KES');
INSERT INTO mos_pshop_currency VALUES (77,'Kampuchean (Cambodian) Riel','KHR');
INSERT INTO mos_pshop_currency VALUES (78,'Comoros Franc','KMF');
INSERT INTO mos_pshop_currency VALUES (79,'North Korean Won','KPW');
INSERT INTO mos_pshop_currency VALUES (80,'(South) Korean Won','KRW');
INSERT INTO mos_pshop_currency VALUES (81,'Kuwaiti Dinar','KWD');
INSERT INTO mos_pshop_currency VALUES (82,'Cayman Islands Dollar','KYD');
INSERT INTO mos_pshop_currency VALUES (83,'Lao Kip','LAK');
INSERT INTO mos_pshop_currency VALUES (84,'Lebanese Pound','LBP');
INSERT INTO mos_pshop_currency VALUES (85,'Sri Lanka Rupee','LKR');
INSERT INTO mos_pshop_currency VALUES (86,'Liberian Dollar','LRD');
INSERT INTO mos_pshop_currency VALUES (87,'Lesotho Loti','LSL');
INSERT INTO mos_pshop_currency VALUES (89,'Libyan Dinar','LYD');
INSERT INTO mos_pshop_currency VALUES (90,'Moroccan Dirham','MAD');
INSERT INTO mos_pshop_currency VALUES (91,'Malagasy Franc','MGF');
INSERT INTO mos_pshop_currency VALUES (92,'Mongolian Tugrik','MNT');
INSERT INTO mos_pshop_currency VALUES (93,'Macau Pataca','MOP');
INSERT INTO mos_pshop_currency VALUES (94,'Mauritanian Ouguiya','MRO');
INSERT INTO mos_pshop_currency VALUES (95,'Maltese Lira','MTL');
INSERT INTO mos_pshop_currency VALUES (96,'Mauritius Rupee','MUR');
INSERT INTO mos_pshop_currency VALUES (97,'Maldive Rufiyaa','MVR');
INSERT INTO mos_pshop_currency VALUES (98,'Malawi Kwacha','MWK');
INSERT INTO mos_pshop_currency VALUES (99,'Mexican Peso','MXP');
INSERT INTO mos_pshop_currency VALUES (100,'Malaysian Ringgit','MYR');
INSERT INTO mos_pshop_currency VALUES (101,'Mozambique Metical','MZM');
INSERT INTO mos_pshop_currency VALUES (102,'Nigerian Naira','NGN');
INSERT INTO mos_pshop_currency VALUES (103,'Nicaraguan Cordoba','NIC');
INSERT INTO mos_pshop_currency VALUES (105,'Norwegian Kroner','NOK');
INSERT INTO mos_pshop_currency VALUES (106,'Nepalese Rupee','NPR');
INSERT INTO mos_pshop_currency VALUES (107,'New Zealand Dollar','NZD');
INSERT INTO mos_pshop_currency VALUES (108,'Omani Rial','OMR');
INSERT INTO mos_pshop_currency VALUES (109,'Panamanian Balboa','PAB');
INSERT INTO mos_pshop_currency VALUES (110,'Peruvian Inti','PEI');
INSERT INTO mos_pshop_currency VALUES (111,'Papua New Guinea Kina','PGK');
INSERT INTO mos_pshop_currency VALUES (112,'Philippine Peso','PHP');
INSERT INTO mos_pshop_currency VALUES (113,'Pakistan Rupee','PKR');
INSERT INTO mos_pshop_currency VALUES (114,'Polish Zloty','PLZ');
INSERT INTO mos_pshop_currency VALUES (116,'Paraguay Guarani','PYG');
INSERT INTO mos_pshop_currency VALUES (117,'Qatari Rial','QAR');
INSERT INTO mos_pshop_currency VALUES (118,'Romanian Leu','ROL');
INSERT INTO mos_pshop_currency VALUES (119,'Rwanda Franc','RWF');
INSERT INTO mos_pshop_currency VALUES (120,'Saudi Arabian Riyal','SAR');
INSERT INTO mos_pshop_currency VALUES (121,'Solomon Islands Dollar','SBD');
INSERT INTO mos_pshop_currency VALUES (122,'Seychelles Rupee','SCR');
INSERT INTO mos_pshop_currency VALUES (123,'Sudanese Pound','SDP');
INSERT INTO mos_pshop_currency VALUES (124,'Swedish Krona','SEK');
INSERT INTO mos_pshop_currency VALUES (125,'Singapore Dollar','SGD');
INSERT INTO mos_pshop_currency VALUES (126,'St. Helena Pound','SHP');
INSERT INTO mos_pshop_currency VALUES (127,'Sierra Leone Leone','SLL');
INSERT INTO mos_pshop_currency VALUES (128,'Somali Schilling','SOS');
INSERT INTO mos_pshop_currency VALUES (129,'Suriname Guilder','SRG');
INSERT INTO mos_pshop_currency VALUES (130,'Sao Tome and Principe Dobra','STD');
INSERT INTO mos_pshop_currency VALUES (131,'USSR Rouble','SUR');
INSERT INTO mos_pshop_currency VALUES (132,'El Salvador Colon','SVC');
INSERT INTO mos_pshop_currency VALUES (133,'Syrian Potmd','SYP');
INSERT INTO mos_pshop_currency VALUES (134,'Swaziland Lilangeni','SZL');
INSERT INTO mos_pshop_currency VALUES (135,'Thai Bath','THB');
INSERT INTO mos_pshop_currency VALUES (136,'Tunisian Dinar','TND');
INSERT INTO mos_pshop_currency VALUES (137,'Tongan Pa\'anga','TOP');
INSERT INTO mos_pshop_currency VALUES (138,'East Timor Escudo','TPE');
INSERT INTO mos_pshop_currency VALUES (139,'Turkish Lira','TRL');
INSERT INTO mos_pshop_currency VALUES (140,'Trinidad and Tobago Dollar','TTD');
INSERT INTO mos_pshop_currency VALUES (141,'Taiwan Dollar','TWD');
INSERT INTO mos_pshop_currency VALUES (142,'Tanzanian Schilling','TZS');
INSERT INTO mos_pshop_currency VALUES (143,'Uganda Shilling','UGS');
INSERT INTO mos_pshop_currency VALUES (144,'US Dollar','USD');
INSERT INTO mos_pshop_currency VALUES (145,'Uruguayan Peso','UYP');
INSERT INTO mos_pshop_currency VALUES (146,'Venezualan Bolivar','VEB');
INSERT INTO mos_pshop_currency VALUES (147,'Vietnamese Dong','VND');
INSERT INTO mos_pshop_currency VALUES (148,'Vanuatu Vatu','VUV');
INSERT INTO mos_pshop_currency VALUES (149,'Samoan Tala','WST');
INSERT INTO mos_pshop_currency VALUES (150,'Democratic Yemeni Dinar','YDD');
INSERT INTO mos_pshop_currency VALUES (151,'Yemeni Rial','YER');
INSERT INTO mos_pshop_currency VALUES (152,'New Yugoslavia Dinar','YUD');
INSERT INTO mos_pshop_currency VALUES (153,'South African Rand','ZAR');
INSERT INTO mos_pshop_currency VALUES (154,'Zambian Kwacha','ZMK');
INSERT INTO mos_pshop_currency VALUES (155,'Zaire Zaire','ZRZ');
INSERT INTO mos_pshop_currency VALUES (156,'Zimbabwe Dollar','ZWD');
#
# Table structure for table `mos_pshop_function`
#
DROP table IF EXISTS mos_pshop_function;
CREATE TABLE `mos_pshop_function` (
`function_id` int(11) NOT NULL auto_increment,
`module_id` int(11) default NULL,
`function_name` varchar(32) default NULL,
`function_class` varchar(32) default NULL,
`function_method` varchar(32) default NULL,
`function_description` text,
`function_perms` varchar(255) default NULL,
PRIMARY KEY (`function_id`),
KEY `idx_function_module_id` (`module_id`),
KEY `idx_function_name` (`function_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_function`
#
INSERT INTO mos_pshop_function VALUES (1,1,'userAdd','ps_user','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (2,1,'userDelete','ps_user','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (3,1,'userUpdate','ps_user','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (4,1,'adminPasswdUpdate','ps_user','update_admin_passwd','Updates Site Administrator Password','admin');
INSERT INTO mos_pshop_function VALUES (31,2,'productAdd','ps_product','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (6,1,'functionAdd','ps_function','add','','admin');
INSERT INTO mos_pshop_function VALUES (7,1,'functionUpdate','ps_function','update','','admin');
INSERT INTO mos_pshop_function VALUES (8,1,'functionDelete','ps_function','delete','','admin');
INSERT INTO mos_pshop_function VALUES (9,1,'userLogout','ps_user','logout','','none');
INSERT INTO mos_pshop_function VALUES (10,1,'userAddressAdd','ps_user_address','add','','admin,storeadmin,shopper,demo');
INSERT INTO mos_pshop_function VALUES (11,1,'userAddressUpdate','ps_user_address','update','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (12,1,'userAddressDelete','ps_user_address','delete','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (13,1,'moduleAdd','ps_module','add','','admin');
INSERT INTO mos_pshop_function VALUES (14,1,'moduleUpdate','ps_module','update','','admin');
INSERT INTO mos_pshop_function VALUES (15,1,'moduleDelete','ps_module','delete','','admin');
INSERT INTO mos_pshop_function VALUES (16,1,'userLogin','ps_user','login','','none');
INSERT INTO mos_pshop_function VALUES (17,3,'vendorAdd','ps_vendor','add','','admin');
INSERT INTO mos_pshop_function VALUES (18,3,'vendorUpdate','ps_vendor','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (19,3,'vendorDelete','ps_vendor','delete','','admin');
INSERT INTO mos_pshop_function VALUES (20,3,'vendorCategoryAdd','ps_vendor_category','add','','admin');
INSERT INTO mos_pshop_function VALUES (21,3,'vendorCategoryUpdate','ps_vendor_category','update','','admin');
INSERT INTO mos_pshop_function VALUES (22,3,'vendorCategoryDelete','ps_vendor_category','delete','','admin');
INSERT INTO mos_pshop_function VALUES (23,4,'shopperAdd','ps_shopper','add','','none');
INSERT INTO mos_pshop_function VALUES (24,4,'shopperDelete','ps_shopper','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (25,4,'shopperUpdate','ps_shopper','update','','admin,storeadmin,shopper');
INSERT INTO mos_pshop_function VALUES (26,4,'shopperGroupAdd','ps_shopper_group','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (27,4,'shopperGroupUpdate','ps_shopper_group','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (28,4,'shopperGroupDelete','ps_shopper_group','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (29,5,'orderSearch','ps_order','find','','admin,storeadmin,demo');
INSERT INTO mos_pshop_function VALUES (30,5,'orderStatusSet','ps_order','order_status_update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (32,2,'productDelete','ps_product','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (33,2,'productUpdate','ps_product','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (34,2,'productCategoryAdd','ps_product_category','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (35,2,'productCategoryUpdate','ps_product_category','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (36,2,'productCategoryDelete','ps_product_category','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (37,2,'productPriceAdd','ps_product_price','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (38,2,'productPriceUpdate','ps_product_price','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (39,2,'productPriceDelete','ps_product_price','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (40,2,'productAttributeAdd','ps_product_attribute','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (41,2,'productAttributeUpdate','ps_product_attribute','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (42,2,'productAttributeDelete','ps_product_attribute','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (43,7,'cartAdd','ps_cart','add','','none');
INSERT INTO mos_pshop_function VALUES (44,7,'cartUpdate','ps_cart','update','','none');
INSERT INTO mos_pshop_function VALUES (45,7,'cartDelete','ps_cart','delete','','none');
INSERT INTO mos_pshop_function VALUES (46,10,'checkoutComplete','ps_checkout','add','','shopper,storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (47,1,'setLanguage','ps_module','set_language','','none');
INSERT INTO mos_pshop_function VALUES (48,8,'paymentMethodUpdate','ps_payment_method','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (49,8,'paymentMethodAdd','ps_payment_method','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (50,8,'paymentMethodDelete','ps_payment_method','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (51,5,'orderDelete','ps_order','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (52,11,'addTaxRate','ps_tax','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (53,11,'updateTaxRate','ps_tax','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (54,11,'deleteTaxRate','ps_tax','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (55,10,'checkoutValidateST','ps_checkout','validate_shipto','','none');
INSERT INTO mos_pshop_function VALUES (59,5,'orderStatusUpdate','ps_order_status','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (60,5,'orderStatusAdd','ps_order_status','add','','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (61,5,'orderStatusDelete','ps_order_status','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (62,1,'currencyAdd','ps_currency','add','add a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (63,1,'currencyUpdate','ps_currency','update',' update a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (64,1,'currencyDelete','ps_currency','delete','delete a currency','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (65,1,'countryAdd','ps_country','add','Add a country ','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (66,1,'countryUpdate','ps_country','update','Update a country record','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (67,1,'countryDelete','ps_country','delete','Delete a country record','storeadmin,admin');
INSERT INTO mos_pshop_function VALUES (68,2,'product_csv','ps_csv','upload_csv','','admin');
INSERT INTO mos_pshop_function VALUES (110,7,'waitingListAdd','zw_waiting_list','add','','none');
INSERT INTO mos_pshop_function VALUES (111,13,'addzone','ps_zone','add','This will add a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (112,13,'updatezone','ps_zone','update','This will update a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (113,13,'deletezone','ps_zone','delete','This will delete a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (114,13,'zoneassign','ps_zone','assign','This will assign a country to a zone','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (115,1,'writeConfig','ps_config','writeconfig','This will write the configuration details to phpshop.cfg.php','admin');
INSERT INTO mos_pshop_function VALUES (116,12839,'carrierAdd','ps_shipping','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (117,12839,'carrierDelete','ps_shipping','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (118,12839,'carrierUpdate','ps_shipping','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (119,12839,'rateAdd','ps_shipping','rate_add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (120,12839,'rateUpdate','ps_shipping','rate_update','','admin,shopadmin');
INSERT INTO mos_pshop_function VALUES (121,12839,'rateDelete','ps_shipping','rate_delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (122,10,'checkoutProcess','ps_checkout','process','','shopper,storeadmin,admin,demo');
INSERT INTO mos_pshop_function VALUES (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');
INSERT INTO mos_pshop_function VALUES (124,98,'affiliateAdd','ps_affiliate','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (125,98,'affiliateUpdate','ps_affiliate','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (126,98,'affiliateDelete','ps_affiliate','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (127,98,'affiliateEmail','ps_affiliate','email','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (128,99,'manufacturerAdd','ps_manufacturer','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (129,99,'manufacturerUpdate','ps_manufacturer','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (130,99,'manufacturerDelete','ps_manufacturer','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (131,99,'manufacturercategoryAdd','ps_manufacturer_category','add','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (132,99,'manufacturercategoryUpdate','ps_manufacturer_category','update','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (133,99,'manufacturercategoryDelete','ps_manufacturer_category','delete','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (134,7,'addReview','ps_reviews','process_review','This lets the user add a review and rating to a product.','admin,storeadmin,shopper,demo');
INSERT INTO mos_pshop_function VALUES (135,7,'productReviewDelete','ps_reviews','delete_review','This deletes a review and from a product.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (136,8,'creditcardAdd','ps_creditcard','add','Adds a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (137,8,'creditcardUpdate','ps_creditcard','update','Updates a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (138,8,'creditcardDelete','ps_creditcard','delete','Deletes a Credit Card entry.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (139,2,'publishProduct','ps_product','product_publish','Changes the product_publish field, so that a product can be published or unpublished easily.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (140,2,'export_csv','ps_csv','export_csv','This function exports all relevant product data to CSV.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (141,2,'reorder','ps_product_category','reorder','Changes the list order of a category.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (142,2,'discountAdd','ps_product_discount','add','Adds a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (143,2,'discountUpdate','ps_product_discount','update','Updates a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (144,2,'discountDelete','ps_product_discount','delete','Deletes a discount.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (145,8,'shippingmethodSave','ps_shipping_method','save','','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (146,2,'uploadProductFile','ps_product_files','add','Uploads and Adds a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (147,2,'updateProductFile','ps_product_files','update','Updates a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (148,2,'deleteProductFile','ps_product_files','delete','Deletes a Product Image/File.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (149,12843,'couponAdd','ps_coupon','add_coupon_code','Adds a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (150,12843,'couponUpdate','ps_coupon','update_coupon','Updates a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (151,12843,'couponDelete','ps_coupon','remove_coupon_code','Deletes a Coupon.','admin,storeadmin');
INSERT INTO mos_pshop_function VALUES (152,12843,'couponProcess','ps_coupon','process_coupon_code','Processes a Coupon.','admin,storeadmin,shopper,demo');
#
# Table structure for table `mos_pshop_manufacturer`
#
DROP table IF EXISTS mos_pshop_manufacturer;
CREATE TABLE `mos_pshop_manufacturer` (
`manufacturer_id` int(11) NOT NULL auto_increment,
`mf_name` varchar(64) default NULL,
`mf_email` varchar(255) default NULL,
`mf_desc` text,
`mf_category_id` int(11) default NULL,
`mf_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`manufacturer_id`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_manufacturer`
#
INSERT INTO mos_pshop_manufacturer VALUES (1,'Manufacturer','info@manufacturer.com','An example for a manufacturer',1,'http://www.a-url.com');
#
# Table structure for table `mos_pshop_manufacturer_category`
#
DROP table IF EXISTS mos_pshop_manufacturer_category;
CREATE TABLE `mos_pshop_manufacturer_category` (
`mf_category_id` int(11) NOT NULL auto_increment,
`mf_category_name` varchar(64) default NULL,
`mf_category_desc` text,
PRIMARY KEY (`mf_category_id`),
KEY `idx_manufacturer_category_category_name` (`mf_category_name`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_manufacturer_category`
#
INSERT INTO mos_pshop_manufacturer_category VALUES (1,'-default-','This is the default manufacturer category');
#
# Table structure for table `mos_pshop_module`
#
DROP table IF EXISTS mos_pshop_module;
CREATE TABLE `mos_pshop_module` (
`module_id` int(11) NOT NULL auto_increment,
`module_name` varchar(255) default NULL,
`module_description` text,
`module_perms` varchar(255) default NULL,
`module_header` varchar(255) default NULL,
`module_footer` varchar(255) default NULL,
`module_publish` char(1) default NULL,
`list_order` int(11) default NULL,
`language_code_1` varchar(4) default NULL,
`language_code_2` varchar(4) default NULL,
`language_code_3` varchar(4) default NULL,
`language_code_4` varchar(4) default NULL,
`language_code_5` varchar(4) default NULL,
`language_file_1` varchar(255) default NULL,
`language_file_2` varchar(255) default NULL,
`language_file_3` varchar(255) default NULL,
`language_file_4` varchar(255) default NULL,
`language_file_5` varchar(255) default NULL,
`module_label_1` varchar(255) default NULL,
`module_label_2` varchar(255) default NULL,
`module_label_3` varchar(255) default NULL,
`module_label_4` varchar(255) default NULL,
`module_label_5` varchar(255) default NULL,
PRIMARY KEY (`module_id`),
KEY `idx_module_name` (`module_name`),
KEY `idx_module_list_order` (`list_order`)
) TYPE=MyISAM;
#
# Dumping data for table `mos_pshop_module`
#
INSERT INTO mos_pshop_module VALUES (1,'admin','![\"Pay](\"https://www.paymate.com.au/images/paymate-PE-payment-88x31.gif\")