--------------------------------------------------------------------------
-- 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 

--
-- ACTUALIZA_EVENTO  (Trigger) 
--

ALTER TABLE ACT_HISDETMOV
MODIFY(DEP_REV  DEFAULT 0);

ALTER TABLE ACT_HISDETMOV
MODIFY(DEP_MEJ  DEFAULT 0);

ALTER TABLE ACT_MOVCONSE
MODIFY(CONSECUTIVO  DEFAULT 0);

ALTER TABLE ACT_DETMOV
MODIFY(DEP_REV  DEFAULT 0);

ALTER TABLE ACT_DETMOV
MODIFY(DEP_MEJ  DEFAULT 0);

 ALTER TABLE ACT_HISDETMOV ADD (DEP_REVDED NUMBER(14,2) DEFAULT 0 NOT NULL);
ALTER TABLE ACT_DETMOV MODIFY DEP_REVDED DEFAULT 0;
**ver tabla principal