/*==============================================================*/
/* Database name:  Database                                     */
/* DBMS name:      ORACLE Version 10g                           */
/* Created on:     16/11/2009 13:16:28 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


spool fitbank201062006.log


/*==============================================================*/
/* Table: TNATURALINFORMACIONADICIONAL                          */
/*==============================================================*/
alter table TNATURALINFORMACIONADICIONAL add (
   OCUPACARGOPUBLICO    VARCHAR2(1)                    default '0',
   RELACIONSECTORPUBLICO VARCHAR2(1)                    default '0');

comment on column TNATURALINFORMACIONADICIONAL.OCUPACARGOPUBLICO is
'Indica si la persona ocupa cargo publico';

comment on column TNATURALINFORMACIONADICIONAL.RELACIONSECTORPUBLICO is
'Indica si mantiene relacion comercial o familiar con una persona que ocupa o haya ocupado un cargo publico';

alter table TNATURALINFORMACIONADICIONAL
   add constraint CKOCUPACARGOPUBLICO check (OCUPACARGOPUBLICO is null or (OCUPACARGOPUBLICO = upper(OCUPACARGOPUBLICO) and OCUPACARGOPUBLICO in ('1','0')));

alter table TNATURALINFORMACIONADICIONAL
   add constraint CKRELACIONSECTORPUBLICO check (RELACIONSECTORPUBLICO is null or (RELACIONSECTORPUBLICO = upper(RELACIONSECTORPUBLICO) and RELACIONSECTORPUBLICO in ('1','0')));


spool off