4,7 → 4,7 |
CREATE TABLE IF NOT EXISTS brutex.tbl_events |
( |
btx_event_type VARCHAR(128) NOT NULL, |
btx_id VARCHAR(32) NOT NULL, |
btx_id VARCHAR(128) NOT NULL, |
btx_obj_type VARCHAR(32) NOT NULL, |
btx_obj_id VARCHAR(32) NOT NULL, |
btx_timestamp BIGINT NOT NULL, |
12,12 → 12,13 |
); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_key ON brutex.tbl_events (btx_obj_id, btx_obj_type, btx_event_type); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_ts ON brutex.tbl_events (btx_timestamp ASC); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_id ON brutex.tbl_events (btx_id); |
|
|
CREATE TABLE IF NOT EXISTS brutex.tbl_events_snap |
( |
btx_event_type VARCHAR(128) NOT NULL, |
btx_id VARCHAR(32) NOT NULL, |
btx_id VARCHAR(128) NOT NULL, |
btx_obj_type VARCHAR(32) NOT NULL, |
btx_obj_id VARCHAR(32) NOT NULL, |
btx_timestamp BIGINT NOT NULL, |
30,7 → 31,7 |
CREATE TABLE IF NOT EXISTS brutex.tbl_events_errors |
( |
btx_event_type VARCHAR(128) NOT NULL, |
btx_id VARCHAR(32) NOT NULL, |
btx_id VARCHAR(128) NOT NULL, |
btx_obj_type VARCHAR(32) NOT NULL, |
btx_obj_id VARCHAR(32) NOT NULL, |
btx_timestamp BIGINT NOT NULL, |
40,3 → 41,17 |
); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_ts ON brutex.tbl_events_errors (btx_timestamp ASC); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_retry ON brutex.tbl_events_errors (btx_retry); |
|
CREATE TABLE IF NOT EXISTS brutex.tbl_events_all |
( |
btx_event_type VARCHAR(128) NOT NULL, |
btx_id VARCHAR(128) NOT NULL, |
btx_obj_type VARCHAR(32) NOT NULL, |
btx_obj_id VARCHAR(32) NOT NULL, |
btx_timestamp BIGINT NOT NULL, |
btx_supersed_id VARCHAR(128), |
btx_event CLOB |
); |
|
CREATE INDEX IF NOT EXISTS brutex.btx_idx_ssed ON brutex.tbl_events_all (btx_supersed_id); |
CREATE INDEX IF NOT EXISTS brutex.btx_idx_ts ON brutex.tbl_events_all (btx_timestamp ASC); |