SQL Commands

Output always begins with PRAGMA foreign_keys=ON regardless of whether the configuration has any references.

The schema begins of a series of CREATE TABLE SQL commands for each struct object in config. The name of the table inherits from the structure name.

Each field within each struct is mapped into a representative SQL type except the struct, which is a virtual type. The name of the column inherits from the field name.

Furthermore, types may have the following attributes.

If null is not specified, the SQL column is marked as NOT NULL. The default attribute is type-specific.

Reference types may contain the actup and actdel attributes map as follows:

These are assigned as FOREIGN KEY(xxx) REFERENCE yyy(zzz) followed by the update or delete clause, if applicable.

Lastly, any unique statement on the structure is rendered as a unique index. The name of the index is the (sorted) fields in the unique statement, separated by underscores, and prefixed with “unique_strct__” where “strct” is the name of the structure. Thus, an example structure “xyzzy” having unique(foo, bar) would be rendered as:

CREATE UNIQUE INDEX unique_xyzzy__bar_foo ON xyzzy(foo, bar);