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.

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
+);