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/20200813114528_CreateProfiles.php (1828B)

<?php
declare(strict_types=1);

use Migrations\AbstractMigration;

class CreateProfiles 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('profiles'); 
        $table->addColumn('user_id', 'integer', [
            'default' => null,
            'limit' => 11,
            'null' => false,
        ]);  
        $table->addColumn('first_name', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('last_name', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('image', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => true,
        ]);
        $table->addColumn('address', 'string', [
            'default' => null,
            'limit' => 255,
            'null' => false,
        ]);
        $table->addColumn('phone', 'integer', [
            'default' => null,
            'limit' => 11,
            'null' => false,
        ]);
        $table->addColumn('contact_phone', 'boolean', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('contact_email', 'boolean', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('created', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->addColumn('modified', 'datetime', [
            'default' => null,
            'null' => false,
        ]);
        $table->create();
    }
}

table('profiles'); $table->addColumn('user_id', 'integer', [ 'default' => null, 'limit' => 11, 'null' => false, ]); $table->addColumn('first_name', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('last_name', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('image', 'string', [ 'default' => null, 'limit' => 255, 'null' => true, ]); $table->addColumn('address', 'string', [ 'default' => null, 'limit' => 255, 'null' => false, ]); $table->addColumn('phone', 'integer', [ 'default' => null, 'limit' => 11, 'null' => false, ]); $table->addColumn('contact_phone', 'boolean', [ 'default' => null, 'null' => false, ]); $table->addColumn('contact_email', 'boolean', [ 'default' => null, 'null' => false, ]); $table->addColumn('created', 'datetime', [ 'default' => null, 'null' => false, ]); $table->addColumn('modified', 'datetime', [ 'default' => null, 'null' => false, ]); $table->create(); } }