[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390562#comment-14390562
]
NCSU Service Desk commented on VCL-763:
---------------------------------------
Your support incident has been updated with the following comment:
2015-04-01 09:43:10 EDT - Marhn Fullmer (Additional comments)
Forwarded by: [email protected]:
---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <[email protected]>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: [email protected]
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14390531#comment-14390531
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1670641 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1670641 ]
VCL-763 - Add missing constraints to database tables
statistics.php: modified addToStatGraphCache: added code to set $affilid
and $provid to 'NULL' when they are passed in as 0 so that NULL is used in
the insert query instead of 0 to prevent a foreign key constraint error
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)
Click here to view:
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
Ref:MSG0052940
> 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)
