Difference between revisions of "2.0/Mysql:Scheme"
From AnopeWiki
| Line 29: | Line 29: | ||
|} | |} | ||
| − | == BotInfo == | + | == <div class="moduleheader">BotInfo</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| + | |- | ||
| + | |id || Botinformation ID Number | ||
| + | |- | ||
| + | |timestamp || Human readable date and time that the bot was created | ||
| + | |- | ||
| + | |created || Unix Timestamp for the date and time that the bot was created | ||
| + | |- | ||
| + | |host || Hostname defined for the bot | ||
| + | |- | ||
| + | |nick || IRC Nick for the bot. | ||
| + | |- | ||
| + | |oper_only || Flag to determine of the bot is for ircop access only | ||
| + | |- | ||
| + | |realname || Real-name field for /whois information | ||
| + | |- | ||
| + | |user || Ident/Username field for /whois information | ||
|- | |- | ||
|} | |} | ||
| − | == ChanAccess == | + | == <div class="moduleheader">ChanAccess</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 41: | Line 57: | ||
|} | |} | ||
| − | == ChannelInfo == | + | == <div class="moduleheader">ChannelInfo</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 47: | Line 63: | ||
|} | |} | ||
| − | == Exception == | + | == <div class="moduleheader">Exception</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 53: | Line 69: | ||
|} | |} | ||
| − | == ForbidData == | + | == <div class="moduleheader">ForbidData</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 59: | Line 75: | ||
|} | |} | ||
| − | == Memo == | + | == <div class="moduleheader">Memo</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 65: | Line 81: | ||
|} | |} | ||
| − | == NewsItem == | + | == <div class="moduleheader">NewsItem</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 71: | Line 87: | ||
|} | |} | ||
| − | == NickAlias == | + | == <div class="moduleheader">NickAlias</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 77: | Line 93: | ||
|} | |} | ||
| − | == NickCore == | + | == <div class="moduleheader">NickCore</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
| Line 83: | Line 99: | ||
|} | |} | ||
| − | == Stats == | + | == <div class="moduleheader">Stats</div> == |
:{| class="modules sortable" | :{| class="modules sortable" | ||
! Column || Description | ! Column || Description | ||
|- | |- | ||
|} | |} | ||
Revision as of 21:49, 27 May 2014
- Work in progress
- NOTE: These tables are usually prefixed by the prefix= entry in the services.conf configuration file.
- Example: anope_db_AutoKick
Contents
AutoKick
- Channel AutoKick List
Column Description id Entry ID number timestamp Date and time akick was set addtime UnixTime akick was added ci Channel name creator Who set the akick last_used Unixtime of when last kick was done mask hostmask to auto kick reason Reason for kick
BotInfo
Column Description id Botinformation ID Number timestamp Human readable date and time that the bot was created created Unix Timestamp for the date and time that the bot was created host Hostname defined for the bot nick IRC Nick for the bot. oper_only Flag to determine of the bot is for ircop access only realname Real-name field for /whois information user Ident/Username field for /whois information
ChanAccess
Column Description
ChannelInfo
Column Description
Exception
Column Description
ForbidData
Column Description
Memo
Column Description
NewsItem
Column Description
NickAlias
Column Description
NickCore
Column Description
Stats
Column Description
