/*==============================================================*/
/* Database name:  FITBANK PHYSICAL DATA MODEL                  */
/* DBMS name:      IBM DB2 UDB 5.x Common Server                */
/* Created on:     29/01/2010 15:42:44 PM                       */
/*==============================================================*/
-- SQL script that update fitBank squema

-- To run this script from the SQL Plus, perform the following steps:
-- 1. connect to the database
-- 2. set define character to !
--      "set define !"
-- 3. issue the command "@ <script-name>"
--    where <script-name> represents the name of this script


-- fitbank201063006.log


/*==============================================================*/
/* Table: TGIROSTRANSFERENCIASAUTORIZADO                        */
/*==============================================================*/
alter table TGIROSTRANSFERENCIASAUTORIZADO drop constraint CKCARGOSBANCARIOSGIR;

alter table TGIROSTRANSFERENCIASAUTORIZADO
   add constraint CKCARGOSBANCARIOSGIR check (CARGOSBANCARIOS is null or (CARGOSBANCARIOS in ('R','B','C')));

comment on column TGIROSTRANSFERENCIASAUTORIZADO.CARGOSBANCARIOS is
'Define si los cargos bancarios se cobran al R=remitente, B=beneficiario o C=Compartido';