|
|
| (38 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| {{stub}} | | {{to htyp}} |
| {{editing}}
| |
| | |
| [[Techniques]]: [[osCommerce]]
| |
| | |
| [[osCommerce]] is [[FOSS|open source]] software for managing an online store. It is written in [[PHP]] and uses the [[MySQL]] database engine.
| |
| | |
| The following documentation is from notes I took while evaluating osCommerce for use at vbz.net. I ended up deciding that it would not be suitable, but could provide useful examples for how to do things using PHP and MySQL.
| |
| | |
| ==Tables==
| |
| *address_book
| |
| *address_format
| |
| *banners
| |
| *banners_history
| |
| *categories
| |
| *categories_description
| |
| *configuration
| |
| *configuration_group
| |
| *counter
| |
| *counter_history
| |
| *countries
| |
| *currencies
| |
| *customers
| |
| *customers_basket
| |
| *customers_basket_attributes
| |
| *customers_info
| |
| *geo_zones
| |
| *languages
| |
| *manufacturers
| |
| *manufacturers_info
| |
| *newsletters
| |
| *orders
| |
| *orders_products_info
| |
| *orders_products_attributes
| |
| *orders_products_download
| |
| *orders_status
| |
| *orders_status_history
| |
| *orders_total
| |
| *products
| |
| *products_attributes
| |
| *products_attributes_download
| |
| *products_description
| |
| *products_notifications
| |
| *products_options
| |
| *products_options_values
| |
| *products_options_values_to_products_options
| |
| *products_to_categories
| |
| *reviews
| |
| **'''reviews_id'''# -- integer - not null, auto inc
| |
| **'''products_id''' -- integer - not null, default 0
| |
| **'''customers_id''' -- integer
| |
| **'''customers_name''' -- varchar(64) - not null
| |
| **'''reviews_rating''' -- int(1)
| |
| **'''date_added''' -- datetime
| |
| **'''last_modified''' -- datetime
| |
| **'''reviews_read''' -- int(5) - not null, default 0
| |
| *reviews_description
| |
| **'''reviews_id'''# -- integer - not null, default 0
| |
| **'''languages_id'''# -- integer - not null, default 0
| |
| **'''reviews_text''' -- text - not null
| |
| *sessions
| |
| **'''sesskey'''# -- varchar(32) - not null
| |
| **'''expiry''' -- integer unsigned - not null, default 0
| |
| **'''value''' -- text - not null
| |
| *specials
| |
| **'''specials_id'''# -- integer - not null, auto inc
| |
| **'''products_id''' -- integer - not null, default 0
| |
| **'''specials_new_products_price''' - decimal(15,4) - not null, default 0.0000
| |
| **'''specials_date_added''' -- datetime
| |
| **'''specials_last_modified''' -- datetime
| |
| **'''expires_date''' -- datetime
| |
| **'''date_status_change''' -- datetime
| |
| **'''status''' -- int(1) - not null
| |
| *tax_class
| |
| **'''tax_class_id'''# -- integer - not null, auto inc
| |
| **'''tax_class_title''' -- varchar(32) - not null
| |
| **'''tax_class_description''' -- varchar(255) - not null
| |
| **'''last_modified''' -- datetime
| |
| **'''date_added''' -- datetime - not null, default 0000-00-00 00:00:00
| |
| *tax_rates
| |
| **'''tax_rates_id'''# -- integer - not null, auto inc
| |
| **'''tax_zone_id''' -- integer - not null, default 0
| |
| **'''tax_class_id''' -- integer - not null, default 0
| |
| **'''tax_priority''' -- int(5) - default 1
| |
| **'''tax_rate''' -- decimal(7,4) - not null, default 0.0000
| |
| **'''tax_description''' -- varchar(255) - not null
| |
| **'''last_modified''' -- datetime
| |
| **'''date_added''' -- datetime - not null, default 0000-00-00 00:00:00
| |
| *whos_online
| |
| **'''customer_id''' -- integer
| |
| **'''full_name''' -- varchar(34) - not null
| |
| **'''session_id''' -- varchar(128) - 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(34) - not null
| |
| *zones
| |
| **'''zone_id'''# -- integer - not null, autoinc
| |
| **'''zone_country_id''' -- integer - not null, default 0
| |
| **'''zone_code''' -- varchar(32) - not null
| |
| **'''zone_name''' -- varchar(32) - not null
| |
| *zones_to_geo_zones
| |
| **'''association_id'''# - integer - not null, autoinc
| |
| **'''zone_country_id''' - integer - not null
| |
| **'''zone_id''' - integer
| |
| **'''geo_zone_id''' - integer
| |
| **'''last_modified''' - datetime
| |
| **'''date_added''' - datetime - not null
| |
This page has been moved to HTYP, the HyperTwin Yellow Pages.