--
-- PostgreSQL database dump
--

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

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: adhesionenlignesauve; Type: TABLE; Schema: public; Owner: mathieu; Tablespace: 
--

CREATE TABLE adhesionenlignesauve (
    croael integer DEFAULT nextval('adhesionenlignesauve_serial'::regclass) NOT NULL,
    datmajael timestamp without time zone DEFAULT now() NOT NULL,
    ideael integer NOT NULL,
    sexael character(1),
    datnaiael timestamp without time zone,
    nomael character varying(23) NOT NULL,
    preael character varying(15),
    nomjefael character varying(23),
    nomrecael character varying(23) DEFAULT '-'::character varying NOT NULL,
    nomjefrecael character varying(23) DEFAULT '-'::character varying,
    auxadrael character varying(38),
    voiadrael character varying(38),
    bopadrael character varying(38),
    copadrael character(5),
    locadrael character varying(32),
    quaadrael character(5),
    cotadrael character(2),
    ctcadrael character varying(64),
    telael character varying(25),
    tel2ael character varying(25),
    faxael character varying(25),
    maiael character varying(80),
    datdercotael timestamp without time zone,
    datderficael timestamp without time zone,
    croacaael integer NOT NULL,
    crodisael integer DEFAULT 1 NOT NULL,
    crocatael integer DEFAULT 1 NOT NULL,
    croechael integer DEFAULT 1 NOT NULL,
    croadmael integer DEFAULT 1 NOT NULL,
    crodetael integer DEFAULT 1 NOT NULL,
    croserael integer DEFAULT 1 NOT NULL,
    croselael integer DEFAULT 1 NOT NULL,
    croetaaffael integer,
    croetaexeael integer,
    autintael character(1) DEFAULT 'O'::bpchar NOT NULL,
    autextael character(1) DEFAULT 'O'::bpchar NOT NULL,
    nusael smallint DEFAULT 1,
    couael smallint DEFAULT 0,
    cirael smallint DEFAULT 0,
    ustael character(4) NOT NULL,
    memael character varying(999),
    crorouael integer,
    datrouael timestamp without time zone DEFAULT now(),
    idefgrael character varying(8),
    delael character(1) DEFAULT 'N'::bpchar NOT NULL,
    datcarael timestamp without time zone,
    hisresael character varying(250),
    annresael character varying(4),
    adrrouael integer DEFAULT 1 NOT NULL,
    crosecrspael integer,
    numsecrspael integer,
    crossiael integer,
    datproael timestamp without time zone,
    roumaiael character(1) DEFAULT 'N'::bpchar NOT NULL,
    croiutdelael integer,
    modautael character varying(255),
    crodspael integer,
    datrtrael timestamp without time zone,
    quonumael integer DEFAULT 1 NOT NULL,
    quodenael integer DEFAULT 1 NOT NULL,
    etpael integer DEFAULT 0 NOT NULL,
    cromodael integer DEFAULT 1,
    typrenael character(1) DEFAULT 'N'::bpchar NOT NULL,
    moncotael double precision DEFAULT 0 NOT NULL,
    nbrprlael integer,
    ibanael character varying(27),
    bicael character varying(11),
    idesynael integer,
    monregael double precision DEFAULT 0 NOT NULL,
    crowpyaael integer DEFAULT 1,
    dejadhael character(1) DEFAULT 'N'::bpchar,
    CONSTRAINT adhesionenlignesauve_adrrouael_check CHECK ((adrrouael >= 0)),
    CONSTRAINT adhesionenlignesauve_autextael_check CHECK ((autextael = ANY (ARRAY['O'::bpchar, 'N'::bpchar]))),
    CONSTRAINT adhesionenlignesauve_autintael_check CHECK ((autintael = ANY (ARRAY['O'::bpchar, 'N'::bpchar]))),
    CONSTRAINT adhesionenlignesauve_cirael_check CHECK ((cirael >= 0)),
    CONSTRAINT adhesionenlignesauve_couael_check CHECK ((couael >= 0)),
    CONSTRAINT adhesionenlignesauve_delael_check CHECK ((delael = ANY (ARRAY['S'::bpchar, 'D'::bpchar, 'N'::bpchar]))),
    CONSTRAINT adhesionenlignesauve_numsecrspael_check CHECK ((numsecrspael >= 0)),
    CONSTRAINT adhesionenlignesauve_nusael_check CHECK ((nusael >= 0)),
    CONSTRAINT adhesionenlignesauve_roumaiael_check CHECK ((roumaiael = ANY (ARRAY['O'::bpchar, 'N'::bpchar]))),
    CONSTRAINT adhesionenlignesauve_sexael_check CHECK (((sexael = ANY (ARRAY['1'::bpchar, '2'::bpchar])) OR (sexael IS NULL)))
);


ALTER TABLE adhesionenlignesauve OWNER TO mathieu;

--
-- Data for Name: adhesionenlignesauve; Type: TABLE DATA; Schema: public; Owner: mathieu
--

COPY adhesionenlignesauve (croael, datmajael, ideael, sexael, datnaiael, nomael, preael, nomjefael, nomrecael, nomjefrecael, auxadrael, voiadrael, bopadrael, copadrael, locadrael, quaadrael, cotadrael, ctcadrael, telael, tel2ael, faxael, maiael, datdercotael, datderficael, croacaael, crodisael, crocatael, croechael, croadmael, crodetael, croserael, croselael, croetaaffael, croetaexeael, autintael, autextael, nusael, couael, cirael, ustael, memael, crorouael, datrouael, idefgrael, delael, datcarael, hisresael, annresael, adrrouael, crosecrspael, numsecrspael, crossiael, datproael, roumaiael, croiutdelael, modautael, crodspael, datrtrael, quonumael, quodenael, etpael, cromodael, typrenael, moncotael, nbrprlael, ibanael, bicael, idesynael, monregael, crowpyaael, dejadhael) FROM stdin;
\.


--
-- Name: pk_croaelsauve; Type: CONSTRAINT; Schema: public; Owner: mathieu; Tablespace: 
--

ALTER TABLE ONLY adhesionenlignesauve
    ADD CONSTRAINT pk_croaelsauve PRIMARY KEY (croael);


--
-- Name: adhesionenlignesauve; Type: ACL; Schema: public; Owner: mathieu
--

REVOKE ALL ON TABLE adhesionenlignesauve FROM PUBLIC;
REVOKE ALL ON TABLE adhesionenlignesauve FROM mathieu;
GRANT ALL ON TABLE adhesionenlignesauve TO mathieu;
GRANT ALL ON TABLE adhesionenlignesauve TO egide;
GRANT SELECT ON TABLE adhesionenlignesauve TO PUBLIC;


--
-- PostgreSQL database dump complete
--

