[Marble-development] Data tables...

[Elissa F. <fe...@ne...>]

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