
Table - application_review_grades
----------------------------------
ALTER TABLE `ceulocker`.`application_review_grades` 
ADD column `conflict_of_interest_reason` varchar(2000) NULL after `xx_association_id`;

alter table `ceulocker`.`application_review_grades` 
   add column `private_admin_comment` varchar(2000) NULL after `conflict_of_interest_reason`, 
   add column `provider_comment` varchar(2000) NULL after `private_admin_comment`

alter table `ceulocker`.`application_review_grades` 
   add column `review_time_spent` int(10) NULL after `provider_comment`

alter table `ceulocker`.`application_review_grades` 
   change `review_time_spent` `review_time_spent` float(10) NULL

Table - application_reviewer_score
------------------------------------
CREATE TABLE `application_reviewer_score` (
  `application_score_id` int(11) NOT NULL AUTO_INCREMENT,
  `reviewerId` int(11) DEFAULT NULL,
  `ceulid` varchar(200) DEFAULT NULL,
  `organization_id_fk` varchar(200) DEFAULT NULL,
  `scoring_category_id_fk` int(11) DEFAULT NULL,
  `score_value` int(11) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modified` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`application_score_id`)
)

Table - ceu_applications
-------------------------
ALTER TABLE `ceulocker`.`ceu_applications` 
ADD column `isErrorFatal` varchar(2000) bit(1) DEFAULT 0 after `active`;

Table - organizations
----------------------
alter table `ceulocker`.`organizations` 
   add column `scoring_type_id_fk` int NULL after `organizationjs`

Table - scoring_category
-------------------------
CREATE TABLE `scoring_category` (
  `scoring_category_id` int(11) NOT NULL AUTO_INCREMENT,
  `organization_id_fk` varchar(50) DEFAULT NULL,
  `scoring_category_name` varchar(50) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modified` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`scoring_category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

insert  into `scoring_category`(`scoring_category_id`,`organization_id_fk`,`scoring_category_name`,`date_created`,`date_modified`) values (1,'af84b18e-6943-11e4-bad8-d49433213vvc','Educational Value','2020-11-21 05:18:56','2020-11-21 05:18:56'),(2,'af84b18e-6943-11e4-bad8-d49433213vvc','Difficulty Level','2020-11-21 05:19:05','2020-11-21 05:19:05'),(3,'af84b18e-6943-11e4-bad8-d49433213vvc','Originality','2020-11-21 05:19:35','2020-11-21 05:19:35');

Table - scoring_types
----------------------
CREATE TABLE `scoring_types` (
  `scoring_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `scoring_type_desc` varchar(200) DEFAULT NULL,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `date_modified` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`scoring_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

insert  into `scoring_types`(`scoring_type_id`,`scoring_type_desc`,`date_created`,`date_modified`) values (1,'1-10 scale','2020-11-21 05:07:24','2020-11-21 05:07:24'),(2,'1-5 scale','2020-11-21 05:07:49','2020-11-21 05:07:49'),(3,'Yes/No scale','2020-11-21 05:08:02','2020-11-21 05:08:02'),(4,'Accept/Reject','2020-11-21 05:08:14','2020-11-21 05:08:14');


alter table `ceulocker`.`application_discussion_group` 
   change `ceulid_fk` `ceulid_fk` varchar(100) character set utf8mb4 collate utf8mb4_general_ci NULL , 
   change `description` `description` varchar(600) character set utf8mb4 collate utf8mb4_general_ci NULL 


alter table `ceulocker`.`application_discussion_comments` 
   change `comment` `comment` varchar(600) character set utf8mb4 collate utf8mb4_general_ci NULL 


ALTER TABLE application_reviews ADD isActive BIT DEFAULT 1
ALTER TABLE ceu_application_organization_status ADD isActive BIT DEFAULT 1
ALTER TABLE application_review_grades ADD isUrgent BIT DEFAULT 0
alter table `ceulocker`.`application_review_grades` 
add column `adminNotation` varchar(600) NULL after `isUrgent`