Changeset 10 for trunk

Timestamp:

11/19/08 13:22:49 (17 years ago)

Author:

yumileroy

Message:

[svn] - add sql updates for character database forgotten in previous commit

Original author: w12x
Date: 2008-10-05 09:44:08-05:00

Location:

trunk/sql

Files:

• characters.sql (modified) (2 diffs)
• updates/11_arena_points_characters.sql (added)

trunk/sql/characters.sql

@@ -54 +54 @@
   `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;
 
@@ -1209 +1210 @@
 /*!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 */;