--- /dev/null
+$DBversion = 'XXX'; # will be replaced by the RM
+if( CheckVersion( $DBversion ) ) {
+
+ if( !TableExists( 'itemtypes_branches' ) ) {
+ $dbh->do( "
+ CREATE TABLE itemtypes_branches( -- association table between authorised_values and branches
+ itemtype VARCHAR(10) NOT NULL,
+ branchcode VARCHAR(10) NOT NULL,
+ FOREIGN KEY (itemtype) REFERENCES itemtypes(itemtype) ON DELETE CASCADE,
+ FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
+ ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+ ");
+ }
+
+ SetVersion( $DBversion );
+ print "Upgrade to $DBversion done (Bug 15497 - Add itemtypes_branches table)\n";
+}
PRIMARY KEY (shortcut_name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+--
+-- Table structure for table itemtypes_branches
+--
+
+DROP TABLE IF EXISTS itemtypes_branches;
+CREATE TABLE itemtypes_branches( -- association table between authorised_values and branches
+ itemtype VARCHAR(10) NOT NULL,
+ branchcode VARCHAR(10) NOT NULL,
+ FOREIGN KEY (itemtype) REFERENCES itemtypes(itemtype) ON DELETE CASCADE,
+ FOREIGN KEY (branchcode) REFERENCES branches(branchcode) ON DELETE CASCADE
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;