root/branches/1.9/sql/au_server_gs.sql

24032411
430
  `mp` INT(11) NOT NULL DEFAULT 1 ,
430
  `mp` INT(11) NOT NULL DEFAULT 1 ,
431
  `fp` INT(11) NOT NULL DEFAULT 1 ,
431
  `fp` INT(11) NOT NULL DEFAULT 1 ,
432
  PRIMARY KEY (`player_id`) )
432
  PRIMARY KEY (`player_id`) )
433
ENGINE = MyISAM DEFAULT CHARSET=UTF8;
433
ENGINE = MyISAM DEFAULT CHARSET=UTF8;
434
435
436
-- ----------------------------
437
-- `siege_locations`
438
-- ----------------------------
439
440
CREATE TABLE IF NOT EXISTS `siege_locations` (
441
  `id` int(11) NOT NULL,
442
  `race` enum('ELYOS', 'ASMODIANS', 'BALAUR') NOT NULL,
443
  `legion_id` int (11) NOT NULL,
444
  PRIMARY KEY(`id`)
445
) ENGINE=InnoDB DEFAULT CHARSET=utf8;