DROP DATABASE IF EXISTS test;

CREATE DATABASE test;

USE test;

CREATE TABLE User

(

    Id               INT AUTO_INCREMENT PRIMARY KEY,

    Username         VARCHAR(50) NOT NULL

) WITH SYSTEM VERSIONING;

CREATE TABLE Products

(

    Id                INT AUTO_INCREMENT PRIMARY KEY,

    Name              VARCHAR(100) NOT NULL,

    ModifiedBy        INT NOT NULL,

    FOREIGN KEY(ModifiedBy) REFERENCES User(Id) ON DELETE CASCADE

) WITH SYSTEM VERSIONING;

INSERT INTO User(Username) VALUES ("admin");

INSERT INTO Products(Name, ModifiedBy) VALUES ("Apple", 1);

#Error is thrown on the delete

DELETE FROM User WHERE Username = "admin";