diff options
| author | Dave Whiteland <dave@mysociety.org> | 2013-02-06 15:08:23 +0000 |
|---|---|---|
| committer | Dave Whiteland <dave@mysociety.org> | 2013-02-06 15:08:23 +0000 |
| commit | 0f24a44cd6e8b056db482cb91c85768b6d1e7d1d (patch) | |
| tree | 09a90f38574ee62754f3c8ac077152ed99a38296 /db/schema_0030-add-body-name.sql | |
| parent | c061769ba72f420e2f2c6064fa526648e57339f1 (diff) | |
| parent | 5b2e18389734751165d2eeb21a3b3f2e8d2e8755 (diff) | |
Merge remote branch 'origin/master' into oxfordshire-header
Diffstat (limited to 'db/schema_0030-add-body-name.sql')
| -rw-r--r-- | db/schema_0030-add-body-name.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/db/schema_0030-add-body-name.sql b/db/schema_0030-add-body-name.sql new file mode 100644 index 000000000..30ac26e98 --- /dev/null +++ b/db/schema_0030-add-body-name.sql @@ -0,0 +1,7 @@ +begin; + +ALTER TABLE body ADD name text; +UPDATE body SET name=''; +ALTER table body ALTER COLUMN name SET NOT NULL; + +commit; |