[jira] [Commented] (VCL-763) Add missing constraints to database tables

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14387242#comment-14387242 ] 

ASF subversion and git services commented on VCL-763:
-----------------------------------------------------

Commit 1670182 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670182 ]

VCL-763 - Add missing constraints to database tables

requests.php: modified AJeditRequest: fixed call to retryGetSemaphore where '1' was passed for $imageid and $imagerevisionid - the image being added to the semaphore table is not important in this case, but with the foreign key constraint, they need to be values actually in those tables

xmlrpcWrappers.php: modified XMLRPCextendRequest and XMLRPCsetRequestEnding: fixed calls to retryGetSemaphore where '1' was passed for $imageid and $imagerevisionid - the image being added to the semaphore table is not important in this case, but with the foreign key constraint, they need to be values actually in those tables

> 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)