add build architecture to schema of builds table

1 files changed, 2 insertions, 4 deletions

diff --git a/webapp.py b/webapp.py
index cc9de37..3d3af0d 100644
--- a/webapp.py
+++ b/webapp.py
@@ -370,8 +370,7 @@ def collect_depstate(conn, source):
 def show_index():
     with db.engine.connect() as conn:
         builds = list(conn.execute("""
-            SELECT source, version, 'amd64' AS buildarch,
-                architecture AS hostarch, starttime, filename,
+            SELECT source, version, buildarch, hostarch, starttime, filename,
                 ifnull((SELECT max(patched + 1) FROM bugs
                                                 WHERE affects = source),
                        0) AS buglvl
@@ -392,8 +391,7 @@ def show_source(source):
         context["version"], context["depresult"] = collect_depstate(conn,
                                                                     source)
         query = sqlalchemy.text("""
-            SELECT version, 'amd64' AS buildarch, architecture AS hostarch,
-                   success, starttime, filename
+            SELECT version, buildarch, hostarch, success, starttime, filename
                 FROM builds WHERE source = :source;""")
         context["builds"] = list(conn.execute(query, source=source))
         query = sqlalchemy.text("""