Free Hero Mesh

Update of "SQL tables"
Login
This is a mirror of the main repository for Free Hero Mesh. New tickets and changes will not be accepted at this mirror.
Overview

Artifact ID: 934540cff3f0677a0071cb6fe982b2002a26662b
Page Name:SQL tables
Date: 2018-04-20 05:30:01
Original User: zzo38
Next c0e3a5fdadf347e960ed9c05cc3a37e73b533c54
Content

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.

CLASSES * ?

INVENTORY * ?

LEVELS * ?

MOVES * ?

OBJECTS * ?

PICTURES

CREATE TEMPORARY TABLE "PICTURES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT, "OFFSET" INT);

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.

USERCACHEDATA

USERCACHEINDEX