c.execute("""CREATE OR REPLACE VIEW bin_assoc_by_arch AS
SELECT ba.suite, ba.bin, a.id AS arch
FROM bin_associations ba
JOIN binaries b ON ba.bin = b.id, architecture a
c.execute("""CREATE OR REPLACE VIEW bin_assoc_by_arch AS
SELECT ba.suite, ba.bin, a.id AS arch
FROM bin_associations ba
JOIN binaries b ON ba.bin = b.id, architecture a