[
https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Josh Thompson updated VCL-763:
------------------------------
Comment: was deleted
(was: This is an automated message from the NC State Service Desk.
Acknowledgement for: [1]INC2505301Thank 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:19:04 EDT
Modified 2015-04-03 14:19:04 EDT
State New
Assignment Group VCL
Customer Info
()
Contact Type Email
Comments:
2015-04-03 14:19:04 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=14394813#comment-14394813
]
ASF subversion and git services commented on VCL-763:
-----------------------------------------------------
Commit 1671119 from [~jfthomps] in branch 'vcl/trunk'
[ https://svn.apache.org/r1671119 ]
VCL-763 - Add missing constraints to database tables
vcl.sql and update-vcl.sql: modified foreign key constraint for
nathostcomputermap.nathostid to be ON DELETE SET NULL ON UPDATE CASCADE
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
Links:[2]INC2505301This email was sent from a server at North Carolina State
UniversityRaleigh | NC | 27695
Ref:MSG0072037
----------------------------------------------------------------------------------------
[1]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=c788214c6fd7f50045ebea6eae3ee479%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2]
https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=c788214c6fd7f50045ebea6eae3ee479%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: Josh Thompson
> 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)
