X-Git-Url: http://git.pippins.net/embedvideo/.git/static/git-logo.png?a=blobdiff_plain;f=bin%2Fupgrade_2_0_to_3_0;fp=bin%2Fupgrade_2_0_to_3_0;h=c37ba9dee53b6522931f5e09c07bec39d4002970;hb=4800cbc5c11e33d6f32ea72c80c07a71ab02c158;hp=265699f2add53615ff136f2efac3505cd065f445;hpb=df320830596790d3601a8a693227103d1f6df11f;p=eq%2F.git

diff --git a/bin/upgrade_2_0_to_3_0 b/bin/upgrade_2_0_to_3_0
index 265699f..c37ba9d 100755
--- 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";
 
+# 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";