Mercurial > gemma

annotate schema/updates/1317/01.migrate_styles.sql @ 5007:799e8248de8d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
First step to move geometry creation for WFS features to loader.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 11 Mar 2020 14:23:52 +0100
parents 4a9a1e323e11
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4918
4a9a1e323e11 First version of geo styles in ZIP files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
1 ALTER TABLE sys_admin.published_services ADD COLUMN bin_blob bytea;
4a9a1e323e11 First version of geo styles in ZIP files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
2 UPDATE sys_admin.published_services SET bin_blob = style::text::bytea WHERE style is NOT NULL;
4a9a1e323e11 First version of geo styles in ZIP files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
3 ALTER TABLE sys_admin.published_services DROP COLUMN style;
4a9a1e323e11 First version of geo styles in ZIP files.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
4 ALTER TABLE sys_admin.published_services RENAME COLUMN bin_blob TO style;