From 3ba3ee500fa1d5d0eac9f98ffceab1d3e1645698 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 17 Oct 2018 15:16:31 +0200 Subject: misc/database-layout.dump: new columns/keys in `statistics` --- misc/database-layout.dump | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) diff --git a/misc/database-layout.dump b/misc/database-layout.dump index 010fdfd..f9fbde3 100644 --- a/misc/database-layout.dump +++ b/misc/database-layout.dump @@ -892,8 +892,11 @@ statistics CREATE TABLE `statistics` ( `locked_tasks_count` mediumint(9) NOT NULL, `blocked_tasks_count` mediumint(9) NOT NULL, `next_tasks_count` mediumint(9) NOT NULL, + `architecture` smallint(6) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), - UNIQUE KEY `date` (`date`) + UNIQUE KEY `date_architecture` (`date`,`architecture`), + KEY `architecture` (`architecture`), + CONSTRAINT `statistics_ibfk_1` FOREIGN KEY (`architecture`) REFERENCES `architectures` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci todo_links CREATE TABLE `todo_links` ( `dependent` bigint(20) NOT NULL, -- cgit v1.2.3-70-g09d2