X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F062-guar-policy-expire.sql;h=72a2449bc5c162093d790c4c5af361c8c3ce3318;hb=f4178d38662a52ae2ccc8957e499621e735f4d16;hp=76d568cc986f20d4a3329f48028ff6437116f395;hpb=11351a969a05274d75e84160b0b584e4e4901d1f;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
+