ALTER TABLE SYS$LINK$UNIT ADD CONSTRAINT FK_SYS$LINK$UNIT_5 FOREIGN KEY (ID_TYPE_UNIT_GTP) REFERENCES DIR$UNIT$TYPE_UNIT (ID) ON UPDATE CASCADE;

RECONNECT;

ALTER TABLE SYS$LINK$UNIT ADD CONSTRAINT FK_SYS$LINK$UNIT_6 FOREIGN KEY (ID_TYPE_UNIT_BOTTLE) REFERENCES DIR$UNIT$TYPE_UNIT (ID) ON UPDATE CASCADE;

RECONNECT;

ALTER TABLE SYS$LINK$UNIT ADD CONSTRAINT FK_SYS$LINK$UNIT_7 FOREIGN KEY (ID_TYPE_UNIT_CGBU) REFERENCES DIR$UNIT$TYPE_UNIT (ID) ON UPDATE CASCADE;

RECONNECT;

ALTER TABLE SYS$LINK$UNIT ADD CONSTRAINT FK_SYS$LINK$UNIT_8 FOREIGN KEY (ID_TYPE_UNIT_AUTO_GFS) REFERENCES DIR$UNIT$TYPE_UNIT (ID) ON UPDATE CASCADE;

RECONNECT;

/* Create Foreign Key... */
RECONNECT;

ALTER TABLE BAT$FSA$BATCH ADD CONSTRAINT FK_BAT$FSA$BATCH_CREATOR FOREIGN KEY (ID_CREATOR) REFERENCES DIR$SECURITY$DB_USER (ID) ON UPDATE CASCADE;

ALTER TABLE BAT$FSA$BATCH ADD CONSTRAINT FK_BAT$FSA$BATCH_TSERVICE FOREIGN KEY (ID_TSERVICE) REFERENCES DIR$TSERVICE$TSERVICE (ID) ON UPDATE CASCADE;

ALTER TABLE BAT$FSA$BATCH ADD CONSTRAINT FK_BAT$FSA$BATCH_WORKER_ACCEPT FOREIGN KEY (ID_WORKER_ACCEPT) REFERENCES DIR$TSERVICE$WORKER (ID) ON UPDATE CASCADE;

/******************************************************************************/
/****                     Dropping unique constraints                      ****/
/******************************************************************************/
RECONNECT;

ALTER TABLE DIR$UNIT$SERVICES_OF_PURPOSE DROP CONSTRAINT UNQ_DIR$UNIT$SERVICES_OF_PURPO;

RECONNECT;

ALTER TABLE DIR$UNIT$TYPE_UNIT_SERVICE DROP CONSTRAINT UNQ_DIR$UNIT$TYPE_UNIT_SERVICE;

RECONNECT;

ALTER TABLE DOC$LAWSUIT$WRIT_OF_EXEC DROP CONSTRAINT UNQ_DOC$LAWSUIT$WRIT_OF_EXEC_NU;

RECONNECT;

/******************************************************************************/
/****                   Dropping primary key constraints                   ****/
/******************************************************************************/
RECONNECT;

ALTER TABLE DIR$CS$KIND_WORK_USED_MATERIAL DROP CONSTRAINT PK_DIR$CS$KIND_WORK_USED_MATERI;

RECONNECT;

ALTER TABLE DIR$LAWSUIT$DECISION_FOR_PERIOD DROP CONSTRAINT PK_DIR$LAWSUIT$DECISION_FOR_PER;

RECONNECT;

ALTER TABLE DIR$LAWSUIT$REASON_COURT_DECISI DROP CONSTRAINT PK_DIR$LAWSUIT$REASON_COURT_DES;

RECONNECT;

ALTER TABLE DIR$SERVICE$STATE_SERVICE DROP CONSTRAINT PK_DIR$SERVICE$STATE_SERVICE;

RECONNECT;