D 2018-04-20T05:30:01.256
L SQL\stables
U zzo38
W 875
This document is a list of the available SQL tables and views that you can use in the customization of Free Hero Mesh.

(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. A question mark in the heading is something that hasn't even been written into the program yet.

<h2>CLASSES * ?</h2>

<h2>INVENTORY * ?</h2>

<h2>LEVELS * ?</h2>

<h2>MOVES * ?</h2>

<h2>OBJECTS * ?</h2>

<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.

<h2>USERCACHEDATA</h2>

<h2>USERCACHEINDEX</h2>

Z 789e7f13a759e69f9eb2ea4127bf207f