X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-live.git;a=blobdiff_plain;f=yarrg%2Fdb-idempotent-populate;h=eb1a30b43a581047e330b4f226670083366e3fb0;hp=bb0448ce478389c1c030220514c1cdabe648f588;hb=6c12b260489687e82eaa1c6fed353dd2a40da838;hpb=5f3c445b5b9eda482c8098c115a9b5282e55f001

diff --git a/yarrg/db-idempotent-populate b/yarrg/db-idempotent-populate
index bb0448c..eb1a30b 100755
--- a/yarrg/db-idempotent-populate
+++ b/yarrg/db-idempotent-populate
@@ -229,6 +229,7 @@ table_maycompact('commods', 'commodid',
 	commodclassid	INTEGER			NOT NULL
 	ordval		INTEGER			NOT NULL
 	posinclass	INTEGER			NOT NULL
+	flags		TEXT			NOT NULL
 END
 
 table_maycompact('islands', 'islandid',
@@ -343,6 +344,7 @@ END
 			commodclassid
 			ordval
 			posinclass
+			flags
 			);
     my $insert= $dbh->prepare("
  INSERT OR IGNORE INTO $table{commods}
@@ -370,7 +372,8 @@ END
 			  $c->{Volume},
 			  $clid,
 			  commodsortkey($commod),
-			  $posincl{$commod}
+			  $posincl{$commod},
+			  $c->{Flags}
 			  );
 	$insert->execute($commod, @valuevalues);
 	$update->execute(@valuevalues, $commod);