If we are showing a RAW image, show an extra download link.

[pr0n] / sql / upgrade-v2.71.sql

diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql
index 8fce91d5adfb5fad6ea577688958fcab73a21fa3..a4335ea3ed51ccdcd5f9aa65133752ad23dba430 100644 (file)
--- a/sql/upgrade-v2.71.sql
+++ b/sql/upgrade-v2.71.sql
@@ -4,4 +4,6 @@
 ALTER TABLE last_picture_cache ADD COLUMN last_update TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT now();
 ALTER TABLE events DROP COLUMN last_update;
 ALTER TABLE users ADD COLUMN digest_ha1_hex character(32);
+ALTER TABLE users ALTER COLUMN sha1password TYPE character(27);
 
+GRANT UPDATE ON TABLE users TO pr0n;