Switched to another legacy module

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index 43986e850e1b5eaee0ac018533b91f4d746c3da4..fbccddcb281da5145efbcbdfe0f23adead4df25d 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -1,6 +1,6 @@
 -- ------------------------------------------
 -- Friendica 2021.12-dev (Siberian Iris)
--- DB_UPDATE_VERSION 1441
+-- DB_UPDATE_VERSION 1443
 -- ------------------------------------------
 
 
@@ -681,16 +681,6 @@ CREATE TABLE IF NOT EXISTS `hook` (
         UNIQUE INDEX `hook_file_function` (`hook`,`file`,`function`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='addon hook registry';
 
---
--- TABLE host
---
-CREATE TABLE IF NOT EXISTS `host` (
-       `id` tinyint unsigned NOT NULL auto_increment COMMENT 'sequential ID',
-       `name` varchar(128) NOT NULL DEFAULT '' COMMENT 'The hostname',
-        PRIMARY KEY(`id`),
-        UNIQUE INDEX `name` (`name`)
-) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Hostname';
-
 --
 -- TABLE inbox-status
 --
@@ -715,7 +705,7 @@ CREATE TABLE IF NOT EXISTS `intro` (
        `contact-id` int unsigned NOT NULL DEFAULT 0 COMMENT '',
        `suggest-cid` int unsigned COMMENT 'Suggested contact',
        `knowyou` boolean NOT NULL DEFAULT '0' COMMENT '',
-       `duplex` boolean NOT NULL DEFAULT '0' COMMENT '',
+       `duplex` boolean NOT NULL DEFAULT '0' COMMENT 'deprecated',
        `note` text COMMENT '',
        `hash` varchar(255) NOT NULL DEFAULT '' COMMENT '',
        `datetime` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
@@ -1325,10 +1315,11 @@ CREATE TABLE IF NOT EXISTS `post-user-notification` (
 -- TABLE process
 --
 CREATE TABLE IF NOT EXISTS `process` (
-       `pid` int unsigned NOT NULL COMMENT '',
+       `pid` int unsigned NOT NULL COMMENT 'The ID of the process',
+       `hostname` varchar(32) NOT NULL COMMENT 'The name of the host the process is ran on',
        `command` varbinary(32) NOT NULL DEFAULT '' COMMENT '',
        `created` datetime NOT NULL DEFAULT '0001-01-01 00:00:00' COMMENT '',
-        PRIMARY KEY(`pid`),
+        PRIMARY KEY(`pid`,`hostname`),
         INDEX `command` (`command`)
 ) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Currently running system processes';