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 |