Mercurial > bmsapp / changeset

--- a/src/EditYeastPack.cpp	Mon Jan 30 17:05:13 2023 +0100
+++ b/src/EditYeastPack.cpp	Tue Jan 31 11:10:14 2023 +0100
@@ -122,11 +122,11 @@
     	if (this->recno == -1) {
     	    query.prepare("INSERT INTO inventory_yeastpack SET laboratory=:laboratory, form=:form, "
 		"package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, "
-		"size=:size, used='0', uuid = :uuid");
+		"size=:size, used='0', valid='1', uuid = :uuid");
     	} else {
 	    query.prepare("UPDATE inventory_yeastpack SET laboratory=:laboratory, form=:form, "
 		"package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, "
-                "size=:size WHERE record = :recno");
+                "size=:size, valid='1' WHERE record = :recno");
     	}
 	query.bindValue(":laboratory", ui->laboratoryEdit->text());
 	query.bindValue(":form", ui->formEdit->currentIndex());
@@ -165,7 +165,7 @@
     QSqlQuery query;
     query.prepare("INSERT INTO inventory_yeastpack SET laboratory=:laboratory, form=:form, "
                 "package=:package, notes=:notes, cells=:cells, viability=:viability, max=:max, "
-                "size=:size, used=:used, uuid=:uuid");
+                "size=:size, used=:used, valid='0', uuid=:uuid");
     query.bindValue(":laboratory", ui->laboratoryEdit->text());
     query.bindValue(":form", ui->formEdit->currentIndex());
     query.bindValue(":package", ui->packageEdit->text() + " [copy]");

--- a/src/MainWindow.cpp	Mon Jan 30 17:05:13 2023 +0100
+++ b/src/MainWindow.cpp	Tue Jan 31 11:10:14 2023 +0100
@@ -186,6 +186,7 @@
 		"`max` tinyint(4) NOT NULL DEFAULT 100,"
   		"`size` float NOT NULL DEFAULT 0,"
 		"`used` int(11) NOT NULL DEFAULT 0,"
+		"`valid` tinyint(1) NOT NULL DEFAULT 0,"
   		"PRIMARY KEY (`record`),"
   		"UNIQUE KEY `uuid` (`uuid`),"
 		"UNIQUE KEY `package` (`laboratory`,`form`,`package`),"