-- -- Stores the synonym cut down in portions of 3 characters -- to be used in search. -- CREATE TABLE category_synonym_index ( -- -- Id of the synonym refered to. -- synonym_id integer NOT NULL, -- -- 3 character part of the synonym. -- trigram char(3) NOT NULL, ON DELETE CASCADE, CONSTRAINT category_synonym_index_fk REFERENCES category_synonyms () ); CREATE INDEX category_syn_index_synonym_ix ON category_synonym_index (synonym_id); CREATE INDEX category_syn_index_trigram_ix ON category_synonym_index (trigram); CREATE TRIGGER RI_ConstraintTrigger_c_341164 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341165 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 90,112 bytes -- Table rows: 2,342
Begin main content
