ALTER TABLE `termsrule` ADD COLUMN `termsOptions`  json NOT NULL AFTER `monthly`;

update termsrule
set termsOptions = '[7,14,30,45]', updated = updated
where id in (1,2,3);

update termsrule
set termsOptions = '[1]', updated = updated
where id = 4;

#for Migwell only
update customer
set termsRuleId = 4, terms = 1
where termsRuleId = 1;

update termsrule
set active = 0
where id = 1;
