alter table DT461 add SAP_RELEVANT number(5,0);
alter table DT461 MODIFY ("SAP_RELEVANT" DEFAULT 0);
alter table DT461 add EXPORT_TO_SAP number(5,0);
alter table DT461 MODIFY ("EXPORT_TO_SAP" DEFAULT 0);
alter table DT461 add DATE_LAST_SAP_PROJECT_EXPORT date;
alter table DT461 MODIFY ("DATE_LAST_SAP_PROJECT_EXPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_SAP_PROJECT_EXPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_SAP_PROJECT_EXPORT" DEFAULT 0);
alter table DT461 add DATE_LAST_SAP_PSP_EXPORT date;
alter table DT461 MODIFY ("DATE_LAST_SAP_PSP_EXPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_SAP_PSP_EXPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_SAP_PSP_EXPORT" DEFAULT 0);
alter table DT461 add DATE_LAST_PLANNED_COSTS_EXPORT date;
alter table DT461 MODIFY ("DATE_LAST_PLANNED_COSTS_EXPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_PLANNED_COSTS_EXPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_PLANNED_COSTS_EXPORT" DEFAULT 0);
alter table DT461 add DATE_LAST_ACTUAL_HOURS_EXPORT date;
alter table DT461 MODIFY ("DATE_LAST_ACTUAL_HOURS_EXPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_ACTUAL_HOURS_EXPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_ACTUAL_HOURS_EXPORT" DEFAULT 0);
alter table DT461 add DATE_LAST_ACTUAL_COSTS_IMPORT date;
alter table DT461 MODIFY ("DATE_LAST_ACTUAL_COSTS_IMPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_ACTUAL_COSTS_IMPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_ACTUAL_COSTS_IMPORT" DEFAULT 0);
alter table DT461 add DATE_LAST_LIABILITY_IMPORT date;
alter table DT461 MODIFY ("DATE_LAST_LIABILITY_IMPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT461 add TIME_LAST_LIABILITY_IMPORT number(10,0);
alter table DT461 MODIFY ("TIME_LAST_LIABILITY_IMPORT" DEFAULT 0);

alter table DT963 add DATE_LAST_SAP_PSP_EXPORT date;
alter table DT963 MODIFY ("DATE_LAST_SAP_PSP_EXPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT963 add TIME_LAST_SAP_PSP_EXPORT number(10,0);
alter table DT963 MODIFY ("TIME_LAST_SAP_PSP_EXPORT" DEFAULT 0);
alter table DT963 add DATE_LAST_SAP_PSP_IMPORT date;
alter table DT963 MODIFY ("DATE_LAST_SAP_PSP_IMPORT" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));
alter table DT963 add TIME_LAST_SAP_PSP_IMPORT number(10,0);
alter table DT963 MODIFY ("TIME_LAST_SAP_PSP_IMPORT" DEFAULT 0);


update DT461 set SAP_RELEVANT = DEFAULT;
update DT461 set EXPORT_TO_SAP = DEFAULT;
update DT461 set DATE_LAST_SAP_PROJECT_EXPORT = DEFAULT;
update DT461 set TIME_LAST_SAP_PROJECT_EXPORT = DEFAULT;
update DT461 set DATE_LAST_SAP_PSP_EXPORT = DEFAULT;
update DT461 set TIME_LAST_SAP_PSP_EXPORT = DEFAULT;
update DT461 set TIME_LAST_PLANNED_COSTS_EXPORT = DEFAULT;
update DT461 set DATE_LAST_ACTUAL_HOURS_EXPORT = DEFAULT;
update DT461 set TIME_LAST_ACTUAL_HOURS_EXPORT = DEFAULT;
update DT461 set DATE_LAST_ACTUAL_COSTS_IMPORT = DEFAULT;
update DT461 set TIME_LAST_ACTUAL_COSTS_IMPORT = DEFAULT;
update DT461 set DATE_LAST_LIABILITY_IMPORT = DEFAULT;
update DT461 set TIME_LAST_LIABILITY_IMPORT = DEFAULT;

update DT963 set DATE_LAST_SAP_PSP_EXPORT = DEFAULT;
update DT963 set TIME_LAST_SAP_PSP_EXPORT = DEFAULT;
update DT963 set DATE_LAST_SAP_PSP_IMPORT = DEFAULT;
update DT963 set TIME_LAST_SAP_PSP_IMPORT = DEFAULT;

commit;