The unified diff between revisions [65f52f37..] and [36cf2167..] 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 [1a59f2ab0d1a31dc4596d27c1bb5c4909ce142c8]
#    to [d2b63fc6563a0cb09ce7d56c1edeb4919295f2a0]
#
============================================================
--- init.sql	1a59f2ab0d1a31dc4596d27c1bb5c4909ce142c8
+++ init.sql	d2b63fc6563a0cb09ce7d56c1edeb4919295f2a0
@@ -11,7 +11,7 @@ CREATE TABLE directories (
 	UNIQUE (name, parent_id)
 );

-CREATE TABLE entries (
+CREATE TABLE keys (
 	id integer primary key,
 	name text,
 	directory_id integer not null,
@@ -24,9 +24,18 @@ CREATE TABLE lists (
 );

 CREATE TABLE lists (
-	list_id integer,
+	key_id integer,
 	list_idx integer,
 	value_type text,
-	value blob
+	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
+);
+