xref: /plugin/combo/db/combo-secondary/update0003.sql (revision 04fd306c7c155fa133ebb3669986875d65988276)

drop TABLE EVENTS_QUEUE;

-- Event Queue table
CREATE TABLE EVENTS_QUEUE
(
    NAME      TEXT,     -- Name
    DATA      TEXT,     -- JSON
    DATA_HASH TEXT,     -- JSON Hash
    TIMESTAMP TIMESTAMP, -- Timestamp creation,
    constraint pk_events_queue primary key (NAME, DATA_HASH)
);