Failed Conditions
Push — master ( 58c386...42cc4d )
by Adrien
05:55
created

Version20181208061959::up()   A

Complexity

Conditions 1
Paths 1

Size

Total Lines 6
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Code Coverage

Tests 0
CRAP Score 2

Importance

Changes 0
Metric Value
cc 1
eloc 3
nc 1
nop 1
dl 0
loc 6
ccs 0
cts 5
cp 0
crap 2
rs 10
c 0
b 0
f 0
1
<?php
2
3
declare(strict_types=1);
4
5
namespace Application\Migration;
6
7
use Doctrine\DBAL\Schema\Schema;
8
9
class Version20181208061959 extends AbstractMigration
10
{
11
    public function up(Schema $schema): void
12
    {
13
        $this->abortIf($this->connection->getDatabasePlatform()->getName() !== 'mysql', 'Migration can only be executed safely on \'mysql\'.');
14
15
        $this->addSql('ALTER TABLE bookable ADD remarks TEXT NOT NULL');
16
        $this->addSql('ALTER TABLE user ADD last_login DATETIME DEFAULT NULL, ADD active_from DATETIME DEFAULT NULL, ADD welcome_session_date DATETIME DEFAULT NULL, ADD sex SMALLINT DEFAULT 0 NOT NULL, ADD mobile_phone VARCHAR(25) DEFAULT \'\' NOT NULL, ADD ichtus_swiss_sailing VARCHAR(25) DEFAULT \'\' NOT NULL, ADD terms_agreement TINYINT(1) DEFAULT \'0\' NOT NULL, ADD has_insurance TINYINT(1) DEFAULT \'0\' NOT NULL, ADD receives_newsletter TINYINT(1) DEFAULT \'0\' NOT NULL, ADD family_relationship ENUM(\'householder\', \'partner\', \'ex_partner\', \'child\', \'parent\', \'sister\', \'brother\') DEFAULT \'householder\' NOT NULL COMMENT \'(DC2Type:Relationship)\', ADD billing_type ENUM(\'all_electronic\', \'paper_bill_electronic_reminder\', \'paper_bill_paper_reminder\') DEFAULT \'all_electronic\' NOT NULL COMMENT \'(DC2Type:BillingType)\', ADD remarks TEXT NOT NULL');
17
    }
18
}
19