1 files changed, 17 insertions, 0 deletions
diff --git a/maintenance/ibm_db2/patch-log_user_text.sql b/maintenance/ibm_db2/patch-log_user_text.sql
new file mode 100644
index 00000000..3534057a
--- /dev/null
+++ b/maintenance/ibm_db2/patch-log_user_text.sql
@@ -0,0 +1,17 @@
+CREATE TABLE logging (
+  log_id			BIGINT      NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
+  --PRIMARY KEY DEFAULT nextval('log_log_id_seq'),
+  log_type			VARCHAR(32)         NOT NULL,
+  log_action		VARCHAR(32)         NOT NULL,
+  log_timestamp		TIMESTAMP(3)  NOT NULL,
+  log_user			BIGINT NOT NULL DEFAULT 0,
+  --                REFERENCES user(user_id) ON DELETE SET NULL,
+  -- Name of the user who performed this action
+  log_user_text		VARCHAR(255) NOT NULL default '',
+  log_namespace		SMALLINT     NOT NULL,
+  log_title			VARCHAR(255)         NOT NULL,
+  log_page			BIGINT,
+  log_comment		VARCHAR(255),
+  log_params		CLOB(64K) INLINE LENGTH 4096,
+  log_deleted		SMALLINT     NOT NULL DEFAULT 0
+);