filename int4 not null references content_file_names(id) on delete cascade
);""")
+ c.execute("""CREATE TABLE temp_content_associations (
+ id serial not null,
+ package text not null,
+ version debversion not null,
+ filepath int4 not null references content_file_paths(id) on delete cascade,
+ filename int4 not null references content_file_names(id) on delete cascade
+ );""")
+
c.execute("""CREATE FUNCTION comma_concat(text, text) RETURNS text
AS $_$select case
WHEN $2 is null or $2 = '' THEN $1
INITCOND = ''
);""")
+ c.execute( "CREATE INDEX content_assocaitions_binary ON content_associations(binary_pkg)" )
+
c.execute("UPDATE config SET value = '2' WHERE name = 'db_revision'")
self.db.commit()