1、表名：cpa_channel_app_source 设计，表前缀：cpa_，如图1
图1
2、查看命令：yii migrate/create 的帮助文档
PS E:/wwwroot/channel-pub-api> ./yii help migrate/create
DESCRIPTION
"
Creates a new migration.
This command creates a new migration using the available migration template.
After using this command, developers should modify the created migration
skeleton by filling up the actual migration logic.
yii migrate/create create_user_table
In order to generate a namespaced migration, you should specify a namespace before the migration's name.
Note that backslash (/) is usually considered a special character in the shell, so you need to escape it
properly to avoid shell errors or incorrect behavior.
For example:
yii migrate/create 'app//migrations//createUserTable'
In case [[migrationPath]] is not set and no namespace is provided, the first entry of [[migrationNamespaces]] will be used.
USAGE
yii migrate/create <name> [...options...]
- name (required): string
the name of the new migration. This should only contain
letters, digits, underscores and/or backslashes.
Note: If the migration name is of a special form, for example create_xxx or
drop_xxx, then the generated migration file will contain extra code,
in this case for creating/dropping tables.
OPTIONS
--appconfig: string
custom application configuration file path.
If not set, default application configuration is used.
--color: boolean, 0 or 1
whether to enable ANSI color in the output.
If not set, ANSI color will only be enabled for terminals that support it.
--comment, -C: string (defaults to '')
the comment for the table being created.
--compact, -c: boolean, 0 or 1 (defaults to 0)
indicates whether the console output should be compacted.
If this is set to true, the individual commands ran within the migration will not be output to the console.
Default is false, in other words the output is fully verbose by default.
--db: Connection|array|string (defaults to 'db')
the DB connection object or the application component ID of the DB connection to use
when applying migrations. Starting from version 2.0.3, this can also be a configuration array
for creating the object.
--fields, -f: array
column definition strings used for creating migration code.
The format of each definition is `COLUMN_NAME:COLUMN_TYPE:COLUMN_DECORATOR`. Delimiter is `,`.
For example, `--fields="name:string(12):notNull:unique"`
produces a string column of size 12 which is not null and unique values.
Note: primary key is added automatically and is named id by default.
If you want to use another name you may specify it explicitly like
`--fields="id_key:primaryKey,name:string(12):notNull:unique"`
--help, -h: boolean, 0 or 1
whether to display help information about current command.
--interactive: boolean, 0 or 1 (defaults to 1)
whether to run the command interactively.
--migration-namespaces: array
list of namespaces containing the migration classes.
Migration namespaces should be resolvable as a [path alias](guide:concept-aliases) if prefixed with `@`, e.g. if you specify
the namespace `app/migrations`, the code `Yii::getAlias('@app/migrations')` should be able to return
the file path to the directory this namespace refers to.
This corresponds with the [autoloading conventions](guide:concept-autoloading) of Yii.
For example:
```php
[
'app/migrations',
'some/extension/migrations',
]
```
--migration-path, -p: string|array
the directory containing the migration classes. This can be either
a [path alias](guide:concept-aliases) or a directory path.
Migration classes located at this path should be declared without a namespace.
Use [[migrationNamespaces]] property in case you are using namespaced migrations.
If you have set up [[migrationNamespaces]], you may set this field to `null` in order
to disable usage of migrations that are not namespaced.
Since version 2.0.12 you may also specify an array of migration paths that should be searched for
migrations to load. This is mainly useful to support old extensions that provide migrations
without namespace and to adopt the new feature of namespaced migrations while keeping existing migrations.
In general, to load migrations from different locations, [[migrationNamespaces]] is the preferable solution
as the migration name contains the origin of the migration in the history, which is not the case when
using multiple migration paths.
--migration-table, -t: string (defaults to '{{%migration}}')
the name of the table for keeping applied migration information.
--template-file, -F: (defaults to '@yii/views/migration.php')
--use-table-prefix, -P: boolean, 0 or 1 (defaults to 1)
indicates whether the table names generated should consider
the `tablePrefix` setting of the DB connection. For example, if the table
name is `post` the generator wil return `{{%post}}`.
3、添加字段，如果迁移的名称遵循 add_xxx_to_yyy 这样的格式，生成的类文件将会包含必要的 addColumn 和 dropColumn。你可以像如下这样指定多个字段：yii migrate/create add_xxx_column_yyy_column_to_zzz_table –fields=”xxx:integer,yyy:text”。如图2
图2
PS E:/wwwroot/channel-pub-api> ./yii migrate/create add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table --fields="group_name:string(64):notNull:defaultValue(''),name:string(32):notNull:defaultValue(''),avatar:string:notNull:defaultValue(''),fans_count:integer:notNull:defaultValue(0)"
Yii Migration Tool (based on Yii v2.0.35)
Create new migration 'E:/wwwroot/channel-pub-api/console/migrations/m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table.php'? (yes|no) [no]:yes
New migration created successfully.
4、生成 PHP 类文件：m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table.php。
<?php
use yii/db/Migration;
/**
* Handles adding columns to table `{{%channel_app_source}}`.
*/
class m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table extends Migration
{
/**
* {@inheritdoc}
*/
public function safeUp()
{
$this->addColumn('{{%channel_app_source}}', 'group_name', $this->string(64)->notNull()->defaultValue(''));
$this->addColumn('{{%channel_app_source}}', 'name', $this->string(32)->notNull()->defaultValue(''));
$this->addColumn('{{%channel_app_source}}', 'avatar', $this->string()->notNull()->defaultValue(''));
$this->addColumn('{{%channel_app_source}}', 'fans_count', $this->integer()->notNull()->defaultValue(0));
}
/**
* {@inheritdoc}
*/
public function safeDown()
{
$this->dropColumn('{{%channel_app_source}}', 'group_name');
$this->dropColumn('{{%channel_app_source}}', 'name');
$this->dropColumn('{{%channel_app_source}}', 'avatar');
$this->dropColumn('{{%channel_app_source}}', 'fans_count');
}
}
5、编辑 PHP 类文件：m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table.php。以添加其他的字段选项：字段注释、字段顺序。
<?php
use yii/db/Migration;
/**
* Handles adding columns to table `{{%channel_app_source}}`.
*/
class m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table extends Migration
{
/**
* {@inheritdoc}
*/
public function safeUp()
{
$this->addColumn('{{%channel_app_source}}', 'group_name', $this->string(64)->notNull()->defaultValue('')->comment('租户名称')->after('group_id'));
$this->addColumn('{{%channel_app_source}}', 'name', $this->string(32)->notNull()->defaultValue('')->comment('名称')->after('channel_type_code'));
$this->addColumn('{{%channel_app_source}}', 'avatar', $this->string()->notNull()->defaultValue('')->comment('头像')->after('name'));
$this->addColumn('{{%channel_app_source}}', 'fans_count', $this->integer()->notNull()->defaultValue(0)->comment('粉丝数')->after('avatar'));
}
/**
* {@inheritdoc}
*/
public function safeDown()
{
$this->dropColumn('{{%channel_app_source}}', 'group_name');
$this->dropColumn('{{%channel_app_source}}', 'name');
$this->dropColumn('{{%channel_app_source}}', 'avatar');
$this->dropColumn('{{%channel_app_source}}', 'fans_count');
}
}
6、提交迁移，为了将数据库升级到最新的结构，你应该使用如下命令来提交所有新的迁移。如图3
图3
PS E:/wwwroot/channel-pub-api> ./yii migrate
Yii Migration Tool (based on Yii v2.0.35)
Total 1 new migration to be applied:
m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table
Apply the above migration? (yes|no) [no]:yes
*** applying m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table
> add column group_name string(64) NOT NULL DEFAULT '' COMMENT '租户名称' AFTER `group_id` to table {{%channel_app_source}} ... done (time: 0.108s)
> add column name string(32) NOT NULL DEFAULT '' COMMENT '名称' AFTER `channel_type_code` to table {{%channel_app_source}} ... done (time: 0.097s)
> add column avatar string NOT NULL DEFAULT '' COMMENT '头像' AFTER `name` to table {{%channel_app_source}} ... done (time: 0.170s)
> add column fans_count integer NOT NULL DEFAULT 0 COMMENT '粉丝数' AFTER `avatar` to table {{%channel_app_source}} ... done (time: 0.158s)
*** applied m201014_055436_add_group_name_column_name_column_avatar_column_fans_count_column_to_channel_app_source_table (time: 0.551s)
1 migration was applied.
Migrated up successfully.
7、查看最新的表设计，符合预期，如图4
图4
原创文章，作者：3628473679，如若转载，请注明出处：https://blog.ytso.com/181584.html