generate "alter table" statements based on rules

[rkiddy]

There is going to be a smarter way to do this than just the obvious.

For example, the longitude and latitude columns can be changed to decimal(12,8).

I want to have a fetch_special_after.sql file that does these alters. I tried to generate them with an awk script and it got a bit dumb.

I could just look at the database and change all of the columns with this name, but I want to do it per dataset so that it only gets done when needed.