[Vtigercrm-developers] prefix table in database
Dhr. R.R. Gerbrands
werk at r2g.nl
Thu Mar 23 01:22:16 PST 2006
Hi Mike,
I'll agree with your arguments against version control, I've got no idea if
adodb helps us with this.
So let's forget that one, for prefix tables.
Let me then suggest this for references: comparing module map/directory
naming and table naming.
Looking at the modules and the current names for tables, then I see in the
map module for example 'accounts' Looking at the tables I find 9 tables
starting with account, I presumed they are related to the module 'accounts'?
It's more or less the same for these module_map names:
accounts
activity
contact
customview
email (i would include tables starting with mail also)
notes
products
quotes
reports
rss
users
Can this be used as references?
Or use all tables originating from the module, for example from squirrelmail
in one prefix table name.
> .vti_ as default
> .vti_a_ for addon
> .vti_p_ for plugin
> .vti_{modulename}_ for module
Best regards,
Remco Gerbrands
-----Oorspronkelijk bericht-----
Van: vtigercrm-developers-bounces at lists.vtigercrm.com
[mailto:vtigercrm-developers-bounces at lists.vtigercrm.com]Namens Mike
Fedyk
Verzonden: woensdag 22 maart 2006 9:02
Aan: vtigercrm-developers at lists.vtigercrm.com
Onderwerp: Re: [Vtigercrm-developers] prefix table in database
A lot of those tables store many-many relationships between various
modules. Which module owns a table when it references to more than one
module? I've thought about this before but that really killed the idea
for me. If a solution or policy can be made that solves it, then it
looks much more interesting.
Also I absolutely do not like storing version numbers in table or db
names. The migration from 4.2.[0123] should be able to be done by
testing for some unique structure that is not in that version and
changing it to the current version. Also adodb's data dictionary
functions may be able to do this for us. I just want to make sure it
does it in a lossless fashion.
Mike
More information about the vtigercrm-developers
mailing list