schema/spacewalk/common/tables/rhnContentSource.sql | 4 +---
schema/spacewalk/common/tables/rhnKSData.sql | 3 +--
schema/spacewalk/common/tables/rhn_current_state_summaries.sql | 4 ++--
3 files changed, 4 insertions(+), 7 deletions(-)
New commits:
commit 1a50846a7a445bac96c2f232dbb08e03ce9cfdaf
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jul 30 14:28:06 2010 +0200
The slash is not needed as it causes the create index command to be run for the second time, during raw db population.
diff --git a/schema/spacewalk/common/tables/rhnContentSource.sql b/schema/spacewalk/common/tables/rhnContentSource.sql
index 479bae8..347aa12 100644
--- a/schema/spacewalk/common/tables/rhnContentSource.sql
+++ b/schema/spacewalk/common/tables/rhnContentSource.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- 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
@@ -44,9 +44,3 @@ create unique index rhn_cs_uq
tablespace [[64k_tbs]]
;
-/
-
---
--- Revision 1.0 2009/06/26 21:54 jlsherrill
--- Initial file.
---
commit 6f37477e41aca9e9ef04007a6f6df1168b10a4e9
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jul 30 14:26:52 2010 +0200
Underscore is not valid syntax during raw db population.
diff --git a/schema/spacewalk/common/tables/rhn_current_state_summaries.sql b/schema/spacewalk/common/tables/rhn_current_state_summaries.sql
index 49aee46..84c7be4 100644
--- a/schema/spacewalk/common/tables/rhn_current_state_summaries.sql
+++ b/schema/spacewalk/common/tables/rhn_current_state_summaries.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- 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
@@ -16,7 +16,7 @@
CREATE TABLE rhn_current_state_summaries
(
- customer_id NUMBER(12)_ NOT NULL,
+ customer_id NUMBER(12) NOT NULL,
template_id VARCHAR2(10) NOT NULL,
state VARCHAR2(20) NOT NULL,
state_count NUMBER(9),
commit 62b425aaef44c1f9ce037ae7478007a18e93a65a
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Fri Jul 30 14:26:02 2010 +0200
Empty line in the create table command causes error during raw db population.
diff --git a/schema/spacewalk/common/tables/rhnKSData.sql b/schema/spacewalk/common/tables/rhnKSData.sql
index 176519f..576014b 100644
--- a/schema/spacewalk/common/tables/rhnKSData.sql
+++ b/schema/spacewalk/common/tables/rhnKSData.sql
@@ -1,5 +1,5 @@
--
--- Copyright (c) 2008 Red Hat, Inc.
+-- 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
@@ -64,7 +64,6 @@ CREATE TABLE rhnKSData
DEFAULT (sysdate) NOT NULL,
modified DATE
DEFAULT (sysdate) NOT NULL,
-
CONSTRAINT rhn_ks_type_ck
CHECK (ks_type in ( 'wizard' , 'raw' ))
)