<?php

/**
 * Data object containing the SQL and PHP code to migrate the database
 * up to version 1433766877.
 * Generated on 2015-06-08 14:34:37 by root
 */
class PropelMigration_1433766877
{

    public function preUp($manager)
    {
        // add the pre-migration code here
    }

    public function postUp($manager)
    {
        // add the post-migration code here
    }

    public function preDown($manager)
    {
        // add the pre-migration code here
    }

    public function postDown($manager)
    {
        // add the post-migration code here
    }

    /**
     * Get the SQL statements for the Up migration
     *
     * @return array list of the SQL strings to execute for the Up migration
     *               the keys being the datasources
     */
    public function getUpSQL()
    {
        return array (
  'centreon' => '
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;

ALTER TABLE `cfg_informations`     ADD `informationId` INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT FIRST;

ALTER TABLE `cfg_options` ADD `option_id` INTEGER  PRIMARY KEY NOT NULL AUTO_INCREMENT FIRST;

# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
',
);
    }

    /**
     * Get the SQL statements for the Down migration
     *
     * @return array list of the SQL strings to execute for the Down migration
     *               the keys being the datasources
     */
    public function getDownSQL()
    {
        return array (
  'centreon' => '
# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;


ALTER TABLE `cfg_informations`  DROP `informationId`;


ALTER TABLE `cfg_options` DROP `option_id`;


# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
',
);
    }

}

Add class migration of BDD for new columns
Add class migration of BDD for new columns
