From 74dd882ac66d5404e7feeb3662375609d5b8d378 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 18 Apr 2012 13:11:38 -0400 Subject: [PATCH] search filter group : baseline schema Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 26 ++++++++++++++++---------- 1 file changed, 16 insertions(+), 10 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 229f6e368b..397ac2fdaa 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -680,23 +680,29 @@ CREATE TABLE actor.org_unit_custom_tree_node ( sibling_order INTEGER NOT NULL DEFAULT 0, CONSTRAINT aouctn_once_per_org UNIQUE (tree, org_unit) +CREATE TABLE actor.search_query ( + id SERIAL PRIMARY KEY, + label TEXT NOT NULL, -- i18n + query_text TEXT NOT NULL -- QP text +); + CREATE TABLE actor.search_filter_group ( id SERIAL PRIMARY KEY, - owner INT NOT NULL REFERENCES actor.org_unit (id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - code TEXT NOT NULL, -- use in templates / CGI params + owner INT NOT NULL REFERENCES actor.org_unit (id) + ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, label TEXT NOT NULL, -- i18n create_date TIMESTAMPTZ NOT NULL DEFAULT now(), - CONSTRAINT sf_code_once_per_org UNIQUE (owner, code), - CONSTRAINT sf_label_once_per_org UNIQUE (owner, label) + CONSTRAINT asfg_label_once_per_org UNIQUE (owner, label) ); CREATE TABLE actor.search_filter_group_entry ( - id SERIAL PRIMARY KEY, - grp INT NOT NULL REFERENCES actor.search_filter_group(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, - label TEXT NOT NULL, -- i18n - pos INT NOT NULL DEFAULT 0, - query_text TEXT NOT NULL, -- QP text - CONSTRAINT query_once_per_group UNIQUE (grp, query_text) + id SERIAL PRIMARY KEY, + grp INT NOT NULL REFERENCES actor.search_filter_group(id) + ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, + pos INT NOT NULL DEFAULT 0, + query INT NOT NULL REFERENCES actor.search_query(id) + ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED, + CONSTRAINT asfge_query_once_per_group UNIQUE (grp, query) ); COMMIT; -- 2.11.0