From 8949336217af1e379472b236b721b4f2f79d8df5 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Tue, 6 Dec 2011 16:09:16 -0500 Subject: [PATCH] address alert : DB Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 3f8fb920f7..cdcee255ad 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -605,4 +605,18 @@ CREATE TABLE actor.usr_saved_search ( CONSTRAINT name_once_per_user UNIQUE (owner, name) ); +CREATE TABLE actor.address_alert ( + id SERIAL PRIMARY KEY, + owner INT NOT NULL REFERENCES actor.org_unit (id) DEFERRABLE INITIALLY DEFERRED, + match_all BOOL NOT NULL DEFAULT TRUE, + alert_message TEXT NOT NULL, + street1 TEXT, + street2 TEXT, + city TEXT, + county TEXT, + state TEXT, + country TEXT, + post_code TEXT, +); + COMMIT; -- 2.11.0