CREATE SCHEMA "MYSCHEMA";

CREATE TABLE "MYSCHEMA"."STAFF" (
    "STAFFNUM"   VARCHAR(10)  NOT NULL,
    "LASTCHANGE" DATE,
    "FIRSTNAME"  VARCHAR(30),
    "LASTNAME"   VARCHAR(30),
    "MAIL"       VARCHAR(100)
);

ALTER TABLE "MYSCHEMA"."STAFF" ADD CONSTRAINT "STAFF_PK" PRIMARY KEY ("STAFFNUM");