diff options
| -rw-r--r-- | db/migrate_from_osgb36_to_wgs84.pl | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/db/migrate_from_osgb36_to_wgs84.pl b/db/migrate_from_osgb36_to_wgs84.pl index 462061281..7ea8fd419 100644 --- a/db/migrate_from_osgb36_to_wgs84.pl +++ b/db/migrate_from_osgb36_to_wgs84.pl @@ -77,6 +77,11 @@ sub migrate_problem_table { $dbh->commit; # every batch of updates } + print "make latitude, longitude columns not null\n"; + $dbh->do("ALTER TABLE problem ALTER COLUMN $_ SET NOT NULL") + for qw(latitude longitude); + $dbh->commit; + # drop old index, create new one print "drop and create indexes\n"; $dbh->do("DROP INDEX problem_state_easting_northing_idx"); |