diff options
author | runningnak3d <runningnak3d@gmail.com> | 2011-02-02 07:50:21 -0700 |
---|---|---|
committer | runningnak3d <runningnak3d@gmail.com> | 2011-02-02 07:50:21 -0700 |
commit | 0a5d8711e5294c36d40b779187e1718d3365f5fa (patch) | |
tree | 66886f94d35e874a6c02c18f8e4c0b6fd702aa10 /sql/old/2.4.3/00541_characters.sql | |
parent | 704e0af9c4e656e8aae5f163fce8cced14a39112 (diff) |
Misc: Restructuring directory layout to accomodate the fact that we will
be pushing DB content. We will no longer have a seperate DB repo.
Diffstat (limited to 'sql/old/2.4.3/00541_characters.sql')
-rw-r--r-- | sql/old/2.4.3/00541_characters.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/old/2.4.3/00541_characters.sql b/sql/old/2.4.3/00541_characters.sql new file mode 100644 index 00000000000..2651c069e05 --- /dev/null +++ b/sql/old/2.4.3/00541_characters.sql @@ -0,0 +1,8 @@ +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`; |