sites_

The sites_ table stores information about the different sites supported by this Aurea List Manager server. Lyris Aurea List Manager allows you to define different virtual domains for the outside world.

For example, one single Aurea List Manager server could support CheapTickets.acme.com, GreatVacations.acme.com, and BanjoDiscussions.banjo.org.

To users these look like three different servers, but they are all managed from one Aurea List Manager configuration.

Primary Key: SiteID_

Field Name

Description

Version Added

AllowWYSIWYG_

Whether this site should have the HTML editor enabled by default. (bool, 'T' is default)

Added in 8.5

City_

City location of this site (varchar(100), NULL )

 

Comments_

Additional comments about this site (from document table) (varchar(200), NULL)

 

Country_

location of this site (varchar(40), NULL)

 
CTDomains_

text(2147483647), NULL

 
CTEnable_

char(1), NOT NULL

 
CTEnableAllDomains_

char(1), NOT NULL

 

CTToken_

char(16), NULL

 
DefaultEncodingID_

int(4), NULL

 
Desc_

Short description of this site (from document table) (varchar(200), NULL)

 
DigestFtr_

Text that should be appended to every digest on the lists in this site (Text, NULL)

 

DKHeaders_

Colon separated list of mail headers to be included in messages signed

9.2

DKIMSignOn_

Whether DKIM signing is enabled for this site (char(1), NULL)

10.2

DKIMSiteSign_

Sets the default site signing policy, which lists can use (char(1), NOT NULL, default 'F')

10.2

DKSelector

DomainKeys selector sub-domain

9.2

DKSignOn_

Whether DomainKeys signing is enabled for this site (char(1), NULL)

10.2

DKSiteKey_

The PEM encoded DomainKeys private key

9.2

DKSiteSign_

Y: Sign email sent from this site; N: Don’t’ sign

9.2

DigestHdr_

Text that should be prepended to every digest on the lists in this site (text, NULL)

 

DomainName_

Domain name (Hostname) that this site should answer to (varchar(100), NULL)

 
GuiHost_

The name of the web interface domain used for clickthroughs and other customer interaction (varchar(100), NULL)

 
HideMRIEmails (char(1), NOT NULL) 10.0
LicenseLevel_

Limit the site to a lower license level. Useful for hosting situations. Values are (S, P, E) (char(1), NULL)

 
MailAddr_

Postal mailing address for this site (from document table) (varchar(238), NULL)

 
MainAdmin_

Reference to main administrator of this site (from people table) (varchar(50), NULL)

 
MailStreamID_ The MailStream associated with this Site (int, NULL) 10.0

MessageFtr_

Text that should be appended to every message on the lists in this site (text, NULL)

 

MessageHdr_

Text that should be prepended to every message on the lists in this site (Text, NULL)

 

MessageFtrHTML_

and

MessageHdrHTML_

Added to separate text footers from html footers

Added in 8.95.

Name_

Name which identifies this site. e.g.: 'Example Group Ltd' (varchar(30), NOT NULL)

OwnerGIF_

URL to GIF for Owner's logo (varchar(100), NULL)

PiperCompany_

Company name used for EmailAdvisor service (varchar(25), NULL)

Added in 8.8

PiperPassword_

Password used for EmailAdvisor service (varchar(50), or varchar2(50) : Oracle only), NULL)

Added in 8.8

PiperUserName_

User name used for EmailAdvisor service (varchar(50), or varchar2(50) : Oracle only), NULL)

Added in 8.8

SiteID_

Unique identifier for this site. (int, NOT NULL)

TclMergeInit

The site level Tcl initialization string. (text, NULL)

Added in 8.5

TechSupp_

Reference to technical support contact for this site (from people table) (varchar(50), NULL)

 

TranslateLangID_

The default translation language for this site. Applies to default list documents if translated versions exist and to the web interface (int, NULL)

 

URLLyris_

URL to Aurea List Manager 5.0 homepage for this site (varchar(100), NULL)

 

URLOwner_

URL for owner's site. eg: http://www.example.com (varchar(100), NULL)

 

WWWPort_

What port to use for this web server. eg: 80 (varchar(10), NULL)