root/trunk/AE-go_GameServer/sql/au_server_gs.sql

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