DNF台服每天0点刷新角色创建限制数据库代码

//每一段代码运行一次，总共4段，一定要分开！

use d_taiwan;
select @@event_scheduler;
set global event_scheduler = on;
select @@event_scheduler;


CREATE PROCEDURE reset_create_role() 
update d_taiwan.limit_create_character set count=0;


CREATE EVENT  event_reset_create_role
ON SCHEDULE
EVERY '1' day STARTS '2021-09-12 00:00:00'
DO 
call reset_create_role();


alter event event_reset_create_role enable;