<commit_before><?php

namespace Kanboard\Plugin\Chat\Schema;

use PDO;

const VERSION = 1;

function version_1(PDO $pdo)
{
    $pdo->exec('CREATE TABLE chat_messages (
        `id` INT NOT NULL AUTO_INCREMENT,
        `message` TEXT NOT NULL,
        `user_id` INT NOT NULL,
        `creation_date` INT NOT NULL,
        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
    ) ENGINE=InnoDB CHARSET=utf8');

    $pdo->exec('CREATE TABLE chat_sequences (
        "user_id" INT "users" NOT NULL UNIQUE,
        "message_id" INT NOT NULL,
        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
    ) ENGINE=InnoDB CHARSET=utf8');
}<commit_msg>Fix typo in Mysql schema<commit_after><?php

namespace Kanboard\Plugin\Chat\Schema;

use PDO;

const VERSION = 1;

function version_1(PDO $pdo)
{
    $pdo->exec('CREATE TABLE chat_messages (
        `id` INT NOT NULL AUTO_INCREMENT,
        `message` TEXT NOT NULL,
        `user_id` INT NOT NULL,
        `creation_date` INT NOT NULL,
        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE,
        PRIMARY KEY(id)
    ) ENGINE=InnoDB CHARSET=utf8');

    $pdo->exec('CREATE TABLE chat_sequences (
        `user_id` INT NOT NULL UNIQUE,
        `message_id` INT NOT NULL,
        FOREIGN KEY(user_id) REFERENCES users(id) ON DELETE CASCADE
    ) ENGINE=InnoDB CHARSET=utf8');
}
{'fraction_non_alphanumeric': 0.10265878877400296, 'fraction_numerical': 0.005908419497784343, 'mean_word_length': 3.106060606060606, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 7, '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': '1726180', 'n_tokens_mistral': 503, 'n_tokens_neox': 479, 'n_words': 129}