<commit_before>CREATE TABLE IF NOT EXISTS tvshow (
  id      TEXT PRIMARY KEY,
  name    TEXT,
  quality TEXT
);


CREATE TABLE IF NOT EXISTS episode (
  tvshow_id          TEXT,
  season             INTEGER,
  number             INTEGER,
  title              TEXT,
  state              TEXT,
  link               TEXT,
  quality            TEXT,
  download_timestamp TEXT,

  FOREIGN KEY (tvshow_id) REFERENCES tvshow,

  PRIMARY KEY (tvshow_id, season, number)
);<commit_msg>Split Episode table into Episode and File<commit_after>CREATE TABLE IF NOT EXISTS tvshow (
  id      TEXT PRIMARY KEY,
  name    TEXT,
  quality TEXT
);


CREATE TABLE IF NOT EXISTS episode (
  tvshow_id          TEXT,
  season             INTEGER,
  number             INTEGER,
  title              TEXT NOT NULL,

  FOREIGN KEY (tvshow_id) REFERENCES tvshow,

  PRIMARY KEY (tvshow_id, season, number)
);


CREATE TABLE IF NOT EXISTS file (
  tvshow_id          TEXT NOT NULL,
  season             INTEGER NOT NULL,
  number             INTEGER NOT NULL,
  state              TEXT NOT NULL,
  link               TEXT NOT NULL,
  quality            TEXT NOT NULL,
  download_timestamp TEXT NOT NULL,

  FOREIGN KEY (tvshow_id, season, number) REFERENCES episode,

  PRIMARY KEY (tvshow_id, season, number)
);

{'fraction_non_alphanumeric': 0.052059052059052056, 'fraction_numerical': 0.0, 'mean_word_length': 1.9339407744874715, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 4, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7028583', 'n_tokens_mistral': 397, 'n_tokens_neox': 368, 'n_words': 138}