GBuGEQy3

1--- schema.sql	2017-01-29 00:22:58.170965988 +0000
2+++ schema2.sql	2017-01-29 00:23:13.124518999 +0000
3@@ -2,23 +2,12 @@
4 -- PostgreSQL database dump
5 --
6 
7--- Dumped from database version 9.5.5
8--- Dumped by pg_dump version 9.5.5
9-
10 SET statement_timeout = 0;
11 SET lock_timeout = 0;
12 SET client_encoding = 'UTF8';
13 SET standard_conforming_strings = on;
14 SET check_function_bodies = false;
15 SET client_min_messages = warning;
16-SET row_security = off;
17-
18---
19--- Name: membership; Type: COMMENT; Schema: -; Owner: -
20---
21-
22-COMMENT ON DATABASE membership IS 'URY database for EVERYTHING.';
23-
24 
25 --
26 -- Name: bapsplanner; Type: SCHEMA; Schema: -; Owner: -
27@@ -35,20 +24,6 @@
28 
29 
30 --
31--- Name: deploy; Type: SCHEMA; Schema: -; Owner: -
32---
33-
34-CREATE SCHEMA deploy;
35-
36-
37---
38--- Name: SCHEMA deploy; Type: COMMENT; Schema: -; Owner: -
39---
40-
41-COMMENT ON SCHEMA deploy IS 'used by Studio Infomation Service. Deprecated somewhat.';
42-
43-
44---
45 -- Name: jukebox; Type: SCHEMA; Schema: -; Owner: -
46 --
47 
48@@ -63,34 +38,6 @@
49 
50 
51 --
52--- Name: loggerng; Type: SCHEMA; Schema: -; Owner: -
53---
54-
55-CREATE SCHEMA loggerng;
56-
57-
58---
59--- Name: SCHEMA loggerng; Type: COMMENT; Schema: -; Owner: -
60---
61-
62-COMMENT ON SCHEMA loggerng IS 'Used by the Logger.';
63-
64-
65---
66--- Name: loggerng_test; Type: SCHEMA; Schema: -; Owner: -
67---
68-
69-CREATE SCHEMA loggerng_test;
70-
71-
72---
73--- Name: SCHEMA loggerng_test; Type: COMMENT; Schema: -; Owner: -
74---
75-
76-COMMENT ON SCHEMA loggerng_test IS 'Schema for testing loggerng-server';
77-
78-
79---
80 -- Name: mail; Type: SCHEMA; Schema: -; Owner: -
81 --
82 
83@@ -115,7 +62,7 @@
84 -- Name: SCHEMA metadata; Type: COMMENT; Schema: -; Owner: -
85 --
86 
87-COMMENT ON SCHEMA metadata IS 'Metadata systems. Not long for this world?';
88+COMMENT ON SCHEMA metadata IS 'Metadata systems.';
89 
90 
91 --
92@@ -168,20 +115,6 @@
93 
94 
95 --
96--- Name: rapier; Type: SCHEMA; Schema: -; Owner: -
97---
98-
99-CREATE SCHEMA rapier;
100-
101-
102---
103--- Name: SCHEMA rapier; Type: COMMENT; Schema: -; Owner: -
104---
105-
106-COMMENT ON SCHEMA rapier IS 'Internal information for Rapier, the API for Electronic Radio. UNUSED (Probably).';
107-
108-
109---
110 -- Name: schedule; Type: SCHEMA; Schema: -; Owner: -
111 --
112 
113@@ -192,7 +125,7 @@
114 -- Name: SCHEMA schedule; Type: COMMENT; Schema: -; Owner: -
115 --
116 
117-COMMENT ON SCHEMA schedule IS 'Schema for the URY schedule.  New tables should go here, but legacy schedule tables are in the public schema under the sched_ prefix.';
118+COMMENT ON SCHEMA schedule IS 'Schema for the MyRadio schedule.';
119 
120 
121 --
122@@ -210,20 +143,6 @@
123 
124 
125 --
126--- Name: smsd; Type: SCHEMA; Schema: -; Owner: -
127---
128-
129-CREATE SCHEMA smsd;
130-
131-
132---
133--- Name: SCHEMA smsd; Type: COMMENT; Schema: -; Owner: -
134---
135-
136-COMMENT ON SCHEMA smsd IS 'Stores internal metadata for the Gammu SMS Daemon';
137-
138-
139---
140 -- Name: tracklist; Type: SCHEMA; Schema: -; Owner: -
141 --
142 
143@@ -286,82 +205,36 @@
144 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
145 
146 
147---
148--- Name: unaccent; Type: EXTENSION; Schema: -; Owner: -
149---
150-
151-CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public;
152-
153-
154---
155--- Name: EXTENSION unaccent; Type: COMMENT; Schema: -; Owner: -
156---
157-
158-COMMENT ON EXTENSION unaccent IS 'text search dictionary that removes accents';
159-
160-
161 SET search_path = public, pg_catalog;
162 
163 --
164--- Name: showtime; Type: TYPE; Schema: public; Owner: -
165---
166-
167-CREATE TYPE showtime AS (
168-	unixstart integer,
169-	unixend integer,
170-	description character varying
171-);
172-
173-
174---
175--- Name: armor(bytea); Type: FUNCTION; Schema: public; Owner: -
176---
177-
178-CREATE FUNCTION armor(bytea) RETURNS text
179-    LANGUAGE c IMMUTABLE STRICT
180-    AS '$libdir/pgcrypto', 'pg_armor';
181-
182-
183---
184 -- Name: bapstotracklist(); Type: FUNCTION; Schema: public; Owner: -
185 --
186 
187 CREATE FUNCTION bapstotracklist() RETURNS trigger
188     LANGUAGE plpgsql
189-    AS $$
190-DECLARE
191-    audid INTEGER;
192+    AS $$DECLARE
193+audid INTEGER;
194 BEGIN
195-    IF ((TG_OP = 'UPDATE')
196-        AND ((SELECT COUNT(*) FROM (SELECT sel.action FROM selector sel
197-                                    WHERE sel.action >= 4 AND sel.action <= 11
198-                                    ORDER BY sel.TIME DESC LIMIT 1) AS seltop
199-              INNER JOIN tracklist.selbaps bsel ON (seltop.action = bsel.selaction)
200-              WHERE bsel.bapsloc = NEW."serverid" AND (NEW."timeplayed" >= (SELECT sel.TIME FROM selector sel
201-                                                                            ORDER BY sel.TIME DESC
202-                                                                            LIMIT 1))) = 1)
203-        AND ((SELECT COUNT(*) FROM baps_audio ba WHERE ba.audioid = NEW."audioid" AND ba.trackid > 0) = 1)
204-        AND ((NEW."timestopped" - NEW."timeplayed" > '00:00:30'))
205-        AND ((SELECT COUNT(*) FROM tracklist.tracklist WHERE bapsaudioid = NEW."audiologid") = 0))
206-    THEN
207-        INSERT INTO tracklist.tracklist (SOURCE, timestart, timestop, timeslotid, bapsaudioid)
208-            VALUES ('b', NEW."timeplayed", NEW."timestopped", (SELECT show_season_timeslot_id FROM schedule.show_season_timeslot
209-                                                               WHERE start_time <= NOW()
210-                                                                   AND (start_time + duration) >= NOW()
211-                                                                   AND show_season_id != 0
212-                                                               ORDER BY show_season_timeslot_id ASC
213-                                                               LIMIT 1),
214-                    NEW."audiologid")
215-            RETURNING audiologid INTO audid;
216-    INSERT INTO tracklist.track_rec
217-        VALUES ("audid", (SELECT rec.recordid FROM rec_track rec
218-                          INNER JOIN baps_audio ba USING (trackid)
219-                          WHERE ba.audioid = NEW."audioid"),
220-                (SELECT trackid FROM baps_audio WHERE audioid = NEW."audioid"));
221-    END IF;
222-    RETURN NULL;
223-END;
224-$$;
225+	IF ((TG_OP = 'UPDATE')
226+        AND ((SELECT COUNT(*) FROM (SELECT sel.action FROM selector sel WHERE sel.action >= 4 AND sel.action <= 11 ORDER BY sel.time DESC LIMIT 1)AS seltop INNER JOIN tracklist.selbaps bsel ON (seltop.action = bsel.selaction) WHERE bsel.bapsloc = NEW."serverid" AND (NEW."timeplayed" >= (SELECT sel.time FROM selector sel ORDER BY sel.time DESC LIMIT 1) ) ) = 1 )
227+        AND ((SELECT COUNT(*) FROM baps_audio ba WHERE ba.audioid = NEW."audioid" AND ba.trackid > 0 ) = 1 )
228+        AND ((NEW."timestopped" - NEW."timeplayed" > '00:00:30') )
229+        AND ((SELECT COUNT(*) FROM tracklist.tracklist WHERE bapsaudioid = NEW."audiologid") = 0)
230+        )
231+
232+ THEN
233+        INSERT INTO tracklist.tracklist (source, timestart, timestop, timeslotid, bapsaudioid)
234+                VALUES ('b', NEW."timeplayed", NEW."timestopped", (SELECT show_season_timeslot_id FROM schedule.show_season_timeslot WHERE start_time <= NOW() AND (start_time + duration) >= NOW()ORDER BY show_season_timeslot_id ASC LIMIT 1 ), NEW."audiologid" )
235+                RETURNING audiologid INTO audid;
236+	INSERT INTO tracklist.track_rec
237+                VALUES ("audid", (SELECT rec.recordid FROM rec_track rec INNER JOIN baps_audio ba USING (trackid)
238+                WHERE ba.audioid = NEW."audioid"), (SELECT trackid FROM baps_audio WHERE audioid = NEW."audioid"));
239+
240+
241+	END IF;
242+	RETURN NULL;
243+END $$;
244 
245 
246 --
247@@ -387,335 +260,6 @@
248 
249 
250 --
251--- Name: crypt(text, text); Type: FUNCTION; Schema: public; Owner: -
252---
253-
254-CREATE FUNCTION crypt(text, text) RETURNS text
255-    LANGUAGE c IMMUTABLE STRICT
256-    AS '$libdir/pgcrypto', 'pg_crypt';
257-
258-
259---
260--- Name: dearmor(text); Type: FUNCTION; Schema: public; Owner: -
261---
262-
263-CREATE FUNCTION dearmor(text) RETURNS bytea
264-    LANGUAGE c IMMUTABLE STRICT
265-    AS '$libdir/pgcrypto', 'pg_dearmor';
266-
267-
268---
269--- Name: decrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
270---
271-
272-CREATE FUNCTION decrypt(bytea, bytea, text) RETURNS bytea
273-    LANGUAGE c IMMUTABLE STRICT
274-    AS '$libdir/pgcrypto', 'pg_decrypt';
275-
276-
277---
278--- Name: decrypt_iv(bytea, bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
279---
280-
281-CREATE FUNCTION decrypt_iv(bytea, bytea, bytea, text) RETURNS bytea
282-    LANGUAGE c IMMUTABLE STRICT
283-    AS '$libdir/pgcrypto', 'pg_decrypt_iv';
284-
285-
286---
287--- Name: digest(bytea, text); Type: FUNCTION; Schema: public; Owner: -
288---
289-
290-CREATE FUNCTION digest(bytea, text) RETURNS bytea
291-    LANGUAGE c IMMUTABLE STRICT
292-    AS '$libdir/pgcrypto', 'pg_digest';
293-
294-
295---
296--- Name: digest(text, text); Type: FUNCTION; Schema: public; Owner: -
297---
298-
299-CREATE FUNCTION digest(text, text) RETURNS bytea
300-    LANGUAGE c IMMUTABLE STRICT
301-    AS '$libdir/pgcrypto', 'pg_digest';
302-
303-
304---
305--- Name: encrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
306---
307-
308-CREATE FUNCTION encrypt(bytea, bytea, text) RETURNS bytea
309-    LANGUAGE c IMMUTABLE STRICT
310-    AS '$libdir/pgcrypto', 'pg_encrypt';
311-
312-
313---
314--- Name: encrypt_iv(bytea, bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
315---
316-
317-CREATE FUNCTION encrypt_iv(bytea, bytea, bytea, text) RETURNS bytea
318-    LANGUAGE c IMMUTABLE STRICT
319-    AS '$libdir/pgcrypto', 'pg_encrypt_iv';
320-
321-
322---
323--- Name: gen_random_bytes(integer); Type: FUNCTION; Schema: public; Owner: -
324---
325-
326-CREATE FUNCTION gen_random_bytes(integer) RETURNS bytea
327-    LANGUAGE c STRICT
328-    AS '$libdir/pgcrypto', 'pg_random_bytes';
329-
330-
331---
332--- Name: gen_salt(text); Type: FUNCTION; Schema: public; Owner: -
333---
334-
335-CREATE FUNCTION gen_salt(text) RETURNS text
336-    LANGUAGE c STRICT
337-    AS '$libdir/pgcrypto', 'pg_gen_salt';
338-
339-
340---
341--- Name: gen_salt(text, integer); Type: FUNCTION; Schema: public; Owner: -
342---
343-
344-CREATE FUNCTION gen_salt(text, integer) RETURNS text
345-    LANGUAGE c STRICT
346-    AS '$libdir/pgcrypto', 'pg_gen_salt_rounds';
347-
348-
349---
350--- Name: hmac(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
351---
352-
353-CREATE FUNCTION hmac(bytea, bytea, text) RETURNS bytea
354-    LANGUAGE c IMMUTABLE STRICT
355-    AS '$libdir/pgcrypto', 'pg_hmac';
356-
357-
358---
359--- Name: hmac(text, text, text); Type: FUNCTION; Schema: public; Owner: -
360---
361-
362-CREATE FUNCTION hmac(text, text, text) RETURNS bytea
363-    LANGUAGE c IMMUTABLE STRICT
364-    AS '$libdir/pgcrypto', 'pg_hmac';
365-
366-
367---
368--- Name: pastshows(integer, integer); Type: FUNCTION; Schema: public; Owner: -
369---
370-
371-CREATE FUNCTION pastshows(integer, integer) RETURNS SETOF showtime
372-    LANGUAGE sql
373-    AS $_$
374-SELECT
375-    CAST(EXTRACT(EPOCH FROM st.starttime) AS integer) AS unixstart,
376-    CAST(EXTRACT(EPOCH FROM st.endtime) AS integer) AS unixend,
377-    se.summary || ' by ' ||
378-    array_to_string ( array(
379-        SELECT substring(inside_m.fname,1,1)||'. '|| inside_m.sname
380-        FROM sched_timeslot inside_st
381-            NATURAL JOIN sched_entry inside_se
382-            NATURAL JOIN sched_memberentry inside_sm
383-            NATURAL JOIN member inside_m
384-        WHERE inside_st.starttime >= timestamp 'epoch' + $1 * INTERVAL '1 second'
385-            AND inside_st.endtime <= timestamp 'epoch' + $2 * INTERVAL '1 second'
386-            AND inside_st.timeslotid = st.timeslotid
387-    ), ', ') AS description
388-FROM sched_timeslot st
389-    NATURAL JOIN sched_entry se
390-    NATURAL JOIN sched_memberentry sm
391-    NATURAL JOIN member m
392-WHERE st.starttime >= timestamp 'epoch' + $1 * INTERVAL '1 second'
393-    AND st.endtime <= timestamp 'epoch' + $2 * INTERVAL '1 second'
394-GROUP BY st.timeslotid,se.summary,st.starttime,st.endtime
395-ORDER BY st.starttime;
396-$_$;
397-
398-
399---
400--- Name: pgp_key_id(bytea); Type: FUNCTION; Schema: public; Owner: -
401---
402-
403-CREATE FUNCTION pgp_key_id(bytea) RETURNS text
404-    LANGUAGE c IMMUTABLE STRICT
405-    AS '$libdir/pgcrypto', 'pgp_key_id_w';
406-
407-
408---
409--- Name: pgp_pub_decrypt(bytea, bytea); Type: FUNCTION; Schema: public; Owner: -
410---
411-
412-CREATE FUNCTION pgp_pub_decrypt(bytea, bytea) RETURNS text
413-    LANGUAGE c IMMUTABLE STRICT
414-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text';
415-
416-
417---
418--- Name: pgp_pub_decrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
419---
420-
421-CREATE FUNCTION pgp_pub_decrypt(bytea, bytea, text) RETURNS text
422-    LANGUAGE c IMMUTABLE STRICT
423-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text';
424-
425-
426---
427--- Name: pgp_pub_decrypt(bytea, bytea, text, text); Type: FUNCTION; Schema: public; Owner: -
428---
429-
430-CREATE FUNCTION pgp_pub_decrypt(bytea, bytea, text, text) RETURNS text
431-    LANGUAGE c IMMUTABLE STRICT
432-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text';
433-
434-
435---
436--- Name: pgp_pub_decrypt_bytea(bytea, bytea); Type: FUNCTION; Schema: public; Owner: -
437---
438-
439-CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea) RETURNS bytea
440-    LANGUAGE c IMMUTABLE STRICT
441-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea';
442-
443-
444---
445--- Name: pgp_pub_decrypt_bytea(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
446---
447-
448-CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text) RETURNS bytea
449-    LANGUAGE c IMMUTABLE STRICT
450-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea';
451-
452-
453---
454--- Name: pgp_pub_decrypt_bytea(bytea, bytea, text, text); Type: FUNCTION; Schema: public; Owner: -
455---
456-
457-CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text, text) RETURNS bytea
458-    LANGUAGE c IMMUTABLE STRICT
459-    AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea';
460-
461-
462---
463--- Name: pgp_pub_encrypt(text, bytea); Type: FUNCTION; Schema: public; Owner: -
464---
465-
466-CREATE FUNCTION pgp_pub_encrypt(text, bytea) RETURNS bytea
467-    LANGUAGE c STRICT
468-    AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text';
469-
470-
471---
472--- Name: pgp_pub_encrypt(text, bytea, text); Type: FUNCTION; Schema: public; Owner: -
473---
474-
475-CREATE FUNCTION pgp_pub_encrypt(text, bytea, text) RETURNS bytea
476-    LANGUAGE c STRICT
477-    AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text';
478-
479-
480---
481--- Name: pgp_pub_encrypt_bytea(bytea, bytea); Type: FUNCTION; Schema: public; Owner: -
482---
483-
484-CREATE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea) RETURNS bytea
485-    LANGUAGE c STRICT
486-    AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea';
487-
488-
489---
490--- Name: pgp_pub_encrypt_bytea(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: -
491---
492-
493-CREATE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea, text) RETURNS bytea
494-    LANGUAGE c STRICT
495-    AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea';
496-
497-
498---
499--- Name: pgp_sym_decrypt(bytea, text); Type: FUNCTION; Schema: public; Owner: -
500---
501-
502-CREATE FUNCTION pgp_sym_decrypt(bytea, text) RETURNS text
503-    LANGUAGE c IMMUTABLE STRICT
504-    AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text';
505-
506-
507---
508--- Name: pgp_sym_decrypt(bytea, text, text); Type: FUNCTION; Schema: public; Owner: -
509---
510-
511-CREATE FUNCTION pgp_sym_decrypt(bytea, text, text) RETURNS text
512-    LANGUAGE c IMMUTABLE STRICT
513-    AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text';
514-
515-
516---
517--- Name: pgp_sym_decrypt_bytea(bytea, text); Type: FUNCTION; Schema: public; Owner: -
518---
519-
520-CREATE FUNCTION pgp_sym_decrypt_bytea(bytea, text) RETURNS bytea
521-    LANGUAGE c IMMUTABLE STRICT
522-    AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea';
523-
524-
525---
526--- Name: pgp_sym_decrypt_bytea(bytea, text, text); Type: FUNCTION; Schema: public; Owner: -
527---
528-
529-CREATE FUNCTION pgp_sym_decrypt_bytea(bytea, text, text) RETURNS bytea
530-    LANGUAGE c IMMUTABLE STRICT
531-    AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea';
532-
533-
534---
535--- Name: pgp_sym_encrypt(text, text); Type: FUNCTION; Schema: public; Owner: -
536---
537-
538-CREATE FUNCTION pgp_sym_encrypt(text, text) RETURNS bytea
539-    LANGUAGE c STRICT
540-    AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text';
541-
542-
543---
544--- Name: pgp_sym_encrypt(text, text, text); Type: FUNCTION; Schema: public; Owner: -
545---
546-
547-CREATE FUNCTION pgp_sym_encrypt(text, text, text) RETURNS bytea
548-    LANGUAGE c STRICT
549-    AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text';
550-
551-
552---
553--- Name: pgp_sym_encrypt_bytea(bytea, text); Type: FUNCTION; Schema: public; Owner: -
554---
555-
556-CREATE FUNCTION pgp_sym_encrypt_bytea(bytea, text) RETURNS bytea
557-    LANGUAGE c STRICT
558-    AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea';
559-
560-
561---
562--- Name: pgp_sym_encrypt_bytea(bytea, text, text); Type: FUNCTION; Schema: public; Owner: -
563---
564-
565-CREATE FUNCTION pgp_sym_encrypt_bytea(bytea, text, text) RETURNS bytea
566-    LANGUAGE c STRICT
567-    AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea';
568-
569-
570---
571--- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: -
572---
573-
574-CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
575-    LANGUAGE c
576-    AS '$libdir/plpgsql', 'plpgsql_call_handler';
577-
578-
579---
580 -- Name: process_gammu_text(); Type: FUNCTION; Schema: public; Owner: -
581 --
582 
583@@ -749,10 +293,8 @@
584     myshelfnumber integer DEFAULT 0;
585     recordrow RECORD;
586 BEGIN
587-
588     IF ((NEW.media='7' OR NEW.media='2') AND NEW.format='a') THEN
589         FOR recordrow IN SELECT * FROM rec_record WHERE media=NEW.media AND (format='7' OR format='2') AND shelfletter=NEW.shelfletter ORDER BY shelfnumber LOOP
590-
591 	        IF recordrow.shelfnumber > myshelfnumber+1 THEN
592 			EXIT;
593 		END IF;
594@@ -778,11 +320,11 @@
595 
596 CREATE FUNCTION update_timestamp() RETURNS trigger
597     LANGUAGE plpgsql
598-    AS $$
599-  BEGIN
600-    NEW."UpdatedInDB" := LOCALTIMESTAMP(0);
601-    RETURN NEW;
602-  END;
603+    AS $$
604+  BEGIN
605+    NEW."UpdatedInDB" := LOCALTIMESTAMP(0);
606+    RETURN NEW;
607+  END;
608 $$;
609 
610 
611@@ -805,7 +347,7 @@
612 SET default_with_oids = false;
613 
614 --
615--- Name: auto_playlists; Type: TABLE; Schema: bapsplanner; Owner: -
616+-- Name: auto_playlists; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
617 --
618 
619 CREATE TABLE auto_playlists (
620@@ -816,24 +358,6 @@
621 
622 
623 --
624--- Name: client_ids; Type: TABLE; Schema: bapsplanner; Owner: -
625---
626-
627-CREATE TABLE client_ids (
628-    client_id integer NOT NULL,
629-    show_season_timeslot_id integer,
630-    session_id character varying(64)
631-);
632-
633-
634---
635--- Name: TABLE client_ids; Type: COMMENT; Schema: bapsplanner; Owner: -
636---
637-
638-COMMENT ON TABLE client_ids IS 'Enables tracking of individual windows instead of sessions - a session may have more than one window open.';
639-
640-
641---
642 -- Name: client_ids_client_id_seq; Type: SEQUENCE; Schema: bapsplanner; Owner: -
643 --
644 
645@@ -846,24 +370,13 @@
646 
647 
648 --
649--- Name: client_ids_client_id_seq; Type: SEQUENCE OWNED BY; Schema: bapsplanner; Owner: -
650+-- Name: client_ids; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
651 --
652 
653-ALTER SEQUENCE client_ids_client_id_seq OWNED BY client_ids.client_id;
654-
655-
656---
657--- Name: managed_items; Type: TABLE; Schema: bapsplanner; Owner: -
658---
659-
660-CREATE TABLE managed_items (
661-    manageditemid integer NOT NULL,
662-    managedplaylistid integer NOT NULL,
663-    title character varying NOT NULL,
664-    length time without time zone,
665-    bpm smallint,
666-    expirydate date,
667-    memberid integer
668+CREATE TABLE client_ids (
669+    client_id integer DEFAULT nextval('client_ids_client_id_seq'::regclass) NOT NULL,
670+    show_season_timeslot_id integer,
671+    session_id character varying(64)
672 );
673 
674 
675@@ -880,10 +393,18 @@
676 
677 
678 --
679--- Name: managed_items_manageditemid_seq; Type: SEQUENCE OWNED BY; Schema: bapsplanner; Owner: -
680+-- Name: managed_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
681 --
682 
683-ALTER SEQUENCE managed_items_manageditemid_seq OWNED BY managed_items.manageditemid;
684+CREATE TABLE managed_items (
685+    manageditemid integer DEFAULT nextval('managed_items_manageditemid_seq'::regclass) NOT NULL,
686+    managedplaylistid integer NOT NULL,
687+    title character varying NOT NULL,
688+    length time without time zone,
689+    bpm smallint,
690+    expirydate date,
691+    memberid integer
692+);
693 
694 
695 --
696@@ -906,7 +427,7 @@
697 
698 
699 --
700--- Name: managed_playlists; Type: TABLE; Schema: bapsplanner; Owner: -
701+-- Name: managed_playlists; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
702 --
703 
704 CREATE TABLE managed_playlists (
705@@ -944,7 +465,7 @@
706 
707 
708 --
709--- Name: managed_user_items; Type: TABLE; Schema: bapsplanner; Owner: -
710+-- Name: managed_user_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
711 --
712 
713 CREATE TABLE managed_user_items (
714@@ -957,7 +478,7 @@
715 
716 
717 --
718--- Name: secure_play_token; Type: TABLE; Schema: bapsplanner; Owner: -
719+-- Name: secure_play_token; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
720 --
721 
722 CREATE TABLE secure_play_token (
723@@ -976,7 +497,7 @@
724 
725 
726 --
727--- Name: timeslot_change_ops; Type: TABLE; Schema: bapsplanner; Owner: -
728+-- Name: timeslot_change_ops; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
729 --
730 
731 CREATE TABLE timeslot_change_ops (
732@@ -1014,7 +535,7 @@
733 
734 
735 --
736--- Name: timeslot_items; Type: TABLE; Schema: bapsplanner; Owner: -
737+-- Name: timeslot_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace:
738 --
739 
740 CREATE TABLE timeslot_items (
741@@ -1048,86 +569,10 @@
742 ALTER SEQUENCE timeslot_items_timeslot_item_id_seq OWNED BY timeslot_items.timeslot_item_id;
743 
744 
745-SET search_path = deploy, pg_catalog;
746-
747---
748--- Name: myury; Type: TABLE; Schema: deploy; Owner: -
749---
750-
751-CREATE TABLE myury (
752-    memberid integer NOT NULL,
753-    migrated boolean DEFAULT false,
754-    enforced boolean DEFAULT false
755-);
756-
757-
758---
759--- Name: showplanner; Type: TABLE; Schema: deploy; Owner: -
760---
761-
762-CREATE TABLE showplanner (
763-    memberid integer NOT NULL,
764-    migrated boolean DEFAULT false,
765-    enforced boolean DEFAULT false,
766-    helptab boolean DEFAULT true
767-);
768-
769-
770-SET search_path = website, pg_catalog;
771-
772---
773--- Name: banner_campaign; Type: TABLE; Schema: website; Owner: -
774---
775-
776-CREATE TABLE banner_campaign (
777-    memberid integer,
778-    approvedid integer,
779-    effective_from timestamp with time zone NOT NULL,
780-    effective_to timestamp with time zone,
781-    banner_campaign_id integer NOT NULL,
782-    banner_location_id integer NOT NULL,
783-    banner_id integer NOT NULL
784-);
785-
786-
787---
788--- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE; Schema: website; Owner: -
789---
790-
791-CREATE SEQUENCE banner_campaign_banner_campaign_id_seq
792-    START WITH 1
793-    INCREMENT BY 1
794-    NO MINVALUE
795-    NO MAXVALUE
796-    CACHE 1;
797-
798-
799---
800--- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: website; Owner: -
801---
802-
803-ALTER SEQUENCE banner_campaign_banner_campaign_id_seq OWNED BY banner_campaign.banner_campaign_id;
804-
805-
806 SET search_path = jukebox, pg_catalog;
807 
808 --
809--- Name: playlist_availability; Type: TABLE; Schema: jukebox; Owner: -
810---
811-
812-CREATE TABLE playlist_availability (
813-    memberid integer,
814-    approvedid integer,
815-    effective_from timestamp with time zone NOT NULL,
816-    effective_to timestamp with time zone,
817-    playlist_availability_id integer DEFAULT nextval('website.banner_campaign_banner_campaign_id_seq'::regclass) NOT NULL,
818-    weight integer NOT NULL,
819-    playlistid character varying NOT NULL
820-);
821-
822-
823---
824--- Name: playlist_entries; Type: TABLE; Schema: jukebox; Owner: -
825+-- Name: playlist_entries; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
826 --
827 
828 CREATE TABLE playlist_entries (
829@@ -1159,7 +604,7 @@
830 
831 
832 --
833--- Name: playlist_revisions; Type: TABLE; Schema: jukebox; Owner: -
834+-- Name: playlist_revisions; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
835 --
836 
837 CREATE TABLE playlist_revisions (
838@@ -1184,17 +629,18 @@
839 
840 
841 --
842--- Name: playlist_timeslot; Type: TABLE; Schema: jukebox; Owner: -
843+-- Name: playlist_timeslot; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
844 --
845 
846 CREATE TABLE playlist_timeslot (
847     id integer DEFAULT nextval('playlist_timeslot_id_seq'::regclass) NOT NULL,
848     memberid integer NOT NULL,
849     approvedid integer,
850+    weight integer NOT NULL,
851+    playlistid character varying(15) NOT NULL,
852     day smallint NOT NULL,
853     start_time time without time zone NOT NULL,
854-    end_time time without time zone NOT NULL,
855-    playlist_availability_id integer NOT NULL
856+    end_time time without time zone NOT NULL
857 );
858 
859 
860@@ -1206,7 +652,7 @@
861 
862 
863 --
864--- Name: playlists; Type: TABLE; Schema: jukebox; Owner: -
865+-- Name: playlists; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
866 --
867 
868 CREATE TABLE playlists (
869@@ -1237,7 +683,7 @@
870 
871 
872 --
873--- Name: request; Type: TABLE; Schema: jukebox; Owner: -
874+-- Name: request; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
875 --
876 
877 CREATE TABLE request (
878@@ -1269,7 +715,21 @@
879 
880 
881 --
882--- Name: silence_log; Type: TABLE; Schema: jukebox; Owner: -
883+-- Name: requests; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
884+--
885+
886+CREATE TABLE requests (
887+    "user" integer NOT NULL,
888+    start timestamp with time zone NOT NULL,
889+    "end" timestamp with time zone NOT NULL,
890+    format character varying(4) NOT NULL,
891+    title character varying(64),
892+    removed boolean DEFAULT false NOT NULL
893+);
894+
895+
896+--
897+-- Name: silence_log; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
898 --
899 
900 CREATE TABLE silence_log (
901@@ -1326,7 +786,7 @@
902 
903 
904 --
905--- Name: track_blacklist; Type: TABLE; Schema: jukebox; Owner: -
906+-- Name: track_blacklist; Type: TABLE; Schema: jukebox; Owner: -; Tablespace:
907 --
908 
909 CREATE TABLE track_blacklist (
910@@ -1341,70 +801,10 @@
911 COMMENT ON TABLE track_blacklist IS 'A list of Tracks that should, under no circumstances, be played on the jukebox.';
912 
913 
914-SET search_path = loggerng, pg_catalog;
915-
916---
917--- Name: logs; Type: TABLE; Schema: loggerng; Owner: -
918---
919-
920-CREATE TABLE logs (
921-    start timestamp with time zone NOT NULL,
922-    "end" timestamp with time zone NOT NULL,
923-    completed boolean DEFAULT false NOT NULL,
924-    deleted boolean DEFAULT false NOT NULL,
925-    format character varying(4) NOT NULL,
926-    progress real
927-);
928-
929-
930---
931--- Name: requests; Type: TABLE; Schema: loggerng; Owner: -
932---
933-
934-CREATE TABLE requests (
935-    "user" integer NOT NULL,
936-    start timestamp with time zone NOT NULL,
937-    "end" timestamp with time zone NOT NULL,
938-    format character varying(4) NOT NULL,
939-    title character varying(64),
940-    removed boolean DEFAULT false NOT NULL
941-);
942-
943-
944-SET search_path = loggerng_test, pg_catalog;
945-
946---
947--- Name: logs; Type: TABLE; Schema: loggerng_test; Owner: -
948---
949-
950-CREATE TABLE logs (
951-    start timestamp with time zone NOT NULL,
952-    "end" timestamp with time zone NOT NULL,
953-    completed boolean DEFAULT false NOT NULL,
954-    deleted boolean DEFAULT false NOT NULL,
955-    format character varying(4) NOT NULL,
956-    progress real
957-);
958-
959-
960---
961--- Name: requests; Type: TABLE; Schema: loggerng_test; Owner: -
962---
963-
964-CREATE TABLE requests (
965-    "user" integer NOT NULL,
966-    start timestamp with time zone NOT NULL,
967-    "end" timestamp with time zone NOT NULL,
968-    format character varying(4) NOT NULL,
969-    title character varying(64),
970-    removed boolean DEFAULT false NOT NULL
971-);
972-
973-
974 SET search_path = mail, pg_catalog;
975 
976 --
977--- Name: alias; Type: TABLE; Schema: mail; Owner: -
978+-- Name: alias; Type: TABLE; Schema: mail; Owner: -; Tablespace:
979 --
980 
981 CREATE TABLE alias (
982@@ -1433,7 +833,7 @@
983 
984 
985 --
986--- Name: alias_list; Type: TABLE; Schema: mail; Owner: -
987+-- Name: alias_list; Type: TABLE; Schema: mail; Owner: -; Tablespace:
988 --
989 
990 CREATE TABLE alias_list (
991@@ -1443,7 +843,7 @@
992 
993 
994 --
995--- Name: alias_member; Type: TABLE; Schema: mail; Owner: -
996+-- Name: alias_member; Type: TABLE; Schema: mail; Owner: -; Tablespace:
997 --
998 
999 CREATE TABLE alias_member (
1000@@ -1453,7 +853,7 @@
1001 
1002 
1003 --
1004--- Name: alias_officer; Type: TABLE; Schema: mail; Owner: -
1005+-- Name: alias_officer; Type: TABLE; Schema: mail; Owner: -; Tablespace:
1006 --
1007 
1008 CREATE TABLE alias_officer (
1009@@ -1463,25 +863,6 @@
1010 
1011 
1012 --
1013--- Name: alias_officer_alias_id_seq; Type: SEQUENCE; Schema: mail; Owner: -
1014---
1015-
1016-CREATE SEQUENCE alias_officer_alias_id_seq
1017-    START WITH 1
1018-    INCREMENT BY 1
1019-    NO MINVALUE
1020-    NO MAXVALUE
1021-    CACHE 1;
1022-
1023-
1024---
1025--- Name: alias_officer_alias_id_seq; Type: SEQUENCE OWNED BY; Schema: mail; Owner: -
1026---
1027-
1028-ALTER SEQUENCE alias_officer_alias_id_seq OWNED BY alias_officer.alias_id;
1029-
1030-
1031---
1032 -- Name: alias_source_seq; Type: SEQUENCE; Schema: mail; Owner: -
1033 --
1034 
1035@@ -1494,14 +875,7 @@
1036 
1037 
1038 --
1039--- Name: alias_source_seq; Type: SEQUENCE OWNED BY; Schema: mail; Owner: -
1040---
1041-
1042-ALTER SEQUENCE alias_source_seq OWNED BY alias.source;
1043-
1044-
1045---
1046--- Name: alias_text; Type: TABLE; Schema: mail; Owner: -
1047+-- Name: alias_text; Type: TABLE; Schema: mail; Owner: -; Tablespace:
1048 --
1049 
1050 CREATE TABLE alias_text (
1051@@ -1511,7 +885,7 @@
1052 
1053 
1054 --
1055--- Name: email; Type: TABLE; Schema: mail; Owner: -
1056+-- Name: email; Type: TABLE; Schema: mail; Owner: -; Tablespace:
1057 --
1058 
1059 CREATE TABLE email (
1060@@ -1524,7 +898,7 @@
1061 
1062 
1063 --
1064--- Name: email_recipient_list; Type: TABLE; Schema: mail; Owner: -
1065+-- Name: email_recipient_list; Type: TABLE; Schema: mail; Owner: -; Tablespace:
1066 --
1067 
1068 CREATE TABLE email_recipient_list (
1069@@ -1535,7 +909,7 @@
1070 
1071 
1072 --
1073--- Name: email_recipient_member; Type: TABLE; Schema: mail; Owner: -
1074+-- Name: email_recipient_member; Type: TABLE; Schema: mail; Owner: -; Tablespace:
1075 --
1076 
1077 CREATE TABLE email_recipient_member (
1078@@ -1567,7 +941,7 @@
1079 SET search_path = metadata, pg_catalog;
1080 
1081 --
1082--- Name: metadata_key; Type: TABLE; Schema: metadata; Owner: -
1083+-- Name: metadata_key; Type: TABLE; Schema: metadata; Owner: -; Tablespace:
1084 --
1085 
1086 CREATE TABLE metadata_key (
1087@@ -1629,7 +1003,7 @@
1088 
1089 
1090 --
1091--- Name: package; Type: TABLE; Schema: metadata; Owner: -
1092+-- Name: package; Type: TABLE; Schema: metadata; Owner: -; Tablespace:
1093 --
1094 
1095 CREATE TABLE package (
1096@@ -1641,7 +1015,7 @@
1097 
1098 
1099 --
1100--- Name: package_image_metadata; Type: TABLE; Schema: metadata; Owner: -
1101+-- Name: package_image_metadata; Type: TABLE; Schema: metadata; Owner: -; Tablespace:
1102 --
1103 
1104 CREATE TABLE package_image_metadata (
1105@@ -1696,7 +1070,7 @@
1106 
1107 
1108 --
1109--- Name: package_text_metadata; Type: TABLE; Schema: metadata; Owner: -
1110+-- Name: package_text_metadata; Type: TABLE; Schema: metadata; Owner: -; Tablespace:
1111 --
1112 
1113 CREATE TABLE package_text_metadata (
1114@@ -1734,7 +1108,7 @@
1115 SET search_path = music, pg_catalog;
1116 
1117 --
1118--- Name: chart_release; Type: TABLE; Schema: music; Owner: -
1119+-- Name: chart_release; Type: TABLE; Schema: music; Owner: -; Tablespace:
1120 --
1121 
1122 CREATE TABLE chart_release (
1123@@ -1764,7 +1138,7 @@
1124 
1125 
1126 --
1127--- Name: chart_row; Type: TABLE; Schema: music; Owner: -
1128+-- Name: chart_row; Type: TABLE; Schema: music; Owner: -; Tablespace:
1129 --
1130 
1131 CREATE TABLE chart_row (
1132@@ -1798,7 +1172,7 @@
1133 
1134 
1135 --
1136--- Name: chart_type; Type: TABLE; Schema: music; Owner: -
1137+-- Name: chart_type; Type: TABLE; Schema: music; Owner: -; Tablespace:
1138 --
1139 
1140 CREATE TABLE chart_type (
1141@@ -1828,7 +1202,7 @@
1142 
1143 
1144 --
1145--- Name: explicit_checked; Type: TABLE; Schema: music; Owner: -
1146+-- Name: explicit_checked; Type: TABLE; Schema: music; Owner: -; Tablespace:
1147 --
1148 
1149 CREATE TABLE explicit_checked (
1150@@ -1839,7 +1213,7 @@
1151 SET search_path = myradio, pg_catalog;
1152 
1153 --
1154--- Name: schema; Type: TABLE; Schema: myradio; Owner: -
1155+-- Name: schema; Type: TABLE; Schema: myradio; Owner: -; Tablespace:
1156 --
1157 
1158 CREATE TABLE schema (
1159@@ -1851,7 +1225,7 @@
1160 SET search_path = myury, pg_catalog;
1161 
1162 --
1163--- Name: act_permission; Type: TABLE; Schema: myury; Owner: -
1164+-- Name: act_permission; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1165 --
1166 
1167 CREATE TABLE act_permission (
1168@@ -1868,11 +1242,8 @@
1169 --
1170 
1171 COMMENT ON TABLE act_permission IS 'Specifies what permissions are required in order to use a feature. This is an *OR* type permission system - any of these matching will grant access.
1172-
1173 A NULL in the module or action field matches any module or action.
1174-
1175 A NULL permissionid means that no permissions are required to use that Service/Module/Action combination.
1176-
1177 NULL permissions on wildcards will be ignored.';
1178 
1179 
1180@@ -1896,7 +1267,7 @@
1181 
1182 
1183 --
1184--- Name: actions; Type: TABLE; Schema: myury; Owner: -
1185+-- Name: actions; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1186 --
1187 
1188 CREATE TABLE actions (
1189@@ -1912,7 +1283,7 @@
1190 -- Name: TABLE actions; Type: COMMENT; Schema: myury; Owner: -
1191 --
1192 
1193-COMMENT ON TABLE actions IS 'Stores Actions within managed MyURY Service Modules';
1194+COMMENT ON TABLE actions IS 'Stores Actions within managed MyRadio Service Modules';
1195 
1196 
1197 --
1198@@ -1935,7 +1306,7 @@
1199 
1200 
1201 --
1202--- Name: api_class_map; Type: TABLE; Schema: myury; Owner: -
1203+-- Name: api_class_map; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1204 --
1205 
1206 CREATE TABLE api_class_map (
1207@@ -1949,7 +1320,7 @@
1208 -- Name: TABLE api_class_map; Type: COMMENT; Schema: myury; Owner: -
1209 --
1210 
1211-COMMENT ON TABLE api_class_map IS 'Maps MyURY Internal classes to the names exposed to the MyURY API. For example, MyURY_Track would map to Track. If a class is not mapped, it is not available at all to the API.';
1212+COMMENT ON TABLE api_class_map IS 'Maps MyRadio Internal classes to the names exposed to the MyRadio API. For example, MyRadio_Track would map to Track. If a class is not mapped, it is not available at all to the API.';
1213 
1214 
1215 --
1216@@ -1972,7 +1343,7 @@
1217 
1218 
1219 --
1220--- Name: api_key; Type: TABLE; Schema: myury; Owner: -
1221+-- Name: api_key; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1222 --
1223 
1224 CREATE TABLE api_key (
1225@@ -1986,11 +1357,11 @@
1226 -- Name: TABLE api_key; Type: COMMENT; Schema: myury; Owner: -
1227 --
1228 
1229-COMMENT ON TABLE api_key IS 'Access keys for the MyURYpi';
1230+COMMENT ON TABLE api_key IS 'Access keys for the MyRadiopi';
1231 
1232 
1233 --
1234--- Name: api_key_auth; Type: TABLE; Schema: myury; Owner: -
1235+-- Name: api_key_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1236 --
1237 
1238 CREATE TABLE api_key_auth (
1239@@ -2007,7 +1378,7 @@
1240 
1241 
1242 --
1243--- Name: api_key_log; Type: TABLE; Schema: myury; Owner: -
1244+-- Name: api_key_log; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1245 --
1246 
1247 CREATE TABLE api_key_log (
1248@@ -2047,7 +1418,7 @@
1249 
1250 
1251 --
1252--- Name: api_method_auth; Type: TABLE; Schema: myury; Owner: -
1253+-- Name: api_method_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1254 --
1255 
1256 CREATE TABLE api_method_auth (
1257@@ -2063,7 +1434,6 @@
1258 --
1259 
1260 COMMENT ON TABLE api_method_auth IS 'Assigns permissions to API calls. If a Class or Object Method does not have a permission here, it is accessible only to Keys with "AUTH_APISUDO".
1261-
1262 Other than the above exception, the permissions structure is identical to the standard myury action permission system.';
1263 
1264 
1265@@ -2087,7 +1457,7 @@
1266 
1267 
1268 --
1269--- Name: api_mixin_auth; Type: TABLE; Schema: myury; Owner: -
1270+-- Name: api_mixin_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1271 --
1272 
1273 CREATE TABLE api_mixin_auth (
1274@@ -2118,7 +1488,7 @@
1275 
1276 
1277 --
1278--- Name: award_categories; Type: TABLE; Schema: myury; Owner: -
1279+-- Name: award_categories; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1280 --
1281 
1282 CREATE TABLE award_categories (
1283@@ -2147,7 +1517,7 @@
1284 
1285 
1286 --
1287--- Name: award_member; Type: TABLE; Schema: myury; Owner: -
1288+-- Name: award_member; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1289 --
1290 
1291 CREATE TABLE award_member (
1292@@ -2179,66 +1549,7 @@
1293 
1294 
1295 --
1296--- Name: contract_versions; Type: TABLE; Schema: myury; Owner: -
1297---
1298-
1299-CREATE TABLE contract_versions (
1300-    contract_version_id integer NOT NULL,
1301-    description text,
1302-    ratified_date date,
1303-    enforced_date date
1304-);
1305-
1306-
1307---
1308--- Name: TABLE contract_versions; Type: COMMENT; Schema: myury; Owner: -
1309---
1310-
1311-COMMENT ON TABLE contract_versions IS 'Stores the revision history of URY''s presenter contract. This way we can ensure presenters have signed the latest version.';
1312-
1313-
1314---
1315--- Name: COLUMN contract_versions.description; Type: COMMENT; Schema: myury; Owner: -
1316---
1317-
1318-COMMENT ON COLUMN contract_versions.description IS 'A description of revisions made in this version of the contract.';
1319-
1320-
1321---
1322--- Name: COLUMN contract_versions.ratified_date; Type: COMMENT; Schema: myury; Owner: -
1323---
1324-
1325-COMMENT ON COLUMN contract_versions.ratified_date IS 'The date the new version of the contract came into use.';
1326-
1327-
1328---
1329--- Name: COLUMN contract_versions.enforced_date; Type: COMMENT; Schema: myury; Owner: -
1330---
1331-
1332-COMMENT ON COLUMN contract_versions.enforced_date IS 'If NULL, then it isn''t required for presenters to have signed the new contract yet.';
1333-
1334-
1335---
1336--- Name: contract_versions_contract_version_id_seq; Type: SEQUENCE; Schema: myury; Owner: -
1337---
1338-
1339-CREATE SEQUENCE contract_versions_contract_version_id_seq
1340-    START WITH 1
1341-    INCREMENT BY 1
1342-    NO MINVALUE
1343-    NO MAXVALUE
1344-    CACHE 1;
1345-
1346-
1347---
1348--- Name: contract_versions_contract_version_id_seq; Type: SEQUENCE OWNED BY; Schema: myury; Owner: -
1349---
1350-
1351-ALTER SEQUENCE contract_versions_contract_version_id_seq OWNED BY contract_versions.contract_version_id;
1352-
1353-
1354---
1355--- Name: error_rate; Type: TABLE; Schema: myury; Owner: -
1356+-- Name: error_rate; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1357 --
1358 
1359 CREATE TABLE error_rate (
1360@@ -2285,7 +1596,7 @@
1361 
1362 
1363 --
1364--- Name: modules; Type: TABLE; Schema: myury; Owner: -
1365+-- Name: modules; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1366 --
1367 
1368 CREATE TABLE modules (
1369@@ -2300,7 +1611,7 @@
1370 -- Name: TABLE modules; Type: COMMENT; Schema: myury; Owner: -
1371 --
1372 
1373-COMMENT ON TABLE modules IS 'Stores Modules within MyURY managed Services';
1374+COMMENT ON TABLE modules IS 'Stores Modules within MyRadio managed Services';
1375 
1376 
1377 --
1378@@ -2323,7 +1634,7 @@
1379 
1380 
1381 --
1382--- Name: password_reset_token; Type: TABLE; Schema: myury; Owner: -
1383+-- Name: password_reset_token; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1384 --
1385 
1386 CREATE TABLE password_reset_token (
1387@@ -2342,7 +1653,7 @@
1388 
1389 
1390 --
1391--- Name: photos; Type: TABLE; Schema: myury; Owner: -
1392+-- Name: photos; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1393 --
1394 
1395 CREATE TABLE photos (
1396@@ -2380,7 +1691,7 @@
1397 
1398 
1399 --
1400--- Name: services; Type: TABLE; Schema: myury; Owner: -
1401+-- Name: services; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1402 --
1403 
1404 CREATE TABLE services (
1405@@ -2394,7 +1705,7 @@
1406 -- Name: TABLE services; Type: COMMENT; Schema: myury; Owner: -
1407 --
1408 
1409-COMMENT ON TABLE services IS 'Lists all Services managed by MyURY';
1410+COMMENT ON TABLE services IS 'Lists all Services managed by MyRadio';
1411 
1412 
1413 --
1414@@ -2417,7 +1728,7 @@
1415 
1416 
1417 --
1418--- Name: services_versions; Type: TABLE; Schema: myury; Owner: -
1419+-- Name: services_versions; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1420 --
1421 
1422 CREATE TABLE services_versions (
1423@@ -2438,7 +1749,7 @@
1424 
1425 
1426 --
1427--- Name: services_versions_member; Type: TABLE; Schema: myury; Owner: -
1428+-- Name: services_versions_member; Type: TABLE; Schema: myury; Owner: -; Tablespace:
1429 --
1430 
1431 CREATE TABLE services_versions_member (
1432@@ -2469,7 +1780,7 @@
1433 SET search_path = people, pg_catalog;
1434 
1435 --
1436--- Name: credit_type; Type: TABLE; Schema: people; Owner: -
1437+-- Name: credit_type; Type: TABLE; Schema: people; Owner: -; Tablespace:
1438 --
1439 
1440 CREATE TABLE credit_type (
1441@@ -2502,7 +1813,7 @@
1442 
1443 
1444 --
1445--- Name: group_root_role; Type: TABLE; Schema: people; Owner: -
1446+-- Name: group_root_role; Type: TABLE; Schema: people; Owner: -; Tablespace:
1447 --
1448 
1449 CREATE TABLE group_root_role (
1450@@ -2540,7 +1851,7 @@
1451 
1452 
1453 --
1454--- Name: group_type; Type: TABLE; Schema: people; Owner: -
1455+-- Name: group_type; Type: TABLE; Schema: people; Owner: -; Tablespace:
1456 --
1457 
1458 CREATE TABLE group_type (
1459@@ -2569,7 +1880,7 @@
1460 
1461 
1462 --
1463--- Name: metadata; Type: TABLE; Schema: people; Owner: -
1464+-- Name: metadata; Type: TABLE; Schema: people; Owner: -; Tablespace:
1465 --
1466 
1467 CREATE TABLE metadata (
1468@@ -2584,9 +1895,7 @@
1469 --
1470 
1471 COMMENT ON TABLE metadata IS 'Key-value store for textual metadata associated with rules.
1472-
1473 As of writing the metadata schema is:
1474-
1475 ''Collective-Name'' - human readable name for the group of everyone in this role, example ''Station Managers''.  This is used as the team name when the role is a grouproot.
1476 ''Individual-Name'' - human readable name for an individual in this role, example ''Station Manager''.
1477 ''Acronym'' - self-explanatory, example ''SM''.
1478@@ -2616,7 +1925,7 @@
1479 
1480 
1481 --
1482--- Name: quote; Type: TABLE; Schema: people; Owner: -
1483+-- Name: quote; Type: TABLE; Schema: people; Owner: -; Tablespace:
1484 --
1485 
1486 CREATE TABLE quote (
1487@@ -2647,7 +1956,7 @@
1488 
1489 
1490 --
1491--- Name: role; Type: TABLE; Schema: people; Owner: -
1492+-- Name: role; Type: TABLE; Schema: people; Owner: -; Tablespace:
1493 --
1494 
1495 CREATE TABLE role (
1496@@ -2702,7 +2011,7 @@
1497 
1498 
1499 --
1500--- Name: role_inheritance; Type: TABLE; Schema: people; Owner: -
1501+-- Name: role_inheritance; Type: TABLE; Schema: people; Owner: -; Tablespace:
1502 --
1503 
1504 CREATE TABLE role_inheritance (
1505@@ -2760,7 +2069,7 @@
1506 
1507 
1508 --
1509--- Name: role_text_metadata; Type: TABLE; Schema: people; Owner: -
1510+-- Name: role_text_metadata; Type: TABLE; Schema: people; Owner: -; Tablespace:
1511 --
1512 
1513 CREATE TABLE role_text_metadata (
1514@@ -2809,7 +2118,7 @@
1515 
1516 
1517 --
1518--- Name: role_visibility; Type: TABLE; Schema: people; Owner: -
1519+-- Name: role_visibility; Type: TABLE; Schema: people; Owner: -; Tablespace:
1520 --
1521 
1522 CREATE TABLE role_visibility (
1523@@ -2906,10 +2215,116 @@
1524 
1525 SET search_path = public, pg_catalog;
1526 
1527+--
1528+-- Name: acl_member; Type: TABLE; Schema: public; Owner: -; Tablespace:
1529+--
1530+
1531+CREATE TABLE acl_member (
1532+    privilegeid integer NOT NULL,
1533+    memberid integer,
1534+    class text NOT NULL,
1535+    verb text NOT NULL,
1536+    scope integer DEFAULT 0 NOT NULL
1537+);
1538+
1539+
1540+--
1541+-- Name: TABLE acl_member; Type: COMMENT; Schema: public; Owner: -
1542+--
1543+
1544+COMMENT ON TABLE acl_member IS 'Access Control List for regular members (used to grant temporary and extraordinary permissions)';
1545+
1546+
1547+--
1548+-- Name: COLUMN acl_member.privilegeid; Type: COMMENT; Schema: public; Owner: -
1549+--
1550+
1551+COMMENT ON COLUMN acl_member.privilegeid IS 'The unique ID of this ACL row.';
1552+
1553+
1554+--
1555+-- Name: COLUMN acl_member.memberid; Type: COMMENT; Schema: public; Owner: -
1556+--
1557+
1558+COMMENT ON COLUMN acl_member.memberid IS 'The unique ID of the member being granted a permission.';
1559+
1560+
1561+--
1562+-- Name: COLUMN acl_member.class; Type: COMMENT; Schema: public; Owner: -
1563+--
1564+
1565+COMMENT ON COLUMN acl_member.class IS 'The full name of the Rapier object class a permission is being granted for.';
1566+
1567+
1568+--
1569+-- Name: COLUMN acl_member.verb; Type: COMMENT; Schema: public; Owner: -
1570+--
1571+
1572+COMMENT ON COLUMN acl_member.verb IS 'The verb (eg "read") representing the privileged action being granted.';
1573+
1574+
1575+--
1576+-- Name: COLUMN acl_member.scope; Type: COMMENT; Schema: public; Owner: -
1577+--
1578+
1579+COMMENT ON COLUMN acl_member.scope IS 'The scope of this action being granted. (see constants_acl_scope).';
1580+
1581+
1582+--
1583+-- Name: acl_member_privilegeid_seq; Type: SEQUENCE; Schema: public; Owner: -
1584+--
1585+
1586+CREATE SEQUENCE acl_member_privilegeid_seq
1587+    START WITH 1
1588+    INCREMENT BY 1
1589+    NO MINVALUE
1590+    NO MAXVALUE
1591+    CACHE 1;
1592+
1593+
1594+--
1595+-- Name: acl_member_privilegeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1596+--
1597+
1598+ALTER SEQUENCE acl_member_privilegeid_seq OWNED BY acl_member.privilegeid;
1599+
1600+
1601+--
1602+-- Name: acl_officer; Type: TABLE; Schema: public; Owner: -; Tablespace:
1603+--
1604+
1605+CREATE TABLE acl_officer (
1606+    privilegeid integer DEFAULT nextval('acl_member_privilegeid_seq'::regclass) NOT NULL,
1607+    officerid integer NOT NULL,
1608+    class text NOT NULL,
1609+    verb text NOT NULL,
1610+    scope integer DEFAULT 0 NOT NULL
1611+);
1612+
1613+
1614+--
1615+-- Name: COLUMN acl_officer.class; Type: COMMENT; Schema: public; Owner: -
1616+--
1617+
1618+COMMENT ON COLUMN acl_officer.class IS 'The full name of the Rapier object class a permission is being granted for.';
1619+
1620+
1621+--
1622+-- Name: acl_officer_privilegeid_seq; Type: SEQUENCE; Schema: public; Owner: -
1623+--
1624+
1625+CREATE SEQUENCE acl_officer_privilegeid_seq
1626+    START WITH 1
1627+    INCREMENT BY 1
1628+    NO MINVALUE
1629+    NO MAXVALUE
1630+    CACHE 1;
1631+
1632+
1633 SET default_with_oids = true;
1634 
1635 --
1636--- Name: auth; Type: TABLE; Schema: public; Owner: -
1637+-- Name: auth; Type: TABLE; Schema: public; Owner: -; Tablespace:
1638 --
1639 
1640 CREATE TABLE auth (
1641@@ -2945,7 +2360,7 @@
1642 SET default_with_oids = false;
1643 
1644 --
1645--- Name: auth_group; Type: TABLE; Schema: public; Owner: -
1646+-- Name: auth_group; Type: TABLE; Schema: public; Owner: -; Tablespace:
1647 --
1648 
1649 CREATE TABLE auth_group (
1650@@ -2976,7 +2391,7 @@
1651 SET default_with_oids = true;
1652 
1653 --
1654--- Name: auth_officer; Type: TABLE; Schema: public; Owner: -
1655+-- Name: auth_officer; Type: TABLE; Schema: public; Owner: -; Tablespace:
1656 --
1657 
1658 CREATE TABLE auth_officer (
1659@@ -2995,7 +2410,38 @@
1660 SET default_with_oids = false;
1661 
1662 --
1663--- Name: auth_subnet; Type: TABLE; Schema: public; Owner: -
1664+-- Name: auth_permission; Type: TABLE; Schema: public; Owner: -; Tablespace:
1665+--
1666+
1667+CREATE TABLE auth_permission (
1668+    id integer NOT NULL,
1669+    name character varying(50) NOT NULL,
1670+    content_type_id integer NOT NULL,
1671+    codename character varying(100) NOT NULL
1672+);
1673+
1674+
1675+--
1676+-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1677+--
1678+
1679+CREATE SEQUENCE auth_permission_id_seq
1680+    START WITH 1
1681+    INCREMENT BY 1
1682+    NO MINVALUE
1683+    NO MAXVALUE
1684+    CACHE 1;
1685+
1686+
1687+--
1688+-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1689+--
1690+
1691+ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;
1692+
1693+
1694+--
1695+-- Name: auth_subnet; Type: TABLE; Schema: public; Owner: -; Tablespace:
1696 --
1697 
1698 CREATE TABLE auth_subnet (
1699@@ -3012,7 +2458,7 @@
1700 
1701 
1702 --
1703--- Name: auth_trainingstatus; Type: TABLE; Schema: public; Owner: -
1704+-- Name: auth_trainingstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
1705 --
1706 
1707 CREATE TABLE auth_trainingstatus (
1708@@ -3029,7 +2475,7 @@
1709 
1710 
1711 --
1712--- Name: auth_user; Type: TABLE; Schema: public; Owner: -
1713+-- Name: auth_user; Type: TABLE; Schema: public; Owner: -; Tablespace:
1714 --
1715 
1716 CREATE TABLE auth_user (
1717@@ -3048,7 +2494,7 @@
1718 
1719 
1720 --
1721--- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: -
1722+-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: -; Tablespace:
1723 --
1724 
1725 CREATE TABLE auth_user_groups (
1726@@ -3111,7 +2557,7 @@
1727 SET default_with_oids = true;
1728 
1729 --
1730--- Name: baps_audio; Type: TABLE; Schema: public; Owner: -
1731+-- Name: baps_audio; Type: TABLE; Schema: public; Owner: -; Tablespace:
1732 --
1733 
1734 CREATE TABLE baps_audio (
1735@@ -3141,7 +2587,7 @@
1736 
1737 
1738 --
1739--- Name: baps_audiolog; Type: TABLE; Schema: public; Owner: -
1740+-- Name: baps_audiolog; Type: TABLE; Schema: public; Owner: -; Tablespace:
1741 --
1742 
1743 CREATE TABLE baps_audiolog (
1744@@ -3174,7 +2620,7 @@
1745 
1746 
1747 --
1748--- Name: baps_filefolder; Type: TABLE; Schema: public; Owner: -
1749+-- Name: baps_filefolder; Type: TABLE; Schema: public; Owner: -; Tablespace:
1750 --
1751 
1752 CREATE TABLE baps_filefolder (
1753@@ -3210,7 +2656,7 @@
1754 
1755 
1756 --
1757--- Name: baps_fileitem; Type: TABLE; Schema: public; Owner: -
1758+-- Name: baps_fileitem; Type: TABLE; Schema: public; Owner: -; Tablespace:
1759 --
1760 
1761 CREATE TABLE baps_fileitem (
1762@@ -3239,7 +2685,7 @@
1763 
1764 
1765 --
1766--- Name: baps_item; Type: TABLE; Schema: public; Owner: -
1767+-- Name: baps_item; Type: TABLE; Schema: public; Owner: -; Tablespace:
1768 --
1769 
1770 CREATE TABLE baps_item (
1771@@ -3251,7 +2697,7 @@
1772     libraryitemid integer,
1773     fileitemid integer,
1774     name2 character varying(255),
1775-    CONSTRAINT baps_item_check CHECK ((((textitemid IS NULL) AND (libraryitemid IS NULL) AND (fileitemid IS NOT NULL)) OR ((textitemid IS NOT NULL) AND (libraryitemid IS NULL) AND (fileitemid IS NULL)) OR ((textitemid IS NULL) AND (libraryitemid IS NOT NULL) AND (fileitemid IS NULL))))
1776+    CONSTRAINT baps_item_check CHECK ((((((textitemid IS NULL) AND (libraryitemid IS NULL)) AND (fileitemid IS NOT NULL)) OR (((textitemid IS NOT NULL) AND (libraryitemid IS NULL)) AND (fileitemid IS NULL))) OR (((textitemid IS NULL) AND (libraryitemid IS NOT NULL)) AND (fileitemid IS NULL))))
1777 );
1778 
1779 
1780@@ -3275,7 +2721,7 @@
1781 
1782 
1783 --
1784--- Name: baps_libraryitem; Type: TABLE; Schema: public; Owner: -
1785+-- Name: baps_libraryitem; Type: TABLE; Schema: public; Owner: -; Tablespace:
1786 --
1787 
1788 CREATE TABLE baps_libraryitem (
1789@@ -3305,7 +2751,7 @@
1790 
1791 
1792 --
1793--- Name: baps_listing; Type: TABLE; Schema: public; Owner: -
1794+-- Name: baps_listing; Type: TABLE; Schema: public; Owner: -; Tablespace:
1795 --
1796 
1797 CREATE TABLE baps_listing (
1798@@ -3348,7 +2794,7 @@
1799 
1800 
1801 --
1802--- Name: rec_track; Type: TABLE; Schema: public; Owner: -
1803+-- Name: rec_track; Type: TABLE; Schema: public; Owner: -; Tablespace:
1804 --
1805 
1806 CREATE TABLE rec_track (
1807@@ -3365,8 +2811,8 @@
1808     digitisedby integer,
1809     duration integer,
1810     lastfm_verified boolean DEFAULT false,
1811-    last_edited_time timestamp with time zone,
1812-    last_edited_memberid integer
1813+    last_edited_memberid integer,
1814+    last_edited_time timestamp with time zone
1815 );
1816 
1817 
1818@@ -3408,7 +2854,7 @@
1819 
1820 
1821 --
1822--- Name: baps_server; Type: TABLE; Schema: public; Owner: -
1823+-- Name: baps_server; Type: TABLE; Schema: public; Owner: -; Tablespace:
1824 --
1825 
1826 CREATE TABLE baps_server (
1827@@ -3437,7 +2883,7 @@
1828 
1829 
1830 --
1831--- Name: baps_show; Type: TABLE; Schema: public; Owner: -
1832+-- Name: baps_show; Type: TABLE; Schema: public; Owner: -; Tablespace:
1833 --
1834 
1835 CREATE TABLE baps_show (
1836@@ -3470,7 +2916,7 @@
1837 
1838 
1839 --
1840--- Name: baps_textitem; Type: TABLE; Schema: public; Owner: -
1841+-- Name: baps_textitem; Type: TABLE; Schema: public; Owner: -; Tablespace:
1842 --
1843 
1844 CREATE TABLE baps_textitem (
1845@@ -3499,7 +2945,7 @@
1846 
1847 
1848 --
1849--- Name: baps_user; Type: TABLE; Schema: public; Owner: -
1850+-- Name: baps_user; Type: TABLE; Schema: public; Owner: -; Tablespace:
1851 --
1852 
1853 CREATE TABLE baps_user (
1854@@ -3515,7 +2961,7 @@
1855 
1856 
1857 --
1858--- Name: baps_user_external; Type: TABLE; Schema: public; Owner: -
1859+-- Name: baps_user_external; Type: TABLE; Schema: public; Owner: -; Tablespace:
1860 --
1861 
1862 CREATE TABLE baps_user_external (
1863@@ -3545,7 +2991,7 @@
1864 
1865 
1866 --
1867--- Name: baps_user_filefolder; Type: TABLE; Schema: public; Owner: -
1868+-- Name: baps_user_filefolder; Type: TABLE; Schema: public; Owner: -; Tablespace:
1869 --
1870 
1871 CREATE TABLE baps_user_filefolder (
1872@@ -3596,51 +3042,150 @@
1873 SET default_with_oids = false;
1874 
1875 --
1876--- Name: cat_view_promoter; Type: TABLE; Schema: public; Owner: -
1877+-- Name: chart; Type: TABLE; Schema: public; Owner: -; Tablespace:
1878 --
1879 
1880-CREATE TABLE cat_view_promoter (
1881-    chicken integer,
1882-    nipples character varying
1883+CREATE TABLE chart (
1884+    chartweek integer NOT NULL,
1885+    lastweek text NOT NULL,
1886+    title text NOT NULL,
1887+    artist text NOT NULL,
1888+    "position" integer NOT NULL
1889 );
1890 
1891 
1892 --
1893--- Name: TABLE cat_view_promoter; Type: COMMENT; Schema: public; Owner: -
1894+-- Name: TABLE chart; Type: COMMENT; Schema: public; Owner: -
1895 --
1896 
1897-COMMENT ON TABLE cat_view_promoter IS 'Don''t delete, or the cataloguer breaks.';
1898+COMMENT ON TABLE chart IS 'ury chart rundowns';
1899 
1900 
1901 --
1902--- Name: chart; Type: TABLE; Schema: public; Owner: -
1903+-- Name: COLUMN chart.chartweek; Type: COMMENT; Schema: public; Owner: -
1904 --
1905 
1906-CREATE TABLE chart (
1907-    chartweek integer NOT NULL,
1908-    lastweek text NOT NULL,
1909-    title text NOT NULL,
1910-    artist text NOT NULL,
1911-    "position" integer NOT NULL
1912+COMMENT ON COLUMN chart.chartweek IS 'chart release timestamp';
1913+
1914+
1915+--
1916+-- Name: client; Type: TABLE; Schema: public; Owner: -; Tablespace:
1917+--
1918+
1919+CREATE TABLE client (
1920+    clientid integer NOT NULL,
1921+    name text NOT NULL,
1922+    secrethash text NOT NULL,
1923+    description text
1924 );
1925 
1926 
1927 --
1928--- Name: TABLE chart; Type: COMMENT; Schema: public; Owner: -
1929+-- Name: TABLE client; Type: COMMENT; Schema: public; Owner: -
1930 --
1931 
1932-COMMENT ON TABLE chart IS 'ury chart rundowns';
1933+COMMENT ON TABLE client IS 'Registry of clients allowed to use Rapier.';
1934 
1935 
1936 --
1937--- Name: COLUMN chart.chartweek; Type: COMMENT; Schema: public; Owner: -
1938+-- Name: COLUMN client.clientid; Type: COMMENT; Schema: public; Owner: -
1939 --
1940 
1941-COMMENT ON COLUMN chart.chartweek IS 'chart release timestamp';
1942+COMMENT ON COLUMN client.clientid IS 'The numeric ID of the client.';
1943+
1944+
1945+--
1946+-- Name: COLUMN client.name; Type: COMMENT; Schema: public; Owner: -
1947+--
1948+
1949+COMMENT ON COLUMN client.name IS 'The log-in name of the client.';
1950+
1951+
1952+--
1953+-- Name: COLUMN client.secrethash; Type: COMMENT; Schema: public; Owner: -
1954+--
1955+
1956+COMMENT ON COLUMN client.secrethash IS 'A hash of the log-in password of the client.';
1957+
1958+
1959+--
1960+-- Name: COLUMN client.description; Type: COMMENT; Schema: public; Owner: -
1961+--
1962+
1963+COMMENT ON COLUMN client.description IS 'A human-readable description of the client.';
1964+
1965+
1966+--
1967+-- Name: client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: -
1968+--
1969+
1970+CREATE SEQUENCE client_clientid_seq
1971+    START WITH 1
1972+    INCREMENT BY 1
1973+    NO MINVALUE
1974+    NO MAXVALUE
1975+    CACHE 1;
1976+
1977+
1978+--
1979+-- Name: client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1980+--
1981+
1982+ALTER SEQUENCE client_clientid_seq OWNED BY client.clientid;
1983+
1984+
1985+--
1986+-- Name: constants_acl_scope; Type: TABLE; Schema: public; Owner: -; Tablespace:
1987+--
1988+
1989+CREATE TABLE constants_acl_scope (
1990+    scopeid integer NOT NULL,
1991+    description text NOT NULL
1992+);
1993+
1994+
1995+--
1996+-- Name: TABLE constants_acl_scope; Type: COMMENT; Schema: public; Owner: -
1997+--
1998+
1999+COMMENT ON TABLE constants_acl_scope IS 'Human-readable descriptions for the ACL scope levels.';
2000 
2001 
2002 --
2003--- Name: selector; Type: TABLE; Schema: public; Owner: -
2004+-- Name: COLUMN constants_acl_scope.scopeid; Type: COMMENT; Schema: public; Owner: -
2005+--
2006+
2007+COMMENT ON COLUMN constants_acl_scope.scopeid IS 'The unique ID of this scope level.';
2008+
2009+
2010+--
2011+-- Name: COLUMN constants_acl_scope.description; Type: COMMENT; Schema: public; Owner: -
2012+--
2013+
2014+COMMENT ON COLUMN constants_acl_scope.description IS 'The human-readable description of this scope level.';
2015+
2016+
2017+--
2018+-- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE; Schema: public; Owner: -
2019+--
2020+
2021+CREATE SEQUENCE constants_acl_scope_scopeid_seq
2022+    START WITH 3
2023+    INCREMENT BY 1
2024+    NO MINVALUE
2025+    NO MAXVALUE
2026+    CACHE 1;
2027+
2028+
2029+--
2030+-- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2031+--
2032+
2033+ALTER SEQUENCE constants_acl_scope_scopeid_seq OWNED BY constants_acl_scope.scopeid;
2034+
2035+
2036+--
2037+-- Name: selector; Type: TABLE; Schema: public; Owner: -; Tablespace:
2038 --
2039 
2040 CREATE TABLE selector (
2041@@ -3673,7 +3218,7 @@
2042 
2043 
2044 --
2045--- Name: gammu; Type: TABLE; Schema: public; Owner: -
2046+-- Name: gammu; Type: TABLE; Schema: public; Owner: -; Tablespace:
2047 --
2048 
2049 CREATE TABLE gammu (
2050@@ -3685,13 +3230,13 @@
2051 -- Name: TABLE gammu; Type: COMMENT; Schema: public; Owner: -
2052 --
2053 
2054-COMMENT ON TABLE gammu IS 'Gammu - text messaging system';
2055+COMMENT ON TABLE gammu IS 'Do not delete - Gammu will break';
2056 
2057 
2058 SET default_with_oids = true;
2059 
2060 --
2061--- Name: l_action; Type: TABLE; Schema: public; Owner: -
2062+-- Name: l_action; Type: TABLE; Schema: public; Owner: -; Tablespace:
2063 --
2064 
2065 CREATE TABLE l_action (
2066@@ -3743,7 +3288,7 @@
2067 
2068 
2069 --
2070--- Name: l_college; Type: TABLE; Schema: public; Owner: -
2071+-- Name: l_college; Type: TABLE; Schema: public; Owner: -; Tablespace:
2072 --
2073 
2074 CREATE TABLE l_college (
2075@@ -3765,7 +3310,7 @@
2076 
2077 
2078 --
2079--- Name: l_musicinterest; Type: TABLE; Schema: public; Owner: -
2080+-- Name: l_musicinterest; Type: TABLE; Schema: public; Owner: -; Tablespace:
2081 --
2082 
2083 CREATE TABLE l_musicinterest (
2084@@ -3789,7 +3334,7 @@
2085 SET default_with_oids = false;
2086 
2087 --
2088--- Name: l_newsfeed; Type: TABLE; Schema: public; Owner: -
2089+-- Name: l_newsfeed; Type: TABLE; Schema: public; Owner: -; Tablespace:
2090 --
2091 
2092 CREATE TABLE l_newsfeed (
2093@@ -3810,7 +3355,7 @@
2094 --
2095 
2096 CREATE SEQUENCE l_newsfeeds_feedid_seq
2097-    START WITH 1
2098+    START WITH 5
2099     INCREMENT BY 1
2100     NO MINVALUE
2101     NO MAXVALUE
2102@@ -3827,7 +3372,7 @@
2103 SET default_with_oids = true;
2104 
2105 --
2106--- Name: l_presenterstatus; Type: TABLE; Schema: public; Owner: -
2107+-- Name: l_presenterstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
2108 --
2109 
2110 CREATE TABLE l_presenterstatus (
2111@@ -3867,7 +3412,7 @@
2112 
2113 
2114 --
2115--- Name: l_status; Type: TABLE; Schema: public; Owner: -
2116+-- Name: l_status; Type: TABLE; Schema: public; Owner: -; Tablespace:
2117 --
2118 
2119 CREATE TABLE l_status (
2120@@ -3879,7 +3424,7 @@
2121 SET default_with_oids = false;
2122 
2123 --
2124--- Name: l_subnet; Type: TABLE; Schema: public; Owner: -
2125+-- Name: l_subnet; Type: TABLE; Schema: public; Owner: -; Tablespace:
2126 --
2127 
2128 CREATE TABLE l_subnet (
2129@@ -3909,7 +3454,7 @@
2130 
2131 
2132 --
2133--- Name: mail_alias_text; Type: TABLE; Schema: public; Owner: -
2134+-- Name: mail_alias_text; Type: TABLE; Schema: public; Owner: -; Tablespace:
2135 --
2136 
2137 CREATE TABLE mail_alias_text (
2138@@ -3947,7 +3492,7 @@
2139 
2140 
2141 --
2142--- Name: mail_alias_list; Type: TABLE; Schema: public; Owner: -
2143+-- Name: mail_alias_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
2144 --
2145 
2146 CREATE TABLE mail_alias_list (
2147@@ -3966,7 +3511,7 @@
2148 
2149 
2150 --
2151--- Name: mail_alias_member; Type: TABLE; Schema: public; Owner: -
2152+-- Name: mail_alias_member; Type: TABLE; Schema: public; Owner: -; Tablespace:
2153 --
2154 
2155 CREATE TABLE mail_alias_member (
2156@@ -3985,7 +3530,7 @@
2157 
2158 
2159 --
2160--- Name: mail_alias_officer; Type: TABLE; Schema: public; Owner: -
2161+-- Name: mail_alias_officer; Type: TABLE; Schema: public; Owner: -; Tablespace:
2162 --
2163 
2164 CREATE TABLE mail_alias_officer (
2165@@ -4004,7 +3549,7 @@
2166 
2167 
2168 --
2169--- Name: mail_list; Type: TABLE; Schema: public; Owner: -
2170+-- Name: mail_list; Type: TABLE; Schema: public; Owner: -; Tablespace:
2171 --
2172 
2173 CREATE TABLE mail_list (
2174@@ -4089,7 +3634,7 @@
2175 
2176 
2177 --
2178--- Name: mail_subscription; Type: TABLE; Schema: public; Owner: -
2179+-- Name: mail_subscription; Type: TABLE; Schema: public; Owner: -; Tablespace:
2180 --
2181 
2182 CREATE TABLE mail_subscription (
2183@@ -4108,7 +3653,7 @@
2184 SET default_with_oids = true;
2185 
2186 --
2187--- Name: member; Type: TABLE; Schema: public; Owner: -
2188+-- Name: member; Type: TABLE; Schema: public; Owner: -; Tablespace:
2189 --
2190 
2191 CREATE TABLE member (
2192@@ -4132,25 +3677,11 @@
2193     profile_photo integer,
2194     bio text,
2195     auth_provider character varying,
2196-    contract_signed boolean DEFAULT false
2197+    contract_signed boolean DEFAULT false NOT NULL
2198 );
2199 
2200 
2201 --
2202--- Name: TABLE member; Type: COMMENT; Schema: public; Owner: -
2203---
2204-
2205-COMMENT ON TABLE member IS 'The members!';
2206-
2207-
2208---
2209--- Name: COLUMN member.sex; Type: COMMENT; Schema: public; Owner: -
2210---
2211-
2212-COMMENT ON COLUMN member.sex IS 'Yes please!';
2213-
2214-
2215---
2216 -- Name: COLUMN member.email; Type: COMMENT; Schema: public; Owner: -
2217 --
2218 
2219@@ -4193,13 +3724,6 @@
2220 
2221 
2222 --
2223--- Name: COLUMN member.contract_signed; Type: COMMENT; Schema: public; Owner: -
2224---
2225-
2226-COMMENT ON COLUMN member.contract_signed IS 'Has the member signed the current year''s presenter contract?';
2227-
2228-
2229---
2230 -- Name: member_memberid_seq; Type: SEQUENCE; Schema: public; Owner: -
2231 --
2232 
2233@@ -4214,7 +3738,7 @@
2234 SET default_with_oids = false;
2235 
2236 --
2237--- Name: member_news_feed; Type: TABLE; Schema: public; Owner: -
2238+-- Name: member_news_feed; Type: TABLE; Schema: public; Owner: -; Tablespace:
2239 --
2240 
2241 CREATE TABLE member_news_feed (
2242@@ -4266,7 +3790,7 @@
2243 SET default_with_oids = true;
2244 
2245 --
2246--- Name: member_officer; Type: TABLE; Schema: public; Owner: -
2247+-- Name: member_officer; Type: TABLE; Schema: public; Owner: -; Tablespace:
2248 --
2249 
2250 CREATE TABLE member_officer (
2251@@ -4281,7 +3805,7 @@
2252 SET default_with_oids = false;
2253 
2254 --
2255--- Name: member_pass; Type: TABLE; Schema: public; Owner: -
2256+-- Name: member_pass; Type: TABLE; Schema: public; Owner: -; Tablespace:
2257 --
2258 
2259 CREATE TABLE member_pass (
2260@@ -4300,7 +3824,7 @@
2261 SET default_with_oids = true;
2262 
2263 --
2264--- Name: member_presenterstatus; Type: TABLE; Schema: public; Owner: -
2265+-- Name: member_presenterstatus; Type: TABLE; Schema: public; Owner: -; Tablespace:
2266 --
2267 
2268 CREATE TABLE member_presenterstatus (
2269@@ -4334,7 +3858,7 @@
2270 
2271 
2272 --
2273--- Name: member_year; Type: TABLE; Schema: public; Owner: -
2274+-- Name: member_year; Type: TABLE; Schema: public; Owner: -; Tablespace:
2275 --
2276 
2277 CREATE TABLE member_year (
2278@@ -4347,7 +3871,7 @@
2279 SET default_with_oids = false;
2280 
2281 --
2282--- Name: net_switchport; Type: TABLE; Schema: public; Owner: -
2283+-- Name: net_switchport; Type: TABLE; Schema: public; Owner: -; Tablespace:
2284 --
2285 
2286 CREATE TABLE net_switchport (
2287@@ -4373,7 +3897,7 @@
2288 
2289 
2290 --
2291--- Name: net_switchport_tags; Type: TABLE; Schema: public; Owner: -
2292+-- Name: net_switchport_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
2293 --
2294 
2295 CREATE TABLE net_switchport_tags (
2296@@ -4383,7 +3907,7 @@
2297 
2298 
2299 --
2300--- Name: net_vlan; Type: TABLE; Schema: public; Owner: -
2301+-- Name: net_vlan; Type: TABLE; Schema: public; Owner: -; Tablespace:
2302 --
2303 
2304 CREATE TABLE net_vlan (
2305@@ -4400,7 +3924,7 @@
2306 
2307 
2308 --
2309--- Name: news_feed; Type: TABLE; Schema: public; Owner: -
2310+-- Name: news_feed; Type: TABLE; Schema: public; Owner: -; Tablespace:
2311 --
2312 
2313 CREATE TABLE news_feed (
2314@@ -4440,7 +3964,7 @@
2315 
2316 
2317 --
2318--- Name: nipsweb_migrate; Type: TABLE; Schema: public; Owner: -
2319+-- Name: nipsweb_migrate; Type: TABLE; Schema: public; Owner: -; Tablespace:
2320 --
2321 
2322 CREATE TABLE nipsweb_migrate (
2323@@ -4460,7 +3984,7 @@
2324 SET default_with_oids = true;
2325 
2326 --
2327--- Name: officer; Type: TABLE; Schema: public; Owner: -
2328+-- Name: officer; Type: TABLE; Schema: public; Owner: -; Tablespace:
2329 --
2330 
2331 CREATE TABLE officer (
2332@@ -4477,13 +4001,6 @@
2333 
2334 
2335 --
2336--- Name: COLUMN officer.officer_alias; Type: COMMENT; Schema: public; Owner: -
2337---
2338-
2339-COMMENT ON COLUMN officer.officer_alias IS 'The officer''s alias for email (<this>@ury.org.uk)';
2340-
2341-
2342---
2343 -- Name: COLUMN officer.type; Type: COMMENT; Schema: public; Owner: -
2344 --
2345 
2346@@ -4503,7 +4020,7 @@
2347 
2348 
2349 --
2350--- Name: rec_cleanlookup; Type: TABLE; Schema: public; Owner: -
2351+-- Name: rec_cleanlookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2352 --
2353 
2354 CREATE TABLE rec_cleanlookup (
2355@@ -4513,7 +4030,7 @@
2356 
2357 
2358 --
2359--- Name: rec_formatlookup; Type: TABLE; Schema: public; Owner: -
2360+-- Name: rec_formatlookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2361 --
2362 
2363 CREATE TABLE rec_formatlookup (
2364@@ -4523,7 +4040,7 @@
2365 
2366 
2367 --
2368--- Name: rec_genrelookup; Type: TABLE; Schema: public; Owner: -
2369+-- Name: rec_genrelookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2370 --
2371 
2372 CREATE TABLE rec_genrelookup (
2373@@ -4535,7 +4052,7 @@
2374 SET default_with_oids = false;
2375 
2376 --
2377--- Name: rec_itunes; Type: TABLE; Schema: public; Owner: -
2378+-- Name: rec_itunes; Type: TABLE; Schema: public; Owner: -; Tablespace:
2379 --
2380 
2381 CREATE TABLE rec_itunes (
2382@@ -4557,7 +4074,7 @@
2383 SET default_with_oids = true;
2384 
2385 --
2386--- Name: rec_labelqueue; Type: TABLE; Schema: public; Owner: -
2387+-- Name: rec_labelqueue; Type: TABLE; Schema: public; Owner: -; Tablespace:
2388 --
2389 
2390 CREATE TABLE rec_labelqueue (
2391@@ -4580,7 +4097,7 @@
2392 
2393 
2394 --
2395--- Name: rec_locationlookup; Type: TABLE; Schema: public; Owner: -
2396+-- Name: rec_locationlookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2397 --
2398 
2399 CREATE TABLE rec_locationlookup (
2400@@ -4592,7 +4109,7 @@
2401 SET default_with_oids = false;
2402 
2403 --
2404--- Name: rec_lookup; Type: TABLE; Schema: public; Owner: -
2405+-- Name: rec_lookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2406 --
2407 
2408 CREATE TABLE rec_lookup (
2409@@ -4652,7 +4169,7 @@
2410 SET default_with_oids = true;
2411 
2412 --
2413--- Name: rec_medialookup; Type: TABLE; Schema: public; Owner: -
2414+-- Name: rec_medialookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2415 --
2416 
2417 CREATE TABLE rec_medialookup (
2418@@ -4662,7 +4179,7 @@
2419 
2420 
2421 --
2422--- Name: rec_record; Type: TABLE; Schema: public; Owner: -
2423+-- Name: rec_record; Type: TABLE; Schema: public; Owner: -; Tablespace:
2424 --
2425 
2426 CREATE TABLE rec_record (
2427@@ -4699,7 +4216,7 @@
2428 
2429 
2430 --
2431--- Name: rec_statuslookup; Type: TABLE; Schema: public; Owner: -
2432+-- Name: rec_statuslookup; Type: TABLE; Schema: public; Owner: -; Tablespace:
2433 --
2434 
2435 CREATE TABLE rec_statuslookup (
2436@@ -4723,7 +4240,7 @@
2437 SET default_with_oids = false;
2438 
2439 --
2440--- Name: rec_trackcorrection; Type: TABLE; Schema: public; Owner: -
2441+-- Name: rec_trackcorrection; Type: TABLE; Schema: public; Owner: -; Tablespace:
2442 --
2443 
2444 CREATE TABLE rec_trackcorrection (
2445@@ -4734,7 +4251,7 @@
2446     proposed_album_name character varying NOT NULL,
2447     state character(1) DEFAULT 'p'::bpchar NOT NULL,
2448     reviewedby integer,
2449-    level integer DEFAULT '-1'::integer NOT NULL
2450+    level integer DEFAULT (-1) NOT NULL
2451 );
2452 
2453 
2454@@ -4765,56 +4282,7 @@
2455 
2456 
2457 --
2458--- Name: rec_trackproposal; Type: TABLE; Schema: public; Owner: -
2459---
2460-
2461-CREATE TABLE rec_trackproposal (
2462-    proposalid integer NOT NULL,
2463-    proposed_title character varying,
2464-    proposed_artist character varying,
2465-    proposed_album_name character varying,
2466-    proposed_position smallint,
2467-    state character(1) DEFAULT 'p'::bpchar,
2468-    proposedby integer,
2469-    reviewedby integer
2470-);
2471-
2472-
2473---
2474--- Name: TABLE rec_trackproposal; Type: COMMENT; Schema: public; Owner: -
2475---
2476-
2477-COMMENT ON TABLE rec_trackproposal IS 'Stores proposed metadata for tracks last.fm could not identify.';
2478-
2479-
2480---
2481--- Name: COLUMN rec_trackproposal.state; Type: COMMENT; Schema: public; Owner: -
2482---
2483-
2484-COMMENT ON COLUMN rec_trackproposal.state IS '''a'' Accepted, ''r'' Rejected or ''p'' Pending';
2485-
2486-
2487---
2488--- Name: rec_trackproposal_proposalid_seq; Type: SEQUENCE; Schema: public; Owner: -
2489---
2490-
2491-CREATE SEQUENCE rec_trackproposal_proposalid_seq
2492-    START WITH 1
2493-    INCREMENT BY 1
2494-    NO MINVALUE
2495-    NO MAXVALUE
2496-    CACHE 1;
2497-
2498-
2499---
2500--- Name: rec_trackproposal_proposalid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2501---
2502-
2503-ALTER SEQUENCE rec_trackproposal_proposalid_seq OWNED BY rec_trackproposal.proposalid;
2504-
2505-
2506---
2507--- Name: recommended_listening; Type: TABLE; Schema: public; Owner: -
2508+-- Name: recommended_listening; Type: TABLE; Schema: public; Owner: -; Tablespace:
2509 --
2510 
2511 CREATE TABLE recommended_listening (
2512@@ -4863,7 +4331,7 @@
2513 SET search_path = schedule, pg_catalog;
2514 
2515 --
2516--- Name: show; Type: TABLE; Schema: schedule; Owner: -
2517+-- Name: show; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
2518 --
2519 
2520 CREATE TABLE show (
2521@@ -4899,7 +4367,7 @@
2522 -- Name: COLUMN show.submitted; Type: COMMENT; Schema: schedule; Owner: -
2523 --
2524 
2525-COMMENT ON COLUMN show.submitted IS 'When the application was submitted. If Null, the application has just been saved by the user (not yet implemented in MyURY)';
2526+COMMENT ON COLUMN show.submitted IS 'When the application was submitted. If Null, the application has just been saved by the user (not yet implemented in MyRadio)';
2527 
2528 
2529 --
2530@@ -4910,7 +4378,7 @@
2531 
2532 
2533 --
2534--- Name: show_metadata; Type: TABLE; Schema: schedule; Owner: -
2535+-- Name: show_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
2536 --
2537 
2538 CREATE TABLE show_metadata (
2539@@ -4988,209 +4456,8 @@
2540 COMMENT ON COLUMN show_metadata.effective_to IS 'The timestamp of the period at which this metadatum stops being effective.  If NULL, the metadatum is effective indefinitely from effective_from.';
2541 
2542 
2543-SET search_path = public, pg_catalog;
2544-
2545---
2546--- Name: sched_entry; Type: VIEW; Schema: public; Owner: -
2547---
2548-
2549-CREATE VIEW sched_entry AS
2550- SELECT t0.entryid,
2551-    t0.entrytypeid,
2552-    t0.rss,
2553-    t0.url,
2554-    t1.summary,
2555-    t1.createddate,
2556-    NULL::unknown AS oid,
2557-    t1.summary AS description
2558-   FROM (( SELECT show.show_id AS entryid,
2559-            '3' AS entrytypeid,
2560-            NULL::unknown AS rss,
2561-            NULL::unknown AS url
2562-           FROM schedule.show) t0
2563-     LEFT JOIN ( SELECT show_metadata.show_id AS entryid,
2564-            show_metadata.metadata_value AS summary,
2565-            show_metadata.effective_from AS createddate
2566-           FROM schedule.show_metadata
2567-          WHERE ((show_metadata.metadata_key_id = 2) AND ((show_metadata.effective_to IS NULL) OR (show_metadata.effective_to >= now())))) t1 ON ((t0.entryid = t1.entryid)));
2568-
2569-
2570-SET default_with_oids = true;
2571-
2572---
2573--- Name: sched_entrytype; Type: TABLE; Schema: public; Owner: -
2574---
2575-
2576-CREATE TABLE sched_entrytype (
2577-    entrytypeid integer NOT NULL,
2578-    entrytypename character varying(30) NOT NULL,
2579-    causesclash boolean DEFAULT true,
2580-    takesuptime boolean DEFAULT false
2581-);
2582-
2583-
2584---
2585--- Name: COLUMN sched_entrytype.takesuptime; Type: COMMENT; Schema: public; Owner: -
2586---
2587-
2588-COMMENT ON COLUMN sched_entrytype.takesuptime IS 'defines if this entrytype appears in a persons schedule';
2589-
2590-
2591---
2592--- Name: sched_entrytype_entrytypeid_seq; Type: SEQUENCE; Schema: public; Owner: -
2593---
2594-
2595-CREATE SEQUENCE sched_entrytype_entrytypeid_seq
2596-    START WITH 1
2597-    INCREMENT BY 1
2598-    NO MINVALUE
2599-    NO MAXVALUE
2600-    CACHE 1;
2601-
2602-
2603 --
2604--- Name: sched_entrytype_entrytypeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2605---
2606-
2607-ALTER SEQUENCE sched_entrytype_entrytypeid_seq OWNED BY sched_entrytype.entrytypeid;
2608-
2609-
2610---
2611--- Name: sched_genre_genreid_seq; Type: SEQUENCE; Schema: public; Owner: -
2612---
2613-
2614-CREATE SEQUENCE sched_genre_genreid_seq
2615-    START WITH 1
2616-    INCREMENT BY 1
2617-    NO MINVALUE
2618-    NO MAXVALUE
2619-    CACHE 1;
2620-
2621-
2622-SET default_with_oids = false;
2623-
2624---
2625--- Name: sched_genre; Type: TABLE; Schema: public; Owner: -
2626---
2627-
2628-CREATE TABLE sched_genre (
2629-    genreid integer DEFAULT nextval('sched_genre_genreid_seq'::regclass) NOT NULL,
2630-    genrename character varying(30) NOT NULL
2631-);
2632-
2633-
2634---
2635--- Name: COLUMN sched_genre.genreid; Type: COMMENT; Schema: public; Owner: -
2636---
2637-
2638-COMMENT ON COLUMN sched_genre.genreid IS 'The unique ID number of the genre.';
2639-
2640-
2641---
2642--- Name: COLUMN sched_genre.genrename; Type: COMMENT; Schema: public; Owner: -
2643---
2644-
2645-COMMENT ON COLUMN sched_genre.genrename IS 'The name of the genre.';
2646-
2647-
2648-SET default_with_oids = true;
2649-
2650---
2651--- Name: sched_musiccategory; Type: TABLE; Schema: public; Owner: -
2652---
2653-
2654-CREATE TABLE sched_musiccategory (
2655-    musiccategoryid integer NOT NULL,
2656-    musiccategoryname character varying(30) NOT NULL,
2657-    ordering integer
2658-);
2659-
2660-
2661---
2662--- Name: sched_musiccategory_musiccategoryid_seq; Type: SEQUENCE; Schema: public; Owner: -
2663---
2664-
2665-CREATE SEQUENCE sched_musiccategory_musiccategoryid_seq
2666-    START WITH 1
2667-    INCREMENT BY 1
2668-    NO MINVALUE
2669-    NO MAXVALUE
2670-    CACHE 1;
2671-
2672-
2673---
2674--- Name: sched_musiccategory_musiccategoryid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2675---
2676-
2677-ALTER SEQUENCE sched_musiccategory_musiccategoryid_seq OWNED BY sched_musiccategory.musiccategoryid;
2678-
2679-
2680---
2681--- Name: sched_room; Type: TABLE; Schema: public; Owner: -
2682---
2683-
2684-CREATE TABLE sched_room (
2685-    roomid integer NOT NULL,
2686-    roomname character varying(30) NOT NULL,
2687-    ordering integer
2688-);
2689-
2690-
2691---
2692--- Name: sched_room_roomid_seq; Type: SEQUENCE; Schema: public; Owner: -
2693---
2694-
2695-CREATE SEQUENCE sched_room_roomid_seq
2696-    START WITH 1
2697-    INCREMENT BY 1
2698-    NO MINVALUE
2699-    NO MAXVALUE
2700-    CACHE 1;
2701-
2702-
2703---
2704--- Name: sched_room_roomid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2705---
2706-
2707-ALTER SEQUENCE sched_room_roomid_seq OWNED BY sched_room.roomid;
2708-
2709-
2710---
2711--- Name: sched_speechcategory; Type: TABLE; Schema: public; Owner: -
2712---
2713-
2714-CREATE TABLE sched_speechcategory (
2715-    speechcategoryid integer NOT NULL,
2716-    speechcategoryname character varying(30) NOT NULL,
2717-    ordering integer
2718-);
2719-
2720-
2721---
2722--- Name: sched_speechcategory_speechcategoryid_seq; Type: SEQUENCE; Schema: public; Owner: -
2723---
2724-
2725-CREATE SEQUENCE sched_speechcategory_speechcategoryid_seq
2726-    START WITH 1
2727-    INCREMENT BY 1
2728-    NO MINVALUE
2729-    NO MAXVALUE
2730-    CACHE 1;
2731-
2732-
2733---
2734--- Name: sched_speechcategory_speechcategoryid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2735---
2736-
2737-ALTER SEQUENCE sched_speechcategory_speechcategoryid_seq OWNED BY sched_speechcategory.speechcategoryid;
2738-
2739-
2740-SET search_path = schedule, pg_catalog;
2741-
2742-SET default_with_oids = false;
2743-
2744---
2745--- Name: show_season; Type: TABLE; Schema: schedule; Owner: -
2746+-- Name: show_season; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
2747 --
2748 
2749 CREATE TABLE show_season (
2750@@ -5245,7 +4512,7 @@
2751 
2752 
2753 --
2754--- Name: show_season_timeslot; Type: TABLE; Schema: schedule; Owner: -
2755+-- Name: show_season_timeslot; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
2756 --
2757 
2758 CREATE TABLE show_season_timeslot (
2759@@ -5311,7 +4578,7 @@
2760 
2761 
2762 --
2763--- Name: selector_actions; Type: TABLE; Schema: public; Owner: -
2764+-- Name: selector_actions; Type: TABLE; Schema: public; Owner: -; Tablespace:
2765 --
2766 
2767 CREATE TABLE selector_actions (
2768@@ -5373,7 +4640,7 @@
2769 SET default_with_oids = true;
2770 
2771 --
2772--- Name: sis_commtype; Type: TABLE; Schema: public; Owner: -
2773+-- Name: sis_commtype; Type: TABLE; Schema: public; Owner: -; Tablespace:
2774 --
2775 
2776 CREATE TABLE sis_commtype (
2777@@ -5404,7 +4671,7 @@
2778 SET default_with_oids = false;
2779 
2780 --
2781--- Name: sis_piss; Type: TABLE; Schema: public; Owner: -
2782+-- Name: sis_piss; Type: TABLE; Schema: public; Owner: -; Tablespace:
2783 --
2784 
2785 CREATE TABLE sis_piss (
2786@@ -5444,7 +4711,7 @@
2787 SET default_with_oids = true;
2788 
2789 --
2790--- Name: sis_status; Type: TABLE; Schema: public; Owner: -
2791+-- Name: sis_status; Type: TABLE; Schema: public; Owner: -; Tablespace:
2792 --
2793 
2794 CREATE TABLE sis_status (
2795@@ -5458,7 +4725,7 @@
2796 --
2797 
2798 CREATE SEQUENCE sis_status_statusid_seq
2799-    START WITH 1
2800+    START WITH 6
2801     INCREMENT BY 1
2802     NO MINVALUE
2803     NO MAXVALUE
2804@@ -5487,66 +4754,54 @@
2805 SET default_with_oids = false;
2806 
2807 --
2808--- Name: sso_session; Type: TABLE; Schema: public; Owner: -
2809+-- Name: site_package; Type: TABLE; Schema: public; Owner: -; Tablespace:
2810 --
2811 
2812-CREATE TABLE sso_session (
2813-    id character varying(32) NOT NULL,
2814-    data text,
2815-    "timestamp" timestamp without time zone NOT NULL
2816+CREATE TABLE site_package (
2817+    packageid integer NOT NULL,
2818+    name text NOT NULL,
2819+    active boolean DEFAULT false NOT NULL,
2820+    starttime timestamp without time zone,
2821+    endtime timestamp without time zone
2822 );
2823 
2824 
2825-SET default_with_oids = true;
2826-
2827 --
2828--- Name: strm_useragent; Type: TABLE; Schema: public; Owner: -
2829+-- Name: TABLE site_package; Type: COMMENT; Schema: public; Owner: -
2830 --
2831 
2832-CREATE TABLE strm_useragent (
2833-    useragentid integer NOT NULL,
2834-    useragent character varying(255) NOT NULL
2835-);
2836+COMMENT ON TABLE site_package IS 'Table defining special event packages, which temporarily replace the site look and feel.
2837+Packages reside in /content/packages/*NAME* and must include the following files:
2838+1) package.css - a CSS file patching the normal URY CSS to add event-specific changes such as a different banner.
2839+2) index.php - a PHP file that will replace the home page while the package is active.  This will usually redirect to the actual home page for the event.';
2840 
2841 
2842 --
2843--- Name: strm_client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: -
2844+-- Name: COLUMN site_package.packageid; Type: COMMENT; Schema: public; Owner: -
2845 --
2846 
2847-CREATE SEQUENCE strm_client_clientid_seq
2848-    START WITH 1
2849-    INCREMENT BY 1
2850-    NO MINVALUE
2851-    NO MAXVALUE
2852-    CACHE 1;
2853+COMMENT ON COLUMN site_package.packageid IS 'The unique identifier of the package.  The package with the highest packageid (and active set to TRUE) is the one that will be applied to the site.';
2854 
2855 
2856 --
2857--- Name: strm_client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2858+-- Name: COLUMN site_package.name; Type: COMMENT; Schema: public; Owner: -
2859 --
2860 
2861-ALTER SEQUENCE strm_client_clientid_seq OWNED BY strm_useragent.useragentid;
2862+COMMENT ON COLUMN site_package.name IS 'The name of the package, which also denotes the subdirectory of /content/packages/ that contains the package files.';
2863 
2864 
2865 --
2866--- Name: strm_log; Type: TABLE; Schema: public; Owner: -
2867+-- Name: COLUMN site_package.active; Type: COMMENT; Schema: public; Owner: -
2868 --
2869 
2870-CREATE TABLE strm_log (
2871-    logid integer NOT NULL,
2872-    streamid integer NOT NULL,
2873-    useragentid integer NOT NULL,
2874-    starttime timestamp with time zone NOT NULL,
2875-    endtime timestamp with time zone NOT NULL,
2876-    ipaddr inet NOT NULL
2877-);
2878+COMMENT ON COLUMN site_package.active IS 'When TRUE, the package is active.  There should generally be only one active package; in the case that there are multiple the one with the highest packageid is selected.';
2879 
2880 
2881 --
2882--- Name: strm_log_logid_seq; Type: SEQUENCE; Schema: public; Owner: -
2883+-- Name: site_special_package_packageid_seq; Type: SEQUENCE; Schema: public; Owner: -
2884 --
2885 
2886-CREATE SEQUENCE strm_log_logid_seq
2887+CREATE SEQUENCE site_special_package_packageid_seq
2888     START WITH 1
2889     INCREMENT BY 1
2890     NO MINVALUE
2891@@ -5555,28 +4810,28 @@
2892 
2893 
2894 --
2895--- Name: strm_log_logid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2896+-- Name: site_special_package_packageid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2897 --
2898 
2899-ALTER SEQUENCE strm_log_logid_seq OWNED BY strm_log.logid;
2900+ALTER SEQUENCE site_special_package_packageid_seq OWNED BY site_package.packageid;
2901 
2902 
2903 --
2904--- Name: strm_logfile; Type: TABLE; Schema: public; Owner: -
2905+-- Name: sitetree_tree; Type: TABLE; Schema: public; Owner: -; Tablespace:
2906 --
2907 
2908-CREATE TABLE strm_logfile (
2909-    logfileid integer NOT NULL,
2910-    filename character varying(255) NOT NULL,
2911-    lastsize integer
2912+CREATE TABLE sitetree_tree (
2913+    id integer NOT NULL,
2914+    title character varying(100) NOT NULL,
2915+    alias character varying(80) NOT NULL
2916 );
2917 
2918 
2919 --
2920--- Name: strm_logfile_logfileid_seq; Type: SEQUENCE; Schema: public; Owner: -
2921+-- Name: sitetree_tree_id_seq; Type: SEQUENCE; Schema: public; Owner: -
2922 --
2923 
2924-CREATE SEQUENCE strm_logfile_logfileid_seq
2925+CREATE SEQUENCE sitetree_tree_id_seq
2926     START WITH 1
2927     INCREMENT BY 1
2928     NO MINVALUE
2929@@ -5585,108 +4840,72 @@
2930 
2931 
2932 --
2933--- Name: strm_logfile_logfileid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2934+-- Name: sitetree_tree_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2935 --
2936 
2937-ALTER SEQUENCE strm_logfile_logfileid_seq OWNED BY strm_logfile.logfileid;
2938+ALTER SEQUENCE sitetree_tree_id_seq OWNED BY sitetree_tree.id;
2939 
2940 
2941 --
2942--- Name: strm_stream; Type: TABLE; Schema: public; Owner: -
2943+-- Name: sitetree_treeitem; Type: TABLE; Schema: public; Owner: -; Tablespace:
2944 --
2945 
2946-CREATE TABLE strm_stream (
2947-    streamid integer NOT NULL,
2948-    streamname character varying(255) NOT NULL
2949+CREATE TABLE sitetree_treeitem (
2950+    id integer NOT NULL,
2951+    title character varying(100) NOT NULL,
2952+    hint character varying(200) NOT NULL,
2953+    url character varying(200) NOT NULL,
2954+    urlaspattern boolean NOT NULL,
2955+    tree_id integer NOT NULL,
2956+    hidden boolean NOT NULL,
2957+    alias character varying(80),
2958+    description text NOT NULL,
2959+    inmenu boolean NOT NULL,
2960+    inbreadcrumbs boolean NOT NULL,
2961+    insitetree boolean NOT NULL,
2962+    access_loggedin boolean NOT NULL,
2963+    access_restricted boolean NOT NULL,
2964+    access_perm_type integer NOT NULL,
2965+    parent_id integer,
2966+    sort_order integer NOT NULL
2967 );
2968 
2969 
2970 --
2971--- Name: strm_stream_streamid_seq; Type: SEQUENCE; Schema: public; Owner: -
2972---
2973-
2974-CREATE SEQUENCE strm_stream_streamid_seq
2975-    START WITH 1
2976-    INCREMENT BY 1
2977-    NO MINVALUE
2978-    NO MAXVALUE
2979-    CACHE 1;
2980-
2981-
2982---
2983--- Name: strm_stream_streamid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
2984+-- Name: sitetree_treeitem_access_permissions; Type: TABLE; Schema: public; Owner: -; Tablespace:
2985 --
2986 
2987-ALTER SEQUENCE strm_stream_streamid_seq OWNED BY strm_stream.streamid;
2988-
2989-
2990---
2991--- Name: team; Type: TABLE; Schema: public; Owner: -
2992---
2993-
2994-CREATE TABLE team (
2995-    teamid integer DEFAULT nextval(('"team_teamid_seq"'::text)::regclass) NOT NULL,
2996-    team_name character varying(255) NOT NULL,
2997-    descr character varying(255),
2998-    local_group character varying(255),
2999-    local_alias character varying(255),
3000-    ordering smallint,
3001-    status character(1) DEFAULT 'c'::bpchar NOT NULL
3002+CREATE TABLE sitetree_treeitem_access_permissions (
3003+    id integer NOT NULL,
3004+    treeitem_id integer NOT NULL,
3005+    permission_id integer NOT NULL
3006 );
3007 
3008 
3009 --
3010--- Name: team_teamid_seq; Type: SEQUENCE; Schema: public; Owner: -
3011+-- Name: sitetree_treeitem_access_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3012 --
3013 
3014-CREATE SEQUENCE team_teamid_seq
3015+CREATE SEQUENCE sitetree_treeitem_access_permissions_id_seq
3016     START WITH 1
3017     INCREMENT BY 1
3018     NO MINVALUE
3019-    MAXVALUE 2147483647
3020+    NO MAXVALUE
3021     CACHE 1;
3022 
3023 
3024-SET default_with_oids = false;
3025-
3026---
3027--- Name: terms; Type: TABLE; Schema: public; Owner: -
3028---
3029-
3030-CREATE TABLE terms (
3031-    start timestamp with time zone NOT NULL,
3032-    descr character varying(10) NOT NULL,
3033-    finish timestamp with time zone NOT NULL,
3034-    termid integer NOT NULL
3035-);
3036-
3037-
3038---
3039--- Name: TABLE terms; Type: COMMENT; Schema: public; Owner: -
3040---
3041-
3042-COMMENT ON TABLE terms IS 'URY university term database.  Must be updated regularly.  Starts and finishes should be midnight UTC on the Monday of Weeks 1 and 11 respectively, NOT MIDNIGHT LOCAL TIME.';
3043-
3044-
3045---
3046--- Name: COLUMN terms.start; Type: COMMENT; Schema: public; Owner: -
3047---
3048-
3049-COMMENT ON COLUMN terms.start IS 'Midnight UTC, Monday Week 1';
3050-
3051-
3052 --
3053--- Name: COLUMN terms.finish; Type: COMMENT; Schema: public; Owner: -
3054+-- Name: sitetree_treeitem_access_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3055 --
3056 
3057-COMMENT ON COLUMN terms.finish IS 'Midnight UTC, Monday Week 11';
3058+ALTER SEQUENCE sitetree_treeitem_access_permissions_id_seq OWNED BY sitetree_treeitem_access_permissions.id;
3059 
3060 
3061 --
3062--- Name: terms_termid_seq; Type: SEQUENCE; Schema: public; Owner: -
3063+-- Name: sitetree_treeitem_id_seq; Type: SEQUENCE; Schema: public; Owner: -
3064 --
3065 
3066-CREATE SEQUENCE terms_termid_seq
3067+CREATE SEQUENCE sitetree_treeitem_id_seq
3068     START WITH 1
3069     INCREMENT BY 1
3070     NO MINVALUE
3071@@ -5695,74 +4914,73 @@
3072 
3073 
3074 --
3075--- Name: terms_termid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3076+-- Name: sitetree_treeitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3077 --
3078 
3079-ALTER SEQUENCE terms_termid_seq OWNED BY terms.termid;
3080-
3081+ALTER SEQUENCE sitetree_treeitem_id_seq OWNED BY sitetree_treeitem.id;
3082 
3083-SET search_path = rapier, pg_catalog;
3084 
3085 --
3086--- Name: acl_member; Type: TABLE; Schema: rapier; Owner: -
3087+-- Name: sso_session; Type: TABLE; Schema: public; Owner: -; Tablespace:
3088 --
3089 
3090-CREATE TABLE acl_member (
3091-    privilegeid integer NOT NULL,
3092-    memberid integer,
3093-    class text NOT NULL,
3094-    verb text NOT NULL,
3095-    scope integer DEFAULT 0 NOT NULL
3096+CREATE TABLE sso_session (
3097+    id character varying(32) NOT NULL,
3098+    data text,
3099+    "timestamp" timestamp without time zone NOT NULL
3100 );
3101 
3102 
3103---
3104--- Name: TABLE acl_member; Type: COMMENT; Schema: rapier; Owner: -
3105---
3106-
3107-COMMENT ON TABLE acl_member IS 'Access Control List for regular members (used to grant temporary and extraordinary permissions)';
3108-
3109-
3110---
3111--- Name: COLUMN acl_member.privilegeid; Type: COMMENT; Schema: rapier; Owner: -
3112---
3113-
3114-COMMENT ON COLUMN acl_member.privilegeid IS 'The unique ID of this ACL row.';
3115-
3116+SET default_with_oids = true;
3117 
3118 --
3119--- Name: COLUMN acl_member.memberid; Type: COMMENT; Schema: rapier; Owner: -
3120+-- Name: strm_useragent; Type: TABLE; Schema: public; Owner: -; Tablespace:
3121 --
3122 
3123-COMMENT ON COLUMN acl_member.memberid IS 'The unique ID of the member being granted a permission.';
3124+CREATE TABLE strm_useragent (
3125+    useragentid integer NOT NULL,
3126+    useragent character varying(255) NOT NULL
3127+);
3128 
3129 
3130 --
3131--- Name: COLUMN acl_member.class; Type: COMMENT; Schema: rapier; Owner: -
3132+-- Name: strm_client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: -
3133 --
3134 
3135-COMMENT ON COLUMN acl_member.class IS 'The full name of the Rapier object class a permission is being granted for.';
3136+CREATE SEQUENCE strm_client_clientid_seq
3137+    START WITH 1
3138+    INCREMENT BY 1
3139+    NO MINVALUE
3140+    NO MAXVALUE
3141+    CACHE 1;
3142 
3143 
3144 --
3145--- Name: COLUMN acl_member.verb; Type: COMMENT; Schema: rapier; Owner: -
3146+-- Name: strm_client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3147 --
3148 
3149-COMMENT ON COLUMN acl_member.verb IS 'The verb (eg "read") representing the privileged action being granted.';
3150+ALTER SEQUENCE strm_client_clientid_seq OWNED BY strm_useragent.useragentid;
3151 
3152 
3153 --
3154--- Name: COLUMN acl_member.scope; Type: COMMENT; Schema: rapier; Owner: -
3155+-- Name: strm_log; Type: TABLE; Schema: public; Owner: -; Tablespace:
3156 --
3157 
3158-COMMENT ON COLUMN acl_member.scope IS 'The scope of this action being granted. (see constants_acl_scope).';
3159+CREATE TABLE strm_log (
3160+    logid integer NOT NULL,
3161+    streamid integer NOT NULL,
3162+    useragentid integer NOT NULL,
3163+    starttime timestamp with time zone NOT NULL,
3164+    endtime timestamp with time zone NOT NULL,
3165+    ipaddr inet NOT NULL
3166+);
3167 
3168 
3169 --
3170--- Name: acl_member_privilegeid_seq; Type: SEQUENCE; Schema: rapier; Owner: -
3171+-- Name: strm_log_logid_seq; Type: SEQUENCE; Schema: public; Owner: -
3172 --
3173 
3174-CREATE SEQUENCE acl_member_privilegeid_seq
3175+CREATE SEQUENCE strm_log_logid_seq
3176     START WITH 1
3177     INCREMENT BY 1
3178     NO MINVALUE
3179@@ -5771,37 +4989,28 @@
3180 
3181 
3182 --
3183--- Name: acl_member_privilegeid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: -
3184+-- Name: strm_log_logid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3185 --
3186 
3187-ALTER SEQUENCE acl_member_privilegeid_seq OWNED BY acl_member.privilegeid;
3188+ALTER SEQUENCE strm_log_logid_seq OWNED BY strm_log.logid;
3189 
3190 
3191 --
3192--- Name: acl_officer; Type: TABLE; Schema: rapier; Owner: -
3193+-- Name: strm_logfile; Type: TABLE; Schema: public; Owner: -; Tablespace:
3194 --
3195 
3196-CREATE TABLE acl_officer (
3197-    privilegeid integer DEFAULT nextval('acl_member_privilegeid_seq'::regclass) NOT NULL,
3198-    officerid integer NOT NULL,
3199-    class text NOT NULL,
3200-    verb text NOT NULL,
3201-    scope integer DEFAULT 0 NOT NULL
3202+CREATE TABLE strm_logfile (
3203+    logfileid integer NOT NULL,
3204+    filename character varying(255) NOT NULL,
3205+    lastsize integer
3206 );
3207 
3208 
3209 --
3210--- Name: COLUMN acl_officer.class; Type: COMMENT; Schema: rapier; Owner: -
3211---
3212-
3213-COMMENT ON COLUMN acl_officer.class IS 'The full name of the Rapier object class a permission is being granted for.';
3214-
3215-
3216---
3217--- Name: acl_officer_privilegeid_seq; Type: SEQUENCE; Schema: rapier; Owner: -
3218+-- Name: strm_logfile_logfileid_seq; Type: SEQUENCE; Schema: public; Owner: -
3219 --
3220 
3221-CREATE SEQUENCE acl_officer_privilegeid_seq
3222+CREATE SEQUENCE strm_logfile_logfileid_seq
3223     START WITH 1
3224     INCREMENT BY 1
3225     NO MINVALUE
3226@@ -5810,108 +5019,109 @@
3227 
3228 
3229 --
3230--- Name: client; Type: TABLE; Schema: rapier; Owner: -
3231---
3232-
3233-CREATE TABLE client (
3234-    clientid integer NOT NULL,
3235-    name text NOT NULL,
3236-    secrethash text NOT NULL,
3237-    description text
3238-);
3239-
3240-
3241---
3242--- Name: TABLE client; Type: COMMENT; Schema: rapier; Owner: -
3243+-- Name: strm_logfile_logfileid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3244 --
3245 
3246-COMMENT ON TABLE client IS 'Registry of clients allowed to use Rapier.';
3247+ALTER SEQUENCE strm_logfile_logfileid_seq OWNED BY strm_logfile.logfileid;
3248 
3249 
3250 --
3251--- Name: COLUMN client.clientid; Type: COMMENT; Schema: rapier; Owner: -
3252+-- Name: strm_stream; Type: TABLE; Schema: public; Owner: -; Tablespace:
3253 --
3254 
3255-COMMENT ON COLUMN client.clientid IS 'The numeric ID of the client.';
3256+CREATE TABLE strm_stream (
3257+    streamid integer NOT NULL,
3258+    streamname character varying(255) NOT NULL
3259+);
3260 
3261 
3262 --
3263--- Name: COLUMN client.name; Type: COMMENT; Schema: rapier; Owner: -
3264+-- Name: strm_stream_streamid_seq; Type: SEQUENCE; Schema: public; Owner: -
3265 --
3266 
3267-COMMENT ON COLUMN client.name IS 'The log-in name of the client.';
3268+CREATE SEQUENCE strm_stream_streamid_seq
3269+    START WITH 1
3270+    INCREMENT BY 1
3271+    NO MINVALUE
3272+    NO MAXVALUE
3273+    CACHE 1;
3274 
3275 
3276 --
3277--- Name: COLUMN client.secrethash; Type: COMMENT; Schema: rapier; Owner: -
3278+-- Name: strm_stream_streamid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3279 --
3280 
3281-COMMENT ON COLUMN client.secrethash IS 'A hash of the log-in password of the client.';
3282+ALTER SEQUENCE strm_stream_streamid_seq OWNED BY strm_stream.streamid;
3283 
3284 
3285 --
3286--- Name: COLUMN client.description; Type: COMMENT; Schema: rapier; Owner: -
3287+-- Name: team; Type: TABLE; Schema: public; Owner: -; Tablespace:
3288 --
3289 
3290-COMMENT ON COLUMN client.description IS 'A human-readable description of the client.';
3291+CREATE TABLE team (
3292+    teamid integer DEFAULT nextval(('"team_teamid_seq"'::text)::regclass) NOT NULL,
3293+    team_name character varying(255) NOT NULL,
3294+    descr character varying(255),
3295+    local_group character varying(255),
3296+    local_alias character varying(255),
3297+    ordering smallint,
3298+    status character(1) DEFAULT 'c'::bpchar NOT NULL
3299+);
3300 
3301 
3302 --
3303--- Name: client_clientid_seq; Type: SEQUENCE; Schema: rapier; Owner: -
3304+-- Name: team_teamid_seq; Type: SEQUENCE; Schema: public; Owner: -
3305 --
3306 
3307-CREATE SEQUENCE client_clientid_seq
3308+CREATE SEQUENCE team_teamid_seq
3309     START WITH 1
3310     INCREMENT BY 1
3311     NO MINVALUE
3312-    NO MAXVALUE
3313+    MAXVALUE 2147483647
3314     CACHE 1;
3315 
3316 
3317---
3318--- Name: client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: -
3319---
3320-
3321-ALTER SEQUENCE client_clientid_seq OWNED BY client.clientid;
3322-
3323+SET default_with_oids = false;
3324 
3325 --
3326--- Name: constants_acl_scope; Type: TABLE; Schema: rapier; Owner: -
3327+-- Name: terms; Type: TABLE; Schema: public; Owner: -; Tablespace:
3328 --
3329 
3330-CREATE TABLE constants_acl_scope (
3331-    scopeid integer NOT NULL,
3332-    description text NOT NULL
3333+CREATE TABLE terms (
3334+    start timestamp with time zone NOT NULL,
3335+    descr character varying(10) NOT NULL,
3336+    finish timestamp with time zone NOT NULL,
3337+    termid integer NOT NULL
3338 );
3339 
3340 
3341 --
3342--- Name: TABLE constants_acl_scope; Type: COMMENT; Schema: rapier; Owner: -
3343+-- Name: TABLE terms; Type: COMMENT; Schema: public; Owner: -
3344 --
3345 
3346-COMMENT ON TABLE constants_acl_scope IS 'Human-readable descriptions for the ACL scope levels.';
3347+COMMENT ON TABLE terms IS 'URY university term database.  Must be updated regularly.  Starts and finishes should be midnight UTC on the Monday of Weeks 1 and 11 respectively, NOT MIDNIGHT LOCAL TIME.';
3348 
3349 
3350 --
3351--- Name: COLUMN constants_acl_scope.scopeid; Type: COMMENT; Schema: rapier; Owner: -
3352+-- Name: COLUMN terms.start; Type: COMMENT; Schema: public; Owner: -
3353 --
3354 
3355-COMMENT ON COLUMN constants_acl_scope.scopeid IS 'The unique ID of this scope level.';
3356+COMMENT ON COLUMN terms.start IS 'Midnight UTC, Monday Week 1';
3357 
3358 
3359 --
3360--- Name: COLUMN constants_acl_scope.description; Type: COMMENT; Schema: rapier; Owner: -
3361+-- Name: COLUMN terms.finish; Type: COMMENT; Schema: public; Owner: -
3362 --
3363 
3364-COMMENT ON COLUMN constants_acl_scope.description IS 'The human-readable description of this scope level.';
3365+COMMENT ON COLUMN terms.finish IS 'Midnight UTC, Monday Week 11';
3366 
3367 
3368 --
3369--- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE; Schema: rapier; Owner: -
3370+-- Name: terms_termid_seq; Type: SEQUENCE; Schema: public; Owner: -
3371 --
3372 
3373-CREATE SEQUENCE constants_acl_scope_scopeid_seq
3374-    START WITH 3
3375+CREATE SEQUENCE terms_termid_seq
3376+    START WITH 1
3377     INCREMENT BY 1
3378     NO MINVALUE
3379     NO MAXVALUE
3380@@ -5919,16 +5129,16 @@
3381 
3382 
3383 --
3384--- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: -
3385+-- Name: terms_termid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
3386 --
3387 
3388-ALTER SEQUENCE constants_acl_scope_scopeid_seq OWNED BY constants_acl_scope.scopeid;
3389+ALTER SEQUENCE terms_termid_seq OWNED BY terms.termid;
3390 
3391 
3392 SET search_path = schedule, pg_catalog;
3393 
3394 --
3395--- Name: block; Type: TABLE; Schema: schedule; Owner: -
3396+-- Name: block; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3397 --
3398 
3399 CREATE TABLE block (
3400@@ -6010,7 +5220,7 @@
3401 
3402 
3403 --
3404--- Name: block_range_rule; Type: TABLE; Schema: schedule; Owner: -
3405+-- Name: block_range_rule; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3406 --
3407 
3408 CREATE TABLE block_range_rule (
3409@@ -6026,7 +5236,6 @@
3410 --
3411 
3412 COMMENT ON TABLE block_range_rule IS 'Block rules that associate timeslots falling into given ranges with corresponding blocks.
3413-
3414 This is the lowest priority rule type.';
3415 
3416 
3417@@ -6090,7 +5299,7 @@
3418 
3419 
3420 --
3421--- Name: block_show_rule; Type: TABLE; Schema: schedule; Owner: -
3422+-- Name: block_show_rule; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3423 --
3424 
3425 CREATE TABLE block_show_rule (
3426@@ -6105,7 +5314,6 @@
3427 --
3428 
3429 COMMENT ON TABLE block_show_rule IS 'A block show rule matches all timeslots of a given show to a given block.
3430-
3431 This rule scheme takes precedence over any other scheme except direct timeslot assignment.';
3432 
3433 
3434@@ -6150,7 +5358,7 @@
3435 
3436 
3437 --
3438--- Name: genre; Type: TABLE; Schema: schedule; Owner: -
3439+-- Name: genre; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3440 --
3441 
3442 CREATE TABLE genre (
3443@@ -6179,7 +5387,7 @@
3444 
3445 
3446 --
3447--- Name: location; Type: TABLE; Schema: schedule; Owner: -
3448+-- Name: location; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3449 --
3450 
3451 CREATE TABLE location (
3452@@ -6234,7 +5442,7 @@
3453 
3454 
3455 --
3456--- Name: season_metadata; Type: TABLE; Schema: schedule; Owner: -
3457+-- Name: season_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3458 --
3459 
3460 CREATE TABLE season_metadata (
3461@@ -6306,7 +5514,7 @@
3462 
3463 
3464 --
3465--- Name: show_credit; Type: TABLE; Schema: schedule; Owner: -
3466+-- Name: show_credit; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3467 --
3468 
3469 CREATE TABLE show_credit (
3470@@ -6348,7 +5556,7 @@
3471 
3472 
3473 --
3474--- Name: show_genre; Type: TABLE; Schema: schedule; Owner: -
3475+-- Name: show_genre; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3476 --
3477 
3478 CREATE TABLE show_genre (
3479@@ -6382,7 +5590,7 @@
3480 
3481 
3482 --
3483--- Name: show_image_metadata; Type: TABLE; Schema: schedule; Owner: -
3484+-- Name: show_image_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3485 --
3486 
3487 CREATE TABLE show_image_metadata (
3488@@ -6417,7 +5625,7 @@
3489 
3490 
3491 --
3492--- Name: show_location; Type: TABLE; Schema: schedule; Owner: -
3493+-- Name: show_location; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3494 --
3495 
3496 CREATE TABLE show_location (
3497@@ -6470,7 +5678,7 @@
3498 
3499 
3500 --
3501--- Name: show_podcast_link; Type: TABLE; Schema: schedule; Owner: -
3502+-- Name: show_podcast_link; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3503 --
3504 
3505 CREATE TABLE show_podcast_link (
3506@@ -6480,7 +5688,7 @@
3507 
3508 
3509 --
3510--- Name: show_season_requested_time; Type: TABLE; Schema: schedule; Owner: -
3511+-- Name: show_season_requested_time; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3512 --
3513 
3514 CREATE TABLE show_season_requested_time (
3515@@ -6548,7 +5756,7 @@
3516 
3517 
3518 --
3519--- Name: show_season_requested_week; Type: TABLE; Schema: schedule; Owner: -
3520+-- Name: show_season_requested_week; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3521 --
3522 
3523 CREATE TABLE show_season_requested_week (
3524@@ -6642,7 +5850,6 @@
3525 --
3526 
3527 COMMENT ON VIEW show_season_timeslot_credit IS 'Removed:
3528-
3529   WHERE show_credit.effective_from IS NOT NULL AND show_credit.effective_from <= show_season_timeslot.start_time AND (show_credit.effective_to IS NULL OR show_credit.effective_to >= (show_season_timeslot.start_time + show_season_timeslot.duration));';
3530 
3531 
3532@@ -6666,7 +5873,7 @@
3533 
3534 
3535 --
3536--- Name: timeslot_metadata; Type: TABLE; Schema: schedule; Owner: -
3537+-- Name: timeslot_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3538 --
3539 
3540 CREATE TABLE timeslot_metadata (
3541@@ -6740,7 +5947,7 @@
3542 
3543 
3544 --
3545--- Name: show_type; Type: TABLE; Schema: schedule; Owner: -
3546+-- Name: show_type; Type: TABLE; Schema: schedule; Owner: -; Tablespace:
3547 --
3548 
3549 CREATE TABLE show_type (
3550@@ -6844,7 +6051,7 @@
3551 SET search_path = sis2, pg_catalog;
3552 
3553 --
3554--- Name: config; Type: TABLE; Schema: sis2; Owner: -
3555+-- Name: config; Type: TABLE; Schema: sis2; Owner: -; Tablespace:
3556 --
3557 
3558 CREATE TABLE config (
3559@@ -6854,7 +6061,7 @@
3560 
3561 
3562 --
3563--- Name: member_options; Type: TABLE; Schema: sis2; Owner: -
3564+-- Name: member_options; Type: TABLE; Schema: sis2; Owner: -; Tablespace:
3565 --
3566 
3567 CREATE TABLE member_options (
3568@@ -6864,7 +6071,7 @@
3569 
3570 
3571 --
3572--- Name: member_signin; Type: TABLE; Schema: sis2; Owner: -
3573+-- Name: member_signin; Type: TABLE; Schema: sis2; Owner: -; Tablespace:
3574 --
3575 
3576 CREATE TABLE member_signin (
3577@@ -6938,7 +6145,7 @@
3578 
3579 
3580 --
3581--- Name: messages; Type: TABLE; Schema: sis2; Owner: -
3582+-- Name: messages; Type: TABLE; Schema: sis2; Owner: -; Tablespace:
3583 --
3584 
3585 CREATE TABLE messages (
3586@@ -6980,281 +6187,10 @@
3587 ALTER SEQUENCE messages_commid_seq OWNED BY messages.commid;
3588 
3589 
3590-SET search_path = smsd, pg_catalog;
3591-
3592---
3593--- Name: daemons; Type: TABLE; Schema: smsd; Owner: -
3594---
3595-
3596-CREATE TABLE daemons (
3597-    "Start" text NOT NULL,
3598-    "Info" text NOT NULL
3599-);
3600-
3601-
3602---
3603--- Name: gammu; Type: TABLE; Schema: smsd; Owner: -
3604---
3605-
3606-CREATE TABLE gammu (
3607-    "Version" smallint DEFAULT (0)::smallint NOT NULL
3608-);
3609-
3610-
3611---
3612--- Name: inbox; Type: TABLE; Schema: smsd; Owner: -
3613---
3614-
3615-CREATE TABLE inbox (
3616-    "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3617-    "ReceivingDateTime" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3618-    "Text" text NOT NULL,
3619-    "SenderNumber" character varying(20) DEFAULT ''::character varying NOT NULL,
3620-    "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL,
3621-    "UDH" text NOT NULL,
3622-    "SMSCNumber" character varying(20) DEFAULT ''::character varying NOT NULL,
3623-    "Class" integer DEFAULT '-1'::integer NOT NULL,
3624-    "TextDecoded" text DEFAULT ''::text NOT NULL,
3625-    "ID" integer NOT NULL,
3626-    "RecipientID" text NOT NULL,
3627-    "Processed" boolean DEFAULT false NOT NULL,
3628-    CONSTRAINT "inbox_Coding_check" CHECK ((("Coding")::text = ANY (ARRAY[('Default_No_Compression'::character varying)::text, ('Unicode_No_Compression'::character varying)::text, ('8bit'::character varying)::text, ('Default_Compression'::character varying)::text, ('Unicode_Compression'::character varying)::text])))
3629-);
3630-
3631-
3632---
3633--- Name: inbox_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3634---
3635-
3636-CREATE SEQUENCE "inbox_ID_seq"
3637-    START WITH 1
3638-    INCREMENT BY 1
3639-    NO MINVALUE
3640-    NO MAXVALUE
3641-    CACHE 1;
3642-
3643-
3644---
3645--- Name: inbox_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3646---
3647-
3648-ALTER SEQUENCE "inbox_ID_seq" OWNED BY inbox."ID";
3649-
3650-
3651---
3652--- Name: outbox; Type: TABLE; Schema: smsd; Owner: -
3653---
3654-
3655-CREATE TABLE outbox (
3656-    "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3657-    "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3658-    "SendingDateTime" timestamp without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3659-    "SendBefore" time without time zone DEFAULT '23:59:59'::time without time zone NOT NULL,
3660-    "SendAfter" time without time zone DEFAULT '00:00:00'::time without time zone NOT NULL,
3661-    "Text" text,
3662-    "DestinationNumber" character varying(20) DEFAULT ''::character varying NOT NULL,
3663-    "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL,
3664-    "UDH" text,
3665-    "Class" integer DEFAULT '-1'::integer,
3666-    "TextDecoded" text DEFAULT ''::text NOT NULL,
3667-    "ID" integer NOT NULL,
3668-    "MultiPart" boolean DEFAULT false NOT NULL,
3669-    "RelativeValidity" integer DEFAULT '-1'::integer,
3670-    "SenderID" character varying(255),
3671-    "SendingTimeOut" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3672-    "DeliveryReport" character varying(10) DEFAULT 'default'::character varying,
3673-    "CreatorID" text NOT NULL,
3674-    CONSTRAINT "outbox_Coding_check" CHECK ((("Coding")::text = ANY (ARRAY[('Default_No_Compression'::character varying)::text, ('Unicode_No_Compression'::character varying)::text, ('8bit'::character varying)::text, ('Default_Compression'::character varying)::text, ('Unicode_Compression'::character varying)::text]))),
3675-    CONSTRAINT "outbox_DeliveryReport_check" CHECK ((("DeliveryReport")::text = ANY (ARRAY[('default'::character varying)::text, ('yes'::character varying)::text, ('no'::character varying)::text])))
3676-);
3677-
3678-
3679---
3680--- Name: outbox_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3681---
3682-
3683-CREATE SEQUENCE "outbox_ID_seq"
3684-    START WITH 1
3685-    INCREMENT BY 1
3686-    NO MINVALUE
3687-    NO MAXVALUE
3688-    CACHE 1;
3689-
3690-
3691---
3692--- Name: outbox_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3693---
3694-
3695-ALTER SEQUENCE "outbox_ID_seq" OWNED BY outbox."ID";
3696-
3697-
3698---
3699--- Name: outbox_multipart; Type: TABLE; Schema: smsd; Owner: -
3700---
3701-
3702-CREATE TABLE outbox_multipart (
3703-    "Text" text,
3704-    "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL,
3705-    "UDH" text,
3706-    "Class" integer DEFAULT '-1'::integer,
3707-    "TextDecoded" text,
3708-    "ID" integer NOT NULL,
3709-    "SequencePosition" integer DEFAULT 1 NOT NULL,
3710-    CONSTRAINT "outbox_multipart_Coding_check" CHECK ((("Coding")::text = ANY (ARRAY[('Default_No_Compression'::character varying)::text, ('Unicode_No_Compression'::character varying)::text, ('8bit'::character varying)::text, ('Default_Compression'::character varying)::text, ('Unicode_Compression'::character varying)::text])))
3711-);
3712-
3713-
3714---
3715--- Name: outbox_multipart_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3716---
3717-
3718-CREATE SEQUENCE "outbox_multipart_ID_seq"
3719-    START WITH 1
3720-    INCREMENT BY 1
3721-    NO MINVALUE
3722-    NO MAXVALUE
3723-    CACHE 1;
3724-
3725-
3726---
3727--- Name: outbox_multipart_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3728---
3729-
3730-ALTER SEQUENCE "outbox_multipart_ID_seq" OWNED BY outbox_multipart."ID";
3731-
3732-
3733---
3734--- Name: pbk; Type: TABLE; Schema: smsd; Owner: -
3735---
3736-
3737-CREATE TABLE pbk (
3738-    "ID" integer NOT NULL,
3739-    "GroupID" integer DEFAULT '-1'::integer NOT NULL,
3740-    "Name" text NOT NULL,
3741-    "Number" text NOT NULL
3742-);
3743-
3744-
3745---
3746--- Name: pbk_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3747---
3748-
3749-CREATE SEQUENCE "pbk_ID_seq"
3750-    START WITH 1
3751-    INCREMENT BY 1
3752-    NO MINVALUE
3753-    NO MAXVALUE
3754-    CACHE 1;
3755-
3756-
3757---
3758--- Name: pbk_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3759---
3760-
3761-ALTER SEQUENCE "pbk_ID_seq" OWNED BY pbk."ID";
3762-
3763-
3764---
3765--- Name: pbk_groups; Type: TABLE; Schema: smsd; Owner: -
3766---
3767-
3768-CREATE TABLE pbk_groups (
3769-    "Name" text NOT NULL,
3770-    "ID" integer NOT NULL
3771-);
3772-
3773-
3774---
3775--- Name: pbk_groups_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3776---
3777-
3778-CREATE SEQUENCE "pbk_groups_ID_seq"
3779-    START WITH 1
3780-    INCREMENT BY 1
3781-    NO MINVALUE
3782-    NO MAXVALUE
3783-    CACHE 1;
3784-
3785-
3786---
3787--- Name: pbk_groups_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3788---
3789-
3790-ALTER SEQUENCE "pbk_groups_ID_seq" OWNED BY pbk_groups."ID";
3791-
3792-
3793---
3794--- Name: phones; Type: TABLE; Schema: smsd; Owner: -
3795---
3796-
3797-CREATE TABLE phones (
3798-    "ID" text NOT NULL,
3799-    "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3800-    "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3801-    "TimeOut" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3802-    "Send" boolean DEFAULT false NOT NULL,
3803-    "Receive" boolean DEFAULT false NOT NULL,
3804-    "IMEI" character varying(35) NOT NULL,
3805-    "Client" text NOT NULL,
3806-    "Battery" integer DEFAULT '-1'::integer NOT NULL,
3807-    "Signal" integer DEFAULT '-1'::integer NOT NULL,
3808-    "Sent" integer DEFAULT 0 NOT NULL,
3809-    "Received" integer DEFAULT 0 NOT NULL
3810-);
3811-
3812-
3813---
3814--- Name: sentitems; Type: TABLE; Schema: smsd; Owner: -
3815---
3816-
3817-CREATE TABLE sentitems (
3818-    "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3819-    "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3820-    "SendingDateTime" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL,
3821-    "DeliveryDateTime" timestamp(0) without time zone,
3822-    "Text" text NOT NULL,
3823-    "DestinationNumber" character varying(20) DEFAULT ''::character varying NOT NULL,
3824-    "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL,
3825-    "UDH" text NOT NULL,
3826-    "SMSCNumber" character varying(20) DEFAULT ''::character varying NOT NULL,
3827-    "Class" integer DEFAULT '-1'::integer NOT NULL,
3828-    "TextDecoded" text DEFAULT ''::text NOT NULL,
3829-    "ID" integer NOT NULL,
3830-    "SenderID" character varying(255) NOT NULL,
3831-    "SequencePosition" integer DEFAULT 1 NOT NULL,
3832-    "Status" character varying(255) DEFAULT 'SendingOK'::character varying NOT NULL,
3833-    "StatusError" integer DEFAULT '-1'::integer NOT NULL,
3834-    "TPMR" integer DEFAULT '-1'::integer NOT NULL,
3835-    "RelativeValidity" integer DEFAULT '-1'::integer NOT NULL,
3836-    "CreatorID" text NOT NULL,
3837-    CONSTRAINT "sentitems_Coding_check" CHECK ((("Coding")::text = ANY (ARRAY[('Default_No_Compression'::character varying)::text, ('Unicode_No_Compression'::character varying)::text, ('8bit'::character varying)::text, ('Default_Compression'::character varying)::text, ('Unicode_Compression'::character varying)::text]))),
3838-    CONSTRAINT "sentitems_Status_check" CHECK ((("Status")::text = ANY (ARRAY[('SendingOK'::character varying)::text, ('SendingOKNoReport'::character varying)::text, ('SendingError'::character varying)::text, ('DeliveryOK'::character varying)::text, ('DeliveryFailed'::character varying)::text, ('DeliveryPending'::character varying)::text, ('DeliveryUnknown'::character varying)::text, ('Error'::character varying)::text])))
3839-);
3840-
3841-
3842---
3843--- Name: sentitems_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: -
3844---
3845-
3846-CREATE SEQUENCE "sentitems_ID_seq"
3847-    START WITH 1
3848-    INCREMENT BY 1
3849-    NO MINVALUE
3850-    NO MAXVALUE
3851-    CACHE 1;
3852-
3853-
3854---
3855--- Name: sentitems_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: -
3856---
3857-
3858-ALTER SEQUENCE "sentitems_ID_seq" OWNED BY sentitems."ID";
3859-
3860-
3861 SET search_path = tracklist, pg_catalog;
3862 
3863 --
3864--- Name: selbaps; Type: TABLE; Schema: tracklist; Owner: -
3865+-- Name: selbaps; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3866 --
3867 
3868 CREATE TABLE selbaps (
3869@@ -7271,7 +6207,7 @@
3870 
3871 
3872 --
3873--- Name: source; Type: TABLE; Schema: tracklist; Owner: -
3874+-- Name: source; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3875 --
3876 
3877 CREATE TABLE source (
3878@@ -7288,7 +6224,7 @@
3879 
3880 
3881 --
3882--- Name: state; Type: TABLE; Schema: tracklist; Owner: -
3883+-- Name: state; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3884 --
3885 
3886 CREATE TABLE state (
3887@@ -7305,7 +6241,7 @@
3888 
3889 
3890 --
3891--- Name: track_notrec; Type: TABLE; Schema: tracklist; Owner: -
3892+-- Name: track_notrec; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3893 --
3894 
3895 CREATE TABLE track_notrec (
3896@@ -7327,7 +6263,7 @@
3897 
3898 
3899 --
3900--- Name: track_rec; Type: TABLE; Schema: tracklist; Owner: -
3901+-- Name: track_rec; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3902 --
3903 
3904 CREATE TABLE track_rec (
3905@@ -7345,7 +6281,7 @@
3906 
3907 
3908 --
3909--- Name: tracklist; Type: TABLE; Schema: tracklist; Owner: -
3910+-- Name: tracklist; Type: TABLE; Schema: tracklist; Owner: -; Tablespace:
3911 --
3912 
3913 CREATE TABLE tracklist (
3914@@ -7388,7 +6324,7 @@
3915 SET search_path = uryplayer, pg_catalog;
3916 
3917 --
3918--- Name: podcast; Type: TABLE; Schema: uryplayer; Owner: -
3919+-- Name: podcast; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace:
3920 --
3921 
3922 CREATE TABLE podcast (
3923@@ -7402,7 +6338,7 @@
3924 
3925 
3926 --
3927--- Name: podcast_credit; Type: TABLE; Schema: uryplayer; Owner: -
3928+-- Name: podcast_credit; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace:
3929 --
3930 
3931 CREATE TABLE podcast_credit (
3932@@ -7437,7 +6373,7 @@
3933 
3934 
3935 --
3936--- Name: podcast_image_metadata; Type: TABLE; Schema: uryplayer; Owner: -
3937+-- Name: podcast_image_metadata; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace:
3938 --
3939 
3940 CREATE TABLE podcast_image_metadata (
3941@@ -7472,7 +6408,7 @@
3942 
3943 
3944 --
3945--- Name: podcast_metadata; Type: TABLE; Schema: uryplayer; Owner: -
3946+-- Name: podcast_metadata; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace:
3947 --
3948 
3949 CREATE TABLE podcast_metadata (
3950@@ -7507,7 +6443,7 @@
3951 
3952 
3953 --
3954--- Name: podcast_package_entry; Type: TABLE; Schema: uryplayer; Owner: -
3955+-- Name: podcast_package_entry; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace:
3956 --
3957 
3958 CREATE TABLE podcast_package_entry (
3959@@ -7578,7 +6514,7 @@
3960 SET search_path = webcam, pg_catalog;
3961 
3962 --
3963--- Name: memberviews; Type: TABLE; Schema: webcam; Owner: -
3964+-- Name: memberviews; Type: TABLE; Schema: webcam; Owner: -; Tablespace:
3965 --
3966 
3967 CREATE TABLE memberviews (
3968@@ -7588,15 +6524,14 @@
3969 
3970 
3971 --
3972--- Name: streams; Type: TABLE; Schema: webcam; Owner: -
3973+-- Name: streams; Type: TABLE; Schema: webcam; Owner: -; Tablespace:
3974 --
3975 
3976 CREATE TABLE streams (
3977     streamid integer NOT NULL,
3978     streamname character varying NOT NULL,
3979     liveurl character varying NOT NULL,
3980-    staticurl character varying NOT NULL,
3981-    camera text
3982+    staticurl character varying NOT NULL
3983 );
3984 
3985 
3986@@ -7604,7 +6539,7 @@
3987 -- Name: TABLE streams; Type: COMMENT; Schema: webcam; Owner: -
3988 --
3989 
3990-COMMENT ON TABLE streams IS 'Stores a list of streams available on MyURY';
3991+COMMENT ON TABLE streams IS 'Stores a list of streams available on MyRadio';
3992 
3993 
3994 --
3995@@ -7629,7 +6564,7 @@
3996 SET search_path = website, pg_catalog;
3997 
3998 --
3999--- Name: banner; Type: TABLE; Schema: website; Owner: -
4000+-- Name: banner; Type: TABLE; Schema: website; Owner: -; Tablespace:
4001 --
4002 
4003 CREATE TABLE banner (
4004@@ -7646,7 +6581,7 @@
4005 -- Name: COLUMN banner.photoid; Type: COMMENT; Schema: website; Owner: -
4006 --
4007 
4008-COMMENT ON COLUMN banner.photoid IS 'The corresponding MyURY Photo ID, if one exists.';
4009+COMMENT ON COLUMN banner.photoid IS 'The corresponding MyRadio Photo ID, if one exists.';
4010 
4011 
4012 --
4013@@ -7669,7 +6604,41 @@
4014 
4015 
4016 --
4017--- Name: banner_location; Type: TABLE; Schema: website; Owner: -
4018+-- Name: banner_campaign; Type: TABLE; Schema: website; Owner: -; Tablespace:
4019+--
4020+
4021+CREATE TABLE banner_campaign (
4022+    memberid integer,
4023+    approvedid integer,
4024+    effective_from timestamp with time zone NOT NULL,
4025+    effective_to timestamp with time zone,
4026+    banner_campaign_id integer NOT NULL,
4027+    banner_location_id integer NOT NULL,
4028+    banner_id integer NOT NULL
4029+);
4030+
4031+
4032+--
4033+-- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE; Schema: website; Owner: -
4034+--
4035+
4036+CREATE SEQUENCE banner_campaign_banner_campaign_id_seq
4037+    START WITH 1
4038+    INCREMENT BY 1
4039+    NO MINVALUE
4040+    NO MAXVALUE
4041+    CACHE 1;
4042+
4043+
4044+--
4045+-- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: website; Owner: -
4046+--
4047+
4048+ALTER SEQUENCE banner_campaign_banner_campaign_id_seq OWNED BY banner_campaign.banner_campaign_id;
4049+
4050+
4051+--
4052+-- Name: banner_location; Type: TABLE; Schema: website; Owner: -; Tablespace:
4053 --
4054 
4055 CREATE TABLE banner_location (
4056@@ -7699,7 +6668,7 @@
4057 
4058 
4059 --
4060--- Name: banner_timeslot; Type: TABLE; Schema: website; Owner: -
4061+-- Name: banner_timeslot; Type: TABLE; Schema: website; Owner: -; Tablespace:
4062 --
4063 
4064 CREATE TABLE banner_timeslot (
4065@@ -7750,7 +6719,7 @@
4066 
4067 
4068 --
4069--- Name: banner_type; Type: TABLE; Schema: website; Owner: -
4070+-- Name: banner_type; Type: TABLE; Schema: website; Owner: -; Tablespace:
4071 --
4072 
4073 CREATE TABLE banner_type (
4074@@ -7782,20 +6751,6 @@
4075 SET search_path = bapsplanner, pg_catalog;
4076 
4077 --
4078--- Name: client_id; Type: DEFAULT; Schema: bapsplanner; Owner: -
4079---
4080-
4081-ALTER TABLE ONLY client_ids ALTER COLUMN client_id SET DEFAULT nextval('client_ids_client_id_seq'::regclass);
4082-
4083-
4084---
4085--- Name: manageditemid; Type: DEFAULT; Schema: bapsplanner; Owner: -
4086---
4087-
4088-ALTER TABLE ONLY managed_items ALTER COLUMN manageditemid SET DEFAULT nextval('managed_items_manageditemid_seq'::regclass);
4089-
4090-
4091---
4092 -- Name: managedplaylistid; Type: DEFAULT; Schema: bapsplanner; Owner: -
4093 --
4094 
4095@@ -7967,13 +6922,6 @@
4096 
4097 
4098 --
4099--- Name: contract_version_id; Type: DEFAULT; Schema: myury; Owner: -
4100---
4101-
4102-ALTER TABLE ONLY contract_versions ALTER COLUMN contract_version_id SET DEFAULT nextval('contract_versions_contract_version_id_seq'::regclass);
4103-
4104-
4105---
4106 -- Name: request_id; Type: DEFAULT; Schema: myury; Owner: -
4107 --
4108 
4109@@ -8069,6 +7017,13 @@
4110 SET search_path = public, pg_catalog;
4111 
4112 --
4113+-- Name: privilegeid; Type: DEFAULT; Schema: public; Owner: -
4114+--
4115+
4116+ALTER TABLE ONLY acl_member ALTER COLUMN privilegeid SET DEFAULT nextval('acl_member_privilegeid_seq'::regclass);
4117+
4118+
4119+--
4120 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
4121 --
4122 
4123@@ -8079,6 +7034,13 @@
4124 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
4125 --
4126 
4127+ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);
4128+
4129+
4130+--
4131+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
4132+--
4133+
4134 ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);
4135 
4136 
4137@@ -8181,6 +7143,20 @@
4138 
4139 
4140 --
4141+-- Name: clientid; Type: DEFAULT; Schema: public; Owner: -
4142+--
4143+
4144+ALTER TABLE ONLY client ALTER COLUMN clientid SET DEFAULT nextval('client_clientid_seq'::regclass);
4145+
4146+
4147+--
4148+-- Name: scopeid; Type: DEFAULT; Schema: public; Owner: -
4149+--
4150+
4151+ALTER TABLE ONLY constants_acl_scope ALTER COLUMN scopeid SET DEFAULT nextval('constants_acl_scope_scopeid_seq'::regclass);
4152+
4153+
4154+--
4155 -- Name: feedid; Type: DEFAULT; Schema: public; Owner: -
4156 --
4157 
4158@@ -8237,73 +7213,66 @@
4159 
4160 
4161 --
4162--- Name: proposalid; Type: DEFAULT; Schema: public; Owner: -
4163---
4164-
4165-ALTER TABLE ONLY rec_trackproposal ALTER COLUMN proposalid SET DEFAULT nextval('rec_trackproposal_proposalid_seq'::regclass);
4166-
4167-
4168---
4169--- Name: entrytypeid; Type: DEFAULT; Schema: public; Owner: -
4170+-- Name: selid; Type: DEFAULT; Schema: public; Owner: -
4171 --
4172 
4173-ALTER TABLE ONLY sched_entrytype ALTER COLUMN entrytypeid SET DEFAULT nextval('sched_entrytype_entrytypeid_seq'::regclass);
4174+ALTER TABLE ONLY selector ALTER COLUMN selid SET DEFAULT nextval('selector_selid_seq'::regclass);
4175 
4176 
4177 --
4178--- Name: musiccategoryid; Type: DEFAULT; Schema: public; Owner: -
4179+-- Name: action; Type: DEFAULT; Schema: public; Owner: -
4180 --
4181 
4182-ALTER TABLE ONLY sched_musiccategory ALTER COLUMN musiccategoryid SET DEFAULT nextval('sched_musiccategory_musiccategoryid_seq'::regclass);
4183+ALTER TABLE ONLY selector_actions ALTER COLUMN action SET DEFAULT nextval('selector_actions_action_seq'::regclass);
4184 
4185 
4186 --
4187--- Name: roomid; Type: DEFAULT; Schema: public; Owner: -
4188+-- Name: commtypeid; Type: DEFAULT; Schema: public; Owner: -
4189 --
4190 
4191-ALTER TABLE ONLY sched_room ALTER COLUMN roomid SET DEFAULT nextval('sched_room_roomid_seq'::regclass);
4192+ALTER TABLE ONLY sis_commtype ALTER COLUMN commtypeid SET DEFAULT nextval('sis_commtype_commtypeid_seq'::regclass);
4193 
4194 
4195 --
4196--- Name: speechcategoryid; Type: DEFAULT; Schema: public; Owner: -
4197+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
4198 --
4199 
4200-ALTER TABLE ONLY sched_speechcategory ALTER COLUMN speechcategoryid SET DEFAULT nextval('sched_speechcategory_speechcategoryid_seq'::regclass);
4201+ALTER TABLE ONLY sis_piss ALTER COLUMN id SET DEFAULT nextval('sis_piss_id_seq'::regclass);
4202 
4203 
4204 --
4205--- Name: selid; Type: DEFAULT; Schema: public; Owner: -
4206+-- Name: statusid; Type: DEFAULT; Schema: public; Owner: -
4207 --
4208 
4209-ALTER TABLE ONLY selector ALTER COLUMN selid SET DEFAULT nextval('selector_selid_seq'::regclass);
4210+ALTER TABLE ONLY sis_status ALTER COLUMN statusid SET DEFAULT nextval('sis_status_statusid_seq'::regclass);
4211 
4212 
4213 --
4214--- Name: action; Type: DEFAULT; Schema: public; Owner: -
4215+-- Name: packageid; Type: DEFAULT; Schema: public; Owner: -
4216 --
4217 
4218-ALTER TABLE ONLY selector_actions ALTER COLUMN action SET DEFAULT nextval('selector_actions_action_seq'::regclass);
4219+ALTER TABLE ONLY site_package ALTER COLUMN packageid SET DEFAULT nextval('site_special_package_packageid_seq'::regclass);
4220 
4221 
4222 --
4223--- Name: commtypeid; Type: DEFAULT; Schema: public; Owner: -
4224+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
4225 --
4226 
4227-ALTER TABLE ONLY sis_commtype ALTER COLUMN commtypeid SET DEFAULT nextval('sis_commtype_commtypeid_seq'::regclass);
4228+ALTER TABLE ONLY sitetree_tree ALTER COLUMN id SET DEFAULT nextval('sitetree_tree_id_seq'::regclass);
4229 
4230 
4231 --
4232 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
4233 --
4234 
4235-ALTER TABLE ONLY sis_piss ALTER COLUMN id SET DEFAULT nextval('sis_piss_id_seq'::regclass);
4236+ALTER TABLE ONLY sitetree_treeitem ALTER COLUMN id SET DEFAULT nextval('sitetree_treeitem_id_seq'::regclass);
4237 
4238 
4239 --
4240--- Name: statusid; Type: DEFAULT; Schema: public; Owner: -
4241+-- Name: id; Type: DEFAULT; Schema: public; Owner: -
4242 --
4243 
4244-ALTER TABLE ONLY sis_status ALTER COLUMN statusid SET DEFAULT nextval('sis_status_statusid_seq'::regclass);
4245+ALTER TABLE ONLY sitetree_treeitem_access_permissions ALTER COLUMN id SET DEFAULT nextval('sitetree_treeitem_access_permissions_id_seq'::regclass);
4246 
4247 
4248 --
4249@@ -8341,29 +7310,6 @@
4250 ALTER TABLE ONLY terms ALTER COLUMN termid SET DEFAULT nextval('terms_termid_seq'::regclass);
4251 
4252 
4253-SET search_path = rapier, pg_catalog;
4254-
4255---
4256--- Name: privilegeid; Type: DEFAULT; Schema: rapier; Owner: -
4257---
4258-
4259-ALTER TABLE ONLY acl_member ALTER COLUMN privilegeid SET DEFAULT nextval('acl_member_privilegeid_seq'::regclass);
4260-
4261-
4262---
4263--- Name: clientid; Type: DEFAULT; Schema: rapier; Owner: -
4264---
4265-
4266-ALTER TABLE ONLY client ALTER COLUMN clientid SET DEFAULT nextval('client_clientid_seq'::regclass);
4267-
4268-
4269---
4270--- Name: scopeid; Type: DEFAULT; Schema: rapier; Owner: -
4271---
4272-
4273-ALTER TABLE ONLY constants_acl_scope ALTER COLUMN scopeid SET DEFAULT nextval('constants_acl_scope_scopeid_seq'::regclass);
4274-
4275-
4276 SET search_path = schedule, pg_catalog;
4277 
4278 --
4279@@ -8494,50 +7440,6 @@
4280 ALTER TABLE ONLY messages ALTER COLUMN commid SET DEFAULT nextval('messages_commid_seq'::regclass);
4281 
4282 
4283-SET search_path = smsd, pg_catalog;
4284-
4285---
4286--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4287---
4288-
4289-ALTER TABLE ONLY inbox ALTER COLUMN "ID" SET DEFAULT nextval('"inbox_ID_seq"'::regclass);
4290-
4291-
4292---
4293--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4294---
4295-
4296-ALTER TABLE ONLY outbox ALTER COLUMN "ID" SET DEFAULT nextval('"outbox_ID_seq"'::regclass);
4297-
4298-
4299---
4300--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4301---
4302-
4303-ALTER TABLE ONLY outbox_multipart ALTER COLUMN "ID" SET DEFAULT nextval('"outbox_multipart_ID_seq"'::regclass);
4304-
4305-
4306---
4307--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4308---
4309-
4310-ALTER TABLE ONLY pbk ALTER COLUMN "ID" SET DEFAULT nextval('"pbk_ID_seq"'::regclass);
4311-
4312-
4313---
4314--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4315---
4316-
4317-ALTER TABLE ONLY pbk_groups ALTER COLUMN "ID" SET DEFAULT nextval('"pbk_groups_ID_seq"'::regclass);
4318-
4319-
4320---
4321--- Name: ID; Type: DEFAULT; Schema: smsd; Owner: -
4322---
4323-
4324-ALTER TABLE ONLY sentitems ALTER COLUMN "ID" SET DEFAULT nextval('"sentitems_ID_seq"'::regclass);
4325-
4326-
4327 SET search_path = tracklist, pg_catalog;
4328 
4329 --
4330@@ -8633,7 +7535,7 @@
4331 SET search_path = bapsplanner, pg_catalog;
4332 
4333 --
4334--- Name: auto_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4335+-- Name: auto_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4336 --
4337 
4338 ALTER TABLE ONLY auto_playlists
4339@@ -8641,7 +7543,7 @@
4340 
4341 
4342 --
4343--- Name: client_ids_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4344+-- Name: client_ids_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4345 --
4346 
4347 ALTER TABLE ONLY client_ids
4348@@ -8649,7 +7551,7 @@
4349 
4350 
4351 --
4352--- Name: managed_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4353+-- Name: managed_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4354 --
4355 
4356 ALTER TABLE ONLY managed_items
4357@@ -8657,7 +7559,7 @@
4358 
4359 
4360 --
4361--- Name: managed_playlists_folder_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4362+-- Name: managed_playlists_folder_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4363 --
4364 
4365 ALTER TABLE ONLY managed_playlists
4366@@ -8665,7 +7567,7 @@
4367 
4368 
4369 --
4370--- Name: managed_playlists_name_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4371+-- Name: managed_playlists_name_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4372 --
4373 
4374 ALTER TABLE ONLY managed_playlists
4375@@ -8673,7 +7575,7 @@
4376 
4377 
4378 --
4379--- Name: managed_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4380+-- Name: managed_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4381 --
4382 
4383 ALTER TABLE ONLY managed_playlists
4384@@ -8681,7 +7583,7 @@
4385 
4386 
4387 --
4388--- Name: secure_play_token_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4389+-- Name: secure_play_token_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4390 --
4391 
4392 ALTER TABLE ONLY secure_play_token
4393@@ -8689,7 +7591,7 @@
4394 
4395 
4396 --
4397--- Name: timeslot_change_ops_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4398+-- Name: timeslot_change_ops_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4399 --
4400 
4401 ALTER TABLE ONLY timeslot_change_ops
4402@@ -8697,43 +7599,17 @@
4403 
4404 
4405 --
4406--- Name: timeslot_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -
4407+-- Name: timeslot_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace:
4408 --
4409 
4410 ALTER TABLE ONLY timeslot_items
4411     ADD CONSTRAINT timeslot_items_pkey PRIMARY KEY (timeslot_item_id);
4412 
4413 
4414-SET search_path = deploy, pg_catalog;
4415-
4416---
4417--- Name: myury_pkey; Type: CONSTRAINT; Schema: deploy; Owner: -
4418---
4419-
4420-ALTER TABLE ONLY myury
4421-    ADD CONSTRAINT myury_pkey PRIMARY KEY (memberid);
4422-
4423-
4424---
4425--- Name: showplanner_pkey; Type: CONSTRAINT; Schema: deploy; Owner: -
4426---
4427-
4428-ALTER TABLE ONLY showplanner
4429-    ADD CONSTRAINT showplanner_pkey PRIMARY KEY (memberid);
4430-
4431-
4432 SET search_path = jukebox, pg_catalog;
4433 
4434 --
4435--- Name: playlist_availability_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4436---
4437-
4438-ALTER TABLE ONLY playlist_availability
4439-    ADD CONSTRAINT playlist_availability_pkey PRIMARY KEY (playlist_availability_id);
4440-
4441-
4442---
4443--- Name: playlist_entries_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4444+-- Name: playlist_entries_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4445 --
4446 
4447 ALTER TABLE ONLY playlist_entries
4448@@ -8741,7 +7617,7 @@
4449 
4450 
4451 --
4452--- Name: playlist_revisions_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4453+-- Name: playlist_revisions_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4454 --
4455 
4456 ALTER TABLE ONLY playlist_revisions
4457@@ -8749,7 +7625,7 @@
4458 
4459 
4460 --
4461--- Name: playlist_timeslot_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4462+-- Name: playlist_timeslot_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4463 --
4464 
4465 ALTER TABLE ONLY playlist_timeslot
4466@@ -8757,7 +7633,7 @@
4467 
4468 
4469 --
4470--- Name: playlists_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4471+-- Name: playlists_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4472 --
4473 
4474 ALTER TABLE ONLY playlists
4475@@ -8765,7 +7641,7 @@
4476 
4477 
4478 --
4479--- Name: request_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4480+-- Name: request_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4481 --
4482 
4483 ALTER TABLE ONLY request
4484@@ -8773,7 +7649,7 @@
4485 
4486 
4487 --
4488--- Name: silence_log_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4489+-- Name: silence_log_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4490 --
4491 
4492 ALTER TABLE ONLY silence_log
4493@@ -8781,53 +7657,17 @@
4494 
4495 
4496 --
4497--- Name: track_blacklist_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -
4498+-- Name: track_blacklist_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace:
4499 --
4500 
4501 ALTER TABLE ONLY track_blacklist
4502     ADD CONSTRAINT track_blacklist_pkey PRIMARY KEY (trackid);
4503 
4504 
4505-SET search_path = loggerng, pg_catalog;
4506-
4507---
4508--- Name: logs_pkey; Type: CONSTRAINT; Schema: loggerng; Owner: -
4509---
4510-
4511-ALTER TABLE ONLY logs
4512-    ADD CONSTRAINT logs_pkey PRIMARY KEY (start, "end", format);
4513-
4514-
4515---
4516--- Name: requests_pkey; Type: CONSTRAINT; Schema: loggerng; Owner: -
4517---
4518-
4519-ALTER TABLE ONLY requests
4520-    ADD CONSTRAINT requests_pkey PRIMARY KEY ("user", start, "end", format);
4521-
4522-
4523-SET search_path = loggerng_test, pg_catalog;
4524-
4525---
4526--- Name: logs_pkey; Type: CONSTRAINT; Schema: loggerng_test; Owner: -
4527---
4528-
4529-ALTER TABLE ONLY logs
4530-    ADD CONSTRAINT logs_pkey PRIMARY KEY (start, "end", format);
4531-
4532-
4533---
4534--- Name: requests_pkey; Type: CONSTRAINT; Schema: loggerng_test; Owner: -
4535---
4536-
4537-ALTER TABLE ONLY requests
4538-    ADD CONSTRAINT requests_pkey PRIMARY KEY ("user", start, "end", format);
4539-
4540-
4541 SET search_path = mail, pg_catalog;
4542 
4543 --
4544--- Name: alias_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4545+-- Name: alias_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4546 --
4547 
4548 ALTER TABLE ONLY alias_list
4549@@ -8835,7 +7675,7 @@
4550 
4551 
4552 --
4553--- Name: alias_member_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4554+-- Name: alias_member_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4555 --
4556 
4557 ALTER TABLE ONLY alias_member
4558@@ -8843,7 +7683,7 @@
4559 
4560 
4561 --
4562--- Name: alias_officer_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4563+-- Name: alias_officer_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4564 --
4565 
4566 ALTER TABLE ONLY alias_officer
4567@@ -8851,7 +7691,7 @@
4568 
4569 
4570 --
4571--- Name: alias_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4572+-- Name: alias_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4573 --
4574 
4575 ALTER TABLE ONLY alias
4576@@ -8859,7 +7699,7 @@
4577 
4578 
4579 --
4580--- Name: alias_source_key; Type: CONSTRAINT; Schema: mail; Owner: -
4581+-- Name: alias_source_key; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4582 --
4583 
4584 ALTER TABLE ONLY alias
4585@@ -8867,7 +7707,7 @@
4586 
4587 
4588 --
4589--- Name: alias_text_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4590+-- Name: alias_text_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4591 --
4592 
4593 ALTER TABLE ONLY alias_text
4594@@ -8875,7 +7715,7 @@
4595 
4596 
4597 --
4598--- Name: email_recipient_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4599+-- Name: email_recipient_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4600 --
4601 
4602 ALTER TABLE ONLY email_recipient_list
4603@@ -8883,7 +7723,7 @@
4604 
4605 
4606 --
4607--- Name: email_recipient_user_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4608+-- Name: email_recipient_user_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4609 --
4610 
4611 ALTER TABLE ONLY email_recipient_member
4612@@ -8891,7 +7731,7 @@
4613 
4614 
4615 --
4616--- Name: emails_pkey; Type: CONSTRAINT; Schema: mail; Owner: -
4617+-- Name: emails_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace:
4618 --
4619 
4620 ALTER TABLE ONLY email
4621@@ -8901,7 +7741,7 @@
4622 SET search_path = metadata, pg_catalog;
4623 
4624 --
4625--- Name: metadata_key_name_key; Type: CONSTRAINT; Schema: metadata; Owner: -
4626+-- Name: metadata_key_name_key; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace:
4627 --
4628 
4629 ALTER TABLE ONLY metadata_key
4630@@ -8909,7 +7749,7 @@
4631 
4632 
4633 --
4634--- Name: metadata_key_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -
4635+-- Name: metadata_key_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace:
4636 --
4637 
4638 ALTER TABLE ONLY metadata_key
4639@@ -8917,7 +7757,7 @@
4640 
4641 
4642 --
4643--- Name: package_image_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -
4644+-- Name: package_image_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace:
4645 --
4646 
4647 ALTER TABLE ONLY package_image_metadata
4648@@ -8925,7 +7765,7 @@
4649 
4650 
4651 --
4652--- Name: package_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -
4653+-- Name: package_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace:
4654 --
4655 
4656 ALTER TABLE ONLY package
4657@@ -8933,7 +7773,7 @@
4658 
4659 
4660 --
4661--- Name: package_text_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -
4662+-- Name: package_text_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace:
4663 --
4664 
4665 ALTER TABLE ONLY package_text_metadata
4666@@ -8943,7 +7783,7 @@
4667 SET search_path = music, pg_catalog;
4668 
4669 --
4670--- Name: chart_release_pkey; Type: CONSTRAINT; Schema: music; Owner: -
4671+-- Name: chart_release_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace:
4672 --
4673 
4674 ALTER TABLE ONLY chart_release
4675@@ -8951,7 +7791,7 @@
4676 
4677 
4678 --
4679--- Name: chart_row_chart_row_id_key; Type: CONSTRAINT; Schema: music; Owner: -
4680+-- Name: chart_row_chart_row_id_key; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace:
4681 --
4682 
4683 ALTER TABLE ONLY chart_row
4684@@ -8959,7 +7799,7 @@
4685 
4686 
4687 --
4688--- Name: chart_row_pkey; Type: CONSTRAINT; Schema: music; Owner: -
4689+-- Name: chart_row_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace:
4690 --
4691 
4692 ALTER TABLE ONLY chart_row
4693@@ -8967,7 +7807,7 @@
4694 
4695 
4696 --
4697--- Name: chart_type_pkey; Type: CONSTRAINT; Schema: music; Owner: -
4698+-- Name: chart_type_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace:
4699 --
4700 
4701 ALTER TABLE ONLY chart_type
4702@@ -8975,7 +7815,7 @@
4703 
4704 
4705 --
4706--- Name: explicit_checked_pkey; Type: CONSTRAINT; Schema: music; Owner: -
4707+-- Name: explicit_checked_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace:
4708 --
4709 
4710 ALTER TABLE ONLY explicit_checked
4711@@ -8985,7 +7825,7 @@
4712 SET search_path = myradio, pg_catalog;
4713 
4714 --
4715--- Name: schema_pkey; Type: CONSTRAINT; Schema: myradio; Owner: -
4716+-- Name: schema_pkey; Type: CONSTRAINT; Schema: myradio; Owner: -; Tablespace:
4717 --
4718 
4719 ALTER TABLE ONLY schema
4720@@ -8995,7 +7835,7 @@
4721 SET search_path = myury, pg_catalog;
4722 
4723 --
4724--- Name: act_permission_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4725+-- Name: act_permission_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4726 --
4727 
4728 ALTER TABLE ONLY act_permission
4729@@ -9003,7 +7843,7 @@
4730 
4731 
4732 --
4733--- Name: act_permission_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -
4734+-- Name: act_permission_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4735 --
4736 
4737 ALTER TABLE ONLY act_permission
4738@@ -9011,7 +7851,7 @@
4739 
4740 
4741 --
4742--- Name: actions_moduleid_key; Type: CONSTRAINT; Schema: myury; Owner: -
4743+-- Name: actions_moduleid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4744 --
4745 
4746 ALTER TABLE ONLY actions
4747@@ -9019,7 +7859,7 @@
4748 
4749 
4750 --
4751--- Name: actions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4752+-- Name: actions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4753 --
4754 
4755 ALTER TABLE ONLY actions
4756@@ -9027,7 +7867,7 @@
4757 
4758 
4759 --
4760--- Name: api_class_map_api_name_key; Type: CONSTRAINT; Schema: myury; Owner: -
4761+-- Name: api_class_map_api_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4762 --
4763 
4764 ALTER TABLE ONLY api_class_map
4765@@ -9035,7 +7875,7 @@
4766 
4767 
4768 --
4769--- Name: api_class_map_class_name_key; Type: CONSTRAINT; Schema: myury; Owner: -
4770+-- Name: api_class_map_class_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4771 --
4772 
4773 ALTER TABLE ONLY api_class_map
4774@@ -9043,7 +7883,7 @@
4775 
4776 
4777 --
4778--- Name: api_class_map_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4779+-- Name: api_class_map_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4780 --
4781 
4782 ALTER TABLE ONLY api_class_map
4783@@ -9051,7 +7891,7 @@
4784 
4785 
4786 --
4787--- Name: api_key_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4788+-- Name: api_key_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4789 --
4790 
4791 ALTER TABLE ONLY api_key_auth
4792@@ -9059,7 +7899,7 @@
4793 
4794 
4795 --
4796--- Name: api_key_log_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4797+-- Name: api_key_log_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4798 --
4799 
4800 ALTER TABLE ONLY api_key_log
4801@@ -9067,7 +7907,7 @@
4802 
4803 
4804 --
4805--- Name: api_key_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4806+-- Name: api_key_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4807 --
4808 
4809 ALTER TABLE ONLY api_key
4810@@ -9075,7 +7915,7 @@
4811 
4812 
4813 --
4814--- Name: api_method_auth_class_name_method_name_typeid_key; Type: CONSTRAINT; Schema: myury; Owner: -
4815+-- Name: api_method_auth_class_name_method_name_typeid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4816 --
4817 
4818 ALTER TABLE ONLY api_method_auth
4819@@ -9083,7 +7923,7 @@
4820 
4821 
4822 --
4823--- Name: api_method_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4824+-- Name: api_method_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4825 --
4826 
4827 ALTER TABLE ONLY api_method_auth
4828@@ -9091,7 +7931,7 @@
4829 
4830 
4831 --
4832--- Name: award_categories_name_key; Type: CONSTRAINT; Schema: myury; Owner: -
4833+-- Name: award_categories_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4834 --
4835 
4836 ALTER TABLE ONLY award_categories
4837@@ -9099,7 +7939,7 @@
4838 
4839 
4840 --
4841--- Name: award_categories_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4842+-- Name: award_categories_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4843 --
4844 
4845 ALTER TABLE ONLY award_categories
4846@@ -9107,7 +7947,7 @@
4847 
4848 
4849 --
4850--- Name: award_member_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4851+-- Name: award_member_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4852 --
4853 
4854 ALTER TABLE ONLY award_member
4855@@ -9115,15 +7955,7 @@
4856 
4857 
4858 --
4859--- Name: contract_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4860---
4861-
4862-ALTER TABLE ONLY contract_versions
4863-    ADD CONSTRAINT contract_versions_pkey PRIMARY KEY (contract_version_id);
4864-
4865-
4866---
4867--- Name: error_rate_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4868+-- Name: error_rate_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4869 --
4870 
4871 ALTER TABLE ONLY error_rate
4872@@ -9131,7 +7963,7 @@
4873 
4874 
4875 --
4876--- Name: modules_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4877+-- Name: modules_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4878 --
4879 
4880 ALTER TABLE ONLY modules
4881@@ -9139,7 +7971,7 @@
4882 
4883 
4884 --
4885--- Name: modules_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -
4886+-- Name: modules_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4887 --
4888 
4889 ALTER TABLE ONLY modules
4890@@ -9147,7 +7979,7 @@
4891 
4892 
4893 --
4894--- Name: photos_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4895+-- Name: photos_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4896 --
4897 
4898 ALTER TABLE ONLY photos
4899@@ -9155,7 +7987,7 @@
4900 
4901 
4902 --
4903--- Name: services_name_key; Type: CONSTRAINT; Schema: myury; Owner: -
4904+-- Name: services_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4905 --
4906 
4907 ALTER TABLE ONLY services
4908@@ -9163,7 +7995,7 @@
4909 
4910 
4911 --
4912--- Name: services_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4913+-- Name: services_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4914 --
4915 
4916 ALTER TABLE ONLY services
4917@@ -9171,7 +8003,7 @@
4918 
4919 
4920 --
4921--- Name: services_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4922+-- Name: services_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4923 --
4924 
4925 ALTER TABLE ONLY services_versions
4926@@ -9179,7 +8011,7 @@
4927 
4928 
4929 --
4930--- Name: services_versions_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -
4931+-- Name: services_versions_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4932 --
4933 
4934 ALTER TABLE ONLY services_versions
4935@@ -9187,7 +8019,7 @@
4936 
4937 
4938 --
4939--- Name: services_versions_serviceid_key1; Type: CONSTRAINT; Schema: myury; Owner: -
4940+-- Name: services_versions_serviceid_key1; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4941 --
4942 
4943 ALTER TABLE ONLY services_versions
4944@@ -9195,7 +8027,7 @@
4945 
4946 
4947 --
4948--- Name: services_versions_users_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4949+-- Name: services_versions_users_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4950 --
4951 
4952 ALTER TABLE ONLY services_versions_member
4953@@ -9203,7 +8035,7 @@
4954 
4955 
4956 --
4957--- Name: single_login_token_pkey; Type: CONSTRAINT; Schema: myury; Owner: -
4958+-- Name: single_login_token_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace:
4959 --
4960 
4961 ALTER TABLE ONLY password_reset_token
4962@@ -9213,7 +8045,7 @@
4963 SET search_path = people, pg_catalog;
4964 
4965 --
4966--- Name: group_root_role_pkey; Type: CONSTRAINT; Schema: people; Owner: -
4967+-- Name: group_root_role_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
4968 --
4969 
4970 ALTER TABLE ONLY group_root_role
4971@@ -9221,7 +8053,7 @@
4972 
4973 
4974 --
4975--- Name: group_root_role_role_id_id_key; Type: CONSTRAINT; Schema: people; Owner: -
4976+-- Name: group_root_role_role_id_id_key; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
4977 --
4978 
4979 ALTER TABLE ONLY group_root_role
4980@@ -9229,7 +8061,7 @@
4981 
4982 
4983 --
4984--- Name: group_type_pkey; Type: CONSTRAINT; Schema: people; Owner: -
4985+-- Name: group_type_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
4986 --
4987 
4988 ALTER TABLE ONLY group_type
4989@@ -9237,7 +8069,7 @@
4990 
4991 
4992 --
4993--- Name: metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -
4994+-- Name: metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
4995 --
4996 
4997 ALTER TABLE ONLY metadata
4998@@ -9245,7 +8077,7 @@
4999 
5000 
5001 --
5002--- Name: quote_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5003+-- Name: quote_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5004 --
5005 
5006 ALTER TABLE ONLY quote
5007@@ -9253,7 +8085,7 @@
5008 
5009 
5010 --
5011--- Name: role_inheritance_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5012+-- Name: role_inheritance_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5013 --
5014 
5015 ALTER TABLE ONLY role_inheritance
5016@@ -9261,7 +8093,7 @@
5017 
5018 
5019 --
5020--- Name: role_metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5021+-- Name: role_metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5022 --
5023 
5024 ALTER TABLE ONLY role_text_metadata
5025@@ -9269,7 +8101,7 @@
5026 
5027 
5028 --
5029--- Name: roles_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5030+-- Name: roles_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5031 --
5032 
5033 ALTER TABLE ONLY role
5034@@ -9277,7 +8109,7 @@
5035 
5036 
5037 --
5038--- Name: schedule.showcredittype_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5039+-- Name: schedule.showcredittype_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5040 --
5041 
5042 ALTER TABLE ONLY credit_type
5043@@ -9285,7 +8117,7 @@
5044 
5045 
5046 --
5047--- Name: types_name_key; Type: CONSTRAINT; Schema: people; Owner: -
5048+-- Name: types_name_key; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5049 --
5050 
5051 ALTER TABLE ONLY role_visibility
5052@@ -9293,7 +8125,7 @@
5053 
5054 
5055 --
5056--- Name: types_pkey; Type: CONSTRAINT; Schema: people; Owner: -
5057+-- Name: types_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace:
5058 --
5059 
5060 ALTER TABLE ONLY role_visibility
5061@@ -9303,7 +8135,7 @@
5062 SET search_path = public, pg_catalog;
5063 
5064 --
5065--- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5066+-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5067 --
5068 
5069 ALTER TABLE ONLY auth_group
5070@@ -9311,7 +8143,7 @@
5071 
5072 
5073 --
5074--- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5075+-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5076 --
5077 
5078 ALTER TABLE ONLY auth_group
5079@@ -9319,7 +8151,7 @@
5080 
5081 
5082 --
5083--- Name: auth_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5084+-- Name: auth_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5085 --
5086 
5087 ALTER TABLE ONLY auth_officer
5088@@ -9327,7 +8159,7 @@
5089 
5090 
5091 --
5092--- Name: auth_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5093+-- Name: auth_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5094 --
5095 
5096 ALTER TABLE ONLY auth
5097@@ -9335,7 +8167,7 @@
5098 
5099 
5100 --
5101--- Name: auth_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5102+-- Name: auth_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5103 --
5104 
5105 ALTER TABLE ONLY auth_subnet
5106@@ -9343,7 +8175,7 @@
5107 
5108 
5109 --
5110--- Name: auth_trainingstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5111+-- Name: auth_trainingstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5112 --
5113 
5114 ALTER TABLE ONLY auth_trainingstatus
5115@@ -9351,7 +8183,7 @@
5116 
5117 
5118 --
5119--- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5120+-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5121 --
5122 
5123 ALTER TABLE ONLY auth_user_groups
5124@@ -9359,7 +8191,7 @@
5125 
5126 
5127 --
5128--- Name: auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -
5129+-- Name: auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5130 --
5131 
5132 ALTER TABLE ONLY auth_user_groups
5133@@ -9367,7 +8199,7 @@
5134 
5135 
5136 --
5137--- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5138+-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5139 --
5140 
5141 ALTER TABLE ONLY auth_user
5142@@ -9375,7 +8207,7 @@
5143 
5144 
5145 --
5146--- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -
5147+-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5148 --
5149 
5150 ALTER TABLE ONLY auth_user
5151@@ -9383,7 +8215,7 @@
5152 
5153 
5154 --
5155--- Name: baps_audio_filename_key; Type: CONSTRAINT; Schema: public; Owner: -
5156+-- Name: baps_audio_filename_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5157 --
5158 
5159 ALTER TABLE ONLY baps_audio
5160@@ -9391,7 +8223,7 @@
5161 
5162 
5163 --
5164--- Name: baps_audio_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5165+-- Name: baps_audio_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5166 --
5167 
5168 ALTER TABLE ONLY baps_audio
5169@@ -9399,7 +8231,7 @@
5170 
5171 
5172 --
5173--- Name: baps_audio_trackid_key; Type: CONSTRAINT; Schema: public; Owner: -
5174+-- Name: baps_audio_trackid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5175 --
5176 
5177 ALTER TABLE ONLY baps_audio
5178@@ -9407,7 +8239,7 @@
5179 
5180 
5181 --
5182--- Name: baps_audiolog_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5183+-- Name: baps_audiolog_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5184 --
5185 
5186 ALTER TABLE ONLY baps_audiolog
5187@@ -9415,7 +8247,7 @@
5188 
5189 
5190 --
5191--- Name: baps_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5192+-- Name: baps_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5193 --
5194 
5195 ALTER TABLE ONLY baps_filefolder
5196@@ -9425,7 +8257,7 @@
5197 
5198 
5199 --
5200--- Name: baps_filefolder_workgroup_key; Type: CONSTRAINT; Schema: public; Owner: -
5201+-- Name: baps_filefolder_workgroup_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5202 --
5203 
5204 ALTER TABLE ONLY baps_filefolder
5205@@ -9433,7 +8265,7 @@
5206 
5207 
5208 --
5209--- Name: baps_fileitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5210+-- Name: baps_fileitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5211 --
5212 
5213 ALTER TABLE ONLY baps_fileitem
5214@@ -9443,7 +8275,7 @@
5215 
5216 
5217 --
5218--- Name: baps_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5219+-- Name: baps_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5220 --
5221 
5222 ALTER TABLE ONLY baps_item
5223@@ -9453,7 +8285,7 @@
5224 
5225 
5226 --
5227--- Name: baps_libraryitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5228+-- Name: baps_libraryitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5229 --
5230 
5231 ALTER TABLE ONLY baps_libraryitem
5232@@ -9463,7 +8295,7 @@
5233 
5234 
5235 --
5236--- Name: baps_listing_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5237+-- Name: baps_listing_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5238 --
5239 
5240 ALTER TABLE ONLY baps_listing
5241@@ -9471,7 +8303,7 @@
5242 
5243 
5244 --
5245--- Name: baps_server_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5246+-- Name: baps_server_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5247 --
5248 
5249 ALTER TABLE ONLY baps_server
5250@@ -9479,7 +8311,7 @@
5251 
5252 
5253 --
5254--- Name: baps_server_servername_key; Type: CONSTRAINT; Schema: public; Owner: -
5255+-- Name: baps_server_servername_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5256 --
5257 
5258 ALTER TABLE ONLY baps_server
5259@@ -9487,7 +8319,7 @@
5260 
5261 
5262 --
5263--- Name: baps_show_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5264+-- Name: baps_show_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5265 --
5266 
5267 ALTER TABLE ONLY baps_show
5268@@ -9495,7 +8327,7 @@
5269 
5270 
5271 --
5272--- Name: baps_show_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5273+-- Name: baps_show_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5274 --
5275 
5276 ALTER TABLE ONLY baps_show
5277@@ -9505,7 +8337,7 @@
5278 
5279 
5280 --
5281--- Name: baps_textitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5282+-- Name: baps_textitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5283 --
5284 
5285 ALTER TABLE ONLY baps_textitem
5286@@ -9515,7 +8347,7 @@
5287 
5288 
5289 --
5290--- Name: baps_user_external_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5291+-- Name: baps_user_external_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5292 --
5293 
5294 ALTER TABLE ONLY baps_user_external
5295@@ -9523,7 +8355,7 @@
5296 
5297 
5298 --
5299--- Name: baps_user_external_userid_key; Type: CONSTRAINT; Schema: public; Owner: -
5300+-- Name: baps_user_external_userid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5301 --
5302 
5303 ALTER TABLE ONLY baps_user_external
5304@@ -9531,7 +8363,7 @@
5305 
5306 
5307 --
5308--- Name: baps_user_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5309+-- Name: baps_user_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5310 --
5311 
5312 ALTER TABLE ONLY baps_user_filefolder
5313@@ -9539,7 +8371,7 @@
5314 
5315 
5316 --
5317--- Name: baps_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5318+-- Name: baps_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5319 --
5320 
5321 ALTER TABLE ONLY baps_user
5322@@ -9547,7 +8379,7 @@
5323 
5324 
5325 --
5326--- Name: baps_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -
5327+-- Name: baps_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5328 --
5329 
5330 ALTER TABLE ONLY baps_user
5331@@ -9557,7 +8389,7 @@
5332 
5333 
5334 --
5335--- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5336+-- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5337 --
5338 
5339 ALTER TABLE ONLY chart
5340@@ -9565,7 +8397,7 @@
5341 
5342 
5343 --
5344--- Name: l_action_descr_key; Type: CONSTRAINT; Schema: public; Owner: -
5345+-- Name: l_action_descr_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5346 --
5347 
5348 ALTER TABLE ONLY l_action
5349@@ -9573,7 +8405,7 @@
5350 
5351 
5352 --
5353--- Name: l_action_phpconstant_key; Type: CONSTRAINT; Schema: public; Owner: -
5354+-- Name: l_action_phpconstant_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5355 --
5356 
5357 ALTER TABLE ONLY l_action
5358@@ -9581,7 +8413,7 @@
5359 
5360 
5361 --
5362--- Name: l_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5363+-- Name: l_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5364 --
5365 
5366 ALTER TABLE ONLY l_action
5367@@ -9589,7 +8421,7 @@
5368 
5369 
5370 --
5371--- Name: l_college_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5372+-- Name: l_college_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5373 --
5374 
5375 ALTER TABLE ONLY l_college
5376@@ -9597,7 +8429,7 @@
5377 
5378 
5379 --
5380--- Name: l_musicinterest_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5381+-- Name: l_musicinterest_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5382 --
5383 
5384 ALTER TABLE ONLY l_musicinterest
5385@@ -9605,7 +8437,7 @@
5386 
5387 
5388 --
5389--- Name: l_newsfeeds_feedname_key; Type: CONSTRAINT; Schema: public; Owner: -
5390+-- Name: l_newsfeeds_feedname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5391 --
5392 
5393 ALTER TABLE ONLY l_newsfeed
5394@@ -9613,7 +8445,7 @@
5395 
5396 
5397 --
5398--- Name: l_newsfeeds_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5399+-- Name: l_newsfeeds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5400 --
5401 
5402 ALTER TABLE ONLY l_newsfeed
5403@@ -9621,7 +8453,7 @@
5404 
5405 
5406 --
5407--- Name: l_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5408+-- Name: l_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5409 --
5410 
5411 ALTER TABLE ONLY l_presenterstatus
5412@@ -9629,7 +8461,7 @@
5413 
5414 
5415 --
5416--- Name: l_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5417+-- Name: l_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5418 --
5419 
5420 ALTER TABLE ONLY l_status
5421@@ -9637,7 +8469,7 @@
5422 
5423 
5424 --
5425--- Name: l_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5426+-- Name: l_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5427 --
5428 
5429 ALTER TABLE ONLY l_subnet
5430@@ -9645,7 +8477,7 @@
5431 
5432 
5433 --
5434--- Name: mail_alias_list_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5435+-- Name: mail_alias_list_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5436 --
5437 
5438 ALTER TABLE ONLY mail_alias_list
5439@@ -9653,7 +8485,7 @@
5440 
5441 
5442 --
5443--- Name: mail_alias_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5444+-- Name: mail_alias_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5445 --
5446 
5447 ALTER TABLE ONLY mail_alias_list
5448@@ -9661,7 +8493,7 @@
5449 
5450 
5451 --
5452--- Name: mail_alias_member_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5453+-- Name: mail_alias_member_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5454 --
5455 
5456 ALTER TABLE ONLY mail_alias_member
5457@@ -9669,7 +8501,7 @@
5458 
5459 
5460 --
5461--- Name: mail_alias_member_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5462+-- Name: mail_alias_member_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5463 --
5464 
5465 ALTER TABLE ONLY mail_alias_member
5466@@ -9677,7 +8509,7 @@
5467 
5468 
5469 --
5470--- Name: mail_alias_officer_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5471+-- Name: mail_alias_officer_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5472 --
5473 
5474 ALTER TABLE ONLY mail_alias_officer
5475@@ -9685,7 +8517,7 @@
5476 
5477 
5478 --
5479--- Name: mail_alias_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5480+-- Name: mail_alias_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5481 --
5482 
5483 ALTER TABLE ONLY mail_alias_officer
5484@@ -9693,7 +8525,7 @@
5485 
5486 
5487 --
5488--- Name: mail_alias_text_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5489+-- Name: mail_alias_text_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5490 --
5491 
5492 ALTER TABLE ONLY mail_alias_text
5493@@ -9701,7 +8533,7 @@
5494 
5495 
5496 --
5497--- Name: mail_alias_text_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5498+-- Name: mail_alias_text_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5499 --
5500 
5501 ALTER TABLE ONLY mail_alias_text
5502@@ -9709,7 +8541,7 @@
5503 
5504 
5505 --
5506--- Name: mail_list_listaddress_key; Type: CONSTRAINT; Schema: public; Owner: -
5507+-- Name: mail_list_listaddress_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5508 --
5509 
5510 ALTER TABLE ONLY mail_list
5511@@ -9717,7 +8549,7 @@
5512 
5513 
5514 --
5515--- Name: mail_list_listname_key; Type: CONSTRAINT; Schema: public; Owner: -
5516+-- Name: mail_list_listname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5517 --
5518 
5519 ALTER TABLE ONLY mail_list
5520@@ -9725,7 +8557,7 @@
5521 
5522 
5523 --
5524--- Name: mail_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5525+-- Name: mail_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5526 --
5527 
5528 ALTER TABLE ONLY mail_list
5529@@ -9733,7 +8565,7 @@
5530 
5531 
5532 --
5533--- Name: member_eduroam_key; Type: CONSTRAINT; Schema: public; Owner: -
5534+-- Name: member_eduroam_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5535 --
5536 
5537 ALTER TABLE ONLY member
5538@@ -9741,7 +8573,7 @@
5539 
5540 
5541 --
5542--- Name: member_email_key; Type: CONSTRAINT; Schema: public; Owner: -
5543+-- Name: member_email_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5544 --
5545 
5546 ALTER TABLE ONLY member
5547@@ -9749,7 +8581,7 @@
5548 
5549 
5550 --
5551--- Name: member_local_alias_key; Type: CONSTRAINT; Schema: public; Owner: -
5552+-- Name: member_local_alias_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5553 --
5554 
5555 ALTER TABLE ONLY member
5556@@ -9757,7 +8589,7 @@
5557 
5558 
5559 --
5560--- Name: member_local_name_key; Type: CONSTRAINT; Schema: public; Owner: -
5561+-- Name: member_local_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5562 --
5563 
5564 ALTER TABLE ONLY member
5565@@ -9765,7 +8597,7 @@
5566 
5567 
5568 --
5569--- Name: member_mail_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5570+-- Name: member_mail_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5571 --
5572 
5573 ALTER TABLE ONLY mail_subscription
5574@@ -9773,7 +8605,7 @@
5575 
5576 
5577 --
5578--- Name: member_news_feed_memberid_key; Type: CONSTRAINT; Schema: public; Owner: -
5579+-- Name: member_news_feed_memberid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5580 --
5581 
5582 ALTER TABLE ONLY member_news_feed
5583@@ -9781,7 +8613,7 @@
5584 
5585 
5586 --
5587--- Name: member_news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5588+-- Name: member_news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5589 --
5590 
5591 ALTER TABLE ONLY member_news_feed
5592@@ -9789,7 +8621,7 @@
5593 
5594 
5595 --
5596--- Name: member_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5597+-- Name: member_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5598 --
5599 
5600 ALTER TABLE ONLY member_officer
5601@@ -9797,7 +8629,7 @@
5602 
5603 
5604 --
5605--- Name: member_pass_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5606+-- Name: member_pass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5607 --
5608 
5609 ALTER TABLE ONLY member_pass
5610@@ -9805,7 +8637,7 @@
5611 
5612 
5613 --
5614--- Name: member_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5615+-- Name: member_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5616 --
5617 
5618 ALTER TABLE ONLY member
5619@@ -9813,7 +8645,7 @@
5620 
5621 
5622 --
5623--- Name: member_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5624+-- Name: member_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5625 --
5626 
5627 ALTER TABLE ONLY member_presenterstatus
5628@@ -9821,7 +8653,7 @@
5629 
5630 
5631 --
5632--- Name: member_year_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5633+-- Name: member_year_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5634 --
5635 
5636 ALTER TABLE ONLY member_year
5637@@ -9829,7 +8661,7 @@
5638 
5639 
5640 --
5641--- Name: net_switchport_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5642+-- Name: net_switchport_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5643 --
5644 
5645 ALTER TABLE ONLY net_switchport_tags
5646@@ -9837,7 +8669,7 @@
5647 
5648 
5649 --
5650--- Name: net_switchports_mac_key; Type: CONSTRAINT; Schema: public; Owner: -
5651+-- Name: net_switchports_mac_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5652 --
5653 
5654 ALTER TABLE ONLY net_switchport
5655@@ -9845,7 +8677,7 @@
5656 
5657 
5658 --
5659--- Name: net_switchports_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5660+-- Name: net_switchports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5661 --
5662 
5663 ALTER TABLE ONLY net_switchport
5664@@ -9853,7 +8685,7 @@
5665 
5666 
5667 --
5668--- Name: net_vlan_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5669+-- Name: net_vlan_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5670 --
5671 
5672 ALTER TABLE ONLY net_vlan
5673@@ -9861,7 +8693,7 @@
5674 
5675 
5676 --
5677--- Name: news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5678+-- Name: news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5679 --
5680 
5681 ALTER TABLE ONLY news_feed
5682@@ -9869,7 +8701,7 @@
5683 
5684 
5685 --
5686--- Name: nipsweb_migrate_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5687+-- Name: nipsweb_migrate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5688 --
5689 
5690 ALTER TABLE ONLY nipsweb_migrate
5691@@ -9877,7 +8709,7 @@
5692 
5693 
5694 --
5695--- Name: officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5696+-- Name: officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5697 --
5698 
5699 ALTER TABLE ONLY officer
5700@@ -9885,7 +8717,7 @@
5701 
5702 
5703 --
5704--- Name: rec_cleanlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5705+-- Name: rec_cleanlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5706 --
5707 
5708 ALTER TABLE ONLY rec_cleanlookup
5709@@ -9893,7 +8725,7 @@
5710 
5711 
5712 --
5713--- Name: rec_formatlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5714+-- Name: rec_formatlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5715 --
5716 
5717 ALTER TABLE ONLY rec_formatlookup
5718@@ -9901,7 +8733,7 @@
5719 
5720 
5721 --
5722--- Name: rec_genrelookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5723+-- Name: rec_genrelookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5724 --
5725 
5726 ALTER TABLE ONLY rec_genrelookup
5727@@ -9909,7 +8741,7 @@
5728 
5729 
5730 --
5731--- Name: rec_itunes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5732+-- Name: rec_itunes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5733 --
5734 
5735 ALTER TABLE ONLY rec_itunes
5736@@ -9917,7 +8749,7 @@
5737 
5738 
5739 --
5740--- Name: rec_labelqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5741+-- Name: rec_labelqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5742 --
5743 
5744 ALTER TABLE ONLY rec_labelqueue
5745@@ -9925,7 +8757,7 @@
5746 
5747 
5748 --
5749--- Name: rec_locationlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5750+-- Name: rec_locationlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5751 --
5752 
5753 ALTER TABLE ONLY rec_locationlookup
5754@@ -9933,7 +8765,7 @@
5755 
5756 
5757 --
5758--- Name: rec_lookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5759+-- Name: rec_lookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5760 --
5761 
5762 ALTER TABLE ONLY rec_lookup
5763@@ -9941,7 +8773,7 @@
5764 
5765 
5766 --
5767--- Name: rec_medialookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5768+-- Name: rec_medialookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5769 --
5770 
5771 ALTER TABLE ONLY rec_medialookup
5772@@ -9949,7 +8781,7 @@
5773 
5774 
5775 --
5776--- Name: rec_record_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5777+-- Name: rec_record_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5778 --
5779 
5780 ALTER TABLE ONLY rec_record
5781@@ -9957,7 +8789,7 @@
5782 
5783 
5784 --
5785--- Name: rec_statuslookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5786+-- Name: rec_statuslookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5787 --
5788 
5789 ALTER TABLE ONLY rec_statuslookup
5790@@ -9965,7 +8797,7 @@
5791 
5792 
5793 --
5794--- Name: rec_track_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5795+-- Name: rec_track_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5796 --
5797 
5798 ALTER TABLE ONLY rec_track
5799@@ -9973,7 +8805,7 @@
5800 
5801 
5802 --
5803--- Name: rec_track_trackid_recordid_key; Type: CONSTRAINT; Schema: public; Owner: -
5804+-- Name: rec_track_trackid_recordid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5805 --
5806 
5807 ALTER TABLE ONLY rec_track
5808@@ -9981,7 +8813,7 @@
5809 
5810 
5811 --
5812--- Name: rec_trackcorrection_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5813+-- Name: rec_trackcorrection_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5814 --
5815 
5816 ALTER TABLE ONLY rec_trackcorrection
5817@@ -9989,15 +8821,7 @@
5818 
5819 
5820 --
5821--- Name: rec_trackproposal_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5822---
5823-
5824-ALTER TABLE ONLY rec_trackproposal
5825-    ADD CONSTRAINT rec_trackproposal_pkey PRIMARY KEY (proposalid);
5826-
5827-
5828---
5829--- Name: recommended_listening_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5830+-- Name: recommended_listening_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5831 --
5832 
5833 ALTER TABLE ONLY recommended_listening
5834@@ -10005,89 +8829,7 @@
5835 
5836 
5837 --
5838--- Name: sched_entrytype_entrytypename_key; Type: CONSTRAINT; Schema: public; Owner: -
5839---
5840-
5841-ALTER TABLE ONLY sched_entrytype
5842-    ADD CONSTRAINT sched_entrytype_entrytypename_key UNIQUE (entrytypename);
5843-
5844-ALTER TABLE sched_entrytype CLUSTER ON sched_entrytype_entrytypename_key;
5845-
5846-
5847---
5848--- Name: sched_entrytype_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5849---
5850-
5851-ALTER TABLE ONLY sched_entrytype
5852-    ADD CONSTRAINT sched_entrytype_pkey PRIMARY KEY (entrytypeid);
5853-
5854-
5855---
5856--- Name: sched_genre_musiccategoryname_key; Type: CONSTRAINT; Schema: public; Owner: -
5857---
5858-
5859-ALTER TABLE ONLY sched_genre
5860-    ADD CONSTRAINT sched_genre_musiccategoryname_key UNIQUE (genrename);
5861-
5862-
5863---
5864--- Name: sched_genre_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5865---
5866-
5867-ALTER TABLE ONLY sched_genre
5868-    ADD CONSTRAINT sched_genre_pkey PRIMARY KEY (genreid);
5869-
5870-
5871---
5872--- Name: sched_musiccategory_musiccategoryname_key; Type: CONSTRAINT; Schema: public; Owner: -
5873---
5874-
5875-ALTER TABLE ONLY sched_musiccategory
5876-    ADD CONSTRAINT sched_musiccategory_musiccategoryname_key UNIQUE (musiccategoryname);
5877-
5878-
5879---
5880--- Name: sched_musiccategory_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5881---
5882-
5883-ALTER TABLE ONLY sched_musiccategory
5884-    ADD CONSTRAINT sched_musiccategory_pkey PRIMARY KEY (musiccategoryid);
5885-
5886-
5887---
5888--- Name: sched_room_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5889---
5890-
5891-ALTER TABLE ONLY sched_room
5892-    ADD CONSTRAINT sched_room_pkey PRIMARY KEY (roomid);
5893-
5894-
5895---
5896--- Name: sched_room_roomname_key; Type: CONSTRAINT; Schema: public; Owner: -
5897---
5898-
5899-ALTER TABLE ONLY sched_room
5900-    ADD CONSTRAINT sched_room_roomname_key UNIQUE (roomname);
5901-
5902-
5903---
5904--- Name: sched_speechcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5905---
5906-
5907-ALTER TABLE ONLY sched_speechcategory
5908-    ADD CONSTRAINT sched_speechcategory_pkey PRIMARY KEY (speechcategoryid);
5909-
5910-
5911---
5912--- Name: sched_speechcategory_speechcategoryname_key; Type: CONSTRAINT; Schema: public; Owner: -
5913---
5914-
5915-ALTER TABLE ONLY sched_speechcategory
5916-    ADD CONSTRAINT sched_speechcategory_speechcategoryname_key UNIQUE (speechcategoryname);
5917-
5918-
5919---
5920--- Name: selector_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5921+-- Name: selector_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5922 --
5923 
5924 ALTER TABLE ONLY selector_actions
5925@@ -10095,7 +8837,7 @@
5926 
5927 
5928 --
5929--- Name: selector_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5930+-- Name: selector_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5931 --
5932 
5933 ALTER TABLE ONLY selector
5934@@ -10103,7 +8845,7 @@
5935 
5936 
5937 --
5938--- Name: sis_piss_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5939+-- Name: sis_piss_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5940 --
5941 
5942 ALTER TABLE ONLY sis_piss
5943@@ -10111,7 +8853,7 @@
5944 
5945 
5946 --
5947--- Name: sis_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5948+-- Name: sis_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5949 --
5950 
5951 ALTER TABLE ONLY sis_status
5952@@ -10119,7 +8861,7 @@
5953 
5954 
5955 --
5956--- Name: sis_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5957+-- Name: sis_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5958 --
5959 
5960 ALTER TABLE ONLY sis_commtype
5961@@ -10127,7 +8869,7 @@
5962 
5963 
5964 --
5965--- Name: sso_session_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5966+-- Name: sso_session_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5967 --
5968 
5969 ALTER TABLE ONLY sso_session
5970@@ -10135,7 +8877,7 @@
5971 
5972 
5973 --
5974--- Name: strm_client_clientname_key; Type: CONSTRAINT; Schema: public; Owner: -
5975+-- Name: strm_client_clientname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5976 --
5977 
5978 ALTER TABLE ONLY strm_useragent
5979@@ -10143,7 +8885,7 @@
5980 
5981 
5982 --
5983--- Name: strm_client_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5984+-- Name: strm_client_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5985 --
5986 
5987 ALTER TABLE ONLY strm_useragent
5988@@ -10151,7 +8893,7 @@
5989 
5990 
5991 --
5992--- Name: strm_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -
5993+-- Name: strm_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
5994 --
5995 
5996 ALTER TABLE ONLY strm_log
5997@@ -10159,7 +8901,7 @@
5998 
5999 
6000 --
6001--- Name: strm_logfile_filename_key; Type: CONSTRAINT; Schema: public; Owner: -
6002+-- Name: strm_logfile_filename_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6003 --
6004 
6005 ALTER TABLE ONLY strm_logfile
6006@@ -10167,7 +8909,7 @@
6007 
6008 
6009 --
6010--- Name: strm_logfile_pkey; Type: CONSTRAINT; Schema: public; Owner: -
6011+-- Name: strm_logfile_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6012 --
6013 
6014 ALTER TABLE ONLY strm_logfile
6015@@ -10175,7 +8917,7 @@
6016 
6017 
6018 --
6019--- Name: strm_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: -
6020+-- Name: strm_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6021 --
6022 
6023 ALTER TABLE ONLY strm_stream
6024@@ -10183,7 +8925,7 @@
6025 
6026 
6027 --
6028--- Name: strm_stream_streamname_key; Type: CONSTRAINT; Schema: public; Owner: -
6029+-- Name: strm_stream_streamname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6030 --
6031 
6032 ALTER TABLE ONLY strm_stream
6033@@ -10191,7 +8933,7 @@
6034 
6035 
6036 --
6037--- Name: team_pkey; Type: CONSTRAINT; Schema: public; Owner: -
6038+-- Name: team_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6039 --
6040 
6041 ALTER TABLE ONLY team
6042@@ -10199,67 +8941,17 @@
6043 
6044 
6045 --
6046--- Name: terms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
6047+-- Name: terms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
6048 --
6049 
6050 ALTER TABLE ONLY terms
6051     ADD CONSTRAINT terms_pkey PRIMARY KEY (termid);
6052 
6053 
6054-SET search_path = rapier, pg_catalog;
6055-
6056---
6057--- Name: acl_member_memberid_key; Type: CONSTRAINT; Schema: rapier; Owner: -
6058---
6059-
6060-ALTER TABLE ONLY acl_member
6061-    ADD CONSTRAINT acl_member_memberid_key UNIQUE (memberid, class, verb);
6062-
6063-
6064---
6065--- Name: acl_member_pkey; Type: CONSTRAINT; Schema: rapier; Owner: -
6066---
6067-
6068-ALTER TABLE ONLY acl_member
6069-    ADD CONSTRAINT acl_member_pkey PRIMARY KEY (privilegeid);
6070-
6071-
6072---
6073--- Name: acl_officer_officerid_key; Type: CONSTRAINT; Schema: rapier; Owner: -
6074---
6075-
6076-ALTER TABLE ONLY acl_officer
6077-    ADD CONSTRAINT acl_officer_officerid_key UNIQUE (officerid, class, verb);
6078-
6079-
6080---
6081--- Name: acl_officer_pkey; Type: CONSTRAINT; Schema: rapier; Owner: -
6082---
6083-
6084-ALTER TABLE ONLY acl_officer
6085-    ADD CONSTRAINT acl_officer_pkey PRIMARY KEY (privilegeid);
6086-
6087-
6088---
6089--- Name: client_pkey; Type: CONSTRAINT; Schema: rapier; Owner: -
6090---
6091-
6092-ALTER TABLE ONLY client
6093-    ADD CONSTRAINT client_pkey PRIMARY KEY (clientid);
6094-
6095-
6096---
6097--- Name: constants_acl_scope_pkey; Type: CONSTRAINT; Schema: rapier; Owner: -
6098---
6099-
6100-ALTER TABLE ONLY constants_acl_scope
6101-    ADD CONSTRAINT constants_acl_scope_pkey PRIMARY KEY (scopeid);
6102-
6103-
6104 SET search_path = schedule, pg_catalog;
6105 
6106 --
6107--- Name: block_direct_rules_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6108+-- Name: block_direct_rules_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6109 --
6110 
6111 ALTER TABLE ONLY block_show_rule
6112@@ -10267,7 +8959,7 @@
6113 
6114 
6115 --
6116--- Name: block_range_rule_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6117+-- Name: block_range_rule_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6118 --
6119 
6120 ALTER TABLE ONLY block_range_rule
6121@@ -10275,7 +8967,7 @@
6122 
6123 
6124 --
6125--- Name: blocks_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6126+-- Name: blocks_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6127 --
6128 
6129 ALTER TABLE ONLY block
6130@@ -10283,7 +8975,7 @@
6131 
6132 
6133 --
6134--- Name: genre_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -
6135+-- Name: genre_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6136 --
6137 
6138 ALTER TABLE ONLY genre
6139@@ -10291,7 +8983,7 @@
6140 
6141 
6142 --
6143--- Name: genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6144+-- Name: genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6145 --
6146 
6147 ALTER TABLE ONLY genre
6148@@ -10299,7 +8991,7 @@
6149 
6150 
6151 --
6152--- Name: location_location_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -
6153+-- Name: location_location_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6154 --
6155 
6156 ALTER TABLE ONLY location
6157@@ -10307,7 +8999,7 @@
6158 
6159 
6160 --
6161--- Name: location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6162+-- Name: location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6163 --
6164 
6165 ALTER TABLE ONLY location
6166@@ -10315,7 +9007,7 @@
6167 
6168 
6169 --
6170--- Name: season_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6171+-- Name: season_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6172 --
6173 
6174 ALTER TABLE ONLY season_metadata
6175@@ -10323,7 +9015,7 @@
6176 
6177 
6178 --
6179--- Name: show_credit_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6180+-- Name: show_credit_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6181 --
6182 
6183 ALTER TABLE ONLY show_credit
6184@@ -10331,7 +9023,7 @@
6185 
6186 
6187 --
6188--- Name: show_genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6189+-- Name: show_genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6190 --
6191 
6192 ALTER TABLE ONLY show_genre
6193@@ -10339,7 +9031,7 @@
6194 
6195 
6196 --
6197--- Name: show_image_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6198+-- Name: show_image_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6199 --
6200 
6201 ALTER TABLE ONLY show_image_metadata
6202@@ -10347,7 +9039,7 @@
6203 
6204 
6205 --
6206--- Name: show_location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6207+-- Name: show_location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6208 --
6209 
6210 ALTER TABLE ONLY show_location
6211@@ -10355,7 +9047,7 @@
6212 
6213 
6214 --
6215--- Name: show_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6216+-- Name: show_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6217 --
6218 
6219 ALTER TABLE ONLY show_metadata
6220@@ -10363,7 +9055,7 @@
6221 
6222 
6223 --
6224--- Name: show_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6225+-- Name: show_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6226 --
6227 
6228 ALTER TABLE ONLY show
6229@@ -10371,7 +9063,7 @@
6230 
6231 
6232 --
6233--- Name: show_podcast_link_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6234+-- Name: show_podcast_link_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6235 --
6236 
6237 ALTER TABLE ONLY show_podcast_link
6238@@ -10379,7 +9071,7 @@
6239 
6240 
6241 --
6242--- Name: show_season_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6243+-- Name: show_season_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6244 --
6245 
6246 ALTER TABLE ONLY show_season
6247@@ -10387,7 +9079,7 @@
6248 
6249 
6250 --
6251--- Name: show_season_requested_time_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6252+-- Name: show_season_requested_time_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6253 --
6254 
6255 ALTER TABLE ONLY show_season_requested_time
6256@@ -10395,7 +9087,7 @@
6257 
6258 
6259 --
6260--- Name: show_season_requested_week_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6261+-- Name: show_season_requested_week_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6262 --
6263 
6264 ALTER TABLE ONLY show_season_requested_week
6265@@ -10403,7 +9095,7 @@
6266 
6267 
6268 --
6269--- Name: show_season_requested_week_show_season_id_key; Type: CONSTRAINT; Schema: schedule; Owner: -
6270+-- Name: show_season_requested_week_show_season_id_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6271 --
6272 
6273 ALTER TABLE ONLY show_season_requested_week
6274@@ -10411,7 +9103,7 @@
6275 
6276 
6277 --
6278--- Name: show_season_timeslot_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6279+-- Name: show_season_timeslot_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6280 --
6281 
6282 ALTER TABLE ONLY show_season_timeslot
6283@@ -10419,7 +9111,7 @@
6284 
6285 
6286 --
6287--- Name: show_season_timeslot_start_time_key; Type: CONSTRAINT; Schema: schedule; Owner: -
6288+-- Name: show_season_timeslot_start_time_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6289 --
6290 
6291 ALTER TABLE ONLY show_season_timeslot
6292@@ -10427,7 +9119,7 @@
6293 
6294 
6295 --
6296--- Name: show_type_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -
6297+-- Name: show_type_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6298 --
6299 
6300 ALTER TABLE ONLY show_type
6301@@ -10435,7 +9127,7 @@
6302 
6303 
6304 --
6305--- Name: show_type_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6306+-- Name: show_type_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6307 --
6308 
6309 ALTER TABLE ONLY show_type
6310@@ -10443,7 +9135,7 @@
6311 
6312 
6313 --
6314--- Name: timeslot_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -
6315+-- Name: timeslot_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace:
6316 --
6317 
6318 ALTER TABLE ONLY timeslot_metadata
6319@@ -10453,7 +9145,7 @@
6320 SET search_path = sis2, pg_catalog;
6321 
6322 --
6323--- Name: config_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -
6324+-- Name: config_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace:
6325 --
6326 
6327 ALTER TABLE ONLY config
6328@@ -10461,7 +9153,7 @@
6329 
6330 
6331 --
6332--- Name: member_options_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -
6333+-- Name: member_options_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace:
6334 --
6335 
6336 ALTER TABLE ONLY member_options
6337@@ -10469,7 +9161,7 @@
6338 
6339 
6340 --
6341--- Name: member_signin_memberid_show_season_timeslot_id_key; Type: CONSTRAINT; Schema: sis2; Owner: -
6342+-- Name: member_signin_memberid_show_season_timeslot_id_key; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace:
6343 --
6344 
6345 ALTER TABLE ONLY member_signin
6346@@ -10477,75 +9169,17 @@
6347 
6348 
6349 --
6350--- Name: member_signin_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -
6351+-- Name: member_signin_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace:
6352 --
6353 
6354 ALTER TABLE ONLY member_signin
6355     ADD CONSTRAINT member_signin_pkey PRIMARY KEY (member_signin_id);
6356 
6357 
6358-SET search_path = smsd, pg_catalog;
6359-
6360---
6361--- Name: inbox_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6362---
6363-
6364-ALTER TABLE ONLY inbox
6365-    ADD CONSTRAINT inbox_pkey PRIMARY KEY ("ID");
6366-
6367-
6368---
6369--- Name: outbox_multipart_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6370---
6371-
6372-ALTER TABLE ONLY outbox_multipart
6373-    ADD CONSTRAINT outbox_multipart_pkey PRIMARY KEY ("ID", "SequencePosition");
6374-
6375-
6376---
6377--- Name: outbox_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6378---
6379-
6380-ALTER TABLE ONLY outbox
6381-    ADD CONSTRAINT outbox_pkey PRIMARY KEY ("ID");
6382-
6383-
6384---
6385--- Name: pbk_groups_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6386---
6387-
6388-ALTER TABLE ONLY pbk_groups
6389-    ADD CONSTRAINT pbk_groups_pkey PRIMARY KEY ("ID");
6390-
6391-
6392---
6393--- Name: pbk_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6394---
6395-
6396-ALTER TABLE ONLY pbk
6397-    ADD CONSTRAINT pbk_pkey PRIMARY KEY ("ID");
6398-
6399-
6400---
6401--- Name: phones_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6402---
6403-
6404-ALTER TABLE ONLY phones
6405-    ADD CONSTRAINT phones_pkey PRIMARY KEY ("IMEI");
6406-
6407-
6408---
6409--- Name: sentitems_pkey; Type: CONSTRAINT; Schema: smsd; Owner: -
6410---
6411-
6412-ALTER TABLE ONLY sentitems
6413-    ADD CONSTRAINT sentitems_pkey PRIMARY KEY ("ID", "SequencePosition");
6414-
6415-
6416 SET search_path = tracklist, pg_catalog;
6417 
6418 --
6419--- Name: pri_track_notrec; Type: CONSTRAINT; Schema: tracklist; Owner: -
6420+-- Name: pri_track_notrec; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6421 --
6422 
6423 ALTER TABLE ONLY track_notrec
6424@@ -10553,7 +9187,7 @@
6425 
6426 
6427 --
6428--- Name: pri_track_rec; Type: CONSTRAINT; Schema: tracklist; Owner: -
6429+-- Name: pri_track_rec; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6430 --
6431 
6432 ALTER TABLE ONLY track_rec
6433@@ -10561,7 +9195,7 @@
6434 
6435 
6436 --
6437--- Name: source_source_key; Type: CONSTRAINT; Schema: tracklist; Owner: -
6438+-- Name: source_source_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6439 --
6440 
6441 ALTER TABLE ONLY source
6442@@ -10569,7 +9203,7 @@
6443 
6444 
6445 --
6446--- Name: source_sourceid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -
6447+-- Name: source_sourceid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6448 --
6449 
6450 ALTER TABLE ONLY source
6451@@ -10577,7 +9211,7 @@
6452 
6453 
6454 --
6455--- Name: state_stateid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -
6456+-- Name: state_stateid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6457 --
6458 
6459 ALTER TABLE ONLY state
6460@@ -10585,7 +9219,7 @@
6461 
6462 
6463 --
6464--- Name: tracklist_pkey; Type: CONSTRAINT; Schema: tracklist; Owner: -
6465+-- Name: tracklist_pkey; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace:
6466 --
6467 
6468 ALTER TABLE ONLY tracklist
6469@@ -10595,7 +9229,7 @@
6470 SET search_path = uryplayer, pg_catalog;
6471 
6472 --
6473--- Name: podcast_credit_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -
6474+-- Name: podcast_credit_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace:
6475 --
6476 
6477 ALTER TABLE ONLY podcast_credit
6478@@ -10603,7 +9237,7 @@
6479 
6480 
6481 --
6482--- Name: podcast_image_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -
6483+-- Name: podcast_image_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace:
6484 --
6485 
6486 ALTER TABLE ONLY podcast_image_metadata
6487@@ -10611,7 +9245,7 @@
6488 
6489 
6490 --
6491--- Name: podcast_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -
6492+-- Name: podcast_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace:
6493 --
6494 
6495 ALTER TABLE ONLY podcast_metadata
6496@@ -10619,7 +9253,7 @@
6497 
6498 
6499 --
6500--- Name: podcast_package_entry_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -
6501+-- Name: podcast_package_entry_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace:
6502 --
6503 
6504 ALTER TABLE ONLY podcast_package_entry
6505@@ -10627,7 +9261,7 @@
6506 
6507 
6508 --
6509--- Name: podcast_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -
6510+-- Name: podcast_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace:
6511 --
6512 
6513 ALTER TABLE ONLY podcast
6514@@ -10637,7 +9271,7 @@
6515 SET search_path = webcam, pg_catalog;
6516 
6517 --
6518--- Name: memberviews_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -
6519+-- Name: memberviews_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -; Tablespace:
6520 --
6521 
6522 ALTER TABLE ONLY memberviews
6523@@ -10645,7 +9279,7 @@
6524 
6525 
6526 --
6527--- Name: streams_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -
6528+-- Name: streams_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -; Tablespace:
6529 --
6530 
6531 ALTER TABLE ONLY streams
6532@@ -10655,7 +9289,7 @@
6533 SET search_path = website, pg_catalog;
6534 
6535 --
6536--- Name: banner_campaign_pkey; Type: CONSTRAINT; Schema: website; Owner: -
6537+-- Name: banner_campaign_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace:
6538 --
6539 
6540 ALTER TABLE ONLY banner_campaign
6541@@ -10663,7 +9297,7 @@
6542 
6543 
6544 --
6545--- Name: banner_location_pkey; Type: CONSTRAINT; Schema: website; Owner: -
6546+-- Name: banner_location_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace:
6547 --
6548 
6549 ALTER TABLE ONLY banner_location
6550@@ -10671,7 +9305,7 @@
6551 
6552 
6553 --
6554--- Name: banner_pkey; Type: CONSTRAINT; Schema: website; Owner: -
6555+-- Name: banner_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace:
6556 --
6557 
6558 ALTER TABLE ONLY banner
6559@@ -10679,7 +9313,7 @@
6560 
6561 
6562 --
6563--- Name: banner_timeslot_pkey; Type: CONSTRAINT; Schema: website; Owner: -
6564+-- Name: banner_timeslot_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace:
6565 --
6566 
6567 ALTER TABLE ONLY banner_timeslot
6568@@ -10687,124 +9321,80 @@
6569 
6570 
6571 --
6572--- Name: banner_type_pkey; Type: CONSTRAINT; Schema: website; Owner: -
6573+-- Name: banner_type_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace:
6574 --
6575 
6576 ALTER TABLE ONLY banner_type
6577     ADD CONSTRAINT banner_type_pkey PRIMARY KEY (banner_type_id);
6578 
6579 
6580-SET search_path = jukebox, pg_catalog;
6581-
6582---
6583--- Name: playlist_availability_approvedid_idx; Type: INDEX; Schema: jukebox; Owner: -
6584---
6585-
6586-CREATE INDEX playlist_availability_approvedid_idx ON playlist_availability USING btree (approvedid);
6587-
6588-
6589---
6590--- Name: playlist_availability_banner_id_idx; Type: INDEX; Schema: jukebox; Owner: -
6591---
6592-
6593-CREATE INDEX playlist_availability_banner_id_idx ON playlist_availability USING btree (playlistid);
6594-
6595-
6596---
6597--- Name: playlist_availability_banner_location_id_idx; Type: INDEX; Schema: jukebox; Owner: -
6598---
6599-
6600-CREATE INDEX playlist_availability_banner_location_id_idx ON playlist_availability USING btree (weight);
6601-
6602-
6603---
6604--- Name: playlist_availability_effective_from_idx; Type: INDEX; Schema: jukebox; Owner: -
6605---
6606-
6607-CREATE INDEX playlist_availability_effective_from_idx ON playlist_availability USING btree (effective_from);
6608-
6609-
6610---
6611--- Name: playlist_availability_effective_to_idx; Type: INDEX; Schema: jukebox; Owner: -
6612---
6613-
6614-CREATE INDEX playlist_availability_effective_to_idx ON playlist_availability USING btree (effective_to);
6615-
6616-
6617---
6618--- Name: playlist_availability_memberid_idx; Type: INDEX; Schema: jukebox; Owner: -
6619---
6620-
6621-CREATE INDEX playlist_availability_memberid_idx ON playlist_availability USING btree (memberid);
6622-
6623-
6624 SET search_path = metadata, pg_catalog;
6625 
6626 --
6627--- Name: package_image_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -
6628+-- Name: package_image_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6629 --
6630 
6631 CREATE INDEX package_image_metadata_approvedid ON package_image_metadata USING btree (approvedid);
6632 
6633 
6634 --
6635--- Name: package_image_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -
6636+-- Name: package_image_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6637 --
6638 
6639 CREATE INDEX package_image_metadata_element_id ON package_image_metadata USING btree (element_id);
6640 
6641 
6642 --
6643--- Name: package_image_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -
6644+-- Name: package_image_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6645 --
6646 
6647 CREATE INDEX package_image_metadata_memberid ON package_image_metadata USING btree (memberid);
6648 
6649 
6650 --
6651--- Name: package_image_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -
6652+-- Name: package_image_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6653 --
6654 
6655 CREATE INDEX package_image_metadata_metadata_key_id ON package_image_metadata USING btree (metadata_key_id);
6656 
6657 
6658 --
6659--- Name: package_name; Type: INDEX; Schema: metadata; Owner: -
6660+-- Name: package_name; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6661 --
6662 
6663 CREATE INDEX package_name ON package USING btree (name);
6664 
6665 
6666 --
6667--- Name: package_name_like; Type: INDEX; Schema: metadata; Owner: -
6668+-- Name: package_name_like; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6669 --
6670 
6671 CREATE INDEX package_name_like ON package USING btree (name varchar_pattern_ops);
6672 
6673 
6674 --
6675--- Name: package_text_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -
6676+-- Name: package_text_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6677 --
6678 
6679 CREATE INDEX package_text_metadata_approvedid ON package_text_metadata USING btree (approvedid);
6680 
6681 
6682 --
6683--- Name: package_text_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -
6684+-- Name: package_text_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6685 --
6686 
6687 CREATE INDEX package_text_metadata_element_id ON package_text_metadata USING btree (element_id);
6688 
6689 
6690 --
6691--- Name: package_text_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -
6692+-- Name: package_text_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6693 --
6694 
6695 CREATE INDEX package_text_metadata_memberid ON package_text_metadata USING btree (memberid);
6696 
6697 
6698 --
6699--- Name: package_text_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -
6700+-- Name: package_text_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace:
6701 --
6702 
6703 CREATE INDEX package_text_metadata_metadata_key_id ON package_text_metadata USING btree (metadata_key_id);
6704@@ -10813,28 +9403,28 @@
6705 SET search_path = music, pg_catalog;
6706 
6707 --
6708--- Name: chart_release_chart_type_id; Type: INDEX; Schema: music; Owner: -
6709+-- Name: chart_release_chart_type_id; Type: INDEX; Schema: music; Owner: -; Tablespace:
6710 --
6711 
6712 CREATE INDEX chart_release_chart_type_id ON chart_release USING btree (chart_type_id);
6713 
6714 
6715 --
6716--- Name: chart_row_chart_release_id; Type: INDEX; Schema: music; Owner: -
6717+-- Name: chart_row_chart_release_id; Type: INDEX; Schema: music; Owner: -; Tablespace:
6718 --
6719 
6720 CREATE INDEX chart_row_chart_release_id ON chart_row USING btree (chart_release_id);
6721 
6722 
6723 --
6724--- Name: chart_type_name; Type: INDEX; Schema: music; Owner: -
6725+-- Name: chart_type_name; Type: INDEX; Schema: music; Owner: -; Tablespace:
6726 --
6727 
6728 CREATE INDEX chart_type_name ON chart_type USING btree (name);
6729 
6730 
6731 --
6732--- Name: chart_type_name_like; Type: INDEX; Schema: music; Owner: -
6733+-- Name: chart_type_name_like; Type: INDEX; Schema: music; Owner: -; Tablespace:
6734 --
6735 
6736 CREATE INDEX chart_type_name_like ON chart_type USING btree (name varchar_pattern_ops);
6737@@ -10843,14 +9433,14 @@
6738 SET search_path = myury, pg_catalog;
6739 
6740 --
6741--- Name: api_key_log_timestamp_index; Type: INDEX; Schema: myury; Owner: -
6742+-- Name: api_key_log_timestamp_index; Type: INDEX; Schema: myury; Owner: -; Tablespace:
6743 --
6744 
6745 CREATE INDEX api_key_log_timestamp_index ON api_key_log USING btree ("timestamp");
6746 
6747 
6748 --
6749--- Name: error_rate_i_timestamp; Type: INDEX; Schema: myury; Owner: -
6750+-- Name: error_rate_i_timestamp; Type: INDEX; Schema: myury; Owner: -; Tablespace:
6751 --
6752 
6753 CREATE INDEX error_rate_i_timestamp ON error_rate USING btree ("timestamp");
6754@@ -10859,21 +9449,21 @@
6755 SET search_path = people, pg_catalog;
6756 
6757 --
6758--- Name: group_root_role_group_type_id; Type: INDEX; Schema: people; Owner: -
6759+-- Name: group_root_role_group_type_id; Type: INDEX; Schema: people; Owner: -; Tablespace:
6760 --
6761 
6762 CREATE INDEX group_root_role_group_type_id ON group_root_role USING btree (group_type_id);
6763 
6764 
6765 --
6766--- Name: role_metadata_effective_from_index; Type: INDEX; Schema: people; Owner: -
6767+-- Name: role_metadata_effective_from_index; Type: INDEX; Schema: people; Owner: -; Tablespace:
6768 --
6769 
6770 CREATE INDEX role_metadata_effective_from_index ON role_text_metadata USING btree (effective_from);
6771 
6772 
6773 --
6774--- Name: role_metadata_effective_to_index; Type: INDEX; Schema: people; Owner: -
6775+-- Name: role_metadata_effective_to_index; Type: INDEX; Schema: people; Owner: -; Tablespace:
6776 --
6777 
6778 CREATE INDEX role_metadata_effective_to_index ON role_text_metadata USING btree (effective_to);
6779@@ -10882,245 +9472,238 @@
6780 SET search_path = public, pg_catalog;
6781 
6782 --
6783--- Name: audiolog_timeplayed_index; Type: INDEX; Schema: public; Owner: -
6784+-- Name: audiolog_timeplayed_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
6785 --
6786 
6787 CREATE INDEX audiolog_timeplayed_index ON baps_audiolog USING btree (timeplayed);
6788 
6789 
6790 --
6791--- Name: audiolog_timestopped_index; Type: INDEX; Schema: public; Owner: -
6792+-- Name: audiolog_timestopped_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
6793 --
6794 
6795 CREATE INDEX audiolog_timestopped_index ON baps_audiolog USING btree (timestopped);
6796 
6797 
6798 --
6799--- Name: baps_item_fileitemid_key; Type: INDEX; Schema: public; Owner: -
6800+-- Name: baps_item_fileitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6801 --
6802 
6803 CREATE INDEX baps_item_fileitemid_key ON baps_item USING btree (fileitemid);
6804 
6805 
6806 --
6807--- Name: baps_item_libraryitemid_key; Type: INDEX; Schema: public; Owner: -
6808+-- Name: baps_item_libraryitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6809 --
6810 
6811 CREATE INDEX baps_item_libraryitemid_key ON baps_item USING btree (libraryitemid);
6812 
6813 
6814 --
6815--- Name: baps_item_listingid_key; Type: INDEX; Schema: public; Owner: -
6816+-- Name: baps_item_listingid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6817 --
6818 
6819 CREATE INDEX baps_item_listingid_key ON baps_item USING btree (listingid);
6820 
6821 
6822 --
6823--- Name: baps_item_position_key; Type: INDEX; Schema: public; Owner: -
6824+-- Name: baps_item_position_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6825 --
6826 
6827 CREATE INDEX baps_item_position_key ON baps_item USING btree ("position");
6828 
6829 
6830 --
6831--- Name: baps_item_textitemid_key; Type: INDEX; Schema: public; Owner: -
6832+-- Name: baps_item_textitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6833 --
6834 
6835 CREATE INDEX baps_item_textitemid_key ON baps_item USING btree (textitemid);
6836 
6837 
6838 --
6839--- Name: baps_item_viewable_key; Type: INDEX; Schema: public; Owner: -
6840+-- Name: baps_item_viewable_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6841 --
6842 
6843 CREATE INDEX baps_item_viewable_key ON baps_show USING btree (viewable);
6844 
6845 
6846 --
6847--- Name: baps_libraryitem_trackid_index; Type: INDEX; Schema: public; Owner: -
6848+-- Name: baps_libraryitem_trackid_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
6849 --
6850 
6851 CREATE INDEX baps_libraryitem_trackid_index ON baps_libraryitem USING btree (trackid);
6852 
6853 
6854 --
6855--- Name: baps_listing_channel_key; Type: INDEX; Schema: public; Owner: -
6856+-- Name: baps_listing_channel_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6857 --
6858 
6859 CREATE INDEX baps_listing_channel_key ON baps_listing USING btree (channel);
6860 
6861 
6862 --
6863--- Name: baps_listing_showid_key; Type: INDEX; Schema: public; Owner: -
6864+-- Name: baps_listing_showid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6865 --
6866 
6867 CREATE INDEX baps_listing_showid_key ON baps_listing USING btree (showid);
6868 
6869 
6870 --
6871--- Name: baps_show_broadcastdate_index; Type: INDEX; Schema: public; Owner: -
6872+-- Name: baps_show_broadcastdate_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
6873 --
6874 
6875 CREATE INDEX baps_show_broadcastdate_index ON baps_show USING btree (broadcastdate);
6876 
6877 
6878 --
6879--- Name: baps_show_userid_key; Type: INDEX; Schema: public; Owner: -
6880+-- Name: baps_show_userid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6881 --
6882 
6883 CREATE INDEX baps_show_userid_key ON baps_show USING btree (userid);
6884 
6885 
6886 --
6887--- Name: baps_user_usernamechart_key; Type: INDEX; Schema: public; Owner: -
6888+-- Name: baps_user_usernamechart_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6889 --
6890 
6891 CREATE INDEX baps_user_usernamechart_key ON baps_user USING btree (username) WHERE ((username)::text = 'chart'::text);
6892 
6893 
6894 --
6895--- Name: chartweektimestamp; Type: INDEX; Schema: public; Owner: -
6896+-- Name: chartweektimestamp; Type: INDEX; Schema: public; Owner: -; Tablespace:
6897 --
6898 
6899 CREATE INDEX chartweektimestamp ON chart USING btree (chartweek);
6900 
6901 
6902 --
6903--- Name: i_endtime; Type: INDEX; Schema: public; Owner: -
6904+-- Name: i_endtime; Type: INDEX; Schema: public; Owner: -; Tablespace:
6905 --
6906 
6907 CREATE INDEX i_endtime ON strm_log USING btree (endtime);
6908 
6909 
6910 --
6911--- Name: idx_member_eduroam; Type: INDEX; Schema: public; Owner: -
6912+-- Name: idx_member_eduroam; Type: INDEX; Schema: public; Owner: -; Tablespace:
6913 --
6914 
6915 CREATE INDEX idx_member_eduroam ON member USING btree (eduroam);
6916 
6917 
6918 --
6919--- Name: idx_member_email; Type: INDEX; Schema: public; Owner: -
6920+-- Name: idx_member_email; Type: INDEX; Schema: public; Owner: -; Tablespace:
6921 --
6922 
6923 CREATE INDEX idx_member_email ON member USING btree (email);
6924 
6925 
6926 --
6927--- Name: idx_member_localalias; Type: INDEX; Schema: public; Owner: -
6928+-- Name: idx_member_localalias; Type: INDEX; Schema: public; Owner: -; Tablespace:
6929 --
6930 
6931 CREATE INDEX idx_member_localalias ON member USING btree (local_alias);
6932 
6933 
6934 --
6935--- Name: idx_member_localname; Type: INDEX; Schema: public; Owner: -
6936+-- Name: idx_member_localname; Type: INDEX; Schema: public; Owner: -; Tablespace:
6937 --
6938 
6939 CREATE INDEX idx_member_localname ON member USING btree (local_name);
6940 
6941 
6942 --
6943--- Name: l_college_collegeid_key; Type: INDEX; Schema: public; Owner: -
6944+-- Name: l_college_collegeid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6945 --
6946 
6947 CREATE UNIQUE INDEX l_college_collegeid_key ON l_college USING btree (collegeid);
6948 
6949 
6950 --
6951--- Name: l_musicinterest_typeid_key; Type: INDEX; Schema: public; Owner: -
6952+-- Name: l_musicinterest_typeid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6953 --
6954 
6955 CREATE UNIQUE INDEX l_musicinterest_typeid_key ON l_musicinterest USING btree (typeid);
6956 
6957 
6958 --
6959--- Name: member_memberid_key; Type: INDEX; Schema: public; Owner: -
6960+-- Name: member_memberid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6961 --
6962 
6963 CREATE UNIQUE INDEX member_memberid_key ON member USING btree (memberid);
6964 
6965 
6966 --
6967--- Name: member_office_member_office_key; Type: INDEX; Schema: public; Owner: -
6968+-- Name: member_office_member_office_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6969 --
6970 
6971 CREATE UNIQUE INDEX member_office_member_office_key ON member_officer USING btree (member_officerid);
6972 
6973 
6974 --
6975--- Name: officer_officerid_key; Type: INDEX; Schema: public; Owner: -
6976+-- Name: officer_officerid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6977 --
6978 
6979 CREATE UNIQUE INDEX officer_officerid_key ON officer USING btree (officerid);
6980 
6981 
6982 --
6983--- Name: rec_record_dateadded_key; Type: INDEX; Schema: public; Owner: -
6984+-- Name: rec_record_dateadded_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6985 --
6986 
6987 CREATE INDEX rec_record_dateadded_key ON rec_record USING btree (dateadded);
6988 
6989 
6990 --
6991--- Name: rec_record_format_key; Type: INDEX; Schema: public; Owner: -
6992+-- Name: rec_record_format_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
6993 --
6994 
6995 CREATE INDEX rec_record_format_key ON rec_record USING btree (format) WHERE (format = 's'::bpchar);
6996 
6997 
6998 --
6999--- Name: rec_record_recordid_key; Type: INDEX; Schema: public; Owner: -
7000+-- Name: rec_record_recordid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7001 --
7002 
7003 CREATE UNIQUE INDEX rec_record_recordid_key ON rec_record USING btree (recordid);
7004 
7005 
7006 --
7007--- Name: rec_track_artist_index; Type: INDEX; Schema: public; Owner: -
7008+-- Name: rec_track_artist_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
7009 --
7010 
7011 CREATE INDEX rec_track_artist_index ON rec_track USING btree (artist);
7012 
7013 
7014 --
7015--- Name: rec_track_recordid_key; Type: INDEX; Schema: public; Owner: -
7016+-- Name: rec_track_recordid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7017 --
7018 
7019 CREATE INDEX rec_track_recordid_key ON rec_track USING btree (recordid);
7020 
7021 
7022 --
7023--- Name: rec_track_trackid_key; Type: INDEX; Schema: public; Owner: -
7024+-- Name: rec_track_trackid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7025 --
7026 
7027 CREATE UNIQUE INDEX rec_track_trackid_key ON rec_track USING btree (trackid);
7028 
7029 
7030 --
7031--- Name: rec_unique_recordid; Type: INDEX; Schema: public; Owner: -
7032+-- Name: rec_unique_recordid; Type: INDEX; Schema: public; Owner: -; Tablespace:
7033 --
7034 
7035 CREATE INDEX rec_unique_recordid ON rec_labelqueue USING btree (recordid);
7036 
7037 
7038 --
7039--- Name: recommended_listening_chartweek_key; Type: INDEX; Schema: public; Owner: -
7040+-- Name: recommended_listening_chartweek_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7041 --
7042 
7043 CREATE INDEX recommended_listening_chartweek_key ON recommended_listening USING btree (week);
7044 
7045 
7046 --
7047--- Name: sched_entrytype_entrytypenamenews_key; Type: INDEX; Schema: public; Owner: -
7048---
7049-
7050-CREATE INDEX sched_entrytype_entrytypenamenews_key ON sched_entrytype USING btree (entrytypename) WHERE ((entrytypename)::text = 'News'::text);
7051-
7052-
7053---
7054--- Name: strm_log_starttime_key; Type: INDEX; Schema: public; Owner: -
7055+-- Name: strm_log_starttime_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7056 --
7057 
7058 CREATE INDEX strm_log_starttime_key ON strm_log USING btree (starttime);
7059@@ -11129,14 +9712,14 @@
7060 
7061 
7062 --
7063--- Name: strm_log_steamid_key; Type: INDEX; Schema: public; Owner: -
7064+-- Name: strm_log_steamid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7065 --
7066 
7067 CREATE INDEX strm_log_steamid_key ON strm_log USING btree (streamid);
7068 
7069 
7070 --
7071--- Name: team_teamid_key; Type: INDEX; Schema: public; Owner: -
7072+-- Name: team_teamid_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
7073 --
7074 
7075 CREATE UNIQUE INDEX team_teamid_key ON team USING btree (teamid);
7076@@ -11145,207 +9728,163 @@
7077 SET search_path = schedule, pg_catalog;
7078 
7079 --
7080--- Name: block_range_rule_end_time_index; Type: INDEX; Schema: schedule; Owner: -
7081+-- Name: block_range_rule_end_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7082 --
7083 
7084 CREATE INDEX block_range_rule_end_time_index ON block_range_rule USING btree (end_time);
7085 
7086 
7087 --
7088--- Name: block_range_rule_start_time_index; Type: INDEX; Schema: schedule; Owner: -
7089+-- Name: block_range_rule_start_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7090 --
7091 
7092 CREATE INDEX block_range_rule_start_time_index ON block_range_rule USING btree (start_time);
7093 
7094 
7095 --
7096--- Name: duration; Type: INDEX; Schema: schedule; Owner: -
7097+-- Name: duration; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7098 --
7099 
7100 CREATE INDEX duration ON show_season_timeslot USING btree (duration);
7101 
7102 
7103 --
7104--- Name: season_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -
7105+-- Name: season_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7106 --
7107 
7108 CREATE INDEX season_metadata_effective_from_index ON season_metadata USING btree (effective_from);
7109 
7110 
7111 --
7112--- Name: season_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -
7113+-- Name: season_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7114 --
7115 
7116 CREATE INDEX season_metadata_effective_to_index ON season_metadata USING btree (effective_to);
7117 
7118 
7119 --
7120--- Name: show_credit_effective_from_index; Type: INDEX; Schema: schedule; Owner: -
7121+-- Name: show_credit_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7122 --
7123 
7124 CREATE INDEX show_credit_effective_from_index ON show_credit USING btree (effective_from);
7125 
7126 
7127 --
7128--- Name: show_credit_effective_to_index; Type: INDEX; Schema: schedule; Owner: -
7129+-- Name: show_credit_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7130 --
7131 
7132 CREATE INDEX show_credit_effective_to_index ON show_credit USING btree (effective_to);
7133 
7134 
7135 --
7136--- Name: show_id_index; Type: INDEX; Schema: schedule; Owner: -
7137+-- Name: show_id_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7138 --
7139 
7140 CREATE INDEX show_id_index ON show_credit USING btree (show_id);
7141 
7142 
7143 --
7144--- Name: show_image_metadata_approvedid; Type: INDEX; Schema: schedule; Owner: -
7145+-- Name: show_image_metadata_approvedid; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7146 --
7147 
7148 CREATE INDEX show_image_metadata_approvedid ON show_image_metadata USING btree (approvedid);
7149 
7150 
7151 --
7152--- Name: show_image_metadata_memberid; Type: INDEX; Schema: schedule; Owner: -
7153+-- Name: show_image_metadata_memberid; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7154 --
7155 
7156 CREATE INDEX show_image_metadata_memberid ON show_image_metadata USING btree (memberid);
7157 
7158 
7159 --
7160--- Name: show_image_metadata_metadata_key_id; Type: INDEX; Schema: schedule; Owner: -
7161+-- Name: show_image_metadata_metadata_key_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7162 --
7163 
7164 CREATE INDEX show_image_metadata_metadata_key_id ON show_image_metadata USING btree (metadata_key_id);
7165 
7166 
7167 --
7168--- Name: show_image_metadata_show_id; Type: INDEX; Schema: schedule; Owner: -
7169+-- Name: show_image_metadata_show_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7170 --
7171 
7172 CREATE INDEX show_image_metadata_show_id ON show_image_metadata USING btree (show_id);
7173 
7174 
7175 --
7176--- Name: show_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -
7177+-- Name: show_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7178 --
7179 
7180 CREATE INDEX show_metadata_effective_from_index ON show_metadata USING btree (effective_from);
7181 
7182 
7183 --
7184--- Name: show_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -
7185+-- Name: show_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7186 --
7187 
7188 CREATE INDEX show_metadata_effective_to_index ON show_metadata USING btree (effective_to);
7189 
7190 
7191 --
7192--- Name: show_podcast_link_podcast_id; Type: INDEX; Schema: schedule; Owner: -
7193+-- Name: show_podcast_link_podcast_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7194 --
7195 
7196 CREATE INDEX show_podcast_link_podcast_id ON show_podcast_link USING btree (podcast_id);
7197 
7198 
7199 --
7200--- Name: show_season_index; Type: INDEX; Schema: schedule; Owner: -
7201+-- Name: show_season_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7202 --
7203 
7204 CREATE INDEX show_season_index ON show_season_timeslot USING btree (show_season_id);
7205 
7206 
7207 --
7208--- Name: start_time_index; Type: INDEX; Schema: schedule; Owner: -
7209+-- Name: start_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7210 --
7211 
7212 CREATE INDEX start_time_index ON show_season_timeslot USING btree (start_time);
7213 
7214 
7215 --
7216--- Name: timeslot_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -
7217+-- Name: timeslot_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7218 --
7219 
7220 CREATE INDEX timeslot_metadata_effective_from_index ON timeslot_metadata USING btree (effective_from);
7221 
7222 
7223 --
7224--- Name: timeslot_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -
7225+-- Name: timeslot_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace:
7226 --
7227 
7228 CREATE INDEX timeslot_metadata_effective_to_index ON timeslot_metadata USING btree (effective_to);
7229 
7230 
7231-SET search_path = smsd, pg_catalog;
7232-
7233---
7234--- Name: outbox_date; Type: INDEX; Schema: smsd; Owner: -
7235---
7236-
7237-CREATE INDEX outbox_date ON outbox USING btree ("SendingDateTime", "SendingTimeOut");
7238-
7239-
7240---
7241--- Name: outbox_sender; Type: INDEX; Schema: smsd; Owner: -
7242---
7243-
7244-CREATE INDEX outbox_sender ON outbox USING btree ("SenderID");
7245-
7246-
7247---
7248--- Name: sentitems_date; Type: INDEX; Schema: smsd; Owner: -
7249---
7250-
7251-CREATE INDEX sentitems_date ON sentitems USING btree ("DeliveryDateTime");
7252-
7253-
7254---
7255--- Name: sentitems_dest; Type: INDEX; Schema: smsd; Owner: -
7256---
7257-
7258-CREATE INDEX sentitems_dest ON sentitems USING btree ("DestinationNumber");
7259-
7260-
7261---
7262--- Name: sentitems_sender; Type: INDEX; Schema: smsd; Owner: -
7263---
7264-
7265-CREATE INDEX sentitems_sender ON sentitems USING btree ("SenderID");
7266-
7267-
7268---
7269--- Name: sentitems_tpmr; Type: INDEX; Schema: smsd; Owner: -
7270---
7271-
7272-CREATE INDEX sentitems_tpmr ON sentitems USING btree ("TPMR");
7273-
7274-
7275 SET search_path = tracklist, pg_catalog;
7276 
7277 --
7278--- Name: index_tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -
7279+-- Name: index_tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -; Tablespace:
7280 --
7281 
7282 CREATE INDEX index_tracklist_tracklist_timeslotid ON tracklist USING btree (timeslotid);
7283 
7284 
7285 --
7286--- Name: index_tracklist_tracklist_timestart; Type: INDEX; Schema: tracklist; Owner: -
7287+-- Name: index_tracklist_tracklist_timestart; Type: INDEX; Schema: tracklist; Owner: -; Tablespace:
7288 --
7289 
7290 CREATE INDEX index_tracklist_tracklist_timestart ON tracklist USING btree (timestart);
7291 
7292 
7293 --
7294--- Name: index_tracklist_tracklist_timestop; Type: INDEX; Schema: tracklist; Owner: -
7295+-- Name: index_tracklist_tracklist_timestop; Type: INDEX; Schema: tracklist; Owner: -; Tablespace:
7296 --
7297 
7298 CREATE INDEX index_tracklist_tracklist_timestop ON tracklist USING btree (timestop);
7299 
7300 
7301 --
7302--- Name: tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -
7303+-- Name: tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -; Tablespace:
7304 --
7305 
7306 CREATE INDEX tracklist_tracklist_timeslotid ON tracklist USING btree (timeslotid);
7307@@ -11354,133 +9893,133 @@
7308 SET search_path = uryplayer, pg_catalog;
7309 
7310 --
7311--- Name: podcast_approvedid; Type: INDEX; Schema: uryplayer; Owner: -
7312+-- Name: podcast_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7313 --
7314 
7315 CREATE INDEX podcast_approvedid ON podcast USING btree (approvedid);
7316 
7317 
7318 --
7319--- Name: podcast_credit_approvedid; Type: INDEX; Schema: uryplayer; Owner: -
7320+-- Name: podcast_credit_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7321 --
7322 
7323 CREATE INDEX podcast_credit_approvedid ON podcast_credit USING btree (approvedid);
7324 
7325 
7326 --
7327--- Name: podcast_credit_credit_type_id; Type: INDEX; Schema: uryplayer; Owner: -
7328+-- Name: podcast_credit_credit_type_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7329 --
7330 
7331 CREATE INDEX podcast_credit_credit_type_id ON podcast_credit USING btree (credit_type_id);
7332 
7333 
7334 --
7335--- Name: podcast_credit_creditid; Type: INDEX; Schema: uryplayer; Owner: -
7336+-- Name: podcast_credit_creditid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7337 --
7338 
7339 CREATE INDEX podcast_credit_creditid ON podcast_credit USING btree (creditid);
7340 
7341 
7342 --
7343--- Name: podcast_credit_memberid; Type: INDEX; Schema: uryplayer; Owner: -
7344+-- Name: podcast_credit_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7345 --
7346 
7347 CREATE INDEX podcast_credit_memberid ON podcast_credit USING btree (memberid);
7348 
7349 
7350 --
7351--- Name: podcast_credit_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -
7352+-- Name: podcast_credit_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7353 --
7354 
7355 CREATE INDEX podcast_credit_podcast_id ON podcast_credit USING btree (podcast_id);
7356 
7357 
7358 --
7359--- Name: podcast_image_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -
7360+-- Name: podcast_image_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7361 --
7362 
7363 CREATE INDEX podcast_image_metadata_approvedid ON podcast_image_metadata USING btree (approvedid);
7364 
7365 
7366 --
7367--- Name: podcast_image_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -
7368+-- Name: podcast_image_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7369 --
7370 
7371 CREATE INDEX podcast_image_metadata_memberid ON podcast_image_metadata USING btree (memberid);
7372 
7373 
7374 --
7375--- Name: podcast_image_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -
7376+-- Name: podcast_image_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7377 --
7378 
7379 CREATE INDEX podcast_image_metadata_metadata_key_id ON podcast_image_metadata USING btree (metadata_key_id);
7380 
7381 
7382 --
7383--- Name: podcast_image_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -
7384+-- Name: podcast_image_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7385 --
7386 
7387 CREATE INDEX podcast_image_metadata_podcast_id ON podcast_image_metadata USING btree (podcast_id);
7388 
7389 
7390 --
7391--- Name: podcast_memberid; Type: INDEX; Schema: uryplayer; Owner: -
7392+-- Name: podcast_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7393 --
7394 
7395 CREATE INDEX podcast_memberid ON podcast USING btree (memberid);
7396 
7397 
7398 --
7399--- Name: podcast_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -
7400+-- Name: podcast_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7401 --
7402 
7403 CREATE INDEX podcast_metadata_approvedid ON podcast_metadata USING btree (approvedid);
7404 
7405 
7406 --
7407--- Name: podcast_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -
7408+-- Name: podcast_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7409 --
7410 
7411 CREATE INDEX podcast_metadata_memberid ON podcast_metadata USING btree (memberid);
7412 
7413 
7414 --
7415--- Name: podcast_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -
7416+-- Name: podcast_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7417 --
7418 
7419 CREATE INDEX podcast_metadata_metadata_key_id ON podcast_metadata USING btree (metadata_key_id);
7420 
7421 
7422 --
7423--- Name: podcast_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -
7424+-- Name: podcast_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7425 --
7426 
7427 CREATE INDEX podcast_metadata_podcast_id ON podcast_metadata USING btree (podcast_id);
7428 
7429 
7430 --
7431--- Name: podcast_package_entry_approvedid; Type: INDEX; Schema: uryplayer; Owner: -
7432+-- Name: podcast_package_entry_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7433 --
7434 
7435 CREATE INDEX podcast_package_entry_approvedid ON podcast_package_entry USING btree (approvedid);
7436 
7437 
7438 --
7439--- Name: podcast_package_entry_memberid; Type: INDEX; Schema: uryplayer; Owner: -
7440+-- Name: podcast_package_entry_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7441 --
7442 
7443 CREATE INDEX podcast_package_entry_memberid ON podcast_package_entry USING btree (memberid);
7444 
7445 
7446 --
7447--- Name: podcast_package_entry_package_id; Type: INDEX; Schema: uryplayer; Owner: -
7448+-- Name: podcast_package_entry_package_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7449 --
7450 
7451 CREATE INDEX podcast_package_entry_package_id ON podcast_package_entry USING btree (package_id);
7452 
7453 
7454 --
7455--- Name: podcast_package_entry_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -
7456+-- Name: podcast_package_entry_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace:
7457 --
7458 
7459 CREATE INDEX podcast_package_entry_podcast_id ON podcast_package_entry USING btree (podcast_id);
7460@@ -11489,105 +10028,105 @@
7461 SET search_path = website, pg_catalog;
7462 
7463 --
7464--- Name: banner_campaign_approvedid; Type: INDEX; Schema: website; Owner: -
7465+-- Name: banner_campaign_approvedid; Type: INDEX; Schema: website; Owner: -; Tablespace:
7466 --
7467 
7468 CREATE INDEX banner_campaign_approvedid ON banner_campaign USING btree (approvedid);
7469 
7470 
7471 --
7472--- Name: banner_campaign_banner_id; Type: INDEX; Schema: website; Owner: -
7473+-- Name: banner_campaign_banner_id; Type: INDEX; Schema: website; Owner: -; Tablespace:
7474 --
7475 
7476 CREATE INDEX banner_campaign_banner_id ON banner_campaign USING btree (banner_id);
7477 
7478 
7479 --
7480--- Name: banner_campaign_banner_location_id; Type: INDEX; Schema: website; Owner: -
7481+-- Name: banner_campaign_banner_location_id; Type: INDEX; Schema: website; Owner: -; Tablespace:
7482 --
7483 
7484 CREATE INDEX banner_campaign_banner_location_id ON banner_campaign USING btree (banner_location_id);
7485 
7486 
7487 --
7488--- Name: banner_campaign_effective_from_index; Type: INDEX; Schema: website; Owner: -
7489+-- Name: banner_campaign_effective_from_index; Type: INDEX; Schema: website; Owner: -; Tablespace:
7490 --
7491 
7492 CREATE INDEX banner_campaign_effective_from_index ON banner_campaign USING btree (effective_from);
7493 
7494 
7495 --
7496--- Name: banner_campaign_effective_to_index; Type: INDEX; Schema: website; Owner: -
7497+-- Name: banner_campaign_effective_to_index; Type: INDEX; Schema: website; Owner: -; Tablespace:
7498 --
7499 
7500 CREATE INDEX banner_campaign_effective_to_index ON banner_campaign USING btree (effective_to);
7501 
7502 
7503 --
7504--- Name: banner_campaign_memberid; Type: INDEX; Schema: website; Owner: -
7505+-- Name: banner_campaign_memberid; Type: INDEX; Schema: website; Owner: -; Tablespace:
7506 --
7507 
7508 CREATE INDEX banner_campaign_memberid ON banner_campaign USING btree (memberid);
7509 
7510 
7511 --
7512--- Name: banner_location_name; Type: INDEX; Schema: website; Owner: -
7513+-- Name: banner_location_name; Type: INDEX; Schema: website; Owner: -; Tablespace:
7514 --
7515 
7516 CREATE INDEX banner_location_name ON banner_location USING btree (name);
7517 
7518 
7519 --
7520--- Name: banner_location_name_like; Type: INDEX; Schema: website; Owner: -
7521+-- Name: banner_location_name_like; Type: INDEX; Schema: website; Owner: -; Tablespace:
7522 --
7523 
7524 CREATE INDEX banner_location_name_like ON banner_location USING btree (name varchar_pattern_ops);
7525 
7526 
7527 --
7528--- Name: banner_timeslot_approvedid; Type: INDEX; Schema: website; Owner: -
7529+-- Name: banner_timeslot_approvedid; Type: INDEX; Schema: website; Owner: -; Tablespace:
7530 --
7531 
7532 CREATE INDEX banner_timeslot_approvedid ON banner_timeslot USING btree (approvedid);
7533 
7534 
7535 --
7536--- Name: banner_timeslot_banner_campaign_id; Type: INDEX; Schema: website; Owner: -
7537+-- Name: banner_timeslot_banner_campaign_id; Type: INDEX; Schema: website; Owner: -; Tablespace:
7538 --
7539 
7540 CREATE INDEX banner_timeslot_banner_campaign_id ON banner_timeslot USING btree (banner_campaign_id);
7541 
7542 
7543 --
7544--- Name: banner_timeslot_from_time_index; Type: INDEX; Schema: website; Owner: -
7545+-- Name: banner_timeslot_from_time_index; Type: INDEX; Schema: website; Owner: -; Tablespace:
7546 --
7547 
7548 CREATE INDEX banner_timeslot_from_time_index ON banner_timeslot USING btree (start_time);
7549 
7550 
7551 --
7552--- Name: banner_timeslot_memberid; Type: INDEX; Schema: website; Owner: -
7553+-- Name: banner_timeslot_memberid; Type: INDEX; Schema: website; Owner: -; Tablespace:
7554 --
7555 
7556 CREATE INDEX banner_timeslot_memberid ON banner_timeslot USING btree (memberid);
7557 
7558 
7559 --
7560--- Name: banner_timeslot_to_time_index; Type: INDEX; Schema: website; Owner: -
7561+-- Name: banner_timeslot_to_time_index; Type: INDEX; Schema: website; Owner: -; Tablespace:
7562 --
7563 
7564 CREATE INDEX banner_timeslot_to_time_index ON banner_timeslot USING btree (end_time);
7565 
7566 
7567 --
7568--- Name: banner_type_name; Type: INDEX; Schema: website; Owner: -
7569+-- Name: banner_type_name; Type: INDEX; Schema: website; Owner: -; Tablespace:
7570 --
7571 
7572 CREATE INDEX banner_type_name ON banner_type USING btree (name);
7573 
7574 
7575 --
7576--- Name: banner_type_name_like; Type: INDEX; Schema: website; Owner: -
7577+-- Name: banner_type_name_like; Type: INDEX; Schema: website; Owner: -; Tablespace:
7578 --
7579 
7580 CREATE INDEX banner_type_name_like ON banner_type USING btree (name varchar_pattern_ops);
7581@@ -11618,43 +10157,6 @@
7582 CREATE TRIGGER set_shelfcode_trigger BEFORE INSERT ON rec_record FOR EACH ROW EXECUTE PROCEDURE set_shelfcode_func();
7583 
7584 
7585-SET search_path = smsd, pg_catalog;
7586-
7587---
7588--- Name: gammutafter; Type: TRIGGER; Schema: smsd; Owner: -
7589---
7590-
7591-CREATE TRIGGER gammutafter AFTER INSERT ON inbox FOR EACH ROW EXECUTE PROCEDURE public.process_gammu_text();
7592-
7593-
7594---
7595--- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: -
7596---
7597-
7598-CREATE TRIGGER update_timestamp BEFORE UPDATE ON inbox FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp();
7599-
7600-
7601---
7602--- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: -
7603---
7604-
7605-CREATE TRIGGER update_timestamp BEFORE UPDATE ON outbox FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp();
7606-
7607-
7608---
7609--- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: -
7610---
7611-
7612-CREATE TRIGGER update_timestamp BEFORE UPDATE ON phones FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp();
7613-
7614-
7615---
7616--- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: -
7617---
7618-
7619-CREATE TRIGGER update_timestamp BEFORE UPDATE ON sentitems FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp();
7620-
7621-
7622 SET search_path = bapsplanner, pg_catalog;
7623 
7624 --
7625@@ -11713,16 +10215,6 @@
7626     ADD CONSTRAINT timeslot_items_timeslot_id_fkey FOREIGN KEY (timeslot_id) REFERENCES schedule.show_season_timeslot(show_season_timeslot_id) ON UPDATE CASCADE ON DELETE CASCADE;
7627 
7628 
7629-SET search_path = deploy, pg_catalog;
7630-
7631---
7632--- Name: myury_memberid_fkey; Type: FK CONSTRAINT; Schema: deploy; Owner: -
7633---
7634-
7635-ALTER TABLE ONLY myury
7636-    ADD CONSTRAINT myury_memberid_fkey FOREIGN KEY (memberid) REFERENCES public.member(memberid) ON DELETE CASCADE;
7637-
7638-
7639 SET search_path = jukebox, pg_catalog;
7640 
7641 --
7642@@ -11734,14 +10226,6 @@
7643 
7644 
7645 --
7646--- Name: playlist_availability_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: -
7647---
7648-
7649-ALTER TABLE ONLY playlist_availability
7650-    ADD CONSTRAINT playlist_availability_playlistid_fkey FOREIGN KEY (playlistid) REFERENCES playlists(playlistid) ON UPDATE CASCADE;
7651-
7652-
7653---
7654 -- Name: playlist_entries_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: -
7655 --
7656 
7657@@ -11806,18 +10290,10 @@
7658 
7659 
7660 --
7661--- Name: playlist_timeslot_playlist_availability_id_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: -
7662---
7663-
7664-ALTER TABLE ONLY playlist_timeslot
7665-    ADD CONSTRAINT playlist_timeslot_playlist_availability_id_fkey FOREIGN KEY (playlist_availability_id) REFERENCES playlist_availability(playlist_availability_id);
7666-
7667-
7668---
7669 -- Name: playlist_timeslot_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: -
7670 --
7671 
7672-ALTER TABLE ONLY playlist_availability
7673+ALTER TABLE ONLY playlist_timeslot
7674     ADD CONSTRAINT playlist_timeslot_playlistid_fkey FOREIGN KEY (playlistid) REFERENCES playlists(playlistid);
7675 
7676 
7677@@ -11853,42 +10329,6 @@
7678     ADD CONSTRAINT track_blacklist_trackid_fkey FOREIGN KEY (trackid) REFERENCES public.rec_track(trackid);
7679 
7680 
7681-SET search_path = loggerng, pg_catalog;
7682-
7683---
7684--- Name: requests_start_fkey; Type: FK CONSTRAINT; Schema: loggerng; Owner: -
7685---
7686-
7687-ALTER TABLE ONLY requests
7688-    ADD CONSTRAINT requests_start_fkey FOREIGN KEY (start, "end", format) REFERENCES logs(start, "end", format) ON UPDATE CASCADE ON DELETE CASCADE;
7689-
7690-
7691---
7692--- Name: requests_user_fkey; Type: FK CONSTRAINT; Schema: loggerng; Owner: -
7693---
7694-
7695-ALTER TABLE ONLY requests
7696-    ADD CONSTRAINT requests_user_fkey FOREIGN KEY ("user") REFERENCES public.member(memberid);
7697-
7698-
7699-SET search_path = loggerng_test, pg_catalog;
7700-
7701---
7702--- Name: requests_start_fkey; Type: FK CONSTRAINT; Schema: loggerng_test; Owner: -
7703---
7704-
7705-ALTER TABLE ONLY requests
7706-    ADD CONSTRAINT requests_start_fkey FOREIGN KEY (start, "end", format) REFERENCES logs(start, "end", format) ON UPDATE CASCADE ON DELETE CASCADE;
7707-
7708-
7709---
7710--- Name: requests_user_fkey; Type: FK CONSTRAINT; Schema: loggerng_test; Owner: -
7711---
7712-
7713-ALTER TABLE ONLY requests
7714-    ADD CONSTRAINT requests_user_fkey FOREIGN KEY ("user") REFERENCES public.member(memberid);
7715-
7716-
7717 SET search_path = mail, pg_catalog;
7718 
7719 --
7720@@ -12550,6 +10990,14 @@
7721 
7722 
7723 --
7724+-- Name: $4; Type: FK CONSTRAINT; Schema: public; Owner: -
7725+--
7726+
7727+ALTER TABLE ONLY rec_track
7728+    ADD CONSTRAINT "$4" FOREIGN KEY (last_edited_memberid) REFERENCES member(memberid) ON UPDATE CASCADE ON DELETE SET NULL;
7729+
7730+
7731+--
7732 -- Name: $6; Type: FK CONSTRAINT; Schema: public; Owner: -
7733 --
7734 
7735@@ -12626,7 +11074,7 @@
7736 --
7737 
7738 ALTER TABLE ONLY baps_item
7739-    ADD CONSTRAINT baps_item_fileitemid_fkey FOREIGN KEY (fileitemid) REFERENCES baps_fileitem(fileitemid) ON UPDATE CASCADE ON DELETE CASCADE;
7740+    ADD CONSTRAINT baps_item_fileitemid_fkey FOREIGN KEY (fileitemid) REFERENCES baps_fileitem(fileitemid);
7741 
7742 
7743 --
7744@@ -12634,7 +11082,7 @@
7745 --
7746 
7747 ALTER TABLE ONLY baps_item
7748-    ADD CONSTRAINT baps_item_libraryitemid_fkey FOREIGN KEY (libraryitemid) REFERENCES baps_libraryitem(libraryitemid) ON UPDATE CASCADE ON DELETE CASCADE;
7749+    ADD CONSTRAINT baps_item_libraryitemid_fkey FOREIGN KEY (libraryitemid) REFERENCES baps_libraryitem(libraryitemid);
7750 
7751 
7752 --
7753@@ -12846,14 +11294,6 @@
7754 
7755 
7756 --
7757--- Name: rec_track_lasteditedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7758---
7759-
7760-ALTER TABLE ONLY rec_track
7761-    ADD CONSTRAINT rec_track_lasteditedby_fkey FOREIGN KEY (last_edited_memberid) REFERENCES member(memberid) ON UPDATE CASCADE ON DELETE SET NULL;
7762-
7763-
7764---
7765 -- Name: rec_trackcorrection_reviewedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7766 --
7767 
7768@@ -12870,22 +11310,6 @@
7769 
7770 
7771 --
7772--- Name: rec_trackproposal_proposedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7773---
7774-
7775-ALTER TABLE ONLY rec_trackproposal
7776-    ADD CONSTRAINT rec_trackproposal_proposedby_fkey FOREIGN KEY (proposedby) REFERENCES member(memberid);
7777-
7778-
7779---
7780--- Name: rec_trackproposal_reviewedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7781---
7782-
7783-ALTER TABLE ONLY rec_trackproposal
7784-    ADD CONSTRAINT rec_trackproposal_reviewedby_fkey FOREIGN KEY (reviewedby) REFERENCES member(memberid);
7785-
7786-
7787---
7788 -- Name: selector_action_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
7789 --
7790 
7791@@ -12909,40 +11333,6 @@
7792     ADD CONSTRAINT user_id_refs_id_831107f1 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;
7793 
7794 
7795-SET search_path = rapier, pg_catalog;
7796-
7797---
7798--- Name: acl_member_memberid_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: -
7799---
7800-
7801-ALTER TABLE ONLY acl_member
7802-    ADD CONSTRAINT acl_member_memberid_fkey FOREIGN KEY (memberid) REFERENCES public.member(memberid) ON UPDATE CASCADE ON DELETE CASCADE;
7803-
7804-
7805---
7806--- Name: acl_member_scope_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: -
7807---
7808-
7809-ALTER TABLE ONLY acl_member
7810-    ADD CONSTRAINT acl_member_scope_fkey FOREIGN KEY (scope) REFERENCES constants_acl_scope(scopeid) ON UPDATE SET DEFAULT ON DELETE SET DEFAULT;
7811-
7812-
7813---
7814--- Name: acl_officer_officerid_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: -
7815---
7816-
7817-ALTER TABLE ONLY acl_officer
7818-    ADD CONSTRAINT acl_officer_officerid_fkey FOREIGN KEY (officerid) REFERENCES public.officer(officerid) ON UPDATE CASCADE ON DELETE CASCADE;
7819-
7820-
7821---
7822--- Name: acl_officer_scope_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: -
7823---
7824-
7825-ALTER TABLE ONLY acl_officer
7826-    ADD CONSTRAINT acl_officer_scope_fkey FOREIGN KEY (scope) REFERENCES constants_acl_scope(scopeid) ON UPDATE SET DEFAULT ON DELETE SET DEFAULT;
7827-
7828-
7829 SET search_path = schedule, pg_catalog;
7830 
7831 --
7832@@ -13440,6 +11830,14 @@
7833 
7834 
7835 --
7836+-- Name: podcast_credit_credit_type_id_fkey; Type: FK CONSTRAINT; Schema: uryplayer; Owner: -
7837+--
7838+
7839+ALTER TABLE ONLY podcast_credit
7840+    ADD CONSTRAINT podcast_credit_credit_type_id_fkey FOREIGN KEY (credit_type_id) REFERENCES people.credit_type(credit_type_id) DEFERRABLE INITIALLY DEFERRED;
7841+
7842+
7843+--
7844 -- Name: podcast_credit_creditid_fkey; Type: FK CONSTRAINT; Schema: uryplayer; Owner: -
7845 --
7846 
7847@@ -13646,4 +12044,3 @@
7848 --
7849 -- PostgreSQL database dump complete
7850 --
7851-