[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14394895#comment-14394895
]
NCSU Service Desk commented on VCL-763:
---------------------------------------
This is an automated message from the NC State Service Desk.
Acknowledgement for: [1]INC2505310Thank you for contacting VCL. Your incident
has been placed in our automated tracking system. You may reply to this message
to add additional information.
Call Information:
Description [jira] [Commented] (VCL-763) Add missing constraints to
database tables
Created 2015-04-03 14:40:02 EDT
Modified 2015-04-03 14:40:02 EDT
State New
Assignment Group VCL
Customer Info
()
Contact Type Email
Comments:
2015-04-03 14:40:02 EDT - Guest Additional comments
Received from: [email protected]:
[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14394879#comment-14394879
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1671122 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1671122 ]
VCL-763 - Add missing constraints to database tables
vcl.sql and update-vcl.sql: (last commit was wrong) updated foreign key for
nathostcomputermap.nathostid to be ON DELETE CASCADE ON UPDATE CASCADE
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Links:[2]INC2505310This email was sent from a server at North Carolina State
UniversityRaleigh | NC | 27695
Ref:MSG0072208
----------------------------------------------------------------------------------------
[1]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=ca5d6d8c6fd7f50045ebea6eae3ee4a9%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=ca5d6d8c6fd7f50045ebea6eae3ee4a9%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
> 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)
