diff options
| -rw-r--r-- | sql/characters.sql | 20 | ||||
| -rw-r--r-- | sql/updates/11_arena_points_characters.sql | 5 |
2 files changed, 24 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 1c294e21a75..f42dfe764de 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -53,7 +53,8 @@ CREATE TABLE `arena_team_member` ( `played_week` int(10) unsigned NOT NULL default '0', `wons_week` int(10) unsigned NOT NULL default '0', `played_season` int(10) unsigned NOT NULL default '0', - `wons_season` int(10) unsigned NOT NULL default '0' + `wons_season` int(10) unsigned NOT NULL default '0', + `points_to_add` int(10) unsigned NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- @@ -1208,6 +1209,23 @@ LOCK TABLES `petition_sign` WRITE; /*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */; /*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */; UNLOCK TABLES; + +-- +-- Table structure for table `saved_variables` +-- +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'; + +-- +-- Dumping data for table `saved_variables` +-- + +LOCK TABLES `saved_variables` WRITE; +/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */; +/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */; +UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; 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 |