--
--

-- Started on 2011-05-31 18:56:27

SET escape_string_warning = off;

--
-- TOC entry 9 (class 2615 OID 529210)
-- Name: Common; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "Common";


ALTER SCHEMA "Common" OWNER TO openconcerto;

--
-- TOC entry 10834 (class 0 OID 0)
-- Dependencies: 9
-- Name: SCHEMA "Common"; Type: COMMENT; Schema: -; Owner: openconcerto
--

COMMENT ON SCHEMA "Common" IS 'Standard public schema';


--
-- TOC entry 10 (class 2615 OID 529211)
-- Name: Default; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "Default";


ALTER SCHEMA "Default" OWNER TO openconcerto;

--
-- TOC entry 10836 (class 0 OID 0)
-- Dependencies: 10
-- Name: SCHEMA "Default"; Type: COMMENT; Schema: -; Owner: openconcerto
--

COMMENT ON SCHEMA "Default" IS 'Standard public schema';


--
-- TOC entry 7 (class 2615 OID 529212)
-- Name: OpenConcerto42; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "OpenConcerto42";


ALTER SCHEMA "OpenConcerto42" OWNER TO openconcerto;

--
-- TOC entry 8 (class 2615 OID 529213)
-- Name: OpenConcerto48; Type: SCHEMA; Schema: -; Owner: openconcerto
--

CREATE SCHEMA "OpenConcerto48";


ALTER SCHEMA "OpenConcerto48" OWNER TO openconcerto;


--
-- TOC entry 23 (class 1255 OID 529214)
-- Dependencies: 10
-- Name: next_ordret(); Type: FUNCTION; Schema: Default; Owner: openconcerto
--

CREATE FUNCTION next_ordret() RETURNS numeric
    LANGUAGE sql
    AS $$ UPDATE ordreT_generator set tmpVal = currentVal, currentVal = currentVal + inc ;SELECT tmpVal from ordreT_generator; $$;


ALTER FUNCTION "Default".next_ordret() OWNER TO openconcerto;

--
-- TOC entry 24 (class 1255 OID 529215)
-- Dependencies: 10
-- Name: reset_ordret(); Type: FUNCTION; Schema: Default; Owner: openconcerto
--

CREATE FUNCTION reset_ordret() RETURNS numeric
    LANGUAGE sql
    AS $$ update ordreT_generator set currentVal = minVal ;select currentVal from ordreT_generator; $$;


ALTER FUNCTION "Default".reset_ordret() OWNER TO openconcerto;




--
-- TOC entry 2746 (class 1259 OID 529216)
-- Dependencies: 3710 3711 3712 3713 9
-- Name: ACCES_SOCIETE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ACCES_SOCIETE" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1,
    "ID_SOCIETE_COMMON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."ACCES_SOCIETE" OWNER TO openconcerto;

--
-- TOC entry 2747 (class 1259 OID 529223)
-- Dependencies: 2746 9
-- Name: ACCES_SOCIETE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."ACCES_SOCIETE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10840 (class 0 OID 0)
-- Dependencies: 2747
-- Name: ACCES_SOCIETE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "ACCES_SOCIETE_ID_seq" OWNED BY "ACCES_SOCIETE"."ID";


--
-- TOC entry 10841 (class 0 OID 0)
-- Dependencies: 2747
-- Name: ACCES_SOCIETE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"ACCES_SOCIETE_ID_seq"', 1, true);


--
-- TOC entry 2748 (class 1259 OID 529225)
-- Dependencies: 3715 3716 3717 3718 3719 3720 3721 9
-- Name: ADRESSE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ADRESSE_COMMON" (
    "ID" integer NOT NULL,
    "RUE" character varying(2048) DEFAULT ''::text NOT NULL,
    "CODE_POSTAL" character varying DEFAULT ''::character varying NOT NULL,
    "PAYS" character varying DEFAULT ''::character varying NOT NULL,
    "VILLE" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CEDEX" integer,
    "HAS_CEDEX" boolean DEFAULT false
);


ALTER TABLE "Common"."ADRESSE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2749 (class 1259 OID 529238)
-- Dependencies: 2748 9
-- Name: ADRESSE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."ADRESSE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10842 (class 0 OID 0)
-- Dependencies: 2749
-- Name: ADRESSE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "ADRESSE_COMMON_ID_seq" OWNED BY "ADRESSE_COMMON"."ID";


--
-- TOC entry 10843 (class 0 OID 0)
-- Dependencies: 2749
-- Name: ADRESSE_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"ADRESSE_COMMON_ID_seq"', 61, true);


--
-- TOC entry 2750 (class 1259 OID 529240)
-- Dependencies: 3723 3724 3725 3726 3727 3728 3729 3730 3731 3732 3733 3734 3735 3736 3737 3738 3739 3740 9
-- Name: BANQUE_POLE_PRODUIT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BANQUE_POLE_PRODUIT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "NUMERO_RUE" character varying(2048) DEFAULT ''::text,
    "VOIE" character varying(2048) DEFAULT ''::text,
    "RUE" character varying(2048) DEFAULT ''::text,
    "CODE_POSTAL" character varying(2048) DEFAULT ''::text,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "CODE_ETS" character varying(2048) DEFAULT ''::text,
    "CODE_GUICHET" character varying(2048) DEFAULT ''::text,
    "NUMERO_COMPTE" character varying(2048) DEFAULT ''::text,
    "CLE_RICE" character varying(2048) DEFAULT ''::text,
    "DOMICILIATION" character varying(2048) DEFAULT ''::text,
    "BIC" character varying(2048) DEFAULT ''::text,
    "IBAN" character varying(2048) DEFAULT ''::text,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ID_POLE_PRODUIT" integer DEFAULT 1
);


ALTER TABLE "Common"."BANQUE_POLE_PRODUIT" OWNER TO openconcerto;

--
-- TOC entry 2751 (class 1259 OID 529264)
-- Dependencies: 2750 9
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."BANQUE_POLE_PRODUIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10844 (class 0 OID 0)
-- Dependencies: 2751
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "BANQUE_POLE_PRODUIT_ID_seq" OWNED BY "BANQUE_POLE_PRODUIT"."ID";


--
-- TOC entry 10845 (class 0 OID 0)
-- Dependencies: 2751
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"BANQUE_POLE_PRODUIT_ID_seq"', 1, true);


--
-- TOC entry 2752 (class 1259 OID 529266)
-- Dependencies: 3742 3743 3744 3745 3746 3747 3748 9
-- Name: CAISSE_COTISATION; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CAISSE_COTISATION" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_COMMON" integer DEFAULT 1 NOT NULL,
    "TEL" character varying DEFAULT ''::character varying NOT NULL,
    "MAIL" character varying DEFAULT ''::character varying NOT NULL,
    "TEL_PORTABLE" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."CAISSE_COTISATION" OWNER TO openconcerto;

--
-- TOC entry 2753 (class 1259 OID 529279)
-- Dependencies: 2752 9
-- Name: CAISSE_COTISATION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "CAISSE_COTISATION_ID_seq"
    START WITH 9
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."CAISSE_COTISATION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10846 (class 0 OID 0)
-- Dependencies: 2753
-- Name: CAISSE_COTISATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "CAISSE_COTISATION_ID_seq" OWNED BY "CAISSE_COTISATION"."ID";


--
-- TOC entry 10847 (class 0 OID 0)
-- Dependencies: 2753
-- Name: CAISSE_COTISATION_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"CAISSE_COTISATION_ID_seq"', 9, false);


--
-- TOC entry 2754 (class 1259 OID 529281)
-- Dependencies: 3749 3750 3751 3752 9
-- Name: COMPLETION; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMPLETION" (
    "CHAMP" character varying DEFAULT ''::character varying NOT NULL,
    "LABEL" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."COMPLETION" OWNER TO openconcerto;

--
-- TOC entry 2755 (class 1259 OID 529291)
-- Dependencies: 3754 3755 3756 3757 9
-- Name: COMPTE_PCE_DEFAULT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMPTE_PCE_DEFAULT" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "NUMERO_DEFAULT" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."COMPTE_PCE_DEFAULT" OWNER TO openconcerto;

--
-- TOC entry 2756 (class 1259 OID 529301)
-- Dependencies: 2755 9
-- Name: COMPTE_PCE_DEFAULT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."COMPTE_PCE_DEFAULT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10848 (class 0 OID 0)
-- Dependencies: 2756
-- Name: COMPTE_PCE_DEFAULT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "COMPTE_PCE_DEFAULT_ID_seq" OWNED BY "COMPTE_PCE_DEFAULT"."ID";


--
-- TOC entry 10849 (class 0 OID 0)
-- Dependencies: 2756
-- Name: COMPTE_PCE_DEFAULT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMPTE_PCE_DEFAULT_ID_seq"', 28, true);


--
-- TOC entry 2757 (class 1259 OID 529303)
-- Dependencies: 3758 3759 3761 9
-- Name: CONNEXION; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CONNEXION" (
    "LOGIN" character varying(45),
    "MDP" character varying(2048),
    "DATE" timestamp with time zone,
    "IP" character varying(2048),
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL,
    "FAILED" boolean DEFAULT false
);


ALTER TABLE "Common"."CONNEXION" OWNER TO openconcerto;

--
-- TOC entry 2758 (class 1259 OID 529312)
-- Dependencies: 2757 9
-- Name: CONNEXION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."CONNEXION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10850 (class 0 OID 0)
-- Dependencies: 2758
-- Name: CONNEXION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "CONNEXION_ID_seq" OWNED BY "CONNEXION"."ID";


--
-- TOC entry 10851 (class 0 OID 0)
-- Dependencies: 2758
-- Name: CONNEXION_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"CONNEXION_ID_seq"', 3375, true);


--
-- TOC entry 2759 (class 1259 OID 529314)
-- Dependencies: 3763 3764 3765 3766 3767 3768 9
-- Name: DOMAINE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "DOMAINE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CONDITION" character varying(2048) DEFAULT ''::text,
    "Q18" boolean DEFAULT false,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "Common"."DOMAINE" OWNER TO openconcerto;

--
-- TOC entry 2760 (class 1259 OID 529326)
-- Dependencies: 2759 9
-- Name: DOMAINE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."DOMAINE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10852 (class 0 OID 0)
-- Dependencies: 2760
-- Name: DOMAINE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "DOMAINE_ID_seq" OWNED BY "DOMAINE"."ID";


--
-- TOC entry 10853 (class 0 OID 0)
-- Dependencies: 2760
-- Name: DOMAINE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"DOMAINE_ID_seq"', 1, true);


--
-- TOC entry 2761 (class 1259 OID 529328)
-- Dependencies: 3769 3770 3772 3773 3774 9
-- Name: ECHANTILLON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ECHANTILLON" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying,
    "PV_HT" bigint DEFAULT 0,
    "PV_TTC" bigint DEFAULT 0
);


ALTER TABLE "Common"."ECHANTILLON" OWNER TO openconcerto;

--
-- TOC entry 2762 (class 1259 OID 529339)
-- Dependencies: 2761 9
-- Name: ECHANTILLON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."ECHANTILLON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10854 (class 0 OID 0)
-- Dependencies: 2762
-- Name: ECHANTILLON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "ECHANTILLON_ID_seq" OWNED BY "ECHANTILLON"."ID";


--
-- TOC entry 10855 (class 0 OID 0)
-- Dependencies: 2762
-- Name: ECHANTILLON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"ECHANTILLON_ID_seq"', 1, true);


--
-- TOC entry 2763 (class 1259 OID 529341)
-- Dependencies: 3776 3777 3778 3779 3780 9
-- Name: EXERCICE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "EXERCICE_COMMON" (
    "ID" integer NOT NULL,
    "DATE_DEB" date,
    "DATE_FIN" date,
    "NUMERO" integer DEFAULT 1 NOT NULL,
    "CLOTURE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE_CLOTURE" date,
    "ID_SOCIETE_COMMON" integer DEFAULT 1
);


ALTER TABLE "Common"."EXERCICE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2764 (class 1259 OID 529349)
-- Dependencies: 2763 9
-- Name: EXERCICE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."EXERCICE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10856 (class 0 OID 0)
-- Dependencies: 2764
-- Name: EXERCICE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "EXERCICE_COMMON_ID_seq" OWNED BY "EXERCICE_COMMON"."ID";


--
-- TOC entry 10857 (class 0 OID 0)
-- Dependencies: 2764
-- Name: EXERCICE_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"EXERCICE_COMMON_ID_seq"', 60, true);


--
-- TOC entry 2765 (class 1259 OID 529351)
-- Dependencies: 3781 3782 9
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FWK_SCHEMA_METADATA" (
    "NAME" character varying(100) DEFAULT ''::character varying NOT NULL,
    "VALUE" character varying(250) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Common"."FWK_SCHEMA_METADATA" OWNER TO openconcerto;

--
-- TOC entry 2766 (class 1259 OID 529356)
-- Dependencies: 3783 3784 9
-- Name: FWK_UNDEFINED_IDS; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FWK_UNDEFINED_IDS" (
    "TABLENAME" character varying DEFAULT ''::character varying NOT NULL,
    "UNDEFINED_ID" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."FWK_UNDEFINED_IDS" OWNER TO openconcerto;

--
-- TOC entry 2767 (class 1259 OID 529364)
-- Dependencies: 3786 3787 3788 9
-- Name: IMPRESSION_RUBRIQUE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "IMPRESSION_RUBRIQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."IMPRESSION_RUBRIQUE" OWNER TO openconcerto;

--
-- TOC entry 2768 (class 1259 OID 529373)
-- Dependencies: 2767 9
-- Name: IMPRESSION_RUBRIQUE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "IMPRESSION_RUBRIQUE_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."IMPRESSION_RUBRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10858 (class 0 OID 0)
-- Dependencies: 2768
-- Name: IMPRESSION_RUBRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "IMPRESSION_RUBRIQUE_ID_seq" OWNED BY "IMPRESSION_RUBRIQUE"."ID";


--
-- TOC entry 10859 (class 0 OID 0)
-- Dependencies: 2768
-- Name: IMPRESSION_RUBRIQUE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"IMPRESSION_RUBRIQUE_ID_seq"', 5, false);


--
-- TOC entry 2769 (class 1259 OID 529375)
-- Dependencies: 3790 3791 3792 3793 3794 3795 3796 3797 3798 3799 3800 3801 3802 3803 9
-- Name: INDICE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "INDICE" (
    "ANNEE" integer,
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "JANVIER" bigint DEFAULT 0,
    "FEVRIER" bigint DEFAULT 0,
    "MARS" bigint DEFAULT 0,
    "AVRIL" bigint DEFAULT 0,
    "MAI" bigint DEFAULT 0,
    "JUIN" bigint DEFAULT 0,
    "JUILLET" bigint DEFAULT 0,
    "AOUT" bigint DEFAULT 0,
    "SEPTEMBRE" bigint DEFAULT 0,
    "OCTOBRE" bigint DEFAULT 0,
    "NOVEMBRE" bigint DEFAULT 0,
    "DECEMBRE" bigint DEFAULT 0
);


ALTER TABLE "Common"."INDICE" OWNER TO openconcerto;

--
-- TOC entry 2770 (class 1259 OID 529392)
-- Dependencies: 2769 9
-- Name: INDICE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."INDICE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10860 (class 0 OID 0)
-- Dependencies: 2770
-- Name: INDICE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "INDICE_ID_seq" OWNED BY "INDICE"."ID";


--
-- TOC entry 10861 (class 0 OID 0)
-- Dependencies: 2770
-- Name: INDICE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"INDICE_ID_seq"', 6, true);


--
-- TOC entry 2771 (class 1259 OID 529394)
-- Dependencies: 3805 3806 3807 3808 3809 9
-- Name: OBJET; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "OBJET" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_DOMAINE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."OBJET" OWNER TO openconcerto;

--
-- TOC entry 2772 (class 1259 OID 529405)
-- Dependencies: 2771 9
-- Name: OBJET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."OBJET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10862 (class 0 OID 0)
-- Dependencies: 2772
-- Name: OBJET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "OBJET_ID_seq" OWNED BY "OBJET"."ID";


--
-- TOC entry 10863 (class 0 OID 0)
-- Dependencies: 2772
-- Name: OBJET_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"OBJET_ID_seq"', 1, true);


--
-- TOC entry 2773 (class 1259 OID 529407)
-- Dependencies: 3811 3812 3813 3814 3815 3816 3817 3818 3819 3820 3821 3822 3823 3824 9
-- Name: PERIODE_VALIDITE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PERIODE_VALIDITE" (
    "ID" integer NOT NULL,
    "JANVIER" boolean DEFAULT true NOT NULL,
    "FEVRIER" boolean DEFAULT true NOT NULL,
    "MARS" boolean DEFAULT true NOT NULL,
    "AVRIL" boolean DEFAULT true NOT NULL,
    "MAI" boolean DEFAULT true NOT NULL,
    "JUIN" boolean DEFAULT true NOT NULL,
    "JUILLET" boolean DEFAULT true NOT NULL,
    "AOUT" boolean DEFAULT true NOT NULL,
    "SEPTEMBRE" boolean DEFAULT true NOT NULL,
    "OCTOBRE" boolean DEFAULT true NOT NULL,
    "NOVEMBRE" boolean DEFAULT true NOT NULL,
    "DECEMBRE" boolean DEFAULT true NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."PERIODE_VALIDITE" OWNER TO openconcerto;

--
-- TOC entry 2774 (class 1259 OID 529424)
-- Dependencies: 2773 9
-- Name: PERIODE_VALIDITE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "PERIODE_VALIDITE_ID_seq"
    START WITH 95
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."PERIODE_VALIDITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10864 (class 0 OID 0)
-- Dependencies: 2774
-- Name: PERIODE_VALIDITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "PERIODE_VALIDITE_ID_seq" OWNED BY "PERIODE_VALIDITE"."ID";


--
-- TOC entry 10865 (class 0 OID 0)
-- Dependencies: 2774
-- Name: PERIODE_VALIDITE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"PERIODE_VALIDITE_ID_seq"', 95, false);


--
-- TOC entry 2775 (class 1259 OID 529426)
-- Dependencies: 3825 3826 3827 3828 3829 3830 3831 3832 3833 3834 9
-- Name: POLE_PRODUIT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "POLE_PRODUIT" (
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM_DIRECTEUR" character varying(2048) DEFAULT ''::text,
    "NOM_SECRETAIRE" character varying(2048) DEFAULT ''::text,
    "TEL" character varying(22) DEFAULT ''::character varying,
    "FAX" character varying(22) DEFAULT ''::character varying,
    "MAIL" character varying(2048) DEFAULT ''::text,
    "ID_ADRESSE_COMMON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL
);


ALTER TABLE "Common"."POLE_PRODUIT" OWNER TO openconcerto;

--
-- TOC entry 2776 (class 1259 OID 529442)
-- Dependencies: 2775 9
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."POLE_PRODUIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10866 (class 0 OID 0)
-- Dependencies: 2776
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "POLE_PRODUIT_ID_seq" OWNED BY "POLE_PRODUIT"."ID";


--
-- TOC entry 10867 (class 0 OID 0)
-- Dependencies: 2776
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"POLE_PRODUIT_ID_seq"', 1, true);


--
-- TOC entry 2777 (class 1259 OID 529444)
-- Dependencies: 3837 3838 3839 9
-- Name: PROFIL_PAYE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PROFIL_PAYE" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."PROFIL_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2778 (class 1259 OID 529453)
-- Dependencies: 3841 3842 3843 3844 3845 3846 3847 9
-- Name: PROFIL_PAYE_ELEMENT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PROFIL_PAYE_ELEMENT" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ID_PROFIL_PAYE" integer DEFAULT 1 NOT NULL,
    "SOURCE" character varying DEFAULT ''::character varying NOT NULL,
    "IDSOURCE" integer DEFAULT 1 NOT NULL,
    "POSITION" integer DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."PROFIL_PAYE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2779 (class 1259 OID 529466)
-- Dependencies: 2778 9
-- Name: PROFIL_PAYE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."PROFIL_PAYE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10868 (class 0 OID 0)
-- Dependencies: 2779
-- Name: PROFIL_PAYE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "PROFIL_PAYE_ELEMENT_ID_seq" OWNED BY "PROFIL_PAYE_ELEMENT"."ID";


--
-- TOC entry 10869 (class 0 OID 0)
-- Dependencies: 2779
-- Name: PROFIL_PAYE_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"PROFIL_PAYE_ELEMENT_ID_seq"', 168, true);


--
-- TOC entry 2780 (class 1259 OID 529468)
-- Dependencies: 2777 9
-- Name: PROFIL_PAYE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."PROFIL_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10870 (class 0 OID 0)
-- Dependencies: 2780
-- Name: PROFIL_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "PROFIL_PAYE_ID_seq" OWNED BY "PROFIL_PAYE"."ID";


--
-- TOC entry 10871 (class 0 OID 0)
-- Dependencies: 2780
-- Name: PROFIL_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"PROFIL_PAYE_ID_seq"', 9, true);


--
-- TOC entry 2781 (class 1259 OID 529470)
-- Dependencies: 3849 3850 3851 3852 9
-- Name: RIGHT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RIGHT" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CODE" character varying(128) DEFAULT ''::character varying,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "DESCRIPTION" character varying(500) DEFAULT ''::character varying
);


ALTER TABLE "Common"."RIGHT" OWNER TO openconcerto;

--
-- TOC entry 2782 (class 1259 OID 529480)
-- Dependencies: 2781 9
-- Name: RIGHT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."RIGHT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10872 (class 0 OID 0)
-- Dependencies: 2782
-- Name: RIGHT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "RIGHT_ID_seq" OWNED BY "RIGHT"."ID";


--
-- TOC entry 10873 (class 0 OID 0)
-- Dependencies: 2782
-- Name: RIGHT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"RIGHT_ID_seq"', 16, true);


--
-- TOC entry 2783 (class 1259 OID 529482)
-- Dependencies: 3854 3855 3856 3857 3858 3859 3860 3861 3862 3863 3864 3865 3866 9
-- Name: RUBRIQUE_BRUT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RUBRIQUE_BRUT" (
    "ID" integer NOT NULL,
    "CODE" character varying DEFAULT ''::character varying NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT" character varying(2048) DEFAULT ''::text NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_TYPE_RUBRIQUE_BRUT" integer DEFAULT 1 NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "PART_BRUT" boolean DEFAULT false NOT NULL,
    "PART_CP" boolean DEFAULT false NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_BRUT" OWNER TO openconcerto;

--
-- TOC entry 2784 (class 1259 OID 529501)
-- Dependencies: 2783 9
-- Name: RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "RUBRIQUE_BRUT_ID_seq"
    START WITH 42
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_BRUT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10874 (class 0 OID 0)
-- Dependencies: 2784
-- Name: RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "RUBRIQUE_BRUT_ID_seq" OWNED BY "RUBRIQUE_BRUT"."ID";


--
-- TOC entry 10875 (class 0 OID 0)
-- Dependencies: 2784
-- Name: RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"RUBRIQUE_BRUT_ID_seq"', 42, false);


--
-- TOC entry 2785 (class 1259 OID 529503)
-- Dependencies: 3868 3869 3870 3871 3872 3873 3874 3875 3876 3877 3878 3879 3880 3881 9
-- Name: RUBRIQUE_COMM; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RUBRIQUE_COMM" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "CODE" character varying DEFAULT ''::character varying NOT NULL,
    "NB_BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX_SAL" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_SAL_AJ" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_SAL_DED" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "NOM_VISIBLE" boolean DEFAULT true NOT NULL,
    "MONTANT" real DEFAULT 0 NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_COMM" OWNER TO openconcerto;

--
-- TOC entry 2786 (class 1259 OID 529523)
-- Dependencies: 2785 9
-- Name: RUBRIQUE_COMM_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "RUBRIQUE_COMM_ID_seq"
    START WITH 10
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_COMM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10876 (class 0 OID 0)
-- Dependencies: 2786
-- Name: RUBRIQUE_COMM_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "RUBRIQUE_COMM_ID_seq" OWNED BY "RUBRIQUE_COMM"."ID";


--
-- TOC entry 10877 (class 0 OID 0)
-- Dependencies: 2786
-- Name: RUBRIQUE_COMM_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"RUBRIQUE_COMM_ID_seq"', 10, false);


--
-- TOC entry 2787 (class 1259 OID 529525)
-- Dependencies: 3883 3884 3885 3886 3887 3888 3889 3890 3891 3892 3893 3894 3895 9
-- Name: RUBRIQUE_COTISATION; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RUBRIQUE_COTISATION" (
    "ID" integer NOT NULL,
    "CODE" character varying DEFAULT ''::character varying NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ID_CAISSE_COTISATION" integer DEFAULT 1 NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TX_SAL" character varying(2048) DEFAULT ''::text NOT NULL,
    "TX_PAT" character varying(2048) DEFAULT ''::text NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "PART_CSG" boolean DEFAULT false NOT NULL,
    "BRUT" boolean DEFAULT false NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_COTISATION" OWNER TO openconcerto;

--
-- TOC entry 2788 (class 1259 OID 529544)
-- Dependencies: 2787 9
-- Name: RUBRIQUE_COTISATION_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "RUBRIQUE_COTISATION_ID_seq"
    START WITH 43
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_COTISATION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10878 (class 0 OID 0)
-- Dependencies: 2788
-- Name: RUBRIQUE_COTISATION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "RUBRIQUE_COTISATION_ID_seq" OWNED BY "RUBRIQUE_COTISATION"."ID";


--
-- TOC entry 10879 (class 0 OID 0)
-- Dependencies: 2788
-- Name: RUBRIQUE_COTISATION_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"RUBRIQUE_COTISATION_ID_seq"', 43, false);


--
-- TOC entry 2789 (class 1259 OID 529546)
-- Dependencies: 3897 3898 3899 3900 3901 3902 3903 3904 3905 3906 3907 3908 3909 9
-- Name: RUBRIQUE_NET; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RUBRIQUE_NET" (
    "ID" integer NOT NULL,
    "CODE" character varying DEFAULT ''::character varying NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "BASE" character varying(2048) DEFAULT ''::text NOT NULL,
    "TAUX" character varying(2048) DEFAULT ''::text NOT NULL,
    "MONTANT" character varying(2048) DEFAULT ''::text NOT NULL,
    "IMPOSABLE" boolean DEFAULT false NOT NULL,
    "FRAIS_PERS" boolean DEFAULT false NOT NULL,
    "BRUT" boolean DEFAULT false NOT NULL,
    "ID_PERIODE_VALIDITE" integer DEFAULT 1 NOT NULL,
    "ID_TYPE_RUBRIQUE_NET" integer DEFAULT 1 NOT NULL,
    "ID_IMPRESSION_RUBRIQUE" integer DEFAULT 1 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL
);


ALTER TABLE "Common"."RUBRIQUE_NET" OWNER TO openconcerto;

--
-- TOC entry 2790 (class 1259 OID 529565)
-- Dependencies: 2789 9
-- Name: RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "RUBRIQUE_NET_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."RUBRIQUE_NET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10880 (class 0 OID 0)
-- Dependencies: 2790
-- Name: RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "RUBRIQUE_NET_ID_seq" OWNED BY "RUBRIQUE_NET"."ID";


--
-- TOC entry 10881 (class 0 OID 0)
-- Dependencies: 2790
-- Name: RUBRIQUE_NET_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"RUBRIQUE_NET_ID_seq"', 6, false);


--
-- TOC entry 2791 (class 1259 OID 529567)
-- Dependencies: 3911 3912 3913 3914 9
-- Name: SERVICE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SERVICE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."SERVICE" OWNER TO openconcerto;

--
-- TOC entry 2792 (class 1259 OID 529577)
-- Dependencies: 2791 9
-- Name: SERVICE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."SERVICE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10882 (class 0 OID 0)
-- Dependencies: 2792
-- Name: SERVICE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "SERVICE_ID_seq" OWNED BY "SERVICE"."ID";


--
-- TOC entry 10883 (class 0 OID 0)
-- Dependencies: 2792
-- Name: SERVICE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"SERVICE_ID_seq"', 1, true);


--
-- TOC entry 2793 (class 1259 OID 529579)
-- Dependencies: 3916 3917 3918 3919 3920 3921 3922 3923 3924 3925 3926 3927 3928 3929 9
-- Name: SOCIETE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SOCIETE_COMMON" (
    "ID" integer NOT NULL,
    "DATABASE_NAME" character varying DEFAULT ''::character varying NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "NUM_SIRET" character varying DEFAULT ''::character varying NOT NULL,
    "NUM_NII" character varying DEFAULT ''::character varying NOT NULL,
    "NUM_APE" character varying DEFAULT ''::character varying NOT NULL,
    "ID_EXERCICE_COMMON" integer DEFAULT 1 NOT NULL,
    "NUM_TEL" character varying DEFAULT ''::character varying NOT NULL,
    "NUM_FAX" character varying DEFAULT ''::character varying NOT NULL,
    "MAIL" character varying DEFAULT ''::character varying NOT NULL,
    "ID_ADRESSE_COMMON" integer DEFAULT 1 NOT NULL,
    "TYPE" character varying DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "NUMERO_URSSAF" character varying DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Common"."SOCIETE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2794 (class 1259 OID 529599)
-- Dependencies: 2793 9
-- Name: SOCIETE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."SOCIETE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10884 (class 0 OID 0)
-- Dependencies: 2794
-- Name: SOCIETE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "SOCIETE_COMMON_ID_seq" OWNED BY "SOCIETE_COMMON"."ID";


--
-- TOC entry 10885 (class 0 OID 0)
-- Dependencies: 2794
-- Name: SOCIETE_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"SOCIETE_COMMON_ID_seq"', 48, true);


--
-- TOC entry 2795 (class 1259 OID 529601)
-- Dependencies: 3931 3932 3933 3934 9
-- Name: STOCK; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "STOCK" (
    "ID" integer NOT NULL,
    "QTE_REEL" real DEFAULT 0 NOT NULL,
    "QTE_TH" real DEFAULT 0 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."STOCK" OWNER TO openconcerto;

--
-- TOC entry 2796 (class 1259 OID 529608)
-- Dependencies: 2795 9
-- Name: STOCK_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10886 (class 0 OID 0)
-- Dependencies: 2796
-- Name: STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "STOCK_ID_seq" OWNED BY "STOCK"."ID";


--
-- TOC entry 10887 (class 0 OID 0)
-- Dependencies: 2796
-- Name: STOCK_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"STOCK_ID_seq"', 1, true);


--
-- TOC entry 2797 (class 1259 OID 529610)
-- Dependencies: 3936 3937 3938 3939 3940 3941 3942 3943 3944 3945 3946 9
-- Name: TACHE_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TACHE_COMMON" (
    "ID" integer NOT NULL,
    "PRIORITE" integer DEFAULT 0 NOT NULL,
    "FAIT" boolean DEFAULT false NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text NOT NULL,
    "DATE_ENTREE" timestamp without time zone,
    "DATE_FAIT" timestamp without time zone,
    "DATE_EXP" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_TO" integer DEFAULT 1 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "COMMENT" character varying(2048),
    "ID_USER_COMMON_ASSIGN_BY" integer DEFAULT 1,
    "ID_SOCIETE_COMMON" integer DEFAULT 1,
    "TYPE" character varying(128) DEFAULT ''::character varying,
    "COOKIE" character varying(128) DEFAULT ''::character varying
);


ALTER TABLE "Common"."TACHE_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2798 (class 1259 OID 529627)
-- Dependencies: 2797 9
-- Name: TACHE_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."TACHE_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10888 (class 0 OID 0)
-- Dependencies: 2798
-- Name: TACHE_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "TACHE_COMMON_ID_seq" OWNED BY "TACHE_COMMON"."ID";


--
-- TOC entry 10889 (class 0 OID 0)
-- Dependencies: 2798
-- Name: TACHE_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"TACHE_COMMON_ID_seq"', 704, true);


--
-- TOC entry 2799 (class 1259 OID 529629)
-- Dependencies: 3948 3949 3950 3951 9
-- Name: TACHE_LISTENER_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TACHE_LISTENER_COMMON" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_LISTENTO" integer DEFAULT 1 NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."TACHE_LISTENER_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2800 (class 1259 OID 529636)
-- Dependencies: 2799 9
-- Name: TACHE_LISTENER_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "TACHE_LISTENER_COMMON_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."TACHE_LISTENER_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10890 (class 0 OID 0)
-- Dependencies: 2800
-- Name: TACHE_LISTENER_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "TACHE_LISTENER_COMMON_ID_seq" OWNED BY "TACHE_LISTENER_COMMON"."ID";


--
-- TOC entry 10891 (class 0 OID 0)
-- Dependencies: 2800
-- Name: TACHE_LISTENER_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"TACHE_LISTENER_COMMON_ID_seq"', 4, false);


--
-- TOC entry 2801 (class 1259 OID 529638)
-- Dependencies: 3953 3954 3955 3956 3957 3958 3959 9
-- Name: TACHE_RIGHTS; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TACHE_RIGHTS" (
    "ID" integer NOT NULL,
    "ID_USER_COMMON" integer DEFAULT 1 NOT NULL,
    "ID_USER_COMMON_TO" integer DEFAULT 1 NOT NULL,
    "READ" boolean DEFAULT false NOT NULL,
    "MODIFY" boolean DEFAULT false NOT NULL,
    "ADD" boolean DEFAULT false NOT NULL,
    "VALIDATE" boolean DEFAULT false NOT NULL,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "Common"."TACHE_RIGHTS" OWNER TO openconcerto;

--
-- TOC entry 2802 (class 1259 OID 529648)
-- Dependencies: 2801 9
-- Name: TACHE_RIGHTS_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."TACHE_RIGHTS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10892 (class 0 OID 0)
-- Dependencies: 2802
-- Name: TACHE_RIGHTS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "TACHE_RIGHTS_ID_seq" OWNED BY "TACHE_RIGHTS"."ID";


--
-- TOC entry 10893 (class 0 OID 0)
-- Dependencies: 2802
-- Name: TACHE_RIGHTS_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"TACHE_RIGHTS_ID_seq"', 34, true);


--
-- TOC entry 2803 (class 1259 OID 529650)
-- Dependencies: 3961 3962 3963 9
-- Name: TYPE_RUBRIQUE_BRUT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TYPE_RUBRIQUE_BRUT" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 1 NOT NULL
);


ALTER TABLE "Common"."TYPE_RUBRIQUE_BRUT" OWNER TO openconcerto;

--
-- TOC entry 2804 (class 1259 OID 529659)
-- Dependencies: 2803 9
-- Name: TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "TYPE_RUBRIQUE_BRUT_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_RUBRIQUE_BRUT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10894 (class 0 OID 0)
-- Dependencies: 2804
-- Name: TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "TYPE_RUBRIQUE_BRUT_ID_seq" OWNED BY "TYPE_RUBRIQUE_BRUT"."ID";


--
-- TOC entry 10895 (class 0 OID 0)
-- Dependencies: 2804
-- Name: TYPE_RUBRIQUE_BRUT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"TYPE_RUBRIQUE_BRUT_ID_seq"', 6, false);


--
-- TOC entry 2805 (class 1259 OID 529661)
-- Dependencies: 3965 3966 3967 9
-- Name: TYPE_RUBRIQUE_NET; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TYPE_RUBRIQUE_NET" (
    "ID" integer NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."TYPE_RUBRIQUE_NET" OWNER TO openconcerto;

--
-- TOC entry 2806 (class 1259 OID 529670)
-- Dependencies: 2805 9
-- Name: TYPE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "TYPE_RUBRIQUE_NET_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."TYPE_RUBRIQUE_NET_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10896 (class 0 OID 0)
-- Dependencies: 2806
-- Name: TYPE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "TYPE_RUBRIQUE_NET_ID_seq" OWNED BY "TYPE_RUBRIQUE_NET"."ID";


--
-- TOC entry 10897 (class 0 OID 0)
-- Dependencies: 2806
-- Name: TYPE_RUBRIQUE_NET_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"TYPE_RUBRIQUE_NET_ID_seq"', 5, false);


--
-- TOC entry 2807 (class 1259 OID 529672)
-- Dependencies: 3969 3970 3971 3972 3973 3974 3975 3976 3977 3978 9
-- Name: USER_COMMON; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "USER_COMMON" (
    "ID" integer NOT NULL,
    "LOGIN" character varying DEFAULT ''::character varying NOT NULL,
    "PASSWORD" character varying DEFAULT ''::character varying NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying DEFAULT ''::character varying NOT NULL,
    "SURNOM" character varying DEFAULT ''::character varying NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "SUPERUSER" boolean DEFAULT false,
    "ADMIN" boolean DEFAULT false,
    "MAIL" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Common"."USER_COMMON" OWNER TO openconcerto;

--
-- TOC entry 2808 (class 1259 OID 529688)
-- Dependencies: 2807 9
-- Name: USER_COMMON_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."USER_COMMON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10898 (class 0 OID 0)
-- Dependencies: 2808
-- Name: USER_COMMON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "USER_COMMON_ID_seq" OWNED BY "USER_COMMON"."ID";


--
-- TOC entry 10899 (class 0 OID 0)
-- Dependencies: 2808
-- Name: USER_COMMON_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"USER_COMMON_ID_seq"', 15, true);


--
-- TOC entry 2809 (class 1259 OID 529690)
-- Dependencies: 3979 3980 3981 3983 3984 3985 9
-- Name: USER_RIGHT; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "USER_RIGHT" (
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON" integer DEFAULT 1,
    "HAVE_RIGHT" boolean,
    "CODE" character varying(128) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "DESCRIPTION" character varying(500) DEFAULT ''::character varying,
    "ID_RIGHT" integer DEFAULT 1,
    "OBJECT" character varying(256)
);


ALTER TABLE "Common"."USER_RIGHT" OWNER TO openconcerto;

--
-- TOC entry 2810 (class 1259 OID 529702)
-- Dependencies: 2809 9
-- Name: USER_RIGHT_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."USER_RIGHT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10900 (class 0 OID 0)
-- Dependencies: 2810
-- Name: USER_RIGHT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "USER_RIGHT_ID_seq" OWNED BY "USER_RIGHT"."ID";


--
-- TOC entry 10901 (class 0 OID 0)
-- Dependencies: 2810
-- Name: USER_RIGHT_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"USER_RIGHT_ID_seq"', 19, true);


--
-- TOC entry 2811 (class 1259 OID 529704)
-- Dependencies: 3987 3988 3989 3990 3991 3992 3993 9
-- Name: VARIABLE_PAYE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "VARIABLE_PAYE" (
    "ID" integer NOT NULL,
    "VALEUR" real DEFAULT 0 NOT NULL,
    "FORMULE" character varying(2048) DEFAULT ''::text NOT NULL,
    "NOM" character varying DEFAULT ''::character varying NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CATEGORIE" character varying DEFAULT ''::character varying NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::text NOT NULL
);


ALTER TABLE "Common"."VARIABLE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2812 (class 1259 OID 529717)
-- Dependencies: 2811 9
-- Name: VARIABLE_PAYE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

CREATE SEQUENCE "VARIABLE_PAYE_ID_seq"
    START WITH 51
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Common"."VARIABLE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10902 (class 0 OID 0)
-- Dependencies: 2812
-- Name: VARIABLE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "VARIABLE_PAYE_ID_seq" OWNED BY "VARIABLE_PAYE"."ID";


--
-- TOC entry 10903 (class 0 OID 0)
-- Dependencies: 2812
-- Name: VARIABLE_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"VARIABLE_PAYE_ID_seq"', 51, false);


--
-- TOC entry 2813 (class 1259 OID 529719)
-- Dependencies: 3995 3996 3997 3998 3999 9
-- Name: VILLE; Type: TABLE; Schema: Common; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "VILLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048),
    "CODE_POSTAL" character varying(2048),
    "X_LAMBERT" bigint DEFAULT 0,
    "Y_LAMBERT" bigint DEFAULT 0,
    "POPULATION" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0
);


ALTER TABLE "Common"."VILLE" OWNER TO openconcerto;

--
-- TOC entry 2814 (class 1259 OID 529730)
-- Dependencies: 2813 9
-- Name: VILLE_ID_seq; Type: SEQUENCE; Schema: Common; Owner: openconcerto
--

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


ALTER TABLE "Common"."VILLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10904 (class 0 OID 0)
-- Dependencies: 2814
-- Name: VILLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Common; Owner: openconcerto
--

ALTER SEQUENCE "VILLE_ID_seq" OWNED BY "VILLE"."ID";


--
-- TOC entry 10905 (class 0 OID 0)
-- Dependencies: 2814
-- Name: VILLE_ID_seq; Type: SEQUENCE SET; Schema: Common; Owner: openconcerto
--

SELECT pg_catalog.setval('"VILLE_ID_seq"', 117, true);



--
-- TOC entry 2815 (class 1259 OID 529732)
-- Dependencies: 4001 4002 4003 4004 4005 4006 10
-- Name: ACOMPTE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ACOMPTE" (
    "ID" integer NOT NULL,
    "ID_SALARIE" integer DEFAULT 1,
    "MONTANT" real DEFAULT 0,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ACOMPTE" OWNER TO openconcerto;

--
-- TOC entry 2816 (class 1259 OID 529741)
-- Dependencies: 2815 10
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ACOMPTE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ACOMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10906 (class 0 OID 0)
-- Dependencies: 2816
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ACOMPTE_ID_seq" OWNED BY "ACOMPTE"."ID";


--
-- TOC entry 10907 (class 0 OID 0)
-- Dependencies: 2816
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ACOMPTE_ID_seq"', 2, false);


--
-- TOC entry 2817 (class 1259 OID 529743)
-- Dependencies: 4007 4009 4010 4011 4012 4013 4014 4015 4016 4017 10
-- Name: ADRESSE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ADRESSE" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_ADRESSE" integer NOT NULL,
    "RUE" character varying(2048) DEFAULT ''::text,
    "CODE_POSTAL" integer DEFAULT 0,
    "PAYS" character varying(100) DEFAULT ''::character varying,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "HAS_CEDEX" boolean DEFAULT false,
    "CEDEX" integer,
    "DEST" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_CLIENT" integer DEFAULT 1
);


ALTER TABLE "Default"."ADRESSE" OWNER TO openconcerto;

--
-- TOC entry 2818 (class 1259 OID 529759)
-- Dependencies: 2817 10
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ADRESSE_ID_ADRESSE_seq"
    START WITH 9
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ADRESSE_ID_ADRESSE_seq" OWNER TO openconcerto;

--
-- TOC entry 10908 (class 0 OID 0)
-- Dependencies: 2818
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ADRESSE_ID_ADRESSE_seq" OWNED BY "ADRESSE"."ID_ADRESSE";


--
-- TOC entry 10909 (class 0 OID 0)
-- Dependencies: 2818
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ADRESSE_ID_ADRESSE_seq"', 9, false);


--
-- TOC entry 2819 (class 1259 OID 529761)
-- Dependencies: 4019 4020 4021 4022 4023 4024 10
-- Name: AFFACTURAGE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AFFACTURAGE" (
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "DATE" date,
    "NB_FACT" integer DEFAULT 0,
    "MONTANT_FACT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."AFFACTURAGE" OWNER TO openconcerto;

--
-- TOC entry 2820 (class 1259 OID 529770)
-- Dependencies: 2819 10
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."AFFACTURAGE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10910 (class 0 OID 0)
-- Dependencies: 2820
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "AFFACTURAGE_ID_seq" OWNED BY "AFFACTURAGE"."ID";


--
-- TOC entry 10911 (class 0 OID 0)
-- Dependencies: 2820
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"AFFACTURAGE_ID_seq"', 1, true);


--
-- TOC entry 2821 (class 1259 OID 529837)
-- Dependencies: 4026 4027 4028 4029 4030 4031 4032 4033 4034 4035 4036 4037 4038 4039 4040 4041 4042 4043 4044 4045 4046 4047 4048 4049 4050 4051 4052 10
-- Name: ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ARTICLE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PA_HT" bigint DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CREATION_AUTO" boolean DEFAULT false,
    "PV_TTC" bigint DEFAULT 0,
    "ID_STOCK" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false NOT NULL,
    "OBSOLETE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 2822 (class 1259 OID 529870)
-- Dependencies: 2821 10
-- Name: ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ARTICLE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10912 (class 0 OID 0)
-- Dependencies: 2822
-- Name: ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ARTICLE_ID_seq" OWNED BY "ARTICLE"."ID";


--
-- TOC entry 10913 (class 0 OID 0)
-- Dependencies: 2822
-- Name: ARTICLE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ARTICLE_ID_seq"', 2, false);


--
-- TOC entry 2823 (class 1259 OID 529872)
-- Dependencies: 4054 4055 4056 4057 4058 4059 10
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ASSOCIATION_COMPTE_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_AXE_ANALYTIQUE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_REPARTITION_ANALYTIQUE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ASSOCIATION_COMPTE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 2824 (class 1259 OID 529881)
-- Dependencies: 2823 10
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10914 (class 0 OID 0)
-- Dependencies: 2824
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNED BY "ASSOCIATION_COMPTE_ANALYTIQUE"."ID";


--
-- TOC entry 10915 (class 0 OID 0)
-- Dependencies: 2824
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 2825 (class 1259 OID 529892)
-- Dependencies: 4061 4062 4063 4064 4065 4066 4067 4068 4069 4070 4071 4072 4073 4074 4075 4076 4077 4078 4079 4080 4081 4082 4083 4084 4085 4086 4087 10
-- Name: AVOIR_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "DATE" date,
    "MONTANT_TTC" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "MONTANT_TVA" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "SOLDE" boolean DEFAULT false,
    "A_DEDUIRE" boolean DEFAULT false,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "DATE_ENVOI_AFFACTURAGE" date,
    "AFFACTURAGE" boolean DEFAULT false,
    "MONTANT_SOLDE" bigint DEFAULT 0,
    "MONTANT_RESTANT" bigint DEFAULT 0,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "ID_CONTACT" integer DEFAULT 1,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "MOTIF" character varying DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "AFFACTURE" boolean DEFAULT false
);


ALTER TABLE "Default"."AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2826 (class 1259 OID 529926)
-- Dependencies: 4089 4090 4091 4092 4093 4094 4095 4096 4097 4098 4099 4100 4101 4102 4103 4104 4105 4106 4107 4108 4109 4110 4111 4112 4113 4114 4115 4116 4117 4118 4119 4120 4121 4122 4123 4124 4125 4126 4127 4128 4129 4130 4131 4132 4133 4134 4135 4136 4137 4138 4139 10
-- Name: AVOIR_CLIENT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_CLIENT_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PA_HT" bigint DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "QTE" integer DEFAULT 1,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "TARIF_Q18_HT" bigint DEFAULT 0,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "Q18" boolean DEFAULT false,
    "ID_CONTACT" integer DEFAULT 1,
    "INDICE_0" bigint DEFAULT 0,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "INDICE_N" bigint DEFAULT 0,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "MONTANT_INITIAL" bigint DEFAULT 0,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "DATE_FIN" timestamp without time zone,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "DATE" timestamp without time zone,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ACOMPTE" boolean DEFAULT false,
    "POURCENT_ACOMPTE" numeric DEFAULT 100,
    "POURCENT_REMISE" numeric DEFAULT 0,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Default"."AVOIR_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2827 (class 1259 OID 529985)
-- Dependencies: 2826 10
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."AVOIR_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10916 (class 0 OID 0)
-- Dependencies: 2827
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_CLIENT_ELEMENT_ID_seq" OWNED BY "AVOIR_CLIENT_ELEMENT"."ID";


--
-- TOC entry 10917 (class 0 OID 0)
-- Dependencies: 2827
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_CLIENT_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2828 (class 1259 OID 529987)
-- Dependencies: 2825 10
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "AVOIR_CLIENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10918 (class 0 OID 0)
-- Dependencies: 2828
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_CLIENT_ID_seq" OWNED BY "AVOIR_CLIENT"."ID";


--
-- TOC entry 10919 (class 0 OID 0)
-- Dependencies: 2828
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_CLIENT_ID_seq"', 2, false);


--
-- TOC entry 2829 (class 1259 OID 529989)
-- Dependencies: 4141 4142 4143 4144 4145 4146 4147 4148 4149 4150 4151 4152 4153 4154 4155 10
-- Name: AVOIR_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "DATE" date,
    "SOLDE" boolean DEFAULT false,
    "A_DEDUIRE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_TAXE" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "MONTANT_TVA" bigint DEFAULT 0,
    "MONTANT_TTC" bigint DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "IMMO" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."AVOIR_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 2830 (class 1259 OID 530010)
-- Dependencies: 2829 10
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."AVOIR_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10920 (class 0 OID 0)
-- Dependencies: 2830
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_FOURNISSEUR_ID_seq" OWNED BY "AVOIR_FOURNISSEUR"."ID";


--
-- TOC entry 10921 (class 0 OID 0)
-- Dependencies: 2830
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_FOURNISSEUR_ID_seq"', 1, true);


--
-- TOC entry 2831 (class 1259 OID 530012)
-- Dependencies: 4156 4158 4159 4160 10
-- Name: AXE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AXE_ANALYTIQUE" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."AXE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 2832 (class 1259 OID 530022)
-- Dependencies: 2831 10
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "AXE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."AXE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10922 (class 0 OID 0)
-- Dependencies: 2832
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "AXE_ANALYTIQUE_ID_seq" OWNED BY "AXE_ANALYTIQUE"."ID";


--
-- TOC entry 10923 (class 0 OID 0)
-- Dependencies: 2832
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"AXE_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 2833 (class 1259 OID 530024)
-- Dependencies: 4162 4163 4164 4165 4166 4167 4168 4169 4170 4171 4172 4173 4174 4175 4176 4177 4178 4179 4180 4181 4182 10
-- Name: BANQUE_POLE_PRODUIT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BANQUE_POLE_PRODUIT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "NUMERO_RUE" character varying(2048) DEFAULT ''::text,
    "VOIE" character varying(2048) DEFAULT ''::text,
    "RUE" character varying(2048) DEFAULT ''::text,
    "CODE_POSTAL" character varying(2048) DEFAULT ''::text,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "CODE_ETS" character varying(2048) DEFAULT ''::text,
    "CODE_GUICHET" character varying(2048) DEFAULT ''::text,
    "NUMERO_COMPTE" character varying(2048) DEFAULT ''::text,
    "CLE_RICE" character varying(2048) DEFAULT ''::text,
    "DOMICILIATION" character varying(2048) DEFAULT ''::text,
    "BIC" character varying(2048) DEFAULT ''::text,
    "IBAN" character varying(2048) DEFAULT ''::text,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ID_POLE_PRODUIT" integer DEFAULT 1,
    "ID_JOURNAL" integer DEFAULT 1,
    "AFFACTURAGE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE" integer DEFAULT 1
);


ALTER TABLE "Default"."BANQUE_POLE_PRODUIT" OWNER TO openconcerto;

--
-- TOC entry 2834 (class 1259 OID 530051)
-- Dependencies: 2833 10
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."BANQUE_POLE_PRODUIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10924 (class 0 OID 0)
-- Dependencies: 2834
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "BANQUE_POLE_PRODUIT_ID_seq" OWNED BY "BANQUE_POLE_PRODUIT"."ID";


--
-- TOC entry 10925 (class 0 OID 0)
-- Dependencies: 2834
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"BANQUE_POLE_PRODUIT_ID_seq"', 1, true);


--
-- TOC entry 2835 (class 1259 OID 530053)
-- Dependencies: 4183 4185 4186 4187 4188 4189 4190 4191 4192 4193 4194 10
-- Name: BON_DE_LIVRAISON; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_DE_LIVRAISON" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "DATE" date,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_CLIENT" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "TOTAL_HT" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_POIDS" real DEFAULT 0,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."BON_DE_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 2836 (class 1259 OID 530070)
-- Dependencies: 4195 4196 4197 4199 4200 4201 4202 4203 4204 4205 4206 4207 4208 4209 4210 4211 4212 4213 4214 4215 4216 4217 4218 4219 4220 4221 4222 4223 4224 4225 4226 4227 4228 4229 10
-- Name: BON_DE_LIVRAISON_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_DE_LIVRAISON_ELEMENT" (
    "ID_SAISIE_VENTE_FACTURE_ELEMENT" integer DEFAULT 1,
    "QTE_A_LIVRER" integer DEFAULT 0,
    "QTE_LIVREE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PV_HT" bigint DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "ID_METRIQUE_2" bigint DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "ID_STYLE" integer DEFAULT 1,
    "T_POIDS_LIVREE" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."BON_DE_LIVRAISON_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2837 (class 1259 OID 530110)
-- Dependencies: 2836 10
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "BON_DE_LIVRAISON_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."BON_DE_LIVRAISON_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10926 (class 0 OID 0)
-- Dependencies: 2837
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "BON_DE_LIVRAISON_ELEMENT_ID_seq" OWNED BY "BON_DE_LIVRAISON_ELEMENT"."ID";


--
-- TOC entry 10927 (class 0 OID 0)
-- Dependencies: 2837
-- Name: BON_DE_LIVRAISON_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"BON_DE_LIVRAISON_ELEMENT_ID_seq"', 2, false);


--
-- TOC entry 2838 (class 1259 OID 530112)
-- Dependencies: 2835 10
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "BON_DE_LIVRAISON_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."BON_DE_LIVRAISON_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10928 (class 0 OID 0)
-- Dependencies: 2838
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "BON_DE_LIVRAISON_ID_seq" OWNED BY "BON_DE_LIVRAISON"."ID";


--
-- TOC entry 10929 (class 0 OID 0)
-- Dependencies: 2838
-- Name: BON_DE_LIVRAISON_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"BON_DE_LIVRAISON_ID_seq"', 2, false);


--
-- TOC entry 2839 (class 1259 OID 530114)
-- Dependencies: 4231 4232 4233 4234 4235 4236 4237 4238 4239 4240 10
-- Name: BON_RECEPTION; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_RECEPTION" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "TOTAL_HT" bigint DEFAULT 0,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_POIDS" real DEFAULT 0,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_COMMANDE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."BON_RECEPTION" OWNER TO openconcerto;

--
-- TOC entry 2840 (class 1259 OID 530130)
-- Dependencies: 4242 4243 4244 4245 4246 4247 4248 4249 4250 4251 4252 4253 4254 4255 4256 4257 4258 4259 4260 4261 4262 4263 4264 4265 4266 4267 4268 4269 4270 4271 4272 10
-- Name: BON_RECEPTION_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_RECEPTION_ELEMENT" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "QTE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ID_BON_RECEPTION" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "ID_STYLE" integer DEFAULT 1,
    "PV_HT" bigint DEFAULT 0,
    "T_PA_TTC" bigint DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."BON_RECEPTION_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2841 (class 1259 OID 530167)
-- Dependencies: 2840 10
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."BON_RECEPTION_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10930 (class 0 OID 0)
-- Dependencies: 2841
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "BON_RECEPTION_ELEMENT_ID_seq" OWNED BY "BON_RECEPTION_ELEMENT"."ID";


--
-- TOC entry 10931 (class 0 OID 0)
-- Dependencies: 2841
-- Name: BON_RECEPTION_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"BON_RECEPTION_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2842 (class 1259 OID 530169)
-- Dependencies: 2839 10
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."BON_RECEPTION_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10932 (class 0 OID 0)
-- Dependencies: 2842
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "BON_RECEPTION_ID_seq" OWNED BY "BON_RECEPTION"."ID";


--
-- TOC entry 10933 (class 0 OID 0)
-- Dependencies: 2842
-- Name: BON_RECEPTION_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"BON_RECEPTION_ID_seq"', 1, true);


--
-- TOC entry 2843 (class 1259 OID 530171)
-- Dependencies: 4273 4274 4275 4276 10
-- Name: CAISSE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CAISSE" (
    "NOM" character varying(2048) DEFAULT ''::text,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID" integer NOT NULL
);


ALTER TABLE "Default"."CAISSE" OWNER TO openconcerto;

--
-- TOC entry 2844 (class 1259 OID 530181)
-- Dependencies: 2843 10
-- Name: CAISSE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."CAISSE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10934 (class 0 OID 0)
-- Dependencies: 2844
-- Name: CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CAISSE_ID_seq" OWNED BY "CAISSE"."ID";


--
-- TOC entry 10935 (class 0 OID 0)
-- Dependencies: 2844
-- Name: CAISSE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CAISSE_ID_seq"', 1, true);


--
-- TOC entry 2845 (class 1259 OID 530183)
-- Dependencies: 4279 4280 4281 4282 4283 4284 4285 4286 4287 4288 10
-- Name: CHEQUE_AVOIR_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CHEQUE_AVOIR_CLIENT" (
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0 NOT NULL,
    "DECAISSE" boolean DEFAULT false NOT NULL,
    "ID_MOUVEMENT" integer DEFAULT 1 NOT NULL,
    "DATE_AVOIR" date,
    "DATE_MIN_DECAISSE" date,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE_DECAISSE" date,
    "ID_BANQUE_POLE_PRODUIT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "REG_COMPTA" boolean DEFAULT false
);


ALTER TABLE "Default"."CHEQUE_AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2846 (class 1259 OID 530199)
-- Dependencies: 2845 10
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."CHEQUE_AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10936 (class 0 OID 0)
-- Dependencies: 2846
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CHEQUE_AVOIR_CLIENT_ID_seq" OWNED BY "CHEQUE_AVOIR_CLIENT"."ID";


--
-- TOC entry 10937 (class 0 OID 0)
-- Dependencies: 2846
-- Name: CHEQUE_AVOIR_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CHEQUE_AVOIR_CLIENT_ID_seq"', 1, true);


--
-- TOC entry 2847 (class 1259 OID 530201)
-- Dependencies: 4290 4291 4292 4293 4294 4295 4296 4297 4298 10
-- Name: CHEQUE_A_ENCAISSER; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CHEQUE_A_ENCAISSER" (
    "ID" integer NOT NULL,
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "ENCAISSE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "DATE_MIN_DEPOT" date,
    "DATE_VENTE" date,
    "DATE_DEPOT" date,
    "ID_BANQUE_POLE_PRODUIT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "REG_COMPTA" boolean DEFAULT false
);


ALTER TABLE "Default"."CHEQUE_A_ENCAISSER" OWNER TO openconcerto;

--
-- TOC entry 2848 (class 1259 OID 530216)
-- Dependencies: 2847 10
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CHEQUE_A_ENCAISSER_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CHEQUE_A_ENCAISSER_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10938 (class 0 OID 0)
-- Dependencies: 2848
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CHEQUE_A_ENCAISSER_ID_seq" OWNED BY "CHEQUE_A_ENCAISSER"."ID";


--
-- TOC entry 10939 (class 0 OID 0)
-- Dependencies: 2848
-- Name: CHEQUE_A_ENCAISSER_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CHEQUE_A_ENCAISSER_ID_seq"', 2, false);


--
-- TOC entry 2849 (class 1259 OID 530218)
-- Dependencies: 4299 4301 4302 4303 4304 4305 4306 4307 4308 10
-- Name: CHEQUE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CHEQUE_FOURNISSEUR" (
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "DECAISSE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "DATE_ACHAT" date,
    "DATE_MIN_DECAISSE" date,
    "DATE_DECAISSE" date,
    "ID_BANQUE_POLE_PRODUIT" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "REG_COMPTA" boolean DEFAULT false
);


ALTER TABLE "Default"."CHEQUE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 2850 (class 1259 OID 530233)
-- Dependencies: 2849 10
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CHEQUE_FOURNISSEUR_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CHEQUE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10940 (class 0 OID 0)
-- Dependencies: 2850
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CHEQUE_FOURNISSEUR_ID_seq" OWNED BY "CHEQUE_FOURNISSEUR"."ID";


--
-- TOC entry 10941 (class 0 OID 0)
-- Dependencies: 2850
-- Name: CHEQUE_FOURNISSEUR_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CHEQUE_FOURNISSEUR_ID_seq"', 2, false);


--
-- TOC entry 2851 (class 1259 OID 530235)
-- Dependencies: 4310 4311 4312 4313 4314 4315 4316 4317 10
-- Name: CLASSEMENT_CONVENTIONNEL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CLASSEMENT_CONVENTIONNEL" (
    "ID" integer NOT NULL,
    "NIVEAU" character varying(45) DEFAULT ''::character varying,
    "COEFF" character varying(45) DEFAULT ''::character varying,
    "INDICE" character varying(45) DEFAULT ''::character varying,
    "POSITION" character varying(45) DEFAULT ''::character varying,
    "ECHELON" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CLASSEMENT_CONVENTIONNEL" OWNER TO openconcerto;

--
-- TOC entry 2852 (class 1259 OID 530246)
-- Dependencies: 2851 10
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CLASSEMENT_CONVENTIONNEL_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CLASSEMENT_CONVENTIONNEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10942 (class 0 OID 0)
-- Dependencies: 2852
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CLASSEMENT_CONVENTIONNEL_ID_seq" OWNED BY "CLASSEMENT_CONVENTIONNEL"."ID";


--
-- TOC entry 10943 (class 0 OID 0)
-- Dependencies: 2852
-- Name: CLASSEMENT_CONVENTIONNEL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CLASSEMENT_CONVENTIONNEL_ID_seq"', 2, false);


--
-- TOC entry 2853 (class 1259 OID 530248)
-- Dependencies: 4319 4320 4321 4322 4323 10
-- Name: CLASSE_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CLASSE_COMPTE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "TYPE_NUMERO_COMPTE" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CLASSE_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 2854 (class 1259 OID 530259)
-- Dependencies: 2853 10
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CLASSE_COMPTE_ID_seq"
    START WITH 12
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CLASSE_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10944 (class 0 OID 0)
-- Dependencies: 2854
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CLASSE_COMPTE_ID_seq" OWNED BY "CLASSE_COMPTE"."ID";


--
-- TOC entry 10945 (class 0 OID 0)
-- Dependencies: 2854
-- Name: CLASSE_COMPTE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CLASSE_COMPTE_ID_seq"', 12, false);


--
-- TOC entry 2855 (class 1259 OID 530261)
-- Dependencies: 4325 4326 4327 4328 4329 4330 4331 4332 4333 4334 4335 4336 4337 4338 4339 4340 4341 4342 4343 4344 4345 4346 4347 4348 4349 4350 4351 4352 4353 4354 4355 4356 4357 4358 10
-- Name: CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CLIENT" (
    "ID" integer NOT NULL,
    "FORME_JURIDIQUE" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "TEL" character varying(100) DEFAULT ''::character varying,
    "MAIL" character varying(100) DEFAULT ''::character varying,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "NUMERO_TVA" character varying(100) DEFAULT ''::character varying,
    "ID_ADRESSE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "RESPONSABLE" character varying(100) DEFAULT ''::character varying,
    "ID_ADRESSE_L" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "TEL_P" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE_TECH" character varying(100) DEFAULT ''::character varying,
    "TEL_P_TECH" character varying(100) DEFAULT ''::character varying,
    "TEL_TECH" character varying(100) DEFAULT ''::character varying,
    "MAIL_TECH" character varying(100) DEFAULT ''::character varying,
    "RESPONSABLE_COM" character varying(100) DEFAULT ''::character varying,
    "TEL_P_COM" character varying(100) DEFAULT ''::character varying,
    "MAIL_COM" character varying(100) DEFAULT ''::character varying,
    "TEL_COM" character varying(100) DEFAULT ''::character varying,
    "ID_MODE_REGLEMENT" integer DEFAULT 1 NOT NULL,
    "ID_ADRESSE_F" integer DEFAULT 1,
    "FAX_TECH" character varying(100) DEFAULT ''::character varying,
    "FAX_COM" character varying(100) DEFAULT ''::character varying,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "SIRET" character varying(2048) DEFAULT ''::text,
    "RIB" character varying(2048) DEFAULT ''::text,
    "MARCHE_PUBLIC" boolean DEFAULT false,
    "MARCHE_PRIVE" boolean DEFAULT false,
    "AFFACTURAGE" boolean DEFAULT false,
    "MAX_FACTURE" bigint DEFAULT 0,
    "COMPTANT" boolean DEFAULT false,
    "COMPTE_CLIENT_AUTO" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2856 (class 1259 OID 530304)
-- Dependencies: 2855 10
-- Name: CLIENT_ID_CLIENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CLIENT_ID_CLIENT_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CLIENT_ID_CLIENT_seq" OWNER TO openconcerto;

--
-- TOC entry 10946 (class 0 OID 0)
-- Dependencies: 2856
-- Name: CLIENT_ID_CLIENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CLIENT_ID_CLIENT_seq" OWNED BY "CLIENT"."ID";


--
-- TOC entry 10947 (class 0 OID 0)
-- Dependencies: 2856
-- Name: CLIENT_ID_CLIENT_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CLIENT_ID_CLIENT_seq"', 2, false);


--
-- TOC entry 2857 (class 1259 OID 530306)
-- Dependencies: 4360 4361 4362 4363 4364 10
-- Name: CODE_CARACT_ACTIVITE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_CARACT_ACTIVITE" (
    "ID" integer NOT NULL,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_CARACT_ACTIVITE" OWNER TO openconcerto;

--
-- TOC entry 2858 (class 1259 OID 530314)
-- Dependencies: 2857 10
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_CARACT_ACTIVITE_ID_seq"
    START WITH 12
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_CARACT_ACTIVITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10948 (class 0 OID 0)
-- Dependencies: 2858
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_CARACT_ACTIVITE_ID_seq" OWNED BY "CODE_CARACT_ACTIVITE"."ID";


--
-- TOC entry 10949 (class 0 OID 0)
-- Dependencies: 2858
-- Name: CODE_CARACT_ACTIVITE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_CARACT_ACTIVITE_ID_seq"', 12, false);


--
-- TOC entry 2859 (class 1259 OID 530316)
-- Dependencies: 4366 4367 4368 4369 4370 10
-- Name: CODE_CONTRAT_TRAVAIL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_CONTRAT_TRAVAIL" (
    "ID" integer NOT NULL,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "NOM" character varying(128) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_CONTRAT_TRAVAIL" OWNER TO openconcerto;

--
-- TOC entry 2860 (class 1259 OID 530324)
-- Dependencies: 2859 10
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_CONTRAT_TRAVAIL_ID_seq"
    START WITH 14
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_CONTRAT_TRAVAIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10950 (class 0 OID 0)
-- Dependencies: 2860
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_CONTRAT_TRAVAIL_ID_seq" OWNED BY "CODE_CONTRAT_TRAVAIL"."ID";


--
-- TOC entry 10951 (class 0 OID 0)
-- Dependencies: 2860
-- Name: CODE_CONTRAT_TRAVAIL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_CONTRAT_TRAVAIL_ID_seq"', 14, false);


--
-- TOC entry 2861 (class 1259 OID 530326)
-- Dependencies: 4372 4373 4374 4375 4376 10
-- Name: CODE_DROIT_CONTRAT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_DROIT_CONTRAT" (
    "ID" integer NOT NULL,
    "CODE" character varying(4) DEFAULT ''::character varying,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_DROIT_CONTRAT" OWNER TO openconcerto;

--
-- TOC entry 2862 (class 1259 OID 530334)
-- Dependencies: 2861 10
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_DROIT_CONTRAT_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_DROIT_CONTRAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10952 (class 0 OID 0)
-- Dependencies: 2862
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_DROIT_CONTRAT_ID_seq" OWNED BY "CODE_DROIT_CONTRAT"."ID";


--
-- TOC entry 10953 (class 0 OID 0)
-- Dependencies: 2862
-- Name: CODE_DROIT_CONTRAT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_DROIT_CONTRAT_ID_seq"', 4, false);


--
-- TOC entry 2863 (class 1259 OID 530336)
-- Dependencies: 4378 4379 4380 4381 4382 10
-- Name: CODE_EMPLOI; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_EMPLOI" (
    "ID" integer NOT NULL,
    "CODE" character varying(11) DEFAULT ''::character varying,
    "NOM" character varying(195) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_EMPLOI" OWNER TO openconcerto;

--
-- TOC entry 2864 (class 1259 OID 530344)
-- Dependencies: 2863 10
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_EMPLOI_ID_seq"
    START WITH 1036
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_EMPLOI_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10954 (class 0 OID 0)
-- Dependencies: 2864
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_EMPLOI_ID_seq" OWNED BY "CODE_EMPLOI"."ID";


--
-- TOC entry 10955 (class 0 OID 0)
-- Dependencies: 2864
-- Name: CODE_EMPLOI_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_EMPLOI_ID_seq"', 1036, false);


--
-- TOC entry 2865 (class 1259 OID 530365)
-- Dependencies: 4384 4385 4386 4387 4388 10
-- Name: CODE_REGIME; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_REGIME" (
    "ID" integer NOT NULL,
    "CODE" character varying(4) DEFAULT ''::character varying,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_REGIME" OWNER TO openconcerto;

--
-- TOC entry 2866 (class 1259 OID 530373)
-- Dependencies: 2865 10
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_REGIME_ID_seq"
    START WITH 23
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_REGIME_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10956 (class 0 OID 0)
-- Dependencies: 2866
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_REGIME_ID_seq" OWNED BY "CODE_REGIME"."ID";


--
-- TOC entry 10957 (class 0 OID 0)
-- Dependencies: 2866
-- Name: CODE_REGIME_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_REGIME_ID_seq"', 23, false);


--
-- TOC entry 2867 (class 1259 OID 530375)
-- Dependencies: 4390 4391 4392 4393 4394 10
-- Name: CODE_STATUT_CATEGORIEL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_STATUT_CATEGORIEL" (
    "ID" integer NOT NULL,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_STATUT_CATEGORIEL" OWNER TO openconcerto;

--
-- TOC entry 2868 (class 1259 OID 530383)
-- Dependencies: 2867 10
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_STATUT_CATEGORIEL_ID_seq"
    START WITH 6
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_STATUT_CATEGORIEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10958 (class 0 OID 0)
-- Dependencies: 2868
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_STATUT_CATEGORIEL_ID_seq" OWNED BY "CODE_STATUT_CATEGORIEL"."ID";


--
-- TOC entry 10959 (class 0 OID 0)
-- Dependencies: 2868
-- Name: CODE_STATUT_CATEGORIEL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_STATUT_CATEGORIEL_ID_seq"', 6, false);


--
-- TOC entry 2869 (class 1259 OID 530385)
-- Dependencies: 4396 4397 4398 4399 4400 10
-- Name: CODE_STATUT_PROF; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CODE_STATUT_PROF" (
    "ID" integer NOT NULL,
    "CODE" character varying(5) DEFAULT ''::character varying,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CODE_STATUT_PROF" OWNER TO openconcerto;

--
-- TOC entry 2870 (class 1259 OID 530393)
-- Dependencies: 2869 10
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CODE_STATUT_PROF_ID_seq"
    START WITH 51
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CODE_STATUT_PROF_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10960 (class 0 OID 0)
-- Dependencies: 2870
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CODE_STATUT_PROF_ID_seq" OWNED BY "CODE_STATUT_PROF"."ID";


--
-- TOC entry 10961 (class 0 OID 0)
-- Dependencies: 2870
-- Name: CODE_STATUT_PROF_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CODE_STATUT_PROF_ID_seq"', 51, false);


--
-- TOC entry 2871 (class 1259 OID 530395)
-- Dependencies: 4402 4403 4404 4405 4406 4407 4408 4409 4410 4411 4412 4413 4414 10
-- Name: COMMANDE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMMANDE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "DATE_ECHEANCE" date,
    "IDSOURCE" integer DEFAULT 1,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "T_SERVICE" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMMANDE" OWNER TO openconcerto;

--
-- TOC entry 2872 (class 1259 OID 530415)
-- Dependencies: 4415 4416 4417 4419 4420 4421 4422 4423 4424 4425 4426 4427 4428 4429 10
-- Name: COMMANDE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMMANDE_CLIENT" (
    "NOM" character varying(2048) DEFAULT ''::text,
    "SOURCE" character varying(100) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "DATE" date,
    "ID_CLIENT" integer DEFAULT 1,
    "DATE_ECHEANCE" date,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "T_SERVICE" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "T_POIDS" real DEFAULT 0,
    "ID_DEVIS" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMMANDE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2873 (class 1259 OID 530436)
-- Dependencies: 4431 4432 4433 4434 4435 4436 4437 4438 4439 4440 4441 4442 4443 4444 4445 4446 4447 4448 4449 4450 4451 4452 4453 4454 4455 4456 4457 4458 4459 4460 10
-- Name: COMMANDE_CLIENT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMMANDE_CLIENT_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" bigint DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "POIDS" real DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMMANDE_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2874 (class 1259 OID 530472)
-- Dependencies: 2873 10
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."COMMANDE_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10962 (class 0 OID 0)
-- Dependencies: 2874
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMMANDE_CLIENT_ELEMENT_ID_seq" OWNED BY "COMMANDE_CLIENT_ELEMENT"."ID";


--
-- TOC entry 10963 (class 0 OID 0)
-- Dependencies: 2874
-- Name: COMMANDE_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMMANDE_CLIENT_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2875 (class 1259 OID 530474)
-- Dependencies: 2872 10
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "COMMANDE_CLIENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."COMMANDE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10964 (class 0 OID 0)
-- Dependencies: 2875
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMMANDE_CLIENT_ID_seq" OWNED BY "COMMANDE_CLIENT"."ID";


--
-- TOC entry 10965 (class 0 OID 0)
-- Dependencies: 2875
-- Name: COMMANDE_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMMANDE_CLIENT_ID_seq"', 2, false);


--
-- TOC entry 2876 (class 1259 OID 530476)
-- Dependencies: 4462 4463 4464 4465 4466 4467 4468 4469 4470 4471 4472 4473 4474 4475 4476 4477 4478 4479 4480 4481 4482 4483 4484 4485 4486 4487 4488 4489 4490 4491 4492 10
-- Name: COMMANDE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMMANDE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::character varying,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" bigint DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "POIDS" real DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_COMMANDE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "T_PA_TTC" bigint DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMMANDE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2877 (class 1259 OID 530513)
-- Dependencies: 2876 10
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."COMMANDE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10966 (class 0 OID 0)
-- Dependencies: 2877
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMMANDE_ELEMENT_ID_seq" OWNED BY "COMMANDE_ELEMENT"."ID";


--
-- TOC entry 10967 (class 0 OID 0)
-- Dependencies: 2877
-- Name: COMMANDE_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMMANDE_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2878 (class 1259 OID 530515)
-- Dependencies: 2871 10
-- Name: COMMANDE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "COMMANDE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."COMMANDE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10968 (class 0 OID 0)
-- Dependencies: 2878
-- Name: COMMANDE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMMANDE_ID_seq" OWNED BY "COMMANDE"."ID";


--
-- TOC entry 10969 (class 0 OID 0)
-- Dependencies: 2878
-- Name: COMMANDE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMMANDE_ID_seq"', 2, false);


--
-- TOC entry 2879 (class 1259 OID 530517)
-- Dependencies: 4494 4495 4496 4497 4498 4499 4500 4501 4502 4503 4504 4505 10
-- Name: COMMERCIAL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMMERCIAL" (
    "ID_COMMERCIAL" integer NOT NULL,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "PRENOM" character varying(100) DEFAULT ''::character varying,
    "FONCTION" character varying(100) DEFAULT ''::character varying,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying,
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying,
    "FAX" character varying(100) DEFAULT ''::character varying,
    "EMAIL" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "ID_USER_COMMON" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMMERCIAL" OWNER TO openconcerto;

--
-- TOC entry 2880 (class 1259 OID 530535)
-- Dependencies: 2879 10
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."COMMERCIAL_ID_COMMERCIAL_seq" OWNER TO openconcerto;

--
-- TOC entry 10970 (class 0 OID 0)
-- Dependencies: 2880
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMMERCIAL_ID_COMMERCIAL_seq" OWNED BY "COMMERCIAL"."ID_COMMERCIAL";


--
-- TOC entry 10971 (class 0 OID 0)
-- Dependencies: 2880
-- Name: COMMERCIAL_ID_COMMERCIAL_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMMERCIAL_ID_COMMERCIAL_seq"', 2, true);


--
-- TOC entry 2881 (class 1259 OID 530537)
-- Dependencies: 4506 4507 4508 10
-- Name: COMPLETION; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMPLETION" (
    "CHAMP" character varying(100) DEFAULT ''::character varying,
    "LABEL" character varying(200) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8)
);


ALTER TABLE "Default"."COMPLETION" OWNER TO openconcerto;

--
-- TOC entry 2882 (class 1259 OID 530543)
-- Dependencies: 4510 4511 4512 4513 4514 4515 4516 4517 4518 4519 10
-- Name: COMPTE_PCE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMPTE_PCE" (
    "ID" integer NOT NULL,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "TOTAL_DEBIT" bigint DEFAULT 0,
    "TOTAL_CREDIT" bigint DEFAULT 0,
    "RACINE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMPTE_PCE" OWNER TO openconcerto;

--
-- TOC entry 2883 (class 1259 OID 530559)
-- Dependencies: 2882 10
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "COMPTE_PCE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."COMPTE_PCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10972 (class 0 OID 0)
-- Dependencies: 2883
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMPTE_PCE_ID_seq" OWNED BY "COMPTE_PCE"."ID";


--
-- TOC entry 10973 (class 0 OID 0)
-- Dependencies: 2883
-- Name: COMPTE_PCE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMPTE_PCE_ID_seq"', 2, false);


--
-- TOC entry 2884 (class 1259 OID 530561)
-- Dependencies: 4521 4522 4523 4524 4525 4526 4527 4528 4529 4530 10
-- Name: COMPTE_PCG; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COMPTE_PCG" (
    "ID" integer NOT NULL,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "INFOS" character varying(3072) DEFAULT ''::text,
    "ID_TYPE_COMPTE_PCG_BASE" integer DEFAULT 1,
    "ID_TYPE_COMPTE_PCG_AB" integer DEFAULT 1,
    "ID_TYPE_COMPTE_PCG_DEV" integer DEFAULT 1,
    "ID_NATURE_COMPTE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COMPTE_PCG" OWNER TO openconcerto;

--
-- TOC entry 2885 (class 1259 OID 530577)
-- Dependencies: 2884 10
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "COMPTE_PCG_ID_seq"
    START WITH 978
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."COMPTE_PCG_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10974 (class 0 OID 0)
-- Dependencies: 2885
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COMPTE_PCG_ID_seq" OWNED BY "COMPTE_PCG"."ID";


--
-- TOC entry 10975 (class 0 OID 0)
-- Dependencies: 2885
-- Name: COMPTE_PCG_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COMPTE_PCG_ID_seq"', 978, false);


--
-- TOC entry 2886 (class 1259 OID 530579)
-- Dependencies: 4532 4533 4534 4535 4536 4537 4538 4539 4540 4541 4542 4543 4544 4545 4546 10
-- Name: CONTACT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CONTACT" (
    "ID" integer NOT NULL,
    "NOM" character varying(100) DEFAULT ''::character varying NOT NULL,
    "PRENOM" character varying(100) DEFAULT ''::character varying NOT NULL,
    "TEL_DIRECT" character varying(100) DEFAULT ''::character varying NOT NULL,
    "TEL_MOBILE" character varying(100) DEFAULT ''::character varying NOT NULL,
    "EMAIL" character varying(100) DEFAULT ''::character varying NOT NULL,
    "FAX" character varying(100) DEFAULT ''::character varying NOT NULL,
    "ID_TITRE_PERSONNEL" integer DEFAULT 2 NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "FONCTION" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "TEL_STANDARD" character varying(100) DEFAULT ''::character varying NOT NULL,
    "TEL_PERSONEL" character varying(100) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."CONTACT" OWNER TO openconcerto;

--
-- TOC entry 2887 (class 1259 OID 530600)
-- Dependencies: 2886 10
-- Name: CONTACT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."CONTACT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10976 (class 0 OID 0)
-- Dependencies: 2887
-- Name: CONTACT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CONTACT_ID_seq" OWNED BY "CONTACT"."ID";


--
-- TOC entry 10977 (class 0 OID 0)
-- Dependencies: 2887
-- Name: CONTACT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CONTACT_ID_seq"', 1, true);


--
-- TOC entry 2888 (class 1259 OID 530602)
-- Dependencies: 4548 4549 4550 4551 4552 4553 4554 4555 4556 4557 10
-- Name: CONTRAT_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CONTRAT_SALARIE" (
    "ID" integer NOT NULL,
    "NATURE" character varying(2048) DEFAULT ''::text,
    "ID_CODE_EMPLOI" integer DEFAULT 1,
    "ID_CODE_CONTRAT_TRAVAIL" integer DEFAULT 1,
    "ID_CODE_DROIT_CONTRAT" integer DEFAULT 1,
    "ID_CODE_CARACT_ACTIVITE" integer DEFAULT 1,
    "ID_CODE_STATUT_PROF" integer DEFAULT 1,
    "ID_CODE_STATUT_CATEGORIEL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CONTRAT_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 2889 (class 1259 OID 530618)
-- Dependencies: 2888 10
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CONTRAT_SALARIE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CONTRAT_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10978 (class 0 OID 0)
-- Dependencies: 2889
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CONTRAT_SALARIE_ID_seq" OWNED BY "CONTRAT_SALARIE"."ID";


--
-- TOC entry 10979 (class 0 OID 0)
-- Dependencies: 2889
-- Name: CONTRAT_SALARIE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CONTRAT_SALARIE_ID_seq"', 2, false);


--
-- TOC entry 2890 (class 1259 OID 530620)
-- Dependencies: 4559 4560 4561 4562 4563 4564 4565 4566 10
-- Name: COURRIER_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "COURRIER_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "ID_MODELE_COURRIER_CLIENT" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."COURRIER_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2891 (class 1259 OID 530636)
-- Dependencies: 2890 10
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."COURRIER_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10980 (class 0 OID 0)
-- Dependencies: 2891
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "COURRIER_CLIENT_ID_seq" OWNED BY "COURRIER_CLIENT"."ID";


--
-- TOC entry 10981 (class 0 OID 0)
-- Dependencies: 2891
-- Name: COURRIER_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"COURRIER_CLIENT_ID_seq"', 1, true);


--
-- TOC entry 2892 (class 1259 OID 530638)
-- Dependencies: 4568 4569 4570 4571 4572 10
-- Name: CUMULS_CONGES; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CUMULS_CONGES" (
    "ID" integer NOT NULL,
    "RESTANT" real DEFAULT 0,
    "ACQUIS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CUMULS_CONGES" OWNER TO openconcerto;

--
-- TOC entry 2893 (class 1259 OID 530646)
-- Dependencies: 2892 10
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CUMULS_CONGES_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CUMULS_CONGES_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10982 (class 0 OID 0)
-- Dependencies: 2893
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CUMULS_CONGES_ID_seq" OWNED BY "CUMULS_CONGES"."ID";


--
-- TOC entry 10983 (class 0 OID 0)
-- Dependencies: 2893
-- Name: CUMULS_CONGES_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CUMULS_CONGES_ID_seq"', 2, false);


--
-- TOC entry 2894 (class 1259 OID 530648)
-- Dependencies: 4574 4575 4576 4577 4578 4579 4580 4581 4582 10
-- Name: CUMULS_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "CUMULS_PAYE" (
    "ID" integer NOT NULL,
    "SAL_BRUT_C" real DEFAULT 0,
    "COT_PAT_C" real DEFAULT 0,
    "COT_SAL_C" real DEFAULT 0,
    "NET_IMP_C" real DEFAULT 0,
    "NET_A_PAYER_C" real DEFAULT 0,
    "CSG_C" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."CUMULS_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2895 (class 1259 OID 530660)
-- Dependencies: 2894 10
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "CUMULS_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."CUMULS_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10984 (class 0 OID 0)
-- Dependencies: 2895
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "CUMULS_PAYE_ID_seq" OWNED BY "CUMULS_PAYE"."ID";


--
-- TOC entry 10985 (class 0 OID 0)
-- Dependencies: 2895
-- Name: CUMULS_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"CUMULS_PAYE_ID_seq"', 2, false);


--
-- TOC entry 2896 (class 1259 OID 530662)
-- Dependencies: 4584 4585 4586 4587 4588 4589 4590 10
-- Name: DEPARTEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "DEPARTEMENT" (
    "ID" integer NOT NULL,
    "NUMERO" character varying(10) DEFAULT ''::character varying,
    "NOM" character varying(100) DEFAULT ''::character varying,
    "CHEF_LIEU" character varying(100) DEFAULT ''::character varying,
    "REGION_ADMIN" character varying(100) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."DEPARTEMENT" OWNER TO openconcerto;

--
-- TOC entry 2897 (class 1259 OID 530672)
-- Dependencies: 2896 10
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "DEPARTEMENT_ID_seq"
    START WITH 102
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."DEPARTEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10986 (class 0 OID 0)
-- Dependencies: 2897
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "DEPARTEMENT_ID_seq" OWNED BY "DEPARTEMENT"."ID";


--
-- TOC entry 10987 (class 0 OID 0)
-- Dependencies: 2897
-- Name: DEPARTEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"DEPARTEMENT_ID_seq"', 102, false);


--
-- TOC entry 2898 (class 1259 OID 530674)
-- Dependencies: 4592 4593 4594 4595 4596 4597 4598 4599 4600 4601 4602 4603 4604 4605 4606 10
-- Name: DEVIS; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "DEVIS" (
    "ID_DEVIS" integer NOT NULL,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "OBJET" character varying(100) DEFAULT ''::character varying,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "T_SERVICE" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_ETAT_DEVIS" integer DEFAULT 1,
    "DATE_ENVOI" timestamp without time zone,
    "T_POIDS" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "ID_ADRESSE" integer DEFAULT 1
);


ALTER TABLE "Default"."DEVIS" OWNER TO openconcerto;

--
-- TOC entry 2899 (class 1259 OID 530696)
-- Dependencies: 4608 4609 4610 4611 4612 4613 4614 4615 4616 4617 4618 4619 4620 4621 4622 4623 4624 4625 4626 4627 4628 4629 4630 4631 4632 4633 4634 4635 4636 4637 10
-- Name: DEVIS_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "DEVIS_ELEMENT" (
    "ID_DEVIS_ELEMENT" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PA_HT" bigint DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "QTE" integer DEFAULT 1,
    "ID_DEVIS" integer DEFAULT 1,
    "SERVICE" boolean DEFAULT false,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."DEVIS_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2900 (class 1259 OID 530732)
-- Dependencies: 2899 10
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq" OWNER TO openconcerto;

--
-- TOC entry 10988 (class 0 OID 0)
-- Dependencies: 2900
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq" OWNED BY "DEVIS_ELEMENT"."ID_DEVIS_ELEMENT";


--
-- TOC entry 10989 (class 0 OID 0)
-- Dependencies: 2900
-- Name: DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"DEVIS_ELEMENT_ID_DEVIS_ELEMENT_seq"', 2, false);


--
-- TOC entry 2901 (class 1259 OID 530734)
-- Dependencies: 2898 10
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "DEVIS_ID_DEVIS_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."DEVIS_ID_DEVIS_seq" OWNER TO openconcerto;

--
-- TOC entry 10990 (class 0 OID 0)
-- Dependencies: 2901
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "DEVIS_ID_DEVIS_seq" OWNED BY "DEVIS"."ID_DEVIS";


--
-- TOC entry 10991 (class 0 OID 0)
-- Dependencies: 2901
-- Name: DEVIS_ID_DEVIS_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"DEVIS_ID_DEVIS_seq"', 2, false);


--
-- TOC entry 2902 (class 1259 OID 530736)
-- Dependencies: 4639 4640 4641 4642 4643 4644 4645 4646 4647 4648 4649 10
-- Name: ECHANTILLON_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ECHANTILLON_ELEMENT" (
    "ID" integer NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "NOM" character varying DEFAULT ''::character varying,
    "QTE" integer DEFAULT 1,
    "PV_HT" bigint DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ECHANTILLON_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2903 (class 1259 OID 530753)
-- Dependencies: 2902 10
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."ECHANTILLON_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10992 (class 0 OID 0)
-- Dependencies: 2903
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ECHANTILLON_ELEMENT_ID_seq" OWNED BY "ECHANTILLON_ELEMENT"."ID";


--
-- TOC entry 10993 (class 0 OID 0)
-- Dependencies: 2903
-- Name: ECHANTILLON_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ECHANTILLON_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2904 (class 1259 OID 530755)
-- Dependencies: 4651 4652 4653 4654 4655 4656 4657 4658 4659 10
-- Name: ECHEANCE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ECHEANCE_CLIENT" (
    "ID" integer NOT NULL,
    "MONTANT" bigint DEFAULT 0,
    "DATE" date,
    "NOMBRE_RELANCE" integer DEFAULT 0,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_CLIENT" integer DEFAULT 1,
    "REGLE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "REG_COMPTA" boolean DEFAULT false,
    "DATE_LAST_RELANCE" date
);


ALTER TABLE "Default"."ECHEANCE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2905 (class 1259 OID 530770)
-- Dependencies: 2904 10
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ECHEANCE_CLIENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ECHEANCE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10994 (class 0 OID 0)
-- Dependencies: 2905
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ECHEANCE_CLIENT_ID_seq" OWNED BY "ECHEANCE_CLIENT"."ID";


--
-- TOC entry 10995 (class 0 OID 0)
-- Dependencies: 2905
-- Name: ECHEANCE_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ECHEANCE_CLIENT_ID_seq"', 2, false);


--
-- TOC entry 2906 (class 1259 OID 530772)
-- Dependencies: 4661 4662 4663 4664 4665 4666 4667 10
-- Name: ECHEANCE_FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ECHEANCE_FOURNISSEUR" (
    "ID" integer NOT NULL,
    "MONTANT" bigint DEFAULT 0,
    "DATE" date,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "REGLE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ECHEANCE_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 2907 (class 1259 OID 530782)
-- Dependencies: 2906 10
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ECHEANCE_FOURNISSEUR_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ECHEANCE_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10996 (class 0 OID 0)
-- Dependencies: 2907
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ECHEANCE_FOURNISSEUR_ID_seq" OWNED BY "ECHEANCE_FOURNISSEUR"."ID";


--
-- TOC entry 10997 (class 0 OID 0)
-- Dependencies: 2907
-- Name: ECHEANCE_FOURNISSEUR_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ECHEANCE_FOURNISSEUR_ID_seq"', 2, false);


--
-- TOC entry 2908 (class 1259 OID 530784)
-- Dependencies: 4669 4670 4671 4672 4673 4674 4675 4676 4677 4678 4679 4680 4681 4682 4683 4684 4685 10
-- Name: ECRITURE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ECRITURE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "DATE" date,
    "DEBIT" bigint DEFAULT 0,
    "CREDIT" bigint DEFAULT 0,
    "ID_JOURNAL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "VALIDE" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "POINTEE" character varying(45) DEFAULT ''::character varying,
    "DATE_POINTEE" date,
    "DATE_VALIDE" date,
    "IDUSER_CREATE" integer DEFAULT 1,
    "IDUSER_VALIDE" integer DEFAULT 1,
    "IDUSER_DELETE" integer DEFAULT 1,
    "LETTRAGE" character varying(256) DEFAULT ''::character varying,
    "DATE_LETTRAGE" date,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "JOURNAL_NOM" character varying(2048) DEFAULT ''::text,
    "JOURNAL_CODE" character varying(2048) DEFAULT ''::text,
    "COMPTE_NOM" character varying(2048) DEFAULT ''::text,
    "COMPTE_NUMERO" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Default"."ECRITURE" OWNER TO openconcerto;

--
-- TOC entry 2909 (class 1259 OID 530807)
-- Dependencies: 2908 10
-- Name: ECRITURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ECRITURE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ECRITURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 10998 (class 0 OID 0)
-- Dependencies: 2909
-- Name: ECRITURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ECRITURE_ID_seq" OWNED BY "ECRITURE"."ID";


--
-- TOC entry 10999 (class 0 OID 0)
-- Dependencies: 2909
-- Name: ECRITURE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ECRITURE_ID_seq"', 2, false);


--
-- TOC entry 2910 (class 1259 OID 530809)
-- Dependencies: 4687 4688 4689 4690 10
-- Name: EMPLOYEUR_MULTIPLE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "EMPLOYEUR_MULTIPLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."EMPLOYEUR_MULTIPLE" OWNER TO openconcerto;

--
-- TOC entry 2911 (class 1259 OID 530816)
-- Dependencies: 2910 10
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "EMPLOYEUR_MULTIPLE_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."EMPLOYEUR_MULTIPLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11000 (class 0 OID 0)
-- Dependencies: 2911
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "EMPLOYEUR_MULTIPLE_ID_seq" OWNED BY "EMPLOYEUR_MULTIPLE"."ID";


--
-- TOC entry 11001 (class 0 OID 0)
-- Dependencies: 2911
-- Name: EMPLOYEUR_MULTIPLE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"EMPLOYEUR_MULTIPLE_ID_seq"', 5, false);


--
-- TOC entry 2912 (class 1259 OID 530818)
-- Dependencies: 4692 4693 4694 4695 4696 4697 4698 4699 4700 10
-- Name: ENCAISSER_MONTANT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ENCAISSER_MONTANT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "MONTANT" bigint DEFAULT 0,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying(200),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_TICKET_CAISSE" integer DEFAULT 1
);


ALTER TABLE "Default"."ENCAISSER_MONTANT" OWNER TO openconcerto;

--
-- TOC entry 2913 (class 1259 OID 530830)
-- Dependencies: 4702 4703 4704 4705 4706 4707 4708 10
-- Name: ENCAISSER_MONTANT_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ENCAISSER_MONTANT_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_ECHEANCE_CLIENT" integer DEFAULT 1,
    "ID_MOUVEMENT_ECHEANCE" integer DEFAULT 1,
    "ID_ENCAISSER_MONTANT" integer DEFAULT 1,
    "MONTANT_REGLE" bigint DEFAULT 0,
    "MONTANT_A_REGLER" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE" timestamp without time zone
);


ALTER TABLE "Default"."ENCAISSER_MONTANT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2914 (class 1259 OID 530840)
-- Dependencies: 2913 10
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."ENCAISSER_MONTANT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11002 (class 0 OID 0)
-- Dependencies: 2914
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ENCAISSER_MONTANT_ELEMENT_ID_seq" OWNED BY "ENCAISSER_MONTANT_ELEMENT"."ID";


--
-- TOC entry 11003 (class 0 OID 0)
-- Dependencies: 2914
-- Name: ENCAISSER_MONTANT_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ENCAISSER_MONTANT_ELEMENT_ID_seq"', 1, true);


--
-- TOC entry 2915 (class 1259 OID 530842)
-- Dependencies: 2912 10
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ENCAISSER_MONTANT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ENCAISSER_MONTANT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11004 (class 0 OID 0)
-- Dependencies: 2915
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ENCAISSER_MONTANT_ID_seq" OWNED BY "ENCAISSER_MONTANT"."ID";


--
-- TOC entry 11005 (class 0 OID 0)
-- Dependencies: 2915
-- Name: ENCAISSER_MONTANT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ENCAISSER_MONTANT_ID_seq"', 2, false);


--
-- TOC entry 2916 (class 1259 OID 530844)
-- Dependencies: 4710 4711 4712 4713 4714 4715 4716 4717 4718 4719 4720 4721 4722 4723 10
-- Name: ETAT_CIVIL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ETAT_CIVIL" (
    "ID" integer NOT NULL,
    "ID_ADRESSE" integer DEFAULT 1,
    "DATE_NAISSANCE" date,
    "NUMERO_SS" character varying(45) DEFAULT ''::character varying,
    "NB_ENFANTS" integer DEFAULT 0,
    "COMMUNE_NAISSANCE" character varying(45) DEFAULT ''::character varying,
    "ID_DEPARTEMENT_NAISSANCE" integer DEFAULT 1,
    "ID_PAYS_NAISSANCE" integer DEFAULT 1,
    "TELEPHONE" character varying(45) DEFAULT ''::character varying,
    "MAIL" character varying(45) DEFAULT ''::character varying,
    "PORTABLE" character varying(45) DEFAULT ''::character varying,
    "NB_PERS_A_CHARGE" integer DEFAULT 0,
    "ID_SITUATION_FAMILIALE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ETAT_CIVIL" OWNER TO openconcerto;

--
-- TOC entry 2917 (class 1259 OID 530861)
-- Dependencies: 2916 10
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ETAT_CIVIL_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ETAT_CIVIL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11006 (class 0 OID 0)
-- Dependencies: 2917
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ETAT_CIVIL_ID_seq" OWNED BY "ETAT_CIVIL"."ID";


--
-- TOC entry 11007 (class 0 OID 0)
-- Dependencies: 2917
-- Name: ETAT_CIVIL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ETAT_CIVIL_ID_seq"', 2, false);


--
-- TOC entry 2918 (class 1259 OID 530863)
-- Dependencies: 4724 4726 4727 4728 4729 10
-- Name: ETAT_DEVIS; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ETAT_DEVIS" (
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0 NOT NULL,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ETAT_DEVIS" OWNER TO openconcerto;

--
-- TOC entry 2919 (class 1259 OID 530871)
-- Dependencies: 2918 10
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "ETAT_DEVIS_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."ETAT_DEVIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11008 (class 0 OID 0)
-- Dependencies: 2919
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ETAT_DEVIS_ID_seq" OWNED BY "ETAT_DEVIS"."ID";


--
-- TOC entry 11009 (class 0 OID 0)
-- Dependencies: 2919
-- Name: ETAT_DEVIS_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ETAT_DEVIS_ID_seq"', 5, false);


--
-- TOC entry 2920 (class 1259 OID 530873)
-- Dependencies: 4731 4732 4733 4734 10
-- Name: ETAT_RAPPORT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ETAT_RAPPORT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048),
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."ETAT_RAPPORT" OWNER TO openconcerto;

--
-- TOC entry 2921 (class 1259 OID 530883)
-- Dependencies: 2920 10
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."ETAT_RAPPORT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11010 (class 0 OID 0)
-- Dependencies: 2921
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "ETAT_RAPPORT_ID_seq" OWNED BY "ETAT_RAPPORT"."ID";


--
-- TOC entry 11011 (class 0 OID 0)
-- Dependencies: 2921
-- Name: ETAT_RAPPORT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"ETAT_RAPPORT_ID_seq"', 2, true);


--
-- TOC entry 2922 (class 1259 OID 530885)
-- Dependencies: 4736 4737 4738 4739 4740 4741 10
-- Name: FAMILLE_ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FAMILLE_ARTICLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_FAMILLE_ARTICLE_PERE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."FAMILLE_ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 2923 (class 1259 OID 530894)
-- Dependencies: 2922 10
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."FAMILLE_ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11012 (class 0 OID 0)
-- Dependencies: 2923
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "FAMILLE_ARTICLE_ID_seq" OWNED BY "FAMILLE_ARTICLE"."ID";


--
-- TOC entry 11013 (class 0 OID 0)
-- Dependencies: 2923
-- Name: FAMILLE_ARTICLE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"FAMILLE_ARTICLE_ID_seq"', 1, true);


--
-- TOC entry 2924 (class 1259 OID 530896)
-- Dependencies: 4743 4744 4745 4746 4747 4748 4749 4750 4751 4752 4753 4754 4755 4756 4757 4758 4759 4760 4761 4762 10
-- Name: FICHE_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FICHE_PAYE" (
    "ID" integer NOT NULL,
    "ANNEE" integer DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_SALARIE" integer DEFAULT 1,
    "ID_PROFIL_PAYE" integer DEFAULT 1,
    "SAL_BRUT" real DEFAULT 0,
    "COT_PAT" real DEFAULT 0,
    "COT_SAL" real DEFAULT 0,
    "NET_IMP" real DEFAULT 0,
    "NET_A_PAYER" real DEFAULT 0,
    "ACOMPTE" real DEFAULT 0,
    "ID_MOIS" integer DEFAULT 1,
    "VALIDE" boolean DEFAULT false,
    "CSG" real DEFAULT 0,
    "DU" date,
    "AU" date,
    "CONGES_ACQUIS" real DEFAULT 0,
    "ID_CUMULS_PAYE" integer DEFAULT 1,
    "ID_CUMULS_CONGES" integer DEFAULT 1,
    "ID_VARIABLE_SALARIE" integer DEFAULT 1,
    "ID_REGLEMENT_PAYE" integer DEFAULT 1,
    "NATURE_EMPLOI" character varying(150) DEFAULT ''::character varying,
    "ID_IDCC" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."FICHE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2925 (class 1259 OID 530919)
-- Dependencies: 4764 4765 4766 4767 4768 4769 4770 4771 4772 4773 4774 10
-- Name: FICHE_PAYE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FICHE_PAYE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_FICHE_PAYE" integer DEFAULT 1,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "NB_BASE" real,
    "TAUX_SAL" real,
    "TAUX_PAT" real,
    "MONTANT_SAL_AJ" real,
    "MONTANT_PAT" real,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "POSITION" integer DEFAULT 0,
    "MONTANT_SAL_DED" real,
    "VALIDE" boolean DEFAULT false,
    "IMPRESSION" boolean DEFAULT true,
    "IN_PERIODE" boolean DEFAULT true,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."FICHE_PAYE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2926 (class 1259 OID 530933)
-- Dependencies: 2925 10
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "FICHE_PAYE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."FICHE_PAYE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11014 (class 0 OID 0)
-- Dependencies: 2926
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "FICHE_PAYE_ELEMENT_ID_seq" OWNED BY "FICHE_PAYE_ELEMENT"."ID";


--
-- TOC entry 11015 (class 0 OID 0)
-- Dependencies: 2926
-- Name: FICHE_PAYE_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"FICHE_PAYE_ELEMENT_ID_seq"', 2, false);


--
-- TOC entry 2927 (class 1259 OID 530935)
-- Dependencies: 2924 10
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "FICHE_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."FICHE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11016 (class 0 OID 0)
-- Dependencies: 2927
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "FICHE_PAYE_ID_seq" OWNED BY "FICHE_PAYE"."ID";


--
-- TOC entry 11017 (class 0 OID 0)
-- Dependencies: 2927
-- Name: FICHE_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"FICHE_PAYE_ID_seq"', 2, false);


--
-- TOC entry 2928 (class 1259 OID 530998)
-- Dependencies: 4776 4777 4778 4779 4780 4781 4782 4783 4784 4785 4786 10
-- Name: FOURNISSEUR; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FOURNISSEUR" (
    "ID_FOURNISSEUR" integer NOT NULL,
    "TYPE" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_ADRESSE_E" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "UE" boolean DEFAULT false NOT NULL,
    "ID_COMPTE_PCE" integer DEFAULT 1 NOT NULL,
    "ID_MODE_REGLEMENT" integer DEFAULT 1 NOT NULL,
    "TEL" character varying(2048) DEFAULT ''::text,
    "FAX" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 2929 (class 1259 OID 531015)
-- Dependencies: 2928 10
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "FOURNISSEUR_ID_FOURNISSEUR_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."FOURNISSEUR_ID_FOURNISSEUR_seq" OWNER TO openconcerto;

--
-- TOC entry 11018 (class 0 OID 0)
-- Dependencies: 2929
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "FOURNISSEUR_ID_FOURNISSEUR_seq" OWNED BY "FOURNISSEUR"."ID_FOURNISSEUR";


--
-- TOC entry 11019 (class 0 OID 0)
-- Dependencies: 2929
-- Name: FOURNISSEUR_ID_FOURNISSEUR_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"FOURNISSEUR_ID_FOURNISSEUR_seq"', 2, false);


--
-- TOC entry 2930 (class 1259 OID 531017)
-- Dependencies: 4787 4788 10
-- Name: FWK_SCHEMA_METADATA; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FWK_SCHEMA_METADATA" (
    "NAME" character varying(100) DEFAULT ''::character varying NOT NULL,
    "VALUE" character varying(250) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "Default"."FWK_SCHEMA_METADATA" OWNER TO openconcerto;

--
-- TOC entry 2931 (class 1259 OID 531022)
-- Dependencies: 4789 4790 10
-- Name: FWK_UNDEFINED_IDS; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "FWK_UNDEFINED_IDS" (
    "TABLENAME" character varying(250) DEFAULT ''::character varying NOT NULL,
    "UNDEFINED_ID" integer DEFAULT 0
);


ALTER TABLE "Default"."FWK_UNDEFINED_IDS" OWNER TO openconcerto;

--
-- TOC entry 2932 (class 1259 OID 531027)
-- Dependencies: 4792 4793 4794 4795 4796 10
-- Name: IDCC; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "IDCC" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."IDCC" OWNER TO openconcerto;

--
-- TOC entry 2933 (class 1259 OID 531038)
-- Dependencies: 2932 10
-- Name: IDCC_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "IDCC_ID_seq"
    START WITH 996
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."IDCC_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11020 (class 0 OID 0)
-- Dependencies: 2933
-- Name: IDCC_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "IDCC_ID_seq" OWNED BY "IDCC"."ID";


--
-- TOC entry 11021 (class 0 OID 0)
-- Dependencies: 2933
-- Name: IDCC_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"IDCC_ID_seq"', 996, false);


--
-- TOC entry 2934 (class 1259 OID 531040)
-- Dependencies: 4798 4799 4800 4801 4802 4803 4804 4805 4806 4807 4808 10
-- Name: INFOS_SALARIE_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "INFOS_SALARIE_PAYE" (
    "ID" integer NOT NULL,
    "ID_IDCC" integer DEFAULT 1,
    "ID_CONTRAT_SALARIE" integer DEFAULT 1,
    "ID_CLASSEMENT_CONVENTIONNEL" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "DUREE_HEBDO" real DEFAULT 0,
    "DUREE_MOIS" real DEFAULT 0,
    "DATE_ARRIVE" date,
    "CONGES_PAYES" real DEFAULT 0,
    "TAUX_AT" real DEFAULT 0,
    "SALAIRE_MOIS" real DEFAULT 0,
    "DATE_SORTIE" date,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."INFOS_SALARIE_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2935 (class 1259 OID 531054)
-- Dependencies: 2934 10
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "INFOS_SALARIE_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."INFOS_SALARIE_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11022 (class 0 OID 0)
-- Dependencies: 2935
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "INFOS_SALARIE_PAYE_ID_seq" OWNED BY "INFOS_SALARIE_PAYE"."ID";


--
-- TOC entry 11023 (class 0 OID 0)
-- Dependencies: 2935
-- Name: INFOS_SALARIE_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"INFOS_SALARIE_PAYE_ID_seq"', 2, false);


--
-- TOC entry 2936 (class 1259 OID 531056)
-- Dependencies: 4810 4811 4812 4813 4814 10
-- Name: JOURNAL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "JOURNAL" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "PAR_DEFAUT" boolean DEFAULT false,
    "TYPE_BANQUE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."JOURNAL" OWNER TO openconcerto;

--
-- TOC entry 2937 (class 1259 OID 531067)
-- Dependencies: 2936 10
-- Name: JOURNAL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "JOURNAL_ID_seq"
    START WITH 7
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."JOURNAL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11024 (class 0 OID 0)
-- Dependencies: 2937
-- Name: JOURNAL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "JOURNAL_ID_seq" OWNED BY "JOURNAL"."ID";


--
-- TOC entry 11025 (class 0 OID 0)
-- Dependencies: 2937
-- Name: JOURNAL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"JOURNAL_ID_seq"', 7, false);


--
-- TOC entry 2938 (class 1259 OID 531069)
-- Dependencies: 4816 4817 4818 4819 4820 10
-- Name: METRIQUE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "METRIQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "UNITE" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."METRIQUE" OWNER TO openconcerto;

--
-- TOC entry 2939 (class 1259 OID 531077)
-- Dependencies: 2938 10
-- Name: METRIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "METRIQUE_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."METRIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11026 (class 0 OID 0)
-- Dependencies: 2939
-- Name: METRIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "METRIQUE_ID_seq" OWNED BY "METRIQUE"."ID";


--
-- TOC entry 11027 (class 0 OID 0)
-- Dependencies: 2939
-- Name: METRIQUE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"METRIQUE_ID_seq"', 4, false);


--
-- TOC entry 2940 (class 1259 OID 531079)
-- Dependencies: 4822 4823 4824 4825 4826 4827 4828 4829 10
-- Name: MODELE_COURRIER_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MODELE_COURRIER_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "CODE" character varying(10) DEFAULT ''::character varying,
    "LOCATION" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CONTENU" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MODELE_COURRIER_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2941 (class 1259 OID 531093)
-- Dependencies: 2940 10
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."MODELE_COURRIER_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11028 (class 0 OID 0)
-- Dependencies: 2941
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MODELE_COURRIER_CLIENT_ID_seq" OWNED BY "MODELE_COURRIER_CLIENT"."ID";


--
-- TOC entry 11029 (class 0 OID 0)
-- Dependencies: 2941
-- Name: MODELE_COURRIER_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MODELE_COURRIER_CLIENT_ID_seq"', 9, true);


--
-- TOC entry 2942 (class 1259 OID 531095)
-- Dependencies: 4831 4832 4833 4834 4835 4836 4837 4838 4839 4840 4841 4842 4843 10
-- Name: MODE_REGLEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MODE_REGLEMENT" (
    "ID_MODE_REGLEMENT" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "AJOURS" integer DEFAULT 0,
    "LENJOUR" integer DEFAULT 0,
    "ID_TYPE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "FIN_MOIS" boolean DEFAULT false,
    "COMPTANT" boolean DEFAULT false,
    "DATE_DEPOT" date,
    "DATE_FACTURE" boolean DEFAULT false,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ETS" character varying(2048) DEFAULT ''::text,
    "DATE_VIREMENT" date
);


ALTER TABLE "Default"."MODE_REGLEMENT" OWNER TO openconcerto;

--
-- TOC entry 2943 (class 1259 OID 531115)
-- Dependencies: 2942 10
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."MODE_REGLEMENT_ID_MODE_REGLEMENT_seq" OWNER TO openconcerto;

--
-- TOC entry 11030 (class 0 OID 0)
-- Dependencies: 2943
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MODE_REGLEMENT_ID_MODE_REGLEMENT_seq" OWNED BY "MODE_REGLEMENT"."ID_MODE_REGLEMENT";


--
-- TOC entry 11031 (class 0 OID 0)
-- Dependencies: 2943
-- Name: MODE_REGLEMENT_ID_MODE_REGLEMENT_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MODE_REGLEMENT_ID_MODE_REGLEMENT_seq"', 3, true);


--
-- TOC entry 2944 (class 1259 OID 531117)
-- Dependencies: 4845 10
-- Name: MODE_REGLEMENT_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MODE_REGLEMENT_PAYE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying
);


ALTER TABLE "Default"."MODE_REGLEMENT_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2945 (class 1259 OID 531121)
-- Dependencies: 2944 10
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "MODE_REGLEMENT_PAYE_ID_seq"
    START WITH 4
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."MODE_REGLEMENT_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11032 (class 0 OID 0)
-- Dependencies: 2945
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MODE_REGLEMENT_PAYE_ID_seq" OWNED BY "MODE_REGLEMENT_PAYE"."ID";


--
-- TOC entry 11033 (class 0 OID 0)
-- Dependencies: 2945
-- Name: MODE_REGLEMENT_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MODE_REGLEMENT_PAYE_ID_seq"', 4, false);


--
-- TOC entry 2946 (class 1259 OID 531123)
-- Dependencies: 4847 4848 4849 4850 4851 4852 4853 4854 4855 4856 4857 4858 4859 4860 4861 10
-- Name: MODE_VENTE_ARTICLE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MODE_VENTE_ARTICLE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0.00000000,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MODE_VENTE_ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 2947 (class 1259 OID 531141)
-- Dependencies: 2946 10
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."MODE_VENTE_ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11034 (class 0 OID 0)
-- Dependencies: 2947
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MODE_VENTE_ARTICLE_ID_seq" OWNED BY "MODE_VENTE_ARTICLE"."ID";


--
-- TOC entry 11035 (class 0 OID 0)
-- Dependencies: 2947
-- Name: MODE_VENTE_ARTICLE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MODE_VENTE_ARTICLE_ID_seq"', 6, true);


--
-- TOC entry 2948 (class 1259 OID 531143)
-- Dependencies: 4863 4864 4865 4866 10
-- Name: MOIS; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MOIS" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MOIS" OWNER TO openconcerto;

--
-- TOC entry 2949 (class 1259 OID 531150)
-- Dependencies: 2948 10
-- Name: MOIS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "MOIS_ID_seq"
    START WITH 14
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."MOIS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11036 (class 0 OID 0)
-- Dependencies: 2949
-- Name: MOIS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MOIS_ID_seq" OWNED BY "MOIS"."ID";


--
-- TOC entry 11037 (class 0 OID 0)
-- Dependencies: 2949
-- Name: MOIS_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MOIS_ID_seq"', 14, false);


--
-- TOC entry 2950 (class 1259 OID 531152)
-- Dependencies: 4868 4869 4870 4871 4872 4873 4874 4875 10
-- Name: MOUVEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MOUVEMENT" (
    "ID" integer NOT NULL,
    "NUMERO" integer DEFAULT 0,
    "IDSOURCE" integer DEFAULT 1,
    "SOURCE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_MOUVEMENT_PERE" integer DEFAULT 1,
    "ID_PIECE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MOUVEMENT" OWNER TO openconcerto;

--
-- TOC entry 2951 (class 1259 OID 531166)
-- Dependencies: 2950 10
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "MOUVEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."MOUVEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11038 (class 0 OID 0)
-- Dependencies: 2951
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MOUVEMENT_ID_seq" OWNED BY "MOUVEMENT"."ID";


--
-- TOC entry 11039 (class 0 OID 0)
-- Dependencies: 2951
-- Name: MOUVEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MOUVEMENT_ID_seq"', 2, false);


--
-- TOC entry 2952 (class 1259 OID 531168)
-- Dependencies: 4877 4878 4879 4880 4881 4882 4883 4884 4885 10
-- Name: MOUVEMENT_STOCK; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "MOUVEMENT_STOCK" (
    "ID" integer NOT NULL,
    "QTE" real DEFAULT 0,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NUMERO" character varying(150) DEFAULT ''::character varying,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "DATE" date,
    "ID_ARTICLE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."MOUVEMENT_STOCK" OWNER TO openconcerto;

--
-- TOC entry 2953 (class 1259 OID 531180)
-- Dependencies: 2952 10
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "MOUVEMENT_STOCK_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."MOUVEMENT_STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11040 (class 0 OID 0)
-- Dependencies: 2953
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "MOUVEMENT_STOCK_ID_seq" OWNED BY "MOUVEMENT_STOCK"."ID";


--
-- TOC entry 11041 (class 0 OID 0)
-- Dependencies: 2953
-- Name: MOUVEMENT_STOCK_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"MOUVEMENT_STOCK_ID_seq"', 2, false);


--
-- TOC entry 2954 (class 1259 OID 531182)
-- Dependencies: 4887 4888 4889 4890 10
-- Name: NATURE_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "NATURE_COMPTE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."NATURE_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 2955 (class 1259 OID 531192)
-- Dependencies: 2954 10
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "NATURE_COMPTE_ID_seq"
    START WITH 13
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."NATURE_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11042 (class 0 OID 0)
-- Dependencies: 2955
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "NATURE_COMPTE_ID_seq" OWNED BY "NATURE_COMPTE"."ID";


--
-- TOC entry 11043 (class 0 OID 0)
-- Dependencies: 2955
-- Name: NATURE_COMPTE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"NATURE_COMPTE_ID_seq"', 13, false);


--
-- TOC entry 2956 (class 1259 OID 531208)
-- Dependencies: 4892 4893 4894 4895 4896 4897 4898 4899 4900 4901 4902 4903 4904 4905 4906 4907 4908 4909 4910 4911 4912 4913 4914 4915 4916 4917 4918 4919 10
-- Name: NUMEROTATION_AUTO; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "NUMEROTATION_AUTO" (
    "ID" integer NOT NULL,
    "DEVIS_FORMAT" character varying(45) DEFAULT ''::character varying,
    "DEVIS_START" integer DEFAULT 1,
    "BON_L_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_L_START" integer DEFAULT 1,
    "FACT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "FACT_START" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SALARIE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "SALARIE_START" integer DEFAULT 1,
    "PROPOSITION_FORMAT" character varying(45) DEFAULT ''::character varying,
    "PROPOSITION_START" integer DEFAULT 0,
    "RELANCE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "RELANCE_START" integer DEFAULT 0,
    "COMMANDE_CLIENT_START" integer DEFAULT 0,
    "COMMANDE_CLIENT_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COMMANDE_START" integer DEFAULT 0,
    "COMMANDE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_R_FORMAT" character varying(45) DEFAULT ''::character varying,
    "BON_R_START" integer DEFAULT 0,
    "AFFAIRE_START" integer DEFAULT 0,
    "AFFAIRE_FORMAT" character varying(45) DEFAULT ''::character varying,
    "AVOIR_START" integer DEFAULT 0,
    "AVOIR_FORMAT" character varying(45) DEFAULT ''::character varying,
    "CODE_LETTRAGE" character varying(128) DEFAULT 'AAA'::character varying,
    "COURRIER_FORMAT" character varying(45) DEFAULT ''::character varying,
    "COURRIER_START" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."NUMEROTATION_AUTO" OWNER TO openconcerto;

--
-- TOC entry 2957 (class 1259 OID 531242)
-- Dependencies: 2956 10
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "NUMEROTATION_AUTO_ID_seq"
    START WITH 3
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."NUMEROTATION_AUTO_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11044 (class 0 OID 0)
-- Dependencies: 2957
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "NUMEROTATION_AUTO_ID_seq" OWNED BY "NUMEROTATION_AUTO"."ID";


--
-- TOC entry 11045 (class 0 OID 0)
-- Dependencies: 2957
-- Name: NUMEROTATION_AUTO_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"NUMEROTATION_AUTO_ID_seq"', 3, false);


--
-- TOC entry 2958 (class 1259 OID 531252)
-- Dependencies: 4921 4922 4923 4924 4925 10
-- Name: PAYS; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PAYS" (
    "ID" integer NOT NULL,
    "CODE" character varying(15) DEFAULT ''::character varying,
    "NOM" character varying(50) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."PAYS" OWNER TO openconcerto;

--
-- TOC entry 2959 (class 1259 OID 531260)
-- Dependencies: 2958 10
-- Name: PAYS_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "PAYS_ID_seq"
    START WITH 194
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."PAYS_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11046 (class 0 OID 0)
-- Dependencies: 2959
-- Name: PAYS_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "PAYS_ID_seq" OWNED BY "PAYS"."ID";


--
-- TOC entry 11047 (class 0 OID 0)
-- Dependencies: 2959
-- Name: PAYS_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"PAYS_ID_seq"', 194, false);


--
-- TOC entry 2960 (class 1259 OID 531262)
-- Dependencies: 4927 4928 4929 4930 10
-- Name: PIECE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PIECE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."PIECE" OWNER TO openconcerto;

--
-- TOC entry 2961 (class 1259 OID 531272)
-- Dependencies: 2960 10
-- Name: PIECE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "PIECE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."PIECE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11048 (class 0 OID 0)
-- Dependencies: 2961
-- Name: PIECE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "PIECE_ID_seq" OWNED BY "PIECE"."ID";


--
-- TOC entry 11049 (class 0 OID 0)
-- Dependencies: 2961
-- Name: PIECE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"PIECE_ID_seq"', 2, false);


--
-- TOC entry 2962 (class 1259 OID 531274)
-- Dependencies: 4932 4933 4934 4935 4936 4937 4938 4939 4940 4941 4942 4943 4944 10
-- Name: POLE_PRODUIT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "POLE_PRODUIT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM_DIRECTEUR" character varying(2048) DEFAULT ''::text,
    "NOM_SECRETAIRE" character varying(2048) DEFAULT ''::text,
    "TEL" character varying(22) DEFAULT ''::character varying,
    "FAX" character varying(22) DEFAULT ''::character varying,
    "MAIL" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone,
    "FACTURE_ADRESSE" boolean DEFAULT false,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "RAISON_SOCIALE" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Default"."POLE_PRODUIT" OWNER TO openconcerto;

--
-- TOC entry 2963 (class 1259 OID 531293)
-- Dependencies: 2962 10
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."POLE_PRODUIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11050 (class 0 OID 0)
-- Dependencies: 2963
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "POLE_PRODUIT_ID_seq" OWNED BY "POLE_PRODUIT"."ID";


--
-- TOC entry 11051 (class 0 OID 0)
-- Dependencies: 2963
-- Name: POLE_PRODUIT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"POLE_PRODUIT_ID_seq"', 1, true);


--
-- TOC entry 2964 (class 1259 OID 531295)
-- Dependencies: 4946 4947 4948 4949 4950 10
-- Name: POSTE_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "POSTE_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_AXE_ANALYTIQUE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."POSTE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 2965 (class 1259 OID 531306)
-- Dependencies: 2964 10
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "POSTE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."POSTE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11052 (class 0 OID 0)
-- Dependencies: 2965
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "POSTE_ANALYTIQUE_ID_seq" OWNED BY "POSTE_ANALYTIQUE"."ID";


--
-- TOC entry 11053 (class 0 OID 0)
-- Dependencies: 2965
-- Name: POSTE_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"POSTE_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 2966 (class 1259 OID 531339)
-- Dependencies: 4952 4953 4954 4955 10
-- Name: PREFERENCES; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PREFERENCES" (
    "NAME" character varying(2048) NOT NULL,
    "VALUE" character varying(2048),
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."PREFERENCES" OWNER TO openconcerto;

--
-- TOC entry 2967 (class 1259 OID 531349)
-- Dependencies: 2966 10
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."PREFERENCES_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11054 (class 0 OID 0)
-- Dependencies: 2967
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "PREFERENCES_ID_seq" OWNED BY "PREFERENCES"."ID";


--
-- TOC entry 11055 (class 0 OID 0)
-- Dependencies: 2967
-- Name: PREFERENCES_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"PREFERENCES_ID_seq"', 4, true);


--
-- TOC entry 2968 (class 1259 OID 531351)
-- Dependencies: 4957 4958 4959 4960 4961 4962 4963 4964 4965 4966 4967 4968 4969 4970 4971 4972 4973 4974 4975 10
-- Name: PREFS_COMPTE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "PREFS_COMPTE" (
    "ID" integer NOT NULL,
    "ID_COMPTE_PCE_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_ACHAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_PRODUIT" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_VENTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE_SERVICE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACOMPTE_REGL" integer DEFAULT 1,
    "ID_COMPTE_PCE_PAYE" integer DEFAULT 1,
    "ID_COMPTE_PCE_TVA_INTRA" integer DEFAULT 1 NOT NULL,
    "ID_COMPTE_PCE_TVA_IMMO" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_O" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT" integer DEFAULT 1,
    "ID_COMPTE_PCE_BILAN_F" integer DEFAULT 1,
    "ID_COMPTE_PCE_ACHAT_INTRA" integer DEFAULT 1,
    "ID_JOURNAL_FACTOR" integer DEFAULT 1,
    "ID_COMPTE_PCE_FACTOR" integer DEFAULT 1,
    "ID_COMPTE_PCE_RESULTAT_PERTE" integer DEFAULT 1
);


ALTER TABLE "Default"."PREFS_COMPTE" OWNER TO openconcerto;

--
-- TOC entry 2969 (class 1259 OID 531373)
-- Dependencies: 2968 10
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "PREFS_COMPTE_ID_seq"
    START WITH 3
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."PREFS_COMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11056 (class 0 OID 0)
-- Dependencies: 2969
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "PREFS_COMPTE_ID_seq" OWNED BY "PREFS_COMPTE"."ID";


--
-- TOC entry 11057 (class 0 OID 0)
-- Dependencies: 2969
-- Name: PREFS_COMPTE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"PREFS_COMPTE_ID_seq"', 3, false);


--
-- TOC entry 2970 (class 1259 OID 531443)
-- Dependencies: 4977 4978 4979 4980 4981 10
-- Name: REFERENCE_CLIENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REFERENCE_CLIENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REFERENCE_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 2971 (class 1259 OID 531455)
-- Dependencies: 2970 10
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."REFERENCE_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11058 (class 0 OID 0)
-- Dependencies: 2971
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REFERENCE_CLIENT_ID_seq" OWNED BY "REFERENCE_CLIENT"."ID";


--
-- TOC entry 11059 (class 0 OID 0)
-- Dependencies: 2971
-- Name: REFERENCE_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REFERENCE_CLIENT_ID_seq"', 2, true);


--
-- TOC entry 2972 (class 1259 OID 531457)
-- Dependencies: 4983 4984 4985 4986 4987 4988 4989 4990 4991 4992 10
-- Name: REGIME_BASE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REGIME_BASE" (
    "ID" integer NOT NULL,
    "ID_CODE_REGIME_BASE" integer DEFAULT 1,
    "ID_CODE_REGIME_MALADIE" integer DEFAULT 1,
    "ID_CODE_REGIME_AT" integer DEFAULT 1,
    "ID_CODE_REGIME_VIEL_P" integer DEFAULT 1,
    "ID_CODE_REGIME_VIEL_S" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying DEFAULT ''::character varying,
    "CODE" character varying DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REGIME_BASE" OWNER TO openconcerto;

--
-- TOC entry 2973 (class 1259 OID 531473)
-- Dependencies: 2972 10
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "REGIME_BASE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."REGIME_BASE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11060 (class 0 OID 0)
-- Dependencies: 2973
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REGIME_BASE_ID_seq" OWNED BY "REGIME_BASE"."ID";


--
-- TOC entry 11061 (class 0 OID 0)
-- Dependencies: 2973
-- Name: REGIME_BASE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REGIME_BASE_ID_seq"', 2, false);


--
-- TOC entry 2974 (class 1259 OID 531475)
-- Dependencies: 4994 4995 4996 4997 4998 4999 5000 5001 10
-- Name: REGLEMENT_PAYE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REGLEMENT_PAYE" (
    "ID" integer NOT NULL,
    "NOM_BANQUE" character varying(45) DEFAULT ''::character varying,
    "RIB" character varying(45) DEFAULT ''::character varying,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "LE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT_PAYE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REGLEMENT_PAYE" OWNER TO openconcerto;

--
-- TOC entry 2975 (class 1259 OID 531486)
-- Dependencies: 2974 10
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "REGLEMENT_PAYE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."REGLEMENT_PAYE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11062 (class 0 OID 0)
-- Dependencies: 2975
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REGLEMENT_PAYE_ID_seq" OWNED BY "REGLEMENT_PAYE"."ID";


--
-- TOC entry 11063 (class 0 OID 0)
-- Dependencies: 2975
-- Name: REGLEMENT_PAYE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REGLEMENT_PAYE_ID_seq"', 2, false);


--
-- TOC entry 2976 (class 1259 OID 531488)
-- Dependencies: 5003 5004 5005 5006 10
-- Name: REGLER_MONTANT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REGLER_MONTANT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "MONTANT" bigint DEFAULT 0,
    "ID_ECHEANCE_FOURNISSEUR" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REGLER_MONTANT" OWNER TO openconcerto;

--
-- TOC entry 2977 (class 1259 OID 531495)
-- Dependencies: 2976 10
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "REGLER_MONTANT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."REGLER_MONTANT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11064 (class 0 OID 0)
-- Dependencies: 2977
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REGLER_MONTANT_ID_seq" OWNED BY "REGLER_MONTANT"."ID";


--
-- TOC entry 11065 (class 0 OID 0)
-- Dependencies: 2977
-- Name: REGLER_MONTANT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REGLER_MONTANT_ID_seq"', 2, false);


--
-- TOC entry 2978 (class 1259 OID 531497)
-- Dependencies: 5008 5009 5010 5011 5012 5013 5014 5015 5016 10
-- Name: RELANCE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "RELANCE" (
    "ID" integer NOT NULL,
    "DATE" date,
    "ID_TYPE_LETTRE_RELANCE" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "MONTANT" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."RELANCE" OWNER TO openconcerto;

--
-- TOC entry 2979 (class 1259 OID 531512)
-- Dependencies: 2978 10
-- Name: RELANCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "RELANCE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."RELANCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11066 (class 0 OID 0)
-- Dependencies: 2979
-- Name: RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "RELANCE_ID_seq" OWNED BY "RELANCE"."ID";


--
-- TOC entry 11067 (class 0 OID 0)
-- Dependencies: 2979
-- Name: RELANCE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"RELANCE_ID_seq"', 2, false);


--
-- TOC entry 2980 (class 1259 OID 531514)
-- Dependencies: 5018 5019 5020 5021 10
-- Name: REPARTITION_ANALYTIQUE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REPARTITION_ANALYTIQUE" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 2981 (class 1259 OID 531524)
-- Dependencies: 5023 5024 5025 5026 5027 5028 10
-- Name: REPARTITION_ANALYTIQUE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "REPARTITION_ANALYTIQUE_ELEMENT" (
    "ID" integer NOT NULL,
    "ID_REPARTITION_ANALYTIQUE" integer DEFAULT 1,
    "ID_POSTE_ANALYTIQUE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "TAUX" real DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2982 (class 1259 OID 531533)
-- Dependencies: 2981 10
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "REPARTITION_ANALYTIQUE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11068 (class 0 OID 0)
-- Dependencies: 2982
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REPARTITION_ANALYTIQUE_ELEMENT_ID_seq" OWNED BY "REPARTITION_ANALYTIQUE_ELEMENT"."ID";


--
-- TOC entry 11069 (class 0 OID 0)
-- Dependencies: 2982
-- Name: REPARTITION_ANALYTIQUE_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REPARTITION_ANALYTIQUE_ELEMENT_ID_seq"', 2, false);


--
-- TOC entry 2983 (class 1259 OID 531535)
-- Dependencies: 2980 10
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "REPARTITION_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."REPARTITION_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11070 (class 0 OID 0)
-- Dependencies: 2983
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "REPARTITION_ANALYTIQUE_ID_seq" OWNED BY "REPARTITION_ANALYTIQUE"."ID";


--
-- TOC entry 11071 (class 0 OID 0)
-- Dependencies: 2983
-- Name: REPARTITION_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"REPARTITION_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 2984 (class 1259 OID 531537)
-- Dependencies: 5030 5031 5032 5033 5034 5035 5036 5037 5038 5039 5040 5041 5042 5043 5044 5045 5046 10
-- Name: SAISIE_ACHAT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_ACHAT" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NOM" character varying(2048) DEFAULT ''::text,
    "MONTANT_TTC" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "NUMERO_COMMANDE" character varying(2048) DEFAULT ''::text,
    "NUMERO_FACTURE" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "MONTANT_HT" bigint DEFAULT 0,
    "MONTANT_TVA" bigint DEFAULT 0,
    "IDSOURCE" integer DEFAULT 1,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "ID_COMPTE_PCE" integer DEFAULT 1 NOT NULL,
    "ID_AVOIR_FOURNISSEUR" integer DEFAULT 1,
    "IMMO" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_ACHAT" OWNER TO openconcerto;

--
-- TOC entry 2985 (class 1259 OID 531560)
-- Dependencies: 2984 10
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_ACHAT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_ACHAT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11072 (class 0 OID 0)
-- Dependencies: 2985
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_ACHAT_ID_seq" OWNED BY "SAISIE_ACHAT"."ID";


--
-- TOC entry 11073 (class 0 OID 0)
-- Dependencies: 2985
-- Name: SAISIE_ACHAT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_ACHAT_ID_seq"', 2, false);


--
-- TOC entry 2986 (class 1259 OID 531562)
-- Dependencies: 5048 5049 5050 5051 10
-- Name: SAISIE_KM; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_KM" (
    "ID" integer NOT NULL,
    "DATE" date,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_JOURNAL" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_KM" OWNER TO openconcerto;

--
-- TOC entry 2987 (class 1259 OID 531572)
-- Dependencies: 5052 5054 5055 5056 5057 5058 5059 5060 5061 5062 10
-- Name: SAISIE_KM_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_KM_ELEMENT" (
    "ID_SAISIE_KM" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NUMERO" character varying(100) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "NOM_ECRITURE" character varying(2048) DEFAULT ''::text,
    "DEBIT" bigint DEFAULT 0,
    "CREDIT" bigint DEFAULT 0,
    "ID_ECRITURE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_KM_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2988 (class 1259 OID 531588)
-- Dependencies: 2987 10
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_KM_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_KM_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11074 (class 0 OID 0)
-- Dependencies: 2988
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_KM_ELEMENT_ID_seq" OWNED BY "SAISIE_KM_ELEMENT"."ID";


--
-- TOC entry 11075 (class 0 OID 0)
-- Dependencies: 2988
-- Name: SAISIE_KM_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_KM_ELEMENT_ID_seq"', 2, false);


--
-- TOC entry 2989 (class 1259 OID 531590)
-- Dependencies: 2986 10
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_KM_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_KM_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11076 (class 0 OID 0)
-- Dependencies: 2989
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_KM_ID_seq" OWNED BY "SAISIE_KM"."ID";


--
-- TOC entry 11077 (class 0 OID 0)
-- Dependencies: 2989
-- Name: SAISIE_KM_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_KM_ID_seq"', 2, false);


--
-- TOC entry 2990 (class 1259 OID 531592)
-- Dependencies: 5064 5065 5066 5067 5068 5069 5070 5071 5072 5073 5074 5075 5076 5077 10
-- Name: SAISIE_VENTE_COMPTOIR; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_VENTE_COMPTOIR" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_ARTICLE" integer DEFAULT 1,
    "DATE" date,
    "ID_CLIENT" integer DEFAULT 0,
    "MONTANT_TTC" bigint DEFAULT 0,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "ECHEANCE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SAISIE_VENTE_COMPTOIR" OWNER TO openconcerto;

--
-- TOC entry 2991 (class 1259 OID 531612)
-- Dependencies: 2990 10
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_VENTE_COMPTOIR_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_COMPTOIR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11078 (class 0 OID 0)
-- Dependencies: 2991
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_VENTE_COMPTOIR_ID_seq" OWNED BY "SAISIE_VENTE_COMPTOIR"."ID";


--
-- TOC entry 11079 (class 0 OID 0)
-- Dependencies: 2991
-- Name: SAISIE_VENTE_COMPTOIR_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_VENTE_COMPTOIR_ID_seq"', 2, false);


--
-- TOC entry 2992 (class 1259 OID 531614)
-- Dependencies: 5078 5080 5081 5082 5083 5084 5085 5086 5087 5088 5089 5090 5091 5092 5093 5094 5095 5096 5097 5098 5099 5100 5101 5102 5103 5104 5105 5106 5107 5108 5109 5110 5111 5112 5113 5114 5115 5116 5117 10
-- Name: SAISIE_VENTE_FACTURE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_VENTE_FACTURE" (
    "ID_DEVIS" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "NOM" character varying(250) DEFAULT ''::character varying,
    "DATE" date,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "ID_CLIENT" integer DEFAULT 1,
    "T_HT" bigint DEFAULT 0,
    "T_TVA" bigint DEFAULT 0,
    "T_TTC" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "REMISE_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "T_SERVICE" bigint DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "T_POIDS" real DEFAULT 0,
    "SOURCE" character varying(45) DEFAULT ''::character varying,
    "IDSOURCE" integer DEFAULT 1,
    "PREVISIONNELLE" boolean DEFAULT false NOT NULL,
    "COMPLEMENT" boolean DEFAULT false NOT NULL,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "DATE_ENVOI" timestamp without time zone,
    "DATE_REGLEMENT" timestamp without time zone,
    "ACOMPTE" boolean DEFAULT false,
    "POURCENT_ACOMPTE" real DEFAULT 0,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "DATE_ENVOI_AFFACTURAGE" date,
    "AFFACTURAGE" boolean DEFAULT false,
    "ID_CONTACT" integer DEFAULT 1,
    "TYPE_INTERVENTION" character varying(2048) DEFAULT ''::text,
    "ID_REFERENCE_CLIENT" integer DEFAULT 1,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "T_AVOIR_TTC" bigint DEFAULT 0,
    "REF_CLIENT" character varying DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "CREATION_DATE" timestamp without time zone,
    "T_HA" bigint DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "ID_COMPTE_PCE_VENTE" integer DEFAULT 1,
    "ID_MOIS_CCIP" integer DEFAULT 1,
    "RETOUR_NATEXIS" boolean DEFAULT false,
    "CONTROLE_TECHNIQUE" boolean DEFAULT false
);


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE" OWNER TO openconcerto;

--
-- TOC entry 2993 (class 1259 OID 531664)
-- Dependencies: 5118 5119 5121 5122 5123 5124 5125 5126 5127 5128 5129 5130 5131 5132 5133 5134 5135 5136 5137 5138 5139 5140 5141 5142 5143 5144 5145 5146 5147 5148 5149 5150 5151 5152 5153 5154 5155 5156 5157 5158 5159 5160 5161 5162 5163 5164 5165 5166 5167 5168 5169 5170 5171 5172 5173 10
-- Name: SAISIE_VENTE_FACTURE_ELEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SAISIE_VENTE_FACTURE_ELEMENT" (
    "LIVREE" boolean DEFAULT false,
    "QTE_LIVREE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_STYLE" integer DEFAULT 1,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "PV_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "POIDS" real DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SERVICE" boolean DEFAULT false,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PA_HT" bigint DEFAULT 0,
    "T_POIDS" real DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1 NOT NULL,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "INDICE_0" bigint DEFAULT 0,
    "INDICE_N" bigint DEFAULT 0,
    "MONTANT_INITIAL" bigint DEFAULT 0,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "Q18" boolean DEFAULT false,
    "TARIF_Q18_HT" bigint DEFAULT 0,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "DATE" date,
    "ID_CONTACT" integer DEFAULT 1,
    "DATE_FIN" timestamp without time zone,
    "POURCENT_CCIP" character varying DEFAULT '...'::character varying,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text,
    "ACOMPTE" boolean DEFAULT false,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "POURCENT_REMISE" numeric DEFAULT 0,
    "POURCENT_ACOMPTE" numeric DEFAULT 100,
    "REPARTITION_POURCENT" numeric DEFAULT 0,
    "ID_TICKET_CAISSE" integer DEFAULT 1
);


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 2994 (class 1259 OID 531728)
-- Dependencies: 2993 10
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_VENTE_FACTURE_ELEMENT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11080 (class 0 OID 0)
-- Dependencies: 2994
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_VENTE_FACTURE_ELEMENT_ID_seq" OWNED BY "SAISIE_VENTE_FACTURE_ELEMENT"."ID";


--
-- TOC entry 11081 (class 0 OID 0)
-- Dependencies: 2994
-- Name: SAISIE_VENTE_FACTURE_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_VENTE_FACTURE_ELEMENT_ID_seq"', 2, false);


--
-- TOC entry 2995 (class 1259 OID 531730)
-- Dependencies: 2992 10
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SAISIE_VENTE_FACTURE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SAISIE_VENTE_FACTURE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11082 (class 0 OID 0)
-- Dependencies: 2995
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SAISIE_VENTE_FACTURE_ID_seq" OWNED BY "SAISIE_VENTE_FACTURE"."ID";


--
-- TOC entry 11083 (class 0 OID 0)
-- Dependencies: 2995
-- Name: SAISIE_VENTE_FACTURE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SAISIE_VENTE_FACTURE_ID_seq"', 2, false);


--
-- TOC entry 2996 (class 1259 OID 531732)
-- Dependencies: 5175 5176 5177 5178 5179 5180 5181 5182 5183 5184 5185 5186 5187 5188 5189 10
-- Name: SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SALARIE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ID_TITRE_PERSONNEL" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "PRENOM" character varying(45) DEFAULT ''::character varying,
    "NOM_JEUNE_FILLE" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_ETAT_CIVIL" integer DEFAULT 1,
    "ID_REGLEMENT_PAYE" integer DEFAULT 1,
    "ID_INFOS_SALARIE_PAYE" integer DEFAULT 1,
    "ID_FICHE_PAYE" integer DEFAULT 1,
    "ID_CUMULS_PAYE" integer DEFAULT 1,
    "DERNIER_MOIS" integer DEFAULT 0,
    "DERNIERE_ANNEE" integer DEFAULT 0,
    "ID_CUMULS_CONGES" integer DEFAULT 1,
    "ID_VARIABLE_SALARIE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SALARIE" OWNER TO openconcerto;

--
-- TOC entry 2997 (class 1259 OID 531750)
-- Dependencies: 2996 10
-- Name: SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SALARIE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11084 (class 0 OID 0)
-- Dependencies: 2997
-- Name: SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SALARIE_ID_seq" OWNED BY "SALARIE"."ID";


--
-- TOC entry 11085 (class 0 OID 0)
-- Dependencies: 2997
-- Name: SALARIE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SALARIE_ID_seq"', 2, false);


--
-- TOC entry 2998 (class 1259 OID 531762)
-- Dependencies: 5191 5192 5193 5194 5195 5196 5197 10
-- Name: SECTEUR_ACTIVITE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SECTEUR_ACTIVITE" (
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CONDITIONS" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SECTEUR_ACTIVITE" OWNER TO openconcerto;

--
-- TOC entry 2999 (class 1259 OID 531775)
-- Dependencies: 2998 10
-- Name: SECTEUR_ACTIVITE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."SECTEUR_ACTIVITE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11086 (class 0 OID 0)
-- Dependencies: 2999
-- Name: SECTEUR_ACTIVITE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SECTEUR_ACTIVITE_ID_seq" OWNED BY "SECTEUR_ACTIVITE"."ID";


--
-- TOC entry 11087 (class 0 OID 0)
-- Dependencies: 2999
-- Name: SECTEUR_ACTIVITE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SECTEUR_ACTIVITE_ID_seq"', 1, true);


--
-- TOC entry 3000 (class 1259 OID 531777)
-- Dependencies: 5199 5200 5201 5202 5203 10
-- Name: SITUATION_FAMILIALE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "SITUATION_FAMILIALE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "CODE" character varying DEFAULT ''::character varying,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."SITUATION_FAMILIALE" OWNER TO openconcerto;

--
-- TOC entry 3001 (class 1259 OID 531788)
-- Dependencies: 3000 10
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "SITUATION_FAMILIALE_ID_seq"
    START WITH 7
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."SITUATION_FAMILIALE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11088 (class 0 OID 0)
-- Dependencies: 3001
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "SITUATION_FAMILIALE_ID_seq" OWNED BY "SITUATION_FAMILIALE"."ID";


--
-- TOC entry 11089 (class 0 OID 0)
-- Dependencies: 3001
-- Name: SITUATION_FAMILIALE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"SITUATION_FAMILIALE_ID_seq"', 7, false);


--
-- TOC entry 3002 (class 1259 OID 531790)
-- Dependencies: 5205 5206 5207 5208 5209 10
-- Name: STOCK; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "STOCK" (
    "ID" integer NOT NULL,
    "QTE_REEL" real DEFAULT 0,
    "QTE_TH" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."STOCK" OWNER TO openconcerto;

--
-- TOC entry 3003 (class 1259 OID 531798)
-- Dependencies: 3002 10
-- Name: STOCK_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "STOCK_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."STOCK_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11090 (class 0 OID 0)
-- Dependencies: 3003
-- Name: STOCK_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "STOCK_ID_seq" OWNED BY "STOCK"."ID";


--
-- TOC entry 11091 (class 0 OID 0)
-- Dependencies: 3003
-- Name: STOCK_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"STOCK_ID_seq"', 2, false);


--
-- TOC entry 3004 (class 1259 OID 531800)
-- Dependencies: 5211 5212 5213 10
-- Name: STYLE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "STYLE" (
    "ID_STYLE" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "Default"."STYLE" OWNER TO openconcerto;

--
-- TOC entry 3005 (class 1259 OID 531809)
-- Dependencies: 3004 10
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "STYLE_ID_STYLE_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."STYLE_ID_STYLE_seq" OWNER TO openconcerto;

--
-- TOC entry 11092 (class 0 OID 0)
-- Dependencies: 3005
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "STYLE_ID_STYLE_seq" OWNED BY "STYLE"."ID_STYLE";


--
-- TOC entry 11093 (class 0 OID 0)
-- Dependencies: 3005
-- Name: STYLE_ID_STYLE_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"STYLE_ID_STYLE_seq"', 5, false);


--
-- TOC entry 3006 (class 1259 OID 531811)
-- Dependencies: 5215 5216 5217 5218 5219 5220 5221 5222 5223 10
-- Name: TAXE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TAXE" (
    "ID_TAXE" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "TAUX" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "CODE" character varying(2048) DEFAULT ''::text,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE_DED" integer DEFAULT 1,
    "ID_COMPTE_PCE_COLLECTE" integer DEFAULT 1
);


ALTER TABLE "Default"."TAXE" OWNER TO openconcerto;

--
-- TOC entry 3007 (class 1259 OID 531826)
-- Dependencies: 3006 10
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "TAXE_ID_TAXE_seq"
    START WITH 6
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."TAXE_ID_TAXE_seq" OWNER TO openconcerto;

--
-- TOC entry 11094 (class 0 OID 0)
-- Dependencies: 3007
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TAXE_ID_TAXE_seq" OWNED BY "TAXE"."ID_TAXE";


--
-- TOC entry 11095 (class 0 OID 0)
-- Dependencies: 3007
-- Name: TAXE_ID_TAXE_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TAXE_ID_TAXE_seq"', 6, false);


--
-- TOC entry 3008 (class 1259 OID 531828)
-- Dependencies: 5225 5226 5227 5228 5229 5230 5231 5232 5233 5234 5235 10
-- Name: TICKET_CAISSE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TICKET_CAISSE" (
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "DATE" timestamp without time zone,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "TOTAL_TTC" bigint DEFAULT 0,
    "TOTAL_TVA" bigint DEFAULT 0,
    "TOTAL_HT" bigint DEFAULT 0,
    "ID_CAISSE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1
);


ALTER TABLE "Default"."TICKET_CAISSE" OWNER TO openconcerto;

--
-- TOC entry 3009 (class 1259 OID 531845)
-- Dependencies: 3008 10
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."TICKET_CAISSE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11096 (class 0 OID 0)
-- Dependencies: 3009
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TICKET_CAISSE_ID_seq" OWNED BY "TICKET_CAISSE"."ID";


--
-- TOC entry 11097 (class 0 OID 0)
-- Dependencies: 3009
-- Name: TICKET_CAISSE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TICKET_CAISSE_ID_seq"', 1, true);


--
-- TOC entry 3010 (class 1259 OID 531847)
-- Dependencies: 5237 5238 5239 5240 5241 5242 10
-- Name: TITRE_PERSONNEL; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TITRE_PERSONNEL" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "SEXE_M" boolean DEFAULT true,
    "CODE" character varying(8) DEFAULT ''::character varying,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."TITRE_PERSONNEL" OWNER TO openconcerto;

--
-- TOC entry 3011 (class 1259 OID 531856)
-- Dependencies: 3010 10
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "TITRE_PERSONNEL_ID_seq"
    START WITH 5
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."TITRE_PERSONNEL_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11098 (class 0 OID 0)
-- Dependencies: 3011
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TITRE_PERSONNEL_ID_seq" OWNED BY "TITRE_PERSONNEL"."ID";


--
-- TOC entry 11099 (class 0 OID 0)
-- Dependencies: 3011
-- Name: TITRE_PERSONNEL_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TITRE_PERSONNEL_ID_seq"', 5, false);


--
-- TOC entry 3012 (class 1259 OID 531858)
-- Dependencies: 5244 5245 10
-- Name: TYPE_COMPTE_PCG; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TYPE_COMPTE_PCG" (
    "ID" integer NOT NULL,
    "RACINE" boolean DEFAULT false,
    "NOM" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "Default"."TYPE_COMPTE_PCG" OWNER TO openconcerto;

--
-- TOC entry 3013 (class 1259 OID 531866)
-- Dependencies: 3012 10
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "TYPE_COMPTE_PCG_ID_seq"
    START WITH 8
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."TYPE_COMPTE_PCG_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11100 (class 0 OID 0)
-- Dependencies: 3013
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TYPE_COMPTE_PCG_ID_seq" OWNED BY "TYPE_COMPTE_PCG"."ID";


--
-- TOC entry 11101 (class 0 OID 0)
-- Dependencies: 3013
-- Name: TYPE_COMPTE_PCG_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TYPE_COMPTE_PCG_ID_seq"', 8, false);


--
-- TOC entry 3014 (class 1259 OID 531868)
-- Dependencies: 5247 5248 5249 5250 5251 10
-- Name: TYPE_LETTRE_RELANCE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TYPE_LETTRE_RELANCE" (
    "ID" integer NOT NULL,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "MODELE" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."TYPE_LETTRE_RELANCE" OWNER TO openconcerto;

--
-- TOC entry 3015 (class 1259 OID 531879)
-- Dependencies: 3014 10
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."TYPE_LETTRE_RELANCE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11102 (class 0 OID 0)
-- Dependencies: 3015
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TYPE_LETTRE_RELANCE_ID_seq" OWNED BY "TYPE_LETTRE_RELANCE"."ID";


--
-- TOC entry 11103 (class 0 OID 0)
-- Dependencies: 3015
-- Name: TYPE_LETTRE_RELANCE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TYPE_LETTRE_RELANCE_ID_seq"', 2, true);


--
-- TOC entry 3016 (class 1259 OID 531881)
-- Dependencies: 5253 5254 5255 5256 5257 5258 5259 5260 10
-- Name: TYPE_REGLEMENT; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "TYPE_REGLEMENT" (
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "COMPTANT" boolean DEFAULT false,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_COMPTE_PCE_CLIENT" integer DEFAULT 1,
    "ID_COMPTE_PCE_FOURN" integer DEFAULT 1,
    "ECHEANCE" boolean DEFAULT false,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."TYPE_REGLEMENT" OWNER TO openconcerto;

--
-- TOC entry 3017 (class 1259 OID 531895)
-- Dependencies: 3016 10
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

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


ALTER TABLE "Default"."TYPE_REGLEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11104 (class 0 OID 0)
-- Dependencies: 3017
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "TYPE_REGLEMENT_ID_seq" OWNED BY "TYPE_REGLEMENT"."ID";


--
-- TOC entry 11105 (class 0 OID 0)
-- Dependencies: 3017
-- Name: TYPE_REGLEMENT_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"TYPE_REGLEMENT_ID_seq"', 9, true);


--
-- TOC entry 3018 (class 1259 OID 531897)
-- Dependencies: 5262 5263 5264 5265 5266 5267 5268 5269 10
-- Name: VARIABLE_SALARIE; Type: TABLE; Schema: Default; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "VARIABLE_SALARIE" (
    "ID" integer NOT NULL,
    "HEURE_ABS" real DEFAULT 0,
    "HEURE_110" real DEFAULT 0,
    "HEURE_125" real DEFAULT 0,
    "HEURE_150" real DEFAULT 0,
    "HEURE_200" real DEFAULT 0,
    "CONGES_PRIS" real DEFAULT 0,
    "HEURE_TRAV" real DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer,
    "ID_USER_COMMON_CREATE" integer,
    "CREATION_DATE" timestamp without time zone
);


ALTER TABLE "Default"."VARIABLE_SALARIE" OWNER TO openconcerto;

--
-- TOC entry 3019 (class 1259 OID 531908)
-- Dependencies: 3018 10
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE; Schema: Default; Owner: openconcerto
--

CREATE SEQUENCE "VARIABLE_SALARIE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "Default"."VARIABLE_SALARIE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11106 (class 0 OID 0)
-- Dependencies: 3019
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE OWNED BY; Schema: Default; Owner: openconcerto
--

ALTER SEQUENCE "VARIABLE_SALARIE_ID_seq" OWNED BY "VARIABLE_SALARIE"."ID";


--
-- TOC entry 11107 (class 0 OID 0)
-- Dependencies: 3019
-- Name: VARIABLE_SALARIE_ID_seq; Type: SEQUENCE SET; Schema: Default; Owner: openconcerto
--

SELECT pg_catalog.setval('"VARIABLE_SALARIE_ID_seq"', 2, false);



--
-- TOC entry 3020 (class 1259 OID 531910)
-- Dependencies: 5270 5271 5272 5273 5274 5276 7
-- Name: ACOMPTE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ACOMPTE" (
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MONTANT" real DEFAULT 0,
    "ID_SALARIE" integer DEFAULT 1,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."ACOMPTE" OWNER TO openconcerto;

--
-- TOC entry 3021 (class 1259 OID 531919)
-- Dependencies: 3020 7
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "ACOMPTE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ACOMPTE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11108 (class 0 OID 0)
-- Dependencies: 3021
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "ACOMPTE_ID_seq" OWNED BY "ACOMPTE"."ID";


--
-- TOC entry 11109 (class 0 OID 0)
-- Dependencies: 3021
-- Name: ACOMPTE_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"ACOMPTE_ID_seq"', 2, false);


--
-- TOC entry 3022 (class 1259 OID 531921)
-- Dependencies: 5277 5279 5280 5281 5282 5283 5284 5285 5286 5287 7
-- Name: ADRESSE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ADRESSE" (
    "MODIFICATION_DATE" timestamp without time zone,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8),
    "CODE_POSTAL" integer DEFAULT 0,
    "ID_ADRESSE" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DEST" character varying(2048) DEFAULT ''::text,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "CEDEX" integer,
    "RUE" character varying(2048) DEFAULT ''::text,
    "ID_CLIENT" integer DEFAULT 1,
    "HAS_CEDEX" boolean DEFAULT false,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "PAYS" character varying(100) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto42"."ADRESSE" OWNER TO openconcerto;

--
-- TOC entry 3023 (class 1259 OID 531937)
-- Dependencies: 3022 7
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto42"."ADRESSE_ID_ADRESSE_seq" OWNER TO openconcerto;

--
-- TOC entry 11110 (class 0 OID 0)
-- Dependencies: 3023
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "ADRESSE_ID_ADRESSE_seq" OWNED BY "ADRESSE"."ID_ADRESSE";


--
-- TOC entry 11111 (class 0 OID 0)
-- Dependencies: 3023
-- Name: ADRESSE_ID_ADRESSE_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"ADRESSE_ID_ADRESSE_seq"', 32, true);


--
-- TOC entry 3024 (class 1259 OID 531939)
-- Dependencies: 5288 5289 5291 5292 5293 5294 7
-- Name: AFFACTURAGE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AFFACTURAGE" (
    "ORDRE" numeric(16,8) DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "DATE" date,
    "ID" integer NOT NULL,
    "ARCHIVE" integer DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "NB_FACT" integer DEFAULT 0,
    "MONTANT_FACT" bigint DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."AFFACTURAGE" OWNER TO openconcerto;

--
-- TOC entry 3025 (class 1259 OID 531948)
-- Dependencies: 3024 7
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "AFFACTURAGE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AFFACTURAGE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11112 (class 0 OID 0)
-- Dependencies: 3025
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "AFFACTURAGE_ID_seq" OWNED BY "AFFACTURAGE"."ID";


--
-- TOC entry 11113 (class 0 OID 0)
-- Dependencies: 3025
-- Name: AFFACTURAGE_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"AFFACTURAGE_ID_seq"', 2, false);


--
-- TOC entry 3026 (class 1259 OID 532015)
-- Dependencies: 5295 5296 5297 5298 5299 5300 5301 5302 5303 5304 5305 5306 5307 5308 5309 5310 5311 5312 5313 5314 5315 5316 5318 5319 5320 5321 5322 7
-- Name: ARTICLE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ARTICLE" (
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "PV_TTC" bigint DEFAULT 0,
    "POIDS" real DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer,
    "ID_USER_COMMON_MODIFY" integer,
    "PA_HT" bigint DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "CREATION_AUTO" boolean DEFAULT false,
    "ORDRE" numeric(16,8),
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "ID_STOCK" integer DEFAULT 1,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "PV_HT" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID" integer NOT NULL,
    "CODE" character varying(45) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "OBSOLETE" boolean DEFAULT false,
    "ID_FAMILLE_ARTICLE" integer DEFAULT 1,
    "INFOS" character varying(2048) DEFAULT ''::character varying NOT NULL
);


ALTER TABLE "OpenConcerto42"."ARTICLE" OWNER TO openconcerto;

--
-- TOC entry 3027 (class 1259 OID 532048)
-- Dependencies: 3026 7
-- Name: ARTICLE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto42"."ARTICLE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11114 (class 0 OID 0)
-- Dependencies: 3027
-- Name: ARTICLE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "ARTICLE_ID_seq" OWNED BY "ARTICLE"."ID";


--
-- TOC entry 11115 (class 0 OID 0)
-- Dependencies: 3027
-- Name: ARTICLE_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"ARTICLE_ID_seq"', 27, true);


--
-- TOC entry 3028 (class 1259 OID 532050)
-- Dependencies: 5323 5324 5325 5326 5327 5329 7
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "ASSOCIATION_COMPTE_ANALYTIQUE" (
    "ID_REPARTITION_ANALYTIQUE" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID_AXE_ANALYTIQUE" integer DEFAULT 1,
    "ID" integer NOT NULL,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 3029 (class 1259 OID 532059)
-- Dependencies: 3028 7
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11116 (class 0 OID 0)
-- Dependencies: 3029
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq" OWNED BY "ASSOCIATION_COMPTE_ANALYTIQUE"."ID";


--
-- TOC entry 11117 (class 0 OID 0)
-- Dependencies: 3029
-- Name: ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"ASSOCIATION_COMPTE_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 3030 (class 1259 OID 532070)
-- Dependencies: 5330 5331 5332 5333 5335 5336 5337 5338 5339 5340 5341 5342 5343 5344 5345 5346 5347 5348 5349 5350 5351 5352 5353 5354 5355 5356 5357 7
-- Name: AVOIR_CLIENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_CLIENT" (
    "MONTANT_SOLDE" bigint DEFAULT 0,
    "SOLDE" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "MONTANT_SERVICE" bigint DEFAULT 0,
    "ID" integer NOT NULL,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "MOTIF" character varying DEFAULT ''::character varying,
    "ENVOYE_EN_AFFACTURAGE" boolean DEFAULT false,
    "REMISE_HT" bigint DEFAULT 0,
    "ID_COMMERCIAL" integer DEFAULT 1,
    "NOM" character varying(256) DEFAULT ''::character varying,
    "CREATION_DATE" timestamp without time zone,
    "MONTANT_TTC" bigint DEFAULT 0,
    "MONTANT_HT" bigint DEFAULT 0,
    "PORT_HT" bigint DEFAULT 0,
    "ID_ADRESSE" integer DEFAULT 1,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_COMPTE_PCE_SERVICE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "DATE_ENVOI_AFFACTURAGE" date,
    "ID_CLIENT" integer DEFAULT 1,
    "ID_CONTACT" integer DEFAULT 1,
    "DATE" date,
    "AFFACTURE" boolean DEFAULT false,
    "MONTANT_TVA" bigint DEFAULT 0,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "COMPTE_SERVICE_AUTO" boolean DEFAULT false,
    "AFFACTURAGE" boolean DEFAULT false,
    "A_DEDUIRE" boolean DEFAULT false,
    "ID_TAXE" integer DEFAULT 1,
    "MONTANT_RESTANT" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "NUMERO" character varying(45) DEFAULT ''::character varying
);


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT" OWNER TO openconcerto;

--
-- TOC entry 3031 (class 1259 OID 532104)
-- Dependencies: 5358 5359 5360 5361 5362 5363 5364 5365 5366 5367 5368 5369 5370 5371 5372 5373 5374 5375 5376 5377 5378 5379 5380 5381 5382 5383 5384 5385 5386 5387 5388 5389 5390 5391 5392 5393 5394 5395 5396 5397 5398 5399 5400 5401 5402 5403 5404 5405 5407 5408 5409 7
-- Name: AVOIR_CLIENT_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_CLIENT_ELEMENT" (
    "INDICE_N" bigint DEFAULT 0,
    "ID_CONTACT" integer DEFAULT 1,
    "LOCAL_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "T_PV_HT" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "POURCENT_SERVICE" character varying(2048) DEFAULT ''::text,
    "SOUS_ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "ID_STYLE" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "POIDS" real DEFAULT 0,
    "POURCENT_ACOMPTE" numeric DEFAULT 100,
    "CREATION_DATE" timestamp without time zone,
    "MONTANT_REVISABLE" boolean DEFAULT false,
    "TARIF_Q18_HT" bigint DEFAULT 0,
    "OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "ID_METRIQUE_2" integer DEFAULT 1,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "DATE" timestamp without time zone,
    "ID_TAXE" integer DEFAULT 1,
    "CODE_MISSION" character varying(45) DEFAULT ''::character varying,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "DATE_FIN" timestamp without time zone,
    "ACOMPTE" boolean DEFAULT false,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PV_HT" bigint DEFAULT 0,
    "PA_HT" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "Q18" boolean DEFAULT false,
    "T_POIDS" real DEFAULT 0,
    "MONTANT_INITIAL" bigint DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "POURCENT_REMISE" numeric DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_AVOIR_CLIENT" integer DEFAULT 1,
    "T_PV_TTC" bigint DEFAULT 0,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "NOM_MISSION" character varying(256) DEFAULT ''::character varying,
    "QTE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "ACTIVITE" character varying(45) DEFAULT ''::character varying,
    "INDICE_0" bigint DEFAULT 0,
    "INFOS_OBJET_INSPECTE" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "REFERENTIEL_INSPECTION" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "SITUATION_ADMIN" character varying(2048) DEFAULT ''::text
);


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 3032 (class 1259 OID 532163)
-- Dependencies: 3031 7
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ELEMENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11118 (class 0 OID 0)
-- Dependencies: 3032
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_CLIENT_ELEMENT_ID_seq" OWNED BY "AVOIR_CLIENT_ELEMENT"."ID";


--
-- TOC entry 11119 (class 0 OID 0)
-- Dependencies: 3032
-- Name: AVOIR_CLIENT_ELEMENT_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_CLIENT_ELEMENT_ID_seq"', 2, true);


--
-- TOC entry 3033 (class 1259 OID 532165)
-- Dependencies: 3030 7
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto42"."AVOIR_CLIENT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11120 (class 0 OID 0)
-- Dependencies: 3033
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_CLIENT_ID_seq" OWNED BY "AVOIR_CLIENT"."ID";


--
-- TOC entry 11121 (class 0 OID 0)
-- Dependencies: 3033
-- Name: AVOIR_CLIENT_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_CLIENT_ID_seq"', 2, true);


--
-- TOC entry 3034 (class 1259 OID 532167)
-- Dependencies: 5410 5411 5412 5413 5414 5415 5416 5417 5419 5420 5421 5422 5423 5424 5425 7
-- Name: AVOIR_FOURNISSEUR; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AVOIR_FOURNISSEUR" (
    "SOLDE" boolean DEFAULT false,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "MONTANT_TVA" bigint DEFAULT 0,
    "DATE" date,
    "NUMERO" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer,
    "A_DEDUIRE" boolean DEFAULT false,
    "CREATION_DATE" timestamp without time zone,
    "MODIFICATION_DATE" timestamp without time zone,
    "IMMO" boolean DEFAULT false,
    "ID_MOUVEMENT" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer,
    "ID" integer NOT NULL,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ID_FOURNISSEUR" integer DEFAULT 1,
    "MONTANT_HT" bigint DEFAULT 0,
    "ID_MODE_REGLEMENT" integer DEFAULT 1,
    "ARCHIVE" integer DEFAULT 0,
    "ID_TAXE" integer DEFAULT 1,
    "MONTANT_TTC" bigint DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."AVOIR_FOURNISSEUR" OWNER TO openconcerto;

--
-- TOC entry 3035 (class 1259 OID 532188)
-- Dependencies: 3034 7
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

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


ALTER TABLE "OpenConcerto42"."AVOIR_FOURNISSEUR_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11122 (class 0 OID 0)
-- Dependencies: 3035
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "AVOIR_FOURNISSEUR_ID_seq" OWNED BY "AVOIR_FOURNISSEUR"."ID";


--
-- TOC entry 11123 (class 0 OID 0)
-- Dependencies: 3035
-- Name: AVOIR_FOURNISSEUR_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"AVOIR_FOURNISSEUR_ID_seq"', 2, true);


--
-- TOC entry 3036 (class 1259 OID 532190)
-- Dependencies: 5426 5427 5428 5429 7
-- Name: AXE_ANALYTIQUE; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "AXE_ANALYTIQUE" (
    "CREATION_DATE" timestamp without time zone,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "NOM" character varying(2048) DEFAULT ''::text,
    "ORDRE" numeric(16,8),
    "ARCHIVE" integer DEFAULT 0,
    "ID" integer NOT NULL,
    "MODIFICATION_DATE" timestamp without time zone
);


ALTER TABLE "OpenConcerto42"."AXE_ANALYTIQUE" OWNER TO openconcerto;

--
-- TOC entry 3037 (class 1259 OID 532200)
-- Dependencies: 3036 7
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "AXE_ANALYTIQUE_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."AXE_ANALYTIQUE_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11124 (class 0 OID 0)
-- Dependencies: 3037
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "AXE_ANALYTIQUE_ID_seq" OWNED BY "AXE_ANALYTIQUE"."ID";


--
-- TOC entry 11125 (class 0 OID 0)
-- Dependencies: 3037
-- Name: AXE_ANALYTIQUE_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"AXE_ANALYTIQUE_ID_seq"', 2, false);


--
-- TOC entry 3038 (class 1259 OID 532202)
-- Dependencies: 5431 5432 5433 5434 5435 5436 5437 5438 5439 5440 5441 5442 5443 5444 5445 5446 5447 5449 5450 5451 5452 7
-- Name: BANQUE_POLE_PRODUIT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BANQUE_POLE_PRODUIT" (
    "NUMERO_COMPTE" character varying(2048) DEFAULT ''::text,
    "VILLE" character varying(2048) DEFAULT ''::text,
    "BIC" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_MODIFY" integer,
    "CODE_ETS" character varying(2048) DEFAULT ''::text,
    "CREATION_DATE" timestamp without time zone,
    "ORDRE" numeric(16,8) DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0,
    "CLE_RICE" character varying(2048) DEFAULT ''::text,
    "CODE_GUICHET" character varying(2048) DEFAULT ''::text,
    "RUE" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_POLE_PRODUIT" integer DEFAULT 1,
    "CODE" character varying(2048) DEFAULT ''::text,
    "IBAN" character varying(2048) DEFAULT ''::text,
    "ID_USER_COMMON_CREATE" integer,
    "VOIE" character varying(2048) DEFAULT ''::text,
    "NUMERO_RUE" character varying(2048) DEFAULT ''::text,
    "NOM" character varying(2048) DEFAULT ''::text,
    "DOMICILIATION" character varying(2048) DEFAULT ''::text,
    "CODE_POSTAL" character varying(2048) DEFAULT ''::text,
    "ID" integer NOT NULL,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "ID_COMPTE_PCE" integer DEFAULT 1,
    "ID_JOURNAL" integer DEFAULT 1,
    "AFFACTURAGE" boolean DEFAULT false
);


ALTER TABLE "OpenConcerto42"."BANQUE_POLE_PRODUIT" OWNER TO openconcerto;

--
-- TOC entry 3039 (class 1259 OID 532229)
-- Dependencies: 3038 7
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE; Schema: OpenConcerto42; Owner: openconcerto
--

CREATE SEQUENCE "BANQUE_POLE_PRODUIT_ID_seq"
    START WITH 2
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE "OpenConcerto42"."BANQUE_POLE_PRODUIT_ID_seq" OWNER TO openconcerto;

--
-- TOC entry 11126 (class 0 OID 0)
-- Dependencies: 3039
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE OWNED BY; Schema: OpenConcerto42; Owner: openconcerto
--

ALTER SEQUENCE "BANQUE_POLE_PRODUIT_ID_seq" OWNED BY "BANQUE_POLE_PRODUIT"."ID";


--
-- TOC entry 11127 (class 0 OID 0)
-- Dependencies: 3039
-- Name: BANQUE_POLE_PRODUIT_ID_seq; Type: SEQUENCE SET; Schema: OpenConcerto42; Owner: openconcerto
--

SELECT pg_catalog.setval('"BANQUE_POLE_PRODUIT_ID_seq"', 2, false);


--
-- TOC entry 3040 (class 1259 OID 532231)
-- Dependencies: 5454 5455 5456 5457 5458 5459 5460 5461 5462 5463 5464 7
-- Name: BON_DE_LIVRAISON; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_DE_LIVRAISON" (
    "ID_USER_COMMON_CREATE" integer,
    "DATE" date,
    "ID" integer NOT NULL,
    "ID_COMMANDE_CLIENT" integer DEFAULT 1,
    "NOM" character varying(45) DEFAULT ''::character varying,
    "ARCHIVE" integer DEFAULT 0,
    "CREATION_DATE" timestamp without time zone,
    "TOTAL_TTC" bigint DEFAULT 0,
    "ID_CLIENT" integer DEFAULT 1,
    "ORDRE" numeric(16,8),
    "TOTAL_TVA" bigint DEFAULT 0,
    "ID_USER_COMMON_MODIFY" integer,
    "TOTAL_HT" bigint DEFAULT 0,
    "INFOS" character varying(2048) DEFAULT ''::text,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_SAISIE_VENTE_FACTURE" integer DEFAULT 1,
    "NUMERO" character varying(45) DEFAULT ''::character varying,
    "TOTAL_POIDS" real DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON" OWNER TO openconcerto;

--
-- TOC entry 3041 (class 1259 OID 532248)
-- Dependencies: 5465 5466 5467 5468 5469 5470 5471 5472 5473 5474 5475 5476 5477 5478 5479 5480 5481 5482 5483 5484 5485 5486 5487 5488 5489 5490 5491 5492 5494 5495 5496 5497 5498 5499 7
-- Name: BON_DE_LIVRAISON_ELEMENT; Type: TABLE; Schema: OpenConcerto42; Owner: openconcerto; Tablespace: 
--

CREATE TABLE "BON_DE_LIVRAISON_ELEMENT" (
    "T_POIDS" real DEFAULT 0,
    "NOM" character varying(2048) DEFAULT ''::text,
    "T_PV_HT" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_1" bigint DEFAULT 0,
    "ID_METRIQUE_3" integer DEFAULT 1,
    "PV_HT" bigint DEFAULT 0,
    "ID_MODE_VENTE_ARTICLE" integer DEFAULT 1,
    "ID_USER_COMMON_MODIFY" integer DEFAULT 1,
    "ID_METRIQUE_1" integer DEFAULT 1,
    "VALEUR_METRIQUE_3" real DEFAULT 0,
    "SERVICE" boolean DEFAULT false,
    "VALEUR_METRIQUE_2" real DEFAULT 0,
    "ID_BON_DE_LIVRAISON" integer DEFAULT 1,
    "CREATION_DATE" timestamp without time zone,
    "PRIX_METRIQUE_VT_3" bigint DEFAULT 0,
    "PRIX_METRIQUE_HA_3" bigint DEFAULT 0,
    "QTE_A_LIVRER" integer DEFAULT 0,
    "ID_METRIQUE_2" bigint DEFAULT 1,
    "PRIX_METRIQUE_VT_1" bigint DEFAULT 0,
    "QTE" integer DEFAULT 0,
    "T_PV_TTC" bigint DEFAULT 0,
    "T_PA_HT" bigint DEFAULT 0,
    "MODIFICATION_DATE" timestamp without time zone,
    "ID_STYLE" integer DEFAULT 1,
    "VALEUR_METRIQUE_1" real DEFAULT 0,
    "PRIX_METRIQUE_VT_2" bigint DEFAULT 0,
    "CODE" character varying(45) DEFAULT ''::character varying,
    "POIDS" real DEFAULT 0,
    "ID_USER_COMMON_CREATE" integer DEFAULT 1,
    "T_POIDS_LIVREE" real DEFAULT 0,
    "ID" integer NOT NULL,
    "PA_HT" bigint DEFAULT 0,
    "ID_SAISIE_VENTE_FACTURE_ELEMENT" integer DEFAULT 1,
    "QTE_LIVREE" integer DEFAULT 0,
    "ORDRE" numeric(16,8),
    "ID_TAXE" integer DEFAULT 1,
    "PRIX_METRIQUE_HA_2" bigint DEFAULT 0,
    "ARCHIVE" integer DEFAULT 0
);


ALTER TABLE "OpenConcerto42"."BON_DE_LIVRAISON_ELEMENT" OWNER TO openconcerto;

--
-- TOC entry 3042 (class 1259 OID 532288)
-- Dependencies: 3041 7
