From 28443931678840bc3dea22c8b4563e5dad01dab4 Mon Sep 17 00:00:00 2001 From: scottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4> Date: Mon, 26 Jul 2010 16:18:09 +0000 Subject: [PATCH] New table: actor.usr_saved_search M Open-ILS/src/sql/Pg/005.schema.actors.sql M Open-ILS/src/sql/Pg/002.schema.config.sql A Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql M Open-ILS/examples/fm_IDL.xml git-svn-id: svn://svn.open-ils.org/ILS/trunk@17034 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/fm_IDL.xml | 18 +++++++++++++++++ Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- Open-ILS/src/sql/Pg/005.schema.actors.sql | 18 +++++++++++++++++ .../Pg/upgrade/0351.schema.usr_saved_search.sql | 23 ++++++++++++++++++++++ 4 files changed, 60 insertions(+), 1 deletion(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index 32c824229c..00d2ca5c6b 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -2385,6 +2385,24 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA <link field="replaces" reltype="has_a" key="id" map="" class="aua"/> </links> </class> + + <class id="auss" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="actor::usr_saved_search" oils_persist:tablename="actor.usr_saved_search" reporter:label="User Saved Search"> + <fields oils_persist:primary="id" oils_persist:sequence="usr_saved_search_id_seq"> + <field reporter:label="ID" name="id" reporter:datatype="id"/> + <field reporter:label="Owner" name="owner" reporter:datatype="link"/> + <field reporter:label="Name" name="name" reporter:datatype="text"/> + <field reporter:label="Create Date" name="create_date" reporter:datatype="timestamp"/> + <field reporter:label="Query Text" name="query_text" reporter:datatype="text"/> + <field reporter:label="Query Type" name="query_type" reporter:datatype="text"/> + <field reporter:label="Target" name="target" reporter:datatype="text"/> + </fields> + <links> + <link field="owner" reltype="has_a" key="id" map="" class="au"/> + </links> + <permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1"> + </permacrud> + </class> + <class id="acnn" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="asset::call_number_note" oils_persist:tablename="asset.call_number_note" reporter:label="Call Number Note"> <fields oils_persist:primary="id" oils_persist:sequence="asset.call_number_note_id_seq"> <field name="call_number" /> diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 64539f0a3f..d656461344 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -68,7 +68,7 @@ CREATE TABLE config.upgrade_log ( install_date TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW() ); -INSERT INTO config.upgrade_log (version) VALUES ('0350'); -- Scott McKellar +INSERT INTO config.upgrade_log (version) VALUES ('0351'); -- Scott McKellar CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index f65ca48b2e..91d4eee18c 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -608,4 +608,22 @@ CREATE INDEX actor_usr_standing_penalty_usr_idx ON actor.usr_standing_penalty (u CREATE INDEX actor_usr_standing_penalty_staff_idx ON actor.usr_standing_penalty ( staff ); +CREATE TABLE actor.usr_saved_search ( + id SERIAL PRIMARY KEY, + owner INT NOT NULL REFERENCES actor.usr (id) + ON DELETE CASCADE + DEFERRABLE INITIALLY DEFERRED, + name TEXT NOT NULL, + create_date TIMESTAMPTZ NOT NULL DEFAULT now(), + query_text TEXT NOT NULL, + query_type TEXT NOT NULL + CONSTRAINT valid_query_text CHECK ( + query_type IN ( 'URL' )) DEFAULT 'URL', + -- we may add other types someday + target TEXT NOT NULL + CONSTRAINT valid_target CHECK ( + target IN ( 'record', 'metarecord', 'callnumber' )), + CONSTRAINT name_once_per_user UNIQUE (owner, name) +); + COMMIT; diff --git a/Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql b/Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql new file mode 100644 index 0000000000..e0842df39d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/0351.schema.usr_saved_search.sql @@ -0,0 +1,23 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version) VALUES ('0351'); -- Scott McKellar + +CREATE TABLE actor.usr_saved_search ( + id SERIAL PRIMARY KEY, + owner INT NOT NULL REFERENCES actor.usr (id) + ON DELETE CASCADE + DEFERRABLE INITIALLY DEFERRED, + name TEXT NOT NULL, + create_date TIMESTAMPTZ NOT NULL DEFAULT now(), + query_text TEXT NOT NULL, + query_type TEXT NOT NULL + CONSTRAINT valid_query_text CHECK ( + query_type IN ( 'URL' )) DEFAULT 'URL', + -- we may add other types someday + target TEXT NOT NULL + CONSTRAINT valid_target CHECK ( + target IN ( 'record', 'metarecord', 'callnumber' )), + CONSTRAINT name_once_per_user UNIQUE (owner, name) +); + +COMMIT; -- 2.11.0