root/traduc/trunk/www/tools/docspgfr_schema.dump

--
-- 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;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: pages; Type: TABLE; Schema: public; Owner: docspgfr; Tablespace: 
--

CREATE TABLE pages (
    id integer NOT NULL,
    url text,
    titre text,
    tags1 text,
    tags2 text,
    contenu text,
    fti tsvector,
    version integer
);


ALTER TABLE public.pages OWNER TO docspgfr;

--
-- Name: pages_id_seq; Type: SEQUENCE; Schema: public; Owner: docspgfr
--

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


ALTER TABLE public.pages_id_seq OWNER TO docspgfr;

--
-- Name: pages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: docspgfr
--

ALTER SEQUENCE pages_id_seq OWNED BY pages.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: docspgfr
--

ALTER TABLE pages ALTER COLUMN id SET DEFAULT nextval('pages_id_seq'::regclass);


--
-- Name: public; Type: ACL; Schema: -; Owner: docspgfr
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM docspgfr;
GRANT ALL ON SCHEMA public TO docspgfr;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- PostgreSQL database dump complete
--