create table tankFilters (
    tankLightID int not null primary key auto_increment,
    tankID varchar(32) not null references tanks(tankID),
	filterID varchar(32) not null references filters(filterID),
    tankFilterSortOrder int not null default 1
);
