20250712025652_extension_eav_attribute_option.php 836 B

12345678910111213141516171819202122232425
  1. <?php
  2. use think\migration\Migrator;
  3. use think\migration\db\Column;
  4. class ExtensionEavAttributeOption extends Migrator
  5. {
  6. /**
  7. * Change Method.
  8. *
  9. * Write your reversible migrations using this method.
  10. */
  11. public function change()
  12. {
  13. $table = $this->table('extension_eav_attribute_option', ['engine' => 'InnoDB', 'comment' => '属性选项表']);
  14. $table->addColumn(Column::unsignedInteger('attribute_id')->setComment('属性ID'))
  15. ->addColumn(Column::string('label')->setComment('显示文本'))
  16. ->addColumn(Column::string('value')->setComment('选项值'))
  17. ->addColumn(Column::unsignedInteger('sort')->setComment('排序'))
  18. ->addTimestamps()
  19. ->addSoftDelete()
  20. ->addIndex(['attribute_id'])
  21. ->create();
  22. }
  23. }