Uploaded image for project: 'ManifoldCF'
  1. ManifoldCF
  2. CONNECTORS-887

Database schema not updated properly

    XMLWordPrintableJSON

    Details

      Description

      When running Manifold 1.6 the first time with an database schema from Manifold 1.3 the schema is not updated properly. The SQL-command

      "ALTER TABLE authconnections MODIFY groupname VARCHAR(32) NOT NULL REFERENCES authgroups(groupname) ON DELETE RESTRICT"

      fails. It should instead add the column:

      "ALTER TABLE authconnections ADD groupname VARCHAR(32) NOT NULL REFERENCES authgroups(groupname) ON DELETE RESTRICT"

      The next startup after executing the corrected SQL-statement succeeds.

        Attachments

          Activity

            People

            • Assignee:
              kwright@metacarta.com Karl Wright
              Reporter:
              florianschmedding Florian Schmedding
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: