--
-- This table maintains the list of all package instances in the sytem.
--
CREATE TABLE apm_packages (
package_id integer PRIMARY KEY NOT NULL,
package_key varchar(100),
--
-- This column enables a name to associated with each instance of package. This enables the storage
-- of a human-readable distinction between different package instances. This is useful
-- if a site admin wishes to name an instance of an application, e.g. bboard, for a subsite. The admin
-- might create one instance, "Boston Public Bboard" for managing public forums for the Boston subsite,
-- and "Boston Private Bboard" for managing private forums for the Boston subsite.
--
instance_name varchar(300) NOT NULL,
default_locale varchar(30),
CONSTRAINT apm_packages_pack_id_pk REFERENCES acs_objects (),
CONSTRAINT apm_packages_package_id_fk REFERENCES acs_objects (),
CONSTRAINT apm_packages_package_key_fk REFERENCES acs_objects (),
CONSTRAINT apm_packages_package_key_fk REFERENCES apm_package_types (),
CONSTRAINT apm_packages_pack_id_pk REFERENCES apm_package_types (),
CONSTRAINT apm_packages_package_id_fk REFERENCES apm_package_types ()
);
CREATE INDEX apm_packages_package_key_idx ON apm_packages (package_key);
CREATE TRIGGER RI_ConstraintTrigger_a_340377 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340378 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340432 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340433 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340467 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340468 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340632 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340633 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340662 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340663 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340709 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340710 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340714 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_340715 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340727 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340728 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340737 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340738 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340762 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340763 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340972 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340973 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341062 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341063 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341257 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341258 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342427 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342428 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342582 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342583 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342767 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342768 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342782 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342783 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342827 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342828 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342832 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342833 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342912 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342913 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342967 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342968 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343102 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343103 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343107 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343108 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343112 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343113 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343117 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343118 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343707 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343708 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322762 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1322763 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to apm_packages:
--acs_mail_lite_queue(apm_packages_pack_id_pk)
--acs_mail_lite_queue(apm_packages_package_id_fk)
--acs_mail_lite_queue(apm_packages_package_key_fk)
--acs_mail_lite_send_msg_id_map(apm_packages_pack_id_pk)
--acs_mail_lite_send_msg_id_map(apm_packages_package_id_fk)
--acs_mail_lite_send_msg_id_map(apm_packages_package_key_fk)
--acs_named_objects(apm_packages_pack_id_pk)
--acs_named_objects(apm_packages_package_id_fk)
--acs_named_objects(apm_packages_package_key_fk)
--acs_objects(apm_packages_pack_id_pk)
--acs_objects(apm_packages_package_id_fk)
--acs_objects(apm_packages_package_key_fk)
--ad_locale_user_prefs(apm_packages_pack_id_pk)
--ad_locale_user_prefs(apm_packages_package_id_fk)
--ad_locale_user_prefs(apm_packages_package_key_fk)
--apm_applications(apm_packages_pack_id_pk)
--apm_applications(apm_packages_package_id_fk)
--apm_applications(apm_packages_package_key_fk)
--apm_parameter_values(apm_packages_pack_id_pk)
--apm_parameter_values(apm_packages_package_id_fk)
--apm_parameter_values(apm_packages_package_key_fk)
--apm_services(apm_packages_pack_id_pk)
--apm_services(apm_packages_package_id_fk)
--apm_services(apm_packages_package_key_fk)
--application_groups(apm_packages_pack_id_pk)
--application_groups(apm_packages_package_id_fk)
--application_groups(apm_packages_package_key_fk)
--attachments_fs_root_folder_map(apm_packages_pack_id_pk)
--attachments_fs_root_folder_map(apm_packages_package_id_fk)
--attachments_fs_root_folder_map(apm_packages_package_key_fk)
--bt_projects(apm_packages_pack_id_pk)
--bt_projects(apm_packages_package_id_fk)
--bt_projects(apm_packages_package_key_fk)
--calendars(apm_packages_pack_id_pk)
--calendars(apm_packages_package_id_fk)
--calendars(apm_packages_package_key_fk)
--cr_folders(apm_packages_pack_id_pk)
--cr_folders(apm_packages_package_id_fk)
--cr_folders(apm_packages_package_key_fk)
--fs_root_folders(apm_packages_pack_id_pk)
--fs_root_folders(apm_packages_package_id_fk)
--fs_root_folders(apm_packages_package_key_fk)
--pa_package_root_folder_map(apm_packages_pack_id_pk)
--pa_package_root_folder_map(apm_packages_package_id_fk)
--pa_package_root_folder_map(apm_packages_package_key_fk)
--pages(apm_packages_pack_id_pk)
--pages(apm_packages_package_id_fk)
--pages(apm_packages_package_key_fk)
--pinds_blog_categories(apm_packages_pack_id_pk)
--pinds_blog_categories(apm_packages_package_id_fk)
--pinds_blog_categories(apm_packages_package_key_fk)
--pinds_blog_entries(apm_packages_pack_id_pk)
--pinds_blog_entries(apm_packages_package_id_fk)
--pinds_blog_entries(apm_packages_package_key_fk)
--sp_folders(apm_packages_pack_id_pk)
--sp_folders(apm_packages_package_id_fk)
--sp_folders(apm_packages_package_key_fk)
--weblogger_blogroll_entries(apm_packages_pack_id_pk)
--weblogger_blogroll_entries(apm_packages_package_id_fk)
--weblogger_blogroll_entries(apm_packages_package_key_fk)
--weblogger_channels(apm_packages_pack_id_pk)
--weblogger_channels(apm_packages_package_id_fk)
--weblogger_channels(apm_packages_package_key_fk)
--weblogger_ping_urls(apm_packages_pack_id_pk)
--weblogger_ping_urls(apm_packages_package_id_fk)
--weblogger_ping_urls(apm_packages_package_key_fk)
--weblogger_technorati_cache(apm_packages_pack_id_pk)
--weblogger_technorati_cache(apm_packages_package_id_fk)
--weblogger_technorati_cache(apm_packages_package_key_fk)
--xooauth_packages(apm_packages_pack_id_pk)
--xooauth_packages(apm_packages_package_id_fk)
--xooauth_packages(apm_packages_package_key_fk)
--xowiki_package(apm_packages_pack_id_pk)
--xowiki_package(apm_packages_package_id_fk)
--xowiki_package(apm_packages_package_key_fk)
-- Table size: 16,384 bytes
-- Table rows: 249
Tables: