[platal.git] / upgrade / 1.0.2 / 07_areas.sql

ALTER TABLE geoloc_subadministrativeareas ADD COLUMN administrativearea VARCHAR(255) DEFAULT NULL;

    UPDATE  geoloc_subadministrativeareas AS gs
INNER JOIN  profile_addresses             AS pa ON (gs.id = pa.subAdministrativeAreaId)
       SET  gs.administrativearea = pa.administrativeAreaId;

-- vim:set syntax=mysql:
Commit	Line	Data
9895bd60 SJ	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: