alter table student_year add column snack_service_sty enum('YES','NO') default 'NO' after extracurricular_service;


create table data_protection_terms_conditions(
	serial_dpt int NOT NULL AUTO_INCREMENT,
    serial_usr int NOT NULL,
    id_usr varchar(13) NOT NULL,
    serial_scy int NOT NULL,
    timestamp_dpt TIMESTAMP  NOT NULL DEFAULT CURRENT_TIMESTAMP,
    status_dpt ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
    PRIMARY KEY (`serial_dpt`),
	FOREIGN KEY (serial_usr) REFERENCES user(serial_usr),
	FOREIGN KEY (serial_scy) REFERENCES school_year(serial_scy)
);