mysql> select * from logins where name = 'kra3zy1';
+---------+----------------+------+-------+---------------------+
| name    | ip             | paid | allow | lastOnline          |
+---------+----------------+------+-------+---------------------+
| kra3zy1 | 68.66.102.54   | true | NULL  | 2012-09-15 15:12:06 |
| kra3zy1 | 65.183.108.102 | true | NULL  | 2012-09-16 16:03:19 |
+---------+----------------+------+-------+---------------------+
2 rows in set (0.00 sec)

mysql> select * from logins where name = 'Vaynord';
+---------+----------------+------+-------+---------------------+
| name    | ip             | paid | allow | lastOnline          |
+---------+----------------+------+-------+---------------------+
| Vaynord | 68.66.102.54   | true | NULL  | 2012-09-15 19:54:47 |
| Vaynord | 65.183.108.102 | true | NULL  | 2012-09-16 16:01:54 |
+---------+----------------+------+-------+---------------------+
2 rows in set (0.00 sec)

the faction table is what stores the names of the groups you make in citadel:
mysql> select * from faction where founder = 'Vaynord';
+---------+---------+----------+
| name    | founder | password |
+---------+---------+----------+
| Vaynord | Vaynord | NULL     |
| kraezy  | Vaynord | NULL     |
+---------+---------+----------+
2 rows in set (0.00 sec)