Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Insert lead IDs into the vicidial_list_archive table. Ignore lead IDs that exist in the vicidial_list_archive table.

  2. Update lead ID in the vicidial_list_archive table with lead ID data from the vicidial_list table.

  3. Delete lead IDs from the vicidial_list table. Performs safe delete by checking if the lead ID exists IDs exist in the vicidial_list_archive table and if the column data matches the vicidial_list table lead ID.

...