
use score;

ALTER TABLE feedbacks
    ADD COLUMN type ENUM('Support', 'Feedback', 'Plots') NULL DEFAULT 'Feedback',
    ADD COLUMN subject TEXT NULL,
    MODIFY COLUMN session TEXT NULL,
    MODIFY COLUMN firstname VARCHAR(255) NULL,
    MODIFY COLUMN lastname VARCHAR(255) NULL,
    MODIFY COLUMN goodPoint TEXT NULL,
    MODIFY COLUMN tutorImprove TEXT NULL,
    MODIFY COLUMN additionalComment TEXT NULL,
	MODIFY COLUMN language ENUM('FR', 'EN', 'ES', 'LT') NULL DEFAULT 'EN',
	MODIFY COLUMN usefulness ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood',
	MODIFY COLUMN confident ENUM('yes', 'no', 'unsure') NULL DEFAULT 'no',
	MODIFY COLUMN content ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood',
	MODIFY COLUMN teaching ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood';

Alter table users DROP  FOREIGN KEY FK_38005df66f42efb4850385ec8fh;
ALTER TABLE users

ADD CONSTRAINT FK_df3743253c3516d64861a82283
FOREIGN KEY (institutionId) 
REFERENCES institutions (id) 
ON DELETE CASCADE 
ON UPDATE CASCADE;

ALTER TABLE users  DROP INDEX IDX_97672ac88f789774dd47f7c8be;