Need database dump of a wiki database

[waterkip]

A database dump of a wiki would be nice to have, so we can create a DB and populate it.

[vanHoesel]

--
-- PostgreSQL database dump
--

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: content; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE TABLE content (
    node_id integer NOT NULL,
    version integer DEFAULT 0 NOT NULL,
    text text DEFAULT ''::text NOT NULL,
    modified timestamp without time zone,
    comment text DEFAULT ''::text NOT NULL,
    moderated boolean DEFAULT true NOT NULL,
    verified timestamp without time zone,
    verified_info text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.content OWNER TO actuser_wiki;

--
-- Name: internal_links; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE TABLE internal_links (
    link_from character varying(200) DEFAULT ''::character varying NOT NULL,
    link_to character varying(200) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE public.internal_links OWNER TO actuser_wiki;

--
-- Name: metadata; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE TABLE metadata (
    node_id integer NOT NULL,
    version integer DEFAULT 0 NOT NULL,
    metadata_type character varying(200) DEFAULT ''::character varying NOT NULL,
    metadata_value text DEFAULT ''::text NOT NULL
);


ALTER TABLE public.metadata OWNER TO actuser_wiki;

--
-- Name: node_seq; Type: SEQUENCE; Schema: public; Owner: actuser_wiki
--

CREATE SEQUENCE node_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.node_seq OWNER TO actuser_wiki;

--
-- Name: node_seq; Type: SEQUENCE SET; Schema: public; Owner: actuser_wiki
--

SELECT pg_catalog.setval('node_seq', 1, false);


--
-- Name: node; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE TABLE node (
    id integer DEFAULT nextval('node_seq'::regclass) NOT NULL,
    name character varying(200) DEFAULT ''::character varying NOT NULL,
    version integer DEFAULT 0 NOT NULL,
    text text DEFAULT ''::text NOT NULL,
    modified timestamp without time zone,
    moderate boolean DEFAULT false NOT NULL
);


ALTER TABLE public.node OWNER TO actuser_wiki;

--
-- Name: schema_info; Type: TABLE; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE TABLE schema_info (
    version integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.schema_info OWNER TO actuser_wiki;

--
-- Data for Name: content; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--

COPY content (node_id, version, text, modified, comment, moderated, verified, verified_info) FROM stdin;
\.


--
-- Data for Name: internal_links; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--

COPY internal_links (link_from, link_to) FROM stdin;
\.


--
-- Data for Name: metadata; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--

COPY metadata (node_id, version, metadata_type, metadata_value) FROM stdin;
\.


--
-- Data for Name: node; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--

COPY node (id, name, version, text, modified, moderate) FROM stdin;
\.


--
-- Data for Name: schema_info; Type: TABLE DATA; Schema: public; Owner: actuser_wiki
--

COPY schema_info (version) FROM stdin;
10
\.


--
-- Name: pk_id; Type: CONSTRAINT; Schema: public; Owner: actuser_wiki; Tablespace: 
--

ALTER TABLE ONLY node
    ADD CONSTRAINT pk_id PRIMARY KEY (id);


--
-- Name: pk_node_id; Type: CONSTRAINT; Schema: public; Owner: actuser_wiki; Tablespace: 
--

ALTER TABLE ONLY content
    ADD CONSTRAINT pk_node_id PRIMARY KEY (node_id, version);


--
-- Name: internal_links_pkey; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE UNIQUE INDEX internal_links_pkey ON internal_links USING btree (link_from, link_to);


--
-- Name: metadata_index; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE INDEX metadata_index ON metadata USING btree (node_id, version, metadata_type, metadata_value);


--
-- Name: node_name; Type: INDEX; Schema: public; Owner: actuser_wiki; Tablespace: 
--

CREATE UNIQUE INDEX node_name ON node USING btree (name);


--
-- Name: fk_node_id; Type: FK CONSTRAINT; Schema: public; Owner: actuser_wiki
--

ALTER TABLE ONLY metadata
    ADD CONSTRAINT fk_node_id FOREIGN KEY (node_id) REFERENCES node(id);


--
-- Name: fk_node_id; Type: FK CONSTRAINT; Schema: public; Owner: actuser_wiki
--

ALTER TABLE ONLY content
    ADD CONSTRAINT fk_node_id FOREIGN KEY (node_id) REFERENCES node(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;


--
-- PostgreSQL database dump complete
--

[waterkip]

Thanks, seems to be working!