From 83dbf81380cb161c30c8a5874d7499c68c0606ac Mon Sep 17 00:00:00 2001 From: erickson Date: Mon, 22 Dec 2008 18:29:46 +0000 Subject: [PATCH] added "replaces" column for indicating a change pending on an existing address git-svn-id: svn://svn.open-ils.org/ILS/trunk@11646 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 1108879b58..6f014757ff 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -455,7 +455,8 @@ CREATE TABLE actor.usr_address ( county TEXT, state TEXT NOT NULL, country TEXT NOT NULL, - post_code TEXT NOT NULL + post_code TEXT NOT NULL, + replaces INT REFERENCES actor.usr_address (id) DEFERRABLE INITIALLY DEFERRED ); CREATE INDEX actor_usr_addr_usr_idx ON actor.usr_address (usr); -- 2.43.2