پاکسازی تغییرات اخیر و حذف نسخه‌های ماقبل آخر

این مطلب یک یادداشت سریع است.

select * from nw_page where page_id=146;
select * from nw_revision where rev_id=441;
select * from nw_text where old_id=290;
select * from nw_content where content_id=290;
select * from nw_recentchanges where rc_cur_id=146 and rc_this_oldid=441;




delete from nw_recentchanges where rc_log_type='import' and rc_source='mw.log';
delete from nw_recentchanges where rc_log_type='delete' and rc_source='mw.log';
delete from nw_recentchanges where rc_log_type='upload' and rc_source='mw.log';
delete from nw_revision where rev_id not in (select page_latest from nw_page);