The unified diff between revisions [30d555c4..] and [900934c7..] is displayed below. It can also be downloaded as a raw diff.

This diff has been restricted to the following files: 'init.sql'

#
#
# patch "init.sql"
#  from [d2b63fc6563a0cb09ce7d56c1edeb4919295f2a0]
#    to [98c619d34be3c004009e650df8c5282ec4fce633]
#
============================================================
--- init.sql	d2b63fc6563a0cb09ce7d56c1edeb4919295f2a0
+++ init.sql	98c619d34be3c004009e650df8c5282ec4fce633
@@ -17,21 +17,62 @@ CREATE TABLE keys (
 	directory_id integer not null,
 	mod_user text,
 	mod_time text,
-	schema_name text,
 	value_type text,
 	value,
 	UNIQUE (name, directory_id)
 );

+CREATE TABLE keys_to_schema_name (
+	key_id integer primary key,
+	schema_name text
+);
+
 CREATE TABLE lists (
 	key_id integer,
 	list_idx integer,
+	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
+);
+
+CREATE TABLE schemas (
+	key_id integer primary key,
+	schema_type text,
+	scheam_list_type text,
+	schema_car_type text,
+	schema_cdr_type text,
+	locale text,
+	owner text,
+	short_desc text,
+	long_desc text,
+	default_value_id integer
+);
+
+CREATE TABLE schemas_keys (
+	id integer primary key,
+	name text,
+	directory_id integer not null,
 	value_type text,
+	value,
+	UNIQUE (name, directory_id)
+);
+
+CREATE TABLE schemas_lists (
+	key_id integer,
+	list_idx integer,
+	value_type text,
 	value,
 	UNIQUE (key_id, list_idx)
 );

-CREATE TABLE pairs (
+CREATE TABLE schemas_pairs (
 	key_id integer primary key,
 	car_value_type text,
 	car_value,