-- -- Symlinks are pointers to items within the content repository. -- CREATE TABLE cr_symlinks ( symlink_id integer PRIMARY KEY NOT NULL, target_id integer NOT NULL, label varchar(1000), ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_symlink_id_fk REFERENCES cr_items (), CONSTRAINT cr_symlinks_pk REFERENCES cr_items (), CONSTRAINT cr_symlinks_target_id_fk REFERENCES cr_items () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT cr_symlinks_target_id_fk REFERENCES cr_items (), CONSTRAINT cr_symlink_id_fk REFERENCES cr_items (), CONSTRAINT cr_symlinks_pk REFERENCES cr_items () ); CREATE INDEX cr_symlinks_by_target_id ON cr_symlinks (target_id); CREATE TRIGGER RI_ConstraintTrigger_c_341444 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341445 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341454 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341455 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 24,576 bytes -- Table rows: 553
Begin main content
