@Test
public void onCreate() {

    final TableDefaultsCustomizer customizer = mock(TableDefaultsCustomizer.class);
    mReceiptsTable.onCreate(mSQLiteDatabase, customizer);
    verify(mSQLiteDatabase).execSQL(mSqlCaptor.capture());
    verifyZeroInteractions(customizer);
    final String creatingTable = mSqlCaptor.getValue();
    assertTrue(creatingTable.contains("CREATE TABLE receipts"));
    assertTrue(creatingTable.contains("id INTEGER PRIMARY KEY AUTOINCREMENT"));
    assertTrue(creatingTable.contains("path TEXT"));
    assertTrue(creatingTable.contains("name TEXT"));
    assertTrue(creatingTable.contains("parentKey INTEGER"));
    assertTrue(creatingTable.contains("categoryKey INTEGER"));
    assertTrue(creatingTable.contains("price DECIMAL(10, 2)"));
    assertTrue(creatingTable.contains("tax DECIMAL(10, 2)"));
    assertTrue(creatingTable.contains("tax2 DECIMAL(10, 2)"));
    assertTrue(creatingTable.contains("exchange_rate DECIMAL(10, 10)"));
    assertTrue(creatingTable.contains("rcpt_date DATE"));
    assertTrue(creatingTable.contains("timezone TEXT"));
    assertTrue(creatingTable.contains("comment TEXT"));
    assertTrue(creatingTable.contains("expenseable BOOLEAN"));
    assertTrue(creatingTable.contains("isocode TEXT"));
    assertTrue(creatingTable.contains("paymentMethodKey INTEGER"));
    assertTrue(creatingTable.contains("fullpageimage BOOLEAN"));
    assertTrue(creatingTable.contains("receipt_processing_status TEXT"));
    assertTrue(creatingTable.contains("extra_edittext_1 TEXT"));
    assertTrue(creatingTable.contains("extra_edittext_2 TEXT"));
    assertTrue(creatingTable.contains("extra_edittext_3 TEXT"));
    assertTrue(creatingTable.contains("drive_sync_id TEXT"));
    assertTrue(creatingTable.contains("drive_is_synced BOOLEAN DEFAULT 0"));
    assertTrue(creatingTable.contains("drive_marked_for_deletion BOOLEAN DEFAULT 0"));
    assertTrue(creatingTable.contains("last_local_modification_time DATE"));
    assertTrue(creatingTable.contains("custom_order_id INTEGER DEFAULT 0"));
    assertTrue(creatingTable.contains("uuid TEXT"));
    assertTrue(creatingTable.contains("name_hidden_auto_complete BOOLEAN DEFAULT 0"));
    assertTrue(creatingTable.contains("comment_hidden_auto_complete BOOLEAN DEFAULT 0"));
}