X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fraids.sql;fp=database%2Fraids.sql;h=0000000000000000000000000000000000000000;hb=76887e53c27118fe04ae8fe75dce610a398b5853;hp=57de47f0f19b0a73d99df2afa3c054c7e1d7d1a1;hpb=73119e806350719e2ce899bfbaa2ba19f0dc87d1;p=ndwebbie.git diff --git a/database/raids.sql b/database/raids.sql deleted file mode 100644 index 57de47f..0000000 --- a/database/raids.sql +++ /dev/null @@ -1,25 +0,0 @@ -INSERT INTO forum_boards (fcid,fbid,board) VALUES(7,-5,'Raid logs'); -INSERT INTO forum_access (fbid,gid) VALUES(-5,1); -INSERT INTO forum_access (fbid,gid) VALUES(-5,3); - -ALTER TABLE raids ADD COLUMN ftid INTEGER; - - -CREATE OR REPLACE FUNCTION add_raid() RETURNS trigger -AS $$ -DECLARE - rec RECORD; -BEGIN - INSERT INTO forum_threads (ftid,fbid,subject,uid) VALUES - (DEFAULT,-5,'Raid ' || NEW.id,-3) RETURNING ftid INTO rec; - NEW.ftid := rec.ftid; - return NEW; -END; -$$ - LANGUAGE plpgsql; - - -CREATE TRIGGER add_raid - BEFORE INSERT ON raids - FOR EACH ROW - EXECUTE PROCEDURE add_raid();