clan_skills.sql 350 B

12345678
  1. CREATE TABLE IF NOT EXISTS `clan_skills` (
  2. `clan_id` int(11) NOT NULL DEFAULT 0,
  3. `skill_id` int(11) NOT NULL DEFAULT 0,
  4. `skill_level` int(5) NOT NULL DEFAULT 0,
  5. `skill_name` varchar(26) DEFAULT NULL,
  6. `sub_pledge_id` INT NOT NULL DEFAULT '-2',
  7. PRIMARY KEY (`clan_id`,`skill_id`,`sub_pledge_id`)
  8. ) ENGINE=InnoDB DEFAULT CHARSET=utf8;