From e253334ddd45ea47bfd58288a481e5c99297ab48 Mon Sep 17 00:00:00 2001 From: Anthony Towns Date: Mon, 14 Jan 2008 03:58:13 +0000 Subject: [PATCH] add keyrings table to init_pool sql --- setup/init_pool.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/setup/init_pool.sql b/setup/init_pool.sql index 168d981a..e09cc986 100644 --- a/setup/init_pool.sql +++ b/setup/init_pool.sql @@ -34,10 +34,17 @@ CREATE TABLE uid ( name TEXT ); +CREATE TABLE keyrings ( + id SERIAL PRIMARY KEY, + name TEXT +); + + CREATE TABLE fingerprint ( id SERIAL PRIMARY KEY, fingerprint TEXT UNIQUE NOT NULL, - uid INT4 REFERENCES uid + uid INT4 REFERENCES uid, + keyring INT4 REFERENCES keyrings ); CREATE TABLE location ( -- 2.39.2