1INDEXES = (
2    ('acl_groups_hosts', 'host_id'),
3    ('acl_groups_hosts', 'acl_group_id'),
4    ('acl_groups_users', 'user_id'),
5    ('acl_groups_users', 'acl_group_id'),
6)
7
8def get_index_name(table, field):
9    return table + '_' + field
10
11
12def migrate_up(manager):
13    for table, field in INDEXES:
14        manager.execute('CREATE INDEX %s ON %s (%s)' %
15                        (get_index_name(table, field), table, field))
16
17
18def migrate_down(manager):
19    for table, field in INDEXES:
20        manager.execute('DROP INDEX %s ON %s' %
21                        (get_index_name(table, field), table))
22