schema.sql

--
-- PostgreSQL database dump
--

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

--
-- Name: forum; Type: SCHEMA; Schema: -; Owner: -
--


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: edomain; Type: TABLE; Schema: forum; Owner: -; Tablespace: 
--

CREATE TABLE edomain (
    id integer NOT NULL,
    domain_id integer DEFAULT 0,
    url character varying(200),
    title character varying(50),
    status integer DEFAULT 1,
    pre_text text,
    post_text text,
    analytics character varying(15),
    header_text text
);


--
-- Name: edomain_id_seq; Type: SEQUENCE; Schema: forum; Owner: -
--

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


--
-- Name: edomain_id_seq; Type: SEQUENCE OWNED BY; Schema: forum; Owner: -
--

ALTER SEQUENCE edomain_id_seq OWNED BY edomain.id;


--
-- Name: forum; Type: TABLE; Schema: forum; Owner: -; Tablespace: 
--

CREATE TABLE forum (
    id integer NOT NULL,
    domain_id integer DEFAULT 0,
    title character varying(50) DEFAULT ''::character varying,
    body text,
    status smallint DEFAULT (1)::smallint,
    sorder smallint DEFAULT (1)::smallint,
    created timestamp without time zone DEFAULT now() NOT NULL,
    oid integer DEFAULT 0,
    updated timestamp without time zone,
    topics integer DEFAULT 0,
    group_name character varying(30)
);


--
-- Name: forum_id_seq; Type: SEQUENCE; Schema: forum; Owner: -
--

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


--
-- Name: forum_id_seq; Type: SEQUENCE OWNED BY; Schema: forum; Owner: -
--

ALTER SEQUENCE forum_id_seq OWNED BY forum.id;


--
-- Name: post; Type: TABLE; Schema: forum; Owner: -; Tablespace: 
--

CREATE TABLE post (
    id integer NOT NULL,
    pid integer DEFAULT 0,
    forum_id integer DEFAULT 0,
    title character varying(150) DEFAULT ''::character varying,
    tripcode character varying(10) DEFAULT ''::character varying,
    body text,
    status smallint DEFAULT (0)::smallint,
    created timestamp without time zone DEFAULT now() NOT NULL,
    updated timestamp without time zone,
    oid integer DEFAULT 0,
    topics integer DEFAULT 0
);


--
-- Name: post_id_seq; Type: SEQUENCE; Schema: forum; Owner: -
--

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


--
-- Name: post_id_seq; Type: SEQUENCE OWNED BY; Schema: forum; Owner: -
--

ALTER SEQUENCE post_id_seq OWNED BY post.id;


--
-- Name: id; Type: DEFAULT; Schema: forum; Owner: -
--

ALTER TABLE ONLY edomain ALTER COLUMN id SET DEFAULT nextval('edomain_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: forum; Owner: -
--

ALTER TABLE ONLY forum ALTER COLUMN id SET DEFAULT nextval('forum_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: forum; Owner: -
--

ALTER TABLE ONLY post ALTER COLUMN id SET DEFAULT nextval('post_id_seq'::regclass);


--
-- Name: edomain_pkey; Type: CONSTRAINT; Schema: forum; Owner: -; Tablespace: 
--

ALTER TABLE ONLY edomain
    ADD CONSTRAINT edomain_pkey PRIMARY KEY (id);


--
-- Name: forum_pkey; Type: CONSTRAINT; Schema: forum; Owner: -; Tablespace: 
--

ALTER TABLE ONLY forum
    ADD CONSTRAINT forum_pkey PRIMARY KEY (id);


--
-- Name: post_pkey; Type: CONSTRAINT; Schema: forum; Owner: -; Tablespace: 
--

ALTER TABLE ONLY post
    ADD CONSTRAINT post_pkey PRIMARY KEY (id);


--
-- Name: forum_domain_id_status_idx; Type: INDEX; Schema: forum; Owner: -; Tablespace: 
--

CREATE INDEX forum_domain_id_status_idx ON forum USING btree (domain_id, status);


--
-- Name: post_forum_id_ndx; Type: INDEX; Schema: forum; Owner: -; Tablespace: 
--

CREATE INDEX post_forum_id_ndx ON post USING btree (forum_id);


--
-- Name: post_pid_ndx; Type: INDEX; Schema: forum; Owner: -; Tablespace: 
--

CREATE INDEX post_pid_ndx ON post USING btree (pid);


--
-- Name: post_status_ndx; Type: INDEX; Schema: forum; Owner: -; Tablespace: 
--

CREATE INDEX post_status_ndx ON post USING btree (status);


--
-- PostgreSQL database dump complete
--