[
https://issues.apache.org/jira/browse/VCL-764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14250200#comment-14250200
]
ASF subversion and git services commented on VCL-764:
-----------------------------------------------------
Commit 1646301 from [~arkurth] in branch 'vcl/trunk'
[ https://svn.apache.org/r1646301 ]
VCL-764
Removed explicit id values for computerloadstate table.
Updated computerloadstate entries:
Removed connected
Changed connecttimeout to reconnecttimeout
Added noinitialconnection, initialconnecttimeout
Changed variable name: connecttimeout --> reconnecttimeout
Added variable: initialconnecttimeout
VCL-763
Added indexes and constraints to computerloadlog for loadstateid and
computerloadlog columns.
> Database changes for VCL 2.4
> ----------------------------
>
> Key: VCL-764
> URL: https://issues.apache.org/jira/browse/VCL-764
> Project: VCL
> Issue Type: Improvement
> Components: database
> Affects Versions: 2.3.2
> Reporter: Andy Kurth
> Fix For: 2.4
>
>
> This is a catchall issue to track database changes for VCL 2.4 which aren't
> directly related to another issue.
> We really need to rework the database update process when upgrading VCL
> versions. update-vcl.sql is difficult to manage and keep in sync with
> vcl.sql. A single Perl script could be written which could be used for both
> fresh installs and updates.
> For fresh installs, it could simply import the vcl.sql file.
> For updates, it could query the existing database in order to determine if
> table definitions match vcl.sql and then execute an "alter" statement. This
> will be much easier to code than the current stored procedures in
> update-vcl.sql.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
