[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388518#comment-14388518
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670335 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670335 ]
VCL-763 - Add missing constraints to database tables
vcl.sql:
-modified blockRequest.groupid to allow NULL
-modified statgraphcache.affiliationid and statgraphcache.provisioningid to
allow NULL
update-vcl.sql:
-changes for blockRequest table: change groupid and managementnodeid to allow
NULL; added updates to change any entries that had those fields set to 0 to be
NULL
-changes for statgraphcache table: changed fields affiliationid and
provisioningid in create table for statgraphcache to allow NULL; added alter
tables to change those fields to allow NULL for when the table already exists;
added updates to change any entries that had those fields set to 0 to be NULL;
added deletes to remove any entries from statgraphcache where affiliationid or
provisioningid have values that are not in the corresponding tables
-changes for blockRequest constraints: changed foreign keys for groupid and
managementnodeid to set null on delete and cascade on update
-changes for statgraphcache constraints: remove existing constraints, recreate
them with cascade for both detele and update
> Add missing constraints to database tables
> ------------------------------------------
>
> Key: VCL-763
> URL: https://issues.apache.org/jira/browse/VCL-763
> Project: VCL
> Issue Type: Improvement
> Components: database
> Affects Versions: 2.3.2
> Reporter: Andy Kurth
> Assignee: Andy Kurth
> Priority: Minor
> Fix For: 2.4
>
>
> There are some database columns which reference another table which are
> missing a constraint. One example is computer.vmhostid. It's handy to have
> the constraints defined.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
