CREATE os_address_book (
address_book_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL,
entry_gender char(1) NOT NULL default '',
entry_company varchar(255) default '',
entry_firstname varchar(255) NOT NULL default '',
entry_secondname varchar(255) NOT NULL default '',
entry_lastname varchar(255) NOT NULL default '',
entry_street_address varchar(255) NOT NULL default '',
entry_suburb varchar(255) default '',
entry_postcode varchar(10) NOT NULL default '',
entry_city varchar(255) NOT NULL default '',
entry_state varchar(255) default '',
entry_country_id int(11) NOT NULL default '0',
entry_zone_id int(11) NOT NULL default '0',
address_date_added datetime default '0000-00-00 00:00:00',
address_last_modified datetime default '0000-00-00 00:00:00',
PRIMARY KEY (address_book_id),
KEY idx_address_book_customers_id (customers_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE os_address_format (
address_format_id int(11) NOT NULL auto_increment,
address_format varchar(255) NOT NULL,
address_summary varchar(255) NOT NULL,
PRIMARY KEY (address_format_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
CREATE os_admin_access (
customers_id varchar(255) NOT NULL default '0',
configuration int(1) NOT NULL default '0',
modules int(1) NOT NULL default '0',
countries int(1) NOT NULL default '0',
currencies int(1) NOT NULL default '0',
zones int(1) NOT NULL default '0',
geo_zones int(1) NOT NULL default '0',
tax_classes int(1) NOT NULL default '0',
tax_rates int(1) NOT NULL default '0',
accounting int(1) NOT NULL default '0',
backup int(1) NOT NULL default '0',
cache int(1) NOT NULL default '0',
server_info int(1) NOT NULL default '0',
whos_online int(1) NOT NULL default '0',
languages int(1) NOT NULL default '0',
define_language int(1) NOT NULL default '0',
orders_status int(1) NOT NULL default '0',
shipping_status int(1) NOT NULL default '0',
customers int(1) NOT NULL default '0',
create_account int(1) NOT NULL default '0',
customers_status int(1) NOT NULL default '0',
orders int(1) NOT NULL default '0',
campaigns int(1) NOT NULL default '0',
print_packingslip int(1) NOT NULL default '0',
print_order int(1) NOT NULL default '0',
popup_memo int(1) NOT NULL default '0',
coupon_admin int(1) NOT NULL default '0',
listcategories int(1) NOT NULL default '0',
gv_queue int(1) NOT NULL default '0',
gv_mail int(1) NOT NULL default '0',
gv_sent int(1) NOT NULL default '0',
validproducts int(1) NOT NULL default '0',
validcategories int(1) NOT NULL default '0',
mail int(1) NOT NULL default '0',
categories int(1) NOT NULL default '0',
new_attributes int(1) NOT NULL default '0',
products_attributes int(1) NOT NULL default '0',
manufacturers int(1) NOT NULL default '0',
reviews int(1) NOT NULL default '0',
specials int(1) NOT NULL default '0',
stats_products_expected int(1) NOT NULL default '0',
stats_products_viewed int(1) NOT NULL default '0',
stats_products_purchased int(1) NOT NULL default '0',
stats_customers int(1) NOT NULL default '0',
stats_sales_report int(1) NOT NULL default '0',
stats_campaigns int(1) NOT NULL default '0',
banner_manager int(1) NOT NULL default '0',
banner_statistics int(1) NOT NULL default '0',
module_newsletter int(1) NOT NULL default '0',
index2 int(1) NOT NULL default '0',
content_manager int(1) NOT NULL default '0',
content_preview int(1) NOT NULL default '0',
credits int(1) NOT NULL default '0',
blacklist int(1) NOT NULL default '0',
orders_edit int(1) NOT NULL default '0',
popup_image int(1) NOT NULL default '0',
csv_backend int(1) NOT NULL default '0',
products_vpe int(1) NOT NULL default '0',
cross_sell_groups int(1) NOT NULL default '0',
fck_wrapper int(1) NOT NULL default '0',
easypopulate int(1) NOT NULL default '0',
quick_updates int(1) NOT NULL default '0',
latest_news int(1) NOT NULL default '0',
recover_cart_sales int(1) NOT NULL default '0',
featured int(1) NOT NULL default '0',
authors int(1) NOT NULL default '0',
articles int(1) NOT NULL default '0',
articles_config int(1) NOT NULL default '0',
stats_sales_report2 int(1) NOT NULL default '0',
chart_data int(1) NOT NULL default '0',
articles_xsell int(1) NOT NULL default '0',
email_manager int(1) NOT NULL default '0',
category_specials int(1) NOT NULL default '0',
products_options int(1) NOT NULL default '0',
product_extra_fields int(1) NOT NULL default '0',
ship2pay int(1) NOT NULL default '0',
faq int(1) NOT NULL default '0',
affiliate_affiliates int(1) NOT NULL default '0',
affiliate_banners int(1) NOT NULL default '0',
affiliate_clicks int(1) NOT NULL default '0',
affiliate_contact int(1) NOT NULL default '0',
affiliate_invoice int(1) NOT NULL default '0',
affiliate_payment int(1) NOT NULL default '0',
affiliate_popup_image int(1) NOT NULL default '0',
affiliate_sales int(1) NOT NULL default '0',
affiliate_statistics int(1) NOT NULL default '0',
affiliate_summary int(1) NOT NULL default '0',
customer_extra_fields int(1) NOT NULL default '0',
themes int(1) NOT NULL,
themes_edit int(1) NOT NULL,
general_index int(1) NOT NULL,
plugins int(1) NOT NULL,
stats_stock_warning int(1) NOT NULL,
products_expected int(1) NOT NULL,
plugins_page int(1) NOT NULL,
file int(1) NOT NULL,
error_log int(1) NOT NULL,
import int(1) NOT NULL,
export int(1) NOT NULL,
PRIMARY KEY (customers_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_articles (
articles_id int(11) NOT NULL auto_increment,
articles_date_added datetime NOT NULL default '0000-00-00 00:00:00',
articles_last_modified datetime default NULL,
articles_date_available datetime default NULL,
articles_status tinyint(1) NOT NULL default '0',
authors_id int(11) default NULL,
articles_page_url varchar(255) default NULL,
sort_order int(4) NOT NULL default '0',
PRIMARY KEY (articles_id),
KEY idx_articles_date_added (articles_date_added)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
CREATE os_articles_description (
articles_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
articles_name varchar(255) NOT NULL default '',
articles_description text,
articles_url varchar(255) default NULL,
articles_viewed int(5) default '0',
articles_head_title_tag varchar(80) default NULL,
articles_head_desc_tag text,
articles_head_keywords_tag text,
PRIMARY KEY (articles_id,language_id),
KEY articles_name (articles_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
CREATE os_articles_to_topics (
articles_id int(11) NOT NULL default '0',
topics_id int(11) NOT NULL default '0',
PRIMARY KEY (articles_id,topics_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_articles_xsell (
ID int(10) NOT NULL auto_increment,
articles_id int(10) unsigned NOT NULL default '1',
xsell_id int(10) unsigned NOT NULL default '1',
sort_order int(10) unsigned NOT NULL default '1',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_authors (
authors_id int(11) NOT NULL auto_increment,
authors_name varchar(255) NOT NULL default '',
authors_image varchar(64) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY (authors_id),
KEY IDX_AUTHORS_NAME (authors_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_authors_info (
authors_id int(11) NOT NULL default '0',
languages_id int(11) NOT NULL default '0',
authors_description text,
authors_url varchar(255) NOT NULL default '',
url_clicked int(5) NOT NULL default '0',
date_last_click datetime default NULL,
PRIMARY KEY (authors_id,languages_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_banktransfer (
orders_id int(11) NOT NULL default '0',
banktransfer_owner varchar(255) default NULL,
banktransfer_number varchar(24) default NULL,
banktransfer_bankname varchar(255) default NULL,
banktransfer_blz varchar(8) default NULL,
banktransfer_status int(11) default NULL,
banktransfer_prz char(2) default NULL,
banktransfer_fax char(2) default NULL,
KEY orders_id (orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_banners (
banners_id int(11) NOT NULL auto_increment,
banners_title varchar(255) NOT NULL,
banners_url varchar(255) NOT NULL,
banners_image varchar(255) NOT NULL,
banners_group varchar(10) NOT NULL,
banners_html_text text,
expires_impressions int(7) default '0',
expires_date datetime default NULL,
date_scheduled datetime default NULL,
date_added datetime NOT NULL,
date_status_change datetime default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (banners_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_banners_history (
banners_history_id int(11) NOT NULL auto_increment,
banners_id int(11) NOT NULL,
banners_shown int(5) NOT NULL default '0',
banners_clicked int(5) NOT NULL default '0',
banners_history_date datetime NOT NULL,
PRIMARY KEY (banners_history_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_campaigns (
campaigns_id int(11) NOT NULL auto_increment,
campaigns_name varchar(255) NOT NULL default '',
campaigns_refID varchar(255) default NULL,
campaigns_leads int(11) NOT NULL default '0',
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY (campaigns_id),
KEY IDX_CAMPAIGNS_NAME (campaigns_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_campaigns_ip (
user_ip varchar(15) NOT NULL,
time datetime NOT NULL,
campaign varchar(32) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_card_blacklist (
blacklist_id int(5) NOT NULL auto_increment,
blacklist_card_number varchar(20) NOT NULL default '',
date_added datetime default NULL,
last_modified datetime default NULL,
KEY blacklist_id (blacklist_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_categories (
categories_id int(11) NOT NULL auto_increment,
categories_image varchar(255) default NULL,
parent_id int(11) NOT NULL default '0',
categories_status tinyint(1) unsigned NOT NULL default '1',
categories_template varchar(255) default NULL,
group_permission_0 tinyint(1) NOT NULL,
group_permission_1 tinyint(1) NOT NULL,
group_permission_2 tinyint(1) NOT NULL,
group_permission_3 tinyint(1) NOT NULL,
listing_template varchar(255) default NULL,
sort_order int(3) NOT NULL default '0',
products_sorting varchar(255) default NULL,
products_sorting2 varchar(255) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
yml_bid int(4) NOT NULL default '0',
yml_cbid int(4) NOT NULL default '0',
categories_url varchar(255) default NULL,
yml_enable tinyint(1) NOT NULL default '1',
PRIMARY KEY (categories_id),
KEY idx_categories_parent_id (parent_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;
CREATE os_categories_description (
categories_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
categories_name varchar(255) NOT NULL,
categories_heading_title varchar(255) NOT NULL,
categories_description text NOT NULL,
categories_meta_title varchar(255) NOT NULL,
categories_meta_description varchar(255) NOT NULL,
categories_meta_keywords varchar(255) NOT NULL,
PRIMARY KEY (categories_id,language_id),
KEY idx_categories_name (categories_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_cm_file_flags (
file_flag int(11) NOT NULL,
file_flag_name varchar(255) NOT NULL,
PRIMARY KEY (file_flag)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_companies (
orders_id int(11) NOT NULL default '0',
name varchar(255) default NULL,
inn varchar(255) default NULL,
kpp varchar(255) default NULL,
ogrn varchar(255) default NULL,
okpo varchar(255) default NULL,
rs varchar(255) default NULL,
bank_name varchar(255) default NULL,
bik varchar(255) default NULL,
ks varchar(255) default NULL,
address varchar(255) default NULL,
yur_address varchar(255) default NULL,
fakt_address varchar(255) default NULL,
telephone varchar(255) default NULL,
fax varchar(255) default NULL,
email varchar(255) default NULL,
director varchar(255) default NULL,
accountant varchar(255) default NULL,
KEY orders_id (orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_configuration (
configuration_id int(11) NOT NULL auto_increment,
configuration_key varchar(255) NOT NULL,
configuration_value varchar(255) NOT NULL,
configuration_group_id int(11) NOT NULL,
sort_order int(5) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL,
use_function varchar(255) default NULL,
set_function varchar(255) default NULL,
PRIMARY KEY (configuration_id),
KEY idx_configuration_group_id (configuration_group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=427 ;
CREATE os_configuration_group (
configuration_group_id int(11) NOT NULL auto_increment,
configuration_group_key varchar(255) NOT NULL,
configuration_group_title varchar(255) NOT NULL,
configuration_group_description varchar(255) NOT NULL,
sort_order int(5) default NULL,
visible int(1) default '1',
PRIMARY KEY (configuration_group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
CREATE os_content_manager (
content_id int(11) NOT NULL auto_increment,
categories_id int(11) NOT NULL default '0',
parent_id int(11) NOT NULL default '0',
group_ids text,
languages_id int(11) NOT NULL default '0',
content_title text NOT NULL,
content_heading text NOT NULL,
content_text text NOT NULL,
content_url text NOT NULL,
sort_order int(4) NOT NULL default '0',
file_flag int(1) NOT NULL default '0',
content_file varchar(255) NOT NULL default '',
content_status int(1) NOT NULL default '0',
content_group int(11) NOT NULL,
content_delete int(1) NOT NULL default '1',
content_meta_title text,
content_meta_description text,
content_meta_keywords text,
content_page_url varchar(255) default NULL,
PRIMARY KEY (content_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
CREATE os_counter (
startdate char(8) default NULL,
counter int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_counter_history (
month char(8) default NULL,
counter int(12) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_countries (
countries_id int(11) NOT NULL auto_increment,
countries_name varchar(255) NOT NULL,
countries_iso_code_2 char(2) NOT NULL,
countries_iso_code_3 char(3) NOT NULL,
address_format_id int(11) NOT NULL,
status int(1) default '1',
PRIMARY KEY (countries_id),
KEY IDX_COUNTRIES_NAME (countries_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=240 ;
CREATE os_coupons (
coupon_id int(11) NOT NULL auto_increment,
coupon_type char(1) NOT NULL default 'F',
coupon_code varchar(255) NOT NULL default '',
coupon_amount decimal(8,4) NOT NULL default '0.0000',
coupon_minimum_order decimal(8,4) NOT NULL default '0.0000',
coupon_start_date datetime NOT NULL default '0000-00-00 00:00:00',
coupon_expire_date datetime NOT NULL default '0000-00-00 00:00:00',
uses_per_coupon int(5) NOT NULL default '1',
uses_per_user int(5) NOT NULL default '0',
restrict_to_products varchar(255) default NULL,
restrict_to_categories varchar(255) default NULL,
restrict_to_customers text,
coupon_active char(1) NOT NULL default 'Y',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
date_modified datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (coupon_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_coupons_description (
coupon_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
coupon_name varchar(255) NOT NULL default '',
coupon_description text,
KEY coupon_id (coupon_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_coupon_email_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id_sent int(11) NOT NULL default '0',
sent_firstname varchar(255) default NULL,
sent_lastname varchar(255) default NULL,
emailed_to varchar(255) default NULL,
date_sent datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (unique_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_coupon_gv_customer (
customer_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
PRIMARY KEY (customer_id),
KEY customer_id (customer_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_coupon_gv_queue (
unique_id int(5) NOT NULL auto_increment,
customer_id int(5) NOT NULL default '0',
order_id int(5) NOT NULL default '0',
amount decimal(8,4) NOT NULL default '0.0000',
date_created datetime NOT NULL default '0000-00-00 00:00:00',
ipaddr varchar(255) NOT NULL default '',
release_flag char(1) NOT NULL default 'N',
PRIMARY KEY (unique_id),
KEY uid (unique_id,customer_id,order_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_coupon_redeem_track (
unique_id int(11) NOT NULL auto_increment,
coupon_id int(11) NOT NULL default '0',
customer_id int(11) NOT NULL default '0',
redeem_date datetime NOT NULL default '0000-00-00 00:00:00',
redeem_ip varchar(255) NOT NULL default '',
order_id int(11) NOT NULL default '0',
PRIMARY KEY (unique_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_currencies (
currencies_id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL,
code char(3) NOT NULL,
symbol_left varchar(12) default NULL,
symbol_right varchar(12) default NULL,
decimal_point char(1) default NULL,
thousands_point char(1) default NULL,
decimal_places char(1) default NULL,
value float(13,8) default NULL,
last_updated datetime default NULL,
PRIMARY KEY (currencies_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
CREATE os_customers (
customers_id int(11) NOT NULL auto_increment,
customers_cid varchar(255) default NULL,
customers_vat_id varchar(20) default NULL,
customers_vat_id_status int(2) NOT NULL default '0',
customers_warning varchar(255) default NULL,
customers_status int(5) NOT NULL default '1',
customers_gender char(1) NOT NULL default '',
customers_firstname varchar(255) NOT NULL default '',
customers_secondname varchar(255) NOT NULL default '',
customers_lastname varchar(255) NOT NULL default '',
customers_dob datetime NOT NULL default '0000-00-00 00:00:00',
customers_email_address varchar(96) NOT NULL,
customers_default_address_id int(11) NOT NULL,
customers_telephone varchar(255) NOT NULL,
customers_fax varchar(255) default NULL,
customers_password varchar(40) NOT NULL,
customers_newsletter char(1) default NULL,
customers_newsletter_mode char(1) NOT NULL default '0',
member_flag char(1) NOT NULL default '0',
delete_user char(1) NOT NULL default '1',
account_type int(1) NOT NULL default '0',
password_request_key varchar(255) NOT NULL default '',
payment_unallowed varchar(255) NOT NULL default '',
shipping_unallowed varchar(255) NOT NULL default '',
refferers_id int(5) NOT NULL default '0',
customers_date_added datetime default '0000-00-00 00:00:00',
customers_last_modified datetime default '0000-00-00 00:00:00',
orig_reference text,
login_reference text,
login_tries char(2) NOT NULL default '0',
login_time datetime NOT NULL default '0000-00-00 00:00:00',
customers_username varchar(64) default NULL,
customers_fid int(5) default NULL,
customers_sid int(5) default NULL,
PRIMARY KEY (customers_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE os_customers_basket (
customers_basket_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL,
products_id tinytext NOT NULL,
customers_basket_quantity int(2) NOT NULL,
final_price decimal(15,4) NOT NULL,
customers_basket_date_added char(8) default NULL,
PRIMARY KEY (customers_basket_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_customers_basket_attributes (
customers_basket_attributes_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL,
products_id tinytext NOT NULL,
products_options_id int(11) NOT NULL,
products_options_value_id int(11) NOT NULL,
products_options_value_text text,
PRIMARY KEY (customers_basket_attributes_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_customers_info (
customers_info_id int(11) NOT NULL,
customers_info_date_of_last_logon datetime default NULL,
customers_info_number_of_logons int(5) default NULL,
customers_info_date_account_created datetime default NULL,
customers_info_date_account_last_modified datetime default NULL,
global_product_notifications int(1) default '0',
PRIMARY KEY (customers_info_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_customers_ip (
customers_ip_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
customers_ip varchar(15) NOT NULL default '',
customers_ip_date datetime NOT NULL default '0000-00-00 00:00:00',
customers_host varchar(255) NOT NULL default '',
customers_advertiser varchar(30) default NULL,
customers_referer_url varchar(255) default NULL,
PRIMARY KEY (customers_ip_id),
KEY customers_id (customers_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
CREATE os_customers_memo (
memo_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
memo_date date NOT NULL default '0000-00-00',
memo_title text NOT NULL,
memo_text text NOT NULL,
poster_id int(11) NOT NULL default '0',
PRIMARY KEY (memo_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_customers_status (
customers_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
customers_status_name varchar(255) NOT NULL default '',
customers_status_public int(1) NOT NULL default '1',
customers_status_min_order int(7) default NULL,
customers_status_max_order int(7) default NULL,
customers_status_image varchar(255) default NULL,
customers_status_discount decimal(4,2) default '0.00',
customers_status_ot_discount_flag char(1) NOT NULL default '0',
customers_status_ot_discount decimal(4,2) default '0.00',
customers_status_graduated_prices varchar(1) NOT NULL default '0',
customers_status_show_price int(1) NOT NULL default '1',
customers_status_show_price_tax int(1) NOT NULL default '1',
customers_status_add_tax_ot int(1) NOT NULL default '0',
customers_status_payment_unallowed varchar(255) NOT NULL,
customers_status_shipping_unallowed varchar(255) NOT NULL,
customers_status_discount_attributes int(1) NOT NULL default '0',
customers_fsk18 int(1) NOT NULL default '1',
customers_fsk18_display int(1) NOT NULL default '1',
customers_status_write_reviews int(1) NOT NULL default '1',
customers_status_read_reviews int(1) NOT NULL default '1',
customers_status_accumulated_limit decimal(15,4) default '0.0000',
PRIMARY KEY (customers_status_id,language_id),
KEY idx_orders_status_name (customers_status_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_customers_status_history (
customers_status_history_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
new_value int(5) NOT NULL default '0',
old_value int(5) default NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
customer_notified int(1) default '0',
PRIMARY KEY (customers_status_history_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_customers_status_orders_status (
customers_status_id int(11) NOT NULL default '0',
orders_status_id int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_customers_to_extra_fields (
customers_id int(11) NOT NULL default '0',
fields_id int(11) NOT NULL default '0',
value text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_extra_fields (
fields_id int(11) NOT NULL auto_increment,
fields_input_type int(11) NOT NULL default '0',
fields_input_value text NOT NULL,
fields_status tinyint(2) NOT NULL default '0',
fields_required_status tinyint(2) NOT NULL default '0',
fields_size int(5) NOT NULL default '0',
fields_required_email tinyint(2) NOT NULL default '0',
PRIMARY KEY (fields_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_extra_fields_info (
fields_id int(11) NOT NULL default '0',
languages_id int(11) NOT NULL default '0',
fields_name varchar(32) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_faq (
faq_id int(11) NOT NULL auto_increment,
question varchar(255) NOT NULL,
answer text NOT NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
language int(11) NOT NULL default '1',
status tinyint(1) NOT NULL default '0',
faq_page_url varchar(256) NOT NULL,
PRIMARY KEY (faq_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_featured (
featured_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
featured_quantity int(4) NOT NULL,
featured_date_added datetime default NULL,
featured_last_modified datetime default NULL,
expires_date datetime default NULL,
date_status_change datetime default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (featured_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_geo_zones (
geo_zone_id int(11) NOT NULL auto_increment,
geo_zone_name varchar(255) NOT NULL,
geo_zone_description varchar(255) NOT NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL,
PRIMARY KEY (geo_zone_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_goods_carousello (
good_carousello_id int(11) NOT NULL auto_increment,
good_carousello_visibility int(11) NOT NULL default '1',
PRIMARY KEY (good_carousello_id)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;
CREATE os_goods_carousello_settings (
good_carousello_settings_code varchar(255) NOT NULL default '',
good_carousello_settings_value varchar(255) NOT NULL default '',
PRIMARY KEY (good_carousello_settings_code)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
CREATE os_languages (
languages_id int(11) NOT NULL auto_increment,
name varchar(255) NOT NULL,
code char(2) NOT NULL,
image varchar(255) default NULL,
directory varchar(255) default NULL,
sort_order int(3) default NULL,
status int(3) default NULL,
language_charset text NOT NULL,
PRIMARY KEY (languages_id),
KEY IDX_LANGUAGES_NAME (name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE os_latest_news (
news_id int(11) NOT NULL auto_increment,
headline varchar(255) NOT NULL,
content text NOT NULL,
date_added datetime NOT NULL default '0000-00-00 00:00:00',
language int(11) NOT NULL default '1',
status tinyint(1) NOT NULL default '0',
news_page_url varchar(255) NOT NULL,
PRIMARY KEY (news_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
CREATE os_manufacturers (
manufacturers_id int(11) NOT NULL auto_increment,
manufacturers_name varchar(255) NOT NULL,
manufacturers_image varchar(255) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
PRIMARY KEY (manufacturers_id),
KEY IDX_MANUFACTURERS_NAME (manufacturers_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_manufacturers_info (
manufacturers_id int(11) NOT NULL,
languages_id int(11) NOT NULL,
manufacturers_meta_title varchar(255) NOT NULL,
manufacturers_meta_description varchar(255) NOT NULL,
manufacturers_meta_keywords varchar(255) NOT NULL,
manufacturers_url varchar(255) NOT NULL,
manufacturers_description mediumtext NOT NULL,
url_clicked int(5) NOT NULL default '0',
date_last_click datetime default NULL,
PRIMARY KEY (manufacturers_id,languages_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_media_content (
file_id int(11) NOT NULL auto_increment,
old_filename text NOT NULL,
new_filename text NOT NULL,
file_comment text NOT NULL,
PRIMARY KEY (file_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_module_newsletter (
newsletter_id int(11) NOT NULL auto_increment,
title text NOT NULL,
bc text NOT NULL,
cc text NOT NULL,
date datetime default NULL,
status int(1) NOT NULL default '0',
body text NOT NULL,
PRIMARY KEY (newsletter_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_module_newsletter_temp_3 (
id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL default '0',
customers_status int(11) NOT NULL default '0',
customers_firstname varchar(64) NOT NULL default '',
customers_lastname varchar(64) NOT NULL default '',
customers_email_address text NOT NULL,
mail_key varchar(32) NOT NULL default '',
date datetime NOT NULL default '0000-00-00 00:00:00',
comment varchar(64) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=339 ;
CREATE os_newsletters (
newsletters_id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL,
content text NOT NULL,
module varchar(255) NOT NULL,
date_added datetime NOT NULL,
date_sent datetime default NULL,
status int(1) default NULL,
locked int(1) default '0',
PRIMARY KEY (newsletters_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_newsletters_history (
news_hist_id int(11) NOT NULL default '0',
news_hist_cs int(11) NOT NULL default '0',
news_hist_cs_date_sent date default NULL,
PRIMARY KEY (news_hist_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_newsletter_recipients (
mail_id int(11) NOT NULL auto_increment,
customers_email_address varchar(96) NOT NULL default '',
customers_id int(11) NOT NULL default '0',
customers_status int(5) NOT NULL default '0',
customers_firstname varchar(255) NOT NULL default '',
customers_lastname varchar(255) NOT NULL default '',
mail_status int(1) NOT NULL default '0',
mail_key varchar(255) NOT NULL default '',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (mail_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders (
orders_id int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL,
customers_cid varchar(255) default NULL,
customers_vat_id varchar(20) default NULL,
customers_status int(11) default NULL,
customers_status_name varchar(255) NOT NULL,
customers_status_image varchar(64) default NULL,
customers_status_discount decimal(4,2) default NULL,
customers_name varchar(255) NOT NULL,
customers_firstname varchar(255) NOT NULL,
customers_secondname varchar(255) NOT NULL,
customers_lastname varchar(255) NOT NULL,
customers_company varchar(255) default NULL,
customers_street_address varchar(255) NOT NULL,
customers_suburb varchar(255) default NULL,
customers_city varchar(255) NOT NULL,
customers_postcode varchar(10) NOT NULL,
customers_state varchar(255) default NULL,
customers_country varchar(255) NOT NULL,
customers_telephone varchar(255) NOT NULL,
customers_email_address varchar(96) NOT NULL,
customers_address_format_id int(5) NOT NULL,
delivery_name varchar(255) NOT NULL,
delivery_firstname varchar(255) NOT NULL,
delivery_secondname varchar(255) NOT NULL,
delivery_lastname varchar(255) NOT NULL,
delivery_company varchar(255) default NULL,
delivery_street_address varchar(255) NOT NULL,
delivery_suburb varchar(255) default NULL,
delivery_city varchar(255) NOT NULL,
delivery_postcode varchar(10) NOT NULL,
delivery_state varchar(255) default NULL,
delivery_country varchar(255) NOT NULL,
delivery_country_iso_code_2 char(2) NOT NULL,
delivery_address_format_id int(5) NOT NULL,
billing_name varchar(255) NOT NULL,
billing_firstname varchar(255) NOT NULL,
billing_secondname varchar(255) NOT NULL,
billing_lastname varchar(255) NOT NULL,
billing_company varchar(255) default NULL,
billing_street_address varchar(255) NOT NULL,
billing_suburb varchar(255) default NULL,
billing_city varchar(255) NOT NULL,
billing_postcode varchar(10) NOT NULL,
billing_state varchar(255) default NULL,
billing_country varchar(255) NOT NULL,
billing_country_iso_code_2 char(2) NOT NULL,
billing_address_format_id int(5) NOT NULL,
payment_method varchar(255) NOT NULL,
cc_type varchar(20) default NULL,
cc_owner varchar(255) default NULL,
cc_number varchar(255) default NULL,
cc_expires varchar(4) default NULL,
cc_start varchar(4) default NULL,
cc_issue varchar(3) default NULL,
cc_cvv varchar(4) default NULL,
comments varchar(255) default NULL,
last_modified datetime default NULL,
date_purchased datetime default NULL,
orders_status int(5) NOT NULL,
orders_date_finished datetime default NULL,
currency char(3) default NULL,
currency_value decimal(14,6) default NULL,
account_type int(1) NOT NULL default '0',
payment_class varchar(255) NOT NULL,
shipping_method varchar(255) NOT NULL,
shipping_class varchar(255) NOT NULL,
customers_ip varchar(255) NOT NULL,
language varchar(255) NOT NULL,
afterbuy_success int(1) NOT NULL default '0',
afterbuy_id int(32) NOT NULL default '0',
refferers_id varchar(255) NOT NULL,
conversion_type int(1) NOT NULL default '0',
orders_ident_key varchar(255) default NULL,
orig_reference text,
login_reference text,
PRIMARY KEY (orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_products (
orders_products_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL,
products_id int(11) NOT NULL,
products_model varchar(255) default NULL,
products_name varchar(255) NOT NULL,
products_price decimal(15,4) NOT NULL,
products_discount_made decimal(4,2) default NULL,
products_shipping_time varchar(255) default NULL,
final_price decimal(15,4) NOT NULL,
products_tax decimal(7,4) NOT NULL,
products_quantity int(2) NOT NULL,
allow_tax int(1) NOT NULL,
PRIMARY KEY (orders_products_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_products_attributes (
orders_products_attributes_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL,
orders_products_id int(11) NOT NULL,
products_options varchar(255) NOT NULL,
products_options_values varchar(255) NOT NULL,
options_values_price decimal(15,4) NOT NULL,
price_prefix char(1) NOT NULL,
PRIMARY KEY (orders_products_attributes_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_products_download (
orders_products_download_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
orders_products_id int(11) NOT NULL default '0',
orders_products_filename varchar(255) NOT NULL default '',
download_maxdays int(2) NOT NULL default '0',
download_count int(2) NOT NULL default '0',
PRIMARY KEY (orders_products_download_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_recalculate (
orders_recalculate_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL default '0',
n_price decimal(15,4) NOT NULL default '0.0000',
b_price decimal(15,4) NOT NULL default '0.0000',
tax decimal(15,4) NOT NULL default '0.0000',
tax_rate decimal(7,4) NOT NULL default '0.0000',
class varchar(255) NOT NULL default '',
PRIMARY KEY (orders_recalculate_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_status (
orders_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
orders_status_name varchar(255) NOT NULL,
PRIMARY KEY (orders_status_id,language_id),
KEY idx_orders_status_name (orders_status_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_orders_status_history (
orders_status_history_id int(11) NOT NULL auto_increment,
orders_id int(11) NOT NULL,
orders_status_id int(5) NOT NULL,
date_added datetime NOT NULL,
customer_notified int(1) default '0',
comments text,
PRIMARY KEY (orders_status_history_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_orders_total (
orders_total_id int(10) unsigned NOT NULL auto_increment,
orders_id int(11) NOT NULL,
title varchar(255) NOT NULL,
text varchar(255) NOT NULL,
value decimal(15,4) NOT NULL,
class varchar(255) NOT NULL,
sort_order int(11) NOT NULL,
PRIMARY KEY (orders_total_id),
KEY idx_orders_total_orders_id (orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_payment_moneybookers (
mb_TRID varchar(255) NOT NULL default '',
mb_ERRNO smallint(3) unsigned NOT NULL default '0',
mb_ERRTXT varchar(255) NOT NULL default '',
mb_DATE datetime NOT NULL default '0000-00-00 00:00:00',
mb_MBTID bigint(18) unsigned NOT NULL default '0',
mb_STATUS tinyint(1) NOT NULL default '0',
mb_ORDERID int(11) unsigned NOT NULL default '0',
PRIMARY KEY (mb_TRID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_payment_moneybookers_countries (
osc_cID int(11) NOT NULL default '0',
mb_cID char(3) NOT NULL default '',
PRIMARY KEY (osc_cID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_payment_moneybookers_currencies (
mb_currID char(3) NOT NULL default '',
mb_currName varchar(255) NOT NULL default '',
PRIMARY KEY (mb_currID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_payment_qenta (
q_TRID varchar(255) NOT NULL default '',
q_DATE datetime NOT NULL default '0000-00-00 00:00:00',
q_QTID bigint(18) unsigned NOT NULL default '0',
q_ORDERDESC varchar(255) NOT NULL default '',
q_STATUS tinyint(1) NOT NULL default '0',
q_ORDERID int(11) unsigned NOT NULL default '0',
PRIMARY KEY (q_TRID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_personal_offers_by_customers_status_0 (
price_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
quantity int(11) default NULL,
personal_offer decimal(15,4) default NULL,
PRIMARY KEY (price_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_persons (
orders_id int(11) NOT NULL default '0',
name varchar(255) default NULL,
address varchar(255) default NULL,
KEY orders_id (orders_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_plugins (
plugins_id int(11) NOT NULL auto_increment,
plugins_key varchar(64) NOT NULL,
plugins_name varchar(64) NOT NULL,
plugins_value text NOT NULL,
sort_order int(5) default NULL,
sort_plugins int(5) default NULL,
use_function text,
PRIMARY KEY (plugins_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
CREATE os_post_index (
Id int(6) unsigned NOT NULL auto_increment,
tax_zone_id int(1) NOT NULL default '0',
low int(7) NOT NULL default '0',
high int(7) NOT NULL default '0',
mono int(7) NOT NULL default '0',
PRIMARY KEY (Id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
CREATE os_products (
products_id int(11) NOT NULL auto_increment,
products_ean varchar(255) default NULL,
products_quantity int(4) NOT NULL,
products_shippingtime int(4) NOT NULL,
products_model varchar(255) default NULL,
group_permission_0 tinyint(1) NOT NULL,
group_permission_1 tinyint(1) NOT NULL,
group_permission_2 tinyint(1) NOT NULL,
group_permission_3 tinyint(1) NOT NULL,
products_sort int(4) NOT NULL default '0',
products_image varchar(255) default NULL,
products_price decimal(15,4) NOT NULL,
products_discount_allowed decimal(15,4) NOT NULL default '0.0000',
products_date_added datetime NOT NULL,
products_last_modified datetime default NULL,
products_date_available datetime default NULL,
products_weight decimal(5,2) NOT NULL,
products_status tinyint(1) NOT NULL,
products_tax_class_id int(11) NOT NULL,
product_template varchar(64) default NULL,
options_template varchar(64) default NULL,
manufacturers_id int(11) default NULL,
products_ordered int(11) NOT NULL default '0',
products_fsk18 int(1) NOT NULL default '0',
products_vpe int(11) NOT NULL,
products_vpe_status int(1) NOT NULL default '0',
products_vpe_value decimal(15,4) NOT NULL,
products_startpage int(1) NOT NULL default '0',
products_startpage_sort int(4) NOT NULL default '0',
products_to_xml tinyint(1) NOT NULL default '1',
yml_bid tinyint(1) NOT NULL default '0',
yml_cbid tinyint(1) NOT NULL default '0',
products_page_url varchar(255) default NULL,
PRIMARY KEY (products_id),
KEY idx_products_date_added (products_date_added)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ;
CREATE os_products_attributes (
products_attributes_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
options_id int(11) NOT NULL,
options_values_id int(11) NOT NULL,
options_values_price decimal(15,4) NOT NULL,
price_prefix char(1) NOT NULL,
attributes_model varchar(255) default NULL,
attributes_stock int(4) default NULL,
options_values_weight decimal(15,4) NOT NULL,
weight_prefix char(1) NOT NULL,
sortorder int(11) default NULL,
PRIMARY KEY (products_attributes_id),
KEY PRODUCTS_ID_INDEX (products_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
CREATE os_products_attributes_download (
products_attributes_id int(11) NOT NULL,
products_attributes_filename varchar(255) NOT NULL default '',
products_attributes_maxdays int(2) default '0',
products_attributes_maxcount int(2) default '0',
PRIMARY KEY (products_attributes_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_content (
content_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL default '0',
group_ids text,
content_name varchar(255) NOT NULL default '',
content_file varchar(255) NOT NULL,
content_link text NOT NULL,
languages_id int(11) NOT NULL default '0',
content_read int(11) NOT NULL default '0',
file_comment text NOT NULL,
PRIMARY KEY (content_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_products_description (
products_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
products_name varchar(255) NOT NULL default '',
products_description text,
products_short_description text,
products_keywords varchar(255) default NULL,
products_meta_title text NOT NULL,
products_meta_description text NOT NULL,
products_meta_keywords text NOT NULL,
products_url varchar(255) default NULL,
products_viewed int(5) default '0',
PRIMARY KEY (products_id,language_id),
KEY products_name (products_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=100 ;
CREATE os_products_extra_fields (
products_extra_fields_id int(11) NOT NULL auto_increment,
products_extra_fields_name varchar(255) NOT NULL,
products_extra_fields_order int(3) NOT NULL default '0',
products_extra_fields_status tinyint(1) NOT NULL default '1',
languages_id int(11) NOT NULL default '0',
PRIMARY KEY (products_extra_fields_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
CREATE os_products_graduated_prices (
products_id int(11) NOT NULL default '0',
quantity int(11) NOT NULL default '0',
unitprice decimal(15,4) NOT NULL default '0.0000',
KEY products_id (products_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_images (
image_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
image_nr smallint(6) NOT NULL,
image_name varchar(254) NOT NULL,
PRIMARY KEY (image_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_products_notifications (
products_id int(11) NOT NULL,
customers_id int(11) NOT NULL,
date_added datetime NOT NULL,
PRIMARY KEY (products_id,customers_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_options (
products_options_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
products_options_name varchar(255) NOT NULL default '',
products_options_length int(11) NOT NULL default '32',
products_options_size int(11) NOT NULL default '32',
products_options_rows int(11) NOT NULL default '4',
products_options_type int(11) NOT NULL,
PRIMARY KEY (products_options_id,language_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_options_images (
image_id int(11) NOT NULL auto_increment,
products_options_values_id int(11) NOT NULL,
image_nr smallint(6) NOT NULL,
image_name varchar(254) NOT NULL,
PRIMARY KEY (image_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_products_options_values (
products_options_values_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
products_options_values_name varchar(255) NOT NULL default '',
products_options_values_description text,
products_options_values_text varchar(255) NOT NULL default '',
products_options_values_image varchar(255) NOT NULL default '',
products_options_values_link varchar(255) NOT NULL default '',
PRIMARY KEY (products_options_values_id,language_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_options_values_to_products_options (
products_options_values_to_products_options_id int(11) NOT NULL auto_increment,
products_options_id int(11) NOT NULL,
products_options_values_id int(11) NOT NULL,
PRIMARY KEY (products_options_values_to_products_options_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
CREATE os_products_to_categories (
products_id int(11) NOT NULL,
categories_id int(11) NOT NULL,
PRIMARY KEY (products_id,categories_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_to_products_extra_fields (
products_id int(11) NOT NULL default '0',
products_extra_fields_id int(11) NOT NULL default '0',
products_extra_fields_value varchar(255) default NULL,
PRIMARY KEY (products_id,products_extra_fields_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_vpe (
products_vpe_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '0',
products_vpe_name varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_products_xsell (
ID int(10) NOT NULL auto_increment,
products_id int(10) unsigned NOT NULL default '1',
products_xsell_grp_name_id int(10) unsigned NOT NULL default '1',
xsell_id int(10) unsigned NOT NULL default '1',
sort_order int(10) unsigned NOT NULL default '1',
PRIMARY KEY (ID)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_products_xsell_grp_name (
products_xsell_grp_name_id int(10) NOT NULL,
xsell_sort_order int(10) NOT NULL default '0',
language_id smallint(6) NOT NULL default '0',
groupname varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_reviews (
reviews_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
customers_id int(11) default NULL,
customers_name varchar(255) NOT NULL,
reviews_rating int(1) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
reviews_read int(5) NOT NULL default '0',
PRIMARY KEY (reviews_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_reviews_description (
reviews_id int(11) NOT NULL,
languages_id int(11) NOT NULL,
reviews_text text NOT NULL,
PRIMARY KEY (reviews_id,languages_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_scart (
scartid int(11) NOT NULL auto_increment,
customers_id int(11) NOT NULL,
dateadded varchar(8) NOT NULL,
PRIMARY KEY (scartid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_scroll (
scroll_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (scroll_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_sessions (
sesskey varchar(255) NOT NULL,
expiry int(11) unsigned NOT NULL,
value text NOT NULL,
PRIMARY KEY (sesskey)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_ship2pay (
s2p_id int(11) NOT NULL auto_increment,
shipment varchar(100) NOT NULL,
payments_allowed varchar(250) NOT NULL,
zones_id int(11) NOT NULL default '0',
status tinyint(4) NOT NULL,
PRIMARY KEY (s2p_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_shipping_status (
shipping_status_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
shipping_status_name varchar(255) NOT NULL,
shipping_status_image varchar(255) NOT NULL,
PRIMARY KEY (shipping_status_id,language_id),
KEY idx_shipping_status_name (shipping_status_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_specials (
specials_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
specials_quantity int(4) NOT NULL,
specials_new_products_price decimal(15,4) NOT NULL,
specials_date_added datetime default NULL,
specials_last_modified datetime default NULL,
expires_date datetime default NULL,
date_status_change datetime default NULL,
status int(1) NOT NULL default '1',
PRIMARY KEY (specials_id),
KEY idx_products_id (products_id),
KEY PRODUCTS_ID_INDEX (products_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_special_category (
special_id int(11) unsigned NOT NULL auto_increment,
categ_id int(11) unsigned NOT NULL default '0',
discount decimal(5,2) NOT NULL default '0.00',
discount_type enum('p','f') NOT NULL default 'f',
special_date_added datetime NOT NULL default '0000-00-00 00:00:00',
special_last_modified datetime NOT NULL default '0000-00-00 00:00:00',
expire_date datetime NOT NULL default '0000-00-00 00:00:00',
date_status_change datetime NOT NULL default '0000-00-00 00:00:00',
status tinyint(1) NOT NULL default '1',
PRIMARY KEY (special_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_special_product (
special_product_id int(11) unsigned NOT NULL auto_increment,
special_id int(11) unsigned NOT NULL default '0',
product_id int(11) unsigned NOT NULL default '0',
PRIMARY KEY (special_product_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_tax_class (
tax_class_id int(11) NOT NULL auto_increment,
tax_class_title varchar(255) NOT NULL,
tax_class_description varchar(255) NOT NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL,
PRIMARY KEY (tax_class_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_tax_rates (
tax_rates_id int(11) NOT NULL auto_increment,
tax_zone_id int(11) NOT NULL,
tax_class_id int(11) NOT NULL,
tax_priority int(5) default '1',
tax_rate decimal(7,4) NOT NULL,
tax_description varchar(255) NOT NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL,
PRIMARY KEY (tax_rates_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE os_topics (
topics_id int(11) NOT NULL auto_increment,
topics_image varchar(64) default NULL,
parent_id int(11) NOT NULL default '0',
sort_order int(3) default NULL,
date_added datetime default NULL,
last_modified datetime default NULL,
topics_page_url varchar(255) default NULL,
PRIMARY KEY (topics_id),
KEY idx_topics_parent_id (parent_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
CREATE os_topics_description (
topics_id int(11) NOT NULL default '0',
language_id int(11) NOT NULL default '1',
topics_name varchar(255) NOT NULL default '',
topics_heading_title varchar(255) default NULL,
topics_description text,
PRIMARY KEY (topics_id,language_id),
KEY idx_topics_name (topics_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_video (
video_id int(11) NOT NULL auto_increment,
products_id int(11) NOT NULL,
name varchar(255) NOT NULL default '',
alt varchar(255) NOT NULL default '',
video_key varchar(32) NOT NULL default '',
PRIMARY KEY (video_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
CREATE os_whos_online (
customer_id int(11) default NULL,
full_name varchar(255) NOT NULL,
session_id varchar(255) NOT NULL,
ip_address varchar(15) NOT NULL,
time_entry varchar(14) NOT NULL,
time_last_click varchar(14) NOT NULL,
last_page_url varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE os_zones (
zone_id int(11) NOT NULL auto_increment,
zone_country_id int(11) NOT NULL,
zone_code varchar(255) NOT NULL,
zone_name varchar(255) NOT NULL,
PRIMARY KEY (zone_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=387 ;
CREATE os_zones_to_geo_zones (
association_id int(11) NOT NULL auto_increment,
zone_country_id int(11) NOT NULL,
zone_id int(11) default NULL,
geo_zone_id int(11) default NULL,
last_modified datetime default NULL,
date_added datetime NOT NULL,
PRIMARY KEY (association_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
