Bugzilla – Attachment 143894 Details for
Bug 32187
(Bug 24161 follow-up) With IndependentBranches on a non superlibrarian librarian is not able to track late orders
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 32187: DB changes
Bug-32187-DB-changes.patch (text/plain), 2.31 KB, created by
Jonathan Druart
on 2022-11-15 09:10:14 UTC
(
hide
)
Description:
Bug 32187: DB changes
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2022-11-15 09:10:14 UTC
Size:
2.31 KB
patch
obsolete
>From 1b622ef1e72b04bcf17fab06023dd17278e85e7a Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Tue, 15 Nov 2022 10:07:58 +0100 >Subject: [PATCH] Bug 32187: DB changes > >--- > installer/data/mysql/kohastructure.sql | 5 +++-- > 1 file changed, 3 insertions(+), 2 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 7015a95ff34..510d409aee7 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -328,7 +328,7 @@ CREATE TABLE `aqbasket` ( > `creationdate` date DEFAULT NULL COMMENT 'the date the basket was created', > `closedate` date DEFAULT NULL COMMENT 'the date the basket was closed', > `booksellerid` int(11) NOT NULL DEFAULT 1 COMMENT 'the Koha assigned ID for the vendor (aqbooksellers.id)', >- `authorisedby` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the borrowernumber of the person who created the basket', >+ `authorisedby` int(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'the borrowernumber of the person who created the basket', > `booksellerinvoicenumber` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'appears to always be NULL', > `basketgroupid` int(11) DEFAULT NULL COMMENT 'links this basket to its group (aqbasketgroups.id)', > `deliveryplace` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'basket delivery place', >@@ -345,7 +345,8 @@ CREATE TABLE `aqbasket` ( > CONSTRAINT `aqbasket_ibfk_1` FOREIGN KEY (`booksellerid`) REFERENCES `aqbooksellers` (`id`) ON UPDATE CASCADE, > CONSTRAINT `aqbasket_ibfk_2` FOREIGN KEY (`contractnumber`) REFERENCES `aqcontract` (`contractnumber`), > CONSTRAINT `aqbasket_ibfk_3` FOREIGN KEY (`basketgroupid`) REFERENCES `aqbasketgroups` (`id`) ON UPDATE CASCADE, >- CONSTRAINT `aqbasket_ibfk_4` FOREIGN KEY (`branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE >+ CONSTRAINT `aqbasket_ibfk_4` FOREIGN KEY (`branch`) REFERENCES `branches` (`branchcode`) ON DELETE SET NULL ON UPDATE CASCADE, >+ CONSTRAINT `aqbasket_ibfk_5` FOREIGN KEY (`authorisedby`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE > ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; > /*!40101 SET character_set_client = @saved_cs_client */; > >-- >2.25.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 32187
: 143894 |
143895