Author Table Reference

Author Table

Associated Perl objects

• MT::Author

Fields

• author_id - integer not null auto_increment. Author primary key.
• author_name - string(255) not null. The username the user uses for logging into Melody.
• author_nickname - string(255). The user's display name.
• author_password - string(60) not null. A hash of the user's password.
• author_type - smallint not null.
• author_email - string(127). The user's email address.
• author_url - string(255). The URL associated with the user (mainly used for association during commenting).
• author_public_key - text. A field for storing a public key (as in PKI) associated with a user.
• author_preferred_language - string(50). The language associated with the user. Normally derived from that of the blog which first created them.
• author_api_password - string(60). The user's password for the XMLRPC system. This is different from their normal Melody login password.
• author_remote_auth_username - string(50).
• author_remote_auth_token - string(50).
• author_entry_prefs - string(255). If the user is capable of creating entries, this field will contain their entry editor preferences.
• author_text_format - string(30).
• author_status - integer. Status of the user. Possible values are:
  • 1 - Approved
  • 2 - Blocked/Banned
  • 3 - Pending Approval
• author_external_id - string(255). A unique ID code from their external authenticator if the user was logged in via a mechanism other than the native Melody login system, such as OpenID.
• author_auth_type - string(50). The method they logged in. Common values include:
  • LiveJournal - Authenticated by LiveJournal.
  • MT - Native Melody login.
  • OpenID - Generic OpenID authentication.
• author_userpic_asset_id - integer. Points to the image asset which functions as their userpic.
• author_basename - string(255). This value is used in many cases when publishing author listing archives. It forms the basis of the "%b" archive mapping instruction.