Free Hero Mesh

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

Changes to "SQL tables" between 2018-04-27 19:30:44 and 2018-04-28 04:42:50

1
2
3
4
5

6
7

8
9
10
11

12
13
14
15

16
17

18
19

20
21
22
23
24
25
26
1
2
3
4

5
6

7
8
9
10

11
12
13
14

15
16

17
18

19
20
21
22
23
24
25
26




-
+

-
+



-
+



-
+

-
+

-
+







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. A question mark in the heading is something that hasn't even been written into the program yet.
An asterisk in the heading indicates a virtual table; you cannot define triggers on a virtual table.

<h2>CLASSES * ?</h2>
<h2>CLASSES *</h2>

This table is read-only.

<h2>INVENTORY * ?</h2>
<h2>INVENTORY *</h2>

This table is read-only.

<h2>LEVELS * ?</h2>
<h2>LEVELS *</h2>

<h2>MOVES * ?</h2>
<h2>MOVES *</h2>

<h2>OBJECTS * ?</h2>
<h2>OBJECTS *</h2>

This table is read-only.

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