summaryrefslogtreecommitdiffstats
path: root/db updates.sql
diff options
context:
space:
mode:
authorPatrick Davison <snapwilliam@gmail.com>2013-03-24 13:58:26 -0700
committerPatrick Davison <snapwilliam@gmail.com>2013-03-24 13:58:26 -0700
commita9dcb92d783a77b493d865c655244bb8e5d54a41 (patch)
treeb1371aa5b5e87c76b7e8676237624134e3827714 /db updates.sql
parent41acac169cf71b9912a20ffe336dc685b221d74c (diff)
downloadpathery-a9dcb92d783a77b493d865c655244bb8e5d54a41.tar.xz
Missing wallOrientation SQL. Changed back to 25 per-notification.
Diffstat (limited to 'db updates.sql')
-rw-r--r--db updates.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/db updates.sql b/db updates.sql
index f472392..5afd88f 100644
--- a/db updates.sql
+++ b/db updates.sql
@@ -247,4 +247,6 @@ DROP INDEX `mapID` ,
ADD UNIQUE `mapID` ( `mapID` , `ordering` );
-- Optimizing the daily update queries
-ALTER TABLE `solutions` ADD INDEX ( `isHighScore` ) \ No newline at end of file
+ALTER TABLE `solutions` ADD INDEX ( `isHighScore` )
+
+ALTER TABLE `users` ADD `wallOrientation` TINYINT NOT NULL DEFAULT '0' AFTER `wallEmblem` \ No newline at end of file