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


-- fitbank201064029.log


/*==============================================================*/
/* Table: TREPREPORTESID                                        */
/*==============================================================*/
alter  table TREPREPORTESID add    CSUBSISTEMA          VARCHAR(2);

comment on column TREPREPORTESID.CSUBSISTEMA is
'Codigo del subsistema';

alter table TREPREPORTESID
   add constraint FKREPSUBS foreign key (CSUBSISTEMA)
      references TSUBSISTEMAID (CSUBSISTEMA);