Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u184721437

Directory:

/home/u184721437/domains/dataduck.in/public_html/app-project/7plus/application/migrations

Free Space:

7.05 TB

🔧 Quick Actions

✏️ Editing: 014_delivery_boy.php

<?php
defined('BASEPATH') or exit('No direct script access allowed');
class Migration_delivery_boy extends CI_Migration
{

public function up()
    {
        /* adding new column in users status */

$fields = array(
            'status' => array(
                'type'           => 'TINYINT',
                'constraint'     => '4',
                'NULL'           => FALSE,
                'default'        => '0',
                'after'          => 'driving_license'
            ),
        );
        $this->dbforge->add_column('users', $fields);

// ALTER TABLE `zipcodes` ADD `city_id` INT NOT NULL AFTER `zipcode`;
    // ALTER TABLE `zipcodes` ADD `minimum_free_delivery_order_amount` DOUBLE NOT NULL DEFAULT '0' AFTER `city_id`;
    // ALTER TABLE `zipcodes` ADD `delivery_charges` DOUBLE NULL DEFAULT '0' AFTER `minimum_free_delivery_order_amount`;

$fields = array(
            'city_id' => array(
                'type'           => 'INT',
                'constraint'     => '11',
                'NULL'           => FALSE,
                'after'          => 'zipcode'
            ),
            'minimum_free_delivery_order_amount' => array(
                'type'           => 'DOUBLE',
                'NULL'           => FALSE,
                'default'        => '0',
                'after'          => 'city_id'
            ),
            'delivery_charges' => array(
                'type'           => 'DOUBLE',
                'NULL'           => TRUE,
                'default'        => '0',
                'after'          => 'minimum_free_delivery_order_amount'
            ),
        );
        $this->dbforge->add_column('zipcodes', $fields);

// ALTER TABLE `addresses` ADD `system_pincode` TINYINT NOT NULL DEFAULT '1' AFTER `pincode`;

$fields = array(
            'system_pincode' => array(
                'type'           => 'TINYINT',
                'constraint'     => '4',
                'NULL'           => FALSE,
                'default'        => '1',
                'after'          => 'pincode'
            ),
        );
        $this->dbforge->add_column('addresses', $fields);

}
    public function down()
    {
        $this->dbforge->drop_column('status', 'users');
        $this->dbforge->drop_column('city_id', 'zipcodes');
        $this->dbforge->drop_column('minimum_free_delivery_order_amount', 'zipcodes');
        $this->dbforge->drop_column('delivery_charges', 'zipcodes');
        $this->dbforge->drop_column('system_pincode', 'addresses');
    }
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: 014_delivery_boy.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation