title: How to Add a Boolean Column in Android SQlite
body: <p>I have created a table for my  <code>ContentProvider</code> using the following line :</p>
  
  <pre><code>static final String CREATE_DB_TABLE = 
    " CREATE TABLE " + CONTACTS_TABLE_NAME +
    " (_id INTEGER PRIMARY KEY AUTOINCREMENT, " + 
    " pid TEXT NOT NULL, " +
    " name TEXT NOT NULL,"+
    "number TEXT NOT NULL);";
  </code></pre>
  
  <p>It has 4 columns. Now i want to add a column with a boolean value of true/false. How can i add append/change this statement if i have to add a <strong>boolean</strong> column named <strong>"status"</strong>.</p>