Getting the following error.
ERROR 1146 (42S02) at line 2 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.heat_template_params' doesn't exist
ERROR 1146 (42S02) at line 6 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.model_recipe' doesn't exist
ERROR 1146 (42S02) at line 10 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service' doesn't exist
ERROR 1146 (42S02) at line 14 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service_recipe' doesn't exist
ERROR 1146 (42S02) at line 18 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.service_to_resource_customizations' doesn't exist
ERROR 1146 (42S02) at line 22 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.vf_module' doesn't exist
ERROR 1146 (42S02) at line 26 in file: '../../main-schemas/MySQL-Catalog-schema.sql': Table 'mso_catalog.vnf_resource_customization' doesn't exist

This is because, foreign key is dropped while table doesn't exits.