CREATE TABLE Users(
    id INTEGER,
    name VARCHAR(255),
    nickname VARCHAR(255),
    created DATETIME,
    CONSTRAINT u_nickname UNIQUE(nickname),
    CONSTRAINT fk_id FOREIGEN KEY(id) REFERENCE Kunde(user_id),
    PEIMARYKEY(id)
);

INSERT INTO Users VALUES(1,'Peter','Pet','YYY.MMM.DDD hh:mm:ss');
INSERT INTO Users(id,name)VALUES(2,'KLAUS');

ALTER TABLE Users DROP COLUMN created;
ALTER TABLE Users ADD passwort VARCHAR(255);

UPDATE Users SET name='Kai' WHERE ud=2;

DELETE FROM users WHERE id=2;