X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F062-guar-policy-expire.sql;h=d7e22b50be34f0efd5503c9bb9e251b151ae4f68;hb=d805fe6d9173d5de9a5a0e09e1a466f865b66017;hp=72a2449bc5c162093d790c4c5af361c8c3ce3318;hpb=dd8ea26db05952301b2f52c10f5cf0c17338fca3;p=brisk.git diff --git a/sql/sql.d/062-guar-policy-expire.sql b/sql/sql.d/062-guar-policy-expire.sql index 72a2449..d7e22b5 100644 --- a/sql/sql.d/062-guar-policy-expire.sql +++ b/sql/sql.d/062-guar-policy-expire.sql @@ -1,6 +1,6 @@ --- 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;