PHP Schema\Schema类代码示例

 /**
  * Generate table oro_reminder
  *
  * @param Schema $schema
  */
 public static function oroReminderTable(Schema $schema)
 {
     /** Generate table oro_reminder **/
     $table = $schema->createTable('oro_reminder');
     $table->addColumn('id', 'integer', ['autoincrement' => true]);
     $table->addColumn('recipient_id', 'integer', ['notnull' => false]);
     $table->addColumn('subject', 'string', ['length' => 32]);
     $table->addColumn('start_at', 'datetime', []);
     $table->addColumn('expire_at', 'datetime', []);
     $table->addColumn('method', 'string', ['length' => 255]);
     $table->addColumn('interval_number', 'integer', []);
     $table->addColumn('interval_unit', 'string', ['length' => 1]);
     $table->addColumn('state', 'string', ['length' => 32]);
     $table->addColumn('related_entity_id', 'integer', []);
     $table->addColumn('related_entity_classname', 'string', ['length' => 255]);
     $table->addColumn('created_at', 'datetime', []);
     $table->addColumn('updated_at', 'datetime', ['notnull' => false]);
     $table->addColumn('sent_at', 'datetime', ['notnull' => false]);
     $table->addColumn('failure_exception', 'array', ['notnull' => false, 'comment' => '(DC2Type:array)']);
     $table->setPrimaryKey(['id']);
     $table->addIndex(['recipient_id'], 'IDX_2F4F9F57E92F8F78', []);
     $table->addIndex(['state'], 'reminder_state_idx', []);
     /** End of generate table oro_reminder **/
     /** Generate foreign keys for table oro_reminder **/
     $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['recipient_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]);
     /** End of generate foreign keys for table oro_reminder **/
 }

 /**
  * @param Schema $schema
  */
 private function createAuditField(Schema $schema)
 {
     $oroAuditFieldTable = $schema->createTable('oro_audit_field');
     $oroAuditFieldTable->addColumn('id', 'integer', ['autoincrement' => true]);
     $oroAuditFieldTable->addColumn('audit_id', 'integer', []);
     $oroAuditFieldTable->addColumn('field', 'string', ['length' => 255]);
     $oroAuditFieldTable->addColumn('data_type', 'string', ['length' => 255]);
     $oroAuditFieldTable->addColumn('old_integer', 'bigint', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_float', 'float', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_boolean', 'boolean', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_text', 'text', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_date', 'date', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_time', 'time', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('old_datetime', 'datetime', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_integer', 'bigint', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_float', 'float', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_boolean', 'boolean', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_text', 'text', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_date', 'date', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_time', 'time', ['notnull' => false]);
     $oroAuditFieldTable->addColumn('new_datetime', 'datetime', ['notnull' => false]);
     $oroAuditFieldTable->setPrimaryKey(['id']);
     $oroAuditFieldTable->addIndex(['audit_id'], 'IDX_9A31A824BD29F359', []);
     $oroAuditFieldTable->addForeignKeyConstraint($schema->getTable('oro_audit'), ['audit_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]);
 }

 /**
  * @param Schema $schema
  *
  * @throws SkipMigrationException
  * @throws \Doctrine\DBAL\Schema\SchemaException
  */
 public function preUp(Schema $schema)
 {
     $pageHitTable = $schema->getTable($this->prefix . 'users');
     if ($pageHitTable->hasColumn('signature')) {
         throw new SkipMigrationException('Schema includes this migration');
     }
 }

 /**
  * Change oro_integration_channel table
  *
  * @param Schema $schema
  */
 public static function modifyChannelTable(Schema $schema)
 {
     $table = $schema->getTable('oro_integration_channel');
     $table->addColumn('default_user_owner_id', 'integer', ['notnull' => false]);
     $table->addIndex(['default_user_owner_id'], 'IDX_55B9B9C5A89019EA', []);
     $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['default_user_owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null], 'FK_55B9B9C5A89019EA');
 }

 /**
  * Add orob2b_shopping_list_line_item foreign keys.
  *
  * @param Schema $schema
  */
 protected function addOrob2BShoppingListLineItemForeignKeys(Schema $schema)
 {
     $table = $schema->getTable('orob2b_shopping_list_line_item');
     $table->addForeignKeyConstraint($schema->getTable('orob2b_shopping_list'), ['shopping_list_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]);
     $table->addForeignKeyConstraint($schema->getTable('orob2b_product'), ['product_id'], ['id'], ['onDelete' => 'CASCADE', 'onUpdate' => null]);
     $table->addForeignKeyConstraint($schema->getTable('orob2b_product_unit'), ['unit_code'], ['code'], ['onDelete' => 'CASCADE', 'onUpdate' => null]);
 }

 /**
  * @param Schema $schema
  *
  * @throws \Doctrine\DBAL\Schema\SchemaException
  */
 public static function addAttachmentRelation(Schema $schema)
 {
     $table = $schema->getTable('oro_email_attachment');
     $table->addColumn('file_id', 'integer', ['notnull' => false]);
     $table->addUniqueIndex(['file_id'], 'UNIQ_F4427F2393CB796C');
     $table->addForeignKeyConstraint($schema->getTable('oro_attachment_file'), ['file_id'], ['id'], ['onDelete' => 'SET NULL'], 'FK_F4427F2393CB796C');
 }

 /**
  * {@inheritdoc}
  */
 public function up(Schema $schema, QueryBag $queries)
 {
     $table = $schema->getTable('oro_calendar_event');
     $table->dropColumn('reminder');
     $table->dropColumn('remind_at');
     $table->dropColumn('reminded');
 }

 public function down(Schema $schema)
 {
     // remove website creationmode and ismarkedfordeletion column
     $schema->getTable('website')->dropColumn('share');
     $schema->getTable('website')->dropColumn('creationmode');
     $schema->getTable('website')->dropColumn('ismarkedfordeletion');
 }

 /**
  * @param Schema $schema
  * @param string $table
  * @throws \Doctrine\DBAL\Schema\SchemaException
  */
 public static function addToSchema(Schema $schema, $table)
 {
     if ($schema->hasTable($table)) {
         $table = $schema->getTable($table);
     } else {
         $table = $schema->createTable($table);
     }
     if (!$table->hasColumn('event_id')) {
         $id = $table->addColumn('event_id', 'integer', ['unsigned' => true]);
         $id->setAutoincrement(true);
         $table->setPrimaryKey(['event_id']);
     }
     if (!$table->hasColumn('aggregate_id')) {
         $table->addColumn('aggregate_id', 'string', ['length' => 50]);
     }
     if (!$table->hasColumn('version')) {
         $table->addColumn('version', 'integer');
     }
     if (!$table->hasColumn('type')) {
         $table->addColumn('type', 'string', ['length' => 100]);
     }
     if (!$table->hasColumn('payload')) {
         $table->addColumn('payload', 'text');
     }
     if (!$table->hasColumn('recorded_on')) {
         $table->addColumn('recorded_on', 'string', ['length' => 50]);
     }
     $table->addUniqueIndex(['aggregate_id', 'version']);
 }

 /**
  * @param Schema $fromSchema
  * @param Schema $toSchema
  *
  * @return string[]
  */
 public function getSqlDiffToMigrate(Schema $fromSchema, Schema $toSchema)
 {
     if ($toSchema instanceof LazyLoadingInterface && !$toSchema->isProxyInitialized()) {
         return [];
     }
     return $this->originalSchemaManipulator->getSqlDiffToMigrate($fromSchema, $toSchema);
 }

 /**
  * Adds owner_id field
  *
  * @param Schema $schema
  */
 public static function addOwner(Schema $schema)
 {
     $table = $schema->getTable('oro_embedded_form');
     $table->addColumn('owner_id', 'integer', ['notnull' => false]);
     $table->addIndex(['owner_id'], 'IDX_F7A34C17E3C61F9', []);
     $table->addForeignKeyConstraint($schema->getTable('oro_organization'), ['owner_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null]);
 }

 /**
  * {@inheritdoc}
  */
 public function up(Schema $schema, QueryBag $queries)
 {
     $table = $schema->getTable('oro_reminder');
     $table->addColumn('sender_id', 'integer', ['notnull' => false]);
     $table->addIndex(['sender_id'], 'idx_2f4f9f57f624b39d', []);
     $table->addForeignKeyConstraint($schema->getTable('oro_user'), ['sender_id'], ['id'], ['onUpdate' => null, 'onDelete' => 'SET NULL']);
 }

 /**
  * Add origin to EmailUser
  *
  * @param Schema $schema
  * @throws \Doctrine\DBAL\Schema\SchemaException
  */
 public static function updateOroEmailUserTable(Schema $schema)
 {
     $table = $schema->getTable('oro_email_user');
     $table->removeForeignKey('fk_91f5cff6162cb942');
     $table->dropIndex('idx_91f5cff6162cb942');
     $table->addColumn('origin_id', 'integer', ['notnull' => false]);
 }

 /**
  * @param Schema   $schema
  * @param QueryBag $queries
  * @param string   $tableName
  * @param string   $columnName
  * @param string   $type
  *
  * @throws \Exception
  */
 public function changePrimaryKeyType(Schema $schema, QueryBag $queries, $tableName, $columnName, $type)
 {
     $targetColumn = $schema->getTable($tableName)->getColumn($columnName);
     $type = Type::getType($type);
     if ($targetColumn->getType() === $type) {
         return;
     }
     /** @var ForeignKeyConstraint[] $foreignKeys */
     $foreignKeys = [];
     foreach ($schema->getTables() as $table) {
         /** @var ForeignKeyConstraint[] $tableForeignKeys */
         $tableForeignKeys = array_filter($table->getForeignKeys(), function (ForeignKeyConstraint $tableForeignKey) use($tableName, $columnName) {
             if ($tableForeignKey->getForeignTableName() !== $tableName) {
                 return false;
             }
             return $tableForeignKey->getForeignColumns() === [$columnName];
         });
         foreach ($tableForeignKeys as $tableForeignKey) {
             $foreignKeys[$tableForeignKey->getName()] = $tableForeignKey;
             $foreignKeyTableName = $tableForeignKey->getLocalTable()->getName();
             $foreignKeyColumnNames = $tableForeignKey->getLocalColumns();
             $queries->addPreQuery($this->platform->getDropForeignKeySQL($tableForeignKey, $foreignKeyTableName));
             $column = $schema->getTable($foreignKeyTableName)->getColumn(reset($foreignKeyColumnNames));
             if ($column instanceof ExtendColumn) {
                 $column->disableExtendOptions()->setType($type)->enableExtendOptions();
             } else {
                 $column->setType($type);
             }
         }
     }
     $targetColumn->setType($type);
     foreach ($foreignKeys as $foreignKey) {
         $queries->addPostQuery($this->platform->getCreateForeignKeySQL($foreignKey, $foreignKey->getLocalTable()));
     }
 }

 /**
  * @param Schema $schema
  */
 protected function modifycOrocrmContactusRequestTable(Schema $schema)
 {
     $table = $schema->getTable('orocrm_contactus_request');
     $table->addColumn('data_channel_id', 'integer', ['notnull' => false]);
     $table->addIndex(['data_channel_id'], 'IDX_342872E8BDC09B73', []);
     $table->addForeignKeyConstraint($schema->getTable('orocrm_channel'), ['data_channel_id'], ['id'], ['onDelete' => 'SET NULL', 'onUpdate' => null], 'FK_342872E8BDC09B73');
 }