CREATE TABLE customers(
    ID              INT PRIMARY KEY NOT NULL
    , NAME          VARCHAR(10) NOT NULL
    , SURNAME       VARCHAR(20) NOT NULL
    , CITY          VARCHAR(20) NOT NULL
    , PLZ           INTEGER(4) NOT NULL
)