"CREATE TABLE IF NOT EXISTS [muleAccounts] ([accountId] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT, [accountRealm] INTEGER  NULL, [accountLogin] VARCHAR(32)  NULL, [accountPasswd] VARCHAR(32)  NULL, [accountUser] TEXT  NULL)",
			"CREATE TABLE IF NOT EXISTS [muleChars] ([charId] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL, [charAccountId] INTEGER  NULL, [charName] VARCHAR(32)  NULL, [charExpansion] BOOLEAN  NULL, [charHardcore] BOOLEAN  NULL, [charLadder] BOOLEAN  NULL, [charClassId] INTEGER NULL)",
			"CREATE TABLE IF NOT EXISTS [muleItems] ([itemId] INTEGER  NOT NULL PRIMARY KEY AUTOINCREMENT, [itemCharId] INTEGER  NULL, [itemName] VARCHAR(64)  NULL, [itemType] INTEGER  NULL, [itemClass] INTEGER  NULL, [itemClassid] INTEGER  NULL, [itemQuality] INTEGER  NULL, [itemFlag] INTEGER  NULL, [itemColor] INTEGER  NULL, [itemImage] VARCHAR(8)  NULL, [itemMD5] VARCHAR(32)  NULL, [itemDescription] TEXT  NULL, [itemLocation] INTEGER  NULL)",
			"CREATE TABLE IF NOT EXISTS [muleItemsStats] ([statsItemId] INTEGER  NULL, [statsName] VARCHAR(50)  NULL, [statsValue] INTEGER  NULL)",
			"CREATE UNIQUE INDEX IF NOT EXISTS [IDX_MULEACCOUNTS_ACCOUNTID] ON [muleAccounts]([accountRealm]  ASC, [accountLogin]  ASC)",
			"CREATE UNIQUE INDEX IF NOT EXISTS [IDX_MULECHARS_CHARID] ON [muleChars]([charAccountId]  ASC, [charName]  ASC)",
			"CREATE UNIQUE INDEX IF NOT EXISTS [IDX_MULEITEMS_ITEMID] ON [muleItems]([itemId]  ASC, [itemCharId]  ASC)",
			"CREATE UNIQUE INDEX IF NOT EXISTS [IDX_MULEITEMSSTATS_STATSITEMID] ON [muleItemsStats]([statsItemId]  ASC,[statsName]  ASC)",
			"CREATE TRIGGER [ON_TBL_MULEACCOUNTS_DELETE] BEFORE DELETE ON [muleAccounts] FOR EACH ROW BEGIN DELETE FROM muleChars WHERE charAccountId = OLD.accountId; END",
			"CREATE TRIGGER [ON_TBL_MULECHARS_DELETE] BEFORE DELETE ON [muleChars] FOR EACH ROW BEGIN DELETE FROM muleItems WHERE itemCharId = OLD.charId; END",
			"CREATE TRIGGER [ON_TBL_MULEITEMS_DELETE] BEFORE DELETE ON [muleItems] FOR EACH ROW BEGIN DELETE FROM muleItemsStats WHERE statsItemId = OLD.itemId; END"