Florian Schmedding created CONNECTORS-887:
---------------------------------------------

             Summary: Database schema not updated properly
                 Key: CONNECTORS-887
                 URL: https://issues.apache.org/jira/browse/CONNECTORS-887
             Project: ManifoldCF
          Issue Type: Bug
          Components: Framework core
    Affects Versions: ManifoldCF 1.6
         Environment: MySQL database
            Reporter: Florian Schmedding
            Priority: Minor


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.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)

Reply via email to