system_variables

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
errorEmail VARCHAR 128 √ NULL
ticketEmail VARCHAR 128 √ NULL
searchErrorEmail VARCHAR 128 √ NULL
loadCoversFrom020z BOOLEAN 3 √ 0
runNightlyFullIndex BOOLEAN 3 √ 0
currencyCode CHAR 3 √ 'USD'
allowableHtmlTags VARCHAR 512 √ 'p|div|span|a|b|em|strong|i|ul|ol|li|br|h1|h2|h3|h4|h5|h6'
allowHtmlInMarkdownFields BOOLEAN 3 √ 1
useHtmlEditorRatherThanMarkdown BOOLEAN 3 √ 1
storeRecordDetailsInSolr BOOLEAN 3 √ 0
storeRecordDetailsInDatabase BOOLEAN 3 √ 1
greenhouseUrl VARCHAR 128 √ NULL
libraryToUseForPayments BOOLEAN 3 √ 0
solrConnectTimeout INT 10 √ 2
solrQueryTimeout INT 10 √ 10
catalogStatus BOOLEAN 3 √ 0
offlineMessage TEXT 65535 √ NULL
indexVersion INT 10 √ 2
searchVersion INT 10 √ 1
regroupAllRecordsDuringNightlyIndex TINYINT 3 √ 0
processEmptyGroupedWorks TINYINT 3 √ 1
appScheme VARCHAR 72 √ 'aspen-lida'
googleBucket VARCHAR 128 √ NULL
trackIpAddresses BOOLEAN 3 √ 0
communityContentUrl VARCHAR 128 √ ''
allowScheduledUpdates BOOLEAN 3 √ 1
doQuickUpdates BOOLEAN 3 √ 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships