| for MySQL databases, by Hank Castello, CompuSolver.com | Download script (free) |
Sample data shown below for Joomla site with Virtuemart database
| jos_banner | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| bid | int(11) | NO | PRI | auto_increment | |
| cid | int(11) | NO | 0 | ||
| type | varchar(30) | NO | banner | ||
| name | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| imptotal | int(11) | NO | 0 | ||
| impmade | int(11) | NO | 0 | ||
| clicks | int(11) | NO | 0 | ||
| imageurl | varchar(100) | NO | |||
| clickurl | varchar(200) | NO | |||
| date | datetime | YES | |||
| showBanner | tinyint(1) | NO | MUL | 0 | |
| checked_out | tinyint(1) | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| editor | varchar(50) | YES | |||
| custombannercode | text | YES | |||
| catid | int(10) unsigned | NO | MUL | 0 | |
| description | text | NO | |||
| sticky | tinyint(1) unsigned | NO | 0 | ||
| ordering | int(11) | NO | 0 | ||
| publish_up | datetime | NO | 0000-00-00 00:00:00 | ||
| publish_down | datetime | NO | 0000-00-00 00:00:00 | ||
| tags | text | NO | |||
| params | text | NO |
| jos_bannerclient | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| cid | int(11) | NO | PRI | auto_increment | |
| name | varchar(255) | NO | |||
| contact | varchar(255) | NO | |||
| varchar(255) | NO | ||||
| extrainfo | text | NO | |||
| checked_out | tinyint(1) | NO | 0 | ||
| checked_out_time | time | YES | |||
| editor | varchar(50) | YES |
| jos_bannertrack | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| track_date | date | NO | |||
| track_type | int(10) unsigned | NO | |||
| banner_id | int(10) unsigned | NO |
| jos_categories | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| parent_id | int(11) | NO | 0 | ||
| title | varchar(255) | NO | |||
| name | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| image | varchar(255) | NO | |||
| section | varchar(50) | NO | MUL | ||
| image_position | varchar(30) | NO | |||
| description | text | NO | |||
| published | tinyint(1) | NO | 0 | ||
| checked_out | int(11) unsigned | NO | MUL | 0 | |
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| editor | varchar(50) | YES | |||
| ordering | int(11) | NO | 0 | ||
| access | tinyint(3) unsigned | NO | MUL | 0 | |
| count | int(11) | NO | 0 | ||
| params | text | NO |
| jos_components | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(50) | NO | |||
| link | varchar(255) | NO | |||
| menuid | int(11) unsigned | NO | 0 | ||
| parent | int(11) unsigned | NO | MUL | 0 | |
| admin_menu_link | varchar(255) | NO | |||
| admin_menu_alt | varchar(255) | NO | |||
| option | varchar(50) | NO | |||
| ordering | int(11) | NO | 0 | ||
| admin_menu_img | varchar(255) | NO | |||
| iscore | tinyint(4) | NO | 0 | ||
| params | text | NO | |||
| enabled | tinyint(4) | NO | 1 |
| jos_contact_details | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| con_position | varchar(255) | YES | |||
| address | text | YES | |||
| suburb | varchar(100) | YES | |||
| state | varchar(100) | YES | |||
| country | varchar(100) | YES | |||
| postcode | varchar(100) | YES | |||
| telephone | varchar(255) | YES | |||
| fax | varchar(255) | YES | |||
| misc | mediumtext | YES | |||
| image | varchar(255) | YES | |||
| imagepos | varchar(20) | YES | |||
| email_to | varchar(255) | YES | |||
| default_con | tinyint(1) unsigned | NO | 0 | ||
| published | tinyint(1) unsigned | NO | 0 | ||
| checked_out | int(11) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| ordering | int(11) | NO | 0 | ||
| params | text | NO | |||
| user_id | int(11) | NO | 0 | ||
| catid | int(11) | NO | MUL | 0 | |
| access | tinyint(3) unsigned | NO | 0 | ||
| mobile | varchar(255) | NO | |||
| webpage | varchar(255) | NO |
| jos_content | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| title | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| title_alias | varchar(255) | NO | |||
| introtext | mediumtext | NO | |||
| fulltext | mediumtext | NO | |||
| state | tinyint(3) | NO | MUL | 0 | |
| sectionid | int(11) unsigned | NO | MUL | 0 | |
| mask | int(11) unsigned | NO | 0 | ||
| catid | int(11) unsigned | NO | MUL | 0 | |
| created | datetime | NO | 0000-00-00 00:00:00 | ||
| created_by | int(11) unsigned | NO | MUL | 0 | |
| created_by_alias | varchar(255) | NO | |||
| modified | datetime | NO | 0000-00-00 00:00:00 | ||
| modified_by | int(11) unsigned | NO | 0 | ||
| checked_out | int(11) unsigned | NO | MUL | 0 | |
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| publish_up | datetime | NO | 0000-00-00 00:00:00 | ||
| publish_down | datetime | NO | 0000-00-00 00:00:00 | ||
| images | text | NO | |||
| urls | text | NO | |||
| attribs | text | NO | |||
| version | int(11) unsigned | NO | 1 | ||
| parentid | int(11) unsigned | NO | 0 | ||
| ordering | int(11) | NO | 0 | ||
| metakey | text | NO | |||
| metadesc | text | NO | |||
| access | int(11) unsigned | NO | MUL | 0 | |
| hits | int(11) unsigned | NO | 0 | ||
| metadata | text | NO |
| jos_content_frontpage | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| content_id | int(11) | NO | PRI | 0 | |
| ordering | int(11) | NO | 0 |
| jos_content_rating | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| content_id | int(11) | NO | PRI | 0 | |
| rating_sum | int(11) unsigned | NO | 0 | ||
| rating_count | int(11) unsigned | NO | 0 | ||
| lastip | varchar(50) | NO |
| jos_core_acl_aro | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| section_value | varchar(240) | NO | MUL | 0 | |
| value | varchar(240) | NO | |||
| order_value | int(11) | NO | 0 | ||
| name | varchar(255) | NO | |||
| hidden | int(11) | NO | MUL | 0 |
| jos_core_acl_aro_groups | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| parent_id | int(11) | NO | MUL | 0 | |
| name | varchar(255) | NO | |||
| lft | int(11) | NO | MUL | 0 | |
| rgt | int(11) | NO | 0 | ||
| value | varchar(255) | NO |
| jos_core_acl_aro_map | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| acl_id | int(11) | NO | PRI | 0 | |
| section_value | varchar(230) | NO | PRI | 0 | |
| value | varchar(100) | NO | PRI |
| jos_core_acl_aro_sections | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| value | varchar(230) | NO | UNI | ||
| order_value | int(11) | NO | 0 | ||
| name | varchar(230) | NO | |||
| hidden | int(11) | NO | MUL | 0 |
| jos_core_acl_groups_aro_map | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| group_id | int(11) | NO | PRI | 0 | |
| section_value | varchar(240) | NO | PRI | ||
| aro_id | int(11) | NO | PRI | 0 |
| jos_core_log_items | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| time_stamp | date | NO | 0000-00-00 | ||
| item_table | varchar(50) | NO | |||
| item_id | int(11) unsigned | NO | 0 | ||
| hits | int(11) unsigned | NO | 0 |
| jos_core_log_searches | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| search_term | varchar(128) | NO | |||
| hits | int(11) unsigned | NO | 0 |
| jos_groups | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | tinyint(3) unsigned | NO | PRI | 0 | |
| name | varchar(50) | NO |
| jos_jcomments | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| parent | int(11) unsigned | NO | 0 | ||
| object_id | int(11) unsigned | NO | MUL | 0 | |
| object_group | varchar(255) | NO | |||
| object_params | text | NO | |||
| lang | varchar(255) | NO | MUL | ||
| userid | int(11) unsigned | NO | MUL | 0 | |
| name | varchar(255) | NO | |||
| username | varchar(255) | NO | |||
| varchar(255) | NO | MUL | |||
| homepage | varchar(255) | NO | |||
| title | varchar(255) | NO | |||
| comment | text | NO | |||
| ip | varchar(15) | NO | |||
| date | datetime | NO | 0000-00-00 00:00:00 | ||
| isgood | smallint(5) unsigned | NO | 0 | ||
| ispoor | smallint(5) unsigned | NO | 0 | ||
| published | tinyint(1) unsigned | NO | 0 | ||
| subscribe | tinyint(1) unsigned | NO | MUL | 0 | |
| source | varchar(255) | NO | MUL | ||
| checked_out | int(11) unsigned | NO | MUL | 0 | |
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| editor | varchar(50) | NO |
| jos_jcomments_custom_bbcodes | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| name | varchar(32) | NO | |||
| simple_pattern | varchar(255) | NO | |||
| simple_replacement_html | text | NO | |||
| simple_replacement_text | text | NO | |||
| pattern | varchar(255) | NO | |||
| replacement_html | text | NO | |||
| replacement_text | text | NO | |||
| button_acl | text | NO | |||
| button_open_tag | varchar(16) | NO | |||
| button_close_tag | varchar(16) | NO | |||
| button_title | varchar(255) | NO | |||
| button_prompt | varchar(255) | NO | |||
| button_image | varchar(255) | NO | |||
| button_css | varchar(255) | NO | |||
| button_enabled | tinyint(1) unsigned | NO | 0 | ||
| ordering | int(11) unsigned | NO | 0 | ||
| published | tinyint(1) unsigned | NO | 0 |
| jos_jcomments_settings | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| component | varchar(50) | NO | PRI | ||
| lang | varchar(20) | NO | PRI | ||
| name | varchar(50) | NO | PRI | ||
| value | text | NO |
| jos_jcomments_subscriptions | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| object_id | int(11) unsigned | NO | MUL | 0 | |
| object_group | varchar(255) | NO | |||
| lang | varchar(255) | NO | MUL | ||
| userid | int(11) unsigned | NO | 0 | ||
| name | varchar(255) | NO | |||
| varchar(255) | NO | ||||
| hash | varchar(255) | NO | MUL | ||
| published | tinyint(1) unsigned | NO | 0 |
| jos_jcomments_version | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| version | varchar(16) | NO | PRI | ||
| previous | varchar(16) | NO | |||
| installed | datetime | NO | 0000-00-00 00:00:00 | ||
| updated | datetime | NO | 0000-00-00 00:00:00 |
| jos_jcomments_votes | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| commentid | int(11) unsigned | NO | MUL | 0 | |
| userid | int(11) unsigned | NO | 0 | ||
| ip | varchar(15) | NO | |||
| date | datetime | NO | 0000-00-00 00:00:00 | ||
| value | tinyint(1) | NO |
| jos_menu | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| menutype | varchar(75) | YES | MUL | ||
| name | varchar(255) | YES | |||
| alias | varchar(255) | NO | |||
| link | text | YES | |||
| type | varchar(50) | NO | |||
| published | tinyint(1) | NO | 0 | ||
| parent | int(11) unsigned | NO | 0 | ||
| componentid | int(11) unsigned | NO | MUL | 0 | |
| sublevel | int(11) | YES | 0 | ||
| ordering | int(11) | YES | 0 | ||
| checked_out | int(11) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| pollid | int(11) | NO | 0 | ||
| browserNav | tinyint(4) | YES | 0 | ||
| access | tinyint(3) unsigned | NO | 0 | ||
| utaccess | tinyint(3) unsigned | NO | 0 | ||
| params | text | NO | |||
| lft | int(11) unsigned | NO | 0 | ||
| rgt | int(11) unsigned | NO | 0 | ||
| home | int(1) unsigned | NO | 0 |
| jos_menu_types | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(10) unsigned | NO | PRI | auto_increment | |
| menutype | varchar(75) | NO | UNI | ||
| title | varchar(255) | NO | |||
| description | varchar(255) | NO |
| jos_messages | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| message_id | int(10) unsigned | NO | PRI | auto_increment | |
| user_id_from | int(10) unsigned | NO | 0 | ||
| user_id_to | int(10) unsigned | NO | MUL | 0 | |
| folder_id | int(10) unsigned | NO | 0 | ||
| date_time | datetime | NO | 0000-00-00 00:00:00 | ||
| state | int(11) | NO | 0 | ||
| priority | int(1) unsigned | NO | 0 | ||
| subject | text | NO | |||
| message | text | NO |
| jos_messages_cfg | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_id | int(10) unsigned | NO | PRI | 0 | |
| cfg_name | varchar(100) | NO | PRI | ||
| cfg_value | varchar(255) | NO |
| jos_migration_backlinks | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| itemid | int(11) | NO | PRI | ||
| name | varchar(100) | NO | |||
| url | text | NO | |||
| sefurl | text | NO | |||
| newurl | text | NO |
| jos_modules | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| title | text | NO | |||
| content | text | NO | |||
| ordering | int(11) | NO | 0 | ||
| position | varchar(50) | YES | |||
| checked_out | int(11) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| published | tinyint(1) | NO | MUL | 0 | |
| module | varchar(50) | YES | MUL | ||
| numnews | int(11) | NO | 0 | ||
| access | tinyint(3) unsigned | NO | 0 | ||
| showtitle | tinyint(3) unsigned | NO | 1 | ||
| params | text | NO | |||
| iscore | tinyint(4) | NO | 0 | ||
| client_id | tinyint(4) | NO | 0 | ||
| control | text | NO |
| jos_modules_menu | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| moduleid | int(11) | NO | PRI | 0 | |
| menuid | int(11) | NO | PRI | 0 |
| jos_newsfeeds | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| catid | int(11) | NO | MUL | 0 | |
| id | int(11) | NO | PRI | auto_increment | |
| name | text | NO | |||
| alias | varchar(255) | NO | |||
| link | text | NO | |||
| filename | varchar(200) | YES | |||
| published | tinyint(1) | NO | MUL | 0 | |
| numarticles | int(11) unsigned | NO | 1 | ||
| cache_time | int(11) unsigned | NO | 3600 | ||
| checked_out | tinyint(3) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| ordering | int(11) | NO | 0 | ||
| rtl | tinyint(4) | NO | 0 |
| jos_plugins | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(100) | NO | |||
| element | varchar(100) | NO | |||
| folder | varchar(100) | NO | |||
| access | tinyint(3) unsigned | NO | 0 | ||
| ordering | int(11) | NO | 0 | ||
| published | tinyint(3) | NO | MUL | 0 | |
| iscore | tinyint(3) | NO | 0 | ||
| client_id | tinyint(3) | NO | 0 | ||
| checked_out | int(11) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| params | text | NO |
| jos_poll_data | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| pollid | int(11) | NO | MUL | 0 | |
| text | text | NO | |||
| hits | int(11) | NO | 0 |
| jos_poll_date | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | bigint(20) | NO | PRI | auto_increment | |
| date | datetime | NO | 0000-00-00 00:00:00 | ||
| vote_id | int(11) | NO | 0 | ||
| poll_id | int(11) | NO | MUL | 0 |
| jos_poll_menu | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| pollid | int(11) | NO | PRI | 0 | |
| menuid | int(11) | NO | PRI | 0 |
| jos_polls | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| title | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| voters | int(9) | NO | 0 | ||
| checked_out | int(11) | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| published | tinyint(1) | NO | 0 | ||
| access | int(11) | NO | 0 | ||
| lag | int(11) | NO | 0 |
| jos_rokcandy | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| catid | int(11) | NO | |||
| macro | text | NO | |||
| html | text | NO | |||
| published | tinyint(1) | NO | |||
| checked_out | int(11) | NO | |||
| checked_out_time | datetime | NO | |||
| ordering | int(11) | NO | |||
| params | text | NO |
| jos_sections | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| title | varchar(255) | NO | |||
| name | varchar(255) | NO | |||
| alias | varchar(255) | NO | |||
| image | text | NO | |||
| scope | varchar(50) | NO | MUL | ||
| image_position | varchar(30) | NO | |||
| description | text | NO | |||
| published | tinyint(1) | NO | 0 | ||
| checked_out | int(11) unsigned | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| ordering | int(11) | NO | 0 | ||
| access | tinyint(3) unsigned | NO | 0 | ||
| count | int(11) | NO | 0 | ||
| params | text | NO |
| jos_session | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| username | varchar(150) | YES | |||
| time | varchar(14) | YES | MUL | ||
| session_id | varchar(200) | NO | PRI | 0 | |
| guest | tinyint(4) | YES | MUL | 1 | |
| userid | int(11) | YES | MUL | 0 | |
| usertype | varchar(50) | YES | |||
| gid | tinyint(3) unsigned | NO | 0 | ||
| client_id | tinyint(3) unsigned | NO | 0 | ||
| data | longtext | YES |
| jos_stats_agents | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| agent | varchar(255) | NO | |||
| type | tinyint(1) unsigned | NO | 0 | ||
| hits | int(11) unsigned | NO | 1 |
| jos_templates_menu | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| template | varchar(255) | NO | PRI | ||
| menuid | int(11) | NO | PRI | 0 | |
| client_id | tinyint(4) | NO | PRI | 0 |
| jos_users | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) | NO | PRI | auto_increment | |
| name | varchar(255) | NO | MUL | ||
| username | varchar(150) | NO | MUL | ||
| varchar(100) | NO | MUL | |||
| password | varchar(100) | NO | |||
| usertype | varchar(25) | NO | MUL | ||
| block | tinyint(4) | NO | 0 | ||
| sendEmail | tinyint(4) | YES | 0 | ||
| gid | tinyint(3) unsigned | NO | MUL | 1 | |
| registerDate | datetime | NO | 0000-00-00 00:00:00 | ||
| lastvisitDate | datetime | NO | 0000-00-00 00:00:00 | ||
| activation | varchar(100) | NO | |||
| params | text | NO |
| jos_vm_auth_group | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| group_id | int(11) | NO | PRI | auto_increment | |
| group_name | varchar(128) | YES | |||
| group_level | int(11) | YES |
| jos_vm_auth_user_group | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_id | int(11) | NO | PRI | 0 | |
| group_id | int(11) | YES |
| jos_vm_auth_user_vendor | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_id | int(11) | YES | MUL | ||
| vendor_id | int(11) | YES | MUL |
| jos_vm_cart | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_id | int(11) | NO | PRI | ||
| cart_content | text | NO | |||
| last_updated | timestamp | NO | CURRENT_TIMESTAMP |
| jos_vm_category | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| category_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | NO | MUL | 0 | |
| category_name | varchar(128) | NO | MUL | ||
| category_description | text | YES | |||
| category_thumb_image | varchar(255) | YES | |||
| category_full_image | varchar(255) | YES | |||
| category_publish | char(1) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| category_browsepage | varchar(255) | NO | browse_1 | ||
| products_per_row | tinyint(2) | NO | 1 | ||
| category_flypage | varchar(255) | YES | |||
| list_order | int(11) | YES |
| jos_vm_category_xref | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| category_parent_id | int(11) | NO | MUL | 0 | |
| category_child_id | int(11) | NO | PRI | 0 | |
| category_list | int(11) | YES | MUL |
| jos_vm_country | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| country_id | int(11) | NO | PRI | auto_increment | |
| zone_id | int(11) | NO | 1 | ||
| country_name | varchar(64) | YES | MUL | ||
| country_3_code | char(3) | YES | |||
| country_2_code | char(2) | YES |
| jos_vm_coupons | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| coupon_id | int(16) | NO | PRI | auto_increment | |
| coupon_code | varchar(32) | NO | |||
| percent_or_total | enum('percent','total') | NO | percent | ||
| coupon_type | enum('gift','permanent') | NO | gift | ||
| coupon_value | decimal(12,2) | NO | 0.00 |
| jos_vm_creditcard | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| creditcard_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | NO | 0 | ||
| creditcard_name | varchar(70) | NO | |||
| creditcard_code | varchar(30) | NO |
| jos_vm_csv | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| field_id | int(11) | NO | PRI | auto_increment | |
| field_name | varchar(128) | NO | |||
| field_default_value | text | YES | |||
| field_ordering | int(3) | NO | 0 | ||
| field_required | char(1) | YES | N |
| jos_vm_currency | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| currency_id | int(11) | NO | PRI | auto_increment | |
| currency_name | varchar(64) | YES | MUL | ||
| currency_code | char(3) | YES |
| jos_vm_export | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| export_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | YES | |||
| export_name | varchar(255) | YES | |||
| export_desc | text | NO | |||
| export_class | varchar(50) | NO | |||
| export_enabled | char(1) | NO | N | ||
| export_config | text | NO | |||
| iscore | tinyint(3) | NO | 0 |
| jos_vm_function | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| function_id | int(11) | NO | PRI | auto_increment | |
| module_id | int(11) | YES | MUL | ||
| function_name | varchar(32) | YES | MUL | ||
| function_class | varchar(32) | YES | |||
| function_method | varchar(32) | YES | |||
| function_description | text | YES | |||
| function_perms | varchar(255) | YES |
| jos_vm_manufacturer | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| manufacturer_id | int(11) | NO | PRI | auto_increment | |
| mf_name | varchar(64) | YES | |||
| mf_email | varchar(255) | YES | |||
| mf_desc | text | YES | |||
| mf_category_id | int(11) | YES | |||
| mf_url | varchar(255) | NO |
| jos_vm_manufacturer_category | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| mf_category_id | int(11) | NO | PRI | auto_increment | |
| mf_category_name | varchar(64) | YES | MUL | ||
| mf_category_desc | text | YES |
| jos_vm_module | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| module_id | int(11) | NO | PRI | auto_increment | |
| module_name | varchar(255) | YES | MUL | ||
| module_description | text | YES | |||
| module_perms | varchar(255) | YES | |||
| module_publish | char(1) | YES | |||
| list_order | int(11) | YES | MUL |
| jos_vm_order_history | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_status_history_id | int(11) | NO | PRI | auto_increment | |
| order_id | int(11) | NO | 0 | ||
| order_status_code | char(1) | NO | 0 | ||
| date_added | datetime | NO | 0000-00-00 00:00:00 | ||
| customer_notified | int(1) | YES | 0 | ||
| comments | text | YES |
| jos_vm_order_item | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_item_id | int(11) | NO | PRI | auto_increment | |
| order_id | int(11) | YES | MUL | ||
| user_info_id | varchar(32) | YES | MUL | ||
| vendor_id | int(11) | YES | MUL | ||
| product_id | int(11) | YES | |||
| order_item_sku | varchar(64) | NO | |||
| order_item_name | varchar(64) | NO | |||
| product_quantity | int(11) | YES | |||
| product_item_price | decimal(15,5) | YES | |||
| product_final_price | decimal(12,2) | NO | 0.00 | ||
| order_item_currency | varchar(16) | YES | |||
| order_status | char(1) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| product_attribute | text | YES |
| jos_vm_order_payment | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_id | int(11) | NO | MUL | 0 | |
| payment_method_id | int(11) | YES | MUL | ||
| order_payment_code | varchar(30) | NO | |||
| order_payment_number | blob | YES | |||
| order_payment_expire | int(11) | YES | |||
| order_payment_name | varchar(255) | YES | |||
| order_payment_log | text | YES | |||
| order_payment_trans_id | text | NO |
| jos_vm_order_status | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_status_id | int(11) | NO | PRI | auto_increment | |
| order_status_code | char(1) | NO | |||
| order_status_name | varchar(64) | YES | |||
| order_status_description | text | NO | |||
| list_order | int(11) | YES | MUL | ||
| vendor_id | int(11) | YES | MUL |
| jos_vm_order_user_info | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_info_id | int(11) | NO | PRI | auto_increment | |
| order_id | int(11) | NO | MUL | 0 | |
| user_id | int(11) | NO | 0 | ||
| address_type | char(2) | YES | |||
| address_type_name | varchar(32) | YES | |||
| company | varchar(64) | YES | |||
| title | varchar(32) | YES | |||
| last_name | varchar(32) | YES | |||
| first_name | varchar(32) | YES | |||
| middle_name | varchar(32) | YES | |||
| phone_1 | varchar(32) | YES | |||
| phone_2 | varchar(32) | YES | |||
| fax | varchar(32) | YES | |||
| address_1 | varchar(64) | NO | |||
| address_2 | varchar(64) | YES | |||
| city | varchar(32) | NO | |||
| state | varchar(32) | NO | |||
| country | varchar(32) | NO | US | ||
| zip | varchar(32) | NO | |||
| user_email | varchar(255) | YES | |||
| extra_field_1 | varchar(255) | YES | |||
| extra_field_2 | varchar(255) | YES | |||
| extra_field_3 | varchar(255) | YES | |||
| extra_field_4 | char(1) | YES | |||
| extra_field_5 | char(1) | YES | |||
| bank_account_nr | varchar(32) | NO | |||
| bank_name | varchar(32) | NO | |||
| bank_sort_code | varchar(16) | NO | |||
| bank_iban | varchar(64) | NO | |||
| bank_account_holder | varchar(48) | NO | |||
| bank_account_type | enum('Checking','Business Checking','Savings') | NO | Checking |
| jos_vm_orders | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_id | int(11) | NO | PRI | auto_increment | |
| user_id | int(11) | NO | MUL | 0 | |
| vendor_id | int(11) | NO | MUL | 0 | |
| order_number | varchar(32) | YES | MUL | ||
| user_info_id | varchar(32) | YES | MUL | ||
| order_total | decimal(15,5) | NO | 0.00000 | ||
| order_subtotal | decimal(15,5) | YES | |||
| order_tax | decimal(10,2) | YES | |||
| order_tax_details | text | NO | |||
| order_shipping | decimal(10,2) | YES | |||
| order_shipping_tax | decimal(10,2) | YES | |||
| coupon_discount | decimal(12,2) | NO | 0.00 | ||
| coupon_code | varchar(32) | YES | |||
| order_discount | decimal(12,2) | NO | 0.00 | ||
| order_currency | varchar(16) | YES | |||
| order_status | char(1) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| ship_method_id | varchar(255) | YES | MUL | ||
| customer_note | text | NO | |||
| ip_address | varchar(15) | NO |
| jos_vm_payment_method | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| payment_method_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | YES | MUL | ||
| payment_method_name | varchar(255) | YES | MUL | ||
| payment_class | varchar(50) | NO | |||
| shopper_group_id | int(11) | YES | MUL | ||
| payment_method_discount | decimal(12,2) | YES | |||
| payment_method_discount_is_percent | tinyint(1) | NO | |||
| payment_method_discount_max_amount | decimal(10,2) | NO | |||
| payment_method_discount_min_amount | decimal(10,2) | NO | |||
| list_order | int(11) | YES | MUL | ||
| payment_method_code | varchar(8) | YES | |||
| enable_processor | char(1) | YES | |||
| is_creditcard | tinyint(1) | NO | 0 | ||
| payment_enabled | char(1) | NO | N | ||
| accepted_creditcards | varchar(128) | NO | |||
| payment_extrainfo | text | NO | |||
| payment_passkey | blob | NO |
| jos_vm_product | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | NO | MUL | 0 | |
| product_parent_id | int(11) | NO | MUL | 0 | |
| product_sku | varchar(64) | NO | MUL | ||
| product_s_desc | varchar(255) | YES | |||
| product_desc | text | YES | |||
| product_thumb_image | varchar(255) | YES | |||
| product_full_image | varchar(255) | YES | |||
| product_publish | char(1) | YES | |||
| product_weight | decimal(10,4) | YES | |||
| product_weight_uom | varchar(32) | YES | pounds. | ||
| product_length | decimal(10,4) | YES | |||
| product_width | decimal(10,4) | YES | |||
| product_height | decimal(10,4) | YES | |||
| product_lwh_uom | varchar(32) | YES | inches | ||
| product_url | varchar(255) | YES | |||
| product_in_stock | int(11) | NO | 0 | ||
| product_available_date | int(11) | YES | |||
| product_availability | varchar(56) | NO | |||
| product_special | char(1) | YES | |||
| product_discount_id | int(11) | YES | |||
| ship_code_id | int(11) | YES | MUL | ||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| product_name | varchar(64) | YES | MUL | ||
| product_sales | int(11) | NO | 0 | ||
| attribute | text | YES | |||
| custom_attribute | text | NO | |||
| product_tax_id | int(11) | YES | |||
| product_unit | varchar(32) | YES | |||
| product_packaging | int(11) | YES | |||
| child_options | varchar(45) | YES | |||
| quantity_options | varchar(45) | YES | |||
| child_option_ids | varchar(45) | YES | |||
| product_order_levels | varchar(45) | YES |
| jos_vm_product_attribute | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| attribute_id | int(11) | NO | PRI | auto_increment | |
| product_id | int(11) | NO | MUL | 0 | |
| attribute_name | char(255) | NO | MUL | ||
| attribute_value | char(255) | NO |
| jos_vm_product_attribute_sku | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | NO | MUL | 0 | |
| attribute_name | char(255) | NO | MUL | ||
| attribute_list | int(11) | NO | MUL | 0 |
| jos_vm_product_category_xref | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| category_id | int(11) | NO | MUL | 0 | |
| product_id | int(11) | NO | MUL | 0 | |
| product_list | int(11) | YES | MUL |
| jos_vm_product_discount | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| discount_id | int(11) | NO | PRI | auto_increment | |
| amount | decimal(12,2) | NO | 0.00 | ||
| is_percent | tinyint(1) | NO | 0 | ||
| start_date | int(11) | NO | 0 | ||
| end_date | int(11) | NO | 0 |
| jos_vm_product_download | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | NO | 0 | ||
| user_id | int(11) | NO | 0 | ||
| order_id | int(11) | NO | 0 | ||
| end_date | int(11) | NO | 0 | ||
| download_max | int(11) | NO | 0 | ||
| download_id | varchar(32) | NO | PRI | ||
| file_name | varchar(255) | NO |
| jos_vm_product_files | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| file_id | int(19) | NO | PRI | auto_increment | |
| file_product_id | int(11) | NO | 0 | ||
| file_name | varchar(128) | NO | |||
| file_title | varchar(128) | NO | |||
| file_description | mediumtext | NO | |||
| file_extension | varchar(128) | NO | |||
| file_mimetype | varchar(64) | NO | |||
| file_url | varchar(254) | NO | |||
| file_published | tinyint(1) | NO | 0 | ||
| file_is_image | tinyint(1) | NO | 0 | ||
| file_image_height | int(11) | NO | 0 | ||
| file_image_width | int(11) | NO | 0 | ||
| file_image_thumb_height | int(11) | NO | 50 | ||
| file_image_thumb_width | int(11) | NO | 0 |
| jos_vm_product_mf_xref | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | YES | MUL | ||
| manufacturer_id | int(11) | YES | MUL |
| jos_vm_product_price | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_price_id | int(11) | NO | PRI | auto_increment | |
| product_id | int(11) | NO | MUL | 0 | |
| product_price | decimal(12,5) | YES | |||
| product_currency | char(16) | YES | |||
| product_price_vdate | int(11) | YES | |||
| product_price_edate | int(11) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| shopper_group_id | int(11) | YES | MUL | ||
| price_quantity_start | int(11) unsigned | NO | 0 | ||
| price_quantity_end | int(11) unsigned | NO | 0 |
| jos_vm_product_product_type_xref | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | NO | MUL | 0 | |
| product_type_id | int(11) | NO | MUL | 0 |
| jos_vm_product_relations | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(11) | NO | PRI | 0 | |
| related_products | text | YES |
| jos_vm_product_reviews | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| review_id | int(11) | NO | PRI | auto_increment | |
| product_id | int(11) | NO | MUL | 0 | |
| comment | text | NO | |||
| userid | int(11) | NO | 0 | ||
| time | int(11) | NO | 0 | ||
| user_rating | tinyint(1) | NO | 0 | ||
| review_ok | int(11) | NO | 0 | ||
| review_votes | int(11) | NO | 0 | ||
| published | char(1) | NO | Y |
| jos_vm_product_type | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_type_id | int(11) | NO | PRI | auto_increment | |
| product_type_name | varchar(255) | NO | |||
| product_type_description | text | YES | |||
| product_type_publish | char(1) | YES | |||
| product_type_browsepage | varchar(255) | YES | |||
| product_type_flypage | varchar(255) | YES | |||
| product_type_list_order | int(11) | YES |
| jos_vm_product_type_parameter | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_type_id | int(11) | NO | PRI | 0 | |
| parameter_name | varchar(255) | NO | PRI | ||
| parameter_label | varchar(255) | NO | |||
| parameter_description | text | YES | |||
| parameter_list_order | int(11) | NO | MUL | 0 | |
| parameter_type | char(1) | NO | T | ||
| parameter_values | varchar(255) | YES | |||
| parameter_multiselect | char(1) | YES | |||
| parameter_default | varchar(255) | YES | |||
| parameter_unit | varchar(32) | YES |
| jos_vm_product_votes | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| product_id | int(255) | NO | PRI | 0 | |
| votes | text | NO | |||
| allvotes | int(11) | NO | 0 | ||
| rating | tinyint(1) | NO | 0 | ||
| lastip | varchar(50) | NO | 0 |
| jos_vm_shipping_carrier | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| shipping_carrier_id | int(11) | NO | PRI | auto_increment | |
| shipping_carrier_name | char(80) | NO | |||
| shipping_carrier_list_order | int(11) | NO | 0 |
| jos_vm_shipping_label | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| order_id | int(11) | NO | PRI | 0 | |
| shipper_class | varchar(32) | YES | |||
| ship_date | varchar(32) | YES | |||
| service_code | varchar(32) | YES | |||
| special_service | varchar(32) | YES | |||
| package_type | varchar(16) | YES | |||
| order_weight | decimal(10,2) | YES | |||
| is_international | tinyint(1) | YES | |||
| additional_protection_type | varchar(16) | YES | |||
| additional_protection_value | decimal(10,2) | YES | |||
| duty_value | decimal(10,2) | YES | |||
| content_desc | varchar(255) | YES | |||
| label_is_generated | tinyint(1) | NO | 0 | ||
| tracking_number | varchar(32) | YES | |||
| label_image | blob | YES | |||
| have_signature | tinyint(1) | NO | 0 | ||
| signature_image | blob | YES |
| jos_vm_shipping_rate | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| shipping_rate_id | int(11) | NO | PRI | auto_increment | |
| shipping_rate_name | varchar(255) | NO | |||
| shipping_rate_carrier_id | int(11) | NO | 0 | ||
| shipping_rate_country | text | NO | |||
| shipping_rate_zip_start | varchar(32) | NO | |||
| shipping_rate_zip_end | varchar(32) | NO | |||
| shipping_rate_weight_start | decimal(10,3) | NO | 0.000 | ||
| shipping_rate_weight_end | decimal(10,3) | NO | 0.000 | ||
| shipping_rate_value | decimal(10,2) | NO | 0.00 | ||
| shipping_rate_package_fee | decimal(10,2) | NO | 0.00 | ||
| shipping_rate_currency_id | int(11) | NO | 0 | ||
| shipping_rate_vat_id | int(11) | NO | 0 | ||
| shipping_rate_list_order | int(11) | NO | 0 |
| jos_vm_shopper_group | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| shopper_group_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | YES | MUL | ||
| shopper_group_name | varchar(32) | YES | MUL | ||
| shopper_group_desc | text | YES | |||
| shopper_group_discount | decimal(5,2) | NO | 0.00 | ||
| show_price_including_tax | tinyint(1) | NO | 1 | ||
| default | tinyint(1) | NO | 0 |
| jos_vm_shopper_vendor_xref | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_id | int(11) | YES | MUL | ||
| vendor_id | int(11) | YES | MUL | ||
| shopper_group_id | int(11) | YES | MUL | ||
| customer_number | varchar(32) | YES |
| jos_vm_state | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| state_id | int(11) | NO | PRI | auto_increment | |
| country_id | int(11) | NO | MUL | 1 | |
| state_name | varchar(64) | YES | |||
| state_3_code | char(3) | YES | |||
| state_2_code | char(2) | YES |
| jos_vm_tax_rate | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| tax_rate_id | int(11) | NO | PRI | auto_increment | |
| vendor_id | int(11) | YES | MUL | ||
| tax_state | varchar(64) | YES | |||
| tax_country | varchar(64) | YES | |||
| mdate | int(11) | YES | |||
| tax_rate | decimal(10,5) | YES |
| jos_vm_user_info | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| user_info_id | varchar(32) | NO | PRI | ||
| user_id | int(11) | NO | MUL | 0 | |
| address_type | char(2) | YES | |||
| address_type_name | varchar(32) | YES | |||
| company | varchar(64) | YES | |||
| title | varchar(32) | YES | |||
| last_name | varchar(32) | YES | |||
| first_name | varchar(32) | YES | |||
| middle_name | varchar(32) | YES | |||
| phone_1 | varchar(32) | YES | |||
| phone_2 | varchar(32) | YES | |||
| fax | varchar(32) | YES | |||
| address_1 | varchar(64) | NO | |||
| address_2 | varchar(64) | YES | |||
| city | varchar(32) | NO | |||
| state | varchar(32) | NO | |||
| country | varchar(32) | NO | US | ||
| zip | varchar(32) | NO | |||
| user_email | varchar(255) | YES | |||
| extra_field_1 | varchar(255) | YES | |||
| extra_field_2 | varchar(255) | YES | |||
| extra_field_3 | varchar(255) | YES | |||
| extra_field_4 | char(1) | YES | |||
| extra_field_5 | char(1) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| perms | varchar(40) | NO | shopper | ||
| bank_account_nr | varchar(32) | NO | |||
| bank_name | varchar(32) | NO | |||
| bank_sort_code | varchar(16) | NO | |||
| bank_iban | varchar(64) | NO | |||
| bank_account_holder | varchar(48) | NO | |||
| bank_account_type | enum('Checking','Business Checking','Savings') | NO | Checking |
| jos_vm_userfield | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| fieldid | int(11) | NO | PRI | auto_increment | |
| name | varchar(50) | NO | |||
| title | varchar(255) | NO | |||
| description | mediumtext | NO | |||
| type | varchar(50) | NO | |||
| maxlength | int(11) | YES | |||
| size | int(11) | YES | |||
| required | tinyint(4) | YES | 0 | ||
| ordering | int(11) | YES | |||
| cols | int(11) | YES | |||
| rows | int(11) | YES | |||
| value | varchar(50) | YES | |||
| default | int(11) | YES | |||
| published | tinyint(1) | NO | 1 | ||
| registration | tinyint(1) | NO | 0 | ||
| shipping | tinyint(1) | NO | 0 | ||
| account | tinyint(1) | NO | 1 | ||
| readonly | tinyint(1) | NO | 0 | ||
| calculated | tinyint(1) | NO | 0 | ||
| sys | tinyint(4) | NO | 0 | ||
| vendor_id | int(11) | YES | |||
| params | mediumtext | YES |
| jos_vm_userfield_values | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| fieldvalueid | int(11) | NO | PRI | auto_increment | |
| fieldid | int(11) | NO | 0 | ||
| fieldtitle | varchar(255) | NO | |||
| fieldvalue | varchar(255) | NO | |||
| ordering | int(11) | NO | 0 | ||
| sys | tinyint(4) | NO | 0 |
| jos_vm_vendor | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| vendor_id | int(11) | NO | PRI | auto_increment | |
| vendor_name | varchar(64) | YES | MUL | ||
| contact_last_name | varchar(32) | NO | |||
| contact_first_name | varchar(32) | NO | |||
| contact_middle_name | varchar(32) | YES | |||
| contact_title | varchar(32) | YES | |||
| contact_phone_1 | varchar(32) | NO | |||
| contact_phone_2 | varchar(32) | YES | |||
| contact_fax | varchar(32) | YES | |||
| contact_email | varchar(255) | YES | |||
| vendor_phone | varchar(32) | YES | |||
| vendor_address_1 | varchar(64) | NO | |||
| vendor_address_2 | varchar(64) | YES | |||
| vendor_city | varchar(32) | NO | |||
| vendor_state | varchar(32) | NO | |||
| vendor_country | varchar(32) | NO | US | ||
| vendor_zip | varchar(32) | NO | |||
| vendor_store_name | varchar(128) | NO | |||
| vendor_store_desc | text | YES | |||
| vendor_category_id | int(11) | YES | MUL | ||
| vendor_thumb_image | varchar(255) | YES | |||
| vendor_full_image | varchar(255) | YES | |||
| vendor_currency | varchar(16) | YES | |||
| cdate | int(11) | YES | |||
| mdate | int(11) | YES | |||
| vendor_image_path | varchar(255) | YES | |||
| vendor_terms_of_service | text | NO | |||
| vendor_url | varchar(255) | NO | |||
| vendor_min_pov | decimal(10,2) | YES | |||
| vendor_freeshipping | decimal(10,2) | NO | 0.00 | ||
| vendor_currency_display_style | varchar(64) | NO | |||
| vendor_accepted_currencies | text | NO | |||
| vendor_address_format | text | NO | |||
| vendor_date_format | varchar(255) | NO |
| jos_vm_vendor_category | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| vendor_category_id | int(11) | NO | PRI | auto_increment | |
| vendor_category_name | varchar(64) | YES | MUL | ||
| vendor_category_desc | text | YES |
| jos_vm_waiting_list | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| waiting_list_id | int(11) | NO | PRI | auto_increment | |
| product_id | int(11) | NO | MUL | 0 | |
| user_id | int(11) | NO | 0 | ||
| notify_email | varchar(150) | NO | MUL | ||
| notified | enum('0','1') | YES | 0 | ||
| notify_date | timestamp | NO | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| jos_vm_zone_shipping | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| zone_id | int(11) | NO | PRI | auto_increment | |
| zone_name | varchar(255) | YES | |||
| zone_cost | decimal(10,2) | YES | |||
| zone_limit | decimal(10,2) | YES | |||
| zone_description | text | NO | |||
| zone_tax_rate | int(11) | NO | 0 |
| jos_weblinks | |
| Fields |
| Field | Type | Null | Index | Default | Extra |
| id | int(11) unsigned | NO | PRI | auto_increment | |
| catid | int(11) | NO | MUL | 0 | |
| sid | int(11) | NO | 0 | ||
| title | varchar(250) | NO | |||
| alias | varchar(255) | NO | |||
| url | varchar(250) | NO | |||
| description | text | NO | |||
| date | datetime | NO | 0000-00-00 00:00:00 | ||
| hits | int(11) | NO | 0 | ||
| published | tinyint(1) | NO | 0 | ||
| checked_out | int(11) | NO | 0 | ||
| checked_out_time | datetime | NO | 0000-00-00 00:00:00 | ||
| ordering | int(11) | NO | 0 | ||
| archived | tinyint(1) | NO | 0 | ||
| approved | tinyint(1) | NO | 1 | ||
| params | text | NO |