Below is the file 'init.sql' from this revision. You can also download the file.

CREATE TABLE gconf (
	version integer
);
INSERT INTO gconf (version) VALUES (1);

CREATE TABLE directories (
	id integer primary key,
	name text not null,
	parent_id integer not null,
	UNIQUE (name, parent_id)
);

CREATE TABLE keys (
	id integer primary key,
	name text,
	directory_id integer not null,
	mod_user text,
	mod_time text,
	schema_name text,
	value_type text,
	value,
	UNIQUE (name, directory_id)
);

CREATE TABLE lists (
	key_id integer,
	list_idx integer,
	value_type text,
	value,
	UNIQUE (key_id, list_idx)
);

CREATE TABLE pairs (
	key_id integer primary key,
	car_value_type text,
	car_value,
	cdr_value_type text,
	cdr_value
);