<commit_before>CREATE TABLE requestHistory (
  requestId varchar(100) NOT NULL,
  createdAt timestamp(3) NOT NULL DEFAULT '1971-01-01 00:00:01.000',
  requestState varchar(25) NOT NULL,
  user varchar(100) DEFAULT NULL,
  request blob NOT NULL,
  requestJson TEXT DEFAULT NULL,
  message varchar(280) DEFAULT NULL,
  PRIMARY KEY (requestId,createdAt)
);

CREATE TABLE deployHistory (
  requestId varchar(100) NOT NULL,
  deployId varchar(100) NOT NULL,
  createdAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  user varchar(100) DEFAULT NULL,
  deployStateAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  deployState varchar(25) NOT NULL,
  bytes mediumblob NOT NULL,
  deployJson TEXT DEFAULT NULL,
  message varchar(280) DEFAULT NULL,
  PRIMARY KEY (requestId,deployId),
  KEY requestId (requestId,createdAt)
);

CREATE TABLE taskHistory (
  taskId varchar(200) NOT NULL,
  requestId varchar(100) NOT NULL,
  updatedAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  lastTaskStatus varchar(25) DEFAULT NULL,
  bytes mediumblob NOT NULL,
  taskJson TEXT DEFAULT NULL,
  runId varchar(100) DEFAULT NULL,
  deployId varchar(100) DEFAULT NULL,
  host varchar(100) CHARACTER SET ascii DEFAULT NULL,
  startedAt timestamp NULL DEFAULT NULL,
  purged tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (taskId),
  KEY requestId (requestId,updatedAt),
  KEY runId (runId,requestId),
  KEY startedAt (requestId,startedAt),
  KEY lastTaskStatus (requestId,lastTaskStatus,startedAt),
  KEY deployId (requestId,deployId,startedAt),
  KEY host (requestId,host,startedAt),
  KEY host2 (host),
  KEY requestDeployUpdated (requestId, deployId, updatedAt),
  KEY hostUpdated (host, updatedAt),
  KEY updatedAt (updatedAt,requestId),
  KEY purged (requestId,purged,updatedAt),
  KEY startedAt3 (startedAt)
);<commit_msg>remove index from test sql<commit_after>CREATE TABLE requestHistory (
  requestId varchar(100) NOT NULL,
  createdAt timestamp(3) NOT NULL DEFAULT '1971-01-01 00:00:01.000',
  requestState varchar(25) NOT NULL,
  user varchar(100) DEFAULT NULL,
  request blob NOT NULL,
  requestJson TEXT DEFAULT NULL,
  message varchar(280) DEFAULT NULL,
  PRIMARY KEY (requestId,createdAt)
);

CREATE TABLE deployHistory (
  requestId varchar(100) NOT NULL,
  deployId varchar(100) NOT NULL,
  createdAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  user varchar(100) DEFAULT NULL,
  deployStateAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  deployState varchar(25) NOT NULL,
  bytes mediumblob NOT NULL,
  deployJson TEXT DEFAULT NULL,
  message varchar(280) DEFAULT NULL,
  PRIMARY KEY (requestId,deployId),
);

CREATE TABLE taskHistory (
  taskId varchar(200) NOT NULL,
  requestId varchar(100) NOT NULL,
  updatedAt timestamp NOT NULL DEFAULT '1971-01-01 00:00:01',
  lastTaskStatus varchar(25) DEFAULT NULL,
  bytes mediumblob NOT NULL,
  taskJson TEXT DEFAULT NULL,
  runId varchar(100) DEFAULT NULL,
  deployId varchar(100) DEFAULT NULL,
  host varchar(100) CHARACTER SET ascii DEFAULT NULL,
  startedAt timestamp NULL DEFAULT NULL,
  purged tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (taskId),
);
{'fraction_non_alphanumeric': 0.08738796414852752, 'fraction_numerical': 0.06722151088348272, 'mean_word_length': 5.091617933723197, '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': '1353198', 'n_tokens_mistral': 1129, 'n_tokens_neox': 950, 'n_words': 334}