List of database tables?

[sneakyimp]

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.

[Nullachtfuffzehn]

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

[FIMBLE]

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

[sneakyimp]

Thanks manfred, you are the man! RC2a is precisely what I'm after.

[sneakyimp]

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