-- Aumetar las columanas de capcha

ALTER TABLE `school_setup` 
ADD COLUMN `web_site_key_sst` VARCHAR(200) NULL AFTER `use_identification_username`,
ADD COLUMN `secret_key_sst` VARCHAR(200) NULL AFTER `web_site_key_sst`;

-- para ejecutar en los demos


update school_setup set web_site_key_sst='6Ldt-F0gAAAAAL2P5apA9Ic1P8xZbBBLB6j3yjag';
update school_setup set secret_key_sst='6Ldt-F0gAAAAACzJXLl7gZA0kPXqXVlQDc8jWGgu';

-- para ejecutar en equipos locales
update school_setup set web_site_key_sst=null;
update school_setup set secret_key_sst=null;

ALTER TABLE `school_setup` 
CHANGE COLUMN `options` `options` SET('SEND_COPY_ALL_GUARDIANS', 'ADMISSION_ECSOLVENCY', 'ADMISSION_HIDEADDINSTITUTIONS', 'SKILLS', 'SHOW_SUBPERIOD_REPORT_CARD', 'SHOW_PERIOD_REPORT_CARD', 'CRON_CREATE_ACTIVITY', 'SHOW_PAI_REPORT_CARD', 'HAS_MOBILE_APP', 'ONLINE_PAYMENT_BY_TYPE_DOCUMENT', 'ADMISSION_SEND_MAIL_GUARDIAN', 'SEND_MAIL_TO_COLECTURIA', 'SEND_MAIL_TO_GENERAL_SECRETARY', 'SEND_MAIL_TO_NURSING', 'ADMISSION_SEND_MAIL_RESET_PASSWORD', 'HAS_SIMULATED_GRADES', 'PRINT_CONTRACT_IN_BURSAR', 'SEND_EMAIL_IN_ADMISSION_REPORT_GRADES', 'SEND_EMAIL_IN_PROCEEDS_TO_TEST', 'SEND_EMAIL_IN_PROCEEDS_TO_INTERVIEW', 'SEND_EMAIL_IN_ADMISSION_REPORT_INTERVIEW', 'USE_SERIAL_USER_IN_TRANSPORT_REPORT', 'DONT_SEND_PUSH_DEFAULT', 'DONT_SEND_EMAIL_DEFAULT', 'SEND_MESSAGE_ON_ACTIVITY', 'SET_MESSAGE_COPY_ACTIVITY', 'USE_EXTERNAL_ROUTE', 'SHOW_SEND_EMAIL', 'SEND_EMAIL_ATTACHMENT_GUARDIAN', 'SEND_EMAIL_ATTACHMENT_STUDENT', 'SEND_EMAIL_WITH_MESSAGE', 'SHOW_ATTACHMENT_ACTIVITY', 'CHOOSE_MULTIPLE_EXTRACURRICULAR', 'SHOW_ALL_CONFIG_SUBJECTS', 'INCIDENT_REPORT_ADMINISTRATION', 'NOT_EDIT_STUDENTS_EMAIL_IN_WIZARD', 'QUOTA_MODALITY_REGISTRATION_PROCESS', 'SEND_EMAIL_WHEN_CREATE_NEW_USER', 'VERIFY_CAPCHA') NULL DEFAULT NULL ;
