Summary of "urls_" fields for ListManager

 

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