[jira] [Issue Comment Deleted] (VCL-763) Add missing constraints to database tables

["Andy Kurth (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/VCL-763?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andy Kurth updated VCL-763:
---------------------------
    Comment: was deleted

(was: This is an automated message from the NC State Service Desk.


Acknowledgement for: [1]INC2504067
The NC State Help Desk has received your message and logged it in 
our automated tracking system. This is an automatic response. You 
will be receiving a more personal response from us shortly.

Any further communication you have with us will automatically become
part of the log for this call.  Please do not alter the Subject line
when replying via email since it contains the identifying "Call ID
Tracking Number".  When contacting us, please refer to this number
(this is not a phone number).

If you do not hear from us soon and would like to check on the status
of your call, go to our on-line form on the World Wide Web at the
address:

   http://help.ncsu.edu/myhelp.php

Enter your call's tracking number and click the "Lookup" button.

We will be getting back to you as soon as possible.

The NC State Help Desk is open for business from 7am-6pm, Monday
through Friday, except during official University holidays.

For information on current and proposed system outages or changes,
you may want to visit Sysnews:

   http://sysnews.ncsu.edu/

If you would prefer to search for solutions to your problem while you
await a response from us, you might want to take a look at:

   http://help.ncsu.edu/

Many of the most frequently asked questions are answered there.

Please realize that the contact information we utilize to contact you
must be up to date to ensure a timely response to your query. Please
verify your contact information with the proper University department.
Information about maintaining your contact information can be found at:

   http://help.ncsu.edu/services/get-soln.pl?id=849

Thanks!

Call Information:

	
Description	Fwd: [jira] [Commented] (VCL-763) Add missing constraints to database tables
Created	2015-04-01 09:43:10 EDT

Modified	2015-04-01 09:43:10 EDT

State	New

Assignment Group	ENGR_CSC_NETLABS

Customer Info	Marhn Fullmer
mhfullme@ncsu.edu (mhfullme)
919-515-5343
Contact Type	Email
Comments: 




2015-04-01 09:43:10 EDT - Marhn Fullmer	Additional comments
Forwarded by: mhfullme@ncsu.edu:

---------- Forwarded message ----------
From: ASF subversion and git services (JIRA) <ji...@apache.org>
Date: Wed, Apr 1, 2015 at 9:22 AM
Subject: [jira] [Commented] (VCL-763) Add missing constraints to database
tables
To: dev@vcl.apache.org



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

Links:[2]INC2504067This email was sent from a server at North Carolina State UniversityRaleigh | NC | 27695
 Ref:MSG0052941
----------------------------------------------------------------------------------------
[1] https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%26sysparm_stack=incident_list.do%3Fsysparm_query=active=true
[2] https://ncsu.service-now.com/nav_to.do?uri=incident.do%3Fsys_id=7326de5f6f47b500615fc00aea3ee4c8%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)