[jira] [Commented] (VCL-870) Synchronize foreign keys and other items between vcl.sql and update-vcl.sql

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

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

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

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

VCL-870 - Synchronize foreign keys and other items between vcl.sql and update-vcl.sql

vcl.sql: changed usergroup entries, for groups that had maxextendtime set to 30, changed that value to 60 to match the default value for new groups

update-vcl.sql:
-added entry to add 'Default for Editable by' user group
-added entry to add admin user to 'Default for Editable by' user group
-added delete to remove connecttimeout entry from variable table (connecttimeout was renamed to reconnecttimeout)
-added entry to add 'xcat|timeout_error_limit' to variable table
-added entry to add 'xcat|rpower_error_limit' to variable table

> Synchronize foreign keys and other items between vcl.sql and update-vcl.sql
> ---------------------------------------------------------------------------
>
>                 Key: VCL-870
>                 URL: https://issues.apache.org/jira/browse/VCL-870
>             Project: VCL
>          Issue Type: Bug
>          Components: database
>            Reporter: Josh Thompson
>             Fix For: 2.5
>
>
> The foreign keys created by the vcl.sql and update-vcl.sql files are not in sync with each other. Some keys are created with things like "ON UPDATE CASCADE" in one file and "ON DELETE CASCADE ON UPDATE CASCADE" in the other file.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)