1-- rebuild primary key with sid_num column 2alter table reports drop constraint reports_idx; 3ALTER TABLE reports ADD CONSTRAINT reports_idx PRIMARY KEY (sid_num,activity,sensing_start);