ALTER TABLE `subject_course`
ADD COLUMN `integration_id` VARCHAR(45) NULL DEFAULT NULL AFTER `same_subjects_to_migrate`;

ALTER TABLE `optional_subject`
ADD COLUMN `integration_id` VARCHAR(45) NULL DEFAULT NULL AFTER `same_subjects_to_migrate`;

ALTER TABLE `subperiod`
ADD COLUMN `integration_code` VARCHAR(45) NULL DEFAULT NULL AFTER `enable_grade_report`;

ALTER TABLE `period`
ADD COLUMN `integration_code` VARCHAR(45) NULL DEFAULT NULL AFTER `options_prd`;

ALTER TABLE `year_period_exam_setup`
ADD COLUMN `integration_code` VARCHAR(45) NULL DEFAULT NULL AFTER `weight_ype`;

ALTER TABLE `level_section_year`
ADD COLUMN `discipline_subject_integration` VARCHAR(45) NULL DEFAULT NULL AFTER `course_director_grade_weight_lsy`;

CREATE TABLE `power_school_web_services` (
  `serial_psw` INT NOT NULL AUTO_INCREMENT,
  `url_psw` VARCHAR(100) NOT NULL,
  `token_psw` VARCHAR(100) NOT NULL,
  `status_psw` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_psw`),
  UNIQUE INDEX `serial_psw_UNIQUE` (`serial_psw` ASC));


INSERT INTO `process` (`serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('849', 'Administración powerschool', 'laravel/public/powerSchool', '1', 'LOCKABLE');
