urls_

This table stores information about the URL for a message.

Primary key: UrlID_

Note

On MSSQL, the URLText_ may display only 256 characters when in fact up to 4000 characters are recorded.

Added or Modified in 8.9

Field Name

Description

Version Added

UrlID_

An auto-numbering field to server as a unique identifier for the row. (int, NOT NULL)

PrettyName_

The text that the users sees as the link (ex: Click Me). (varchar (100), NULL)

URLHash_

An MD5 hash of the UrlText_ to enable MS SQL to index this table.(char(32), NOT NULL)

Added in 8.9

UrlText_

The actual URL (varchar(4000), NOT NULL)

Field changed to 4000 characters in 8.9