schema/spacewalk/common/data/rhnFAQClass.sql | 40 ---------- schema/spacewalk/common/tables/rhnFAQ.sql | 40 ---------- schema/spacewalk/common/tables/rhnFAQClass.sql | 38 --------- schema/spacewalk/common/tables/rhnPackage.sql | 2 schema/spacewalk/common/tables/rhnSet.sql | 2 schema/spacewalk/common/tables/rhnSystemMigrations.sql | 4 - schema/spacewalk/common/tables/rhnVirtualInstance.sql | 2 schema/spacewalk/common/tables/rhn_check_probe.sql | 6 - schema/spacewalk/common/tables/rhn_check_suite_probe.sql | 4 - schema/spacewalk/common/tables/rhn_check_suites.sql | 4 - schema/spacewalk/common/tables/rhn_command.sql | 2 schema/spacewalk/common/tables/rhn_command_param_threshold.sql | 2 schema/spacewalk/common/tables/rhn_command_parameter.sql | 2 schema/spacewalk/common/tables/rhn_command_queue_commands.sql | 2 schema/spacewalk/common/tables/rhn_command_queue_execs.sql | 8 +- schema/spacewalk/common/tables/rhn_command_queue_execs_bk.sql | 8 +- schema/spacewalk/common/tables/rhn_command_queue_instances.sql | 6 - schema/spacewalk/common/tables/rhn_command_queue_instances_bk.sql | 6 - schema/spacewalk/common/tables/rhn_command_queue_params.sql | 4 - schema/spacewalk/common/tables/rhn_command_queue_sessions.sql | 2 schema/spacewalk/common/tables/rhn_command_target.sql | 4 - schema/spacewalk/common/tables/rhn_contact_groups.sql | 10 +- schema/spacewalk/common/tables/rhn_contact_methods.sql | 18 ++-- schema/spacewalk/common/tables/rhn_current_alerts.sql | 16 ++-- schema/spacewalk/common/tables/rhn_current_state_summaries.sql | 4 - schema/spacewalk/common/tables/rhn_deployed_probe.sql | 22 ++--- schema/spacewalk/common/tables/rhn_host_check_suites.sql | 4 - schema/spacewalk/common/tables/rhn_host_probe.sql | 6 - schema/spacewalk/common/tables/rhn_method_types.sql | 4 - schema/spacewalk/common/tables/rhn_multi_scout_threshold.sql | 6 - schema/spacewalk/common/tables/rhn_notification_formats.sql | 8 +- schema/spacewalk/common/tables/rhn_notifservers.sql | 2 schema/spacewalk/common/tables/rhn_os.sql | 2 schema/spacewalk/common/tables/rhn_os_commands_xref.sql | 4 - schema/spacewalk/common/tables/rhn_pager_types.sql | 2 schema/spacewalk/common/tables/rhn_physical_location.sql | 4 - schema/spacewalk/common/tables/rhn_probe.sql | 16 ++-- schema/spacewalk/common/tables/rhn_probe_state.sql | 4 - schema/spacewalk/common/tables/rhn_redirect_criteria.sql | 4 - schema/spacewalk/common/tables/rhn_redirect_email_targets.sql | 2 schema/spacewalk/common/tables/rhn_redirect_group_targets.sql | 4 - schema/spacewalk/common/tables/rhn_redirect_method_targets.sql | 4 - schema/spacewalk/common/tables/rhn_redirects.sql | 14 +-- schema/spacewalk/common/tables/rhn_sat_cluster.sql | 6 - schema/spacewalk/common/tables/rhn_sat_cluster_probe.sql | 4 - schema/spacewalk/common/tables/rhn_sat_node.sql | 12 +-- schema/spacewalk/common/tables/rhn_sat_node_probe.sql | 4 - schema/spacewalk/common/tables/rhn_satellite_state.sql | 30 +++---- schema/spacewalk/common/tables/rhn_schedule_days.sql | 6 - schema/spacewalk/common/tables/rhn_schedule_days_norm.sql | 8 +- schema/spacewalk/common/tables/rhn_schedule_types.sql | 2 schema/spacewalk/common/tables/rhn_schedule_weeks.sql | 8 +- schema/spacewalk/common/tables/rhn_schedules.sql | 6 - schema/spacewalk/common/tables/rhn_server_monitoring_info.sql | 4 - schema/spacewalk/common/tables/rhn_service_probe_origins.sql | 4 - schema/spacewalk/common/tables/rhn_snmp_alert.sql | 16 ++-- schema/spacewalk/common/tables/rhn_strategies.sql | 2 schema/spacewalk/common/tables/rhn_threshold_type.sql | 2 schema/spacewalk/common/tables/rhn_time_zone_names.sql | 4 - schema/spacewalk/common/tables/rhn_url_probe.sql | 8 +- schema/spacewalk/common/tables/rhn_url_probe_step.sql | 34 ++++---- schema/spacewalk/common/tables/tables.deps | 1 schema/spacewalk/common/views/rhnServerOutdatedPackages.sql | 2 schema/spacewalk/oracle/class/evr_t.sql | 18 ---- schema/spacewalk/oracle/procs/sequence_currval.sql | 9 -- schema/spacewalk/oracle/procs/sequence_nextval.sql | 9 -- schema/spacewalk/oracle/triggers/rhnFAQ.sql | 25 ------ 67 files changed, 196 insertions(+), 376 deletions(-)
New commits: commit 3410acac4756bea244993a25095376bd922a789b Author: Jeff Ortel jortel@redhat.com Date: Tue Jul 21 18:10:51 2009 -0500
Resolve differences between databases created master and pgsql sources.
diff --git a/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql b/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql index 95e4e16..a68f3ce 100644 --- a/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql +++ b/schema/spacewalk/common/views/rhnServerOutdatedPackages.sql @@ -27,7 +27,7 @@ AS SELECT DISTINCT SNPC.server_id, P.name_id, P.evr_id, - PN.name || '-' || evr_t_as_vre_simple( PE.evr ), + PN.name || '-' || PE.evr.as_vre_simple(), E.id, E.advisory FROM rhnPackageName PN, diff --git a/schema/spacewalk/oracle/class/evr_t.sql b/schema/spacewalk/oracle/class/evr_t.sql index ddc06c3..0d03097 100644 --- a/schema/spacewalk/oracle/class/evr_t.sql +++ b/schema/spacewalk/oracle/class/evr_t.sql @@ -61,21 +61,3 @@ end; / show errors
-create or replace function evr_t_as_vre( a evr_t ) - return varchar2 -is -begin - return a.as_vre; -end; -/ -show errors - -create or replace function evr_t_as_vre_simple( a evr_t ) - return VARCHAR2 -is -begin - return a.as_vre_simple; -end; -/ -show errors - diff --git a/schema/spacewalk/oracle/procs/sequence_currval.sql b/schema/spacewalk/oracle/procs/sequence_currval.sql deleted file mode 100644 index 891e74f..0000000 --- a/schema/spacewalk/oracle/procs/sequence_currval.sql +++ /dev/null @@ -1,9 +0,0 @@ -create or replace function sequence_currval( seq_name varchar2 ) return number as - ret number; -begin - execute immediate 'select '|| seq_name || '.currval from dual' - into ret; - return ret; -end; -/ - diff --git a/schema/spacewalk/oracle/procs/sequence_nextval.sql b/schema/spacewalk/oracle/procs/sequence_nextval.sql deleted file mode 100644 index c93e152..0000000 --- a/schema/spacewalk/oracle/procs/sequence_nextval.sql +++ /dev/null @@ -1,9 +0,0 @@ -create or replace function sequence_nextval( seq_name varchar2 ) return number as - ret number; -begin - execute immediate 'select '|| seq_name || '.nextval from dual' - into ret; - return ret; -end; -/ -
commit 79a08479f36399c26aae812fec749d0e9f38179c Author: Jeff Ortel jortel@redhat.com Date: Tue Jul 21 16:01:15 2009 -0500
Resolve differences between databases created master and pgsql sources.
diff --git a/schema/spacewalk/common/data/rhnFAQClass.sql b/schema/spacewalk/common/data/rhnFAQClass.sql deleted file mode 100644 index e013e94..0000000 --- a/schema/spacewalk/common/data/rhnFAQClass.sql +++ /dev/null @@ -1,40 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- --- data for rhnFAQClass --- - -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -1, 'General', 'general', 100); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -2, 'Account Management', 'account_management', 120); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -3, 'Getting Started', 'getting_started', 140); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -4, 'Service Levels', 'service_levels', 160); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -5, 'Using Spacewalk', 'using_rhn', 180); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -6, 'Technical Questions', 'technical_questions', 200); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -7, 'Management Service', 'enterprise_service', 220); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -8, 'Privacy/Legal', 'legal', 240); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -9, 'Policies', 'policy', 260); -INSERT INTO RHNFAQCLASS ( ID, NAME, LABEL, ORDERING ) VALUES ( -11, 'Definitions', 'definitions', 270); -COMMIT; - -COMMIT; diff --git a/schema/spacewalk/common/tables/rhnFAQ.sql b/schema/spacewalk/common/tables/rhnFAQ.sql deleted file mode 100644 index 40b3c39..0000000 --- a/schema/spacewalk/common/tables/rhnFAQ.sql +++ /dev/null @@ -1,40 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - - -CREATE TABLE rhnFAQ -( - id NUMBER NOT NULL - CONSTRAINT rhn_faq_id_pk PRIMARY KEY - USING INDEX TABLESPACE [[64k_tbs]], - class_id NUMBER - CONSTRAINT rhn_faq_class_fk - REFERENCES rhnFAQClass (id), - subject VARCHAR2(200), - details VARCHAR2(4000), - private NUMBER - DEFAULT (0) NOT NULL, - usage_count NUMBER - DEFAULT (0) NOT NULL, - created DATE - DEFAULT (sysdate) NOT NULL, - modified DATE - DEFAULT (sysdate) NOT NULL -) -ENABLE ROW MOVEMENT -; - -CREATE SEQUENCE rhn_faq_id_seq; - diff --git a/schema/spacewalk/common/tables/rhnFAQClass.sql b/schema/spacewalk/common/tables/rhnFAQClass.sql deleted file mode 100644 index 6f3432f..0000000 --- a/schema/spacewalk/common/tables/rhnFAQClass.sql +++ /dev/null @@ -1,38 +0,0 @@ --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - - -CREATE TABLE rhnFAQClass -( - id NUMBER NOT NULL - CONSTRAINT rhn_faq_class_id_pk PRIMARY KEY - USING INDEX TABLESPACE [[64k_tbs]], - name VARCHAR2(128), - label VARCHAR2(32) NOT NULL, - ordering NUMBER NOT NULL -) -ENABLE ROW MOVEMENT -; - -CREATE UNIQUE INDEX rhn_faqclass_label_uq - ON rhnFAQClass (label) - TABLESPACE [[64k_tbs]]; - -CREATE UNIQUE INDEX rhn_faqclass_or_uq - ON rhnFAQClass (ordering) - TABLESPACE [[64k_tbs]]; - -CREATE SEQUENCE RHN_FAQ_CLASS_ID_SEQ START WITH 101; - diff --git a/schema/spacewalk/common/tables/rhnPackage.sql b/schema/spacewalk/common/tables/rhnPackage.sql index 0388466..8318474 100644 --- a/schema/spacewalk/common/tables/rhnPackage.sql +++ b/schema/spacewalk/common/tables/rhnPackage.sql @@ -48,7 +48,7 @@ CREATE TABLE rhnPackage md5sum VARCHAR2(64) NOT NULL, vendor VARCHAR2(64) NOT NULL, payload_format VARCHAR2(32), - compat NUMBER + compat NUMBER(1) DEFAULT (0) CONSTRAINT rhn_package_compat_check CHECK (compat in ( 1 , 0 )), diff --git a/schema/spacewalk/common/tables/rhnSet.sql b/schema/spacewalk/common/tables/rhnSet.sql index 78105d0..87e8b83 100644 --- a/schema/spacewalk/common/tables/rhnSet.sql +++ b/schema/spacewalk/common/tables/rhnSet.sql @@ -21,7 +21,7 @@ CREATE TABLE rhnSet REFERENCES web_contact (id) ON DELETE CASCADE, label VARCHAR2(32) NOT NULL, - element NUMBER NOT NULL, + element NUMBER, element_two NUMBER, element_three NUMBER, CONSTRAINT rhn_set_user_label_elem_unq UNIQUE (user_id, label, element, element_two, element_three) diff --git a/schema/spacewalk/common/tables/rhnSystemMigrations.sql b/schema/spacewalk/common/tables/rhnSystemMigrations.sql index b5c8d74..6d81a87 100644 --- a/schema/spacewalk/common/tables/rhnSystemMigrations.sql +++ b/schema/spacewalk/common/tables/rhnSystemMigrations.sql @@ -16,11 +16,11 @@
CREATE TABLE rhnSystemMigrations ( - org_id_to NUMBER + org_id_to NUMBER NOT NULL CONSTRAINT rhn_sys_mig_oidto_fk REFERENCES web_customer (id) ON DELETE SET NULL, - org_id_from NUMBER + org_id_from NUMBER NOT NULL CONSTRAINT rhn_sys_mig_oidfrm_fk REFERENCES web_customer (id) ON DELETE SET NULL, diff --git a/schema/spacewalk/common/tables/rhnVirtualInstance.sql b/schema/spacewalk/common/tables/rhnVirtualInstance.sql index 02bea28..f74b71a 100644 --- a/schema/spacewalk/common/tables/rhnVirtualInstance.sql +++ b/schema/spacewalk/common/tables/rhnVirtualInstance.sql @@ -26,7 +26,7 @@ CREATE TABLE rhnVirtualInstance CONSTRAINT rhn_vi_vsi_fk REFERENCES rhnServer (id), uuid VARCHAR2(128), - confirmed NUMBER + confirmed NUMBER(1) DEFAULT (1) NOT NULL, created DATE DEFAULT (sysdate) NOT NULL, diff --git a/schema/spacewalk/common/tables/rhn_check_probe.sql b/schema/spacewalk/common/tables/rhn_check_probe.sql index 4d0cdda..e1c1212 100644 --- a/schema/spacewalk/common/tables/rhn_check_probe.sql +++ b/schema/spacewalk/common/tables/rhn_check_probe.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_check_probe ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_chkpb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], probe_type VARCHAR2(12) DEFAULT ('check') NOT NULL CONSTRAINT chkpb_probe_type_ck CHECK (probe_type = 'check'), - host_id NUMBER NOT NULL, - sat_cluster_id NUMBER NOT NULL + host_id NUMBER(12) NOT NULL, + sat_cluster_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_check_suite_probe.sql b/schema/spacewalk/common/tables/rhn_check_suite_probe.sql index 0717883..75b0f37 100644 --- a/schema/spacewalk/common/tables/rhn_check_suite_probe.sql +++ b/schema/spacewalk/common/tables/rhn_check_suite_probe.sql @@ -16,14 +16,14 @@
CREATE TABLE rhn_check_suite_probe ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_ckspb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], probe_type VARCHAR2(12) DEFAULT ('suite') NOT NULL CONSTRAINT rhn_ckspb_probe_type_ck CHECK (probe_type = 'suite'), - check_suite_id NUMBER NOT NULL + check_suite_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_check_suites.sql b/schema/spacewalk/common/tables/rhn_check_suites.sql index 1ff0fc8..d1d0976 100644 --- a/schema/spacewalk/common/tables/rhn_check_suites.sql +++ b/schema/spacewalk/common/tables/rhn_check_suites.sql @@ -16,10 +16,10 @@
CREATE TABLE rhn_check_suites ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cksut_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], - customer_id NUMBER NOT NULL, + customer_id NUMBER(12) NOT NULL, suite_name VARCHAR2(40) NOT NULL, description VARCHAR2(255), last_update_user VARCHAR2(40) NOT NULL, diff --git a/schema/spacewalk/common/tables/rhn_command.sql b/schema/spacewalk/common/tables/rhn_command.sql index 2aa15cc..15a6714 100644 --- a/schema/spacewalk/common/tables/rhn_command.sql +++ b/schema/spacewalk/common/tables/rhn_command.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_command ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cmmnd_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], name VARCHAR2(40) NOT NULL, diff --git a/schema/spacewalk/common/tables/rhn_command_param_threshold.sql b/schema/spacewalk/common/tables/rhn_command_param_threshold.sql index 1541133..832cc45 100644 --- a/schema/spacewalk/common/tables/rhn_command_param_threshold.sql +++ b/schema/spacewalk/common/tables/rhn_command_param_threshold.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_command_param_threshold ( - command_id NUMBER NOT NULL, + command_id NUMBER(12) NOT NULL, param_name VARCHAR2(40) NOT NULL, param_type VARCHAR2(10) NOT NULL CONSTRAINT rhn_coptr_param_type_ck diff --git a/schema/spacewalk/common/tables/rhn_command_parameter.sql b/schema/spacewalk/common/tables/rhn_command_parameter.sql index 73872cd..a8773d4 100644 --- a/schema/spacewalk/common/tables/rhn_command_parameter.sql +++ b/schema/spacewalk/common/tables/rhn_command_parameter.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_command_parameter ( - command_id NUMBER NOT NULL, + command_id NUMBER(12) NOT NULL, param_name VARCHAR2(40) NOT NULL, param_type VARCHAR2(10) DEFAULT ('config') NOT NULL, diff --git a/schema/spacewalk/common/tables/rhn_command_queue_commands.sql b/schema/spacewalk/common/tables/rhn_command_queue_commands.sql index 2ba6cc4..32ce539 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_commands.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_commands.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_command_queue_commands ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cqcmd_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], description VARCHAR2(40) NOT NULL, diff --git a/schema/spacewalk/common/tables/rhn_command_queue_execs.sql b/schema/spacewalk/common/tables/rhn_command_queue_execs.sql index 2d46ef7..8eb1d38 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_execs.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_execs.sql @@ -16,12 +16,12 @@
CREATE TABLE rhn_command_queue_execs ( - instance_id NUMBER NOT NULL, - netsaint_id NUMBER NOT NULL, + instance_id NUMBER(12) NOT NULL, + netsaint_id NUMBER(12) NOT NULL, date_accepted DATE, date_executed DATE, - exit_status NUMBER, - execution_time NUMBER, + exit_status NUMBER(5), + execution_time NUMBER(10,6), stdout VARCHAR2(4000), stderr VARCHAR2(4000), last_update_date DATE, diff --git a/schema/spacewalk/common/tables/rhn_command_queue_execs_bk.sql b/schema/spacewalk/common/tables/rhn_command_queue_execs_bk.sql index 6fa0039..878f85c 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_execs_bk.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_execs_bk.sql @@ -16,12 +16,12 @@
CREATE TABLE rhn_command_queue_execs_bk ( - instance_id NUMBER NOT NULL, - netsaint_id NUMBER NOT NULL, + instance_id NUMBER(12) NOT NULL, + netsaint_id NUMBER(12) NOT NULL, date_accepted DATE, date_executed DATE, - exit_status NUMBER, - execution_time NUMBER, + exit_status NUMBER(5), + execution_time NUMBER(10), stdout VARCHAR2(4000), stderr VARCHAR2(4000), last_update_date DATE, diff --git a/schema/spacewalk/common/tables/rhn_command_queue_instances.sql b/schema/spacewalk/common/tables/rhn_command_queue_instances.sql index 049ca19..247ceb7 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_instances.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_instances.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_command_queue_instances ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cqins_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], - command_id NUMBER NOT NULL, + command_id NUMBER(12) NOT NULL, notes VARCHAR2(2000), date_submitted DATE NOT NULL, expiration_date DATE NOT NULL, notify_email VARCHAR2(50), - timeout NUMBER, + timeout NUMBER(5), last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_command_queue_instances_bk.sql b/schema/spacewalk/common/tables/rhn_command_queue_instances_bk.sql index 74b1794..a2773cc 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_instances_bk.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_instances_bk.sql @@ -16,13 +16,13 @@
CREATE TABLE rhn_command_queue_instances_bk ( - recid NUMBER NOT NULL, - command_id NUMBER NOT NULL, + recid NUMBER(12) NOT NULL, + command_id NUMBER(12) NOT NULL, notes VARCHAR2(2000), date_submitted DATE NOT NULL, expiration_date DATE NOT NULL, notify_email VARCHAR2(50), - timeout NUMBER, + timeout NUMBER(5), last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_command_queue_params.sql b/schema/spacewalk/common/tables/rhn_command_queue_params.sql index 508130b..84d0215 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_params.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_params.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_command_queue_params ( - instance_id NUMBER NOT NULL, - ord NUMBER NOT NULL, + instance_id NUMBER(12) NOT NULL, + ord NUMBER(3) NOT NULL, value VARCHAR2(1024) ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_command_queue_sessions.sql b/schema/spacewalk/common/tables/rhn_command_queue_sessions.sql index 9e60354..ba15c97 100644 --- a/schema/spacewalk/common/tables/rhn_command_queue_sessions.sql +++ b/schema/spacewalk/common/tables/rhn_command_queue_sessions.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_command_queue_sessions ( - contact_id NUMBER NOT NULL, + contact_id NUMBER(12) NOT NULL, session_id VARCHAR2(255), expiration_date DATE, last_update_user VARCHAR2(40), diff --git a/schema/spacewalk/common/tables/rhn_command_target.sql b/schema/spacewalk/common/tables/rhn_command_target.sql index 94003ef..0af2b55 100644 --- a/schema/spacewalk/common/tables/rhn_command_target.sql +++ b/schema/spacewalk/common/tables/rhn_command_target.sql @@ -16,11 +16,11 @@
CREATE TABLE rhn_command_target ( - recid NUMBER NOT NULL, + recid NUMBER(12) NOT NULL, target_type VARCHAR2(10) NOT NULL CONSTRAINT cmdtg_target_type_ck CHECK (target_type in ( 'cluster' , 'node' )), - customer_id NUMBER NOT NULL + customer_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_contact_groups.sql b/schema/spacewalk/common/tables/rhn_contact_groups.sql index 7d55c16..37c0193 100644 --- a/schema/spacewalk/common/tables/rhn_contact_groups.sql +++ b/schema/spacewalk/common/tables/rhn_contact_groups.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_contact_groups ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cntgp_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_cntgp_recid_notzero CHECK (recid > 0), contact_group_name VARCHAR2(30) NOT NULL, - customer_id NUMBER NOT NULL, - strategy_id NUMBER NOT NULL, - ack_wait NUMBER NOT NULL + customer_id NUMBER(12) NOT NULL, + strategy_id NUMBER(12) NOT NULL, + ack_wait NUMBER(4) NOT NULL CONSTRAINT rhn_cntgp_ack_wait_ck CHECK (ack_wait < 20160), rotate_first CHAR(1) NOT NULL @@ -32,7 +32,7 @@ CREATE TABLE rhn_contact_groups CHECK (rotate_first in ( '0' , '1' )), last_update_user VARCHAR2(40) NOT NULL, last_update_date DATE NOT NULL, - notification_format_id NUMBER + notification_format_id NUMBER(12) DEFAULT (4) NOT NULL ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_contact_methods.sql b/schema/spacewalk/common/tables/rhn_contact_methods.sql index b84506a..63af7dd 100644 --- a/schema/spacewalk/common/tables/rhn_contact_methods.sql +++ b/schema/spacewalk/common/tables/rhn_contact_methods.sql @@ -16,19 +16,19 @@
CREATE TABLE rhn_contact_methods ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_cmeth_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_cmeth_recid_notzero CHECK (recid > 0), method_name VARCHAR2(20), - contact_id NUMBER NOT NULL, - schedule_id NUMBER, - method_type_id NUMBER NOT NULL, - pager_type_id NUMBER, + contact_id NUMBER(12) NOT NULL, + schedule_id NUMBER(12), + method_type_id NUMBER(12) NOT NULL, + pager_type_id NUMBER(12), pager_pin VARCHAR2(20), pager_email VARCHAR2(50), - pager_max_message_length NUMBER + pager_max_message_length NUMBER(6) CONSTRAINT rhn_cmeth_pgr_length_limit CHECK (pager_max_message_length between 10 and 1920), pager_split_long_messages CHAR(1), @@ -37,10 +37,10 @@ CREATE TABLE rhn_contact_methods last_update_user VARCHAR2(40), last_update_date DATE, snmp_host VARCHAR2(255), - snmp_port NUMBER, - notification_format_id NUMBER + snmp_port NUMBER(5), + notification_format_id NUMBER(12) DEFAULT (4) NOT NULL, - sender_sat_cluster_id NUMBER + sender_sat_cluster_id NUMBER(12) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_current_alerts.sql b/schema/spacewalk/common/tables/rhn_current_alerts.sql index 6b2a502..50afff0 100644 --- a/schema/spacewalk/common/tables/rhn_current_alerts.sql +++ b/schema/spacewalk/common/tables/rhn_current_alerts.sql @@ -16,27 +16,27 @@
CREATE TABLE rhn_current_alerts ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_alrts_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[128m_tbs]], date_submitted DATE, last_server_change DATE, date_completed DATE DEFAULT (to_date('31-12-9999', 'dd-mm-yyyy')), - original_server NUMBER, - current_server NUMBER, + original_server NUMBER(12), + current_server NUMBER(12), tel_args VARCHAR2(2200), message VARCHAR2(2000), ticket_id VARCHAR2(80), destination_name VARCHAR2(50), - escalation_level NUMBER + escalation_level NUMBER(2) DEFAULT (0), - host_probe_id NUMBER, + host_probe_id NUMBER(12), host_state VARCHAR2(255), - service_probe_id NUMBER, + service_probe_id NUMBER(12), service_state VARCHAR2(255), - customer_id NUMBER NOT NULL, - netsaint_id NUMBER, + customer_id NUMBER(12) NOT NULL, + netsaint_id NUMBER(12), probe_type VARCHAR2(20) DEFAULT ('none'), in_progress CHAR(1) diff --git a/schema/spacewalk/common/tables/rhn_current_state_summaries.sql b/schema/spacewalk/common/tables/rhn_current_state_summaries.sql index f8729cf..49aee46 100644 --- a/schema/spacewalk/common/tables/rhn_current_state_summaries.sql +++ b/schema/spacewalk/common/tables/rhn_current_state_summaries.sql @@ -16,10 +16,10 @@
CREATE TABLE rhn_current_state_summaries ( - customer_id NUMBER NOT NULL, + customer_id NUMBER(12)_ NOT NULL, template_id VARCHAR2(10) NOT NULL, state VARCHAR2(20) NOT NULL, - state_count NUMBER, + state_count NUMBER(9), last_check DATE ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_deployed_probe.sql b/schema/spacewalk/common/tables/rhn_deployed_probe.sql index 00727dc..583ecfc 100644 --- a/schema/spacewalk/common/tables/rhn_deployed_probe.sql +++ b/schema/spacewalk/common/tables/rhn_deployed_probe.sql @@ -16,25 +16,25 @@
CREATE TABLE rhn_deployed_probe ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_dprob_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[8m_tbs]], probe_type VARCHAR2(15) NOT NULL, description VARCHAR2(255), - customer_id NUMBER NOT NULL, - command_id NUMBER NOT NULL, - contact_group_id NUMBER, - os_id NUMBER, + customer_id NUMBER(12) NOT NULL, + command_id NUMBER(16) NOT NULL, + contact_group_id NUMBER(12), + os_id NUMBER(12), notify_critical CHAR(1), notify_warning CHAR(1), notify_recovery CHAR(1), notify_unknown CHAR(1), - notification_interval_minutes NUMBER NOT NULL, - check_interval_minutes NUMBER NOT NULL, - retry_interval_minutes NUMBER NOT NULL, - max_attempts NUMBER, - sat_cluster_id NUMBER, - parent_probe_id NUMBER, + notification_interval_minutes NUMBER(16) NOT NULL, + check_interval_minutes NUMBER(16) NOT NULL, + retry_interval_minutes NUMBER(16) NOT NULL, + max_attempts NUMBER(16), + sat_cluster_id NUMBER(12), + parent_probe_id NUMBER(12), last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_host_check_suites.sql b/schema/spacewalk/common/tables/rhn_host_check_suites.sql index 62379a0..3e76b08 100644 --- a/schema/spacewalk/common/tables/rhn_host_check_suites.sql +++ b/schema/spacewalk/common/tables/rhn_host_check_suites.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_host_check_suites ( - host_probe_id NUMBER NOT NULL, - suite_id NUMBER NOT NULL + host_probe_id NUMBER(12) NOT NULL, + suite_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_host_probe.sql b/schema/spacewalk/common/tables/rhn_host_probe.sql index 9f5526a..15e4496 100644 --- a/schema/spacewalk/common/tables/rhn_host_probe.sql +++ b/schema/spacewalk/common/tables/rhn_host_probe.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_host_probe ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_hstpb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], probe_type VARCHAR2(12) DEFAULT ('host') NOT NULL CONSTRAINT rhn_hstpb_probe_type_ck CHECK (probe_type = 'host'), - host_id NUMBER NOT NULL, - sat_cluster_id NUMBER NOT NULL + host_id NUMBER(12) NOT NULL, + sat_cluster_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_method_types.sql b/schema/spacewalk/common/tables/rhn_method_types.sql index 30e7ebe..7da4f3b 100644 --- a/schema/spacewalk/common/tables/rhn_method_types.sql +++ b/schema/spacewalk/common/tables/rhn_method_types.sql @@ -16,13 +16,13 @@
CREATE TABLE rhn_method_types ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_mthtp_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]] CONSTRAINT rhn_mthtp_recid_ck CHECK (recid > 0), method_type_name VARCHAR2(20), - notification_format_id NUMBER + notification_format_id NUMBER(12) DEFAULT (4) NOT NULL ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_multi_scout_threshold.sql b/schema/spacewalk/common/tables/rhn_multi_scout_threshold.sql index d1fea5e..7e305c5 100644 --- a/schema/spacewalk/common/tables/rhn_multi_scout_threshold.sql +++ b/schema/spacewalk/common/tables/rhn_multi_scout_threshold.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_multi_scout_threshold ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_msthr_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], scout_warning_threshold_is_all CHAR(1) DEFAULT ('1') NOT NULL, scout_crit_threshold_is_all CHAR(1) DEFAULT ('1') NOT NULL, - scout_warning_threshold NUMBER, - scout_critical_threshold NUMBER + scout_warning_threshold NUMBER(12), + scout_critical_threshold NUMBER(12) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_notification_formats.sql b/schema/spacewalk/common/tables/rhn_notification_formats.sql index 6a3df8d..2341b4b 100644 --- a/schema/spacewalk/common/tables/rhn_notification_formats.sql +++ b/schema/spacewalk/common/tables/rhn_notification_formats.sql @@ -16,15 +16,15 @@
CREATE TABLE rhn_notification_formats ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_ntfmt_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]], - customer_id NUMBER, + customer_id NUMBER(12), description VARCHAR2(255) NOT NULL, subject_format VARCHAR2(4000), body_format VARCHAR2(4000) NOT NULL, - max_subject_length NUMBER, - max_body_length NUMBER + max_subject_length NUMBER(12), + max_body_length NUMBER(12) DEFAULT (1920) NOT NULL, reply_format VARCHAR2(4000) ) diff --git a/schema/spacewalk/common/tables/rhn_notifservers.sql b/schema/spacewalk/common/tables/rhn_notifservers.sql index 360f27c..f798c8b 100644 --- a/schema/spacewalk/common/tables/rhn_notifservers.sql +++ b/schema/spacewalk/common/tables/rhn_notifservers.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_notifservers ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_notsv_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]], name VARCHAR2(255) diff --git a/schema/spacewalk/common/tables/rhn_os.sql b/schema/spacewalk/common/tables/rhn_os.sql index d582a6b..b4fbb80 100644 --- a/schema/spacewalk/common/tables/rhn_os.sql +++ b/schema/spacewalk/common/tables/rhn_os.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_os ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_os000_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]], os_name VARCHAR2(128) diff --git a/schema/spacewalk/common/tables/rhn_os_commands_xref.sql b/schema/spacewalk/common/tables/rhn_os_commands_xref.sql index 890a6a4..887d007 100644 --- a/schema/spacewalk/common/tables/rhn_os_commands_xref.sql +++ b/schema/spacewalk/common/tables/rhn_os_commands_xref.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_os_commands_xref ( - os_id NUMBER NOT NULL, - commands_id NUMBER NOT NULL + os_id NUMBER(12) NOT NULL, + commands_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_pager_types.sql b/schema/spacewalk/common/tables/rhn_pager_types.sql index a6a7931..ef543a9 100644 --- a/schema/spacewalk/common/tables/rhn_pager_types.sql +++ b/schema/spacewalk/common/tables/rhn_pager_types.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_pager_types ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_pgrtp_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_pgrtp_recid_ck diff --git a/schema/spacewalk/common/tables/rhn_physical_location.sql b/schema/spacewalk/common/tables/rhn_physical_location.sql index 5f8f3f4..79cd1dd 100644 --- a/schema/spacewalk/common/tables/rhn_physical_location.sql +++ b/schema/spacewalk/common/tables/rhn_physical_location.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_physical_location ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_phslc_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], location_name VARCHAR2(40), @@ -30,7 +30,7 @@ CREATE TABLE rhn_physical_location deleted CHAR(1), last_update_user VARCHAR2(40), last_update_date DATE, - customer_id NUMBER + customer_id NUMBER(12) DEFAULT (999) NOT NULL ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_probe.sql b/schema/spacewalk/common/tables/rhn_probe.sql index 50c7659..eb2dc45 100644 --- a/schema/spacewalk/common/tables/rhn_probe.sql +++ b/schema/spacewalk/common/tables/rhn_probe.sql @@ -16,22 +16,22 @@
CREATE TABLE rhn_probe ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_probe_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[8m_tbs]], probe_type VARCHAR2(15) NOT NULL, description VARCHAR2(255) NOT NULL, - customer_id NUMBER NOT NULL, - command_id NUMBER NOT NULL, - contact_group_id NUMBER, + customer_id NUMBER(12) NOT NULL, + command_id NUMBER(16) NOT NULL, + contact_group_id NUMBER(12), notify_critical CHAR(1), notify_warning CHAR(1), notify_unknown CHAR(1), notify_recovery CHAR(1), - notification_interval_minutes NUMBER NOT NULL, - check_interval_minutes NUMBER NOT NULL, - retry_interval_minutes NUMBER NOT NULL, - max_attempts NUMBER, + notification_interval_minutes NUMBER(16) NOT NULL, + check_interval_minutes NUMBER(16) NOT NULL, + retry_interval_minutes NUMBER(16) NOT NULL, + max_attempts NUMBER(16), last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_probe_state.sql b/schema/spacewalk/common/tables/rhn_probe_state.sql index 6933727..f326d03 100644 --- a/schema/spacewalk/common/tables/rhn_probe_state.sql +++ b/schema/spacewalk/common/tables/rhn_probe_state.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_probe_state ( - probe_id NUMBER NOT NULL, - scout_id NUMBER NOT NULL, + probe_id NUMBER(12) NOT NULL, + scout_id NUMBER(12) NOT NULL, state VARCHAR2(20), output VARCHAR2(4000), last_check DATE diff --git a/schema/spacewalk/common/tables/rhn_redirect_criteria.sql b/schema/spacewalk/common/tables/rhn_redirect_criteria.sql index a6ebf36..3a88a6d 100644 --- a/schema/spacewalk/common/tables/rhn_redirect_criteria.sql +++ b/schema/spacewalk/common/tables/rhn_redirect_criteria.sql @@ -16,10 +16,10 @@
CREATE TABLE rhn_redirect_criteria ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_rdrcr_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], - redirect_id NUMBER NOT NULL, + redirect_id NUMBER(12) NOT NULL, match_param VARCHAR2(255) NOT NULL, match_value VARCHAR2(255), inverted CHAR(1) diff --git a/schema/spacewalk/common/tables/rhn_redirect_email_targets.sql b/schema/spacewalk/common/tables/rhn_redirect_email_targets.sql index 4478d7d..b063178 100644 --- a/schema/spacewalk/common/tables/rhn_redirect_email_targets.sql +++ b/schema/spacewalk/common/tables/rhn_redirect_email_targets.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_redirect_email_targets ( - redirect_id NUMBER NOT NULL, + redirect_id NUMBER(12) NOT NULL, email_address VARCHAR2(255) NOT NULL ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_redirect_group_targets.sql b/schema/spacewalk/common/tables/rhn_redirect_group_targets.sql index b082388..92f2d01 100644 --- a/schema/spacewalk/common/tables/rhn_redirect_group_targets.sql +++ b/schema/spacewalk/common/tables/rhn_redirect_group_targets.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_redirect_group_targets ( - redirect_id NUMBER NOT NULL, - contact_group_id NUMBER NOT NULL + redirect_id NUMBER(12) NOT NULL, + contact_group_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_redirect_method_targets.sql b/schema/spacewalk/common/tables/rhn_redirect_method_targets.sql index a932015..346efa7 100644 --- a/schema/spacewalk/common/tables/rhn_redirect_method_targets.sql +++ b/schema/spacewalk/common/tables/rhn_redirect_method_targets.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_redirect_method_targets ( - redirect_id NUMBER NOT NULL, - contact_method_id NUMBER NOT NULL + redirect_id NUMBER(12) NOT NULL, + contact_method_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_redirects.sql b/schema/spacewalk/common/tables/rhn_redirects.sql index b49cad1..0c5e6ab 100644 --- a/schema/spacewalk/common/tables/rhn_redirects.sql +++ b/schema/spacewalk/common/tables/rhn_redirects.sql @@ -16,11 +16,11 @@
CREATE TABLE rhn_redirects ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_rdrct_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[8m_tbs]], - customer_id NUMBER, - contact_id NUMBER, + customer_id NUMBER(12), + contact_id NUMBER(12), redirect_type VARCHAR2(20) NOT NULL, description VARCHAR2(25), reason VARCHAR2(2000), @@ -28,17 +28,17 @@ CREATE TABLE rhn_redirects last_update_user VARCHAR2(40), last_update_date DATE, start_date DATE NOT NULL, - recurring NUMBER + recurring NUMBER(12) DEFAULT (0) NOT NULL CONSTRAINT RHN_RDRCT_RECUR_VALID CHECK (recurring in ( 0 , 1 )), - recurring_frequency NUMBER + recurring_frequency NUMBER(12) DEFAULT (2) CONSTRAINT RHN_RDRCT_RECUR_FREQ_VALID CHECK (recurring_frequency in ( 2 , 3 , 6 )), - recurring_duration NUMBER + recurring_duration NUMBER(12) DEFAULT (0), - recurring_dur_type NUMBER + recurring_dur_type NUMBER(12) DEFAULT (12) CONSTRAINT rhn_rdrct_rec_dtype_valid CHECK (recurring_dur_type in ( 12 , 11 , 5 , 3 , 1 )) diff --git a/schema/spacewalk/common/tables/rhn_sat_cluster.sql b/schema/spacewalk/common/tables/rhn_sat_cluster.sql index f709fac..975f199 100644 --- a/schema/spacewalk/common/tables/rhn_sat_cluster.sql +++ b/schema/spacewalk/common/tables/rhn_sat_cluster.sql @@ -16,18 +16,18 @@
CREATE TABLE rhn_sat_cluster ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_satcl_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], target_type VARCHAR2(10) DEFAULT ('cluster') NOT NULL CONSTRAINT rhn_satcl_target_type_ck CHECK (target_type in ( 'cluster' )), - customer_id NUMBER NOT NULL, + customer_id NUMBER(12) NOT NULL, description VARCHAR2(255) NOT NULL, last_update_user VARCHAR2(40), last_update_date DATE, - physical_location_id NUMBER NOT NULL, + physical_location_id NUMBER(12) NOT NULL, public_key VARCHAR2(2000), vip VARCHAR2(15), deployed CHAR(1) diff --git a/schema/spacewalk/common/tables/rhn_sat_cluster_probe.sql b/schema/spacewalk/common/tables/rhn_sat_cluster_probe.sql index 3fd18b5..f0dfc41 100644 --- a/schema/spacewalk/common/tables/rhn_sat_cluster_probe.sql +++ b/schema/spacewalk/common/tables/rhn_sat_cluster_probe.sql @@ -16,14 +16,14 @@
CREATE TABLE rhn_sat_cluster_probe ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_sclpb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], probe_type VARCHAR2(12) DEFAULT ('satcluster') NOT NULL CONSTRAINT rhn_sclpb_probe_type_ck CHECK (probe_type = 'satcluster'), - sat_cluster_id NUMBER NOT NULL + sat_cluster_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_sat_node.sql b/schema/spacewalk/common/tables/rhn_sat_node.sql index e5f390a..510fcfb 100644 --- a/schema/spacewalk/common/tables/rhn_sat_node.sql +++ b/schema/spacewalk/common/tables/rhn_sat_node.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_sat_node ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_satnd_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], server_id NUMBER @@ -29,14 +29,14 @@ CREATE TABLE rhn_sat_node last_update_user VARCHAR2(40), last_update_date DATE, mac_address VARCHAR2(17) NOT NULL, - max_concurrent_checks NUMBER, - sat_cluster_id NUMBER NOT NULL, + max_concurrent_checks NUMBER(4), + sat_cluster_id NUMBER(12) NOT NULL, ip VARCHAR2(15), - sched_log_level NUMBER + sched_log_level NUMBER(4) DEFAULT (0) NOT NULL, - sput_log_level NUMBER + sput_log_level NUMBER(4) DEFAULT (0) NOT NULL, - dq_log_level NUMBER + dq_log_level NUMBER(4) DEFAULT (0) NOT NULL, scout_shared_key VARCHAR2(64) NOT NULL ) diff --git a/schema/spacewalk/common/tables/rhn_sat_node_probe.sql b/schema/spacewalk/common/tables/rhn_sat_node_probe.sql index af72ee1..fb8852c 100644 --- a/schema/spacewalk/common/tables/rhn_sat_node_probe.sql +++ b/schema/spacewalk/common/tables/rhn_sat_node_probe.sql @@ -16,14 +16,14 @@
CREATE TABLE rhn_sat_node_probe ( - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_sndpb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], probe_type VARCHAR2(12) DEFAULT ('satnode') NOT NULL CONSTRAINT rhn_sndpb_probe_type_ck CHECK (probe_type = 'satnode'), - sat_node_id NUMBER NOT NULL + sat_node_id NUMBER(12) NOT NULL ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_satellite_state.sql b/schema/spacewalk/common/tables/rhn_satellite_state.sql index 334acac..3ec5acb 100644 --- a/schema/spacewalk/common/tables/rhn_satellite_state.sql +++ b/schema/spacewalk/common/tables/rhn_satellite_state.sql @@ -16,24 +16,24 @@
CREATE TABLE rhn_satellite_state ( - satellite_id NUMBER NOT NULL + satellite_id NUMBER(12) NOT NULL CONSTRAINT rhn_satst_sat_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], last_check DATE, - probe_count NUMBER, - pct_ok NUMBER, - pct_warning NUMBER, - pct_critical NUMBER, - pct_unknown NUMBER, - pct_pending NUMBER, - recent_state_changes NUMBER, - imminent_probes NUMBER, - max_exec_time NUMBER, - min_exec_time NUMBER, - avg_exec_time NUMBER, - max_latency NUMBER, - min_latency NUMBER, - avg_latency NUMBER + probe_count NUMBER(10), + pct_ok NUMBER(10,2), + pct_warning NUMBER(10,2), + pct_critical NUMBER(10,2), + pct_unknown NUMBER(10,2), + pct_pending NUMBER(10,2), + recent_state_changes NUMBER(10), + imminent_probes NUMBER(10), + max_exec_time NUMBER(10,2), + min_exec_time NUMBER(10,2), + avg_exec_time NUMBER(10,2), + max_latency NUMBER(10,2), + min_latency NUMBER(10,2), + avg_latency NUMBER(10,2) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_schedule_days.sql b/schema/spacewalk/common/tables/rhn_schedule_days.sql index ff57570..4a0a049 100644 --- a/schema/spacewalk/common/tables/rhn_schedule_days.sql +++ b/schema/spacewalk/common/tables/rhn_schedule_days.sql @@ -16,13 +16,13 @@
CREATE TABLE rhn_schedule_days ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_schdy_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_schdy_recid_ck CHECK (recid > 0), - schedule_id NUMBER, - ord NUMBER, + schedule_id NUMBER(12), + ord NUMBER(3), start_1 DATE, end_1 DATE, start_2 DATE, diff --git a/schema/spacewalk/common/tables/rhn_schedule_days_norm.sql b/schema/spacewalk/common/tables/rhn_schedule_days_norm.sql index aed690f..7211fbd 100644 --- a/schema/spacewalk/common/tables/rhn_schedule_days_norm.sql +++ b/schema/spacewalk/common/tables/rhn_schedule_days_norm.sql @@ -16,10 +16,10 @@
CREATE TABLE rhn_schedule_days_norm ( - schedule_id NUMBER, - ord NUMBER, - start_int NUMBER, - end_int NUMBER + schedule_id NUMBER(12), + ord NUMBER(3), + start_int NUMBER(12), + end_int NUMBER(12) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_schedule_types.sql b/schema/spacewalk/common/tables/rhn_schedule_types.sql index a413336..4ee74ba 100644 --- a/schema/spacewalk/common/tables/rhn_schedule_types.sql +++ b/schema/spacewalk/common/tables/rhn_schedule_types.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_schedule_types ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_schtp_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]] CONSTRAINT rhn_schtp_recid_ck diff --git a/schema/spacewalk/common/tables/rhn_schedule_weeks.sql b/schema/spacewalk/common/tables/rhn_schedule_weeks.sql index abfcb22..fbfde1a 100644 --- a/schema/spacewalk/common/tables/rhn_schedule_weeks.sql +++ b/schema/spacewalk/common/tables/rhn_schedule_weeks.sql @@ -16,14 +16,14 @@
CREATE TABLE rhn_schedule_weeks ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_schwk_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_schwk_recid_ck CHECK (recid > 0), - schedule_id NUMBER NOT NULL, - component_schedule_id NUMBER, - ord NUMBER, + schedule_id NUMBER(12) NOT NULL, + component_schedule_id NUMBER(12), + ord NUMBER(3), last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_schedules.sql b/schema/spacewalk/common/tables/rhn_schedules.sql index 9cb2f48..d6e2c88 100644 --- a/schema/spacewalk/common/tables/rhn_schedules.sql +++ b/schema/spacewalk/common/tables/rhn_schedules.sql @@ -16,17 +16,17 @@
CREATE TABLE rhn_schedules ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_sched_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]] CONSTRAINT rhn_sched_recid_ck CHECK (recid > 0), - schedule_type_id NUMBER NOT NULL, + schedule_type_id NUMBER(12) NOT NULL, description VARCHAR2(40) DEFAULT ('unknown') NOT NULL, last_update_user VARCHAR2(40), last_update_date DATE, - customer_id NUMBER + customer_id NUMBER(12) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_server_monitoring_info.sql b/schema/spacewalk/common/tables/rhn_server_monitoring_info.sql index f50aaf4..f861532 100644 --- a/schema/spacewalk/common/tables/rhn_server_monitoring_info.sql +++ b/schema/spacewalk/common/tables/rhn_server_monitoring_info.sql @@ -16,10 +16,10 @@
CREATE TABLE rhn_server_monitoring_info ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_host_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[4m_tbs]], - os_id NUMBER + os_id NUMBER(12) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/rhn_service_probe_origins.sql b/schema/spacewalk/common/tables/rhn_service_probe_origins.sql index 8752798..a07e532 100644 --- a/schema/spacewalk/common/tables/rhn_service_probe_origins.sql +++ b/schema/spacewalk/common/tables/rhn_service_probe_origins.sql @@ -16,8 +16,8 @@
CREATE TABLE rhn_service_probe_origins ( - service_probe_id NUMBER NOT NULL, - origin_probe_id NUMBER, + service_probe_id NUMBER(12) NOT NULL, + origin_probe_id NUMBER(12), decoupled CHAR(1) DEFAULT ('0') NOT NULL ) diff --git a/schema/spacewalk/common/tables/rhn_snmp_alert.sql b/schema/spacewalk/common/tables/rhn_snmp_alert.sql index 0b463b8..e18d0e4 100644 --- a/schema/spacewalk/common/tables/rhn_snmp_alert.sql +++ b/schema/spacewalk/common/tables/rhn_snmp_alert.sql @@ -16,25 +16,25 @@
CREATE TABLE rhn_snmp_alert ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_snmpa_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], - sender_cluster_id NUMBER NOT NULL, + sender_cluster_id NUMBER(12) NOT NULL, dest_ip VARCHAR2(255) NOT NULL, - dest_port NUMBER NOT NULL, + dest_port NUMBER(5) NOT NULL, date_generated DATE, date_submitted DATE, command_name VARCHAR2(255), - notif_type NUMBER, + notif_type NUMBER(5), op_center VARCHAR2(255), notif_url VARCHAR2(255), os_name VARCHAR2(128), message VARCHAR2(2000), - probe_id NUMBER, + probe_id NUMBER(12), host_ip VARCHAR2(255), - severity NUMBER, - command_id NUMBER, - probe_class NUMBER, + severity NUMBER(5), + command_id NUMBER(12), + probe_class NUMBER(5), host_name VARCHAR2(255), support_center VARCHAR2(255) ) diff --git a/schema/spacewalk/common/tables/rhn_strategies.sql b/schema/spacewalk/common/tables/rhn_strategies.sql index 3b97285..ebc5e2d 100644 --- a/schema/spacewalk/common/tables/rhn_strategies.sql +++ b/schema/spacewalk/common/tables/rhn_strategies.sql @@ -16,7 +16,7 @@
CREATE TABLE rhn_strategies ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_strat_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]] CONSTRAINT rhn_strat_recid_ck diff --git a/schema/spacewalk/common/tables/rhn_threshold_type.sql b/schema/spacewalk/common/tables/rhn_threshold_type.sql index 7a00c5c..e2d964c 100644 --- a/schema/spacewalk/common/tables/rhn_threshold_type.sql +++ b/schema/spacewalk/common/tables/rhn_threshold_type.sql @@ -20,7 +20,7 @@ CREATE TABLE rhn_threshold_type CONSTRAINT rhn_trtyp_name_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]], description VARCHAR2(80) NOT NULL, - ordinal NUMBER NOT NULL, + ordinal NUMBER(3) NOT NULL, last_update_user VARCHAR2(40), last_update_date DATE ) diff --git a/schema/spacewalk/common/tables/rhn_time_zone_names.sql b/schema/spacewalk/common/tables/rhn_time_zone_names.sql index 5619c9b..c804828 100644 --- a/schema/spacewalk/common/tables/rhn_time_zone_names.sql +++ b/schema/spacewalk/common/tables/rhn_time_zone_names.sql @@ -16,12 +16,12 @@
CREATE TABLE rhn_time_zone_names ( - recid NUMBER NOT NULL, + recid NUMBER(12) NOT NULL, java_id VARCHAR2(40) NOT NULL CONSTRAINT rhn_tznms_java_id_pk PRIMARY KEY USING INDEX TABLESPACE [[64k_tbs]], display_name VARCHAR2(60) NOT NULL, - gmt_offset_minutes NUMBER NOT NULL, + gmt_offset_minutes NUMBER(4) NOT NULL, use_daylight_time CHAR(1) NOT NULL, last_update_user VARCHAR2(40), last_update_date DATE diff --git a/schema/spacewalk/common/tables/rhn_url_probe.sql b/schema/spacewalk/common/tables/rhn_url_probe.sql index 2b66288..c3139e4 100644 --- a/schema/spacewalk/common/tables/rhn_url_probe.sql +++ b/schema/spacewalk/common/tables/rhn_url_probe.sql @@ -28,21 +28,21 @@ CREATE TABLE rhn_url_probe DEFAULT ('1') NOT NULL CONSTRAINT rhn_urlpb_run_on_scouts_ck CHECK (run_on_scouts in ( '0' , '1' )), - probe_id NUMBER NOT NULL + probe_id NUMBER(12) NOT NULL CONSTRAINT rhn_urlpb_probe_id_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], probe_type VARCHAR2(12) DEFAULT ('url') NOT NULL CONSTRAINT rhn_urlpb_probe_type_ck CHECK (probe_type = 'url'), - sat_cluster_id NUMBER, + sat_cluster_id NUMBER(12), scout_warning_threshold_is_all CHAR(1) DEFAULT ('1') NOT NULL, scout_crit_threshold_is_all CHAR(1) DEFAULT ('1') NOT NULL, - scout_warning_threshold NUMBER + scout_warning_threshold NUMBER(12) DEFAULT (-1), - scout_critical_threshold NUMBER + scout_critical_threshold NUMBER(12) DEFAULT (-1) ) ENABLE ROW MOVEMENT diff --git a/schema/spacewalk/common/tables/rhn_url_probe_step.sql b/schema/spacewalk/common/tables/rhn_url_probe_step.sql index 53f9184..5f4ae21 100644 --- a/schema/spacewalk/common/tables/rhn_url_probe_step.sql +++ b/schema/spacewalk/common/tables/rhn_url_probe_step.sql @@ -16,11 +16,11 @@
CREATE TABLE rhn_url_probe_step ( - recid NUMBER NOT NULL + recid NUMBER(12) NOT NULL CONSTRAINT rhn_urlps_recid_pk PRIMARY KEY USING INDEX TABLESPACE [[2m_tbs]], - url_probe_id NUMBER NOT NULL, - step_number NUMBER NOT NULL, + url_probe_id NUMBER(12) NOT NULL, + step_number NUMBER(3) NOT NULL, description VARCHAR2(255), url VARCHAR2(2000) NOT NULL, protocol_method VARCHAR2(12) NOT NULL, @@ -36,40 +36,40 @@ CREATE TABLE rhn_url_probe_step vpattern VARCHAR2(255), post_content VARCHAR2(4000), post_content_type VARCHAR2(255), - connect_warn NUMBER + connect_warn NUMBER(10,3) DEFAULT (0) NOT NULL, - connect_crit NUMBER + connect_crit NUMBER(10,3) DEFAULT (0) NOT NULL, - latency_warn NUMBER + latency_warn NUMBER(10,3) DEFAULT (0) NOT NULL, - latency_crit NUMBER + latency_crit NUMBER(10,3) DEFAULT (0) NOT NULL, - dns_warn NUMBER + dns_warn NUMBER(10,3) DEFAULT (0) NOT NULL, - dns_crit NUMBER + dns_crit NUMBER(10,3) DEFAULT (0) NOT NULL, - total_warn NUMBER + total_warn NUMBER(10,3) DEFAULT (0) NOT NULL, - total_crit NUMBER + total_crit NUMBER(10,3) DEFAULT (0) NOT NULL, - trans_warn NUMBER + trans_warn NUMBER(12) DEFAULT (0) NOT NULL, - trans_crit NUMBER + trans_crit NUMBER(12) DEFAULT (0) NOT NULL, - through_warn NUMBER + through_warn NUMBER(12) DEFAULT (0) NOT NULL, - through_crit NUMBER + through_crit NUMBER(12) DEFAULT (0) NOT NULL, cookie_key VARCHAR2(255), cookie_value VARCHAR2(255), cookie_path VARCHAR2(255), cookie_domain VARCHAR2(255), - cookie_port NUMBER, + cookie_port NUMBER(5), cookie_secure CHAR(1) DEFAULT (0) NOT NULL CONSTRAINT rhn_urlps_cookie_sec_ck CHECK (cookie_secure in ( '0' , '1' )), - cookie_maxage NUMBER + cookie_maxage NUMBER(9) ) ENABLE ROW MOVEMENT ; diff --git a/schema/spacewalk/common/tables/tables.deps b/schema/spacewalk/common/tables/tables.deps index 0b28da3..5d2616f 100644 --- a/schema/spacewalk/common/tables/tables.deps +++ b/schema/spacewalk/common/tables/tables.deps @@ -104,7 +104,6 @@ rhnErrataRelationship :: rhnRelationshipType rhnErrata rhnErrataRelationshipTmp :: rhnRelationshipType rhnErrataTmp rhnErrata rhnErrataClonedTmp :: rhnErrataTmp rhnErrataTmp :: web_customer -rhnFAQ :: rhnFAQClass rhnFile :: web_customer rhnFileLocation :: rhnFile rhnGrailComponents :: rhnUserGroupType diff --git a/schema/spacewalk/oracle/triggers/rhnFAQ.sql b/schema/spacewalk/oracle/triggers/rhnFAQ.sql deleted file mode 100644 index 24d2116..0000000 --- a/schema/spacewalk/oracle/triggers/rhnFAQ.sql +++ /dev/null @@ -1,25 +0,0 @@ - --- --- Copyright (c) 2008 Red Hat, Inc. --- --- This software is licensed to you under the GNU General Public License, --- version 2 (GPLv2). There is NO WARRANTY for this software, express or --- implied, including the implied warranties of MERCHANTABILITY or FITNESS --- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2 --- along with this software; if not, see --- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt. --- --- Red Hat trademarks are not licensed under GPLv2. No permission is --- granted to use or replicate Red Hat trademarks that are incorporated --- in this software or its documentation. --- - -create or replace trigger -rhn_faq_mod_trig -before insert or update on rhnFAQ -for each row -begin - :new.modified := sysdate; -end; -/ -show errors
spacewalk-commits@lists.fedorahosted.org