<commit_before><?php

namespace Schema;

use PDO;
use Model\Config;

const VERSION = 41;

function version_41($pdo)
{
    $pdo->exec('
        CREATE TABLE "tag" (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            name TEXT
        )
    ');

    $pdo->exec('
        CREATE TABLE "feed_tag" (
            feed_id INTEGER  NOT NULL,
            tag_id INTEGER NOT NULL,
            PRIMARY KEY(feed_id, tag_id)
            FOREIGN KEY(feed_id) REFERENCES feeds(id) ON DELETE CASCADE
        )
    ');
}

function version_40($pdo)
{
    $pdo->exec('UPDATE settings SET "value"="https://github.com/miniflux/miniflux/archive/master.zip" WHERE "key"="auto_update_url"');
}
<commit_msg>update database schema<commit_after><?php

namespace Schema;

use PDO;
use Model\Config;

const VERSION = 41;

function version_41($pdo)
{
    $pdo->exec('
        CREATE TABLE "tag" (
            id INTEGER PRIMARY KEY,
            name TEXT
        )
    ');

    $pdo->exec('
        CREATE TABLE "feed_tag" (
            feed_id INTEGER  NOT NULL,
            tag_id INTEGER NOT NULL,
            PRIMARY KEY(feed_id, tag_id)
            FOREIGN KEY(feed_id) REFERENCES feeds(id) ON DELETE CASCADE
        )
    ');
}

function version_40($pdo)
{
    $pdo->exec('UPDATE settings SET "value"="https://github.com/miniflux/miniflux/archive/master.zip" WHERE "key"="auto_update_url"');
}

{'fraction_non_alphanumeric': 0.11875452570601014, 'fraction_numerical': 0.008689355539464157, 'mean_word_length': 2.3221153846153846, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 9, 'https://': 2, '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': '1021839', 'n_tokens_mistral': 506, 'n_tokens_neox': 461, 'n_words': 107}