insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('be_id_list', 'Y', null);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('pv_overview', 'Y', 4000);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('pv_description', 'Y', 2000);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('FRpath', 'Y', 2000);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('FRlabel', 'Y', 60);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('rtag_name', 'Y', 4000);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('rtag_description', 'N', 4000);
insert into validation_rules (FIELD_NAME, IS_REQUIRED, MAX_STRING_LENGTH) values
('config_spec_branch', 'N', 4000);

insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(1, 'depend_add', 'Dependency Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(2, 'depend_update', 'Dependency Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(3, 'depend_remove', 'Dependency Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(4, 'new_version', 'New Version Created');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(5, 'delete', 'Deleted from Project');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(6, 'add', 'Added to Project');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(7, 'copy', 'Copied into Project');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(8, 'rename', 'Package Version Renamed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(9, 'note_add', 'NoteManager Note Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(10, 'note_remove', 'NoteManager Note Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(11, 'patch_add', 'Patch Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(12, 'patch_remove', 'Patch Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(13, 'reason_for_release', 'Reason for Release Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(14, 'ignore_on', 'Ignore Latest Dependency Version');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(15, 'ignore_off', 'Unignore Latest Dependency Version');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(16, 'makeofficial', 'Package Released');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(17, 'makeunofficial', 'Package UnReleased');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(18, 'ignore_reset', 'Ignore Latest Dependency Version Cancelled');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(19, 'document_add', 'Document Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(20, 'document_remove', 'Document Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(21, 'owner_change', 'Package Owner Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(22, 'runtime_add', 'Run-time Dependency Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(23, 'runtime_remove', 'Run-time Dependency Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(24, 'issue_add', 'ClearQuest Issue Added');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(25, 'issue_fixed', 'ClearQuest Issue Set to Fixed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(26, 'issue_outstanding', 'ClearQuest Issue Set to Outstanding');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(27, 'issue_removed', 'ClearQuest Issue Removed');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(28, 'previous_version_change', 'Package Previous Version Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(29, 'replaced_with', 'Replaced With Other Version');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(30, 'clone_from', 'Package Details Cloned');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(31, 'note_edit', 'NoteManager Note Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(32, 'depend_import', 'Dependencies Imported');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(33, 'document_update', 'Document Updated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(34, 'work_in_progress', 'Work In Progress');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(35, 'delete_from_wip', 'Deleted from Work-In-Progress Area');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(36, 'add_to_planned', 'Added to Pending area');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(37, 'delete_from_released', 'Deleted from Released Area');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(38, 'approve_package', 'Package Approved for Automated Build');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(39, 'deleted_from_pending', 'Deleted from Pending Area');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(40, 'reject_package', 'Package Rejected for Automated Build');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(41, 'change_type_update', 'Change Type Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(42, 'lock_package', 'Administrator - Lock Package');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(43, 'unlock_package', 'Administrator - Unlock Package');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(44, 'new_release', 'New Release Created');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(45, 'set_to_open_mode', 'Release is set to Open Mode');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(46, 'set_to_restrictive_mode', 'Release is set to Restrictive Mode');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(47, 'set_to_closed_mode', 'Release is set to Closed Mode');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(48, 'import_release_contents', 'Import Release Contents');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(49, 'update_release', 'Update Release Details');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(50, 'destroy_release', 'Destroy Release');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(51, 'merge_release', 'Merge Release');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(52, 'patch_obsolete', 'Change Obsolete State');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(53, 'action', null);
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(54, 'link_to_reason_for_release', 'A link to the reason for release of the package');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(55, 'jira_issue_removed', 'JIRA Issue Removed.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(56, 'jira_issue_added', 'Added Jira Issue');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(57, 'set_to_ccb_mode', 'Release is set to CCB Mode');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(58, 'unripple_package', 'Marked for build exclusion/Failed to build');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(59, 'ripple_package', 'Marked for build inclusion');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(60, 'deprecate_package', 'Package requires to be deprecated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(61, 'undeprecate_package', 'Package requires to be undeprecated');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(62, 'add_view_owners', 'Base View owners for the Project Added.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(63, 'remove_view_owners', 'Base View owners for the Project Removed.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(64, 'process_add', 'Added process to the package version');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(65, 'process_remove', 'Removed process from the package version');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(66, 'move_package_version', 'Moved package version from closed release.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(67, 'set_to_archive_mode', 'Release is set to Archive Mode.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(68, 'build_standard_update', 'Build Standard Update.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(69, 'reproducible_package', 'Package Version can be reproduced by the autobuild tool.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(70, 'unreproducible_package', 'Package Version cannot be reproduced by the autobuild tool.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(71, 'modify_product_state', 'Modified the state of the product.');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(72, 'sbom_priority_update', 'SBOM Priority Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(73, 'ripple_type_update', 'Ripple Type Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(74, 'set_advisory_ripple', 'Package set to Advisory Ripple');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(75, 'clear_advisory_ripple', 'Package clear from Advisory Ripple');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(76, 'major_limit_update', 'Major Limit Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(77, 'minor_limit_update', 'Minor Limit Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(78, 'patch_limit_update', 'Patch Limit Update');
insert into action_type (ACTTYPE_ID, NAME, DESCRIPTION) values
(79, 'build_number_limit_update', 'Build Number Limit Update');
