Difference between revisions of "OsCommerce"

From HypertWiki
Jump to navigation Jump to search
(moved to htyp)
 
(30 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_attributes_id'''# -- integer - not null, default 0
*'''products_attributes_filename''' -- varchar(255) - not null
*'''products_attributes_maxdays''' -- int(2) - default 0
*'''products_attributes_maxcount''' -- int(2) - default 0
 
===products_description===
*'''products_id'''# -- integer - not null, auto inc
*'''language_id'''# -- integer - not null, default 1
*'''products_name''' -- varchar(64) - not null
*'''products_description''' -- text
*'''products_url''' -- varchar(255)
*'''products_viewed''' -- int(5) - default 0
 
===products_notifications===
*'''products_id'''# -- integer - not null, default 0
*'''customers_id'''# -- integer - not null, default 0
*'''date_added''' -- datetime - not null, default 0000-00-00 00:00:00
 
===products_options===
*'''products_options_id'''# -- integer - not null, default 0
*'''language_id'''# -- integer -- not null, default 1
*'''products_options_name''' -- varchar(32) - not null
 
===products_options_values===
*'''products_options_values_id'''# -- integer - not null, default 0
*'''language_id'''# -- integer - not null, default 1
*'''products_options_values_name''' -- varchar(64) - not null
 
===products_options_values_to_products_options===
*'''products_options_values_to_products_options_id'''# -- integer - not null, auto inc
*'''products_options_id''' -- integer - not null, default 0
*'''products_options_values_id''' -- integer - not null, default 0
 
===products_to_categories===
*'''products_id'''# -- integer - not null, defaul 0
*'''categories_id'''# -- integer - not null, default 0
 
===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

Latest revision as of 16:45, 23 February 2007

VYPLGO2.64pxh.png This page has been moved to HTYP, the HyperTwin Yellow Pages.