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;
