--############################ PROCESO #################################################
INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('634', NULL, 'Departamento de consejería estudiantil', '#', '289', 'LOCKABLE');
INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('635', '634', 'Registro acumulativo general', 'laravel/public/dce/form', '1.1', 'LOCKABLE');
INSERT INTO `process` (`serial_prc`, `prc_serial_prc`, `name_prc`, `link_prc`, `weight_prc`, `status_prc`) VALUES ('639', '634', 'Administración', 'laravel/public/dcemanagement', '1.2', 'LOCKABLE');


-- ALLOW PAGES
INSERT INTO allowed_pages_by_process values 
(635,'dcecontroller@getform'),
(635,'dcecontroller@postOpenAccordion'),
(635,'dcecontroller@postGeneralData'),
(635,'dcecontroller@postFamilyReferences'),
(635,'dcecontroller@postAcademicData'),
(635,'dcecontroller@postDevelopmentRecord'),
(635,'dcecontroller@postFamilyRelationship'),
(635,'dcecontroller@postHabitCustom'),
(635,'dcecontroller@postHealthData'),
(635,'dcecontroller@postSaveOptionFamilyReferences'),
(635,'dcecontroller@postSaveOptionDceYearData'),
(635,'dcecontroller@getDceCommonData'),
(635,'dcecontroller@getFamilyReferencesInfo'),
(635,'dcecontroller@postFamilyPathologicalByStd'),
(635,'dcecontroller@postFamilyReferencesByStd'),
(635,'dcecontroller@postExternalSupportByStd'),
(635,'dcecontroller@postSaveOptionDceDepartment'),
(635,'dcecontroller@postValidateStatusAccordion')
;
INSERT INTO allowed_pages_by_process values 
(639,'dcemanagementcontroller@getindex'),
(639,'dcemanagementcontroller@postSaveData'),
(639,'dcemanagementcontroller@getCatalogData'),
(639,'dcemanagementcontroller@getCatalogDce');








--############################ FIN PROCESO #############################################

--############################ SCRIPT CREATE TABLE #############################################
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Table `dce_counseling_department`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_counseling_department` (
  `serial_scd` INT(11) NOT NULL AUTO_INCREMENT,
  `serial_std` INT(11) NOT NULL,
  `comment_family_references` TEXT NULL,
  `date_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `has_relatives_with_disabilities` ENUM('YES','NO') NULL DEFAULT NULL,
  `relatives_with_disabilities` TEXT NULL DEFAULT NULL,
  `relatives_type_disabilities` SET('INTELLECTUAL','PHYSICS','MOTOR','HEARING','VISUAL') NULL,
  `year_school_entry` VARCHAR(4) NULL DEFAULT NULL,
  `age_mother_pregnancy` VARCHAR(45) NULL DEFAULT NULL,
  `medication_during_pregnancy` TEXT NULL DEFAULT NULL,
  `week_gestation_pregnancy` VARCHAR(45) NULL DEFAULT NULL,
  `type_birth` ENUM('NORMAL','CESAREAN') NULL DEFAULT NULL,
  `difficulty_pregnancy` VARCHAR(45) NULL DEFAULT NULL,
  `difficulty_giving_birth` VARCHAR(45) NULL DEFAULT NULL,
  `birth_weight` VARCHAR(45) NULL DEFAULT NULL,
  `height_birth` VARCHAR(45) NULL DEFAULT NULL,
  `until_age_use_feedingbottle` VARCHAR(45) NULL DEFAULT NULL,
  `age_control_sphincters` VARCHAR(45) NULL DEFAULT NULL,
  `breastfeeding_time` VARCHAR(45) NULL DEFAULT NULL,
  `age_said_first_words` VARCHAR(45) NULL DEFAULT NULL,
  `age_said_sentences` VARCHAR(45) NULL DEFAULT NULL,
  `age_crawl` VARCHAR(45) NULL DEFAULT NULL,
  `age_stood_alone` VARCHAR(45) NULL DEFAULT NULL,
  `age_walked_alone` VARCHAR(45) NULL DEFAULT NULL,
  `age_up_down_stairs_alone` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`serial_scd`),
  INDEX `fk_student_counseling_department_student1_idx` (`serial_std` ASC),
  CONSTRAINT `fk_student_counseling_department_student1`
    FOREIGN KEY (`serial_std`)
    REFERENCES `student` (`serial_std`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `dce_family_references`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_family_references` (
  `serial_fre` INT(11) NOT NULL AUTO_INCREMENT,
  `serial_scd` INT(11) NOT NULL,
  `first_name_fre` VARCHAR(45) NOT NULL,
  `last_name_fre` VARCHAR(45) NOT NULL,
  `birthdate` DATE NULL DEFAULT NULL,
  `relationship_fre` ENUM('MOTHER','FATHER','SIBLING','GRANDPARENT','AUNT_UNCLE','OTHER') NULL DEFAULT NULL,
  `live_with_student` ENUM('YES','NO') NULL DEFAULT NULL,
  `is_student_in_school` ENUM('YES','NO') NULL DEFAULT NULL,
  `died_fre` ENUM('YES','NO') NULL DEFAULT NULL,
  `status_fre` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_fre`),
  INDEX `fk_dce_family_references_dce_counseling_department1_idx` (`serial_scd` ASC),
  CONSTRAINT `fk_dce_family_references_dce_counseling_department1`
    FOREIGN KEY (`serial_scd`)
    REFERENCES `dce_counseling_department` (`serial_scd`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `dce_catalog`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_catalog` (
  `serial_dca` INT(11) NOT NULL AUTO_INCREMENT,
  `name_dca` VARCHAR(45) NOT NULL,
  `type_dca` ENUM('CHANGE_FAMILY_STRUCTURE','RECREATIONAL_ACTIVITIES','STRENGTHS','EXTERNAL_SUPPORT','FAMILY_RELATIONSHIP','BEHAVIOR','FAMILY_PATHOLOGICAL','OTHER') NULL DEFAULT 'OTHER',
  `status_dca` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_dca`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `dce_common_data`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_common_data` (
  `serial_cda` INT(11) NOT NULL AUTO_INCREMENT,
  `serial_scd` INT(11) NOT NULL,
  `serial_dca` INT(11) NOT NULL,
  `age_start` VARCHAR(45) NULL DEFAULT NULL,
  `treatment_time` VARCHAR(45) NULL DEFAULT NULL,
  `relationship` VARCHAR(45) NULL DEFAULT NULL,
  `status_cda` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_cda`),
  INDEX `fk_dce_common_data_dce_counseling_department1_idx` (`serial_scd` ASC),
  INDEX `fk_dce_student_change_family_dce_catalog1_idx` (`serial_dca` ASC),
  CONSTRAINT `fk_dce_common_data_dce_counseling_department1`
    FOREIGN KEY (`serial_scd`)
    REFERENCES `dce_counseling_department` (`serial_scd`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dce_student_change_family_dce_catalog1`
    FOREIGN KEY (`serial_dca`)
    REFERENCES `dce_catalog` (`serial_dca`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `dce_year_data`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_year_data` (
  `serial_yda` INT(11) NOT NULL AUTO_INCREMENT,
  `serial_scd` INT(11) NOT NULL,
  `serial_scy` INT(11) NOT NULL,
  `year_repeated` TEXT NULL DEFAULT NULL,
  `superdotation` ENUM('YES','NO') NULL DEFAULT NULL,
  `areas_improve` TEXT NULL DEFAULT NULL,
  `academic_leveling` ENUM('YES','NO') NULL DEFAULT NULL,
  `subjects_academic_leveling` TEXT NULL DEFAULT NULL,
  `hours_daily_sleep` VARCHAR(45) NULL DEFAULT NULL,
  `nightmares` ENUM('YES','NO') NULL DEFAULT NULL,
  `num_important_meals` INT(11) NULL DEFAULT NULL,
  `num_lunch` INT(11) NULL DEFAULT NULL,
  `time_watch_tv` VARCHAR(45) NULL DEFAULT NULL,
  `time_use_devices` VARCHAR(45) NULL DEFAULT NULL,
  `time_share_with_parents` VARCHAR(45) NULL DEFAULT NULL,
  `who_cares_afternoon` VARCHAR(45) NULL DEFAULT NULL,
  `fears` TEXT NULL DEFAULT NULL,
  `status_yda` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_yda`),
  INDEX `fk_dce_academic_data_dce_counseling_department1_idx` (`serial_scd` ASC),
  INDEX `fk_dce_academic_data_year_idx` (`serial_scy` ASC),
  CONSTRAINT `fk_dce_academic_data_dce_counseling_department1`
    FOREIGN KEY (`serial_scd`)
    REFERENCES `dce_counseling_department` (`serial_scd`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dce_academic_data_year`
  FOREIGN KEY (`serial_scy`)
  REFERENCES `school_year` (`serial_scy`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `dce_changeable_data`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `dce_changeable_data` (
  `serial_chd` INT(11) NOT NULL AUTO_INCREMENT,
  `serial_yda` INT(11) NOT NULL,
  `serial_dca` INT(11) NULL DEFAULT NULL,
  `relationship` ENUM('FATHER','MOTHER') NULL DEFAULT NULL,
  `status_chd` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_chd`),
  INDEX `fk_dce_common_data_dce_academic_data1_idx` (`serial_yda` ASC),
  INDEX `fk_dce_common_data_dce_catalog1_idx` (`serial_dca` ASC),
  CONSTRAINT `fk_dce_common_data_dce_academic_data1`
    FOREIGN KEY (`serial_yda`)
    REFERENCES `dce_year_data` (`serial_yda`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_dce_common_data_dce_catalog1`
    FOREIGN KEY (`serial_dca`)
    REFERENCES `dce_catalog` (`serial_dca`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;


--############################ FIN CREATE TABLE #########################################

insert into allowed_pages_by_process(serial_prc, url_dsc)
values (635,'dcecontroller@postsearchfamily');