set @tankID = 'corner';
set @tankGroupID = 'corner';
set @aqAdvisor = 'https://aqadvisor.com/AqAdvisor.php?AquTankName=Display360G&AquListBoxTank=Choose&AquTankLength=72&AquTankDepth=48&AquTankHeight=24&AquListBoxFilter=Choose&AquTextFilterRate=N%2FA+&AquFilterString=brist&AquListBoxChooser=Bristlenose+Pleco+%28Ancistrus+sp.%29&AquTextBoxQuantity=1&FormSubmit=Add+%3E&AquTextBoxRemoveQuantity=&AlreadySelected=200909300012%3A6%3A%3A%2C200909300207%3A1%3A%3A%2C200909300162%3A8%3A%3A%2C200909300045%3A6%3A%3A%2C201001061671%3A20%3A%3A%2C200909300029%3A1%3A%3A%2C200911041032%3A6%3A%3A%2C200909300153%3A1%3A%3A&FilterMode=Display+only+suitable+species+for+your+tank&AqTempUnit=F&AqVolUnit=gUS&AqLengthUnit=inch&AqSortType=cname&FilterQuantity=1&AqJuvMode=&AqSpeciesWindowSize=short&AqSearchMode=simple';

insert into tanks (tankID, tankSizeID, sortOrder, url, photo, label, tankGroupID, isReady, isCichlidTank, thermometerID, heaterID, filterPercent, waterChangePercent, stockPercent, tempLow, tempHigh, phLow, phHigh, hardnessLow, hardnessHigh, aqAdvisor)
    values (@tankID, 'tsunami-72x48x24', 10, 'corner', null, 'Display', @tankGroupID, 1, 0, null, null, 0, 42, 127, 75.2, 77, 7, 7.8, 5, 12, @aqAdvisor);


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

/* filtration */
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-60', 1);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-return-pump-corner', 2);
insert into tankFilters (tankID, filterID, tankFilterSortOrder) values (@tankID, 'sump-return-pump-corner', 3);

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

/* stocking */
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'bala-shark', 6, 5, 1);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'redline-barb', 20, 4, 2);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'three-spot-gourami', 'opaline', 1, 1, 3);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'siamese-algae-eater', 1, 1, 4);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'otocinclus', 1, 1, 4);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'dojo-loach', 3, 2, 5);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'dojo-loach', 'golden', 3, 2, 5);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'pictus-catfish', 8, 0, 7);
insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'clown-loach', 6, 0, 8);
-- insert into tankStocking (tankID, speciesID, planned, have, sortOrder) values (@tankID, 'common-pleco', 1, 0, 9);
insert into tankStocking (tankID, speciesID, pattern, planned, have, sortOrder) values (@tankID, 'bristlenose-pleco', 'longfin', 1, 1, 10);

/* plants */
insert into tankPlants (tankID, plantID) values
    -- (@tankID, 'water-lettuce'),
    -- (@tankID, 'water-hyacinth'),
    (@tankID, 'java-fern'),
    (@tankID, 'cabomba-caroliniana');

/* photos */
