X-Git-Url: http://git.pippins.net/embedvideo/.git/static/gitweb.js?a=blobdiff_plain;f=bin%2Fupgrade_4_0_to_5_0;h=c27fa3ac4f2b1dd473001258455e89c8fd575ec2;hb=bf339f318906f8965f5b81e9e4c5eb431f57219a;hp=f1952234504a53eeb0be93c2790d1c217ba1b4b6;hpb=4b94ceb350683f086a54ed56dbb966455b0bfedc;p=eq%2F.git diff --git a/bin/upgrade_4_0_to_5_0 b/bin/upgrade_4_0_to_5_0 index f195223..c27fa3a 100755 --- a/bin/upgrade_4_0_to_5_0 +++ b/bin/upgrade_4_0_to_5_0 @@ -75,12 +75,8 @@ $sth->execute or die "-E- DB error: $DBI::errstr\n"; $sth = $dbh->prepare("ALTER TABLE `tc_indiv` CHANGE `elder` `indiv` INT(16) NOT NULL AUTO_INCREMENT"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; -# Add a new 'birthday' column to the tc_indiv table -$sth = $dbh->prepare("ALTER TABLE `tc_indiv` ADD `birthday` DATE NULL DEFAULT NULL AFTER `name` "); -$sth->execute or die "-E- DB error: $DBI::errstr\n"; - # Add a new 'address' column to the tc_indiv table -$sth = $dbh->prepare("ALTER TABLE `tc_indiv` ADD `address` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `birthday`"); +$sth = $dbh->prepare("ALTER TABLE `tc_indiv` ADD `address` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `name`"); $sth->execute or die "-E- DB error: $DBI::errstr\n"; # Add a new 'family' column to the tc_indiv table