Support:Database Cleanup: Difference between revisions
Content deleted Content added
imported>Hendrik Brummermann No edit summary |
imported>Hendrik Brummermann No edit summary |
||
Line 34:
=== Cleanup Script ===
<source lang="sql">
INSERT INTO del2 SELECT charname FROM del WHERE items='0 leather_armor, 0 club';
INSERT INTO del2 SELECT charname FROM del WHERE items='0 club, 0 leather_armor';
INSERT INTO del2 SELECT charname FROM del WHERE items='0 leather armor, 0 club';
INSERT INTO del2 SELECT charname FROM del WHERE items='0 club, 0 leather armor';
Line 43 ⟶ 45:
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_02_19 WHERE charname=source);
DELETE FROM del2 WHERE EXISTS (SELECT null FROM gameEvents_2009_08_17 WHERE charname=source);
DELETE FROM del2 WHERE EXISTS (SELECT null FROM itemlog WHERE charname = source);
</source>
| |||