changed note field in tc_accomplishment to notes

[eq/.git] / bin / upgrade_1_1_0_to_1_1_1

diff --git a/bin/upgrade_1_1_0_to_1_1_1 b/bin/upgrade_1_1_0_to_1_1_1
index 0337a6e2564c6b283b38d0d389aa9115cf7e1a56..7936a7dfc6e374d2cb6b7083dd53843b2d374300 100755 (executable)
--- a/bin/upgrade_1_1_0_to_1_1_1
+++ b/bin/upgrade_1_1_0_to_1_1_1
@@ -90,6 +90,9 @@ $sth->execute or die "-E- DB error: $DBI::errstr\n";
 $sth = $dbh->prepare("UPDATE tc_interview AS ti JOIN tc_leader AS tl SET ti.interviewer=tl.leader WHERE ti.interviewer=tl.individual");
 $sth->execute or die "-E- DB error: $DBI::errstr\n";
 
+# rename note field in tc_accomplishment to notes
+$sth = $dbh->prepare("ALTER TABLE `tc_accomplishment` CHANGE `note` `notes` VARCHAR( 128 ) NOT NULL ");
+$sth->execute or die "-E- DB error: $DBI::errstr\n";
 
 print "-> Done!\n";