X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=sql%2Fpr0n.sql;h=c8901e2a7eaba02b07ab96a3a7759c1632f273df;hp=5f89f6c91e03c8bf62e76684a3718612d8c53218;hb=54772c93b534979ab28f88a42eca429edf15d483;hpb=238c9466b74b540cedc7569ca3d81a9de911c225;ds=sidebyside

diff --git a/sql/pr0n.sql b/sql/pr0n.sql
index 5f89f6c..c8901e2 100644
--- a/sql/pr0n.sql
+++ b/sql/pr0n.sql
@@ -72,7 +72,8 @@ CREATE TABLE shadow_files (
 CREATE TABLE users (
     username character varying NOT NULL,
     sha1password character(28) NOT NULL,
-    vhost character varying NOT NULL
+    vhost character varying NOT NULL,
+    digest_ha1_hex character(32)
 );
 
 -- Mainly used for manual queries -- usually too slow to be very useful