title: Using SQLite how do I index columns in a CREATE TABLE statement?
body: <p>How do I index a column in my CREATE TABLE statement? The table looks like</p>
  
  <pre><code>command.CommandText =
      "CREATE TABLE if not exists file_hash_list( " +
          "id    INTEGER PRIMARY KEY, " +
          "hash  BLOB NOT NULL, " +
          "filesize INTEGER NOT NULL);";
  command.ExecuteNonQuery();
  </code></pre>
  
  <p>I want filesize to be index and would like it to be 4 bytes</p>