[Koha-patches] [PATCH] Fix kohastructure for deletedborrowers

Nahuel ANGELINETTI nahuel.angelinetti at biblibre.com
Tue Mar 30 11:55:27 CEST 2010


This patch add a forgotten column in deletedborrowers, that make koha doesn't save deletedborrowers in fresh installs.
---
 installer/data/mysql/kohastructure.sql |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql
index 2b62abf..c4f2558 100644
--- a/installer/data/mysql/kohastructure.sql
+++ b/installer/data/mysql/kohastructure.sql
@@ -900,6 +900,7 @@ CREATE TABLE `deletedborrowers` (
   `altcontactaddress3` varchar(255) default NULL,
   `altcontactzipcode` varchar(50) default NULL,
   `altcontactphone` varchar(50) default NULL,
+  `smsalertnumber` varchar(50) default NULL,
   KEY `borrowernumber` (`borrowernumber`),
   KEY `cardnumber` (`cardnumber`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
1.6.3.3




More information about the Koha-patches mailing list