aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorw12x <none@none>2008-10-05 09:44:08 -0500
committerw12x <none@none>2008-10-05 09:44:08 -0500
commit4a16ae4fd6939bc1233f5c1590956d00963db255 (patch)
tree334a199e8668d529bd635de163108a584009b8ee /sql/updates
parent6f0c3469a63c97eef57f36f1a39fed0b281b7cc9 (diff)
[svn] - add sql updates for character database forgotten in previous commit
--HG-- branch : trunk
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/11_arena_points_characters.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/11_arena_points_characters.sql b/sql/updates/11_arena_points_characters.sql
new file mode 100644
index 00000000000..348eba197a5
--- /dev/null
+++ b/sql/updates/11_arena_points_characters.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `arena_team_member` ADD COLUMN `points_to_add` int(10) UNSIGNED NOT NULL DEFAULT '0';
+DROP TABLE IF EXISTS `saved_variables`;
+CREATE TABLE `saved_variables` (
+ `NextArenaPointDistributionTime` timestamp NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; \ No newline at end of file