12345678910111213141516171819 |
- -- ---------------------------
- -- Table structure for clan_data
- -- ---------------------------
- CREATE TABLE IF NOT EXISTS 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,
- crest_large_id INT,
- ally_crest_id INT,
- PRIMARY KEY (clan_id),
- KEY `leader_id` (`leader_id`),
- KEY `ally_id` (`ally_id`)
- );
|