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
|
<?php
/**
* Change page_id column to autoincrement.
*
* Copyright 2010-2013 Horde LLC (http://www.horde.org/)
*
* See the enclosed file COPYING for license information (GPL). If you
* did not receive this file, see http://www.horde.org/licenses/gpl.
*
* @author Chuck Hagenbuch <chuck@horde.org>
* @category Horde
* @license http://www.horde.org/licenses/gpl GPL
* @package Wicked
*/
class WickedAutoIncrementPageId extends Horde_Db_Migration_Base
{
/**
* Upgrade.
*/
public function up()
{
$this->changeColumn('wicked_pages', 'page_id', 'autoincrementKey');
try {
$this->dropTable('wicked_pages_seq');
} catch (Horde_Db_Exception $e) {
}
}
/**
* Downgrade.
*/
public function down()
{
$this->changeColumn('wicked_pages', 'page_id', 'integer', array('autoincrement' => false));
}
}
|