create table tankLights (
    tankLightID int not null primary key auto_increment,
    tankID varchar(32) not null references tanks(tankID),
	lightID varchar(32) not null references lights(lightID),
	intensity varchar(32) not null default 100,
    shareRatio decimal(4,3) not null default '1'
);
