X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fdbstructure.php;h=e455ee33335a2505a3d8fdb2daf33ac5e8221d9e;hb=2bad626be6a17423565a7aa69f001b8997da3efd;hp=882d736e1c17114475d382264bf1bafdfa88f432;hpb=4e49939421d39dfa971d8744691568bcdbdca15e;p=friendica.git

diff --git a/include/dbstructure.php b/include/dbstructure.php
index 882d736e1c..e455ee3333 100644
--- a/include/dbstructure.php
+++ b/include/dbstructure.php
@@ -1572,7 +1572,7 @@ function db_definition() {
 					),
 			"indexes" => array(
 					"PRIMARY" => array("id"),
-					"iid" => array("iid"),
+					"iid" => array("UNIQUE", "iid"),
 					)
 			);
 	$database["spam"] = array(
@@ -1740,12 +1740,14 @@ function db_definition() {
 					"created" => array("type" => "datetime", "not null" => "1", "default" => NULL_DATE),
 					"pid" => array("type" => "int(11)", "not null" => "1", "default" => "0"),
 					"executed" => array("type" => "datetime", "not null" => "1", "default" => NULL_DATE),
+					"done" => array("type" => "tinyint(1)", "not null" => "1", "default" => "0"),
 					),
 			"indexes" => array(
 					"PRIMARY" => array("id"),
 					"pid" => array("pid"),
 					"parameter" => array("parameter(64)"),
 					"priority_created" => array("priority", "created"),
+					"executed" => array("executed"),
 					)
 			);