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


spool fitbank201062010.log


/*==============================================================*/
/* Table: TFORMATOXML                                           */
/*==============================================================*/
alter table TFORMATOXML add   TIPOFORMATO          VARCHAR2(50);

alter table TFORMATOXML modify (	TIPOFORMATO	default 'com.FitBank.xml.Formas.Formulario'	);

update TFORMATOXML set TIPOFORMATO = 'com.FitBank.xml.Formas.Formulario';
alter table TFORMATOXML modify (  TIPOFORMATO      NOT NULL	);

comment on column TFORMATOXML.TIPOFORMATO is
'Tipo de formato del formulario especificado como default com.FitBank.xml.Formas.Formulario';


spool off