ALTER TABLE favorites ADD COLUMN user_uri char(255) DEFAULT NULL; UPDATE favorites SET user_uri='' WHERE user_uri IS NULL; ALTER TABLE favorites MODIFY COLUMN user_uri char(255) NOT NULL DEFAULT '';