Schema:metadata

From ISFDB
Jump to navigation Jump to search

Schema Summary

+------------------------+------------+------+-----+---------+-------+
| Field                  | Type       | Null | Key | Default | Extra |
+------------------------+------------+------+-----+---------+-------+
| metadata_schemaversion | mediumtext | YES  |     | NULL    |       |
| metadata_counter       | int(11)    | YES  |     | NULL    |       |
| metadata_dbstatus      | int(11)    | NO   |     |         |       |
| metadata_editstatus    | int(11)    | NO   |     |         |       |
+------------------------+------------+------+-----+---------+-------+

Description

The metadata table holds a single block of global data.

  • metadata_schemaversion - This column holds the schema version number of this database.
  • metadata_counter - This column holds the number of database queries made.
  • metadata_dbstatus - Database status. Can be one of:
    • 0 = Offline
    • 1 = Online
  • metadata_editstatus - Editing status. Can be one of:
    • 0 = Editing Offline
    • 1 = Public Editing Enabled
    • 2 = Moderator Editing Only