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 6969d96..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 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
+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 DROP COLUMN supp_comp;
+ALTER TABLE #PFX#users ADD COLUMN supp_comp text    DEFAULT 'ff0000ffff00'; -- fg/bg supporter color
+