First I log my account:
/nick alex
/msg nickserv identifiy password123
[Feb 10 15:35:40.786281 2014] Debug: Received: :186 PING 186 00A
[Feb 10 15:35:40.786600 2014] Debug: Sent: :00A PONG 00A 186
[Feb 10 15:35:55.001743 2014] Debug: Received: :186AAAAAG PRIVMSG 00AAAAAAF :identify 123
[Feb 10 15:35:55.166223 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.169367 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.169885 2014] Debug: m_sql_authentication: Checking authentication for alex
[Feb 10 15:35:55.172571 2014] Debug: m_sql_authentication: Successful authentication for alex
[Feb 10 15:35:55.175407 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:35:55.176203 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Your account alex has been successfully created.
[Feb 10 15:35:55.176473 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Your email has been updated to alex@example.net.
[Feb 10 15:35:55.176778 2014] COMMAND: alex!ping@192.168.0.1 used IDENTIFY and identified for account alex
[Feb 10 15:35:55.177023 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Password accepted - you are now recognized.
[Feb 10 15:35:55.177273 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :alex
[Feb 10 15:35:55.177735 2014] USERS: alex!ping@192.168.0.1 is now identified as alex
[Feb 10 15:35:55.186025 2014] Debug: SQL-live got 0 rows for INSERT INTO `anope_db_NickCore` (`id`,`AUTOOP`,`HIDE_EMAIL`,`HIDE_MASK`,`KILLPROTECT`,`KILL_QUICK`,`MEMO_RECEIVE`,`MEMO_SIGNON`,`NS_PRIVATE`,`NS_SECURE`,`access`,`display`,`email`,`greet`,`language`,`memomax`,`pass`) VALUES (0,'1','1','1','1','1','','','1','1','ping@192.* ','alex','alex@example.net','','','0','') ON DUPLICATE KEY UPDATE `AUTOOP`=VALUES(`AUTOOP`),`HIDE_EMAIL`=VALUES(`HIDE_EMAIL`),`HIDE_MASK`=VALUES(`HIDE_MASK`),`KILLPROTECT`=VALUES(`KILLPROTECT`),`KILL_QUICK`=VALUES(`KILL_QUICK`),`MEMO_RECEIVE`=VALUES(`MEMO_RECEIVE`),`MEMO_SIGNON`=VALUES(`MEMO_SIGNON`),`NS_PRIVATE`=VALUES(`NS_PRIVATE`),`NS_SECURE`=VALUES(`NS_SECURE`),`access`=VALUES(`access`),`display`=VALUES(`display`),`email`=VALUES(`email`),`greet`=VALUES(`greet`),`language`=VALUES(`language`),`memomax`=VALUES(`memomax`),`pass`=VALUES(`pass`)
[Feb 10 15:35:55.192399 2014] Debug: SQL-live got 0 rows for INSERT INTO `anope_db_NickAlias` (`id`,`last_quit`,`last_realhost`,`last_realname`,`last_seen`,`last_usermask`,`nc`,`nick`,`time_registered`) VALUES (0,'','ping@192.168.0.1','ping','1392046555','ping@192.168.0.1','alex','alex','1392046555') ON DUPLICATE KEY UPDATE `last_quit`=VALUES(`last_quit`),`last_realhost`=VALUES(`last_realhost`),`last_realname`=VALUES(`last_realname`),`last_seen`=VALUES(`last_seen`),`last_usermask`=VALUES(`last_usermask`),`nc`=VALUES(`nc`),`nick`=VALUES(`nick`),`time_registered`=VALUES(`time_registered`)
[Feb 10 15:35:55.192833 2014] Debug: Sent: :00AAAAAAF MODE 186AAAAAG +r
Anope insert user alex into table anope_db_NickAlias and anope_db_NickCore
Then I do
/msg nickserv info alex
or /msg nickserv info other_user
And anope remove alex.
[Feb 10 15:38:11.827180 2014] Debug: Received: :186AAAAAG PRIVMSG 00AAAAAAF :info alex
[Feb 10 15:38:11.832811 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_BotInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.835874 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickCore` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.838563 2014] Debug: SQL-live got 0 rows for SELECT * FROM `anope_db_ChannelInfo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.838901 2014] Debug: Deleting nickname group alex
[Feb 10 15:38:11.839106 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 15:38:11.839273 2014] USERS: alex!ping@192.168.0.1 is no longer identified as alex
[Feb 10 15:38:11.842081 2014] Debug: SQL-live got error Table 'apichatea.anope_db_Memo' doesn't exist for SELECT * FROM `anope_db_Memo` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.848970 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `id` = 7
[Feb 10 15:38:11.852243 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickCore` WHERE `timestamp` IS NULL
[Feb 10 15:38:11.854782 2014] Debug: SQL-live got error Table 'apichatea.anope_db_ForbidData' doesn't exist for SELECT * FROM `anope_db_ForbidData` WHERE (`timestamp` > FROM_UNIXTIME(1392046468) OR `timestamp` IS NULL)
[Feb 10 15:38:11.859524 2014] Debug: SQL-live got 1 rows for SELECT * FROM `anope_db_NickAlias` WHERE (`timestamp` > FROM_UNIXTIME(1392046555) OR `timestamp` IS NULL)
[Feb 10 15:38:11.860225 2014] Debug: Sent: :00A METADATA 186AAAAAG accountname :
[Feb 10 15:38:11.867239 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `id` = 7
[Feb 10 15:38:11.870260 2014] Debug: SQL-live got 0 rows for DELETE FROM `anope_db_NickAlias` WHERE `timestamp` IS NULL
[Feb 10 15:38:11.870738 2014] Debug: Sent: :00AAAAAAF NOTICE 186AAAAAG :Nick alex isn't registered.
[Feb 10 15:38:11.871473 2014] Debug: Sent: :00AAAAAAF MODE 186AAAAAG -r