--------------------------------------------------------------------------
-- Play this script in PRUEBAS@VISANY to make it look like DESA@VISMAR
--                                                                      --
-- Please review the script before using it to make sure it won't       --
-- cause any unacceptable data loss.                                    --
--                                                                      --
-- PRUEBAS@VISANY Schema Extracted by User PRUEBAS 
-- DESA@VISMAR Schema Extracted by User DESA 

ALTER TABLE SEG_GRANT
 DROP CONSTRAINT SEG_GRUPO_SEGGR_GRUPO_FK; 
ALTER TABLE SEG_GRANT
   ADD CONSTRAINT SEGGRUPO_GRANT_FK FOREIGN KEY (COD_GRUPO)
      REFERENCES SEG_GRUPO (COD_GRUPO);

ALTER TABLE SEG_MNUMNU
 drop CONSTRAINT SEGMNUMOD_MNUMNU_FK; 
ALTER TABLE SEG_MNUMNU
   ADD CONSTRAINT SEGMNUMOD_MENU_FK FOREIGN KEY (MODID)
      REFERENCES SEG_MNUMOD (MODID);

ALTER TABLE SEG_MNUITM
 drop CONSTRAINT SEGMNUMNU_MNUITM_FK; 
ALTER TABLE SEG_MNUITM
   ADD CONSTRAINT SEGMNUMNU_ITEM_FK FOREIGN KEY (MODID, PARENTID)
      REFERENCES SEG_MNUMNU (MODID, ITEMID);

ALTER TABLE SEG_OPCION
MODIFY(NOM_FORMA VARCHAR2(12 BYTE));

ALTER TABLE SEG_GRANT
 ADD CONSTRAINT GENCOMPANIA_SEGGRANT_FK 
 FOREIGN KEY (COD_CIA) 
 REFERENCES GEN_COMPANIA (COD_CIA);

_