系统自Xiuno转换期间执行SQL语句留档 UPDATE post - Assbbs
系统自Xiuno转换期间执行SQL语句留档 UPDATE post SET message fmt = REPLACE message fmt, 'upload/attach/', '/upload/' ; UPDATE post SET message fm…
系统自Xiuno转换期间执行SQL语句留档 UPDATE post SET message fmt = REPLACE message fmt, 'upload/attach/', '/upload/' ; UPDATE post SET message fmt = REPLACE message fmt, 'upload/avatar/', '/avatar/' ; UPDATE thread AS t SET posts = SELECT COUNT p.pid FROM post AS p WHERE p.tid = t.tid ; UPDATE post SET pid = pid + 100000 ; UPDATE post SET pid = tid, tid = 0 WHERE pid IN SELECT MIN pid FROM post GROUP BY tid ; UPDATE post SET quotepid = quotepid + 100000 WHERE quotepid < 200000 AND quotepid !=0 ; UPDATE post AS p SET quote uid = COALESCE SELECT uid FROM post AS p1 WHERE p1.pid = p.quote pid ,0 ; UPDATE post AS p SET quote uid = COALESCE SELECT uid FROM thread AS t WHERE t.tid = p.tid ,0 WHERE p.quote uid = 0 AND p.tid != 0 ;