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

--
-- Name: wsystempay_paiements; Type: TABLE; Schema: public; Owner: egide; Tablespace: 
--

CREATE TABLE wsystempay_paiements (
    crowpai integer NOT NULL,
    idewpai character(6),
    datcrewpai date NOT NULL,
    datmajwpai timestamp without time zone DEFAULT now() NOT NULL,
    idewsyn integer NOT NULL,
    monwpai integer NOT NULL,
    refwpai character varying(15),
    libwpai character varying(150),
    crowsta integer DEFAULT 0 NOT NULL,
    crowres integer DEFAULT (-1),
    crowext integer DEFAULT (-1),
    crowori integer DEFAULT 1 NOT NULL,
    retwpai character varying(3072),
    mode character(10) DEFAULT 'TEST'::bpchar NOT NULL
);


ALTER TABLE wsystempay_paiements OWNER TO egide;

--
-- Name: COLUMN wsystempay_paiements.crowpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.crowpai IS 'serial unique';


--
-- Name: COLUMN wsystempay_paiements.idewpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.idewpai IS 'doit être unique dans la journée';


--
-- Name: COLUMN wsystempay_paiements.datcrewpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.datcrewpai IS 'Date de création aa-mm-jj';


--
-- Name: COLUMN wsystempay_paiements.datmajwpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.datmajwpai IS 'date de mise à jour';


--
-- Name: COLUMN wsystempay_paiements.idewsyn; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.idewsyn IS 'ide de l''adherent';


--
-- Name: COLUMN wsystempay_paiements.monwpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.monwpai IS 'montant à payer exprimé en centime d''euro';


--
-- Name: COLUMN wsystempay_paiements.refwpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.refwpai IS 'référence passée en parametre lors de la création du paiement';


--
-- Name: COLUMN wsystempay_paiements.libwpai; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.libwpai IS 'libélé passé en parametre lors de la création du paiement';


--
-- Name: COLUMN wsystempay_paiements.crowsta; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.crowsta IS 'statut du paiement
0: juste créé
1: à la banque
2: retour ok
99: erreur
';


--
-- Name: COLUMN wsystempay_paiements.crowres; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.crowres IS 'champs vads_result... à lier à la table wsystempay_result';


--
-- Name: COLUMN wsystempay_paiements.crowext; Type: COMMENT; Schema: public; Owner: egide
--

COMMENT ON COLUMN wsystempay_paiements.crowext IS 'champs vads_extra_result... à lier à la table wsystempay_extra';


--
-- Name: wpaiements_crowpai_seq; Type: SEQUENCE; Schema: public; Owner: egide
--

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


ALTER TABLE wpaiements_crowpai_seq OWNER TO egide;

--
-- Name: wpaiements_crowpai_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: egide
--

ALTER SEQUENCE wpaiements_crowpai_seq OWNED BY wsystempay_paiements.crowpai;


--
-- Name: crowpai; Type: DEFAULT; Schema: public; Owner: egide
--

ALTER TABLE ONLY wsystempay_paiements ALTER COLUMN crowpai SET DEFAULT nextval('wpaiements_crowpai_seq'::regclass);


--
-- Name: wpaiements_crowpai_seq; Type: SEQUENCE SET; Schema: public; Owner: egide
--

SELECT pg_catalog.setval('wpaiements_crowpai_seq', 32, true);


--
-- Data for Name: wsystempay_paiements; Type: TABLE DATA; Schema: public; Owner: egide
--

COPY wsystempay_paiements (crowpai, idewpai, datcrewpai, datmajwpai, idewsyn, monwpai, refwpai, libwpai, crowsta, crowres, crowext, crowori, retwpai, mode) FROM stdin;
1	1     	2017-09-25	2017-09-25 18:54:10.340683	504053	12536	8a28a	cotisation	0	-1	-1	1	\N	          
2	2     	2017-09-25	2017-09-25 18:55:44.999521	504053	12536	bd321	cotisation	0	-1	-1	1	\N	          
3	3     	2017-09-26	2017-09-26 12:51:16.043644	504053	12536	cffad	cotisation	0	-1	-1	1	\N	TEST      
4	4     	2017-09-26	2017-09-26 12:54:54.981933	504053	45328	8e636	cotisation	0	-1	-1	1	\N	TEST      
5	5     	2017-09-26	2017-09-26 13:04:37.200381	504053	500	d13cc	cotisation	0	-1	-1	1	\N	TEST      
6	6     	2017-09-26	2017-09-26 13:12:51.032936	504053	100	69e7d	cotisation	0	-1	-1	1	\N	TEST      
7	7     	2017-09-26	2017-09-26 13:13:55.875687	504053	100	502ea	cotisation	0	-1	-1	1	\N	TEST      
8	8     	2017-09-26	2017-09-26 13:15:57.646273	504053	82536	0596e	cotisation	0	-1	-1	1	\N	TEST      
9	9     	2017-09-26	2017-09-26 13:22:53.417997	504053	42536	feb72	cotisation	0	-1	-1	1	\N	TEST      
10	10    	2017-09-28	2017-09-28 07:19:31.918835	76	25600	2017092876	COTISATION SNEP 76	0	-1	-1	2	\N	TEST      
11	11    	2017-09-28	2017-09-28 14:32:05.444156	77	28300	2017092877	COTISATION SNEP 77	0	-1	-1	2	\N	TEST      
12	12    	2017-09-28	2017-09-28 14:32:05.506019	77	28300	2017092877	COTISATION SNEP 77	0	-1	-1	2	\N	TEST      
13	13    	2017-09-28	2017-09-28 15:02:09.492033	81	28300	2017092881	COTISATION SNEP 81	0	-1	-1	2	\N	TEST      
14	14    	2017-09-28	2017-09-28 15:02:09.592182	81	28300	2017092881	COTISATION SNEP 81	0	-1	-1	2	\N	TEST      
15	15    	2017-09-28	2017-09-28 15:46:42.126081	82	19900	2017092882	COTISATION SNEP 82	0	-1	-1	2	\N	TEST      
16	16    	2017-09-28	2017-09-28 15:46:42.171765	82	19900	2017092882	COTISATION SNEP 82	0	-1	-1	2	\N	TEST      
17	17    	2017-09-28	2017-09-28 16:23:28.793629	83	21300	2017092883	COTISATION SNEP 83	0	-1	-1	2	\N	TEST      
18	18    	2017-09-28	2017-09-28 16:23:28.842708	83	21300	2017092883	COTISATION SNEP 83	0	-1	-1	2	\N	TEST      
19	19    	2017-09-29	2017-09-29 16:33:16.828632	84	19900	2017092984	COTISATION SNEP 84	0	-1	-1	2	\N	TEST      
20	20    	2017-09-29	2017-09-29 16:33:17.422123	84	19900	2017092984	COTISATION SNEP 84	0	-1	-1	2	\N	TEST      
21	21    	2017-09-29	2017-09-29 18:02:07.855696	85	12600	2017092985	COTISATION SNEP 85	0	-1	-1	2	\N	TEST      
22	22    	2017-09-29	2017-09-29 18:02:08.391262	85	12600	2017092985	COTISATION SNEP 85	0	-1	-1	2	\N	TEST      
23	23    	2017-09-29	2017-09-29 19:28:34.105572	86	3000	2017092986	COTISATION SNEP 86	0	-1	-1	2	\N	TEST      
24	24    	2017-09-29	2017-09-29 19:28:34.600142	86	3000	2017092986	COTISATION SNEP 86	0	-1	-1	2	\N	TEST      
25	25    	2017-09-29	2017-09-29 19:36:25.596276	87	15200	2017092987	COTISATION SNEP 87	0	-1	-1	2	\N	TEST      
26	26    	2017-09-29	2017-09-29 19:36:26.006604	87	15200	2017092987	COTISATION SNEP 87	0	-1	-1	2	\N	TEST      
27	27    	2017-09-29	2017-09-29 19:41:34.540047	88	14800	2017092988	COTISATION SNEP 88	0	-1	-1	2	\N	TEST      
28	28    	2017-09-29	2017-09-29 19:41:34.94292	88	14800	2017092988	COTISATION SNEP 88	0	-1	-1	2	\N	TEST      
29	29    	2017-09-29	2017-09-29 20:01:26.296921	89	18700	2017092989	COTISATION SNEP 89	0	-1	-1	2	\N	TEST      
30	30    	2017-09-29	2017-09-29 20:01:26.719795	89	18700	2017092989	COTISATION SNEP 89	0	-1	-1	2	\N	TEST      
31	31    	2017-10-02	2017-10-02 17:56:24.075691	91	28300	2017100291	COTISATION SNEP 91	0	-1	-1	2	\N	TEST      
32	32    	2017-10-02	2017-10-02 17:56:24.122116	91	28300	2017100291	COTISATION SNEP 91	0	-1	-1	2	\N	TEST      
\.


--
-- Name: wpaiements_primaire; Type: CONSTRAINT; Schema: public; Owner: egide; Tablespace: 
--

ALTER TABLE ONLY wsystempay_paiements
    ADD CONSTRAINT wpaiements_primaire PRIMARY KEY (crowpai);


--
-- Name: fki_crowori_origine; Type: INDEX; Schema: public; Owner: egide; Tablespace: 
--

CREATE INDEX fki_crowori_origine ON wsystempay_paiements USING btree (crowori);


--
-- Name: ix_idewsyn; Type: INDEX; Schema: public; Owner: egide; Tablespace: 
--

CREATE INDEX ix_idewsyn ON wsystempay_paiements USING btree (idewsyn);


--
-- Name: tr_datmajwpai; Type: TRIGGER; Schema: public; Owner: egide
--

CREATE TRIGGER tr_datmajwpai BEFORE UPDATE ON wsystempay_paiements FOR EACH ROW EXECUTE PROCEDURE setdatmajwpai('datmajwpai');


--
-- PostgreSQL database dump complete
--

