downgrade_0066---0065.sql « db - fixmystreet - This is mySociety's popular map-based reporting platform: easy to install in new countries and regions http://fixmystreet.org/

about summary refs log tree commit diff stats

path: root/db/downgrade_0066---0065.sql

blob: 7c2b146605265a4ee63d006ff74207da7efe35f9 (plain)

BEGIN;

ALTER TABLE users ADD COLUMN area_id integer;
UPDATE users SET area_id = area_ids[1];
ALTER TABLE users DROP COLUMN area_ids;

COMMIT;