create table tankStocking (
    tankStockingID int not null primary key auto_increment,
    tankID varchar(32) not null references tanks(tankID),
	speciesID varchar(32) not null references species(speciesID),
	pattern varchar(20) default '' not null,
	planned tinyint not null,
	plannedMale tinyint default 0,
	plannedFemale tinyint default 0,
	have tinyint default 0,
	haveMale tinyint default 0,
	haveFemale tinyint default 0,
	isTemporary tinyint default 0,
	moveToAfterQuarantine varchar(32),
	sortOrder tinyint default 1
);
