Re[2]: feature proposal: auto increment prefix

   Hi,

   We use our own GUID (Global Unique Identifier) which is composite
from the following subfields:
   1. Country ID     = 1 byte;
   2. State (region) = 1 byte;
   3. City ID        = 2 bytes;
   4. District       = 1 byte;
   5. Server         = 1 byte;
   6. Field Type ID  = 2 bytes;
   7. Counter        = 8 bytes;
               ----------------
               Total: 16 bytes;

   We can add some extra fields like Service Provider ID and other.
Also if this will be unique we have to increase the size of Field Type
ID to 4 bytes instead 2 because the possible values are too many -
Countries, Cities, Streets, etc.:

   1. Country ID          = 1 byte;
   2. Service Provider ID = 2 bytes;
   2. State ID (region)   = 1 byte;
   3. City ID             = 2 bytes;
   4. District ID         = 1 byte;
   5. Server ID           = 1 byte;
   6. Field Type ID       = 4 bytes;
   7. Counter             = 8 bytes;
               ---------------------
                    Total: 20 bytes;


   Best Regards,
   Miroslav Nachev



-- 
MySQL Internals Mailing List
For list archives: http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=gcdmd-internals@xxxxxxxxxxx