/usr/share/php/data/Horde_Vfs/migration/4_horde_vfs_upgrade_null_columns.php is in php-horde-vfs 2.4.0-1ubuntu1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 26 27 | <?php
class HordeVfsUpgradeNullColumns extends Horde_Db_Migration_Base
{
public function up()
{
$this->changeColumn('horde_vfs', 'vfs_path', 'string', array('limit' => 255, 'null' => true));
$this->changeColumn('horde_vfs', 'vfs_owner', 'string', array('limit' => 255, 'null' => true));
$this->changeColumn('horde_muvfs', 'vfs_path', 'string', array('limit' => 255, 'null' => true));
$this->changeColumn('horde_muvfs', 'vfs_owner', 'string', array('limit' => 255, 'null' => true));
$this->update('UPDATE horde_vfs SET vfs_path = NULL WHERE vfs_path = \'\'');
$this->update('UPDATE horde_vfs SET vfs_owner = NULL WHERE vfs_path = \'\'');
$this->update('UPDATE horde_muvfs SET vfs_path = NULL WHERE vfs_path = \'\'');
$this->update('UPDATE horde_muvfs SET vfs_owner = NULL WHERE vfs_path = \'\'');
}
public function down()
{
$this->changeColumn('horde_vfs', 'vfs_path', 'string', array('limit' => 255, 'null' => false));
$this->changeColumn('horde_vfs', 'vfs_owner', 'string', array('limit' => 255, 'null' => false));
$this->changeColumn('horde_muvfs', 'vfs_path', 'string', array('limit' => 255, 'null' => false));
$this->changeColumn('horde_muvfs', 'vfs_owner', 'string', array('limit' => 255, 'null' => false));
$this->update('UPDATE horde_vfs SET vfs_path = \'\' WHERE vfs_path IS NULL');
$this->update('UPDATE horde_vfs SET vfs_owner = \'\' WHERE vfs_path IS NULL');
$this->update('UPDATE horde_muvfs SET vfs_path = \'\' WHERE vfs_path IS NULL');
$this->update('UPDATE horde_muvfs SET vfs_owner = \'\' WHERE vfs_path IS NULL');
}
}
|