Stupid Question about users

[Yours]

Is it possible to change a usernumber id from 2 to 1? I ended up merging wrong and I wanted my main user to be user number 1, not 2. Is it possible to do this without corrupting the few thousand posts I have made? If so, do I need to know much mySQL coding, or do anything super major? A small tut on how to do this (if at all possible) would be nice!

[Yours Truly]

That's the primary key of the table so i'm not sure how easy it would be

[Yours]

well is there any way I can create a new user, make it userid 1 and then merge my existing account into it?

[Yours Truly]

No i don't believe so as the user id1 is already taken i'm not sure if you delete the user id 1 then try and do it but honestly wouldn't try it on a live board

[Yours]

the user ID 1 doesn't exist anymore I merged that user into userid2

[Yours Truly]

Well you can try altering the table user i think and try changing the primary key of the user to 1

[Eikinskjaldi]

Well you can try altering the table user i think and try changing the primary key of the user to 1

Oooh, such a really bad idea!

Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...

I cant be bothered listing thhe rest, but basically it is most of the tables.

[Yours Truly]

Oooh, such a really bad idea!

Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...

I cant be bothered listing thhe rest, but basically it is most of the tables.
Yea i wasn't too sure on what to do just my guess =]

But yea sounds harder than it is :p

[Adam21]

Oooh, such a really bad idea!

Userid is used all over the place as a foreign key, changing it is a really bad idea. You will need to change access, administrator, adminlog, usergroup, announcement, announcementread, article, attachment, calendarmoderator, cpsession, customavatar, customprofilepic, post...

I cant be bothered listing thhe rest, but basically it is most of the tables.


Exactly.The same also applies to forumids.I did try to alter them in the tables once and the ids placing got screwed up!:DNot advisable to!:)

[Dismounted]

Just create a new user with an ID of one and merge it with the number 2? It should handle all the userid references.