X-Git-Url: http://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2Fsql.d%2F053-user-enh.sql;h=e5c6b446907e3345240e55f4569e3f47bb7a10e3;hb=507a79a6e6c512a2b0ac0af6e067f5a8845b7d9c;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..e5c6b44 100644 --- a/sql/sql.d/053-user-enh.sql +++ b/sql/sql.d/053-user-enh.sql @@ -1,2 +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 +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