safekat/ci4/app/Database/Migrations/2025-04-27-082200_AddPliegoColumnOrdenTrabajoTarea.php

<?php

namespace App\Database\Migrations;

use CodeIgniter\Database\Migration;

class AddPliegoColumnOrdenTrabajoTarea extends Migration
{

    protected array $COLUMNS = [
        "pliego_1" => [
            "type" => "INT",
            "unsigned" => true,
            "default" => 0,
        ],
        "pliego_1_total" => [
            "type" => "INT",
            "unsigned" => true,
            "default" => 0,
        ],
        "pliego_2" => [
            "type" => "INT",
            "unsigned" => true,
            "default" => 0,
        ],
        "pliego_2_total" => [
            "type" => "INT",
            "unsigned" => true,
            "default" => 0,
        ],
    ];
    public function up()
    {
        $this->forge->addColumn('orden_trabajo_tareas', $this->COLUMNS);
    }

    public function down()
    {
        $this->forge->dropColumn('orden_trabajo_tareas', array_keys($this->COLUMNS));
    }
}