ctsit / rcc.billing

Automated, data-driven service billing implemented on REDCap Custodian
https://ctsit.github.io/rcc.billing/
Apache License 2.0
0 stars 3 forks source link

On 11/10, execute this SQL code... #185

Closed pbchase closed 1 year ago

pbchase commented 1 year ago

On 11/10, execute this SQL code against the rcc.billing DB:

update ctsi_rcc_billing.service_type set price = 130, service_type = “Annual REDCap Project Maintenance” where service_type_code = 1;
pbchase commented 1 year ago

Also had to enlarge the service_type column. i.e., I did this:

ALTER TABLE `ctsi_rcc_billing`.`service_type` 
CHANGE COLUMN `service_type` `service_type` VARCHAR(50) NULL DEFAULT NULL ;
pbchase commented 1 year ago

I made the MySQL changes in Prod. They suggested a schema changes in the code, so I made those changes as part of PR #192. I also reflected the SQL update command above in the test data. The tests still pass with no other modification