Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
599 blopes 1 
/*==============================================================*/
2 
/* DBMS name:     PostgreSQL 8                                  */
3 
/* Criado em:     06/05/2025                                        */
4 
/* Autor: Bruno Lopes Peixoto                                       */
5 
/*==============================================================*/
6 
 
7 
SET search_path = sc_sec;
8 
 
9 
ALTER TABLE sec_controle_trafego ADD COLUMN dth_verificacao TIMESTAMP NULL;
10 
 
11 
 
12 
ALTER TABLE sec_empresa_adquirente ADD COLUMN seq_conta_bancaria INT8 NULL;
13 
 
14 
ALTER TABLE sec_empresa_adquirente
15 
   ADD CONSTRAINT fk_empresaadquirente_contabancaria FOREIGN KEY (seq_conta_bancaria)
16 
      REFERENCES sec_conta_bancaria (seq_conta_bancaria)
17 
      ON DELETE RESTRICT ON UPDATE RESTRICT;
18 
 
19 
CREATE  INDEX ix_empresa_adquirente_contabanc ON sec_empresa_adquirente (
20 
seq_conta_bancaria
21 
);
22 
 
23 
UPDATE sec_empresa_adquirente SET seq_conta_bancaria = 7;
24 
 
25 
ALTER TABLE sec_empresa_adquirente ALTER COLUMN seq_conta_bancaria SET NOT NULL;
26 
 
27 
 
28 
 
29 
SET search_path = public;