mal_id INTEGER, media VARCHAR(1), score INTEGER, start_date VARCHAR(10), --TIMESTAMP end_date VARCHAR(10), --TIMESTAMP status VARCHAR(1), finished_episodes INTEGER, finished_chapters INTEGER, finished_volumes INTEGER )'); R::exec('CREATE INDEX IF NOT EXISTS idx_usermedia_user_id ON usermedia (user_id)'); R::exec('CREATE INDEX IF NOT EXISTS idx_usermedia_score ON usermedia(score)'); R::exec('CREATE INDEX IF NOT EXISTS idx_usermedia_media_score ON usermedia(media,score)'); R::exec('CREATE INDEX IF NOT EXISTS idx_usermedia_media_mal_id ON usermedia(media,mal_id)'); foreach (Database::getAllDbNames() as $dbName) { $path2 = Config::$dbPath . DIRECTORY_SEPARATOR . $dbName; copy($path1, $path2); } unlink($path1); Database::loadDatabase('media.sqlite'); R::freeze(false); R::exec('CREATE TABLE IF NOT EXISTS media ( id INTEGER PRIMARY KEY, mal_id INTEGER, media VARCHAR(1), title VARCHAR(96), sub_type INTEGER, picture_url VARCHAR(256), average_score FLOAT, average_score_users INTEGER,