MariaDB 10.4

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.4.17-MariaDB


create table rolls ( roll_id int unsigned not null auto_increment primary key, customer_id int unsigned not null, leftroll tinyint unsigned not null check (leftroll <= 6), rightroll tinyint unsigned not null check (rightroll <= 6), index i_customer(customer_id))
show create table rolls


Table
Create Table


rolls
CREATE TABLE `rolls` (
  `roll_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` int(10) unsigned NOT NULL,
  `leftroll` tinyint(3) unsigned NOT NULL CHECK (`leftroll` <= 6),
  `rightroll` tinyint(3) unsigned NOT NULL CHECK (`rightroll` <= 6),
  PRIMARY KEY (`roll_id`),
  KEY `i_customer` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1


insert into rolls (customer_id, leftroll,rightroll) values (2,1,1),(2,6,6)
insert into rolls  (customer_id, leftroll,rightroll) values (2,11,33)
CONSTRAINT `rolls.leftroll` failed for `db_1477387808`.`rolls`