From b976adb8aa32e810aa261c34432e7efaf17cf227 Mon Sep 17 00:00:00 2001
From: Mario Vavti <mario@mariovavti.com>
Date: Fri, 6 Oct 2023 14:24:33 +0200
Subject: add missing columns in install script

---
 install/schema_mysql.sql    | 7 ++++---
 install/schema_postgres.sql | 6 ++++--
 2 files changed, 8 insertions(+), 5 deletions(-)

(limited to 'install')

diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql
index e342c4605..cda82ed08 100644
--- a/install/schema_mysql.sql
+++ b/install/schema_mysql.sql
@@ -1201,18 +1201,19 @@ CREATE TABLE IF NOT EXISTS `tokens` (
 CREATE TABLE IF NOT EXISTS `updates` (
   `ud_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `ud_hash` char(191) NOT NULL DEFAULT '',
-  `ud_guid` char(191) NOT NULL DEFAULT '',
   `ud_date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `ud_last` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
   `ud_flags` int(11) NOT NULL DEFAULT 0 ,
   `ud_addr` char(191) NOT NULL DEFAULT '',
+  `ud_update` numeric(1) NOT NULL DEFAULT 0,
+  `ud_host` char(191) NOT NULL DEFAULT '',
   PRIMARY KEY (`ud_id`),
   KEY `ud_date` (`ud_date`),
-  KEY `ud_guid` (`ud_guid`),
   KEY `ud_hash` (`ud_hash`),
   KEY `ud_flags` (`ud_flags`),
   KEY `ud_addr` (`ud_addr`),
-  KEY `ud_last` (`ud_last`)
+  KEY `ud_last` (`ud_last`),
+  KEY `ud_update` (`ud_update`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4;
 
 CREATE TABLE IF NOT EXISTS `verify` (
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 6d7fe910b..42c65b171 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1194,19 +1194,21 @@ create index "tokens_uid" on tokens ("uid");
 CREATE TABLE "updates" (
   "ud_id" serial  NOT NULL,
   "ud_hash" varchar(128) NOT NULL,
-  "ud_guid" text NOT NULL DEFAULT '',
   "ud_date" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "ud_last" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "ud_flags" bigint NOT NULL DEFAULT '0',
   "ud_addr" text NOT NULL DEFAULT '',
+  "ud_update" smallint NOT NULL DEFAULT '0',
+  "ud_host" text NOT NULL DEFAULT '',
   PRIMARY KEY ("ud_id")
 );
 create index "ud_date" on updates ("ud_date");
-create index "ud_guid" on updates ("ud_guid");
 create index "ud_hash" on updates ("ud_hash");
 create index "ud_flags" on updates ("ud_flags");
 create index "ud_addr" on updates ("ud_addr");
 create index "ud_last" on updates ("ud_last");
+create index "ud_update" on updates ("ud_update");
+
 CREATE TABLE "verify" (
   "id" serial  NOT NULL,
   "channel" bigint  NOT NULL DEFAULT '0',
-- 
cgit v1.2.3