l2j-server-datapack/sql/clan_data.sql

-- ---------------------------
-- 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,
  `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` DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
  `ally_penalty_type` DECIMAL( 1 ) NOT NULL DEFAULT 0,
  `char_penalty_expiry_time` DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
  `dissolving_expiry_time` DECIMAL( 20,0 ) NOT NULL DEFAULT 0,
  PRIMARY KEY (`clan_id`),
  KEY `leader_id` (`leader_id`),
  KEY `ally_id` (`ally_id`)
);