reproducible: store notes in the database. This is a initial work. It does nothing other than picking the yaml files and store it's content on the db

1 files changed, 15 insertions, 0 deletions

diff --git a/bin/reproducible_db_maintenance.py b/bin/reproducible_db_maintenance.py
index 5b82f5c4..17740398 100755
--- a/bin/reproducible_db_maintenance.py
+++ b/bin/reproducible_db_maintenance.py
@@ -339,6 +339,21 @@ schema_updates = {
         'UPDATE stats_builds_age SET suite = "unstable" WHERE suite = "sid"',
         'UPDATE stats_meta_pkg_state SET suite = "unstable" WHERE suite = "sid"',
         'INSERT INTO rb_schema VALUES ("9", "' + now + '")'],
+    10: [ # add the notes and issues tables
+        '''CREATE TABLE notes (
+            package_id INTEGER,
+            version TEXT NOT NULL,
+            issues TEXT,
+            bugs TEXT,
+            comments TEXT,
+            PRIMARY KEY (package_id),
+            FOREIGN KEY(package_id) REFERENCES sources(id))''',
+        '''CREATE TABLE issues (
+            name TEXT NOT NULL,
+            description TEXT NOT NULL,
+            url TEXT,
+            PRIMARY KEY (name))''',
+        'INSERT INTO rb_schema VALUES ("10", "' + now + '")'],
 }