Our site www.viart.com site is operated by latest Viart Shop 5 with default Clear design
Topic Information
Jay
Jay
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
Jay
Yes, no maybe?
 
Vera
Vera
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
daviswe
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
dmOZ
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
TOCDCO
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
dmOZ
I am using that, but its working out all the DB touch points which is the bigger problem