talkproplist — Global. Stores list of possible metadata for comments.
| Column name | Type | Null | Default | Description |
|---|---|---|---|---|
| tpropid | smallint unsigned auto_increment |
|
Unique id of a comment property. | |
| name | varchar(50) | YES |
|
System name of a comment property. |
| prettyname | varchar(60) | YES |
|
Property name formatted to be human-readable. |
| datatype | enum('char','num','bool') |
char
|
Type of property, e.g. bool(ean). | |
| des | varchar(255) | YES |
|
Description of a comment property. |
| scope | enum('general','local') |
general
|
Either "general" for talkprops in the generic LiveJournal code, or "local" if the talkprop is site-specific. |
| Key name | Type | Column(s) |
|---|---|---|
| PRIMARY | PRIMARY | |
| name | UNIQUE |