-- -- Translations for names and descriptions of categories in different languages. -- CREATE TABLE category_translations ( -- -- ID of a category (see categories). -- category_id integer NOT NULL, -- -- ACS-Lang style locale if language ad country. -- locale varchar(5) NOT NULL, -- -- Name of the category in the specified language. -- name varchar(200), -- -- Description of the category in the specified language. -- description varchar(4000), PRIMARY KEY (category_id,locale), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cat_trans_category_id_fk REFERENCES categories (), CONSTRAINT cat_trans_locale_fk REFERENCES categories (), CONSTRAINT category_translations_pkey REFERENCES categories (), CONSTRAINT category_translations_pkey REFERENCES ad_locales (), CONSTRAINT cat_trans_category_id_fk REFERENCES ad_locales (), CONSTRAINT cat_trans_locale_fk REFERENCES ad_locales () ); CREATE TRIGGER category_synonym__insert_cat_trans_trg AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE category_synonym__new_cat_trans_trg (disabled) CREATE TRIGGER category_synonym__update_cat_trans_trg BEFORE UPDATE FOR EACH ROW EXECUTE PROCEDURE category_synonym__edit_cat_trans_trg (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341089 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341090 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341094 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341095 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 16,384 bytes -- Table rows: 179
Begin main content
