alter table DT461 add LAST_SAP_PSP_IMPORT date;
alter table DT461 MODIFY ("LAST_SAP_PSP_IMPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
update DT461 set LAST_SAP_PSP_IMPORT = DEFAULT;
alter table DT461 add TIME_LAST_SAP_PSP_IMPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_SAP_PSP_IMPORT" DEFAULT 0);
update DT461 set TIME_LAST_SAP_PSP_IMPORT = DEFAULT;
alter table DT963 add BUDGET number;
alter table DT963 MODIFY ("BUDGET" DEFAULT 0);
update DT963 set BUDGET = DEFAULT;
alter table SAPPOOL add BUDGET number;
alter table SAPPOOL MODIFY ("BUDGET" DEFAULT 0);
update SAPPOOL set BUDGET = DEFAULT;
alter table DT974 add BUDGET number;
alter table DT974 MODIFY ("BUDGET" DEFAULT 0);
update DT974 set BUDGET = DEFAULT;
alter table DT461 add "SAP_BUDGET" number;
alter table DT461 MODIFY ("SAP_BUDGET" DEFAULT 0);
update DT461 set "SAP_BUDGET" = DEFAULT;
alter table DT963 drop column COST_TOTAL;
alter table DT974 drop column COST_TOTAL;
alter table DT963 drop column EFFORT_TOTAL;
alter table DT974 drop column EFFORT_TOTAL;
alter table DT823 add SAP_BUDGET number;
alter table DT823 MODIFY ("SAP_BUDGET" DEFAULT 0);
update DT823 set SAP_BUDGET = DEFAULT;
alter table DT963 drop column STATUS;
alter table DT974 drop column STATUS;
alter table DT974 add STATUS varchar2(50 char);
alter table SAPPOOL add SAP_STATUS varchar2(50 char);
alter table DT963 add STATUS varchar2(50 char);
