Difference between revisions of "2.0/Mysql:Scheme"

From AnopeWiki
Jump to: navigation, search
(ChanAccess)
Line 54: Line 54:
 
:{| class="modules sortable"
 
:{| class="modules sortable"
 
! Column || Description
 
! Column || Description
 +
|-
 +
|id || Internal ID for the channel Access entry
 +
|-
 +
|timestamp || Date and time it was created
 +
|-
 +
|ci || Channel Name
 +
|-
 +
|created || Unix Datetime for creation of entry
 +
|-
 +
|creator || Who added the entry
 +
|-
 +
|data || Access level, flag(s), and/or xOP level
 +
|-
 +
|last_seen || Last time the user was seen joining the channel
 +
|-
 +
|mask || Hostmask for this entry
 +
|-
 +
|provider || Type of Access list entry
 
|-
 
|-
 
|}
 
|}

Revision as of 21:56, 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

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
id Internal ID for the channel Access entry
timestamp Date and time it was created
ci Channel Name
created Unix Datetime for creation of entry
creator Who added the entry
data Access level, flag(s), and/or xOP level
last_seen Last time the user was seen joining the channel
mask Hostmask for this entry
provider Type of Access list entry

ChannelInfo

Column Description

Exception

Column Description

ForbidData

Column Description

Memo

Column Description

NewsItem

Column Description

NickAlias

Column Description

NickCore

Column Description

Stats

Column Description