-- -- Stores the search text cut down in portions of 3 characters -- to be used in search. -- CREATE TABLE category_search_index ( -- -- Id of the search text refered to. -- query_id integer NOT NULL, -- -- 3 character part of the search text. -- trigram char(3) NOT NULL, ON DELETE CASCADE, CONSTRAINT category_search_index_fk REFERENCES category_search () ); CREATE INDEX category_search_ind_query_ix ON category_search_index (query_id); CREATE INDEX category_search_ind_trigram_ix ON category_search_index (trigram); CREATE TRIGGER RI_ConstraintTrigger_c_341154 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341155 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
