diff options
Diffstat (limited to 'docs/SQLite.md')
| -rw-r--r-- | docs/SQLite.md | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/docs/SQLite.md b/docs/SQLite.md index c23a88ef0..be25bbb27 100644 --- a/docs/SQLite.md +++ b/docs/SQLite.md @@ -1,6 +1,6 @@ # How to modify Anope sqlite databases -Anope uses a custom SQLiite function (anope_canonicalize) for canonicalizing strings for case insensitive comparisons. +Anope uses a custom SQLite function (anope_canonicalize) for canonicalizing strings for case insensitive comparisons. It does this by using SQLites support for having indexes on expressions https://www.sqlite.org/expridx.html. For example the account table could look like: @@ -30,3 +30,14 @@ or libanope_sqlite_rfc1459.so into SQLite, depending on your casemap configurati ``` sqlite> .load lib/libanope_sqlite_ascii.so ``` + +## Example of adding a new operator via SQLite + +``` +BEGIN TRANSACTION; +-- Allocate new ID and insert into objects table +INSERT INTO anope_db_objects (id, type) SELECT MAX(id + 1), 'oper' FROM anope_db_objects; +-- Insert new operator using previously allocated id +INSERT INTO anope_db_oper (name, type, require_oper, id) VALUES ('Adam', 'Services Root', 1, last_insert_rowid()); +COMMIT; +``` |