alter table patient add resp_person_fk int8;
alter table patient add constraint FK_56r2g5ggptqgcvb3hl11adke2 foreign key (resp_person_fk) references person_name;
create index FK_56r2g5ggptqgcvb3hl11adke2 on patient (resp_person_fk) ;

alter table study alter storage_ids drop not null;
alter table study add ext_retrieve_aet varchar(255);

alter table series add ext_retrieve_aet varchar(255);
alter table series alter series_no drop not null;

alter table instance add ext_retrieve_aet varchar(255), add num_frames int4;
alter table instance alter inst_no drop not null;

create index UK_cl9dmi0kb97ov1cjh7rn3dhve on study (ext_retrieve_aet);
create index UK_6ry2squ4qcv129lxpae1oy93m on study (created_time);
drop index UK_3tvtv5bjrpem0qjc3qo84bgsl;

create table stgcmt_result (pk int8 not null, created_time timestamp not null, device_name varchar(255) not null, exporter_id varchar(255) not null, num_failures int4, num_instances int4, series_iuid varchar(255), sop_iuid varchar(255), stgcmt_status int4 not null, study_iuid varchar(255) not null, transaction_uid varchar(255) not null, updated_time timestamp not null, primary key (pk));
alter table stgcmt_result add constraint UK_ey6qpep2qtiwayou7pd0vj22w  unique (transaction_uid);
create index UK_qko59fn9pb87j1eu070ilfkhm on stgcmt_result (updated_time);
create index UK_7ltjgxoijy15rrwihl8euv7vh on stgcmt_result (device_name);
create index UK_gu96kxnbf2p84d1katepo0btq on stgcmt_result (exporter_id);
create index UK_p65blcj4h0uh2itb0bp49mc07 on stgcmt_result (study_iuid);
create index UK_nyoefler7agcmxc8t8yfngq7e on stgcmt_result (stgcmt_status);

alter table sps_station_aet drop pk;
drop sequence sps_station_aet_pk_seq;

create sequence stgcmt_result_pk_seq;