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,
