D 2018-05-05T17:03:36.100
L SQL\stables
P 1e9bca73a118b2f4decfbc104c99f4748d963dfb
U zzo38
W 1008
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>

Z 7dbd4df7148ee3108a45a8dc89a7a756