Details
-
Bug
-
Resolution: Fixed
-
Major
-
COmanage Registry 0.9.1 (Essential Enneagon Plus One)
Description
The current ADOdb schema file app/Config/Schema/schema.xml found on the develop branch with hash 9816b0869a97b2259e5531f10ab4a12b8ca210d4 has errors and inconsistencies that prevent the console command ./Console/cake database from completing successfully and provisioning the database tables, specifically for Postgresql 9.1 on Debian 7.x.
Specific issues include:
1) The name 'co_extended_types_i2' for an index is used more than once (probably a cut and paste error).
2) The table 'email_addresses' appears too late in the schema, preventing the table co_invites from properly referencing it.
3) The name 'co_settings_i1' for an index is used more than once (probably a cut and paste error).
4) The table co_provisioning_queued_events references co_provisioning_targets but does not properly include the 'cm_' prefix inside of the <constraint> element.