rhosocial\user\migrations\m170406_140953_CreateUserProfileView::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	38
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function up()
    {
        $tablePrefix = $this->db->tablePrefix;
        $userTableName = $tablePrefix . 'user';
        $profileTableName = $tablePrefix . 'profile';
$sql = <<<EOT
CREATE 
VIEW `UserProfileView`AS 
SELECT
`t_user`.guid,
`t_user`.id,
`t_user`.pass_hash,
`t_user`.ip,
`t_user`.ip_type,
`t_user`.created_at,
`t_user`.updated_at,
`t_user`.auth_key,
`t_user`.access_token,
`t_user`.password_reset_token,
`t_user`.`status`,
`t_user`.type,
`t_user`.source,
`t_profile`.nickname,
`t_profile`.first_name,
`t_profile`.last_name,
`t_profile`.gravatar_type,
`t_profile`.gravatar,
`t_profile`.gender,
`t_profile`.timezone,
`t_profile`.individual_sign,
`t_profile`.created_at AS profile_created_at,
`t_profile`.updated_at AS profile_updated_at
FROM
`$userTableName` AS `t_user`
INNER JOIN `$profileTableName` AS `t_profile` ON `t_profile`.guid = `t_user`.guid ;
EOT;
        $this->execute($sql);
    }