Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
1 espaco 1 
/*========tur===================================================*/
2 
/* DBMS name:     PostgreSQL 8                                  */
3 
/* Criado em:     04/09/2019                                        */
4 
/* Autor: Bruno Lopes Peixoto                                       */
5 
/*==============================================================*/
6 
 
7 
SET search_path = sc_sec;
8 
 
9 
CREATE SEQUENCE sq_vendaformapagament
10 
INCREMENT 1
11 
minvalue 1
12 
maxvalue 99999999
13 
START 1;
14 
 
15 
ALTER TABLE sq_vendaformapagament owner TO sc_sec
16 
;
17 
 
18 
ALTER TABLE sec_venda_formapagament ADD COLUMN seq_vendaformapagament INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_vendaformapagament'::regclass);
19 
 
20 
DROP INDEX ix_vendaformapag;
21 
ALTER TABLE sec_venda_formapagament DROP CONSTRAINT pk_vendaformapag;
22 
ALTER TABLE sec_venda_formapagament ADD CONSTRAINT pk_vendaformapag PRIMARY KEY (seq_vendaformapagament);
23 
 
24 
SET search_path = public;