Mercurial > gemma

view schema/updates/1317/01.migrate_styles.sql @ 5721:0500d76e074b uploadwg

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed eraseObsoleteGaugesSQL by reintroducing matching on users CC. The condition was removed when introducing file upload, but that leads to too many gauges being removed.
author Sascha Wilde <wilde@sha-bang.de>
date Fri, 19 Apr 2024 16:52:14 +0200
parents 4a9a1e323e11
children
line wrap: on
line source

ALTER TABLE sys_admin.published_services ADD COLUMN bin_blob bytea;
UPDATE sys_admin.published_services SET bin_blob = style::text::bytea WHERE style is NOT NULL;
ALTER TABLE sys_admin.published_services DROP COLUMN style;
ALTER TABLE sys_admin.published_services RENAME COLUMN bin_blob TO style;