Signed-off-by: Richard Marko <rma...@redhat.com> --- schema/spacewalk/common/tables/rhnAbrtInfo.sql | 29 +++++++++++++++++++ .../111-rhnAbrtInfo_create.sql.oracle | 30 ++++++++++++++++++++ .../111-rhnAbrtInfo_create.sql.postgresql | 30 ++++++++++++++++++++ 3 files changed, 89 insertions(+) create mode 100644 schema/spacewalk/common/tables/rhnAbrtInfo.sql create mode 100644 schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.oracle create mode 100644 schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.postgresql
diff --git a/schema/spacewalk/common/tables/rhnAbrtInfo.sql b/schema/spacewalk/common/tables/rhnAbrtInfo.sql new file mode 100644 index 0000000..3e433c2 --- /dev/null +++ b/schema/spacewalk/common/tables/rhnAbrtInfo.sql @@ -0,0 +1,29 @@ +-- +-- Copyright (c) 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 rhnAbrtInfo +( + id NUMBER NOT NULL, + server_id NUMBER NOT NULL + CONSTRAINT rhn_abrt_info_srvr_fk + REFERENCES rhnServer (id) + ON DELETE CASCADE, + num_crashes NUMBER NOT NULL, + created DATE NOT NULL +) +ENABLE ROW MOVEMENT +; + +CREATE SEQUENCE rhn_abrt_info_id_seq; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.oracle b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.oracle new file mode 100644 index 0000000..84d9824 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.oracle @@ -0,0 +1,30 @@ +-- +-- Copyright (c) 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 rhnAbrtInfo +( + id NUMBER NOT NULL + CONSTRAINT rhn_abrt_info_pk PRIMARY KEY, + server_id NUMBER NOT NULL + CONSTRAINT rhn_abrt_info_srvr_fk + REFERENCES rhnServer (id) + ON DELETE CASCADE, + num_crashes NUMBER NOT NULL, + created DATE NOT NULL +) +ENABLE ROW MOVEMENT +; + +CREATE SEQUENCE rhn_abrt_info_id_seq; diff --git a/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.postgresql b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.postgresql new file mode 100644 index 0000000..c2c9343 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-1.7-to-spacewalk-schema-1.8/111-rhnAbrtInfo_create.sql.postgresql @@ -0,0 +1,30 @@ +-- +-- Copyright (c) 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 rhnAbrtInfo +( + id NUMERIC NOT NULL + CONSTRAINT rhn_abrt_info_pk PRIMARY KEY, + server_id NUMERIC NOT NULL + CONSTRAINT rhn_abrt_info_srvr_fk + REFERENCES rhnServer (id) + ON DELETE CASCADE, + num_crashes NUMERIC NOT NULL, + created TIMESTAMPTZ NOT NULL +) + +; + +CREATE SEQUENCE rhn_abrt_info_id_seq; -- 1.7.10.4 _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel