
    create table COPARAGRP (
        "UUID" raw(16),
        "CONFIG_ID" raw(16),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0),
        "STATUS" number(5,0),
        "TRANSFERRED_ON" varchar2(80 char),
        "PR_ID" varchar2(18 char),
        "YEAR" number(10,0),
        "COST_TYPE_GROUP_ID" varchar2(20 char),
        "COST_TYPE_GROUP" varchar2(20 char),
        "CTG_NAME" varchar2(80 char),
        "COST_OBLIGO" number,
        "CTG_TYPE_CODE" varchar2(2 char),
        "CTG_TYPE_NAME" varchar2(40 char),
        "BUDGET_PROJ_COST" number,
        "BUDGET_SUBMITTED_COST" number,
        "BUDGET_APPROVED_COST" number,
        "BASELINE_COST_THIS" number,
        "BUDGET_PROJ_EFF" number,
        "BUDGET_SUBMITTED_EFF" number,
        "BUDGET_APPROVED_EFF" number,
        "COST_PLANNED_THIS" number,
        "COST_ACT_THIS" number,
        "COST_REM_THIS" number,
        "COST_TOTAL_THIS" number,
        "EFFORT_PLANNED_THIS" number,
        "EFFORT_ACT_THIS" number,
        "EFFORT_REM_THIS" number,
        "EFFORT_TOTAL_THIS" number,
        "OBLIGO_IMPORT" number(5,0),
        "CREATION_DATE" date
    ) INITRANS 5 MAXTRANS 255;

    alter table COPARAGRP add constraint PID559DT559 primary key ("UUID");

    alter table COPARAGRP
        add constraint FKCOPARAGRPID560
        foreign key ("CONFIG_ID")
        references INTERFACE_CONFIG
        on delete cascade
        deferrable
        novalidate;
    alter table COPARAGRP enable validate constraint FKCOPARAGRPID560;

    create index IDX_COPARAGRPID560 on COPARAGRP ("CONFIG_ID");

    alter table COPARAGRP MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table COPARAGRP
        add constraint DT559UUID_NOT_NULL check("UUID" is not null);

    alter table COPARAGRP
        add constraint DT559CONFIG_ID_NOT_NULL check("CONFIG_ID" is not null);

    alter table COPARAGRP MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table COPARAGRP MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table COPARAGRP MODIFY ("RWDU" DEFAULT 0);

    alter table COPARAGRP MODIFY ("OWNER" DEFAULT 0);

    alter table COPARAGRP MODIFY ("GROUP" DEFAULT 0);

    alter table COPARAGRP MODIFY ("ANY" DEFAULT 0);

    alter table COPARAGRP MODIFY ("STATUS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("YEAR" DEFAULT 0);

    alter table COPARAGRP MODIFY ("COST_OBLIGO" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_PROJ_COST" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_SUBMITTED_COST" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_APPROVED_COST" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BASELINE_COST_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_PROJ_EFF" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_SUBMITTED_EFF" DEFAULT 0);

    alter table COPARAGRP MODIFY ("BUDGET_APPROVED_EFF" DEFAULT 0);

    alter table COPARAGRP MODIFY ("COST_PLANNED_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("COST_ACT_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("COST_REM_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("COST_TOTAL_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("EFFORT_PLANNED_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("EFFORT_ACT_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("EFFORT_REM_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("EFFORT_TOTAL_THIS" DEFAULT 0);

    alter table COPARAGRP MODIFY ("OBLIGO_IMPORT" DEFAULT 0);

    update COPARAGRP set OBLIGO_IMPORT = DEFAULT;

    alter table COPARAGRP MODIFY ("CREATION_DATE" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));