|
1
|
|
|
2
|
use score;
|
|
3
|
|
|
4
|
ALTER TABLE feedbacks
|
|
5
|
ADD COLUMN type ENUM('Support', 'Feedback', 'Plots') NULL DEFAULT 'Feedback',
|
|
6
|
ADD COLUMN subject TEXT NULL,
|
|
7
|
MODIFY COLUMN session TEXT NULL,
|
|
8
|
MODIFY COLUMN firstname VARCHAR(255) NULL,
|
|
9
|
MODIFY COLUMN lastname VARCHAR(255) NULL,
|
|
10
|
MODIFY COLUMN goodPoint TEXT NULL,
|
|
11
|
MODIFY COLUMN tutorImprove TEXT NULL,
|
|
12
|
MODIFY COLUMN additionalComment TEXT NULL,
|
|
13
|
MODIFY COLUMN language ENUM('FR', 'EN', 'ES', 'LT') NULL DEFAULT 'EN',
|
|
14
|
MODIFY COLUMN usefulness ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood',
|
|
15
|
MODIFY COLUMN confident ENUM('yes', 'no', 'unsure') NULL DEFAULT 'no',
|
|
16
|
MODIFY COLUMN content ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood',
|
|
17
|
MODIFY COLUMN teaching ENUM('veryGood', 'good', 'fair', 'poor', 'veryPoor') NULL DEFAULT 'veryGood';
|
|
18
|
|
|
19
|
Alter table users DROP FOREIGN KEY FK_38005df66f42efb4850385ec8fh;
|
|
20
|
ALTER TABLE users
|
|
21
|
|
|
22
|
ADD CONSTRAINT FK_df3743253c3516d64861a82283
|
|
23
|
FOREIGN KEY (institutionId)
|
|
24
|
REFERENCES institutions (id)
|
|
25
|
ON DELETE CASCADE
|
|
26
|
ON UPDATE CASCADE;
|
|
27
|
|
|
28
|
ALTER TABLE users DROP INDEX IDX_97672ac88f789774dd47f7c8be;
|