X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fupgrade-v2.71.sql;h=8fce91d5adfb5fad6ea577688958fcab73a21fa3;hp=70b910878684cf7e92b9d7a64ce623278de91b63;hb=54772c93b534979ab28f88a42eca429edf15d483;hpb=8de1aceb10809dd7d546bbef0ecb9c6f42f5fff9 diff --git a/sql/upgrade-v2.71.sql b/sql/upgrade-v2.71.sql index 70b9108..8fce91d 100644 --- a/sql/upgrade-v2.71.sql +++ b/sql/upgrade-v2.71.sql @@ -3,4 +3,5 @@ -- 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);