[Mapbender-commits] r10119 - trunk/mapbender/resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: armin11
Date: 2019-05-10 04:08:21 -0700 (Fri, 10 May 2019)
New Revision: 10119

Modified:
   trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
Log:
New fields for more secure password hashing !

Modified: trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql
===================================================================
--- trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2019-05-10 11:05:44 UTC (rev 10118)
+++ trunk/mapbender/resources/db/pgsql/UTF-8/update/update_2.7.4_to_2.8_pgsql_UTF-8.sql	2019-05-10 11:08:21 UTC (rev 10119)
@@ -2603,4 +2603,16 @@
 ALTER FUNCTION f_get_layer_featuretype_coupling(INT[], boolean)
   OWNER TO postgres;
 
+--add new fields for better password hashing 
+ALTER TABLE mb_user ADD COLUMN salt character varying(100);
 
+ALTER TABLE mb_user ADD COLUMN password character varying(255);
+
+ALTER TABLE mb_user ADD COLUMN is_active boolean;
+
+ALTER TABLE mb_user ADD COLUMN activation_key character varying(255);
+
+ALTER TABLE mb_user ADD COLUMN timestamp_delete bigint;
+
+ALTER TABLE mb_user ADD COLUMN timestamp_dsgvo_accepted bigint;
+