Free Hero Mesh

Artifact [41d74d5ccc]
Login
This is a mirror of the main repository for Free Hero Mesh. New tickets and changes will not be accepted at this mirror.

Artifact 41d74d5cccd83f8db920eb3080ac5a973e187825:

Wiki page [SQL tables] by zzo38 on 2018-06-02 05:22:16.
D 2018-06-02T05:22:16.413
L SQL\stables
P b8a28adc16f5bfd45991525254193f08cf18c48d
U zzo38
W 1385
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 <tt>@</tt> or <tt>%</tt> prefix.
Z 3c43d339d5e50d925885198df1aae634