X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fupgrade-v2.71.sql;h=a4335ea3ed51ccdcd5f9aa65133752ad23dba430;hb=6cd0332e10bb468ef5506be63b8a47f7c7e12fd9;hp=8fce91d5adfb5fad6ea577688958fcab73a21fa3;hpb=54772c93b534979ab28f88a42eca429edf15d483;p=pr0n

diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql
index 8fce91d..a4335ea 100644
--- 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;