schema/spacewalk/common/tables/web_customer.sql
| 4 +++-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.oracle
| 3 ++-
schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.postgresql
| 5 +++--
3 files changed, 8 insertions(+), 4 deletions(-)
New commits:
commit 06954f718dcfcd8891f7177486e2cfedb1910b27
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Feb 26 11:07:16 2013 +0100
abrt: check the allowed filesize limit is >= 0
diff --git a/schema/spacewalk/common/tables/web_customer.sql
b/schema/spacewalk/common/tables/web_customer.sql
index 945eeef..4319c14 100644
--- a/schema/spacewalk/common/tables/web_customer.sql
+++ b/schema/spacewalk/common/tables/web_customer.sql
@@ -25,7 +25,9 @@ CREATE TABLE web_customer
CONSTRAINT web_customer_stage_content_chk
CHECK (staging_content_enabled in ( 'Y' ,
'N' )),
crash_file_sizelimit number
- default(2048) not null,
+ default(2048) not null
+ constraint web_customer_sizelimit_chk
+ check (crash_file_sizelimit >= 0),
created timestamp with local time zone
DEFAULT (current_timestamp) NOT NULL,
modified timestamp with local time zone
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.oracle
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.oracle
index 9c8671d..66f6eea 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.oracle
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.oracle
@@ -1,3 +1,4 @@
alter table web_customer
add crash_file_sizelimit
- number default(2048) not null;
+ number default(2048) not null
+ constraint web_customer_sizelimit_chk check (crash_file_sizelimit >= 0);
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.postgresql
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.postgresql
index e835afd..1b482ed 100644
---
a/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.postgresql
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.8-to-spacewalk-schema-1.9/019-web_customer.sql.postgresql
@@ -1,5 +1,6 @@
--- oracle equivalent source sha1 98e82b03e86d16d0b335f306e17344e97383223c
+-- oracle equivalent source sha1 bd2fd82dec1fb797dd7aede1a0f6e8884d68c01d
alter table web_customer
add crash_file_sizelimit
- numeric default(2048) not null;
+ numeric default(2048) not null
+ constraint web_customer_sizelimit_chk check (crash_file_sizelimit >= 0);
Show replies by date