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@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'));