@Override public synchronized void onCreate( @NonNull SQLiteDatabase db, @NonNull TableDefaultsCustomizer customizer) { super.onCreate(db, customizer); final String sql = "CREATE TABLE " + TABLE_NAME + " (" + COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT," + COLUMN_PARENT + " TEXT REFERENCES " + TripsTable.COLUMN_NAME + " ON DELETE CASCADE," + COLUMN_DISTANCE + " DECIMAL(10, 2) DEFAULT 0.00," + COLUMN_LOCATION + " TEXT," + COLUMN_DATE + " DATE," + COLUMN_TIMEZONE + " TEXT," + COLUMN_COMMENT + " TEXT," + COLUMN_RATE_CURRENCY + " TEXT NOT NULL, " + COLUMN_RATE + " DECIMAL(10, 2) DEFAULT 0.00, " + AbstractSqlTable.COLUMN_DRIVE_SYNC_ID + " TEXT, " + AbstractSqlTable.COLUMN_DRIVE_IS_SYNCED + " BOOLEAN DEFAULT 0, " + AbstractSqlTable.COLUMN_DRIVE_MARKED_FOR_DELETION + " BOOLEAN DEFAULT 0, " + AbstractSqlTable.COLUMN_LAST_LOCAL_MODIFICATION_TIME + " DATE " + ");"; Logger.debug(this, sql); db.execSQL(sql); }