schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/150-rhnConfigInfo_selinux.sql | 48 ++++++++++ 1 file changed, 48 insertions(+)
New commits: commit 074cca0508e8d6b4817453f45b2bfada62ed8623 Author: Joshua Roys joshua.roys@gtri.gatech.edu Date: Mon Aug 3 13:25:08 2009 -0400
upgrade script for the previous commit. Patch from Joshua Roys
diff --git a/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/150-rhnConfigInfo_selinux.sql b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/150-rhnConfigInfo_selinux.sql new file mode 100644 index 0000000..f348e11 --- /dev/null +++ b/schema/spacewalk/upgrade/spacewalk-schema-0.5-to-spacewalk-schema-0.6/150-rhnConfigInfo_selinux.sql @@ -0,0 +1,48 @@ +-- +-- Add in a column for selinux context +-- + +ALTER TABLE rhnConfigInfo + ADD selinux_ctx VARCHAR(64); + +DROP INDEX RHN_CONFINFO_UGF_UQ; + +CREATE UNIQUE INDEX rhn_confinfo_ugf_uq + ON rhnConfigInfo( username, groupname, filemode, selinux_ctx ) + tablespace [[4m_tbs]] + ; + +CREATE OR REPLACE FUNCTION +lookup_config_info ( + username_in IN VARCHAR2, + groupname_in IN VARCHAR2, + filemode_in IN VARCHAR2, + selinux_ctx_in IN VARCHAR2 +) RETURN NUMBER +DETERMINISTIC +IS + PRAGMA AUTONOMOUS_TRANSACTION; + v_id NUMBER; + CURSOR lookup_cursor IS + SELECT id + FROM rhnConfigInfo + WHERE 1=1 + AND username = username_in + AND groupname = groupname_in + AND filemode = filemode_in + AND selinux_ctx = selinux_ctx_in; +BEGIN + FOR r IN lookup_cursor LOOP + RETURN r.id; + END LOOP; + -- If we got here, we don't have the id + SELECT rhn_confinfo_id_seq.nextval + INTO v_id + FROM dual; + INSERT INTO rhnConfigInfo (id, username, groupname, filemode, selinux_ctx) + VALUES (v_id, username_in, groupname_in, filemode_in, selinux_ctx_in); + COMMIT; + RETURN v_id; +END lookup_config_info; +/ +show errors
spacewalk-commits@lists.fedorahosted.org