add lice_vers field in db and managed by associated class (read only)

[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
new file mode 100644 (file)
index 0000000..76d568c
--- /dev/null
+++ b/sql/sql.d/062-guar-policy-expire.sql
@@ -0,0 +1,3 @@
+-- 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