Something

-- ---------------------------
-- Table structure for clan_data
-- ---------------------------
CREATE TABLE clan_data (
  clan_id INT NOT NULL default 0,
  clan_name varchar(45) ,
  clan_level INT,
  hasCastle INT,
  hasHideout INT,
  ally_id INT,
  ally_name varchar(45) ,
  leader_id INT,
  crest_id INT,
  ally_crest_id INT,
  PRIMARY KEY  (clan_id),
  KEY `leader_id` (`leader_id`),
  KEY `ally_id` (`ally_id`)
);