Atualização Softwares Licenciados

atualizacao-20181210.sql

CREATE TABLE aquisicoes_software (id_software INT NOT NULL, id_aquisicao INT NOT NULL, id_tipo_licenca INT NOT NULL, PRIMARY KEY(id_software, id_aqui
sicao, id_tipo_licenca));
CREATE INDEX IDX_6BCDE8B1270B845A ON aquisicoes_software (id_software);
CREATE INDEX IDX_6BCDE8B1CF537CBE2AFF7683 ON aquisicoes_software (id_aquisicao, id_tipo_licenca);
ALTER TABLE aquisicoes_software ADD CONSTRAINT FK_6BCDE8B1270B845A FOREIGN KEY (id_software) REFERENCES software (id_software) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE software_estacao DROP CONSTRAINT fk_9bbdd0f8270b845a;
ALTER TABLE software_estacao DROP CONSTRAINT fk_9bbdd0f8cf537cbe;


alter table software_estacao DROP CONSTRAINT software_estacao_pkey;
alter table aquisicao_item drop constraint aquisicao_item_pkey;

ALTER TABLE aquisicao_item ADD PRIMARY KEY (id_tipo_licenca, id_aquisicao);
ALTER TABLE software_estacao ADD CONSTRAINT FK_9BBDD0F82AFF7683CF537CBE FOREIGN KEY (id_tipo_licenca, id_aquisicao) REFERENCES aquisicao_item (id_tipo_licenca, id_aquisicao) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE software_estacao ADD PRIMARY KEY (id_computador);

DROP INDEX idx_9bbdd0f8cf537cbe;
DROP INDEX idx_9bbdd0f89f1b3279;
DROP INDEX idx_9bbdd0f8270b845a;
ALTER TABLE software_estacao ADD id_tipo_licenca INT DEFAULT NULL;
ALTER TABLE software_estacao DROP id_software;
ALTER TABLE software_estacao ADD CONSTRAINT FK_9BBDD0F82AFF7683CF537CBE FOREIGN KEY (id_tipo_licenca, id_aquisicao) REFERENCES aquisicao_item (id_tipo_licenca, id_aquisicao) NOT DEFERRABLE INITIALLY IMMEDIATE;
CREATE INDEX IDX_9BBDD0F82AFF7683CF537CBE ON software_estacao (id_tipo_licenca, id_aquisicao);
ALTER TABLE software_estacao ADD PRIMARY KEY (id_computador);
ALTER TABLE aquisicao_item DROP CONSTRAINT fk_d3de1a3a270b845a;
DROP INDEX idx_d3de1a3a270b845a;
ALTER TABLE aquisicao_item DROP id_software;
ALTER TABLE aquisicao_item ADD PRIMARY KEY (id_tipo_licenca, id_aquisicao);

alter table software_estacao DROP CONSTRAINT software_estacao_pkey;
alter table aquisicao_item drop constraint aquisicao_item_pkey;

ALTER TABLE aquisicao_item ADD PRIMARY KEY (id_tipo_licenca, id_aquisicao);
ALTER TABLE software_estacao ADD CONSTRAINT FK_9BBDD0F82AFF7683CF537CBE FOREIGN KEY (id_tipo_licenca, id_aquisicao) REFERENCES aquisicao_item (id_tipo_licenca, id_aquisicao) NOT DEFERRABLE INITIALLY IMMEDIATE;
ALTER TABLE software_estacao ADD PRIMARY KEY (id_computador);