create or replace table t1 (

  x int,

  sys_start bigint unsigned as row start invisible,

  sys_end bigint unsigned as row end invisible,

  period for system_time (row_start, row_end)

) engine innodb with system versioning;

begin;

insert into t1 values (1);

delete from t1;

commit;