

alter table `ceulocker`.`organizations` 
   add column `organization_short_desc` varchar(100) NULL after `scoring_type_id_fk`, 
   add column `organization_expanded_desc` varchar(500) NULL after `organization_short_desc`, 
   add column `organization_postal_address` varchar(255) NULL after `organization_expanded_desc`, 
   add column `org_approval_seal_abbr` varchar(255) NULL after `organization_postal_address`, 
   add column `org_email_address` varchar(100) NULL after `org_approval_seal_abbr`, 
   add column `provider/holder_email_address` varchar(100) NULL after `org_email_address`, 
   add column `org_country` varchar(50) NULL after `provider/holder_email_address`, 
   add column `org_state` varchar(50) NULL after `org_country`, 
   add column `org_edu_URL` varchar(100) NULL after `org_state`, 
   add column `org_logo_graphic` varchar(100) NULL after `org_edu_URL`, 
   add column `org_time_zone` varchar(50) NULL after `org_logo_graphic`, 
   add column `org_ceulocker_unique_ID` varchar(100) NULL after `org_time_zone`, 
   add column `org_website_url` varchar(100) NULL after `org_ceulocker_unique_ID`, 
   add column `org_gov_status_url` varchar(100) NULL after `org_website_url`, 
   add column `org_youtube_link` varchar(100) NULL after `org_gov_status_url`, 
   add column `org_facebook_link` varchar(100) NULL after `org_youtube_link`, 
   add column `org_twitter_link` varchar(100) NULL after `org_facebook_link`, 
   add column `org_linkedIn_link` varchar(100) NULL after `org_twitter_link`

alter table `ceulocker`.`organizations` 
   add column `org_approval_seal_graphic` varchar(255) NULL after `org_approval_seal_abbr`

alter table `ceulocker`.`organizations` 
   change `provider/holder_email_address` `provider_holder_email_address` varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   add column `enable_org_website_url` int NULL after `org_ceulocker_unique_ID`

alter table `ceulocker`.`organizations` 
   add column `enable_gov_status_url` int NULL after `org_website_url`

alter table `ceulocker`.`organizations` 
   add column `enable_youtube_link` int NULL after `org_gov_status_url`

alter table `ceulocker`.`organizations` 
   add column `enable_facebook_link` int NULL after `org_youtube_link`,
   change `org_youtube_link` `org_youtube_link` varchar(100) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   add column `enable_twitter_link` int NULL after `org_facebook_link`

alter table `ceulocker`.`organizations` 
   add column `enable_linkedIn_link` int NULL after `org_twitter_link`

alter table `ceulocker`.`organizations` 
   add column `org_provider_crib_sheet` varchar(100) NULL after `org_linkedIn_link`

alter table `ceulocker`.`organizations` 
   add column `org_provider_specific_email_text` varchar(255) NULL after `org_provider_crib_sheet`

alter table `ceulocker`.`organizations` 
   add column `org_provider_intro_text` varchar(255) NULL after `org_provider_specific_email_text`

alter table `ceulocker`.`organizations` 
   add column `org_holder_intro_text` varchar(500) NULL after `org_provider_intro_text`, 
   add column `org_holder_specific_email_text` varchar(255) NULL after `org_holder_intro_text`, 
   add column `org_holder_specific_email_address` varchar(255) NULL after `org_holder_specific_email_text`, 
   add column `org_holder_crib_sheet` varchar(100) NULL after `org_holder_specific_email_address`,
   change `org_provider_intro_text` `org_provider_intro_text` varchar(500) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   add column `org_reviewer_intro_text` varchar(500) NULL after `org_holder_crib_sheet`, 
   add column `org_reviewer_specific_email_address` varchar(100) NULL after `org_reviewer_intro_text`, 
   add column `org_reviewer_metrics_sheet` varchar(100) NULL after `org_reviewer_specific_email_address`

alter table `ceulocker`.`organizations` 
   change `organization_expanded_desc` `organization_expanded_desc` varchar(2600) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   change `org_provider_intro_text` `org_provider_intro_text` varchar(600) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   change `org_provider_intro_text` `org_provider_intro_text` varchar(600) character set utf8mb4 collate utf8mb4_unicode_ci NULL , 
   change `org_holder_intro_text` `org_holder_intro_text` varchar(600) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   change `org_reviewer_intro_text` `org_reviewer_intro_text` varchar(600) character set utf8mb4 collate utf8mb4_unicode_ci NULL 

alter table `ceulocker`.`organizations` 
   change `org_approval_seal_abbr` `org_approval_seal_abbr` varchar(32) character set utf8mb4 collate utf8mb4_unicode_ci NULL 
   
   
create table organizations_log(
org_log_id integer auto_increment primary key,
organization_id_fk integer references organizations(organization_id),
activity varchar(500),
created_on datetime,
created_by integer
)

alter table organizations add organization_application_status varchar(10)
alter table organizations add organization_approved bit default 0


alter table `ceulocker`.`organizations` 
add column `created_date` datetime DEFAULT CURRENT_TIMESTAMP NULL after `organization_approved`, 
add column `last_modified_date` datetime DEFAULT CURRENT_TIMESTAMP NULL after `created_date`

ALTER TABLE organizations ADD isDeleted BIT DEFAULT 0

ALTER TABLE ceu_application_organization_status ADD isActive BIT DEFAULT 1

alter table ceulocker.organizations 
add default_approval_period int

alter table ceulocker.organizations 
add credit_term_name varchar(150)

alter table ceulocker.organizations 
add credit_term_abbreviation varchar(50)