alter table DT963 drop column EFFORT_PLAN_SUM;
alter table DT963 drop column EFFORT_ACT_SUM;
alter table DT963 drop column EFFORT_REM_SUM;
alter table DT963 drop column COSTS_PLAN_SUM;
alter table DT963 drop column COSTS_ACT_SUM;
alter table DT963 drop column COSTS_REM_SUM;
alter table DT963 add EFFORT_PLAN_PLANTA number;
alter table DT963 MODIFY ("EFFORT_PLAN_PLANTA" DEFAULT 0);
update DT963 set EFFORT_PLAN_PLANTA = DEFAULT;
alter table DT963 add EFFORT_ACT_PLANTA number;
alter table DT963 MODIFY ("EFFORT_ACT_PLANTA" DEFAULT 0);
update DT963 set EFFORT_ACT_PLANTA = DEFAULT;
alter table DT963 add EFFORT_REM_PLANTA number;
alter table DT963 MODIFY ("EFFORT_REM_PLANTA" DEFAULT 0);
update DT963 set EFFORT_REM_PLANTA = DEFAULT;
alter table DT963 add COSTS_REM_PLANTA number;
alter table DT963 MODIFY ("COSTS_REM_PLANTA" DEFAULT 0);
update DT963 set COSTS_REM_PLANTA = DEFAULT;
alter table DT963 add COSTS_ACT_PLANTA number;
alter table DT963 MODIFY ("COSTS_ACT_PLANTA" DEFAULT 0);
update DT963 set COSTS_ACT_PLANTA = DEFAULT;
alter table DT963 add COSTS_PLAN_PLANTA number;
alter table DT963 MODIFY ("COSTS_PLAN_PLANTA" DEFAULT 0);
update DT963 set COSTS_PLAN_PLANTA = DEFAULT;


alter table DT974 drop column EFFORT_PLAN_SUM;
alter table DT974 drop column EFFORT_ACT_SUM;
alter table DT974 drop column EFFORT_REM_SUM;
alter table DT974 drop column COSTS_PLAN_SUM;
alter table DT974 drop column COSTS_ACT_SUM;
alter table DT974 drop column COSTS_REM_SUM;
alter table DT974 add COSTS_PLAN_PLANTA number;
alter table DT974 MODIFY ("COSTS_PLAN_PLANTA" DEFAULT 0);
update DT974 set COSTS_PLAN_PLANTA = DEFAULT;
alter table DT974 add COSTS_ACT_PLANTA number;
alter table DT974 MODIFY ("COSTS_ACT_PLANTA" DEFAULT 0);
update DT974 set COSTS_ACT_PLANTA = DEFAULT;
alter table DT974 add COSTS_REM_PLANTA number;
alter table DT974 MODIFY ("COSTS_REM_PLANTA" DEFAULT 0);
update DT974 set COSTS_REM_PLANTA = DEFAULT;
alter table DT974 add EFFORT_REM_PLANTA number;
alter table DT974 MODIFY ("EFFORT_REM_PLANTA" DEFAULT 0);
update DT974 set EFFORT_REM_PLANTA = DEFAULT;
alter table DT974 add EFFORT_ACT_PLANTA number;
alter table DT974 MODIFY ("EFFORT_ACT_PLANTA" DEFAULT 0);
update DT974 set EFFORT_ACT_PLANTA = DEFAULT;
alter table DT974 add EFFORT_PLAN_PLANTA number;
alter table DT974 MODIFY ("EFFORT_PLAN_PLANTA" DEFAULT 0);
update DT974 set EFFORT_PLAN_PLANTA = DEFAULT;
