If the database were already containing the old table. Perform the following to upgrade the database
update releases-geo using the upgrade file
[jiajun@sm-geodnssoc ~]$ mysql -u user -p geo-mozilla-com< database-upgrade.sql
create the new tables and stored procedures
[jiajun@sm-geodnssoc ~]$ mysql -u user -p geo-mozilla-com< database.sql
rebuild the views either from geodns.pl/web UI/mysql before restarting the DNS server
[jiajun@sm-geodnssoc ~]$ mysql –u user –p
mysql> call buildViews();