schema/spacewalk/common/tables/web_contact.sql
| 6 +++++-
schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/027-web_contact-ro.sql
| 3 +++
2 files changed, 8 insertions(+), 1 deletion(-)
New commits:
commit d92a0433d633ac097740ce526b69c138107ff579
Author: Milan Zazrivec <mzazrivec(a)redhat.com>
Date: Tue Jul 2 14:22:59 2013 +0200
Spacewalk user: add read_only flag
diff --git a/schema/spacewalk/common/tables/web_contact.sql
b/schema/spacewalk/common/tables/web_contact.sql
index 31ff5dd..c3c23fd 100644
--- a/schema/spacewalk/common/tables/web_contact.sql
+++ b/schema/spacewalk/common/tables/web_contact.sql
@@ -38,7 +38,11 @@ CREATE TABLE web_contact
ignore_flag CHAR(1)
DEFAULT ('N') NOT NULL
CONSTRAINT web_contact_ignore_ck
- CHECK (ignore_flag in ('N','Y'))
+ CHECK (ignore_flag in ('N','Y')),
+ read_only char(1)
+ default ('N') not null
+ constraint web_contact_ro_ck
+ check (read_only in ('Y', 'N'))
)
TABLESPACE [[web_tablespace_2]]
ENABLE ROW MOVEMENT
diff --git
a/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/027-web_contact-ro.sql
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/027-web_contact-ro.sql
new file mode 100644
index 0000000..e8b67bb
--- /dev/null
+++
b/schema/spacewalk/upgrade/spacewalk-schema-1.9-to-spacewalk-schema-1.10/027-web_contact-ro.sql
@@ -0,0 +1,3 @@
+alter table web_contact
+ add read_only char(1) default('N') not null
+ constraint web_contact_ro_ck check (read_only in ('Y', 'N'));
Show replies by date