-- -- This table holds additional knowledge level attributes for the -- apm_package type and its subtypes. -- CREATE TABLE apm_package_types ( -- -- The package_key is what we call the package on this system. -- package_key varchar(100) PRIMARY KEY NOT NULL, pretty_name varchar(100) NOT NULL, pretty_plural varchar(100), -- -- The package URI indicates where the package can be downloaded and -- is a unique identifier for the package. -- package_uri varchar(1500) NOT NULL, package_type varchar(300), -- -- The path to the package specification file. -- spec_file_path varchar(1500), -- -- The last time a spec file was modified. This information is maintained in the -- database so that if a user changes the specification file by editing the file -- (as opposed to using the UI, the system can read the .info file and update -- the information in the database appropriately. -- spec_file_mtime integer, -- -- Indicates if the package should be installed during initial installation, -- in other words whether or not this package is part of the OpenACS core. -- initial_install_p bool DEFAULT false NOT NULL, -- -- Indicates if the package can be used for subsites. If this is set to -- 't', the package can be enabled for any subsite. Otherwise, it is -- restricted to the acs-admin/ subsite. -- singleton_p bool DEFAULT false NOT NULL, implements_subsite_p bool DEFAULT false, inherit_templates_p bool DEFAULT true ); CREATE UNIQUE INDEX apm_package_types_pretty_n_un ON apm_package_types (pretty_name); CREATE UNIQUE INDEX apm_package_types_pretty_pl_un ON apm_package_types (pretty_plural); CREATE UNIQUE INDEX apm_packages_types_p_uri_un ON apm_package_types (package_uri); CREATE TRIGGER RI_ConstraintTrigger_a_340657 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340658 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340702 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340703 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340712 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340713 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342547 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342548 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343612 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_343613 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to apm_package_types: --apm_package_versions(apm_package_types_p_key_pk) --apm_package_versions(apm_packages_pack_type_ck) --apm_packages(apm_package_types_p_key_pk) --apm_packages(apm_packages_pack_type_ck) --apm_parameters(apm_package_types_p_key_pk) --apm_parameters(apm_packages_pack_type_ck) --lang_message_keys(apm_package_types_p_key_pk) --lang_message_keys(apm_packages_pack_type_ck) --workflows(apm_package_types_p_key_pk) --workflows(apm_packages_pack_type_ck) -- Table size: 16,384 bytes -- Table rows: 73
Begin main content
