-- iconos
CREATE TABLE `icon_catalogue` (
  `serial_ict` int(11) NOT NULL AUTO_INCREMENT,
  `name_ict` varchar(45) NOT NULL,
  `description_ict` varchar(100) DEFAULT NULL,
  `status_ict` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_ict`)
);


INSERT INTO `icon_catalogue` (`serial_ict`,`name_ict`,`description_ict`,`status_ict`) VALUES (1,'Calificaciones','Calificaciones por profesores','ACTIVE');
INSERT INTO `icon_catalogue` (`serial_ict`,`name_ict`,`description_ict`,`status_ict`) VALUES (2,'Comportamiento Inspector','Comportamiento para ser registrado por los inspectores','ACTIVE');
INSERT INTO `icon_catalogue` (`serial_ict`,`name_ict`,`description_ict`,`status_ict`) VALUES (3,'Comportamiento Profesor','Comportamiento por profesor de cada materia','ACTIVE');
INSERT INTO `icon_catalogue` (`serial_ict`,`name_ict`,`description_ict`,`status_ict`) VALUES (4,'Comportamiento Dirigente de Curso','Comportamiento registrado por cada dirigente de curso','ACTIVE');
INSERT INTO `icon_catalogue` (`serial_ict`,`name_ict`,`description_ict`,`status_ict`) VALUES (5,'Asistencia','Registro de asistencia','ACTIVE');

-- summary

CREATE TABLE `summary` (
  `serial_ict` int(11) NOT NULL,
  `serial_emp` int(11) NOT NULL,
  `status_sum` enum('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_ict`,`serial_emp`),
  KEY `fk_emp_idx` (`serial_emp`),
  CONSTRAINT `fk_emp` FOREIGN KEY (`serial_emp`) REFERENCES `employee` (`serial_emp`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_ict` FOREIGN KEY (`serial_ict`) REFERENCES `icon_catalogue` (`serial_ict`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ;




-- noticias
CREATE TABLE `new` (
  `serial_new` int(11) NOT NULL AUTO_INCREMENT,
  `title_new` varchar(45) NOT NULL,
  `description_new` text NOT NULL,
  `priority_new` set('IS PRIORITY') DEFAULT NULL,
  `creation_date_new` datetime DEFAULT NULL,
  `publication_date_new` datetime DEFAULT NULL,
  `expiration_date_new` datetime DEFAULT NULL,
  `status_new` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_new`)
);