Contraintes manquantes de la table t_lot_lot

[cedric]

alter table migradour.t_lot_lot ADD CONSTRAINT c_fk_lot_dev_code FOREIGN KEY (lot_dev_code)

REFERENCES ref.tr_devenirlot_dev (dev_code) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE NO ACTION;

alter table migradour.t_lot_lot ADD CONSTRAINT c_fk_lot_org_code FOREIGN KEY (lot_org_code)

REFERENCES ref.ts_organisme_org (org_code) MATCH FULL
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table migradour.t_lot_lot ADD CONSTRAINT c_fk_lot_qte_code FOREIGN KEY (lot_qte_code)

REFERENCES ref.tr_typequantitelot_qte (qte_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table migradour.t_lot_lot ADD CONSTRAINT c_fk_lot_std_code FOREIGN KEY (lot_std_code)

REFERENCES ref.tr_stadedeveloppement_std (std_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table migradour.t_lot_lot ADD CONSTRAINT c_fk_lot_tax_code FOREIGN KEY (lot_tax_code)

REFERENCES ref.tr_taxon_tax (tax_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

[cedric]

alter table smatah.t_lot_lot ADD CONSTRAINT c_fk_lot_dev_code FOREIGN KEY (lot_dev_code)

REFERENCES ref.tr_devenirlot_dev (dev_code) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE NO ACTION;

alter table smatah.t_lot_lot ADD CONSTRAINT c_fk_lot_org_code FOREIGN KEY (lot_org_code)

REFERENCES ref.ts_organisme_org (org_code) MATCH FULL
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table smatah.t_lot_lot ADD CONSTRAINT c_fk_lot_qte_code FOREIGN KEY (lot_qte_code)

REFERENCES ref.tr_typequantitelot_qte (qte_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table smatah.t_lot_lot ADD CONSTRAINT c_fk_lot_std_code FOREIGN KEY (lot_std_code)

REFERENCES ref.tr_stadedeveloppement_std (std_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

alter table smatah.t_lot_lot ADD CONSTRAINT c_fk_lot_tax_code FOREIGN KEY (lot_tax_code)

REFERENCES ref.tr_taxon_tax (tax_code) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION;

[cedric]

update smatah.t_bilanmigrationmensuel_bme SET bme_std_code='MAD' where bme_std_code like 'MAD '

[cedric]

begin;
UPDATE smatah.t_lot_lot set lot_std_code='MAD' where lot_std_code like 'MAD '
COMMIT;