ALTER TABLE ukbb.studies
  ADD COLUMN study_id integer;
ALTER TABLE ukbb.studies
  DROP CONSTRAINT pk_studies;

update ukbb.studies set study_id = 1;

ALTER TABLE ukbb.studies
  ADD CONSTRAINT pk_studies PRIMARY KEY (study_id);


ALTER TABLE ukbb.analysis
  ADD CONSTRAINT analysis_subjects_fk FOREIGN KEY (subject_id) REFERENCES ukbb.subjects (subject_id) ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE ukbb.analysis
  ADD CONSTRAINT analysis_studies FOREIGN KEY (studies_id) REFERENCES ukbb.studies (study_id) ON UPDATE NO ACTION ON DELETE NO ACTION;

update ukbb.analysis set subject_id = 3 where uid=1;
update ukbb.analysis set subject_id = 1 where uid=2;
update ukbb.analysis set subject_id = 2 where uid=3;

update ukbb.analysis set studies_id = 1;


ALTER TABLE ukbb.analysis
  DROP COLUMN study_name;

ALTER TABLE ukbb.analysis
  DROP COLUMN patientid;


ALTER TABLE ukbb.lv_fc_timepoints
  ADD CONSTRAINT timepoints_analysis FOREIGN KEY (analysisid) REFERENCES ukbb.analysis (uid) ON UPDATE NO ACTION ON DELETE NO ACTION;

ALTER TABLE ukbb.lv_fc_totals
  ADD CONSTRAINT total_analysis FOREIGN KEY (totalsid) REFERENCES ukbb.analysis (uid) ON UPDATE NO ACTION ON DELETE NO ACTION;