--------------------------------------------------------------------------
-- 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 
--
-- BANCHK  (View) 
-

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_DEBMES_CK
 CHECK (debmes >= 0);

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_CREMES_CK
 CHECK (cremes >= 0);

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_INGPEN_CK
 CHECK (ingpen >= 0);

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_EGRPEN_CK
 CHECK (egrpen >= 0);

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_DEBBAN_CK
 CHECK (debban >= 0);

ALTER TABLE BANHIS
 ADD CONSTRAINT BANHIS_CREBAN_CK
 CHECK (creban >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_DEBMES_CK
 CHECK (debmes >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_CREMES_CK
 CHECK (cremes >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_EGRPEN_CK
 CHECK (egrpen >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_DEBBAN_CK
 CHECK (debban >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_CREBAN_CK
 CHECK (creban >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_SOBREGIRO_CK
 CHECK (sobregiro >= 0);

ALTER TABLE BANMAE
 ADD CONSTRAINT BANMAE_INGPEN_CK
 CHECK (ingpen >= 0);

ALTER TABLE BANCOBROS
 ADD CONSTRAINT BANCOBROS_MONTO_CK
 CHECK (monto >= 0);

ALTER TABLE BANCON
 ADD CONSTRAINT BANCON_DEBITO_CK
 CHECK (debito >= 0);

ALTER TABLE BANCON
 ADD CONSTRAINT BANCON_CREDITO_CK
 CHECK (credito >= 0);

ALTER TABLE BANEST
 ADD CONSTRAINT BANEST_CREBAN_CK
 CHECK (creban >= 0);

ALTER TABLE BANEST
 ADD CONSTRAINT BANEST_DEBBAN_CK
 CHECK (debban >= 0);

ALTER TABLE BANESTDET
 ADD CONSTRAINT BANESTDET_MONTO_CK
 CHECK (monto >= 0);

ALTER TABLE BANFAC
 ADD CONSTRAINT BANFAC_INTERES
 CHECK (interes >= 0);

ALTER TABLE BANFAC
 ADD CONSTRAINT BANFAC_MONTO_CK
 CHECK (monto >= 0);

ALTER TABLE BANFAC
 ADD CONSTRAINT BANFAC_INTMORA_CK
 CHECK (int_mora >= 0);

_