diff options
| author | Adam <Adam@anope.org> | 2011-01-07 15:57:13 -0500 |
|---|---|---|
| committer | Adam <Adam@anope.org> | 2011-01-07 15:57:13 -0500 |
| commit | 44038491264a350a8849e1d7e8547bbdec134d74 (patch) | |
| tree | 08b3b18d0ff4a4d814e638a882916c07882e16de /data | |
| parent | 9efebe5461fd5985190380d11fd8c3c7a5fba9d6 (diff) | |
Added db_mysql_live which allows Anope to pull data
from the four main SQL tables in realtime, which
effectively gives us "live" SQL.
Changed eventfd pipe engine to not use buffered write.
Added TryLock to threading engines.
Made blocking SQL queries in our SQL API thread-safe.
Diffstat (limited to 'data')
| -rw-r--r-- | data/example.conf | 11 | ||||
| -rw-r--r-- | data/mysql/tables.sql | 2 |
2 files changed, 12 insertions, 1 deletions
diff --git a/data/example.conf b/data/example.conf index 174a0f8a8..561504cb8 100644 --- a/data/example.conf +++ b/data/example.conf @@ -275,6 +275,17 @@ options * Supported: * - db_plain * - db_mysql + * - db_mysql_live + * + * The db_mysql_live module is an extension to db_mysql, and should only be used if + * db_mysql is being used. This module pulls data in real time from SQL as it is + * requested by the core as a result of someone executing commands. This effectively + * allows you to edit your database and have it be immediatly refelected back on Anope. + * It is highly recommended you only use this module if your databases is located + * locally as this module will generate many queries per command. + * db_mysql_live only uses threads for commands and non-blocking queries, so it is safe to + * use on large networks without worrying about response time. + * */ database = "db_plain" diff --git a/data/mysql/tables.sql b/data/mysql/tables.sql index d0f16b0d5..2cda6384e 100644 --- a/data/mysql/tables.sql +++ b/data/mysql/tables.sql @@ -270,7 +270,7 @@ CREATE TABLE IF NOT EXISTS `anope_ns_core` ( `email` text NOT NULL, `greet` text NOT NULL, `flags` text NOT NULL, - `language` smallint(5) unsigned NOT NULL DEFAULT '0', + `language` varchar(5) NOT NULL DEFAULT '', `channelcount` smallint(5) unsigned NOT NULL DEFAULT '0', `memomax` smallint(5) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`display`) |