bugfix: the sequence is not reset when using other schema(not public)

[fanshaohua-fan]

Realized that in my use-case, the sequences were not reset during to the schema issue. Here is the fix.