CREATE TABLE IF NOT EXISTS `guardian_change_log` (
  `serial_gcl` int(11) NOT NULL AUTO_INCREMENT,
  `serial_grd` int(11) NOT NULL, 
  `field_name_gcl` varchar(45) NOT NULL, 
  `field_value_gcl` varchar(512) NOT NULL,
  `serial_usr` int(11) NOT NULL,   
  `date_gcl` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`serial_gcl`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;


-- 
-- Filtros para la tabla `student_year_quota` 
-- 
ALTER TABLE `guardian_change_log` 
  ADD CONSTRAINT `fk_gcl_serial_grd` FOREIGN KEY (`serial_grd`) REFERENCES `guardian` (`serial_grd`),  
  ADD CONSTRAINT `fk_gcl_serial_usr` FOREIGN KEY (`serial_usr`) REFERENCES `user` (`serial_usr`)
;