Yaniv Dary has uploaded a new change for review. Change subject: history: made several changes to vm disks tables ......................................................................
history: made several changes to vm disks tables - dropped old indexes on image_id and created indexes on vm_disk_id. - changed image_id to nullable and vm_disk_id to not nullable. - changed vm_disks_usage_daily_history time column type to date. - changed disk description to 500 chars Change-Id: Ib4f01238d50a8bd21b4b08f5aa03b2c6c771df93 Signed-off-by: Yaniv Dary <[email protected]> --- A data-warehouse/historydbscripts_postgres/upgrade/03_03_0030_change_vm_disks_tables.sql 1 file changed, 40 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/82/17482/1 diff --git a/data-warehouse/historydbscripts_postgres/upgrade/03_03_0030_change_vm_disks_tables.sql b/data-warehouse/historydbscripts_postgres/upgrade/03_03_0030_change_vm_disks_tables.sql new file mode 100644 index 0000000..0052546 --- /dev/null +++ b/data-warehouse/historydbscripts_postgres/upgrade/03_03_0030_change_vm_disks_tables.sql @@ -0,0 +1,40 @@ +--drop old indexes on image_id +DROP INDEX vm_disk_configuration_vm_disk_id_idx; +DROP INDEX vm_disk_samples_history_vm_disk_id_idx; +DROP INDEX vm_disk_hourly_history_vm_disk_id_idx; +DROP INDEX vm_disk_daily_history_vm_disk_id_idx; + +--change image_id to nullable and vm_disk_id to not nullable +ALTER TABLE vm_disk_configuration ALTER COLUMN image_id DROP NOT NULL; +ALTER TABLE vm_disk_samples_history ALTER COLUMN image_id DROP NOT NULL; +ALTER TABLE vm_disk_hourly_history ALTER COLUMN image_id DROP NOT NULL; +ALTER TABLE vm_disk_daily_history ALTER COLUMN image_id DROP NOT NULL; + +--first set default to pervent converation issues +ALTER TABLE vm_disk_configuration ALTER COLUMN vm_disk_id SET DEFAULT cast('00000000-0000-0000-0000-000000000000' as UUID); +ALTER TABLE vm_disk_samples_history ALTER COLUMN vm_disk_id SET DEFAULT cast('00000000-0000-0000-0000-000000000000' as UUID); +ALTER TABLE vm_disk_hourly_history ALTER COLUMN vm_disk_id SET DEFAULT cast('00000000-0000-0000-0000-000000000000' as UUID); +ALTER TABLE vm_disk_daily_history ALTER COLUMN vm_disk_id SET DEFAULT cast('00000000-0000-0000-0000-000000000000' as UUID); + +ALTER TABLE vm_disk_configuration ALTER COLUMN vm_disk_id SET NOT NULL; +ALTER TABLE vm_disk_samples_history ALTER COLUMN vm_disk_id SET NOT NULL; +ALTER TABLE vm_disk_hourly_history ALTER COLUMN vm_disk_id SET NOT NULL; +ALTER TABLE vm_disk_daily_history ALTER COLUMN vm_disk_id SET NOT NULL; + +--now removing the default value +ALTER TABLE vm_disk_configuration ALTER COLUMN vm_disk_id DROP DEFAULT; +ALTER TABLE vm_disk_samples_history ALTER COLUMN vm_disk_id DROP DEFAULT; +ALTER TABLE vm_disk_hourly_history ALTER COLUMN vm_disk_id DROP DEFAULT; +ALTER TABLE vm_disk_daily_history ALTER COLUMN vm_disk_id DROP DEFAULT; + +--now recreate indexes +CREATE INDEX vm_disk_configuration_vm_disk_id_idx ON vm_disk_configuration(vm_disk_id); +CREATE INDEX vm_disk_samples_history_vm_disk_id_idx ON vm_disk_samples_history(vm_disk_id); +CREATE INDEX vm_disk_hourly_history_vm_disk_id_idx ON vm_disk_hourly_history(vm_disk_id); +CREATE INDEX vm_disk_daily_history_vm_disk_id_idx ON vm_disk_daily_history(vm_disk_id); + +--change daily time column type to date +ALTER TABLE vm_disks_usage_daily_history ALTER COLUMN history_datetime TYPE DATE; + +--change disk description to 500 chars +ALTER TABLE vm_disk_configuration ALTER COLUMN vm_disk_description TYPE VARCHAR(500); -- To view, visit http://gerrit.ovirt.org/17482 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib4f01238d50a8bd21b4b08f5aa03b2c6c771df93 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
