0
Accepted

MySQL Export Syntax Error

a.zeillinger 1 year ago updated by Olesya 1 year ago 4

Look at the example below.

There is an opening bracket missing for 2 keys at the end of the create table statement.

Under review

Dear user,

We are looking into this issue. We will notify you as soon as we know more details.

Team - SqlDBM

Accepted

Dear user, could you provide sharelink to your project?

Thank you for your assistance,

SqlDBM Team

Dear user,

did you change the model and it fix the script? Do you know what was the problem?

-- ****************** SqlDBM: MySQL ******************;
-- ***************************************************;


-- ************************************** `S1_usergrouprights`

CREATE TABLE `S1_usergrouprights`
(
`UGRID` int(11) NOT NULL AUTO_INCREMENT ,
`GID` int(11) unsigned NOT NULL ,
`RID` int(11) NOT NULL ,
PRIMARY KEY (`UGRID`),
KEY `fkIdx_331` (`GID`),
CONSTRAINT `FK_331` FOREIGN KEY `fkIdx_331` (`GID`) REFERENCES `S1_usergroups` (`GID`),
KEY `fkIdx_334` (`RID`),
CONSTRAINT `FK_334` FOREIGN KEY `fkIdx_334` (`RID`) REFERENCES `S1_rights` (`RID`),
KEY `Index_sys_usergrouprights_872` (`GID`),
KEY `Index_sys_usergrouprights_873` (`RID`)
) AUTO_INCREMENT=25 ENGINE=INNODB;

Thank you for your assistance,

SqlDBM Team