title: SQLite table constraint - unique on multiple columns
body: <p>I can find syntax "charts" on this on the SQLite website, but no examples and my code is crashing. I have other tables with unique constraints on a single column, but I want to add a constraint to the table on two columns.  This is what I have that is causing an SQLiteException with the message "syntax error".</p>
  
  <pre><code>CREATE TABLE name (column defs) 
  UNIQUE (col_name1, col_name2) ON CONFLICT REPLACE
  </code></pre>
  
  <p>I'm doing this based on the following:</p>
  
  <p><a href="http://www.sqlite.org/syntaxdiagrams.html#table-constraint" rel="noreferrer">table-constraint</a></p>
  
  <p>To be clear, the documentation on the link I provided says that <code>CONTSTRAINT name</code> should come before my constraint definition.</p>
  
  <p>Something that may lead to the solution though is that whatever follows my parenthesized column definitions is what the debugger complains about.</p>
  
  <p>If I put </p>
  
  <pre><code>...last_column_name last_col_datatype) CONSTRAINT ...
  </code></pre>
  
  <p>the error is <strong>near "CONSTRAINT": syntax error</strong></p>
  
  <p>If I put </p>
  
  <pre><code>...last_column_name last_col_datatype) UNIQUE ...
  </code></pre>
  
  <p>the error is <strong>near "UNIQUE": syntax error</strong></p>