@@ -, +, @@ - Add the FK on borrowernumber --- .../data/mysql/atomicupdate/bug_15032.perl | 25 +++++++++++++++++++ installer/data/mysql/kohastructure.sql | 19 ++++++++++++++ 2 files changed, 44 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_15032.perl --- a/installer/data/mysql/atomicupdate/bug_15032.perl +++ a/installer/data/mysql/atomicupdate/bug_15032.perl @@ -0,0 +1,25 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + # $dbh->do( "ALTER TABLE biblio ADD COLUMN badtaste int" ); + + unless ( TableExists('background_jobs') ) { + $dbh->do(q| + CREATE TABLE background_jobs ( + id INT(11) NOT NULL AUTO_INCREMENT, + status VARCHAR(32), + progress INT(11), + size INT(11), + borrowernumber INT(11), + type VARCHAR(64), + data TEXT, + enqueued_on DATETIME DEFAULT NULL, + started_on DATETIME DEFAULT NULL, + ended_on DATETIME DEFAULT NULL, + PRIMARY KEY (id) + ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; + |); + } + + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 15032 - Add new table background_jobs)\n"; +} --- a/installer/data/mysql/kohastructure.sql +++ a/installer/data/mysql/kohastructure.sql @@ -4581,6 +4581,25 @@ CREATE TABLE advanced_editor_macros ( CONSTRAINT borrower_macro_fk FOREIGN KEY ( borrowernumber ) REFERENCES borrowers ( borrowernumber ) ON UPDATE CASCADE ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +-- +-- Table structure for table background_jobs +-- + +DROP TABLE IF EXISTS `background_jobs`; +CREATE TABLE background_jobs ( + id INT(11) NOT NULL AUTO_INCREMENT, + status VARCHAR(32), + progress INT(11), + size INT(11), + borrowernumber INT(11), + type VARCHAR(64), + data TEXT, + enqueued_on DATETIME DEFAULT NULL, + started_on DATETIME DEFAULT NULL, + ended_on DATETIME DEFAULT NULL, + PRIMARY KEY (id) +) 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 */; --