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 ( |
|
Comments_ |
Additional comments about this site (from document table)
( |
|
Country_ |
location of this site ( |
|
CTDomains_ |
text(2147483647), NULL |
|
CTEnable_ |
|
|
CTEnableAllDomains_ |
|
|
CTToken_ |
|
|
DefaultEncodingID_ |
|
|
Desc_ |
Short description of this site (from document table)
( |
|
DigestFtr_ |
Text that should be appended to every digest on the lists
in this site ( |
|
DKHeaders_ |
Colon separated list of mail headers to be included in messages signed |
9.2 |
DKIMSignOn_ |
Whether DKIM signing is enabled for this site ( |
10.2 |
DKIMSiteSign_ |
Sets the default site signing policy, which lists can use ( |
10.2 |
DKSelector |
DomainKeys selector sub-domain |
9.2 |
DKSignOn_ |
Whether DomainKeys signing is enabled for this site ( |
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 ( |
|
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) ( |
|
MailAddr_ |
Postal mailing address for this site (from document table)
( |
|
MainAdmin_ |
Reference to main administrator of this site (from people
table) ( |
|
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 ( |
|
MessageHdr_ |
Text that should be prepended to every message on the
lists in this site ( |
|
MessageFtrHTML_ and MessageHdrHTML_ |
Added to separate text footers from html footers |
Added in 8.95. |
Name_ |
Name which identifies this site. e.g.: 'Example |
|
OwnerGIF_ |
URL to GIF for Owner's logo ( |
|
PiperCompany_ |
Company name used for EmailAdvisor service ( |
Added in 8.8 |
PiperPassword_ |
Password used for EmailAdvisor service ( |
Added in 8.8 |
PiperUserName_ |
User name used for EmailAdvisor service ( |
Added in 8.8 |
SiteID_ |
Unique identifier for this site. ( |
|
TclMergeInit |
The site level Tcl initialization string. ( |
Added in 8.5 |
TechSupp_ |
Reference to technical support contact for this site
(from people table) ( |
|
TranslateLangID_ |
The default translation language for this site. Applies
to default list documents if translated versions exist and to the web interface ( |
|
URLLyris_ |
URL to Aurea List Manager 5.0 homepage for this site ( |
|
URLOwner_ |
URL for owner's site. eg: http://www.example.com ( |
|
WWWPort_ |
What port to use for this web server. eg: 80 ( |