Subversion Repositories Integrator Subversion

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
778 blopes 1 
SET search_path = sc_slp;
2 
ALTER TABLE slp_ativo ADD COLUMN tip_tendencia CHAR(1) NULL;
3 
UPDATE slp_ativo SET tip_tendencia = 'N';
4 
ALTER TABLE slp_ativo ALTER COLUMN tip_tendencia SET NOT NULL;
5 
ALTER TABLE slp_ativo ADD CONSTRAINT ck_tendencia_ativo check (tip_tendencia in ('A','B','N'));