Yii Migrations Droptable And Fk

Yii 1.1 General Discussion
1

0 down vote favorite

I have migration:

function Up:




$this->createTable(

            'vacancy_moderate',

            array(

                'id' => 'int(10) unsigned NOT NULL AUTO_INCREMENT',

                'period_days' => 'tinyint(4) NOT NULL',

                'title' => 'varchar(255) NOT NULL DEFAULT \'\'',

                'price'=> 'int(11) DEFAULT NULL',

                'requirements'=> 'text NOT NULL',

                'conditions'=> 'text',

                'contact_details'=> 'text NOT NULL',

                'country_id'=> 'int(10) unsigned NOT NULL',

                'city_id'=> 'int(10) unsigned DEFAULT NULL',

                'user_id'=> 'int(10) unsigned DEFAULT NULL',

                'club_id'=> 'int(10) DEFAULT NULL',

                'PRIMARY KEY (`id`)',

                'KEY `city_id` (`city_id`)',

                'KEY `user_id` (`user_id`)',

                'KEY `country_id` (`country_id`)',

                'KEY `club_id` (`club_id`)',

                'CONSTRAINT `vacancy_moderate_ibfk_1` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`) ON UPDATE CASCADE',

                'CONSTRAINT `vacancy_moderate_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE',

                'CONSTRAINT `vacancy_moderate_ibfk_3` FOREIGN KEY (`country_id`) REFERENCES `country` (`id`) ON UPDATE CASCADE',

                'CONSTRAINT `vacancy_moderate_ibfk_4` FOREIGN KEY (`club_id`) REFERENCES `clubs` (`id`) ON UPDATE CASCADE'

            ),

            'ENGINE=InnoDB DEFAULT CHARSET=utf8'

        );

function Down:




$this->dropTable('vacancy_moderate');

Question: Should I drop all foreign keys manually or they will be dropped within dropTable?

2

You can use




$this->execute("DROP PROCEDURE IF EXISTS sp_update_reports;");

something like this to drop foreign keys in function Down .