Uploaded image for project: 'VCL'
  1. VCL
  2. VCL-764

Database changes for VCL 2.4

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.2
    • Fix Version/s: 2.4
    • Component/s: database
    • Labels:
      None

      Description

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              arkurth Andrew Kurth
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: