X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F053-user-enh.sql;h=727a3910815b2ccab72015a95f40c040ffb75765;hb=330d75c856cac51f3136b1ab1791c8ef8c564ac0;hp=e5c6b446907e3345240e55f4569e3f47bb7a10e3;hpb=507a79a6e6c512a2b0ac0af6e067f5a8845b7d9c;p=brisk.git

diff --git a/sql/sql.d/053-user-enh.sql b/sql/sql.d/053-user-enh.sql
index e5c6b44..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 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
+