--
--


-- Started on 2022-11-10 12:05:40 CET





--
-- TOC entry 206 (class 1259 OID 13830548)
-- Name: coursetable; Type: TABLE; Schema: public; Owner: mdk
--

CREATE TABLE public.coursetable (
    id bigint NOT NULL,
    fullname character varying,
    shortname character varying,
    idnumber character varying
);


ALTER TABLE public.coursetable OWNER TO mdk;

--
-- TOC entry 207 (class 1259 OID 13830551)
-- Name: coursetable_id_seq; Type: SEQUENCE; Schema: public; Owner: mdk
--

ALTER TABLE public.coursetable ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.coursetable_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 204 (class 1259 OID 13830529)
-- Name: enroltable; Type: TABLE; Schema: public; Owner: mdk
--

CREATE TABLE public.enroltable (
    id bigint NOT NULL,
    courseid character varying,
    userid character varying,
    role character varying
);


ALTER TABLE public.enroltable OWNER TO mdk;

--
-- TOC entry 205 (class 1259 OID 13830538)
-- Name: enroltable_id_seq; Type: SEQUENCE; Schema: public; Owner: mdk
--

ALTER TABLE public.enroltable ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.enroltable_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);

--
-- TOC entry 2987 (class 0 OID 13830548)
-- Dependencies: 206
-- Data for Name: coursetable; Type: TABLE DATA; Schema: public; Owner: mdk
--

COPY public.coursetable (id, fullname, shortname, idnumber) FROM stdin;
1	MDLQA-17174-autocreate	MDLQA-17174-NewCourse	MDLQA-17174-NewCourse
\.


--
-- TOC entry 2985 (class 0 OID 13830529)
-- Dependencies: 204
-- Data for Name: enroltable; Type: TABLE DATA; Schema: public; Owner: mdk
--

COPY public.enroltable (id, courseid, userid, role) FROM stdin;
1	MDLQA-17174	myuser	student
\.



--
-- TOC entry 2856 (class 2606 OID 13830536)
-- Name: enroltable enroltable_pkey; Type: CONSTRAINT; Schema: public; Owner: mdk
--

ALTER TABLE ONLY public.enroltable
    ADD CONSTRAINT enroltable_pkey PRIMARY KEY (id);


-- Completed on 2022-11-10 12:05:40 CET

--
--

