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


-- fitbank201063009.log


/*==============================================================*/
/* Table: TIMPRIMIRDOCUMENTOS                                   */
/*==============================================================*/
alter table TIMPRIMIRDOCUMENTOS drop column    CPROCESOBASE;
alter table TIMPRIMIRDOCUMENTOS drop column    VERSIONPROCESO;

alter table TIMPRIMIRDOCUMENTOS add   CFORMATOREPORTE      VARCHAR(30);

comment on column TIMPRIMIRDOCUMENTOS.CFORMATOREPORTE is
'Codigo del formato del reporte jasper';

alter table TIMPRIMIRDOCUMENTOS
   add constraint FKIMPDOCFORMREP foreign key (CPERSONA_COMPANIA, CFORMATOREPORTE)
      references TFORMATOREPORTEID (CPERSONA_COMPANIA, CFORMATOREPORTE);