create table tanks (
    tankID varchar(32) primary key,
    tankGroupID varchar(32) not null references tankGroups(tankGroupID),
    tankSizeID varchar(32) references tankSizes(tankSizeID),
    label varchar(32) not null,
    url varchar(32) not null,
    isReady tinyint default 0,
    isCichlidTank tinyint default 0,
    sortOrder integer not null,
    photo varchar(16),
    thermometerID varchar(32) references thermometers(thermometerID),
    heaterID varchar(32) references heaters(heaterID),
    filterPercent integer default 0,
    waterChangePercent integer default 0,
    stockPercent integer default 0,
    tempLow real default 0,
    tempHigh real default 0,
    phLow real default 0,
    phHigh real default 0,
    hardnessLow integer default 0,
    hardnessHigh integer default 0,
    aqAdvisor varchar(1024),
    isQuarantineTank tinyint default 0,
    quarantineStartDate datetime default null,
    waterType varchar(1) not null default 'f',
    substrateType varchar(16) not null default 'fs',
    labelWidth integer default 0
);
