X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v2.71.sql;h=a4335ea3ed51ccdcd5f9aa65133752ad23dba430;hp=70b910878684cf7e92b9d7a64ce623278de91b63;hb=e0e1d562e8e5a686c1fcd29d31b491ee6e74777f;hpb=8de1aceb10809dd7d546bbef0ecb9c6f42f5fff9;ds=sidebyside

diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql
index 70b9108..a4335ea 100644
--- a/sql/upgrade-v2.71.sql
+++ b/sql/upgrade-v2.71.sql
@@ -3,4 +3,7 @@
 --
 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;