X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fndawn.sql;h=54ede3a5c10269a2c966b8f2863d1630813f239f;hp=177a3f9139ea61b381ef72492e0bfc3082bbcdcb;hb=3b9c21b8ae0a846dc08e3d8a80f85d9d1718ca57;hpb=1645f2920350986aa64005704a841006a402f318

diff --git a/database/ndawn.sql b/database/ndawn.sql
index 177a3f9..54ede3a 100644
--- a/database/ndawn.sql
+++ b/database/ndawn.sql
@@ -3469,6 +3469,8 @@ CREATE TRIGGER update_forum_thread_posts AFTER INSERT OR DELETE OR UPDATE ON for
 
 CREATE TRIGGER update_planet AFTER UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE update_user_planet();
 
+CREATE TRIGGER update_user_planet_check BEFORE UPDATE ON users FOR EACH ROW WHEN (NEW.pid IS NOT NULL AND OLD.pid IS NULL) EXECUTE PROCEDURE update_user_planet_check();
+
 
 --
 -- Name: update_wiki_page; Type: TRIGGER; Schema: public; Owner: ndawn