<?php
/**
 * Created by PhpStorm.
 * User: Ziy
 * Date: 14/8/30
 * Time: 上午10:51
 */

namespace YHMPassport\SqlMap;


class ShroffAccount
{
    const INSERT_USER_SHROFF_ACCOUNT = 'insert into user_shroff_account (`uid`,`open_id`,`account`,`account_name`,`account_type`,`binding_time`) values (:uid,:open_id,:account,:account_name,:account_type,UNIX_TIMESTAMP()) ON DUPLICATE KEY UPDATE open_id=:open_id,update_time=UNIX_TIMESTAMP()';

    const GET_ACCOUNT_BY_UID = 'select * from `user_shroff_account` where `uid`=:uid and `account_type`=:account_type';

    const GET_ACCOUNT_BY_OPEN_ID = 'select * from `user_shroff_account` where `account`=:open_id and `account_type`=:account_type';
}