<commit_before><?php
require 'connection_config.php';

$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
    echo "<br>Connection Error: Could not Connect.<a href='setup_getInput.php'>Click here to return to previous page.</a><br>";
    die();
}

// Create database
$sql = "CREATE DATABASE IF NOT EXISTS $dbName";
if ($conn->query($sql)) {
    echo "Database was created. <br>";
} else {
    echo "<br>Invalid Database name: Could not instantiate a database.<a href='setup_getInput.php'>Return</a><br>";
    die();
}
$conn->close();

require 'connection.php';

$sql = "CREATE TABLE $userTable (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  firstname VARCHAR(30) NOT NULL,
  lastname VARCHAR(30) NOT NULL,
  psw VARCHAR(60) NOT NULL,
  terminalPin INT(8) DEFAULT 4321,
  sid VARCHAR(50),
  email VARCHAR(50) UNIQUE NOT NULL,
  gender ENUM('female', 'male'),
  overTimeLump INT(3) DEFAULT 0,
  pauseAfterHours DECIMAL(4,2) DEFAULT 6,
  hoursOfRest DECIMAL(4,2) DEFAULT 0.5,
  beginningDate DATETIME DEFAULT UTC_TIMESTAMP,
  enableProjecting ENUM('TRUE', 'FALSE') DEFAULT 'FALSE',
  preferredLang ENUM('ENG', 'GER', 'FRA', 'ITA') DEFAULT 'GER',
  coreTime TIME DEFAULT '8:00'
)";<commit_msg>no utc for this then<commit_after><?php
require 'connection_config.php';

$conn = new mysqli($servername, $username, $password);
if ($conn->connect_error) {
    echo "<br>Connection Error: Could not Connect.<a href='setup_getInput.php'>Click here to return to previous page.</a><br>";
    die();
}

// Create database
$sql = "CREATE DATABASE IF NOT EXISTS $dbName";
if ($conn->query($sql)) {
    echo "Database was created. <br>";
} else {
    echo "<br>Invalid Database name: Could not instantiate a database.<a href='setup_getInput.php'>Return</a><br>";
    die();
}
$conn->close();

require 'connection.php';

$sql = "CREATE TABLE $userTable (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  firstname VARCHAR(30) NOT NULL,
  lastname VARCHAR(30) NOT NULL,
  psw VARCHAR(60) NOT NULL,
  terminalPin INT(8) DEFAULT 4321,
  sid VARCHAR(50),
  email VARCHAR(50) UNIQUE NOT NULL,
  gender ENUM('female', 'male'),
  overTimeLump INT(3) DEFAULT 0,
  pauseAfterHours DECIMAL(4,2) DEFAULT 6,
  hoursOfRest DECIMAL(4,2) DEFAULT 0.5,
  beginningDate DATETIME DEFAULT CURRENT_TIMESTAMP,
  enableProjecting ENUM('TRUE', 'FALSE') DEFAULT 'FALSE',
  preferredLang ENUM('ENG', 'GER', 'FRA', 'ITA') DEFAULT 'GER',
  coreTime TIME DEFAULT '8:00'
)";
{'fraction_non_alphanumeric': 0.14929006085192698, 'fraction_numerical': 0.022718052738336714, 'mean_word_length': 4.9709443099273605, 'pattern_counts': {'":': 0, '<': 23, '<?xml version=': 0, '>': 27, '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': '174753', 'n_tokens_mistral': 888, 'n_tokens_neox': 834, 'n_words': 250}