EXEC DropColumnWithConstraints 'DT963', 'EFFORT_PLAN_SUM';
EXEC DropColumnWithConstraints 'DT963', 'EFFORT_ACT_SUM';
EXEC DropColumnWithConstraints 'DT963', 'EFFORT_REM_SUM';
EXEC DropColumnWithConstraints 'DT963', 'COSTS_PLAN_SUM';
EXEC DropColumnWithConstraints 'DT963', 'COSTS_ACT_SUM';
EXEC DropColumnWithConstraints 'DT963', 'COSTS_REM_SUM';
alter table DT963 add EFFORT_PLAN_PLANTA float;
alter table DT963 add constraint DT963DI064074_DEFAULT DEFAULT 0 FOR [EFFORT_PLAN_PLANTA];
update DT963 set EFFORT_PLAN_PLANTA = DEFAULT;
alter table DT963 add EFFORT_ACT_PLANTA float;
alter table DT963 add constraint DT963DI064075_DEFAULT DEFAULT 0 FOR [EFFORT_ACT_PLANTA];
update DT963 set EFFORT_ACT_PLANTA = DEFAULT;
alter table DT963 add EFFORT_REM_PLANTA float;
alter table DT963 add constraint DT963DI064076_DEFAULT DEFAULT 0 FOR [EFFORT_REM_PLANTA];
update DT963 set EFFORT_REM_PLANTA = DEFAULT;
alter table DT963 add COSTS_REM_PLANTA float;
alter table DT963 add constraint DT963DI064084_DEFAULT DEFAULT 0 FOR [COSTS_REM_PLANTA];
update DT963 set COSTS_REM_PLANTA = DEFAULT;
alter table DT963 add COSTS_ACT_PLANTA float;
alter table DT963 add constraint DT963DI064085_DEFAULT DEFAULT 0 FOR [COSTS_ACT_PLANTA];
update DT963 set COSTS_ACT_PLANTA = DEFAULT;
alter table DT963 add COSTS_PLAN_PLANTA float;
alter table DT963 add constraint DT963DI064086_DEFAULT DEFAULT 0 FOR [COSTS_PLAN_PLANTA];
update DT963 set COSTS_PLAN_PLANTA = DEFAULT;


EXEC DropColumnWithConstraints 'DT974', 'EFFORT_PLAN_SUM';
EXEC DropColumnWithConstraints 'DT974', 'EFFORT_ACT_SUM';
EXEC DropColumnWithConstraints 'DT974', 'EFFORT_REM_SUM';
EXEC DropColumnWithConstraints 'DT974', 'COSTS_PLAN_SUM';
EXEC DropColumnWithConstraints 'DT974', 'COSTS_ACT_SUM';
EXEC DropColumnWithConstraints 'DT974', 'COSTS_REM_SUM';
alter table DT974 add COSTS_PLAN_PLANTA float;
alter table DT974 add constraint DT974DI064091_DEFAULT DEFAULT 0 FOR [COSTS_PLAN_PLANTA];
update DT974 set COSTS_PLAN_PLANTA = DEFAULT;
alter table DT974 add COSTS_ACT_PLANTA float;
alter table DT974 add constraint DT974DI064092_DEFAULT DEFAULT 0 FOR [COSTS_ACT_PLANTA];
update DT974 set COSTS_ACT_PLANTA = DEFAULT;
alter table DT974 add COSTS_REM_PLANTA float;
alter table DT974 add constraint DT974DI064093_DEFAULT DEFAULT 0 FOR [COSTS_REM_PLANTA];
update DT974 set COSTS_REM_PLANTA = DEFAULT;
alter table DT974 add EFFORT_REM_PLANTA float;
alter table DT974 add constraint DT974DI064100_DEFAULT DEFAULT 0 FOR [EFFORT_REM_PLANTA];
update DT974 set EFFORT_REM_PLANTA = DEFAULT;
alter table DT974 add EFFORT_ACT_PLANTA float;
alter table DT974 add constraint DT974DI064101_DEFAULT DEFAULT 0 FOR [EFFORT_ACT_PLANTA];
update DT974 set EFFORT_ACT_PLANTA = DEFAULT;
alter table DT974 add EFFORT_PLAN_PLANTA float;
alter table DT974 add constraint DT974DI064102_DEFAULT DEFAULT 0 FOR [EFFORT_PLAN_PLANTA];
update DT974 set EFFORT_PLAN_PLANTA = DEFAULT;
