diff options
| author | Erich Eckner <git@eckner.net> | 2018-10-17 15:16:31 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-10-17 15:16:31 +0200 |
| commit | 3ba3ee500fa1d5d0eac9f98ffceab1d3e1645698 (patch) | |
| tree | 3b8246c8c4ee37fc71516e346947433463d0494c /misc/database-layout.dump | |
| parent | af7a7ff715860a8d1e9037b700c7b5e9d839264e (diff) | |
| download | builder-3ba3ee500fa1d5d0eac9f98ffceab1d3e1645698.tar.xz | |
misc/database-layout.dump: new columns/keys in `statistics`
Diffstat (limited to 'misc/database-layout.dump')
| -rw-r--r-- | misc/database-layout.dump | 5 |
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, |