Patches for Spacewalk / SaltStack

rhnActionSaltJob.diff

From 0f1a58af683b7fdfff1f7a71defa883a8ab5d9da Mon Sep 17 00:00:00 2001
From: Johannes Renner <[email protected]>
Date: Tue, 14 Jul 2015 13:14:30 +0200
Subject: [PATCH] Database changes to enable the tracking of salt jobs

- create table rhnActionSaltJob
- insert action type salt.job
---
 schema/spacewalk/common/data/rhnActionType.sql     |  1 +
 .../spacewalk/common/tables/rhnActionSaltJob.sql   | 41 ++++++++++++++++++++++
 2 files changed, 42 insertions(+)
 create mode 100644 schema/spacewalk/common/tables/rhnActionSaltJob.sql

diff --git a/schema/spacewalk/common/data/rhnActionType.sql b/schema/spacewalk/common/data/rhnActionType.sql
index db62db4..23bbd00 100644
--- a/schema/spacewalk/common/data/rhnActionType.sql
+++ b/schema/spacewalk/common/data/rhnActionType.sql
@@ -74,6 +74,7 @@ insert into rhnActionType values (51, 'clientcert.update_client_cert', 'Update C
 insert into rhnActionType values (500, 'image.deploy', 'Deploy an image to a virtual host.', 'N', 'N');
 insert into rhnActionType values (501, 'distupgrade.upgrade', 'Service Pack Migration', 'N', 'N');
 insert into rhnActionType values (502, 'packages.setLocks', 'Lock packages', 'N', 'N');
+insert into rhnActionType values (503, 'salt.job', 'Salt Job', 'N', 'N');
 --
 --
 -- Revision 1.25  2004/10/29 05:07:52  pjones
diff --git a/schema/spacewalk/common/tables/rhnActionSaltJob.sql b/schema/spacewalk/common/tables/rhnActionSaltJob.sql
new file mode 100644
index 0000000..80c0d3d
--- /dev/null
+++ b/schema/spacewalk/common/tables/rhnActionSaltJob.sql
@@ -0,0 +1,41 @@
+--
+-- Copyright (c) 2015 SUSE LLC
+--
+-- This software is licensed to you under the GNU General Public License,
+-- version 2 (GPLv2). There is NO WARRANTY for this software, express or
+-- implied, including the implied warranties of MERCHANTABILITY or FITNESS
+-- FOR A PARTICULAR PURPOSE. You should have received a copy of GPLv2
+-- along with this software; if not, see
+-- http://www.gnu.org/licenses/old-licenses/gpl-2.0.txt.
+--
+-- Red Hat trademarks are not licensed under GPLv2. No permission is
+-- granted to use or replicate Red Hat trademarks that are incorporated
+-- in this software or its documentation.
+--
+
+CREATE TABLE rhnActionSaltJob
+(
+    action_id        NUMBER NOT NULL
+                         CONSTRAINT rhn_act_saltjob_act_fk
+                             REFERENCES rhnAction (id)
+                             ON DELETE CASCADE,
+    jid              VARCHAR2(2048) NOT NULL,
+    data             BLOB
+)
+TABLESPACE [[blob]]
+ENABLE ROW MOVEMENT
+;
+
+CREATE UNIQUE INDEX rhn_act_saltjob_aid_idx
+    ON rhnActionSaltJob (action_id)
+    TABLESPACE [[4m_tbs]]
+    NOLOGGING;
+
+ALTER TABLE rhnActionSaltJob
+    ADD CONSTRAINT rhn_saltjob_aid_pk PRIMARY KEY (action_id);
+
+CREATE INDEX rhn_act_saltjob_jid_idx
+    ON rhnActionSaltJob (jid)
+    TABLESPACE [[4m_tbs]]
+    NOLOGGING;
+
-- 
2.4.5