Difference between revisions of "2.0/Mysql:Scheme"
From AnopeWiki
(→ChannelInfo) |
(→ChannelInfo) |
||
| Line 91: | Line 91: | ||
|KEEPTOPIC || Flag to determine if Chanserv should reset the topic when someone tries to change it | |KEEPTOPIC || Flag to determine if Chanserv should reset the topic when someone tries to change it | ||
|- | |- | ||
| − | |PEACE || | + | |PEACE || Peave Flag. When peace is set, a user won't be able to kick, ban or remove a channel status of a user that has a level superior or equal to his via ChanServ commands. |
|- | |- | ||
| − | |SECUREFOUNDER || | + | |SECUREFOUNDER || SecureFounder flag. When secure founder is set, only the real founder will be able to drop the channel, change its founder and its successor. |
|- | |- | ||
| − | |SIGNKICK || Should the person who does a chanserv kick have their nick appended | + | |SIGNKICK || Signed Kick flag. Should the person who does a chanserv kick have their nick appended |
|- | |- | ||
| − | |TOPICLOCK || | + | |TOPICLOCK || Topiclock Flag. When topiclock is set, the channel topic will be unchangeable except via the chanserv topic command |
|- | |- | ||
| − | |banexpire || | + | |banexpire || Bans should auto expire after this time |
|- | |- | ||
| − | |bantype || | + | |bantype || Sets the ban type that will be used by services whenever they need to ban someone from your channel. See Chanserv's SET BANTYPE for details. |
|- | |- | ||
| − | |capsmin || | + | |capsmin || Minimum number of caps, before check for a ban |
|- | |- | ||
| − | |capspercent || | + | |capspercent || Persentage of caps in a line to ban on. |
|- | |- | ||
|description || Channel description | |description || Channel description | ||
|- | |- | ||
| − | |floodline || | + | |floodline || Number of lines to ban for flooding |
|- | |- | ||
| − | |floodsecs || | + | |floodsecs || Number of seconds to check number of lines for banning |
|- | |- | ||
|founder || Channel owner | |founder || Channel owner | ||
|- | |- | ||
| − | |kickerdata:amsgs || | + | |kickerdata:amsgs || Statistics, how many akicks. |
|- | |- | ||
| − | |kickerdata:badwords || | + | |kickerdata:badwords || Statistics, how many badword kicks |
|- | |- | ||
| − | |kickerdata:bolds || | + | |kickerdata:bolds || Statistics, how many bold kicks |
|- | |- | ||
| − | |kickerdata:caps || | + | |kickerdata:caps || Statistics, how many caps kicks |
|- | |- | ||
| − | |kickerdata:colors || | + | |kickerdata:colors || Statistics, how many color kicks |
|- | |- | ||
| − | |kickerdata:flood || | + | |kickerdata:flood || Statistics, how many flood kicks |
|- | |- | ||
| − | |kickerdata:italics || | + | |kickerdata:italics || Statistics, how many italic kicks |
|- | |- | ||
| − | |kickerdata:repeat || | + | |kickerdata:repeat || Statistics, how many repeated lines kicks |
|- | |- | ||
| − | |kickerdata:reverses || | + | |kickerdata:reverses || Statistics, how many reverse text kicks |
|- | |- | ||
| − | |kickerdata:underlines || | + | |kickerdata:underlines || Statistics, how many underline text kicks |
|- | |- | ||
| − | |last_topic || | + | |last_topic || The topic currently set by Chanserv |
|- | |- | ||
|last_topic_setter || Person who set the last topic | |last_topic_setter || Person who set the last topic | ||
| Line 143: | Line 143: | ||
|last_used || Last time someone on the access list joined the channel | |last_used || Last time someone on the access list joined the channel | ||
|- | |- | ||
| − | |levels || | + | |levels || Access levels for channel. See Chanserv's LEVELS command for details. |
|- | |- | ||
|memomax || Maximum number of channel memos. | |memomax || Maximum number of channel memos. | ||
| Line 153: | Line 153: | ||
|time_registered || Unixtime data and time channel was registered. | |time_registered || Unixtime data and time channel was registered. | ||
|- | |- | ||
| − | |ttb || Time to ban | + | |ttb || Time to ban |
|- | |- | ||
| − | |CS_PRIVATE || | + | |CS_PRIVATE || Private flag. When private is set, the channel will not appear in ChanServ's LIST command |
|- | |- | ||
| − | |CS_NO_EXPIRE || Should the channel expire be ignored if the cahnnel sits unused for longer than the expire time of channels. | + | |CS_NO_EXPIRE || No Expire flag. Should the channel expire be ignored if the cahnnel sits unused for longer than the expire time of channels. |
|- | |- | ||
| − | |SECUREOPS || | + | |SECUREOPS || SecureOps Flag. When secure ops is set, users who are not on the userlist will not be allowed chanop status |
|- | |- | ||
| − | |bi || | + | |bi || Assigned Bot nick, if any. |
|- | |- | ||
|successor || Successor for channel ownership if the current channel's founder's nick expires. | |successor || Successor for channel ownership if the current channel's founder's nick expires. | ||
Revision as of 22:42, 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 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 id Internal ID number for this entry timestamp Date and time this entry was created or last updated BS_FANTASY Is BotServ's Fantasy commands enabled flag BS_GREET Is Botserv's channel Greeting enabled flag CS_SECURE Is Chanserv's secure channel flag enabled KEEPTOPIC Flag to determine if Chanserv should reset the topic when someone tries to change it PEACE Peave Flag. When peace is set, a user won't be able to kick, ban or remove a channel status of a user that has a level superior or equal to his via ChanServ commands. SECUREFOUNDER SecureFounder flag. When secure founder is set, only the real founder will be able to drop the channel, change its founder and its successor. SIGNKICK Signed Kick flag. Should the person who does a chanserv kick have their nick appended TOPICLOCK Topiclock Flag. When topiclock is set, the channel topic will be unchangeable except via the chanserv topic command banexpire Bans should auto expire after this time bantype Sets the ban type that will be used by services whenever they need to ban someone from your channel. See Chanserv's SET BANTYPE for details. capsmin Minimum number of caps, before check for a ban capspercent Persentage of caps in a line to ban on. description Channel description floodline Number of lines to ban for flooding floodsecs Number of seconds to check number of lines for banning founder Channel owner kickerdata:amsgs Statistics, how many akicks. kickerdata:badwords Statistics, how many badword kicks kickerdata:bolds Statistics, how many bold kicks kickerdata:caps Statistics, how many caps kicks kickerdata:colors Statistics, how many color kicks kickerdata:flood Statistics, how many flood kicks kickerdata:italics Statistics, how many italic kicks kickerdata:repeat Statistics, how many repeated lines kicks kickerdata:reverses Statistics, how many reverse text kicks kickerdata:underlines Statistics, how many underline text kicks last_topic The topic currently set by Chanserv last_topic_setter Person who set the last topic last_topic_time Unixtime date and time topic was last reset last_used Last time someone on the access list joined the channel levels Access levels for channel. See Chanserv's LEVELS command for details. memomax Maximum number of channel memos. name Channel name repeattimes time_registered Unixtime data and time channel was registered. ttb Time to ban CS_PRIVATE Private flag. When private is set, the channel will not appear in ChanServ's LIST command CS_NO_EXPIRE No Expire flag. Should the channel expire be ignored if the cahnnel sits unused for longer than the expire time of channels. SECUREOPS SecureOps Flag. When secure ops is set, users who are not on the userlist will not be allowed chanop status bi Assigned Bot nick, if any. successor Successor for channel ownership if the current channel's founder's nick expires.
Exception
Column Description
ForbidData
Column Description
Memo
Column Description
NewsItem
Column Description
NickAlias
Column Description
NickCore
Column Description
Stats
Column Description
