"DELETE FROM " + Tables.MOVIE_CREW + " WHERE " + Tables.MOVIE_CREW + "."
+ MovieCrewColumns.MOVIE_ID + "=OLD." + MovieColumns.ID + ";";
String MOVIE_DELETE_COMMENTS =
"DELETE FROM " + Tables.COMMENTS + " WHERE " + Tables.COMMENTS + "."
+ CommentColumns.ITEM_TYPE + "=" + DatabaseContract.ItemType.MOVIE + " AND "
<BUG>+ Tables.COMMENTS + "." + CommentColumns.ITEM_ID + "=OLD." + MovieColumns.ID + ";";
String TIME_MILLIS =</BUG>
"(strftime('%s','now') * 1000 + cast(substr(strftime('%f','now'),4,3) AS INTEGER))";
String SHOW_UPDATE =
"UPDATE " + Tables.SHOWS + " SET " + ShowColumns.LAST_MODIFIED + "=" + TIME_MILLIS

"DELETE FROM " + Tables.MOVIE_CREW + " WHERE " + Tables.MOVIE_CREW + "."
+ MovieCrewColumns.MOVIE_ID + "=OLD." + MovieColumns.ID + ";";
String MOVIE_DELETE_COMMENTS =
"DELETE FROM " + Tables.COMMENTS + " WHERE " + Tables.COMMENTS + "."
+ CommentColumns.ITEM_TYPE + "=" + DatabaseContract.ItemType.MOVIE + " AND "
+ Tables.COMMENTS + "." + CommentColumns.ITEM_ID + "=OLD." + MovieColumns.ID + ";";
String MOVIE_DELETE_RELATED =
"DELETE FROM " + Tables.MOVIE_RELATED + " WHERE " + Tables.MOVIE_RELATED + "."
+ RelatedMoviesColumns.MOVIE_ID + "=OLD." + MovieColumns.ID + ";";
String TIME_MILLIS =
"(strftime('%s','now') * 1000 + cast(substr(strftime('%f','now'),4,3) AS INTEGER))";
String SHOW_UPDATE =
"UPDATE " + Tables.SHOWS + " SET " + ShowColumns.LAST_MODIFIED + "=" + TIME_MILLIS
