sdc-os-chef/sdc-cassandra/chef-repo/cookbooks/cassandra-actions/files/default/alter_dox_db.cql


1
2
3
4
5
6
7
8

USE dox;
ALTER TABLE vsp_information ADD questionnaire_data text;
ALTER TABLE vsp_information ADD vlm_version frozen<version>;
ALTER TABLE vsp_information ADD onboarding_method text;
ALTER TABLE vsp_process ADD type text;
alter table entitlement_pool ADD version_uuid text;
alter table license_key_group ADD version_uuid text;
delete from application_config where namespace='vsp.monitoring' and key = 'component.ceilometer';