I am working on building a database for online shop using Microsoft SQL Server. I downloaded Prestashop and installed it on my machine. I am working out its database which seems very complicated.
What stopped me is when I view the product table in Prestashop as admin, I can see text description of each item. But when I view it in the MySQL database I can't see it!!! (I am using XAMPP to view the database) I mean there's no column called description or something. Any one knows where they hide the text?
In PrestaShop, the texts are saved to database in tables that have their names ending in
_lang, in your case it is
ps_ is default prefix). This allows the relation to
to many as a text can be in more than one language.