20220625181248_add_product_table.php 836 B

1234567891011121314151617181920
  1. <?php
  2. declare(strict_types=1);
  3. use Phinx\Db\Adapter\MysqlAdapter;
  4. use Phinx\Migration\AbstractMigration;
  5. final class AddProductTable extends AbstractMigration {
  6. public function change(): void {
  7. $this->table("product", ["signed" => false, "collation" => "utf8mb4_general_ci"])
  8. ->addColumn("supplier_id", "integer", ["signed" => false])
  9. ->addColumn("name", "string")
  10. ->addColumn("type", "integer", ["limit" => MysqlAdapter::INT_TINY, "signed" => false])
  11. ->addColumn("price", "decimal", ["signed" => false, "precision" => 8, "scale" => 2])
  12. ->addColumn("dts_created", "datetime")
  13. ->addColumn("dts_updated", "datetime", ["null" => true])
  14. ->addColumn("dts_deleted", "datetime", ["null" => true])
  15. ->addForeignKey("supplier_id", "supplier", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  16. ->create();
  17. }
  18. }