                  retired_by = NULL,
                  date_retired = NULL,
                  retire_reason = NULL,
-                 uuid = "09f979d7-b091-11e4-bc78-040ccecfdba4" WHERE
-    user_id = @buendia_admin_id;
+                 uuid = "buendia_user_buendia_admin"
+WHERE user_id = @buendia_admin_id;
 
 -- Add "buendia_admin" to the list of users to keep.
 INSERT INTO keep_users (SELECT * FROM users WHERE user_id = @buendia_admin_id);

UPDATE order_type SET retired_by = @buendia_admin_id WHERE
    retired_by IS NOT NULL AND retired_by != @admin_id;

UPDATE orders SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE orders SET voided_by = @buendia_admin_id WHERE
    voided_by IS NOT NULL AND voided_by != @admin_id;

UPDATE patient SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;
UPDATE patient SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE patient SET voided_by = @buendia_admin_id WHERE
    voided_by IS NOT NULL AND voided_by != @admin_id;

UPDATE patient_identifier SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE patient_identifier SET voided_by = @buendia_admin_id WHERE
    voided_by IS NOT NULL AND voided_by != @admin_id;
UPDATE patient_identifier SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;

UPDATE patient_identifier_type SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE patient_identifier_type SET retired_by = @buendia_admin_id WHERE
    retired_by IS NOT NULL AND retired_by != @admin_id;

UPDATE patient_program SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE patient_program SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;
UPDATE patient_program SET voided_by = @buendia_admin_id WHERE
    voided_by IS NOT NULL AND voided_by != @admin_id;

UPDATE patient_state SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;
UPDATE patient_state SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;
UPDATE patient_state SET voided_by = @buendia_admin_id WHERE
    voided_by IS NOT NULL AND voided_by != @admin_id;

UPDATE person SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;
UPDATE person SET creator = @buendia_admin_id WHERE

UPDATE encounter_type SET retired_by = @buendia_admin_id WHERE
    retired_by IS NOT NULL AND retired_by != @admin_id;

UPDATE field_type SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;

UPDATE hl7_source SET creator = @buendia_admin_id WHERE
    creator IS NOT NULL AND creator != @admin_id;

UPDATE order_frequency SET changed_by = @buendia_admin_id WHERE
    changed_by IS NOT NULL AND changed_by != @admin_id;
UPDATE order_frequency SET creator = @buendia_admin_id WHERE
