1 INSERT INTO forum_boards (fcid,fbid,board) VALUES(9,-5,'Raid logs');
3 ALTER TABLE raids ADD COLUMN ftid INTEGER;
6 CREATE OR REPLACE FUNCTION add_raid() RETURNS trigger
11 INSERT INTO forum_threads (ftid,fbid,subject,uid) VALUES
12 (DEFAULT,-5,'Raid ' || NEW.id,-3) RETURNING ftid INTO rec;
20 CREATE TRIGGER add_raid
21 BEFORE INSERT ON raids
23 EXECUTE PROCEDURE add_raid();