2.0/Mysql:Scheme

• Work in progress

• NOTE: These tables are usually prefixed by the prefix= entry in the services.conf configuration file.

Example: anope_db_AutoKick

These tables are auto-created when you use m_sql and/or m_sql_live. Do not alter their formats unless you really know what you are doing. Changes could result in data corruption or preventing services from accessing the data.

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	How many repeated lines before kicking.
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.

EntryMsg

Column	Description
id	Internal ID number of entry
timestamp	Date and Time entry was last updated or created
ci	Channel name
creator	who set it
message	Entry message to display to users
when	When was it last updated or created, unixtime format.

Exception

Column	Description
id	internal ID number for this entry
timestamp	Date and time entry was last updated or created
expires	Expires after how long
limit	How many connections are allowed as the exception
mask	hostmask to allow
reason	Why they were allowed the exception
time	Unixtime format for the last time the record was updated, or created.
who	who set the exception

ForbidData

Column	Description
id	Internal ID number of the entry
timestamp	Date and Time entry was last updated or created
created	Unixtime format of date/time when it was created.
creator	Who created the entry
expires	when to expire
mask	What to forbid
reason	Why banned
type	mask type (1: nick, 2: channel, 3: email, etc)

Memo

Column	Description
id	Internal ID number
timestamp	Date and time entry was last modified or created
owner	Recipient of the memo
receipt	Should a read receipt be sent flag
sender	Who sent the memo
text	The text of the memo
time	Unixtime format, of last time the memo was created, accessed, or modified
unread	Read status of the memo

NewsItem

Column	Description
id	Internal ID number of the entry
timestamp	Date and time that this entry was created, or updated
text	News item text to be displayed
time	Unixtime format of the creation date of this entry
type	News item type LogonNews, OperNews, RandomNews
who	Who submitted the news item

NickAlias

Column	Description

NickCore

Column	Description

Stats

Column	Description