AnselUpgradeSqlHierarchical::up PHP Method

    public function up()
    {
        try {
            $this->removeIndex('ansel_shares', 'share_parents');
        } catch (Exception $e) {
        }
        try {
            $this->removeIndex('ansel_shares', array('name' => 'ansel_shares_share_parents_idx'));
        } catch (Exception $e) {
        }
        $this->addColumn('ansel_shares', 'share_name', 'string', array('limit' => 255, 'null' => false, 'default' => ''));
        $this->changeColumn('ansel_shares', 'share_parents', 'text');
        // Add sharenames
        $sql = 'SELECT share_id FROM ansel_shares';
        $ids = $this->_connection->selectValues($sql);
        $sql = 'UPDATE ansel_shares SET share_name = ? WHERE share_id = ?';
        foreach ($ids as $id) {
            $params = array(strval(new Horde_Support_Randomid()), $id);
            $this->_connection->update($sql, $params);
        }
    }