PropelMigration_1455268734

Complexity

Total Complexity

6

Size/Duplication

Total Lines	77
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	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	26	1
A	getDownSQL()	0	12	1

<?php

/**
 * Data object containing the SQL and PHP code to migrate the database
 * up to version 1455268734.
 * Generated on 2016-02-12 09:18:54 by vagrant
 */
class PropelMigration_1455268734

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 (
  'tvheadend_status_manager' => '
PRAGMA foreign_keys = OFF;

DROP TABLE IF EXISTS [input];

CREATE TABLE [input]
(
    [uuid] VARCHAR(255) NOT NULL,
    [instance_name] VARCHAR(255) NOT NULL,
    [started] TIMESTAMP NOT NULL,
    [input] VARCHAR(255) NOT NULL,
    [network] VARCHAR(255) NOT NULL,
    [mux] VARCHAR(255) NOT NULL,
    [weight] INTEGER NOT NULL,
    PRIMARY KEY ([uuid]),
    UNIQUE ([uuid]),
    FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name])
);

PRAGMA foreign_keys = ON;
',
);
    }

    /**
     * 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 (
  'tvheadend_status_manager' => '
PRAGMA foreign_keys = OFF;

DROP TABLE IF EXISTS [input];

PRAGMA foreign_keys = ON;
',
);
    }

}