+
+CREATE TABLE randomsongsused (
+ song INTEGER NOT NULL PRIMARY KEY REFERENCES songs
+);
+
+CREATE SCHEMA bigscreen;
+
+CREATE TABLE bigscreen.active_tournament (
+ tournament INTEGER NOT NULL REFERENCES tournaments
+);
+
+-- install PL/PgSQL
+CREATE FUNCTION plpgsql_call_handler() RETURNS opaque
+ AS '/usr/lib/postgresql/lib/plpgsql.so', 'plpgsql_call_handler'
+ LANGUAGE "C";
+CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
+
+-- NOTIFY active_tournament when anything has changed
+CREATE FUNCTION notify_active_tournament() RETURNS trigger
+AS '
+ DECLARE
+ BEGIN
+ NOTIFY bigscreen.active_tournament;
+ END;'
+LANGUAGE plpgsql;
+