From 6a5e2cd5072f2f45ab4526be31ac049eed6bee81 Mon Sep 17 00:00:00 2001 From: James Troup Date: Tue, 11 Feb 2003 18:09:44 +0000 Subject: [PATCH] Add UID table --- init_pool.sql | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/init_pool.sql b/init_pool.sql index 51ac90e9..093e0291 100644 --- a/init_pool.sql +++ b/init_pool.sql @@ -28,9 +28,15 @@ CREATE TABLE maintainer ( name TEXT UNIQUE NOT NULL ); +CREATE TABLE uid ( + id SERIAL PRIMARY KEY, + uid TEXT UNIQUE NOT NULL +); + CREATE TABLE fingerprint ( id SERIAL PRIMARY KEY, - fingerprint TEXT UNIQUE NOT NULL + fingerprint TEXT UNIQUE NOT NULL, + uid INT4 REFERENCES uid ); CREATE TABLE location ( -- 2.39.2