-- -- Stores multilingual synonyms of the categories. -- CREATE TABLE category_synonyms ( -- -- Primary key. -- synonym_id integer PRIMARY KEY NOT NULL, -- -- Category the synonyms are refering to. -- category_id integer NOT NULL, -- -- Language of the synonym. -- locale varchar(5) NOT NULL, -- -- Actual synonym of the category in given language. -- name varchar(100) NOT NULL, -- -- Marks if the entry is a synonym to be edited by user or is a copy -- of a category translation and cannot be edited directly. -- synonym_p bool DEFAULT true, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_synonyms_cat_fk REFERENCES categories (), CONSTRAINT category_synonyms_locale_fk REFERENCES categories (), CONSTRAINT category_synonyms_pk REFERENCES categories () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_synonyms_pk REFERENCES ad_locales (), CONSTRAINT category_synonyms_cat_fk REFERENCES ad_locales (), CONSTRAINT category_synonyms_locale_fk REFERENCES ad_locales () ); CREATE INDEX category_synonyms_locale_ix ON category_synonyms (category_id, locale); CREATE INDEX category_synonyms_name_ix ON category_synonyms (category_id, name); CREATE TRIGGER RI_ConstraintTrigger_a_341147 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341148 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341162 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341163 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341169 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341170 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341174 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341175 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to category_synonyms: --category_search_results(category_synonyms_cat_fk) --category_search_results(category_synonyms_locale_fk) --category_search_results(category_synonyms_pk) --category_synonym_index(category_synonyms_cat_fk) --category_synonym_index(category_synonyms_locale_fk) --category_synonym_index(category_synonyms_pk) -- Table size: 16,384 bytes -- Table rows: 179
Begin main content
