@Test
public void testCreateTableDefinition() {

    String expectedSql = "CREATE TABLE IF NOT EXISTS `FullTestModel` (`id` INTEGER PRIMARY KEY AUTOINCREMENT, " +
            "`booleanField` INTEGER, `dateField` INTEGER, `doubleField` REAL, `intField` INTEGER, `stringField` " +
            "TEXT COLLATE BINARY UNIQUE ON CONFLICT IGNORE, UNIQUE (`dateField`, `doubleField`) ON CONFLICT FAIL, " +
            "UNIQUE (`booleanField`, `intField`) ON CONFLICT ROLLBACK);";
    TableInfo testModelTableInfo = ReActiveAndroid.getTableInfo(FullTestModel.class);
    assertEquals(expectedSql, SQLiteUtils.createTableDefinition(testModelTableInfo));
}