userproplist — List of possible meta-data on users.
| 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. Indeded 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 |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| name | UNIQUE |