schema/spacewalk/common/tables/rhnCpu.sql
| 2 +-
schema/spacewalk/common/tables/rhnRam.sql
| 2 +-
schema/spacewalk/common/tables/rhnServerDMI.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
| 6 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
| 6 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.oracle
| 6 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.postgresql
| 6 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.oracle
| 6 ++++++
schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.postgresql
| 6 ++++++
9 files changed, 39 insertions(+), 3 deletions(-)
New commits:
commit 9e8384cf38eb31aa5b7c8420f34e19f8da6335be
Author: Miroslav Suchý <msuchy(a)redhat.com>
Date: Tue Nov 22 10:53:29 2011 +0100
in tables rhnRam, rhnCpu and rhnServerDMI allow only one record per server
Java part of Spacewalk assume only one record per server there.
If there are more records per server tomcat will fail with traceback of
apocalyptic size.
diff --git a/schema/spacewalk/common/tables/rhnCpu.sql
b/schema/spacewalk/common/tables/rhnCpu.sql
index 849068e..dcdb923 100644
--- a/schema/spacewalk/common/tables/rhnCpu.sql
+++ b/schema/spacewalk/common/tables/rhnCpu.sql
@@ -48,7 +48,7 @@ CREATE TABLE rhnCpu
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_cpu_server_id_idx
+CREATE UNIQUE INDEX rhn_cpu_server_id_uq
ON rhnCpu (server_id)
TABLESPACE [[4m_tbs]]
NOLOGGING;
diff --git a/schema/spacewalk/common/tables/rhnRam.sql
b/schema/spacewalk/common/tables/rhnRam.sql
index 84dfb71..67a02c1 100644
--- a/schema/spacewalk/common/tables/rhnRam.sql
+++ b/schema/spacewalk/common/tables/rhnRam.sql
@@ -32,7 +32,7 @@ CREATE TABLE rhnRam
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_ram_sid_idx
+CREATE UNIQUE INDEX rhn_ram_sid_uq
ON rhnRam (server_id)
TABLESPACE [[4m_tbs]]
NOLOGGING;
diff --git a/schema/spacewalk/common/tables/rhnServerDMI.sql
b/schema/spacewalk/common/tables/rhnServerDMI.sql
index 2e5e786..23caafb 100644
--- a/schema/spacewalk/common/tables/rhnServerDMI.sql
+++ b/schema/spacewalk/common/tables/rhnServerDMI.sql
@@ -38,7 +38,7 @@ CREATE TABLE rhnServerDMI
ENABLE ROW MOVEMENT
;
-CREATE INDEX rhn_server_dmi_sid_idx
+CREATE UNIQUE INDEX rhn_server_dmi_sid_uq
ON rhnServerDMI (server_id)
TABLESPACE [[2m_tbs]]
NOLOGGING;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
new file mode 100644
index 0000000..8c6e6ee
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.oracle
@@ -0,0 +1,6 @@
+DROP INDEX rhn_ram_sid_idx;
+
+CREATE UNIQUE INDEX rhn_ram_sid_uq
+ ON rhnRam (server_id)
+ TABLESPACE [[4m_tbs]]
+ NOLOGGING;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
new file mode 100644
index 0000000..2c01a8f
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/125-alter-index-rhnRam.sql.postgresql
@@ -0,0 +1,6 @@
+-- oracle equivalent source sha1 586724a3a2befe543cd5352b7e1d3d88f82d82f3
+
+DROP INDEX rhn_ram_sid_idx;
+
+CREATE UNIQUE INDEX rhn_ram_sid_uq
+ ON rhnRam (server_id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.oracle
new file mode 100644
index 0000000..b327501
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.oracle
@@ -0,0 +1,6 @@
+DROP INDEX rhn_cpu_server_id_idx;
+
+CREATE UNIQUE INDEX rhn_cpu_server_id_uq
+ ON rhnCpu (server_id)
+ TABLESPACE [[4m_tbs]]
+ NOLOGGING;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.postgresql
new file mode 100644
index 0000000..eaca4a9
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/126-alter-index-rhnCpu.sql.postgresql
@@ -0,0 +1,6 @@
+-- oracle equivalent source sha1 9cf5504d7dabce531f966048916bf85ce13e43ed
+
+DROP INDEX rhn_cpu_server_id_idx;
+
+CREATE UNIQUE INDEX rhn_cpu_server_id_uq
+ ON rhnCpu (server_id);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.oracle
new file mode 100644
index 0000000..e5ff9f8
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.oracle
@@ -0,0 +1,6 @@
+DROP INDEX rhn_server_dmi_sid_idx;
+
+CREATE UNIQUE INDEX rhn_server_dmi_sid_uq
+ ON rhnServerDMI (server_id)
+ TABLESPACE [[2m_tbs]]
+ NOLOGGING;
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.postgresql
new file mode 100644
index 0000000..096f010
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/127-alter-index-rhnServerDmi.sql.postgresql
@@ -0,0 +1,6 @@
+-- oracle equivalent source sha1 37531557b1d0368256273ea973cbdbc6eac3dd19
+
+DROP INDEX rhn_server_dmi_sid_idx;
+
+CREATE UNIQUE INDEX rhn_server_dmi_sid_uq
+ ON rhnServerDMI (server_id);
Show replies by date