Fix and initial tests for bigint

In sqlite a primary autoincrement id must be defined as INTEGER. Otherwise the following error raises:
```OperationalError: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY```
As stated here http://www.sqlite.org/autoinc.html the field will still be a 64-bit signed integer.