- jdk 7
- IntelliJ IDEA
- JIndent
- tortoise
- attlassian connector

DELETE FROM tblclassinclude;
DELETE FROM tblclassexclude where itemgroupid > 1;
DELETE FROM tblbackpack;
DELETE FROM tblequipment;

DELETE FROM tblcharacter;
DELETE FROM tblplayer WHERE playerid > 5;
DELETE FROM tblclass WHERE classid > 10;
DELETE FROM tblgem WHERE gemid > 5;


DELETE FROM tblitem;
DELETE FROM tblbaseitem WHERE baseitemid > 1;
DELETE FROM tbllevel WHERE levelid > 5;
DELETE FROM tblmodifier WHERE modifierid > 4;
DELETE FROM tblattribute WHERE attributeid > 3;
DELETE FROM tblitemtype WHERE itemtypeid > 6;

commit;

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