|
From: Elissa F. <fe...@ne...> - 2004-03-14 05:22:36
|
Hi Justin, I'd like to see the following changes to the database, now that I've=20 given it a look. First, I'd like all tables to have an ID field. This = is to allow easier deletions**. =20 - the chr table to be called "character" (everything else has it spelled out). - "grp" to be called "group" - "usr" to be "user" =20 - The "ogin" field in "usr" to be "login" (in "user"). - "privileges" to be "privilege. - all other tables that are plural (e.g., Character_Holdings) to be singular (Character_Holding). I'm just looking for consistency across the board. All other tables are fully spelled out, and I'd prefer not to have to remember which are, which aren't, etc.=20 ** - If I've already computed that id=3D16 is the record that contains data X, and I choose to delete it, I don't want to have to recompute it each the time. On the other hand, I'm basing this on the assumption that a GM doesn't have an evil twin who's performing the very same=20 database maintenance at the same time to the very end of the very same table. MySQL's auto-incrementing WILL use a previously used max id, which means if someone's deleted and inserted into the same table in the time that you have viewed the data and decided to delete the same last record(s), you WILL be chosing different data than you=20 expect. On the other hand, sometimes you just gotta delete record 16, and you don't have any other way to easily grab it. Feedback, etc? Thanks, Elissa |