projects
/
eq
/
.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Added ability to pull address of district leaders for their interviews.
[eq/.git]
/
bin
/
upgrade_2_0_to_3_0
diff --git
a/bin/upgrade_2_0_to_3_0
b/bin/upgrade_2_0_to_3_0
index 265699f2add53615ff136f2efac3505cd065f445..c37ba9dee53b6522931f5e09c07bec39d4002970 100755
(executable)
--- a/
bin/upgrade_2_0_to_3_0
+++ b/
bin/upgrade_2_0_to_3_0
@@
-19,6
+19,10
@@
$dbh=DBI->connect("dbi:mysql:dbname=$dbname:host=$dbhost:port=$dbport",$dbuser,$
$sth = $dbh->prepare("ALTER TABLE `eq_elder` ADD `email` VARCHAR( 120 ) NULL AFTER `phone`");
$sth->execute or die "-E- DB error: $DBI::errstr\n";
$sth = $dbh->prepare("ALTER TABLE `eq_elder` ADD `email` VARCHAR( 120 ) NULL AFTER `phone`");
$sth->execute or die "-E- DB error: $DBI::errstr\n";
+# Add a new 'indiv_id' field to the eq_elder table
+$sth = $dbh->prepare("ALTER TABLE `eq_elder` ADD `indiv_id` INT( 16 ) UNSIGNED NOT NULL AFTER `elder`");
+$sth->execute or die "-E- DB error: $DBI::errstr\n";
+
# Add a new 'location' field to the eq_appointment table
$sth = $dbh->prepare("ALTER TABLE `eq_appointment` ADD `location` VARCHAR( 120 ) NULL AFTER `time`");
$sth->execute or die "-E- DB error: $DBI::errstr\n";
# Add a new 'location' field to the eq_appointment table
$sth = $dbh->prepare("ALTER TABLE `eq_appointment` ADD `location` VARCHAR( 120 ) NULL AFTER `time`");
$sth->execute or die "-E- DB error: $DBI::errstr\n";