X-Git-Url: https://git.decadent.org.uk/gitweb/?p=dak.git;a=blobdiff_plain;f=setup%2Fschema_68.sql;fp=setup%2Fschema_68.sql;h=afe94e9b474bc85334c12c50f33017c55ed4e373;hp=4a00ffc4f44cf8e94b37312063a79a9f14e6a996;hb=4dab90faf5d04a94cc6f0a35f7d5e8e6a11921c2;hpb=c9380046315c3a661b90de240459f40424b0993b diff --git a/setup/schema_68.sql b/setup/schema_68.sql index 4a00ffc4..afe94e9b 100644 --- a/setup/schema_68.sql +++ b/setup/schema_68.sql @@ -18,93 +18,8 @@ CREATE SCHEMA audit; ALTER SCHEMA audit OWNER TO dak; --- --- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: dak --- - -CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql; - - -ALTER PROCEDURAL LANGUAGE plpgsql OWNER TO dak; - SET search_path = public, pg_catalog; --- --- Name: debversion; Type: SHELL TYPE; Schema: public; Owner: postgres --- - -CREATE TYPE debversion; - - --- --- Name: debversionin(cstring); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversionin(cstring) RETURNS debversion - LANGUAGE internal IMMUTABLE STRICT - AS $$textin$$; - - -ALTER FUNCTION public.debversionin(cstring) OWNER TO postgres; - --- --- Name: debversionout(debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversionout(debversion) RETURNS cstring - LANGUAGE internal IMMUTABLE STRICT - AS $$textout$$; - - -ALTER FUNCTION public.debversionout(debversion) OWNER TO postgres; - --- --- Name: debversionrecv(internal); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversionrecv(internal) RETURNS debversion - LANGUAGE internal STABLE STRICT - AS $$textrecv$$; - - -ALTER FUNCTION public.debversionrecv(internal) OWNER TO postgres; - --- --- Name: debversionsend(debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversionsend(debversion) RETURNS bytea - LANGUAGE internal STABLE STRICT - AS $$textsend$$; - - -ALTER FUNCTION public.debversionsend(debversion) OWNER TO postgres; - --- --- Name: debversion; Type: TYPE; Schema: public; Owner: postgres --- - -CREATE TYPE debversion ( - INTERNALLENGTH = variable, - INPUT = debversionin, - OUTPUT = debversionout, - RECEIVE = debversionrecv, - SEND = debversionsend, - CATEGORY = 'S', - ALIGNMENT = int4, - STORAGE = extended -); - - -ALTER TYPE public.debversion OWNER TO postgres; - --- --- Name: TYPE debversion; Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON TYPE debversion IS 'Debian package version number'; - - -- -- Name: bin_associations_id_max(); Type: FUNCTION; Schema: public; Owner: dak -- @@ -127,176 +42,6 @@ CREATE FUNCTION binaries_id_max() RETURNS integer ALTER FUNCTION public.binaries_id_max() OWNER TO dak; --- --- Name: debversion(character); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion(character) RETURNS debversion - LANGUAGE internal IMMUTABLE STRICT - AS $$rtrim1$$; - - -ALTER FUNCTION public.debversion(character) OWNER TO postgres; - --- --- Name: debversion_cmp(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_cmp(version1 debversion, version2 debversion) RETURNS integer - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_cmp'; - - -ALTER FUNCTION public.debversion_cmp(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_cmp(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_cmp(version1 debversion, version2 debversion) IS 'Compare Debian versions'; - - --- --- Name: debversion_eq(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_eq(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_eq'; - - -ALTER FUNCTION public.debversion_eq(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_eq(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_eq(version1 debversion, version2 debversion) IS 'debversion equal'; - - --- --- Name: debversion_ge(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_ge(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_ge'; - - -ALTER FUNCTION public.debversion_ge(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_ge(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_ge(version1 debversion, version2 debversion) IS 'debversion greater-than-or-equal'; - - --- --- Name: debversion_gt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_gt(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_gt'; - - -ALTER FUNCTION public.debversion_gt(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_gt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_gt(version1 debversion, version2 debversion) IS 'debversion greater-than'; - - --- --- Name: debversion_hash(debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_hash(debversion) RETURNS integer - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_hash'; - - -ALTER FUNCTION public.debversion_hash(debversion) OWNER TO postgres; - --- --- Name: debversion_larger(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_larger(version1 debversion, version2 debversion) RETURNS debversion - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_larger'; - - -ALTER FUNCTION public.debversion_larger(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: debversion_le(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_le(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_le'; - - -ALTER FUNCTION public.debversion_le(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_le(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_le(version1 debversion, version2 debversion) IS 'debversion less-than-or-equal'; - - --- --- Name: debversion_lt(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_lt(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_lt'; - - -ALTER FUNCTION public.debversion_lt(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_lt(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_lt(version1 debversion, version2 debversion) IS 'debversion less-than'; - - --- --- Name: debversion_ne(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_ne(version1 debversion, version2 debversion) RETURNS boolean - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_ne'; - - -ALTER FUNCTION public.debversion_ne(version1 debversion, version2 debversion) OWNER TO postgres; - --- --- Name: FUNCTION debversion_ne(version1 debversion, version2 debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON FUNCTION debversion_ne(version1 debversion, version2 debversion) IS 'debversion not equal'; - - --- --- Name: debversion_smaller(debversion, debversion); Type: FUNCTION; Schema: public; Owner: postgres --- - -CREATE FUNCTION debversion_smaller(version1 debversion, version2 debversion) RETURNS debversion - LANGUAGE c IMMUTABLE STRICT - AS '$libdir/debversion', 'debversion_smaller'; - - -ALTER FUNCTION public.debversion_smaller(version1 debversion, version2 debversion) OWNER TO postgres; - -- -- Name: dsc_files_id_max(); Type: FUNCTION; Schema: public; Owner: dak -- @@ -548,249 +293,6 @@ $$; ALTER FUNCTION public.trigger_override_update() OWNER TO dak; --- --- Name: >; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR > ( - PROCEDURE = debversion_gt, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = <, - NEGATOR = >= -); - - -ALTER OPERATOR public.> (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR > (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR > (debversion, debversion) IS 'debversion greater-than'; - - --- --- Name: max(debversion); Type: AGGREGATE; Schema: public; Owner: postgres --- - -CREATE AGGREGATE max(debversion) ( - SFUNC = debversion_larger, - STYPE = debversion, - SORTOP = > -); - - -ALTER AGGREGATE public.max(debversion) OWNER TO postgres; - --- --- Name: <; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR < ( - PROCEDURE = debversion_lt, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = >, - NEGATOR = >= -); - - -ALTER OPERATOR public.< (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR < (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR < (debversion, debversion) IS 'debversion less-than'; - - --- --- Name: min(debversion); Type: AGGREGATE; Schema: public; Owner: postgres --- - -CREATE AGGREGATE min(debversion) ( - SFUNC = debversion_smaller, - STYPE = debversion, - SORTOP = < -); - - -ALTER AGGREGATE public.min(debversion) OWNER TO postgres; - --- --- Name: space_separated_list(text); Type: AGGREGATE; Schema: public; Owner: dak --- - -CREATE AGGREGATE space_separated_list(text) ( - SFUNC = space_concat, - STYPE = text, - INITCOND = '' -); - - -ALTER AGGREGATE public.space_separated_list(text) OWNER TO dak; - --- --- Name: <=; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR <= ( - PROCEDURE = debversion_le, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = >=, - NEGATOR = > -); - - -ALTER OPERATOR public.<= (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR <= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR <= (debversion, debversion) IS 'debversion less-than-or-equal'; - - --- --- Name: <>; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR <> ( - PROCEDURE = debversion_ne, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = <>, - NEGATOR = = -); - - -ALTER OPERATOR public.<> (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR <> (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR <> (debversion, debversion) IS 'debversion not equal'; - - --- --- Name: =; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR = ( - PROCEDURE = debversion_eq, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = =, - NEGATOR = <> -); - - -ALTER OPERATOR public.= (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR = (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR = (debversion, debversion) IS 'debversion equal'; - - --- --- Name: >=; Type: OPERATOR; Schema: public; Owner: postgres --- - -CREATE OPERATOR >= ( - PROCEDURE = debversion_ge, - LEFTARG = debversion, - RIGHTARG = debversion, - COMMUTATOR = <=, - NEGATOR = < -); - - -ALTER OPERATOR public.>= (debversion, debversion) OWNER TO postgres; - --- --- Name: OPERATOR >= (debversion, debversion); Type: COMMENT; Schema: public; Owner: postgres --- - -COMMENT ON OPERATOR >= (debversion, debversion) IS 'debversion greater-than-or-equal'; - - --- --- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres --- - -CREATE OPERATOR CLASS debversion_ops - DEFAULT FOR TYPE debversion USING btree AS - OPERATOR 1 <(debversion,debversion) , - OPERATOR 2 <=(debversion,debversion) , - OPERATOR 3 =(debversion,debversion) , - OPERATOR 4 >=(debversion,debversion) , - OPERATOR 5 >(debversion,debversion) , - FUNCTION 1 debversion_cmp(debversion,debversion); - - -ALTER OPERATOR CLASS public.debversion_ops USING btree OWNER TO postgres; - --- --- Name: debversion_ops; Type: OPERATOR CLASS; Schema: public; Owner: postgres --- - -CREATE OPERATOR CLASS debversion_ops - DEFAULT FOR TYPE debversion USING hash AS - OPERATOR 1 =(debversion,debversion) , - FUNCTION 1 debversion_hash(debversion); - - -ALTER OPERATOR CLASS public.debversion_ops USING hash OWNER TO postgres; - -SET search_path = pg_catalog; - --- --- Name: CAST (character AS public.debversion); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (character AS public.debversion) WITH FUNCTION public.debversion(character); - - --- --- Name: CAST (public.debversion AS character); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (public.debversion AS character) WITHOUT FUNCTION AS ASSIGNMENT; - - --- --- Name: CAST (public.debversion AS text); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (public.debversion AS text) WITHOUT FUNCTION AS IMPLICIT; - - --- --- Name: CAST (public.debversion AS character varying); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (public.debversion AS character varying) WITHOUT FUNCTION AS IMPLICIT; - - --- --- Name: CAST (text AS public.debversion); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (text AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT; - - --- --- Name: CAST (character varying AS public.debversion); Type: CAST; Schema: pg_catalog; Owner: --- - -CREATE CAST (character varying AS public.debversion) WITHOUT FUNCTION AS ASSIGNMENT; - - SET search_path = audit, pg_catalog; SET default_tablespace = '';