I generated an initial list of columns that were converted to bigint,
integer and float from NUMERIC that ora2pg spit out a while ago.... I
have attached the file.. It uses the space separated format
TableName ColumnName DataType
for example:
db_change_script_expanded line_no bigint
rhnaction id bigint
AFAIK its only problem is the non use of small-int... It should serve as
a comprehensive beginning list :)...
Partha
Gurjeet Singh wrote:
Hi All,
Porting Oracle's NUMBER datatype to Postgres' numeric datatype might
seem very straight-forward. But the NUMERIC datatype is known to have a huge
performance impact on the query run-times.
So we have decided to convert the number columns to
SMALLINT/INTEGER/BIGINT wherever possible. In the last conference call, Jeff
opined that we first target those columns for migration which are NUMBERs
and are part of PRIMARY KEY, as this will help us in migrating the FOREIGN
KEY columns pointing to these PKey columns; and these two categories of
columns will cover most NUMBER columns that might affect the performance.
Please find attached the list of primary key columns of datatype NUMBER,
their table names, precision and scale (under the columns "P,S"), the names
of the PRIMARY KEY constraints.
What we are looking for from the developers is that they should comment
about the possible MAX_VAL for these columns. For example, Devan pointed out
the other day that in the application there are only around 50 action types,
which limits the number of values of "rhnActionType"."id" column to no more
than 50 values. Now equipped with this knowledge, this column can be easily
converted to SMALLINT; also, other columns referencing this column can also
be converted to SMALLINT.
So please come forward and comment on what would be the best data type
for the columns listed in the attached file. We need this.
Thanks and best regards,
------------------------------------------------------------------------
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
db_change_history seq_no bigint
db_change_history bug_id bigint
db_change_history elapsed_seconds bigint
db_change_history_output seq_no bigint
db_change_history_output line_no bigint
db_change_history_output bug_id bigint
db_change_ignore_errs seq_no bigint
db_change_ignore_errs bug_id bigint
db_change_ignore_errs err_no bigint
db_change_lock seq_no bigint
db_change_lock bug_id bigint
db_change_resources seq_no bigint
db_change_resources bug_id bigint
db_change_script seq_no bigint
db_change_script bug_id bigint
db_change_script_expanded seq_no bigint
db_change_script_expanded bug_id bigint
db_change_script_expanded line_no bigint
db_change_script_parsed bug_id bigint
db_change_script_parsed line_no bigint
db_change_script_parsed stmt_no bigint
db_change_script_parsed seq_no bigint
db_change_script_source bug_id bigint
db_change_script_source line_no bigint
db_change_script_source seq_no bigint
demo_log server_id bigint
demo_log org_id bigint
foo foo bigint
pxtsessions expires bigint
pxtsessions web_user_id bigint
pxtsessions id bigint
rhn_check_probe host_id bigint
rhn_check_probe sat_cluster_id bigint
rhn_check_probe probe_id bigint
rhn_check_suite_probe check_suite_id bigint
rhn_check_suite_probe probe_id bigint
rhn_check_suites recid bigint
rhn_check_suites customer_id bigint
rhn_command recid bigint
rhn_command_param_threshold command_id bigint
rhn_command_parameter max_value bigint
rhn_command_parameter min_value bigint
rhn_command_parameter command_id bigint
rhn_command_parameter field_maximum_length integer
rhn_command_parameter field_visible_length integer
rhn_command_parameter field_order integer
rhn_command_queue_commands recid bigint
rhn_command_queue_execs instance_id bigint
rhn_command_queue_execs netsaint_id bigint
rhn_command_queue_execs execution_time integer
rhn_command_queue_execs exit_status integer
rhn_command_queue_execs_bk netsaint_id bigint
rhn_command_queue_execs_bk instance_id bigint
rhn_command_queue_execs_bk execution_time integer
rhn_command_queue_execs_bk exit_status integer
rhn_command_queue_instances recid bigint
rhn_command_queue_instances command_id bigint
rhn_command_queue_instances timeout integer
rhn_command_queue_instances_bk recid bigint
rhn_command_queue_instances_bk command_id bigint
rhn_command_queue_instances_bk timeout integer
rhn_command_queue_params instance_id bigint
rhn_command_queue_sessions contact_id bigint
rhn_command_target recid bigint
rhn_command_target customer_id bigint
rhn_contact_group_members order_number bigint
rhn_contact_group_members member_contact_method_id bigint
rhn_contact_group_members member_contact_group_id bigint
rhn_contact_group_members contact_group_id bigint
rhn_contact_groups customer_id bigint
rhn_contact_groups recid bigint
rhn_contact_groups strategy_id bigint
rhn_contact_groups notification_format_id bigint
rhn_contact_methods recid bigint
rhn_contact_methods schedule_id bigint
rhn_contact_methods sender_sat_cluster_id bigint
rhn_contact_methods method_type_id bigint
rhn_contact_methods pager_type_id bigint
rhn_contact_methods notification_format_id bigint
rhn_contact_methods contact_id bigint
rhn_contact_methods pager_max_message_length integer
rhn_contact_methods snmp_port integer
rhn_current_alerts current_server bigint
rhn_current_alerts netsaint_id bigint
rhn_current_alerts customer_id bigint
rhn_current_alerts service_probe_id bigint
rhn_current_alerts recid bigint
rhn_current_alerts host_probe_id bigint
rhn_current_alerts original_server bigint
rhn_current_state_summaries customer_id bigint
rhn_current_state_summaries state_count integer
rhn_deployed_probe os_id bigint
rhn_deployed_probe contact_group_id bigint
rhn_deployed_probe command_id bigint
rhn_deployed_probe customer_id bigint
rhn_deployed_probe check_interval_minutes bigint
rhn_deployed_probe sat_cluster_id bigint
rhn_deployed_probe retry_interval_minutes bigint
rhn_deployed_probe parent_probe_id bigint
rhn_deployed_probe max_attempts bigint
rhn_deployed_probe recid bigint
rhn_deployed_probe notification_interval_minutes bigint
rhn_host_check_suites suite_id bigint
rhn_host_check_suites host_probe_id bigint
rhn_host_probe sat_cluster_id bigint
rhn_host_probe probe_id bigint
rhn_host_probe host_id bigint
rhn_interface_monitoring server_id bigint
rhn_ll_netsaint netsaint_id bigint
rhn_method_types recid bigint
rhn_method_types notification_format_id bigint
rhn_multi_scout_threshold scout_critical_threshold bigint
rhn_multi_scout_threshold probe_id bigint
rhn_multi_scout_threshold scout_warning_threshold bigint
rhn_notification_formats max_subject_length bigint
rhn_notification_formats max_body_length bigint
rhn_notification_formats customer_id bigint
rhn_notification_formats recid bigint
rhn_notifservers recid bigint
rhn_os recid bigint
rhn_os_commands_xref os_id bigint
rhn_os_commands_xref commands_id bigint
rhn_pager_types recid bigint
rhn_physical_location customer_id bigint
rhn_physical_location recid bigint
rhn_probe retry_interval_minutes bigint
rhn_probe recid bigint
rhn_probe customer_id bigint
rhn_probe command_id bigint
rhn_probe contact_group_id bigint
rhn_probe notification_interval_minutes bigint
rhn_probe check_interval_minutes bigint
rhn_probe max_attempts bigint
rhn_probe_param_value probe_id bigint
rhn_probe_param_value command_id bigint
rhn_probe_state probe_id bigint
rhn_probe_state scout_id bigint
rhn_redirect_criteria recid bigint
rhn_redirect_criteria redirect_id bigint
rhn_redirect_email_targets redirect_id bigint
rhn_redirect_group_targets redirect_id bigint
rhn_redirect_group_targets contact_group_id bigint
rhn_redirect_method_targets contact_method_id bigint
rhn_redirect_method_targets redirect_id bigint
rhn_redirects recurring_frequency bigint
rhn_redirects recurring bigint
rhn_redirects contact_id bigint
rhn_redirects customer_id bigint
rhn_redirects recid bigint
rhn_redirects recurring_dur_type bigint
rhn_redirects recurring_duration bigint
rhn_sat_cluster customer_id bigint
rhn_sat_cluster physical_location_id bigint
rhn_sat_cluster recid bigint
rhn_sat_cluster_probe sat_cluster_id bigint
rhn_sat_cluster_probe probe_id bigint
rhn_sat_node sat_cluster_id bigint
rhn_sat_node recid bigint
rhn_sat_node server_id bigint
rhn_sat_node_probe sat_node_id bigint
rhn_sat_node_probe probe_id bigint
rhn_satellite_state satellite_id bigint
rhn_satellite_state recent_state_changes integer
rhn_satellite_state pct_pending integer
rhn_satellite_state pct_unknown integer
rhn_satellite_state pct_warning integer
rhn_satellite_state probe_count integer
rhn_satellite_state avg_latency integer
rhn_satellite_state min_latency integer
rhn_satellite_state max_latency integer
rhn_satellite_state avg_exec_time integer
rhn_satellite_state min_exec_time integer
rhn_satellite_state max_exec_time integer
rhn_satellite_state pct_ok integer
rhn_satellite_state imminent_probes integer
rhn_satellite_state pct_critical integer
rhn_schedule_days schedule_id bigint
rhn_schedule_days recid bigint
rhn_schedule_days_norm start_int bigint
rhn_schedule_days_norm end_int bigint
rhn_schedule_days_norm schedule_id bigint
rhn_schedule_types recid bigint
rhn_schedule_weeks component_schedule_id bigint
rhn_schedule_weeks schedule_id bigint
rhn_schedule_weeks recid bigint
rhn_schedules customer_id bigint
rhn_schedules recid bigint
rhn_schedules schedule_type_id bigint
rhn_server_monitoring_info recid bigint
rhn_server_monitoring_info os_id bigint
rhn_service_probe_origins origin_probe_id bigint
rhn_service_probe_origins service_probe_id bigint
rhn_snmp_alert sender_cluster_id bigint
rhn_snmp_alert recid bigint
rhn_snmp_alert command_id bigint
rhn_snmp_alert probe_id bigint
rhn_snmp_alert notif_type integer
rhn_snmp_alert probe_class integer
rhn_snmp_alert dest_port integer
rhn_snmp_alert severity integer
rhn_strategies recid bigint
rhn_time_zone_names recid bigint
rhn_url_probe scout_warning_threshold bigint
rhn_url_probe probe_id bigint
rhn_url_probe sat_cluster_id bigint
rhn_url_probe scout_critical_threshold bigint
rhn_url_probe_step connect_warn bigint
rhn_url_probe_step recid bigint
rhn_url_probe_step url_probe_id bigint
rhn_url_probe_step connect_crit bigint
rhn_url_probe_step latency_warn bigint
rhn_url_probe_step latency_crit bigint
rhn_url_probe_step dns_warn bigint
rhn_url_probe_step dns_crit bigint
rhn_url_probe_step total_warn bigint
rhn_url_probe_step total_crit bigint
rhn_url_probe_step trans_warn bigint
rhn_url_probe_step trans_crit bigint
rhn_url_probe_step through_warn bigint
rhn_url_probe_step through_crit bigint
rhn_url_probe_step cookie_port integer
rhn_url_probe_step cookie_maxage integer
rhnaction action_type bigint
rhnaction org_id bigint
rhnaction id bigint
rhnaction scheduler bigint
rhnaction version integer
rhnaction prerequisite integer
rhnaction archived integer
rhnactionconfigchannel action_id bigint
rhnactionconfigchannel config_channel_id bigint
rhnactionconfigchannel server_id bigint
rhnactionconfigdate action_id bigint
rhnactionconfigdatefile action_id bigint
rhnactionconfigfilename failure_id bigint
rhnactionconfigfilename config_revision_id bigint
rhnactionconfigfilename config_file_name_id bigint
rhnactionconfigfilename server_id bigint
rhnactionconfigfilename action_id bigint
rhnactionconfigrevision action_id bigint
rhnactionconfigrevision failure_id bigint
rhnactionconfigrevision config_revision_id bigint
rhnactionconfigrevision server_id bigint
rhnactionconfigrevision id bigint
rhnactionconfigrevisionresult action_config_revision_id bigint
rhnactiondaemonconfig action_id bigint
rhnactiondaemonconfig interval integer
rhnactionerrataupdate action_id bigint
rhnactionerrataupdate errata_id bigint
rhnactionkickstart action_id bigint
rhnactionkickstart id bigint
rhnactionkickstart kstree_id bigint
rhnactionkickstartfilelist action_ks_id bigint
rhnactionkickstartfilelist file_list_id bigint
rhnactionkickstartguest ks_session_id bigint
rhnactionkickstartguest action_id bigint
rhnactionkickstartguest kstree_id bigint
rhnactionkickstartguest mem_kb bigint
rhnactionkickstartguest id bigint
rhnactionkickstartguest vcpus integer
rhnactionkickstartguest disk_gb 701
rhnactionpackage name_id bigint
rhnactionpackage id bigint
rhnactionpackage evr_id bigint
rhnactionpackage action_id bigint
rhnactionpackage package_arch_id bigint
rhnactionpackageanswerfile action_package_id bigint
rhnactionpackagedelta action_id bigint
rhnactionpackagedelta package_delta_id bigint
rhnactionpackageorder action_package_id bigint
rhnactionpackageorder package_order integer
rhnactionpackageremovalfailure server_id bigint
rhnactionpackageremovalfailure name_id bigint
rhnactionpackageremovalfailure evr_id bigint
rhnactionpackageremovalfailure capability_id bigint
rhnactionpackageremovalfailure action_id bigint
rhnactionpackageremovalfailure sense integer
rhnactionpackageremovalfailure flags integer
rhnactionpackageremovalfailure suggested integer
rhnactionscript action_id bigint
rhnactionscript id bigint
rhnactionscript timeout integer
rhnactionstatus id integer
rhnactiontransactions from_trans_id bigint
rhnactiontransactions action_id bigint
rhnactiontransactions to_trans_id bigint
rhnactiontype id bigint
rhnactionvirtdestroy action_id bigint
rhnactionvirtreboot action_id bigint
rhnactionvirtrefresh action_id bigint
rhnactionvirtresume action_id bigint
rhnactionvirtschedulepoller action_id bigint
rhnactionvirtschedulepoller month integer
rhnactionvirtschedulepoller minute integer
rhnactionvirtschedulepoller hour integer
rhnactionvirtschedulepoller dow integer
rhnactionvirtschedulepoller dom integer
rhnactionvirtsetmemory action_id bigint
rhnactionvirtsetmemory memory bigint
rhnactionvirtshutdown action_id bigint
rhnactionvirtstart action_id bigint
rhnactionvirtsuspend action_id bigint
rhnactionvirtvcpu action_id bigint
rhnactionvirtvcpu vcpu integer
rhnactivationkey ks_session_id bigint
rhnactivationkey reg_token_id bigint
rhnappinstallinstance id bigint
rhnappinstallsession server_id bigint
rhnappinstallsession id bigint
rhnappinstallsession instance_id bigint
rhnappinstallsession user_id bigint
rhnappinstallsession step_number integer
rhnappinstallsessiondata session_id bigint
rhnappinstallsessiondata id bigint
rhnarchtype id bigint
rhnarchtypeactions arch_type_id bigint
rhnarchtypeactions action_type_id bigint
rhnblacklistobsoletes name_id bigint
rhnblacklistobsoletes evr_id bigint
rhnblacklistobsoletes ignore_name_id bigint
rhnblacklistobsoletes package_arch_id bigint
rhnchannel parent_channel bigint
rhnchannel org_id bigint
rhnchannel channel_arch_id bigint
rhnchannel product_name_id bigint
rhnchannel channel_product_id bigint
rhnchannel id bigint
rhnchannelarch id bigint
rhnchannelarch arch_type_id bigint
rhnchannelcloned original_id bigint
rhnchannelcloned id bigint
rhnchannelcomps channel_id bigint
rhnchannelcomps id bigint
rhnchanneldownloads downloads_id bigint
rhnchanneldownloads channel_id bigint
rhnchannelerrata channel_id bigint
rhnchannelerrata errata_id bigint
rhnchannelfamily org_id bigint
rhnchannelfamily id bigint
rhnchannelfamilylicense channel_family_id bigint
rhnchannelfamilylicenseconsent user_id bigint
rhnchannelfamilylicenseconsent channel_family_id bigint
rhnchannelfamilylicenseconsent server_id bigint
rhnchannelfamilymembers channel_id bigint
rhnchannelfamilymembers channel_family_id bigint
rhnchannelfamilyvirtsublevel channel_family_id bigint
rhnchannelfamilyvirtsublevel virt_sub_level_id bigint
rhnchannelnewestpackage package_arch_id bigint
rhnchannelnewestpackage package_id bigint
rhnchannelnewestpackage evr_id bigint
rhnchannelnewestpackage name_id bigint
rhnchannelnewestpackage channel_id bigint
rhnchannelnewestpackageaudit channel_id bigint
rhnchannelpackage channel_id bigint
rhnchannelpackage package_id bigint
rhnchannelpackagearchcompat channel_arch_id bigint
rhnchannelpackagearchcompat package_arch_id bigint
rhnchannelparent channel bigint
rhnchannelparent parent_channel bigint
rhnchannelpermission channel_id bigint
rhnchannelpermission role_id bigint
rhnchannelpermission user_id bigint
rhnchannelpermissionrole id bigint
rhnchannelpg channel_arch_id bigint
rhnchannelpg id bigint
rhnchannelpg channel_product_id bigint
rhnchannelpg product_name_id bigint
rhnchannelpg org_id bigint
rhnchannelpg parent_channel bigint
rhnchannelproduct id bigint
rhnclientcapability server_id bigint
rhnclientcapability capability_name_id bigint
rhnclientcapabilityname id bigint
rhnconfigchannel id bigint
rhnconfigchannel confchan_type_id bigint
rhnconfigchannel org_id bigint
rhnconfigchanneltype id bigint
rhnconfigchanneltype priority integer
rhnconfigcontent file_size bigint
rhnconfigcontent id bigint
rhnconfigfile config_channel_id bigint
rhnconfigfile config_file_name_id bigint
rhnconfigfile latest_config_revision_id bigint
rhnconfigfile state_id bigint
rhnconfigfile id bigint
rhnconfigfilefailure id bigint
rhnconfigfilename id bigint
rhnconfigfilestate id bigint
rhnconfigfiletype id bigint
rhnconfiginfo id bigint
rhnconfiginfo filemode integer
rhnconfigrevision id bigint
rhnconfigrevision config_file_type_id bigint
rhnconfigrevision changed_by_id bigint
rhnconfigrevision config_info_id bigint
rhnconfigrevision config_content_id bigint
rhnconfigrevision config_file_id bigint
rhnconfigrevision revision integer
rhncpu server_id bigint
rhncpu id bigint
rhncpu cpu_arch_id bigint
rhncpu nrcpu integer
rhncpuarch id bigint
rhncryptokey org_id bigint
rhncryptokey crypto_key_type_id bigint
rhncryptokey id bigint
rhncryptokeykickstart ksdata_id bigint
rhncryptokeykickstart crypto_key_id bigint
rhncryptokeytype id bigint
rhncustomdatakey last_modified_by bigint
rhncustomdatakey created_by bigint
rhncustomdatakey org_id bigint
rhncustomdatakey id bigint
rhncve id bigint
rhndailysummaryqueue org_id bigint
rhndevice pcitype bigint
rhndevice id bigint
rhndevice server_id bigint
rhndevice detached integer
rhndistchannelmap channel_arch_id bigint
rhndistchannelmap channel_id bigint
rhndownloads channel_family_id bigint
rhndownloads file_id bigint
rhndownloads id bigint
rhndownloads download_type integer
rhndownloads ordering integer
rhndownloadtype id bigint
rhnemailaddress state_id bigint
rhnemailaddress id bigint
rhnemailaddress user_id bigint
rhnemailaddresslog user_id bigint
rhnemailaddressstate id bigint
rhnerrata org_id bigint
rhnerrata id bigint
rhnerrata severity_id bigint
rhnerrata advisory_rel bigint
rhnerratabuglist errata_id bigint
rhnerratabuglist bug_id bigint
rhnerratabuglisttmp bug_id bigint
rhnerratabuglisttmp errata_id bigint
rhnerratacloned original_id bigint
rhnerratacloned id bigint
rhnerrataclonedtmp id bigint
rhnerrataclonedtmp original_id bigint
rhnerratacve cve_id bigint
rhnerratacve errata_id bigint
rhnerratafile id bigint
rhnerratafile type bigint
rhnerratafile errata_id bigint
rhnerratafilechannel errata_file_id bigint
rhnerratafilechannel channel_id bigint
rhnerratafilechanneltmp channel_id bigint
rhnerratafilechanneltmp errata_file_id bigint
rhnerratafilepackage package_id bigint
rhnerratafilepackage errata_file_id bigint
rhnerratafilepackagesource package_id bigint
rhnerratafilepackagesource errata_file_id bigint
rhnerratafilepackagetmp package_id bigint
rhnerratafilepackagetmp errata_file_id bigint
rhnerratafiletmp errata_id bigint
rhnerratafiletmp id bigint
rhnerratafiletmp type integer
rhnerratafiletype id bigint
rhnerratakeyword errata_id bigint
rhnerratakeywordtmp errata_id bigint
rhnerratanotificationqueue errata_id bigint
rhnerratanotificationqueue org_id bigint
rhnerratapackage package_id bigint
rhnerratapackage errata_id bigint
rhnerratapackagetmp errata_id bigint
rhnerratapackagetmp package_id bigint
rhnerrataqueue errata_id bigint
rhnerrataseverity id bigint
rhnerrataseverity rank integer
rhnerratatmp org_id bigint
rhnerratatmp id bigint
rhnerratatmp advisory_rel integer
rhnexception id bigint
rhnfaq id bigint
rhnfaq class_id bigint
rhnfaq private integer
rhnfaq usage_count integer
rhnfaqclass id bigint
rhnfaqclass ordering integer
rhnfeature id bigint
rhnfile org_id bigint
rhnfile id bigint
rhnfile file_size bigint
rhnfiledownload user_id bigint
rhnfiledownload file_id bigint
rhnfilelist org_id bigint
rhnfilelist id bigint
rhnfilelistmembers config_file_name_id bigint
rhnfilelistmembers file_list_id bigint
rhnfilelocation file_id bigint
rhngrailcomponentchoices user_id bigint
rhngrailcomponentchoices ordering integer
rhngrailcomponents id bigint
rhngrailcomponents role_required integer
rhnindexerwork last_id bigint
rhninfopane id bigint
rhnkickstartabletree id bigint
rhnkickstartabletree kstree_type bigint
rhnkickstartabletree channel_id bigint
rhnkickstartabletree org_id bigint
rhnkickstartabletree install_type bigint
rhnkickstartchildchannel ksdata_id bigint
rhnkickstartchildchannel channel_id bigint
rhnkickstartcommand kickstart_id bigint
rhnkickstartcommand id bigint
rhnkickstartcommand ks_command_name_id bigint
rhnkickstartcommandname id bigint
rhnkickstartcommandname sort_order integer
rhnkickstartdefaultregtoken regtoken_id bigint
rhnkickstartdefaultregtoken kickstart_id bigint
rhnkickstartdefaults server_profile_id bigint
rhnkickstartdefaults kickstart_id bigint
rhnkickstartdefaults kstree_id bigint
rhnkickstartdefaults virtualization_type bigint
rhnkickstartiprange org_id bigint
rhnkickstartiprange kickstart_id bigint
rhnkickstartiprange max bigint
rhnkickstartiprange min bigint
rhnkickstartpackage package_name_id bigint
rhnkickstartpackage kickstart_id bigint
rhnkickstartpreservefilelist kickstart_id bigint
rhnkickstartpreservefilelist file_list_id bigint
rhnkickstartscript id bigint
rhnkickstartscript kickstart_id bigint
rhnkickstartscript position integer
rhnkickstartsession kickstart_id bigint
rhnkickstartsession virtualization_type bigint
rhnkickstartsession server_profile_id bigint
rhnkickstartsession state_id bigint
rhnkickstartsession action_id bigint
rhnkickstartsession host_server_id bigint
rhnkickstartsession new_server_id bigint
rhnkickstartsession old_server_id bigint
rhnkickstartsession scheduler bigint
rhnkickstartsession org_id bigint
rhnkickstartsession kstree_id bigint
rhnkickstartsession id bigint
rhnkickstartsession package_fetch_count integer
rhnkickstartsessionhistory action_id bigint
rhnkickstartsessionhistory state_id bigint
rhnkickstartsessionhistory kickstart_session_id bigint
rhnkickstartsessionhistory id bigint
rhnkickstartsessionstate id bigint
rhnkickstarttimezone install_type bigint
rhnkickstarttimezone id bigint
rhnkickstartvirtualizationtype id bigint
rhnksdata id bigint
rhnksdata org_id bigint
rhnksinstalltype id bigint
rhnkstreefile file_size bigint
rhnkstreefile kstree_id bigint
rhnkstreetype id bigint
rhnmessage id bigint
rhnmessage message_type bigint
rhnmessage priority integer
rhnmessagepriority id bigint
rhnmessagetype id bigint
rhnmonitor probe_id bigint
rhnmonitor server_id bigint
rhnmonitor batch_id bigint
rhnmonitor granularity integer
rhnmonitorgranularity id bigint
rhnorgchannelsettings setting_id bigint
rhnorgchannelsettings org_id bigint
rhnorgchannelsettings channel_id bigint
rhnorgchannelsettingstype id bigint
rhnorgentitlements entitlement_id bigint
rhnorgentitlements org_id bigint
rhnorgentitlementtype id bigint
rhnorgerratacachequeue org_id bigint
rhnorgerratacachequeue server_count integer
rhnorgerratacachequeue processed integer
rhnorginfo org_id bigint
rhnorginfo default_group_type bigint
rhnorgquota used bigint
rhnorgquota org_id bigint
rhnorgquota total bigint
rhnorgquota bonus bigint
rhnpackage package_group bigint
rhnpackage package_size bigint
rhnpackage evr_id bigint
rhnpackage name_id bigint
rhnpackage payload_size bigint
rhnpackage source_rpm_id bigint
rhnpackage org_id bigint
rhnpackage id bigint
rhnpackage package_arch_id bigint
rhnpackage header_end integer
rhnpackage header_start integer
rhnpackage compat integer
rhnpackagearch id bigint
rhnpackagearch arch_type_id bigint
rhnpackagecapability id bigint
rhnpackagechangelog package_id bigint
rhnpackageconflicts package_id bigint
rhnpackageconflicts capability_id bigint
rhnpackageconflicts sense integer
rhnpackagedelta id bigint
rhnpackagedeltaelement transaction_package_id bigint
rhnpackagedeltaelement package_delta_id bigint
rhnpackageevr id bigint
rhnpackagefile rdev bigint
rhnpackagefile package_id bigint
rhnpackagefile capability_id bigint
rhnpackagefile device bigint
rhnpackagefile inode bigint
rhnpackagefile file_size bigint
rhnpackagefile flags integer
rhnpackagefile file_mode integer
rhnpackagefile verifyflags integer
rhnpackagegroup id bigint
rhnpackagename id bigint
rhnpackagenevra id bigint
rhnpackagenevra evr_id bigint
rhnpackagenevra name_id bigint
rhnpackagenevra package_arch_id bigint
rhnpackageobsoletes capability_id bigint
rhnpackageobsoletes package_id bigint
rhnpackageobsoletes sense integer
rhnpackageprovides capability_id bigint
rhnpackageprovides package_id bigint
rhnpackageprovides sense integer
rhnpackagerequires capability_id bigint
rhnpackagerequires package_id bigint
rhnpackagerequires sense integer
rhnpackagesense id bigint
rhnpackagesensemap sense_id bigint
rhnpackagesensemap sense integer
rhnpackagesignature package_id bigint
rhnpackagesignature id bigint
rhnpackagesignature type_id bigint
rhnpackagesigtype id bigint
rhnpackagesource org_id bigint
rhnpackagesource id bigint
rhnpackagesource payload_size bigint
rhnpackagesource source_rpm_id bigint
rhnpackagesource package_size bigint
rhnpackagesource package_group integer
rhnpackagesyncblacklist org_id bigint
rhnpackagesyncblacklist package_name_id bigint
rhnpaiderratatempcache user_id bigint
rhnpaiderratatempcache server_id bigint
rhnpaiderratatempcache errata_id bigint
rhnpathchannelmap channel_id bigint
rhnprivatechannelfamily org_id bigint
rhnprivatechannelfamily channel_family_id bigint
rhnprivatechannelfamily current_members integer
rhnprivatechannelfamily max_members integer
rhnproduct product_line_id bigint
rhnproduct id bigint
rhnproductchannel product_id bigint
rhnproductchannel channel_id bigint
rhnproductline id bigint
rhnproductname id bigint
rhnprovisionstate id bigint
rhnproxyinfo proxy_evr_id bigint
rhnproxyinfo server_id bigint
rhnpublicchannelfamily channel_family_id bigint
rhnpushclient id bigint
rhnpushclient state_id bigint
rhnpushclient server_id bigint
rhnpushclientstate id bigint
rhnpushdispatcher id bigint
rhnpushdispatcher port integer
rhnram id bigint
rhnram server_id bigint
rhnram ram bigint
rhnram swap bigint
rhnregtoken server_id bigint
rhnregtoken org_id bigint
rhnregtoken user_id bigint
rhnregtoken id bigint
rhnregtoken usage_limit integer
rhnregtoken disabled integer
rhnregtokenchannels token_id bigint
rhnregtokenchannels channel_id bigint
rhnregtokenconfigchannels config_channel_id bigint
rhnregtokenconfigchannels token_id bigint
rhnregtokenconfigchannels position integer
rhnregtokenentitlement reg_token_id bigint
rhnregtokenentitlement server_group_type_id bigint
rhnregtokengroups server_group_id bigint
rhnregtokengroups token_id bigint
rhnregtokenorgdefault reg_token_id bigint
rhnregtokenorgdefault org_id bigint
rhnregtokenpackages name_id bigint
rhnregtokenpackages token_id bigint
rhnrelationshiptype id bigint
rhnreleasechannelmap channel_arch_id bigint
rhnreleasechannelmap channel_id bigint
rhnsatellitecert version 701
rhnsatellitechannelfamily server_id bigint
rhnsatellitechannelfamily channel_family_id bigint
rhnsatellitechannelfamily quantity integer
rhnsatelliteinfo evr_id bigint
rhnsatelliteinfo server_id bigint
rhnsatelliteservergroup server_group_type bigint
rhnsatelliteservergroup server_id bigint
rhnsatelliteservergroup max_members integer
rhnsavedsearch type bigint
rhnsavedsearch web_contact_id bigint
rhnsavedsearch id bigint
rhnsavedsearchtype id bigint
rhnserver provision_state_id bigint
rhnserver server_arch_id bigint
rhnserver org_id bigint
rhnserver id bigint
rhnserver creator_id bigint
rhnserver last_boot integer
rhnserveraction action_id bigint
rhnserveraction server_id bigint
rhnserveraction status integer
rhnserveraction result_code integer
rhnserveraction remaining_tries integer
rhnserveractionpackageresult server_id bigint
rhnserveractionpackageresult action_package_id bigint
rhnserveractionpackageresult result_code integer
rhnserveractionscriptresult action_script_id bigint
rhnserveractionscriptresult server_id bigint
rhnserveractionscriptresult return_code integer
rhnserveractionverifymissing package_capability_id bigint
rhnserveractionverifymissing package_arch_id bigint
rhnserveractionverifymissing package_evr_id bigint
rhnserveractionverifymissing package_name_id bigint
rhnserveractionverifymissing action_id bigint
rhnserveractionverifymissing server_id bigint
rhnserveractionverifyresult package_arch_id bigint
rhnserveractionverifyresult server_id bigint
rhnserveractionverifyresult package_evr_id bigint
rhnserveractionverifyresult package_capability_id bigint
rhnserveractionverifyresult action_id bigint
rhnserveractionverifyresult package_name_id bigint
rhnserverarch arch_type_id bigint
rhnserverarch id bigint
rhnservercacheinfo server_id bigint
rhnserverchannel channel_id bigint
rhnserverchannel server_id bigint
rhnserverchannelarchcompat channel_arch_id bigint
rhnserverchannelarchcompat server_arch_id bigint
rhnserverconfigchannel server_id bigint
rhnserverconfigchannel config_channel_id bigint
rhnserverconfigchannel position integer
rhnservercustomdatavalue created_by bigint
rhnservercustomdatavalue server_id bigint
rhnservercustomdatavalue key_id bigint
rhnservercustomdatavalue last_modified_by bigint
rhnserverdmi server_id bigint
rhnserverdmi id bigint
rhnserverevent id bigint
rhnserverevent server_id bigint
rhnservergroup id bigint
rhnservergroup group_type bigint
rhnservergroup org_id bigint
rhnservergroup max_members integer
rhnservergroup current_members integer
rhnservergroupmembers server_id bigint
rhnservergroupmembers server_group_id bigint
rhnservergroupnotes creator bigint
rhnservergroupnotes id bigint
rhnservergroupnotes server_group_id bigint
rhnservergrouptype id bigint
rhnservergrouptypefeature feature_id bigint
rhnservergrouptypefeature server_group_type_id bigint
rhnserverhistory id bigint
rhnserverhistory server_id bigint
rhnserverinfo server_id bigint
rhnserverinfo checkin_counter integer
rhnserverinstallinfo id bigint
rhnserverinstallinfo server_id bigint
rhnserverinstallinfo iso_status integer
rhnserverlocation server_id bigint
rhnserverlocation id bigint
rhnserverlock locker_id bigint
rhnserverlock server_id bigint
rhnservermessage server_id bigint
rhnservermessage message_id bigint
rhnservermessage server_event integer
rhnserverneedederratacache errata_id bigint
rhnserverneedederratacache server_id bigint
rhnserverneedederratacache org_id bigint
rhnserverneededpackagecache server_id bigint
rhnserverneededpackagecache errata_id bigint
rhnserverneededpackagecache org_id bigint
rhnserverneededpackagecache package_id bigint
rhnservernetinterface server_id bigint
rhnservernetwork id bigint
rhnservernetwork server_id bigint
rhnservernotes id bigint
rhnservernotes server_id bigint
rhnservernotes creator bigint
rhnserverpackage evr_id bigint
rhnserverpackage server_id bigint
rhnserverpackage name_id bigint
rhnserverpackage package_arch_id bigint
rhnserverpackagearchcompat server_arch_id bigint
rhnserverpackagearchcompat package_arch_id bigint
rhnserverpackagearchcompat preference integer
rhnserverpath proxy_server_id bigint
rhnserverpath server_id bigint
rhnserverpath position integer
rhnserverpreservefilelist server_id bigint
rhnserverpreservefilelist file_list_id bigint
rhnserverprofile profile_type_id bigint
rhnserverprofile id bigint
rhnserverprofile org_id bigint
rhnserverprofile base_channel bigint
rhnserverprofilepackage server_profile_id bigint
rhnserverprofilepackage evr_id bigint
rhnserverprofilepackage name_id bigint
rhnserverprofiletype id bigint
rhnserverservergrouparchcompat server_group_type bigint
rhnserverservergrouparchcompat server_arch_id bigint
rhnservertokenregs token_id bigint
rhnservertokenregs server_id bigint
rhnserveruuid server_id bigint
rhnset element bigint
rhnset element_two bigint
rhnset user_id bigint
rhnsgtypebaseaddoncompat base_id bigint
rhnsgtypebaseaddoncompat addon_id bigint
rhnsgtypevirtsublevel server_group_type_id bigint
rhnsgtypevirtsublevel virt_sub_level_id bigint
rhnsnapshot server_id bigint
rhnsnapshot invalid bigint
rhnsnapshot org_id bigint
rhnsnapshot id bigint
rhnsnapshotchannel snapshot_id bigint
rhnsnapshotchannel channel_id bigint
rhnsnapshotconfigchannel config_channel_id bigint
rhnsnapshotconfigchannel snapshot_id bigint
rhnsnapshotconfigrevision config_revision_id bigint
rhnsnapshotconfigrevision snapshot_id bigint
rhnsnapshotinvalidreason id bigint
rhnsnapshotpackage nevra_id bigint
rhnsnapshotpackage snapshot_id bigint
rhnsnapshotservergroup snapshot_id bigint
rhnsnapshotservergroup server_group_id bigint
rhnsnapshottag tag_id bigint
rhnsnapshottag snapshot_id bigint
rhnsnapshottag server_id bigint
rhnsnperrataqueue errata_id bigint
rhnsnperrataqueue processed integer
rhnsnpserverqueue server_id bigint
rhnsnpserverqueue processed integer
rhnsolarispackage package_id bigint
rhnsolarispatch patch_type bigint
rhnsolarispatch package_id bigint
rhnsolarispatchedpackage package_nevra_id bigint
rhnsolarispatchedpackage patch_id bigint
rhnsolarispatchedpackage server_id bigint
rhnsolarispatchpackages package_nevra_id bigint
rhnsolarispatchpackages patch_id bigint
rhnsolarispatchset package_id bigint
rhnsolarispatchsetmembers patch_id bigint
rhnsolarispatchsetmembers patch_set_id bigint
rhnsolarispatchsetmembers patch_order integer
rhnsolarispatchtype id bigint
rhnsourcerpm id bigint
rhntag org_id bigint
rhntag id bigint
rhntag name_id bigint
rhntagname id bigint
rhntaskqueue org_id bigint
rhntaskqueue task_data integer
rhntaskqueue priority integer
rhntemplatecategory id bigint
rhntemplatestring category_id bigint
rhntemplatestring id bigint
rhntextmessage message_id bigint
rhntimezone id bigint
rhntransaction id bigint
rhntransaction rpm_trans_id bigint
rhntransaction server_id bigint
rhntransactionelement transaction_package_id bigint
rhntransactionelement transaction_id bigint
rhntransactionoperation id bigint
rhntransactionpackage name_id bigint
rhntransactionpackage package_arch_id bigint
rhntransactionpackage id bigint
rhntransactionpackage evr_id bigint
rhntransactionpackage operation integer
rhnuserdefaultsystemgroups user_id bigint
rhnuserdefaultsystemgroups system_group_id bigint
rhnusergroup org_id bigint
rhnusergroup group_type bigint
rhnusergroup id bigint
rhnusergroup current_members integer
rhnusergroup max_members integer
rhnusergroupmembers user_id bigint
rhnusergroupmembers user_group_id bigint
rhnusergrouptype id bigint
rhnuserinfo timezone_id bigint
rhnuserinfo user_id bigint
rhnuserinfo bad_email integer
rhnuserinfo no_clear_sets integer
rhnuserinfo page_size integer
rhnuserinfo email_notify integer
rhnuserinfo tz_offset integer
rhnuserinfopane user_id bigint
rhnuserinfopane pane_id bigint
rhnusermessage user_id bigint
rhnusermessage message_id bigint
rhnusermessage status integer
rhnusermessagestatus id integer
rhnusermessagetype id bigint
rhnuserservergroupperms user_id bigint
rhnuserservergroupperms server_group_id bigint
rhnuserserverperms user_id bigint
rhnuserserverperms server_id bigint
rhnuserserverprefs server_id bigint
rhnuserserverprefs user_id bigint
rhnversioninfo evr_id bigint
rhnversioninfo name_id bigint
rhnvirtsublevel id bigint
rhnvirtualinstance virtual_system_id bigint
rhnvirtualinstance host_system_id bigint
rhnvirtualinstance id bigint
rhnvirtualinstanceeventlog old_state bigint
rhnvirtualinstanceeventlog new_host_system_id bigint
rhnvirtualinstanceeventlog old_host_system_id bigint
rhnvirtualinstanceeventlog new_memory_size_k bigint
rhnvirtualinstanceeventlog old_memory_size_k bigint
rhnvirtualinstanceeventlog new_state bigint
rhnvirtualinstanceeventlog event_type bigint
rhnvirtualinstanceeventlog virtual_instance_id bigint
rhnvirtualinstanceeventlog id bigint
rhnvirtualinstanceeventlog old_vcpus integer
rhnvirtualinstanceeventlog new_vcpus integer
rhnvirtualinstanceeventtype id bigint
rhnvirtualinstanceinfo instance_type bigint
rhnvirtualinstanceinfo memory_size_k bigint
rhnvirtualinstanceinfo instance_id bigint
rhnvirtualinstanceinfo vcpus integer
rhnvirtualinstanceinfo state integer
rhnvirtualinstanceinstalllog ks_session_id bigint
rhnvirtualinstanceinstalllog id bigint
rhnvirtualinstancestate id bigint
rhnvirtualinstancetype id bigint
rhnvisibleobjects object_id bigint
rhnvisibleobjects pxt_session_id bigint
rhnwebcontactchangelog web_contact_id bigint
rhnwebcontactchangelog id bigint
rhnwebcontactchangelog web_contact_from_id bigint
rhnwebcontactchangelog change_state_id bigint
rhnwebcontactchangestate id bigint
state_change entry_time bigint
time_series entry_time bigint
web_contact oracle_contact_id bigint
web_contact id bigint
web_contact org_id bigint
web_customer oracle_customer_id bigint
web_customer oracle_customer_number bigint
web_customer id bigint
web_customer_notification org_id bigint
web_customer_notification id bigint
web_user_contact_permission web_user_id bigint
web_user_personal_info web_user_id bigint
web_user_personal_info pin integer
web_user_site_info id bigint
web_user_site_info web_user_id bigint
_______________________________________________
Spacewalk-devel mailing list
Spacewalk-devel@redhat.com
https://www.redhat.com/mailman/listinfo/spacewalk-devel
