ALTER TABLE ctb_param_demonst_result ADD COLUMN ind_cod_agl character varying(1);
UPDATE ctb_param_demonst_result SET ind_cod_agl = 'T';
ALTER TABLE ctb_param_demonst_result  ALTER COLUMN ind_cod_agl SET NOT NULL;


ALTER TABLE ctb_param_demonst_result ADD COLUMN nivel_agl integer;
UPDATE ctb_param_demonst_result SET nivel_agl = '4';
ALTER TABLE ctb_param_demonst_result  ALTER COLUMN nivel_agl SET NOT NULL;

ALTER TABLE ctb_param_demonst_result ADD COLUMN cod_agl_sup character varying(50);
UPDATE ctb_param_demonst_result SET cod_agl_sup = '';
ALTER TABLE ctb_param_demonst_result  ALTER COLUMN cod_agl_sup SET NOT NULL;

ALTER TABLE ctb_param_demonst_result ADD COLUMN ind_dc_cta character varying(1);
UPDATE ctb_param_demonst_result SET ind_dc_cta = 'C';
ALTER TABLE ctb_param_demonst_result  ALTER COLUMN ind_dc_cta SET NOT NULL;


ALTER TABLE ctb_param_demonst_result ADD COLUMN ind_grp_dre character varying(1);
UPDATE ctb_param_demonst_result SET ind_grp_dre = 'D';
ALTER TABLE ctb_param_demonst_result  ALTER COLUMN ind_grp_dre SET NOT NULL;