/usr/share/horde/trean/migration/2_trean_upgrade_folders_to_tags_pre.php is in php-horde-trean 1.1.4-1build1.
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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | <?php
/**
* Steps to perform to bring the database tables from the old folder structure
* up to being ready for the new tags structure.
*
* Copyright 2010-2016 Horde LLC (http://www.horde.org/)
*
* See the enclosed file LICENSE for license information (BSD). If you
* did not receive this file, see http://www.horde.org/licenses/bsdl.php.
*
* @author Michael J. Rubinsky <mrubinsk@horde.org>
* @category Horde
* @license http://www.horde.org/licenses/bsdl.php BSD
* @package Trean
*/
class TreanUpgradeFoldersToTagsPre extends Horde_Db_Migration_Base
{
/**
* Upgrade.
*/
public function up()
{
$this->changeColumn('trean_bookmarks', 'bookmark_id', 'autoincrementKey');
try {
$this->dropTable('trean_bookmarks_seq');
} catch (Horde_Db_Exception $e) {
}
$t = $this->_connection->table('trean_bookmarks');
$cols = $t->getColumns();
if (!in_array('bookmark_dt', array_keys($cols))) {
$this->addColumn('trean_bookmarks', 'bookmark_dt', 'datetime');
}
if (!in_array('user_id', array_keys($cols))) {
$this->addColumn('trean_bookmarks', 'user_id', 'integer', array('unsigned' => true));
$this->addIndex('trean_bookmarks', array('user_id'));
}
$this->changeColumn('trean_bookmarks', 'bookmark_clicks', 'integer', array('unsigned' => true, 'default' => 0));
$this->changeColumn('trean_bookmarks', 'bookmark_description', 'string', array('limit' => 1024));
$this->changeColumn('trean_bookmarks', 'bookmark_url', 'string', array('limit' => 1024));
}
/**
* Downgrade
*/
public function down()
{
$this->removeColumn('trean_bookmarks', 'user_id');
$this->removeColumn('trean_bookmarks', 'bookmark_dt');
$this->changeColumn('trean_bookmarks', 'bookmark_id', 'integer', array('null' => false));
$this->changeColumn('trean_bookmarks', 'bookmark_url', 'string', array('limit' => 255));
$this->changeColumn('trean_bookmarks', 'bookmark_description', 'string', array('limit' => 255));
}
}
|