-- goldfields Netfoundry-Pay-As-You-Go
SET @billingId_goldfields = (select id from  Account where id = UUID_TO_BIN('81e1342f-95df-4a6e-b34a-b7265dd10507'));
-- technilium_demo Netfoundry-Pay-As-You-Go
SET @billingId_technilium_demo = (select id from  Account where id = UUID_TO_BIN('5be5cfc9-e4c7-4807-a37b-ffc53b96a0b3'));

-- contractId_goldfields
SET @contractId_goldfields = (Select id from Contract where accountId=@billingId_goldfields and active=true);
-- contractId_technilium_demo
SET @contractId_technilium_demo = (Select id from Contract where accountId=@billingId_technilium_demo and active=true);

-- UPDATE Account
UPDATE Account SET active = false, deletedAt=CURDATE() WHERE id in ( @billingId_goldfields, @billingId_technilium_demo);

-- UPDATE Contract
UPDATE Contract SET active = false, deletedAt=CURDATE() WHERE id= @contractId_goldfields;
UPDATE Contract SET active = false, deletedAt=CURDATE() WHERE id= @contractId_technilium_demo;

-- UPDATE BillableResource
UPDATE BillableResource  SET active = false, deletedAt=CURDATE()  where contractId = @contractId_goldfields;
UPDATE BillableResource  SET active = false, deletedAt=CURDATE()  where contractId = @contractId_technilium_demo;