/*==============================================================*/
/* Database name:  FITBANK PHYSICAL DATA MODEL                  */
/* DBMS name:      IBM DB2 UDB 5.x Common Server                */
/* Created on:     14/04/2010 14:15:00 AM                       */
/*==============================================================*/
-- 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


-- fitbank201064002.log


/*==============================================================*/
/* Table: TPRODUCTOCAPTACIONESVISTA                             */
/*==============================================================*/
alter table TPRODUCTOCAPTACIONESVISTA add
   PERMITEMANCOMUNADO   VARCHAR(1)                    default '1';

comment on column TPRODUCTOCAPTACIONESVISTA.PERMITEMANCOMUNADO is
'Indica si las cuentas de este producto permiten tener mas clientes relacionados a parte del titular o no';

alter table TPRODUCTOCAPTACIONESVISTA
   add constraint CKPERMITEMANCOMUNADO check (PERMITEMANCOMUNADO is null or (PERMITEMANCOMUNADO in ('1','0')));