Catalogue version 10.0
This issue will track the changes for catalogue 10.0.
-
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE
andDISK_INSTANCE_SPACE
columns ofDISK_SYSTEM
. -
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE_NAME
column ofVIRTUAL_ORGANIZATION
. -
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE_NAME
column ofREQUESTER_ACTIVITY_MOUNT_RULE
. -
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE_NAME
column ofREQUESTER_MOUNT_RULE
. -
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE_NAME
column ofREQUESTER_GROUP_MOUNT_RULE
. -
Add NOT_NULL
andFOREIGN_KEY
constraints toDISK_INSTANCE_NAME
column ofARCHIVE_FILE
. -
Drop ACTIVITY_WEIGHTS
table #1112 (moved) -
Drop TAPE_DRIVE
table #1091 (closed) - Remove columns from
DISK_SYSTEM
table #1111 (closed) ? -
Adds the following UNIQUE INDEX
es (see #990 (closed) for rationale):-
ADMIN_USER_AUN_UN_IDX ON ADMIN_USER(LOWER(ADMIN_USER_NAME)); -
DISK_SYSTEM_DSN_UN_IDX ON DISK_SYSTEM(LOWER(DISK_SYSTEM_NAME)); -
DISK_INSTANCE_DIN_UN_IDX ON DISK_INSTANCE(LOWER(DISK_INSTANCE_NAME)); -
DISK_INSTNCE_SPCE_DISN_UN_IDX ON DISK_INSTANCE_SPACE(LOWER(DISK_INSTANCE_SPACE_NAME)); -
VIRTUAL_ORG_VON_UN_IDX ON VIRTUAL_ORGANIZATION(LOWER(VIRTUAL_ORGANIZATION_NAME)); -
STORAGE_CLASS_SCN_UN_IDX ON STORAGE_CLASS(LOWER(STORAGE_CLASS_NAME)); -
TAPE_POOL_TPN_UN_IDX ON TAPE_POOL(LOWER(TAPE_POOL_NAME)); -
MEDIA_TYPE_MTN_UN_IDX ON MEDIA_TYPE(LOWER(MEDIA_TYPE_NAME)); -
LOGICAL_LIBRARY_LLN_UN_IDX ON LOGICAL_LIBRARY(LOWER(LOGICAL_LIBRARY_NAME)); -
TAPE_VID_UN_IDX ON TAPE(LOWER(VID)); -
MOUNT_POLICY_MPN_UN_IDX ON MOUNT_POLICY(LOWER(MOUNT_POLICY_NAME)); -
DRIVE_STATE_DN_UN_IDX ON DRIVE_STATE(LOWER(DRIVE_NAME));
-
- Removes the following
CONSTRAINT
s which are replaced byUNIQUE INDEX
es above:-
CONSTRAINT VIRTUAL_ORGANIZATION_VON_UN UNIQUE(VIRTUAL_ORGANIZATION_NAME) -
CONSTRAINT STORAGE_CLASS_SCN_UN UNIQUE(STORAGE_CLASS_NAME) -
CONSTRAINT TAPE_POOL_TPN_UN UNIQUE(TAPE_POOL_NAME) -
CONSTRAINT MEDIA_TYPE_MTN_UN UNIQUE(MEDIA_TYPE_NAME) -
CONSTRAINT LOGICAL_LIBRARY_LLN_UN UNIQUE(LOGICAL_LIBRARY_NAME)
-
- Adds indexes for columns used in foreign keys #1158 (closed)
-
CREATE INDEX STORAGE_CLASS_VOI_IDX ON STORAGE_CLASS(VIRTUAL_ORGANIZATION_ID); -
CREATE INDEX TAPE_POOL_VOI_IDX ON TAPE_POOL(VIRTUAL_ORGANIZATION_ID); -
CREATE INDEX TAPE_LLI_IDX ON TAPE(LOGICAL_LIBRARY_ID); -
CREATE INDEX TAPE_MTI_IDX ON TAPE(MEDIA_TYPE_ID); -
CREATE INDEX REQ_ACT_MNT_RULE_MPN_IDX ON REQUESTER_ACTIVITY_MOUNT_RULE(MOUNT_POLICY_NAME); -
CREATE INDEX REQ_MNT_RULE_MPN_IDX ON REQUESTER_MOUNT_RULE(MOUNT_POLICY_NAME); -
CREATE INDEX REQ_GRP_MNT_RULE_MPN_IDX ON REQUESTER_GROUP_MOUNT_RULE(MOUNT_POLICY_NAME); -
CREATE INDEX ARCHIVE_FILE_SCI_IDX ON ARCHIVE_FILE(STORAGE_CLASS_ID); -
CREATE INDEX FILE_RECYCLE_LOG_SCD_IDX ON FILE_RECYCLE_LOG(STORAGE_CLASS_ID); -
CREATE INDEX FILE_RECYCLE_LOG_VID_IDX ON FILE_RECYCLE_LOG(VID);
-
Edited by Miguel Barros