--
-- Extlinks are pointers to items anywhere on the web which the publisher wishes
-- to categorize, index and relate to items in the content repository.
--
CREATE TABLE cr_extlinks (
extlink_id integer PRIMARY KEY NOT NULL,
url varchar(1000) NOT NULL,
label varchar(1000) NOT NULL,
description text(-5),
ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT cr_extlink_id_fk REFERENCES cr_items (),
CONSTRAINT cr_extlinks_pk REFERENCES cr_items ()
);
CREATE TRIGGER RI_ConstraintTrigger_c_341249 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341250 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 188,416 bytes
-- Table rows: 547
Tables: