From a49f5eca54b4bb37522719972de00007ed6bf1a0 Mon Sep 17 00:00:00 2001 From: APTX Date: Mon, 23 Jul 2012 19:34:42 +0200 Subject: [PATCH] type->source rename in rename_data --- localmylist/renameutils.cpp | 2 +- localmylist/share/schema/schema.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/localmylist/renameutils.cpp b/localmylist/renameutils.cpp index 0f8fc06..14e0a23 100644 --- a/localmylist/renameutils.cpp +++ b/localmylist/renameutils.cpp @@ -42,7 +42,7 @@ void setupRenameEnv(const QSqlRecord &record, RenameParser::Environment &env) env["Depr"] = /*r.value("")*/ false ? "1" : ""; // Data missing? env["Cen"] = record.value("censored").toBool() ? "1" : "0"; env["Ver"] = record.value("version").toString(); - env["Source"] = record.value("type").toString(); // TODO This is called source on AniDB + env["Source"] = record.value("source").toString(); env["Quality"] = record.value("quality").toString(); env["CurrentFN"] = QFileInfo(record.value("path").toString()).fileName(); env["FCrc"] = record.value("crc").toString(); diff --git a/localmylist/share/schema/schema.sql b/localmylist/share/schema/schema.sql index e924d56..2909620 100644 --- a/localmylist/share/schema/schema.sql +++ b/localmylist/share/schema/schema.sql @@ -207,7 +207,7 @@ CREATE VIEW rename_data AS (SELECT max(episode.epno) AS highest_epno FROM episode WHERE episode.aid = f.aid) AS highest_epno, e.anidb_update AS episode_anidb_update, e.entry_update AS episode_entry_update, e.my_update AS episode_my_update, e.epno, e.title_english AS episode_title_english, e.title_romaji AS episode_title_romaji, e.title_kanji AS episode_title_kanji, e.length AS episode_length, e.airdate, e.state, e.special, e.recap, e.opening, e.ending, e.rating, e.votes, e.my_vote, e.my_vote_date, - f.anidb_update, f.entry_update, f.my_update, f.ed2k, f.size, f.length, f.extension, f.group_name, f.group_name_short, f.crc, f.release_date, f.version, f.censored, f.type, f.quality_id, + f.anidb_update, f.entry_update, f.my_update, f.ed2k, f.size, f.length, f.extension, f.group_name, f.group_name_short, f.crc, f.release_date, f.version, f.censored, f.source, f.quality_id, f.quality, f.resolution, f.video_codec, f.audio_codec, f.audio_language, f.subtitle_language, f.aspect_ratio, f.my_watched, f.my_state, f.my_file_state, f.my_storage, f.my_source, f.my_other, fl.host_id, fl.path, fl.renamed, fl.failed_rename FROM file f -- 2.52.0