From 234b37809da8e32b9b6d7d369c00080841d092ac Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Tue, 28 Jul 2015 10:33:37 -0400 Subject: [PATCH] Bug 14610 - Add new db table --- installer/data/mysql/atomicupdate/bug_14610.sql | 30 +++++++++++++++++++++++ 1 files changed, 30 insertions(+), 0 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_14610.sql diff --git a/installer/data/mysql/atomicupdate/bug_14610.sql b/installer/data/mysql/atomicupdate/bug_14610.sql new file mode 100644 index 0000000..ddfbd6a --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_14610.sql @@ -0,0 +1,30 @@ +CREATE TABLE `koha_kohaqa`.`article_requests` ( + `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , + `borrowernumber` INT( 11 ) NOT NULL, + `biblionumber` INT( 11 ) NOT NULL , + `itemnumber` INT NULL , + `title` TEXT NULL DEFAULT NULL , + `author` TEXT NULL DEFAULT NULL , + `volume` TEXT NULL DEFAULT NULL , + `issue` TEXT NULL DEFAULT NULL , + `date` TEXT NULL DEFAULT NULL , + `pages` TEXT NULL DEFAULT NULL , + `chapters` TEXT NULL DEFAULT NULL , + `created_on` TIMESTAMP NOT NULL , + `updated_on` TIMESTAMP NULL DEFAULT NULL , + INDEX ( `borrowernumber` ), + INDEX ( `biblionumber` ), + INDEX ( `itemnumber` ) + ) ENGINE = INNODB; + +ALTER TABLE `article_requests` ADD FOREIGN KEY ( `borrowernumber` ) REFERENCES `koha_kohaqa`.`borrowers` ( + `borrowernumber` + ) ON DELETE CASCADE ON UPDATE CASCADE ; + +ALTER TABLE `article_requests` ADD FOREIGN KEY ( `biblionumber` ) REFERENCES `koha_kohaqa`.`biblio` ( + `biblionumber` + ) ON DELETE CASCADE ON UPDATE CASCADE ; + +ALTER TABLE `article_requests` ADD FOREIGN KEY ( `itemnumber` ) REFERENCES `koha_kohaqa`.`items` ( + `itemnumber` + ) ON DELETE SET NULL ON UPDATE CASCADE ; -- 1.7.2.5