schema/spacewalk/common/tables/rhnISSSlave.sql
| 2 +-
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/022-rhnISSSlave.sql
| 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
New commits:
commit b9947816810a883fb9d7dd150282557736a8407c
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Thu Jun 27 09:49:13 2013 +0200
fix sql syntax
diff --git a/schema/spacewalk/common/tables/rhnISSSlave.sql
b/schema/spacewalk/common/tables/rhnISSSlave.sql
index 36f9838..1e60d26 100644
--- a/schema/spacewalk/common/tables/rhnISSSlave.sql
+++ b/schema/spacewalk/common/tables/rhnISSSlave.sql
@@ -2,7 +2,7 @@
create table rhnISSSlave (
id number not null constraint rhn_isss_id_pk primary key,
slave varchar2(512) not null constraint rhn_isss_name_uq unique,
- enabled char(1) not null default 'Y',
+ enabled char(1) default 'Y' not null
constraint rhn_isss_enabled_yn check (enabled in ( 'Y', 'N' )),
allow_all_orgs char(1) not null default 'Y',
constraint rhn_isss_allorgs_yn check (allow_all_orgs in ( 'Y', 'N' )),
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/022-rhnISSSlave.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/022-rhnISSSlave.sql
index dfd56e4..3cbaa7c 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/022-rhnISSSlave.sql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/022-rhnISSSlave.sql
@@ -1,7 +1,7 @@
create table rhnISSSlave (
id number not null constraint rhn_isss_id_pk primary key,
slave varchar2(512) not null constraint rhn_isss_name_uq unique,
- enabled char(1) not null default 'Y',
+ enabled char(1) default 'Y' not null
constraint rhn_isss_enabled_yn check (enabled in ( 'Y', 'N' )),
allow_all_orgs char(1) not null default 'Y',
constraint rhn_isss_allorgs_yn check (allow_all_orgs in ( 'Y',
'N' )),
Show replies by date