From b40c38f58c6ff780b518e07a836dd683c971b5b3 Mon Sep 17 00:00:00 2001 From: Mario Date: Mon, 14 Aug 2023 07:38:36 +0000 Subject: missing semicolon --- install/schema_mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 0f407960d..71a5c8f92 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1629,4 +1629,4 @@ CREATE TABLE IF NOT EXISTS workerq ( KEY workerq_reservationid (workerq_reservationid), KEY workerq_processtimeout (workerq_uuid), KEY workerq_uuid (workerq_processtimeout) -) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4 +) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4; -- cgit v1.2.3 From 1acfc05e2db2ba5556b8d8596dcf7b3b99f75f6b Mon Sep 17 00:00:00 2001 From: Mario Date: Mon, 14 Aug 2023 07:58:44 +0000 Subject: fix index name mixup --- install/schema_mysql.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 71a5c8f92..e342c4605 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1627,6 +1627,6 @@ CREATE TABLE IF NOT EXISTS workerq ( workerq_cmd varchar(191) NOT NULL DEFAULT '', KEY workerq_priority (workerq_priority), KEY workerq_reservationid (workerq_reservationid), - KEY workerq_processtimeout (workerq_uuid), - KEY workerq_uuid (workerq_processtimeout) + KEY workerq_processtimeout (workerq_processtimeout), + KEY workerq_uuid (workerq_uuid) ) ENGINE = InnoDB DEFAULT CHARSET=utf8mb4; -- cgit v1.2.3 From b976adb8aa32e810aa261c34432e7efaf17cf227 Mon Sep 17 00:00:00 2001 From: Mario Vavti 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 From 0092b7c0a4d6cf49c092e2232af63f87be63142b Mon Sep 17 00:00:00 2001 From: Mario Vavti Date: Fri, 6 Oct 2023 14:28:59 +0200 Subject: should be tinyint instead of numeric for mysql --- install/schema_mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index cda82ed08..570ac6c86 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1205,7 +1205,7 @@ CREATE TABLE IF NOT EXISTS `updates` ( `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_update` tinyint(1) NOT NULL DEFAULT 0, `ud_host` char(191) NOT NULL DEFAULT '', PRIMARY KEY (`ud_id`), KEY `ud_date` (`ud_date`), -- cgit v1.2.3 From aad6042d425c390ebc3eed1b77636c854df739cc Mon Sep 17 00:00:00 2001 From: Mario Date: Thu, 9 Nov 2023 20:09:49 +0000 Subject: DB Update 1259 --- install/schema_mysql.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'install') diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 570ac6c86..b17b62962 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -217,7 +217,7 @@ CREATE TABLE IF NOT EXISTS `auth_codes` ( CREATE TABLE IF NOT EXISTS `cache` ( `k` char(191) NOT NULL DEFAULT '', - `v` text NOT NULL, + `v` mediumtext NOT NULL, `updated` datetime NOT NULL DEFAULT '0001-01-01 00:00:00', PRIMARY KEY (`k`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- cgit v1.2.3