Allowing sqlite unsigned

[0xpr03]

Versions

• Rust: 1.29.2
• Diesel: 1.3.3
• Database: sqlite
• Operating System linux

Problem Description

I can't describe unsigned integers in diesel for sqlite, although I'm trying to access an existing DB with unsigned integer. (Called integerunsigned by SQliteBrowser)

What are you trying to accomplish?

Access unsigned integers in sqlite.

Steps to reproduce

db.rs:

let connection =
            SqliteConnection::establish("mydb.db").expect("Csn't rach db");
        let result = General
            .load::<GeneralEntry>(&connection)
            .expect("Can't query db settings");

schema.rs:

table! {
    General(key) {
        key -> VarChar,
        timestamp -> Unsigned<Integer>,
        value -> VarChar,
    }
}

models.rs:

use schema::General;

#[derive(Queryable)]
pub struct GeneralEntry {
    pub timestamp: u32,
    pub key: String,
    pub value: String,
}

#[derive(Insertable)]
#[table_name = "General"]
pub struct NewGeneral<'a> {
    pub timestamp: u32,
    pub key: &'a str,
    pub value: &'a str,
}

Output rustc:

.load::<GeneralEntry>(&connection)
    |              ^^^^ the trait `diesel::sql_types::HasSqlType<diesel::sql_types::Unsigned<diesel::sql_types::Integer>>` is not implemented for `diesel::sqlite::Sqlite`

Checklist

• I have already looked over the issue tracker for similar issues.
• This issue can be reproduced on Rust's stable channel. (Your issue will be
  closed if this is not the case)