mysql> use arkeos;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+------------------+
| Tables_in_arkeos |
+------------------+
| attackers        |
| bruteforcers     |
+------------------+
2 rows in set (0.00 sec)

mysql> describe attackers;
+------------------+--------------+------+-----+---------+-------+
| Field            | Type         | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| hostname         | varchar(100) | NO   |     | NULL    |       |
| extension_used   | varchar(100) | NO   |     | NULL    |       |
| attacker_address | varchar(150) | NO   |     | NULL    |       |
| user_agent       | varchar(100) | NO   |     | NULL    |       |
| channel_used     | varchar(100) | NO   |     | NULL    |       |
| start_date       | date         | NO   |     | NULL    |       |
| start_time       | time         | NO   |     | NULL    |       |
+------------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

mysql> describe bruteforcers;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| hostid     | varchar(44)  | NO   |     | NULL    |       |
| start_date | date         | NO   |     | NULL    |       |
| start_time | time         | NO   |     | NULL    |       |
| stop_date  | date         | NO   |     | NULL    |       |
| stop_time  | time         | NO   |     | NULL    |       |
| attacker   | varchar(150) | NO   |     | NULL    |       |
| attempts   | varchar(150) | NO   |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
7 rows in set (0.00 sec)

mysql> select * from attackers ;
+----------+----------------+------------------+----------------+--------------+------------+------------+
| hostname | extension_used | attacker_address | user_agent     | channel_used | start_date | start_time |
+----------+----------------+------------------+----------------+--------------+------------+------------+
| managed  | 100            | 10.4.64.109      | snom360/7.3.14 | 100          | 2010-07-28 | 15:05:42   |
| managed  | 100            | 10.4.64.109      | snom360/7.3.14 | 100          | 2010-07-28 | 15:08:22   |
| managed  | 100            | 10.4.64.109      | snom360/7.3.14 | 100          | 2010-07-28 | 15:10:00   |
+----------+----------------+------------------+----------------+--------------+------------+------------+
3 rows in set (0.00 sec)

mysql> select * from bruteforcers ;
+------------------------------------------+------------+------------+------------+-----------+----------------+----------+
| hostid                                   | start_date | start_time | stop_date  | stop_time | attacker       | attempts |
+------------------------------------------+------------+------------+------------+-----------+----------------+----------+
| e3d8862a1f1457b8722646dbec79d0f4b7e1b2ab | 2010-07-17 | 20:26:08   | 2010-07-17 | 20:44:26  | 220.241.37.123 | 35787    |
+------------------------------------------+------------+------------+------------+-----------+----------------+----------+
1 row in set (0.00 sec)