A user name can be the same as a character name.
Test:
Created (by mistake) a character named after my account.
Question:
Can you have the same character name in two different servers?
Accounts and characters are probably stored in different database tables. Do you think the character name is the primary key? Alternatively, there might be some kind of surrogate key, e.g. a sequence number. It is an MS SQL Server, isn't it? About a year ago Sofia deleted a character named oytis and she has now re-created a new one with the same name. Thus either the character name is not a primary key, or the characters are indeed deleted and not de-activated.
4 comments:
about the question:
yes, you can have the same character name in different servers, i do.
that was one of the reasons ncsoft asked to create a new char with the desired name when you transfer characters from, to another server.
about the db stuff:
i dont think that the name is primary key, not even in server-separated tables. its impractical and could create problems when ncsoft staff look the log files, history or what ever is their method of checking things that happened. There are db experts in our lovely clan that can explain things better than me but even with my basic knowledge i thing its safe bet to say that the name is no primary key.
Deleted characters are simply... deleted! I suppose that's one good reason for the 7-day period of deletion.
Inactive or banned accounts' characters are de-activated, i.e. they are still in the database.
What kind of database designer actually deletes rows?!?!
We usually only *say* we do..
Oh. Ooooooh!
Post a Comment