diff options
Diffstat (limited to 'maintenance/ibm_db2/patch-log_search.sql')
-rw-r--r-- | maintenance/ibm_db2/patch-log_search.sql | 8 |
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 +); |