SCORE

use score;

ALTER TABLE score.users

modify column title varchar(255) NULL;

ALTER TABLE score.users

modify column phoneCode varchar(255) NULL;

ALTER TABLE score.users

modify column phone varchar(255) NULL;

ALTER TABLE score.users

modify column country varchar(255) NULL;

ALTER TABLE score.users

modify column about text NULL;

ALTER TABLE score.users

modify column address text NULL;

ALTER TABLE score.users

modify column password varchar(255) NULL;

-- Drop the existing foreign key constraint

ALTER TABLE learning_blocks_steps

DROP FOREIGN KEY FK_3837e7ca688ee19a5c8f0fe60fa;

-- Create a new foreign key constraint with ON DELETE CASCADE and ON UPDATE CASCADE

ALTER TABLE learning_blocks_steps

ADD CONSTRAINT FK_3837e7ca688ee19a5c8f0fe60fa

FOREIGN KEY (learningBlockId)

REFERENCES learning_blocks(id)

ON DELETE CASCADE

ON UPDATE CASCADE;