From 065e33bdd752b298b896a03880d445b54bec2e69 Mon Sep 17 00:00:00 2001 From: Brendan Gallagher Date: Thu, 31 Dec 2015 19:45:35 +0000 Subject: [PATCH] Removing the amoticupdate file Signed-off-by: Brendan Gallagher brendan@bywatersolutions.com --- installer/data/mysql/atomicupdate/bug_14945.sql | 13 ------------- 1 file changed, 13 deletions(-) delete mode 100644 installer/data/mysql/atomicupdate/bug_14945.sql diff --git a/installer/data/mysql/atomicupdate/bug_14945.sql b/installer/data/mysql/atomicupdate/bug_14945.sql deleted file mode 100644 index 497e98f84f..0000000000 --- a/installer/data/mysql/atomicupdate/bug_14945.sql +++ /dev/null @@ -1,13 +0,0 @@ -INSERT INTO systempreferences (variable,value,options,explanation,type) VALUES ('StoreLastBorrower','0','','If ON, the last borrower to return an item will be stored in items.last_returned_by','YesNo'); - -CREATE TABLE IF NOT EXISTS `items_last_borrower` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `itemnumber` int(11) NOT NULL, - `borrowernumber` int(11) NOT NULL, - `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - PRIMARY KEY (`id`), - UNIQUE KEY `itemnumber` (`itemnumber`), - KEY `borrowernumber` (`borrowernumber`), - CONSTRAINT `items_last_borrower_ibfk_2` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, - CONSTRAINT `items_last_borrower_ibfk_1` FOREIGN KEY (`itemnumber`) REFERENCES `items` (`itemnumber`) ON DELETE CASCADE ON UPDATE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- 2.20.1