<div class="gmail_extra">Hi Nicolas,</div><div class="gmail_extra"><br></div><div class="gmail_extra">You are absolutely right. The main reason to go with sequence tables instead of auto increment fields is to support portability. </div>
<div class="gmail_extra"><br></div><div class="gmail_extra">But unfortunately, some tables are left over with auto-increment columns yet, which needs to be cleaned up eventually.<br><br><div class="gmail_quote">On Fri, Apr 27, 2012 at 2:15 AM, Nicolas Larcipretti <span dir="ltr"><<a href="mailto:niclarcipretti@gmail.com" target="_blank">niclarcipretti@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="gmail_extra">Hi rodrigo,</div><div class="gmail_extra"><br></div><div class="gmail_extra">Indeed, that would be changing 6 for half a dozen like we say in Brazil (lol).</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">
Cheers<br><br><div class="gmail_quote">2012/4/26 Rodrigo Souza <span dir="ltr"><<a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
<div><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">Dears</span></div><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"><div>
<span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"><br></span></div>the</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">oracle</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">is to</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">create a trigger</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">to feed</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">an</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">autonumber</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">field</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">, then</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">the problem</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">would not</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"></span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">extinguish these</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">tables</span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)"> </span><span style="color:rgb(51,51,51);font-family:arial,sans-serif;font-size:16px;background-color:rgb(245,245,245)">_seq</span> <div>
<font><br></font></div><div><font><br></font></div><div><font><br></font></div><div><font><br clear="all"></font>Atte,<br><b>Rodrigo Souza de Oliveira</b><div><b>Consultor de TI<br></b>Hostplan Informática Ltda<br><div>Telefones: <a href="tel:%2821%29%209217-7909" value="+552192177909" target="_blank">(21) 9217-7909</a> e/ou <a href="tel:%2821%29%208153-5287" value="+552181535287" target="_blank">(21) 8153-5287</a><div>
website: <a href="http://www.hostplan.com.br" target="_blank">www.hostplan.com.br</a><br>e-mail/msn: <a href="mailto:rodrigo@hostplan.com.br" target="_blank">rodrigo@hostplan.com.br</a><br><img height="137" width="200"><br>
</div></div></div><br>
<div class="gmail_extra"><br><br><div class="gmail_quote">Em 26 de abril de 2012 16:54, Nicolas Larcipretti <span dir="ltr"><<a href="mailto:niclarcipretti@gmail.com" target="_blank">niclarcipretti@gmail.com</a>></span> escreveu:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div><div class="gmail_extra">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.</div>
<div class="gmail_extra"><br></div><div class="gmail_extra">Don't know if the people who first developed Vtiger were thinking this way...but it's definitely a good way to think!<div><div><br><br><div class="gmail_quote">
2012/4/26 Adam Heinz <span dir="ltr"><<a href="mailto:amh@metricwise.net" target="_blank">amh@metricwise.net</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">What is the use of tables like vtiger_picklist_seq when the<br>
vtiger_picklist.picklistid primary key is already defined as<br>
auto_increment? If you need the picklistid, just call ADOdb<br>
Insert_ID() after the fact. I know they're trivial little things, but<br>
there's more than one hundred _seq tables cluttering up SHOW TABLES.<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div></div></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div></div>
<br></div></div>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br>Regards,<br>Asha<br>vtiger Team<br><br><b>Connect with us on: </b><a href="http://twitter.com/#%21/vtigercrm" target="_blank">Twitter</a> <b>I</b> <a href="http://www.facebook.com/pages/vtiger/226866697333578?sk=wall" target="_blank">Facebook</a> <b>I</b> <a href="http://blog.vtiger.com/" target="_blank">Blog</a><b> I</b> <a href="http://wiki.vtiger.com/index.php/Main_Page" target="_blank">Wiki</a> <b>I </b><a href="http://forums.vtiger.com/" target="_blank">Forums </a><b>I</b> <a href="http://vtiger.com/" target="_blank">Website</a><br>
<br>
</div>