New table by UpgradeSchemaRoute: code/Vender_name/Module_name/Setup/UpgradeSchema.php
<?phpnamespace Vender_name\Module_name\Setup;use Magento\Framework\Setup\UpgradeSchemaInterface;use Magento\Framework\Setup\ModuleContextInterface;use Magento\Framework\Setup\SchemaSetupInterface;use Magento\Framework\DB\Ddl\Table;class UpgradeSchema implements UpgradeSchemaInterface{ /** * @param SchemaSetupInterface $setup * @param ModuleContextInterface $context */ public function upgrade(SchemaSetupInterface $setup, ModuleContextInterface $context) { $setup->startSetup(); if (version_compare($context->getVersion(), '1.0.1') < 0) { if ($setup->getConnection()->isTableExists($setup->getTable('supplier_data')) != true) { $table = $setup->getConnection() ->newTable($setup->getTable('supplier_data')) ->addColumn( 'supplier_id' , Table::TYPE_INTEGER , null , [ 'identity' => true , 'unsigned' => true , 'nullable' => false , 'primary' => true ] , 'Supplier Id' )->addColumn( 'supplier_name' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier Name' )->addColumn( 'mobile' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier Mobile' )->addColumn( 'address' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier Address' )->addColumn( 'city' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier City' )->addColumn( 'country' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier Country' )->addColumn( 'link' , Table::TYPE_TEXT , 255 , ['nullable' => false , 'default' => ''] , 'Supplier Link' )->addColumn( 'status' , Table::TYPE_SMALLINT, null , ['nullable' => false , 'default' => 0] , 'Status' )->addColumn( 'created_at' , Table::TYPE_TIMESTAMP , null , ['nullable' => false , 'default' => ''] , 'Created Date' )->addColumn( 'updated_at' , Table::TYPE_TIMESTAMP , null , ['nullable' => false , 'default' => ''] , 'Updated Date' ) ->setComment('Supplier Table') ->setOption('type', 'InnoDB') ->setOption('charset', 'utf8'); $setup->getConnection()->createTable($table); } } $setup->endSetup(); }}执行 php bin/magento setup:upgrade注:执行命令前检查module.xml文件中的版本是否更改
...