OmniMessaging Installation Guide 1.7

OmniMessaging Installation Guide
07/22/04 Opsol Integrators Inc. Confidential and Proprietary 38
=USER_MESSAGE_TB PRIMARY KEY (MAILBOX_ID, LOGIN_USER_ID, UID)
=MAILBOX_BASE PRIMARY KEY (MAILBOX_ID)
UNIQUE INDEX =MAILBOX_I0 ON =MAILBOX_BASE ( PARENT_MAILBOX_OR_NAME_SPACE
,PARENT_ID_TYPE
,NAME_HASH_KEY
,MAILBOX_ELEMENT_NAME
,MAILBOX_STATUS)
INDEX =MAILBOX_I1 ON =MAILBOX_BASE (QUOTA_ROOT, MAILBOX_SIZE,
MAILBOX_STATUS,
NO_OF_MESSAGES)
VIEW =MAILBOX_TB AS SELECT * FROM =MAILBOX_BASE WHERE
MAILBOX_STATUS <> "d"
=MAILBOX_CONTENT_BASE PRIMARY KEY ( MAILBOX_ID ,UID )
UNIQUE INDEX =MAILBOX_CONTENT_I0 ON =MAILBOX_CONTENT_BASE (
MAILBOX_ID, SEQUENCE, TOP4GMT, PHANDLE, EXPUNGE)
VIEW =MAILBOX_CONTENT_TB AS SELECT * FROM =MAILBOX_CONTENT_BASE
WHERE EXPUNGE = 0
=MAILBOX_SMTP_BL_TB PRIMARY KEY ( MAILBOX_ID, MAIL_ADDRESS)
=MESSAGE_TB PRIMARY KEY (SEQUENCE, TOP4GMT, PHANDLE)
=MSG_BODYSTRUCTURE_TB PRIMARY KEY (SEQUENCE, TOP4GMT,
PHANDLE, BLOCK_NO)
=MESSAGE_CONTENT_TB PRIMARY KEY (SEQUENCE, TOP4GMT,
PHANDLE, BLOCK_NO)
=MESSAGE_POOL_TB PRIMARY KEY ( MSG_TABLE_NO )
=NDR_TB PRIMARY KEY ( NDR_TYPE )
=NAMESPACE_BASE PRIMARY KEY ( NAMESPACE_ID )
CREATE VIEW =NAMESPACE_TB AS SELECT * FROM =NAMESPACE_BASE WHERE
STATUS <> "d"
=NAMESPACE_ACCESS_TB PRIMARY KEY (ACCOUNT_ID, NAMESPACE_NAME)
UNIQUE INDEX =NAMESPACE_ACCESS_I0 ON =NAMESPACE_ACCESS_TB (ACCOUNT_ID,
NAMESPACE_ID)
=QUOTA_TB PRIMARY KEY ( MAILBOX_ID )
=REDIRECTION_TB CLUSTERING KEY (ADDRESS_ID, ADDRESS_HASH_KEY)
INDEX =REDIRECTION_I0 ON =REDIRECTION_TB (REDIRECT_ADDRESS_ID)
=REGISTRY PRIMARY KEY(OBJECT_NAME, PROCESS_HANDLE)
=SERVICE_PACKAGE_BASE PRIMARY KEY ( SERVICE_PACKAGE_ID )
VIEW =SERVICE_PACKAGE_TB AS SELECT * FROM =SERVICE_PACKAGE_BASE
WHERE STATUS <> "d"
=SESSION_TB PRIMARY KEY ( USER_ID, PROCESS, THREAD )
INDEX =SESSION_I0 ON =SESSION_TB (CURRENT_MAILBOX)
INDEX =SESSION_I1 ON =SESSION_TB (CLIENT_IP_ADDRESS)