summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-log_search.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/ibm_db2/patch-log_search.sql')
-rw-r--r--maintenance/ibm_db2/patch-log_search.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/maintenance/ibm_db2/patch-log_search.sql b/maintenance/ibm_db2/patch-log_search.sql
new file mode 100644
index 00000000..a6a696e1
--- /dev/null
+++ b/maintenance/ibm_db2/patch-log_search.sql
@@ -0,0 +1,8 @@
+CREATE TABLE log_search (
+ -- The type of ID (rev ID, log ID, rev TIMESTAMP(3), username)
+ ls_field VARCHAR(32) FOR BIT DATA NOT NULL,
+ -- The value of the ID
+ ls_value varchar(255) NOT NULL,
+ -- Key to log_id
+ ls_log_id BIGINT NOT NULL default 0
+);