--
-- PostgreSQL database dump
--
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--
COMMENT ON SCHEMA public IS 'Standard public schema';
SET search_path = public, pg_catalog;
SET default_tablespace = '';
SET default_with_oids = false;
--
-- Name: author; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE author (
id integer NOT NULL,
pauseid text,
name text,
email text,
average_kwalitee numeric(6,3),
num_dists integer DEFAULT 0 NOT NULL,
rank integer DEFAULT 0 NOT NULL,
prev_av_kw numeric(6,3),
prev_rank integer DEFAULT 0 NOT NULL,
average_total_kwalitee numeric(6,3) DEFAULT 0
);
ALTER TABLE public.author OWNER TO cpants;
--
-- Name: author_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE author_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.author_id_seq OWNER TO cpants;
--
-- Name: author_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE author_id_seq OWNED BY author.id;
--
-- Name: dist; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE dist (
id integer NOT NULL,
run integer,
dist text,
package text,
vname text,
author integer,
version text,
version_major text,
version_minor text,
extension text,
extractable integer DEFAULT 0 NOT NULL,
extracts_nicely integer DEFAULT 0 NOT NULL,
size_packed integer DEFAULT 0 NOT NULL,
size_unpacked integer DEFAULT 0 NOT NULL,
released timestamp without time zone,
files integer DEFAULT 0 NOT NULL,
files_list text,
dirs integer DEFAULT 0 NOT NULL,
dirs_list text,
symlinks integer DEFAULT 0 NOT NULL,
symlinks_list text,
bad_permissions integer DEFAULT 0 NOT NULL,
bad_permissions_list text,
file_makefile_pl integer DEFAULT 0 NOT NULL,
file_build_pl integer DEFAULT 0 NOT NULL,
file_readme text,
file_manifest integer DEFAULT 0 NOT NULL,
file_meta_yml integer DEFAULT 0 NOT NULL,
file_signature integer DEFAULT 0 NOT NULL,
file_ninja integer DEFAULT 0 NOT NULL,
file_test_pl integer DEFAULT 0 NOT NULL,
file_changelog text,
dir_lib integer DEFAULT 0 NOT NULL,
dir_t integer DEFAULT 0 NOT NULL,
dir_xt integer DEFAULT 0 NOT NULL,
broken_module_install text DEFAULT 0 NOT NULL,
manifest_matches_dist integer DEFAULT 0 NOT NULL,
buildfile_executable integer DEFAULT 0 NOT NULL,
license text,
metayml_is_parsable integer DEFAULT 0 NOT NULL,
file_license integer DEFAULT 0 NOT NULL,
needs_compiler integer DEFAULT 0 NOT NULL,
got_prereq_from text,
is_core integer DEFAULT 0 NOT NULL,
file__build integer DEFAULT 0 NOT NULL,
file_build integer DEFAULT 0 NOT NULL,
file_makefile integer DEFAULT 0 NOT NULL,
file_blib integer DEFAULT 0 NOT NULL,
file_pm_to_blib integer DEFAULT 0 NOT NULL,
stdin_in_makefile_pl integer DEFAULT 0 NOT NULL,
stdin_in_build_pl integer DEFAULT 0 NOT NULL,
external_license_file text,
file_licence text,
licence_file text,
license_file text,
license_type text,
no_index text,
ignored_files_list text,
license_in_pod integer DEFAULT 0 NOT NULL,
license_from_yaml text,
license_from_external_license_file text,
test_files_list text
);
ALTER TABLE public.dist OWNER TO cpants;
--
-- Name: dist_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE dist_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.dist_id_seq OWNER TO cpants;
--
-- Name: dist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE dist_id_seq OWNED BY dist.id;
--
-- Name: error; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE error (
id integer NOT NULL,
dist integer,
prereq_matches_use text,
build_prereq_matches_use text,
manifest_matches_dist text,
metayml_conforms_to_known_spec text,
cpants text,
no_pod_errors text,
metayml_is_parsable text,
no_generated_files text DEFAULT 0 NOT NULL,
has_version_in_each_file text,
no_stdin_for_prompting text,
easily_repackageable_by_fedora text,
easily_repackageable_by_debian text,
easily_repackageable text,
metayml_conforms_spec_current text,
no_large_files text,
has_license_in_source_file text,
has_no_patches_in_debian text,
latest_version_distributed_by_debian text,
has_no_bugs_reported_in_debian text
);
ALTER TABLE public.error OWNER TO cpants;
--
-- Name: error_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE error_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.error_id_seq OWNER TO cpants;
--
-- Name: error_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE error_id_seq OWNED BY error.id;
--
-- Name: history_author; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE history_author (
id integer NOT NULL,
run integer,
author integer,
average_kwalitee numeric,
num_dists integer,
rank integer
);
ALTER TABLE public.history_author OWNER TO cpants;
--
-- Name: history_author_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE history_author_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.history_author_id_seq OWNER TO cpants;
--
-- Name: history_author_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE history_author_id_seq OWNED BY history_author.id;
--
-- Name: history_dist; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE history_dist (
id integer NOT NULL,
run integer,
distname text,
version text,
kwalitee numeric(6,3) DEFAULT 0 NOT NULL,
dist integer
);
ALTER TABLE public.history_dist OWNER TO cpants;
--
-- Name: history_dist_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE history_dist_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.history_dist_id_seq OWNER TO cpants;
--
-- Name: history_dist_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE history_dist_id_seq OWNED BY history_dist.id;
--
-- Name: kwalitee; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE kwalitee (
id integer NOT NULL,
dist integer,
abs_kw integer DEFAULT 0 NOT NULL,
abs_core_kw integer DEFAULT 0 NOT NULL,
kwalitee numeric(6,3) DEFAULT 0 NOT NULL,
rel_core_kw numeric(6,3) DEFAULT 0 NOT NULL,
extractable integer DEFAULT 0 NOT NULL,
extracts_nicely integer DEFAULT 0 NOT NULL,
has_version integer DEFAULT 0 NOT NULL,
has_proper_version integer DEFAULT 0 NOT NULL,
no_cpants_errors integer DEFAULT 0 NOT NULL,
has_readme integer DEFAULT 0 NOT NULL,
has_manifest integer DEFAULT 0 NOT NULL,
has_meta_yml integer DEFAULT 0 NOT NULL,
has_buildtool integer DEFAULT 0 NOT NULL,
has_changelog integer DEFAULT 0 NOT NULL,
no_symlinks integer DEFAULT 0 NOT NULL,
has_tests integer DEFAULT 0 NOT NULL,
proper_libs integer DEFAULT 0 NOT NULL,
is_prereq integer DEFAULT 0 NOT NULL,
use_strict integer DEFAULT 0 NOT NULL,
use_warnings integer DEFAULT 0 NOT NULL,
has_test_pod integer DEFAULT 0 NOT NULL,
has_test_pod_coverage integer DEFAULT 0 NOT NULL,
no_pod_errors integer DEFAULT 0 NOT NULL,
has_working_buildtool integer DEFAULT 0 NOT NULL,
manifest_matches_dist integer DEFAULT 0 NOT NULL,
has_example integer DEFAULT 0 NOT NULL,
buildtool_not_executable integer DEFAULT 0 NOT NULL,
has_humanreadable_license integer DEFAULT 0 NOT NULL,
metayml_is_parsable integer DEFAULT 0 NOT NULL,
metayml_conforms_spec_current integer DEFAULT 0 NOT NULL,
metayml_has_license integer DEFAULT 0 NOT NULL,
metayml_conforms_to_known_spec integer DEFAULT 0 NOT NULL,
has_license integer DEFAULT 0 NOT NULL,
prereq_matches_use integer DEFAULT 0 NOT NULL,
build_prereq_matches_use integer DEFAULT 0 NOT NULL,
no_generated_files integer DEFAULT 0 NOT NULL,
run integer,
has_version_in_each_file integer DEFAULT 0 NOT NULL,
has_tests_in_t_dir integer DEFAULT 0 NOT NULL,
no_stdin_for_prompting integer DEFAULT 0 NOT NULL,
easily_repackageable_by_fedora integer DEFAULT 0 NOT NULL,
easily_repackageable_by_debian integer DEFAULT 0 NOT NULL,
easily_repackageable integer DEFAULT 0 NOT NULL,
fits_fedora_license integer DEFAULT 0 NOT NULL,
metayml_declares_perl_version integer DEFAULT 0 NOT NULL,
no_large_files integer,
has_separate_license_file integer DEFAULT 0 NOT NULL,
has_license_in_source_file integer DEFAULT 0 NOT NULL,
metayml_has_provides integer DEFAULT 0 NOT NULL,
uses_test_nowarnings integer DEFAULT 0 NOT NULL,
latest_version_distributed_by_debian integer DEFAULT 0 NOT NULL,
has_no_bugs_reported_in_debian integer DEFAULT 0 NOT NULL,
has_no_patches_in_debian integer DEFAULT 0 NOT NULL,
distributed_by_debian integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.kwalitee OWNER TO cpants;
--
-- Name: kwalitee_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE kwalitee_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.kwalitee_id_seq OWNER TO cpants;
--
-- Name: kwalitee_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE kwalitee_id_seq OWNED BY kwalitee.id;
--
-- Name: modules; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE modules (
id integer NOT NULL,
dist integer,
module text,
file text,
in_lib integer DEFAULT 0 NOT NULL,
in_basedir integer DEFAULT 0 NOT NULL,
is_core integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.modules OWNER TO cpants;
--
-- Name: modules_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE modules_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.modules_id_seq OWNER TO cpants;
--
-- Name: modules_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE modules_id_seq OWNED BY modules.id;
--
-- Name: prereq; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE prereq (
id integer NOT NULL,
dist integer,
requires text,
version text,
in_dist integer,
is_prereq integer DEFAULT 0 NOT NULL,
is_build_prereq integer DEFAULT 0 NOT NULL,
is_optional_prereq integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.prereq OWNER TO cpants;
--
-- Name: prereq_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE prereq_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.prereq_id_seq OWNER TO cpants;
--
-- Name: prereq_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE prereq_id_seq OWNED BY prereq.id;
--
-- Name: run; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE run (
id integer NOT NULL,
mcanalyse_version text,
mcprocess_version text,
available_kwalitee integer DEFAULT 0 NOT NULL,
total_kwalitee integer DEFAULT 0 NOT NULL,
date timestamp without time zone DEFAULT now()
);
ALTER TABLE public.run OWNER TO cpants;
--
-- Name: run_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE run_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.run_id_seq OWNER TO cpants;
--
-- Name: run_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE run_id_seq OWNED BY run.id;
--
-- Name: uses; Type: TABLE; Schema: public; Owner: cpants; Tablespace:
--
CREATE TABLE uses (
id integer NOT NULL,
dist integer,
module text,
in_dist integer,
in_code integer DEFAULT 0 NOT NULL,
in_tests integer DEFAULT 0 NOT NULL
);
ALTER TABLE public.uses OWNER TO cpants;
--
-- Name: uses_id_seq; Type: SEQUENCE; Schema: public; Owner: cpants
--
CREATE SEQUENCE uses_id_seq
INCREMENT BY 1
NO MAXVALUE
NO MINVALUE
CACHE 1;
ALTER TABLE public.uses_id_seq OWNER TO cpants;
--
-- Name: uses_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: cpants
--
ALTER SEQUENCE uses_id_seq OWNED BY uses.id;
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE author ALTER COLUMN id SET DEFAULT nextval('author_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE dist ALTER COLUMN id SET DEFAULT nextval('dist_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE error ALTER COLUMN id SET DEFAULT nextval('error_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE history_author ALTER COLUMN id SET DEFAULT nextval('history_author_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE history_dist ALTER COLUMN id SET DEFAULT nextval('history_dist_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE kwalitee ALTER COLUMN id SET DEFAULT nextval('kwalitee_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE modules ALTER COLUMN id SET DEFAULT nextval('modules_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE prereq ALTER COLUMN id SET DEFAULT nextval('prereq_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE run ALTER COLUMN id SET DEFAULT nextval('run_id_seq'::regclass);
--
-- Name: id; Type: DEFAULT; Schema: public; Owner: cpants
--
ALTER TABLE uses ALTER COLUMN id SET DEFAULT nextval('uses_id_seq'::regclass);
--
-- Name: author_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY author
ADD CONSTRAINT author_pkey PRIMARY KEY (id);
--
-- Name: dist_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY dist
ADD CONSTRAINT dist_pkey PRIMARY KEY (id);
--
-- Name: error_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY error
ADD CONSTRAINT error_pkey PRIMARY KEY (id);
--
-- Name: history_author_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY history_author
ADD CONSTRAINT history_author_pkey PRIMARY KEY (id);
--
-- Name: history_dist_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY history_dist
ADD CONSTRAINT history_dist_pkey PRIMARY KEY (id);
--
-- Name: kwalitee_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY kwalitee
ADD CONSTRAINT kwalitee_pkey PRIMARY KEY (id);
--
-- Name: modules_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY modules
ADD CONSTRAINT modules_pkey PRIMARY KEY (id);
--
-- Name: prereq_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY prereq
ADD CONSTRAINT prereq_pkey PRIMARY KEY (id);
--
-- Name: run_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY run
ADD CONSTRAINT run_pkey PRIMARY KEY (id);
--
-- Name: uses_pkey; Type: CONSTRAINT; Schema: public; Owner: cpants; Tablespace:
--
ALTER TABLE ONLY uses
ADD CONSTRAINT uses_pkey PRIMARY KEY (id);
--
-- Name: auth_av; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX auth_av ON author USING btree (average_kwalitee);
--
-- Name: auth_num; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX auth_num ON author USING btree (num_dists);
--
-- Name: auth_pav; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX auth_pav ON author USING btree (prev_av_kw);
--
-- Name: auth_prank; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX auth_prank ON author USING btree (prev_rank);
--
-- Name: auth_rank; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX auth_rank ON author USING btree (rank);
--
-- Name: author_pauseid_key; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE UNIQUE INDEX author_pauseid_key ON author USING btree (pauseid);
--
-- Name: dist_auth; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX dist_auth ON dist USING btree (author);
--
-- Name: dist_dist_key; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE UNIQUE INDEX dist_dist_key ON dist USING btree (dist);
--
-- Name: dist_package_key; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE UNIQUE INDEX dist_package_key ON dist USING btree (package);
--
-- Name: dist_vname_key; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE UNIQUE INDEX dist_vname_key ON dist USING btree (vname);
--
-- Name: modules_basedir; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX modules_basedir ON modules USING btree (in_basedir);
--
-- Name: modules_core; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX modules_core ON modules USING btree (is_core);
--
-- Name: modules_dist; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX modules_dist ON modules USING btree (dist);
--
-- Name: modules_lib; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX modules_lib ON modules USING btree (in_lib);
--
-- Name: prereq_dist; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_dist ON prereq USING btree (dist);
--
-- Name: prereq_in_dist; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_in_dist ON prereq USING btree (in_dist);
--
-- Name: prereq_is_buildred; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_is_buildred ON prereq USING btree (is_build_prereq);
--
-- Name: prereq_is_optreq; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_is_optreq ON prereq USING btree (is_optional_prereq);
--
-- Name: prereq_is_req; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_is_req ON prereq USING btree (is_prereq);
--
-- Name: prereq_requires; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX prereq_requires ON prereq USING btree (requires);
--
-- Name: uses_dist; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX uses_dist ON uses USING btree (dist);
--
-- Name: uses_in_code; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX uses_in_code ON uses USING btree (in_code);
--
-- Name: uses_in_dist; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX uses_in_dist ON uses USING btree (in_dist);
--
-- Name: uses_in_tests; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX uses_in_tests ON uses USING btree (in_tests);
--
-- Name: uses_module; Type: INDEX; Schema: public; Owner: cpants; Tablespace:
--
CREATE INDEX uses_module ON uses USING btree (module);
--
-- Name: dist_author_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY dist
ADD CONSTRAINT dist_author_fkey FOREIGN KEY (author) REFERENCES author(id);
--
-- Name: dist_run_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY dist
ADD CONSTRAINT dist_run_fkey FOREIGN KEY (run) REFERENCES run(id);
--
-- Name: error_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY error
ADD CONSTRAINT error_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE CASCADE;
--
-- Name: history_author_author_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY history_author
ADD CONSTRAINT history_author_author_fkey FOREIGN KEY (author) REFERENCES author(id);
--
-- Name: history_author_run_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY history_author
ADD CONSTRAINT history_author_run_fkey FOREIGN KEY (run) REFERENCES run(id);
--
-- Name: history_dist_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY history_dist
ADD CONSTRAINT history_dist_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE SET NULL;
--
-- Name: history_dist_run_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY history_dist
ADD CONSTRAINT history_dist_run_fkey FOREIGN KEY (run) REFERENCES run(id);
--
-- Name: kwalitee_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY kwalitee
ADD CONSTRAINT kwalitee_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE CASCADE;
--
-- Name: kwalitee_run_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY kwalitee
ADD CONSTRAINT kwalitee_run_fkey FOREIGN KEY (run) REFERENCES run(id);
--
-- Name: modules_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY modules
ADD CONSTRAINT modules_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE CASCADE;
--
-- Name: prereq_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY prereq
ADD CONSTRAINT prereq_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE CASCADE;
--
-- Name: uses_dist_fkey; Type: FK CONSTRAINT; Schema: public; Owner: cpants
--
ALTER TABLE ONLY uses
ADD CONSTRAINT uses_dist_fkey FOREIGN KEY (dist) REFERENCES dist(id) ON DELETE CASCADE;
--
-- Name: public; Type: ACL; Schema: -; Owner: postgres
--
REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;
--
-- PostgreSQL database dump complete
--