[Koha-patches] [PATCH] Adding updates for Suggestions

[Henri-Damien LAURENT]

---
 .../0004-Add_Some_Missing_fields_to_suggestions.pl |   25 ++++++++++++++++++++
 1 files changed, 25 insertions(+), 0 deletions(-)
 create mode 100644 installer/data/mysql/atomicupdate/0004-Add_Some_Missing_fields_to_suggestions.pl

diff --git a/installer/data/mysql/atomicupdate/0004-Add_Some_Missing_fields_to_suggestions.pl b/installer/data/mysql/atomicupdate/0004-Add_Some_Missing_fields_to_suggestions.pl
new file mode 100644
index 0000000..8eed19b
--- /dev/null
+++ b/installer/data/mysql/atomicupdate/0004-Add_Some_Missing_fields_to_suggestions.pl
@@ -0,0 +1,25 @@
+#!/usr/bin/perl
+use strict;
+use warnings;
+use C4::Context;
+my $dbh=C4::Context->dbh;
+$dbh->do(<<SUGGESTIONS);
+ALTER table suggestions 
+    ADD budgetid INT(11),
+    ADD branchcode VARCHAR(10) default NULL,
+    ADD acceptedby INT(11) default NULL,
+    ADD acceptedon date default NULL,
+    ADD suggestedby INT(11) default NULL,
+    ADD suggestedon date default NULL,
+    ADD managedby INT(11) default NULL,
+    ADD managedon date default NULL,
+    ADD rejectedby INT(11) default NULL,
+    ADD rejectedon date default NULL,
+    ADD collectiontitle text default NULL,
+    ADD itemtype VARCHAR(30) default NULL,
+    ADD biblionumber INT(11) default NULL,
+    ADD sort1 VARCHAR(80) default NULL,
+    ADD sort2 VARCHAR(80) default NULL
+    ;
+SUGGESTIONS
+print "Add some fields to suggestions";
-- 
1.6.0.4