Page 1 of 1

changing the database

Posted: 12 Sep 2022, 11:55
by saltri77
Hello everyone,
I would need to know if it is possible, and how without running into problems, to be able to modify some tables in the database, related to phocacart. For example, I would need an X field to be directly in the Y table rather than as an additional field. it's possible to do it? Thank you.

Re: changing the database

Posted: 12 Sep 2022, 22:03
by Jan
Hi, I don't know what you exactly mean with "X field to be directly in the Y table" but of course if you change some data, you need to care about the relations between tables. So you can change the title and this will be safe but changing relation columns like ID will be not always safe.

Jan

Re: changing the database

Posted: 13 Sep 2022, 07:36
by saltri77
Thank you for your answer.
I mean that I need to have some custom fields directly in the table of products (for example), and not in another table. That is because will be more easy for my customer (the person to who I'm building the website) using his web site.

Re: changing the database

Posted: 16 Sep 2022, 01:08
by Jan
But sometimes it is just no possible to have everything in one row, e.g. if the product can have more categories, this cannot be stored in one row and relation table needs to be used, etc. :idea:

Jan