update order of table drops
@@ -29,13 +29,13 @@ set FOREIGN_KEY_CHECKS=1;
-- AIRAVATA-2938: bring database schema into sync with registry-refactoring DB init scripts
-- somehow these workflow tables got created in the replica_catalog schema
DROP TABLE IF EXISTS `PORT`;
-DROP TABLE IF EXISTS `WORKFLOW`;
DROP TABLE IF EXISTS `WORKFLOW_OUTPUT`;
DROP TABLE IF EXISTS `WORKFLOW_STATUS`;
-DROP TABLE IF EXISTS `NODE`;
DROP TABLE IF EXISTS `WORKFLOW_INPUT`;
+DROP TABLE IF EXISTS `NODE`;
DROP TABLE IF EXISTS `COMPONENT_STATUS`;
DROP TABLE IF EXISTS `EDGE`;
+DROP TABLE IF EXISTS `WORKFLOW`;
set FOREIGN_KEY_CHECKS=0;
ALTER TABLE `DATA_PRODUCT` CHANGE `PRODUCT_TYPE` `PRODUCT_TYPE` varchar(10) DEFAULT NULL;
ALTER TABLE `DATA_REPLICA_LOCATION` CHANGE `REPLICA_LOCATION_CATEGORY` `REPLICA_LOCATION_CATEGORY` varchar(26) DEFAULT NULL;
