userproplist

userproplist — Global. Stores list of possible metadata on users. Allows for having userprops stored globally for indexing; and, by way of the multihomed column, on a cluster as "multihomed userprops", for easy access on user profile pages and such.

userproplist

Column name Type Null Default Description
upropid smallint unsigned auto_increment   Unique id for this meta-data property.
name varchar(50) YES Name of property, matching [a-z0-9_]+. Intended for use by code and clients.
indexed enum('1','0')   1  
cldversion tinyint unsigned   0  
multihomed enum('1','0')   0  
prettyname varchar(60) YES Mixed case pretty name with spaces and punctuation. Intended for use by humans.
datatype enum('char','num','bool','blobchar')   char Either "char" for text data, "num" for an integer, or "bool" for a 1/0 value.
des varchar(255) YES Description of the meta-data, for use by developers (humans?)
scope enum('general','local')   general Either "general" for userprops in the generic LiveJournal code, or "local" if the userprop is site-specific.
Key name Type Column(s)
PRIMARY PRIMARY
name UNIQUE