PropelMigration_1455269307

Complexity

Total Complexity

6

Size/Duplication

Total Lines	84
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
A	getUpSQL()	0	12	1
B	getDownSQL()	0	33	1

<?php

/**
 * Data object containing the SQL and PHP code to migrate the database
 * up to version 1455269307.
 * Generated on 2016-02-12 09:28:27 by vagrant
 */
class PropelMigration_1455269307

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;

ALTER TABLE [subscription] ADD [input_id] INTEGER;

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;

CREATE TEMPORARY TABLE [subscription__temp__56bda5bb0fcd8] AS SELECT [id],[instance_name],[input_id],[user_id],[channel_id],[subscription_id],[started],[stopped],[title],[service] FROM [subscription];
DROP TABLE [subscription];

CREATE TABLE [subscription]
(
    [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    [instance_name] VARCHAR(255) NOT NULL,
    [user_id] INTEGER,
    [channel_id] INTEGER NOT NULL,
    [subscription_id] INTEGER NOT NULL,
    [started] TIMESTAMP NOT NULL,
    [stopped] TIMESTAMP,
    [title] VARCHAR(255) NOT NULL,
    [service] VARCHAR(255) NOT NULL,
    UNIQUE ([id]),
    FOREIGN KEY ([channel_id]) REFERENCES [channel] ([id]),
    FOREIGN KEY ([user_id]) REFERENCES [user] ([id]),
    FOREIGN KEY ([instance_name]) REFERENCES [instance] ([name])
);

INSERT INTO [subscription] (id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service) SELECT id, instance_name, user_id, channel_id, subscription_id, started, stopped, title, service FROM [subscription__temp__56bda5bb0fcd8];
DROP TABLE [subscription__temp__56bda5bb0fcd8];

PRAGMA foreign_keys = ON;
',
);
    }

}