We got rid of two workerqueue queries, yeah!

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 4a5946ef38dc747b8c210e7f4f5b84ea60e046a4..7f7e975e72818ef4ce84f8dd2a070e90ef9bfd07 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
--- Friendica 3.5.2-rc (Asparagus)
--- DB_UPDATE_VERSION 1227
+-- Friendica 3.5.3dev (Asparagus)
+-- DB_UPDATE_VERSION 1228
 -- ------------------------------------------
 
 
@@ -580,7 +580,7 @@ CREATE TABLE IF NOT EXISTS `locks` (
        `id` int(11) NOT NULL auto_increment,
        `name` varchar(128) NOT NULL DEFAULT '',
        `locked` tinyint(1) NOT NULL DEFAULT 0,
-       `created` datetime DEFAULT '0001-01-01 00:00:00',
+       `pid` int(10) unsigned NOT NULL DEFAULT 0,
         PRIMARY KEY(`id`)
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
@@ -1116,6 +1116,7 @@ CREATE TABLE IF NOT EXISTS `workerqueue` (
        `executed` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
         PRIMARY KEY(`id`),
         INDEX `pid` (`pid`),
+        INDEX `parameter` (`parameter`(192)),
         INDEX `priority_created` (`priority`,`created`)
 ) DEFAULT COLLATE utf8mb4_general_ci;