Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

List of database tables?


sneakyimp

Recommended Posts

I am the new guy working on a project that uses OSC v 2.2. They've installed a lot of mods and there are some 155 tables in there. Is there anywhere I can easily find a list of the tables that exist in a fresh out-of-the-box OSC 2.2 install?

 

Or, if someone knows where a data dictionary might be, that would be AWESOME.

FlashMOG - make multiplayer games in Flash/PHP!

Link to comment
Share on other sites

Which version of 2.2 are you talking of? Cause there are different numbers of tables from 2.2 to RC2a.

 

Here is a list of 2.2RC2a:

 

address_book

address_format

administrators

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

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_description

sessions

specials

tax_class

tax_rates

whos_online

zones

zones_to_geo_zones

Link to comment
Share on other sites

Hi If you can find a version of osCommerce 2.2 ms it has a database map included.

I think there are 47 tables by default.

If you download the 2.2MS verion you can also just load it to phpmyadmin and see from there

Nic

Sometimes you're the dog and sometimes the lamp post

[/url]

My Contributions

Link to comment
Share on other sites

Thanks Fimble. Lazy sod that I am, I was hoping to avoid download/install. Manfred generously gave me pretty much exactly what I need.

FlashMOG - make multiplayer games in Flash/PHP!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...