3 INSERT INTO config.upgrade_log (version) VALUES ('0351'); -- Scott McKellar
5 CREATE TABLE actor.usr_saved_search (
7 owner INT NOT NULL REFERENCES actor.usr (id)
9 DEFERRABLE INITIALLY DEFERRED,
11 create_date TIMESTAMPTZ NOT NULL DEFAULT now(),
12 query_text TEXT NOT NULL,
13 query_type TEXT NOT NULL
14 CONSTRAINT valid_query_text CHECK (
15 query_type IN ( 'URL' )) DEFAULT 'URL',
16 -- we may add other types someday
18 CONSTRAINT valid_target CHECK (
19 target IN ( 'record', 'metarecord', 'callnumber' )),
20 CONSTRAINT name_once_per_user UNIQUE (owner, name)