[Vtigercrm-developers] [Vtigercrm-commits] [vtiger-commits] r4323 - /vtigercrm/branches/4.2_postgresql_integration/install/5createTables.inc.php

[Mike Fedyk]

vtigercrm-commits at vtiger.fosslabs.com wrote:
> Author: allanbush
> Date: Mon Mar 20 03:04:56 2006
> New Revision: 4323
>
> Log:
> Added dummy sequence requests.
>
> Adodb usually creates sequences on demand, but if it trys to do it during a transaction problems can occur so we'll do them all right after the tables are created.  The side effect of this is that the first id in the tables will be 2 instead of 1.
>
> References ticket:17.
>
> Modified:
>     vtigercrm/branches/4.2_postgresql_integration/install/5createTables.inc.php
>
> Modified: vtigercrm/branches/4.2_postgresql_integration/install/5createTables.inc.php
> ==============================================================================
> --- vtigercrm/branches/4.2_postgresql_integration/install/5createTables.inc.php (original)
> +++ vtigercrm/branches/4.2_postgresql_integration/install/5createTables.inc.php Mon Mar 20 03:04:56 2006
> @@ -227,6 +227,30 @@
>  else
>  	eecho("Tables Successfully created.\n");
>  
> +// ensure required sequences are created (adodb creates them as needed, but if
> +// creation occurs within a transaction we get problems
> +$db->getUniqueID("activity_reminder");
> +$db->getUniqueID("crmentity");
> +$db->getUniqueID("customfield_sequence");
> +$db->getUniqueID("customview");
> +$db->getUniqueID("def_org_share");
> +$db->getUniqueID("emailtemplates");
> +$db->getUniqueID("field");
> +$db->getUniqueID("import_maps");
> +$db->getUniqueID("inventorynotification");
> +$db->getUniqueID("mail_accounts");
> +$db->getUniqueID("notificationscheduler");
> +$db->getUniqueID("potstagehistory");
> +$db->getUniqueID("profile");
> +$db->getUniqueID("relatedlists");
> +$db->getUniqueID("reportmodules");
> +$db->getUniqueID("role");
> +$db->getUniqueID("rss");
> +$db->getUniqueID("selectquery");
> +$db->getUniqueID("systems");
> +$db->getUniqueID("wordtemplates");
Any way this can be detected at runtime instead of storing a list of 
tables that need it in the source?