schema/spacewalk/common/tables/rhn_contact_group_members.sql
| 6 ++--
schema/spacewalk/common/tables/rhn_ll_netsaint.sql
| 2 -
schema/spacewalk/common/tables/rhn_probe_param_value.sql
| 4 +-
schema/spacewalk/postgres/procs/rhn_prepare_install.sql
| 2 -
schema/spacewalk/postgres/triggers/rhnFAQ.sql
| 14 ----------
schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/001-numeric-12-columns.sql
| 8 +++++
6 files changed, 15 insertions(+), 21 deletions(-)
New commits:
commit 4685b9e2225ba3c14f576fdf6a4cc980e74162d6
Author: Devan Goodwin <dgoodwin(a)redhat.com>
Date: Wed Aug 12 17:29:38 2009 -0300
Removing PostgreSQL rhnFAQ trigger, table no longer exists.
diff --git a/schema/spacewalk/postgres/triggers/rhnFAQ.sql
b/schema/spacewalk/postgres/triggers/rhnFAQ.sql
deleted file mode 100644
index b9ee131..0000000
--- a/schema/spacewalk/postgres/triggers/rhnFAQ.sql
+++ /dev/null
@@ -1,14 +0,0 @@
-create or replace function rhn_faq_mod_trig_fun() returns trigger as
-$$
-begin
- new.modified := current_timestamp;
-
- return new;
-end;
-$$ language plpgsql;
-
-create trigger
-rhn_faq_mod_trig
-before insert or update on rhnFaq
-for each row
-execute procedure rhn_faq_mod_trig_fun();
commit 9bfcee416f62ec342d249c51b8edc64d57b67ef6
Author: Devan Goodwin <dgoodwin(a)redhat.com>
Date: Wed Aug 12 11:29:03 2009 -0300
Fix numeric/smallint incompatible types in PostgreSQL.
Several columns use NUMERIC(12) in the common schema, which gets
translated to SMALLINT. Meanwhile other tables reference those columns
as foreign keys but are of type NUMERIC.
diff --git a/schema/spacewalk/common/tables/rhn_contact_group_members.sql
b/schema/spacewalk/common/tables/rhn_contact_group_members.sql
index 25b67aa..952265b 100644
--- a/schema/spacewalk/common/tables/rhn_contact_group_members.sql
+++ b/schema/spacewalk/common/tables/rhn_contact_group_members.sql
@@ -16,16 +16,16 @@
CREATE TABLE rhn_contact_group_members
(
- contact_group_id NUMBER NOT NULL
+ contact_group_id NUMBER(12) NOT NULL
CONSTRAINT rhn_cntgm_cgid_fk
REFERENCES rhn_contact_groups (recid)
ON DELETE CASCADE,
order_number NUMBER NOT NULL,
- member_contact_method_id NUMBER
+ member_contact_method_id NUMBER(12)
CONSTRAINT rhn_cntgm_mcmid_fk
REFERENCES rhn_contact_methods (recid)
ON DELETE CASCADE,
- member_contact_group_id NUMBER
+ member_contact_group_id NUMBER(12)
CONSTRAINT rhn_cntgm_mcgid_fk
REFERENCES rhn_contact_groups (recid)
ON DELETE CASCADE,
diff --git a/schema/spacewalk/common/tables/rhn_ll_netsaint.sql
b/schema/spacewalk/common/tables/rhn_ll_netsaint.sql
index eaf4553..eda6c67 100644
--- a/schema/spacewalk/common/tables/rhn_ll_netsaint.sql
+++ b/schema/spacewalk/common/tables/rhn_ll_netsaint.sql
@@ -16,7 +16,7 @@
CREATE TABLE rhn_ll_netsaint
(
- netsaint_id NUMBER NOT NULL,
+ netsaint_id NUMBER(12) NOT NULL,
city VARCHAR2(255)
)
ENABLE ROW MOVEMENT
diff --git a/schema/spacewalk/common/tables/rhn_probe_param_value.sql
b/schema/spacewalk/common/tables/rhn_probe_param_value.sql
index e2f606b..ded05e1 100644
--- a/schema/spacewalk/common/tables/rhn_probe_param_value.sql
+++ b/schema/spacewalk/common/tables/rhn_probe_param_value.sql
@@ -16,8 +16,8 @@
CREATE TABLE rhn_probe_param_value
(
- probe_id NUMBER NOT NULL,
- command_id NUMBER NOT NULL,
+ probe_id NUMBER(12) NOT NULL,
+ command_id NUMBER(12) NOT NULL,
param_name VARCHAR2(40) NOT NULL,
value VARCHAR2(1024),
last_update_user VARCHAR2(40),
diff --git a/schema/spacewalk/postgres/procs/rhn_prepare_install.sql
b/schema/spacewalk/postgres/procs/rhn_prepare_install.sql
index 05e51a6..5ebb34b 100644
--- a/schema/spacewalk/postgres/procs/rhn_prepare_install.sql
+++ b/schema/spacewalk/postgres/procs/rhn_prepare_install.sql
@@ -26,7 +26,7 @@ rhn_prepare_install
command_instance_id in out rhn_command_queue_instances.recid%type,
install_command in rhn_command_queue_instances.command_id%type
)
-returns numeric
+returns smallint
as $$
declare
/* ignore this command if it has not been run after five minutes */
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/001-numeric-12-columns.sql
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/001-numeric-12-columns.sql
new file mode 100644
index 0000000..c5ec175
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-0.6-to-spacewalk-schema-0.7/001-numeric-12-columns.sql
@@ -0,0 +1,8 @@
+-- Change columns to numeric 12 to match the columns of their foreign keys.
+alter table rhn_contact_group_members modify(contact_group_id NUMBER(12));
+alter table rhn_contact_group_members modify(member_contact_method_id NUMBER(12));
+alter table rhn_contact_group_members modify(member_contact_group_id NUMBER(12));
+alter table rhn_ll_netsaint modify(netsaint_id NUMBER(12));
+alter table rhn_probe_param_value modify(probe_id NUMBER(12));
+alter table rhn_probe_param_value modify(command_id NUMBER(12));
+
Show replies by date