Wednesday, April 4, 2012

yg banyak datanya :
- attribute
- modifier
- itemType
- level
- class
- gem

===

DELETE FROM tblbackpack;

DELETE FROM tblequipment;

DELETE FROM tblcharacter WHERE CHARACTERid > 1200;

DELETE FROM tblclass WHERE classid > 20;

DELETE FROM tblgem WHERE gemid > 8;

ALTER TABLE tblgem AUTO_INCREMENT=8

===

ALTER TABLE tblclass AUTO_INCREMENT=20

===

DELETE FROM tblbackpack;

DELETE FROM tblequipment;

DELETE FROM tblitem;

DELETE FROM tblbaseitem WHERE baseitemid > 1000;

DELETE FROM tblitemgroup WHERE itemgroupid <> 1

===

DELETE FROM tblmodifier WHERE modifierid > 5000

===

DELETE FROM tblattribute WHERE attributeid <> 2 AND attributeid <> 3

No comments:

Post a Comment