[Vtigercrm-developers] sequence tables vs auto_increment

[Nicolas Larcipretti]

Maybe portability. If you try to port all the tables to Oracle, for
instance, auto-increment would never work. But if you control the sequences
in a separate table, it becomes highly portable.

Don't know if the people who first developed Vtiger were thinking this
way...but it's definitely a good way to think!

2012/4/26 Adam Heinz <amh at metricwise.net>

> What is the use of tables like vtiger_picklist_seq when the
> vtiger_picklist.picklistid primary key is already defined as
> auto_increment?  If you need the picklistid, just call ADOdb
> Insert_ID() after the fact.  I know they're trivial little things, but
> there's more than one hundred _seq tables cluttering up SHOW TABLES.
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20120426/8a0db674/attachment.html