db/migrations/1.151_add_automatic_updates_to_plugins.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

<?php
/**
 * Adds two columns into plugins to enable automatic updates
 */
class AddAutomaticUpdatesToPlugins extends Migration
{
    function description()
    {
        return 'Plugins can now be updated automatically via github or other repositories';
    }

    function up()
    {
        DBManager::get()->exec("
            ALTER TABLE `plugins` ADD `automatic_update_url` VARCHAR( 256 ) NULL DEFAULT NULL AFTER `dependentonid` ,
            ADD `automatic_update_secret` VARCHAR( 32 ) NULL DEFAULT NULL AFTER `automatic_update_url`
        ");
    }

    function down()
    {
        DBManager::get()->exec("ALTER TABLE `plugins` DROP COLUMN `automatic_update_secret` ");
        DBManager::get()->exec("ALTER TABLE `plugins` DROP COLUMN `automatic_update_url` ");
    }
}