<commit_before>drop database if exists taskmaster;
create database taskmaster character set utf8 collate utf8_unicode_ci;
grant all privileges on taskmaster.* to 'taskmaster'@'localhost' identified by '4ssTruck3r';
use taskmaster;

create table User (
  Id integer not null auto_increment,
  Email varchar(50) unique not null,
  Passwd varchar(40) not null,
  FullName varchar(80) null,
  IsActive boolean not null,
  primary key(id)
);

create table Crontab (
  Id integer not null auto_increment,
  UserId integer not null,
  CrontabString varchar(100) not null,
  DateCreation timestamp not null default current_timestamp, 
  DateLastModified timestamp, 
  DateLastExecution timestamp,
  Errors integer default 0,
  Success integer default 0,
  IsActive boolean not null,
  primary key(id)
);

<commit_msg>db schema<commit_after>drop database if exists taskmaster;
create database taskmaster character set utf8 collate utf8_unicode_ci;
grant all privileges on taskmaster.* to 'taskmaster'@'localhost' identified by '4ssTruck3r';
use taskmaster;

create table User (
  Id integer not null auto_increment,
  Email varchar(50) unique not null,
  Passwd varchar(40) not null,
  FullName varchar(80) null,
  IsActive boolean not null,
  primary key(id)
);

create table Crontab (
  Id integer not null auto_increment,
  UserId integer not null,
  CrontabString varchar(100) not null,
  DateCreation timestamp not null default current_timestamp, 
  DateLastModified timestamp, 
  DateLastExecution timestamp,
  Errors integer default 0,
  Success integer default 0,
  IsActive boolean not null,
  SrcURL    varchar(1024),
  DstURL    varchar(1024),
  SrcMethod varchar(16),
  DstMethod varchar(16),
  SrcBody   varchar(512),
  Policy    varchar(16),
  primary key(id)
);


{'fraction_non_alphanumeric': 0.0644431882419446, 'fraction_numerical': 0.026568682871678916, 'mean_word_length': 4.841584158415841, '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': '2194788', 'n_tokens_mistral': 571, 'n_tokens_neox': 521, 'n_words': 195}