[
https://issues.apache.org/jira/browse/CLOUDSTACK-2676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13725826#comment-13725826
]
Alena Prokharchyk commented on CLOUDSTACK-2676:
-----------------------------------------------
I think its too late to add as it will affect the db upgrade for all the tables
in cloud/cloud_usage tables.
> Add Not Null Constraint to UUID columns for cloudstack schema to avoid empty
> UUID column
> ----------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-2676
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2676
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.2.0
> Reporter: Min Chen
> Fix For: 4.2.0
>
>
> To make sure that we have a consistent upgrade base for all 4.1 customers
> later, in schema-410to420.sql, we have added sql scripts to populate UUID
> column of all pre-4.1 schema tables with values from their ID column if UUID
> column is NULL. To make this work properly, we require that all UUID columns
> should be populated with values when you add new data into both pre-4.1
> schema or post-4.1 schema. To properly enforce this, we should add Not Null
> constraint at DB level to UUID columns for cloudstack schema. We need to make
> sure you add those constraints after upgrading the data.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
