ALTER TABLE ADRFILE.APPLICATION
  DROP CONSTRAINT APP_PK;

ALTER TABLE ADRFILE.APPLICATION ADD (
  CONSTRAINT APP_PK
  PRIMARY KEY
  (APPLICATION_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY_PATTERN
  DROP CONSTRAINT DIRPTN_PK;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN ADD (
  CONSTRAINT DIRPTN_PK
  PRIMARY KEY
  (DIRECTORY_PATTERN_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY
  DROP CONSTRAINT DIR_PK;

ALTER TABLE ADRFILE.DIRECTORY ADD (
  CONSTRAINT DIR_PK
  PRIMARY KEY
  (DIRECTORY_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG
  DROP CONSTRAINT DOCACCLOG_PK;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG ADD (
  CONSTRAINT DOCACCLOG_PK
  PRIMARY KEY
  (DOCUMENT_ACCESS_LOG_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.FILES
  DROP CONSTRAINT FLE_PK;

ALTER TABLE ADRFILE.FILES ADD (
  CONSTRAINT FLE_PK
  PRIMARY KEY
  (FILE_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.MOUNT_POINT
  DROP CONSTRAINT MNTPNT_PK;

ALTER TABLE ADRFILE.MOUNT_POINT ADD (
  CONSTRAINT MNTPNT_PK
  PRIMARY KEY
  (MOUNT_POINT_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY
  DROP CONSTRAINT RELATIONSHIP104;


ALTER TABLE ADRFILE.DIRECTORY ADD (
  CONSTRAINT RELATIONSHIP104 
  FOREIGN KEY (MOUNT_POINT_ID) 
  REFERENCES ADRFILE.MOUNT_POINT (MOUNT_POINT_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY_PATTERN
  DROP CONSTRAINT RELATIONSHIP110;


ALTER TABLE ADRFILE.DIRECTORY_PATTERN ADD (
  CONSTRAINT RELATIONSHIP110 
  FOREIGN KEY (APPLICATION_ID) 
  REFERENCES ADRFILE.APPLICATION (APPLICATION_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY
  DROP CONSTRAINT RELATIONSHIP111;


ALTER TABLE ADRFILE.DIRECTORY ADD (
  CONSTRAINT RELATIONSHIP111 
  FOREIGN KEY (APPLICATION_ID) 
  REFERENCES ADRFILE.APPLICATION (APPLICATION_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.FILES
  DROP CONSTRAINT RELATIONSHIP112;


ALTER TABLE ADRFILE.FILES ADD (
  CONSTRAINT RELATIONSHIP112 
  FOREIGN KEY (DIRECTORY_ID) 
  REFERENCES ADRFILE.DIRECTORY (DIRECTORY_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG
  DROP CONSTRAINT RELATIONSHIP115;


ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG ADD (
  CONSTRAINT RELATIONSHIP115 
  FOREIGN KEY (FILE_ID) 
  REFERENCES ADRFILE.FILES (FILE_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.MOUNT_POINT
  DROP CONSTRAINT RELATIONSHIP118;


ALTER TABLE ADRFILE.MOUNT_POINT ADD (
  CONSTRAINT RELATIONSHIP118 
  FOREIGN KEY (APPLICATION_ID) 
  REFERENCES ADRFILE.APPLICATION (APPLICATION_ID)
  ENABLE VALIDATE);
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  DIRECTORY_ID NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  DIRECTORY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  NAME NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  IN_USE_FLAG NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  IN_USE_FLAG NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.DIRECTORY MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  DOCUMENT_ACCESS_LOG_ID NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  DOCUMENT_ACCESS_LOG_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  ACCESS_DATE NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  ACCESS_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.DOCUMENT_ACCESS_LOG MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  DIRECTORY_PATTERN_ID NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  DIRECTORY_PATTERN_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  NAME NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  IN_USE_FLAG NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  IN_USE_FLAG NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.DIRECTORY_PATTERN MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  MOUNT_POINT_ID NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  MOUNT_POINT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  APPLICATION_ID NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  APPLICATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  NAME NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.MOUNT_POINT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  APPLICATION_ID NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  APPLICATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.APPLICATION MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  FILE_ID NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  FILE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  NAME NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE ADRFILE.FILES MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
