# -*- coding: utf-8 -*-
from trac.db import DatabaseManager
def do_upgrade(env, cursor):
db_connector, _ = DatabaseManager(env)._get_connector()
# Create indices for forum, topic and message times.
cursor.execute("CREATE INDEX forum_time_idx "
"ON forum (time)")
cursor.execute("CREATE INDEX topic_time_idx "
"ON topic (time)")
cursor.execute("CREATE INDEX message_time_idx "
"ON message (time)")
# Set database schema version.
cursor.execute("UPDATE system "
"SET value = '4' "
"WHERE name = 'discussion_version'")