<?php

namespace YHMPassport\SqlMap;

class Sso
{
	
	const GET_BY_UID_AND_SSOUID = 'select * from `sso_user_relation` where `uid`=:uid and `sso_uid`=:sso_uid';
	
	const SET_RELATION = 'insert into `sso_user_relation`(`uid`,`sso_uid`,`bind_time`) values(:uid,:sso_uid,UNIX_TIMESTAMP())';
	
	const GET_UID_BY_SSOUID = 'select `uid` from `sso_user_relation` where `sso_uid`=:sso_uid';
	
	const GET_SSOUID_BY_UID = 'select `sso_uid` from `sso_user_relation` where `uid`=:uid';
}