ALTER TABLE contact ADD COLUMN pauselasttime timestamp with time zone;
UPDATE contact SET pauselasttime=NOW();
ALTER TABLE contact ALTER pauselasttime SET NOT NULL;
ALTER TABLE contact ALTER pauselasttime SET DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE contact ADD COLUMN pauselastreason varchar(255);
UPDATE contact SET pauselastreason='';
ALTER TABLE contact ALTER pauselastreason SET NOT NULL;
ALTER TABLE contact ALTER pauselastreason SET DEFAULT '';

ALTER TABLE contact ADD COLUMN pausesessionid varchar(50);
UPDATE contact SET pausesessionid='';
ALTER TABLE contact ALTER pausesessionid SET NOT NULL;
ALTER TABLE contact ALTER pausesessionid SET DEFAULT '';

ALTER TABLE contact ADD COLUMN pausecallseq integer;
UPDATE contact SET pausecallseq=0;
ALTER TABLE contact ALTER pausecallseq SET NOT NULL;
ALTER TABLE contact ALTER pausecallseq SET DEFAULT 0;

