enhanced data model and sql builder.sh script to manage complex alter table scenario...

[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
index e5c6b44..727a391 100644 (file)
--- a/sql/sql.d/053-user-enh.sql
+++ b/sql/sql.d/053-user-enh.sql
@@ -1,2 +1,6 @@
+ALTER TABLE #PFX#users DROP COLUMN last_dona;
 ALTER TABLE #PFX#users ADD COLUMN last_dona integer DEFAULT 0;             -- last donate
-ALTER TABLE #PFX#users ADD COLUMN supp_comp text    DEFAULT 'ff0000ffff00' -- fg/bg supporter color
\ No newline at end of file
+
+ALTER TABLE #PFX#users DROP COLUMN supp_comp;
+ALTER TABLE #PFX#users ADD COLUMN supp_comp text    DEFAULT 'ff0000ffff00'; -- fg/bg supporter color
+