add guar_code field to users table and related classes extensions

[brisk.git] / sql / sql.d / 064-user-guarant.sql

diff --git a/sql/sql.d/064-user-guarant.sql b/sql/sql.d/064-user-guarant.sql
new file mode 100644 (file)
index 0000000..980dab5
--- /dev/null
+++ b/sql/sql.d/064-user-guarant.sql
@@ -0,0 +1,3 @@
+-- add guarantee of a user
+ALTER TABLE #PFX#users DROP COLUMN guar_code;
+ALTER TABLE #PFX#users ADD COLUMN guar_code integer DEFAULT -1;  -- who guaranted this user