<commit_before>
CREATE TABLE ACCOUNT(
  username VARCHAR(32) NOT NULL,
  personname VARCHAR(64) NOT NULL,
  password VARCHAR(32) NOT NULL,
  PRIMARY KEY(username)
);

CREATE TABLE TEAM(
  teamnr INT NOT NULL AUTO_INCREMENT,
  teamname VARCHAR(32) NOT NULL,
  PRIMARY KEY(teamnr)
);

CREATE TABLE TEAM_MEMBER(
  username VARCHAR(32) NOT NULL,
  teamnr INT NOT NULL,
  PRIMARY KEY(username,teamnr),
  FOREIGN KEY(username) REFERENCES ACCOUNT(username),
  FOREIGN KEY(teamnr) REFERENCES TEAM(teamnr)
);

CREATE TABLE EVENT(
  eid INT NOT NULL AUTO_INCREMENT,
  eventname VARCHAR(32) NOT NULL,
  date DATE NOT NULL,
  start TIME NOT NULL,
  end TIME NOT NULL,
  creator VARCHAR(32) NOT NULL,
  PRIMARY KEY(eid),
  FOREIGN KEY(creator) REFERENCES ACCOUNT(username)
);

CREATE TABLE TEAM_EVENT (
  teamnr INT NOT NULL,
  eid INT NOT NULL,
  PRIMARY KEY(teamnr, eid),
  FOREIGN KEY(teamnr) REFERENCES TEAM(teamnr),
  FOREIGN KEY(eid) REFERENCES ACCOUNT(eid)
);

CREATE TABLE USER_EVENT(
  username VARCHAR(32) NOT NULL,
  eid INT NOT NULL,
  PRIMARY KEY(username,eid),
  FOREIGN KEY(username) REFERENCES ACCOUNT(username),
  FOREIGN KEY(eid) REFERENCES EVENT(eid)
);

<commit_msg>Change account back to user<commit_after>
CREATE TABLE USER(
  username VARCHAR(32) NOT NULL,
  name VARCHAR(64) NOT NULL,
  password VARCHAR(32) NOT NULL,
  PRIMARY KEY(username)
);

CREATE TABLE TEAM(
  teamnr INT NOT NULL AUTO_INCREMENT,
  teamname VARCHAR(32) NOT NULL,
  PRIMARY KEY(teamnr)
);

CREATE TABLE TEAM_MEMBER(
  username VARCHAR(32) NOT NULL,
  teamnr INT NOT NULL,
  PRIMARY KEY(username,teamnr),
  FOREIGN KEY(username) REFERENCES USER(username),
  FOREIGN KEY(teamnr) REFERENCES TEAM(teamnr)
);

CREATE TABLE EVENT(
  eid INT NOT NULL AUTO_INCREMENT,
  eventname VARCHAR(32) NOT NULL,
  date DATE NOT NULL,
  start TIME NOT NULL,
  end TIME NOT NULL,
  creator VARCHAR(32) NOT NULL,
  PRIMARY KEY(eid),
  FOREIGN KEY(creator) REFERENCES USER(username)
);

CREATE TABLE TEAM_EVENT (
  teamnr INT NOT NULL,
  eid INT NOT NULL,
  PRIMARY KEY(teamnr, eid),
  FOREIGN KEY(teamnr) REFERENCES TEAM(teamnr),
  FOREIGN KEY(eid) REFERENCES USER(eid)
);

CREATE TABLE USER_EVENT(
  username VARCHAR(32) NOT NULL,
  eid INT NOT NULL,
  PRIMARY KEY(username,eid),
  FOREIGN KEY(username) REFERENCES USER(username),
  FOREIGN KEY(eid) REFERENCES EVENT(eid)
);


{'fraction_non_alphanumeric': 0.08892689183411714, 'fraction_numerical': 0.013681060282171868, 'mean_word_length': 4.693430656934306, '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': '7365521', 'n_tokens_mistral': 904, 'n_tokens_neox': 844, 'n_words': 264}