create table user

(

    id               int auto_increment primary key,

    username         varchar(50) not null

) engine innodb 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

) engine innodb with system versioning;

insert into user(username) values ("admin");

insert into products(name, modifiedby) values ("apple", 1);

delete from user where username = "admin";