From ddb68d9eb22a34eb79c4588eed983ad8e684f1c1 Mon Sep 17 00:00:00 2001 From: =?utf8?q?V=C3=A1s=C3=A1ry=20D=C3=A1niel?= Date: Wed, 14 Feb 2024 16:29:38 +0100 Subject: [PATCH] Enable nulls on asset series_id, season_id --- .../scripts/005_modify_asset_enable_nulls.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) create mode 100644 mc-vod-sync/mc-vod-sync-db/migrations/scripts/005_modify_asset_enable_nulls.sql diff --git a/mc-vod-sync/mc-vod-sync-db/migrations/scripts/005_modify_asset_enable_nulls.sql b/mc-vod-sync/mc-vod-sync-db/migrations/scripts/005_modify_asset_enable_nulls.sql new file mode 100644 index 00000000..7506748e --- /dev/null +++ b/mc-vod-sync/mc-vod-sync-db/migrations/scripts/005_modify_asset_enable_nulls.sql @@ -0,0 +1,15 @@ +-- // Modify Asset +-- Migration SQL that makes the change goes here. +ALTER TABLE asset + ALTER COLUMN season_id DROP NOT NULL + ALTER COLUMN series_id DROP NOT NULL; +CALL SYSPROC.ADMIN_CMD('REORG TABLE asset'); + +-- //@UNDO +-- SQL to undo the change goes here. +ALTER TABLE asset + ALTER COLUMN season_id SET NOT NULL + ALTER COLUMN series_id SET NOT NULL; +CALL SYSPROC.ADMIN_CMD('REORG TABLE asset'); + + -- 2.54.0