github.com/kaleido-io/firefly@v0.0.0-20210622132723-8b4b6aacb971/db/migrations/ql/000003_create_message_data_join_table.up.sql (about) 1 CREATE TABLE messages_data ( 2 message_id string NOT NULL, 3 data_id string NOT NULL, 4 data_hash string NOT NULL, 5 data_idx int64 NOT NULL 6 ); 7 8 CREATE UNIQUE INDEX messages_data_primary ON messages_data(message_id,data_id)