--
-- Stores users multilingual search texts for category synonyms.
--
CREATE TABLE category_search (
--
-- Primary key.
--
query_id integer PRIMARY KEY NOT NULL,
--
-- Actual search text in given language.
--
search_text varchar(200) NOT NULL,
--
-- Language of the search text.
--
locale varchar(5) NOT NULL,
--
-- Counts how often this search text has been used by users.
--
queried_count integer DEFAULT 1 NOT NULL,
--
-- Date of last usage of this search text.
-- A sweeper will delete search texts not used for a while.
--
last_queried timestamptz DEFAULT ('now'::text)::timestamp(6) with time zone NOT NULL,
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT category_search_id_pk REFERENCES ad_locales (),
CONSTRAINT category_search_query_un REFERENCES ad_locales (),
CONSTRAINT category_search_locale_fk REFERENCES ad_locales ()
);
CREATE INDEX category_search_date_ix ON category_search (last_queried);
CREATE UNIQUE INDEX category_search_query_un ON category_search (search_text, locale);
CREATE TRIGGER RI_ConstraintTrigger_a_341142 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341143 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341152 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341153 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341159 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341160 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Tables with foreign keys that refer to category_search:
--category_search_index(category_search_id_pk)
--category_search_index(category_search_locale_fk)
--category_search_index(category_search_query_un)
--category_search_results(category_search_id_pk)
--category_search_results(category_search_locale_fk)
--category_search_results(category_search_query_un)
-- Table size: 0 bytes
-- Table rows: 0
Begin main content
