Skip to content

Wallos: Open-source, self-hostable personal subscription tracker. Visualize your recurring expenses, manage your budget, and save money.

372 B
Raw Blame
<?php
    // This migration adds a URL column to the subscriptions table.

    $columnQuery = $db->query("SELECT * FROM pragma_table_info('subscriptions') where name='url'");
    $columnRequired = $columnQuery->fetchArray(SQLITE3_ASSOC) === false;

    if ($columnRequired) {
        $db->exec('ALTER TABLE subscriptions ADD COLUMN url VARCHAR(255);');
    }

?>