You are here: ListManager Programmer's Guide > ListManager Tables > Clicktracking > urls_
 

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

   

Lyris, Inc.

6401 Hollis Street., # 125

Emeryville, CA 94608



Customer Support:

1-888-LYRIS-CS (1-888-597-4727)

or

1-571-730-5259



Hours:

Monday through Friday

6:00 a.m.--6:00 p.m. PST

Self-Serve Portal:

http://www.lyris.com/customer-service/contact-support/