db.migration.V9__Remove_Unique_from_DataSource.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of quark-catalog Show documentation

There is a newer version: 6.0.3

BEGIN;
ALTER TABLE data_sources ADD COLUMN temp_col VARCHAR(200) NOT NULL DEFAULT 'TMP';

UPDATE data_sources
SET temp_col = name;

ALTER TABLE data_sources DROP COLUMN name;

ALTER TABLE data_sources ADD COLUMN name VARCHAR(200) NOT NULL;

UPDATE data_sources
SET name = temp_col;

ALTER TABLE data_sources DROP COLUMN temp_col;
COMMIT;