ALTER TABLE `zt_build` DROP `artifacts`;
ALTER TABLE `zt_build` ADD `artifactRepoID` mediumint(8) unsigned NOT NULL default '0' AFTER `bugs`;

DROP TABLE IF EXISTS `zt_devops_action`;
DROP TABLE IF EXISTS `zt_gitfoxsynclog`;

DELETE FROM `zt_cron` WHERE `command` = 'moduleName=instance&methodName=syncGitFoxData';

ALTER TABLE `zt_repo` DROP `gitfoxID`;
ALTER TABLE `zt_oauth` DROP `token`;

DROP TABLE IF EXISTS `zt_env`;

ALTER TABLE `zt_host` DROP `CD`;
ALTER TABLE `zt_host` DROP `sshPort`;
ALTER TABLE `zt_host` DROP `remoteID`;

ALTER TABLE `zt_deploy` DROP `type`;
ALTER TABLE `zt_deploy` DROP `env`;
ALTER TABLE `zt_deploy` DROP `artifact`;
ALTER TABLE `zt_deploy` DROP `releaseTPL`;
ALTER TABLE `zt_deploy` DROP `remoteID`;

ALTER TABLE `zt_deploy` DROP `lastReviewedBy`;
ALTER TABLE `zt_deploy` DROP `lastReviewedDate`;
ALTER TABLE `zt_deploy` DROP `reviewedBy`;

DROP TABLE IF EXISTS `zt_template`;
ALTER TABLE `zt_system` DROP `appKey`;
ALTER TABLE `zt_system` DROP `remoteAppID`;

DROP TABLE IF EXISTS `zt_cluster`;

DELETE FROM `zt_screen` WHERE `builtin` = 1 AND `createdBy` = 'devopsSystem';

ALTER TABLE `zt_metriclib` DROP `artifactrepo`;
