INSERT INTO location_address (Adr_Line1, Adr_Line2, Adr_City, Adr_State, Adr_Zip)
SELECT Org_Address1, Org_Address2, Org_City, Org_State, Org_Zip FROM organization

ALTER TABLE location_address ADD Adr_Migration_Org_Id INT NOT NULL;

ALTER TABLE organization ADD Org_Address INT NOT NULL;

INSERT INTO location_address (Adr_Line1, Adr_Line2, Adr_City, Adr_State, Adr_Zip, Adr_Migration_Org_Id)
SELECT Org_Address1, Org_Address2, Org_City, Org_State, Org_Zip, Org_Id FROM organization;

UPDATE organization
INNER JOIN location_address ON Adr_Migration_Org_Id = Org_Id
SET Org_Address = Adr_Id

ALTER TABLE location_address DROP Adr_Migration_Org_Id;

INSERT INTO location_address (Adr_Line1, Adr_Line2, Adr_City, Adr_State, Adr_Zip, original_migration_id)
SELECT Org_Address1, Org_Address2, Org_City, Org_State, Org_Zip, id
    FROM organization;

UPDATE organization
    JOIN location_address ON organization.id = location_address.original_migration_id
    SET Org_Address = location_address.id;

AFTER INSERT ON `trigger_cart_items` FOR EACH ROW BEGIN INSERT INTO trigger_cart_log (cart_id, item_id) VALUES (NEW.cart_id, NEW.item_id); END