Just a general question about the tables. I was in my _authors table and i noticed erractic numbering of author uid. When an author deletes the account, the uid goes with it and then they are not reassigned by the looks of things so i have author number: 1, 4, 5, 8, 15.... with great holes in the number order.
It is not a big deal, but i was wondering if i coudl tidy this up a little, but was a bit scared to touch it in case i destroyed the whole archive. I woudl like to re-assign a few uid to authors so i coudl get my counts in order.
As an example, if i renumber author with uid 4 to uid 2 in the _authors table will that cause me any problems, and is that the only place in which i woudl have to do that?
Or is it just wiser to leave things well enough alone with regards to this?
thanks
jacci
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
Are you sure they are actually skipped? Try clicking on the column in phpMyAdmin to get it to sort by that column. Sometimes they are there, but just out of order.
Also, I wouldn't go messing with uids, unless you want to create a lot of work for yourself. You'd have to reassign them everywhere they appear, and off the top of my head, that's the members, preferences, stories, chapters reviews--any table where you need to know which user did what. That's all handled by uid and not name.
They are definitely skipped, as they correspond exactly to the holes in my stories folder numbers as well.
Okay then, i was kind of hoping it woudl just be that one spot. I think i will let this one lie, it was just bothering my sense of order, that was all.
thanks
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
As an example, if i renumber author with uid 4 to uid 2 in the _authors table will that cause me any problems, and is that the only place in which i woudl have to do that?
It will cause you HUGE problems. Everything is stored by uid #. Every story, favorite, review, comment, series, challenge, etc is saved on the the uid of the author. If you renumbered the author all of that will be misnumbered.
Am going to let this one go i think. It is upsetting my numerical sense of order, but i will get over it. lmao
thanks alot for your replies
why is nothing ever easy?
url: http://www.pretendercentre.com/missingpieces/
php: 5.2.5 msql: 5.0.45-community
efic version: 3.4.3 latest patches: yes
bridges: none mods: challenges, displayword, beta-search
