21 lines
771 B
SQL
21 lines
771 B
SQL
CREATE TABLE IF NOT EXISTS `clan_data` (
|
|
`clan_id` INT NOT NULL default 0,
|
|
`clan_name` varchar(45) ,
|
|
`clan_level` INT,
|
|
`reputation_score` INT NOT NULL default 0,
|
|
`hasCastle` INT,
|
|
`ally_id` INT,
|
|
`ally_name` varchar(45),
|
|
`leader_id` INT,
|
|
`crest_id` INT,
|
|
`crest_large_id` INT,
|
|
`ally_crest_id` INT,
|
|
`auction_bid_at` INT NOT NULL default 0,
|
|
`ally_penalty_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
|
|
`ally_penalty_type` DECIMAL( 1 ) NOT NULL DEFAULT 0,
|
|
`char_penalty_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
|
|
`dissolving_expiry_time` bigint(13) unsigned NOT NULL DEFAULT '0',
|
|
PRIMARY KEY (`clan_id`),
|
|
KEY `leader_id` (`leader_id`),
|
|
KEY `ally_id` (`ally_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |