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: 1e9bca73a118b2f4decfbc104c99f4748d963dfb
Page Name:SQL tables
Date: 2018-04-28 04:42:50
Original User: zzo38
Parent: 7ae0579ee759ff52be31368126d436d3b20b8ed1 (diff)
Next b8a28adc16f5bfd45991525254193f08cf18c48d
Content

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.

CLASSES *

This table is read-only.

INVENTORY *

This table is read-only.

LEVELS *

MOVES *

OBJECTS *

This table is read-only.

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.

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

USERCACHEDATA

USERCACHEINDEX