set @tankID = 'entryway-bottom-right';
set @tankGroupID = 'entryway';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=Entryway-BottomRight&AquListBoxTank=Choose&AquTankLength=48&AquTankDepth=18&AquTankHeight=16&AquListBoxFilter=User+Defined&AquTextFilterRate=110+++++&AquListBoxFilter2=User+Defined&AquTextFilterRate2=50+++++&AquFilterString=Siamensis&AquListBoxChooser=Siamese+Algae+Eater+%28Crossocheilus+siamensis%29&AquTextBoxQuantity=1&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=200909300009%3A4%3A%3A%2C200909300005%3A6%3A%3A%2C200909300222%3A10%3A%3A%2C200909300046%3A1%3A%3A&FilterMode=Display+only+suitable+species+for+your+tank&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=2&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';

insert into tanks (tankID, tankSizeID, sortOrder, url, photo, label, tankGroupID, substrateType, isReady, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, '60-breeder-aqueon', 70, 'bottom-right', null, 'Bottom Right', @tankGroupID, 'ps', 1, 0, 'thievel-min-max', null, 101, 50, 115, 75.2, 77, 6, 7.8, 5, 15, @aqAdvisor);

/* lighting */
insert into tankLights (tankID, lightID, intensity) values (@tankID, 'beamswork-36', 40);

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'tidal-110', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'dvhey-80-gallon-sponge', 2);

/* pumps */
insert into airPumpGroupTanks (airPumpGroupID, tankID, sponge) values ('entryway-pump2', @tankID, 'main');

/* stocking */
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'angelfish', 'koi', 2, 2, 10);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'angelfish', 'zebra', 1, 1, 10);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 25);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'koi-sanke', 3, 3, 70, 1, 2);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'red-wag', 2, 2, 70, 1, 1);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'pineapple', 2, 2, 70, 0, 1);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'red-velvet', 2, 1, 70, 0, 1);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'green', 1, 1, 70, 0, 1);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder, haveMale, haveFemale) values (@tankID, 'swordtail', 'blue', 1, 1, 70, 0, 1);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'aeneas-corydoras', 'albino', 6, 6, 80);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'clown-pleco', 1, 1, 90);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'red-spotted', 1, 1, 90);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-nerite', 'zebra', 1, 1, 90);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'snail-mystery', 'brown', 1, 1, 99);

/* feeding */
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'flakes', 0, 1, 0, 1, 0, 1, 1);
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'wafers', 0, 0, 0, 1, 0, 0, 1);
-- insert into tankFeeding (tankID, foodTypeID, mon, tue, wed, thu, fri, sat, sun) values (@tankID, 'bugBites', 0, 1, 0, 0, 0, 1, 0);

/* plants */
insert into tankPlants (tankID, plantID) values
    (@tankID, 'anacharis-elodea'),
    (@tankID, 'jungle-val'),
    (@tankID, 'amazon-sword'),
    (@tankID, 'creeping-jenny'),
    (@tankID, 'water-wisteria'),
    (@tankID, 'tiger-lotus');

/* photos */
