Created
January 29, 2017 00:25
-
-
Save LordAro/af59c6fd1c6ed9c17414272a9e082799 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- schema.sql 2017-01-29 00:22:58.170965988 +0000 | |
| +++ schema2.sql 2017-01-29 00:23:13.124518999 +0000 | |
| @@ -2,23 +2,12 @@ | |
| -- PostgreSQL database dump | |
| -- | |
| --- Dumped from database version 9.5.5 | |
| --- Dumped by pg_dump version 9.5.5 | |
| - | |
| SET statement_timeout = 0; | |
| SET lock_timeout = 0; | |
| SET client_encoding = 'UTF8'; | |
| SET standard_conforming_strings = on; | |
| SET check_function_bodies = false; | |
| SET client_min_messages = warning; | |
| -SET row_security = off; | |
| - | |
| --- | |
| --- Name: membership; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON DATABASE membership IS 'URY database for EVERYTHING.'; | |
| - | |
| -- | |
| -- Name: bapsplanner; Type: SCHEMA; Schema: -; Owner: - | |
| @@ -35,20 +24,6 @@ | |
| -- | |
| --- Name: deploy; Type: SCHEMA; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE SCHEMA deploy; | |
| - | |
| - | |
| --- | |
| --- Name: SCHEMA deploy; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON SCHEMA deploy IS 'used by Studio Infomation Service. Deprecated somewhat.'; | |
| - | |
| - | |
| --- | |
| -- Name: jukebox; Type: SCHEMA; Schema: -; Owner: - | |
| -- | |
| @@ -63,34 +38,6 @@ | |
| -- | |
| --- Name: loggerng; Type: SCHEMA; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE SCHEMA loggerng; | |
| - | |
| - | |
| --- | |
| --- Name: SCHEMA loggerng; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON SCHEMA loggerng IS 'Used by the Logger.'; | |
| - | |
| - | |
| --- | |
| --- Name: loggerng_test; Type: SCHEMA; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE SCHEMA loggerng_test; | |
| - | |
| - | |
| --- | |
| --- Name: SCHEMA loggerng_test; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON SCHEMA loggerng_test IS 'Schema for testing loggerng-server'; | |
| - | |
| - | |
| --- | |
| -- Name: mail; Type: SCHEMA; Schema: -; Owner: - | |
| -- | |
| @@ -115,7 +62,7 @@ | |
| -- Name: SCHEMA metadata; Type: COMMENT; Schema: -; Owner: - | |
| -- | |
| -COMMENT ON SCHEMA metadata IS 'Metadata systems. Not long for this world?'; | |
| +COMMENT ON SCHEMA metadata IS 'Metadata systems.'; | |
| -- | |
| @@ -168,20 +115,6 @@ | |
| -- | |
| --- Name: rapier; Type: SCHEMA; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE SCHEMA rapier; | |
| - | |
| - | |
| --- | |
| --- Name: SCHEMA rapier; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON SCHEMA rapier IS 'Internal information for Rapier, the API for Electronic Radio. UNUSED (Probably).'; | |
| - | |
| - | |
| --- | |
| -- Name: schedule; Type: SCHEMA; Schema: -; Owner: - | |
| -- | |
| @@ -192,7 +125,7 @@ | |
| -- Name: SCHEMA schedule; Type: COMMENT; Schema: -; Owner: - | |
| -- | |
| -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.'; | |
| +COMMENT ON SCHEMA schedule IS 'Schema for the MyRadio schedule.'; | |
| -- | |
| @@ -210,20 +143,6 @@ | |
| -- | |
| --- Name: smsd; Type: SCHEMA; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE SCHEMA smsd; | |
| - | |
| - | |
| --- | |
| --- Name: SCHEMA smsd; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON SCHEMA smsd IS 'Stores internal metadata for the Gammu SMS Daemon'; | |
| - | |
| - | |
| --- | |
| -- Name: tracklist; Type: SCHEMA; Schema: -; Owner: - | |
| -- | |
| @@ -286,82 +205,36 @@ | |
| COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | |
| --- | |
| --- Name: unaccent; Type: EXTENSION; Schema: -; Owner: - | |
| --- | |
| - | |
| -CREATE EXTENSION IF NOT EXISTS unaccent WITH SCHEMA public; | |
| - | |
| - | |
| --- | |
| --- Name: EXTENSION unaccent; Type: COMMENT; Schema: -; Owner: - | |
| --- | |
| - | |
| -COMMENT ON EXTENSION unaccent IS 'text search dictionary that removes accents'; | |
| - | |
| - | |
| SET search_path = public, pg_catalog; | |
| -- | |
| --- Name: showtime; Type: TYPE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TYPE showtime AS ( | |
| - unixstart integer, | |
| - unixend integer, | |
| - description character varying | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: armor(bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION armor(bytea) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_armor'; | |
| - | |
| - | |
| --- | |
| -- Name: bapstotracklist(); Type: FUNCTION; Schema: public; Owner: - | |
| -- | |
| CREATE FUNCTION bapstotracklist() RETURNS trigger | |
| LANGUAGE plpgsql | |
| - AS $$ | |
| -DECLARE | |
| - audid INTEGER; | |
| + AS $$DECLARE | |
| +audid INTEGER; | |
| BEGIN | |
| - IF ((TG_OP = 'UPDATE') | |
| - 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) | |
| - AND ((SELECT COUNT(*) FROM baps_audio ba WHERE ba.audioid = NEW."audioid" AND ba.trackid > 0) = 1) | |
| - AND ((NEW."timestopped" - NEW."timeplayed" > '00:00:30')) | |
| - AND ((SELECT COUNT(*) FROM tracklist.tracklist WHERE bapsaudioid = NEW."audiologid") = 0)) | |
| - THEN | |
| - INSERT INTO tracklist.tracklist (SOURCE, timestart, timestop, timeslotid, bapsaudioid) | |
| - 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() | |
| - AND show_season_id != 0 | |
| - ORDER BY show_season_timeslot_id ASC | |
| - LIMIT 1), | |
| - NEW."audiologid") | |
| - RETURNING audiologid INTO audid; | |
| - INSERT INTO tracklist.track_rec | |
| - VALUES ("audid", (SELECT rec.recordid FROM rec_track rec | |
| - INNER JOIN baps_audio ba USING (trackid) | |
| - WHERE ba.audioid = NEW."audioid"), | |
| - (SELECT trackid FROM baps_audio WHERE audioid = NEW."audioid")); | |
| - END IF; | |
| - RETURN NULL; | |
| -END; | |
| -$$; | |
| + IF ((TG_OP = 'UPDATE') | |
| + 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 ) | |
| + AND ((SELECT COUNT(*) FROM baps_audio ba WHERE ba.audioid = NEW."audioid" AND ba.trackid > 0 ) = 1 ) | |
| + AND ((NEW."timestopped" - NEW."timeplayed" > '00:00:30') ) | |
| + AND ((SELECT COUNT(*) FROM tracklist.tracklist WHERE bapsaudioid = NEW."audiologid") = 0) | |
| + ) | |
| + | |
| + THEN | |
| + INSERT INTO tracklist.tracklist (source, timestart, timestop, timeslotid, bapsaudioid) | |
| + 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" ) | |
| + RETURNING audiologid INTO audid; | |
| + INSERT INTO tracklist.track_rec | |
| + VALUES ("audid", (SELECT rec.recordid FROM rec_track rec INNER JOIN baps_audio ba USING (trackid) | |
| + WHERE ba.audioid = NEW."audioid"), (SELECT trackid FROM baps_audio WHERE audioid = NEW."audioid")); | |
| + | |
| + | |
| + END IF; | |
| + RETURN NULL; | |
| +END $$; | |
| -- | |
| @@ -387,335 +260,6 @@ | |
| -- | |
| --- Name: crypt(text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION crypt(text, text) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_crypt'; | |
| - | |
| - | |
| --- | |
| --- Name: dearmor(text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION dearmor(text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_dearmor'; | |
| - | |
| - | |
| --- | |
| --- Name: decrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION decrypt(bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_decrypt'; | |
| - | |
| - | |
| --- | |
| --- Name: decrypt_iv(bytea, bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION decrypt_iv(bytea, bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_decrypt_iv'; | |
| - | |
| - | |
| --- | |
| --- Name: digest(bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION digest(bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_digest'; | |
| - | |
| - | |
| --- | |
| --- Name: digest(text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION digest(text, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_digest'; | |
| - | |
| - | |
| --- | |
| --- Name: encrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION encrypt(bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_encrypt'; | |
| - | |
| - | |
| --- | |
| --- Name: encrypt_iv(bytea, bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION encrypt_iv(bytea, bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_encrypt_iv'; | |
| - | |
| - | |
| --- | |
| --- Name: gen_random_bytes(integer); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION gen_random_bytes(integer) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pg_random_bytes'; | |
| - | |
| - | |
| --- | |
| --- Name: gen_salt(text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION gen_salt(text) RETURNS text | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pg_gen_salt'; | |
| - | |
| - | |
| --- | |
| --- Name: gen_salt(text, integer); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION gen_salt(text, integer) RETURNS text | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pg_gen_salt_rounds'; | |
| - | |
| - | |
| --- | |
| --- Name: hmac(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION hmac(bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_hmac'; | |
| - | |
| - | |
| --- | |
| --- Name: hmac(text, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION hmac(text, text, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pg_hmac'; | |
| - | |
| - | |
| --- | |
| --- Name: pastshows(integer, integer); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pastshows(integer, integer) RETURNS SETOF showtime | |
| - LANGUAGE sql | |
| - AS $_$ | |
| -SELECT | |
| - CAST(EXTRACT(EPOCH FROM st.starttime) AS integer) AS unixstart, | |
| - CAST(EXTRACT(EPOCH FROM st.endtime) AS integer) AS unixend, | |
| - se.summary || ' by ' || | |
| - array_to_string ( array( | |
| - SELECT substring(inside_m.fname,1,1)||'. '|| inside_m.sname | |
| - FROM sched_timeslot inside_st | |
| - NATURAL JOIN sched_entry inside_se | |
| - NATURAL JOIN sched_memberentry inside_sm | |
| - NATURAL JOIN member inside_m | |
| - WHERE inside_st.starttime >= timestamp 'epoch' + $1 * INTERVAL '1 second' | |
| - AND inside_st.endtime <= timestamp 'epoch' + $2 * INTERVAL '1 second' | |
| - AND inside_st.timeslotid = st.timeslotid | |
| - ), ', ') AS description | |
| -FROM sched_timeslot st | |
| - NATURAL JOIN sched_entry se | |
| - NATURAL JOIN sched_memberentry sm | |
| - NATURAL JOIN member m | |
| -WHERE st.starttime >= timestamp 'epoch' + $1 * INTERVAL '1 second' | |
| - AND st.endtime <= timestamp 'epoch' + $2 * INTERVAL '1 second' | |
| -GROUP BY st.timeslotid,se.summary,st.starttime,st.endtime | |
| -ORDER BY st.starttime; | |
| -$_$; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_key_id(bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_key_id(bytea) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_key_id_w'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt(bytea, bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt(bytea, bytea) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt(bytea, bytea, text) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt(bytea, bytea, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt(bytea, bytea, text, text) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt_bytea(bytea, bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt_bytea(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_decrypt_bytea(bytea, bytea, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_decrypt_bytea(bytea, bytea, text, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_decrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_encrypt(text, bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_encrypt(text, bytea) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_encrypt(text, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_encrypt(text, bytea, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_encrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_encrypt_bytea(bytea, bytea); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_pub_encrypt_bytea(bytea, bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_pub_encrypt_bytea(bytea, bytea, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_pub_encrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_decrypt(bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_decrypt(bytea, text) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_decrypt(bytea, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_decrypt(bytea, text, text) RETURNS text | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_decrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_decrypt_bytea(bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_decrypt_bytea(bytea, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_decrypt_bytea(bytea, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_decrypt_bytea(bytea, text, text) RETURNS bytea | |
| - LANGUAGE c IMMUTABLE STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_decrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_encrypt(text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_encrypt(text, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_encrypt(text, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_encrypt(text, text, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_encrypt_text'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_encrypt_bytea(bytea, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_encrypt_bytea(bytea, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: pgp_sym_encrypt_bytea(bytea, text, text); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION pgp_sym_encrypt_bytea(bytea, text, text) RETURNS bytea | |
| - LANGUAGE c STRICT | |
| - AS '$libdir/pgcrypto', 'pgp_sym_encrypt_bytea'; | |
| - | |
| - | |
| --- | |
| --- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler | |
| - LANGUAGE c | |
| - AS '$libdir/plpgsql', 'plpgsql_call_handler'; | |
| - | |
| - | |
| --- | |
| -- Name: process_gammu_text(); Type: FUNCTION; Schema: public; Owner: - | |
| -- | |
| @@ -749,10 +293,8 @@ | |
| myshelfnumber integer DEFAULT 0; | |
| recordrow RECORD; | |
| BEGIN | |
| - | |
| IF ((NEW.media='7' OR NEW.media='2') AND NEW.format='a') THEN | |
| 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 | |
| - | |
| IF recordrow.shelfnumber > myshelfnumber+1 THEN | |
| EXIT; | |
| END IF; | |
| @@ -778,11 +320,11 @@ | |
| CREATE FUNCTION update_timestamp() RETURNS trigger | |
| LANGUAGE plpgsql | |
| - AS $$ | |
| - BEGIN | |
| - NEW."UpdatedInDB" := LOCALTIMESTAMP(0); | |
| - RETURN NEW; | |
| - END; | |
| + AS $$ | |
| + BEGIN | |
| + NEW."UpdatedInDB" := LOCALTIMESTAMP(0); | |
| + RETURN NEW; | |
| + END; | |
| $$; | |
| @@ -805,7 +347,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: auto_playlists; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: auto_playlists; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auto_playlists ( | |
| @@ -816,24 +358,6 @@ | |
| -- | |
| --- Name: client_ids; Type: TABLE; Schema: bapsplanner; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE client_ids ( | |
| - client_id integer NOT NULL, | |
| - show_season_timeslot_id integer, | |
| - session_id character varying(64) | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: TABLE client_ids; Type: COMMENT; Schema: bapsplanner; Owner: - | |
| --- | |
| - | |
| -COMMENT ON TABLE client_ids IS 'Enables tracking of individual windows instead of sessions - a session may have more than one window open.'; | |
| - | |
| - | |
| --- | |
| -- Name: client_ids_client_id_seq; Type: SEQUENCE; Schema: bapsplanner; Owner: - | |
| -- | |
| @@ -846,24 +370,13 @@ | |
| -- | |
| --- Name: client_ids_client_id_seq; Type: SEQUENCE OWNED BY; Schema: bapsplanner; Owner: - | |
| +-- Name: client_ids; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| -ALTER SEQUENCE client_ids_client_id_seq OWNED BY client_ids.client_id; | |
| - | |
| - | |
| --- | |
| --- Name: managed_items; Type: TABLE; Schema: bapsplanner; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE managed_items ( | |
| - manageditemid integer NOT NULL, | |
| - managedplaylistid integer NOT NULL, | |
| - title character varying NOT NULL, | |
| - length time without time zone, | |
| - bpm smallint, | |
| - expirydate date, | |
| - memberid integer | |
| +CREATE TABLE client_ids ( | |
| + client_id integer DEFAULT nextval('client_ids_client_id_seq'::regclass) NOT NULL, | |
| + show_season_timeslot_id integer, | |
| + session_id character varying(64) | |
| ); | |
| @@ -880,10 +393,18 @@ | |
| -- | |
| --- Name: managed_items_manageditemid_seq; Type: SEQUENCE OWNED BY; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| -ALTER SEQUENCE managed_items_manageditemid_seq OWNED BY managed_items.manageditemid; | |
| +CREATE TABLE managed_items ( | |
| + manageditemid integer DEFAULT nextval('managed_items_manageditemid_seq'::regclass) NOT NULL, | |
| + managedplaylistid integer NOT NULL, | |
| + title character varying NOT NULL, | |
| + length time without time zone, | |
| + bpm smallint, | |
| + expirydate date, | |
| + memberid integer | |
| +); | |
| -- | |
| @@ -906,7 +427,7 @@ | |
| -- | |
| --- Name: managed_playlists; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_playlists; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE managed_playlists ( | |
| @@ -944,7 +465,7 @@ | |
| -- | |
| --- Name: managed_user_items; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_user_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE managed_user_items ( | |
| @@ -957,7 +478,7 @@ | |
| -- | |
| --- Name: secure_play_token; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: secure_play_token; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE secure_play_token ( | |
| @@ -976,7 +497,7 @@ | |
| -- | |
| --- Name: timeslot_change_ops; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: timeslot_change_ops; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE timeslot_change_ops ( | |
| @@ -1014,7 +535,7 @@ | |
| -- | |
| --- Name: timeslot_items; Type: TABLE; Schema: bapsplanner; Owner: - | |
| +-- Name: timeslot_items; Type: TABLE; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE timeslot_items ( | |
| @@ -1048,86 +569,10 @@ | |
| ALTER SEQUENCE timeslot_items_timeslot_item_id_seq OWNED BY timeslot_items.timeslot_item_id; | |
| -SET search_path = deploy, pg_catalog; | |
| - | |
| --- | |
| --- Name: myury; Type: TABLE; Schema: deploy; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE myury ( | |
| - memberid integer NOT NULL, | |
| - migrated boolean DEFAULT false, | |
| - enforced boolean DEFAULT false | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: showplanner; Type: TABLE; Schema: deploy; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE showplanner ( | |
| - memberid integer NOT NULL, | |
| - migrated boolean DEFAULT false, | |
| - enforced boolean DEFAULT false, | |
| - helptab boolean DEFAULT true | |
| -); | |
| - | |
| - | |
| -SET search_path = website, pg_catalog; | |
| - | |
| --- | |
| --- Name: banner_campaign; Type: TABLE; Schema: website; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE banner_campaign ( | |
| - memberid integer, | |
| - approvedid integer, | |
| - effective_from timestamp with time zone NOT NULL, | |
| - effective_to timestamp with time zone, | |
| - banner_campaign_id integer NOT NULL, | |
| - banner_location_id integer NOT NULL, | |
| - banner_id integer NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE; Schema: website; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE banner_campaign_banner_campaign_id_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: website; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE banner_campaign_banner_campaign_id_seq OWNED BY banner_campaign.banner_campaign_id; | |
| - | |
| - | |
| SET search_path = jukebox, pg_catalog; | |
| -- | |
| --- Name: playlist_availability; Type: TABLE; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE playlist_availability ( | |
| - memberid integer, | |
| - approvedid integer, | |
| - effective_from timestamp with time zone NOT NULL, | |
| - effective_to timestamp with time zone, | |
| - playlist_availability_id integer DEFAULT nextval('website.banner_campaign_banner_campaign_id_seq'::regclass) NOT NULL, | |
| - weight integer NOT NULL, | |
| - playlistid character varying NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_entries; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: playlist_entries; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE playlist_entries ( | |
| @@ -1159,7 +604,7 @@ | |
| -- | |
| --- Name: playlist_revisions; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: playlist_revisions; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE playlist_revisions ( | |
| @@ -1184,17 +629,18 @@ | |
| -- | |
| --- Name: playlist_timeslot; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: playlist_timeslot; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE playlist_timeslot ( | |
| id integer DEFAULT nextval('playlist_timeslot_id_seq'::regclass) NOT NULL, | |
| memberid integer NOT NULL, | |
| approvedid integer, | |
| + weight integer NOT NULL, | |
| + playlistid character varying(15) NOT NULL, | |
| day smallint NOT NULL, | |
| start_time time without time zone NOT NULL, | |
| - end_time time without time zone NOT NULL, | |
| - playlist_availability_id integer NOT NULL | |
| + end_time time without time zone NOT NULL | |
| ); | |
| @@ -1206,7 +652,7 @@ | |
| -- | |
| --- Name: playlists; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: playlists; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE playlists ( | |
| @@ -1237,7 +683,7 @@ | |
| -- | |
| --- Name: request; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: request; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE request ( | |
| @@ -1269,7 +715,21 @@ | |
| -- | |
| --- Name: silence_log; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: requests; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE requests ( | |
| + "user" integer NOT NULL, | |
| + start timestamp with time zone NOT NULL, | |
| + "end" timestamp with time zone NOT NULL, | |
| + format character varying(4) NOT NULL, | |
| + title character varying(64), | |
| + removed boolean DEFAULT false NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: silence_log; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE silence_log ( | |
| @@ -1326,7 +786,7 @@ | |
| -- | |
| --- Name: track_blacklist; Type: TABLE; Schema: jukebox; Owner: - | |
| +-- Name: track_blacklist; Type: TABLE; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE track_blacklist ( | |
| @@ -1341,70 +801,10 @@ | |
| COMMENT ON TABLE track_blacklist IS 'A list of Tracks that should, under no circumstances, be played on the jukebox.'; | |
| -SET search_path = loggerng, pg_catalog; | |
| - | |
| --- | |
| --- Name: logs; Type: TABLE; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE logs ( | |
| - start timestamp with time zone NOT NULL, | |
| - "end" timestamp with time zone NOT NULL, | |
| - completed boolean DEFAULT false NOT NULL, | |
| - deleted boolean DEFAULT false NOT NULL, | |
| - format character varying(4) NOT NULL, | |
| - progress real | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: requests; Type: TABLE; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE requests ( | |
| - "user" integer NOT NULL, | |
| - start timestamp with time zone NOT NULL, | |
| - "end" timestamp with time zone NOT NULL, | |
| - format character varying(4) NOT NULL, | |
| - title character varying(64), | |
| - removed boolean DEFAULT false NOT NULL | |
| -); | |
| - | |
| - | |
| -SET search_path = loggerng_test, pg_catalog; | |
| - | |
| --- | |
| --- Name: logs; Type: TABLE; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE logs ( | |
| - start timestamp with time zone NOT NULL, | |
| - "end" timestamp with time zone NOT NULL, | |
| - completed boolean DEFAULT false NOT NULL, | |
| - deleted boolean DEFAULT false NOT NULL, | |
| - format character varying(4) NOT NULL, | |
| - progress real | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: requests; Type: TABLE; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE requests ( | |
| - "user" integer NOT NULL, | |
| - start timestamp with time zone NOT NULL, | |
| - "end" timestamp with time zone NOT NULL, | |
| - format character varying(4) NOT NULL, | |
| - title character varying(64), | |
| - removed boolean DEFAULT false NOT NULL | |
| -); | |
| - | |
| - | |
| SET search_path = mail, pg_catalog; | |
| -- | |
| --- Name: alias; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: alias; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE alias ( | |
| @@ -1433,7 +833,7 @@ | |
| -- | |
| --- Name: alias_list; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: alias_list; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE alias_list ( | |
| @@ -1443,7 +843,7 @@ | |
| -- | |
| --- Name: alias_member; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: alias_member; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE alias_member ( | |
| @@ -1453,7 +853,7 @@ | |
| -- | |
| --- Name: alias_officer; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: alias_officer; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE alias_officer ( | |
| @@ -1463,25 +863,6 @@ | |
| -- | |
| --- Name: alias_officer_alias_id_seq; Type: SEQUENCE; Schema: mail; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE alias_officer_alias_id_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: alias_officer_alias_id_seq; Type: SEQUENCE OWNED BY; Schema: mail; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE alias_officer_alias_id_seq OWNED BY alias_officer.alias_id; | |
| - | |
| - | |
| --- | |
| -- Name: alias_source_seq; Type: SEQUENCE; Schema: mail; Owner: - | |
| -- | |
| @@ -1494,14 +875,7 @@ | |
| -- | |
| --- Name: alias_source_seq; Type: SEQUENCE OWNED BY; Schema: mail; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE alias_source_seq OWNED BY alias.source; | |
| - | |
| - | |
| --- | |
| --- Name: alias_text; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: alias_text; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE alias_text ( | |
| @@ -1511,7 +885,7 @@ | |
| -- | |
| --- Name: email; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: email; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE email ( | |
| @@ -1524,7 +898,7 @@ | |
| -- | |
| --- Name: email_recipient_list; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: email_recipient_list; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE email_recipient_list ( | |
| @@ -1535,7 +909,7 @@ | |
| -- | |
| --- Name: email_recipient_member; Type: TABLE; Schema: mail; Owner: - | |
| +-- Name: email_recipient_member; Type: TABLE; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE email_recipient_member ( | |
| @@ -1567,7 +941,7 @@ | |
| SET search_path = metadata, pg_catalog; | |
| -- | |
| --- Name: metadata_key; Type: TABLE; Schema: metadata; Owner: - | |
| +-- Name: metadata_key; Type: TABLE; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE metadata_key ( | |
| @@ -1629,7 +1003,7 @@ | |
| -- | |
| --- Name: package; Type: TABLE; Schema: metadata; Owner: - | |
| +-- Name: package; Type: TABLE; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE package ( | |
| @@ -1641,7 +1015,7 @@ | |
| -- | |
| --- Name: package_image_metadata; Type: TABLE; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata; Type: TABLE; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE package_image_metadata ( | |
| @@ -1696,7 +1070,7 @@ | |
| -- | |
| --- Name: package_text_metadata; Type: TABLE; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata; Type: TABLE; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE package_text_metadata ( | |
| @@ -1734,7 +1108,7 @@ | |
| SET search_path = music, pg_catalog; | |
| -- | |
| --- Name: chart_release; Type: TABLE; Schema: music; Owner: - | |
| +-- Name: chart_release; Type: TABLE; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE chart_release ( | |
| @@ -1764,7 +1138,7 @@ | |
| -- | |
| --- Name: chart_row; Type: TABLE; Schema: music; Owner: - | |
| +-- Name: chart_row; Type: TABLE; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE chart_row ( | |
| @@ -1798,7 +1172,7 @@ | |
| -- | |
| --- Name: chart_type; Type: TABLE; Schema: music; Owner: - | |
| +-- Name: chart_type; Type: TABLE; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE chart_type ( | |
| @@ -1828,7 +1202,7 @@ | |
| -- | |
| --- Name: explicit_checked; Type: TABLE; Schema: music; Owner: - | |
| +-- Name: explicit_checked; Type: TABLE; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE explicit_checked ( | |
| @@ -1839,7 +1213,7 @@ | |
| SET search_path = myradio, pg_catalog; | |
| -- | |
| --- Name: schema; Type: TABLE; Schema: myradio; Owner: - | |
| +-- Name: schema; Type: TABLE; Schema: myradio; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE schema ( | |
| @@ -1851,7 +1225,7 @@ | |
| SET search_path = myury, pg_catalog; | |
| -- | |
| --- Name: act_permission; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: act_permission; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE act_permission ( | |
| @@ -1868,11 +1242,8 @@ | |
| -- | |
| 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. | |
| - | |
| A NULL in the module or action field matches any module or action. | |
| - | |
| A NULL permissionid means that no permissions are required to use that Service/Module/Action combination. | |
| - | |
| NULL permissions on wildcards will be ignored.'; | |
| @@ -1896,7 +1267,7 @@ | |
| -- | |
| --- Name: actions; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: actions; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE actions ( | |
| @@ -1912,7 +1283,7 @@ | |
| -- Name: TABLE actions; Type: COMMENT; Schema: myury; Owner: - | |
| -- | |
| -COMMENT ON TABLE actions IS 'Stores Actions within managed MyURY Service Modules'; | |
| +COMMENT ON TABLE actions IS 'Stores Actions within managed MyRadio Service Modules'; | |
| -- | |
| @@ -1935,7 +1306,7 @@ | |
| -- | |
| --- Name: api_class_map; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_class_map; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_class_map ( | |
| @@ -1949,7 +1320,7 @@ | |
| -- Name: TABLE api_class_map; Type: COMMENT; Schema: myury; Owner: - | |
| -- | |
| -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.'; | |
| +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.'; | |
| -- | |
| @@ -1972,7 +1343,7 @@ | |
| -- | |
| --- Name: api_key; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_key; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_key ( | |
| @@ -1986,11 +1357,11 @@ | |
| -- Name: TABLE api_key; Type: COMMENT; Schema: myury; Owner: - | |
| -- | |
| -COMMENT ON TABLE api_key IS 'Access keys for the MyURYpi'; | |
| +COMMENT ON TABLE api_key IS 'Access keys for the MyRadiopi'; | |
| -- | |
| --- Name: api_key_auth; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_key_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_key_auth ( | |
| @@ -2007,7 +1378,7 @@ | |
| -- | |
| --- Name: api_key_log; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_key_log; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_key_log ( | |
| @@ -2047,7 +1418,7 @@ | |
| -- | |
| --- Name: api_method_auth; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_method_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_method_auth ( | |
| @@ -2063,7 +1434,6 @@ | |
| -- | |
| 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". | |
| - | |
| Other than the above exception, the permissions structure is identical to the standard myury action permission system.'; | |
| @@ -2087,7 +1457,7 @@ | |
| -- | |
| --- Name: api_mixin_auth; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: api_mixin_auth; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE api_mixin_auth ( | |
| @@ -2118,7 +1488,7 @@ | |
| -- | |
| --- Name: award_categories; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: award_categories; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE award_categories ( | |
| @@ -2147,7 +1517,7 @@ | |
| -- | |
| --- Name: award_member; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: award_member; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE award_member ( | |
| @@ -2179,66 +1549,7 @@ | |
| -- | |
| --- Name: contract_versions; Type: TABLE; Schema: myury; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE contract_versions ( | |
| - contract_version_id integer NOT NULL, | |
| - description text, | |
| - ratified_date date, | |
| - enforced_date date | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: TABLE contract_versions; Type: COMMENT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -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.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN contract_versions.description; Type: COMMENT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN contract_versions.description IS 'A description of revisions made in this version of the contract.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN contract_versions.ratified_date; Type: COMMENT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN contract_versions.ratified_date IS 'The date the new version of the contract came into use.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN contract_versions.enforced_date; Type: COMMENT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN contract_versions.enforced_date IS 'If NULL, then it isn''t required for presenters to have signed the new contract yet.'; | |
| - | |
| - | |
| --- | |
| --- Name: contract_versions_contract_version_id_seq; Type: SEQUENCE; Schema: myury; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE contract_versions_contract_version_id_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: contract_versions_contract_version_id_seq; Type: SEQUENCE OWNED BY; Schema: myury; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE contract_versions_contract_version_id_seq OWNED BY contract_versions.contract_version_id; | |
| - | |
| - | |
| --- | |
| --- Name: error_rate; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: error_rate; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE error_rate ( | |
| @@ -2285,7 +1596,7 @@ | |
| -- | |
| --- Name: modules; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: modules; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE modules ( | |
| @@ -2300,7 +1611,7 @@ | |
| -- Name: TABLE modules; Type: COMMENT; Schema: myury; Owner: - | |
| -- | |
| -COMMENT ON TABLE modules IS 'Stores Modules within MyURY managed Services'; | |
| +COMMENT ON TABLE modules IS 'Stores Modules within MyRadio managed Services'; | |
| -- | |
| @@ -2323,7 +1634,7 @@ | |
| -- | |
| --- Name: password_reset_token; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: password_reset_token; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE password_reset_token ( | |
| @@ -2342,7 +1653,7 @@ | |
| -- | |
| --- Name: photos; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: photos; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE photos ( | |
| @@ -2380,7 +1691,7 @@ | |
| -- | |
| --- Name: services; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: services; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE services ( | |
| @@ -2394,7 +1705,7 @@ | |
| -- Name: TABLE services; Type: COMMENT; Schema: myury; Owner: - | |
| -- | |
| -COMMENT ON TABLE services IS 'Lists all Services managed by MyURY'; | |
| +COMMENT ON TABLE services IS 'Lists all Services managed by MyRadio'; | |
| -- | |
| @@ -2417,7 +1728,7 @@ | |
| -- | |
| --- Name: services_versions; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: services_versions; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE services_versions ( | |
| @@ -2438,7 +1749,7 @@ | |
| -- | |
| --- Name: services_versions_member; Type: TABLE; Schema: myury; Owner: - | |
| +-- Name: services_versions_member; Type: TABLE; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE services_versions_member ( | |
| @@ -2469,7 +1780,7 @@ | |
| SET search_path = people, pg_catalog; | |
| -- | |
| --- Name: credit_type; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: credit_type; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE credit_type ( | |
| @@ -2502,7 +1813,7 @@ | |
| -- | |
| --- Name: group_root_role; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: group_root_role; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE group_root_role ( | |
| @@ -2540,7 +1851,7 @@ | |
| -- | |
| --- Name: group_type; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: group_type; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE group_type ( | |
| @@ -2569,7 +1880,7 @@ | |
| -- | |
| --- Name: metadata; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: metadata; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE metadata ( | |
| @@ -2584,9 +1895,7 @@ | |
| -- | |
| COMMENT ON TABLE metadata IS 'Key-value store for textual metadata associated with rules. | |
| - | |
| As of writing the metadata schema is: | |
| - | |
| ''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. | |
| ''Individual-Name'' - human readable name for an individual in this role, example ''Station Manager''. | |
| ''Acronym'' - self-explanatory, example ''SM''. | |
| @@ -2616,7 +1925,7 @@ | |
| -- | |
| --- Name: quote; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: quote; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE quote ( | |
| @@ -2647,7 +1956,7 @@ | |
| -- | |
| --- Name: role; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: role; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE role ( | |
| @@ -2702,7 +2011,7 @@ | |
| -- | |
| --- Name: role_inheritance; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: role_inheritance; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE role_inheritance ( | |
| @@ -2760,7 +2069,7 @@ | |
| -- | |
| --- Name: role_text_metadata; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: role_text_metadata; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE role_text_metadata ( | |
| @@ -2809,7 +2118,7 @@ | |
| -- | |
| --- Name: role_visibility; Type: TABLE; Schema: people; Owner: - | |
| +-- Name: role_visibility; Type: TABLE; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE role_visibility ( | |
| @@ -2906,10 +2215,116 @@ | |
| SET search_path = public, pg_catalog; | |
| +-- | |
| +-- Name: acl_member; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE acl_member ( | |
| + privilegeid integer NOT NULL, | |
| + memberid integer, | |
| + class text NOT NULL, | |
| + verb text NOT NULL, | |
| + scope integer DEFAULT 0 NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: TABLE acl_member; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON TABLE acl_member IS 'Access Control List for regular members (used to grant temporary and extraordinary permissions)'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_member.privilegeid; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_member.privilegeid IS 'The unique ID of this ACL row.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_member.memberid; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_member.memberid IS 'The unique ID of the member being granted a permission.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_member.class; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_member.class IS 'The full name of the Rapier object class a permission is being granted for.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_member.verb; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_member.verb IS 'The verb (eg "read") representing the privileged action being granted.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_member.scope; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_member.scope IS 'The scope of this action being granted. (see constants_acl_scope).'; | |
| + | |
| + | |
| +-- | |
| +-- Name: acl_member_privilegeid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE acl_member_privilegeid_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| +-- | |
| +-- Name: acl_member_privilegeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER SEQUENCE acl_member_privilegeid_seq OWNED BY acl_member.privilegeid; | |
| + | |
| + | |
| +-- | |
| +-- Name: acl_officer; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE acl_officer ( | |
| + privilegeid integer DEFAULT nextval('acl_member_privilegeid_seq'::regclass) NOT NULL, | |
| + officerid integer NOT NULL, | |
| + class text NOT NULL, | |
| + verb text NOT NULL, | |
| + scope integer DEFAULT 0 NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN acl_officer.class; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN acl_officer.class IS 'The full name of the Rapier object class a permission is being granted for.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: acl_officer_privilegeid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE acl_officer_privilegeid_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: auth; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth ( | |
| @@ -2945,7 +2360,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: auth_group; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_group; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_group ( | |
| @@ -2976,7 +2391,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: auth_officer; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_officer; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_officer ( | |
| @@ -2995,7 +2410,38 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: auth_subnet; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_permission; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE auth_permission ( | |
| + id integer NOT NULL, | |
| + name character varying(50) NOT NULL, | |
| + content_type_id integer NOT NULL, | |
| + codename character varying(100) NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE auth_permission_id_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| +-- | |
| +-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id; | |
| + | |
| + | |
| +-- | |
| +-- Name: auth_subnet; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_subnet ( | |
| @@ -3012,7 +2458,7 @@ | |
| -- | |
| --- Name: auth_trainingstatus; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_trainingstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_trainingstatus ( | |
| @@ -3029,7 +2475,7 @@ | |
| -- | |
| --- Name: auth_user; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_user; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_user ( | |
| @@ -3048,7 +2494,7 @@ | |
| -- | |
| --- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE auth_user_groups ( | |
| @@ -3111,7 +2557,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: baps_audio; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_audio; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_audio ( | |
| @@ -3141,7 +2587,7 @@ | |
| -- | |
| --- Name: baps_audiolog; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_audiolog; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_audiolog ( | |
| @@ -3174,7 +2620,7 @@ | |
| -- | |
| --- Name: baps_filefolder; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_filefolder; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_filefolder ( | |
| @@ -3210,7 +2656,7 @@ | |
| -- | |
| --- Name: baps_fileitem; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_fileitem; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_fileitem ( | |
| @@ -3239,7 +2685,7 @@ | |
| -- | |
| --- Name: baps_item; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_item; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_item ( | |
| @@ -3251,7 +2697,7 @@ | |
| libraryitemid integer, | |
| fileitemid integer, | |
| name2 character varying(255), | |
| - 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)))) | |
| + 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)))) | |
| ); | |
| @@ -3275,7 +2721,7 @@ | |
| -- | |
| --- Name: baps_libraryitem; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_libraryitem; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_libraryitem ( | |
| @@ -3305,7 +2751,7 @@ | |
| -- | |
| --- Name: baps_listing; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_listing; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_listing ( | |
| @@ -3348,7 +2794,7 @@ | |
| -- | |
| --- Name: rec_track; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_track; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_track ( | |
| @@ -3365,8 +2811,8 @@ | |
| digitisedby integer, | |
| duration integer, | |
| lastfm_verified boolean DEFAULT false, | |
| - last_edited_time timestamp with time zone, | |
| - last_edited_memberid integer | |
| + last_edited_memberid integer, | |
| + last_edited_time timestamp with time zone | |
| ); | |
| @@ -3408,7 +2854,7 @@ | |
| -- | |
| --- Name: baps_server; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_server; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_server ( | |
| @@ -3437,7 +2883,7 @@ | |
| -- | |
| --- Name: baps_show; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_show; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_show ( | |
| @@ -3470,7 +2916,7 @@ | |
| -- | |
| --- Name: baps_textitem; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_textitem; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_textitem ( | |
| @@ -3499,7 +2945,7 @@ | |
| -- | |
| --- Name: baps_user; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_user; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_user ( | |
| @@ -3515,7 +2961,7 @@ | |
| -- | |
| --- Name: baps_user_external; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_user_external; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_user_external ( | |
| @@ -3545,7 +2991,7 @@ | |
| -- | |
| --- Name: baps_user_filefolder; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: baps_user_filefolder; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE baps_user_filefolder ( | |
| @@ -3596,51 +3042,150 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: cat_view_promoter; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: chart; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE cat_view_promoter ( | |
| - chicken integer, | |
| - nipples character varying | |
| +CREATE TABLE chart ( | |
| + chartweek integer NOT NULL, | |
| + lastweek text NOT NULL, | |
| + title text NOT NULL, | |
| + artist text NOT NULL, | |
| + "position" integer NOT NULL | |
| ); | |
| -- | |
| --- Name: TABLE cat_view_promoter; Type: COMMENT; Schema: public; Owner: - | |
| +-- Name: TABLE chart; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON TABLE cat_view_promoter IS 'Don''t delete, or the cataloguer breaks.'; | |
| +COMMENT ON TABLE chart IS 'ury chart rundowns'; | |
| -- | |
| --- Name: chart; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: COLUMN chart.chartweek; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -CREATE TABLE chart ( | |
| - chartweek integer NOT NULL, | |
| - lastweek text NOT NULL, | |
| - title text NOT NULL, | |
| - artist text NOT NULL, | |
| - "position" integer NOT NULL | |
| +COMMENT ON COLUMN chart.chartweek IS 'chart release timestamp'; | |
| + | |
| + | |
| +-- | |
| +-- Name: client; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE client ( | |
| + clientid integer NOT NULL, | |
| + name text NOT NULL, | |
| + secrethash text NOT NULL, | |
| + description text | |
| ); | |
| -- | |
| --- Name: TABLE chart; Type: COMMENT; Schema: public; Owner: - | |
| +-- Name: TABLE client; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON TABLE chart IS 'ury chart rundowns'; | |
| +COMMENT ON TABLE client IS 'Registry of clients allowed to use Rapier.'; | |
| -- | |
| --- Name: COLUMN chart.chartweek; Type: COMMENT; Schema: public; Owner: - | |
| +-- Name: COLUMN client.clientid; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN chart.chartweek IS 'chart release timestamp'; | |
| +COMMENT ON COLUMN client.clientid IS 'The numeric ID of the client.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN client.name; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN client.name IS 'The log-in name of the client.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN client.secrethash; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN client.secrethash IS 'A hash of the log-in password of the client.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN client.description; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN client.description IS 'A human-readable description of the client.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE client_clientid_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| +-- | |
| +-- Name: client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER SEQUENCE client_clientid_seq OWNED BY client.clientid; | |
| + | |
| + | |
| +-- | |
| +-- Name: constants_acl_scope; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE constants_acl_scope ( | |
| + scopeid integer NOT NULL, | |
| + description text NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: TABLE constants_acl_scope; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON TABLE constants_acl_scope IS 'Human-readable descriptions for the ACL scope levels.'; | |
| -- | |
| --- Name: selector; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: COLUMN constants_acl_scope.scopeid; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN constants_acl_scope.scopeid IS 'The unique ID of this scope level.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: COLUMN constants_acl_scope.description; Type: COMMENT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +COMMENT ON COLUMN constants_acl_scope.description IS 'The human-readable description of this scope level.'; | |
| + | |
| + | |
| +-- | |
| +-- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE constants_acl_scope_scopeid_seq | |
| + START WITH 3 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| +-- | |
| +-- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER SEQUENCE constants_acl_scope_scopeid_seq OWNED BY constants_acl_scope.scopeid; | |
| + | |
| + | |
| +-- | |
| +-- Name: selector; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE selector ( | |
| @@ -3673,7 +3218,7 @@ | |
| -- | |
| --- Name: gammu; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: gammu; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE gammu ( | |
| @@ -3685,13 +3230,13 @@ | |
| -- Name: TABLE gammu; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON TABLE gammu IS 'Gammu - text messaging system'; | |
| +COMMENT ON TABLE gammu IS 'Do not delete - Gammu will break'; | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: l_action; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_action; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_action ( | |
| @@ -3743,7 +3288,7 @@ | |
| -- | |
| --- Name: l_college; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_college; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_college ( | |
| @@ -3765,7 +3310,7 @@ | |
| -- | |
| --- Name: l_musicinterest; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_musicinterest; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_musicinterest ( | |
| @@ -3789,7 +3334,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: l_newsfeed; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_newsfeed; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_newsfeed ( | |
| @@ -3810,7 +3355,7 @@ | |
| -- | |
| CREATE SEQUENCE l_newsfeeds_feedid_seq | |
| - START WITH 1 | |
| + START WITH 5 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| @@ -3827,7 +3372,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: l_presenterstatus; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_presenterstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_presenterstatus ( | |
| @@ -3867,7 +3412,7 @@ | |
| -- | |
| --- Name: l_status; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_status; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_status ( | |
| @@ -3879,7 +3424,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: l_subnet; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: l_subnet; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE l_subnet ( | |
| @@ -3909,7 +3454,7 @@ | |
| -- | |
| --- Name: mail_alias_text; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_alias_text; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_alias_text ( | |
| @@ -3947,7 +3492,7 @@ | |
| -- | |
| --- Name: mail_alias_list; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_alias_list; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_alias_list ( | |
| @@ -3966,7 +3511,7 @@ | |
| -- | |
| --- Name: mail_alias_member; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_alias_member; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_alias_member ( | |
| @@ -3985,7 +3530,7 @@ | |
| -- | |
| --- Name: mail_alias_officer; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_alias_officer; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_alias_officer ( | |
| @@ -4004,7 +3549,7 @@ | |
| -- | |
| --- Name: mail_list; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_list; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_list ( | |
| @@ -4089,7 +3634,7 @@ | |
| -- | |
| --- Name: mail_subscription; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: mail_subscription; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE mail_subscription ( | |
| @@ -4108,7 +3653,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: member; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member ( | |
| @@ -4132,25 +3677,11 @@ | |
| profile_photo integer, | |
| bio text, | |
| auth_provider character varying, | |
| - contract_signed boolean DEFAULT false | |
| + contract_signed boolean DEFAULT false NOT NULL | |
| ); | |
| -- | |
| --- Name: TABLE member; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON TABLE member IS 'The members!'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN member.sex; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN member.sex IS 'Yes please!'; | |
| - | |
| - | |
| --- | |
| -- Name: COLUMN member.email; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| @@ -4193,13 +3724,6 @@ | |
| -- | |
| --- Name: COLUMN member.contract_signed; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN member.contract_signed IS 'Has the member signed the current year''s presenter contract?'; | |
| - | |
| - | |
| --- | |
| -- Name: member_memberid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| @@ -4214,7 +3738,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: member_news_feed; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member_news_feed; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_news_feed ( | |
| @@ -4266,7 +3790,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: member_officer; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member_officer; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_officer ( | |
| @@ -4281,7 +3805,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: member_pass; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member_pass; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_pass ( | |
| @@ -4300,7 +3824,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: member_presenterstatus; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member_presenterstatus; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_presenterstatus ( | |
| @@ -4334,7 +3858,7 @@ | |
| -- | |
| --- Name: member_year; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: member_year; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_year ( | |
| @@ -4347,7 +3871,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: net_switchport; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: net_switchport; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE net_switchport ( | |
| @@ -4373,7 +3897,7 @@ | |
| -- | |
| --- Name: net_switchport_tags; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: net_switchport_tags; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE net_switchport_tags ( | |
| @@ -4383,7 +3907,7 @@ | |
| -- | |
| --- Name: net_vlan; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: net_vlan; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE net_vlan ( | |
| @@ -4400,7 +3924,7 @@ | |
| -- | |
| --- Name: news_feed; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: news_feed; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE news_feed ( | |
| @@ -4440,7 +3964,7 @@ | |
| -- | |
| --- Name: nipsweb_migrate; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: nipsweb_migrate; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE nipsweb_migrate ( | |
| @@ -4460,7 +3984,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: officer; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: officer; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE officer ( | |
| @@ -4477,13 +4001,6 @@ | |
| -- | |
| --- Name: COLUMN officer.officer_alias; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN officer.officer_alias IS 'The officer''s alias for email (<this>@ury.org.uk)'; | |
| - | |
| - | |
| --- | |
| -- Name: COLUMN officer.type; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| @@ -4503,7 +4020,7 @@ | |
| -- | |
| --- Name: rec_cleanlookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_cleanlookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_cleanlookup ( | |
| @@ -4513,7 +4030,7 @@ | |
| -- | |
| --- Name: rec_formatlookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_formatlookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_formatlookup ( | |
| @@ -4523,7 +4040,7 @@ | |
| -- | |
| --- Name: rec_genrelookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_genrelookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_genrelookup ( | |
| @@ -4535,7 +4052,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: rec_itunes; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_itunes; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_itunes ( | |
| @@ -4557,7 +4074,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: rec_labelqueue; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_labelqueue; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_labelqueue ( | |
| @@ -4580,7 +4097,7 @@ | |
| -- | |
| --- Name: rec_locationlookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_locationlookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_locationlookup ( | |
| @@ -4592,7 +4109,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: rec_lookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_lookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_lookup ( | |
| @@ -4652,7 +4169,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: rec_medialookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_medialookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_medialookup ( | |
| @@ -4662,7 +4179,7 @@ | |
| -- | |
| --- Name: rec_record; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_record; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_record ( | |
| @@ -4699,7 +4216,7 @@ | |
| -- | |
| --- Name: rec_statuslookup; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_statuslookup; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_statuslookup ( | |
| @@ -4723,7 +4240,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: rec_trackcorrection; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: rec_trackcorrection; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE rec_trackcorrection ( | |
| @@ -4734,7 +4251,7 @@ | |
| proposed_album_name character varying NOT NULL, | |
| state character(1) DEFAULT 'p'::bpchar NOT NULL, | |
| reviewedby integer, | |
| - level integer DEFAULT '-1'::integer NOT NULL | |
| + level integer DEFAULT (-1) NOT NULL | |
| ); | |
| @@ -4765,56 +4282,7 @@ | |
| -- | |
| --- Name: rec_trackproposal; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE rec_trackproposal ( | |
| - proposalid integer NOT NULL, | |
| - proposed_title character varying, | |
| - proposed_artist character varying, | |
| - proposed_album_name character varying, | |
| - proposed_position smallint, | |
| - state character(1) DEFAULT 'p'::bpchar, | |
| - proposedby integer, | |
| - reviewedby integer | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: TABLE rec_trackproposal; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON TABLE rec_trackproposal IS 'Stores proposed metadata for tracks last.fm could not identify.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN rec_trackproposal.state; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN rec_trackproposal.state IS '''a'' Accepted, ''r'' Rejected or ''p'' Pending'; | |
| - | |
| - | |
| --- | |
| --- Name: rec_trackproposal_proposalid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE rec_trackproposal_proposalid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: rec_trackproposal_proposalid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE rec_trackproposal_proposalid_seq OWNED BY rec_trackproposal.proposalid; | |
| - | |
| - | |
| --- | |
| --- Name: recommended_listening; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: recommended_listening; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE recommended_listening ( | |
| @@ -4863,7 +4331,7 @@ | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| --- Name: show; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show ( | |
| @@ -4899,7 +4367,7 @@ | |
| -- Name: COLUMN show.submitted; Type: COMMENT; Schema: schedule; Owner: - | |
| -- | |
| -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)'; | |
| +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)'; | |
| -- | |
| @@ -4910,7 +4378,7 @@ | |
| -- | |
| --- Name: show_metadata; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_metadata ( | |
| @@ -4988,209 +4456,8 @@ | |
| 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.'; | |
| -SET search_path = public, pg_catalog; | |
| - | |
| --- | |
| --- Name: sched_entry; Type: VIEW; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE VIEW sched_entry AS | |
| - SELECT t0.entryid, | |
| - t0.entrytypeid, | |
| - t0.rss, | |
| - t0.url, | |
| - t1.summary, | |
| - t1.createddate, | |
| - NULL::unknown AS oid, | |
| - t1.summary AS description | |
| - FROM (( SELECT show.show_id AS entryid, | |
| - '3' AS entrytypeid, | |
| - NULL::unknown AS rss, | |
| - NULL::unknown AS url | |
| - FROM schedule.show) t0 | |
| - LEFT JOIN ( SELECT show_metadata.show_id AS entryid, | |
| - show_metadata.metadata_value AS summary, | |
| - show_metadata.effective_from AS createddate | |
| - FROM schedule.show_metadata | |
| - 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))); | |
| - | |
| - | |
| -SET default_with_oids = true; | |
| - | |
| --- | |
| --- Name: sched_entrytype; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sched_entrytype ( | |
| - entrytypeid integer NOT NULL, | |
| - entrytypename character varying(30) NOT NULL, | |
| - causesclash boolean DEFAULT true, | |
| - takesuptime boolean DEFAULT false | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN sched_entrytype.takesuptime; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN sched_entrytype.takesuptime IS 'defines if this entrytype appears in a persons schedule'; | |
| - | |
| - | |
| --- | |
| --- Name: sched_entrytype_entrytypeid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE sched_entrytype_entrytypeid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| -- | |
| --- Name: sched_entrytype_entrytypeid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE sched_entrytype_entrytypeid_seq OWNED BY sched_entrytype.entrytypeid; | |
| - | |
| - | |
| --- | |
| --- Name: sched_genre_genreid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE sched_genre_genreid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| -SET default_with_oids = false; | |
| - | |
| --- | |
| --- Name: sched_genre; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sched_genre ( | |
| - genreid integer DEFAULT nextval('sched_genre_genreid_seq'::regclass) NOT NULL, | |
| - genrename character varying(30) NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN sched_genre.genreid; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN sched_genre.genreid IS 'The unique ID number of the genre.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN sched_genre.genrename; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN sched_genre.genrename IS 'The name of the genre.'; | |
| - | |
| - | |
| -SET default_with_oids = true; | |
| - | |
| --- | |
| --- Name: sched_musiccategory; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sched_musiccategory ( | |
| - musiccategoryid integer NOT NULL, | |
| - musiccategoryname character varying(30) NOT NULL, | |
| - ordering integer | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: sched_musiccategory_musiccategoryid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE sched_musiccategory_musiccategoryid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: sched_musiccategory_musiccategoryid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE sched_musiccategory_musiccategoryid_seq OWNED BY sched_musiccategory.musiccategoryid; | |
| - | |
| - | |
| --- | |
| --- Name: sched_room; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sched_room ( | |
| - roomid integer NOT NULL, | |
| - roomname character varying(30) NOT NULL, | |
| - ordering integer | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: sched_room_roomid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE sched_room_roomid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: sched_room_roomid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE sched_room_roomid_seq OWNED BY sched_room.roomid; | |
| - | |
| - | |
| --- | |
| --- Name: sched_speechcategory; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sched_speechcategory ( | |
| - speechcategoryid integer NOT NULL, | |
| - speechcategoryname character varying(30) NOT NULL, | |
| - ordering integer | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: sched_speechcategory_speechcategoryid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE sched_speechcategory_speechcategoryid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: sched_speechcategory_speechcategoryid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE sched_speechcategory_speechcategoryid_seq OWNED BY sched_speechcategory.speechcategoryid; | |
| - | |
| - | |
| -SET search_path = schedule, pg_catalog; | |
| - | |
| -SET default_with_oids = false; | |
| - | |
| --- | |
| --- Name: show_season; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_season; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_season ( | |
| @@ -5245,7 +4512,7 @@ | |
| -- | |
| --- Name: show_season_timeslot; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_season_timeslot; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_season_timeslot ( | |
| @@ -5311,7 +4578,7 @@ | |
| -- | |
| --- Name: selector_actions; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: selector_actions; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE selector_actions ( | |
| @@ -5373,7 +4640,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: sis_commtype; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: sis_commtype; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE sis_commtype ( | |
| @@ -5404,7 +4671,7 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: sis_piss; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: sis_piss; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE sis_piss ( | |
| @@ -5444,7 +4711,7 @@ | |
| SET default_with_oids = true; | |
| -- | |
| --- Name: sis_status; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: sis_status; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE sis_status ( | |
| @@ -5458,7 +4725,7 @@ | |
| -- | |
| CREATE SEQUENCE sis_status_statusid_seq | |
| - START WITH 1 | |
| + START WITH 6 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| @@ -5487,66 +4754,54 @@ | |
| SET default_with_oids = false; | |
| -- | |
| --- Name: sso_session; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: site_package; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE sso_session ( | |
| - id character varying(32) NOT NULL, | |
| - data text, | |
| - "timestamp" timestamp without time zone NOT NULL | |
| +CREATE TABLE site_package ( | |
| + packageid integer NOT NULL, | |
| + name text NOT NULL, | |
| + active boolean DEFAULT false NOT NULL, | |
| + starttime timestamp without time zone, | |
| + endtime timestamp without time zone | |
| ); | |
| -SET default_with_oids = true; | |
| - | |
| -- | |
| --- Name: strm_useragent; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: TABLE site_package; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -CREATE TABLE strm_useragent ( | |
| - useragentid integer NOT NULL, | |
| - useragent character varying(255) NOT NULL | |
| -); | |
| +COMMENT ON TABLE site_package IS 'Table defining special event packages, which temporarily replace the site look and feel. | |
| +Packages reside in /content/packages/*NAME* and must include the following files: | |
| +1) package.css - a CSS file patching the normal URY CSS to add event-specific changes such as a different banner. | |
| +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.'; | |
| -- | |
| --- Name: strm_client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- Name: COLUMN site_package.packageid; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE strm_client_clientid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| +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.'; | |
| -- | |
| --- Name: strm_client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- Name: COLUMN site_package.name; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE strm_client_clientid_seq OWNED BY strm_useragent.useragentid; | |
| +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.'; | |
| -- | |
| --- Name: strm_log; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: COLUMN site_package.active; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -CREATE TABLE strm_log ( | |
| - logid integer NOT NULL, | |
| - streamid integer NOT NULL, | |
| - useragentid integer NOT NULL, | |
| - starttime timestamp with time zone NOT NULL, | |
| - endtime timestamp with time zone NOT NULL, | |
| - ipaddr inet NOT NULL | |
| -); | |
| +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.'; | |
| -- | |
| --- Name: strm_log_logid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- Name: site_special_package_packageid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE strm_log_logid_seq | |
| +CREATE SEQUENCE site_special_package_packageid_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| @@ -5555,28 +4810,28 @@ | |
| -- | |
| --- Name: strm_log_logid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- Name: site_special_package_packageid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE strm_log_logid_seq OWNED BY strm_log.logid; | |
| +ALTER SEQUENCE site_special_package_packageid_seq OWNED BY site_package.packageid; | |
| -- | |
| --- Name: strm_logfile; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: sitetree_tree; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE strm_logfile ( | |
| - logfileid integer NOT NULL, | |
| - filename character varying(255) NOT NULL, | |
| - lastsize integer | |
| +CREATE TABLE sitetree_tree ( | |
| + id integer NOT NULL, | |
| + title character varying(100) NOT NULL, | |
| + alias character varying(80) NOT NULL | |
| ); | |
| -- | |
| --- Name: strm_logfile_logfileid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- Name: sitetree_tree_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE strm_logfile_logfileid_seq | |
| +CREATE SEQUENCE sitetree_tree_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| @@ -5585,108 +4840,72 @@ | |
| -- | |
| --- Name: strm_logfile_logfileid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- Name: sitetree_tree_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE strm_logfile_logfileid_seq OWNED BY strm_logfile.logfileid; | |
| +ALTER SEQUENCE sitetree_tree_id_seq OWNED BY sitetree_tree.id; | |
| -- | |
| --- Name: strm_stream; Type: TABLE; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE strm_stream ( | |
| - streamid integer NOT NULL, | |
| - streamname character varying(255) NOT NULL | |
| +CREATE TABLE sitetree_treeitem ( | |
| + id integer NOT NULL, | |
| + title character varying(100) NOT NULL, | |
| + hint character varying(200) NOT NULL, | |
| + url character varying(200) NOT NULL, | |
| + urlaspattern boolean NOT NULL, | |
| + tree_id integer NOT NULL, | |
| + hidden boolean NOT NULL, | |
| + alias character varying(80), | |
| + description text NOT NULL, | |
| + inmenu boolean NOT NULL, | |
| + inbreadcrumbs boolean NOT NULL, | |
| + insitetree boolean NOT NULL, | |
| + access_loggedin boolean NOT NULL, | |
| + access_restricted boolean NOT NULL, | |
| + access_perm_type integer NOT NULL, | |
| + parent_id integer, | |
| + sort_order integer NOT NULL | |
| ); | |
| -- | |
| --- Name: strm_stream_streamid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE strm_stream_streamid_seq | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: strm_stream_streamid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem_access_permissions; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -ALTER SEQUENCE strm_stream_streamid_seq OWNED BY strm_stream.streamid; | |
| - | |
| - | |
| --- | |
| --- Name: team; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE team ( | |
| - teamid integer DEFAULT nextval(('"team_teamid_seq"'::text)::regclass) NOT NULL, | |
| - team_name character varying(255) NOT NULL, | |
| - descr character varying(255), | |
| - local_group character varying(255), | |
| - local_alias character varying(255), | |
| - ordering smallint, | |
| - status character(1) DEFAULT 'c'::bpchar NOT NULL | |
| +CREATE TABLE sitetree_treeitem_access_permissions ( | |
| + id integer NOT NULL, | |
| + treeitem_id integer NOT NULL, | |
| + permission_id integer NOT NULL | |
| ); | |
| -- | |
| --- Name: team_teamid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem_access_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE team_teamid_seq | |
| +CREATE SEQUENCE sitetree_treeitem_access_permissions_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| - MAXVALUE 2147483647 | |
| + NO MAXVALUE | |
| CACHE 1; | |
| -SET default_with_oids = false; | |
| - | |
| --- | |
| --- Name: terms; Type: TABLE; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE terms ( | |
| - start timestamp with time zone NOT NULL, | |
| - descr character varying(10) NOT NULL, | |
| - finish timestamp with time zone NOT NULL, | |
| - termid integer NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: TABLE terms; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -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.'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN terms.start; Type: COMMENT; Schema: public; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN terms.start IS 'Midnight UTC, Monday Week 1'; | |
| - | |
| - | |
| -- | |
| --- Name: COLUMN terms.finish; Type: COMMENT; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem_access_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN terms.finish IS 'Midnight UTC, Monday Week 11'; | |
| +ALTER SEQUENCE sitetree_treeitem_access_permissions_id_seq OWNED BY sitetree_treeitem_access_permissions.id; | |
| -- | |
| --- Name: terms_termid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem_id_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE terms_termid_seq | |
| +CREATE SEQUENCE sitetree_treeitem_id_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| @@ -5695,74 +4914,73 @@ | |
| -- | |
| --- Name: terms_termid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| +-- Name: sitetree_treeitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE terms_termid_seq OWNED BY terms.termid; | |
| - | |
| +ALTER SEQUENCE sitetree_treeitem_id_seq OWNED BY sitetree_treeitem.id; | |
| -SET search_path = rapier, pg_catalog; | |
| -- | |
| --- Name: acl_member; Type: TABLE; Schema: rapier; Owner: - | |
| +-- Name: sso_session; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE acl_member ( | |
| - privilegeid integer NOT NULL, | |
| - memberid integer, | |
| - class text NOT NULL, | |
| - verb text NOT NULL, | |
| - scope integer DEFAULT 0 NOT NULL | |
| +CREATE TABLE sso_session ( | |
| + id character varying(32) NOT NULL, | |
| + data text, | |
| + "timestamp" timestamp without time zone NOT NULL | |
| ); | |
| --- | |
| --- Name: TABLE acl_member; Type: COMMENT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -COMMENT ON TABLE acl_member IS 'Access Control List for regular members (used to grant temporary and extraordinary permissions)'; | |
| - | |
| - | |
| --- | |
| --- Name: COLUMN acl_member.privilegeid; Type: COMMENT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN acl_member.privilegeid IS 'The unique ID of this ACL row.'; | |
| - | |
| +SET default_with_oids = true; | |
| -- | |
| --- Name: COLUMN acl_member.memberid; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_useragent; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -COMMENT ON COLUMN acl_member.memberid IS 'The unique ID of the member being granted a permission.'; | |
| +CREATE TABLE strm_useragent ( | |
| + useragentid integer NOT NULL, | |
| + useragent character varying(255) NOT NULL | |
| +); | |
| -- | |
| --- Name: COLUMN acl_member.class; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_client_clientid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN acl_member.class IS 'The full name of the Rapier object class a permission is being granted for.'; | |
| +CREATE SEQUENCE strm_client_clientid_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| -- | |
| --- Name: COLUMN acl_member.verb; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN acl_member.verb IS 'The verb (eg "read") representing the privileged action being granted.'; | |
| +ALTER SEQUENCE strm_client_clientid_seq OWNED BY strm_useragent.useragentid; | |
| -- | |
| --- Name: COLUMN acl_member.scope; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_log; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -COMMENT ON COLUMN acl_member.scope IS 'The scope of this action being granted. (see constants_acl_scope).'; | |
| +CREATE TABLE strm_log ( | |
| + logid integer NOT NULL, | |
| + streamid integer NOT NULL, | |
| + useragentid integer NOT NULL, | |
| + starttime timestamp with time zone NOT NULL, | |
| + endtime timestamp with time zone NOT NULL, | |
| + ipaddr inet NOT NULL | |
| +); | |
| -- | |
| --- Name: acl_member_privilegeid_seq; Type: SEQUENCE; Schema: rapier; Owner: - | |
| +-- Name: strm_log_logid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE acl_member_privilegeid_seq | |
| +CREATE SEQUENCE strm_log_logid_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| @@ -5771,37 +4989,28 @@ | |
| -- | |
| --- Name: acl_member_privilegeid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: - | |
| +-- Name: strm_log_logid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE acl_member_privilegeid_seq OWNED BY acl_member.privilegeid; | |
| +ALTER SEQUENCE strm_log_logid_seq OWNED BY strm_log.logid; | |
| -- | |
| --- Name: acl_officer; Type: TABLE; Schema: rapier; Owner: - | |
| +-- Name: strm_logfile; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE acl_officer ( | |
| - privilegeid integer DEFAULT nextval('acl_member_privilegeid_seq'::regclass) NOT NULL, | |
| - officerid integer NOT NULL, | |
| - class text NOT NULL, | |
| - verb text NOT NULL, | |
| - scope integer DEFAULT 0 NOT NULL | |
| +CREATE TABLE strm_logfile ( | |
| + logfileid integer NOT NULL, | |
| + filename character varying(255) NOT NULL, | |
| + lastsize integer | |
| ); | |
| -- | |
| --- Name: COLUMN acl_officer.class; Type: COMMENT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -COMMENT ON COLUMN acl_officer.class IS 'The full name of the Rapier object class a permission is being granted for.'; | |
| - | |
| - | |
| --- | |
| --- Name: acl_officer_privilegeid_seq; Type: SEQUENCE; Schema: rapier; Owner: - | |
| +-- Name: strm_logfile_logfileid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE acl_officer_privilegeid_seq | |
| +CREATE SEQUENCE strm_logfile_logfileid_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| @@ -5810,108 +5019,109 @@ | |
| -- | |
| --- Name: client; Type: TABLE; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE client ( | |
| - clientid integer NOT NULL, | |
| - name text NOT NULL, | |
| - secrethash text NOT NULL, | |
| - description text | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: TABLE client; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_logfile_logfileid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON TABLE client IS 'Registry of clients allowed to use Rapier.'; | |
| +ALTER SEQUENCE strm_logfile_logfileid_seq OWNED BY strm_logfile.logfileid; | |
| -- | |
| --- Name: COLUMN client.clientid; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_stream; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -COMMENT ON COLUMN client.clientid IS 'The numeric ID of the client.'; | |
| +CREATE TABLE strm_stream ( | |
| + streamid integer NOT NULL, | |
| + streamname character varying(255) NOT NULL | |
| +); | |
| -- | |
| --- Name: COLUMN client.name; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_stream_streamid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN client.name IS 'The log-in name of the client.'; | |
| +CREATE SEQUENCE strm_stream_streamid_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| -- | |
| --- Name: COLUMN client.secrethash; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: strm_stream_streamid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN client.secrethash IS 'A hash of the log-in password of the client.'; | |
| +ALTER SEQUENCE strm_stream_streamid_seq OWNED BY strm_stream.streamid; | |
| -- | |
| --- Name: COLUMN client.description; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: team; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -COMMENT ON COLUMN client.description IS 'A human-readable description of the client.'; | |
| +CREATE TABLE team ( | |
| + teamid integer DEFAULT nextval(('"team_teamid_seq"'::text)::regclass) NOT NULL, | |
| + team_name character varying(255) NOT NULL, | |
| + descr character varying(255), | |
| + local_group character varying(255), | |
| + local_alias character varying(255), | |
| + ordering smallint, | |
| + status character(1) DEFAULT 'c'::bpchar NOT NULL | |
| +); | |
| -- | |
| --- Name: client_clientid_seq; Type: SEQUENCE; Schema: rapier; Owner: - | |
| +-- Name: team_teamid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE client_clientid_seq | |
| +CREATE SEQUENCE team_teamid_seq | |
| START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| - NO MAXVALUE | |
| + MAXVALUE 2147483647 | |
| CACHE 1; | |
| --- | |
| --- Name: client_clientid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE client_clientid_seq OWNED BY client.clientid; | |
| - | |
| +SET default_with_oids = false; | |
| -- | |
| --- Name: constants_acl_scope; Type: TABLE; Schema: rapier; Owner: - | |
| +-- Name: terms; Type: TABLE; Schema: public; Owner: -; Tablespace: | |
| -- | |
| -CREATE TABLE constants_acl_scope ( | |
| - scopeid integer NOT NULL, | |
| - description text NOT NULL | |
| +CREATE TABLE terms ( | |
| + start timestamp with time zone NOT NULL, | |
| + descr character varying(10) NOT NULL, | |
| + finish timestamp with time zone NOT NULL, | |
| + termid integer NOT NULL | |
| ); | |
| -- | |
| --- Name: TABLE constants_acl_scope; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: TABLE terms; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON TABLE constants_acl_scope IS 'Human-readable descriptions for the ACL scope levels.'; | |
| +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.'; | |
| -- | |
| --- Name: COLUMN constants_acl_scope.scopeid; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: COLUMN terms.start; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN constants_acl_scope.scopeid IS 'The unique ID of this scope level.'; | |
| +COMMENT ON COLUMN terms.start IS 'Midnight UTC, Monday Week 1'; | |
| -- | |
| --- Name: COLUMN constants_acl_scope.description; Type: COMMENT; Schema: rapier; Owner: - | |
| +-- Name: COLUMN terms.finish; Type: COMMENT; Schema: public; Owner: - | |
| -- | |
| -COMMENT ON COLUMN constants_acl_scope.description IS 'The human-readable description of this scope level.'; | |
| +COMMENT ON COLUMN terms.finish IS 'Midnight UTC, Monday Week 11'; | |
| -- | |
| --- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE; Schema: rapier; Owner: - | |
| +-- Name: terms_termid_seq; Type: SEQUENCE; Schema: public; Owner: - | |
| -- | |
| -CREATE SEQUENCE constants_acl_scope_scopeid_seq | |
| - START WITH 3 | |
| +CREATE SEQUENCE terms_termid_seq | |
| + START WITH 1 | |
| INCREMENT BY 1 | |
| NO MINVALUE | |
| NO MAXVALUE | |
| @@ -5919,16 +5129,16 @@ | |
| -- | |
| --- Name: constants_acl_scope_scopeid_seq; Type: SEQUENCE OWNED BY; Schema: rapier; Owner: - | |
| +-- Name: terms_termid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - | |
| -- | |
| -ALTER SEQUENCE constants_acl_scope_scopeid_seq OWNED BY constants_acl_scope.scopeid; | |
| +ALTER SEQUENCE terms_termid_seq OWNED BY terms.termid; | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| --- Name: block; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: block; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE block ( | |
| @@ -6010,7 +5220,7 @@ | |
| -- | |
| --- Name: block_range_rule; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: block_range_rule; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE block_range_rule ( | |
| @@ -6026,7 +5236,6 @@ | |
| -- | |
| COMMENT ON TABLE block_range_rule IS 'Block rules that associate timeslots falling into given ranges with corresponding blocks. | |
| - | |
| This is the lowest priority rule type.'; | |
| @@ -6090,7 +5299,7 @@ | |
| -- | |
| --- Name: block_show_rule; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: block_show_rule; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE block_show_rule ( | |
| @@ -6105,7 +5314,6 @@ | |
| -- | |
| COMMENT ON TABLE block_show_rule IS 'A block show rule matches all timeslots of a given show to a given block. | |
| - | |
| This rule scheme takes precedence over any other scheme except direct timeslot assignment.'; | |
| @@ -6150,7 +5358,7 @@ | |
| -- | |
| --- Name: genre; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: genre; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE genre ( | |
| @@ -6179,7 +5387,7 @@ | |
| -- | |
| --- Name: location; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: location; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE location ( | |
| @@ -6234,7 +5442,7 @@ | |
| -- | |
| --- Name: season_metadata; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: season_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE season_metadata ( | |
| @@ -6306,7 +5514,7 @@ | |
| -- | |
| --- Name: show_credit; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_credit; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_credit ( | |
| @@ -6348,7 +5556,7 @@ | |
| -- | |
| --- Name: show_genre; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_genre; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_genre ( | |
| @@ -6382,7 +5590,7 @@ | |
| -- | |
| --- Name: show_image_metadata; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_image_metadata ( | |
| @@ -6417,7 +5625,7 @@ | |
| -- | |
| --- Name: show_location; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_location; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_location ( | |
| @@ -6470,7 +5678,7 @@ | |
| -- | |
| --- Name: show_podcast_link; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_podcast_link; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_podcast_link ( | |
| @@ -6480,7 +5688,7 @@ | |
| -- | |
| --- Name: show_season_requested_time; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_season_requested_time; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_season_requested_time ( | |
| @@ -6548,7 +5756,7 @@ | |
| -- | |
| --- Name: show_season_requested_week; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_season_requested_week; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_season_requested_week ( | |
| @@ -6642,7 +5850,6 @@ | |
| -- | |
| COMMENT ON VIEW show_season_timeslot_credit IS 'Removed: | |
| - | |
| 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));'; | |
| @@ -6666,7 +5873,7 @@ | |
| -- | |
| --- Name: timeslot_metadata; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: timeslot_metadata; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE timeslot_metadata ( | |
| @@ -6740,7 +5947,7 @@ | |
| -- | |
| --- Name: show_type; Type: TABLE; Schema: schedule; Owner: - | |
| +-- Name: show_type; Type: TABLE; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE show_type ( | |
| @@ -6844,7 +6051,7 @@ | |
| SET search_path = sis2, pg_catalog; | |
| -- | |
| --- Name: config; Type: TABLE; Schema: sis2; Owner: - | |
| +-- Name: config; Type: TABLE; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE config ( | |
| @@ -6854,7 +6061,7 @@ | |
| -- | |
| --- Name: member_options; Type: TABLE; Schema: sis2; Owner: - | |
| +-- Name: member_options; Type: TABLE; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_options ( | |
| @@ -6864,7 +6071,7 @@ | |
| -- | |
| --- Name: member_signin; Type: TABLE; Schema: sis2; Owner: - | |
| +-- Name: member_signin; Type: TABLE; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE member_signin ( | |
| @@ -6938,7 +6145,7 @@ | |
| -- | |
| --- Name: messages; Type: TABLE; Schema: sis2; Owner: - | |
| +-- Name: messages; Type: TABLE; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE messages ( | |
| @@ -6980,281 +6187,10 @@ | |
| ALTER SEQUENCE messages_commid_seq OWNED BY messages.commid; | |
| -SET search_path = smsd, pg_catalog; | |
| - | |
| --- | |
| --- Name: daemons; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE daemons ( | |
| - "Start" text NOT NULL, | |
| - "Info" text NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: gammu; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE gammu ( | |
| - "Version" smallint DEFAULT (0)::smallint NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: inbox; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE inbox ( | |
| - "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "ReceivingDateTime" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "Text" text NOT NULL, | |
| - "SenderNumber" character varying(20) DEFAULT ''::character varying NOT NULL, | |
| - "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL, | |
| - "UDH" text NOT NULL, | |
| - "SMSCNumber" character varying(20) DEFAULT ''::character varying NOT NULL, | |
| - "Class" integer DEFAULT '-1'::integer NOT NULL, | |
| - "TextDecoded" text DEFAULT ''::text NOT NULL, | |
| - "ID" integer NOT NULL, | |
| - "RecipientID" text NOT NULL, | |
| - "Processed" boolean DEFAULT false NOT NULL, | |
| - 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]))) | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: inbox_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "inbox_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: inbox_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "inbox_ID_seq" OWNED BY inbox."ID"; | |
| - | |
| - | |
| --- | |
| --- Name: outbox; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE outbox ( | |
| - "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "SendingDateTime" timestamp without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "SendBefore" time without time zone DEFAULT '23:59:59'::time without time zone NOT NULL, | |
| - "SendAfter" time without time zone DEFAULT '00:00:00'::time without time zone NOT NULL, | |
| - "Text" text, | |
| - "DestinationNumber" character varying(20) DEFAULT ''::character varying NOT NULL, | |
| - "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL, | |
| - "UDH" text, | |
| - "Class" integer DEFAULT '-1'::integer, | |
| - "TextDecoded" text DEFAULT ''::text NOT NULL, | |
| - "ID" integer NOT NULL, | |
| - "MultiPart" boolean DEFAULT false NOT NULL, | |
| - "RelativeValidity" integer DEFAULT '-1'::integer, | |
| - "SenderID" character varying(255), | |
| - "SendingTimeOut" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "DeliveryReport" character varying(10) DEFAULT 'default'::character varying, | |
| - "CreatorID" text NOT NULL, | |
| - 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]))), | |
| - CONSTRAINT "outbox_DeliveryReport_check" CHECK ((("DeliveryReport")::text = ANY (ARRAY[('default'::character varying)::text, ('yes'::character varying)::text, ('no'::character varying)::text]))) | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: outbox_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "outbox_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: outbox_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "outbox_ID_seq" OWNED BY outbox."ID"; | |
| - | |
| - | |
| --- | |
| --- Name: outbox_multipart; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE outbox_multipart ( | |
| - "Text" text, | |
| - "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL, | |
| - "UDH" text, | |
| - "Class" integer DEFAULT '-1'::integer, | |
| - "TextDecoded" text, | |
| - "ID" integer NOT NULL, | |
| - "SequencePosition" integer DEFAULT 1 NOT NULL, | |
| - 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]))) | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: outbox_multipart_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "outbox_multipart_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: outbox_multipart_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "outbox_multipart_ID_seq" OWNED BY outbox_multipart."ID"; | |
| - | |
| - | |
| --- | |
| --- Name: pbk; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE pbk ( | |
| - "ID" integer NOT NULL, | |
| - "GroupID" integer DEFAULT '-1'::integer NOT NULL, | |
| - "Name" text NOT NULL, | |
| - "Number" text NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: pbk_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "pbk_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: pbk_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "pbk_ID_seq" OWNED BY pbk."ID"; | |
| - | |
| - | |
| --- | |
| --- Name: pbk_groups; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE pbk_groups ( | |
| - "Name" text NOT NULL, | |
| - "ID" integer NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: pbk_groups_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "pbk_groups_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: pbk_groups_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "pbk_groups_ID_seq" OWNED BY pbk_groups."ID"; | |
| - | |
| - | |
| --- | |
| --- Name: phones; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE phones ( | |
| - "ID" text NOT NULL, | |
| - "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "TimeOut" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "Send" boolean DEFAULT false NOT NULL, | |
| - "Receive" boolean DEFAULT false NOT NULL, | |
| - "IMEI" character varying(35) NOT NULL, | |
| - "Client" text NOT NULL, | |
| - "Battery" integer DEFAULT '-1'::integer NOT NULL, | |
| - "Signal" integer DEFAULT '-1'::integer NOT NULL, | |
| - "Sent" integer DEFAULT 0 NOT NULL, | |
| - "Received" integer DEFAULT 0 NOT NULL | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems; Type: TABLE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TABLE sentitems ( | |
| - "UpdatedInDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "InsertIntoDB" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "SendingDateTime" timestamp(0) without time zone DEFAULT ('now'::text)::timestamp(0) without time zone NOT NULL, | |
| - "DeliveryDateTime" timestamp(0) without time zone, | |
| - "Text" text NOT NULL, | |
| - "DestinationNumber" character varying(20) DEFAULT ''::character varying NOT NULL, | |
| - "Coding" character varying(255) DEFAULT 'Default_No_Compression'::character varying NOT NULL, | |
| - "UDH" text NOT NULL, | |
| - "SMSCNumber" character varying(20) DEFAULT ''::character varying NOT NULL, | |
| - "Class" integer DEFAULT '-1'::integer NOT NULL, | |
| - "TextDecoded" text DEFAULT ''::text NOT NULL, | |
| - "ID" integer NOT NULL, | |
| - "SenderID" character varying(255) NOT NULL, | |
| - "SequencePosition" integer DEFAULT 1 NOT NULL, | |
| - "Status" character varying(255) DEFAULT 'SendingOK'::character varying NOT NULL, | |
| - "StatusError" integer DEFAULT '-1'::integer NOT NULL, | |
| - "TPMR" integer DEFAULT '-1'::integer NOT NULL, | |
| - "RelativeValidity" integer DEFAULT '-1'::integer NOT NULL, | |
| - "CreatorID" text NOT NULL, | |
| - 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]))), | |
| - 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]))) | |
| -); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_ID_seq; Type: SEQUENCE; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE SEQUENCE "sentitems_ID_seq" | |
| - START WITH 1 | |
| - INCREMENT BY 1 | |
| - NO MINVALUE | |
| - NO MAXVALUE | |
| - CACHE 1; | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_ID_seq; Type: SEQUENCE OWNED BY; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER SEQUENCE "sentitems_ID_seq" OWNED BY sentitems."ID"; | |
| - | |
| - | |
| SET search_path = tracklist, pg_catalog; | |
| -- | |
| --- Name: selbaps; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: selbaps; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE selbaps ( | |
| @@ -7271,7 +6207,7 @@ | |
| -- | |
| --- Name: source; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: source; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE source ( | |
| @@ -7288,7 +6224,7 @@ | |
| -- | |
| --- Name: state; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: state; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE state ( | |
| @@ -7305,7 +6241,7 @@ | |
| -- | |
| --- Name: track_notrec; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: track_notrec; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE track_notrec ( | |
| @@ -7327,7 +6263,7 @@ | |
| -- | |
| --- Name: track_rec; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: track_rec; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE track_rec ( | |
| @@ -7345,7 +6281,7 @@ | |
| -- | |
| --- Name: tracklist; Type: TABLE; Schema: tracklist; Owner: - | |
| +-- Name: tracklist; Type: TABLE; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE tracklist ( | |
| @@ -7388,7 +6324,7 @@ | |
| SET search_path = uryplayer, pg_catalog; | |
| -- | |
| --- Name: podcast; Type: TABLE; Schema: uryplayer; Owner: - | |
| +-- Name: podcast; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE podcast ( | |
| @@ -7402,7 +6338,7 @@ | |
| -- | |
| --- Name: podcast_credit; Type: TABLE; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE podcast_credit ( | |
| @@ -7437,7 +6373,7 @@ | |
| -- | |
| --- Name: podcast_image_metadata; Type: TABLE; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE podcast_image_metadata ( | |
| @@ -7472,7 +6408,7 @@ | |
| -- | |
| --- Name: podcast_metadata; Type: TABLE; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE podcast_metadata ( | |
| @@ -7507,7 +6443,7 @@ | |
| -- | |
| --- Name: podcast_package_entry; Type: TABLE; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry; Type: TABLE; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE podcast_package_entry ( | |
| @@ -7578,7 +6514,7 @@ | |
| SET search_path = webcam, pg_catalog; | |
| -- | |
| --- Name: memberviews; Type: TABLE; Schema: webcam; Owner: - | |
| +-- Name: memberviews; Type: TABLE; Schema: webcam; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE memberviews ( | |
| @@ -7588,15 +6524,14 @@ | |
| -- | |
| --- Name: streams; Type: TABLE; Schema: webcam; Owner: - | |
| +-- Name: streams; Type: TABLE; Schema: webcam; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE streams ( | |
| streamid integer NOT NULL, | |
| streamname character varying NOT NULL, | |
| liveurl character varying NOT NULL, | |
| - staticurl character varying NOT NULL, | |
| - camera text | |
| + staticurl character varying NOT NULL | |
| ); | |
| @@ -7604,7 +6539,7 @@ | |
| -- Name: TABLE streams; Type: COMMENT; Schema: webcam; Owner: - | |
| -- | |
| -COMMENT ON TABLE streams IS 'Stores a list of streams available on MyURY'; | |
| +COMMENT ON TABLE streams IS 'Stores a list of streams available on MyRadio'; | |
| -- | |
| @@ -7629,7 +6564,7 @@ | |
| SET search_path = website, pg_catalog; | |
| -- | |
| --- Name: banner; Type: TABLE; Schema: website; Owner: - | |
| +-- Name: banner; Type: TABLE; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE banner ( | |
| @@ -7646,7 +6581,7 @@ | |
| -- Name: COLUMN banner.photoid; Type: COMMENT; Schema: website; Owner: - | |
| -- | |
| -COMMENT ON COLUMN banner.photoid IS 'The corresponding MyURY Photo ID, if one exists.'; | |
| +COMMENT ON COLUMN banner.photoid IS 'The corresponding MyRadio Photo ID, if one exists.'; | |
| -- | |
| @@ -7669,7 +6604,41 @@ | |
| -- | |
| --- Name: banner_location; Type: TABLE; Schema: website; Owner: - | |
| +-- Name: banner_campaign; Type: TABLE; Schema: website; Owner: -; Tablespace: | |
| +-- | |
| + | |
| +CREATE TABLE banner_campaign ( | |
| + memberid integer, | |
| + approvedid integer, | |
| + effective_from timestamp with time zone NOT NULL, | |
| + effective_to timestamp with time zone, | |
| + banner_campaign_id integer NOT NULL, | |
| + banner_location_id integer NOT NULL, | |
| + banner_id integer NOT NULL | |
| +); | |
| + | |
| + | |
| +-- | |
| +-- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE; Schema: website; Owner: - | |
| +-- | |
| + | |
| +CREATE SEQUENCE banner_campaign_banner_campaign_id_seq | |
| + START WITH 1 | |
| + INCREMENT BY 1 | |
| + NO MINVALUE | |
| + NO MAXVALUE | |
| + CACHE 1; | |
| + | |
| + | |
| +-- | |
| +-- Name: banner_campaign_banner_campaign_id_seq; Type: SEQUENCE OWNED BY; Schema: website; Owner: - | |
| +-- | |
| + | |
| +ALTER SEQUENCE banner_campaign_banner_campaign_id_seq OWNED BY banner_campaign.banner_campaign_id; | |
| + | |
| + | |
| +-- | |
| +-- Name: banner_location; Type: TABLE; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE banner_location ( | |
| @@ -7699,7 +6668,7 @@ | |
| -- | |
| --- Name: banner_timeslot; Type: TABLE; Schema: website; Owner: - | |
| +-- Name: banner_timeslot; Type: TABLE; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE banner_timeslot ( | |
| @@ -7750,7 +6719,7 @@ | |
| -- | |
| --- Name: banner_type; Type: TABLE; Schema: website; Owner: - | |
| +-- Name: banner_type; Type: TABLE; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE TABLE banner_type ( | |
| @@ -7782,20 +6751,6 @@ | |
| SET search_path = bapsplanner, pg_catalog; | |
| -- | |
| --- Name: client_id; Type: DEFAULT; Schema: bapsplanner; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY client_ids ALTER COLUMN client_id SET DEFAULT nextval('client_ids_client_id_seq'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: manageditemid; Type: DEFAULT; Schema: bapsplanner; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY managed_items ALTER COLUMN manageditemid SET DEFAULT nextval('managed_items_manageditemid_seq'::regclass); | |
| - | |
| - | |
| --- | |
| -- Name: managedplaylistid; Type: DEFAULT; Schema: bapsplanner; Owner: - | |
| -- | |
| @@ -7967,13 +6922,6 @@ | |
| -- | |
| --- Name: contract_version_id; Type: DEFAULT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY contract_versions ALTER COLUMN contract_version_id SET DEFAULT nextval('contract_versions_contract_version_id_seq'::regclass); | |
| - | |
| - | |
| --- | |
| -- Name: request_id; Type: DEFAULT; Schema: myury; Owner: - | |
| -- | |
| @@ -8069,6 +7017,13 @@ | |
| SET search_path = public, pg_catalog; | |
| -- | |
| +-- Name: privilegeid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER TABLE ONLY acl_member ALTER COLUMN privilegeid SET DEFAULT nextval('acl_member_privilegeid_seq'::regclass); | |
| + | |
| + | |
| +-- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| @@ -8079,6 +7034,13 @@ | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| +ALTER TABLE ONLY auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass); | |
| + | |
| + | |
| +-- | |
| +-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| +-- | |
| + | |
| ALTER TABLE ONLY auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass); | |
| @@ -8181,6 +7143,20 @@ | |
| -- | |
| +-- Name: clientid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER TABLE ONLY client ALTER COLUMN clientid SET DEFAULT nextval('client_clientid_seq'::regclass); | |
| + | |
| + | |
| +-- | |
| +-- Name: scopeid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER TABLE ONLY constants_acl_scope ALTER COLUMN scopeid SET DEFAULT nextval('constants_acl_scope_scopeid_seq'::regclass); | |
| + | |
| + | |
| +-- | |
| -- Name: feedid; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| @@ -8237,73 +7213,66 @@ | |
| -- | |
| --- Name: proposalid; Type: DEFAULT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY rec_trackproposal ALTER COLUMN proposalid SET DEFAULT nextval('rec_trackproposal_proposalid_seq'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: entrytypeid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: selid; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sched_entrytype ALTER COLUMN entrytypeid SET DEFAULT nextval('sched_entrytype_entrytypeid_seq'::regclass); | |
| +ALTER TABLE ONLY selector ALTER COLUMN selid SET DEFAULT nextval('selector_selid_seq'::regclass); | |
| -- | |
| --- Name: musiccategoryid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: action; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sched_musiccategory ALTER COLUMN musiccategoryid SET DEFAULT nextval('sched_musiccategory_musiccategoryid_seq'::regclass); | |
| +ALTER TABLE ONLY selector_actions ALTER COLUMN action SET DEFAULT nextval('selector_actions_action_seq'::regclass); | |
| -- | |
| --- Name: roomid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: commtypeid; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sched_room ALTER COLUMN roomid SET DEFAULT nextval('sched_room_roomid_seq'::regclass); | |
| +ALTER TABLE ONLY sis_commtype ALTER COLUMN commtypeid SET DEFAULT nextval('sis_commtype_commtypeid_seq'::regclass); | |
| -- | |
| --- Name: speechcategoryid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sched_speechcategory ALTER COLUMN speechcategoryid SET DEFAULT nextval('sched_speechcategory_speechcategoryid_seq'::regclass); | |
| +ALTER TABLE ONLY sis_piss ALTER COLUMN id SET DEFAULT nextval('sis_piss_id_seq'::regclass); | |
| -- | |
| --- Name: selid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: statusid; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY selector ALTER COLUMN selid SET DEFAULT nextval('selector_selid_seq'::regclass); | |
| +ALTER TABLE ONLY sis_status ALTER COLUMN statusid SET DEFAULT nextval('sis_status_statusid_seq'::regclass); | |
| -- | |
| --- Name: action; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: packageid; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY selector_actions ALTER COLUMN action SET DEFAULT nextval('selector_actions_action_seq'::regclass); | |
| +ALTER TABLE ONLY site_package ALTER COLUMN packageid SET DEFAULT nextval('site_special_package_packageid_seq'::regclass); | |
| -- | |
| --- Name: commtypeid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sis_commtype ALTER COLUMN commtypeid SET DEFAULT nextval('sis_commtype_commtypeid_seq'::regclass); | |
| +ALTER TABLE ONLY sitetree_tree ALTER COLUMN id SET DEFAULT nextval('sitetree_tree_id_seq'::regclass); | |
| -- | |
| -- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sis_piss ALTER COLUMN id SET DEFAULT nextval('sis_piss_id_seq'::regclass); | |
| +ALTER TABLE ONLY sitetree_treeitem ALTER COLUMN id SET DEFAULT nextval('sitetree_treeitem_id_seq'::regclass); | |
| -- | |
| --- Name: statusid; Type: DEFAULT; Schema: public; Owner: - | |
| +-- Name: id; Type: DEFAULT; Schema: public; Owner: - | |
| -- | |
| -ALTER TABLE ONLY sis_status ALTER COLUMN statusid SET DEFAULT nextval('sis_status_statusid_seq'::regclass); | |
| +ALTER TABLE ONLY sitetree_treeitem_access_permissions ALTER COLUMN id SET DEFAULT nextval('sitetree_treeitem_access_permissions_id_seq'::regclass); | |
| -- | |
| @@ -8341,29 +7310,6 @@ | |
| ALTER TABLE ONLY terms ALTER COLUMN termid SET DEFAULT nextval('terms_termid_seq'::regclass); | |
| -SET search_path = rapier, pg_catalog; | |
| - | |
| --- | |
| --- Name: privilegeid; Type: DEFAULT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_member ALTER COLUMN privilegeid SET DEFAULT nextval('acl_member_privilegeid_seq'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: clientid; Type: DEFAULT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY client ALTER COLUMN clientid SET DEFAULT nextval('client_clientid_seq'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: scopeid; Type: DEFAULT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY constants_acl_scope ALTER COLUMN scopeid SET DEFAULT nextval('constants_acl_scope_scopeid_seq'::regclass); | |
| - | |
| - | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| @@ -8494,50 +7440,6 @@ | |
| ALTER TABLE ONLY messages ALTER COLUMN commid SET DEFAULT nextval('messages_commid_seq'::regclass); | |
| -SET search_path = smsd, pg_catalog; | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY inbox ALTER COLUMN "ID" SET DEFAULT nextval('"inbox_ID_seq"'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY outbox ALTER COLUMN "ID" SET DEFAULT nextval('"outbox_ID_seq"'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY outbox_multipart ALTER COLUMN "ID" SET DEFAULT nextval('"outbox_multipart_ID_seq"'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY pbk ALTER COLUMN "ID" SET DEFAULT nextval('"pbk_ID_seq"'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY pbk_groups ALTER COLUMN "ID" SET DEFAULT nextval('"pbk_groups_ID_seq"'::regclass); | |
| - | |
| - | |
| --- | |
| --- Name: ID; Type: DEFAULT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sentitems ALTER COLUMN "ID" SET DEFAULT nextval('"sentitems_ID_seq"'::regclass); | |
| - | |
| - | |
| SET search_path = tracklist, pg_catalog; | |
| -- | |
| @@ -8633,7 +7535,7 @@ | |
| SET search_path = bapsplanner, pg_catalog; | |
| -- | |
| --- Name: auto_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: auto_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auto_playlists | |
| @@ -8641,7 +7543,7 @@ | |
| -- | |
| --- Name: client_ids_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: client_ids_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY client_ids | |
| @@ -8649,7 +7551,7 @@ | |
| -- | |
| --- Name: managed_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY managed_items | |
| @@ -8657,7 +7559,7 @@ | |
| -- | |
| --- Name: managed_playlists_folder_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_playlists_folder_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY managed_playlists | |
| @@ -8665,7 +7567,7 @@ | |
| -- | |
| --- Name: managed_playlists_name_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_playlists_name_key; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY managed_playlists | |
| @@ -8673,7 +7575,7 @@ | |
| -- | |
| --- Name: managed_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: managed_playlists_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY managed_playlists | |
| @@ -8681,7 +7583,7 @@ | |
| -- | |
| --- Name: secure_play_token_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: secure_play_token_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY secure_play_token | |
| @@ -8689,7 +7591,7 @@ | |
| -- | |
| --- Name: timeslot_change_ops_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: timeslot_change_ops_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY timeslot_change_ops | |
| @@ -8697,43 +7599,17 @@ | |
| -- | |
| --- Name: timeslot_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: - | |
| +-- Name: timeslot_items_pkey; Type: CONSTRAINT; Schema: bapsplanner; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY timeslot_items | |
| ADD CONSTRAINT timeslot_items_pkey PRIMARY KEY (timeslot_item_id); | |
| -SET search_path = deploy, pg_catalog; | |
| - | |
| --- | |
| --- Name: myury_pkey; Type: CONSTRAINT; Schema: deploy; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY myury | |
| - ADD CONSTRAINT myury_pkey PRIMARY KEY (memberid); | |
| - | |
| - | |
| --- | |
| --- Name: showplanner_pkey; Type: CONSTRAINT; Schema: deploy; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY showplanner | |
| - ADD CONSTRAINT showplanner_pkey PRIMARY KEY (memberid); | |
| - | |
| - | |
| SET search_path = jukebox, pg_catalog; | |
| -- | |
| --- Name: playlist_availability_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY playlist_availability | |
| - ADD CONSTRAINT playlist_availability_pkey PRIMARY KEY (playlist_availability_id); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_entries_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: playlist_entries_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY playlist_entries | |
| @@ -8741,7 +7617,7 @@ | |
| -- | |
| --- Name: playlist_revisions_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: playlist_revisions_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY playlist_revisions | |
| @@ -8749,7 +7625,7 @@ | |
| -- | |
| --- Name: playlist_timeslot_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: playlist_timeslot_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY playlist_timeslot | |
| @@ -8757,7 +7633,7 @@ | |
| -- | |
| --- Name: playlists_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: playlists_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY playlists | |
| @@ -8765,7 +7641,7 @@ | |
| -- | |
| --- Name: request_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: request_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY request | |
| @@ -8773,7 +7649,7 @@ | |
| -- | |
| --- Name: silence_log_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: silence_log_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY silence_log | |
| @@ -8781,53 +7657,17 @@ | |
| -- | |
| --- Name: track_blacklist_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: - | |
| +-- Name: track_blacklist_pkey; Type: CONSTRAINT; Schema: jukebox; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY track_blacklist | |
| ADD CONSTRAINT track_blacklist_pkey PRIMARY KEY (trackid); | |
| -SET search_path = loggerng, pg_catalog; | |
| - | |
| --- | |
| --- Name: logs_pkey; Type: CONSTRAINT; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY logs | |
| - ADD CONSTRAINT logs_pkey PRIMARY KEY (start, "end", format); | |
| - | |
| - | |
| --- | |
| --- Name: requests_pkey; Type: CONSTRAINT; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_pkey PRIMARY KEY ("user", start, "end", format); | |
| - | |
| - | |
| -SET search_path = loggerng_test, pg_catalog; | |
| - | |
| --- | |
| --- Name: logs_pkey; Type: CONSTRAINT; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY logs | |
| - ADD CONSTRAINT logs_pkey PRIMARY KEY (start, "end", format); | |
| - | |
| - | |
| --- | |
| --- Name: requests_pkey; Type: CONSTRAINT; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_pkey PRIMARY KEY ("user", start, "end", format); | |
| - | |
| - | |
| SET search_path = mail, pg_catalog; | |
| -- | |
| --- Name: alias_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias_list | |
| @@ -8835,7 +7675,7 @@ | |
| -- | |
| --- Name: alias_member_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_member_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias_member | |
| @@ -8843,7 +7683,7 @@ | |
| -- | |
| --- Name: alias_officer_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_officer_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias_officer | |
| @@ -8851,7 +7691,7 @@ | |
| -- | |
| --- Name: alias_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias | |
| @@ -8859,7 +7699,7 @@ | |
| -- | |
| --- Name: alias_source_key; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_source_key; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias | |
| @@ -8867,7 +7707,7 @@ | |
| -- | |
| --- Name: alias_text_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: alias_text_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY alias_text | |
| @@ -8875,7 +7715,7 @@ | |
| -- | |
| --- Name: email_recipient_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: email_recipient_list_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY email_recipient_list | |
| @@ -8883,7 +7723,7 @@ | |
| -- | |
| --- Name: email_recipient_user_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: email_recipient_user_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY email_recipient_member | |
| @@ -8891,7 +7731,7 @@ | |
| -- | |
| --- Name: emails_pkey; Type: CONSTRAINT; Schema: mail; Owner: - | |
| +-- Name: emails_pkey; Type: CONSTRAINT; Schema: mail; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY email | |
| @@ -8901,7 +7741,7 @@ | |
| SET search_path = metadata, pg_catalog; | |
| -- | |
| --- Name: metadata_key_name_key; Type: CONSTRAINT; Schema: metadata; Owner: - | |
| +-- Name: metadata_key_name_key; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY metadata_key | |
| @@ -8909,7 +7749,7 @@ | |
| -- | |
| --- Name: metadata_key_pkey; Type: CONSTRAINT; Schema: metadata; Owner: - | |
| +-- Name: metadata_key_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY metadata_key | |
| @@ -8917,7 +7757,7 @@ | |
| -- | |
| --- Name: package_image_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY package_image_metadata | |
| @@ -8925,7 +7765,7 @@ | |
| -- | |
| --- Name: package_pkey; Type: CONSTRAINT; Schema: metadata; Owner: - | |
| +-- Name: package_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY package | |
| @@ -8933,7 +7773,7 @@ | |
| -- | |
| --- Name: package_text_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata_pkey; Type: CONSTRAINT; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY package_text_metadata | |
| @@ -8943,7 +7783,7 @@ | |
| SET search_path = music, pg_catalog; | |
| -- | |
| --- Name: chart_release_pkey; Type: CONSTRAINT; Schema: music; Owner: - | |
| +-- Name: chart_release_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY chart_release | |
| @@ -8951,7 +7791,7 @@ | |
| -- | |
| --- Name: chart_row_chart_row_id_key; Type: CONSTRAINT; Schema: music; Owner: - | |
| +-- Name: chart_row_chart_row_id_key; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY chart_row | |
| @@ -8959,7 +7799,7 @@ | |
| -- | |
| --- Name: chart_row_pkey; Type: CONSTRAINT; Schema: music; Owner: - | |
| +-- Name: chart_row_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY chart_row | |
| @@ -8967,7 +7807,7 @@ | |
| -- | |
| --- Name: chart_type_pkey; Type: CONSTRAINT; Schema: music; Owner: - | |
| +-- Name: chart_type_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY chart_type | |
| @@ -8975,7 +7815,7 @@ | |
| -- | |
| --- Name: explicit_checked_pkey; Type: CONSTRAINT; Schema: music; Owner: - | |
| +-- Name: explicit_checked_pkey; Type: CONSTRAINT; Schema: music; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY explicit_checked | |
| @@ -8985,7 +7825,7 @@ | |
| SET search_path = myradio, pg_catalog; | |
| -- | |
| --- Name: schema_pkey; Type: CONSTRAINT; Schema: myradio; Owner: - | |
| +-- Name: schema_pkey; Type: CONSTRAINT; Schema: myradio; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY schema | |
| @@ -8995,7 +7835,7 @@ | |
| SET search_path = myury, pg_catalog; | |
| -- | |
| --- Name: act_permission_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: act_permission_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY act_permission | |
| @@ -9003,7 +7843,7 @@ | |
| -- | |
| --- Name: act_permission_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: act_permission_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY act_permission | |
| @@ -9011,7 +7851,7 @@ | |
| -- | |
| --- Name: actions_moduleid_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: actions_moduleid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY actions | |
| @@ -9019,7 +7859,7 @@ | |
| -- | |
| --- Name: actions_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: actions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY actions | |
| @@ -9027,7 +7867,7 @@ | |
| -- | |
| --- Name: api_class_map_api_name_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_class_map_api_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_class_map | |
| @@ -9035,7 +7875,7 @@ | |
| -- | |
| --- Name: api_class_map_class_name_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_class_map_class_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_class_map | |
| @@ -9043,7 +7883,7 @@ | |
| -- | |
| --- Name: api_class_map_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_class_map_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_class_map | |
| @@ -9051,7 +7891,7 @@ | |
| -- | |
| --- Name: api_key_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_key_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_key_auth | |
| @@ -9059,7 +7899,7 @@ | |
| -- | |
| --- Name: api_key_log_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_key_log_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_key_log | |
| @@ -9067,7 +7907,7 @@ | |
| -- | |
| --- Name: api_key_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_key_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_key | |
| @@ -9075,7 +7915,7 @@ | |
| -- | |
| --- Name: api_method_auth_class_name_method_name_typeid_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_method_auth_class_name_method_name_typeid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_method_auth | |
| @@ -9083,7 +7923,7 @@ | |
| -- | |
| --- Name: api_method_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: api_method_auth_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY api_method_auth | |
| @@ -9091,7 +7931,7 @@ | |
| -- | |
| --- Name: award_categories_name_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: award_categories_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY award_categories | |
| @@ -9099,7 +7939,7 @@ | |
| -- | |
| --- Name: award_categories_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: award_categories_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY award_categories | |
| @@ -9107,7 +7947,7 @@ | |
| -- | |
| --- Name: award_member_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: award_member_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY award_member | |
| @@ -9115,15 +7955,7 @@ | |
| -- | |
| --- Name: contract_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY contract_versions | |
| - ADD CONSTRAINT contract_versions_pkey PRIMARY KEY (contract_version_id); | |
| - | |
| - | |
| --- | |
| --- Name: error_rate_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: error_rate_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY error_rate | |
| @@ -9131,7 +7963,7 @@ | |
| -- | |
| --- Name: modules_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: modules_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY modules | |
| @@ -9139,7 +7971,7 @@ | |
| -- | |
| --- Name: modules_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: modules_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY modules | |
| @@ -9147,7 +7979,7 @@ | |
| -- | |
| --- Name: photos_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: photos_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY photos | |
| @@ -9155,7 +7987,7 @@ | |
| -- | |
| --- Name: services_name_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_name_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services | |
| @@ -9163,7 +7995,7 @@ | |
| -- | |
| --- Name: services_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services | |
| @@ -9171,7 +8003,7 @@ | |
| -- | |
| --- Name: services_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_versions_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services_versions | |
| @@ -9179,7 +8011,7 @@ | |
| -- | |
| --- Name: services_versions_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_versions_serviceid_key; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services_versions | |
| @@ -9187,7 +8019,7 @@ | |
| -- | |
| --- Name: services_versions_serviceid_key1; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_versions_serviceid_key1; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services_versions | |
| @@ -9195,7 +8027,7 @@ | |
| -- | |
| --- Name: services_versions_users_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: services_versions_users_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY services_versions_member | |
| @@ -9203,7 +8035,7 @@ | |
| -- | |
| --- Name: single_login_token_pkey; Type: CONSTRAINT; Schema: myury; Owner: - | |
| +-- Name: single_login_token_pkey; Type: CONSTRAINT; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY password_reset_token | |
| @@ -9213,7 +8045,7 @@ | |
| SET search_path = people, pg_catalog; | |
| -- | |
| --- Name: group_root_role_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: group_root_role_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY group_root_role | |
| @@ -9221,7 +8053,7 @@ | |
| -- | |
| --- Name: group_root_role_role_id_id_key; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: group_root_role_role_id_id_key; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY group_root_role | |
| @@ -9229,7 +8061,7 @@ | |
| -- | |
| --- Name: group_type_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: group_type_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY group_type | |
| @@ -9237,7 +8069,7 @@ | |
| -- | |
| --- Name: metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY metadata | |
| @@ -9245,7 +8077,7 @@ | |
| -- | |
| --- Name: quote_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: quote_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY quote | |
| @@ -9253,7 +8085,7 @@ | |
| -- | |
| --- Name: role_inheritance_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: role_inheritance_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY role_inheritance | |
| @@ -9261,7 +8093,7 @@ | |
| -- | |
| --- Name: role_metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: role_metadata_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY role_text_metadata | |
| @@ -9269,7 +8101,7 @@ | |
| -- | |
| --- Name: roles_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: roles_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY role | |
| @@ -9277,7 +8109,7 @@ | |
| -- | |
| --- Name: schedule.showcredittype_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: schedule.showcredittype_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY credit_type | |
| @@ -9285,7 +8117,7 @@ | |
| -- | |
| --- Name: types_name_key; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: types_name_key; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY role_visibility | |
| @@ -9293,7 +8125,7 @@ | |
| -- | |
| --- Name: types_pkey; Type: CONSTRAINT; Schema: people; Owner: - | |
| +-- Name: types_pkey; Type: CONSTRAINT; Schema: people; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY role_visibility | |
| @@ -9303,7 +8135,7 @@ | |
| SET search_path = public, pg_catalog; | |
| -- | |
| --- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_group | |
| @@ -9311,7 +8143,7 @@ | |
| -- | |
| --- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_group | |
| @@ -9319,7 +8151,7 @@ | |
| -- | |
| --- Name: auth_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_officer | |
| @@ -9327,7 +8159,7 @@ | |
| -- | |
| --- Name: auth_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth | |
| @@ -9335,7 +8167,7 @@ | |
| -- | |
| --- Name: auth_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_subnet | |
| @@ -9343,7 +8175,7 @@ | |
| -- | |
| --- Name: auth_trainingstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_trainingstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_trainingstatus | |
| @@ -9351,7 +8183,7 @@ | |
| -- | |
| --- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_user_groups | |
| @@ -9359,7 +8191,7 @@ | |
| -- | |
| --- Name: auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_user_groups_user_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_user_groups | |
| @@ -9367,7 +8199,7 @@ | |
| -- | |
| --- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_user | |
| @@ -9375,7 +8207,7 @@ | |
| -- | |
| --- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY auth_user | |
| @@ -9383,7 +8215,7 @@ | |
| -- | |
| --- Name: baps_audio_filename_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_audio_filename_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_audio | |
| @@ -9391,7 +8223,7 @@ | |
| -- | |
| --- Name: baps_audio_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_audio_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_audio | |
| @@ -9399,7 +8231,7 @@ | |
| -- | |
| --- Name: baps_audio_trackid_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_audio_trackid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_audio | |
| @@ -9407,7 +8239,7 @@ | |
| -- | |
| --- Name: baps_audiolog_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_audiolog_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_audiolog | |
| @@ -9415,7 +8247,7 @@ | |
| -- | |
| --- Name: baps_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_filefolder | |
| @@ -9425,7 +8257,7 @@ | |
| -- | |
| --- Name: baps_filefolder_workgroup_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_filefolder_workgroup_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_filefolder | |
| @@ -9433,7 +8265,7 @@ | |
| -- | |
| --- Name: baps_fileitem_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_fileitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_fileitem | |
| @@ -9443,7 +8275,7 @@ | |
| -- | |
| --- Name: baps_item_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_item_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_item | |
| @@ -9453,7 +8285,7 @@ | |
| -- | |
| --- Name: baps_libraryitem_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_libraryitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_libraryitem | |
| @@ -9463,7 +8295,7 @@ | |
| -- | |
| --- Name: baps_listing_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_listing_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_listing | |
| @@ -9471,7 +8303,7 @@ | |
| -- | |
| --- Name: baps_server_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_server_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_server | |
| @@ -9479,7 +8311,7 @@ | |
| -- | |
| --- Name: baps_server_servername_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_server_servername_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_server | |
| @@ -9487,7 +8319,7 @@ | |
| -- | |
| --- Name: baps_show_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_show_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_show | |
| @@ -9495,7 +8327,7 @@ | |
| -- | |
| --- Name: baps_show_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_show_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_show | |
| @@ -9505,7 +8337,7 @@ | |
| -- | |
| --- Name: baps_textitem_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_textitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_textitem | |
| @@ -9515,7 +8347,7 @@ | |
| -- | |
| --- Name: baps_user_external_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_user_external_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_user_external | |
| @@ -9523,7 +8355,7 @@ | |
| -- | |
| --- Name: baps_user_external_userid_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_user_external_userid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_user_external | |
| @@ -9531,7 +8363,7 @@ | |
| -- | |
| --- Name: baps_user_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_user_filefolder_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_user_filefolder | |
| @@ -9539,7 +8371,7 @@ | |
| -- | |
| --- Name: baps_user_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_user | |
| @@ -9547,7 +8379,7 @@ | |
| -- | |
| --- Name: baps_user_username_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: baps_user_username_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY baps_user | |
| @@ -9557,7 +8389,7 @@ | |
| -- | |
| --- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: chart_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY chart | |
| @@ -9565,7 +8397,7 @@ | |
| -- | |
| --- Name: l_action_descr_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_action_descr_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_action | |
| @@ -9573,7 +8405,7 @@ | |
| -- | |
| --- Name: l_action_phpconstant_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_action_phpconstant_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_action | |
| @@ -9581,7 +8413,7 @@ | |
| -- | |
| --- Name: l_action_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_action_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_action | |
| @@ -9589,7 +8421,7 @@ | |
| -- | |
| --- Name: l_college_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_college_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_college | |
| @@ -9597,7 +8429,7 @@ | |
| -- | |
| --- Name: l_musicinterest_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_musicinterest_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_musicinterest | |
| @@ -9605,7 +8437,7 @@ | |
| -- | |
| --- Name: l_newsfeeds_feedname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_newsfeeds_feedname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_newsfeed | |
| @@ -9613,7 +8445,7 @@ | |
| -- | |
| --- Name: l_newsfeeds_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_newsfeeds_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_newsfeed | |
| @@ -9621,7 +8453,7 @@ | |
| -- | |
| --- Name: l_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_presenterstatus | |
| @@ -9629,7 +8461,7 @@ | |
| -- | |
| --- Name: l_status_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_status | |
| @@ -9637,7 +8469,7 @@ | |
| -- | |
| --- Name: l_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: l_subnet_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY l_subnet | |
| @@ -9645,7 +8477,7 @@ | |
| -- | |
| --- Name: mail_alias_list_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_list_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_list | |
| @@ -9653,7 +8485,7 @@ | |
| -- | |
| --- Name: mail_alias_list_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_list | |
| @@ -9661,7 +8493,7 @@ | |
| -- | |
| --- Name: mail_alias_member_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_member_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_member | |
| @@ -9669,7 +8501,7 @@ | |
| -- | |
| --- Name: mail_alias_member_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_member_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_member | |
| @@ -9677,7 +8509,7 @@ | |
| -- | |
| --- Name: mail_alias_officer_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_officer_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_officer | |
| @@ -9685,7 +8517,7 @@ | |
| -- | |
| --- Name: mail_alias_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_officer | |
| @@ -9693,7 +8525,7 @@ | |
| -- | |
| --- Name: mail_alias_text_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_text_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_text | |
| @@ -9701,7 +8533,7 @@ | |
| -- | |
| --- Name: mail_alias_text_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_alias_text_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_alias_text | |
| @@ -9709,7 +8541,7 @@ | |
| -- | |
| --- Name: mail_list_listaddress_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_list_listaddress_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_list | |
| @@ -9717,7 +8549,7 @@ | |
| -- | |
| --- Name: mail_list_listname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_list_listname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_list | |
| @@ -9725,7 +8557,7 @@ | |
| -- | |
| --- Name: mail_list_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: mail_list_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_list | |
| @@ -9733,7 +8565,7 @@ | |
| -- | |
| --- Name: member_eduroam_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_eduroam_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member | |
| @@ -9741,7 +8573,7 @@ | |
| -- | |
| --- Name: member_email_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_email_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member | |
| @@ -9749,7 +8581,7 @@ | |
| -- | |
| --- Name: member_local_alias_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_local_alias_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member | |
| @@ -9757,7 +8589,7 @@ | |
| -- | |
| --- Name: member_local_name_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_local_name_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member | |
| @@ -9765,7 +8597,7 @@ | |
| -- | |
| --- Name: member_mail_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_mail_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY mail_subscription | |
| @@ -9773,7 +8605,7 @@ | |
| -- | |
| --- Name: member_news_feed_memberid_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_news_feed_memberid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_news_feed | |
| @@ -9781,7 +8613,7 @@ | |
| -- | |
| --- Name: member_news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_news_feed | |
| @@ -9789,7 +8621,7 @@ | |
| -- | |
| --- Name: member_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_officer | |
| @@ -9797,7 +8629,7 @@ | |
| -- | |
| --- Name: member_pass_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_pass_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_pass | |
| @@ -9805,7 +8637,7 @@ | |
| -- | |
| --- Name: member_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member | |
| @@ -9813,7 +8645,7 @@ | |
| -- | |
| --- Name: member_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_presenterstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_presenterstatus | |
| @@ -9821,7 +8653,7 @@ | |
| -- | |
| --- Name: member_year_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: member_year_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_year | |
| @@ -9829,7 +8661,7 @@ | |
| -- | |
| --- Name: net_switchport_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: net_switchport_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY net_switchport_tags | |
| @@ -9837,7 +8669,7 @@ | |
| -- | |
| --- Name: net_switchports_mac_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: net_switchports_mac_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY net_switchport | |
| @@ -9845,7 +8677,7 @@ | |
| -- | |
| --- Name: net_switchports_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: net_switchports_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY net_switchport | |
| @@ -9853,7 +8685,7 @@ | |
| -- | |
| --- Name: net_vlan_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: net_vlan_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY net_vlan | |
| @@ -9861,7 +8693,7 @@ | |
| -- | |
| --- Name: news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: news_feed_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY news_feed | |
| @@ -9869,7 +8701,7 @@ | |
| -- | |
| --- Name: nipsweb_migrate_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: nipsweb_migrate_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY nipsweb_migrate | |
| @@ -9877,7 +8709,7 @@ | |
| -- | |
| --- Name: officer_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: officer_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY officer | |
| @@ -9885,7 +8717,7 @@ | |
| -- | |
| --- Name: rec_cleanlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_cleanlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_cleanlookup | |
| @@ -9893,7 +8725,7 @@ | |
| -- | |
| --- Name: rec_formatlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_formatlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_formatlookup | |
| @@ -9901,7 +8733,7 @@ | |
| -- | |
| --- Name: rec_genrelookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_genrelookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_genrelookup | |
| @@ -9909,7 +8741,7 @@ | |
| -- | |
| --- Name: rec_itunes_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_itunes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_itunes | |
| @@ -9917,7 +8749,7 @@ | |
| -- | |
| --- Name: rec_labelqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_labelqueue_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_labelqueue | |
| @@ -9925,7 +8757,7 @@ | |
| -- | |
| --- Name: rec_locationlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_locationlookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_locationlookup | |
| @@ -9933,7 +8765,7 @@ | |
| -- | |
| --- Name: rec_lookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_lookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_lookup | |
| @@ -9941,7 +8773,7 @@ | |
| -- | |
| --- Name: rec_medialookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_medialookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_medialookup | |
| @@ -9949,7 +8781,7 @@ | |
| -- | |
| --- Name: rec_record_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_record_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_record | |
| @@ -9957,7 +8789,7 @@ | |
| -- | |
| --- Name: rec_statuslookup_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_statuslookup_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_statuslookup | |
| @@ -9965,7 +8797,7 @@ | |
| -- | |
| --- Name: rec_track_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_track_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_track | |
| @@ -9973,7 +8805,7 @@ | |
| -- | |
| --- Name: rec_track_trackid_recordid_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_track_trackid_recordid_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_track | |
| @@ -9981,7 +8813,7 @@ | |
| -- | |
| --- Name: rec_trackcorrection_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: rec_trackcorrection_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY rec_trackcorrection | |
| @@ -9989,15 +8821,7 @@ | |
| -- | |
| --- Name: rec_trackproposal_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY rec_trackproposal | |
| - ADD CONSTRAINT rec_trackproposal_pkey PRIMARY KEY (proposalid); | |
| - | |
| - | |
| --- | |
| --- Name: recommended_listening_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: recommended_listening_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY recommended_listening | |
| @@ -10005,89 +8829,7 @@ | |
| -- | |
| --- Name: sched_entrytype_entrytypename_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_entrytype | |
| - ADD CONSTRAINT sched_entrytype_entrytypename_key UNIQUE (entrytypename); | |
| - | |
| -ALTER TABLE sched_entrytype CLUSTER ON sched_entrytype_entrytypename_key; | |
| - | |
| - | |
| --- | |
| --- Name: sched_entrytype_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_entrytype | |
| - ADD CONSTRAINT sched_entrytype_pkey PRIMARY KEY (entrytypeid); | |
| - | |
| - | |
| --- | |
| --- Name: sched_genre_musiccategoryname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_genre | |
| - ADD CONSTRAINT sched_genre_musiccategoryname_key UNIQUE (genrename); | |
| - | |
| - | |
| --- | |
| --- Name: sched_genre_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_genre | |
| - ADD CONSTRAINT sched_genre_pkey PRIMARY KEY (genreid); | |
| - | |
| - | |
| --- | |
| --- Name: sched_musiccategory_musiccategoryname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_musiccategory | |
| - ADD CONSTRAINT sched_musiccategory_musiccategoryname_key UNIQUE (musiccategoryname); | |
| - | |
| - | |
| --- | |
| --- Name: sched_musiccategory_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_musiccategory | |
| - ADD CONSTRAINT sched_musiccategory_pkey PRIMARY KEY (musiccategoryid); | |
| - | |
| - | |
| --- | |
| --- Name: sched_room_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_room | |
| - ADD CONSTRAINT sched_room_pkey PRIMARY KEY (roomid); | |
| - | |
| - | |
| --- | |
| --- Name: sched_room_roomname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_room | |
| - ADD CONSTRAINT sched_room_roomname_key UNIQUE (roomname); | |
| - | |
| - | |
| --- | |
| --- Name: sched_speechcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_speechcategory | |
| - ADD CONSTRAINT sched_speechcategory_pkey PRIMARY KEY (speechcategoryid); | |
| - | |
| - | |
| --- | |
| --- Name: sched_speechcategory_speechcategoryname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sched_speechcategory | |
| - ADD CONSTRAINT sched_speechcategory_speechcategoryname_key UNIQUE (speechcategoryname); | |
| - | |
| - | |
| --- | |
| --- Name: selector_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: selector_actions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY selector_actions | |
| @@ -10095,7 +8837,7 @@ | |
| -- | |
| --- Name: selector_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: selector_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY selector | |
| @@ -10103,7 +8845,7 @@ | |
| -- | |
| --- Name: sis_piss_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: sis_piss_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY sis_piss | |
| @@ -10111,7 +8853,7 @@ | |
| -- | |
| --- Name: sis_status_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: sis_status_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY sis_status | |
| @@ -10119,7 +8861,7 @@ | |
| -- | |
| --- Name: sis_type_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: sis_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY sis_commtype | |
| @@ -10127,7 +8869,7 @@ | |
| -- | |
| --- Name: sso_session_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: sso_session_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY sso_session | |
| @@ -10135,7 +8877,7 @@ | |
| -- | |
| --- Name: strm_client_clientname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_client_clientname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_useragent | |
| @@ -10143,7 +8885,7 @@ | |
| -- | |
| --- Name: strm_client_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_client_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_useragent | |
| @@ -10151,7 +8893,7 @@ | |
| -- | |
| --- Name: strm_log_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_log_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_log | |
| @@ -10159,7 +8901,7 @@ | |
| -- | |
| --- Name: strm_logfile_filename_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_logfile_filename_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_logfile | |
| @@ -10167,7 +8909,7 @@ | |
| -- | |
| --- Name: strm_logfile_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_logfile_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_logfile | |
| @@ -10175,7 +8917,7 @@ | |
| -- | |
| --- Name: strm_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_stream_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_stream | |
| @@ -10183,7 +8925,7 @@ | |
| -- | |
| --- Name: strm_stream_streamname_key; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: strm_stream_streamname_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY strm_stream | |
| @@ -10191,7 +8933,7 @@ | |
| -- | |
| --- Name: team_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: team_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY team | |
| @@ -10199,67 +8941,17 @@ | |
| -- | |
| --- Name: terms_pkey; Type: CONSTRAINT; Schema: public; Owner: - | |
| +-- Name: terms_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY terms | |
| ADD CONSTRAINT terms_pkey PRIMARY KEY (termid); | |
| -SET search_path = rapier, pg_catalog; | |
| - | |
| --- | |
| --- Name: acl_member_memberid_key; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_member | |
| - ADD CONSTRAINT acl_member_memberid_key UNIQUE (memberid, class, verb); | |
| - | |
| - | |
| --- | |
| --- Name: acl_member_pkey; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_member | |
| - ADD CONSTRAINT acl_member_pkey PRIMARY KEY (privilegeid); | |
| - | |
| - | |
| --- | |
| --- Name: acl_officer_officerid_key; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_officer | |
| - ADD CONSTRAINT acl_officer_officerid_key UNIQUE (officerid, class, verb); | |
| - | |
| - | |
| --- | |
| --- Name: acl_officer_pkey; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_officer | |
| - ADD CONSTRAINT acl_officer_pkey PRIMARY KEY (privilegeid); | |
| - | |
| - | |
| --- | |
| --- Name: client_pkey; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY client | |
| - ADD CONSTRAINT client_pkey PRIMARY KEY (clientid); | |
| - | |
| - | |
| --- | |
| --- Name: constants_acl_scope_pkey; Type: CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY constants_acl_scope | |
| - ADD CONSTRAINT constants_acl_scope_pkey PRIMARY KEY (scopeid); | |
| - | |
| - | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| --- Name: block_direct_rules_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: block_direct_rules_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY block_show_rule | |
| @@ -10267,7 +8959,7 @@ | |
| -- | |
| --- Name: block_range_rule_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: block_range_rule_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY block_range_rule | |
| @@ -10275,7 +8967,7 @@ | |
| -- | |
| --- Name: blocks_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: blocks_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY block | |
| @@ -10283,7 +8975,7 @@ | |
| -- | |
| --- Name: genre_name_key; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: genre_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY genre | |
| @@ -10291,7 +8983,7 @@ | |
| -- | |
| --- Name: genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY genre | |
| @@ -10299,7 +8991,7 @@ | |
| -- | |
| --- Name: location_location_name_key; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: location_location_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY location | |
| @@ -10307,7 +8999,7 @@ | |
| -- | |
| --- Name: location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY location | |
| @@ -10315,7 +9007,7 @@ | |
| -- | |
| --- Name: season_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: season_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY season_metadata | |
| @@ -10323,7 +9015,7 @@ | |
| -- | |
| --- Name: show_credit_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_credit_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_credit | |
| @@ -10331,7 +9023,7 @@ | |
| -- | |
| --- Name: show_genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_genre_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_genre | |
| @@ -10339,7 +9031,7 @@ | |
| -- | |
| --- Name: show_image_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_image_metadata | |
| @@ -10347,7 +9039,7 @@ | |
| -- | |
| --- Name: show_location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_location_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_location | |
| @@ -10355,7 +9047,7 @@ | |
| -- | |
| --- Name: show_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_metadata | |
| @@ -10363,7 +9055,7 @@ | |
| -- | |
| --- Name: show_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show | |
| @@ -10371,7 +9063,7 @@ | |
| -- | |
| --- Name: show_podcast_link_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_podcast_link_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_podcast_link | |
| @@ -10379,7 +9071,7 @@ | |
| -- | |
| --- Name: show_season_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season | |
| @@ -10387,7 +9079,7 @@ | |
| -- | |
| --- Name: show_season_requested_time_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_requested_time_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season_requested_time | |
| @@ -10395,7 +9087,7 @@ | |
| -- | |
| --- Name: show_season_requested_week_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_requested_week_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season_requested_week | |
| @@ -10403,7 +9095,7 @@ | |
| -- | |
| --- Name: show_season_requested_week_show_season_id_key; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_requested_week_show_season_id_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season_requested_week | |
| @@ -10411,7 +9103,7 @@ | |
| -- | |
| --- Name: show_season_timeslot_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_timeslot_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season_timeslot | |
| @@ -10419,7 +9111,7 @@ | |
| -- | |
| --- Name: show_season_timeslot_start_time_key; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_season_timeslot_start_time_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_season_timeslot | |
| @@ -10427,7 +9119,7 @@ | |
| -- | |
| --- Name: show_type_name_key; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_type_name_key; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_type | |
| @@ -10435,7 +9127,7 @@ | |
| -- | |
| --- Name: show_type_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: show_type_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY show_type | |
| @@ -10443,7 +9135,7 @@ | |
| -- | |
| --- Name: timeslot_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: - | |
| +-- Name: timeslot_metadata_pkey; Type: CONSTRAINT; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY timeslot_metadata | |
| @@ -10453,7 +9145,7 @@ | |
| SET search_path = sis2, pg_catalog; | |
| -- | |
| --- Name: config_pkey; Type: CONSTRAINT; Schema: sis2; Owner: - | |
| +-- Name: config_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY config | |
| @@ -10461,7 +9153,7 @@ | |
| -- | |
| --- Name: member_options_pkey; Type: CONSTRAINT; Schema: sis2; Owner: - | |
| +-- Name: member_options_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_options | |
| @@ -10469,7 +9161,7 @@ | |
| -- | |
| --- Name: member_signin_memberid_show_season_timeslot_id_key; Type: CONSTRAINT; Schema: sis2; Owner: - | |
| +-- Name: member_signin_memberid_show_season_timeslot_id_key; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_signin | |
| @@ -10477,75 +9169,17 @@ | |
| -- | |
| --- Name: member_signin_pkey; Type: CONSTRAINT; Schema: sis2; Owner: - | |
| +-- Name: member_signin_pkey; Type: CONSTRAINT; Schema: sis2; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY member_signin | |
| ADD CONSTRAINT member_signin_pkey PRIMARY KEY (member_signin_id); | |
| -SET search_path = smsd, pg_catalog; | |
| - | |
| --- | |
| --- Name: inbox_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY inbox | |
| - ADD CONSTRAINT inbox_pkey PRIMARY KEY ("ID"); | |
| - | |
| - | |
| --- | |
| --- Name: outbox_multipart_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY outbox_multipart | |
| - ADD CONSTRAINT outbox_multipart_pkey PRIMARY KEY ("ID", "SequencePosition"); | |
| - | |
| - | |
| --- | |
| --- Name: outbox_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY outbox | |
| - ADD CONSTRAINT outbox_pkey PRIMARY KEY ("ID"); | |
| - | |
| - | |
| --- | |
| --- Name: pbk_groups_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY pbk_groups | |
| - ADD CONSTRAINT pbk_groups_pkey PRIMARY KEY ("ID"); | |
| - | |
| - | |
| --- | |
| --- Name: pbk_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY pbk | |
| - ADD CONSTRAINT pbk_pkey PRIMARY KEY ("ID"); | |
| - | |
| - | |
| --- | |
| --- Name: phones_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY phones | |
| - ADD CONSTRAINT phones_pkey PRIMARY KEY ("IMEI"); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_pkey; Type: CONSTRAINT; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY sentitems | |
| - ADD CONSTRAINT sentitems_pkey PRIMARY KEY ("ID", "SequencePosition"); | |
| - | |
| - | |
| SET search_path = tracklist, pg_catalog; | |
| -- | |
| --- Name: pri_track_notrec; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: pri_track_notrec; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY track_notrec | |
| @@ -10553,7 +9187,7 @@ | |
| -- | |
| --- Name: pri_track_rec; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: pri_track_rec; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY track_rec | |
| @@ -10561,7 +9195,7 @@ | |
| -- | |
| --- Name: source_source_key; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: source_source_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY source | |
| @@ -10569,7 +9203,7 @@ | |
| -- | |
| --- Name: source_sourceid_key; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: source_sourceid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY source | |
| @@ -10577,7 +9211,7 @@ | |
| -- | |
| --- Name: state_stateid_key; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: state_stateid_key; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY state | |
| @@ -10585,7 +9219,7 @@ | |
| -- | |
| --- Name: tracklist_pkey; Type: CONSTRAINT; Schema: tracklist; Owner: - | |
| +-- Name: tracklist_pkey; Type: CONSTRAINT; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY tracklist | |
| @@ -10595,7 +9229,7 @@ | |
| SET search_path = uryplayer, pg_catalog; | |
| -- | |
| --- Name: podcast_credit_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY podcast_credit | |
| @@ -10603,7 +9237,7 @@ | |
| -- | |
| --- Name: podcast_image_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY podcast_image_metadata | |
| @@ -10611,7 +9245,7 @@ | |
| -- | |
| --- Name: podcast_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY podcast_metadata | |
| @@ -10619,7 +9253,7 @@ | |
| -- | |
| --- Name: podcast_package_entry_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY podcast_package_entry | |
| @@ -10627,7 +9261,7 @@ | |
| -- | |
| --- Name: podcast_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_pkey; Type: CONSTRAINT; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY podcast | |
| @@ -10637,7 +9271,7 @@ | |
| SET search_path = webcam, pg_catalog; | |
| -- | |
| --- Name: memberviews_pkey; Type: CONSTRAINT; Schema: webcam; Owner: - | |
| +-- Name: memberviews_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY memberviews | |
| @@ -10645,7 +9279,7 @@ | |
| -- | |
| --- Name: streams_pkey; Type: CONSTRAINT; Schema: webcam; Owner: - | |
| +-- Name: streams_pkey; Type: CONSTRAINT; Schema: webcam; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY streams | |
| @@ -10655,7 +9289,7 @@ | |
| SET search_path = website, pg_catalog; | |
| -- | |
| --- Name: banner_campaign_pkey; Type: CONSTRAINT; Schema: website; Owner: - | |
| +-- Name: banner_campaign_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY banner_campaign | |
| @@ -10663,7 +9297,7 @@ | |
| -- | |
| --- Name: banner_location_pkey; Type: CONSTRAINT; Schema: website; Owner: - | |
| +-- Name: banner_location_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY banner_location | |
| @@ -10671,7 +9305,7 @@ | |
| -- | |
| --- Name: banner_pkey; Type: CONSTRAINT; Schema: website; Owner: - | |
| +-- Name: banner_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY banner | |
| @@ -10679,7 +9313,7 @@ | |
| -- | |
| --- Name: banner_timeslot_pkey; Type: CONSTRAINT; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY banner_timeslot | |
| @@ -10687,124 +9321,80 @@ | |
| -- | |
| --- Name: banner_type_pkey; Type: CONSTRAINT; Schema: website; Owner: - | |
| +-- Name: banner_type_pkey; Type: CONSTRAINT; Schema: website; Owner: -; Tablespace: | |
| -- | |
| ALTER TABLE ONLY banner_type | |
| ADD CONSTRAINT banner_type_pkey PRIMARY KEY (banner_type_id); | |
| -SET search_path = jukebox, pg_catalog; | |
| - | |
| --- | |
| --- Name: playlist_availability_approvedid_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_approvedid_idx ON playlist_availability USING btree (approvedid); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_availability_banner_id_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_banner_id_idx ON playlist_availability USING btree (playlistid); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_availability_banner_location_id_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_banner_location_id_idx ON playlist_availability USING btree (weight); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_availability_effective_from_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_effective_from_idx ON playlist_availability USING btree (effective_from); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_availability_effective_to_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_effective_to_idx ON playlist_availability USING btree (effective_to); | |
| - | |
| - | |
| --- | |
| --- Name: playlist_availability_memberid_idx; Type: INDEX; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX playlist_availability_memberid_idx ON playlist_availability USING btree (memberid); | |
| - | |
| - | |
| SET search_path = metadata, pg_catalog; | |
| -- | |
| --- Name: package_image_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_image_metadata_approvedid ON package_image_metadata USING btree (approvedid); | |
| -- | |
| --- Name: package_image_metadata_element_id; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_image_metadata_element_id ON package_image_metadata USING btree (element_id); | |
| -- | |
| --- Name: package_image_metadata_memberid; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_image_metadata_memberid ON package_image_metadata USING btree (memberid); | |
| -- | |
| --- Name: package_image_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_image_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_image_metadata_metadata_key_id ON package_image_metadata USING btree (metadata_key_id); | |
| -- | |
| --- Name: package_name; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_name; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_name ON package USING btree (name); | |
| -- | |
| --- Name: package_name_like; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_name_like; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_name_like ON package USING btree (name varchar_pattern_ops); | |
| -- | |
| --- Name: package_text_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata_approvedid; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_text_metadata_approvedid ON package_text_metadata USING btree (approvedid); | |
| -- | |
| --- Name: package_text_metadata_element_id; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata_element_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_text_metadata_element_id ON package_text_metadata USING btree (element_id); | |
| -- | |
| --- Name: package_text_metadata_memberid; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata_memberid; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_text_metadata_memberid ON package_text_metadata USING btree (memberid); | |
| -- | |
| --- Name: package_text_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: - | |
| +-- Name: package_text_metadata_metadata_key_id; Type: INDEX; Schema: metadata; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX package_text_metadata_metadata_key_id ON package_text_metadata USING btree (metadata_key_id); | |
| @@ -10813,28 +9403,28 @@ | |
| SET search_path = music, pg_catalog; | |
| -- | |
| --- Name: chart_release_chart_type_id; Type: INDEX; Schema: music; Owner: - | |
| +-- Name: chart_release_chart_type_id; Type: INDEX; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX chart_release_chart_type_id ON chart_release USING btree (chart_type_id); | |
| -- | |
| --- Name: chart_row_chart_release_id; Type: INDEX; Schema: music; Owner: - | |
| +-- Name: chart_row_chart_release_id; Type: INDEX; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX chart_row_chart_release_id ON chart_row USING btree (chart_release_id); | |
| -- | |
| --- Name: chart_type_name; Type: INDEX; Schema: music; Owner: - | |
| +-- Name: chart_type_name; Type: INDEX; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX chart_type_name ON chart_type USING btree (name); | |
| -- | |
| --- Name: chart_type_name_like; Type: INDEX; Schema: music; Owner: - | |
| +-- Name: chart_type_name_like; Type: INDEX; Schema: music; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX chart_type_name_like ON chart_type USING btree (name varchar_pattern_ops); | |
| @@ -10843,14 +9433,14 @@ | |
| SET search_path = myury, pg_catalog; | |
| -- | |
| --- Name: api_key_log_timestamp_index; Type: INDEX; Schema: myury; Owner: - | |
| +-- Name: api_key_log_timestamp_index; Type: INDEX; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX api_key_log_timestamp_index ON api_key_log USING btree ("timestamp"); | |
| -- | |
| --- Name: error_rate_i_timestamp; Type: INDEX; Schema: myury; Owner: - | |
| +-- Name: error_rate_i_timestamp; Type: INDEX; Schema: myury; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX error_rate_i_timestamp ON error_rate USING btree ("timestamp"); | |
| @@ -10859,21 +9449,21 @@ | |
| SET search_path = people, pg_catalog; | |
| -- | |
| --- Name: group_root_role_group_type_id; Type: INDEX; Schema: people; Owner: - | |
| +-- Name: group_root_role_group_type_id; Type: INDEX; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX group_root_role_group_type_id ON group_root_role USING btree (group_type_id); | |
| -- | |
| --- Name: role_metadata_effective_from_index; Type: INDEX; Schema: people; Owner: - | |
| +-- Name: role_metadata_effective_from_index; Type: INDEX; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX role_metadata_effective_from_index ON role_text_metadata USING btree (effective_from); | |
| -- | |
| --- Name: role_metadata_effective_to_index; Type: INDEX; Schema: people; Owner: - | |
| +-- Name: role_metadata_effective_to_index; Type: INDEX; Schema: people; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX role_metadata_effective_to_index ON role_text_metadata USING btree (effective_to); | |
| @@ -10882,245 +9472,238 @@ | |
| SET search_path = public, pg_catalog; | |
| -- | |
| --- Name: audiolog_timeplayed_index; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: audiolog_timeplayed_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX audiolog_timeplayed_index ON baps_audiolog USING btree (timeplayed); | |
| -- | |
| --- Name: audiolog_timestopped_index; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: audiolog_timestopped_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX audiolog_timestopped_index ON baps_audiolog USING btree (timestopped); | |
| -- | |
| --- Name: baps_item_fileitemid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_fileitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_fileitemid_key ON baps_item USING btree (fileitemid); | |
| -- | |
| --- Name: baps_item_libraryitemid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_libraryitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_libraryitemid_key ON baps_item USING btree (libraryitemid); | |
| -- | |
| --- Name: baps_item_listingid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_listingid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_listingid_key ON baps_item USING btree (listingid); | |
| -- | |
| --- Name: baps_item_position_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_position_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_position_key ON baps_item USING btree ("position"); | |
| -- | |
| --- Name: baps_item_textitemid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_textitemid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_textitemid_key ON baps_item USING btree (textitemid); | |
| -- | |
| --- Name: baps_item_viewable_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_item_viewable_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_item_viewable_key ON baps_show USING btree (viewable); | |
| -- | |
| --- Name: baps_libraryitem_trackid_index; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_libraryitem_trackid_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_libraryitem_trackid_index ON baps_libraryitem USING btree (trackid); | |
| -- | |
| --- Name: baps_listing_channel_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_listing_channel_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_listing_channel_key ON baps_listing USING btree (channel); | |
| -- | |
| --- Name: baps_listing_showid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_listing_showid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_listing_showid_key ON baps_listing USING btree (showid); | |
| -- | |
| --- Name: baps_show_broadcastdate_index; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_show_broadcastdate_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_show_broadcastdate_index ON baps_show USING btree (broadcastdate); | |
| -- | |
| --- Name: baps_show_userid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_show_userid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_show_userid_key ON baps_show USING btree (userid); | |
| -- | |
| --- Name: baps_user_usernamechart_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: baps_user_usernamechart_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX baps_user_usernamechart_key ON baps_user USING btree (username) WHERE ((username)::text = 'chart'::text); | |
| -- | |
| --- Name: chartweektimestamp; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: chartweektimestamp; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX chartweektimestamp ON chart USING btree (chartweek); | |
| -- | |
| --- Name: i_endtime; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: i_endtime; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX i_endtime ON strm_log USING btree (endtime); | |
| -- | |
| --- Name: idx_member_eduroam; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: idx_member_eduroam; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX idx_member_eduroam ON member USING btree (eduroam); | |
| -- | |
| --- Name: idx_member_email; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: idx_member_email; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX idx_member_email ON member USING btree (email); | |
| -- | |
| --- Name: idx_member_localalias; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: idx_member_localalias; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX idx_member_localalias ON member USING btree (local_alias); | |
| -- | |
| --- Name: idx_member_localname; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: idx_member_localname; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX idx_member_localname ON member USING btree (local_name); | |
| -- | |
| --- Name: l_college_collegeid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: l_college_collegeid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX l_college_collegeid_key ON l_college USING btree (collegeid); | |
| -- | |
| --- Name: l_musicinterest_typeid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: l_musicinterest_typeid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX l_musicinterest_typeid_key ON l_musicinterest USING btree (typeid); | |
| -- | |
| --- Name: member_memberid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: member_memberid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX member_memberid_key ON member USING btree (memberid); | |
| -- | |
| --- Name: member_office_member_office_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: member_office_member_office_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX member_office_member_office_key ON member_officer USING btree (member_officerid); | |
| -- | |
| --- Name: officer_officerid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: officer_officerid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX officer_officerid_key ON officer USING btree (officerid); | |
| -- | |
| --- Name: rec_record_dateadded_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_record_dateadded_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX rec_record_dateadded_key ON rec_record USING btree (dateadded); | |
| -- | |
| --- Name: rec_record_format_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_record_format_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX rec_record_format_key ON rec_record USING btree (format) WHERE (format = 's'::bpchar); | |
| -- | |
| --- Name: rec_record_recordid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_record_recordid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX rec_record_recordid_key ON rec_record USING btree (recordid); | |
| -- | |
| --- Name: rec_track_artist_index; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_track_artist_index; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX rec_track_artist_index ON rec_track USING btree (artist); | |
| -- | |
| --- Name: rec_track_recordid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_track_recordid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX rec_track_recordid_key ON rec_track USING btree (recordid); | |
| -- | |
| --- Name: rec_track_trackid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_track_trackid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX rec_track_trackid_key ON rec_track USING btree (trackid); | |
| -- | |
| --- Name: rec_unique_recordid; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: rec_unique_recordid; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX rec_unique_recordid ON rec_labelqueue USING btree (recordid); | |
| -- | |
| --- Name: recommended_listening_chartweek_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: recommended_listening_chartweek_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX recommended_listening_chartweek_key ON recommended_listening USING btree (week); | |
| -- | |
| --- Name: sched_entrytype_entrytypenamenews_key; Type: INDEX; Schema: public; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX sched_entrytype_entrytypenamenews_key ON sched_entrytype USING btree (entrytypename) WHERE ((entrytypename)::text = 'News'::text); | |
| - | |
| - | |
| --- | |
| --- Name: strm_log_starttime_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: strm_log_starttime_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX strm_log_starttime_key ON strm_log USING btree (starttime); | |
| @@ -11129,14 +9712,14 @@ | |
| -- | |
| --- Name: strm_log_steamid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: strm_log_steamid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX strm_log_steamid_key ON strm_log USING btree (streamid); | |
| -- | |
| --- Name: team_teamid_key; Type: INDEX; Schema: public; Owner: - | |
| +-- Name: team_teamid_key; Type: INDEX; Schema: public; Owner: -; Tablespace: | |
| -- | |
| CREATE UNIQUE INDEX team_teamid_key ON team USING btree (teamid); | |
| @@ -11145,207 +9728,163 @@ | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| --- Name: block_range_rule_end_time_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: block_range_rule_end_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX block_range_rule_end_time_index ON block_range_rule USING btree (end_time); | |
| -- | |
| --- Name: block_range_rule_start_time_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: block_range_rule_start_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX block_range_rule_start_time_index ON block_range_rule USING btree (start_time); | |
| -- | |
| --- Name: duration; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: duration; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX duration ON show_season_timeslot USING btree (duration); | |
| -- | |
| --- Name: season_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: season_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX season_metadata_effective_from_index ON season_metadata USING btree (effective_from); | |
| -- | |
| --- Name: season_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: season_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX season_metadata_effective_to_index ON season_metadata USING btree (effective_to); | |
| -- | |
| --- Name: show_credit_effective_from_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_credit_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_credit_effective_from_index ON show_credit USING btree (effective_from); | |
| -- | |
| --- Name: show_credit_effective_to_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_credit_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_credit_effective_to_index ON show_credit USING btree (effective_to); | |
| -- | |
| --- Name: show_id_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_id_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_id_index ON show_credit USING btree (show_id); | |
| -- | |
| --- Name: show_image_metadata_approvedid; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata_approvedid; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_image_metadata_approvedid ON show_image_metadata USING btree (approvedid); | |
| -- | |
| --- Name: show_image_metadata_memberid; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata_memberid; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_image_metadata_memberid ON show_image_metadata USING btree (memberid); | |
| -- | |
| --- Name: show_image_metadata_metadata_key_id; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata_metadata_key_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_image_metadata_metadata_key_id ON show_image_metadata USING btree (metadata_key_id); | |
| -- | |
| --- Name: show_image_metadata_show_id; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_image_metadata_show_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_image_metadata_show_id ON show_image_metadata USING btree (show_id); | |
| -- | |
| --- Name: show_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_metadata_effective_from_index ON show_metadata USING btree (effective_from); | |
| -- | |
| --- Name: show_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_metadata_effective_to_index ON show_metadata USING btree (effective_to); | |
| -- | |
| --- Name: show_podcast_link_podcast_id; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_podcast_link_podcast_id; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_podcast_link_podcast_id ON show_podcast_link USING btree (podcast_id); | |
| -- | |
| --- Name: show_season_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: show_season_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX show_season_index ON show_season_timeslot USING btree (show_season_id); | |
| -- | |
| --- Name: start_time_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: start_time_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX start_time_index ON show_season_timeslot USING btree (start_time); | |
| -- | |
| --- Name: timeslot_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: timeslot_metadata_effective_from_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX timeslot_metadata_effective_from_index ON timeslot_metadata USING btree (effective_from); | |
| -- | |
| --- Name: timeslot_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: - | |
| +-- Name: timeslot_metadata_effective_to_index; Type: INDEX; Schema: schedule; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX timeslot_metadata_effective_to_index ON timeslot_metadata USING btree (effective_to); | |
| -SET search_path = smsd, pg_catalog; | |
| - | |
| --- | |
| --- Name: outbox_date; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX outbox_date ON outbox USING btree ("SendingDateTime", "SendingTimeOut"); | |
| - | |
| - | |
| --- | |
| --- Name: outbox_sender; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX outbox_sender ON outbox USING btree ("SenderID"); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_date; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX sentitems_date ON sentitems USING btree ("DeliveryDateTime"); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_dest; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX sentitems_dest ON sentitems USING btree ("DestinationNumber"); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_sender; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX sentitems_sender ON sentitems USING btree ("SenderID"); | |
| - | |
| - | |
| --- | |
| --- Name: sentitems_tpmr; Type: INDEX; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE INDEX sentitems_tpmr ON sentitems USING btree ("TPMR"); | |
| - | |
| - | |
| SET search_path = tracklist, pg_catalog; | |
| -- | |
| --- Name: index_tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: - | |
| +-- Name: index_tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX index_tracklist_tracklist_timeslotid ON tracklist USING btree (timeslotid); | |
| -- | |
| --- Name: index_tracklist_tracklist_timestart; Type: INDEX; Schema: tracklist; Owner: - | |
| +-- Name: index_tracklist_tracklist_timestart; Type: INDEX; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX index_tracklist_tracklist_timestart ON tracklist USING btree (timestart); | |
| -- | |
| --- Name: index_tracklist_tracklist_timestop; Type: INDEX; Schema: tracklist; Owner: - | |
| +-- Name: index_tracklist_tracklist_timestop; Type: INDEX; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX index_tracklist_tracklist_timestop ON tracklist USING btree (timestop); | |
| -- | |
| --- Name: tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: - | |
| +-- Name: tracklist_tracklist_timeslotid; Type: INDEX; Schema: tracklist; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX tracklist_tracklist_timeslotid ON tracklist USING btree (timeslotid); | |
| @@ -11354,133 +9893,133 @@ | |
| SET search_path = uryplayer, pg_catalog; | |
| -- | |
| --- Name: podcast_approvedid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_approvedid ON podcast USING btree (approvedid); | |
| -- | |
| --- Name: podcast_credit_approvedid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_credit_approvedid ON podcast_credit USING btree (approvedid); | |
| -- | |
| --- Name: podcast_credit_credit_type_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_credit_type_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_credit_credit_type_id ON podcast_credit USING btree (credit_type_id); | |
| -- | |
| --- Name: podcast_credit_creditid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_creditid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_credit_creditid ON podcast_credit USING btree (creditid); | |
| -- | |
| --- Name: podcast_credit_memberid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_credit_memberid ON podcast_credit USING btree (memberid); | |
| -- | |
| --- Name: podcast_credit_podcast_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_credit_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_credit_podcast_id ON podcast_credit USING btree (podcast_id); | |
| -- | |
| --- Name: podcast_image_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_image_metadata_approvedid ON podcast_image_metadata USING btree (approvedid); | |
| -- | |
| --- Name: podcast_image_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_image_metadata_memberid ON podcast_image_metadata USING btree (memberid); | |
| -- | |
| --- Name: podcast_image_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_image_metadata_metadata_key_id ON podcast_image_metadata USING btree (metadata_key_id); | |
| -- | |
| --- Name: podcast_image_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_image_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_image_metadata_podcast_id ON podcast_image_metadata USING btree (podcast_id); | |
| -- | |
| --- Name: podcast_memberid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_memberid ON podcast USING btree (memberid); | |
| -- | |
| --- Name: podcast_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_metadata_approvedid ON podcast_metadata USING btree (approvedid); | |
| -- | |
| --- Name: podcast_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_metadata_memberid ON podcast_metadata USING btree (memberid); | |
| -- | |
| --- Name: podcast_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata_metadata_key_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_metadata_metadata_key_id ON podcast_metadata USING btree (metadata_key_id); | |
| -- | |
| --- Name: podcast_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_metadata_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_metadata_podcast_id ON podcast_metadata USING btree (podcast_id); | |
| -- | |
| --- Name: podcast_package_entry_approvedid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry_approvedid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_package_entry_approvedid ON podcast_package_entry USING btree (approvedid); | |
| -- | |
| --- Name: podcast_package_entry_memberid; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry_memberid; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_package_entry_memberid ON podcast_package_entry USING btree (memberid); | |
| -- | |
| --- Name: podcast_package_entry_package_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry_package_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_package_entry_package_id ON podcast_package_entry USING btree (package_id); | |
| -- | |
| --- Name: podcast_package_entry_podcast_id; Type: INDEX; Schema: uryplayer; Owner: - | |
| +-- Name: podcast_package_entry_podcast_id; Type: INDEX; Schema: uryplayer; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX podcast_package_entry_podcast_id ON podcast_package_entry USING btree (podcast_id); | |
| @@ -11489,105 +10028,105 @@ | |
| SET search_path = website, pg_catalog; | |
| -- | |
| --- Name: banner_campaign_approvedid; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_approvedid; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_approvedid ON banner_campaign USING btree (approvedid); | |
| -- | |
| --- Name: banner_campaign_banner_id; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_banner_id; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_banner_id ON banner_campaign USING btree (banner_id); | |
| -- | |
| --- Name: banner_campaign_banner_location_id; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_banner_location_id; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_banner_location_id ON banner_campaign USING btree (banner_location_id); | |
| -- | |
| --- Name: banner_campaign_effective_from_index; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_effective_from_index; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_effective_from_index ON banner_campaign USING btree (effective_from); | |
| -- | |
| --- Name: banner_campaign_effective_to_index; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_effective_to_index; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_effective_to_index ON banner_campaign USING btree (effective_to); | |
| -- | |
| --- Name: banner_campaign_memberid; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_campaign_memberid; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_campaign_memberid ON banner_campaign USING btree (memberid); | |
| -- | |
| --- Name: banner_location_name; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_location_name; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_location_name ON banner_location USING btree (name); | |
| -- | |
| --- Name: banner_location_name_like; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_location_name_like; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_location_name_like ON banner_location USING btree (name varchar_pattern_ops); | |
| -- | |
| --- Name: banner_timeslot_approvedid; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_approvedid; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_timeslot_approvedid ON banner_timeslot USING btree (approvedid); | |
| -- | |
| --- Name: banner_timeslot_banner_campaign_id; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_banner_campaign_id; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_timeslot_banner_campaign_id ON banner_timeslot USING btree (banner_campaign_id); | |
| -- | |
| --- Name: banner_timeslot_from_time_index; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_from_time_index; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_timeslot_from_time_index ON banner_timeslot USING btree (start_time); | |
| -- | |
| --- Name: banner_timeslot_memberid; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_memberid; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_timeslot_memberid ON banner_timeslot USING btree (memberid); | |
| -- | |
| --- Name: banner_timeslot_to_time_index; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_timeslot_to_time_index; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_timeslot_to_time_index ON banner_timeslot USING btree (end_time); | |
| -- | |
| --- Name: banner_type_name; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_type_name; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_type_name ON banner_type USING btree (name); | |
| -- | |
| --- Name: banner_type_name_like; Type: INDEX; Schema: website; Owner: - | |
| +-- Name: banner_type_name_like; Type: INDEX; Schema: website; Owner: -; Tablespace: | |
| -- | |
| CREATE INDEX banner_type_name_like ON banner_type USING btree (name varchar_pattern_ops); | |
| @@ -11618,43 +10157,6 @@ | |
| CREATE TRIGGER set_shelfcode_trigger BEFORE INSERT ON rec_record FOR EACH ROW EXECUTE PROCEDURE set_shelfcode_func(); | |
| -SET search_path = smsd, pg_catalog; | |
| - | |
| --- | |
| --- Name: gammutafter; Type: TRIGGER; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TRIGGER gammutafter AFTER INSERT ON inbox FOR EACH ROW EXECUTE PROCEDURE public.process_gammu_text(); | |
| - | |
| - | |
| --- | |
| --- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TRIGGER update_timestamp BEFORE UPDATE ON inbox FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp(); | |
| - | |
| - | |
| --- | |
| --- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TRIGGER update_timestamp BEFORE UPDATE ON outbox FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp(); | |
| - | |
| - | |
| --- | |
| --- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TRIGGER update_timestamp BEFORE UPDATE ON phones FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp(); | |
| - | |
| - | |
| --- | |
| --- Name: update_timestamp; Type: TRIGGER; Schema: smsd; Owner: - | |
| --- | |
| - | |
| -CREATE TRIGGER update_timestamp BEFORE UPDATE ON sentitems FOR EACH ROW EXECUTE PROCEDURE public.update_timestamp(); | |
| - | |
| - | |
| SET search_path = bapsplanner, pg_catalog; | |
| -- | |
| @@ -11713,16 +10215,6 @@ | |
| 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; | |
| -SET search_path = deploy, pg_catalog; | |
| - | |
| --- | |
| --- Name: myury_memberid_fkey; Type: FK CONSTRAINT; Schema: deploy; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY myury | |
| - ADD CONSTRAINT myury_memberid_fkey FOREIGN KEY (memberid) REFERENCES public.member(memberid) ON DELETE CASCADE; | |
| - | |
| - | |
| SET search_path = jukebox, pg_catalog; | |
| -- | |
| @@ -11734,14 +10226,6 @@ | |
| -- | |
| --- Name: playlist_availability_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY playlist_availability | |
| - ADD CONSTRAINT playlist_availability_playlistid_fkey FOREIGN KEY (playlistid) REFERENCES playlists(playlistid) ON UPDATE CASCADE; | |
| - | |
| - | |
| --- | |
| -- Name: playlist_entries_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: - | |
| -- | |
| @@ -11806,18 +10290,10 @@ | |
| -- | |
| --- Name: playlist_timeslot_playlist_availability_id_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY playlist_timeslot | |
| - ADD CONSTRAINT playlist_timeslot_playlist_availability_id_fkey FOREIGN KEY (playlist_availability_id) REFERENCES playlist_availability(playlist_availability_id); | |
| - | |
| - | |
| --- | |
| -- Name: playlist_timeslot_playlistid_fkey; Type: FK CONSTRAINT; Schema: jukebox; Owner: - | |
| -- | |
| -ALTER TABLE ONLY playlist_availability | |
| +ALTER TABLE ONLY playlist_timeslot | |
| ADD CONSTRAINT playlist_timeslot_playlistid_fkey FOREIGN KEY (playlistid) REFERENCES playlists(playlistid); | |
| @@ -11853,42 +10329,6 @@ | |
| ADD CONSTRAINT track_blacklist_trackid_fkey FOREIGN KEY (trackid) REFERENCES public.rec_track(trackid); | |
| -SET search_path = loggerng, pg_catalog; | |
| - | |
| --- | |
| --- Name: requests_start_fkey; Type: FK CONSTRAINT; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_start_fkey FOREIGN KEY (start, "end", format) REFERENCES logs(start, "end", format) ON UPDATE CASCADE ON DELETE CASCADE; | |
| - | |
| - | |
| --- | |
| --- Name: requests_user_fkey; Type: FK CONSTRAINT; Schema: loggerng; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_user_fkey FOREIGN KEY ("user") REFERENCES public.member(memberid); | |
| - | |
| - | |
| -SET search_path = loggerng_test, pg_catalog; | |
| - | |
| --- | |
| --- Name: requests_start_fkey; Type: FK CONSTRAINT; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_start_fkey FOREIGN KEY (start, "end", format) REFERENCES logs(start, "end", format) ON UPDATE CASCADE ON DELETE CASCADE; | |
| - | |
| - | |
| --- | |
| --- Name: requests_user_fkey; Type: FK CONSTRAINT; Schema: loggerng_test; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY requests | |
| - ADD CONSTRAINT requests_user_fkey FOREIGN KEY ("user") REFERENCES public.member(memberid); | |
| - | |
| - | |
| SET search_path = mail, pg_catalog; | |
| -- | |
| @@ -12550,6 +10990,14 @@ | |
| -- | |
| +-- Name: $4; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| +-- | |
| + | |
| +ALTER TABLE ONLY rec_track | |
| + ADD CONSTRAINT "$4" FOREIGN KEY (last_edited_memberid) REFERENCES member(memberid) ON UPDATE CASCADE ON DELETE SET NULL; | |
| + | |
| + | |
| +-- | |
| -- Name: $6; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| @@ -12626,7 +11074,7 @@ | |
| -- | |
| ALTER TABLE ONLY baps_item | |
| - ADD CONSTRAINT baps_item_fileitemid_fkey FOREIGN KEY (fileitemid) REFERENCES baps_fileitem(fileitemid) ON UPDATE CASCADE ON DELETE CASCADE; | |
| + ADD CONSTRAINT baps_item_fileitemid_fkey FOREIGN KEY (fileitemid) REFERENCES baps_fileitem(fileitemid); | |
| -- | |
| @@ -12634,7 +11082,7 @@ | |
| -- | |
| ALTER TABLE ONLY baps_item | |
| - ADD CONSTRAINT baps_item_libraryitemid_fkey FOREIGN KEY (libraryitemid) REFERENCES baps_libraryitem(libraryitemid) ON UPDATE CASCADE ON DELETE CASCADE; | |
| + ADD CONSTRAINT baps_item_libraryitemid_fkey FOREIGN KEY (libraryitemid) REFERENCES baps_libraryitem(libraryitemid); | |
| -- | |
| @@ -12846,14 +11294,6 @@ | |
| -- | |
| --- Name: rec_track_lasteditedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY rec_track | |
| - ADD CONSTRAINT rec_track_lasteditedby_fkey FOREIGN KEY (last_edited_memberid) REFERENCES member(memberid) ON UPDATE CASCADE ON DELETE SET NULL; | |
| - | |
| - | |
| --- | |
| -- Name: rec_trackcorrection_reviewedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| @@ -12870,22 +11310,6 @@ | |
| -- | |
| --- Name: rec_trackproposal_proposedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY rec_trackproposal | |
| - ADD CONSTRAINT rec_trackproposal_proposedby_fkey FOREIGN KEY (proposedby) REFERENCES member(memberid); | |
| - | |
| - | |
| --- | |
| --- Name: rec_trackproposal_reviewedby_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY rec_trackproposal | |
| - ADD CONSTRAINT rec_trackproposal_reviewedby_fkey FOREIGN KEY (reviewedby) REFERENCES member(memberid); | |
| - | |
| - | |
| --- | |
| -- Name: selector_action_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - | |
| -- | |
| @@ -12909,40 +11333,6 @@ | |
| ADD CONSTRAINT user_id_refs_id_831107f1 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED; | |
| -SET search_path = rapier, pg_catalog; | |
| - | |
| --- | |
| --- Name: acl_member_memberid_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_member | |
| - ADD CONSTRAINT acl_member_memberid_fkey FOREIGN KEY (memberid) REFERENCES public.member(memberid) ON UPDATE CASCADE ON DELETE CASCADE; | |
| - | |
| - | |
| --- | |
| --- Name: acl_member_scope_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_member | |
| - ADD CONSTRAINT acl_member_scope_fkey FOREIGN KEY (scope) REFERENCES constants_acl_scope(scopeid) ON UPDATE SET DEFAULT ON DELETE SET DEFAULT; | |
| - | |
| - | |
| --- | |
| --- Name: acl_officer_officerid_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_officer | |
| - ADD CONSTRAINT acl_officer_officerid_fkey FOREIGN KEY (officerid) REFERENCES public.officer(officerid) ON UPDATE CASCADE ON DELETE CASCADE; | |
| - | |
| - | |
| --- | |
| --- Name: acl_officer_scope_fkey; Type: FK CONSTRAINT; Schema: rapier; Owner: - | |
| --- | |
| - | |
| -ALTER TABLE ONLY acl_officer | |
| - ADD CONSTRAINT acl_officer_scope_fkey FOREIGN KEY (scope) REFERENCES constants_acl_scope(scopeid) ON UPDATE SET DEFAULT ON DELETE SET DEFAULT; | |
| - | |
| - | |
| SET search_path = schedule, pg_catalog; | |
| -- | |
| @@ -13440,6 +11830,14 @@ | |
| -- | |
| +-- Name: podcast_credit_credit_type_id_fkey; Type: FK CONSTRAINT; Schema: uryplayer; Owner: - | |
| +-- | |
| + | |
| +ALTER TABLE ONLY podcast_credit | |
| + ADD CONSTRAINT podcast_credit_credit_type_id_fkey FOREIGN KEY (credit_type_id) REFERENCES people.credit_type(credit_type_id) DEFERRABLE INITIALLY DEFERRED; | |
| + | |
| + | |
| +-- | |
| -- Name: podcast_credit_creditid_fkey; Type: FK CONSTRAINT; Schema: uryplayer; Owner: - | |
| -- | |
| @@ -13646,4 +12044,3 @@ | |
| -- | |
| -- PostgreSQL database dump complete | |
| -- | |
| - |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment