|
Field Name
|
Description
|
Version Added
|
|
AddHeadersAndFooters_
|
Should ListManager add the email headers and footers automatically to new content. N = Never, A = Automatic,
I = Insert into content/mailing during creation. (char (1) default='N')
|
8.5
|
|
Additional_
|
Additional fields that should be requested from new subscribers [inactive](text, NULL)
|
|
|
Admin_
|
Administrator responsible for this list (link to people) (varchar(50), NOT NULL)
|
|
|
AdminSend_
|
Only Admins can send mail to the list (bool)
|
|
|
AllowCross_
|
Allows cross-posting of identical messages (bool)
|
|
|
AllowDupe_
|
Allows posting of identical messages (bool)
|
|
|
AllowInfo_
|
Allow non-members to read general information about this list (bool)
|
|
|
Anonymous_
|
If true, the messages posted to the list are stripped of all identifying markers, so that they become
anonymous (bool)
|
|
|
AnyonePost_
|
Anyone can post to the list, even non-members (bool)
|
|
|
ApproveNum_
|
Number of messages have to be approved before a new person can post unapproved (smallint, NOT NULL)
|
|
|
ArchivDays_
|
Keep message archives around for how many days (smallint, NOT NULL)
|
|
|
ArchivNum_
|
Keep how many individual messages archived (int, NOT NULL)
|
|
|
BlnkSubjOk_
|
If set to TRUE, then Lyris will allow messages that have a blank subject line (bool)
|
|
|
CacheDateTime_
|
The date time of the latest refresh of the List Members count stats.
|
|
|
CacheHeldMemberCount_
|
The number of held members in the list calculated by the latest refresh of the List Members count stats.
|
|
|
CacheNormalMemberCount_
|
The number of normal members in the list calculated by the latest refresh of the List Members count stats.
|
|
|
CacheOtherMemberCount_
|
The number of other members in the list calculated by the latest refresh of the List Members count stats.
|
|
|
CacheUnsubMemberCount_
|
The number of unsubscribed members in the list calculated by the latest refresh of the List Members count stats.
|
|
|
Child_
|
If set, then this list can act as a 'child' list to other lists, meaning that this list can be a member
of another list, and receive postings from that list. If this is not set, Lyris automatically rejects
posting submissions from other lists as possible error-mail or loop conditions. (bool)
|
|
|
CleanAuto_
|
Do not mark as 'held' members who bounce too much email (ie: let them bounce all they want) (bool)
|
|
|
CleanDays_
|
After how many days a user is 'held' should we purge them (smallint, NOT NULL)
|
|
|
CleanNotif_
|
For how many days after a user is 'held' should we send them reminder messages (smallint, NOT NULL
|
|
|
CleanUnsub_
|
After how many days a user is 'unsub' should we purge them (smallint, NOT NULL)
|
|
|
Comment_
|
Holds whatever comments the programmer wishes to put in. Useful as a user-defined 'additional info' field.
(text, NULL)
|
|
|
CommentsID_
|
Comment about this list (link to document) (int, NULL)
|
|
|
ConferencePost_
|
Who is allowed to post to the list's conference: A = admin only, M = members only, E = everyone (char(1),
NOT NULL)
|
|
|
ConferenceVisibility_
|
Who can access the conference: D - disabled conference, M - members only, E - everyone (char(1), NOT NULL)
|
|
|
ConferenceDuration_
|
How long the contents of a conference are kept in memory: stored in hours. (smallint, NOT NULL)
|
|
|
ConfDays_
|
How many days after a member has not confirmed to list should he be deleted (smallint, NOT NULL)
|
|
|
ConfNotify_
|
At what day interval should held members receive notification (tinyint, NOT NULL)
|
|
|
ConfUnsub_
|
When unsubscribing over email, should 2=do it immediately, 1=confirm always, 0=confirm only if questionable
(tinyint, NOT NULL)
|
|
|
CreatStamp_
|
Date/time stamp this list was created (smalldatetime, NULL)
|
|
|
CrossClean_
|
Clean out duplicate recipients with cross-posts, so that members of multiple lists only receive one copy
of a message (bool)
|
|
|
DefaultFrom_
|
The 'from' value that should be used as a default for this list. (varchar(200), NULL)
|
|
|
DefaultTo_
|
The value for the TO header, if it is not provided (varchar(200), NULL)
|
|
|
DefaultSubject_
|
The value for the SUBJECT header, if not provided. (varchar(100), NULL)
|
|
|
DefaultSubsetID_
|
The ID number of the subset that this list should use by default when creating new mailings. If set to
0, defaults to the entire list.(int, NULL)
|
8.95
|
|
DeliveryReports_
|
What delivery reports should be sent to admins via email (int, NULL)
|
|
|
DescLongID_
|
Long description of this list (link to document) (int, NULL)
|
|
|
DescShort_
|
Short description of this list (varchar(200), NOT NULL)
|
|
|
DetectHtmlByDefault_
|
Should new messages created in the web interface detect HTML by default. (bool)
|
|
|
DetectOpenByDefault_
|
Should new messages created in the web interface perform open detection by default. (bool)
|
|
|
DigestFtr_
|
Text that should be appended to every digest (text, NULL)
|
|
|
DigestHdr_
|
Text that should be prepended to every digest (text, NOT NULL)
|
|
|
Disabled_
|
If set, then this list is disabled. The list admin is not allowed to send any email to the list (bool)
|
|
|
DKIMListSign_
|
Sets the signing policy for messages on this list. T = True, F = False. (char (1), NULL)
|
Added in 10.2
|
|
DKListSign_
|
If set, enables DomainKeys signing. T = True, F = False. (char (1), NULL)
|
Added in 10.2
|
|
DKSenderListSign_
|
Enables third-party DomainKeys signing when a matching signing domain is not available. (bool, default false)
|
Added in 10.2
|
|
ErrHold_
|
After how many days of mail bounces should a member be placed on hold? (default=5) (tinyint, NOT NULL)
|
|
|
ExpireDays_
|
How many days after a member has expired, should he be deleted (smallint, NOT NULL)
|
|
|
From_
|
If filled in, this specifies the from field of every message send on this list (varchar(100), NULL)
|
|
|
HdrRemove_
|
Headers that should be removed from list postings (text, NULL)
|
|
|
KeepOutmailPostings_
|
How long to keep postings in the outmail_ table. More data gives more accurate reports, but slows the
server performance. (smallint, NOT NULL)
|
|
|
Keywords_
|
Keywords that describe this list (varchar(200), NULL)
|
|
|
ListID_
|
An incrementing numeric counter for the list (int, NOT NULL)
|
|
|
ListSubj_
|
Should we prepend the list name to the subject line of every outgoing list message (char(1), NOT NULL)
|
|
|
MaxMembers_
|
Maximum number of members allowed on this list. If set to 0, then no limit (int, NOT NULL)
|
|
|
MailStreamID_
|
The MailStream associated with this Recipient (int, NULL)
|
|
|
MaxMessNum_
|
Maximum number of messages that can be sent to the list in 24 hour period (0=unlimited) (smallint, NOT
NULL)
|
|
|
MaxMessSiz_
|
In bytes, the maximum size of allowed messages from non-admin people (int, NOT NULL)
|
|
|
MaxPerUser_
|
What is the maximum number of messages that a single user can post on a single day to this list (int,
NOT NULL)
|
|
|
MaxQuoting_
|
What is the maximum number of contiguous lines that can be quoted at once in a single message (int, NOT
NULL)
|
|
|
MergeAllowBody_
|
Are Tcl mail merge tags evaluated in the body of the message ( tinyint, NOT NULL)
|
|
|
MergeCapabilities_
|
What capabilities are allowed for Tcl mail merging (tinyint, NOT NULL)
|
|
|
MergeCapOverride_
|
Whether this list should override the server mail merging settings(tinyint, NOT NULL)
|
|
|
MessageFtr_
|
Text that should be appended to every message (text, NULL)
|
|
|
MessageHdr_
|
Text that should be prepended to every message (text, NULL)
|
|
|
MessageFtrHTML_
and
MessageHdrHTML_
|
Added to separate text footers from html footers.
|
Added in 8.95.
|
|
ModHdrDate_
|
If set, then moderated messages have their Date: header rewritten to be the date/time that they are approved,
removing the original Date: header stamp (char(1), NOT NULL)
|
|
|
Moderated_
|
How often, if at all, is this list moderated? (varchar(20), NOT NULL)
|
|
|
MriVisibility_
|
Whether the Discussion Forum Interface should be generally visible, visible only when accessing the URL
directly, or inaccessible. V = Visible, H = Hidden (visible if you know the URL), I = Inaccessible (char
(1), default 'V')
|
Added in 8.5
|
|
Name_
|
Internal name which identifies this mailing list, not seen by users (varchar(60), primary key, NOT NULL)
|
|
|
NameReqd_
|
When subscribing over the web, should 0=name is optional, 1=name is not asked for, 2=require name (tinyint,
NOT NULL)
|
|
|
NoArchive_
|
Messages on this mailing list should not be archived (bool)
|
|
|
NoBodyOk_
|
If set to TRUE, then Lyris will allow messages with a blank body through to the mailing list (bool)
|
|
|
NoConfirm_
|
Do not send out a confirming message to new subscribers to make sure they used the same email address
(bool)
|
|
|
NonDeliverAfter_
|
If set, lyrActiveRecips records will be deleted if the duration in days since mailing was sent is more than the value (days) in "NonDeliverAfter_". (smallint, NULL)
|
Added in 12.3.8
|
|
NoEmail_
|
Reject all submissions by email. Submissions must be by web (bool)
|
|
|
NoEmailSub_
|
Disallow all subscriptions via email? (bool)
|
|
|
NoListHdr_
|
If true, the list-help headers are not included (bool)
|
|
|
NoMidRewr_
|
If set to TRUE, then Lyris will not rewrite the Message-ID, but instead leave it alone, and use X-Lyris-Message-ID
(bool)
|
|
|
NoNNTP_
|
Do not make this group available over NNTP (bool)
|
|
|
NoSearch
|
Messages on this mailing list should not be full text indexed, and will not be searchable (bool)
|
|
|
PasswdReqd_
|
When subscribing over the web, should 0=password is optional, 1=password is not asked for, 2=require password
(tinyint, NOT NULL)
|
|
|
PgmAfter_
|
Program to execute after a message has been posted to the list (Text, NULL)
|
|
|
PgmBefore_
|
Program to execute before a message is posted to the list (text, NULL)
|
|
|
PgmSub1_
|
Program to execute before a member is subscribed (text, NULL)
|
|
|
PgmSub2_
|
Program to execute after a member is subscribed (text, NULL)
|
|
|
PgmUnsub1_
|
Program to execute before a member is unsubscribed (text, NULL)
|
|
|
PgmUnsub2_
|
Program to execute after a member is unsubscribed (text, NULL)
|
|
|
PiperCompany_
|
Company name used for EmailAdvisor service (varchar(100), NULL)
|
Added in 8.8
|
|
PiperPassword_
|
Password used for EmailAdvisor service (varchar(50), NULL)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(25) or (varchar2(50) : Oracle only), NULL)
|
Added in 8.8
|
|
PostPass_
|
If set, then postings require the user password in the body of the text somewhere. 0=no requirements,
1=required if member has one, 2=all members need a password (tinyint, NOT NULL)
|
|
|
PrivApprov_
|
Search rules for auto-approving applications to a private list (Text, NULL)
|
|
|
PrivDays_
|
How many days after a member has applied to a private list, should he be deleted if not approved (smallint,
NOT NULL)
|
|
|
PrsrvXTags_
|
Should we preserve X-.... SMTP header tags (bool)
|
|
|
RecencyDayCount_
|
How many days to check for recent mailings (smallint, NOT NULL)
|
|
|
RecencyEmailEnabled_
|
Is recency checking enabled for this list? (char, NOT NULL)
|
|
|
RecencyMailCount_
|
How many mailings should trigger recency limits? (smallint, NOT NULL)
|
|
|
RecencyOperator_
|
When checking for recency, should the number of mailings be (m)ore than, (e)qual to or (l)ess than the
number in RecencyMailCount_? (char, NOT NULL)
|
|
|
RecencySequentialEnabled_
|
Apply recency limits to sequential mailings? (bool)
|
|
|
RecencyTriggeredEnabled_
|
Apply recency limits to triggered mailings? (bool)
|
|
|
RecencyWebEnabled_
|
Apply recency limits to posting created by admins in the web interface? (bool)
|
|
|
RecipientLoggingLevel_
|
What level of delivery logging should there be? (N)o logging, non-SMTP errors (m), all (e)rrors, errors
and successes (f). (char, NULL)
|
|
|
ReferralPurgeDays_
|
Purge referral data after how many days? (smallint, NOT NULL)
|
|
|
ReferralsPerDay_
|
The maximum number of people that a member can refer, per day. (smallint, NOT NULL)
|
|
|
RelHour_
|
The hour that this message should be automatically approved (tinyint, NOT NULL)
|
|
|
RelPending_
|
If a pending message hasn't been approved after X days, then send it anyway (tinyint, NOT NULL)
|
|
|
ReplyTo_
|
If filled in, this specifies the reply-to field of every message send on this list (varchar(100), NULL)
|
|
|
ReviewPerm_
|
What security permission to put on 'review' command? 0=only admins, 1=only members, 2=anyone (tinyint,
NOT NULL)
|
|
|
SMTPFrom_
|
If filled in, this specifies the SMTP from field of every message send on this list (varchar(100), NULL)
|
|
|
SMTPHdrs_
|
Text that should be included in the SMTP header of every message (text, NULL)
|
|
|
Security_
|
Is this list 'private' (admin approval) 'closed' (admin must add you) 'password' (you need the password)
'open' (varchar(8), NOT NULL)
|
|
|
SimpleSub_
|
Should this list not allow any of the fancy options, such as norepo/noack/password/etc? (bool)
|
|
|
SponsOrgID_
|
Organization that is sponsoring this list (link to document, type is organization) (int, NULL)
|
|
|
SubNotDays_
|
What days of the month should a subscriber/unsubscriber report be sent to the list admins? Choices are
daily, monthly, monday tuesday wednesday, thursday, friday, saturday, sunday, and modifiers appended to
this can be -nochart (do not include chart of activity) and -email (include email addresses) (text, NULL)
|
|
|
SubPasswd_
|
If this list is 'password' protected for new subscribers, what is the password? (varchar(50), NULL)
|
|
|
SyncConnID_
|
lyrDbConnections.ConnID to use when synchronizing this list. (int, NULL)
|
Added in 8.8
|
|
SyncDeleteMode_
|
What to do with members on list but not in remote DB. (N)o changes, mark (R)emoved. (char (1), default
'N')
|
Added in 8.8
|
|
SyncInsertMode_
|
What to do with members in remote DB and not on list. (Q)uiet, (R)egular (send hello), (C)onfirm, use
(E)xternal member type. (char (1), default 'Q')
|
Added in 8.8
|
|
SyncMaxMalformed_
|
How many malformed members to accept in remote DB. (int '10')
|
Added in 8.8
|
|
SyncNextTime_
|
Date/time of next synchronization. (datetime, NULL)
|
Added in 8.8
|
|
SyncPreviousSuccessTime_
|
Date/time of last synchronization success. (datetime, NULL)
|
Added in 8.8
|
|
SyncPreviousTime_
|
Date/time of previous synchronization attempt (may or may not have been successful) (datetime, NULL)
|
Added in 8.8
|
|
SyncSchedule_
|
How often to synchronize list compared to the scheduled task. (N)ever, (E)very time, (D)aily, (W)eekly.
(char (1), default 'N')
|
Added in 8.8
|
|
SyncTimeRule_
|
Time of day to synchronize list compared to the scheduled task. (A)nytime, (W)indow. (char (1), default
'A')
|
Added in 8.8
|
|
SyncUpdateMode_
|
What to do with members in remote DB and on list but with different status: (N)o changes, (E)xcept member
type, (A)ll including member type. (char (1), default 'N')
|
Added in 8.8
|
|
SyncWeekDay_
|
Day of week to perform synchronizations. 1=Sunday 7=Saturday (smallint '1')
|
Added in 8.8
|
|
SyncWindowStart_
|
Beginning of synchronization window in a given day. (small datetime, '2000-01- 0:00')
|
Added in 8.8
|
|
SyncWindowEnd_
|
Ending of synchronization window in a given day. (small datetime, '2000-01- 0:00')
|
Added in 8.8
|
|
TclMergeInit
|
The list level Tcl initialization string. (text, NULL)
|
Added in 8.5
|
|
To_
|
If filled in, this specifies the To: field of every message send on this list (varchar(200), NULL)
|
|
|
Topic_
|
Topic that this list belongs to (varchar(50), NOT NULL)
|
|
|
TrackAllURLs_
|
Should all URLs in content be automatically made into tracking URLs when the content is saved (bool, 'F')
|
Added in 8.5
|
|
TranslateLangID_
|
The default translation language for this site. Applies to default list documents if translated versions
exist and to the web interface (smallint, NOT NULL)
|
|
|
URLList_
|
URL to list's homepage (varchar(100), NULL)
|
|
|
URLLogo_
|
URL to GIF/JPEG list logo (varchar(200), NULL)
|
|
|
VisibGlobl_
|
Visible via 'list global'? (bool)
|
|
|
Visitors_
|
Allow non-members to visit the list Web site without joining (they cannot contribute) (bool)
|
|
|
WarnNoRecips_
|
Whether to send a warning to sender if list posting goes to no recipients (bool, âTâ is default)
|
8.95
|
|
WATracking_
|
If set, Web Analytics Tracking is enabled for the list. T = True, F = False. (char (1), NOT NULL, default='F')
|
Added in 11.0
|