supp_comp partial support (db/prefs management, usage is missing)

[brisk.git] / sql / sql.d / 053-user-enh.sql

diff --git a/sql/sql.d/053-user-enh.sql b/sql/sql.d/053-user-enh.sql
new file mode 100644 (file)
index 0000000..6969d96
--- /dev/null
+++ b/sql/sql.d/053-user-enh.sql
@@ -0,0 +1,2 @@
+ALTER TABLE #PFX#users ADD COLUMN last_dona timestamp DEFAULT to_timestamp(0)  -- last donate
+ALTER TABLE #PFX#users ADD COLUMN supp_comp text      DEFAULT 'ff0000ffff00'   -- fg/bg supporter color
\ No newline at end of file