upgrade/1.0.2/07_areas.sql

   1 ALTER TABLE geoloc_subadministrativeareas ADD COLUMN administrativearea VARCHAR(255) DEFAULT NULL;
   2
   3     UPDATE  geoloc_subadministrativeareas AS gs
   4 INNER JOIN  profile_addresses             AS pa ON (gs.id = pa.subAdministrativeAreaId)
   5        SET  gs.administrativearea = pa.administrativeAreaId;
   6
   7 -- vim:set syntax=mysql: