Free Hero Mesh

This document is a list of the available SQL tables and views that you can use in the customization of Free Hero Mesh. You can also add your own tables and views. See also: [SQL functions].

(Note: This is only a draft and is likely to change in future.)

An asterisk in the heading indicates a virtual table; you cannot define triggers on a virtual table. Virtual tables also cannot usually be rolled back.

<h2>CLASSES *</h2>
<verbatim-1>CREATE TABLE "CLASSES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT, "EDITORHELP" TEXT, "HELP" TEXT,
 "INPUT" INT, "QUIZ" INT, "TRACEIN" INT, "TRACEOUT" INT, "GROUP" TEXT, "PLAYER" INT);</verbatim-1>

List of all classes. This table is mostly read-only; only the "QUIZ", "TRACEIN", and "TRACEOUT" columns can be altered, and their values must be one or zero. Inserting and deleting rows is not possible.
This table is read-only.

The columns are:
  *  ID: The class ID number.
  *  NAME: The class name (without $ at first).
  *  EDITORHELP: Help text for editing.
  *  HELP: Help text for playing.
  *  INPUT: One if objects of this class receive input (without a popup quiz), or zero if it does not.
  *  QUIZ: One to hide the variables of this object from the player, or zero if it will not hide.
  *  TRACEIN: One to enable tracing when objects of this class receive messages (if tracing is enabled), zero if not.
  *  TRACEOUT: One to enable tracing when objects of this class send messages (if tracing is enabled), zero if not.
  *  GROUP: Normally null. If this is a group of classes, then it contains the names of the classes that the group consists of, with spaces in between, and a space before and after.
  *  PLAYER: One if this class "is the player", or zero if not.

<h2>INVENTORY *</h2>

This table is read-only.

<h2>LEVELS *</h2>