vitess.io/vitess@v0.16.2/examples/compose/tables/lookup_keyspace_schema_file.sql (about)

     1  CREATE TABLE tokens_token_lookup (
     2    id BIGINT NOT NULL AUTO_INCREMENT,
     3    page BIGINT UNSIGNED,
     4    token VARCHAR(255) DEFAULT NULL,
     5    PRIMARY KEY (id),
     6    UNIQUE KEY idx_token_page (`token`, `page`)
     7  ) ENGINE=InnoDB;
     8  
     9  CREATE TABLE messages_message_lookup (
    10    id BIGINT NOT NULL AUTO_INCREMENT,
    11    page BIGINT UNSIGNED,
    12    message VARCHAR(1000),
    13    PRIMARY KEY (id),
    14    UNIQUE KEY idx_message_page (`message`, `page`)
    15  ) ENGINE=InnoDB;
    16