schema/spacewalk/common/tables/rhnServerNetAddress4.sql | 6 - schema/spacewalk/common/tables/rhnServerNetAddress6.sql | 6 - schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle | 9 ++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql | 11 ++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.oracle | 39 ++++++++++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql | 18 ++++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/111-add_rhnServerNetAddress4_data.sql | 6 + schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/115-drop_columns_rhnServerNetInterface.sql | 3 schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.oracle | 39 ++++++++++ schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql | 17 ++++ 10 files changed, 148 insertions(+), 6 deletions(-)
New commits: commit d3ad7644610e0ef27c7fb1528ca3c382518ef6f8 Author: Miroslav Suchý msuchy@redhat.com Date: Thu Oct 20 19:19:02 2011 +0200
schema upgrade
diff --git a/schema/spacewalk/common/tables/rhnServerNetAddress4.sql b/schema/spacewalk/common/tables/rhnServerNetAddress4.sql index 7042fb2..b451aa3 100644 --- a/schema/spacewalk/common/tables/rhnServerNetAddress4.sql +++ b/schema/spacewalk/common/tables/rhnServerNetAddress4.sql @@ -31,10 +31,10 @@ CREATE TABLE rhnServerNetAddress4 ENABLE ROW MOVEMENT ;
-CREATE INDEX rhn_net_addr4_iid_addr_idx +CREATE INDEX rhn_srv_net_addr4_iid_addr_idx ON rhnServerNetAddress4 (interface_id, address) - TABLESPACE [[8m_tbs]]; + TABLESPACE [[64k_tbs]];
ALTER TABLE rhnServerNetAddress4 - ADD CONSTRAINT rhn_net_add4_iid_addr_uq UNIQUE (interface_id, address); + ADD CONSTRAINT rhn_srv_net_addr4_iid_addr_uq UNIQUE (interface_id, address);
diff --git a/schema/spacewalk/common/tables/rhnServerNetAddress6.sql b/schema/spacewalk/common/tables/rhnServerNetAddress6.sql index ee04fe5..79b10e4 100644 --- a/schema/spacewalk/common/tables/rhnServerNetAddress6.sql +++ b/schema/spacewalk/common/tables/rhnServerNetAddress6.sql @@ -31,10 +31,10 @@ CREATE TABLE rhnServerNetAddress6 ENABLE ROW MOVEMENT ;
-CREATE INDEX rhn_net_addr6_iid_sc_addr_idx +CREATE INDEX rhn_srv_net_ad6_iid_sc_ad_idx ON rhnServerNetAddress6 (interface_id, scope, address) - TABLESPACE [[8m_tbs]]; + TABLESPACE [[64_tbs]];
ALTER TABLE rhnServerNetAddress6 - ADD CONSTRAINT rhn_net_addr6_iid_sc_addr_uq UNIQUE (interface_id, scope, address); + ADD CONSTRAINT rhn_srv_net_ad6_iid_sc_ad_uq UNIQUE (interface_id, scope, address);
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle new file mode 100644 index 0000000..1f0ab2a --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.oracle @@ -0,0 +1,9 @@ +alter table rhnServerNetInterface add id number; + +create sequence rhn_srv_net_iface_id_seq; + +update rhnServerNetInterface set id = rhn_srv_net_iface_id_seq.nextval; + +alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_nn check (id is not null); + +alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_pk primary key ( id ); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql new file mode 100644 index 0000000..c2b448d --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/105-alter_rhnServerNetInterface.sql.postgresql @@ -0,0 +1,11 @@ +-- oracle equivalent source sha1 f5872e029cf1b053c88bd876afc8f253461772ac + +alter table rhnServerNetInterface add id numeric; + +create sequence rhn_srv_net_iface_id_seq; + +update rhnServerNetInterface set id = nextval('rhn_srv_net_iface_id_seq'); + +alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_nn check (id is not null); + +alter table rhnServerNetInterface add constraint rhn_srv_net_iface_id_pk primary key ( id ); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.oracle new file mode 100644 index 0000000..7922fdf --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.oracle @@ -0,0 +1,39 @@ +-- +-- Copyright (c) 2011 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 rhnServerNetAddress4 +( + interface_id NUMBER NOT NULL + CONSTRAINT rhn_srv_net_iaddress4_iid_fk + REFERENCES rhnServerNetInterface (id) + ON DELETE CASCADE, + address VARCHAR2(64), + netmask VARCHAR2(64), + broadcast VARCHAR2(64), + created DATE + DEFAULT (sysdate) NOT NULL, + modified DATE + DEFAULT (sysdate) NOT NULL +) +ENABLE ROW MOVEMENT +; + +CREATE INDEX rhn_srv_net_addr4_iid_addr_idx + ON rhnServerNetAddress4 (interface_id, address) + TABLESPACE [[64k_tbs]]; + +ALTER TABLE rhnServerNetAddress4 + ADD CONSTRAINT rhn_srv_net_addr4_iid_addr_uq UNIQUE (interface_id, address); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql new file mode 100644 index 0000000..7b8a6b7 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/110-add_rhnServerNetAddress4.sql.postgresql @@ -0,0 +1,18 @@ +-- oracle equivalent source sha1 af31dbcccd3799c2cd577137f6f7fd608288b2c4 + +CREATE TABLE rhnServerNetAddress4 +( + interface_id NUMERIC NOT NULL + CONSTRAINT rhn_srv_net_iaddress4_iid_fk + REFERENCES rhnServerNetInterface (id) + ON DELETE CASCADE, + address VARCHAR(64), + netmask VARCHAR(64), + broadcast VARCHAR(64), + created timestamptz default current_timestamp NOT NULL, + modified timestamptz default current_timestamp NOT NULL +); + +CREATE UNIQUE INDEX rhn_srv_net_addr4_iid_addr_uq + ON rhnServerNetAddress4 (interface_id, address) + ; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/111-add_rhnServerNetAddress4_data.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/111-add_rhnServerNetAddress4_data.sql new file mode 100644 index 0000000..bda4fb8 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/111-add_rhnServerNetAddress4_data.sql @@ -0,0 +1,6 @@ +INSERT INTO rhnServerNetAddress4 + (interface_id, address, netmask, broadcast, created) + SELECT id, ip_addr, netmask, broadcast, created + FROM rhnServerNetInterface; + +COMMIT; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/115-drop_columns_rhnServerNetInterface.sql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/115-drop_columns_rhnServerNetInterface.sql new file mode 100644 index 0000000..64e42e1 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/115-drop_columns_rhnServerNetInterface.sql @@ -0,0 +1,3 @@ +ALTER TABLE rhnServerNetInterface DROP COLUMN ip_addr; +ALTER TABLE rhnServerNetInterface DROP COLUMN netmask; +ALTER TABLE rhnServerNetInterface DROP COLUMN broadcast; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.oracle new file mode 100644 index 0000000..42c78b2 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.oracle @@ -0,0 +1,39 @@ +-- +-- Copyright (c) 2011 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 rhnServerNetAddress6 +( + interface_id NUMBER NOT NULL + CONSTRAINT rhn_srv_net_iaddress6_iid_fk + REFERENCES rhnServerNetInterface (id) + ON DELETE CASCADE, + address VARCHAR2(45), + netmask VARCHAR2(49), + scope VARCHAR2(64), + created DATE + DEFAULT (sysdate) NOT NULL, + modified DATE + DEFAULT (sysdate) NOT NULL +) +ENABLE ROW MOVEMENT +; + +CREATE INDEX rhn_srv_net_ad6_iid_sc_ad_idx + ON rhnServerNetAddress6 (interface_id, scope, address) + TABLESPACE [[64k_tbs]]; + +ALTER TABLE rhnServerNetAddress6 + ADD CONSTRAINT rhn_srv_net_ad6_iid_sc_ad_uq UNIQUE (interface_id, scope, address); diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql new file mode 100644 index 0000000..844c601 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.5-to-spacewalk-schema-1.6/120-add_rhnServerNetAddress6.sql.postgresql @@ -0,0 +1,17 @@ +-- oracle equivalent source sha1 7c11068302cdb144f446828d4db0f244dbf12293 + +CREATE TABLE rhnServerNetAddress6 +( + interface_id NUMERIC NOT NULL + CONSTRAINT rhn_srv_net_iaddress6_iid_fk + REFERENCES rhnServerNetInterface (id) + ON DELETE CASCADE, + address VARCHAR(45), + netmask VARCHAR(49), + scope VARCHAR(64), + created timestamptz default current_timestamp NOT NULL, + modified timestamptz default current_timestamp NOT NULL +); + +CREATE UNIQUE INDEX rhn_srv_net_ad6_iid_sc_ad_uq + ON rhnServerNetAddress6 (interface_id, scope, address);
spacewalk-commits@lists.fedorahosted.org