/**
* @return CDbTable
*/
public static function TwofaAccounts()
{
return new CDbTable('twofa_accounts', CDbSchemaHelper::prefix(), array(new CDbField('id', CDbField::AUTO_INT), new CDbField('account_id', CDbField::INT), new CDbField('auth_type', CDbField::VAR_CHAR, ETwofaType::AUTH_TYPE_AUTHY), new CDbField('data_type', CDbField::INT, ETwofaType::DATA_TYPE_AUTHY_ID), new CDbField('data_value', CDbField::VAR_CHAR)), array(new CDbKey(CDbKey::TYPE_PRIMARY_KEY, array('id'))));
}
/**
* @return CDbTable
*/
public static function AwmSocial()
{
return new CDbTable('awm_social', CDbSchemaHelper::Prefix(), array(new CDbField('id', CDbField::AUTO_INT), new CDbField('id_acct', CDbField::INT, 0), new CDbField('id_social', CDbField::VAR_CHAR), new CDbField('type', CDbField::INT, 0), new CDbField('name', CDbField::VAR_CHAR), new CDbField('access_token', CDbField::TEXT), new CDbField('refresh_token', CDbField::VAR_CHAR)), array(new CDbKey(CDbKey::TYPE_PRIMARY_KEY, array('id')), new CDbKey(CDbKey::TYPE_INDEX, array('id_acct'))));
}
/**
* @param bool $bAddDropFunction Default value is **false**.
*
* @return array
*/
public function getSqlFunctionsAsArray($bAddDropFunction = false)
{
$aResult = array();
$aFunctions = CDbSchemaHelper::getSqlFunctions();
foreach ($aFunctions as $oFunction) {
$aResult[] = $oFunction->ToString($this->oHelper, $bAddDropFunction);
}
return $aResult;
}
/**
* @return CDbTable
*/
public static function EavAttributesInt()
{
return new CDbTable('eav_attributes_int', CDbSchemaHelper::prefix(), array(new CDbField('id', CDbField::AUTO_INT_BIG_UNSIGNED), new CDbField('id_entity', CDbField::INT_BIG_UNSIGNED), new CDbField('name', CDbField::VAR_CHAR, null, 255), new CDbField('value', CDbField::INT)), array(new CDbKey(CDbKey::TYPE_PRIMARY_KEY, array('id'))));
}