ALTER TABLE phone ADD COLUMN pairedwith integer;
UPDATE phone SET pairedwith='1' WHERE pairedwith IS NULL;
ALTER TABLE phone ALTER COLUMN pairedwith SET NOT NULL;
ALTER TABLE phone ALTER COLUMN pairedwith SET DEFAULT '1';
