DROP TABLE IF EXISTS cr_cursus;
DROP TABLE IF EXISTS cr_cours;

CREATE TABLE cr_cursus (
    cid		SERIAL PRIMARY KEY,
    nomcursus	VARCHAR(64),
    periodes	INTEGER);

CREATE TABLE cr_cours (
    id		SERIAL PRIMARY KEY,
    cid		INTEGER,
    nomcours	VARCHAR(128),
    heures  INTEGER,
    periode	INTEGER);
