/** * @param Schema $schema */ public function down(Schema $schema) { // Drop beer table $schema->dropTable('beers'); // Drop messages table $schema->dropTable('messages'); }
/** * Down method * * @param Schema $schema */ public function down(Schema $schema) { if (Version::isSupportGetInstanceFunction()) { $app = Application::getInstance(); $meta = $this->getMetadata($app['orm.em']); $tool = new SchemaTool($app['orm.em']); $schemaFromMetadata = $tool->getSchemaFromMetadata($meta); // テーブル削除 foreach ($schemaFromMetadata->getTables() as $table) { if ($schema->hasTable($table->getName())) { $schema->dropTable($table->getName()); } } // シーケンス削除 foreach ($schemaFromMetadata->getSequences() as $sequence) { if ($schema->hasSequence($sequence->getName())) { $schema->dropSequence($sequence->getName()); } } } else { if ($schema->hasTable(self::MAKER)) { $schema->dropTable(self::MAKER); } if ($schema->hasTable(self::PRODUCTMAKER)) { $schema->dropTable(self::PRODUCTMAKER); } } if ($this->connection->getDatabasePlatform()->getName() == 'postgresql') { foreach ($this->sequence as $sequence) { if ($schema->hasSequence($sequence)) { $schema->dropSequence($sequence); } } } }
/** * @param Schema $schema */ public function down(Schema $schema) { // this down() migration is auto-generated, please modify it to your needs $schema->dropTable('plg_maker_plugin'); $schema->dropTable('plg_maker'); $schema->dropTable('plg_product_maker'); }
/** * Remove data. * * @param Schema $schema */ public function down(Schema $schema) { if (Version::isSupportGetInstanceFunction()) { $app = Application::getInstance(); $meta = $this->getMetadata($app['orm.em']); $tool = new SchemaTool($app['orm.em']); $schemaFromMetadata = $tool->getSchemaFromMetadata($meta); // テーブル削除 foreach ($schemaFromMetadata->getTables() as $table) { if ($schema->hasTable($table->getName())) { $schema->dropTable($table->getName()); } } // シーケンス削除 foreach ($schemaFromMetadata->getSequences() as $sequence) { if ($schema->hasSequence($sequence->getName())) { $schema->dropSequence($sequence->getName()); } } } else { // this down() migration is auto-generated, please modify it to your needs $schema->dropTable(self::NAME); $schema->dropSequence('plg_recommend_product_recommend_product_id_seq'); } }
/** * remove table. * * @param Schema $schema */ public function down(Schema $schema) { //current version >= 3.0.9 if (Version::isSupportGetInstanceFunction()) { $app = Application::getInstance(); $meta = $this->getMetadata($app['orm.em']); $tool = new SchemaTool($app['orm.em']); $schemaFromMetadata = $tool->getSchemaFromMetadata($meta); // テーブル削除 foreach ($schemaFromMetadata->getTables() as $table) { if ($schema->hasTable($table->getName())) { $schema->dropTable($table->getName()); } } // シーケンス削除 foreach ($schemaFromMetadata->getSequences() as $sequence) { if ($schema->hasSequence($sequence->getName())) { $schema->dropSequence($sequence->getName()); } } //for delete sequence in postgresql if ($this->connection->getDatabasePlatform()->getName() == 'postgresql') { $schema->dropSequence('plg_related_product_id_seq'); } } else { // this down() migration is auto-generated, please modify it to your needs $schema->dropTable(self::NAME); $schema->dropSequence('plg_related_product_id_seq'); } }
/** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { $this->fillActivityTables($queries); $this->fillActivityListTables($queries); // Remove orocrm_magento_cart_emails $table = $schema->getTable('orocrm_magento_cart_emails'); $table->removeForeignKey('FK_11B0F84B1AD5CDBF'); $table->removeForeignKey('FK_11B0F84BA832C1C9'); $schema->dropTable('orocrm_magento_cart_emails'); // Remove orocrm_magento_cart_calls $table = $schema->getTable('orocrm_magento_cart_calls'); $table->removeForeignKey('FK_83A847751AD5CDBF'); $table->removeForeignKey('FK_83A8477550A89B2C'); $schema->dropTable('orocrm_magento_cart_calls'); // Remove orocrm_magento_order_emails $table = $schema->getTable('orocrm_magento_order_emails'); $table->removeForeignKey('FK_10E2A9508D9F6D38'); $table->removeForeignKey('FK_10E2A950A832C1C9'); $schema->dropTable('orocrm_magento_order_emails'); // Remove orocrm_magento_order_calls $table = $schema->getTable('orocrm_magento_order_calls'); $table->removeForeignKey('FK_A885A3450A89B2C'); $table->removeForeignKey('FK_A885A348D9F6D38'); $schema->dropTable('orocrm_magento_order_calls'); }
public function down(Schema $schema) { $schema->dropTable('OAuthAuthCode'); $schema->dropTable('OAuthAccessToken'); $schema->dropTable('OAuthRefreshToken'); $schema->dropTable('OAuthClient'); }
/** * @param Schema $schema */ public function down(Schema $schema) { $schema->dropTable('dict_topic'); $schema->dropTable('dict_source'); $schema->dropTable('dict_web'); $schema->dropTable('dict_ro'); $schema->dropTable('dict_queue'); }
/** * @param Schema $schema */ public function down(Schema $schema) { // this down() migration is auto-generated, please modify it to your needs $schema->dropTable('plg_coupon'); $schema->dropSequence('plg_coupon_coupon_id_seq'); $schema->dropTable('plg_coupon_detail'); $schema->dropSequence('plg_coupon_detail_coupon_detail_id_seq'); $schema->dropTable('plg_coupon_order'); $schema->dropSequence('plg_coupon_order_id_seq'); }
/** * @param Schema $schema */ public function down(Schema $schema) { // this down() migration is auto-generated, please modify it to your needs $schema->dropTable('plg_mailmaga_plugin'); // drop Sequence MailMagazine Plug-in $schema->dropTable('plg_mailmaga_template'); $schema->dropTable('plg_send_history'); $schema->dropTable('plg_send_customer'); // drop sequence. $schema->dropSequence('plg_mailmaga_template_template_id_seq'); $schema->dropSequence('plg_send_history_send_id_seq'); }
/** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { $this->fillActivityTables($queries); $this->fillActivityListTables($queries); // Remove orocrm_contactus_req_emails $table = $schema->getTable('orocrm_contactus_req_emails'); $table->removeForeignKey('FK_E494F7AE427EB8A5'); $table->removeForeignKey('FK_E494F7AEA832C1C9'); $schema->dropTable('orocrm_contactus_req_emails'); // Remove orocrm_contactus_request_calls $table = $schema->getTable('orocrm_contactus_request_calls'); $table->removeForeignKey('FK_6F7A50CE427EB8A5'); $table->removeForeignKey('FK_6F7A50CE50A89B2C'); $schema->dropTable('orocrm_contactus_request_calls'); }
/** * @param Schema $schema */ protected function oroCrmCreateTaskTable(Schema $schema) { if ($schema->hasTable($this->taskTableName)) { $schema->dropTable($this->taskTableName); } $table = $schema->createTable($this->taskTableName); $table->addColumn('id', 'integer', ['autoincrement' => true]); $table->addColumn('subject', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('description', 'string', ['notnull' => false, 'length' => 255]); $table->addColumn('due_date', 'datetime'); $table->addColumn('task_priority_name', 'string', ['notnull' => false, 'length' => 32]); $table->addColumn('owner_id', 'integer', ['notnull' => false]); $table->addColumn('related_account_id', 'integer', ['notnull' => false]); $table->addColumn('related_contact_id', 'integer', ['notnull' => false]); $table->addColumn('reporter_id', 'integer', ['notnull' => false]); $table->addColumn('workflow_item_id', 'integer', ['notnull' => false]); $table->addColumn('workflow_step_id', 'integer', ['notnull' => false]); $table->addColumn('createdAt', 'datetime'); $table->addColumn('updatedAt', 'datetime', ['notnull' => false]); $table->setPrimaryKey(['id']); $table->addIndex(['task_priority_name'], 'IDX_814DEE3FD34C1E8E', []); $table->addIndex(['owner_id'], 'IDX_814DEE3F7E3C61F9', []); $table->addIndex(['related_account_id'], 'IDX_814DEE3FE774F01D', []); $table->addIndex(['related_contact_id'], 'IDX_814DEE3FD6204081', []); $table->addIndex(['reporter_id'], 'IDX_814DEE3FE1CFE6F5', []); $table->addIndex(['due_date'], 'task_due_date_idx'); $table->addUniqueIndex(['workflow_item_id'], 'UNIQ_814DEE3F1023C4EE'); $table->addIndex(['workflow_step_id'], 'IDX_814DEE3F71FE882C', []); $this->oroCrmCreateTaskTableForeignKeys($schema); }
public function down(Schema $schema) { //start cc_show_instances modifications $show_instances_table = $schema->getTable('cc_show_instances'); $show_instances_table->dropColumn('record'); $show_instances_table->dropColumn('rebroadcast'); $show_instances_table->dropColumn('instance_id'); $show_instances_table->dropColumn('file_id'); $show_instances_table->dropColumn('soundcloud_id'); //end cc_show_instances modifications //start cc_show_days modifications $show_days_table = $schema->getTable('cc_show_days'); $show_days_table->dropColumn('record'); //end cc_show_days modifications //start cc_show modifications $show_table = $schema->getTable('cc_show'); $show_table->dropColumn('url'); //end cc_show modifications //start cc_schedule modifications $schedule_table = $schema->getTable('cc_schedule'); $playlist_id_col = $schedule_table->getColumn('playlist_id'); $playlist_id_col->setNotnull(true); //end cc_schedule modifications //drop cc_show_rebroadcast table $schema->dropTable('cc_show_rebroadcast'); //end drop cc_show_rebroadcast table }
/** * Attributes table was not used in the code anymore so can be removed * * @param Schema $schema */ public function up(Schema $schema) { $prefixedTableName = $this->getTablePrefix() . 'attribute'; if ($schema->hasTable($prefixedTableName)) { $schema->dropTable($prefixedTableName); } }
public function down(Schema $schema) { $tables = ['module', 'module_admin', 'user', 'user_provider']; foreach ($tables as $table) { $schema->dropTable($table); } }
/** * @param Schema $schema * * @throws \Doctrine\DBAL\Schema\SchemaException */ public static function execute(Schema $schema) { $schema->dropTable('oro_email_to_folder'); $emailTable = $schema->getTable('oro_email'); $emailTable->dropColumn('is_seen'); $emailTable->dropColumn('received'); }
public function up(\Doctrine\DBAL\Schema\Schema $schema) { // Drop table: display_pages $schema->dropTable('display_pages'); // Alter table: displays $table = $schema->getTable('displays'); $table->dropColumn('attributes'); $table->dropColumn('isfirstnamedislayed'); $table->dropColumn('islastnamedislayed'); $table->dropColumn('isemaildislayed'); $table->dropColumn('iscreatedatdislayed'); $table->dropColumn('isupdatedatdislayed'); $table->dropColumn('islastlogindislayed'); $table->dropColumn('ispercentcompletedislayed'); $table->dropColumn('ishaspaiddislayed'); // Alter table: display_elements $table = $schema->getTable('display_elements'); $table->addColumn('type', 'string', array('length' => 255)); $table->addColumn('title', 'string', array('length' => 255)); $table->addColumn('name', 'string', array('length' => 255, 'notNull' => false)); $table->addColumn('weight', 'integer', array()); $table->dropColumn('attributes'); $table->dropColumn('page_id'); $table->addColumn('display_id', 'bigint', array('precision' => 10, 'notNull' => false)); $table->addIndex(array('display_id'), 'IDX_23A0A27351A2DF33'); $table->dropIndex('idx_23a0a273c4663e4'); $table->addForeignKeyConstraint('displays', array('display_id'), array('id'), array('onDelete' => 'CASCADE'), 'FK_23A0A27351A2DF33'); }
/** * @param Schema $schema */ public function down(Schema $schema) { // this down() migration is auto-generated, please modify it to your needs $calendarobjects = $schema->getTable('calendarobjects'); $calendarobjects->removeColumn('uid'); $schema->dropTable('schedulingobjects'); }
/** * {@inheritdoc} */ public function up(Schema $schema, QueryBag $queries) { $schema->dropTable('oro_calendar_connection'); $calendarConnectionClass = 'Oro\\Bundle\\CalendarBundle\\Entity\\CalendarConnection'; $queries->addPostQuery(new ParametrizedSqlMigrationQuery('DELETE FROM oro_entity_config_field WHERE entity_id IN (' . 'SELECT id FROM oro_entity_config WHERE class_name = :class)', ['class' => $calendarConnectionClass], ['class' => 'string'])); $queries->addPostQuery(new ParametrizedSqlMigrationQuery('DELETE FROM oro_entity_config WHERE class_name = :class', ['class' => $calendarConnectionClass], ['class' => 'string'])); $queries->addPostQuery(new DeleteAclMigrationQuery($this->container, new ObjectIdentity('entity', $calendarConnectionClass))); }
/** * Defines all the tables in the schema * * @param Schema $schema Database schema * @param string $version Table version */ protected function defineTables(Schema $schema, $version) { // Load all table definitions foreach ($this->getTableDefinitions() as $tableDefinition) { // Drop all tables if ($schema->hasTable($tableDefinition->getName())) { $schema->dropTable($tableDefinition->getName()); } // Only create the table if it exists in this version of the schema $table = $schema->createTable($tableDefinition->getName()); $tableDefinition->define($table, $version); // If the table has no columns, drop it if (count($table->getColumns()) < 1) { $schema->dropTable($tableDefinition->getName()); } } }
/** * @param Schema $schema */ public function down(Schema $schema) { // this down() migration is auto-generated, please modify it to your needs if (!$schema->hasTable(self::NAME)) { return true; } $schema->dropTable(self::NAME); }
public function testDropTable() { $tableName = "foo"; $table = new Table($tableName); $schema = new Schema(array($table)); $this->assertTrue($schema->hasTable("foo")); $schema->dropTable("foo"); $this->assertFalse($schema->hasTable("foo")); }
/** * @param Schema $schema */ public function up(Schema $schema) { $tablesToDrop = array("LastNotification", "Event", "Session", "PrintingJobConfiguration", "PrintingJob"); foreach ($tablesToDrop as $table) { if ($schema->hasTable($table)) { $schema->dropTable($table); } } }
/** * @param Schema $schema */ public function up(Schema $schema) { $tablesToDrop = ['LastNotification', 'Event', 'Session', 'PrintingJobConfiguration', 'PrintingJob']; foreach ($tablesToDrop as $table) { if ($schema->hasTable($table)) { $schema->dropTable($table); } } }
/** * @param Schema $schema **/ public function down(Schema $schema) { $app = new \Eccube\Application(); // this down() migration is auto-generated, please modify it to your needs $schema->dropTable('plg_holiday_plugin'); $schema->dropTable('plg_holiday'); $schema->dropTable('plg_holiday_week'); $schema->dropTable('plg_holiday_config'); /* ブロックの削除 */ $block_position_delete = "DELETE FROM dtb_block_position WHERE block_id = (SELECT block_id FROM dtb_block WHERE file_name = 'pg_calendar')"; $this->connection->executeUpdate($block_position_delete); $block_delete = "DELETE FROM dtb_block WHERE file_name = 'pg_calendar'"; $this->connection->executeUpdate($block_delete); /* ブロックファイルとCSSファイルの削除 */ $pg_calendar_filename = $app['config']['template_realdir'] . "/Block/pg_calendar.twig"; @unlink($pg_calendar_filename); $pg_calendar_css_filename = $app['config']['template_html_realdir'] . "/css/pg_calendar.css"; @unlink($pg_calendar_css_filename); }
/** * Down method. * * @param Schema $schema */ public function down(Schema $schema) { if (Version::isSupportMethod()) { $app = Application::getInstance(); $meta = $this->getMetadata($app['orm.em']); $tool = new SchemaTool($app['orm.em']); $schemaFromMetadata = $tool->getSchemaFromMetadata($meta); // テーブル削除 foreach ($schemaFromMetadata->getTables() as $table) { if ($schema->hasTable($table->getName())) { $schema->dropTable($table->getName()); } } } else { if ($schema->hasTable(self::TABLE)) { $schema->dropTable(self::TABLE); } } }
public function down(\Doctrine\DBAL\Schema\Schema $schema) { // Drop table: files $schema->dropTable('files'); // Alter table: attachments $table = $schema->getTable('attachments'); $table->addColumn('attachment', 'text', array('precision' => 10, 'comment' => '')); $table->addColumn('thumbnail', 'text', array('precision' => 10, 'notNull' => false, 'comment' => '')); $table->dropColumn('attachmenthash'); $table->dropColumn('thumbnailhash'); }
/** * @param Schema $schema */ public function up(Schema $schema) { // this up() migration is auto-generated, please modify it to your needs $this->addSql("alter table plg_coupon_order add user_id integer"); $this->addSql("alter table plg_coupon_order add email text"); $this->addSql("alter table plg_coupon_order add discount decimal not null default 0"); $this->addSql("alter table plg_coupon add coupon_use_time integer"); if ($schema->hasTable('plg_coupon_plugin')) { $schema->dropTable('plg_coupon_plugin'); $schema->dropSequence('plg_coupon_plugin_plugin_id_seq'); } }
public function down(Schema $schema) { // Bisherige Ticket-Tabelle entfernen $schema->dropTable('ticket'); // Neue Ticket-Tabelle erstellen $ticketTable = $schema->createTable('ticket'); $ticketTable->addcolumn('id', 'integer')->setNotnull(true); $ticketTable->addcolumn('websiteid', 'string', array('length' => 100))->setNotnull(true); $ticketTable->addcolumn('timestamp', 'integer', array('length' => 100))->setNotnull(true); $ticketTable->addcolumn('url', 'string', array('length' => 255))->setNotnull(true); $ticketTable->setPrimaryKey(array('id', 'websiteid')); $this->addSql('TRUNCATE TABLE ticket'); }
/** * Drop all tables * * @param Schema $schema */ public function down(Schema $schema) { $schema->dropTable('price'); $schema->dropTable('product'); $schema->dropTable('payment'); $schema->dropTable('costumer'); $schema->dropTable('order'); $schema->dropTable('order_product'); }