title: SQLite default values to boolean column, not working as expected
body: <p>I have one <code>SQLite</code> Table with following entity:</p>
  
  <pre><code>[Table ("employee")]
  public class Employees
  {
      [Column ("employee_id")]
      [PrimaryKey]
      public int EmployeeId { get; set; }
  
      [Column ("username")]
      public string UserName { get; set; }
  
      [Column ("password")]
      public string Password { get; set; }
  
      [Column ("first_name")]
      public string FirstName { get; set; }
  
      [Column ("last_name")]
      public string LastName { get; set; }
  
      [Column ("is_wah_allowed")] //Newly added Column
      public bool IsWAHAllowed { get; set; }  
  }
  </code></pre>
  
  <p>When App starts, I am creating a Table.</p>
  
  <pre><code>conn.CreateTable&lt;Employees&gt;();
  </code></pre>
  
  <p>I want to add new boolean column with default value set to 0 - false in <code>SQLite</code> as it stores bool as 0 or 1.</p>
  
  <p>I tried it following ways:</p>
  
  <p><strong>Case 1 :</strong></p>
  
  <pre><code>[Column ("is_wah_allowed")] //Newly added Column
  </code></pre>
  
  <p>Output : This shows Null into DB Browser for SQLite</p>
  
  <p><strong>Case 2 :</strong></p>
  
  <pre><code>[Column ("is_wah_allowed"), Default (false)] //Newly added Column
  </code></pre>
  
  <p>Output : This throws exception at conn.CreateTable(); - Can not convert from bool to int.</p>
  
  <p><strong>Case 3 :</strong></p>
  
  <pre><code>[Column ("is_wah_allowed"), Default (value : 0)] //Newly added Column
  </code></pre>
  
  <p>Output : This shows False values into DB Browser for SQLite, instead of 0.
  When server returns me data, I save/update them and then it shows them as 0 or 1 in updated rows, because server handle this as integer values.</p>
  
  <p>I want to know :</p>
  
  <p>Case 1 : Why it shows Null instead of 0 default value?</p>
  
  <p>Case 2 : Why it throws exception?</p>
  
  <p>Case 3 : Why it shows False instead of 0?</p>
  
  <p>Thanks in advance!!</p>