/** * @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')))); }