--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- Name: ra_documents; Type: TABLE; Schema: public; Owner: proforg; Tablespace:
--

CREATE TABLE ra_documents (
id integer DEFAULT nextval(('ra_documents_id_seq'::text)::regclass) NOT NULL,
parent integer DEFAULT 0 NOT NULL,
title text DEFAULT ''::text NOT NULL,
body text DEFAULT ''::text NOT NULL,
preview text DEFAULT ''::text NOT NULL,
keywords text DEFAULT ''::text NOT NULL,
comments integer DEFAULT 0 NOT NULL,
ear text,
author text,
author_id integer,
dt timestamp without time zone DEFAULT now() NOT NULL,
last_comment_date timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
last_comment_dt timestamp without time zone DEFAULT '1970-01-01 00:00:00'::timestamp without time zone NOT NULL,
CONSTRAINT "$1" CHECK ((parent >= 0)),
CONSTRAINT "$3" CHECK ((comments >= 0))
);

CREATE SEQUENCE ra_documents_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


--
-- Name: ra_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: proforg; Tablespace:
--

ALTER TABLE ONLY ra_documents
ADD CONSTRAINT ra_documents_pkey PRIMARY KEY (id);


--
-- Name: author_id_ra_documents_key; Type: INDEX; Schema: public; Owner: proforg; Tablespace:
--

CREATE INDEX author_id_ra_documents_key ON ra_documents USING btree (author_id);
--
-- Name: parent_ra_documents_index; Type: INDEX; Schema: public; Owner: proforg; Tablespace:
--

CREATE INDEX parent_ra_documents_index ON ra_documents USING btree (parent);

--
-- PostgreSQL database dump complete
--