CREATE TABLE USER (
        USER_ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
        FIRSTNAME TEXT NOT NULL,
        MIDDLENAME TEXT,
        LASTNAME TEXT NOT NULL,
        NICKNAME TEXT NOT NULL,
        EMAIL VARCHAR(256) NOT NULL UNIQUE
) ENGINE=InnoDB;


CREATE TABLE BODYWEIGHT (
        USER_ID INTEGER UNSIGNED NOT NULL PRIMARY KEY,
        WEIGHT DECIMAL(6,2) NOT NULL,
        DAY DATE NOT NULL,
        FOREIGN KEY (USER_ID) REFERENCES USER(USER_ID) ON DELETE CASCADE
) ENGINE=InnoDB;