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.
| 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 |
|
||
| 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 |