title: How do I add multiple unique keys in a table using memsql?
body: <p>Using MemSQL I want to create a table which has multiple unique keys and 1 primary key in it. But I don't know how do I add multiple unique keys in table. This is my table:</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `user_auth` (
    `id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) NOT NULL,
    `code` char(36) NOT NULL,
    `rest_code` char(36) NOT NULL,
    `password` varchar(100) NOT NULL,
    `pswd_updated_on` datetime NOT NULL,
    PRIMARY KEY (`id`)
  );
  </code></pre>
  
  <p>And I wanted add unique key on <code>user_id,code,rest_code</code> columns.</p>