X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdakdb%2Fupdate28.py;h=917877d4be439236c7fb31bfc7e922ff003436fa;hb=160df78096bad73425fa76dcc11df1be85df0df5;hp=bd91231cc6d97fd116832fdd112b58329272de8d;hpb=51a1b371b7f8325f26d8eef6d8bd6ce9d8d31a45;p=dak.git diff --git a/dak/dakdb/update28.py b/dak/dakdb/update28.py index bd91231c..917877d4 100755 --- a/dak/dakdb/update28.py +++ b/dak/dakdb/update28.py @@ -149,11 +149,11 @@ def do_update(self): arch_list = arches(c, suite_id) for (arch_id,arch_str) in arch_list: - c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%d) AND suite=%d"%(arch_str,suite,arch_id,suite_id) ) + c.execute( "CREATE INDEX ind_deb_contents_%s_%s ON deb_contents (arch,suite) WHERE (arch=2 OR arch=%s) AND suite=%s"%(arch_str,suite,arch_id,suite_id) ) for section, sname in [("debian-installer","main"), ("non-free/debian-installer", "nonfree")]: - c.execute( "CREATE INDEX ind_udeb_contents_%s_%s ON udeb_contents (section,suite) WHERE section=%s AND suite=%d"%(sname,suite,section,suite_id) ) + c.execute( "CREATE INDEX ind_udeb_contents_%s_%s ON udeb_contents (section,suite) WHERE section=%s AND suite=%s"%(sname,suite,section,suite_id) ) c.execute( """CREATE OR REPLACE FUNCTION update_contents_for_bin_a() RETURNS trigger AS $$