FM / Migrations

/var/www/vhosts/ihelp.ro/_OLD/config/Migrations/

/var/www/vhosts/ihelp.ro/_OLD/config/Migrations

Name	Size	Mode	Actions
20200813114508_CreateProducts.php	2385	0644	edit dl rm
20200813114509_CreateCauses.php	1945	0644	edit dl rm
20200813114517_CreateCategories.php	873	0644	edit dl rm
20200813114518_CreateProductTags.php	1108	0644	edit dl rm
20200813114528_CreateProfiles.php	1828	0644	edit dl rm
20200813114537_CreateMessages.php	1426	0644	edit dl rm
20200813114538_CreateRoles.php	716	0644	edit dl rm
20200813114547_CreateOrders.php	2801	0644	edit dl rm
20200813114548_CreateTags.php	713	0644	edit dl rm
20200813114557_CreateOrderStatuses.php	732	0644	edit dl rm
20200813114567_CreatePaymentLogs.php	1126	0644	edit dl rm
20200813114568_CreateUsers.php	1512	0644	edit dl rm
20200813114577_CreateProductCategories.php	752	0644	edit dl rm
20200813114578_CreateCauseImages.php	980	0644	edit dl rm
20200813114587_CreateProductFavorites.php	995	0644	edit dl rm
20200813114597_CreateProductImages.php	988	0644	edit dl rm
schema-dump-default.lock	30429	0644	edit dl rm

Edit: /var/www/vhosts/ihelp.ro/_OLD/config/Migrations/20200813114547_CreateOrders.php (2801B)

<?php
declare(strict_types=1);

use Migrations\AbstractMigration;

class CreateOrders extends AbstractMigration
{
    /**
     * Change Method.
     *
     * More information on this method is available here:
     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
     * @return void
     */
    public function change()
    {
        $table = $this->table('orders');
        $table->addColumn('uuid', 'string', [
            'default' => null,
            'limit' => 100,
            'null' => false,
        ]);
        $table->addColumn('user_id', 'integer', [
            'default' => null,
            'limit' => 11,
            'null' => false,
        ]);
        $table->addColumn('order_status_id', 'integer', [
            'default' => null,
            'limit' => 11,
            'null' => false,
        ]);
        $table->addColumn('order_status_date', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('order_status_comment', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('email', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('value', 'float', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('supplier_total', 'float', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('ip', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('gatewayId', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('prcId', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('email_sent', 'boolean', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('email_reminder', 'boolean', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('env_key', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('data', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('created', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('modified', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->create();
    }
}

table('orders'); $table->addColumn('uuid', 'string', [ 'default' => null, 'limit' => 100, 'null' => false, ]); $table->addColumn('user_id', 'integer', [ 'default' => null, 'limit' => 11, 'null' => false, ]); $table->addColumn('order_status_id', 'integer', [ 'default' => null, 'limit' => 11, 'null' => false, ]); $table->addColumn('order_status_date', 'datetime', [ 'default' => null, 'null' => false, ]); $table->addColumn('order_status_comment', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('email', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('value', 'float', [ 'default' => null, 'null' => false, ]); $table->addColumn('supplier_total', 'float', [ 'default' => null, 'null' => false, ]); $table->addColumn('ip', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('gatewayId', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('prcId', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('email_sent', 'boolean', [ 'default' => null, 'null' => false, ]); $table->addColumn('email_reminder', 'boolean', [ 'default' => null, 'null' => false, ]); $table->addColumn('env_key', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('data', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('created', 'datetime', [ 'default' => null, 'null' => false, ]); $table->addColumn('modified', 'datetime', [ 'default' => null, 'null' => false, ]); $table->create(); } }