<commit_before>CREATE TABLE `TaskType` (
  `TaskTypeID` INT         NOT NULL AUTO_INCREMENT,
  `Name`       VARCHAR(50) NOT NULL,
  PRIMARY KEY (`TaskTypeID`)
);

CREATE TABLE `Module` (
  `ModuleID` INT         NOT NULL AUTO_INCREMENT,
  `Name`     VARCHAR(50) NOT NULL,
  PRIMARY KEY (`ModuleID`)
);

CREATE TABLE `User` (
  `UserID`   INT                                    NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(255)                           NOT NULL,
  `Password` VARCHAR(255)                           NOT NULL,
  `Name`     VARCHAR(255),
  `RoleID`   ENUM('user', 'admin') DEFAULT 'user'   NOT NULL,
  PRIMARY KEY (`UserID`)
);

CREATE TABLE `Track` (
  `TrackID`     INT                                     NOT NULL AUTO_INCREMENT,
  `UserID`      INT                                     NOT NULL,
  `Location`    ENUM('Office', 'Home') DEFAULT 'Office' NOT NULL,
  `TimeStart`   DATETIME                                NULL,
  `TimeEnd`     DATETIME                                NULL,
  `Ticket`      INT,
  `TaskTypeID`  INT                                     NULL,
  `ModuleID`    INT,
  `Description` VARCHAR(500)                            NOT NULL,
  `IsDeleted`   SMALLINT(1) DEFAULT 0                   NOT NULL,
  PRIMARY KEY (`TrackID`),
  INDEX `IX_Track_IsDeleted` (`IsDeleted`),
  CONSTRAINT `FK_Track_Module` FOREIGN KEY (`ModuleID`) REFERENCES `Module` (`ModuleID`),
  CONSTRAINT `FK_Track_User` FOREIGN KEY (`UserID`) REFERENCES `User` (`UserID`),
  CONSTRAINT `FK_Track_TaskType` FOREIGN KEY (`TaskTypeID`) REFERENCES `timetracker`.`TaskType` (`TaskTypeID`)
);<commit_msg>Update create-tables.sql<commit_after>CREATE TABLE `TaskType` (
  `TaskTypeID` INT         NOT NULL AUTO_INCREMENT,
  `Name`       VARCHAR(50) NOT NULL,
  PRIMARY KEY (`TaskTypeID`)
);

CREATE TABLE `Module` (
  `ModuleID` INT         NOT NULL AUTO_INCREMENT,
  `Name`     VARCHAR(50) NOT NULL,
  PRIMARY KEY (`ModuleID`)
);

CREATE TABLE `User` (
  `UserID`   INT                                    NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(255)                           NOT NULL,
  `Password` VARCHAR(255)                           NOT NULL,
  `Name`     VARCHAR(255),
  `RoleID`   ENUM('user', 'admin') DEFAULT 'user'   NOT NULL,
  PRIMARY KEY (`UserID`)
);

CREATE TABLE `Track` (
  `TrackID`     INT                                     NOT NULL AUTO_INCREMENT,
  `UserID`      INT                                     NOT NULL,
  `Location`    ENUM('Office', 'Home') DEFAULT 'Office' NOT NULL,
  `TimeStart`   DATETIME                                NULL,
  `TimeEnd`     DATETIME                                NULL,
  `Ticket`      INT,
  `TaskTypeID`  INT                                     NULL,
  `ModuleID`    INT,
  `Description` VARCHAR(500)                            NOT NULL,
  `IsDeleted`   SMALLINT(1) DEFAULT 0                   NOT NULL,
  PRIMARY KEY (`TrackID`),
  INDEX `IX_Track_IsDeleted` (`IsDeleted`),
  CONSTRAINT `FK_Track_Module` FOREIGN KEY (`ModuleID`) REFERENCES `Module` (`ModuleID`),
  CONSTRAINT `FK_Track_User` FOREIGN KEY (`UserID`) REFERENCES `User` (`UserID`),
  CONSTRAINT `FK_Track_TaskType` FOREIGN KEY (`TaskTypeID`) REFERENCES `TaskType` (`TaskTypeID`)
);
{'fraction_non_alphanumeric': 0.1098661686896981, 'fraction_numerical': 0.011204481792717087, 'mean_word_length': 1.8518189884649512, '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': 16, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6168520', 'n_tokens_mistral': 1083, 'n_tokens_neox': 994, 'n_words': 261}