diff options
author | Antanas Uršulis <antanas.ursulis@gmail.com> | 2013-07-30 01:38:23 +0300 |
---|---|---|
committer | Antanas Uršulis <antanas.ursulis@gmail.com> | 2013-07-30 01:38:23 +0300 |
commit | 7ba5f957c082545a9eb097839fdc7eba826a7d80 (patch) | |
tree | cb10b75ef04167ea7ac127f5fb882b11fdc4cfe5 /schema_portage.sql | |
parent | Add hostname to schema (diff) | |
download | log-analysis-7ba5f957c082545a9eb097839fdc7eba826a7d80.tar.gz log-analysis-7ba5f957c082545a9eb097839fdc7eba826a7d80.tar.bz2 log-analysis-7ba5f957c082545a9eb097839fdc7eba826a7d80.zip |
Implement additional metadata storage for logs received from Portage
Flags like 'pkg_failed', 'test_failed', etc. are stored once per group.
This is a discussion item, as it might make sense to store some data
once per file instead.
Diffstat (limited to 'schema_portage.sql')
-rw-r--r-- | schema_portage.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/schema_portage.sql b/schema_portage.sql new file mode 100644 index 0000000..4b9c80d --- /dev/null +++ b/schema_portage.sql @@ -0,0 +1,10 @@ +create table if not exists `groups_portage` ( + `id` int primary key, + `pkg_name` varchar(255) not null, + `matches` int not null, + `pkg_failed` bool not null, + `test_failed` bool not null, + `collision` bool not null, + `bug_assignee` text not null, + `bug_cc` text not null +); |