1
2
3
4
5
6
7
8
9
10
11
12
|
1
2
3
4
5
6
7
8
9
10
11
12
|
-
+
|
This document is a list of the available SQL tables and views that you can use in the customization of Free Hero Mesh. You can also add your own tables and views. 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. Virtual tables also cannot usually be rolled back.
An asterisk in the heading indicates a (eponymous only) virtual table; you cannot define triggers on a virtual table. Virtual tables also cannot usually be rolled back.
<h2>CLASSES *</h2>
<verbatim-1>CREATE TABLE "CLASSES"("ID" INTEGER PRIMARY KEY, "NAME" TEXT, "EDITORHELP" TEXT, "HELP" TEXT,
"INPUT" INT, "QUIZ" INT, "TRACEIN" INT, "TRACEOUT" INT, "GROUP" TEXT, "PLAYER" INT);</verbatim-1>
List of all classes. This table is mostly read-only; only the "QUIZ", "TRACEIN", and "TRACEOUT" columns can be altered, and their values must be one or zero. Inserting and deleting rows is not possible.
|