Skip to content
Snippets Groups Projects

Wrong model

2 files
+ 4
2
Compare changes
  • Side-by-side
  • Inline

Files

@@ -441,7 +441,8 @@ CREATE TABLE IF NOT EXISTS `mdb_access`
@@ -441,7 +441,8 @@ CREATE TABLE IF NOT EXISTS `mdb_access`
download BOOLEAN,
download BOOLEAN,
created TIMESTAMP NOT NULL DEFAULT NOW(),
created TIMESTAMP NOT NULL DEFAULT NOW(),
PRIMARY KEY (aUserID, aDBID),
PRIMARY KEY (aUserID, aDBID),
FOREIGN KEY (`aDBID`) REFERENCES mdb_databases (`id`)
FOREIGN KEY (`aDBID`) REFERENCES mdb_databases (`id`),
 
FOREIGN KEY (`aUserID`) REFERENCES mdb_users (`id`)
) WITH SYSTEM VERSIONING;
) WITH SYSTEM VERSIONING;
CREATE TABLE IF NOT EXISTS `mdb_have_access`
CREATE TABLE IF NOT EXISTS `mdb_have_access`
Loading