X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F053-user-enh.sql;h=727a3910815b2ccab72015a95f40c040ffb75765;hb=47ae15c35f3c407208e52329949039a55e1f3693;hp=6969d96e3543e0960f206e321f8df3d61a10f64c;hpb=b65dddf6cb8fdc5a98719ed170ca38c2059b362c;p=brisk.git

diff --git a/sql/sql.d/053-user-enh.sql b/sql/sql.d/053-user-enh.sql
index 6969d96..727a391 100644
--- 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
+