-- -- Translations for names and descriptions of trees in different languages. -- CREATE TABLE category_tree_translations ( -- -- ID of a tree (see category_trees). -- tree_id integer NOT NULL, -- -- ACS-Lang style locale if language ad country. -- locale varchar(5) NOT NULL, -- -- Name of the tree in the specified language. -- name varchar(50) NOT NULL, -- -- Description of the tree in the specified language. -- description varchar(1000), PRIMARY KEY (tree_id,locale), CONSTRAINT cat_tree_trans_locale_fk REFERENCES ad_locales (), CONSTRAINT cat_tree_trans_tree_id_fk REFERENCES ad_locales (), CONSTRAINT category_tree_translations_pkey REFERENCES ad_locales () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT category_tree_translations_pkey REFERENCES category_trees (), CONSTRAINT cat_tree_trans_locale_fk REFERENCES category_trees (), CONSTRAINT cat_tree_trans_tree_id_fk REFERENCES category_trees () ); CREATE TRIGGER RI_ConstraintTrigger_c_341119 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341120 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341124 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341125 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 8,192 bytes -- Table rows: 4
Begin main content
