+ Trigger.SHOWS_UPDATE_WATCHED + Trigger.SHOWS_UPDATE_AIRDATE
+ Trigger.SHOWS_UPDATE_COLLECTED + " END;";
@ExecOnCreate public static final String TRIGGER_SHOW_DELETE =
"CREATE TRIGGER IF NOT EXISTS " + TriggerName.SHOW_DELETE + " AFTER DELETE ON " + Tables.SHOWS
+ " BEGIN " + Trigger.SHOW_DELETE_SEASONS + Trigger.SHOW_DELETE_GENRES
<BUG>+ Trigger.SHOW_DELETE_CHARACTERS + Trigger.SHOW_DELETE_COMMENTS + " END;";
@ExecOnCreate public static final String TRIGGER_SEASON_DELETE =</BUG>
"CREATE TRIGGER IF NOT EXISTS " + TriggerName.SEASON_DELETE + " AFTER DELETE ON "
+ Tables.SEASONS + " BEGIN " + Trigger.SEASON_DELETE_EPISODES + " END";
@ExecOnCreate public static final String TRIGGER_EPISODE_DELETE =

+ Trigger.SHOWS_UPDATE_WATCHED + Trigger.SHOWS_UPDATE_AIRDATE
+ Trigger.SHOWS_UPDATE_COLLECTED + " END;";
@ExecOnCreate public static final String TRIGGER_SHOW_DELETE =
"CREATE TRIGGER IF NOT EXISTS " + TriggerName.SHOW_DELETE + " AFTER DELETE ON " + Tables.SHOWS
+ " BEGIN " + Trigger.SHOW_DELETE_SEASONS + Trigger.SHOW_DELETE_GENRES
+ Trigger.SHOW_DELETE_CAST + Trigger.SHOW_DELETE_CREW + Trigger.SHOW_DELETE_COMMENTS
+ Trigger.SHOW_DELETE_RELATED + " END;";
@ExecOnCreate public static final String TRIGGER_SEASON_DELETE =
"CREATE TRIGGER IF NOT EXISTS " + TriggerName.SEASON_DELETE + " AFTER DELETE ON "
+ Tables.SEASONS + " BEGIN " + Trigger.SEASON_DELETE_EPISODES + " END";
@ExecOnCreate public static final String TRIGGER_EPISODE_DELETE =
