Is it possible to get a schema of the database design for viart 4.0?
Working with the tables through SQL can get cumbersome at times, and a pre printed map would really be great!
Jay
14 Aug 2013 5:39 AM
Yes, no maybe?
Vera
15 Aug 2013 6:47 AM
We're not sure for what purpose you need this but there is no such document. When using a program like phpMyadmin you can see the list of all tables in the database and it is usually enough. Also the file with database structure that's used during installation /db/mysql_viart_shop.sql if it helps.
Regards,
ViArt Team
daviswe
11 Feb 2014 7:54 PM
Download MySQL desktop, install it on your computer, import the database from your host, and you can view it any way you want, including printed views, etc.
dmOZ
8 Apr 2014 4:53 AM
One thing that I find cumbersome with a lot of products (Viart included) is that for simplicity of DB design there are no foreign keys.
This makes it hard to find the relationships between the tables.
I'm currently tackling trying to move just the users to a different instance of Viart.
I have added a custom field which is a listbox to my customer profiles fields, and I am still trying to fathom which tables are involved
TOCDCO
9 Apr 2014 3:08 PM
Dmoz,
If you're trying to export users, why do you not just use the export feature from the user listing in the admin section, rather than trying to download the tables?
dmOZ
11 Apr 2014 6:26 AM
I am using that, but its working out all the DB touch points which is the bigger problem