table("product", ["signed" => false, "collation" => "utf8mb4_general_ci"]) ->addColumn("supplier_id", "integer", ["signed" => false]) ->addColumn("name", "string") ->addColumn("type", "integer", ["limit" => MysqlAdapter::INT_TINY, "signed" => false]) ->addColumn("price", "decimal", ["signed" => false, "precision" => 8, "scale" => 2]) ->addColumn("dts_created", "datetime") ->addColumn("dts_updated", "datetime", ["null" => true]) ->addColumn("dts_deleted", "datetime", ["null" => true]) ->addForeignKey("supplier_id", "supplier", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->create(); } }