Char_ID on SQL Question

[iZeal]

Hi Just wanted to ask about this weird problem on my SQL but nothing unusual it's just that It's my first time seeing something like this:
the char_id started at 1 instead of 150000:

 

[iZeal]

anyone can help me?

 

[kisuka]

First off, perform the following query on your MySQL database to check what the AUTO_INCREMENT value is currently set to for the char table.

SELECT `AUTO_INCREMENT`FROM information_schema.tables WHERE table_schema = 'ragnarokDB'AND table_name = 'char';
If it's below 150000 then you may have accidently messed up the AUTO_INCREMENT value. It's not a terrible issue really, as long as the account_id is still referencing your correct accounts and the char_id is correct in the other tables then theoretically you should be fine. If it's that much of an issue though and you want any future characters made to have 150k+ IDs then perform the following:

ALTER TABLE `char` AUTO_INCREMENT = 150000;