alter table DT461 add LAST_SAP_PSP_IMPORT datetime2;
alter table DT461 add constraint DT461DI064072_DEFAULT DEFAULT CONVERT(datetime2,'01.01.1970',104) FOR [LAST_SAP_PSP_IMPORT];
update DT461 set LAST_SAP_PSP_IMPORT = DEFAULT;
alter table DT461 add TIME_LAST_SAP_PSP_IMPORT numeric(10,0);
alter table DT461 add constraint DT461DI064073_DEFAULT DEFAULT 0 FOR [TIME_LAST_SAP_PSP_IMPORT];
update DT461 set TIME_LAST_SAP_PSP_IMPORT = DEFAULT;
alter table DT963 add BUDGET float;
alter table DT963 add constraint DT963DI064087_DEFAULT DEFAULT 0 FOR [BUDGET];
update DT963 set BUDGET = DEFAULT;
alter table SAPPOOL add BUDGET float;
alter table SAPPOOL add constraint DT964DI064088_DEFAULT DEFAULT 0 FOR [BUDGET];
update SAPPOOL set BUDGET = DEFAULT;
alter table DT974 add BUDGET float;
alter table DT974 add constraint DT974DI064103_DEFAULT DEFAULT 0 FOR [BUDGET];
update DT974 set BUDGET = DEFAULT;
alter table DT461 add SAP_BUDGET float;
alter table DT461 add constraint DT461DI064104_DEFAULT DEFAULT 0 FOR [SAP_BUDGET];
update DT461 set SAP_BUDGET = DEFAULT;
EXEC DropColumnWithConstraints 'DT963', 'COST_TOTAL';
EXEC DropColumnWithConstraints 'DT973', 'COST_TOTAL';
EXEC DropColumnWithConstraints 'DT963', 'EFFORT_TOTAL';
EXEC DropColumnWithConstraints 'DT974', 'EFFORT_TOTAL';
alter table DT823 add SAP_BUDGET float;
alter table DT823 add constraint DT823DI064108_DEFAULT DEFAULT 0 FOR [SAP_BUDGET];
update DT823 set SAP_BUDGET = DEFAULT;
EXEC DropColumnWithConstraints 'DT963', 'STATUS';
EXEC DropColumnWithConstraints 'DT974', 'STATUS';
alter table DT963 add STATUS varchar(50);
alter table DT974 add STATUS varchar(50);
alter table SAPPOOL add SAP_STATUS varchar(50);
