projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
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";
$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";
print "-> Done!\n";