-- -- PostgreSQL database dump -- SET client_encoding = 'UNICODE'; SET check_function_bodies = false; SET SESSION AUTHORIZATION 'postgres'; SET search_path = public, pg_catalog; -- -- TOC entry 31 (OID 17239) -- Name: plpgsql_call_handler(); Type: FUNC PROCEDURAL LANGUAGE; Schema: public; Owner: postgres -- CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS '$libdir/plpgsql', 'plpgsql_call_handler' LANGUAGE c; SET SESSION AUTHORIZATION DEFAULT; -- -- TOC entry 29 (OID 17240) -- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: public; Owner: -- CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler; -- -- TOC entry 30 (OID 17240) -- Name: plpgsql; Type: ACL LANGUAGE; Schema: public; Owner: -- REVOKE ALL ON LANGUAGE plpgsql FROM PUBLIC; SET SESSION AUTHORIZATION postgres; GRANT ALL ON LANGUAGE plpgsql TO postgres WITH GRANT OPTION; RESET SESSION AUTHORIZATION; SET SESSION AUTHORIZATION postgres; GRANT ALL ON LANGUAGE plpgsql TO PUBLIC; RESET SESSION AUTHORIZATION; SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: postgres -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 32 (OID 17239) -- Name: plpgsql_call_handler(); Type: ACL; Schema: public; Owner: postgres -- REVOKE ALL ON FUNCTION plpgsql_call_handler() FROM PUBLIC; REVOKE ALL ON FUNCTION plpgsql_call_handler() FROM postgres; GRANT ALL ON FUNCTION plpgsql_call_handler() TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 5 (OID 463406) -- Name: components; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE components INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 7 (OID 463406) -- Name: components; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE components FROM PUBLIC; GRANT ALL ON TABLE components TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 17 (OID 463408) -- Name: component; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE component ( uid integer DEFAULT nextval('components'::text), description character varying(64), stocking smallint, reserved smallint, package character varying(64) ); -- -- TOC entry 18 (OID 463408) -- Name: component; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE component FROM PUBLIC; GRANT ALL ON TABLE component TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 8 (OID 463411) -- Name: suppliers; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE suppliers INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 10 (OID 463411) -- Name: suppliers; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE suppliers FROM PUBLIC; GRANT ALL ON TABLE suppliers TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 19 (OID 463413) -- Name: supplier; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE supplier ( uid integer DEFAULT nextval('suppliers'::text), name character varying(64) ); -- -- TOC entry 20 (OID 463413) -- Name: supplier; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE supplier FROM PUBLIC; GRANT ALL ON TABLE supplier TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 11 (OID 463416) -- Name: projects; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE projects INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 13 (OID 463416) -- Name: projects; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE projects FROM PUBLIC; GRANT ALL ON TABLE projects TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 21 (OID 463418) -- Name: project; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE project ( uid integer DEFAULT nextval('projects'::text), name character varying(64) ); -- -- TOC entry 22 (OID 463418) -- Name: project; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE project FROM PUBLIC; GRANT ALL ON TABLE project TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 23 (OID 463421) -- Name: projcomp; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE projcomp ( projuid integer, compuid integer, designations character varying(64), quantity smallint ); -- -- TOC entry 24 (OID 463421) -- Name: projcomp; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE projcomp FROM PUBLIC; GRANT ALL ON TABLE projcomp TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 14 (OID 463423) -- Name: runs; Type: SEQUENCE; Schema: public; Owner: root -- CREATE SEQUENCE runs INCREMENT BY 1 NO MAXVALUE MINVALUE 0 CACHE 1; -- -- TOC entry 16 (OID 463423) -- Name: runs; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE runs FROM PUBLIC; GRANT ALL ON TABLE runs TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 25 (OID 463425) -- Name: run; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE run ( uid integer DEFAULT nextval('runs'::text), projuid integer, quantity integer, runstatus smallint ); -- -- TOC entry 26 (OID 463425) -- Name: run; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE run FROM PUBLIC; GRANT ALL ON TABLE run TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- TOC entry 27 (OID 469926) -- Name: compsupp; Type: TABLE; Schema: public; Owner: root -- CREATE TABLE compsupp ( compuid integer, suppuid integer, partno character varying(64), volume smallint, price double precision ); -- -- TOC entry 28 (OID 469926) -- Name: compsupp; Type: ACL; Schema: public; Owner: root -- REVOKE ALL ON TABLE compsupp FROM PUBLIC; GRANT ALL ON TABLE compsupp TO PUBLIC; SET SESSION AUTHORIZATION 'root'; -- -- Data for TOC entry 33 (OID 463408) -- Name: component; Type: TABLE DATA; Schema: public; Owner: root -- COPY component (uid, description, stocking, reserved, package) FROM stdin; 0 Resistor 27 ohm 0603 0 0 0603 1 Resistor 10K OHM 1/10W 5% 0 0 0603 \. -- -- Data for TOC entry 34 (OID 463413) -- Name: supplier; Type: TABLE DATA; Schema: public; Owner: root -- COPY supplier (uid, name) FROM stdin; 0 Digikey 1 Mouser \. -- -- Data for TOC entry 35 (OID 463418) -- Name: project; Type: TABLE DATA; Schema: public; Owner: root -- COPY project (uid, name) FROM stdin; 0 test \. -- -- Data for TOC entry 36 (OID 463421) -- Name: projcomp; Type: TABLE DATA; Schema: public; Owner: root -- COPY projcomp (projuid, compuid, designations, quantity) FROM stdin; 0 0 R1 R2 R4 R5 4 0 1 R3 1 \. -- -- Data for TOC entry 37 (OID 463425) -- Name: run; Type: TABLE DATA; Schema: public; Owner: root -- COPY run (uid, projuid, quantity, runstatus) FROM stdin; 0 0 3 0 \. -- -- Data for TOC entry 38 (OID 469926) -- Name: compsupp; Type: TABLE DATA; Schema: public; Owner: root -- COPY compsupp (compuid, suppuid, partno, volume, price) FROM stdin; 0 0 311-27GRCT-ND 10 0.02 0 1 660-RK73B1JTTD270J 10 0.02 \. -- -- TOC entry 6 (OID 463406) -- Name: components; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('components', 1, true); -- -- TOC entry 9 (OID 463411) -- Name: suppliers; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('suppliers', 1, true); -- -- TOC entry 12 (OID 463416) -- Name: projects; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('projects', 0, true); -- -- TOC entry 15 (OID 463423) -- Name: runs; Type: SEQUENCE SET; Schema: public; Owner: root -- SELECT pg_catalog.setval('runs', 0, true); SET SESSION AUTHORIZATION 'postgres'; -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema';