CREATE TABLE OPERATIONS_UNIT (
    ID           INTEGER NOT NULL,
    STATUS       INTEGER,
    DATECREATE   TIMESTAMP,
    USERCREATE   VARCHAR( 20 ),
    NAMEUNIT     VARCHAR( 50 ),
    DESCRIPTION  VARCHAR( 300 ) COLLATE PXW_CYRL
);
ALTER TABLE OPERATIONS_UNIT ADD CONSTRAINT PK_OPERATIONS_UNIT PRIMARY KEY (ID);

CREATE TABLE HIST_OPERATUNION (
    ID             INTEGER NOT NULL,
    ID_PARENT      INTEGER,
    STATUS         INTEGER DEFAULT  0 ,
    DATECREATE     TIMESTAMP,
    USERCREATE     VARCHAR( 20 ),
    STHIST         INTEGER,
    ID_GROUPUNIT   INTEGER,
    NAMEOPERATION  VARCHAR( 50 ),
    COMMENTS       VARCHAR( 300 )
);

ALTER TABLE HIST_OPERATUNION ADD CONSTRAINT PK_HIST_OPERATUNION PRIMARY KEY (ID);

CREATE TABLE OPERATUNION (
    ID             INTEGER NOT NULL,
    ID_PARENT      INTEGER,
    STATUS         INTEGER DEFAULT  0 ,
    DATECREATE     TIMESTAMP,
    USERCREATE     VARCHAR( 20 ),
    ID_GROUPUNIT   INTEGER,
    NAMEOPERATION  VARCHAR( 50 ),
    COMMENTS       VARCHAR( 300 )
);

ALTER TABLE OPERATUNION ADD CONSTRAINT PK_OPERATUNION PRIMARY KEY (ID);

ALTER TABLE OPERATUNION ADD CONSTRAINT FK_OPERATUNION FOREIGN KEY (ID_PARENT) REFERENCES OPERATUNION (ID);