Attachment 100866 Details for Bug 18177 – Bug 18177: DB changes

[patch] Bug 18177: DB changes

Bug-18177-DB-changes.patch (text/plain), 1.40 KB, created by Jonathan Druart on 2020-03-17 09:00:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-03-17 09:00:38 UTC

Size: 1.40 KB

patch

obsolete

>From 17877584a9ab0d9bb36151de721ec88649926f75 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Tue, 17 Mar 2020 09:50:18 +0100
>Subject: [PATCH] Bug 18177: DB changes
>
>---
> installer/data/mysql/kohastructure.sql | 7 +------
> 1 file changed, 1 insertion(+), 6 deletions(-)
>
>diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
>index 0f092725b5..e3d0d09760 100644
>--- a/installer/data/mysql/kohastructure.sql
>+++ b/installer/data/mysql/kohastructure.sql
>@@ -2764,13 +2764,8 @@ CREATE TABLE `aqbooksellers` ( -- information about the vendors listed in acquis
>   `address3` LONGTEXT, -- third line of vendor physical address
>   `address4` LONGTEXT, -- fourth line of vendor physical address
>   `phone` varchar(30) default NULL, -- vendor phone number
>-  `accountnumber` LONGTEXT, -- unused in Koha
>-  `othersupplier` LONGTEXT,  -- unused in Koha
>-  `currency` varchar(10) NOT NULL default '', -- unused in Koha
>-  `booksellerfax` LONGTEXT, -- vendor fax number
>+  `accountnumber` LONGTEXT, -- vendor account number
>   `notes` LONGTEXT, -- order notes
>-  `bookselleremail` LONGTEXT, -- vendor email
>-  `booksellerurl` LONGTEXT, -- unused in Koha
>   `postal` LONGTEXT, -- vendor postal address (all lines)
>   `url` varchar(255) default NULL, -- vendor web address
>   `active` tinyint(4) default NULL, -- is this vendor active (1 for yes, 0 for no)
>-- 
>2.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 18177: 100861 | 100862 | 100863 | 100864 | 100865 | 100866 | 100867 | 100868 | 100869 | 100870 | 100871 | 100872 | 100873 | 100874 | 101612 | 101687 | 101688 | 101689 | 101690 | 101691 | 101692 | 101693 | 101694 | 101958 | 101959 | 101960 | 101961 | 101962 | 101963 | 101964 | 101965 | 102011