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

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;