Browse the MySQL database

[rramirezb]

Hello,
I've installed MySQL tools to learn a bit of the DB structure of ZC. I think I begin to understand the structure of the DB; since all the tables and fields have clear names: "categories", "products", "products description".
But I'm missing something: I check the "categories" table, and it only shows part of the real categories in my Store; some are missing;
Where could they be?

[johnny43]

categories
categories_description

[kuroi]

Do you mean that some of your categories are missing (which would be odd and worrying) or, as johnny43 suggested, that some of the data associated with your transactions is not held in the categories table (which is called database normalization and makes it easier to hold data for several languages in the same database without repeating none linguistic information).

[DrByte]

http://www.zen-cart.com/wiki/index.p...rdered_by_Data