char_id sql weird data

[iZeal]

Hello I just notice something weird about my db when i checked the char_id column I notice the start of the value was "1" instead of "150000".. attached is a screen shot..

 

[Emistry]

maybe you accidently changee the auto_increment value ??

[iZeal]

never touch anything with the structure :/ anyway to fix this? I'm not sure if it will also affect the new one's 

Edited August 10, 2014 by iZeal

[Emistry]

ALTER TABLE `char` AUTO_INCREMENT = 150000;

probably the Control Panel that you using changed the original value of 150000.

 

ops..it's char..

somewhere in source defined the default starting value..forget which file...kinda lazy to search..xD

[iZeal]

can you help me where to find that?

hmm what about the previous data?

Edited August 10, 2014 by iZeal

[CandyCandy]

As I can remember, there's nothing bad to start char_id from "1".

Do you really need to start them from "150000"? You can't just change it for existing data without any kind of self-writed parser, which would change char_id for every character on every gameDB table.

 

Edited August 10, 2014 by CandyCandy

[iZeal]

hmm really nothing good bad to happen., it's just that i'm not use to it