The sites_ table stores information about the different sites supported by this ListManager server. Lyris
ListManager allows you to define different virtual domains for the outside world. For example, one single
ListManager 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 ListManager configuration.
|
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)
|
|
|
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 ListManager 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)
|
|