mysql> describe clan_data;
+------------+-------------+------+-----+---------+-------+
| Field      | Type        | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| clan_id    | int(11)     |      | PRI | 0       |       |
| clan_name  | varchar(45) |      |     |         |       |
| clan_level | int(1)      |      |     | 0       |       |
| hasCastle  | int(1)      |      |     | 0       |       |
| hasHideout | int(1)      |      |     | 0       |       |
| ally_id    | int(9)      |      |     | 0       |       |
| ally_name  | varchar(45) |      |     |         |       |
| leader_id  | int(16)     | YES  |     | NULL    |       |
+------------+-------------+------+-----+---------+-------+
8 rows in set (0.00 sec)