<commit_before>create database if not exists dci_payroll;
use dci_payroll;

create table if not exists Address(
  addr_id int unsigned auto_increment not null,
  street_name varchar(100) not null,
  community varchar(100) not null,
  parish varchar(100) not null,
  primary key(addr_id)
);

create table if not exists Personnel(
  personnel_id int unsigned auto_increment not null,
  fname varchar(30) not null,
  lname varchar(30) not null,
  age int unsigned not null,
  address int unsigned not null,
  gender char not null,
  primary key(personnel_id)
);

create table if not exists Task(
  task_id int unsigned auto_increment not null,<commit_msg>added foreign key reference in personnel table.<commit_after>create database if not exists dci_payroll;
use dci_payroll;

create table if not exists Address(
  addr_id int unsigned auto_increment not null,
  street_name varchar(100) not null,
  community varchar(100) not null,
  parish varchar(100) not null,
  primary key(addr_id)
);

create table if not exists Personnel(
  personnel_id int unsigned auto_increment not null,
  fname varchar(30) not null,
  lname varchar(30) not null,
  age int unsigned not null,
  address int unsigned not null,
  gender char not null,
  primary key(personnel_id),
  foreign key(address) references Address(addr_id) on delete cascade on update cascade
);

create table if not exists Task(
  task_id int unsigned auto_increment not null,
{'fraction_non_alphanumeric': 0.056100981767180924, 'fraction_numerical': 0.0182328190743338, 'mean_word_length': 4.848360655737705, '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': '4309070', 'n_tokens_mistral': 451, 'n_tokens_neox': 424, 'n_words': 179}