schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSoourceType.sql | 46 -------- schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql | 46 ++++++++ schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSoource.sql | 57 ---------- schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql | 57 ++++++++++ 4 files changed, 103 insertions(+), 103 deletions(-)
New commits: commit 8e09c300d95336fa21d31f3ffbddfceda470f207 Author: Justin Sherrill jsherril@redhat.com Date: Mon Aug 3 14:19:14 2009 -0400
fixing small typo in upgrade script names
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSoourceType.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSoourceType.sql deleted file mode 100644 index 546a3e1..0000000 --- a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSoourceType.sql +++ /dev/null @@ -1,46 +0,0 @@ --- --- Copyright (c) 2008 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 -rhnContentSourceType -( - id number - constraint rhn_cst_id_nn not null - constraint rhn_cst_id_pk primary key, - label varchar2(32) - constraint rhn_cst_label_nn not null - constraint rhn_cst_label_uq unique, - created date default(sysdate) - constraint rhn_cst_created_nn not null, - modified date default(sysdate) - constraint rhn_cst_modified_nn not null -) - enable row movement - ; - -create sequence rhn_content_source_type_id_seq start with 500; - -create index rhn_ccst_id_l_idx - on rhnContentSourceType(id,label) - tablespace [[64k_tbs]] - ; - - -insert into rhnContentSourceType (id, label) values -(rhn_content_source_type_id_seq.nextval, 'yum'); - diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql new file mode 100644 index 0000000..546a3e1 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/191-rhnContentSourceType.sql @@ -0,0 +1,46 @@ +-- +-- Copyright (c) 2008 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 +rhnContentSourceType +( + id number + constraint rhn_cst_id_nn not null + constraint rhn_cst_id_pk primary key, + label varchar2(32) + constraint rhn_cst_label_nn not null + constraint rhn_cst_label_uq unique, + created date default(sysdate) + constraint rhn_cst_created_nn not null, + modified date default(sysdate) + constraint rhn_cst_modified_nn not null +) + enable row movement + ; + +create sequence rhn_content_source_type_id_seq start with 500; + +create index rhn_ccst_id_l_idx + on rhnContentSourceType(id,label) + tablespace [[64k_tbs]] + ; + + +insert into rhnContentSourceType (id, label) values +(rhn_content_source_type_id_seq.nextval, 'yum'); + diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSoource.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSoource.sql deleted file mode 100644 index ccf5cb8..0000000 --- a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSoource.sql +++ /dev/null @@ -1,57 +0,0 @@ --- --- Copyright (c) 2008 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 -rhnChannelContentSource -( - id number - constraint rhn_ccs_id_nn not null - constraint rhn_ccs_id_pk primary key, - channel_id number - constraint rhn_ccs_c_nn not null - constraint rhn_ccs_c_fk - references rhnChannel(id) on delete cascade, - type_id number - constraint rhn_ccs_type_nn not null - constraint rhn_ccs_type_fk - references rhnContentSourceType(id), - source_url varchar2(512) - constraint rhn_ccs_url_nn not null, - label varchar2(64) - constraint rhn_ccs_l_nn not null, - last_synced date, - created date default(sysdate) - constraint rhn_ccs_cre_nn not null, - modified date default(sysdate) - constraint rhn_ccs_mod_nn not null -) - enable row movement - ; - - -create sequence rhn_chan_content_src_id_seq start with 500; - - -create unique index rhn_ccs_uq - on rhnChannelContentSource(channel_id, type_id, source_url) - tablespace [[64k_tbs]] - ; - -/ -show errors - diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql new file mode 100644 index 0000000..ccf5cb8 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/192-rhnChannelContentSource.sql @@ -0,0 +1,57 @@ +-- +-- Copyright (c) 2008 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 +rhnChannelContentSource +( + id number + constraint rhn_ccs_id_nn not null + constraint rhn_ccs_id_pk primary key, + channel_id number + constraint rhn_ccs_c_nn not null + constraint rhn_ccs_c_fk + references rhnChannel(id) on delete cascade, + type_id number + constraint rhn_ccs_type_nn not null + constraint rhn_ccs_type_fk + references rhnContentSourceType(id), + source_url varchar2(512) + constraint rhn_ccs_url_nn not null, + label varchar2(64) + constraint rhn_ccs_l_nn not null, + last_synced date, + created date default(sysdate) + constraint rhn_ccs_cre_nn not null, + modified date default(sysdate) + constraint rhn_ccs_mod_nn not null +) + enable row movement + ; + + +create sequence rhn_chan_content_src_id_seq start with 500; + + +create unique index rhn_ccs_uq + on rhnChannelContentSource(channel_id, type_id, source_url) + tablespace [[64k_tbs]] + ; + +/ +show errors +
spacewalk-commits@lists.fedorahosted.org