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