--
--


SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


--
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';




--
-- Name: alegoriamerge2; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.alegoriamerge2 (
    id integer NOT NULL,
    name character varying,
    qx double precision,
    qy double precision,
    qz double precision,
    qw double precision,
    fx double precision,
    fy double precision,
    px double precision,
    py double precision,
    sk double precision,
    sx double precision,
    sy double precision,
    c3 double precision,
    c5 double precision,
    c7 double precision,
    cm double precision,
    cx double precision,
    cy double precision,
    source character varying,
    epsgquaternion integer,
    point public.geometry(PointZ,4978)
);


ALTER TABLE public.alegoriamerge2 OWNER TO postgres;

--
-- Name: alegoriamerge2_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.alegoriamerge2_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.alegoriamerge2_id_seq OWNER TO postgres;

--
-- Name: alegoriamerge2_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.alegoriamerge2_id_seq OWNED BY public.alegoriamerge2.id;


--
-- Name: georef; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.georef (
    imgid character varying(255) NOT NULL,
    georefid integer NOT NULL,
    date_prod date
);


ALTER TABLE public.georef OWNER TO postgres;

--
-- Name: georef_georefid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.georef_georefid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.georef_georefid_seq OWNER TO postgres;

--
-- Name: georef_georefid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.georef_georefid_seq OWNED BY public.georef.georefid;


--
-- Name: sources; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.sources (
    id integer NOT NULL,
    tablename character varying,
    credits character varying,
    home character varying,
    url character varying,
    viewer character varying,
    thumbnail character varying,
    lowres character varying,
    highres character varying,
    iip character varying,
    footprint public.geometry(MultiPolygon,2154)
);


ALTER TABLE public.sources OWNER TO postgres;

--
-- Name: sources_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE public.sources_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sources_id_seq OWNER TO postgres;

--
-- Name: sources_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE public.sources_id_seq OWNED BY public.sources.id;


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

ALTER TABLE ONLY public.alegoriamerge2 ALTER COLUMN id SET DEFAULT nextval('public.alegoriamerge2_id_seq'::regclass);


--
-- Name: georefid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.georef ALTER COLUMN georefid SET DEFAULT nextval('public.georef_georefid_seq'::regclass);


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

ALTER TABLE ONLY public.sources ALTER COLUMN id SET DEFAULT nextval('public.sources_id_seq'::regclass);


--
-- Data for Name: alegoriamerge2; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.alegoriamerge2 (id, name, qx, qy, qz, qw, fx, fy, px, py, sk, sx, sy, c3, c5, c7, cm, cx, cy, source, epsgquaternion, point) FROM stdin;
2	pont9.jpg	0.581005201870730903	0.38747788460641025	-0.0494559381556039582	0.714036381791041452	1420.83333333333326	1420.83333333333326	511.5	320	0	1023	640	0	0	0	1	0	0	10	4978	01010000A072130000CD1B146A3B9F5041402E6A423CD904C1955D7089A7B25141
3	19290602-100100_carte_postale_ancienne_aerienne_de_la_cathedrale_notre-dame.jpg	0.496908966390238238	0.380679253085630831	-0.135857549499858205	0.767924157475883162	1180.55555555555566	1180.55555555555566	425	299	0	850	598	0	0	0	1	0	0	10	4978	01010000A072130000D1FD8AB7FD065041A0EE94FE9BFF044140CB05BEEE3B5241
\.


--
-- Name: alegoriamerge2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.alegoriamerge2_id_seq', 3, true);


--
-- Data for Name: georef; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.georef (imgid, georefid, date_prod) FROM stdin;
\.


--
-- Name: georef_georefid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.georef_georefid_seq', 1, false);


--
-- Data for Name: sources; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.sources (id, tablename, credits, home, url, viewer, thumbnail, lowres, highres, iip, footprint) FROM stdin;
5	archives_nationales	\N	\N	http://134.158.74.36/images/archives_nationales/	\N	\N	\N	\N	\N	\N
10	onlinesemiautomatic	\N	\N	../data/	\N	\N	\N	\N	\N	\N
\.


--
-- Name: sources_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.sources_id_seq', 1, false);


--
-- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.spatial_ref_sys  FROM stdin;
\.


--
-- Name: alegoriamerge2_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.alegoriamerge2
    ADD CONSTRAINT alegoriamerge2_pkey PRIMARY KEY (id);


--
-- Name: georef_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.georef
    ADD CONSTRAINT georef_pkey PRIMARY KEY (imgid);


--
-- Name: sources_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.sources
    ADD CONSTRAINT sources_pkey PRIMARY KEY (id);


--
-- Name: SCHEMA 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;


--
--

