/usr/share/horde/whups/migration/7_whups_upgrade_autoincrement.php is in php-horde-whups 3.0.0~beta1-1.
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 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 | <?php
/**
* Change columns to autoincrement.
*
* Copyright 2010-2013 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 Whups
*/
class WhupsUpgradeAutoIncrement extends Horde_Db_Migration_Base
{
/**
* Upgrade.
*/
public function up()
{
$this->changeColumn('whups_tickets', 'ticket_id', 'autoincrementKey');
try {
$this->dropTable('whups_tickets_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_queues', 'queue_id', 'autoincrementKey');
try {
$this->dropTable('whups_queues_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_types', 'type_id', 'autoincrementKey');
try {
$this->dropTable('whups_types_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_states', 'state_id', 'autoincrementKey');
try {
$this->dropTable('whups_states_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_replies', 'reply_id', 'autoincrementKey');
try {
$this->dropTable('whups_replies_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_attributes_desc', 'attribute_id', 'autoincrementKey');
try {
$this->dropTable('whups_attributes_desc_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_comments', 'comment_id', 'autoincrementKey');
try {
$this->dropTable('whups_comments_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_logs', 'log_id', 'autoincrementKey');
try {
$this->dropTable('whups_logs_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_priorities', 'priority_id', 'autoincrementKey');
try {
$this->dropTable('whups_priorities_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_versions', 'version_id', 'autoincrementKey');
try {
$this->dropTable('whups_version_seq');
} catch (Horde_Db_Exception $e) {
}
$this->changeColumn('whups_queries', 'query_id', 'autoincrementKey');
try {
$this->dropTable('whups_queries_seq');
} catch (Horde_Db_Exception $e) {
}
}
/**
* Downgrade
*/
public function down()
{
$this->changeColumn('whups_tickets', 'ticket_id', 'integer', array('null' => false));
$this->changeColumn('whups_queues', 'queue_id', 'integer', array('null' => false));
$this->changeColumn('whups_types', 'type_id', 'integer', array('null' => false));
$this->changeColumn('whups_states', 'state_id', 'integer', array('null' => false));
$this->changeColumn('whups_replies', 'reply_id', 'integer', array('null' => false));
$this->changeColumn('whups_attributes_desc', 'attribute_id', 'integer', array('null' => false));
$this->changeColumn('whups_comments', 'comment_id', 'integer', array('null' => false));
$this->changeColumn('whups_logs', 'log_id', 'integer', array('null' => false));
$this->changeColumn('whups_priorities', 'priority_id', 'integer', array('null' => false));
$this->changeColumn('whups_versions', 'version_id', 'integer', array('null' => false));
$this->changeColumn('whups_queries', 'query_id', 'integer', array('null' => false));
}
}
|