title: Using Navicat to create a Key on 2 column
body: <p>I can create a Primary Key using Navicat in the <code>Design Table</code> section of the software. However, I cannot seem to create a key on 2 columns, which in MySQL statements will be something like</p>
  
  <pre><code>CREATE TABLE casting(movieid INTEGER,
                   actorid INTEGER,
                   PRIMARY KEY (movieid, actorid)
                   )
  </code></pre>
  
  <p>Can it be done using the GUI in Navicat? Or must I write the query manually and run it.</p>