OmniMessaging Installation Guide 1.7

OmniMessaging Installation Guide
07/22/04 Opsol Integrators Inc. Confidential and Proprietary 39
=SUBMISSION_ADDRESS_BASE PRIMARY KEY (NAME_HASH_KEY, DOMAIN_ID,
SMTP_USER)
UNIQUE INDEX =SUBMISSION_ADDRESS_I0 ON =SUBMISSION_ADDRESS_BASE
(ADDRESS_ID)
CREATE INDEX =SUBMISSION_ADDRESS_I1 ON =SUBMISSION_ADDRESS_BASE
(TARGET_MAILBOX, SUBADDR_STATUS)
CREATE INDEX =SUBMISSION_ADDRESS_I2 ON =SUBMISSION_ADDRESS_BASE
(ACCOUNT_ID, ADDRESS_TYPE)
CREATE VIEW =SUBMISSION_ADDRESS_TB AS SELECT * FROM
=SUBMISSION_ADDRESS_BASE WHERE SUBADDR_STATUS <> "d"
=SUBSCRIPTION_TB PRIMARY KEY ( USER_ID, MAILBOX_NAME )
=SYSTEM_PARAMETER_TABLE
=SYSTEM_RELAY_DOMAIN_TB PRIMARY KEY (DOMAIN_NAME)
=SYS_RETRIEVAL_SUBNET_TB PRIMARY KEY (SUBNET, SUBNET_MASK)
=SYS_SMTP_SUBNET_TB PRIMARY KEY (SUBNET, SUBNET_MASK)
15.2 Maximum values for data types used in
keys
MAILBOX_ID UNSIGNED LONG
USER_ID UNSIGNED LONG
DOMAIN_ID UNSIGNED LONG
ACCOUNT_ID UNSIGNED LONG
PROVISIONING_ID STRING MAXLEN 128
ADDRESS_ID UNSIGNED LONG
BLACKLIST_ID UNSIGNED LONG
NAMESPACE_ID UNSIGNED LONG
UID UNSIGNED LONG
MAILBOX_NAME STRING MAXLEN 248
DOMAIN_NAME STRING MAXLEN 64
MAIL_ADDRESS STRING MAXLEN 129
ID_TYPE CHAR
LOGIN_NAME STRING MAXLEN 128
NOTE: An NSIM user's name used for authentication should be expressed in
a seven-bit transfer encoding such as US-ASCII
TOP4GMT INT
PHANDLE STRING MAXLEN 20
MSG_TABLE_NO SHORT
SERVICE_PACKAGE_ID UNSIGNED LONG