From 2a39e02c223801a1ff33cc7ae05e17032b4fea05 Mon Sep 17 00:00:00 2001
From: Henri-Damien LAURENT <henridamien.laurent@biblibre.com>
Date: Tue, 25 Aug 2009 23:56:17 +0200
Subject: [PATCH] Adding updates for Suggestions

Signed-off-by: Galen Charlton <gmcharlt@gmail.com>
---
 ...-Add_Some_Missing_fields_to_suggestions.pl | 25 +++++++++++++++++++
 1 file changed, 25 insertions(+)
 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 0000000000..8eed19b55e
--- /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";
-- 
2.20.1