--- .../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 _______________________________________________ Koha-patches mailing list [email protected] http://lists.koha.org/mailman/listinfo/koha-patches
