Skip to content
This repository was archived by the owner on Aug 6, 2022. It is now read-only.

IV. Database schema

Andrey Bogdanov edited this page Mar 2, 2016 · 26 revisions

Schema

postCounters

Type: hash.

Key: board name.

Value: last post number on the board.

threads:<boardName>

Type: multiple hashes. <boardName> is the additional part of the key.

Key: thread number.

Value: Stringified JSON. Fields:

  • archived Determines if the thread is archived. Possible values: true/false.
  • boardName The thread's board name.
  • closed Determines if the thread is closed. Possible values: true/false.
  • createdAt Thread creation date and time in ISO format.
  • fixed Determines if the thread is fixed. Possible values: true/false.
  • number The number of the thread.
  • user Thread author information. An object.
  • hashpass User hashpass (hex representation of a SHA-1 hash). May be null.
  • ip IP-address of the user in normalized IPv6 form.
  • level User access level. "SUPERUSER", "ADMIN", "MODER", "USER", or null.
  • password Hashed (SHA-1) user password. May be null.
  • unbumpable Determines if the thread is unbumpable. Possible values: true/false`.
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``
``

Value types

  • ZSET — ordered set
  • SET-M — multi-set (using multiple keys)
  • HASH-M — multi-hash (using multiple keys)
  • ZSET-M — ordered multi-set (using multiple keys)

Note: Refer to http://redis.io/topics/data-types

Clone this wiki locally