This document is a list of the available SQL tables and views that you can use in the customization of Free Hero Mesh. 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.

<h2>CLASSES *</h2>

This table is read-only.

<h2>INVENTORY *</h2>

This table is read-only.

<h2>LEVELS *</h2>

<h2>MOVES *</h2>

<h2>OBJECTS *</h2>

This table is read-only in game mode; it can be written in edit mode.

<h2>PICTURES</h2>
<verbatim-1>CREATE TEMPORARY TABLE "PICTURES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT, "OFFSET" INT);</verbatim-1>

A list of all of the pictures that are available; loaded from the .xclass file. Probably only the NAME column is useful to the user; it is the lump name without the .IMG suffix.

While it is possible to write to this table, there is probably no use to do so.

<h2>USERCACHEDATA</h2>

<h2>USERCACHEINDEX</h2>

<h2>VARIABLES</h2>
<verbatim-1>CREATE TEMPORARY TABLE "VARIABLES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT);</verbatim-1>

List of all global and local variables. The ID is the class number left shifted by sixteen bits (the class number is zero for global variables), and then the low sixteen bits have the variable number. The name omits the or <tt>%</tt> prefix.