Subversion Repositories Integrator Subversion

/*========tur===================================================*/
/* DBMS name:     PostgreSQL 8                                  */
/* Criado em:     04/09/2019                                        */
/* Autor: Bruno Lopes Peixoto                                       */
/*==============================================================*/

SET search_path = sc_sec;

CREATE SEQUENCE sq_vendaformapagament
INCREMENT 1
minvalue 1
maxvalue 99999999
START 1;

ALTER TABLE sq_vendaformapagament owner TO sc_sec
;

ALTER TABLE sec_venda_formapagament ADD COLUMN seq_vendaformapagament INT8 NOT NULL DEFAULT NEXTVAL('sc_sec.sq_vendaformapagament'::regclass);

DROP INDEX ix_vendaformapag;
ALTER TABLE sec_venda_formapagament DROP CONSTRAINT pk_vendaformapag;
ALTER TABLE sec_venda_formapagament ADD CONSTRAINT pk_vendaformapag PRIMARY KEY (seq_vendaformapagament);

SET search_path = public;