--
-- PostgreSQL database dump
--

--
-- TOC entry 629 (class 1259 OID 226857)
-- Name: db_sys_regions; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE db_sys_regions (
    id_reg integer NOT NULL,
    titre_fr_reg character varying,
    titre_ar_reg character varying,
    abrev_reg character varying,
    date_creation timestamp without time zone,
    date_modification timestamp without time zone,
    desc_reg character varying
);


ALTER TABLE db_sys_regions OWNER TO postgres;

--
-- TOC entry 628 (class 1259 OID 226855)
-- Name: db_sys_regions_id_reg_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE db_sys_regions_id_reg_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE db_sys_regions_id_reg_seq OWNER TO postgres;

--
-- TOC entry 5832 (class 0 OID 0)
-- Dependencies: 628
-- Name: db_sys_regions_id_reg_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE db_sys_regions_id_reg_seq OWNED BY db_sys_regions.id_reg;


--
-- TOC entry 5695 (class 2604 OID 226860)
-- Name: db_sys_regions id_reg; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY db_sys_regions ALTER COLUMN id_reg SET DEFAULT nextval('db_sys_regions_id_reg_seq'::regclass);


--
-- TOC entry 5697 (class 2606 OID 226865)
-- Name: db_sys_regions regions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY db_sys_regions
    ADD CONSTRAINT regions_pkey PRIMARY KEY (id_reg);


-- Completed on 2019-01-15 18:17:31

--
-- PostgreSQL database dump complete
--

