lexical adjustment, all licence occurrencies are replaced wit tos word

[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..d7e22b5 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 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
+