/*==============================================================*/
/* Database name:  Database                                     */
/* DBMS name:      ORACLE Version 10g                           */
/* Created on:     22/03/2010 18:06:26 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 fitbank201063018.log


/*==============================================================*/
/* Table: TOFICINASSUCURSAL                                     */
/*==============================================================*/
alter table TOFICINASSUCURSAL add   CONEXIONREMOTA       VARCHAR2(100);

comment on column TOFICINASSUCURSAL.CONEXIONREMOTA is
'Direccion para conectividad entre el core y estaciones de trabajo en oficinas remotas';


spool off

------

spool DatosCamposParcial.log                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
set Define "!"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
set feedback off                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
set define off                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
prompt Deleting TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                              
delete from tCamposConsultables where ccampo in (select ccampo from tCamposConsultablesId where tablabase='TOFICINASSUCURSAL');                                                                                                                                                                                                                                                                                                                                                                                     
prompt Deleting TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
delete from tCamposConsultablesId where tablabase='TOFICINASSUCURSAL';                                                                                                                                                                                                                                                                                                                                                                                                                                              
prompt Loading TCAMPOSCONSULTABLESID...                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2531001,'TOFICINASSUCURSAL','COFICINA',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                              
insert into tCamposConsultablesId values(2531002,'TOFICINASSUCURSAL','CPERSONA_COMPANIA',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(8)',8,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2531003,'TOFICINASSUCURSAL','CSUCURSAL',5,null,null,'N','0','1','0',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2531004,'TOFICINASSUCURSAL','VERSIONCONTROL',5,null,null,'N','0','0','1','0','0','0',null,'1',null,null,null,'NUMBER(22)',22,0,'0');                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(2531005,'TOFICINASSUCURSAL','CCIUDAD',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(6)',6,0,'0');                                                                                                                                                                                                                                                                                                                                             
insert into tCamposConsultablesId values(2531006,'TOFICINASSUCURSAL','CPAIS',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultablesId values(2531008,'TOFICINASSUCURSAL','CPROVINCIA',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                          
insert into tCamposConsultablesId values(2531009,'TOFICINASSUCURSAL','CREGION',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultablesId values(2531010,'TOFICINASSUCURSAL','HUSOHORARIO',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(4)',4,0,'0');                                                                                                                                                                                                                                                                                                                                           
insert into tCamposConsultablesId values(2531011,'TOFICINASSUCURSAL','NUMERODIRECCION',5,null,null,'N','0','0','1',null,'0','0',null,'1',null,null,null,'NUMBER(3)',3,0,'0');                                                                                                                                                                                                                                                                                                                                       
insert into tCamposConsultablesId values(2531012,'TOFICINASSUCURSAL','RUTATRANSITO',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(20)',20,0,'0');                                                                                                                                                                                                                                                                                                                                     
insert into tCamposConsultablesId values(2531013,'TOFICINASSUCURSAL','CODIGOSIB',5,null,null,'T','1','0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(5)',5,0,'0');                                                                                                                                                                                                                                                                                                                                           
insert into tCamposConsultablesId values(2531014,'TOFICINASSUCURSAL','CONEXIONREMOTA',5,null,null,'T',null,'0','1',null,'0','0',null,'1',null,null,null,'VARCHAR2(100)',100,0,'0');                                                                                                                                                                                                                                                                                                                                 
prompt Loading TCAMPOSCONSULTABLES...                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531001,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de oficina');                                                                                                                                                                                                                                   
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531002,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de persona de la compania');                                                                                                                                                                                                                    
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531003,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la sucursal');                                                                                                                                                                                                                               
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531004,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Manejo de optimistic locking.');                                                                                                                                                                                                                       
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531005,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de ciudad');                                                                                                                                                                                                                                    
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531006,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo del pais');                                                                                                                                                                                                                                     
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531008,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la provincia');                                                                                                                                                                                                                              
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531009,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la region');                                                                                                                                                                                                                                 
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531010,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Huso horario en el que se encuentra una oficina');                                                                                                                                                                                                     
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531011,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Numero de direccion');                                                                                                                                                                                                                                 
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531012,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de ruta transito de la oficina para la emision de chequeras');                                                                                                                                                                                  
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531013,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Codigo de la oficina para el organismo de control SIB');                                                                                                                                                                                               
insert into tCamposConsultables (CIDIOMA,CCAMPO,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES',2531014,to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'Direccion para conectividad entre el core y estaciones de trabajo en oficinas remotas');                                                                                                                                                               
commit;                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             
set Define "&"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      
set feedback on                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     
prompt Done.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
spool off