Issue Fixes

- Fixed Risk Evaluation Form
- Saving Risk Evaluation history in a separate table
- Updated the query and format of Non-TX Contract Report.

TABLE UPDATE QUERY:
ALTER TABLE `reg_patient_risk` ADD COLUMN `comment` MEDIUMTEXT NULL
DEFAULT NULL AFTER `finalscore`;

NEW TABLE QUERY:
CREATE TABLE `reg_patient_risk_history` (
`history_id` INT(11) NOT NULL AUTO_INCREMENT,
`pid` CHAR(36) NOT NULL,
`ort1a` VARCHAR(12) NULL DEFAULT NULL,
`ort1b` VARCHAR(12) NULL DEFAULT NULL,
`ort1c` VARCHAR(12) NULL DEFAULT NULL,
`ort2a` VARCHAR(12) NULL DEFAULT NULL,
`ort2b` VARCHAR(12) NULL DEFAULT NULL,
`ort2c` VARCHAR(12) NULL DEFAULT NULL,
`ort3` VARCHAR(12) NULL DEFAULT NULL,
`ort4` VARCHAR(12) NULL DEFAULT NULL,
`ort5a` VARCHAR(12) NULL DEFAULT NULL,
`ort5b` VARCHAR(12) NULL DEFAULT NULL,
`ortsum` VARCHAR(12) NULL DEFAULT NULL,
`medd` VARCHAR(12) NULL DEFAULT NULL,
`pulmonary` VARCHAR(12) NULL DEFAULT NULL,
`currentrx` VARCHAR(12) NULL DEFAULT NULL,
`histopioid` VARCHAR(12) NULL DEFAULT NULL,
`preocc` VARCHAR(12) NULL DEFAULT NULL,
`unstable` VARCHAR(12) NULL DEFAULT NULL,
`insecure` VARCHAR(12) NULL DEFAULT NULL,
`prioraberrant` VARCHAR(12) NULL DEFAULT NULL,
`ncmscore` VARCHAR(12) NULL DEFAULT NULL,
`finalscore` VARCHAR(12) NULL DEFAULT NULL,
`comment` MEDIUMTEXT NULL,
`date_entered` DATETIME NULL DEFAULT NULL,
`created_by` CHAR(36) NULL DEFAULT NULL,
PRIMARY KEY (`history_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
ROW_FORMAT=COMPACT
AUTO_INCREMENT=1;