X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F062-guar-policy-expire.sql;h=d7e22b50be34f0efd5503c9bb9e251b151ae4f68;hb=330d75c856cac51f3136b1ab1791c8ef8c564ac0;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..d7e22b5 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 current terms of service version accepted by users
+ALTER TABLE #PFX#users DROP COLUMN tos_vers;
+ALTER TABLE #PFX#users ADD COLUMN tos_vers text DEFAULT '';  -- current accepted terms of service 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
+