From 488ebf5104018eb86e4e33ab3178421f8df3afb8 Mon Sep 17 00:00:00 2001 From: Jonathan McDowell Date: Mon, 31 May 2004 23:47:16 +0000 Subject: [PATCH] cscvs to tla changeset 42 Author: noodles Date: 2002/11/22 11:45:15 Tighten up SQL referencial integrity. --- onak.sql | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/onak.sql b/onak.sql index 9fc033c..3d68910 100644 --- a/onak.sql +++ b/onak.sql @@ -4,17 +4,21 @@ DROP TABLE onak_sigs; CREATE TABLE onak_keys ( keyid char(16) NOT NULL, - keydata oid NOT NULL + keydata oid NOT NULL, + PRIMARY KEY (keyid) ); CREATE INDEX onak_keys_keyid_index ON onak_keys(keyid); CREATE TABLE onak_uids ( keyid char(16) NOT NULL, uid varchar(6000) NOT NULL, - pri boolean + pri boolean, + FOREIGN KEY (keyid) REFERENCES onak_keys ); CREATE TABLE onak_sigs ( signer char(16) NOT NULL, - signee char(16) NOT NULL + signee char(16) NOT NULL, + FOREIGN KEY (signee) REFERENCES onak_keys ); +CREATE INDEX onak_sigs_signee_index ON onak_sigs(signee); -- 2.30.2