schema/spacewalk/common/tables/rhnPackage.sql
| 87 ++++++++++
schema/spacewalk/oracle/tables/rhnPackage.sql
| 87 ----------
schema/spacewalk/postgres/tables/rhnPackage.sql
| 81 ---------
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.oracle
| 30 +++
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.postgresql
| 2
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.oracle
| 1
schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.postgresql
| 7
7 files changed, 127 insertions(+), 168 deletions(-)
New commits:
commit b4a5bc26f2363ba242157c16cb2b08b9ab7717f8
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Sep 7 13:21:48 2012 +0200
Remove the postgres/tables/rhnPackage.sql, we now have the same columns.
diff --git a/schema/spacewalk/common/tables/rhnPackage.sql
b/schema/spacewalk/common/tables/rhnPackage.sql
new file mode 100644
index 0000000..fa1b3fd
--- /dev/null
+++ b/schema/spacewalk/common/tables/rhnPackage.sql
@@ -0,0 +1,87 @@
+--
+-- Copyright (c) 2008--2012 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 rhnPackage
+(
+ id NUMBER NOT NULL
+ CONSTRAINT rhn_package_id_pk PRIMARY KEY
+ USING INDEX TABLESPACE [[4m_tbs]],
+ org_id NUMBER
+ CONSTRAINT rhn_package_oid_fk
+ REFERENCES web_customer (id)
+ ON DELETE CASCADE,
+ name_id NUMBER NOT NULL
+ CONSTRAINT rhn_package_nid_fk
+ REFERENCES rhnPackageName (id),
+ evr_id NUMBER NOT NULL
+ CONSTRAINT rhn_package_eid_fk
+ REFERENCES rhnPackageEvr (id),
+ package_arch_id NUMBER NOT NULL
+ CONSTRAINT rhn_package_paid_fk
+ REFERENCES rhnPackageArch (id),
+ package_group NUMBER
+ CONSTRAINT rhn_package_group_fk
+ REFERENCES rhnPackageGroup (id),
+ rpm_version VARCHAR2(16),
+ description VARCHAR2(4000),
+ summary VARCHAR2(4000),
+ package_size NUMBER NOT NULL,
+ payload_size NUMBER,
+ installed_size NUMBER,
+ build_host VARCHAR2(256),
+ build_time timestamp,
+ source_rpm_id NUMBER
+ CONSTRAINT rhn_package_srcrpmid_fk
+ REFERENCES rhnSourceRPM (id),
+ checksum_id NUMBER NOT NULL
+ CONSTRAINT rhn_package_chsum_fk
+ REFERENCES rhnChecksum (id),
+ vendor VARCHAR2(64) NOT NULL,
+ payload_format VARCHAR2(32),
+ compat NUMBER(1)
+ DEFAULT (0)
+ CONSTRAINT rhn_package_compat_check
+ CHECK (compat in ( 1 , 0 )),
+ path VARCHAR2(1000),
+ header_sig VARCHAR2(64),
+ copyright VARCHAR2(128),
+ cookie VARCHAR2(128),
+ last_modified DATE
+ DEFAULT (sysdate) NOT NULL,
+ created DATE
+ DEFAULT (sysdate) NOT NULL,
+ modified DATE
+ DEFAULT (sysdate) NOT NULL,
+ header_start NUMBER
+ DEFAULT (-1) NOT NULL,
+ header_end NUMBER
+ DEFAULT (-1) NOT NULL
+)
+ENABLE ROW MOVEMENT
+;
+
+CREATE INDEX rhn_package_oid_id_idx
+ ON rhnPackage (org_id, id)
+ TABLESPACE [[64k_tbs]]
+ NOLOGGING;
+
+CREATE INDEX rhn_package_nid_id_idx
+ ON rhnPackage (name_id, id)
+ TABLESPACE [[2m_tbs]]
+ NOLOGGING;
+
+CREATE SEQUENCE rhn_package_id_seq;
+
diff --git a/schema/spacewalk/oracle/tables/rhnPackage.sql
b/schema/spacewalk/oracle/tables/rhnPackage.sql
deleted file mode 100644
index fa1b3fd..0000000
--- a/schema/spacewalk/oracle/tables/rhnPackage.sql
+++ /dev/null
@@ -1,87 +0,0 @@
---
--- Copyright (c) 2008--2012 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 rhnPackage
-(
- id NUMBER NOT NULL
- CONSTRAINT rhn_package_id_pk PRIMARY KEY
- USING INDEX TABLESPACE [[4m_tbs]],
- org_id NUMBER
- CONSTRAINT rhn_package_oid_fk
- REFERENCES web_customer (id)
- ON DELETE CASCADE,
- name_id NUMBER NOT NULL
- CONSTRAINT rhn_package_nid_fk
- REFERENCES rhnPackageName (id),
- evr_id NUMBER NOT NULL
- CONSTRAINT rhn_package_eid_fk
- REFERENCES rhnPackageEvr (id),
- package_arch_id NUMBER NOT NULL
- CONSTRAINT rhn_package_paid_fk
- REFERENCES rhnPackageArch (id),
- package_group NUMBER
- CONSTRAINT rhn_package_group_fk
- REFERENCES rhnPackageGroup (id),
- rpm_version VARCHAR2(16),
- description VARCHAR2(4000),
- summary VARCHAR2(4000),
- package_size NUMBER NOT NULL,
- payload_size NUMBER,
- installed_size NUMBER,
- build_host VARCHAR2(256),
- build_time timestamp,
- source_rpm_id NUMBER
- CONSTRAINT rhn_package_srcrpmid_fk
- REFERENCES rhnSourceRPM (id),
- checksum_id NUMBER NOT NULL
- CONSTRAINT rhn_package_chsum_fk
- REFERENCES rhnChecksum (id),
- vendor VARCHAR2(64) NOT NULL,
- payload_format VARCHAR2(32),
- compat NUMBER(1)
- DEFAULT (0)
- CONSTRAINT rhn_package_compat_check
- CHECK (compat in ( 1 , 0 )),
- path VARCHAR2(1000),
- header_sig VARCHAR2(64),
- copyright VARCHAR2(128),
- cookie VARCHAR2(128),
- last_modified DATE
- DEFAULT (sysdate) NOT NULL,
- created DATE
- DEFAULT (sysdate) NOT NULL,
- modified DATE
- DEFAULT (sysdate) NOT NULL,
- header_start NUMBER
- DEFAULT (-1) NOT NULL,
- header_end NUMBER
- DEFAULT (-1) NOT NULL
-)
-ENABLE ROW MOVEMENT
-;
-
-CREATE INDEX rhn_package_oid_id_idx
- ON rhnPackage (org_id, id)
- TABLESPACE [[64k_tbs]]
- NOLOGGING;
-
-CREATE INDEX rhn_package_nid_id_idx
- ON rhnPackage (name_id, id)
- TABLESPACE [[2m_tbs]]
- NOLOGGING;
-
-CREATE SEQUENCE rhn_package_id_seq;
-
diff --git a/schema/spacewalk/postgres/tables/rhnPackage.sql
b/schema/spacewalk/postgres/tables/rhnPackage.sql
deleted file mode 100644
index 03d31d3..0000000
--- a/schema/spacewalk/postgres/tables/rhnPackage.sql
+++ /dev/null
@@ -1,81 +0,0 @@
--- oracle equivalent source sha1 ac7c0bee7e76f6823a9208a8ce3b674efb0f99d7
---
--- Copyright (c) 2008--2010 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 rhnPackage
-(
- id NUMERIC
- CONSTRAINT rhn_package_id_pk PRIMARY KEY,
- org_id NUMERIC
- CONSTRAINT rhn_package_oid_fk
- REFERENCES web_customer (id)
- ON DELETE CASCADE,
- name_id NUMERIC NOT NULL
- CONSTRAINT rhn_package_nid_fk
- REFERENCES rhnPackageName (id),
- evr_id NUMERIC NOT NULL
- CONSTRAINT rhn_package_eid_fk
- REFERENCES rhnPackageEvr (id),
- package_arch_id NUMERIC NOT NULL
- CONSTRAINT rhn_package_paid_fk
- REFERENCES rhnPackageArch (id),
- package_group NUMERIC
- CONSTRAINT rhn_package_group_fk
- REFERENCES rhnPackageGroup (id),
- rpm_version VARCHAR(16),
- description VARCHAR(4000),
- summary VARCHAR(4000),
- package_size NUMERIC NOT NULL,
- payload_size NUMERIC,
- installed_size NUMERIC,
- build_host VARCHAR(256),
- build_time TIMESTAMP WITHOUT TIME ZONE,
- source_rpm_id NUMERIC
- CONSTRAINT rhn_package_srcrpmid_fk
- REFERENCES rhnSourceRPM (id),
- checksum_id NUMERIC NOT NULL
- CONSTRAINT rhn_package_chsum_fk
- REFERENCES rhnChecksum (id),
- vendor VARCHAR(64) NOT NULL,
- payload_format VARCHAR(32),
- compat SMALLINT
- DEFAULT (0)
- CONSTRAINT rhn_package_compat_check
- CHECK (compat in ( 1 , 0 )),
- path VARCHAR(1000),
- header_sig VARCHAR(64),
- copyright VARCHAR(128),
- cookie VARCHAR(128),
- last_modified TIMESTAMPTZ
- DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
- created TIMESTAMPTZ
- DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
- modified TIMESTAMPTZ
- DEFAULT (CURRENT_TIMESTAMP) NOT NULL,
- header_start NUMERIC
- DEFAULT (-1) NOT NULL,
- header_end NUMERIC
- DEFAULT (-1) NOT NULL
-)
-;
-
-CREATE INDEX rhn_package_oid_id_idx
- ON rhnPackage (org_id, id);
-
-CREATE INDEX rhn_package_nid_id_idx
- ON rhnPackage (name_id, id);
-
-CREATE SEQUENCE rhn_package_id_seq;
-
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.oracle
new file mode 100644
index 0000000..b7b00b1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.oracle
@@ -0,0 +1 @@
+-- This file is intentionally left empty.
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.postgresql
new file mode 100644
index 0000000..07cccb2
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/131-rhnPackage-common.sql.postgresql
@@ -0,0 +1,7 @@
+-- oracle equivalent source sha1 b14267384bc104605623a41b755e68e0103b5aa8
+
+alter table rhnpackage alter compat type numeric(1) ;
+
+alter table rhnpackage drop constraint rhn_package_compat_check;
+alter table rhnpackage add constraint rhn_package_compat_check CHECK (compat in ( 1 , 0
));
+
commit 9b49eff1c218d6ca0fb78c95197f58b54339a1d5
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Sep 7 13:20:18 2012 +0200
Make the rhnPackage.build_time timestamp (without time zone) on both databases.
diff --git a/schema/spacewalk/oracle/tables/rhnPackage.sql
b/schema/spacewalk/oracle/tables/rhnPackage.sql
index 5f605ec..fa1b3fd 100644
--- a/schema/spacewalk/oracle/tables/rhnPackage.sql
+++ b/schema/spacewalk/oracle/tables/rhnPackage.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008--2010 Red Hat, Inc.
+-- Copyright (c) 2008--2012 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
@@ -42,7 +42,7 @@ CREATE TABLE rhnPackage
payload_size NUMBER,
installed_size NUMBER,
build_host VARCHAR2(256),
- build_time DATE,
+ build_time timestamp,
source_rpm_id NUMBER
CONSTRAINT rhn_package_srcrpmid_fk
REFERENCES rhnSourceRPM (id),
diff --git a/schema/spacewalk/postgres/tables/rhnPackage.sql
b/schema/spacewalk/postgres/tables/rhnPackage.sql
index 0bcc914..03d31d3 100644
--- a/schema/spacewalk/postgres/tables/rhnPackage.sql
+++ b/schema/spacewalk/postgres/tables/rhnPackage.sql
@@ -1,4 +1,4 @@
--- oracle equivalent source sha1 198e4f2c8e26ecf4e6dc1b1118915d5b3163ab3f
+-- oracle equivalent source sha1 ac7c0bee7e76f6823a9208a8ce3b674efb0f99d7
--
-- Copyright (c) 2008--2010 Red Hat, Inc.
--
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.oracle
new file mode 100644
index 0000000..4ae4166
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.oracle
@@ -0,0 +1,30 @@
+
+begin
+ for rec in (
+ select trigger_name
+ from user_triggers
+ where table_name = 'RHNPACKAGE'
+ ) loop
+ execute immediate 'alter trigger ' || rec.trigger_name || ' disable';
+ end loop;
+end;
+/
+
+alter table rhnPackage add orig_date date;
+update rhnPackage set orig_date = build_time;
+update rhnPackage set build_time = null;
+alter table rhnPackage modify build_time timestamp;
+update rhnPackage set build_time = orig_date;
+alter table rhnPackage drop column orig_date;
+
+begin
+ for rec in (
+ select trigger_name
+ from user_triggers
+ where table_name = 'RHNPACKAGE'
+ ) loop
+ execute immediate 'alter trigger ' || rec.trigger_name || ' enable';
+ end loop;
+end;
+/
+
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.postgresql
new file mode 100644
index 0000000..bea95a1
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/130-rhnPackage-build_time.sql.postgresql
@@ -0,0 +1,2 @@
+-- oracle equivalent source sha1 040fd923e5d8b4568372d4e19b3d2f28fb3f56b1
+-- This file is intentionally left empty.