X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Ffunctions%2Fcalls.sql;fp=database%2Ffunctions%2Fcalls.sql;h=69821be05f9cae68aa554c38b3c3c4b24f2a59fa;hb=76887e53c27118fe04ae8fe75dce610a398b5853;hp=0000000000000000000000000000000000000000;hpb=73119e806350719e2ce899bfbaa2ba19f0dc87d1;p=ndwebbie.git

diff --git a/database/functions/calls.sql b/database/functions/calls.sql
new file mode 100644
index 0000000..69821be
--- /dev/null
+++ b/database/functions/calls.sql
@@ -0,0 +1,12 @@
+CREATE OR REPLACE FUNCTION add_call() RETURNS trigger
+	AS $_X$
+DECLARE
+	thread INTEGER;
+BEGIN
+	INSERT INTO forum_threads (fbid,subject,uid)
+		VALUES(-3,NEW.uid || ': ' || NEW.landing_tick,-3) RETURNING ftid
+		INTO STRICT thread;
+	NEW.ftid = thread;
+	RETURN NEW;
+END;
+$_X$ LANGUAGE plpgsql;