title: SQLite:"ALTER TABLE `game` ADD UNIQUE(`name`)" Error in SQLite
body: <p>I used the same command syntax above as in Mysql  and would like set a unique key for the tables's filed on Android Device environment, however, the error prompted in LogCat:  </p>
  
  <blockquote>
    <p>03-23 16:16:45.580: E/Database(657): Failure 1 (near "UNIQUE": syntax
    error) on 0x2c0240 when preparing 'ALTER TABLE <code>game</code> ADD
    UNIQUE(<code>name</code>);'.</p>
  </blockquote>
  
  <p>Checking the SQLite's doc, it seems that SQLite does not use this way for setting a unique key. Does anyboy know to do it ? Thanks for response inadvance !</p>