diff options
| author | Patrick Davison <snapwilliam@gmail.com> | 2013-03-27 15:39:08 -0700 |
|---|---|---|
| committer | Patrick Davison <snapwilliam@gmail.com> | 2013-03-27 15:39:08 -0700 |
| commit | ce6050bfe419f820c23f7157a5df8574c27de345 (patch) | |
| tree | 5c42c2c0686af264deeaa7b1f850b43d1f892eea | |
| parent | f859baa3137b1d16f7252947554c51c58daf2b90 (diff) | |
| parent | 5ddccd86ab09b4536b82545700281f32e71680f5 (diff) | |
| download | pathery-ce6050bfe419f820c23f7157a5df8574c27de345.tar.xz | |
Merge branch 'HEAD' of ssh://git@git.raylu.net/pathery
| -rw-r--r-- | db updates.sql | 7 | ||||
| -rw-r--r-- | includes/constants.php | 2 |
2 files changed, 6 insertions, 3 deletions
diff --git a/db updates.sql b/db updates.sql index 5afd88f..739c6e3 100644 --- a/db updates.sql +++ b/db updates.sql @@ -247,6 +247,9 @@ DROP INDEX `mapID` , ADD UNIQUE `mapID` ( `mapID` , `ordering` ); -- Optimizing the daily update queries -ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) +ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ); -ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`
\ No newline at end of file +ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem`; + +ALTER TABLE `solutions` DROP INDEX `userIDmapID` , +ADD UNIQUE `mapIDuserID` ( `mapID` , `userID` );
\ No newline at end of file diff --git a/includes/constants.php b/includes/constants.php index f5dfc20..7b4e1b8 100644 --- a/includes/constants.php +++ b/includes/constants.php @@ -3,7 +3,7 @@ /** * The 'starting date' of pathery, from which we begin recording all statistics (ties, wins, champion points, etc) */ -define('STATS_EARLIEST_DATE', '2011-08-01'); +define('STATS_EARLIEST_DATE', '2012-03-11'); /** * The minimum number of champion points you can get for tying a map, regardless of how many other people tied |