Damir chmo

ALTER TABLE TEMPTHREE
    DROP FOREIGN KEY FK_TEMPTHREE_TEMPONE;
ALTER TABLE TEMPTHREE
    DROP FOREIGN KEY FK_TEMPTHREE_TEMPTWO;
ALTER TABLE TEMPONE
    DROP CONSTRAINT SYS_C0010894;
ALTER TABLE TEMPONE
    DROP CONSTRAINT SYS_C0010893;
ALTER TABLE TEMPTHREE
    DROP CONSTRAINT SYS_C0010898;
ALTER TABLE TEMPTHREE
    DROP CONSTRAINT SYS_C0010897;
ALTER TABLE TEMPTHREE
    DROP CONSTRAINT SYS_C0010896;
ALTER TABLE TEMPTWO
    DROP CONSTRAINT SYS_C0010895;
DROP TABLE TEMPONE;
DROP TABLE TEMPTHREE;
DROP TABLE TEMPTWO;
CREATE TABLE TEMPONE  (
    TEMPONEID       decimal(38,0) NOT NULL,
    TEMPONENUMBERS  decimal(38,0) NOT NULL,
    TEMPONENAME     varchar(50) NULL,
    PRIMARY KEY(TEMPONEID)
);
CREATE TABLE TEMPTHREE  (
    TEMPTHREEID     decimal(38,0) NOT NULL,
    TEMPTWOID       decimal(38,0) NOT NULL,
    TEMPONEID       decimal(38,0) NOT NULL,
    TEMPTHREENAME   varchar(50) NULL,
    PRIMARY KEY(TEMPTHREEID)
);
CREATE TABLE TEMPTWO  (
    TEMPTWOID   decimal(38,0) NOT NULL,
    TEMPTWONAME varchar(50) NULL,
    PRIMARY KEY(TEMPTWOID)
);
ALTER TABLE TEMPONE
    ADD CONSTRAINT SYS_C0010894
    CHECK ("TEMPONENUMBERS" IS NOT NULL);
ALTER TABLE TEMPONE
    ADD CONSTRAINT SYS_C0010893
    CHECK ("TEMPONEID" IS NOT NULL);
ALTER TABLE TEMPTHREE
    ADD CONSTRAINT SYS_C0010898
    CHECK ("TEMPONEID" IS NOT NULL);
ALTER TABLE TEMPTHREE
    ADD CONSTRAINT SYS_C0010897
    CHECK ("TEMPTWOID" IS NOT NULL);
ALTER TABLE TEMPTHREE
    ADD CONSTRAINT SYS_C0010896
    CHECK ("TEMPTHREEID" IS NOT NULL);
ALTER TABLE TEMPTWO
    ADD CONSTRAINT SYS_C0010895
    CHECK ("TEMPTWOID" IS NOT NULL);
ALTER TABLE TEMPTHREE
    ADD CONSTRAINT FK_TEMPTHREE_TEMPONE
    FOREIGN KEY(TEMPONEID)
    REFERENCES TEMPONE(TEMPONEID)
    ON DELETE NO ACTION ;
ALTER TABLE TEMPTHREE
    ADD CONSTRAINT FK_TEMPTHREE_TEMPTWO
    FOREIGN KEY(TEMPTWOID)
    REFERENCES TEMPTWO(TEMPTWOID)
    ON DELETE NO ACTION ;