title: Does UNIQUE automatically add an index?
body: <p>Or do I have to create index manually?</p>
  
  <pre><code>CREATE TABLE pages(
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    stitle TEXT UNIQUE,
    parent INTEGER,
    FOREIGN KEY(parent) REFERENCES pages(id) ON DELETE CASCADE
  );
  </code></pre>
  
  <p>So I should have 2 indexes, right? id and stitle</p>