<commit_before>--
-- example schema
-- --------------
-- schema file for sqlite3 database
-- to be used in this example
--

CREATE TABLE posts (
  `id`    INTEGER PRIMARY KEY,
  `uid`   INTEGER,
  `title` TEXT,
  `body`  TEXT,
  `size`  INTEGER,
  `date`  INTEGER
);

CREATE TABLE comments (
  `id`      INTEGER PRIMARY KEY,
  `post_id` INTEGER,<commit_msg>Improve Sqlite3 schema by adding drop statement<commit_after>--
-- example schema
-- --------------
-- schema file for sqlite3 database
-- to be used in this example
--

DROP TABLE IF EXISTS posts;
CREATE TABLE posts (
  `id`    INTEGER PRIMARY KEY,
  `uid`   INTEGER,
  `title` TEXT,
  `body`  TEXT,
  `size`  INTEGER,
  `date`  INTEGER
);

DROP TABLE IF EXISTS comments;
CREATE TABLE comments (
  `id`      INTEGER PRIMARY KEY,
  `post_id` INTEGER,
{'fraction_non_alphanumeric': 0.1412639405204461, 'fraction_numerical': 0.0037174721189591076, 'mean_word_length': 2.5594713656387666, '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': '812265', 'n_tokens_mistral': 295, 'n_tokens_neox': 271, 'n_words': 95}