summaryrefslogtreecommitdiff
path: root/maintenance/ibm_db2/patch-log_search-rename-index.sql
blob: a6a696e1d1d842bbae9f91492d6f05dfe526c285 (plain)
1
2
3
4
5
6
7
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
);