disa_reas field added to users table

[brisk.git] / sql / sql.d / 062-guar-policy-expire.sql

diff --git a/sql/sql.d/062-guar-policy-expire.sql b/sql/sql.d/062-guar-policy-expire.sql
index 76d568c..72a2449 100644 (file)
--- a/sql/sql.d/062-guar-policy-expire.sql
+++ b/sql/sql.d/062-guar-policy-expire.sql
@@ -1,3 +1,8 @@
 -- add current licence version accepted by users
 ALTER TABLE #PFX#users DROP COLUMN lice_vers;
 ALTER TABLE #PFX#users ADD COLUMN lice_vers text DEFAULT '';  -- current accepted licence version
+
+-- add reason field for disabled users
+ALTER TABLE #PFX#users DROP COLUMN disa_reas;
+ALTER TABLE #PFX#users ADD COLUMN disa_reas integer DEFAULT 0;  -- current disable reason
+