<commit_before>DROP TABLE IF EXISTS books;
CREATE TABLE IF NOT EXISTS books (
  id SERIAL PRIMARY KEY,
  description TEXT,
  image_url VARCHAR(512),
  title VARCHAR(256) NOT NULL
);

DROP TABLE IF EXISTS authors;
CREATE TABLE IF NOT EXISTS authors (
  id SERIAL PRIMARY KEY,
  name VARCHAR(256) NOT NULL
);

DROP TABLE IF EXISTS genres;
CREATE TABLE IF NOT EXISTS genres (
  id SERIAL PRIMARY KEY,
  name VARCHAR(256) NOT NULL
);

-- we create our join table below
DROP TABLE IF EXISTS book_authors;
CREATE TABLE IF NOT EXISTS book_authors (
  book_id INTEGER,
  author_id INTEGER
);
<commit_msg>change author & genre in schema file to accept only unique values<commit_after>DROP TABLE IF EXISTS books;
CREATE TABLE IF NOT EXISTS books (
  id SERIAL PRIMARY KEY,
  description TEXT,
  image_url VARCHAR(512),
  title VARCHAR(256) NOT NULL
);

DROP TABLE IF EXISTS authors;
CREATE TABLE IF NOT EXISTS authors (
  id SERIAL PRIMARY KEY,
  name VARCHAR(256) NOT NULL UNIQUE
);

DROP TABLE IF EXISTS genres;
CREATE TABLE IF NOT EXISTS genres (
  id SERIAL PRIMARY KEY,
  name VARCHAR(256) NOT NULL UNIQUE
);

-- we create our join table below
DROP TABLE IF EXISTS book_authors;
CREATE TABLE IF NOT EXISTS book_authors (
  book_id INTEGER,
  author_id INTEGER
);

{'fraction_non_alphanumeric': 0.05643879173290938, 'fraction_numerical': 0.019077901430842606, 'mean_word_length': 4.117886178861789, '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': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7106876', 'n_tokens_mistral': 448, 'n_tokens_neox': 385, 'n_words': 176}