-- -- 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: crash; Type: SCHEMA; Schema: -; Owner: postgres -- CREATE SCHEMA crash; ALTER SCHEMA crash OWNER TO postgres; -- -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres -- COMMENT ON SCHEMA public IS 'Standard public schema'; SET search_path = crash, pg_catalog; -- -- Name: forum_seq; Type: SEQUENCE; Schema: crash; Owner: postgres -- CREATE SEQUENCE forum_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE crash.forum_seq OWNER TO postgres; -- -- Name: forum_seq; Type: SEQUENCE SET; Schema: crash; Owner: postgres -- SELECT pg_catalog.setval('forum_seq', 1, true); SET default_tablespace = ''; SET default_with_oids = false; -- -- Name: forum; Type: TABLE; Schema: crash; Owner: postgres; Tablespace: -- CREATE TABLE forum ( id integer DEFAULT nextval('forum_seq'::regclass) NOT NULL, category_id integer NOT NULL, status integer DEFAULT 1, moderated integer DEFAULT 0, topics integer DEFAULT 0, posts integer DEFAULT 0, last_post integer DEFAULT 0, forum character varying, system_name character varying, description text ); ALTER TABLE crash.forum OWNER TO postgres; -- -- Name: forum_post_seq; Type: SEQUENCE; Schema: crash; Owner: postgres -- CREATE SEQUENCE forum_post_seq INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; ALTER TABLE crash.forum_post_seq OWNER TO postgres; -- -- Name: forum_post_seq; Type: SEQUENCE SET; Schema: crash; Owner: postgres -- SELECT pg_catalog.setval('forum_post_seq', 1, true); -- -- Name: forum_post; Type: TABLE; Schema: crash; Owner: postgres; Tablespace: -- CREATE TABLE forum_post ( id bigint DEFAULT nextval('forum_post_seq'::regclass) NOT NULL, status integer DEFAULT 1, forum_id integer NOT NULL, thread_id integer DEFAULT 0, sticky integer DEFAULT 0, user_id integer NOT NULL, create_date date DEFAULT now(), create_time time without time zone DEFAULT now(), last_poster_id integer DEFAULT 0, last_post_date date DEFAULT now(), last_post_time time without time zone DEFAULT now(), posts integer DEFAULT 0, topic character varying, post text ); ALTER TABLE crash.forum_post OWNER TO postgres; -- -- Data for Name: forum; Type: TABLE DATA; Schema: crash; Owner: postgres -- -- -- Data for Name: forum_post; Type: TABLE DATA; Schema: crash; Owner: postgres -- -- -- Name: forum_pkey; Type: CONSTRAINT; Schema: crash; Owner: postgres; Tablespace: -- ALTER TABLE ONLY forum ADD CONSTRAINT forum_pkey PRIMARY KEY (id); -- -- Name: forum_post_pkey; Type: CONSTRAINT; Schema: crash; Owner: postgres; Tablespace: -- ALTER TABLE ONLY forum_post ADD CONSTRAINT forum_post_pkey PRIMARY KEY (id); -- -- 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; -- -- Name: forum_seq; Type: ACL; Schema: crash; Owner: postgres -- REVOKE ALL ON SEQUENCE forum_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE forum_seq FROM postgres; GRANT ALL ON SEQUENCE forum_seq TO postgres; GRANT ALL ON SEQUENCE forum_seq TO apache; -- -- Name: forum; Type: ACL; Schema: crash; Owner: postgres -- REVOKE ALL ON TABLE forum FROM PUBLIC; REVOKE ALL ON TABLE forum FROM postgres; GRANT ALL ON TABLE forum TO postgres; GRANT ALL ON TABLE forum TO apache; -- -- Name: forum_post_seq; Type: ACL; Schema: crash; Owner: postgres -- REVOKE ALL ON SEQUENCE forum_post_seq FROM PUBLIC; REVOKE ALL ON SEQUENCE forum_post_seq FROM postgres; GRANT ALL ON SEQUENCE forum_post_seq TO postgres; GRANT ALL ON SEQUENCE forum_post_seq TO apache; -- -- Name: forum_post; Type: ACL; Schema: crash; Owner: postgres -- REVOKE ALL ON TABLE forum_post FROM PUBLIC; REVOKE ALL ON TABLE forum_post FROM postgres; GRANT ALL ON TABLE forum_post TO postgres; GRANT ALL ON TABLE forum_post TO apache; -- -- PostgreSQL database dump complete --