Clean up database directory

[ndwebbie.git] / database / raids.sql

diff --git a/database/raids.sql b/database/raids.sql
deleted file mode 100644 (file)
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();