Joomla 1.5
Download the installation package from our download section. Once the download is complete go to the backend of Joomla. Navigate through your menu system to Extensions/Install Uninstall. Once at the installation screen click the browse button and navigate to where you downloaded the template file. Once you have the file selected click 'Upload File and Install' The template is now installed, now let's set it as the default template:
Navigate through your menu system to Extensions/Template Manager. Find the radio button next to the newly installed template. Click on the Default button at the top right of the screen and you're done!
', '', 1, 1, 0, 1, '2007-12-11 19:38:14', 62, '', '2008-10-08 09:39:26', 62, 0, '0000-00-00 00:00:00', '2007-12-11 19:37:21', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 17, 0, 18, '', '', 0, 9309, ''),
(18, 'Configuring The Template''s Settings', 'configuring-the-templates-settings', 'Configuring The Template''s Settings', 'This template comes loaded with options that you can use to customize your site exactly how you want it. Here's how to get to these custom settings:
Joomla 1.0 In the backend of Joomla navigate to the menu item Site/Template Manager/Site Templates. Select this template''s radio button. Find the Edit HTML button at the top right of your screen and click it. After clicking the Edit HTML button you will be brought to an editor screen. If you've never seen this screen before or have never done any programming relax, just take a deep breath and follow the next few steps. Find the part of the text that looks like this: Begin answering the questions below that line and when you are done click Save at the top. Finally, sit back and relax, you've just completed one of the hardest parts of template configuration! Joomla 1.5 In the backend of Joomla go menu item Extensions/Template Manager. Click on the title of the template. This will bring you to the template manager screen where you can edit the template''s parameters. Click save when you are done \r\n\r\nThis website is powered by Joomla! The software and default templates on which it runs are Copyright 2005 Open Source Matters . All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.
If you want to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU General Public License . If you are unfamiliar with this license, you might want to read ''How To Apply These Terms To Your Program'' and the ''GNU General Public License FAQ'' .
', '', 1, 0, 0, 0, '2004-08-19 20:11:07', 62, '', '2004-08-19 20:14:49', 62, 0, '0000-00-00 00:00:00', '2004-08-19 00:00:00', '0000-00-00 00:00:00', '', '', 'menu_image=\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 11, '', '', 0, 14, ''),
(22, 'Easy To Follow Steps', 'easy-to-follow-steps', 'Easy To Follow Steps', 'We go through great lengths to make sure our templates are easy to setup by means of very user friendly step by step questions in the template configuration. The Native 1.5 version uses the same questions but through the Joomla interface. Below are some generic examples to show how easy our setup is to follow:
// Would you like to enable the page width buttons? Type yes or no.
// Would you like to show the pathway?
// Would you like the main, drop down suckerfish menu shown?
// What color style would you like to use for this template?
// What width in pixels would you like the left column to be?
Those are just some examples there are plenty of easy to follow steps in the template configuration of all our templates to ensure that your template is setup correctly in a very easy to follow manner.
', '', 1, 1, 0, 1, '2007-12-11 21:14:30', 62, '', '2008-06-11 10:26:38', 62, 0, '0000-00-00 00:00:00', '2007-12-11 21:14:14', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 2, 0, 15, '', '', 0, 7913, ''),
(24, 'Custom Page and Column Widths', 'custom-page-and-column-widths', 'Custom Page and Column Widths', 'Easily set your own widths! This template gives you the ability to set your own \r\nwidth for:
1. Page body
\r\n2. Main column widths (left and right)
\r\nAll of this is done very easily in the template configuration.
\r\n
\r\n\r\n
\r\nThe already enabled LyteBox feature gives your site a \r\ndazzling picture display!
\r\nMake sure to click on each of the examples.
\r\nLyteBox comes pre-installed with this template just follow the tutorials below to setup your images.
\r\nSingle Image Example
\r\n\r\n\r\n\r\n\r\n \r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nTo enable use the following around any image:
\r\n<a href="http://www.yoursite.com/images/popup.jpg" rel="lytebox" title="Your \r\nDescription."><p align="center"><img class="boxed" src="http://www.yoursite.com/images/thumbnail.jpg" \r\nalt="Description" width="214" height="61" /></p></a>
\r\nGrouped Images Example
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n \r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nTo enable use the following around any group of images:
\r\n<a href="http://www.yoursite.com/images/popup1.jpg" rel="lytebox[gallery]" \r\ntitle="Your Description"><p align="center"><img class="boxed" src="http://www.yoursite.com/images/thumbnail1.jpg" \r\nalt="Description" width="214" height="61" /></p></a>
\r\nSlideshow Example
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n \r\n\r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nTo enable use the following around any group of images:
\r\n\r\n<a href="http://www.yoursite.com/images/popup1.jpg" rel="lyteshow[gallery]" \r\ntitle="Your Description"><p align="center"><img class="boxed" src="http://www.yoursite.com/images/thumbnail1.jpg" \r\nalt="Description" width="214" height="61" /></p></a>Site Shaper SQL Dumps Login to your phpmyadmin via cpanel or another server database admin panel. Navigate to the database your Joomla install is using Select all tables and drop them. (NOTE: This will delete all your website data on this current Joomla install) Next, click import and import the SQL dump we provide Now you are done, just login via your Joomla admin with username=admin and password=admin This is a sample blockquote. Use <blockquote><p>Your content goes \r\nhere!</p></blockquote> to create a blockquote.
This is a styled box. Use <div class="black_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="gray_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="red_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="blue_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="green_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="yellow_box">Your content \r\ngoes here!</div>
\r\n\r\nThis is a styled box. Use <div class="orange_box">Your content \r\ngoes here!</div>
\r\n\r\nHeading 1 \r\nHeading 2 \r\nHeading 3 \r\nHeading 4 \r\nHeading 5 \r\n\r\nThis is a sample code div. Use <div \r\n class="code">Your content goes here!</div> to create a code div.
\r\n\r\n\r\nThis is an Ordered List \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\nThis is an Unordered List \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\nThis is an Unordered List with class ul_arrow \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\n\r\nThis is an Unordered List with class ul_star \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\nThis is an Unordered List with class ul_bullet \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\nThis is an Unordered List with class ul_bullet_small \r\nCongue Quisque augue elit dolor nibh. \r\nCondimentum elte quis. \r\nOpsum dolor sit amet consectetuer. \r\n \r\n\r\n\r\n\r\nThis is a sample styled number list <li class="li_number1">Your content \r\ngoes here!</li> \r\n\r\nThis is a sample styled number list <li class="li_number2">Your content \r\ngoes here!</li> \r\n\r\nThis is a sample styled number list <li class="li_number3">Your content \r\ngoes here!</li> \r\n\r\nThis is a sample styled number list <li class="li_number4">Your content \r\ngoes here!</li> \r\n\r\n \r\n\r\nThe S5 No-MooMenu is one of the most advanced menu systems for Joomla! Unlike \r\nother similar menu systems that use mootools and cause script conflictions with \r\nyour modules and components the S5 No-MooMenu is completely powered by S5 \r\nEffects so your modules and components won''t cause any conflictions using this \r\nmenu system. Just mouse over the top menu and you will notice the menu smoothly \r\nexpand and fade in.
\r\n
3 Options:
\r\nS5 No-MooMenu with fade-in effect ( click here for an example ) \r\nS5 No-MooMenu with drop-in effect (click here for an example ) \r\nStandard Snap-in Suckerfish Menu (click here for an example ) \r\n\r\nOn this page you will see all the module styles and module positions available plus how to setup each of them.
All modules are fully collapsible!
How to install modules and setup module styles:
Joomla 1.0
Download only module you wish to publish to your site. In the backend of Joomla navigate to the menu item Installers/Modules. Browse for the module's install file and click Upload File & Install. Once the module has installed navigate to the menu item Modules/Site Modules. Find the Module just installed and click on it's title. Change any parameters that you wish and be sure to set it to published and publish it to your desired module position. To apply a module style simply fill in the module class suffix field with any of this template's included module styles. Assign what pages you would like the module to appear on and finally click Save.
Joomla 1.5
Download only module you wish to publish to your site. In the backend of Joomla navigate to the menu item Extensions/Install Uninstall. Browse for the module's install file and click Upload File & Install. Once the module has installed navigate to the menu item Extensions/Module Manager. Find the Module just installed and click on it's title. Change any parameters that you wish and be sure to set it to published and publish it to your desired module position. To apply a module style simply fill in the module class suffix field with any of this template's included module styles. This parameter setting is found under Module Parameters on the right side of the screen. Assign what pages you would like the module to appear on and finally click Save.
', '', 1, 1, 0, 1, '2007-12-05 13:16:18', 62, '', '2008-10-08 18:33:40', 62, 0, '0000-00-00 00:00:00', '2007-12-05 13:16:05', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 15, 0, 19, '', '', 0, 22967, ''),
(36, 'How To Setup the Search Box and Menus', 'how-to-setup-the-search-box-and-menus', 'How To Setup the Search Box and Menus', '1. Search Setup
Publish the default Joomla search module to the 'user1' position. Do not show the search button. 2. Column Menu Setup
No special settings are required for this menu in Joomla 1.0 but in Joomla 1.5 make sure to remove the menu class suffix (Found under advanced parameters) and set the menu style to Legacy Vertical. 3. \r\nTop Menu Setup
Publish any menu to the 'cpanel' position. Set the menu class suffix to -top (Found under advanced parameters in Joomla 1.5) Make sure there are no module styles applied. Set the menu style to flat list (Legacy Flat List in Joomla 1.5) 4. Bottom Menu Setup
Publish any menu to the 'bottom' position. Set the menu class suffix to -bottom (Found under advanced parameters in Joomla 1.5) Make sure there are no module styles applied. Set the menu style to flat list (Legacy Flat List in Joomla 1.5) ', '', 1, 1, 0, 1, '2008-02-14 15:10:56', 62, '', '2008-10-08 18:58:46', 62, 0, '0000-00-00 00:00:00', '2008-02-14 15:10:36', '0000-00-00 00:00:00', '', '', 'pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=', 22, 0, 12, '', '', 0, 6569, ''),
(40, 'S5 Horizontal Login', 's5-horizontal-login', 'S5 Horizontal Login', 'The S5 Horizontal Login Module can be demo''d at the top of this page. Fully customize the module with label names and welcome messages of your own!\r\n\r\nDemo 1:\r\n \r\n\r\n<a onmouseover="Tip(''This is a sample tooltip.'', WIDTH, 140, OPACITY, 80, ABOVE, true, OFFSETX, 1, FADEIN, 200, FADEOUT, 300,SHADOW, true, SHADOWCOLOR, ''#000000'',SHADOWWIDTH, 2, BGCOLOR, ''#000000'',BORDERCOLOR, ''#000000'',FONTCOLOR, ''#FFFFFF'', PADDING, 9)" href="http://www.shape5.com/demo/etensity/">
\r\n<img class="boxed2" alt="" src="http://www.shape5.com/demo/smart_blogger/images/tooltip.jpg"/>
\r\n</a>\r\n
\r\n\r\n \r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nDemo 2:\r\n \r\n\r\n<a href="index.htm" onmouseover="Tip(''Image Demo
<img src=http://www.shape5.com/demo/smart_blogger/images/tooltip.jpg width=220 height=147>'')">Demo 2 Image Tool Tip </a> \r\n
Demo 2 Image Tool Tip \r\nDemo 3:\r\n \r\n\r\n<a href="#" onmouseover="Tip(''Image Demo<br /> <br /><img src=http://www.shape5.com/demo/smart_blogger/images/tooltip.jpg width=220 height=147>'',SHADOW, true, BGCOLOR, ''#000000'', FADEIN, 400, FADEOUT, 400, SHADOWCOLOR, ''#000000'', BORDERCOLOR, ''#000000'',OPACITY, 90,FONTCOLOR, ''#FFFFFF'')"><strong>Demo 3 Image Tool Tip</strong></a>\r\n
\r\n\r\n\r\nDemo 3 Image Tool Tip Have you ever wanted every page on your site to be unique? Well now it''s possible! Simply by using the built-in Joomla menu image you can assign that image as the background of the page! Use a default image that is set to all pages and then apply a unique background image to any page you wish.\r\nExample: Default Background Image:
\r\nCreating a background image: Try to keep your image size between 50k and 120k; using an 8 bit png or low quality jpg will help.
\r\nHow do I set the background color? You can set the background color to any \r\nweb-color you would like through the template configuration!How do I get my images on the menu? Step 1. Step 2.
\r\n\r\n\r\n
\r\nDon''t worry it''s not just for selling photos! \r\nThis module pulls directly from your Virtuemart categories so it can be used on \r\nany type of site!
List of Features:
\r\nList categories alphabetically or by your Virtuemart order \r\nChoose a black, white or custom color style \r\nWorks with onmouseover or onclick \r\nShows up to 3 sublevels of categories \r\nEnter your own button text \r\nAdjust the size of the button \r\nAdjust the size of the list \r\nCustomize the font size, color, margins, etc. for all text \r\nFully powered by S5 Effects \r\n \r\nList of Features:
\r\nSet the border colors to any color you wish \r\nShows up to 150 images and 5 module styles \r\nChoose from up to 5 colors for your module buttons \r\nUpload individual background images for the modules \r\nAdjust the height and width of the module and display window \r\nSet individual hyperlinks to the display window \r\nFully powered by S5 Effects \r\nIf there are more images than space will allow a custom scroll bar will \r\nautomatically appear: \r\n \r\n \r\n\r\nhttp://www.shape5.com/demo/aluma_photography/images/blue.jpg . The psd for \r\nthis background is included.
\r\n\r\nJoomla 1.0 requires you to setup new module positions, but it''s easy and only takes seconds. Here''s how you do it:
\r\n\r\n\r\n\r\nLogin to the backend of Joomla. \r\nNavigate through the menu system to Site/Template Manager/Module Positions \r\nStarting at the first blank position field enter s5_pe_1 as a name. \r\nContinue adding s5_pe_2, s5_pe_3 in the next fields up to s5_pe_5 \r\nClick the save button in the upper right hand corner and you''re done! \r\n \r\n\r\n\r\nSimply assign titles to each tab in the template configuration and publish modules to S5 Tab Show positions. You will see a section at the very bottom where you can name each of the 20 tabs. \r\n \r\n\r\n\r\nJoomla 1.0 requires you to setup 20 new module positions, but it''s easy and only takes seconds. Here''s how you do it:
\r\n\r\n\r\n\r\nLogin to the backend of Joomla. \r\nNavigate through the menu system to Site/Template Manager/Module Positions \r\nStarting at the first blank position field enter s5_tab1 as a name. \r\nContinue adding s5_tab2, s5_tab3 in the next fields up to s5_tab20 \r\nClick the save button in the upper right hand corner and you''re done! \r\n \r\n\r\nHow To Setup The Theme:
\r\nDownload the file shape5_aluma_photography_vm_10.zip from the Aluma \r\nPhotography download section \r\nExtract the contents of that zip file to components/com_virtuemart/themes/ \r\nLogin to the backend of Joomla \r\nNavigate to Components/Virtuemart \r\nOn the Virtuemart Menu click Admin/Configuration \r\nClick the Site tab \r\nUnder the drop down Select The Theme For Your Shop select \r\ns5_aluma_photography \r\nRight below that area select managed for Category Template and flypage.tpl for Flypage \r\nClick Save in the upper right \r\nNavigate back to the same drop down and click Configuration just beside \r\nwhere it says s5_aluma_photography \r\nAdjust the settings as desired. We recommend leaving the settings how they \r\nare for design reasons. Click Save when you''re done \r\n \r\n\r\n\r\n
\r\n\r\n\r\n\r\nSelling physical photos
\r\nThis is probably the easies of the two options. Simply create a product for \r\neach of your photos by using the Add Product form on the Virtuemart menu. When \r\nall of your settings are file out make sure to assign it to a category. On our \r\ndemo we have made the name of the customers the category name.
\r\nSelling downloadable photos
\r\n\r\nDo all the same steps listed above for a physical photo and save the \r\nproduct. \r\nWhen the product is saved navigate to Admin/Configuration/Downlads. \r\nOn the Downloads tab click the check box that says Enable Downloads. \r\nAdjust the DOWNLAODROOT field below that to where you will be storing your \r\ndownloads. \r\nClick Save when you are finished. \r\nNow click on Products/List Products and find the product you just created. \r\nIn the product list there is a column called Media, click on the Number next \r\nto image ex: (1) \r\nIn the popup there may be images already present, these are the images for \r\ndisplay on the site, not the download. \r\nClick on the New button in the upper right. \r\nBrowse for the file that is going to be the downloadable product \r\nThen in the File Type drop down select Downloadable Product File \r\nClick Save \r\n \r\nNow when a customer checks out with a downloadable item in the cart they will \r\nbe asked for payment information and once the item is paid for they will be sent \r\na download link via email.
\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n
\r\nIpsum Praesent veline condimentum cursuseso fringilla consectetuered amet ipsum dolor.
Lorem ipsum dolor sit amet consectetuer vitae sagittis tempus pede lacinia ipsum dolor sit amet ipsum dolor.\r\n
\r\n
Pricing Package # 1 \r\nIpsum Praesent veline condimentum cursuseso fringilla consectetuered amet ipsum dolor.\r\n\r\n\r\n
Pricing Package # 2 \r\nLorem ipsum dolor sit amet consectetuer vit sagitis ieuns menso sit amet dolor.\r\n\r\n', 1, 's5_pe_3', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(33, 'top', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-top\nmoduleclass_sfx=\nmenutype=top\nmenu_style=list_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 0, 0, ''),
(34, 'bottom', '', 1, 'bottom', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-bottom\nmoduleclass_sfx=\nmenutype=bottom\nmenu_style=list_flat\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 0, 0, ''),
(35, 'top', 'This is the top position. It is designed for the S5 Horizontal Login Module.', 2, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(36, 'cpanel', 'This is the cpanel position.', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(37, 'advert1', 'This is the advert1 position.', 2, 'advert1', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(38, 'advert2', 'This is the advert2 position.', 1, 'advert2', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(39, 'advert3', 'This is the advert3 position.', 1, 'advert3', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(40, 'left', 'This is the left position.', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(41, 'right', 'This is the right position.', 2, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(42, 'user2', 'This is the user2 position.', 1, 'user2', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(43, 'user3', 'This is the user3 position.', 2, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(44, 'user4', 'This is the user4 position.', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(45, 'user5', 'This is the user5 position.', 1, 'user5', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(46, 'debug', 'This is the debug position.', 1, 'debug', 0, '0000-00-00 00:00:00', 0, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(47, 'S5 Tab Show Is A Great Addition To Your Site!', 'The S5 Tab Show is a great way to organize your site''s content with a clean and professional display! \r\n\r\nWith the ability to use up to 20 tabs you will never run out of tabs again and each page can have its own unique tabs!\r\n\r\n\r\nclick here !\r\nEverything you see on this demo is available for both Joomla 1.5, Joomla 1.0 and Virtuemart 1.1 Our Site Shapers came with Virtuemart already preinstalled!
', 4, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0, ''),
(50, 'Breadcrumbs', '', 0, 'breadcrumb', 0, '0000-00-00 00:00:00', 1, 'mod_breadcrumbs', 0, 0, 1, 'showHome=1\nhomeText=Home\nshowLast=1\nseparator=\nmoduleclass_sfx=\ncache=0\n\n', 1, 0, ''),
(51, 'Shopping Cart', '', 9, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_virtuemart_cart', 0, 0, 1, 'moduleclass_sfx=\nvmCartDirection=0\nvmEnableGreyBox=0\n\n', 0, 0, ''),
(52, 'S5 VM Quick Category', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_s5_vm_quick_category', 0, 0, 0, 'moduleclass_sfx=\npretext=\nposttext=\nalphabetical=Yes\nclickormouse=onmouseover\ncloseyesno=yes\nbuttontext=Customer Photos\nblackorwhite=black\nstyle=black\nbuttonheight=27\nbuttonwidth=210\nlistwidth=210\nlistheight=280\nlistpadding=8\nlisttmargin=-2\nbuttontextsize=13\nbuttontextweight=bold\nbuttontpadding=5\nbuttonlpadding=33\nmoduletmargin=0\nmodulelmargin=0\nmodulermargin=0\nmodulebmargin=0\nfontsize1=11\nfontweight1=normal\nfontdecoration1=underline\nlineheight1=190%\npaddingl1=10\nmarginl1=0\nmarginr1=0\nfontsize2=11\nfontweight2=normal\nfontdecoration2=underline\nlineheight2=190%\npaddingl2=10\nmarginl2=0\nmarginr2=0\nfontsize3=11\nfontweight3=normal\nfontdecoration3=underline\nlineheight3=170%\npaddingl3=18\nmarginl3=0\nmarginr3=0\nbackground=#141414\nbuttoncolor=#FFFFFF\nbordert=#141414\nborderl=#484848\nborderr=#484848\nborderb=#484848\nborder=1px #222222 solid\nlevel1bg=#222222\nfontcolor1=#FFFFFF\nfontcolorhover1=#FFFFFF\nfontcolor2=#FFFFFF\nfontcolorhover2=#FFFFFF\nfontcolor3=#FFFFFF\nfontcolorhover3=#FFFFFF\n\n', 0, 0, ''),
(53, 'S5 Photo Expression', '', 0, 'advert1', 0, '0000-00-00 00:00:00', 1, 'mod_s5_photo_expression', 0, 0, 0, 'moduleclass_sfx=\npretext=\nposttext=\nmargint=0\nmarginl=0\nmarginr=0\nmarginb=20\nmoduleheight=372\nmodulewidth=948\nbordercolor=#FFFFFF\nhoverbordercolor=#666666\nbordersize=5\nwindowheight=300\nwindowwidth=320\nthumbheight=50\nthumbwidth=50\npos1color=blue\npos1text=Contact Us\npos1largebg=http://www.shape5.com/demo/aluma_photography/images/blue.jpg\npos2color=gold\npos2text=Learn Abous Us\npos2largebg=http://www.shape5.com/demo/aluma_photography/images/gold.jpg\npos3color=red\npos3text=Our Pricing\npos3largebg=http://www.shape5.com/demo/aluma_photography/images/red.jpg\npos4color=black\npos4text=Button 4\npos4largebg=\npos5color=purple\npos5text=Button 5\npos5largebg=\nimage1link=\nimage2link=\nimage3link=\nimage4link=\nimage5link=\nimage6link=\nimage7link=\nimage8link=\nimage9link=\nimage10link=\nimage11link=\nimage12link=\nimage13link=\nimage14link=\nimage15link=\nimage16link=\nimage17link=\nimage18link=\nimage19link=\nimage20link=\nimage21link=\nimage22link=\nimage23link=\nimage24link=\nimage25link=\nimage26link=\nimage27link=\nimage28link=\nimage29link=\nimage30link=\nimage31link=\nimage32link=\nimage33link=\nimage34link=\nimage35link=\nimage36link=\nimage37link=\nimage38link=\nimage39link=\nimage40link=\nimage41link=\nimage42link=\nimage43link=\nimage44link=\nimage45link=\nimage46link=\nimage47link=\nimage48link=\nimage49link=\nimage50link=\nimage51link=\nimage52link=\nimage53link=\nimage54link=\nimage55link=\nimage56link=\nimage57link=\nimage58link=\nimage59link=\nimage60link=\nimage61link=\nimage62link=\nimage63link=\nimage64link=\nimage65link=\nimage66link=\nimage67link=\nimage68link=\nimage69link=\nimage70link=\nimage71link=\nimage72link=\nimage73link=\nimage74link=\nimage75link=\nimage76link=\nimage77link=\nimage78link=\nimage79link=\nimage80link=\nimage81link=\nimage82link=\nimage83link=\nimage84link=\nimage85link=\nimage86link=\nimage87link=\nimage88link=\nimage89link=\nimage90link=\nimage91link=\nimage92link=\nimage93link=\nimage94link=\nimage95link=\nimage96link=\nimage97link=\nimage98link=\nimage99link=\nimage100link=\nimage101link=\nimage102link=\nimage103link=\nimage104link=\nimage105link=\nimage106link=\nimage107link=\nimage108link=\nimage109link=\nimage110link=\nimage111link=\nimage112link=\nimage113link=\nimage114link=\nimage115link=\nimage116link=\nimage117link=\nimage118link=\nimage119link=\nimage120link=\nimage121link=\nimage122link=\nimage123link=\nimage124link=\nimage125link=\nimage126link=\nimage127link=\nimage128link=\nimage129link=\nimage130link=\nimage131link=\nimage132link=\nimage133link=\nimage134link=\nimage135link=\nimage136link=\nimage137link=\nimage138link=\nimage139link=\nimage140link=\nimage141link=\nimage142link=\nimage143link=\nimage144link=\nimage145link=\nimage146link=\nimage147link=\nimage148link=\nimage149link=\nimage150link=\n\n', 0, 0, ''),
(54, 'Contact Us', '', 9, 's5_pe_1', 0, '0000-00-00 00:00:00', 1, 'mod_s5_quick_contact', 0, 0, 1, 'moduleclass_sfx=\npretext=\nadminemail=\nsubjectprefix=Website Submission -\nnametext=Name...\nemailtext=Email...\nsubjecttext=Subject...\nbodytext=Your Message...\nsendtext=Send Message\nwidth=80%\nheight=55px\nthankyou=Your email is now being submitted - Thank you!\nemailerror=Your email address is not valid, please check again - Thank you!\nnotcomplete=All fields are required, please complete the form - Thank you!\n\n', 0, 0, ''),
(55, 'S5 Horizontal Login', '', 9, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_s5_horizontal_login', 0, 0, 1, 'cache=0\nmoduleclass_sfx=\nlogin=\nlogout=\ngreeting=1\nmessageyn=1\nmessage=Welcome to our site!\nusername=Username\npassword=Password\nname=0\nforgotp=Forgot Password?\nforgotu=Username?\n\n', 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_modules_menu`
--
CREATE TABLE `jos_modules_menu` (
`moduleid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_modules_menu`
--
INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES
(16, 1),
(16, 42),
(17, 2),
(17, 3),
(17, 5),
(17, 7),
(17, 8),
(17, 23),
(17, 25),
(17, 26),
(17, 27),
(17, 28),
(17, 29),
(17, 30),
(17, 31),
(17, 32),
(17, 33),
(17, 34),
(17, 35),
(17, 36),
(17, 37),
(17, 38),
(17, 47),
(17, 48),
(17, 53),
(17, 54),
(17, 55),
(17, 59),
(17, 65),
(17, 70),
(17, 80),
(17, 82),
(17, 83),
(17, 87),
(17, 88),
(17, 97),
(17, 100),
(17, 101),
(17, 111),
(17, 112),
(17, 113),
(17, 114),
(17, 115),
(17, 116),
(17, 117),
(17, 118),
(17, 119),
(17, 120),
(17, 121),
(17, 122),
(18, 116),
(18, 117),
(19, 1),
(21, 1),
(21, 110),
(21, 99999999),
(22, 1),
(24, 52),
(24, 64),
(25, 1),
(25, 2),
(25, 3),
(25, 5),
(25, 7),
(25, 8),
(25, 17),
(25, 23),
(25, 25),
(25, 26),
(25, 27),
(25, 28),
(25, 29),
(25, 30),
(25, 31),
(25, 42),
(25, 43),
(25, 44),
(25, 45),
(25, 47),
(25, 52),
(25, 53),
(25, 54),
(25, 55),
(25, 56),
(25, 59),
(25, 64),
(25, 65),
(25, 68),
(25, 70),
(25, 71),
(25, 72),
(25, 73),
(25, 74),
(25, 75),
(25, 76),
(27, 0),
(29, 1),
(29, 2),
(29, 3),
(29, 5),
(29, 7),
(29, 8),
(29, 14),
(29, 15),
(29, 17),
(29, 21),
(29, 23),
(29, 25),
(29, 26),
(29, 27),
(29, 28),
(29, 29),
(29, 30),
(29, 31),
(29, 32),
(29, 33),
(29, 34),
(29, 35),
(29, 36),
(29, 37),
(29, 38),
(29, 42),
(29, 43),
(29, 44),
(29, 45),
(29, 47),
(29, 48),
(29, 53),
(29, 54),
(29, 55),
(29, 59),
(29, 65),
(29, 70),
(29, 73),
(29, 74),
(29, 75),
(29, 76),
(29, 80),
(29, 82),
(29, 83),
(29, 87),
(29, 88),
(29, 97),
(29, 98),
(29, 99),
(29, 100),
(29, 101),
(31, 0),
(32, 0),
(33, 1),
(34, 0),
(35, 49),
(36, 49),
(37, 49),
(38, 49),
(39, 49),
(40, 49),
(41, 49),
(42, 49),
(43, 49),
(44, 49),
(45, 49),
(46, 49),
(47, 116),
(47, 117),
(48, 1),
(49, 1),
(50, 0),
(51, 1),
(51, 123),
(52, 0),
(53, 1),
(54, 1),
(55, 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_newsfeeds`
--
CREATE TABLE `jos_newsfeeds` (
`catid` int(11) NOT NULL default '0',
`id` int(11) NOT NULL auto_increment,
`name` text NOT NULL,
`alias` varchar(255) NOT NULL default '',
`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',
`rtl` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `published` (`published`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `jos_newsfeeds`
--
INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `alias`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`, `rtl`) VALUES
(4, 1, 'Joomla! - Official News', 'joomla-official-news', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 8, 0),
(4, 2, 'Joomla! - Community News', 'joomla-community-news', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 9, 0),
(10, 4, 'Linux Today', 'linux-today', 'http://linuxtoday.com/backend/my-netscape.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(5, 5, 'Business News', 'business-news', 'http://headlines.internet.com/internetnews/bus-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(11, 6, 'Web Developer News', 'web-developer-news', 'http://headlines.internet.com/internetnews/wd-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(10, 7, 'Linux Central:New Products', 'linux-centralnew-products', 'http://linuxcentral.com/backend/lcnew.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(10, 8, 'Linux Central:Best Selling', 'linux-centralbest-selling', 'http://linuxcentral.com/backend/lcbestns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 5, 0),
(10, 9, 'Linux Central:Daily Specials', 'linux-centraldaily-specials', 'http://linuxcentral.com/backend/lcspecialns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 6, 0),
(9, 10, 'Internet:Finance News', 'internetfinance-news', 'http://headlines.internet.com/internetnews/fina-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 7, 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_plugins`
--
CREATE TABLE `jos_plugins` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`folder` varchar(100) NOT NULL default '',
`access` tinyint(3) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(3) NOT NULL default '0',
`iscore` tinyint(3) NOT NULL default '0',
`client_id` tinyint(3) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
--
-- Dumping data for table `jos_plugins`
--
INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Authentication - Joomla', 'joomla', 'authentication', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(2, 'Authentication - LDAP', 'ldap', 'authentication', 0, 2, 0, 1, 0, 0, '0000-00-00 00:00:00', 'host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),
(3, 'Authentication - GMail', 'gmail', 'authentication', 0, 4, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(4, 'Authentication - OpenID', 'openid', 'authentication', 0, 3, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(5, 'User - Joomla!', 'joomla', 'user', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'autoregister=1\n\n'),
(6, 'Search - Content', 'content', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),
(7, 'Search - Contacts', 'contacts', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(8, 'Search - Categories', 'categories', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(9, 'Search - Sections', 'sections', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(10, 'Search - Newsfeeds', 'newsfeeds', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(11, 'Search - Weblinks', 'weblinks', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(12, 'Content - Pagebreak', 'pagebreak', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', 'enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),
(13, 'Content - Rating', 'vote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Content - Email Cloaking', 'emailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'mode=1\n\n'),
(15, 'Content - Code Hightlighter (GeSHi)', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(16, 'Content - Load Module', 'loadmodule', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'enabled=1\nstyle=0\n\n'),
(17, 'Content - Page Navigation', 'pagenavigation', 'content', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'position=1\n\n'),
(18, 'Editor - No Editor', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Editor - TinyMCE 2.0', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'theme=advanced\ncleanup=1\ncleanup_startup=0\nautosave=0\ncompressed=0\nrelative_urls=1\ntext_direction=ltr\nlang_mode=0\nlang_code=en\ninvalid_elements=applet\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nhr=1\nsmilies=1\ntable=1\nstyle=1\nlayer=1\nxhtmlxtras=0\ntemplate=0\ndirectionality=1\nfullscreen=1\nhtml_height=550\nhtml_width=750\npreview=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\n\n'),
(20, 'Editor - XStandard Lite 2.0', 'xstandard', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(21, 'Editor Button - Image', 'image', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(22, 'Editor Button - Pagebreak', 'pagebreak', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(23, 'Editor Button - Readmore', 'readmore', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(24, 'XML-RPC - Joomla', 'joomla', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(25, 'XML-RPC - Blogger API', 'blogger', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', 'catid=1\nsectionid=0\n\n'),
(27, 'System - SEF', 'sef', 'system', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(28, 'System - Debug', 'debug', 'system', 0, 2, 1, 0, 0, 0, '0000-00-00 00:00:00', 'queries=1\nmemory=1\nlangauge=1\n\n'),
(29, 'System - Legacy', 'legacy', 'system', 0, 3, 0, 1, 0, 0, '0000-00-00 00:00:00', 'route=0\n\n'),
(30, 'System - Cache', 'cache', 'system', 0, 4, 0, 1, 0, 0, '0000-00-00 00:00:00', 'browsercache=0\ncachetime=15\n\n'),
(31, 'System - Log', 'log', 'system', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(32, 'System - Remember Me', 'remember', 'system', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(33, 'System - Backlink', 'backlink', 'system', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(34, 'Virtuemart Extended Search Plugin', 'vmxsearch.plugin', 'search', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'density_flag=1\nname_flag=1\nsku_flag=1\ndesc_flag=1\nsdesc_flag=1\nurl_flag=1\nreview_flag=1\nmanufacturer_flag=1\ncategory_flag=1\nparent_filter=both\n');
-- --------------------------------------------------------
--
-- Table structure for table `jos_polls`
--
CREATE TABLE `jos_polls` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`voters` int(9) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL default '0',
`access` int(11) NOT NULL default '0',
`lag` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_polls`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_poll_data`
--
CREATE TABLE `jos_poll_data` (
`id` int(11) NOT NULL auto_increment,
`pollid` int(11) NOT NULL default '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_poll_data`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_poll_date`
--
CREATE TABLE `jos_poll_date` (
`id` bigint(20) NOT NULL auto_increment,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL default '0',
`poll_id` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_poll_date`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_poll_menu`
--
CREATE TABLE `jos_poll_menu` (
`pollid` int(11) NOT NULL default '0',
`menuid` int(11) NOT NULL default '0',
PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_poll_menu`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_sections`
--
CREATE TABLE `jos_sections` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`image` text NOT NULL,
`scope` varchar(50) NOT NULL default '',
`image_position` varchar(30) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `jos_sections`
--
INSERT INTO `jos_sections` (`id`, `title`, `name`, `alias`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(1, 'News', 'The News', 'news', 'articles.jpg', 'content', 'right', 'Select a news topic from the list below, then select a news article to read.', 1, 0, '0000-00-00 00:00:00', 1, 0, 1, ''),
(2, 'Newsflashes', 'Newsflashes', 'newsflashes', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 2, 0, 2, ''),
(3, 'FAQs', 'Frequently Asked Questions', 'faqs', 'pastarchives.jpg', 'content', 'left', 'From the list below choose one of our FAQs topics, then select an FAQ to read. If you have a question which is not in this section, please contact us.', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_session`
--
CREATE TABLE `jos_session` (
`username` varchar(150) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
`client_id` tinyint(3) unsigned NOT NULL default '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_session`
--
INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
('shape5admin', '1223690786', 'fmga57m0klu8vetfaelbqlpec5', 0, 62, 'Super Administrator', 25, 1, '__default|a:8:{s:15:"session.counter";i:15;s:19:"session.timer.start";i:1223690597;s:18:"session.timer.last";i:1223690786;s:17:"session.timer.now";i:1223690786;s:22:"session.client.browser";s:92:"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:3:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}s:11:"application";a:1:{s:4:"data";O:8:"stdClass":1:{s:4:"lang";s:0:"";}}s:9:"com_menus";a:1:{s:4:"data";O:8:"stdClass":1:{s:8:"menutype";s:8:"mainmenu";}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";s:2:"62";s:4:"name";s:13:"Administrator";s:8:"username";s:11:"shape5admin";s:5:"email";s:7:"a@a.com";s:8:"password";s:49:"dec1b57cc4811844a61c7fe7b0925a44:dz9RF6xOfun4KowG";s:14:"password_clear";s:0:"";s:8:"usertype";s:19:"Super Administrator";s:5:"block";s:1:"0";s:9:"sendEmail";s:1:"1";s:3:"gid";s:2:"25";s:12:"registerDate";s:19:"2008-10-07 08:54:13";s:13:"lastvisitDate";s:19:"2008-10-11 02:03:37";s:10:"activation";s:0:"";s:6:"params";s:30:"editor=\nexpired=\nexpired_time=";s:3:"aid";i:2;s:5:"guest";i:0;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:56:"C:\\wamp\\www\\15ss\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":3:{s:6:"editor";s:0:"";s:7:"expired";s:0:"";s:12:"expired_time";s:0:"";}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"85f1472b5d4920205db0fb911996b6f5";}userstate|a:1:{s:10:"product_id";i:0;}auth|a:13:{s:11:"show_prices";i:1;s:7:"user_id";s:2:"62";s:8:"username";s:11:"shape5admin";s:5:"perms";s:5:"admin";s:10:"first_name";s:1:"a";s:9:"last_name";s:1:"a";s:7:"country";s:3:"ZWE";s:3:"zip";s:1:"a";s:16:"shopper_group_id";s:1:"5";s:22:"shopper_group_discount";s:4:"0.00";s:24:"show_price_including_tax";s:1:"1";s:21:"default_shopper_group";s:1:"1";s:22:"is_registered_customer";b:1;}savedcart|a:1:{s:3:"idx";i:0;}cart|a:1:{s:3:"idx";i:0;}recent|a:1:{s:3:"idx";i:0;}ps_vendor_id|s:1:"1";minimum_pov|s:4:"0.00";vendor_currency|s:3:"USD";last_page|s:15:"admin.user_list";'),
('', '1223691024', '5gc5kvtfon7f90lc448k67ap65', 1, 0, '', 0, 0, '__default|a:8:{s:15:"session.counter";i:9;s:19:"session.timer.start";i:1223690776;s:18:"session.timer.last";i:1223691012;s:17:"session.timer.now";i:1223691024;s:22:"session.client.browser";s:92:"Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.17) Gecko/20080829 Firefox/2.0.0.17";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";s:15:"Public Frontend";s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:56:"C:\\wamp\\www\\15ss\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"302d7ce6107aeaeb546ebc7dc339c628";}userstate|a:1:{s:10:"product_id";i:0;}auth|a:11:{s:11:"show_prices";i:1;s:7:"user_id";i:0;s:8:"username";s:4:"demo";s:5:"perms";s:0:"";s:10:"first_name";s:5:"guest";s:9:"last_name";s:0:"";s:16:"shopper_group_id";s:1:"5";s:22:"shopper_group_discount";s:4:"0.00";s:24:"show_price_including_tax";s:1:"1";s:21:"default_shopper_group";i:1;s:22:"is_registered_customer";b:0;}cart|a:1:{s:3:"idx";i:0;}recent|a:1:{s:3:"idx";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:"0.00";vendor_currency|s:3:"USD";vmUseGreyBox|s:1:"0";vmCartDirection|s:1:"0";VMCHECK|s:2:"OK";last_page|s:11:"shop.browse";last_browse_parameters|a:7:{s:11:"category_id";i:11;s:15:"manufacturer_id";i:0;s:7:"keyword";b:0;s:8:"keyword1";s:0:"";s:8:"keyword2";s:0:"";s:8:"featured";s:1:"N";s:10:"discounted";s:1:"N";}product_sess|a:3:{i:32;a:3:{s:13:"discount_info";a:3:{s:6:"amount";i:0;s:10:"is_percent";i:0;s:11:"create_time";i:1223690822;}s:9:"vendor_id";s:1:"1";s:8:"tax_rate";s:6:"0.0825";}i:33;a:3:{s:13:"discount_info";a:3:{s:6:"amount";i:0;s:10:"is_percent";i:0;s:11:"create_time";i:1223690822;}s:9:"vendor_id";s:1:"1";s:8:"tax_rate";s:6:"0.0825";}i:34;a:3:{s:13:"discount_info";a:3:{s:6:"amount";i:0;s:10:"is_percent";i:0;s:11:"create_time";i:1223690822;}s:9:"vendor_id";s:1:"1";s:8:"tax_rate";s:6:"0.0825";}}taxrate|a:1:{i:1;s:6:"0.0825";}');
-- --------------------------------------------------------
--
-- Table structure for table `jos_stats_agents`
--
CREATE TABLE `jos_stats_agents` (
`agent` varchar(255) NOT NULL default '',
`type` tinyint(1) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_stats_agents`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_templates_menu`
--
CREATE TABLE `jos_templates_menu` (
`template` varchar(255) NOT NULL default '',
`menuid` int(11) NOT NULL default '0',
`client_id` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `jos_templates_menu`
--
INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('aluma_photography', 0, 0),
('joomla_admin', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_users`
--
CREATE TABLE `jos_users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`username` varchar(150) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`usertype` varchar(25) NOT NULL default '',
`block` tinyint(4) NOT NULL default '0',
`sendEmail` tinyint(4) default '0',
`gid` tinyint(3) unsigned NOT NULL default '1',
`registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL default '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
--
-- Dumping data for table `jos_users`
--
INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', 'a@a.com', '5fc1a893f2b75da56f143de882d2e255:lUnE9FuakZ4FpgQmlkb3LrbDdVGdJIXz', 'Super Administrator', 0, 1, 25, '2008-10-07 08:54:13', '2008-10-11 02:03:37', '', 'editor=\nexpired=\nexpired_time=\nadmin_language=\nlanguage=\nhelpsite=\ntimezone=0\n\n');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_affiliate`
--
CREATE TABLE `jos_vm_affiliate` (
`affiliate_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`active` char(1) NOT NULL default 'N',
`rate` int(11) NOT NULL default '0',
PRIMARY KEY (`affiliate_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store affiliate user entries' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_affiliate`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_affiliate_sale`
--
CREATE TABLE `jos_vm_affiliate_sale` (
`order_id` int(11) NOT NULL default '0',
`visit_id` varchar(32) NOT NULL default '',
`affiliate_id` int(11) NOT NULL default '0',
`rate` int(2) NOT NULL default '0',
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores orders that affiliates have placed';
--
-- Dumping data for table `jos_vm_affiliate_sale`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_auth_group`
--
CREATE TABLE `jos_vm_auth_group` (
`group_id` int(11) NOT NULL auto_increment,
`group_name` varchar(128) default NULL,
`group_level` int(11) default NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds all the user groups' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jos_vm_auth_group`
--
INSERT INTO `jos_vm_auth_group` (`group_id`, `group_name`, `group_level`) VALUES
(1, 'admin', 0),
(2, 'storeadmin', 250),
(3, 'shopper', 500),
(4, 'demo', 750);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_auth_user_group`
--
CREATE TABLE `jos_vm_auth_user_group` (
`user_id` int(11) NOT NULL default '0',
`group_id` int(11) default NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps the user to user groups';
--
-- Dumping data for table `jos_vm_auth_user_group`
--
INSERT INTO `jos_vm_auth_user_group` (`user_id`, `group_id`) VALUES
(62, 2);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_auth_user_vendor`
--
CREATE TABLE `jos_vm_auth_user_vendor` (
`user_id` int(11) default NULL,
`vendor_id` int(11) default NULL,
KEY `idx_auth_user_vendor_user_id` (`user_id`),
KEY `idx_auth_user_vendor_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps a user to a vendor';
--
-- Dumping data for table `jos_vm_auth_user_vendor`
--
INSERT INTO `jos_vm_auth_user_vendor` (`user_id`, `vendor_id`) VALUES
(62, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_cart`
--
CREATE TABLE `jos_vm_cart` (
`user_id` int(11) NOT NULL,
`cart_content` text NOT NULL,
`last_updated` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the cart contents of a user';
--
-- Dumping data for table `jos_vm_cart`
--
INSERT INTO `jos_vm_cart` (`user_id`, `cart_content`, `last_updated`) VALUES
(62, 'a:1:{s:3:"idx";i:0;}', '2008-10-10 22:03:49');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_category`
--
CREATE TABLE `jos_vm_category` (
`category_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`category_name` varchar(128) NOT NULL default '',
`category_description` text,
`category_thumb_image` varchar(255) default NULL,
`category_full_image` varchar(255) default NULL,
`category_publish` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`category_browsepage` varchar(255) NOT NULL default 'browse_1',
`products_per_row` tinyint(2) NOT NULL default '1',
`category_flypage` varchar(255) default NULL,
`list_order` int(11) default NULL,
PRIMARY KEY (`category_id`),
KEY `idx_category_vendor_id` (`vendor_id`),
KEY `idx_category_name` (`category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Product Categories are stored here' AUTO_INCREMENT=12 ;
--
-- Dumping data for table `jos_vm_category`
--
INSERT INTO `jos_vm_category` (`category_id`, `vendor_id`, `category_name`, `category_description`, `category_thumb_image`, `category_full_image`, `category_publish`, `cdate`, `mdate`, `category_browsepage`, `products_per_row`, `category_flypage`, `list_order`) VALUES
(6, 1, 'Peroni and Rotenberger', 'Wedding pictures of Sarah Peroni and Luke Rotenberger', 'resized/Peroni_and_Roten_48ee56d70c96f_90x90.jpg', 'Peroni_and_Roten_48ee56d71909f.jpg', 'Y', 1223579350, 1223579350, 'managed', 3, 'flypage.tpl', 5),
(2, 1, 'Reynolds and McArthur', 'Wedding pictures of Sarah Reynolds and Luke McArthur', 'resized/Reynolds_and_McA_48ee52bf27979_90x90.jpg', 'Reynolds_and_McA_48ee52bf33cc3.jpg', 'Y', 1223568384, 1223578303, 'managed', 3, 'flypage.tpl', 6),
(3, 1, 'Smith and Burdick', 'Wedding pictures of Sarah Smith and Luke Burdick', 'resized/Smith_and_Burdic_48ee5315bd395_90x90.jpg', 'Smith_and_Burdic_48ee5315c9ead.jpg', 'Y', 1223576138, 1223578389, 'managed', 3, 'flypage.tpl', 8),
(4, 1, 'Brandford and Fries', 'Wedding pictures of Sarah Brandford and Luke Fries', 'resized/Brandford_and_Fr_48ee52e7eec48_90x90.jpg', 'Brandford_and_Fr_48ee52e807137.jpg', 'Y', 1223576898, 1223578343, 'managed', 3, 'flypage.tpl', 2),
(5, 1, 'Rogers and Patten', 'Wedding pictures of Sarah Rogers and Luke Patten', 'resized/Rogers_and_Patte_48ee52f97d153_90x90.jpg', 'Rogers_and_Patte_48ee52f98a053.jpg', 'Y', 1223577472, 1223578361, 'managed', 3, 'flypage.tpl', 7),
(7, 1, 'Miller and Kurtz', 'Wedding pictures of Sarah Miller and Luke Kurtz', 'resized/Miller_and_Kurtz_48ee585eda14c_90x90.jpg', 'Miller_and_Kurtz_48ee585ee687c.jpg', 'Y', 1223579742, 1223579742, 'managed', 3, 'flypage.tpl', 4),
(8, 1, 'Glasner and Huber', 'Wedding pictures of Sarah Glasner and Luke Huber', 'resized/Glasner_and_Hube_48ee59775eec5_90x90.jpg', 'Glasner_and_Hube_48ee59776b5f6.jpg', 'Y', 1223580023, 1223580023, 'managed', 3, 'flypage.tpl', 3),
(9, 1, 'Miscellaneous Photos -', '', 'resized/Miscellaneous_Ph_48ee5add9be78_90x90.jpg', 'Miscellaneous_Ph_48ee5adda81bf.jpg', 'Y', 1223580381, 1223586764, 'managed', 3, 'flypage.tpl', 9),
(10, 1, 'Car Pictures', '', 'resized/Car_Pictures_48ee5b5a17dd0_90x90.jpg', 'Car_Pictures_48ee5b5a254a2.jpg', 'Y', 1223580506, 1223580506, 'managed', 3, 'flypage.tpl', 1),
(11, 1, 'Scenery Pictures', '', 'resized/Scenery_Pictures_48ee5c745f383_90x90.jpg', 'Scenery_Pictures_48ee5c746be9c.jpg', 'Y', 1223580788, 1223580788, 'managed', 3, 'flypage.tpl', 2);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_category_xref`
--
CREATE TABLE `jos_vm_category_xref` (
`category_parent_id` int(11) NOT NULL default '0',
`category_child_id` int(11) NOT NULL default '0',
`category_list` int(11) default NULL,
PRIMARY KEY (`category_child_id`),
KEY `category_xref_category_parent_id` (`category_parent_id`),
KEY `idx_category_xref_category_list` (`category_list`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Category child-parent relation list';
--
-- Dumping data for table `jos_vm_category_xref`
--
INSERT INTO `jos_vm_category_xref` (`category_parent_id`, `category_child_id`, `category_list`) VALUES
(0, 3, NULL),
(0, 2, NULL),
(0, 4, NULL),
(0, 5, NULL),
(0, 6, NULL),
(0, 7, NULL),
(0, 8, NULL),
(0, 9, NULL),
(9, 10, NULL),
(9, 11, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_country`
--
CREATE TABLE `jos_vm_country` (
`country_id` int(11) NOT NULL auto_increment,
`zone_id` int(11) NOT NULL default '1',
`country_name` varchar(64) default NULL,
`country_3_code` char(3) default NULL,
`country_2_code` char(2) default NULL,
PRIMARY KEY (`country_id`),
KEY `idx_country_name` (`country_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Country records' AUTO_INCREMENT=245 ;
--
-- Dumping data for table `jos_vm_country`
--
INSERT INTO `jos_vm_country` (`country_id`, `zone_id`, `country_name`, `country_3_code`, `country_2_code`) VALUES
(1, 1, 'Afghanistan', 'AFG', 'AF'),
(2, 1, 'Albania', 'ALB', 'AL'),
(3, 1, 'Algeria', 'DZA', 'DZ'),
(4, 1, 'American Samoa', 'ASM', 'AS'),
(5, 1, 'Andorra', 'AND', 'AD'),
(6, 1, 'Angola', 'AGO', 'AO'),
(7, 1, 'Anguilla', 'AIA', 'AI'),
(8, 1, 'Antarctica', 'ATA', 'AQ'),
(9, 1, 'Antigua and Barbuda', 'ATG', 'AG'),
(10, 1, 'Argentina', 'ARG', 'AR'),
(11, 1, 'Armenia', 'ARM', 'AM'),
(12, 1, 'Aruba', 'ABW', 'AW'),
(13, 1, 'Australia', 'AUS', 'AU'),
(14, 1, 'Austria', 'AUT', 'AT'),
(15, 1, 'Azerbaijan', 'AZE', 'AZ'),
(16, 1, 'Bahamas', 'BHS', 'BS'),
(17, 1, 'Bahrain', 'BHR', 'BH'),
(18, 1, 'Bangladesh', 'BGD', 'BD'),
(19, 1, 'Barbados', 'BRB', 'BB'),
(20, 1, 'Belarus', 'BLR', 'BY'),
(21, 1, 'Belgium', 'BEL', 'BE'),
(22, 1, 'Belize', 'BLZ', 'BZ'),
(23, 1, 'Benin', 'BEN', 'BJ'),
(24, 1, 'Bermuda', 'BMU', 'BM'),
(25, 1, 'Bhutan', 'BTN', 'BT'),
(26, 1, 'Bolivia', 'BOL', 'BO'),
(27, 1, 'Bosnia and Herzegowina', 'BIH', 'BA'),
(28, 1, 'Botswana', 'BWA', 'BW'),
(29, 1, 'Bouvet Island', 'BVT', 'BV'),
(30, 1, 'Brazil', 'BRA', 'BR'),
(31, 1, 'British Indian Ocean Territory', 'IOT', 'IO'),
(32, 1, 'Brunei Darussalam', 'BRN', 'BN'),
(33, 1, 'Bulgaria', 'BGR', 'BG'),
(34, 1, 'Burkina Faso', 'BFA', 'BF'),
(35, 1, 'Burundi', 'BDI', 'BI'),
(36, 1, 'Cambodia', 'KHM', 'KH'),
(37, 1, 'Cameroon', 'CMR', 'CM'),
(38, 1, 'Canada', 'CAN', 'CA'),
(39, 1, 'Cape Verde', 'CPV', 'CV'),
(40, 1, 'Cayman Islands', 'CYM', 'KY'),
(41, 1, 'Central African Republic', 'CAF', 'CF'),
(42, 1, 'Chad', 'TCD', 'TD'),
(43, 1, 'Chile', 'CHL', 'CL'),
(44, 1, 'China', 'CHN', 'CN'),
(45, 1, 'Christmas Island', 'CXR', 'CX'),
(46, 1, 'Cocos (Keeling) Islands', 'CCK', 'CC'),
(47, 1, 'Colombia', 'COL', 'CO'),
(48, 1, 'Comoros', 'COM', 'KM'),
(49, 1, 'Congo', 'COG', 'CG'),
(50, 1, 'Cook Islands', 'COK', 'CK'),
(51, 1, 'Costa Rica', 'CRI', 'CR'),
(52, 1, 'Cote D''Ivoire', 'CIV', 'CI'),
(53, 1, 'Croatia', 'HRV', 'HR'),
(54, 1, 'Cuba', 'CUB', 'CU'),
(55, 1, 'Cyprus', 'CYP', 'CY'),
(56, 1, 'Czech Republic', 'CZE', 'CZ'),
(57, 1, 'Denmark', 'DNK', 'DK'),
(58, 1, 'Djibouti', 'DJI', 'DJ'),
(59, 1, 'Dominica', 'DMA', 'DM'),
(60, 1, 'Dominican Republic', 'DOM', 'DO'),
(61, 1, 'East Timor', 'TMP', 'TP'),
(62, 1, 'Ecuador', 'ECU', 'EC'),
(63, 1, 'Egypt', 'EGY', 'EG'),
(64, 1, 'El Salvador', 'SLV', 'SV'),
(65, 1, 'Equatorial Guinea', 'GNQ', 'GQ'),
(66, 1, 'Eritrea', 'ERI', 'ER'),
(67, 1, 'Estonia', 'EST', 'EE'),
(68, 1, 'Ethiopia', 'ETH', 'ET'),
(69, 1, 'Falkland Islands (Malvinas)', 'FLK', 'FK'),
(70, 1, 'Faroe Islands', 'FRO', 'FO'),
(71, 1, 'Fiji', 'FJI', 'FJ'),
(72, 1, 'Finland', 'FIN', 'FI'),
(73, 1, 'France', 'FRA', 'FR'),
(74, 1, 'France, Metropolitan', 'FXX', 'FX'),
(75, 1, 'French Guiana', 'GUF', 'GF'),
(76, 1, 'French Polynesia', 'PYF', 'PF'),
(77, 1, 'French Southern Territories', 'ATF', 'TF'),
(78, 1, 'Gabon', 'GAB', 'GA'),
(79, 1, 'Gambia', 'GMB', 'GM'),
(80, 1, 'Georgia', 'GEO', 'GE'),
(81, 1, 'Germany', 'DEU', 'DE'),
(82, 1, 'Ghana', 'GHA', 'GH'),
(83, 1, 'Gibraltar', 'GIB', 'GI'),
(84, 1, 'Greece', 'GRC', 'GR'),
(85, 1, 'Greenland', 'GRL', 'GL'),
(86, 1, 'Grenada', 'GRD', 'GD'),
(87, 1, 'Guadeloupe', 'GLP', 'GP'),
(88, 1, 'Guam', 'GUM', 'GU'),
(89, 1, 'Guatemala', 'GTM', 'GT'),
(90, 1, 'Guinea', 'GIN', 'GN'),
(91, 1, 'Guinea-bissau', 'GNB', 'GW'),
(92, 1, 'Guyana', 'GUY', 'GY'),
(93, 1, 'Haiti', 'HTI', 'HT'),
(94, 1, 'Heard and Mc Donald Islands', 'HMD', 'HM'),
(95, 1, 'Honduras', 'HND', 'HN'),
(96, 1, 'Hong Kong', 'HKG', 'HK'),
(97, 1, 'Hungary', 'HUN', 'HU'),
(98, 1, 'Iceland', 'ISL', 'IS'),
(99, 1, 'India', 'IND', 'IN'),
(100, 1, 'Indonesia', 'IDN', 'ID'),
(101, 1, 'Iran (Islamic Republic of)', 'IRN', 'IR'),
(102, 1, 'Iraq', 'IRQ', 'IQ'),
(103, 1, 'Ireland', 'IRL', 'IE'),
(104, 1, 'Israel', 'ISR', 'IL'),
(105, 1, 'Italy', 'ITA', 'IT'),
(106, 1, 'Jamaica', 'JAM', 'JM'),
(107, 1, 'Japan', 'JPN', 'JP'),
(108, 1, 'Jordan', 'JOR', 'JO'),
(109, 1, 'Kazakhstan', 'KAZ', 'KZ'),
(110, 1, 'Kenya', 'KEN', 'KE'),
(111, 1, 'Kiribati', 'KIR', 'KI'),
(112, 1, 'Korea, Democratic People''s Republic of', 'PRK', 'KP'),
(113, 1, 'Korea, Republic of', 'KOR', 'KR'),
(114, 1, 'Kuwait', 'KWT', 'KW'),
(115, 1, 'Kyrgyzstan', 'KGZ', 'KG'),
(116, 1, 'Lao People''s Democratic Republic', 'LAO', 'LA'),
(117, 1, 'Latvia', 'LVA', 'LV'),
(118, 1, 'Lebanon', 'LBN', 'LB'),
(119, 1, 'Lesotho', 'LSO', 'LS'),
(120, 1, 'Liberia', 'LBR', 'LR'),
(121, 1, 'Libyan Arab Jamahiriya', 'LBY', 'LY'),
(122, 1, 'Liechtenstein', 'LIE', 'LI'),
(123, 1, 'Lithuania', 'LTU', 'LT'),
(124, 1, 'Luxembourg', 'LUX', 'LU'),
(125, 1, 'Macau', 'MAC', 'MO'),
(126, 1, 'Macedonia, The Former Yugoslav Republic of', 'MKD', 'MK'),
(127, 1, 'Madagascar', 'MDG', 'MG'),
(128, 1, 'Malawi', 'MWI', 'MW'),
(129, 1, 'Malaysia', 'MYS', 'MY'),
(130, 1, 'Maldives', 'MDV', 'MV'),
(131, 1, 'Mali', 'MLI', 'ML'),
(132, 1, 'Malta', 'MLT', 'MT'),
(133, 1, 'Marshall Islands', 'MHL', 'MH'),
(134, 1, 'Martinique', 'MTQ', 'MQ'),
(135, 1, 'Mauritania', 'MRT', 'MR'),
(136, 1, 'Mauritius', 'MUS', 'MU'),
(137, 1, 'Mayotte', 'MYT', 'YT'),
(138, 1, 'Mexico', 'MEX', 'MX'),
(139, 1, 'Micronesia, Federated States of', 'FSM', 'FM'),
(140, 1, 'Moldova, Republic of', 'MDA', 'MD'),
(141, 1, 'Monaco', 'MCO', 'MC'),
(142, 1, 'Mongolia', 'MNG', 'MN'),
(143, 1, 'Montserrat', 'MSR', 'MS'),
(144, 1, 'Morocco', 'MAR', 'MA'),
(145, 1, 'Mozambique', 'MOZ', 'MZ'),
(146, 1, 'Myanmar', 'MMR', 'MM'),
(147, 1, 'Namibia', 'NAM', 'NA'),
(148, 1, 'Nauru', 'NRU', 'NR'),
(149, 1, 'Nepal', 'NPL', 'NP'),
(150, 1, 'Netherlands', 'NLD', 'NL'),
(151, 1, 'Netherlands Antilles', 'ANT', 'AN'),
(152, 1, 'New Caledonia', 'NCL', 'NC'),
(153, 1, 'New Zealand', 'NZL', 'NZ'),
(154, 1, 'Nicaragua', 'NIC', 'NI'),
(155, 1, 'Niger', 'NER', 'NE'),
(156, 1, 'Nigeria', 'NGA', 'NG'),
(157, 1, 'Niue', 'NIU', 'NU'),
(158, 1, 'Norfolk Island', 'NFK', 'NF'),
(159, 1, 'Northern Mariana Islands', 'MNP', 'MP'),
(160, 1, 'Norway', 'NOR', 'NO'),
(161, 1, 'Oman', 'OMN', 'OM'),
(162, 1, 'Pakistan', 'PAK', 'PK'),
(163, 1, 'Palau', 'PLW', 'PW'),
(164, 1, 'Panama', 'PAN', 'PA'),
(165, 1, 'Papua New Guinea', 'PNG', 'PG'),
(166, 1, 'Paraguay', 'PRY', 'PY'),
(167, 1, 'Peru', 'PER', 'PE'),
(168, 1, 'Philippines', 'PHL', 'PH'),
(169, 1, 'Pitcairn', 'PCN', 'PN'),
(170, 1, 'Poland', 'POL', 'PL'),
(171, 1, 'Portugal', 'PRT', 'PT'),
(172, 1, 'Puerto Rico', 'PRI', 'PR'),
(173, 1, 'Qatar', 'QAT', 'QA'),
(174, 1, 'Reunion', 'REU', 'RE'),
(175, 1, 'Romania', 'ROM', 'RO'),
(176, 1, 'Russian Federation', 'RUS', 'RU'),
(177, 1, 'Rwanda', 'RWA', 'RW'),
(178, 1, 'Saint Kitts and Nevis', 'KNA', 'KN'),
(179, 1, 'Saint Lucia', 'LCA', 'LC'),
(180, 1, 'Saint Vincent and the Grenadines', 'VCT', 'VC'),
(181, 1, 'Samoa', 'WSM', 'WS'),
(182, 1, 'San Marino', 'SMR', 'SM'),
(183, 1, 'Sao Tome and Principe', 'STP', 'ST'),
(184, 1, 'Saudi Arabia', 'SAU', 'SA'),
(185, 1, 'Senegal', 'SEN', 'SN'),
(186, 1, 'Seychelles', 'SYC', 'SC'),
(187, 1, 'Sierra Leone', 'SLE', 'SL'),
(188, 1, 'Singapore', 'SGP', 'SG'),
(189, 1, 'Slovakia (Slovak Republic)', 'SVK', 'SK'),
(190, 1, 'Slovenia', 'SVN', 'SI'),
(191, 1, 'Solomon Islands', 'SLB', 'SB'),
(192, 1, 'Somalia', 'SOM', 'SO'),
(193, 1, 'South Africa', 'ZAF', 'ZA'),
(194, 1, 'South Georgia and the South Sandwich Islands', 'SGS', 'GS'),
(195, 1, 'Spain', 'ESP', 'ES'),
(196, 1, 'Sri Lanka', 'LKA', 'LK'),
(197, 1, 'St. Helena', 'SHN', 'SH'),
(198, 1, 'St. Pierre and Miquelon', 'SPM', 'PM'),
(199, 1, 'Sudan', 'SDN', 'SD'),
(200, 1, 'Suriname', 'SUR', 'SR'),
(201, 1, 'Svalbard and Jan Mayen Islands', 'SJM', 'SJ'),
(202, 1, 'Swaziland', 'SWZ', 'SZ'),
(203, 1, 'Sweden', 'SWE', 'SE'),
(204, 1, 'Switzerland', 'CHE', 'CH'),
(205, 1, 'Syrian Arab Republic', 'SYR', 'SY'),
(206, 1, 'Taiwan', 'TWN', 'TW'),
(207, 1, 'Tajikistan', 'TJK', 'TJ'),
(208, 1, 'Tanzania, United Republic of', 'TZA', 'TZ'),
(209, 1, 'Thailand', 'THA', 'TH'),
(210, 1, 'Togo', 'TGO', 'TG'),
(211, 1, 'Tokelau', 'TKL', 'TK'),
(212, 1, 'Tonga', 'TON', 'TO'),
(213, 1, 'Trinidad and Tobago', 'TTO', 'TT'),
(214, 1, 'Tunisia', 'TUN', 'TN'),
(215, 1, 'Turkey', 'TUR', 'TR'),
(216, 1, 'Turkmenistan', 'TKM', 'TM'),
(217, 1, 'Turks and Caicos Islands', 'TCA', 'TC'),
(218, 1, 'Tuvalu', 'TUV', 'TV'),
(219, 1, 'Uganda', 'UGA', 'UG'),
(220, 1, 'Ukraine', 'UKR', 'UA'),
(221, 1, 'United Arab Emirates', 'ARE', 'AE'),
(222, 1, 'United Kingdom', 'GBR', 'GB'),
(223, 1, 'United States', 'USA', 'US'),
(224, 1, 'United States Minor Outlying Islands', 'UMI', 'UM'),
(225, 1, 'Uruguay', 'URY', 'UY'),
(226, 1, 'Uzbekistan', 'UZB', 'UZ'),
(227, 1, 'Vanuatu', 'VUT', 'VU'),
(228, 1, 'Vatican City State (Holy See)', 'VAT', 'VA'),
(229, 1, 'Venezuela', 'VEN', 'VE'),
(230, 1, 'Viet Nam', 'VNM', 'VN'),
(231, 1, 'Virgin Islands (British)', 'VGB', 'VG'),
(232, 1, 'Virgin Islands (U.S.)', 'VIR', 'VI'),
(233, 1, 'Wallis and Futuna Islands', 'WLF', 'WF'),
(234, 1, 'Western Sahara', 'ESH', 'EH'),
(235, 1, 'Yemen', 'YEM', 'YE'),
(236, 1, 'Yugoslavia', 'YUG', 'YU'),
(237, 1, 'The Democratic Republic of Congo', 'DRC', 'DC'),
(238, 1, 'Zambia', 'ZMB', 'ZM'),
(239, 1, 'Zimbabwe', 'ZWE', 'ZW'),
(240, 1, 'East Timor', 'XET', 'XE'),
(241, 1, 'Jersey', 'XJE', 'XJ'),
(242, 1, 'St. Barthelemy', 'XSB', 'XB'),
(243, 1, 'St. Eustatius', 'XSE', 'XU'),
(244, 1, 'Canary Islands', 'XCA', 'XC');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_coupons`
--
CREATE TABLE `jos_vm_coupons` (
`coupon_id` int(16) NOT NULL auto_increment,
`coupon_code` varchar(32) NOT NULL default '',
`percent_or_total` enum('percent','total') NOT NULL default 'percent',
`coupon_type` enum('gift','permanent') NOT NULL default 'gift',
`coupon_value` decimal(12,2) NOT NULL default '0.00',
PRIMARY KEY (`coupon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store coupon codes' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_coupons`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_creditcard`
--
CREATE TABLE `jos_vm_creditcard` (
`creditcard_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`creditcard_name` varchar(70) NOT NULL default '',
`creditcard_code` varchar(30) NOT NULL default '',
PRIMARY KEY (`creditcard_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store credit card types' AUTO_INCREMENT=8 ;
--
-- Dumping data for table `jos_vm_creditcard`
--
INSERT INTO `jos_vm_creditcard` (`creditcard_id`, `vendor_id`, `creditcard_name`, `creditcard_code`) VALUES
(1, 1, 'Visa', 'VISA'),
(2, 1, 'MasterCard', 'MC'),
(3, 1, 'American Express', 'amex'),
(4, 1, 'Discover Card', 'discover'),
(5, 1, 'Diners Club', 'diners'),
(6, 1, 'JCB', 'jcb'),
(7, 1, 'Australian Bankcard', 'australian_bc');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_csv`
--
CREATE TABLE `jos_vm_csv` (
`field_id` int(11) NOT NULL auto_increment,
`field_name` varchar(128) NOT NULL default '',
`field_default_value` text,
`field_ordering` int(3) NOT NULL default '0',
`field_required` char(1) default 'N',
PRIMARY KEY (`field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds all fields which are used on CVS Ex-/Import' AUTO_INCREMENT=26 ;
--
-- Dumping data for table `jos_vm_csv`
--
INSERT INTO `jos_vm_csv` (`field_id`, `field_name`, `field_default_value`, `field_ordering`, `field_required`) VALUES
(1, 'product_sku', '', 1, 'Y'),
(2, 'product_s_desc', '', 5, 'N'),
(3, 'product_desc', '', 6, 'N'),
(4, 'product_thumb_image', '', 7, 'N'),
(5, 'product_full_image', '', 8, 'N'),
(6, 'product_weight', '', 9, 'N'),
(7, 'product_weight_uom', 'KG', 10, 'N'),
(8, 'product_length', '', 11, 'N'),
(9, 'product_width', '', 12, 'N'),
(10, 'product_height', '', 13, 'N'),
(11, 'product_lwh_uom', '', 14, 'N'),
(12, 'product_in_stock', '0', 15, 'N'),
(13, 'product_available_date', '', 16, 'N'),
(14, 'product_discount_id', '', 17, 'N'),
(15, 'product_name', '', 2, 'Y'),
(16, 'product_price', '', 4, 'N'),
(17, 'category_path', '', 3, 'Y'),
(18, 'manufacturer_id', '', 18, 'N'),
(19, 'product_tax_id', '', 19, 'N'),
(20, 'product_sales', '', 20, 'N'),
(21, 'product_parent_id', '0', 21, 'N'),
(22, 'attribute', '', 22, 'N'),
(23, 'custom_attribute', '', 23, 'N'),
(24, 'attributes', '', 24, 'N'),
(25, 'attribute_values', '', 25, 'N');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_currency`
--
CREATE TABLE `jos_vm_currency` (
`currency_id` int(11) NOT NULL auto_increment,
`currency_name` varchar(64) default NULL,
`currency_code` char(3) default NULL,
PRIMARY KEY (`currency_id`),
KEY `idx_currency_name` (`currency_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store currencies' AUTO_INCREMENT=159 ;
--
-- Dumping data for table `jos_vm_currency`
--
INSERT INTO `jos_vm_currency` (`currency_id`, `currency_name`, `currency_code`) VALUES
(1, 'Andorran Peseta', 'ADP'),
(2, 'United Arab Emirates Dirham', 'AED'),
(3, 'Afghanistan Afghani', 'AFA'),
(4, 'Albanian Lek', 'ALL'),
(5, 'Netherlands Antillian Guilder', 'ANG'),
(6, 'Angolan Kwanza', 'AOK'),
(7, 'Argentine Peso', 'ARS'),
(9, 'Australian Dollar', 'AUD'),
(10, 'Aruban Florin', 'AWG'),
(11, 'Barbados Dollar', 'BBD'),
(12, 'Bangladeshi Taka', 'BDT'),
(14, 'Bulgarian Lev', 'BGL'),
(15, 'Bahraini Dinar', 'BHD'),
(16, 'Burundi Franc', 'BIF'),
(17, 'Bermudian Dollar', 'BMD'),
(18, 'Brunei Dollar', 'BND'),
(19, 'Bolivian Boliviano', 'BOB'),
(20, 'Brazilian Real', 'BRL'),
(21, 'Bahamian Dollar', 'BSD'),
(22, 'Bhutan Ngultrum', 'BTN'),
(23, 'Burma Kyat', 'BUK'),
(24, 'Botswanian Pula', 'BWP'),
(25, 'Belize Dollar', 'BZD'),
(26, 'Canadian Dollar', 'CAD'),
(27, 'Swiss Franc', 'CHF'),
(28, 'Chilean Unidades de Fomento', 'CLF'),
(29, 'Chilean Peso', 'CLP'),
(30, 'Yuan (Chinese) Renminbi', 'CNY'),
(31, 'Colombian Peso', 'COP'),
(32, 'Costa Rican Colon', 'CRC'),
(33, 'Czech Koruna', 'CZK'),
(34, 'Cuban Peso', 'CUP'),
(35, 'Cape Verde Escudo', 'CVE'),
(36, 'Cyprus Pound', 'CYP'),
(40, 'Danish Krone', 'DKK'),
(41, 'Dominican Peso', 'DOP'),
(42, 'Algerian Dinar', 'DZD'),
(43, 'Ecuador Sucre', 'ECS'),
(44, 'Egyptian Pound', 'EGP'),
(46, 'Ethiopian Birr', 'ETB'),
(47, 'Euro', 'EUR'),
(49, 'Fiji Dollar', 'FJD'),
(50, 'Falkland Islands Pound', 'FKP'),
(52, 'British Pound', 'GBP'),
(53, 'Ghanaian Cedi', 'GHC'),
(54, 'Gibraltar Pound', 'GIP'),
(55, 'Gambian Dalasi', 'GMD'),
(56, 'Guinea Franc', 'GNF'),
(58, 'Guatemalan Quetzal', 'GTQ'),
(59, 'Guinea-Bissau Peso', 'GWP'),
(60, 'Guyanan Dollar', 'GYD'),
(61, 'Hong Kong Dollar', 'HKD'),
(62, 'Honduran Lempira', 'HNL'),
(63, 'Haitian Gourde', 'HTG'),
(64, 'Hungarian Forint', 'HUF'),
(65, 'Indonesian Rupiah', 'IDR'),
(66, 'Irish Punt', 'IEP'),
(67, 'Israeli Shekel', 'ILS'),
(68, 'Indian Rupee', 'INR'),
(69, 'Iraqi Dinar', 'IQD'),
(70, 'Iranian Rial', 'IRR'),
(73, 'Jamaican Dollar', 'JMD'),
(74, 'Jordanian Dinar', 'JOD'),
(75, 'Japanese Yen', 'JPY'),
(76, 'Kenyan Schilling', 'KES'),
(77, 'Kampuchean (Cambodian) Riel', 'KHR'),
(78, 'Comoros Franc', 'KMF'),
(79, 'North Korean Won', 'KPW'),
(80, '(South) Korean Won', 'KRW'),
(81, 'Kuwaiti Dinar', 'KWD'),
(82, 'Cayman Islands Dollar', 'KYD'),
(83, 'Lao Kip', 'LAK'),
(84, 'Lebanese Pound', 'LBP'),
(85, 'Sri Lanka Rupee', 'LKR'),
(86, 'Liberian Dollar', 'LRD'),
(87, 'Lesotho Loti', 'LSL'),
(89, 'Libyan Dinar', 'LYD'),
(90, 'Moroccan Dirham', 'MAD'),
(91, 'Malagasy Franc', 'MGF'),
(92, 'Mongolian Tugrik', 'MNT'),
(93, 'Macau Pataca', 'MOP'),
(94, 'Mauritanian Ouguiya', 'MRO'),
(95, 'Maltese Lira', 'MTL'),
(96, 'Mauritius Rupee', 'MUR'),
(97, 'Maldive Rufiyaa', 'MVR'),
(98, 'Malawi Kwacha', 'MWK'),
(99, 'Mexican Peso', 'MXP'),
(100, 'Malaysian Ringgit', 'MYR'),
(101, 'Mozambique Metical', 'MZM'),
(102, 'Nigerian Naira', 'NGN'),
(103, 'Nicaraguan Cordoba', 'NIC'),
(105, 'Norwegian Kroner', 'NOK'),
(106, 'Nepalese Rupee', 'NPR'),
(107, 'New Zealand Dollar', 'NZD'),
(108, 'Omani Rial', 'OMR'),
(109, 'Panamanian Balboa', 'PAB'),
(110, 'Peruvian Nuevo Sol', 'PEN'),
(111, 'Papua New Guinea Kina', 'PGK'),
(112, 'Philippine Peso', 'PHP'),
(113, 'Pakistan Rupee', 'PKR'),
(114, 'Polish ZÅ‚oty', 'PLN'),
(116, 'Paraguay Guarani', 'PYG'),
(117, 'Qatari Rial', 'QAR'),
(118, 'Romanian Leu', 'RON'),
(119, 'Rwanda Franc', 'RWF'),
(120, 'Saudi Arabian Riyal', 'SAR'),
(121, 'Solomon Islands Dollar', 'SBD'),
(122, 'Seychelles Rupee', 'SCR'),
(123, 'Sudanese Pound', 'SDP'),
(124, 'Swedish Krona', 'SEK'),
(125, 'Singapore Dollar', 'SGD'),
(126, 'St. Helena Pound', 'SHP'),
(127, 'Sierra Leone Leone', 'SLL'),
(128, 'Somali Schilling', 'SOS'),
(129, 'Suriname Guilder', 'SRG'),
(130, 'Sao Tome and Principe Dobra', 'STD'),
(131, 'Russian Ruble', 'RUB'),
(132, 'El Salvador Colon', 'SVC'),
(133, 'Syrian Potmd', 'SYP'),
(134, 'Swaziland Lilangeni', 'SZL'),
(135, 'Thai Bath', 'THB'),
(136, 'Tunisian Dinar', 'TND'),
(137, 'Tongan Pa''anga', 'TOP'),
(138, 'East Timor Escudo', 'TPE'),
(139, 'Turkish Lira', 'TRL'),
(140, 'Trinidad and Tobago Dollar', 'TTD'),
(141, 'Taiwan Dollar', 'TWD'),
(142, 'Tanzanian Schilling', 'TZS'),
(143, 'Uganda Shilling', 'UGS'),
(144, 'US Dollar', 'USD'),
(145, 'Uruguayan Peso', 'UYP'),
(146, 'Venezualan Bolivar', 'VEB'),
(147, 'Vietnamese Dong', 'VND'),
(148, 'Vanuatu Vatu', 'VUV'),
(149, 'Samoan Tala', 'WST'),
(150, 'Democratic Yemeni Dinar', 'YDD'),
(151, 'Yemeni Rial', 'YER'),
(152, 'New Yugoslavia Dinar', 'YUD'),
(153, 'South African Rand', 'ZAR'),
(154, 'Zambian Kwacha', 'ZMK'),
(155, 'Zaire Zaire', 'ZRZ'),
(156, 'Zimbabwe Dollar', 'ZWD'),
(157, 'Slovak Koruna', 'SKK'),
(158, 'Armenian Dram', 'AMD');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_export`
--
CREATE TABLE `jos_vm_export` (
`export_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) default NULL,
`export_name` varchar(255) default NULL,
`export_desc` text NOT NULL,
`export_class` varchar(50) NOT NULL,
`export_enabled` char(1) NOT NULL default 'N',
`export_config` text NOT NULL,
`iscore` tinyint(3) NOT NULL default '0',
PRIMARY KEY (`export_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Export Modules' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_export`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_function`
--
CREATE TABLE `jos_vm_function` (
`function_id` int(11) NOT NULL auto_increment,
`module_id` int(11) default NULL,
`function_name` varchar(32) default NULL,
`function_class` varchar(32) default NULL,
`function_method` varchar(32) default NULL,
`function_description` text,
`function_perms` varchar(255) default NULL,
PRIMARY KEY (`function_id`),
KEY `idx_function_module_id` (`module_id`),
KEY `idx_function_name` (`function_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to map a function alias to a ''real'' class::function' AUTO_INCREMENT=195 ;
--
-- Dumping data for table `jos_vm_function`
--
INSERT INTO `jos_vm_function` (`function_id`, `module_id`, `function_name`, `function_class`, `function_method`, `function_description`, `function_perms`) VALUES
(1, 1, 'userAdd', 'ps_user', 'add', '', 'admin,storeadmin'),
(2, 1, 'userDelete', 'ps_user', 'delete', '', 'admin,storeadmin'),
(3, 1, 'userUpdate', 'ps_user', 'update', '', 'admin,storeadmin'),
(31, 2, 'productAdd', 'ps_product', 'add', '', 'admin,storeadmin'),
(6, 1, 'functionAdd', 'ps_function', 'add', '', 'admin'),
(7, 1, 'functionUpdate', 'ps_function', 'update', '', 'admin'),
(8, 1, 'functionDelete', 'ps_function', 'delete', '', 'admin'),
(9, 1, 'userLogout', 'ps_user', 'logout', '', 'none'),
(10, 1, 'userAddressAdd', 'ps_user_address', 'add', '', 'admin,storeadmin,shopper,demo'),
(11, 1, 'userAddressUpdate', 'ps_user_address', 'update', '', 'admin,storeadmin,shopper'),
(12, 1, 'userAddressDelete', 'ps_user_address', 'delete', '', 'admin,storeadmin,shopper'),
(13, 1, 'moduleAdd', 'ps_module', 'add', '', 'admin'),
(14, 1, 'moduleUpdate', 'ps_module', 'update', '', 'admin'),
(15, 1, 'moduleDelete', 'ps_module', 'delete', '', 'admin'),
(16, 1, 'userLogin', 'ps_user', 'login', '', 'none'),
(17, 3, 'vendorAdd', 'ps_vendor', 'add', '', 'admin'),
(18, 3, 'vendorUpdate', 'ps_vendor', 'update', '', 'admin,storeadmin'),
(19, 3, 'vendorDelete', 'ps_vendor', 'delete', '', 'admin'),
(20, 3, 'vendorCategoryAdd', 'ps_vendor_category', 'add', '', 'admin'),
(21, 3, 'vendorCategoryUpdate', 'ps_vendor_category', 'update', '', 'admin'),
(22, 3, 'vendorCategoryDelete', 'ps_vendor_category', 'delete', '', 'admin'),
(23, 4, 'shopperAdd', 'ps_shopper', 'add', '', 'none'),
(24, 4, 'shopperDelete', 'ps_shopper', 'delete', '', 'admin,storeadmin'),
(25, 4, 'shopperUpdate', 'ps_shopper', 'update', '', 'admin,storeadmin,shopper'),
(26, 4, 'shopperGroupAdd', 'ps_shopper_group', 'add', '', 'admin,storeadmin'),
(27, 4, 'shopperGroupUpdate', 'ps_shopper_group', 'update', '', 'admin,storeadmin'),
(28, 4, 'shopperGroupDelete', 'ps_shopper_group', 'delete', '', 'admin,storeadmin'),
(30, 5, 'orderStatusSet', 'ps_order', 'order_status_update', '', 'admin,storeadmin'),
(32, 2, 'productDelete', 'ps_product', 'delete', '', 'admin,storeadmin'),
(33, 2, 'productUpdate', 'ps_product', 'update', '', 'admin,storeadmin'),
(34, 2, 'productCategoryAdd', 'ps_product_category', 'add', '', 'admin,storeadmin'),
(35, 2, 'productCategoryUpdate', 'ps_product_category', 'update', '', 'admin,storeadmin'),
(36, 2, 'productCategoryDelete', 'ps_product_category', 'delete', '', 'admin,storeadmin'),
(37, 2, 'productPriceAdd', 'ps_product_price', 'add', '', 'admin,storeadmin'),
(38, 2, 'productPriceUpdate', 'ps_product_price', 'update', '', 'admin,storeadmin'),
(39, 2, 'productPriceDelete', 'ps_product_price', 'delete', '', 'admin,storeadmin'),
(40, 2, 'productAttributeAdd', 'ps_product_attribute', 'add', '', 'admin,storeadmin'),
(41, 2, 'productAttributeUpdate', 'ps_product_attribute', 'update', '', 'admin,storeadmin'),
(42, 2, 'productAttributeDelete', 'ps_product_attribute', 'delete', '', 'admin,storeadmin'),
(43, 7, 'cartAdd', 'ps_cart', 'add', '', 'none'),
(44, 7, 'cartUpdate', 'ps_cart', 'update', '', 'none'),
(45, 7, 'cartDelete', 'ps_cart', 'delete', '', 'none'),
(46, 10, 'checkoutComplete', 'ps_checkout', 'add', '', 'shopper,storeadmin,admin'),
(48, 8, 'paymentMethodUpdate', 'ps_payment_method', 'update', '', 'admin,storeadmin'),
(49, 8, 'paymentMethodAdd', 'ps_payment_method', 'add', '', 'admin,storeadmin'),
(50, 8, 'paymentMethodDelete', 'ps_payment_method', 'delete', '', 'admin,storeadmin'),
(51, 5, 'orderDelete', 'ps_order', 'delete', '', 'admin,storeadmin'),
(52, 11, 'addTaxRate', 'ps_tax', 'add', '', 'admin,storeadmin'),
(53, 11, 'updateTaxRate', 'ps_tax', 'update', '', 'admin,storeadmin'),
(54, 11, 'deleteTaxRate', 'ps_tax', 'delete', '', 'admin,storeadmin'),
(55, 10, 'checkoutValidateST', 'ps_checkout', 'validate_shipto', '', 'none'),
(59, 5, 'orderStatusUpdate', 'ps_order_status', 'update', '', 'admin,storeadmin'),
(60, 5, 'orderStatusAdd', 'ps_order_status', 'add', '', 'storeadmin,admin'),
(61, 5, 'orderStatusDelete', 'ps_order_status', 'delete', '', 'admin,storeadmin'),
(62, 1, 'currencyAdd', 'ps_currency', 'add', 'add a currency', 'storeadmin,admin'),
(63, 1, 'currencyUpdate', 'ps_currency', 'update', ' update a currency', 'storeadmin,admin'),
(64, 1, 'currencyDelete', 'ps_currency', 'delete', 'delete a currency', 'storeadmin,admin'),
(65, 1, 'countryAdd', 'ps_country', 'add', 'Add a country ', 'storeadmin,admin'),
(66, 1, 'countryUpdate', 'ps_country', 'update', 'Update a country record', 'storeadmin,admin'),
(67, 1, 'countryDelete', 'ps_country', 'delete', 'Delete a country record', 'storeadmin,admin'),
(68, 2, 'product_csv', 'ps_csv', 'upload_csv', '', 'admin'),
(110, 7, 'waitingListAdd', 'zw_waiting_list', 'add', '', 'none'),
(111, 13, 'addzone', 'ps_zone', 'add', 'This will add a zone', 'admin,storeadmin'),
(112, 13, 'updatezone', 'ps_zone', 'update', 'This will update a zone', 'admin,storeadmin'),
(113, 13, 'deletezone', 'ps_zone', 'delete', 'This will delete a zone', 'admin,storeadmin'),
(114, 13, 'zoneassign', 'ps_zone', 'assign', 'This will assign a country to a zone', 'admin,storeadmin'),
(115, 1, 'writeConfig', 'ps_config', 'writeconfig', 'This will write the configuration details to phpshop.cfg.php', 'admin'),
(116, 12839, 'carrierAdd', 'ps_shipping', 'add', '', 'admin,storeadmin'),
(117, 12839, 'carrierDelete', 'ps_shipping', 'delete', '', 'admin,storeadmin'),
(118, 12839, 'carrierUpdate', 'ps_shipping', 'update', '', 'admin,storeadmin'),
(119, 12839, 'rateAdd', 'ps_shipping', 'rate_add', '', 'admin,storeadmin'),
(120, 12839, 'rateUpdate', 'ps_shipping', 'rate_update', '', 'admin,shopadmin'),
(121, 12839, 'rateDelete', 'ps_shipping', 'rate_delete', '', 'admin,storeadmin'),
(122, 10, 'checkoutProcess', 'ps_checkout', 'process', '', 'none'),
(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', 'none'),
(124, 98, 'affiliateAdd', 'ps_affiliate', 'add', '', 'admin,storeadmin'),
(125, 98, 'affiliateUpdate', 'ps_affiliate', 'update', '', 'admin,storeadmin'),
(126, 98, 'affiliateDelete', 'ps_affiliate', 'delete', '', 'admin,storeadmin'),
(127, 98, 'affiliateEmail', 'ps_affiliate', 'email', '', 'admin,storeadmin'),
(128, 99, 'manufacturerAdd', 'ps_manufacturer', 'add', '', 'admin,storeadmin'),
(129, 99, 'manufacturerUpdate', 'ps_manufacturer', 'update', '', 'admin,storeadmin'),
(130, 99, 'manufacturerDelete', 'ps_manufacturer', 'delete', '', 'admin,storeadmin'),
(131, 99, 'manufacturercategoryAdd', 'ps_manufacturer_category', 'add', '', 'admin,storeadmin'),
(132, 99, 'manufacturercategoryUpdate', 'ps_manufacturer_category', 'update', '', 'admin,storeadmin'),
(133, 99, 'manufacturercategoryDelete', 'ps_manufacturer_category', 'delete', '', 'admin,storeadmin'),
(134, 7, 'addReview', 'ps_reviews', 'process_review', 'This lets the user add a review and rating to a product.', 'admin,storeadmin,shopper,demo'),
(135, 7, 'productReviewDelete', 'ps_reviews', 'delete_review', 'This deletes a review and from a product.', 'admin,storeadmin'),
(136, 8, 'creditcardAdd', 'ps_creditcard', 'add', 'Adds a Credit Card entry.', 'admin,storeadmin'),
(137, 8, 'creditcardUpdate', 'ps_creditcard', 'update', 'Updates a Credit Card entry.', 'admin,storeadmin'),
(138, 8, 'creditcardDelete', 'ps_creditcard', 'delete', 'Deletes a Credit Card entry.', 'admin,storeadmin'),
(139, 2, 'changePublishState', 'vmAbstractObject.class', 'handlePublishState', 'Changes the publish field of an item, so that it can be published or unpublished easily.', 'admin,storeadmin'),
(140, 2, 'export_csv', 'ps_csv', 'export_csv', 'This function exports all relevant product data to CSV.', 'admin,storeadmin'),
(141, 2, 'reorder', 'ps_product_category', 'reorder', 'Changes the list order of a category.', 'admin,storeadmin'),
(142, 2, 'discountAdd', 'ps_product_discount', 'add', 'Adds a discount.', 'admin,storeadmin'),
(143, 2, 'discountUpdate', 'ps_product_discount', 'update', 'Updates a discount.', 'admin,storeadmin'),
(144, 2, 'discountDelete', 'ps_product_discount', 'delete', 'Deletes a discount.', 'admin,storeadmin'),
(145, 8, 'shippingmethodSave', 'ps_shipping_method', 'save', '', 'admin,storeadmin'),
(146, 2, 'uploadProductFile', 'ps_product_files', 'add', 'Uploads and Adds a Product Image/File.', 'admin,storeadmin'),
(147, 2, 'updateProductFile', 'ps_product_files', 'update', 'Updates a Product Image/File.', 'admin,storeadmin'),
(148, 2, 'deleteProductFile', 'ps_product_files', 'delete', 'Deletes a Product Image/File.', 'admin,storeadmin'),
(149, 12843, 'couponAdd', 'ps_coupon', 'add_coupon_code', 'Adds a Coupon.', 'admin,storeadmin'),
(150, 12843, 'couponUpdate', 'ps_coupon', 'update_coupon', 'Updates a Coupon.', 'admin,storeadmin'),
(151, 12843, 'couponDelete', 'ps_coupon', 'remove_coupon_code', 'Deletes a Coupon.', 'admin,storeadmin'),
(152, 12843, 'couponProcess', 'ps_coupon', 'process_coupon_code', 'Processes a Coupon.', 'admin,storeadmin,shopper,demo'),
(153, 2, 'ProductTypeAdd', 'ps_product_type', 'add', 'Function add a Product Type and create new table product_type_.', 'admin'),
(154, 2, 'ProductTypeUpdate', 'ps_product_type', 'update', 'Update a Product Type.', 'admin'),
(155, 2, 'ProductTypeDelete', 'ps_product_type', 'delete', 'Delete a Product Type and drop table product_type_.', 'admin'),
(156, 2, 'ProductTypeReorder', 'ps_product_type', 'reorder', 'Changes the list order of a Product Type.', 'admin'),
(157, 2, 'ProductTypeAddParam', 'ps_product_type_parameter', 'add_parameter', 'Function add a Parameter into a Product Type and create new column in table product_type_.', 'admin'),
(158, 2, 'ProductTypeUpdateParam', 'ps_product_type_parameter', 'update_parameter', 'Function update a Parameter in a Product Type and a column in table product_type_.', 'admin'),
(159, 2, 'ProductTypeDeleteParam', 'ps_product_type_parameter', 'delete_parameter', 'Function delete a Parameter from a Product Type and drop a column in table product_type_.', 'admin'),
(160, 2, 'ProductTypeReorderParam', 'ps_product_type_parameter', 'reorder_parameter', 'Changes the list order of a Parameter.', 'admin'),
(161, 2, 'productProductTypeAdd', 'ps_product_product_type', 'add', 'Add a Product into a Product Type.', 'admin,storeadmin'),
(162, 2, 'productProductTypeDelete', 'ps_product_product_type', 'delete', 'Delete a Product from a Product Type.', 'admin,storeadmin'),
(163, 1, 'stateAdd', 'ps_country', 'addState', 'Add a State ', 'storeadmin,admin'),
(164, 1, 'stateUpdate', 'ps_country', 'updateState', 'Update a state record', 'storeadmin,admin'),
(165, 1, 'stateDelete', 'ps_country', 'deleteState', 'Delete a state record', 'storeadmin,admin'),
(166, 2, 'csvFieldAdd', 'ps_csv', 'add', 'Add a CSV Field ', 'storeadmin,admin'),
(167, 2, 'csvFieldUpdate', 'ps_csv', 'update', 'Update a CSV Field', 'storeadmin,admin'),
(168, 2, 'csvFieldDelete', 'ps_csv', 'delete', 'Delete a CSV Field', 'storeadmin,admin'),
(169, 1, 'userfieldSave', 'ps_userfield', 'savefield', 'add or edit a user field', 'admin'),
(170, 1, 'userfieldDelete', 'ps_userfield', 'deletefield', '', 'admin'),
(171, 1, 'changeordering', 'vmAbstractObject.class', 'handleordering', '', 'admin'),
(172, 2, 'moveProduct', 'ps_product', 'move', 'Move products from one category to another.', 'admin,storeadmin'),
(173, 7, 'productAsk', 'ps_communication', 'mail_question', 'Lets the customer send a question about a specific product.', 'none'),
(174, 7, 'recommendProduct', 'ps_communication', 'sendRecommendation', 'Lets the customer send a recommendation about a specific product to a friend.', 'none'),
(175, 2, 'reviewUpdate', 'ps_reviews', 'update', 'Modify a review about a specific product.', 'admin'),
(176, 8, 'ExportUpdate', 'ps_export', 'update', '', 'admin,storeadmin'),
(177, 8, 'ExportAdd', 'ps_export', 'add', '', 'admin,storeadmin'),
(178, 8, 'ExportDelete', 'ps_export', 'delete', '', 'admin,storeadmin'),
(179, 1, 'writeThemeConfig', 'ps_config', 'writeThemeConfig', 'Writes a theme configuration file.', 'admin'),
(180, 1, 'usergroupAdd', 'usergroup.class', 'add', 'Add a new user group', 'admin'),
(181, 1, 'usergroupUpdate', 'usergroup.class', 'update', 'Update an user group', 'admin'),
(182, 1, 'usergroupDelete', 'usergroup.class', 'delete', 'Delete an user group', 'admin'),
(183, 1, 'setModulePermissions', 'ps_module', 'update_permissions', '', 'admin'),
(184, 1, 'setFunctionPermissions', 'ps_function', 'update_permissions', '', 'admin'),
(185, 2, 'insertDownloadsForProduct', 'ps_order', 'insert_downloads_for_product', '', 'admin'),
(186, 5, 'mailDownloadId', 'ps_order', 'mail_download_id', '', 'storeadmin,admin'),
(187, 7, 'replaceSavedCart', 'ps_cart', 'replaceCart', 'Replace cart with saved cart', 'none'),
(188, 7, 'mergeSavedCart', 'ps_cart', 'mergeSaved', 'Merge saved cart with cart', 'none'),
(189, 7, 'deleteSavedCart', 'ps_cart', 'deleteCart', 'Delete saved cart', 'none'),
(190, 7, 'savedCartDelete', 'ps_cart', 'deleteSaved', 'Delete items from saved cart', 'none'),
(191, 7, 'savedCartUpdate', 'ps_cart', 'updateSaved', 'Update saved cart items', 'none'),
(192, 1, 'getupdatepackage', 'update.class', 'getPatchPackage', 'Retrieves the Patch Package from the virtuemart.net Servers.', 'admin'),
(193, 1, 'applypatchpackage', 'update.class', 'applyPatch', 'Applies the Patch using the instructions from the update.xml file in the downloaded patch.', 'admin'),
(194, 1, 'removePatchPackage', 'update.class', 'removePackageFile', 'Removes a Patch Package File and its extracted contents.', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_manufacturer`
--
CREATE TABLE `jos_vm_manufacturer` (
`manufacturer_id` int(11) NOT NULL auto_increment,
`mf_name` varchar(64) default NULL,
`mf_email` varchar(255) default NULL,
`mf_desc` text,
`mf_category_id` int(11) default NULL,
`mf_url` varchar(255) NOT NULL default '',
PRIMARY KEY (`manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Manufacturers are those who create products' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_vm_manufacturer`
--
INSERT INTO `jos_vm_manufacturer` (`manufacturer_id`, `mf_name`, `mf_email`, `mf_desc`, `mf_category_id`, `mf_url`) VALUES
(1, 'Manufacturer', 'info@manufacturer.com', 'An example for a manufacturer', 1, 'http://www.a-url.com');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_manufacturer_category`
--
CREATE TABLE `jos_vm_manufacturer_category` (
`mf_category_id` int(11) NOT NULL auto_increment,
`mf_category_name` varchar(64) default NULL,
`mf_category_desc` text,
PRIMARY KEY (`mf_category_id`),
KEY `idx_manufacturer_category_category_name` (`mf_category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Manufactorers are assigned to these categories' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_vm_manufacturer_category`
--
INSERT INTO `jos_vm_manufacturer_category` (`mf_category_id`, `mf_category_name`, `mf_category_desc`) VALUES
(1, '-default-', 'This is the default manufacturer category');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_module`
--
CREATE TABLE `jos_vm_module` (
`module_id` int(11) NOT NULL auto_increment,
`module_name` varchar(255) default NULL,
`module_description` text,
`module_perms` varchar(255) default NULL,
`module_publish` char(1) default NULL,
`list_order` int(11) default NULL,
PRIMARY KEY (`module_id`),
KEY `idx_module_name` (`module_name`),
KEY `idx_module_list_order` (`list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='VirtueMart Core Modules, not: Joomla modules' AUTO_INCREMENT=12844 ;
--
-- Dumping data for table `jos_vm_module`
--
INSERT INTO `jos_vm_module` (`module_id`, `module_name`, `module_description`, `module_perms`, `module_publish`, `list_order`) VALUES
(1, 'admin', 'ADMINISTRATIVE USERS ONLY \r\n\r\nOnly used for the following:
\r\n\r\n\r\nUser Maintenance \r\nModule Maintenance \r\nFunction Maintenance \r\n \r\n', 'admin', 'Y', 1),
(2, 'product', 'Here you can adminster your online catalog of products. The Product Administrator allows you to create product categories, create new products, edit product attributes, and add product items for each attribute value.
', 'storeadmin,admin', 'Y', 4),
(3, 'vendor', 'ADMINISTRATIVE USERS ONLY \r\nHere you can manage the vendors on the phpShop system.
', 'admin', 'Y', 6),
(4, 'shopper', 'Manage shoppers in your store. Allows you to create shopper groups. Shopper groups can be used when setting the price for a product. This allows you to create different prices for different types of users. An example of this would be to have a ''wholesale'' group and a ''retail'' group.
', 'admin,storeadmin', 'Y', 4),
(5, 'order', 'View Order and Update Order Status.
', 'admin,storeadmin', 'Y', 5),
(6, 'msgs', 'This module is unprotected an used for displaying system messages to users. We need to have an area that does not require authorization when things go wrong.', 'none', 'N', 99),
(7, 'shop', 'This is the Washupito store module. This is the demo store included with the phpShop distribution.', 'none', 'Y', 99),
(8, 'store', '', 'storeadmin,admin', 'Y', 2),
(9, 'account', 'This module allows shoppers to update their account information and view previously placed orders.', 'shopper,storeadmin,admin,demo', 'N', 99),
(10, 'checkout', '', 'none', 'N', 99),
(11, 'tax', 'The tax module allows you to set tax rates for states or regions within a country. The rate is set as a decimal figure. For example, 2 percent tax would be 0.02.', 'admin,storeadmin', 'Y', 8),
(12, 'reportbasic', 'The report basic module allows you to do queries on all orders.', 'admin,storeadmin', 'Y', 7),
(13, 'zone', 'This is the zone-shipping module. Here you can manage your shipping costs according to Zones.', 'admin,storeadmin', 'N', 9),
(12839, 'shipping', 'Shipping Let this module calculate the shipping fees for your customers.
', 'admin,storeadmin', 'Y', 10),
(98, 'affiliate', 'administrate the affiliates on your store.', 'storeadmin,admin', 'N', 99),
(99, 'manufacturer', 'Manage the manufacturers of products in your store.', 'storeadmin,admin', 'Y', 12),
(12842, 'help', 'Help Module', 'admin,storeadmin', 'Y', 13),
(12843, 'coupon', 'Coupon Management', 'admin,storeadmin', 'Y', 11);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_orders`
--
CREATE TABLE `jos_vm_orders` (
`order_id` int(11) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`vendor_id` int(11) NOT NULL default '0',
`order_number` varchar(32) default NULL,
`user_info_id` varchar(32) default NULL,
`order_total` decimal(15,5) NOT NULL default '0.00000',
`order_subtotal` decimal(15,5) default NULL,
`order_tax` decimal(10,2) default NULL,
`order_tax_details` text NOT NULL,
`order_shipping` decimal(10,2) default NULL,
`order_shipping_tax` decimal(10,2) default NULL,
`coupon_discount` decimal(12,2) NOT NULL default '0.00',
`coupon_code` varchar(32) default NULL,
`order_discount` decimal(12,2) NOT NULL default '0.00',
`order_currency` varchar(16) default NULL,
`order_status` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`ship_method_id` varchar(255) default NULL,
`customer_note` text NOT NULL,
`ip_address` varchar(15) NOT NULL default '',
PRIMARY KEY (`order_id`),
KEY `idx_orders_user_id` (`user_id`),
KEY `idx_orders_vendor_id` (`vendor_id`),
KEY `idx_orders_order_number` (`order_number`),
KEY `idx_orders_user_info_id` (`user_info_id`),
KEY `idx_orders_ship_method_id` (`ship_method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Used to store all orders' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jos_vm_orders`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_history`
--
CREATE TABLE `jos_vm_order_history` (
`order_status_history_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`order_status_code` char(1) NOT NULL default '0',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
`customer_notified` int(1) default '0',
`comments` text,
PRIMARY KEY (`order_status_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all actions and changes that occur to an order' AUTO_INCREMENT=8 ;
--
-- Dumping data for table `jos_vm_order_history`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_item`
--
CREATE TABLE `jos_vm_order_item` (
`order_item_id` int(11) NOT NULL auto_increment,
`order_id` int(11) default NULL,
`user_info_id` varchar(32) default NULL,
`vendor_id` int(11) default NULL,
`product_id` int(11) default NULL,
`order_item_sku` varchar(64) NOT NULL default '',
`order_item_name` varchar(64) NOT NULL default '',
`product_quantity` int(11) default NULL,
`product_item_price` decimal(15,5) default NULL,
`product_final_price` decimal(12,2) NOT NULL default '0.00',
`order_item_currency` varchar(16) default NULL,
`order_status` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`product_attribute` text,
PRIMARY KEY (`order_item_id`),
KEY `idx_order_item_order_id` (`order_id`),
KEY `idx_order_item_user_info_id` (`user_info_id`),
KEY `idx_order_item_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all items (products) which are part of an order' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jos_vm_order_item`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_payment`
--
CREATE TABLE `jos_vm_order_payment` (
`order_id` int(11) NOT NULL default '0',
`payment_method_id` int(11) default NULL,
`order_payment_code` varchar(30) NOT NULL default '',
`order_payment_number` blob,
`order_payment_expire` int(11) default NULL,
`order_payment_name` varchar(255) default NULL,
`order_payment_log` text,
`order_payment_trans_id` text NOT NULL,
KEY `idx_order_payment_order_id` (`order_id`),
KEY `idx_order_payment_method_id` (`payment_method_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The payment method that was chosen for a specific order';
--
-- Dumping data for table `jos_vm_order_payment`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_status`
--
CREATE TABLE `jos_vm_order_status` (
`order_status_id` int(11) NOT NULL auto_increment,
`order_status_code` char(1) NOT NULL default '',
`order_status_name` varchar(64) default NULL,
`order_status_description` text NOT NULL,
`list_order` int(11) default NULL,
`vendor_id` int(11) default NULL,
PRIMARY KEY (`order_status_id`),
KEY `idx_order_status_list_order` (`list_order`),
KEY `idx_order_status_vendor_id` (`vendor_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='All available order statuses' AUTO_INCREMENT=6 ;
--
-- Dumping data for table `jos_vm_order_status`
--
INSERT INTO `jos_vm_order_status` (`order_status_id`, `order_status_code`, `order_status_name`, `order_status_description`, `list_order`, `vendor_id`) VALUES
(1, 'P', 'Pending', '', 1, 1),
(2, 'C', 'Confirmed', '', 2, 1),
(3, 'X', 'Cancelled', '', 3, 1),
(4, 'R', 'Refunded', '', 4, 1),
(5, 'S', 'Shipped', '', 5, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_order_user_info`
--
CREATE TABLE `jos_vm_order_user_info` (
`order_info_id` int(11) NOT NULL auto_increment,
`order_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`address_type` char(2) default NULL,
`address_type_name` varchar(32) default NULL,
`company` varchar(64) default NULL,
`title` varchar(32) default NULL,
`last_name` varchar(32) default NULL,
`first_name` varchar(32) default NULL,
`middle_name` varchar(32) default NULL,
`phone_1` varchar(32) default NULL,
`phone_2` varchar(32) default NULL,
`fax` varchar(32) default NULL,
`address_1` varchar(64) NOT NULL default '',
`address_2` varchar(64) default NULL,
`city` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default 'US',
`zip` varchar(32) NOT NULL default '',
`user_email` varchar(255) default NULL,
`extra_field_1` varchar(255) default NULL,
`extra_field_2` varchar(255) default NULL,
`extra_field_3` varchar(255) default NULL,
`extra_field_4` char(1) default NULL,
`extra_field_5` char(1) default NULL,
`bank_account_nr` varchar(32) NOT NULL default '',
`bank_name` varchar(32) NOT NULL default '',
`bank_sort_code` varchar(16) NOT NULL default '',
`bank_iban` varchar(64) NOT NULL default '',
`bank_account_holder` varchar(48) NOT NULL default '',
`bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL default 'Checking',
PRIMARY KEY (`order_info_id`),
KEY `idx_order_info_order_id` (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores the BillTo and ShipTo Information at order time' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jos_vm_order_user_info`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_payment_method`
--
CREATE TABLE `jos_vm_payment_method` (
`payment_method_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) default NULL,
`payment_method_name` varchar(255) default NULL,
`payment_class` varchar(50) NOT NULL default '',
`shopper_group_id` int(11) default NULL,
`payment_method_discount` decimal(12,2) default NULL,
`payment_method_discount_is_percent` tinyint(1) NOT NULL,
`payment_method_discount_max_amount` decimal(10,2) NOT NULL,
`payment_method_discount_min_amount` decimal(10,2) NOT NULL,
`list_order` int(11) default NULL,
`payment_method_code` varchar(8) default NULL,
`enable_processor` char(1) default NULL,
`is_creditcard` tinyint(1) NOT NULL default '0',
`payment_enabled` char(1) NOT NULL default 'N',
`accepted_creditcards` varchar(128) NOT NULL default '',
`payment_extrainfo` text NOT NULL,
`payment_passkey` blob NOT NULL,
PRIMARY KEY (`payment_method_id`),
KEY `idx_payment_method_vendor_id` (`vendor_id`),
KEY `idx_payment_method_name` (`payment_method_name`),
KEY `idx_payment_method_list_order` (`list_order`),
KEY `idx_payment_method_shopper_group_id` (`shopper_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The payment methods of your store' AUTO_INCREMENT=17 ;
--
-- Dumping data for table `jos_vm_payment_method`
--
INSERT INTO `jos_vm_payment_method` (`payment_method_id`, `vendor_id`, `payment_method_name`, `payment_class`, `shopper_group_id`, `payment_method_discount`, `payment_method_discount_is_percent`, `payment_method_discount_max_amount`, `payment_method_discount_min_amount`, `list_order`, `payment_method_code`, `enable_processor`, `is_creditcard`, `payment_enabled`, `accepted_creditcards`, `payment_extrainfo`, `payment_passkey`) VALUES
(1, 1, 'Purchase Order', '', 6, '0.00', 0, '0.00', '0.00', 4, 'PO', 'N', 0, 'Y', '', '', ''),
(2, 1, 'Cash On Delivery', '', 5, '-2.00', 0, '0.00', '0.00', 5, 'COD', 'N', 0, 'Y', '', '', ''),
(3, 1, 'Credit Card', 'ps_authorize', 5, '0.00', 0, '0.00', '0.00', 0, 'AN', 'Y', 0, 'Y', '1,2,6,7,', '', ''),
(4, 1, 'PayPal', 'ps_paypal', 5, '0.00', 0, '0.00', '0.00', 0, 'PP', 'P', 0, 'Y', '', 'country."'' ORDER BY country_2_code ASC";\r\n$db1->query($q);\r\n\r\n$url = "https://www.paypal.com/cgi-bin/webscr";\r\n$tax_total = $db->f("order_tax") + $db->f("order_shipping_tax");\r\n$discount_total = $db->f("coupon_discount") + $db->f("order_discount");\r\n$post_variables = Array(\r\n"cmd" => "_ext-enter",\r\n"redirect_cmd" => "_xclick",\r\n"upload" => "1",\r\n"business" => PAYPAL_EMAIL,\r\n"receiver_email" => PAYPAL_EMAIL,\r\n"item_name" => $VM_LANG->_(''PHPSHOP_ORDER_PRINT_PO_NUMBER'').": ". $db->f("order_id"),\r\n"order_id" => $db->f("order_id"),\r\n"invoice" => $db->f("order_number"),\r\n"amount" => round( $db->f("order_subtotal")+$tax_total-$discount_total, 2),\r\n"shipping" => sprintf("%.2f", $db->f("order_shipping")),\r\n"currency_code" => $_SESSION[''vendor_currency''],\r\n\r\n"address_override" => "1",\r\n"first_name" => $dbbt->f(''first_name''),\r\n"last_name" => $dbbt->f(''last_name''),\r\n"address1" => $dbbt->f(''address_1''),\r\n"address2" => $dbbt->f(''address_2''),\r\n"zip" => $dbbt->f(''zip''),\r\n"city" => $dbbt->f(''city''),\r\n"state" => $dbbt->f(''state''),\r\n"country" => $db1->f(''country_2_code''),\r\n"email" => $dbbt->f(''user_email''),\r\n"night_phone_b" => $dbbt->f(''phone_1''),\r\n"cpp_header_image" => $vendor_image_url,\r\n\r\n"return" => SECUREURL ."index.php?option=com_virtuemart&page=checkout.result&order_id=".$db->f("order_id"),\r\n"notify_url" => SECUREURL ."administrator/components/com_virtuemart/notify.php",\r\n"cancel_return" => SECUREURL ."index.php",\r\n"undefined_quantity" => "0",\r\n\r\n"test_ipn" => PAYPAL_DEBUG,\r\n"pal" => "NRUBJXESJTY24",\r\n"no_shipping" => "1",\r\n"no_note" => "1"\r\n);\r\nif( $page == "checkout.thankyou" ) {\r\n$query_string = "?";\r\nforeach( $post_variables as $name => $value ) {\r\n$query_string .= $name. "=" . urlencode($value) ."&";\r\n}\r\nvmRedirect( $url . $query_string );\r\n} else {\r\necho '''';\r\n\r\n}\r\n?>', ''),
(5, 1, 'PayMate', 'ps_paymate', 5, '0.00', 0, '0.00', '0.00', 0, 'PM', 'P', 0, 'N', '', '\n ', ''),
(6, 1, 'WorldPay', 'ps_worldpay', 5, '0.00', 0, '0.00', '0.00', 0, 'WP', 'P', 0, 'N', '', '', ''),
(7, 1, '2Checkout', 'ps_twocheckout', 5, '0.00', 0, '0.00', '0.00', 0, '2CO', 'P', 0, 'N', '', 'f("user_info_id")."''"; \n $dbbt = new ps_DB;\n $dbbt->setQuery($q);\n $dbbt->query();\n $dbbt->next_record(); \n // Get ship_to information\n if( $db->f("user_info_id") != $dbbt->f("user_info_id")) {\n $q2 = "SELECT * FROM #__vm_user_info WHERE user_info_id=''".$db->f("user_info_id")."''"; \n $dbst = new ps_DB;\n $dbst->setQuery($q2);\n $dbst->query();\n $dbst->next_record();\n }\n else {\n $dbst = $dbbt;\n }\n \n //Authnet vars to send\n $formdata = array (\n ''x_login'' => TWOCO_LOGIN,\n ''x_email_merchant'' => ((TWOCO_MERCHANT_EMAIL == ''True'') ? ''TRUE'' : ''FALSE''),\n \n // Customer Name and Billing Address\n ''x_first_name'' => $dbbt->f("first_name"),\n ''x_last_name'' => $dbbt->f("last_name"),\n ''x_company'' => $dbbt->f("company"),\n ''x_address'' => $dbbt->f("address_1"),\n ''x_city'' => $dbbt->f("city"),\n ''x_state'' => $dbbt->f("state"),\n ''x_zip'' => $dbbt->f("zip"),\n ''x_country'' => $dbbt->f("country"),\n ''x_phone'' => $dbbt->f("phone_1"),\n ''x_fax'' => $dbbt->f("fax"),\n ''x_email'' => $dbbt->f("email"),\n \n // Customer Shipping Address\n ''x_ship_to_first_name'' => $dbst->f("first_name"),\n ''x_ship_to_last_name'' => $dbst->f("last_name"),\n ''x_ship_to_company'' => $dbst->f("company"),\n ''x_ship_to_address'' => $dbst->f("address_1"),\n ''x_ship_to_city'' => $dbst->f("city"),\n ''x_ship_to_state'' => $dbst->f("state"),\n ''x_ship_to_zip'' => $dbst->f("zip"),\n ''x_ship_to_country'' => $dbst->f("country"),\n \n ''x_invoice_num'' => $db->f("order_number"),\n ''x_receipt_link_url'' => SECUREURL."2checkout_notify.php"\n );\n \n if( TWOCO_TESTMODE == "Y" )\n $formdata[''demo''] = "Y";\n \n $version = "2";\n $url = "https://www2.2checkout.com/2co/buyer/purchase";\n $formdata[''x_amount''] = number_format($db->f("order_total"), 2, ''.'', '''');\n \n //build the post string\n $poststring = '''';\n foreach($formdata AS $key => $val){\n $poststring .= "You haven\\''t configured any terms of service yet. Click here to change this text. ', 'http://www.shape5.com/demo/aluma_photography', '0.00', '0.00', '1|$|2|.| |2|1', 'USD', '{storename}\r\n{address_1}\r\n{address_2}\r\n{city}, {zip}', '%A, %d %B %Y %H:%M');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_vendor_category`
--
CREATE TABLE `jos_vm_vendor_category` (
`vendor_category_id` int(11) NOT NULL auto_increment,
`vendor_category_name` varchar(64) default NULL,
`vendor_category_desc` text,
PRIMARY KEY (`vendor_category_id`),
KEY `idx_vendor_category_category_name` (`vendor_category_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The categories that vendors are assigned to' AUTO_INCREMENT=7 ;
--
-- Dumping data for table `jos_vm_vendor_category`
--
INSERT INTO `jos_vm_vendor_category` (`vendor_category_id`, `vendor_category_name`, `vendor_category_desc`) VALUES
(6, '-default-', 'Default');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_visit`
--
CREATE TABLE `jos_vm_visit` (
`visit_id` varchar(255) NOT NULL default '',
`affiliate_id` int(11) NOT NULL default '0',
`pages` int(11) NOT NULL default '0',
`entry_page` varchar(255) NOT NULL default '',
`exit_page` varchar(255) NOT NULL default '',
`sdate` int(11) NOT NULL default '0',
`edate` int(11) NOT NULL default '0',
PRIMARY KEY (`visit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Records the visit of an affiliate';
--
-- Dumping data for table `jos_vm_visit`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_waiting_list`
--
CREATE TABLE `jos_vm_waiting_list` (
`waiting_list_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`notify_email` varchar(150) NOT NULL default '',
`notified` enum('0','1') default '0',
`notify_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`waiting_list_id`),
KEY `product_id` (`product_id`),
KEY `notify_email` (`notify_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores notifications, users waiting f. products out of stock' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_waiting_list`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_zone_shipping`
--
CREATE TABLE `jos_vm_zone_shipping` (
`zone_id` int(11) NOT NULL auto_increment,
`zone_name` varchar(255) default NULL,
`zone_cost` decimal(10,2) default NULL,
`zone_limit` decimal(10,2) default NULL,
`zone_description` text NOT NULL,
`zone_tax_rate` int(11) NOT NULL default '0',
PRIMARY KEY (`zone_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The Zones managed by the Zone Shipping Module' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `jos_vm_zone_shipping`
--
INSERT INTO `jos_vm_zone_shipping` (`zone_id`, `zone_name`, `zone_cost`, `zone_limit`, `zone_description`, `zone_tax_rate`) VALUES
(1, 'Default', '6.00', '35.00', 'This is the default Shipping Zone. This is the zone information that all countries will use until you assign each individual country to a Zone.', 2),
(2, 'Zone 1', '1000.00', '10000.00', 'This is a zone example', 2),
(3, 'Zone 2', '2.00', '22.00', 'This is the second zone. You can use this for notes about this zone', 2),
(4, 'Zone 3', '11.00', '64.00', 'Another usefull thing might be details about this zone or special instructions.', 2);
-- --------------------------------------------------------
--
-- Table structure for table `jos_weblinks`
--
CREATE TABLE `jos_weblinks` (
`id` int(11) unsigned NOT NULL auto_increment,
`catid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(250) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`url` varchar(250) NOT NULL default '',
`description` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`archived` tinyint(1) NOT NULL default '0',
`approved` tinyint(1) NOT NULL default '1',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `jos_weblinks`
--
INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES
(1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 188, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'),
(2, 2, 0, 'php.net', 'phpnet', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 180, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''),
(3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 185, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''),
(4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 173, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'),
(5, 2, 0, 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 187, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0');
\r\n\r\n
\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\nIpsum Praesent veline condimentum cursuseso fringilla consectetuered amet ipsum dolor. 
\r\n
\r\n
\r\n
\r\n
\r\n
;', '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product`
--
CREATE TABLE `jos_vm_product` (
`product_id` int(11) NOT NULL auto_increment,
`vendor_id` int(11) NOT NULL default '0',
`product_parent_id` int(11) NOT NULL default '0',
`product_sku` varchar(64) NOT NULL default '',
`product_s_desc` varchar(255) default NULL,
`product_desc` text,
`product_thumb_image` varchar(255) default NULL,
`product_full_image` varchar(255) default NULL,
`product_publish` char(1) default NULL,
`product_weight` decimal(10,4) default NULL,
`product_weight_uom` varchar(32) default 'pounds.',
`product_length` decimal(10,4) default NULL,
`product_width` decimal(10,4) default NULL,
`product_height` decimal(10,4) default NULL,
`product_lwh_uom` varchar(32) default 'inches',
`product_url` varchar(255) default NULL,
`product_in_stock` int(11) NOT NULL default '0',
`product_available_date` int(11) default NULL,
`product_availability` varchar(56) NOT NULL default '',
`product_special` char(1) default NULL,
`product_discount_id` int(11) default NULL,
`ship_code_id` int(11) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`product_name` varchar(64) default NULL,
`product_sales` int(11) NOT NULL default '0',
`attribute` text,
`custom_attribute` text NOT NULL,
`product_tax_id` tinyint(2) NOT NULL default '0',
`product_unit` varchar(32) default NULL,
`product_packaging` int(11) default NULL,
`child_options` varchar(45) default NULL,
`quantity_options` varchar(45) default NULL,
`child_option_ids` varchar(45) default NULL,
`product_order_levels` varchar(45) default NULL,
PRIMARY KEY (`product_id`),
KEY `idx_product_vendor_id` (`vendor_id`),
KEY `idx_product_product_parent_id` (`product_parent_id`),
KEY `idx_product_sku` (`product_sku`),
KEY `idx_product_ship_code_id` (`ship_code_id`),
KEY `idx_product_name` (`product_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='All products are stored here.' AUTO_INCREMENT=35 ;
--
-- Dumping data for table `jos_vm_product`
--
INSERT INTO `jos_vm_product` (`product_id`, `vendor_id`, `product_parent_id`, `product_sku`, `product_s_desc`, `product_desc`, `product_thumb_image`, `product_full_image`, `product_publish`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_url`, `product_in_stock`, `product_available_date`, `product_availability`, `product_special`, `product_discount_id`, `ship_code_id`, `cdate`, `mdate`, `product_name`, `product_sales`, `attribute`, `custom_attribute`, `product_tax_id`, `product_unit`, `product_packaging`, `child_options`, `quantity_options`, `child_option_ids`, `product_order_levels`) VALUES
(2, 1, 0, 'picture1', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee54aa016f6_90x90.jpg', 'Picture_1_48ee54aa0d656.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223568588, 1223578794, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(3, 1, 0, 'picture2', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee54c9a58c4_90x90.jpg', 'Picture_2_48ee54c9b1ff5.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223569978, 1223578825, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(4, 1, 0, 'picture3', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee54e5a1571_90x90.jpg', 'Picture_3_48ee54e5ad8ba.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223570141, 1223578853, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(5, 1, 0, 'picture4', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_4_48ee5500b93db_90x90.jpg', 'Picture_4_48ee5500c533d.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223575599, 1223578880, 'Picture 4', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(6, 1, 0, 'picture5', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_5_48ee551930d70_90x90.jpg', 'Picture_5_48ee55193d4a2.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223575893, 1223578905, 'Picture 5', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(7, 1, 0, 'picture6', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_6_48ee5536db211_90x90.jpg', 'Picture_6_48ee5536e755a.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223575945, 1223578934, 'Picture 6', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(8, 1, 0, 'picture7', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee53f9906dc_90x90.jpg', 'Picture_1_48ee53f99ce0d.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576246, 1223578617, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(9, 1, 0, 'picture8', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee54137b73a_90x90.jpg', 'Picture_2_48ee541388639.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576324, 1223578643, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(10, 1, 0, 'picture9', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee54331f767_90x90.jpg', 'Picture_3_48ee54332c27f.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576489, 1223578675, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(11, 1, 0, 'picture10', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_4_48ee5459cd14c_90x90.jpg', 'Picture_4_48ee5459d90ad.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576532, 1223578713, 'Picture 4', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(12, 1, 0, 'picture11', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_5_48ee5471f37eb_90x90.jpg', 'Picture_5_48ee54720b8f4.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576550, 1223578738, 'Picture 5', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(13, 1, 0, 'picture12', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_6_48ee547ddb212_90x90.jpg', 'Picture_6_48ee547de7943.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576567, 1223578749, 'Picture 6', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(14, 1, 0, 'picture13', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee555ddd1b1_90x90.jpg', 'Picture_1_48ee555de94fa.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223576949, 1223578973, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(15, 1, 0, 'picture14', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee557726c6b_90x90.jpg', 'Picture_2_48ee55773339c.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223577022, 1223578999, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(16, 1, 0, 'picture15', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee55949542a_90x90.jpg', 'Picture_3_48ee5594a1b5a.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223577151, 1223579028, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(17, 1, 0, 'picture16', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee55be41b09_90x90.jpg', 'Picture_1_48ee55be4e620.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223577510, 1223579070, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(18, 1, 0, 'picture17', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee55d3f35a7_90x90.jpg', 'Picture_2_48ee55d40ba98.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223577558, 1223579092, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(19, 1, 0, 'picture18', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee55ec19e8f_90x90.jpg', 'Picture_3_48ee55ec261d8.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223577602, 1223579116, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(20, 1, 0, 'picture19', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee56ed3b220_90x90.jpg', 'Picture_1_48ee56ed47950.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579373, 1223579373, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(21, 1, 0, 'picture20', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee572674581_90x90.jpg', 'Picture_2_48ee57268109b.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579430, 1223579430, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(22, 1, 0, 'picture21', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee5750b186e_90x90.jpg', 'Picture_3_48ee5750be387.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579472, 1223579472, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(23, 1, 0, 'picture22', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee587554b09_90x90.jpg', 'Picture_1_48ee5875619ee.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579765, 1223579765, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(24, 1, 0, 'picture23', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee58abb35a5_90x90.jpg', 'Picture_2_48ee58abbfcd6.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579819, 1223579819, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(25, 1, 0, 'picture24', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee58ea70950_90x90.jpg', 'Picture_3_48ee58ea7d84f.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223579882, 1223579882, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(26, 1, 0, 'picture25', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee598f93bd5_90x90.jpg', 'Picture_1_48ee598fa0304.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580047, 1223580047, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(27, 1, 0, 'picture26', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee59bd30e2f_90x90.jpg', 'Picture_2_48ee59bd3d177.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580093, 1223580093, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(28, 1, 0, 'picture27', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee59e154e77_90x90.jpg', 'Picture_3_48ee59e162160.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580129, 1223580129, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(29, 1, 0, 'picture28', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee5b9dcfa3a_90x90.jpg', 'Picture_1_48ee5b9ddc16c.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580573, 1223580573, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(30, 1, 0, 'picture29', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee5c0048e5e_90x90.jpg', 'Picture_2_48ee5c00551a6.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580672, 1223580672, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(31, 1, 0, 'picture30', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee5c19788d0_90x90.jpg', 'Picture_3_48ee5c1984831.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580697, 1223580697, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(32, 1, 0, 'picture31', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_1_48ee5c992670e_90x90.jpg', 'Picture_1_48ee5c9933227.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580825, 1223580825, 'Picture 1', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(33, 1, 0, 'picture32', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_2_48ee5cdc8ee1f_90x90.jpg', 'Picture_2_48ee5cdc9b550.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580892, 1223580892, 'Picture 2', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0'),
(34, 1, 0, 'picture33', 'The default size of this photo is 5x7. Larger sizes are available.', 'For larger sizes select the desired size above.', 'resized/Picture_3_48ee5d1139af7_90x90.jpg', 'Picture_3_48ee5d1146229.jpg', 'Y', '0.0000', 'pounds', '0.0000', '0.0000', '0.0000', 'inches', '', 0, 1223528400, '', 'N', 0, NULL, 1223580945, 1223580945, 'Picture 3', 0, 'Size,8x10[+10],10x20[+25],20x30[+70]', '', 0, 'piece', 0, 'N,N,N,N,N,Y,20%,10%,', 'none,0,0,1', '', '0,0');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_attribute`
--
CREATE TABLE `jos_vm_product_attribute` (
`attribute_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`attribute_name` char(255) NOT NULL default '',
`attribute_value` char(255) NOT NULL default '',
PRIMARY KEY (`attribute_id`),
KEY `idx_product_attribute_product_id` (`product_id`),
KEY `idx_product_attribute_name` (`attribute_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores attributes + their specific values for Child Products' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_vm_product_attribute`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_attribute_sku`
--
CREATE TABLE `jos_vm_product_attribute_sku` (
`product_id` int(11) NOT NULL default '0',
`attribute_name` char(255) NOT NULL default '',
`attribute_list` int(11) NOT NULL default '0',
KEY `idx_product_attribute_sku_product_id` (`product_id`),
KEY `idx_product_attribute_sku_attribute_name` (`attribute_name`),
KEY `idx_product_attribute_list` (`attribute_list`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Attributes for a Parent Product used by its Child Products';
--
-- Dumping data for table `jos_vm_product_attribute_sku`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_category_xref`
--
CREATE TABLE `jos_vm_product_category_xref` (
`category_id` int(11) NOT NULL default '0',
`product_id` int(11) NOT NULL default '0',
`product_list` int(11) default NULL,
KEY `idx_product_category_xref_category_id` (`category_id`),
KEY `idx_product_category_xref_product_id` (`product_id`),
KEY `idx_product_category_xref_product_list` (`product_list`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps Products to Categories';
--
-- Dumping data for table `jos_vm_product_category_xref`
--
INSERT INTO `jos_vm_product_category_xref` (`category_id`, `product_id`, `product_list`) VALUES
(2, 3, 1),
(2, 2, 1),
(2, 4, 1),
(2, 5, 1),
(2, 6, 1),
(2, 7, 1),
(3, 8, 1),
(3, 9, 1),
(3, 10, 1),
(3, 11, 1),
(3, 12, 1),
(3, 13, 1),
(4, 14, 1),
(4, 15, 1),
(4, 16, 1),
(5, 17, 1),
(5, 18, 1),
(5, 19, 1),
(6, 20, 1),
(6, 21, 1),
(6, 22, 1),
(7, 23, 1),
(7, 24, 1),
(7, 25, 1),
(8, 26, 1),
(8, 27, 1),
(8, 28, 1),
(10, 29, 1),
(10, 30, 1),
(10, 31, 1),
(11, 32, 1),
(11, 33, 1),
(11, 34, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_discount`
--
CREATE TABLE `jos_vm_product_discount` (
`discount_id` int(11) NOT NULL auto_increment,
`amount` decimal(12,2) NOT NULL default '0.00',
`is_percent` tinyint(1) NOT NULL default '0',
`start_date` int(11) NOT NULL default '0',
`end_date` int(11) NOT NULL default '0',
PRIMARY KEY (`discount_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Discounts that can be assigned to products' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_product_discount`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_download`
--
CREATE TABLE `jos_vm_product_download` (
`product_id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`order_id` int(11) NOT NULL default '0',
`end_date` int(11) NOT NULL default '0',
`download_max` int(11) NOT NULL default '0',
`download_id` varchar(32) NOT NULL default '',
`file_name` varchar(255) NOT NULL default '',
PRIMARY KEY (`download_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Active downloads for selling downloadable goods';
--
-- Dumping data for table `jos_vm_product_download`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_files`
--
CREATE TABLE `jos_vm_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Additional Images and Files which are assigned to products' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_vm_product_files`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_mf_xref`
--
CREATE TABLE `jos_vm_product_mf_xref` (
`product_id` int(11) default NULL,
`manufacturer_id` int(11) default NULL,
KEY `idx_product_mf_xref_product_id` (`product_id`),
KEY `idx_product_mf_xref_manufacturer_id` (`manufacturer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps a product to a manufacturer';
--
-- Dumping data for table `jos_vm_product_mf_xref`
--
INSERT INTO `jos_vm_product_mf_xref` (`product_id`, `manufacturer_id`) VALUES
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_price`
--
CREATE TABLE `jos_vm_product_price` (
`product_price_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`product_price` decimal(12,5) default NULL,
`product_currency` char(16) default NULL,
`product_price_vdate` int(11) default NULL,
`product_price_edate` int(11) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`shopper_group_id` int(11) default NULL,
`price_quantity_start` int(11) unsigned NOT NULL default '0',
`price_quantity_end` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`product_price_id`),
KEY `idx_product_price_product_id` (`product_id`),
KEY `idx_product_price_shopper_group_id` (`shopper_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds price records for a product' AUTO_INCREMENT=35 ;
--
-- Dumping data for table `jos_vm_product_price`
--
INSERT INTO `jos_vm_product_price` (`product_price_id`, `product_id`, `product_price`, `product_currency`, `product_price_vdate`, `product_price_edate`, `cdate`, `mdate`, `shopper_group_id`, `price_quantity_start`, `price_quantity_end`) VALUES
(2, 2, '15.00000', 'USD', 0, 0, 1223568588, 1223578794, 5, 0, 0),
(3, 3, '15.00000', 'USD', 0, 0, 1223569978, 1223578825, 5, 0, 0),
(4, 4, '15.00000', 'USD', 0, 0, 1223570141, 1223578853, 5, 0, 0),
(5, 5, '15.00000', 'USD', 0, 0, 1223575599, 1223578880, 5, 0, 0),
(6, 6, '15.00000', 'USD', 0, 0, 1223575893, 1223578905, 5, 0, 0),
(7, 7, '15.00000', 'USD', 0, 0, 1223575945, 1223578934, 5, 0, 0),
(8, 8, '15.00000', 'USD', 0, 0, 1223576246, 1223578617, 5, 0, 0),
(9, 9, '15.00000', 'USD', 0, 0, 1223576324, 1223578643, 5, 0, 0),
(10, 10, '15.00000', 'USD', 0, 0, 1223576489, 1223578675, 5, 0, 0),
(11, 11, '15.00000', 'USD', 0, 0, 1223576532, 1223578713, 5, 0, 0),
(12, 12, '15.00000', 'USD', 0, 0, 1223576550, 1223578738, 5, 0, 0),
(13, 13, '15.00000', 'USD', 0, 0, 1223576567, 1223578749, 5, 0, 0),
(14, 14, '15.00000', 'USD', 0, 0, 1223576949, 1223578973, 5, 0, 0),
(15, 15, '15.00000', 'USD', 0, 0, 1223577022, 1223578999, 5, 0, 0),
(16, 16, '15.00000', 'USD', 0, 0, 1223577151, 1223579028, 5, 0, 0),
(17, 17, '15.00000', 'USD', 0, 0, 1223577510, 1223579070, 5, 0, 0),
(18, 18, '15.00000', 'USD', 0, 0, 1223577558, 1223579092, 5, 0, 0),
(19, 19, '15.00000', 'USD', 0, 0, 1223577602, 1223579116, 5, 0, 0),
(20, 20, '15.00000', 'USD', 0, 0, 1223579373, 1223579373, 5, 0, 0),
(21, 21, '15.00000', 'USD', 0, 0, 1223579430, 1223579430, 5, 0, 0),
(22, 22, '15.00000', 'USD', 0, 0, 1223579472, 1223579472, 5, 0, 0),
(23, 23, '15.00000', 'USD', 0, 0, 1223579765, 1223579765, 5, 0, 0),
(24, 24, '15.00000', 'USD', 0, 0, 1223579819, 1223579819, 5, 0, 0),
(25, 25, '15.00000', 'USD', 0, 0, 1223579882, 1223579882, 5, 0, 0),
(26, 26, '15.00000', 'USD', 0, 0, 1223580047, 1223580047, 5, 0, 0),
(27, 27, '15.00000', 'USD', 0, 0, 1223580093, 1223580093, 5, 0, 0),
(28, 28, '15.00000', 'USD', 0, 0, 1223580129, 1223580129, 5, 0, 0),
(29, 29, '15.00000', 'USD', 0, 0, 1223580573, 1223580573, 5, 0, 0),
(30, 30, '15.00000', 'USD', 0, 0, 1223580672, 1223580672, 5, 0, 0),
(31, 31, '15.00000', 'USD', 0, 0, 1223580697, 1223580697, 5, 0, 0),
(32, 32, '15.00000', 'USD', 0, 0, 1223580825, 1223580825, 5, 0, 0),
(33, 33, '15.00000', 'USD', 0, 0, 1223580892, 1223580892, 5, 0, 0),
(34, 34, '15.00000', 'USD', 0, 0, 1223580945, 1223580945, 5, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_product_type_xref`
--
CREATE TABLE `jos_vm_product_product_type_xref` (
`product_id` int(11) NOT NULL default '0',
`product_type_id` int(11) NOT NULL default '0',
KEY `idx_product_product_type_xref_product_id` (`product_id`),
KEY `idx_product_product_type_xref_product_type_id` (`product_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps products to a product type';
--
-- Dumping data for table `jos_vm_product_product_type_xref`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_relations`
--
CREATE TABLE `jos_vm_product_relations` (
`product_id` int(11) NOT NULL default '0',
`related_products` text,
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `jos_vm_product_relations`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_reviews`
--
CREATE TABLE `jos_vm_product_reviews` (
`review_id` int(11) NOT NULL auto_increment,
`product_id` int(11) NOT NULL default '0',
`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',
`published` char(1) NOT NULL default 'Y',
PRIMARY KEY (`review_id`),
UNIQUE KEY `product_id` (`product_id`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_product_reviews`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_type`
--
CREATE TABLE `jos_vm_product_type` (
`product_type_id` int(11) NOT NULL auto_increment,
`product_type_name` varchar(255) NOT NULL default '',
`product_type_description` text,
`product_type_publish` char(1) default NULL,
`product_type_browsepage` varchar(255) default NULL,
`product_type_flypage` varchar(255) default NULL,
`product_type_list_order` int(11) default NULL,
PRIMARY KEY (`product_type_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_product_type`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_type_parameter`
--
CREATE TABLE `jos_vm_product_type_parameter` (
`product_type_id` int(11) NOT NULL default '0',
`parameter_name` varchar(255) NOT NULL default '',
`parameter_label` varchar(255) NOT NULL default '',
`parameter_description` text,
`parameter_list_order` int(11) NOT NULL default '0',
`parameter_type` char(1) NOT NULL default 'T',
`parameter_values` varchar(255) default NULL,
`parameter_multiselect` char(1) default NULL,
`parameter_default` varchar(255) default NULL,
`parameter_unit` varchar(32) default NULL,
PRIMARY KEY (`product_type_id`,`parameter_name`),
KEY `idx_product_type_parameter_product_type_id` (`product_type_id`),
KEY `idx_product_type_parameter_parameter_order` (`parameter_list_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Parameters which are part of a product type';
--
-- Dumping data for table `jos_vm_product_type_parameter`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_product_votes`
--
CREATE TABLE `jos_vm_product_votes` (
`product_id` int(255) NOT NULL default '0',
`votes` text NOT NULL,
`allvotes` int(11) NOT NULL default '0',
`rating` tinyint(1) NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '0',
PRIMARY KEY (`product_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores all votes for a product';
--
-- Dumping data for table `jos_vm_product_votes`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_shipping_carrier`
--
CREATE TABLE `jos_vm_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Shipping Carriers as used by the Standard Shipping Module' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_shipping_carrier`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_shipping_label`
--
CREATE TABLE `jos_vm_shipping_label` (
`order_id` int(11) NOT NULL default '0',
`shipper_class` varchar(32) default NULL,
`ship_date` varchar(32) default NULL,
`service_code` varchar(32) default NULL,
`special_service` varchar(32) default NULL,
`package_type` varchar(16) default NULL,
`order_weight` decimal(10,2) default NULL,
`is_international` tinyint(1) default NULL,
`additional_protection_type` varchar(16) default NULL,
`additional_protection_value` decimal(10,2) default NULL,
`duty_value` decimal(10,2) default NULL,
`content_desc` varchar(255) default NULL,
`label_is_generated` tinyint(1) NOT NULL default '0',
`tracking_number` varchar(32) default NULL,
`label_image` blob,
`have_signature` tinyint(1) NOT NULL default '0',
`signature_image` blob,
PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Stores information used in generating shipping labels';
--
-- Dumping data for table `jos_vm_shipping_label`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_shipping_rate`
--
CREATE TABLE `jos_vm_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Shipping Rates, used by the Standard Shipping Module' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_vm_shipping_rate`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_shopper_group`
--
CREATE TABLE `jos_vm_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(5,2) NOT NULL default '0.00',
`show_price_including_tax` tinyint(1) NOT NULL default '1',
`default` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`shopper_group_id`),
KEY `idx_shopper_group_vendor_id` (`vendor_id`),
KEY `idx_shopper_group_name` (`shopper_group_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Shopper Groups that users can be assigned to' AUTO_INCREMENT=8 ;
--
-- Dumping data for table `jos_vm_shopper_group`
--
INSERT INTO `jos_vm_shopper_group` (`shopper_group_id`, `vendor_id`, `shopper_group_name`, `shopper_group_desc`, `shopper_group_discount`, `show_price_including_tax`, `default`) VALUES
(5, 1, '-default-', 'This is the default shopper group.', '0.00', 1, 1),
(6, 1, 'Gold Level', 'Gold Level phpShoppers.', '0.00', 1, 0),
(7, 1, 'Wholesale', 'Shoppers that can buy at wholesale.', '0.00', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_shopper_vendor_xref`
--
CREATE TABLE `jos_vm_shopper_vendor_xref` (
`user_id` int(11) default NULL,
`vendor_id` int(11) default NULL,
`shopper_group_id` int(11) default NULL,
`customer_number` varchar(32) default NULL,
KEY `idx_shopper_vendor_xref_user_id` (`user_id`),
KEY `idx_shopper_vendor_xref_vendor_id` (`vendor_id`),
KEY `idx_shopper_vendor_xref_shopper_group_id` (`shopper_group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Maps a user to a Shopper Group of a Vendor';
--
-- Dumping data for table `jos_vm_shopper_vendor_xref`
--
INSERT INTO `jos_vm_shopper_vendor_xref` (`user_id`, `vendor_id`, `shopper_group_id`, `customer_number`) VALUES
(62, 1, 5, '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_state`
--
CREATE TABLE `jos_vm_state` (
`state_id` int(11) NOT NULL auto_increment,
`country_id` int(11) NOT NULL default '1',
`state_name` varchar(64) default NULL,
`state_3_code` char(3) default NULL,
`state_2_code` char(2) default NULL,
PRIMARY KEY (`state_id`),
UNIQUE KEY `state_3_code` (`country_id`,`state_3_code`),
UNIQUE KEY `state_2_code` (`country_id`,`state_2_code`),
KEY `idx_country_id` (`country_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='States that are assigned to a country' AUTO_INCREMENT=449 ;
--
-- Dumping data for table `jos_vm_state`
--
INSERT INTO `jos_vm_state` (`state_id`, `country_id`, `state_name`, `state_3_code`, `state_2_code`) VALUES
(1, 223, 'Alabama', 'ALA', 'AL'),
(2, 223, 'Alaska', 'ALK', 'AK'),
(3, 223, 'Arizona', 'ARZ', 'AZ'),
(4, 223, 'Arkansas', 'ARK', 'AR'),
(5, 223, 'California', 'CAL', 'CA'),
(6, 223, 'Colorado', 'COL', 'CO'),
(7, 223, 'Connecticut', 'CCT', 'CT'),
(8, 223, 'Delaware', 'DEL', 'DE'),
(9, 223, 'District Of Columbia', 'DOC', 'DC'),
(10, 223, 'Florida', 'FLO', 'FL'),
(11, 223, 'Georgia', 'GEA', 'GA'),
(12, 223, 'Hawaii', 'HWI', 'HI'),
(13, 223, 'Idaho', 'IDA', 'ID'),
(14, 223, 'Illinois', 'ILL', 'IL'),
(15, 223, 'Indiana', 'IND', 'IN'),
(16, 223, 'Iowa', 'IOA', 'IA'),
(17, 223, 'Kansas', 'KAS', 'KS'),
(18, 223, 'Kentucky', 'KTY', 'KY'),
(19, 223, 'Louisiana', 'LOA', 'LA'),
(20, 223, 'Maine', 'MAI', 'ME'),
(21, 223, 'Maryland', 'MLD', 'MD'),
(22, 223, 'Massachusetts', 'MSA', 'MA'),
(23, 223, 'Michigan', 'MIC', 'MI'),
(24, 223, 'Minnesota', 'MIN', 'MN'),
(25, 223, 'Mississippi', 'MIS', 'MS'),
(26, 223, 'Missouri', 'MIO', 'MO'),
(27, 223, 'Montana', 'MOT', 'MT'),
(28, 223, 'Nebraska', 'NEB', 'NE'),
(29, 223, 'Nevada', 'NEV', 'NV'),
(30, 223, 'New Hampshire', 'NEH', 'NH'),
(31, 223, 'New Jersey', 'NEJ', 'NJ'),
(32, 223, 'New Mexico', 'NEM', 'NM'),
(33, 223, 'New York', 'NEY', 'NY'),
(34, 223, 'North Carolina', 'NOC', 'NC'),
(35, 223, 'North Dakota', 'NOD', 'ND'),
(36, 223, 'Ohio', 'OHI', 'OH'),
(37, 223, 'Oklahoma', 'OKL', 'OK'),
(38, 223, 'Oregon', 'ORN', 'OR'),
(39, 223, 'Pennsylvania', 'PEA', 'PA'),
(40, 223, 'Rhode Island', 'RHI', 'RI'),
(41, 223, 'South Carolina', 'SOC', 'SC'),
(42, 223, 'South Dakota', 'SOD', 'SD'),
(43, 223, 'Tennessee', 'TEN', 'TN'),
(44, 223, 'Texas', 'TXS', 'TX'),
(45, 223, 'Utah', 'UTA', 'UT'),
(46, 223, 'Vermont', 'VMT', 'VT'),
(47, 223, 'Virginia', 'VIA', 'VA'),
(48, 223, 'Washington', 'WAS', 'WA'),
(49, 223, 'West Virginia', 'WEV', 'WV'),
(50, 223, 'Wisconsin', 'WIS', 'WI'),
(51, 223, 'Wyoming', 'WYO', 'WY'),
(52, 38, 'Alberta', 'ALB', 'AB'),
(53, 38, 'British Columbia', 'BRC', 'BC'),
(54, 38, 'Manitoba', 'MAB', 'MB'),
(55, 38, 'New Brunswick', 'NEB', 'NB'),
(56, 38, 'Newfoundland and Labrador', 'NFL', 'NL'),
(57, 38, 'Northwest Territories', 'NWT', 'NT'),
(58, 38, 'Nova Scotia', 'NOS', 'NS'),
(59, 38, 'Nunavut', 'NUT', 'NU'),
(60, 38, 'Ontario', 'ONT', 'ON'),
(61, 38, 'Prince Edward Island', 'PEI', 'PE'),
(62, 38, 'Quebec', 'QEC', 'QC'),
(63, 38, 'Saskatchewan', 'SAK', 'SK'),
(64, 38, 'Yukon', 'YUT', 'YT'),
(65, 222, 'England', 'ENG', 'EN'),
(66, 222, 'Northern Ireland', 'NOI', 'NI'),
(67, 222, 'Scotland', 'SCO', 'SD'),
(68, 222, 'Wales', 'WLS', 'WS'),
(69, 13, 'Australian Capital Territory', 'ACT', 'AT'),
(70, 13, 'New South Wales', 'NSW', 'NW'),
(71, 13, 'Northern Territory', 'NOT', 'NT'),
(72, 13, 'Queensland', 'QLD', 'QL'),
(73, 13, 'South Australia', 'SOA', 'SA'),
(74, 13, 'Tasmania', 'TAS', 'TA'),
(75, 13, 'Victoria', 'VIC', 'VI'),
(76, 13, 'Western Australia', 'WEA', 'WA'),
(77, 138, 'Aguascalientes', 'AGS', 'AG'),
(78, 138, 'Baja California Norte', 'BCN', 'BN'),
(79, 138, 'Baja California Sur', 'BCS', 'BS'),
(80, 138, 'Campeche', 'CAM', 'CA'),
(81, 138, 'Chiapas', 'CHI', 'CS'),
(82, 138, 'Chihuahua', 'CHA', 'CH'),
(83, 138, 'Coahuila', 'COA', 'CO'),
(84, 138, 'Colima', 'COL', 'CM'),
(85, 138, 'Distrito Federal', 'DFM', 'DF'),
(86, 138, 'Durango', 'DGO', 'DO'),
(87, 138, 'Guanajuato', 'GTO', 'GO'),
(88, 138, 'Guerrero', 'GRO', 'GU'),
(89, 138, 'Hidalgo', 'HGO', 'HI'),
(90, 138, 'Jalisco', 'JAL', 'JA'),
(91, 138, 'México (Estado de)', 'EDM', 'EM'),
(92, 138, 'Michoacán', 'MCN', 'MI'),
(93, 138, 'Morelos', 'MOR', 'MO'),
(94, 138, 'Nayarit', 'NAY', 'NY'),
(95, 138, 'Nuevo León', 'NUL', 'NL'),
(96, 138, 'Oaxaca', 'OAX', 'OA'),
(97, 138, 'Puebla', 'PUE', 'PU'),
(98, 138, 'Querétaro', 'QRO', 'QU'),
(99, 138, 'Quintana Roo', 'QUR', 'QR'),
(100, 138, 'San Luis PotosÃ', 'SLP', 'SP'),
(101, 138, 'Sinaloa', 'SIN', 'SI'),
(102, 138, 'Sonora', 'SON', 'SO'),
(103, 138, 'Tabasco', 'TAB', 'TA'),
(104, 138, 'Tamaulipas', 'TAM', 'TM'),
(105, 138, 'Tlaxcala', 'TLX', 'TX'),
(106, 138, 'Veracruz', 'VER', 'VZ'),
(107, 138, 'Yucatán', 'YUC', 'YU'),
(108, 138, 'Zacatecas', 'ZAC', 'ZA'),
(109, 30, 'Acre', 'ACR', 'AC'),
(110, 30, 'Alagoas', 'ALG', 'AL'),
(111, 30, 'Amapá', 'AMP', 'AP'),
(112, 30, 'Amazonas', 'AMZ', 'AM'),
(113, 30, 'BahÃa', 'BAH', 'BA'),
(114, 30, 'Ceará', 'CEA', 'CE'),
(115, 30, 'Distrito Federal', 'DFB', 'DF'),
(116, 30, 'Espirito Santo', 'ESS', 'ES'),
(117, 30, 'Goiás', 'GOI', 'GO'),
(118, 30, 'Maranhão', 'MAR', 'MA'),
(119, 30, 'Mato Grosso', 'MAT', 'MT'),
(120, 30, 'Mato Grosso do Sul', 'MGS', 'MS'),
(121, 30, 'Minas GeraÃs', 'MIG', 'MG'),
(122, 30, 'Paraná', 'PAR', 'PR'),
(123, 30, 'ParaÃba', 'PRB', 'PB'),
(124, 30, 'Pará', 'PAB', 'PA'),
(125, 30, 'Pernambuco', 'PER', 'PE'),
(126, 30, 'PiauÃ', 'PIA', 'PI'),
(127, 30, 'Rio Grande do Norte', 'RGN', 'RN'),
(128, 30, 'Rio Grande do Sul', 'RGS', 'RS'),
(129, 30, 'Rio de Janeiro', 'RDJ', 'RJ'),
(130, 30, 'Rondônia', 'RON', 'RO'),
(131, 30, 'Roraima', 'ROR', 'RR'),
(132, 30, 'Santa Catarina', 'SAC', 'SC'),
(133, 30, 'Sergipe', 'SER', 'SE'),
(134, 30, 'São Paulo', 'SAP', 'SP'),
(135, 30, 'Tocantins', 'TOC', 'TO'),
(136, 44, 'Anhui', 'ANH', '34'),
(137, 44, 'Beijing', 'BEI', '11'),
(138, 44, 'Chongqing', 'CHO', '50'),
(139, 44, 'Fujian', 'FUJ', '35'),
(140, 44, 'Gansu', 'GAN', '62'),
(141, 44, 'Guangdong', 'GUA', '44'),
(142, 44, 'Guangxi Zhuang', 'GUZ', '45'),
(143, 44, 'Guizhou', 'GUI', '52'),
(144, 44, 'Hainan', 'HAI', '46'),
(145, 44, 'Hebei', 'HEB', '13'),
(146, 44, 'Heilongjiang', 'HEI', '23'),
(147, 44, 'Henan', 'HEN', '41'),
(148, 44, 'Hubei', 'HUB', '42'),
(149, 44, 'Hunan', 'HUN', '43'),
(150, 44, 'Jiangsu', 'JIA', '32'),
(151, 44, 'Jiangxi', 'JIX', '36'),
(152, 44, 'Jilin', 'JIL', '22'),
(153, 44, 'Liaoning', 'LIA', '21'),
(154, 44, 'Nei Mongol', 'NML', '15'),
(155, 44, 'Ningxia Hui', 'NIH', '64'),
(156, 44, 'Qinghai', 'QIN', '63'),
(157, 44, 'Shandong', 'SNG', '37'),
(158, 44, 'Shanghai', 'SHH', '31'),
(159, 44, 'Shaanxi', 'SHX', '61'),
(160, 44, 'Sichuan', 'SIC', '51'),
(161, 44, 'Tianjin', 'TIA', '12'),
(162, 44, 'Xinjiang Uygur', 'XIU', '65'),
(163, 44, 'Xizang', 'XIZ', '54'),
(164, 44, 'Yunnan', 'YUN', '53'),
(165, 44, 'Zhejiang', 'ZHE', '33'),
(166, 104, 'Gaza Strip', 'GZS', 'GZ'),
(167, 104, 'West Bank', 'WBK', 'WB'),
(168, 104, 'Other', 'OTH', 'OT'),
(169, 151, 'St. Maarten', 'STM', 'SM'),
(170, 151, 'Bonaire', 'BNR', 'BN'),
(171, 151, 'Curacao', 'CUR', 'CR'),
(172, 175, 'Alba', 'ABA', 'AB'),
(173, 175, 'Arad', 'ARD', 'AR'),
(174, 175, 'Arges', 'ARG', 'AG'),
(175, 175, 'Bacau', 'BAC', 'BC'),
(176, 175, 'Bihor', 'BIH', 'BH'),
(177, 175, 'Bistrita-Nasaud', 'BIS', 'BN'),
(178, 175, 'Botosani', 'BOT', 'BT'),
(179, 175, 'Braila', 'BRL', 'BR'),
(180, 175, 'Brasov', 'BRA', 'BV'),
(181, 175, 'Bucuresti', 'BUC', 'B'),
(182, 175, 'Buzau', 'BUZ', 'BZ'),
(183, 175, 'Calarasi', 'CAL', 'CL'),
(184, 175, 'Caras Severin', 'CRS', 'CS'),
(185, 175, 'Cluj', 'CLJ', 'CJ'),
(186, 175, 'Constanta', 'CST', 'CT'),
(187, 175, 'Covasna', 'COV', 'CV'),
(188, 175, 'Dambovita', 'DAM', 'DB'),
(189, 175, 'Dolj', 'DLJ', 'DJ'),
(190, 175, 'Galati', 'GAL', 'GL'),
(191, 175, 'Giurgiu', 'GIU', 'GR'),
(192, 175, 'Gorj', 'GOR', 'GJ'),
(193, 175, 'Hargita', 'HRG', 'HR'),
(194, 175, 'Hunedoara', 'HUN', 'HD'),
(195, 175, 'Ialomita', 'IAL', 'IL'),
(196, 175, 'Iasi', 'IAS', 'IS'),
(197, 175, 'Ilfov', 'ILF', 'IF'),
(198, 175, 'Maramures', 'MAR', 'MM'),
(199, 175, 'Mehedinti', 'MEH', 'MH'),
(200, 175, 'Mures', 'MUR', 'MS'),
(201, 175, 'Neamt', 'NEM', 'NT'),
(202, 175, 'Olt', 'OLT', 'OT'),
(203, 175, 'Prahova', 'PRA', 'PH'),
(204, 175, 'Salaj', 'SAL', 'SJ'),
(205, 175, 'Satu Mare', 'SAT', 'SM'),
(206, 175, 'Sibiu', 'SIB', 'SB'),
(207, 175, 'Suceava', 'SUC', 'SV'),
(208, 175, 'Teleorman', 'TEL', 'TR'),
(209, 175, 'Timis', 'TIM', 'TM'),
(210, 175, 'Tulcea', 'TUL', 'TL'),
(211, 175, 'Valcea', 'VAL', 'VL'),
(212, 175, 'Vaslui', 'VAS', 'VS'),
(213, 175, 'Vrancea', 'VRA', 'VN'),
(214, 105, 'Agrigento', 'AGR', 'AG'),
(215, 105, 'Alessandria', 'ALE', 'AL'),
(216, 105, 'Ancona', 'ANC', 'AN'),
(217, 105, 'Aosta', 'AOS', 'AO'),
(218, 105, 'Arezzo', 'ARE', 'AR'),
(219, 105, 'Ascoli Piceno', 'API', 'AP'),
(220, 105, 'Asti', 'AST', 'AT'),
(221, 105, 'Avellino', 'AVE', 'AV'),
(222, 105, 'Bari', 'BAR', 'BA'),
(223, 105, 'Belluno', 'BEL', 'BL'),
(224, 105, 'Benevento', 'BEN', 'BN'),
(225, 105, 'Bergamo', 'BEG', 'BG'),
(226, 105, 'Biella', 'BIE', 'BI'),
(227, 105, 'Bologna', 'BOL', 'BO'),
(228, 105, 'Bolzano', 'BOZ', 'BZ'),
(229, 105, 'Brescia', 'BRE', 'BS'),
(230, 105, 'Brindisi', 'BRI', 'BR'),
(231, 105, 'Cagliari', 'CAG', 'CA'),
(232, 105, 'Caltanissetta', 'CAL', 'CL'),
(233, 105, 'Campobasso', 'CBO', 'CB'),
(234, 105, 'Carbonia-Iglesias', 'CAR', 'CI'),
(235, 105, 'Caserta', 'CAS', 'CE'),
(236, 105, 'Catania', 'CAT', 'CT'),
(237, 105, 'Catanzaro', 'CTZ', 'CZ'),
(238, 105, 'Chieti', 'CHI', 'CH'),
(239, 105, 'Como', 'COM', 'CO'),
(240, 105, 'Cosenza', 'COS', 'CS'),
(241, 105, 'Cremona', 'CRE', 'CR'),
(242, 105, 'Crotone', 'CRO', 'KR'),
(243, 105, 'Cuneo', 'CUN', 'CN'),
(244, 105, 'Enna', 'ENN', 'EN'),
(245, 105, 'Ferrara', 'FER', 'FE'),
(246, 105, 'Firenze', 'FIR', 'FI'),
(247, 105, 'Foggia', 'FOG', 'FG'),
(248, 105, 'Forli-Cesena', 'FOC', 'FC'),
(249, 105, 'Frosinone', 'FRO', 'FR'),
(250, 105, 'Genova', 'GEN', 'GE'),
(251, 105, 'Gorizia', 'GOR', 'GO'),
(252, 105, 'Grosseto', 'GRO', 'GR'),
(253, 105, 'Imperia', 'IMP', 'IM'),
(254, 105, 'Isernia', 'ISE', 'IS'),
(255, 105, 'L''Aquila', 'AQU', 'AQ'),
(256, 105, 'La Spezia', 'LAS', 'SP'),
(257, 105, 'Latina', 'LAT', 'LT'),
(258, 105, 'Lecce', 'LEC', 'LE'),
(259, 105, 'Lecco', 'LCC', 'LC'),
(260, 105, 'Livorno', 'LIV', 'LI'),
(261, 105, 'Lodi', 'LOD', 'LO'),
(262, 105, 'Lucca', 'LUC', 'LU'),
(263, 105, 'Macerata', 'MAC', 'MC'),
(264, 105, 'Mantova', 'MAN', 'MN'),
(265, 105, 'Massa-Carrara', 'MAS', 'MS'),
(266, 105, 'Matera', 'MAA', 'MT'),
(267, 105, 'Medio Campidano', 'MED', 'VS'),
(268, 105, 'Messina', 'MES', 'ME'),
(269, 105, 'Milano', 'MIL', 'MI'),
(270, 105, 'Modena', 'MOD', 'MO'),
(271, 105, 'Napoli', 'NAP', 'NA'),
(272, 105, 'Novara', 'NOV', 'NO'),
(273, 105, 'Nuoro', 'NUR', 'NU'),
(274, 105, 'Ogliastra', 'OGL', 'OG'),
(275, 105, 'Olbia-Tempio', 'OLB', 'OT'),
(276, 105, 'Oristano', 'ORI', 'OR'),
(277, 105, 'Padova', 'PDA', 'PD'),
(278, 105, 'Palermo', 'PAL', 'PA'),
(279, 105, 'Parma', 'PAA', 'PR'),
(280, 105, 'Pavia', 'PAV', 'PV'),
(281, 105, 'Perugia', 'PER', 'PG'),
(282, 105, 'Pesaro e Urbino', 'PES', 'PU'),
(283, 105, 'Pescara', 'PSC', 'PE'),
(284, 105, 'Piacenza', 'PIA', 'PC'),
(285, 105, 'Pisa', 'PIS', 'PI'),
(286, 105, 'Pistoia', 'PIT', 'PT'),
(287, 105, 'Pordenone', 'POR', 'PN'),
(288, 105, 'Potenza', 'PTZ', 'PZ'),
(289, 105, 'Prato', 'PRA', 'PO'),
(290, 105, 'Ragusa', 'RAG', 'RG'),
(291, 105, 'Ravenna', 'RAV', 'RA'),
(292, 105, 'Reggio Calabria', 'REG', 'RC'),
(293, 105, 'Reggio Emilia', 'REE', 'RE'),
(294, 105, 'Rieti', 'RIE', 'RI'),
(295, 105, 'Rimini', 'RIM', 'RN'),
(296, 105, 'Roma', 'ROM', 'RM'),
(297, 105, 'Rovigo', 'ROV', 'RO'),
(298, 105, 'Salerno', 'SAL', 'SA'),
(299, 105, 'Sassari', 'SAS', 'SS'),
(300, 105, 'Savona', 'SAV', 'SV'),
(301, 105, 'Siena', 'SIE', 'SI'),
(302, 105, 'Siracusa', 'SIR', 'SR'),
(303, 105, 'Sondrio', 'SOO', 'SO'),
(304, 105, 'Taranto', 'TAR', 'TA'),
(305, 105, 'Teramo', 'TER', 'TE'),
(306, 105, 'Terni', 'TRN', 'TR'),
(307, 105, 'Torino', 'TOR', 'TO'),
(308, 105, 'Trapani', 'TRA', 'TP'),
(309, 105, 'Trento', 'TRE', 'TN'),
(310, 105, 'Treviso', 'TRV', 'TV'),
(311, 105, 'Trieste', 'TRI', 'TS'),
(312, 105, 'Udine', 'UDI', 'UD'),
(313, 105, 'Varese', 'VAR', 'VA'),
(314, 105, 'Venezia', 'VEN', 'VE'),
(315, 105, 'Verbano Cusio Ossola', 'VCO', 'VB'),
(316, 105, 'Vercelli', 'VER', 'VC'),
(317, 105, 'Verona', 'VRN', 'VR'),
(318, 105, 'Vibo Valenzia', 'VIV', 'VV'),
(319, 105, 'Vicenza', 'VII', 'VI'),
(320, 105, 'Viterbo', 'VIT', 'VT'),
(321, 195, 'A Coruña', 'ACO', '15'),
(322, 195, 'Alava', 'ALA', '01'),
(323, 195, 'Albacete', 'ALB', '02'),
(324, 195, 'Alicante', 'ALI', '03'),
(325, 195, 'Almeria', 'ALM', '04'),
(326, 195, 'Asturias', 'AST', '33'),
(327, 195, 'Avila', 'AVI', '05'),
(328, 195, 'Badajoz', 'BAD', '06'),
(329, 195, 'Baleares', 'BAL', '07'),
(330, 195, 'Barcelona', 'BAR', '08'),
(331, 195, 'Burgos', 'BUR', '09'),
(332, 195, 'Caceres', 'CAC', '10'),
(333, 195, 'Cadiz', 'CAD', '11'),
(334, 195, 'Cantabria', 'CAN', '39'),
(335, 195, 'Castellon', 'CAS', '12'),
(336, 195, 'Ceuta', 'CEU', '51'),
(337, 195, 'Ciudad Real', 'CIU', '13'),
(338, 195, 'Cordoba', 'COR', '14'),
(339, 195, 'Cuenca', 'CUE', '16'),
(340, 195, 'Girona', 'GIR', '17'),
(341, 195, 'Granada', 'GRA', '18'),
(342, 195, 'Guadalajara', 'GUA', '19'),
(343, 195, 'Guipuzcoa', 'GUI', '20'),
(344, 195, 'Huelva', 'HUL', '21'),
(345, 195, 'Huesca', 'HUS', '22'),
(346, 195, 'Jaen', 'JAE', '23'),
(347, 195, 'La Rioja', 'LRI', '26'),
(348, 195, 'Las Palmas', 'LPA', '35'),
(349, 195, 'Leon', 'LEO', '24'),
(350, 195, 'Lleida', 'LLE', '25'),
(351, 195, 'Lugo', 'LUG', '27'),
(352, 195, 'Madrid', 'MAD', '28'),
(353, 195, 'Malaga', 'MAL', '29'),
(354, 195, 'Melilla', 'MEL', '52'),
(355, 195, 'Murcia', 'MUR', '30'),
(356, 195, 'Navarra', 'NAV', '31'),
(357, 195, 'Ourense', 'OUR', '32'),
(358, 195, 'Palencia', 'PAL', '34'),
(359, 195, 'Pontevedra', 'PON', '36'),
(360, 195, 'Salamanca', 'SAL', '37'),
(361, 195, 'Santa Cruz de Tenerife', 'SCT', '38'),
(362, 195, 'Segovia', 'SEG', '40'),
(363, 195, 'Sevilla', 'SEV', '41'),
(364, 195, 'Soria', 'SOR', '42'),
(365, 195, 'Tarragona', 'TAR', '43'),
(366, 195, 'Teruel', 'TER', '44'),
(367, 195, 'Toledo', 'TOL', '45'),
(368, 195, 'Valencia', 'VAL', '46'),
(369, 195, 'Valladolid', 'VLL', '47'),
(370, 195, 'Vizcaya', 'VIZ', '48'),
(371, 195, 'Zamora', 'ZAM', '49'),
(372, 195, 'Zaragoza', 'ZAR', '50'),
(373, 11, 'Aragatsotn', 'ARG', 'AG'),
(374, 11, 'Ararat', 'ARR', 'AR'),
(375, 11, 'Armavir', 'ARM', 'AV'),
(376, 11, 'Gegharkunik', 'GEG', 'GR'),
(377, 11, 'Kotayk', 'KOT', 'KT'),
(378, 11, 'Lori', 'LOR', 'LO'),
(379, 11, 'Shirak', 'SHI', 'SH'),
(380, 11, 'Syunik', 'SYU', 'SU'),
(381, 11, 'Tavush', 'TAV', 'TV'),
(382, 11, 'Vayots-Dzor', 'VAD', 'VD'),
(383, 11, 'Yerevan', 'YER', 'ER'),
(384, 99, 'Andaman & Nicobar Islands', 'ANI', 'AI'),
(385, 99, 'Andhra Pradesh', 'AND', 'AN'),
(386, 99, 'Arunachal Pradesh', 'ARU', 'AR'),
(387, 99, 'Assam', 'ASS', 'AS'),
(388, 99, 'Bihar', 'BIH', 'BI'),
(389, 99, 'Chandigarh', 'CHA', 'CA'),
(390, 99, 'Chhatisgarh', 'CHH', 'CH'),
(391, 99, 'Dadra & Nagar Haveli', 'DAD', 'DD'),
(392, 99, 'Daman & Diu', 'DAM', 'DA'),
(393, 99, 'Delhi', 'DEL', 'DE'),
(394, 99, 'Goa', 'GOA', 'GO'),
(395, 99, 'Gujarat', 'GUJ', 'GU'),
(396, 99, 'Haryana', 'HAR', 'HA'),
(397, 99, 'Himachal Pradesh', 'HIM', 'HI'),
(398, 99, 'Jammu & Kashmir', 'JAM', 'JA'),
(399, 99, 'Jharkhand', 'JHA', 'JH'),
(400, 99, 'Karnataka', 'KAR', 'KA'),
(401, 99, 'Kerala', 'KER', 'KE'),
(402, 99, 'Lakshadweep', 'LAK', 'LA'),
(403, 99, 'Madhya Pradesh', 'MAD', 'MD'),
(404, 99, 'Maharashtra', 'MAH', 'MH'),
(405, 99, 'Manipur', 'MAN', 'MN'),
(406, 99, 'Meghalaya', 'MEG', 'ME'),
(407, 99, 'Mizoram', 'MIZ', 'MI'),
(408, 99, 'Nagaland', 'NAG', 'NA'),
(409, 99, 'Orissa', 'ORI', 'OR'),
(410, 99, 'Pondicherry', 'PON', 'PO'),
(411, 99, 'Punjab', 'PUN', 'PU'),
(412, 99, 'Rajasthan', 'RAJ', 'RA'),
(413, 99, 'Sikkim', 'SIK', 'SI'),
(414, 99, 'Tamil Nadu', 'TAM', 'TA'),
(415, 99, 'Tripura', 'TRI', 'TR'),
(416, 99, 'Uttaranchal', 'UAR', 'UA'),
(417, 99, 'Uttar Pradesh', 'UTT', 'UT'),
(418, 99, 'West Bengal', 'WES', 'WE'),
(419, 101, 'Ahmadi va Kohkiluyeh', 'BOK', 'BO'),
(420, 101, 'Ardabil', 'ARD', 'AR'),
(421, 101, 'Azarbayjan-e Gharbi', 'AZG', 'AG'),
(422, 101, 'Azarbayjan-e Sharqi', 'AZS', 'AS'),
(423, 101, 'Bushehr', 'BUS', 'BU'),
(424, 101, 'Chaharmahal va Bakhtiari', 'CMB', 'CM'),
(425, 101, 'Esfahan', 'ESF', 'ES'),
(426, 101, 'Fars', 'FAR', 'FA'),
(427, 101, 'Gilan', 'GIL', 'GI'),
(428, 101, 'Gorgan', 'GOR', 'GO'),
(429, 101, 'Hamadan', 'HAM', 'HA'),
(430, 101, 'Hormozgan', 'HOR', 'HO'),
(431, 101, 'Ilam', 'ILA', 'IL'),
(432, 101, 'Kerman', 'KER', 'KE'),
(433, 101, 'Kermanshah', 'BAK', 'BA'),
(434, 101, 'Khorasan-e Junoubi', 'KHJ', 'KJ'),
(435, 101, 'Khorasan-e Razavi', 'KHR', 'KR'),
(436, 101, 'Khorasan-e Shomali', 'KHS', 'KS'),
(437, 101, 'Khuzestan', 'KHU', 'KH'),
(438, 101, 'Kordestan', 'KOR', 'KO'),
(439, 101, 'Lorestan', 'LOR', 'LO'),
(440, 101, 'Markazi', 'MAR', 'MR'),
(441, 101, 'Mazandaran', 'MAZ', 'MZ'),
(442, 101, 'Qazvin', 'QAS', 'QA'),
(443, 101, 'Qom', 'QOM', 'QO'),
(444, 101, 'Semnan', 'SEM', 'SE'),
(445, 101, 'Sistan va Baluchestan', 'SBA', 'SB'),
(446, 101, 'Tehran', 'TEH', 'TE'),
(447, 101, 'Yazd', 'YAZ', 'YA'),
(448, 101, 'Zanjan', 'ZAN', 'ZA');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_tax_rate`
--
CREATE TABLE `jos_vm_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The tax rates for your store' AUTO_INCREMENT=3 ;
--
-- Dumping data for table `jos_vm_tax_rate`
--
INSERT INTO `jos_vm_tax_rate` (`tax_rate_id`, `vendor_id`, `tax_state`, `tax_country`, `mdate`, `tax_rate`) VALUES
(2, 1, 'CA', 'USA', 964565926, '0.0825');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_userfield`
--
CREATE TABLE `jos_vm_userfield` (
`fieldid` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`title` varchar(255) NOT NULL,
`description` mediumtext NOT NULL,
`type` varchar(50) NOT NULL default '',
`maxlength` int(11) default NULL,
`size` int(11) default NULL,
`required` tinyint(4) default '0',
`ordering` int(11) default NULL,
`cols` int(11) default NULL,
`rows` int(11) default NULL,
`value` varchar(50) default NULL,
`default` int(11) default NULL,
`published` tinyint(1) NOT NULL default '1',
`registration` tinyint(1) NOT NULL default '0',
`shipping` tinyint(1) NOT NULL default '0',
`account` tinyint(1) NOT NULL default '1',
`readonly` tinyint(1) NOT NULL default '0',
`calculated` tinyint(1) NOT NULL default '0',
`sys` tinyint(4) NOT NULL default '0',
`vendor_id` int(11) default NULL,
`params` mediumtext,
PRIMARY KEY (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds the fields for the user information' AUTO_INCREMENT=36 ;
--
-- Dumping data for table `jos_vm_userfield`
--
INSERT INTO `jos_vm_userfield` (`fieldid`, `name`, `title`, `description`, `type`, `maxlength`, `size`, `required`, `ordering`, `cols`, `rows`, `value`, `default`, `published`, `registration`, `shipping`, `account`, `readonly`, `calculated`, `sys`, `vendor_id`, `params`) VALUES
(1, 'email', 'REGISTER_EMAIL', '', 'emailaddress', 100, 30, 1, 2, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(7, 'title', 'PHPSHOP_SHOPPER_FORM_TITLE', '', 'select', 0, 0, 0, 8, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(3, 'password', 'PHPSHOP_SHOPPER_FORM_PASSWORD_1', '', 'password', 25, 30, 1, 4, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(4, 'password2', 'PHPSHOP_SHOPPER_FORM_PASSWORD_2', '', 'password', 25, 30, 1, 5, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 1, 1, NULL),
(6, 'company', 'PHPSHOP_SHOPPER_FORM_COMPANY_NAME', '', 'text', 64, 30, 0, 7, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(5, 'delimiter_billto', 'PHPSHOP_USER_FORM_BILLTO_LBL', '', 'delimiter', 25, 30, 0, 6, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 0, 1, NULL),
(2, 'username', 'REGISTER_UNAME', '', 'text', 25, 30, 1, 3, 0, 0, '', 0, 1, 1, 0, 1, 0, 0, 1, 1, ''),
(35, 'address_type_name', 'PHPSHOP_USER_FORM_ADDRESS_LABEL', '', 'text', 32, 30, 1, 6, NULL, NULL, NULL, NULL, 1, 0, 1, 0, 0, 0, 1, 1, NULL),
(8, 'first_name', 'PHPSHOP_SHOPPER_FORM_FIRST_NAME', '', 'text', 32, 30, 1, 9, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(9, 'last_name', 'PHPSHOP_SHOPPER_FORM_LAST_NAME', '', 'text', 32, 30, 1, 10, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(10, 'middle_name', 'PHPSHOP_SHOPPER_FORM_MIDDLE_NAME', '', 'text', 32, 30, 0, 11, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(11, 'address_1', 'PHPSHOP_SHOPPER_FORM_ADDRESS_1', '', 'text', 64, 30, 1, 12, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(12, 'address_2', 'PHPSHOP_SHOPPER_FORM_ADDRESS_2', '', 'text', 64, 30, 0, 13, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(13, 'city', 'PHPSHOP_SHOPPER_FORM_CITY', '', 'text', 32, 30, 1, 14, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(14, 'zip', 'PHPSHOP_SHOPPER_FORM_ZIP', '', 'text', 32, 30, 1, 15, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(15, 'country', 'PHPSHOP_SHOPPER_FORM_COUNTRY', '', 'select', 0, 0, 1, 16, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(16, 'state', 'PHPSHOP_SHOPPER_FORM_STATE', '', 'select', 0, 0, 1, 17, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(17, 'phone_1', 'PHPSHOP_SHOPPER_FORM_PHONE', '', 'text', 32, 30, 1, 18, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(18, 'phone_2', 'PHPSHOP_SHOPPER_FORM_PHONE2', '', 'text', 32, 30, 0, 19, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(19, 'fax', 'PHPSHOP_SHOPPER_FORM_FAX', '', 'text', 32, 30, 0, 20, NULL, NULL, NULL, NULL, 1, 1, 1, 1, 0, 0, 1, 1, NULL),
(20, 'delimiter_bankaccount', 'PHPSHOP_ACCOUNT_BANK_TITLE', '', 'delimiter', 25, 30, 0, 21, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 0, 1, NULL),
(21, 'bank_account_holder', 'PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_HOLDER', '', 'text', 48, 30, 0, 22, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(22, 'bank_account_nr', 'PHPSHOP_ACCOUNT_LBL_BANK_ACCOUNT_NR', '', 'text', 32, 30, 0, 23, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(23, 'bank_sort_code', 'PHPSHOP_ACCOUNT_LBL_BANK_SORT_CODE', '', 'text', 16, 30, 0, 24, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(24, 'bank_name', 'PHPSHOP_ACCOUNT_LBL_BANK_NAME', '', 'text', 32, 30, 0, 25, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(25, 'bank_account_type', 'PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE', '', 'select', 0, 0, 0, 26, 0, 0, '', 0, 1, 0, 0, 1, 1, 0, 1, 1, ''),
(26, 'bank_iban', 'PHPSHOP_ACCOUNT_LBL_BANK_IBAN', '', 'text', 64, 30, 0, 27, NULL, NULL, NULL, NULL, 1, 0, 0, 1, 0, 0, 1, 1, NULL),
(27, 'delimiter_sendregistration', 'BUTTON_SEND_REG', '', 'delimiter', 25, 30, 0, 28, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, 0, 0, 1, NULL),
(28, 'agreed', 'PHPSHOP_I_AGREE_TO_TOS', '', 'checkbox', NULL, NULL, 1, 29, NULL, NULL, NULL, NULL, 1, 1, 0, 0, 0, 0, 1, 1, NULL),
(29, 'delimiter_userinfo', 'PHPSHOP_ORDER_PRINT_CUST_INFO_LBL', '', 'delimiter', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL, 1, 1, 0, 1, 0, 0, 0, 1, NULL),
(30, 'extra_field_1', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_1', '', 'text', 255, 30, 0, 31, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(31, 'extra_field_2', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_2', '', 'text', 255, 30, 0, 32, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(32, 'extra_field_3', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_3', '', 'text', 255, 30, 0, 33, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(33, 'extra_field_4', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_4', '', 'select', 1, 1, 0, 34, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL),
(34, 'extra_field_5', 'PHPSHOP_SHOPPER_FORM_EXTRA_FIELD_5', '', 'select', 1, 1, 0, 35, NULL, NULL, NULL, NULL, 0, 1, 0, 1, 0, 0, 0, 1, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_userfield_values`
--
CREATE TABLE `jos_vm_userfield_values` (
`fieldvalueid` int(11) NOT NULL auto_increment,
`fieldid` int(11) NOT NULL default '0',
`fieldtitle` varchar(255) NOT NULL default '',
`fieldvalue` varchar(255) NOT NULL,
`ordering` int(11) NOT NULL default '0',
`sys` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`fieldvalueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Holds the different values for dropdown and radio lists' AUTO_INCREMENT=4 ;
--
-- Dumping data for table `jos_vm_userfield_values`
--
INSERT INTO `jos_vm_userfield_values` (`fieldvalueid`, `fieldid`, `fieldtitle`, `fieldvalue`, `ordering`, `sys`) VALUES
(1, 25, 'PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE_BUSINESSCHECKING', 'Checking', 1, 1),
(2, 25, 'PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE_CHECKING', 'Business Checking', 2, 1),
(3, 25, 'PHPSHOP_ACCOUNT_LBL_ACCOUNT_TYPE_SAVINGS', 'Savings', 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_user_info`
--
CREATE TABLE `jos_vm_user_info` (
`user_info_id` varchar(32) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`address_type` char(2) default NULL,
`address_type_name` varchar(32) default NULL,
`company` varchar(64) default NULL,
`title` varchar(32) default NULL,
`last_name` varchar(32) default NULL,
`first_name` varchar(32) default NULL,
`middle_name` varchar(32) default NULL,
`phone_1` varchar(32) default NULL,
`phone_2` varchar(32) default NULL,
`fax` varchar(32) default NULL,
`address_1` varchar(64) NOT NULL default '',
`address_2` varchar(64) default NULL,
`city` varchar(32) NOT NULL default '',
`state` varchar(32) NOT NULL default '',
`country` varchar(32) NOT NULL default 'US',
`zip` varchar(32) NOT NULL default '',
`user_email` varchar(255) default NULL,
`extra_field_1` varchar(255) default NULL,
`extra_field_2` varchar(255) default NULL,
`extra_field_3` varchar(255) default NULL,
`extra_field_4` char(1) default NULL,
`extra_field_5` char(1) default NULL,
`cdate` int(11) default NULL,
`mdate` int(11) default NULL,
`perms` varchar(40) NOT NULL default 'shopper',
`bank_account_nr` varchar(32) NOT NULL default '',
`bank_name` varchar(32) NOT NULL default '',
`bank_sort_code` varchar(16) NOT NULL default '',
`bank_iban` varchar(64) NOT NULL default '',
`bank_account_holder` varchar(48) NOT NULL default '',
`bank_account_type` enum('Checking','Business Checking','Savings') NOT NULL default 'Checking',
PRIMARY KEY (`user_info_id`),
KEY `idx_user_info_user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Customer Information, BT = BillTo and ST = ShipTo';
--
-- Dumping data for table `jos_vm_user_info`
--
INSERT INTO `jos_vm_user_info` (`user_info_id`, `user_id`, `address_type`, `address_type_name`, `company`, `title`, `last_name`, `first_name`, `middle_name`, `phone_1`, `phone_2`, `fax`, `address_1`, `address_2`, `city`, `state`, `country`, `zip`, `user_email`, `extra_field_1`, `extra_field_2`, `extra_field_3`, `extra_field_4`, `extra_field_5`, `cdate`, `mdate`, `perms`, `bank_account_nr`, `bank_name`, `bank_sort_code`, `bank_iban`, `bank_account_holder`, `bank_account_type`) VALUES
('2539c833dd7e7ac1baf2c20184e03e59', 62, 'BT', NULL, 'a', '', 'a', 'a', '', 'a', '', '', 'a', '', 'a', ' - ', 'ZWE', 'a', 'a@a.com', NULL, NULL, NULL, NULL, NULL, 1223387653, 1223690659, 'shopper', '', '', '', '', '', 'Checking');
-- --------------------------------------------------------
--
-- Table structure for table `jos_vm_vendor`
--
CREATE TABLE `jos_vm_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 '',
`vendor_accepted_currencies` text NOT NULL,
`vendor_address_format` text NOT NULL,
`vendor_date_format` varchar(255) NOT NULL,
PRIMARY KEY (`vendor_id`),
KEY `idx_vendor_name` (`vendor_name`),
KEY `idx_vendor_category_id` (`vendor_category_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Vendors manage their products in your store' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_vm_vendor`
--
INSERT INTO `jos_vm_vendor` (`vendor_id`, `vendor_name`, `contact_last_name`, `contact_first_name`, `contact_middle_name`, `contact_title`, `contact_phone_1`, `contact_phone_2`, `contact_fax`, `contact_email`, `vendor_phone`, `vendor_address_1`, `vendor_address_2`, `vendor_city`, `vendor_state`, `vendor_country`, `vendor_zip`, `vendor_store_name`, `vendor_store_desc`, `vendor_category_id`, `vendor_thumb_image`, `vendor_full_image`, `vendor_currency`, `cdate`, `mdate`, `vendor_image_path`, `vendor_terms_of_service`, `vendor_url`, `vendor_min_pov`, `vendor_freeshipping`, `vendor_currency_display_style`, `vendor_accepted_currencies`, `vendor_address_format`, `vendor_date_format`) VALUES
(1, 'Washupito\\''s Tiendita', 'Owner', 'Demo', 'Store', 'Mr.', '555-555-1212', '555-555-1212', '555-555-1212', 'a@a.com', '555-555-1212', '100 Washupito Avenue, N.W.', '', 'Lake Forest', 'CA', 'USA', '92630', 'Washupito\\''s Tiendita', 'On this page you will see all the available first level categories in Virtuemart. Each customer\\''s name is the name of the category. The customer\\''s images are located within each category. The S5 Quick Category module at the top of the page lists the same categories.', 0, '', 'c19970d6f2970cb0d1b13bea3af3144a.gif', 'USD', 950302468, 1223518361, 'shop_image/', '
\n 