AllActivities Import Existing History Items

-- Meetings
insert into psi_allactivities
(id,name,date_entered,description,assigned_user_id,parent_type,parent_id,activity_type,act_id)
select
id,name,date_entered,description,assigned_user_id,parent_type,parent_id,'Meetings',id
from meetings
where meetings.id not in(
    select act_id from psi_allactivities where psi_allactivities.deleted=0
);

-- Calls
insert into psi_allactivities
(id,name,date_entered,description,assigned_user_id,parent_type,parent_id,activity_type,act_id)
select
id,name,date_entered,description,assigned_user_id,parent_type,parent_id,'Calls',id
from calls
where calls.id not in(
    select act_id from psi_allactivities where psi_allactivities.deleted=0
);

-- Tasks
insert into psi_allactivities
(id,name,date_entered,description,assigned_user_id,parent_type,parent_id,activity_type,act_id)
select
id,name,date_entered,description,assigned_user_id,parent_type,parent_id,'Tasks',id
from tasks
where tasks.id not in(
    select act_id from psi_allactivities where psi_allactivities.deleted=0
);

-- Notes
insert into psi_allactivities
(id,name,date_entered,description,assigned_user_id,parent_type,parent_id,activity_type,act_id)
select
id,name,date_entered,description,assigned_user_id,parent_type,parent_id,'Notes',id
from notes
where notes.id not in(
    select act_id from psi_allactivities where psi_allactivities.deleted=0
);