PropelMigration_1475647555

Complexity

Total Complexity

6

Size/Duplication

Total Lines	101
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	0

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	preUp()	0	4	1
A	postUp()	0	4	1
A	preDown()	0	4	1
A	postDown()	0	4	1
B	getUpSQL()	0	43	1
A	getDownSQL()	0	19	1

<?php

/**
 * Data object containing the SQL and PHP code to migrate the database
 * up to version 1475647555.
 * Generated on 2016-10-05 09:05:55 
 */
class PropelMigration_1475647555

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    public $comment = '';

    public function preUp($manager)

The parameter $manager is not used and could be removed.

    {
        // add the pre-migration code here
    }

    public function postUp($manager)

The parameter $manager is not used and could be removed.

    {
        // add the post-migration code here
    }

    public function preDown($manager)

The parameter $manager is not used and could be removed.

    {
        // add the pre-migration code here
    }

    public function postDown($manager)

The parameter $manager is not used and could be removed.

    {
        // 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 (
  'default' => '
# 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;

CREATE TABLE `tasks`
(
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` DATETIME,
    `updated_at` DATETIME,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB;

CREATE TABLE `users`
(
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(255) NOT NULL,
    `email` VARCHAR(255) NOT NULL,
    `password` VARCHAR(255) NOT NULL,
    `remember_token` VARCHAR(100),
    `created_at` DATETIME,
    `updated_at` DATETIME,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `users_email_unique` (`email`)
) ENGINE=InnoDB;

CREATE TABLE `selfprice`
(
    `id` INTEGER NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(50),
    `datecreate` DATETIME,
    `desc` VARCHAR(255),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB;

# 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 (
  'default' => '
# 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;

DROP TABLE IF EXISTS `tasks`;

DROP TABLE IF EXISTS `users`;

DROP TABLE IF EXISTS `selfprice`;

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

}