X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fsql.d%2F062-guar-policy-expire.sql;h=72a2449bc5c162093d790c4c5af361c8c3ce3318;hb=d40b54308d7b7cbeaaf0b997fcf5f9dcbef64518;hp=76d568cc986f20d4a3329f48028ff6437116f395;hpb=aa98b7f65908a7b9e6a7bacf2c1672999eba1992;p=brisk.git

diff --git a/sql/sql.d/062-guar-policy-expire.sql b/sql/sql.d/062-guar-policy-expire.sql
index 76d568c..72a2449 100644
--- 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
+