MySQL create-schemas.sql error

Am trying to setup Wisemapping on docker with Mysql (v5.7 or v8.0) and when I run the create-schemas.sql scipt it errors with the following.

Error in query (1064): Syntax error near 'UNIQUE KEY UC_ROLE (mindmap_id,colaborator_id) ) CHARACTER SET utf8' at line 14

CREATE TABLE COLLABORATION ( id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, colaborator_id INTEGER NOT NULL, properties_id INTEGER NOT NULL, mindmap_id INTEGER NOT NULL, role_id INTEGER NOT NULL, FOREIGN KEY (colaborator_id) REFERENCES COLLABORATOR (id), FOREIGN KEY (mindmap_id) REFERENCES MINDMAP (id) ON DELETE CASCADE ON UPDATE NO ACTION, FOREIGN KEY (properties_id) REFERENCES COLLABORATION_PROPERTIES (id) ON DELETE CASCADE ON UPDATE NO ACTION UNIQUE KEY UC_ROLE (mindmap_id,colaborator_id)

Comments (2)