userproplist

userproplist — List of possible meta-data on users.

userproplist

Column nameTypeNullDefaultDescription
upropidsmallint unsigned auto_incrementUnique id for this meta-data property.
namevarchar(50)YESName of property, matching [a-z0-9_]+. Intended for use by code and clients.
indexedenum('1','0')1
cldversiontinyint unsigned0
multihomedenum('1','0')0
prettynamevarchar(60)YESMixed case pretty name with spaces and punctuation. Indeded for use by humans.
datatypeenum('char','num','bool','blobchar')charEither "char" for text data, "num" for an integer, or "bool" for a 1/0 value.
desvarchar(255)YESDescription of the meta-data, for use by developers (humans?)
scopeenum('general','local')general
Key nameTypeColumn(s)
PRIMARYPRIMARY
nameUNIQUE