Save passwords as bcrypt instead of plain SHA-1 hashes (includes migration of old...

[pr0n] / sql / pr0n.sql

diff --git a/sql/pr0n.sql b/sql/pr0n.sql
index 3b262b52181c245672caa918d399a10ad7596d07..4089a6a577790984a74672c9580fa6d8d80ef957 100644 (file)
--- a/sql/pr0n.sql
+++ b/sql/pr0n.sql
@@ -73,9 +73,10 @@ CREATE TABLE shadow_files (
 
 CREATE TABLE users (
     username character varying NOT NULL,
-    sha1password character(27) NOT NULL,
+    sha1password character(27),
     vhost character varying NOT NULL,
-    digest_ha1_hex character(32)
+    digest_ha1_hex character(32),
+    cryptpassword character varying
 );
 
 -- Mainly used for manual queries -- usually too slow to be very useful