-- -- Applications can register callbacks that are triggered -- whenever a group of a specified type is created. The callback -- must expect the following arguments: -- * object_id: The object that just got created -- * node_id: The node_id where the object got created -- * package_id: The package_id from where the object got created -- These are passed in the following way: -- * tcl procedure: Using named parameters (e.g. -object_id $object_id) -- All callbacks must accept all of these parameters. -- CREATE TABLE subsite_callbacks ( callback_id integer PRIMARY KEY NOT NULL, -- -- The type of event we are monitoring. The keywords here are used -- by the applications to determine which callbacks to trigger. -- event_type varchar(100) NOT NULL, -- -- The object type to monitor. Whenever an object of this type is -- created, the subsite package will check for a registered -- callbacks. -- object_type varchar(1000) NOT NULL, -- -- The actual callback. This can be the name of a plsql function -- or procedure, a url stub relative to the node at which package -- id is mounted, or the name of a tcl function. -- callback varchar(300) NOT NULL, -- -- The type of the callback. This determines how the callback is -- executed. Currenlty only a tcl type is supported but other -- types may be added in the future. -- callback_type varchar(100) NOT NULL, -- -- The order in which the callbacks should fire. This is -- important when you need to ensure that one event fires before -- another (e.g. you must mount a portals application before the -- bboard application) -- sort_order integer DEFAULT 1 NOT NULL, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT sgc_callback_id_pk REFERENCES acs_object_types (), CONSTRAINT sgc_sort_order_ck REFERENCES acs_object_types (), CONSTRAINT sgc_object_type_fk REFERENCES acs_object_types (), CONSTRAINT sgc_event_type_ck REFERENCES acs_object_types (), CONSTRAINT sgc_callback_type_ck REFERENCES acs_object_types () ); CREATE UNIQUE INDEX subsite_callbacks_un ON subsite_callbacks (object_type, event_type, callback_type, callback); CREATE TRIGGER RI_ConstraintTrigger_c_1610641 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610642 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
