create table lightTankSizes (
    lightTankSizeID int not null primary key auto_increment,
    lightID varchar(32) not null references lights(lightID),
    tankSizeID varchar(32) not null references tankSizes(tankSizeID)
);
