lyrDbConnections
This table is used by ListManager for ODBC connections.
Primary Key: ConnID
|
Field Name |
Description |
Version Added |
|
ConnID |
An auto-numbering field to provide a unique ID for this row. (int, NOT NULL) |
Added in 8.8 |
|
ConnName |
User-specified name of connection for display. (varchar(50), NOT NULL) |
Added in 8.8 |
|
ConnStr |
ODBC connection string (format is specific to driver being used) (varchar(1024), NOT NULL) |
Added in 8.8 |
|
Site |
What list or sites is this connection associated with. Association formatted like document association ("list: listname", "site: sitename", "all"). (varchar(66), NOT NULL) |
Added in 8.8 |
|
SelectQuery |
ODBC 'select' query. (text, NULL) |
Added in 8.8 |