schema_0030-add-body-name.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/schema_0030-add-body-name.sql

blob: 30ac26e98941394bc1bbc862e697104da6e2c5f5 (plain)

begin;

ALTER TABLE body ADD name text;
UPDATE body SET name='';
ALTER table body ALTER COLUMN name SET NOT NULL;

commit;