Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-10-17 15:16:31 +0200
committerErich Eckner <git@eckner.net>2018-10-17 15:16:31 +0200
commit3ba3ee500fa1d5d0eac9f98ffceab1d3e1645698 (patch)
tree3b8246c8c4ee37fc71516e346947433463d0494c
parentaf7a7ff715860a8d1e9037b700c7b5e9d839264e (diff)
misc/database-layout.dump: new columns/keys in `statistics`
-rw-r--r--misc/database-layout.dump5
1 files changed, 4 insertions, 1 deletions
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,