ALTER TABLE `conferences` ADD `copyoriginal` INT NOT NULL AFTER `status` , ADD `copyparent` INT NOT NULL AFTER `copyoriginal` , ADD `notes` TEXT NOT NULL AFTER `copyparent`; UPDATE `conferences` SET copyoriginal=id, copyparent=id;