招财猫相关sql
<pre><code class="language-php">#岗位权限复制
#select * from mc_platform_roles where (NAME = &#039;市场主管一考试院&#039; OR NAME = &#039;市场主管&#039;) and pid = &#039;fd98aedb14c44b87929eb1f454142d6d&#039;
#TMS角色权限复制
#select * from mc_employee_data_roles where data_role_name in (&quot;全国二组考试院&quot;,&quot;全国一组考试院&quot;,&quot;北京高考一考试院&quot;,&quot;鲁粤皖高考一考试院&quot;,&quot;浙苏川高考一考试院&quot;,&quot;全国三组考试院&quot;,&quot;全国主管一考试院&quot;,&quot;学业规划一考试院&quot;,&quot;销售五组考试院&quot;,&quot;销售四组考试院&quot;,&quot;销售三组考试院&quot;,&quot;销售二组考试院&quot;,&quot;销售一组考试院&quot;,&quot;产品研培一考试院&quot;,&quot;运营一考试院&quot;,&quot;运营主管一考试院&quot;,&quot;总监一考试院&quot;,&quot;教务二组考试院&quot;,&quot;教务一组考试院&quot;)</code></pre>
<pre><code class="language-php">#登录相关
edubase.mc_members #用户表
edulogs.ec_login_logs #登录记录表
#岗位权限sql
SELECT * FROM mc_members WHERE phone = 15100128182 OR phone = 13801279317 OR phone = 18500500393
SELECT * FROM mc_employees WHERE member_id = &#039;1164e8a079034f4c974d069050223512&#039; OR member_id = &#039;35dde52f12cc4014b9f69eb24546598f&#039; OR member_id = &#039;fefe80b91f544f5180224cd61199afc3&#039;;
SELECT * FROM mc_employee_role
#数据权限表
gc_campus #校区表，数据权限中，校区id
mc_employee_data_roles #数据角色表
mc_merchant_departments #部门表
gc_grades #年部年级表
mc_classification_ands #渠道表
</code></pre>
<pre><code class="language-php">#将密码重置为 123456Zcmiax 9b7db979270081a8edeff037febe2b6e
UPDATE edubase.mc_members SET PASSWORD = &#039;9b7db979270081a8edeff037febe2b6e&#039; WHERE phone = &#039;1850037****&#039;;
#去除登录记录
DELETE FROM edulogs.ec_login_logs WHERE id IN ( SELECT id FROM ( SELECT id FROM edulogs.ec_login_logs WHERE member_id IN ( SELECT id FROM edubase.mc_members WHERE phone = &#039;1850037****&#039; ) ORDER BY created DESC LIMIT 3 ) AS subquery );</code></pre>