--
-- Templates are a special class of text objects that are used for specifying
-- the layout of a content item. They may be mapped to content types for
-- defaults, or may be mapped to individual content items.
--
CREATE TABLE cr_templates (
template_id integer PRIMARY KEY NOT NULL,
ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT cr_template_id_fk REFERENCES cr_items (),
CONSTRAINT cr_templates_pk REFERENCES cr_items ()
);
CREATE TRIGGER RI_ConstraintTrigger_a_341347 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341348 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341459 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341460 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341487 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341488 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to cr_templates:
--cr_item_template_map(cr_template_id_fk)
--cr_item_template_map(cr_templates_pk)
--cr_type_template_map(cr_template_id_fk)
--cr_type_template_map(cr_templates_pk)
-- Table size: 8,192 bytes
-- Table rows: 2
Tables: