/*==============================================================*/
/* Database name:  Database                                     */
/* DBMS name:      ORACLE Version 10g                           */
/* Created on:     25/02/2010 14:21:21 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


spool fitbank201063015.log


/*==============================================================*/
/* Table: TCATEGORIASDETALLE                                    */
/*==============================================================*/
alter table TCATEGORIASDETALLE add    DISMINUYESALDO       VARCHAR2(1)                    default '0';

comment on column TCATEGORIASDETALLE.DISMINUYESALDO is
'Califica a cada categoria de provision ACC, para indicar si suma o resta de manera que se disminuya del saldo (caso de la prima pagada), default 0 = suma';

alter table TCATEGORIASDETALLE
   add constraint CKDISMINUYESALDO check (DISMINUYESALDO is null or (DISMINUYESALDO = upper(DISMINUYESALDO) and DISMINUYESALDO IN ('1','0')));


spool off