Files
TrinityCore/sql/old/2.4.3/00541_characters.sql
runningnak3d 0a5d8711e5 Misc: Restructuring directory layout to accomodate the fact that we will
be pushing DB content. We will no longer have a seperate DB repo.
2011-02-02 07:50:21 -07:00

9 lines
509 B
SQL

DROP TABLE IF EXISTS `saved_variables`;
CREATE TABLE `saved_variables` (
`NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
ALTER TABLE `arena_team_member` DROP COLUMN `points_to_add`;
ALTER TABLE `arena_team_member` ADD COLUMN `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`;