core03Example.sdl

Schema for the core03Example_main.c example. Compile this schema using rdm-compile as follows:

rdm-compile --c-structs --lc-struct-members --catalog core03Example.sdl

and include the generated header file(s) as follows:

#include "core03Example_structs.h"
#include "core03Example_cat.h"

and compile the following generated source file(s):

core03Example_cat.c

Here follows the actual schema:

/*
 * EXAMPLE - Core03 for C
 *
 * This is the DDL (Database Definition Language) for a single field,
 * single record-type database. The one record type is called CORE03_RECORD,
 * and it's one field, MESSAGE, can store an UTF-8 string.
 */
 
create table artist
(
    id rowid primary key,
    name char(100) not null
);
 
create table album
(
    id rowid references artist,
    title char(100) not null
);